/**\r
* @license http://nucleuscms.org/license.txt GNU General Public License\r
* @copyright Copyright (C) 2002-2012 The Nucleus Group\r
- * @version $Id$\r
+ * @version $Id: index.php 1705 2012-03-23 15:46:55Z sakamocchi $\r
*/\r
\r
/* global values initialize */\r
{\r
echo ' class="gry"';\r
}\r
- echo '> > ', _STEP3, "</li>\n";\r
+ echo '> > ', _STEP3, "</li>¥n";\r
}\r
if ( in_array($param->state, array('mysql', 'weblog', 'detail')) )\r
{\r
$languages = explode(',', $_SERVER['HTTP_ACCEPT_LANGUAGE']);\r
foreach ($languages as $language)\r
{\r
- $language = preg_replace('#([\w]+).*#', '$1', $language);\r
+ $language = preg_replace('#([¥w]+).*#', '$1', $language);\r
break;\r
}\r
\r
<?php\r
foreach ( $locales as $locale )\r
{\r
- echo "<option value=\"$locale[0]\"";\r
+ echo "<option value=¥"$locale[0]¥"";\r
if ( i18n::strpos($locale[0], $language) === 0 )\r
{\r
echo ' selected';\r
}\r
- echo ">$locale[1]</option>\n";\r
+ echo ">$locale[1]</option>¥n";\r
}\r
?>\r
</select>\r
{\r
foreach ( $errors as $error )\r
{\r
- echo '<span class="err">', $error, "</span>\n";\r
+ echo '<span class="err">', $error, "</span>¥n";\r
}\r
}\r
}\r
{\r
foreach ( $errors as $error )\r
{\r
- echo '<span class="err">', $error, "</span>\n";\r
+ echo '<span class="err">', $error, "</span>¥n";\r
}\r
}\r
}\r
{\r
foreach ( $errors as $error )\r
{\r
- echo '<span class="err">', $error, "</span>\n";\r
+ echo '<span class="err">', $error, "</span>¥n";\r
}\r
}\r
}\r
<?php\r
if ( $isPostback && !$param->check_all_parameters() )\r
{\r
- echo '<span class="err">', _ERROR26, "</span>\n";\r
+ echo '<span class="err">', _ERROR26, "</span>¥n";\r
}\r
?>\r
</p>\r
{\r
foreach ( $errors as $error )\r
{\r
- echo '<span class="err">', $error, "</span>\n";\r
+ echo '<span class="err">', $error, "</span>¥n";\r
}\r
}\r
}\r
{\r
foreach ( $errors as $error )\r
{\r
- echo '<span class="err">', $error, "</span>\n";\r
+ echo '<span class="err">', $error, "</span>¥n";\r
}\r
}\r
$errors = $param->check_path_parameters();\r
{\r
foreach ( $errors as $error )\r
{\r
- echo '<span class="err">', $error, "</span>\n";\r
+ echo '<span class="err">', $error, "</span>¥n";\r
}\r
}\r
}\r
{\r
foreach ( $errors as $error )\r
{\r
- echo '<span class="err">', $error, "</span>\n";\r
+ echo '<span class="err">', $error, "</span>¥n";\r
}\r
}\r
}\r
{\r
foreach ( $errors as $error )\r
{\r
- echo '<span class="err">', $error, "</span>\n";\r
+ echo '<span class="err">', $error, "</span>¥n";\r
}\r
}\r
}\r
echo _ERROR27;\r
foreach ( $errors as $error )\r
{\r
- echo '<span class="err">', $error, "</span>\n";\r
+ echo '<span class="err">', $error, "</span>¥n";\r
}\r
}\r
else\r
$queries = fread($fd, filesize($filename) );\r
fclose($fd);\r
\r
- $queries = preg_split('#(;\n|;\r)#', $queries);\r
+ $queries = preg_split('#(;¥n|;¥r)#', $queries);\r
\r
foreach ( $queries as $query )\r
{\r
- if ( preg_match('/\w+/', $query) )\r
+ if ( preg_match('/¥w+/', $query) )\r
{\r
if ( $MYSQL_PREFIX )\r
{\r
/*\r
* 8. Write config file ourselves (if possible)\r
*/\r
- $config_data = '<' . '?php' . "\n";\r
- $config_data .= "// mySQL connection information\n";\r
- $config_data .= "\$MYSQL_HOST = '" . $MYSQL_HOST . "';\n";\r
- $config_data .= "\$MYSQL_USER = '" . $MYSQL_USER . "';\n";\r
- $config_data .= "\$MYSQL_PASSWORD = '" . $MYSQL_PASSWORD . "';\n";\r
- $config_data .= "\$MYSQL_DATABASE = '" . $MYSQL_DATABASE . "';\n";\r
- $config_data .= "\$MYSQL_PREFIX = '" . $MYSQL_PREFIX . "';\n";\r
- $config_data .= "// new in 3.50. first element is db handler, the second is the db driver used by the handler\n";\r
- $config_data .= "// default is \$MYSQL_HANDLER = array('mysql','mysql');\n";\r
- $config_data .= "//\$MYSQL_HANDLER = array('mysql','mysql');\n";\r
- $config_data .= "//\$MYSQL_HANDLER = array('pdo','mysql');\n";\r
- $config_data .= "\$MYSQL_HANDLER = array('".$MYSQL_HANDLER[0]."','".$MYSQL_HANDLER[1]."');\n";\r
- $config_data .= "\n";\r
- $config_data .= "// main nucleus directory\n";\r
- $config_data .= "\$DIR_NUCLEUS = '" . $DIR_NUCLEUS . "';\n";\r
- $config_data .= "\n";\r
- $config_data .= "// path to media dir\n";\r
- $config_data .= "\$DIR_MEDIA = '" . $DIR_MEDIA . "';\n";\r
- $config_data .= "\n";\r
- $config_data .= "// extra skin files for imported skins\n";\r
- $config_data .= "\$DIR_SKINS = '" . $DIR_SKINS . "';\n";\r
- $config_data .= "\n";\r
- $config_data .= "// these dirs are normally sub dirs of the nucleus dir, but \n";\r
- $config_data .= "// you can redefine them if you wish\n";\r
- $config_data .= "\$DIR_PLUGINS = \$DIR_NUCLEUS . 'plugins/';\n";\r
- $config_data .= "\$DIR_LOCALES = \$DIR_NUCLEUS . 'locales/';\n";\r
- $config_data .= "\$DIR_LIBS = \$DIR_NUCLEUS . 'libs/';\n";\r
- $config_data .= "\n";\r
- $config_data .= "// include libs\n";\r
- $config_data .= "include(\$DIR_LIBS.'globalfunctions.php');\n";\r
+ $config_data = '<' . '?php' . "¥n";\r
+ $config_data .= "// mySQL connection information¥n";\r
+ $config_data .= "¥$MYSQL_HOST = '" . $MYSQL_HOST . "';¥n";\r
+ $config_data .= "¥$MYSQL_USER = '" . $MYSQL_USER . "';¥n";\r
+ $config_data .= "¥$MYSQL_PASSWORD = '" . $MYSQL_PASSWORD . "';¥n";\r
+ $config_data .= "¥$MYSQL_DATABASE = '" . $MYSQL_DATABASE . "';¥n";\r
+ $config_data .= "¥$MYSQL_PREFIX = '" . $MYSQL_PREFIX . "';¥n";\r
+ $config_data .= "// new in 3.50. first element is db handler, the second is the db driver used by the handler¥n";\r
+ $config_data .= "// default is ¥$MYSQL_HANDLER = array('mysql','mysql');¥n";\r
+ $config_data .= "//¥$MYSQL_HANDLER = array('mysql','mysql');¥n";\r
+ $config_data .= "//¥$MYSQL_HANDLER = array('pdo','mysql');¥n";\r
+ $config_data .= "¥$MYSQL_HANDLER = array('".$MYSQL_HANDLER[0]."','".$MYSQL_HANDLER[1]."');¥n";\r
+ $config_data .= "¥n";\r
+ $config_data .= "// main nucleus directory¥n";\r
+ $config_data .= "¥$DIR_NUCLEUS = '" . $DIR_NUCLEUS . "';¥n";\r
+ $config_data .= "¥n";\r
+ $config_data .= "// path to media dir¥n";\r
+ $config_data .= "¥$DIR_MEDIA = '" . $DIR_MEDIA . "';¥n";\r
+ $config_data .= "¥n";\r
+ $config_data .= "// extra skin files for imported skins¥n";\r
+ $config_data .= "¥$DIR_SKINS = '" . $DIR_SKINS . "';¥n";\r
+ $config_data .= "¥n";\r
+ $config_data .= "// these dirs are normally sub dirs of the nucleus dir, but ¥n";\r
+ $config_data .= "// you can redefine them if you wish¥n";\r
+ $config_data .= "¥$DIR_PLUGINS = ¥$DIR_NUCLEUS . 'plugins/';¥n";\r
+ $config_data .= "¥$DIR_LOCALES = ¥$DIR_NUCLEUS . 'locales/';¥n";\r
+ $config_data .= "¥$DIR_LIBS = ¥$DIR_NUCLEUS . 'libs/';¥n";\r
+ $config_data .= "¥n";\r
+ $config_data .= "// include libs¥n";\r
+ $config_data .= "include(¥$DIR_LIBS.'globalfunctions.php');¥n";\r
$config_data .= "?" . ">";\r
\r
$result = false;\r
}\r
else\r
{\r
- $result = @sql_query('SHOW VARIABLES LIKE \'version\'', $conn);\r
+ $result = @sql_query('SHOW VARIABLES LIKE ¥'version¥'', $conn);\r
\r
if ( $result != FALSE && @sql_num_rows($result) > 0 )\r
{\r
{\r
//$output = shell_exec('mysql -V');\r
$output = ( function_exists('shell_exec') ) ? @shell_exec('mysql -V') : '0.0.0';\r
- preg_match('@[0-9]+\.[0-9]+\.[0-9]+@', $output, $version);\r
+ preg_match('@[0-9]+¥.[0-9]+¥.[0-9]+@', $output, $version);\r
$match = i18n::explode('.', $version[0]);\r
\r
if ( $match[0] == '' )\r
\r
if ( count($missingfiles) > 0 )\r
{\r
- exit(implode( "\n", $missingfiles));\r
+ exit(implode( "¥n", $missingfiles));\r
}\r
}\r
\r
}\r
\r
if ( $this->mysql_user != ''\r
- && !preg_match('/^[a-z0-9_\-]+$/i', $this->mysql_user) )\r
+ && !preg_match('/^[a-z0-9_¥-]+$/i', $this->mysql_user) )\r
{\r
$errors[] = sprintf(_ERROR2, _DB_FIELD2);\r
}\r
}\r
\r
if ( $this->mysql_database != ''\r
- && !preg_match('/^[a-z0-9_\-]+$/i', $this->mysql_database) )\r
+ && !preg_match('/^[a-z0-9_¥-]+$/i', $this->mysql_database) )\r
{\r
$errors[] = sprintf(_ERROR2, _DB_FIELD4);\r
}\r
$this->user_password = '';\r
}\r
\r
- if ( !preg_match("/^[a-z0-9\._+\-]+@[a-z0-9\._\-]+\.[a-z]{2,6}$/i", $this->user_email) )\r
+ if ( !preg_match("/^[a-z0-9¥._+¥-]+@[a-z0-9¥._¥-]+¥.[a-z]{2,6}$/i", $this->user_email) )\r
{\r
$errors[] = _ERROR7;\r
}\r
-CREATE TABLE `nucleus_actionlog` (
- `timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
- `message` varchar(255) NOT NULL default ''
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-
-CREATE TABLE `nucleus_activation` (
- `vkey` varchar(40) NOT NULL default '',
- `vtime` datetime NOT NULL default '0000-00-00 00:00:00',
- `vmember` int(11) NOT NULL default '0',
- `vtype` varchar(15) NOT NULL default '',
- `vextra` varchar(128) NOT NULL default '',
- PRIMARY KEY (`vkey`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-
-CREATE TABLE `nucleus_ban` (
- `iprange` varchar(15) NOT NULL default '',
- `reason` varchar(255) NOT NULL default '',
- `blogid` int(11) NOT NULL default '0'
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-
-CREATE TABLE `nucleus_blog` (
- `bnumber` int(11) NOT NULL auto_increment,
- `bname` varchar(60) NOT NULL default '',
- `bshortname` varchar(15) NOT NULL default '',
- `bdesc` varchar(200) default NULL,
- `bcomments` tinyint(2) NOT NULL default '1',
- `bmaxcomments` int(11) NOT NULL default '0',
- `btimeoffset` decimal(3,1) NOT NULL default '0.0',
- `bnotify` varchar(128) default NULL,
- `burl` varchar(100) default NULL,
- `bupdate` varchar(60) default NULL,
- `bdefskin` int(11) NOT NULL default '1',
- `bpublic` tinyint(2) NOT NULL default '1',
- `bconvertbreaks` tinyint(2) NOT NULL default '1',
- `bdefcat` int(11) default NULL,
- `bnotifytype` int(11) NOT NULL default '15',
- `ballowpast` tinyint(2) NOT NULL default '0',
- `bincludesearch` tinyint(2) NOT NULL default '0',
- `breqemail` TINYINT( 2 ) DEFAULT '0' NOT NULL,
- `bfuturepost` TINYINT(2) DEFAULT '0' NOT NULL,
- PRIMARY KEY (`bnumber`),
--- UNIQUE KEY `bnumber` (`bnumber`),
- UNIQUE KEY `bshortname` (`bshortname`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-
-INSERT INTO `nucleus_blog` VALUES (1, 'My Nucleus CMS', 'mynucleuscms', '', 1, 0, 0.0, '', 'http://localhost:8080/nucleus/', '', 5, 1, 1, 1, 1, 1, 0, 0, 0);
-
-CREATE TABLE `nucleus_category` (
- `catid` int(11) NOT NULL auto_increment,
- `cblog` int(11) NOT NULL default '0',
- `cname` varchar(200) default NULL,
- `cdesc` varchar(200) default NULL,
- PRIMARY KEY (`catid`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-
-INSERT INTO `nucleus_category` VALUES (1, 1, 'General', 'Items that do not fit in other categories');
-
-CREATE TABLE `nucleus_comment` (
- `cnumber` int(11) NOT NULL auto_increment,
- `cbody` text NOT NULL,
- `cuser` varchar(40) default NULL,
- `cmail` varchar(100) default NULL,
- `cemail` VARCHAR( 100 ),
- `cmember` int(11) default NULL,
- `citem` int(11) NOT NULL default '0',
- `ctime` datetime NOT NULL default '0000-00-00 00:00:00',
- `chost` varchar(60) default NULL,
- `cip` varchar(15) NOT NULL default '',
- `cblog` int(11) NOT NULL default '0',
- PRIMARY KEY (`cnumber`),
--- UNIQUE KEY `cnumber` (`cnumber`),
- KEY `citem` (`citem`),
- FULLTEXT KEY `cbody` (`cbody`),
- INDEX `cblog` (`cblog`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-
-CREATE TABLE `nucleus_config` (
- `name` varchar(20) NOT NULL default '',
- `value` varchar(128) default NULL,
- PRIMARY KEY (`name`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-
-INSERT INTO `nucleus_config` VALUES ('DefaultBlog', '1');
-INSERT INTO `nucleus_config` VALUES ('AdminEmail', 'example@example.org');
-INSERT INTO `nucleus_config` VALUES ('IndexURL', 'http://localhost:8080/nucleus/');
-INSERT INTO `nucleus_config` VALUES ('Locale', 'en_Latn_US');
-INSERT INTO `nucleus_config` VALUES ('SessionCookie', '');
-INSERT INTO `nucleus_config` VALUES ('AllowMemberCreate', '');
-INSERT INTO `nucleus_config` VALUES ('AllowMemberMail', '1');
-INSERT INTO `nucleus_config` VALUES ('SiteName', 'My Nucleus CMS');
-INSERT INTO `nucleus_config` VALUES ('AdminURL', 'http://localhost:8080/nucleus/nucleus/');
-INSERT INTO `nucleus_config` VALUES ('NewMemberCanLogon', '1');
-INSERT INTO `nucleus_config` VALUES ('DisableSite', '');
-INSERT INTO `nucleus_config` VALUES ('DisableSiteURL', 'http://www.this-page-intentionally-left-blank.org/');
-INSERT INTO `nucleus_config` VALUES ('LastVisit', '');
-INSERT INTO `nucleus_config` VALUES ('MediaURL', 'http://localhost:8080/nucleus/media/');
-INSERT INTO `nucleus_config` VALUES ('AllowedTypes', 'jpg,jpeg,gif,mpg,mpeg,avi,mov,mp3,swf,png');
-INSERT INTO `nucleus_config` VALUES ('AllowLoginEdit', '');
-INSERT INTO `nucleus_config` VALUES ('AllowUpload', '1');
-INSERT INTO `nucleus_config` VALUES ('DisableJsTools', '2');
-INSERT INTO `nucleus_config` VALUES ('CookiePath', '/');
-INSERT INTO `nucleus_config` VALUES ('CookieDomain', '');
-INSERT INTO `nucleus_config` VALUES ('CookieSecure', '');
-INSERT INTO `nucleus_config` VALUES ('CookiePrefix', '');
-INSERT INTO `nucleus_config` VALUES ('MediaPrefix', '1');
-INSERT INTO `nucleus_config` VALUES ('MaxUploadSize', '1048576');
-INSERT INTO `nucleus_config` VALUES ('NonmemberMail', '');
-INSERT INTO `nucleus_config` VALUES ('PluginURL', 'http://localhost:8080/nucleus/nucleus/plugins/');
-INSERT INTO `nucleus_config` VALUES ('ProtectMemNames', '1');
-INSERT INTO `nucleus_config` VALUES ('BaseSkin', '5');
-INSERT INTO `nucleus_config` VALUES ('SkinsURL', 'http://localhost:8080/nucleus/skins/');
-INSERT INTO `nucleus_config` VALUES ('ActionURL', 'http://localhost:8080/nucleus/action.php');
-INSERT INTO `nucleus_config` VALUES ('URLMode', 'normal');
-INSERT INTO `nucleus_config` VALUES ('DatabaseVersion', '350');
-INSERT INTO `nucleus_config` VALUES ('DebugVars', '0');
-INSERT INTO `nucleus_config` VALUES ('DefaultListSize', '10');
-INSERT INTO `nucleus_config` VALUES ('AdminCSS', 'original');
-
-CREATE TABLE `nucleus_item` (
- `inumber` int(11) NOT NULL auto_increment,
- `ititle` varchar(160) default NULL,
- `ibody` text NOT NULL,
- `imore` text,
- `iblog` int(11) NOT NULL default '0',
- `iauthor` int(11) NOT NULL default '0',
- `itime` datetime NOT NULL default '0000-00-00 00:00:00',
- `iclosed` tinyint(2) NOT NULL default '0',
- `idraft` tinyint(2) NOT NULL default '0',
- `ikarmapos` int(11) NOT NULL default '0',
- `icat` int(11) default NULL,
- `ikarmaneg` int(11) NOT NULL default '0',
- `iposted` tinyint(2) NOT NULL default '1',
- PRIMARY KEY (`inumber`),
--- UNIQUE KEY `inumber` (`inumber`),
- KEY `itime` (`itime`),
- INDEX `iblog` (`iblog`),
- INDEX `idraft` (`idraft`),
- INDEX `icat` (`icat`),
- FULLTEXT KEY `ibody` (`ibody`,`ititle`,`imore`)
-) ENGINE=MyISAM PACK_KEYS=0 DEFAULT CHARSET=utf8;
-
-CREATE TABLE `nucleus_karma` (
- `itemid` int(11) NOT NULL default '0',
- `ip` char(15) NOT NULL default ''
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-
-CREATE TABLE `nucleus_member` (
- `mnumber` int(11) NOT NULL auto_increment,
- `mname` varchar(32) NOT NULL default '',
- `mrealname` varchar(60) default NULL,
- `mpassword` varchar(40) NOT NULL default '',
- `memail` varchar(60) default NULL,
- `murl` varchar(100) default NULL,
- `mnotes` varchar(100) default NULL,
- `madmin` tinyint(2) NOT NULL default '0',
- `mcanlogin` tinyint(2) NOT NULL default '1',
- `mcookiekey` varchar(40) default NULL,
- `mlocale` varchar(20) NOT NULL default '',
- `mautosave` tinyint(2) NOT NULL default '1',
- PRIMARY KEY (`mnumber`),
--- UNIQUE KEY `mnumber` (`mnumber`),
- UNIQUE KEY `mname` (`mname`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-
-INSERT INTO `nucleus_member` VALUES (1, 'example', 'example', '1a79a4d60de6718e8e5b326e338ae533', 'example@example.org', 'http://localhost:8080/nucleus/', '', 1, 1, 'd767aefc60415859570d64c649257f19', '', 1);
-
-CREATE TABLE `nucleus_plugin` (
- `pid` int(11) NOT NULL auto_increment,
- `pfile` varchar(40) NOT NULL default '',
- `porder` int(11) NOT NULL default '0',
- PRIMARY KEY (`pid`),
--- KEY `pid` (`pid`),
- KEY `porder` (`porder`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-
-CREATE TABLE `nucleus_plugin_event` (
- `pid` int(11) NOT NULL default '0',
- `event` varchar(40) default NULL,
- KEY `pid` (`pid`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-
-CREATE TABLE `nucleus_plugin_option` (
- `ovalue` text NOT NULL,
- `oid` int(11) NOT NULL auto_increment,
- `ocontextid` int(11) NOT NULL default '0',
- PRIMARY KEY (`oid`,`ocontextid`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-
-CREATE TABLE `nucleus_plugin_option_desc` (
- `oid` int(11) NOT NULL auto_increment,
- `opid` int(11) NOT NULL default '0',
- `oname` varchar(20) NOT NULL default '',
- `ocontext` varchar(20) NOT NULL default '',
- `odesc` varchar(255) default NULL,
- `otype` varchar(20) default NULL,
- `odef` text,
- `oextra` text,
- PRIMARY KEY (`opid`,`oname`,`ocontext`),
- UNIQUE KEY `oid` (`oid`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-
-CREATE TABLE `nucleus_skin` (
- `sdesc` int(11) NOT NULL default '0',
- `stype` varchar(20) NOT NULL default '',
- `scontent` text NOT NULL,
- PRIMARY KEY (`sdesc`,`stype`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-
--- INSERT INTO `nucleus_skin` VALUES (2, 'index', '<?xml version=\"1.0\" encoding=\"<%charset%>\"?>\n\n<feed xml:lang=\"en-us\" xmlns=\"http://www.w3.org/2005/Atom\">\n <title><%blogsetting(name)%></title>\n <id><%blogsetting(url)%>:<%blogsetting(id)%></id>\n\n <link rel=\"alternate\" type=\"text/html\" href=\"<%blogsetting(url)%>\" />\n <link rel=\"self\" type=\"application/atom+xml\" href=\"<%blogsetting(url)%><%self%>\" />\n <generator uri=\"http://nucleuscms.org/\"><%version%></generator>\n <updated><%blog(feeds/atom/modified,1)%></updated>\n\n <%blog(feeds/atom/entries,10)%>\n</feed>');
--- INSERT INTO `nucleus_skin` VALUES (4, 'index', '<?xml version="1.0"?>\r\n<rsd version="1.0">\r\n <service>\r\n <engineName><%version%></engineName>\r\n <engineLink>http://nucleuscms.org/</engineLink>\r\n <homepageLink><%sitevar(url)%></homepageLink>\r\n <apis>\r\n <api name="MetaWeblog" preferred="true" apiLink="<%adminurl%>xmlrpc/server.php" blogID="<%blogsetting(id)%>">\r\n <docs>http://nucleuscms.org/documentation/devdocs/xmlrpc.html</docs>\r\n </api>\r\n <api name="Blogger" preferred="false" apiLink="<%adminurl%>xmlrpc/server.php" blogID="<%blogsetting(id)%>">\r\n <docs>http://nucleuscms.org/documentation/devdocs/xmlrpc.html</docs>\r\n </api>\r\n </apis>\r\n </service>\r\n</rsd>');
--- INSERT INTO `nucleus_skin` VALUES (3, 'index', '<?xml version="1.0" encoding="<%charset%>"?>\r\n<rss version="2.0">\r\n <channel>\r\n <title><%blogsetting(name)%></title>\r\n <link><%blogsetting(url)%></link>\r\n <description><%blogsetting(desc)%></description>\r\n <language>en-us</language> \r\n <generator><%version%></generator>\r\n <copyright>?</copyright> \r\n <category>Weblog</category>\r\n <docs>http://backend.userland.com/rss</docs>\r\n <image>\r\n <url><%blogsetting(url)%>/nucleus/nucleus2.gif</url>\r\n <title><%blogsetting(name)%></title>\r\n <link><%blogsetting(url)%></link>\r\n </image>\r\n <%blog(feeds/rss20,10)%>\r\n </channel>\r\n</rss>');
-
-CREATE TABLE `nucleus_skin_desc` (
- `sdnumber` int(11) NOT NULL auto_increment,
- `sdname` varchar(20) NOT NULL default '',
- `sddesc` varchar(200) default NULL,
- `sdtype` varchar(40) NOT NULL default 'text/html',
- `sdincmode` varchar(10) NOT NULL default 'normal',
- `sdincpref` varchar(50) NOT NULL default '',
- PRIMARY KEY (`sdnumber`),
--- UNIQUE KEY `sdnumber` (`sdnumber`),
- UNIQUE KEY `sdname` (`sdname`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-
--- INSERT INTO `nucleus_skin_desc` VALUES (2, 'feeds/atom', 'Atom 1.0 weblog syndication', 'application/atom+xml', 'normal', '');
--- INSERT INTO `nucleus_skin_desc` VALUES (3, 'feeds/rss20', 'RSS 2.0 syndication of weblogs', 'text/xml', 'normal', '');
--- INSERT INTO `nucleus_skin_desc` VALUES (4, 'xml/rsd', 'RSD (Really Simple Discovery) information for weblog clients', 'text/xml', 'normal', '');
--- INSERT INTO `nucleus_skin_desc` VALUES (5, 'default', 'Nucleus CMS default skin', 'text/html', 'skindir', 'default/');
-
-CREATE TABLE `nucleus_team` (
- `tmember` int(11) NOT NULL default '0',
- `tblog` int(11) NOT NULL default '0',
- `tadmin` tinyint(2) NOT NULL default '0',
- PRIMARY KEY (`tmember`,`tblog`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-
-INSERT INTO `nucleus_team` VALUES (1, 1, 1);
-
-CREATE TABLE `nucleus_template` (
- `tdesc` int(11) NOT NULL default '0',
- `tpartname` varchar(64) NOT NULL default '',
- `tcontent` text NOT NULL,
- PRIMARY KEY (`tdesc`,`tpartname`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-
--- INSERT INTO `nucleus_template` VALUES (3, 'ITEM', '<item>\r\n <title><%title(xml)%></title>\r\n <link><%blogurl%>index.php?itemid=<%itemid%></link>\r\n<description><![CDATA[<%body%><%more%>]]></description>\r\n <category><%category%></category>\r\n<comments><%blogurl%>index.php?itemid=<%itemid%></comments>\r\n <pubDate><%date(rfc822)%></pubDate>\r\n</item>');
--- INSERT INTO `nucleus_template` VALUES (3, 'EDITLINK', '<a href="<%editlink%>" onclick="<%editpopupcode%>">edit</a>');
--- INSERT INTO `nucleus_template` VALUES (3, 'FORMAT_DATE', '%x');
--- INSERT INTO `nucleus_template` VALUES (3, 'FORMAT_TIME', '%X');
--- INSERT INTO `nucleus_template` VALUES (4, 'ITEM', '<%date(utc)%>');
--- INSERT INTO `nucleus_template` VALUES (5, 'ITEM', '<entry>\n <title type=\"html\"><![CDATA[<%title%>]]></title>\n <link rel=\"alternate\" type=\"text/html\" href=\"<%blogurl%>index.php?itemid=<%itemid%>\" />\n <author>\n <name><%author%></name>\n </author>\n <updated><%date(utc)%></updated>\n <published><%date(iso8601)%></published>\n <content type=\"html\"><![CDATA[<%body%><%more%>]]></content>\n <id><%blogurl%>:<%blogid%>:<%itemid%></id>\n</entry>');
--- INSERT INTO `nucleus_template` VALUES (5, 'POPUP_CODE', '<%media%>');
--- INSERT INTO `nucleus_template` VALUES (5, 'IMAGE_CODE', '<%image%>');
--- INSERT INTO `nucleus_template` VALUES (5, 'MEDIA_CODE', '<%media%>');
--- INSERT INTO `nucleus_template` VALUES (3, 'POPUP_CODE', '<%image%>');
--- INSERT INTO `nucleus_template` VALUES (3, 'MEDIA_CODE', '<%media%>');
--- INSERT INTO `nucleus_template` VALUES (3, 'IMAGE_CODE', '<%media%>');
-
-CREATE TABLE `nucleus_template_desc` (
- `tdnumber` int(11) NOT NULL auto_increment,
- `tdname` varchar(64) NOT NULL default '',
- `tddesc` varchar(200) default NULL,
- PRIMARY KEY (`tdnumber`),
--- UNIQUE KEY `tdnumber` (`tdnumber`),
- UNIQUE KEY `tdname` (`tdname`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-
--- INSERT INTO `nucleus_template_desc` VALUES (4, 'feeds/atom/modified', 'Atom feeds: Inserts last modification date');
--- INSERT INTO `nucleus_template_desc` VALUES (5, 'feeds/atom/entries', 'Atom feeds: Feed items');
--- INSERT INTO `nucleus_template_desc` VALUES (3, 'feeds/rss20', 'Used for RSS 2.0 syndication of your blog');
--- INSERT INTO `nucleus_template_desc` VALUES (8, 'default/index', 'Nucleus CMS default index template');
--- INSERT INTO `nucleus_template_desc` VALUES (9, 'default/item', 'Nucleus CMS default item template');
-
-CREATE TABLE `nucleus_tickets` (
- `ticket` varchar(40) NOT NULL default '',
- `ctime` datetime NOT NULL default '0000-00-00 00:00:00',
- `member` int(11) NOT NULL default '0',
- PRIMARY KEY (`ticket`,`member`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+CREATE TABLE `nucleus_actionlog` (\r
+ `timestamp` datetime NOT NULL default '0000-00-00 00:00:00',\r
+ `message` varchar(255) NOT NULL default ''\r
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;\r
+\r
+CREATE TABLE `nucleus_activation` (\r
+ `vkey` varchar(40) NOT NULL default '',\r
+ `vtime` datetime NOT NULL default '0000-00-00 00:00:00',\r
+ `vmember` int(11) NOT NULL default '0',\r
+ `vtype` varchar(15) NOT NULL default '',\r
+ `vextra` varchar(128) NOT NULL default '',\r
+ PRIMARY KEY (`vkey`)\r
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;\r
+\r
+CREATE TABLE `nucleus_ban` (\r
+ `iprange` varchar(15) NOT NULL default '',\r
+ `reason` varchar(255) NOT NULL default '',\r
+ `blogid` int(11) NOT NULL default '0'\r
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;\r
+\r
+CREATE TABLE `nucleus_blog` (\r
+ `bnumber` int(11) NOT NULL auto_increment,\r
+ `bname` varchar(60) NOT NULL default '',\r
+ `bshortname` varchar(15) NOT NULL default '',\r
+ `bdesc` varchar(200) default NULL,\r
+ `bcomments` tinyint(2) NOT NULL default '1',\r
+ `bmaxcomments` int(11) NOT NULL default '0',\r
+ `btimeoffset` decimal(3,1) NOT NULL default '0.0',\r
+ `bnotify` varchar(128) default NULL,\r
+ `burl` varchar(100) default NULL,\r
+ `bupdate` varchar(60) default NULL,\r
+ `bdefskin` int(11) NOT NULL default '1',\r
+ `bpublic` tinyint(2) NOT NULL default '1',\r
+ `bconvertbreaks` tinyint(2) NOT NULL default '1',\r
+ `bdefcat` int(11) default NULL,\r
+ `bnotifytype` int(11) NOT NULL default '15',\r
+ `ballowpast` tinyint(2) NOT NULL default '0',\r
+ `bincludesearch` tinyint(2) NOT NULL default '0',\r
+ `breqemail` TINYINT( 2 ) DEFAULT '0' NOT NULL,\r
+ `bfuturepost` TINYINT(2) DEFAULT '0' NOT NULL,\r
+ PRIMARY KEY (`bnumber`),\r
+-- UNIQUE KEY `bnumber` (`bnumber`),\r
+ UNIQUE KEY `bshortname` (`bshortname`)\r
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;\r
+\r
+INSERT INTO `nucleus_blog` VALUES (1, 'My Nucleus CMS', 'mynucleuscms', '', 1, 0, 0.0, '', 'http://localhost:8080/nucleus/', '', 5, 1, 1, 1, 1, 1, 0, 0, 0);\r
+\r
+CREATE TABLE `nucleus_category` (\r
+ `catid` int(11) NOT NULL auto_increment,\r
+ `cblog` int(11) NOT NULL default '0',\r
+ `cname` varchar(200) default NULL,\r
+ `cdesc` varchar(200) default NULL,\r
+ PRIMARY KEY (`catid`)\r
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;\r
+\r
+INSERT INTO `nucleus_category` VALUES (1, 1, 'General', 'Items that do not fit in other categories');\r
+\r
+CREATE TABLE `nucleus_comment` (\r
+ `cnumber` int(11) NOT NULL auto_increment,\r
+ `cbody` text NOT NULL,\r
+ `cuser` varchar(40) default NULL,\r
+ `cmail` varchar(100) default NULL,\r
+ `cemail` VARCHAR( 100 ),\r
+ `cmember` int(11) default NULL,\r
+ `citem` int(11) NOT NULL default '0',\r
+ `ctime` datetime NOT NULL default '0000-00-00 00:00:00',\r
+ `chost` varchar(60) default NULL,\r
+ `cip` varchar(15) NOT NULL default '',\r
+ `cblog` int(11) NOT NULL default '0',\r
+ PRIMARY KEY (`cnumber`),\r
+-- UNIQUE KEY `cnumber` (`cnumber`),\r
+ KEY `citem` (`citem`),\r
+ FULLTEXT KEY `cbody` (`cbody`),\r
+ INDEX `cblog` (`cblog`)\r
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;\r
+\r
+CREATE TABLE `nucleus_config` (\r
+ `name` varchar(20) NOT NULL default '',\r
+ `value` varchar(128) default NULL,\r
+ PRIMARY KEY (`name`)\r
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;\r
+\r
+INSERT INTO `nucleus_config` VALUES ('DefaultBlog', '1');\r
+INSERT INTO `nucleus_config` VALUES ('AdminEmail', 'example@example.org');\r
+INSERT INTO `nucleus_config` VALUES ('IndexURL', 'http://localhost:8080/nucleus/');\r
+INSERT INTO `nucleus_config` VALUES ('Locale', 'en_Latn_US');\r
+INSERT INTO `nucleus_config` VALUES ('SessionCookie', '');\r
+INSERT INTO `nucleus_config` VALUES ('AllowMemberCreate', '');\r
+INSERT INTO `nucleus_config` VALUES ('AllowMemberMail', '1');\r
+INSERT INTO `nucleus_config` VALUES ('SiteName', 'My Nucleus CMS');\r
+INSERT INTO `nucleus_config` VALUES ('AdminURL', 'http://localhost:8080/nucleus/nucleus/');\r
+INSERT INTO `nucleus_config` VALUES ('NewMemberCanLogon', '1');\r
+INSERT INTO `nucleus_config` VALUES ('DisableSite', '');\r
+INSERT INTO `nucleus_config` VALUES ('DisableSiteURL', 'http://www.this-page-intentionally-left-blank.org/');\r
+INSERT INTO `nucleus_config` VALUES ('LastVisit', '');\r
+INSERT INTO `nucleus_config` VALUES ('MediaURL', 'http://localhost:8080/nucleus/media/');\r
+INSERT INTO `nucleus_config` VALUES ('AllowedTypes', 'jpg,jpeg,gif,mpg,mpeg,avi,mov,mp3,swf,png');\r
+INSERT INTO `nucleus_config` VALUES ('AllowLoginEdit', '');\r
+INSERT INTO `nucleus_config` VALUES ('AllowUpload', '1');\r
+INSERT INTO `nucleus_config` VALUES ('DisableJsTools', '2');\r
+INSERT INTO `nucleus_config` VALUES ('CookiePath', '/');\r
+INSERT INTO `nucleus_config` VALUES ('CookieDomain', '');\r
+INSERT INTO `nucleus_config` VALUES ('CookieSecure', '');\r
+INSERT INTO `nucleus_config` VALUES ('CookiePrefix', '');\r
+INSERT INTO `nucleus_config` VALUES ('MediaPrefix', '1');\r
+INSERT INTO `nucleus_config` VALUES ('MaxUploadSize', '1048576');\r
+INSERT INTO `nucleus_config` VALUES ('NonmemberMail', '');\r
+INSERT INTO `nucleus_config` VALUES ('PluginURL', 'http://localhost:8080/nucleus/nucleus/plugins/');\r
+INSERT INTO `nucleus_config` VALUES ('ProtectMemNames', '1');\r
+INSERT INTO `nucleus_config` VALUES ('BaseSkin', '5');\r
+INSERT INTO `nucleus_config` VALUES ('SkinsURL', 'http://localhost:8080/nucleus/skins/');\r
+INSERT INTO `nucleus_config` VALUES ('ActionURL', 'http://localhost:8080/nucleus/action.php');\r
+INSERT INTO `nucleus_config` VALUES ('URLMode', 'normal');\r
+INSERT INTO `nucleus_config` VALUES ('DatabaseVersion', '350');\r
+INSERT INTO `nucleus_config` VALUES ('DebugVars', '0');\r
+INSERT INTO `nucleus_config` VALUES ('DefaultListSize', '10');\r
+INSERT INTO `nucleus_config` VALUES ('AdminCSS', 'original');\r
+\r
+CREATE TABLE `nucleus_item` (\r
+ `inumber` int(11) NOT NULL auto_increment,\r
+ `ititle` varchar(160) default NULL,\r
+ `ibody` text NOT NULL,\r
+ `imore` text,\r
+ `iblog` int(11) NOT NULL default '0',\r
+ `iauthor` int(11) NOT NULL default '0',\r
+ `itime` datetime NOT NULL default '0000-00-00 00:00:00',\r
+ `iclosed` tinyint(2) NOT NULL default '0',\r
+ `idraft` tinyint(2) NOT NULL default '0',\r
+ `ikarmapos` int(11) NOT NULL default '0',\r
+ `icat` int(11) default NULL,\r
+ `ikarmaneg` int(11) NOT NULL default '0',\r
+ `iposted` tinyint(2) NOT NULL default '1',\r
+ PRIMARY KEY (`inumber`),\r
+-- UNIQUE KEY `inumber` (`inumber`),\r
+ KEY `itime` (`itime`),\r
+ INDEX `iblog` (`iblog`),\r
+ INDEX `idraft` (`idraft`),\r
+ INDEX `icat` (`icat`),\r
+ FULLTEXT KEY `ibody` (`ibody`,`ititle`,`imore`)\r
+) ENGINE=MyISAM PACK_KEYS=0 DEFAULT CHARSET=utf8;\r
+\r
+CREATE TABLE `nucleus_karma` (\r
+ `itemid` int(11) NOT NULL default '0',\r
+ `ip` char(15) NOT NULL default ''\r
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;\r
+\r
+CREATE TABLE `nucleus_member` (\r
+ `mnumber` int(11) NOT NULL auto_increment,\r
+ `mname` varchar(32) NOT NULL default '',\r
+ `mrealname` varchar(60) default NULL,\r
+ `mpassword` varchar(40) NOT NULL default '',\r
+ `memail` varchar(60) default NULL,\r
+ `murl` varchar(100) default NULL,\r
+ `mnotes` varchar(100) default NULL,\r
+ `madmin` tinyint(2) NOT NULL default '0',\r
+ `mcanlogin` tinyint(2) NOT NULL default '1',\r
+ `mcookiekey` varchar(40) default NULL,\r
+ `mlocale` varchar(20) NOT NULL default '',\r
+ `mautosave` tinyint(2) NOT NULL default '1',\r
+ PRIMARY KEY (`mnumber`),\r
+-- UNIQUE KEY `mnumber` (`mnumber`),\r
+ UNIQUE KEY `mname` (`mname`)\r
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;\r
+\r
+INSERT INTO `nucleus_member` VALUES (1, 'example', 'example', '1a79a4d60de6718e8e5b326e338ae533', 'example@example.org', 'http://localhost:8080/nucleus/', '', 1, 1, 'd767aefc60415859570d64c649257f19', '', 1);\r
+\r
+CREATE TABLE `nucleus_plugin` (\r
+ `pid` int(11) NOT NULL auto_increment,\r
+ `pfile` varchar(40) NOT NULL default '',\r
+ `porder` int(11) NOT NULL default '0',\r
+ PRIMARY KEY (`pid`),\r
+-- KEY `pid` (`pid`),\r
+ KEY `porder` (`porder`)\r
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;\r
+\r
+CREATE TABLE `nucleus_plugin_event` (\r
+ `pid` int(11) NOT NULL default '0',\r
+ `event` varchar(40) default NULL,\r
+ KEY `pid` (`pid`)\r
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;\r
+\r
+CREATE TABLE `nucleus_plugin_option` (\r
+ `ovalue` text NOT NULL,\r
+ `oid` int(11) NOT NULL auto_increment,\r
+ `ocontextid` int(11) NOT NULL default '0',\r
+ PRIMARY KEY (`oid`,`ocontextid`)\r
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;\r
+\r
+CREATE TABLE `nucleus_plugin_option_desc` (\r
+ `oid` int(11) NOT NULL auto_increment,\r
+ `opid` int(11) NOT NULL default '0',\r
+ `oname` varchar(20) NOT NULL default '',\r
+ `ocontext` varchar(20) NOT NULL default '',\r
+ `odesc` varchar(255) default NULL,\r
+ `otype` varchar(20) default NULL,\r
+ `odef` text,\r
+ `oextra` text,\r
+ PRIMARY KEY (`opid`,`oname`,`ocontext`),\r
+ UNIQUE KEY `oid` (`oid`)\r
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;\r
+\r
+CREATE TABLE `nucleus_skin` (\r
+ `sdesc` int(11) NOT NULL default '0',\r
+ `stype` varchar(20) NOT NULL default '',\r
+ `scontent` text NOT NULL,\r
+ PRIMARY KEY (`sdesc`,`stype`)\r
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;\r
+\r
+-- INSERT INTO `nucleus_skin` VALUES (2, 'index', '<?xml version=\"1.0\" encoding=\"<%charset%>\"?>\n\n<feed xml:lang=\"en-us\" xmlns=\"http://www.w3.org/2005/Atom\">\n <title><%blogsetting(name)%></title>\n <id><%blogsetting(url)%>:<%blogsetting(id)%></id>\n\n <link rel=\"alternate\" type=\"text/html\" href=\"<%blogsetting(url)%>\" />\n <link rel=\"self\" type=\"application/atom+xml\" href=\"<%blogsetting(url)%><%self%>\" />\n <generator uri=\"http://nucleuscms.org/\"><%version%></generator>\n <updated><%blog(feeds/atom/modified,1)%></updated>\n\n <%blog(feeds/atom/entries,10)%>\n</feed>');\r
+-- INSERT INTO `nucleus_skin` VALUES (4, 'index', '<?xml version="1.0"?>\r\n<rsd version="1.0">\r\n <service>\r\n <engineName><%version%></engineName>\r\n <engineLink>http://nucleuscms.org/</engineLink>\r\n <homepageLink><%sitevar(url)%></homepageLink>\r\n <apis>\r\n <api name="MetaWeblog" preferred="true" apiLink="<%adminurl%>xmlrpc/server.php" blogID="<%blogsetting(id)%>">\r\n <docs>http://nucleuscms.org/documentation/devdocs/xmlrpc.html</docs>\r\n </api>\r\n <api name="Blogger" preferred="false" apiLink="<%adminurl%>xmlrpc/server.php" blogID="<%blogsetting(id)%>">\r\n <docs>http://nucleuscms.org/documentation/devdocs/xmlrpc.html</docs>\r\n </api>\r\n </apis>\r\n </service>\r\n</rsd>');\r
+-- INSERT INTO `nucleus_skin` VALUES (3, 'index', '<?xml version="1.0" encoding="<%charset%>"?>\r\n<rss version="2.0">\r\n <channel>\r\n <title><%blogsetting(name)%></title>\r\n <link><%blogsetting(url)%></link>\r\n <description><%blogsetting(desc)%></description>\r\n <language>en-us</language> \r\n <generator><%version%></generator>\r\n <copyright>?</copyright> \r\n <category>Weblog</category>\r\n <docs>http://backend.userland.com/rss</docs>\r\n <image>\r\n <url><%blogsetting(url)%>/nucleus/nucleus2.gif</url>\r\n <title><%blogsetting(name)%></title>\r\n <link><%blogsetting(url)%></link>\r\n </image>\r\n <%blog(feeds/rss20,10)%>\r\n </channel>\r\n</rss>');\r
+\r
+CREATE TABLE `nucleus_skin_desc` (\r
+ `sdnumber` int(11) NOT NULL auto_increment,\r
+ `sdname` varchar(20) NOT NULL default '',\r
+ `sddesc` varchar(200) default NULL,\r
+ `sdtype` varchar(40) NOT NULL default 'text/html',\r
+ `sdincmode` varchar(10) NOT NULL default 'normal',\r
+ `sdincpref` varchar(50) NOT NULL default '',\r
+ PRIMARY KEY (`sdnumber`),\r
+-- UNIQUE KEY `sdnumber` (`sdnumber`),\r
+ UNIQUE KEY `sdname` (`sdname`)\r
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;\r
+\r
+-- INSERT INTO `nucleus_skin_desc` VALUES (2, 'feeds/atom', 'Atom 1.0 weblog syndication', 'application/atom+xml', 'normal', '');\r
+-- INSERT INTO `nucleus_skin_desc` VALUES (3, 'feeds/rss20', 'RSS 2.0 syndication of weblogs', 'text/xml', 'normal', '');\r
+-- INSERT INTO `nucleus_skin_desc` VALUES (4, 'xml/rsd', 'RSD (Really Simple Discovery) information for weblog clients', 'text/xml', 'normal', '');\r
+-- INSERT INTO `nucleus_skin_desc` VALUES (5, 'default', 'Nucleus CMS default skin', 'text/html', 'skindir', 'default/');\r
+\r
+CREATE TABLE `nucleus_team` (\r
+ `tmember` int(11) NOT NULL default '0',\r
+ `tblog` int(11) NOT NULL default '0',\r
+ `tadmin` tinyint(2) NOT NULL default '0',\r
+ PRIMARY KEY (`tmember`,`tblog`)\r
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;\r
+\r
+INSERT INTO `nucleus_team` VALUES (1, 1, 1);\r
+\r
+CREATE TABLE `nucleus_template` (\r
+ `tdesc` int(11) NOT NULL default '0',\r
+ `tpartname` varchar(64) NOT NULL default '',\r
+ `tcontent` text NOT NULL,\r
+ PRIMARY KEY (`tdesc`,`tpartname`)\r
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;\r
+\r
+-- INSERT INTO `nucleus_template` VALUES (3, 'ITEM', '<item>\r\n <title><%title(xml)%></title>\r\n <link><%blogurl%>index.php?itemid=<%itemid%></link>\r\n<description><![CDATA[<%body%><%more%>]]></description>\r\n <category><%category%></category>\r\n<comments><%blogurl%>index.php?itemid=<%itemid%></comments>\r\n <pubDate><%date(rfc822)%></pubDate>\r\n</item>');\r
+-- INSERT INTO `nucleus_template` VALUES (3, 'EDITLINK', '<a href="<%editlink%>" onclick="<%editpopupcode%>">edit</a>');\r
+-- INSERT INTO `nucleus_template` VALUES (3, 'FORMAT_DATE', '%x');\r
+-- INSERT INTO `nucleus_template` VALUES (3, 'FORMAT_TIME', '%X');\r
+-- INSERT INTO `nucleus_template` VALUES (4, 'ITEM', '<%date(utc)%>');\r
+-- INSERT INTO `nucleus_template` VALUES (5, 'ITEM', '<entry>\n <title type=\"html\"><![CDATA[<%title%>]]></title>\n <link rel=\"alternate\" type=\"text/html\" href=\"<%blogurl%>index.php?itemid=<%itemid%>\" />\n <author>\n <name><%author%></name>\n </author>\n <updated><%date(utc)%></updated>\n <published><%date(iso8601)%></published>\n <content type=\"html\"><![CDATA[<%body%><%more%>]]></content>\n <id><%blogurl%>:<%blogid%>:<%itemid%></id>\n</entry>');\r
+-- INSERT INTO `nucleus_template` VALUES (5, 'POPUP_CODE', '<%media%>');\r
+-- INSERT INTO `nucleus_template` VALUES (5, 'IMAGE_CODE', '<%image%>');\r
+-- INSERT INTO `nucleus_template` VALUES (5, 'MEDIA_CODE', '<%media%>');\r
+-- INSERT INTO `nucleus_template` VALUES (3, 'POPUP_CODE', '<%image%>');\r
+-- INSERT INTO `nucleus_template` VALUES (3, 'MEDIA_CODE', '<%media%>');\r
+-- INSERT INTO `nucleus_template` VALUES (3, 'IMAGE_CODE', '<%media%>');\r
+\r
+CREATE TABLE `nucleus_template_desc` (\r
+ `tdnumber` int(11) NOT NULL auto_increment,\r
+ `tdname` varchar(64) NOT NULL default '',\r
+ `tddesc` varchar(200) default NULL,\r
+ PRIMARY KEY (`tdnumber`),\r
+-- UNIQUE KEY `tdnumber` (`tdnumber`),\r
+ UNIQUE KEY `tdname` (`tdname`)\r
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;\r
+\r
+-- INSERT INTO `nucleus_template_desc` VALUES (4, 'feeds/atom/modified', 'Atom feeds: Inserts last modification date');\r
+-- INSERT INTO `nucleus_template_desc` VALUES (5, 'feeds/atom/entries', 'Atom feeds: Feed items');\r
+-- INSERT INTO `nucleus_template_desc` VALUES (3, 'feeds/rss20', 'Used for RSS 2.0 syndication of your blog');\r
+-- INSERT INTO `nucleus_template_desc` VALUES (8, 'default/index', 'Nucleus CMS default index template');\r
+-- INSERT INTO `nucleus_template_desc` VALUES (9, 'default/item', 'Nucleus CMS default item template');\r
+\r
+CREATE TABLE `nucleus_tickets` (\r
+ `ticket` varchar(40) NOT NULL default '',\r
+ `ctime` datetime NOT NULL default '0000-00-00 00:00:00',\r
+ `member` int(11) NOT NULL default '0',\r
+ PRIMARY KEY (`ticket`,`member`)\r
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;\r