<?php

$sqlfile=dirname(__FILE__).'/dbsqlite-no-drop-utf8.sql';
$dest=dirname(__FILE__).'/.dbsqlite';
if (file_exists($dest)) exit("File: '$dest' already exists!");

$textdata=file_get_contents($sqlfile);
if (strlen($textdata)==0) exit("Data not found: '$sqlfile'!");

if (!preg_match_all("/(?:[^';]+|'[^']*?')*;/",$textdata,$m, PREG_PATTERN_ORDER)) exit("Data not found");
$textdata=null;
$arraydata=$m[0];
$m=null;

$db=sqlite_open($dest);

sqlite_query($db,'BEGIN TRANSACTION');
foreach($arraydata as $query) {
    $query=trim($query);
    while(preg_match('/^(?:#[^\r\n]*[\r\n]+)/',$query,$m)) $query=substr($query,strlen($m[0]));
    sqlite_query($db,$query);
}
sqlite_query($db,'COMMIT');

function sql_query($query) {
    global $SQLCount;
    $SQLCount++;
    $res = mysql_query($query) or print("mySQL error with query $query: " . mysql_error() . '<p />');
    return $res;
}

function sql_query($query) {
    static $cache=array();
    if (isset($cache[$query])) {
        $res=$cache[$query];
        if (@mysql_data_seek($res,0)) return $res;
        else unset($cache[$query]);
    }
    global $SQLCount;
    $SQLCount++;
    $res = mysql_query($query) or print("mySQL error with query $query: " . mysql_error() . '<p />');
    if (mysql_num_rows($res)<5) $cache[$query]=$res;
    return $res;
}

<?php 
class NP_skinsetting extends NucleusPlugin { 
    function getName() { return 'NP_skinsetting'; }
    function getMinNucleusVersion() { return 220; }
    function getAuthor()  { return 'Katsumi'; }
    function getVersion() { return '0.1'; }
    function getURL() {return 'http://japan.nucleuscms.org/wiki/plugins:authors:katsumi';}
    function getDescription() {
        return 'Usage:<br />
&lt;%skinsetting(id)%&gt;,
&lt;%skinsetting(description)%&gt;,
&lt;%skinsetting(contenttype)%&gt;,
&lt;%skinsetting(includemode)%&gt;,
&lt;%skinsetting(includeprefix)%&gt;,
&lt;%skinsetting(name)%&gt;, or
&lt;%skinsetting(type)%&gt;';
    } 
    function supportsFeature($what) { return ($what=='SqlTablePrefix')?1:0; }
    function getEventList() { return array('InitSkinParse'); }
    var $skinobj;
    function event_InitSkinParse(&$data) {
        $this->skinobj=&$data['skin'];
    }
    function doSkinVar($skintype,$type,$p1='') {
        if ($type=='type') $data=$skintype;
        elseif (method_exists($this->skinobj,"get$type")) {
            $data=call_user_func(array($this->skinobj,"get$type"),$p1);
        }
        echo htmlspecialchars($data,ENT_QUOTES);
    }
}

<?php 
class NP_otherskinsetting extends NucleusPlugin { 
    function getName() { return 'NP_otherskinsetting'; }
    function getMinNucleusVersion() { return 220; }
    function getAuthor()  { return 'Katsumi'; }
    function getVersion() { return '0.1'; }
    function getURL() {return 'http://japan.nucleuscms.org/wiki/plugins:authors:katsumi';}
    function getPluginDep() { return array('NP_skinsetting'); }
    function getDescription() {
        return str_replace('skinsetting(','otherskinsetting([skin_id/name],',
            $this->skinsetting->getDescription());
    }
    function supportsFeature($what) { return ($what=='SqlTablePrefix')?1:0; }
    var $skinsetting;
    function init(){
        global $manager;
        $this->skinsetting=$manager->getPlugin('NP_skinsetting');
    }
    function doSkinVar($skintype,$id,$type,$p1='') {
        static $objs=array();
        if (!is_numeric($id)) $id=SKIN::getIdFromName($id);
        $id=(int)$id;
        if (!isset($objs[$id])) {
            $objs[$id]=new NP_skinsetting;
            $obj=new SKIN($id);
            $data=array('type'=>$skintype,'skin'=>&$obj);
            $objs[$id]->event_InitSkinParse($data);
        }
        return $objs[$id]->doSkinVar($skintype,$type,$p1);
    }
}

<a href="<%nextlink%>" id="nextlink">older items</a>
<a href="<%prevlink%>" id="prevlink">newer items</a>
<script type="text/javascript">
function hide_link(id){
  var element=document.getElementById(id);
  if (element.href=="" || element.href==document.location)
    element.style.display="none";
}
hide_link("nextlink");
hide_link("prevlink");
</script>

<?php

$this->getPlugin('NP_Calendar');
class NP_Calendar_english extends NP_Calendar {
    function getShortName() {
        return 'calendar';
    }
    function install() { }
    function unInstall() { }
}

<?php

$this->getPlugin('NP_Calendar');
class NP_Calendar_english extends NP_Calendar {
}

<?php

$this->getPlugin('NP_Calendar');
if (!class_exists('NP_Calendar_english')) {
    class NP_Calendar_english extends NP_Calendar {
        function getShortName() {
            return 'calendar';
        }
        function install() { }
        function unInstall() { }
    }
}

<?php
class NP_ConvertTags extends NucleusPlugin {
   function getName() { return preg_replace('/\.php$/','',basename(__FILE__)); }
   function getMinNucleusVersion() { return 330; }
   function getAuthor()  { return 'Katsumi'; }
   function getVersion() { return '0.1'; }
   function getURL() {return 'http://japan.nucleuscms.org/wiki/plugins:authors:katsumi';}
   function getDescription() { return $this->getName().' plugin'; }
   function supportsFeature($what) { return ($what=='SqlTablePrefix')?1:0; }
   function getEventList() { return array('PreSkinParse','PreItem'); }
   function doSkinVar($skinType,$type,$p2='') {
      switch($type){
      case 'parsedinclude':
      default:
         return $this->parse_parsedinclude($p2);
      }
   }
   function event_PreItem(&$data) {
      // Convert
      $item=&$data['item'];
      $item->body=$this->convert($item->body);
      $item->more=$this->convert($item->more);
   }
   var $handler,$parser;
   function event_PreSkinParse(&$data) {      
      // Convert
      $contents=&$data['contents'];
      $contents=$this->convert($contents);
      // Set handler and parser
      $skin=&$data['skin'];
      $type=&$data['type'];
      $actions = $skin->getAllowedActionsForType($type);
      $this->handler =& new ACTIONS($type, $skin);
      $this->parser =& new PARSER($actions, $this->handler);
      $this->handler->setParser($this->parser);
      $this->handler->setSkin($skin);
   }
   function parse_parsedinclude($filename) {
      // check current level
      if ($this->handler->level > 3) return;   // max. depth reached (avoid endless loop)
      $filename = $this->handler->getIncludeFileName($filename);
      if (!file_exists($filename)) return '';

      $fsize = filesize($filename);

      // nothing to include
      if ($fsize <= 0)
         return;

      $this->handler->level++;

      // read file
      $fd = fopen ($filename, 'r');
      $contents = fread ($fd, $fsize);
      fclose ($fd);

      // convert
      $contents=$this->convert($contents);

      // parse file contents
      $this->parser->parse($contents);

      $this->handler->level--;
   }
   var $search=array('/\[%([\s\S]*?)%\]/');
   function convert(&$text) {
      $temp=preg_replace($this->search,'<%$1%>',$text);
      return preg_replace('/<%parsedinclude\(([^\(]*)\)%>/','<%ConvertTags(parsedinclude,$1)%>',$temp);
   }
}
?>