<?php
+\r
/*\r
* Nucleus: PHP/MySQL Weblog CMS (http://nucleuscms.org/)\r
* Copyright (C) 2002-2009 The Nucleus Group\r
$DIR_NUCLEUS = '/your/path/to/nucleus/';
// media dir
-$DIR_MEDIA = '/your/path/to/media/';
+$DIR_MEDIA = '/your/path/to/media/';
// extra skin files for imported skins
-$DIR_SKINS = '/your/path/to/skins/';
+$DIR_SKINS = '/your/path/to/skins/';
// these dirs are normally subdirs of the nucleus dir, but
// you can redefine them if you wish
}
// include libs
-include($DIR_LIBS . 'globalfunctions.php');
+include($DIR_LIBS.'globalfunctions.php');
if (!extension_loaded('mbstring')) {
include($DIR_LIBS.'mb_emulator/mb-emulator.php');
}
* @copyright Copyright (C) 2002-2009 The Nucleus Group\r
* @version $Id$\r
*/\r
-
- require "./config.php";
- include $DIR_LIBS."ACTION.php";
-
- if (isset ($_POST['showform'])&&$_POST['showform']==1) {
- $showform = 1;
- }
- else {
- $showform = 0;
- }
-?>
-<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
-<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="ja-JP" lang="ja-JP">
-<head>
- <meta http-equiv="Content-Type" content="text/html; charset=<?php echo _CHARSET; ?>" />
- <title><?php echo CREATE_ACCOUNT_TITLE ?></title>
- <style type="text/css">@import url(nucleus/styles/manual.css);</style>
-</head>
-<body>
-
- <h1><?php echo _CREATE_ACCOUNT0?></h1>
-
-<?php
- // show form only if Visitors are allowed to create a Member Account
- if ($CONF['AllowMemberCreate']==1) {
- // if the form is shown the first time no POST data
- // will be added as value for the input fields
- if ($showform==0) {
-?>
-
- <form method="post" action="createaccount.php">
-
- <div>
- <input type="hidden" name="showform" value="1" />
- <input type="hidden" name="action" value="createaccount" />
-
- <?php echo _CREATE_ACCOUNT_LOGIN_NAME?>
- <br />
- <input name="name" size="20" /> <small>(only a-z, 0-9)</small>
- <br />
- <br />
- <?php echo _CREATE_ACCOUNT_REAL_NAME?>
- <br />
- <input name="realname" size="40" />
- <br />
- <br />
- <?php echo _CREATE_ACCOUNT_EMAIL?>
- <br />
- <input name="email" size="40" /> <small><?php echo _CREATE_ACCOUNT_EMAIL2?></small>
- <br />
- <br />
- <?php echo _CREATE_ACCOUNT_URL?>
- <br />
- <input name="url" size="60" />
- <br />
- <?php
- // add a Captcha challenge or something else
- global $manager;
- $manager->notify('FormExtra', array('type' => 'membermailform-notloggedin'));
- ?>
- <br />
- <br />
- <input type="submit" value="<?php echo _CREATE_ACCOUNT_SUBMIT?>" />
- </div>
-
- </form>
-<?php
- } // close if showfrom ...
- else {
- // after the from is sent it will be validated
- // POST data will be added as value to treat the user with care (;-))
-
- $a = new ACTION();
-
- // if createAccount fails it returns an error message
- $message = $a->createAccount();
-
- echo '<span style="font-weight:bold; color:red;">'.htmlspecialchars($message).'</span><br /><br />';
-?>
-
- <form method="post" action="createaccount.php">
-
- <div>
- <input type="hidden" name="showform" value="1" />
- <input type="hidden" name="action" value="createaccount" />
-
- <?php echo _CREATE_ACCOUNT_LOGIN_NAME?>
- <br />
- <input name="name" size="20" <?php if(isset($_POST['name'])){echo 'value="'.htmlspecialchars($_POST['name']).'"';}?>/> <small>(only a-z, 0-9)</small>
- <br />
- <br />
- <?php echo _CREATE_ACCOUNT_REAL_NAME?>
- <br />
- <input name="realname" size="40" <?php if(isset($_POST['realname'])){echo 'value="'.htmlspecialchars($_POST['realname']).'"';}?>/>
- <br />
- <br />
- <?php echo _CREATE_ACCOUNT_EMAIL?>
- <br />
- <input name="email" size="40" <?php if(isset($_POST['email'])){echo 'value="'.htmlspecialchars($_POST['email']).'"';}?>/> <small><?php echo _CREATE_ACCOUNT_EMAIL2?></small>
- <br />
- <br />
- <?php echo _CREATE_ACCOUNT_URL?>
- <br />
- <input name="url" size="60" <?php if(isset($_POST['url'])){echo 'value="'.htmlspecialchars($_POST['url']).'"';}?>/>
- <br />
- <?php
- // add a Captcha challenge or something else
- global $manager;
- $manager->notify('FormExtra', array('type' => 'membermailform-notloggedin'));
- ?>
- <br />
- <br />
- <input type="submit" value="<?php echo _CREATE_ACCOUNT_SUBMIT?>" />
-
-
- </form>
-<?php
- } // close else showform ...
-
-}
-else {
- echo _CREATE_ACCOUNT1;
- echo _CREATE_ACCOUNT2;
-}
-?>
-
-
-</body>
-</html>
+\r
+require './config.php';\r
+?>\r
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">\r
+<html <?php echo _HTML_XML_NAME_SPACE_AND_LANG_CODE; ?>>\r
+ <head>\r
+ <meta http-equiv="Content-Type" content="text/html; charset=<?php echo _CHARSET; ?>" />\r
+ <title><?php echo _CREATE_ACCOUNT_TITLE ?></title>\r
+ <style type="text/css">@import url(nucleus/styles/manual.css);</style>\r
+ </head>\r
+ <body>\r
+\r
+ <h1><?php echo _CREATE_ACCOUNT0; ?></h1>\r
+<?php\r
+// show form only if Visitors are allowed to create a Member Account\r
+if ($CONF['AllowMemberCreate']==1) { \r
+ if (isset($_POST['showform']) && $_POST['showform'] == 1) {\r
+ include $DIR_LIBS . 'ACTION.php';\r
+ // after the from is sent it will be validated\r
+ // POST data will be added as value to treat the user with care (;-))\r
+ $a = new ACTION();\r
+ // if createAccount fails it returns an error message \r
+ $message = '<span style="font-weight:bold; color:red;">' . htmlspecialchars($a->createAccount()) . '</span><br /><br />';\r
+ if (isset($_POST['name']))\r
+ $name = 'value="' . htmlspecialchars($_POST['name']) . '" ';\r
+ if (isset($_POST['realname']))\r
+ $realname = 'value="' . htmlspecialchars($_POST['realname']) . '" ';\r
+ if (isset($_POST['email']))\r
+ $email = 'value="' . htmlspecialchars($_POST['email']) . '" ';\r
+ if (isset($_POST['url']))\r
+ $url = 'value="' . htmlspecialchars($_POST['url']) . '" ';\r
+// $showform = 1;\r
+// } else {\r
+// $showform = 0;\r
+ echo $message;\r
+ }\r
+?>\r
+ <form method="post" action="createaccount.php">\r
+ <div>\r
+ <input type="hidden" name="showform" value="1" />\r
+ <input type="hidden" name="action" value="createaccount" />\r
+ <?php echo _CREATE_ACCOUNT_LOGIN_NAME; ?>\r
+ <br />\r
+ <input name="name" size="20" <?php echo $name; ?>/> <small><?php echo _CREATE_ACCOUNT_LOGIN_NAME_VALID; ?></small>\r
+ <br />\r
+ <br />\r
+ <?php echo _CREATE_ACCOUNT_REAL_NAME; ?>\r
+ <br />\r
+ <input name="realname" size="40" <?php echo $realname; ?>/>\r
+ <br />\r
+ <br />\r
+ <?php echo _CREATE_ACCOUNT_EMAIL; ?>\r
+ <br />\r
+ <input name="email" size="40" <?php echo $email; ?>/> <small><?php echo _CREATE_ACCOUNT_EMAIL2; ?></small>\r
+ <br />\r
+ <br />\r
+ <?php echo _CREATE_ACCOUNT_URL; ?>\r
+ <br />\r
+ <input name="url" size="60" <?php echo $url; ?>/>\r
+ <br />\r
+<?php\r
+ global $manager;\r
+ // add extra fields from Plugins, like NP_Profile\r
+ $data = array(\r
+ 'type' => 'createaccount.php',\r
+ 'prelabel' => '',\r
+ 'postlabel' => '<br />',\r
+ 'prefield' => '',\r
+ 'postfield' => '<br /><br />'\r
+ );\r
+ $manager->notify('RegistrationFormExtraFields', $data);\r
+ // add a Captcha challenge or something else\r
+ $manager->notify('FormExtra', array('type' => 'membermailform-notloggedin'));\r
+?>\r
+ <br />\r
+ <br />\r
+ <input type="submit" value="<?php echo _CREATE_ACCOUNT_SUBMIT; ?>" />\r
+ </div>\r
+ </form>\r
+<?php\r
+} else {\r
+ echo _CREATE_ACCOUNT1;\r
+ echo _CREATE_ACCOUNT2;\r
+}\r
+?>\r
+ </body>\r
+</html>\r
/**\r
* @license http://nucleuscms.org/license.txt GNU General Public License\r
* @copyright Copyright (C) 2002-2009 The Nucleus Group\r
- * @version $Id: install.php,v 1.8 2007-04-25 06:34:29 kimitake Exp $\r
+ * @version $Id$\r
* $NucleusJP: install.php,v 1.7 2007/02/04 06:28:44 kimitake Exp $\r
*/\r
\r
-- Start Of Configurable Part --\r
*/\r
\r
-include('./install_lang_japanese.php');\r
+include('./install_lang_japanese-utf8.php');\r
\r
// array with names of plugins to install. Plugin files must be present in the nucleus/plugin/\r
// directory.\r
showInstallForm();\r
}\r
\r
- exit;\r
+exit;\r
\r
function showInstallForm() {\r
// 0. pre check if all necessary files exist\r
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">\r
<html xmlns="http://www.w3.org/1999/xhtml">\r
<head>\r
- <meta http-equiv="content-type" content="application/xhtml+xml; charset=UTF-8" />\r
+ <meta http-equiv="content-type" content="application/xhtml+xml; charset=<?php echo _CHARSET; ?>" />\r
<title><?php echo _TITLE; ?></title>\r
<style type="text/css"><!--\r
@import url('nucleus/documentation/styles/manual.css');\r
$minVersion = '4.0.6';\r
\r
if (phpversion() < $minVersion) {\r
- echo ' <span class="warning">', _TEXT2_WARN , $minVersion, '</span>';\r
+ echo ' <span class="warning" style="display:block">' . sprintf(_TEXT2_WARN, $minVersion) . '</span>';\r
} elseif (phpversion() < '5') {\r
- echo ' <span class="warning">' . _TEXT2_WARN3 . '</span>';\r
+ echo ' <span class="warning" style="display:block">' . _TEXT2_WARN3 . '</span>';\r
}\r
?>\r
\r
$result = @mysql_query('SELECT VERSION() AS version');\r
\r
if ($result != FALSE && @mysql_num_rows($result) > 0) {\r
- $row = mysql_fetch_array($result);\r
+ $row = mysql_fetch_array($result);\r
$match = explode('.', $row['version']);\r
} else {\r
$result = @mysql_query('SHOW VARIABLES LIKE \'version\'');\r
\r
if ($result != FALSE && @mysql_num_rows($result) > 0) {\r
- $row = mysql_fetch_row($result);\r
+ $row = mysql_fetch_row($result);\r
$match = explode('.', $row[1]);\r
} else {\r
$output = shell_exec('mysql -V');\r
}\r
\r
if ($mysqlVersion < $minVersion) {\r
- echo ' <span class="warning">'._TEXT2_WARN2 , $minVersion.'</span>';\r
+ echo ' <span class="warning" style="display:block">' . sprintf(_TEXT2_WARN2, $minVersion) . '</span>';\r
}\r
?>\r
\r
\r
<?php\r
// tell people how they can have their config file filled out automatically\r
- if (@file_exists('config.php') && @!is_writable('config.php') ) {\r
+ if (@file_exists('config.php') && @!is_writable('config.php')) {\r
?>\r
\r
<h1><?php echo _HEADER3; ?></h1>\r
<legend><?php echo _TEXT4_TAB_HEAD; ?></legend>\r
<table>\r
<tr>\r
- <td><?php echo _TEXT4_TAB_FIELD1; ?>:</td>\r
+ <td><?php echo _TEXT4_TAB_FIELD1; ?></td>\r
<td><input name="mySQL_host" value="<?php echo htmlspecialchars(@ini_get('mysql.default_host') )?>" /></td>\r
</tr>\r
<tr>\r
- <td><?php echo _TEXT4_TAB_FIELD2; ?>:</td>\r
+ <td><?php echo _TEXT4_TAB_FIELD2; ?></td>\r
<td><input name="mySQL_user" /></td>\r
</tr>\r
<tr>\r
- <td><?php echo _TEXT4_TAB_FIELD3; ?>:</td>\r
+ <td><?php echo _TEXT4_TAB_FIELD3; ?></td>\r
<td><input name="mySQL_password" type="password" /></td>\r
</tr>\r
<tr>\r
- <td><?php echo _TEXT4_TAB_FIELD4; ?>:</td>\r
- <td><input name="mySQL_database" /> (<input name="mySQL_create" value="1" type="checkbox" id="mySQL_create"><label for="mySQL_create" /><?php echo _TEXT4_TAB_FIELD4_ADD; ?></label>)</td>\r
+ <td><?php echo _TEXT4_TAB_FIELD4; ?></td>\r
+ <td><input name="mySQL_database" /> (<input name="mySQL_create" value="1" type="checkbox" id="mySQL_create" /><label for="mySQL_create"><?php echo _TEXT4_TAB_FIELD4_ADD; ?></label>)</td>\r
</tr>\r
</table>\r
</fieldset>\r
<legend><?php echo _TEXT4_TAB2_HEAD; ?></legend>\r
<table>\r
<tr>\r
- <td><input name="mySQL_usePrefix" value="1" type="checkbox" id="mySQL_usePrefix"><label for="mySQL_usePrefix" /><?php echo _TEXT4_TAB2_FIELD; ?>:</label></td>\r
+ <td><input name="mySQL_usePrefix" value="1" type="checkbox" id="mySQL_usePrefix" /><label for="mySQL_usePrefix"><?php echo _TEXT4_TAB2_FIELD; ?></label></td>\r
<td><input name="mySQL_tablePrefix" value="" /></td>\r
</tr>\r
</table>\r
<legend><?php echo _TEXT5_TAB_HEAD; ?></legend>\r
<table>\r
<tr>\r
- <td><?php echo _TEXT5_TAB_FIELD1;?>:</td>\r
+ <td><?php echo _TEXT5_TAB_FIELD1; ?></td>\r
<td><input name="IndexURL" size="60" value="<?php\r
$url = 'http://' . serverVar('HTTP_HOST') . serverVar('PHP_SELF');\r
$url = str_replace('install.php', '', $url);\r
echo $url; ?>" /></td>\r
</tr>\r
<tr>\r
- <td><?php echo _TEXT5_TAB_FIELD2;?>:</td>\r
+ <td><?php echo _TEXT5_TAB_FIELD2; ?></td>\r
<td><input name="AdminURL" size="60" value="<?php\r
if ($url) {\r
- echo $url, 'nucleus/';\r
+ echo $url . 'nucleus/';\r
} ?>" /></td>\r
</tr>\r
<tr>\r
- <td><?php echo _TEXT5_TAB_FIELD3;?>:</td>\r
+ <td><?php echo _TEXT5_TAB_FIELD3; ?></td>\r
<td><input name="AdminPath" size="60" value="<?php\r
if($basePath) {\r
- echo $basePath, 'nucleus/';\r
+ echo $basePath . 'nucleus/';\r
} ?>" /></td>\r
</tr>\r
<tr>\r
- <td><?php echo _TEXT5_TAB_FIELD4;?>:</td>\r
+ <td><?php echo _TEXT5_TAB_FIELD4; ?></td>\r
<td><input name="MediaURL" size="60" value="<?php\r
if ($url) {\r
- echo $url, 'media/';\r
+ echo $url . 'media/';\r
} ?>" /></td>\r
</tr>\r
<tr>\r
- <td><?php echo _TEXT5_TAB_FIELD5;?>:</td>\r
+ <td><?php echo _TEXT5_TAB_FIELD5; ?></td>\r
<td><input name="MediaPath" size="60" value="<?php\r
if ($basePath) {\r
- echo $basePath, 'media/';\r
+ echo $basePath . 'media/';\r
} ?>" /></td>\r
</tr>\r
<tr>\r
- <td><?php echo _TEXT5_TAB_FIELD6;?>:</td>\r
+ <td><?php echo _TEXT5_TAB_FIELD6; ?></td>\r
<td><input name="SkinsURL" size="60" value="<?php\r
if ($url) {\r
- echo $url, 'skins/';\r
+ echo $url . 'skins/';\r
} ?>" />\r
- <br />(used by imported skins)\r
+ <br />(<?php echo _TEXT5_TAB_FIELD7_2; ?>)\r
</td>\r
</tr>\r
<tr>\r
- <td><?php echo _TEXT5_TAB_FIELD7;?>:</td>\r
+ <td><?php echo _TEXT5_TAB_FIELD7; ?></td>\r
<td><input name="SkinsPath" size="60" value="<?php\r
if ($basePath) {\r
- echo $basePath, 'skins/';\r
+ echo $basePath . 'skins/';\r
} ?>" />\r
- <br />(<?php echo _TEXT5_TAB_FIELD7_2;?>)\r
+ <br />(<?php echo _TEXT5_TAB_FIELD7_2; ?>)\r
</td>\r
</tr>\r
<tr>\r
- <td><?php echo _TEXT5_TAB_FIELD8;?>:</td>\r
+ <td><?php echo _TEXT5_TAB_FIELD8; ?></td>\r
<td><input name="PluginURL" size="60" value="<?php\r
if ($url) {\r
- echo $url, 'nucleus/plugins/';\r
+ echo $url . 'nucleus/plugins/';\r
} ?>" /></td>\r
</tr>\r
<tr>\r
- <td><?php echo _TEXT5_TAB_FIELD9;?>:</td>\r
+ <td><?php echo _TEXT5_TAB_FIELD9; ?></td>\r
<td><input name="ActionURL" size="60" value="<?php\r
if ($url) {\r
- echo $url, 'action.php';\r
+ echo $url . 'action.php';\r
} ?>" />\r
<br />(<?php echo _TEXT5_TAB_FIELD9_2;?>)\r
</td>\r
<legend><?php echo _TEXT6_TAB_HEAD; ?></legend>\r
<table>\r
<tr>\r
- <td><?php echo _TEXT6_TAB_FIELD1; ?>:</td>\r
+ <td><?php echo _TEXT6_TAB_FIELD1; ?></td>\r
<td><input name="User_name" value="" /> <small>(<?php echo _TEXT6_TAB_FIELD1_2; ?>)</small></td>\r
</tr>\r
<tr>\r
- <td><?php echo _TEXT6_TAB_FIELD2; ?>:</td>\r
+ <td><?php echo _TEXT6_TAB_FIELD2; ?></td>\r
<td><input name="User_realname" value="" /></td>\r
</tr>\r
<tr>\r
- <td><?php echo _TEXT6_TAB_FIELD3; ?>:</td>\r
+ <td><?php echo _TEXT6_TAB_FIELD3; ?></td>\r
<td><input name="User_password" type="password" value="" /></td>\r
</tr>\r
<tr>\r
- <td><?php echo _TEXT6_TAB_FIELD4; ?>:</td>\r
+ <td><?php echo _TEXT6_TAB_FIELD4; ?></td>\r
<td><input name="User_password2" type="password" value="" /></td>\r
</tr>\r
<tr>\r
- <td><?php echo _TEXT6_TAB_FIELD5; ?>:</td>\r
+ <td><?php echo _TEXT6_TAB_FIELD5; ?></td>\r
<td><input name="User_email" value="" /> <small>(<?php echo _TEXT6_TAB_FIELD5_2; ?>)</small></td>\r
</tr>\r
</table>\r
<legend><?php echo _TEXT7_TAB_HEAD; ?></legend>\r
<table>\r
<tr>\r
- <td><?php echo _TEXT7_TAB_FIELD1; ?>:</td>\r
+ <td><?php echo _TEXT7_TAB_FIELD1; ?></td>\r
<td><input name="Blog_name" size="60" value="My Nucleus CMS" /></td>\r
</tr>\r
<tr>\r
- <td><?php echo _TEXT7_TAB_FIELD2; ?>:</td>\r
+ <td><?php echo _TEXT7_TAB_FIELD2; ?></td>\r
<td><input name="Blog_shortname" value="mynucleuscms" /> <small>(<?php echo _TEXT7_TAB_FIELD2_2; ?>)</small></td>\r
</tr>\r
</table>\r
global $mysql_usePrefix, $mysql_prefix, $weblog_ping;\r
\r
// 0. put all POST-vars into vars\r
- $mysql_host = postVar('mySQL_host');\r
- $mysql_user = postVar('mySQL_user');\r
- $mysql_password = postVar('mySQL_password');\r
- $mysql_database = postVar('mySQL_database');\r
- $mysql_create = postVar('mySQL_create');\r
- $mysql_usePrefix = postVar('mySQL_usePrefix');\r
- $mysql_prefix = postVar('mySQL_tablePrefix');\r
- $config_indexurl = postVar('IndexURL');\r
- $config_adminurl = postVar('AdminURL');\r
- $config_adminpath = postVar('AdminPath');\r
- $config_mediaurl = postVar('MediaURL');\r
- $config_skinsurl = postVar('SkinsURL');\r
- $config_pluginurl = postVar('PluginURL');\r
- $config_actionurl = postVar('ActionURL');\r
- $config_mediapath = postVar('MediaPath');\r
- $config_skinspath = postVar('SkinsPath');\r
- $user_name = postVar('User_name');\r
- $user_realname = postVar('User_realname');\r
- $user_password = postVar('User_password');\r
- $user_password2 = postVar('User_password2');\r
- $user_email = postVar('User_email');\r
- $blog_name = postVar('Blog_name');\r
- $blog_shortname = postVar('Blog_shortname');\r
+ $mysql_host = postVar('mySQL_host');\r
+ $mysql_user = postVar('mySQL_user');\r
+ $mysql_password = postVar('mySQL_password');\r
+ $mysql_database = postVar('mySQL_database');\r
+ $mysql_create = postVar('mySQL_create');\r
+ $mysql_usePrefix = postVar('mySQL_usePrefix');\r
+ $mysql_prefix = postVar('mySQL_tablePrefix');\r
+ $config_indexurl = postVar('IndexURL');\r
+ $config_adminurl = postVar('AdminURL');\r
+ $config_adminpath = postVar('AdminPath');\r
+ $config_mediaurl = postVar('MediaURL');\r
+ $config_skinsurl = postVar('SkinsURL');\r
+ $config_pluginurl = postVar('PluginURL');\r
+ $config_actionurl = postVar('ActionURL');\r
+ $config_mediapath = postVar('MediaPath');\r
+ $config_skinspath = postVar('SkinsPath');\r
+ $user_name = postVar('User_name');\r
+ $user_realname = postVar('User_realname');\r
+ $user_password = postVar('User_password');\r
+ $user_password2 = postVar('User_password2');\r
+ $user_email = postVar('User_email');\r
+ $blog_name = postVar('Blog_name');\r
+ $blog_shortname = postVar('Blog_shortname');\r
$config_adminemail = $user_email;\r
- $config_sitename = $blog_name;\r
- $weblog_ping = postVar('Weblog_ping');\r
-\r
- $config_indexurl = replaceDoubleBackslash($config_indexurl);\r
- $config_adminurl = replaceDoubleBackslash($config_adminurl);\r
- $config_mediaurl = replaceDoubleBackslash($config_mediaurl);\r
- $config_skinsurl = replaceDoubleBackslash($config_skinsurl);\r
- $config_pluginurl = replaceDoubleBackslash($config_pluginurl);\r
- $config_actionurl = replaceDoubleBackslash($config_actionurl);\r
- $config_adminpath = replaceDoubleBackslash($config_adminpath);\r
- $config_skinspath = replaceDoubleBackslash($config_skinspath);\r
- $config_mediapath = replaceDoubleBackslash($config_mediapath);\r
+ $config_sitename = $blog_name;\r
+ $weblog_ping = postVar('Weblog_ping');\r
+\r
+ $config_indexurl = replaceDoubleBackslash($config_indexurl);\r
+ $config_adminurl = replaceDoubleBackslash($config_adminurl);\r
+ $config_mediaurl = replaceDoubleBackslash($config_mediaurl);\r
+ $config_skinsurl = replaceDoubleBackslash($config_skinsurl);\r
+ $config_pluginurl = replaceDoubleBackslash($config_pluginurl);\r
+ $config_actionurl = replaceDoubleBackslash($config_actionurl);\r
+ $config_adminpath = replaceDoubleBackslash($config_adminpath);\r
+ $config_skinspath = replaceDoubleBackslash($config_skinspath);\r
+ $config_mediapath = replaceDoubleBackslash($config_mediapath);\r
\r
// 1. check all the data\r
$errors = array();\r
'nucleus_team',\r
'nucleus_activation',\r
'nucleus_tickets'\r
- );\r
+ );\r
// these are unneeded (one of the replacements above takes care of them)\r
// 'nucleus_plugin_event',\r
// 'nucleus_plugin_option',\r
$mysql_prefix . 'nucleus_team',\r
$mysql_prefix . 'nucleus_activation',\r
$mysql_prefix . 'nucleus_tickets'\r
- );\r
+ );\r
// these are unneeded (one of the replacements above takes care of them)\r
// $mysql_prefix . 'nucleus_plugin_event',\r
// $mysql_prefix . 'nucleus_plugin_option',\r
}\r
\r
// 5a make first post\r
- $newpost = "INSERT INTO `nucleus_item` VALUES (1, '" . _1ST_POST_TITLE . "', '" . _1ST_POST . "', '" . _1ST_POST2 . "', 1, 1, '2005-08-15 11:04:26', 0, 0, 0, 1, 0, 1);";\r
+ $newpost = "INSERT INTO " . tableName('nucleus_item') . " VALUES (1, '" . _1ST_POST_TITLE . "', '" . _1ST_POST . "', '" . _1ST_POST2 . "', 1, 1, '2005-08-15 11:04:26', 0, 0, 0, 1, 0, 1);";\r
mysql_query($newpost) or _doError(_ERROR18 . ' (<small>' . htmlspecialchars($newpost) . '</small>): ' . mysql_error() );\r
\r
// 6. update global settings\r
- updateConfig('IndexURL', $config_indexurl);\r
- updateConfig('AdminURL', $config_adminurl);\r
- updateConfig('MediaURL', $config_mediaurl);\r
- updateConfig('SkinsURL', $config_skinsurl);\r
- updateConfig('PluginURL', $config_pluginurl);\r
- updateConfig('ActionURL', $config_actionurl);\r
+ updateConfig('IndexURL', $config_indexurl);\r
+ updateConfig('AdminURL', $config_adminurl);\r
+ updateConfig('MediaURL', $config_mediaurl);\r
+ updateConfig('SkinsURL', $config_skinsurl);\r
+ updateConfig('PluginURL', $config_pluginurl);\r
+ updateConfig('ActionURL', $config_actionurl);\r
updateConfig('AdminEmail', $config_adminemail);\r
- updateConfig('SiteName', $config_sitename);\r
+ updateConfig('SiteName', $config_sitename);\r
\r
// 7. update GOD member\r
$query = 'UPDATE ' . tableName('nucleus_member')\r
- . " SET mname='" . addslashes($user_name) . "',"\r
- . " mrealname='" . addslashes($user_realname) . "',"\r
- . " mpassword='" . md5(addslashes($user_password) ) . "',"\r
- . " murl='" . addslashes($config_indexurl) . "',"\r
- . " memail='" . addslashes($user_email) . "',"\r
- . " madmin=1, mcanlogin=1"\r
- . " WHERE mnumber=1";\r
+ . " SET mname = '" . addslashes($user_name) . "',"\r
+ . " mrealname = '" . addslashes($user_realname) . "',"\r
+ . " mpassword = '" . md5(addslashes($user_password) ) . "',"\r
+ . " murl = '" . addslashes($config_indexurl) . "',"\r
+ . " memail = '" . addslashes($user_email) . "',"\r
+ . " madmin = 1,"\r
+ . " mcanlogin = 1"\r
+ . " WHERE"\r
+ . " mnumber = 1";\r
\r
mysql_query($query) or _doError(_ERROR19 . ': ' . mysql_error() );\r
\r
// 8. update weblog settings\r
$query = 'UPDATE ' . tableName('nucleus_blog')\r
- . " SET bname='" . addslashes($blog_name) . "',"\r
- . " bshortname='" . addslashes($blog_shortname) . "',"\r
- . " burl='" . addslashes($config_indexurl) . "'"\r
- . " WHERE bnumber=1";\r
+ . " SET bname = '" . addslashes($blog_name) . "',"\r
+ . " bshortname = '" . addslashes($blog_shortname) . "',"\r
+ . " burl = '" . addslashes($config_indexurl) . "'"\r
+ . " WHERE"\r
+ . " bnumber = 1";\r
\r
mysql_query($query) or _doError(_ERROR20 . ': ' . mysql_error() );\r
\r
// 9. update item date\r
$query = 'UPDATE ' . tableName('nucleus_item')\r
- . " SET itime='" . date('Y-m-d H:i:s', time() ) ."'"\r
- . " WHERE inumber=1";\r
+ . " SET itime = '" . date('Y-m-d H:i:s', time() ) ."'"\r
+ . " WHERE inumber = 1";\r
\r
mysql_query($query) or _doError(_ERROR21 . ': ' . mysql_error() );\r
\r
// 10. set global variables\r
global $MYSQL_HOST, $MYSQL_USER, $MYSQL_PASSWORD, $MYSQL_DATABASE, $MYSQL_PREFIX;\r
\r
- $MYSQL_HOST = $mysql_host;\r
- $MYSQL_USER = $mysql_user;\r
+ $MYSQL_HOST = $mysql_host;\r
+ $MYSQL_USER = $mysql_user;\r
$MYSQL_PASSWORD = $mysql_password;\r
$MYSQL_DATABASE = $mysql_database;\r
- $MYSQL_PREFIX = ($mysql_usePrefix == 1)?$mysql_prefix:'';\r
+ $MYSQL_PREFIX = ($mysql_usePrefix == 1) ? $mysql_prefix : '';\r
\r
global $DIR_NUCLEUS, $DIR_MEDIA, $DIR_SKINS, $DIR_PLUGINS, $DIR_LANG, $DIR_LIBS;\r
\r
$DIR_NUCLEUS = $config_adminpath;\r
- $DIR_MEDIA = $config_mediapath;\r
- $DIR_SKINS = $config_skinspath;\r
+ $DIR_MEDIA = $config_mediapath;\r
+ $DIR_SKINS = $config_skinspath;\r
$DIR_PLUGINS = $DIR_NUCLEUS . 'plugins/';\r
- $DIR_LANG = $DIR_NUCLEUS . 'language/';\r
- $DIR_LIBS = $DIR_NUCLEUS . 'libs/';\r
+ $DIR_LANG = $DIR_NUCLEUS . 'language/';\r
+ $DIR_LIBS = $DIR_NUCLEUS . 'libs/';\r
\r
// close database connection (needs to be closed if we want to include globalfunctions.php)\r
mysql_close();\r
$config_data = '<' . '?php' . "\n\n";\r
//$config_data .= "\n"; (extraneous, just added extra \n to previous line\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_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_usePrefix == 1)?$mysql_prefix:'') . "';\n";\r
+ $config_data .= " \$MYSQL_PREFIX = '" . (($mysql_usePrefix == 1) ? $mysql_prefix : '') . "';\n";\r
$config_data .= "\n";\r
$config_data .= " // main nucleus directory\n";\r
$config_data .= " \$DIR_NUCLEUS = '" . $config_adminpath . "';\n";\r
$config_data .= "\n";\r
$config_data .= " // path to media dir\n";\r
- $config_data .= " \$DIR_MEDIA = '" . $config_mediapath . "';\n";\r
+ $config_data .= " \$DIR_MEDIA = '" . $config_mediapath . "';\n";\r
$config_data .= "\n";\r
$config_data .= " // extra skin files for imported skins\n";\r
- $config_data .= " \$DIR_SKINS = '" . $config_skinspath . "';\n";\r
+ $config_data .= " \$DIR_SKINS = '" . $config_skinspath . "';\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_LANG = \$DIR_NUCLEUS . 'language/';\n";\r
- $config_data .= " \$DIR_LIBS = \$DIR_NUCLEUS . 'libs/';\n";\r
+ $config_data .= " \$DIR_LANG = \$DIR_NUCLEUS . 'language/';\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 .= " include(\$DIR_LIBS . 'globalfunctions.php');\n";\r
$config_data .= " if (!extension_loaded('mbstring')) {\n";\r
- $config_data .= " include(\$DIR_LIBS.'mb_emulator/mb-emulator.php');\n";\r
+ $config_data .= " include(\$DIR_LIBS . 'mb_emulator/mb-emulator.php');\n";\r
$config_data .= " }\n";\r
$config_data .= "?" . ">";\r
\r
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">\r
<html xmlns="http://www.w3.org/1999/xhtml">\r
<head>\r
- <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />\r
+ <meta http-equiv="Content-Type" content="text/html; charset=<?php echo _CHARSET; ?>" />\r
<title><?php echo _TITLE; ?></title>\r
<style>@import url('nucleus/styles/manual.css');</style>\r
</head>\r
\r
<pre><code><?php\r
// mySQL connection information\r
- $MYSQL_HOST = '<b><?php echo $mysql_host?></b>';\r
- $MYSQL_USER = '<b><?php echo $mysql_user?></b>';\r
+ $MYSQL_HOST = '<b><?php echo $mysql_host?></b>';\r
+ $MYSQL_USER = '<b><?php echo $mysql_user?></b>';\r
$MYSQL_PASSWORD = '<i><b>xxxxxxxxxxx</b></i>';\r
$MYSQL_DATABASE = '<b><?php echo $mysql_database?></b>';\r
- $MYSQL_PREFIX = '<b><?php echo ($mysql_usePrefix == 1)?$mysql_prefix:''?></b>';\r
+ $MYSQL_PREFIX = '<b><?php echo ($mysql_usePrefix == 1)?$mysql_prefix:''?></b>';\r
\r
// main nucleus directory\r
$DIR_NUCLEUS = '<b><?php echo $config_adminpath?></b>';\r
\r
// path to media dir\r
- $DIR_MEDIA = '<b><?php echo $config_mediapath?></b>';\r
+ $DIR_MEDIA = '<b><?php echo $config_mediapath?></b>';\r
\r
// extra skin files for imported skins\r
- $DIR_SKINS = '<b><?php echo $config_skinspath?></b>';\r
+ $DIR_SKINS = '<b><?php echo $config_skinspath?></b>';\r
\r
// these dirs are normally sub dirs of the nucleus dir, but\r
// you can redefine them if you wish\r
$DIR_PLUGINS = $DIR_NUCLEUS . 'plugins/';\r
- $DIR_LANG = $DIR_NUCLEUS . 'language/';\r
- $DIR_LIBS = $DIR_NUCLEUS . 'libs/';\r
+ $DIR_LANG = $DIR_NUCLEUS . 'language/';\r
+ $DIR_LIBS = $DIR_NUCLEUS . 'libs/';\r
\r
// include libs\r
- include($DIR_LIBS.'globalfunctions.php');\r
+ include($DIR_LIBS . 'globalfunctions.php');\r
if (!extension_loaded('mbstring')) {\r
- include($DIR_LIBS.'mb_emulator/mb-emulator.php');\r
+ include($DIR_LIBS . 'mb_emulator/mb-emulator.php');\r
}\r
?></code></pre>\r
\r
<li><?php echo _TEXT14_L2; ?></li>\r
</ul>\r
\r
- <p>もしこれらのファイルを削除していなければ、管理領域を開くことが出来ません。</p>\r
+ <?php echo _TEXT14_EX; ?>\r
\r
<h1><?php echo _HEADER10; ?></h1>\r
\r
<?php echo _TEXT15; ?>\r
+\r
<ul>\r
<li><?php echo _TEXT15_L1; ?></li>\r
<li><?php echo _TEXT15_L2; ?></li>\r
$res = sql_query('SELECT pid, pfile FROM ' . sql_table('plugin') );\r
\r
while($o = mysql_fetch_object($res) ) {\r
- $pid = $o->pid;\r
+ $pid = $o->pid;\r
$plug =& $manager->getPlugin($o->pfile);\r
\r
if ($plug) {\r
'nucleus/libs/MEDIA.php',\r
'nucleus/libs/ACTIONLOG.php',\r
'nucleus/media.php'\r
- );\r
+ );\r
\r
$count = count($files);\r
\r
\r
function updateConfig($name, $val) {\r
$name = addslashes($name);\r
- $val = trim(addslashes($val) );\r
+ $val = trim(addslashes($val) );\r
\r
$query = 'UPDATE ' . tableName('nucleus_config')\r
- . " SET value='$val'"\r
- . " WHERE name='$name'";\r
+ . " SET value = '$val'"\r
+ . " WHERE name = '$name'";\r
\r
mysql_query($query) or _doError(_ERROR26 . ': ' . mysql_error() );\r
return mysql_insert_id();\r
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">\r
<html xmlns="http://www.w3.org/1999/xhtml">\r
<head>\r
- <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />\r
+ <meta http-equiv="Content-Type" content="text/html; charset=<?php echo _CHARSET ?>" />\r
<title><?php echo _TITLE; ?></title>\r
<style>@import url('nucleus/styles/manual.css');</style>\r
</head>\r
\r
<p><?php echo _ERROR28; ?>: "<?php echo $msg?>";</p>\r
\r
- <p><a href="install.php" onclick="history.back();return false;"><?php echo _TEXT17; ?></a></p>\r
+ <p><a href="install.php" onclick="history.back();"><?php echo _TEXT17; ?></a></p>\r
</body>\r
</html>\r
\r
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">\r
<html xmlns="http://www.w3.org/1999/xhtml">\r
<head>\r
- <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />\r
+ <meta http-equiv="Content-Type" content="text/html; charset=<?php echo _CHARSET ?>" />\r
<title><?php echo _TITLE; ?></title>\r
<style>@import url('nucleus/styles/manual.css');</style>\r
</head>\r
\r
<?php\r
while($msg = array_shift($errors) ) {\r
- echo '<li>', $msg, '</li>';\r
+ echo '<li>' . $msg . '</li>';\r
}\r
?>\r
\r
/* for the non-php systems that decide to show the contents:\r
?></div><?php */\r
\r
-?>\r
+?>
\ No newline at end of file
CREATE TABLE `nucleus_actionlog` (
- `timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
- `message` varchar(255) NOT NULL default ''
+ `logid` int(11) NOT NULL auto_increment,
+ `timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
+ `message` varchar(255) NOT NULL default '',
+ PRIMARY KEY (`logid`)
) TYPE=MyISAM;
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 '',
+ `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`)
) TYPE=MyISAM;
CREATE TABLE `nucleus_ban` (
- `iprange` varchar(15) NOT NULL default '',
- `reason` varchar(255) NOT NULL default '',
- `blogid` int(11) NOT NULL default '0'
+ `iprange` varchar(15) NOT NULL default '',
+ `reason` varchar(255) NOT NULL default '',
+ `blogid` int(11) NOT NULL default '0',
+ KEY `iprange` (`iprange`),
+ KEY `blogid` (`blogid`)
) TYPE=MyISAM;
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(60) 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',
- `bsendping` tinyint(2) NOT NULL default '0',
- `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,
+ `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(60) 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',
+ `bsendping` tinyint(2) NOT NULL default '0',
+ `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) NOT NULL default '0',
+ `bfuturepost` tinyint(2) NOT NULL default '0',
PRIMARY KEY (`bnumber`),
- UNIQUE KEY `bnumber` (`bnumber`),
+-- UNIQUE KEY `bnumber` (`bnumber`),
UNIQUE KEY `bshortname` (`bshortname`)
) TYPE=MyISAM;
INSERT INTO `nucleus_blog` VALUES (1, 'My Nucleus CMS', 'mynucleuscms', '', 1, 0, 0.0, '', 'http://localhost:8080/nucleus/', '', 5, 1, 0, 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',
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',
+ `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`),
+-- UNIQUE KEY `cnumber` (`cnumber`),
KEY `citem` (`citem`),
FULLTEXT KEY `cbody` (`cbody`)
) TYPE=MyISAM;
CREATE TABLE `nucleus_config` (
- `name` varchar(20) NOT NULL default '',
- `value` varchar(128) default NULL,
+ `name` varchar(20) NOT NULL default '',
+ `value` varchar(128) default NULL,
PRIMARY KEY (`name`)
) TYPE=MyISAM;
-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 ('Language', 'japanese-utf8');
-INSERT INTO `nucleus_config` VALUES ('SessionCookie', '');
+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 ('Language', 'japanese-utf8');
+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 ('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', '330');
-INSERT INTO `nucleus_config` VALUES ('DebugVars', '0');
-INSERT INTO `nucleus_config` VALUES ('DefaultListSize', '10');
+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', '340');
+INSERT INTO `nucleus_config` VALUES ('DebugVars', '0');
+INSERT INTO `nucleus_config` VALUES ('DefaultListSize', '10');
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',
+ `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`),
+-- UNIQUE KEY `inumber` (`inumber`),
KEY `itime` (`itime`),
- FULLTEXT KEY `ibody` (`ibody`,`ititle`,`imore`)
+ FULLTEXT KEY `ibody` (`ibody`, `ititle`, `imore`)
) TYPE=MyISAM PACK_KEYS=0;
CREATE TABLE `nucleus_karma` (
- `itemid` int(11) NOT NULL default '0',
- `ip` char(15) NOT NULL default ''
+ `itemid` int(11) NOT NULL default '0',
+ `ip` char(15) NOT NULL default '',
+ KEY `itemid` (`itemid`)
) TYPE=MyISAM;
CREATE TABLE `nucleus_member` (
- `mnumber` int(11) NOT NULL auto_increment,
- `mname` varchar(16) 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,
- `deflang` varchar(20) NOT NULL default '',
- `mautosave` tinyint(2) NOT NULL default '1',
- PRIMARY KEY (`mnumber`),
- UNIQUE KEY `mname` (`mname`),
- UNIQUE KEY `mnumber` (`mnumber`)
+ `mnumber` int(11) NOT NULL auto_increment,
+ `mname` varchar(16) 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,
+ `deflang` varchar(20) NOT NULL default '',
+ `mautosave` tinyint(2) NOT NULL default '1',
+ PRIMARY KEY (`mnumber`),
+-- UNIQUE KEY `mnumber` (`mnumber`),
+ UNIQUE KEY `mname` (`mname`)
) TYPE=MyISAM;
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`)
+ `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`)
) TYPE=MyISAM;
CREATE TABLE `nucleus_plugin_event` (
- `pid` int(11) NOT NULL default '0',
- `event` varchar(40) default NULL,
+ `pid` int(11) NOT NULL default '0',
+ `event` varchar(40) default NULL,
KEY `pid` (`pid`)
) TYPE=MyISAM;
CREATE TABLE `nucleus_plugin_option` (
- `ovalue` text NOT NULL,
- `oid` int(11) NOT NULL auto_increment,
+ `ovalue` text NOT NULL,
+ `oid` int(11) NOT NULL auto_increment,
`ocontextid` int(11) NOT NULL default '0',
- PRIMARY KEY (`oid`,`ocontextid`)
+ PRIMARY KEY (`oid`, `ocontextid`)
) TYPE=MyISAM;
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 '',
+ `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`),
+ `odesc` varchar(255) default NULL,
+ `otype` varchar(20) default NULL,
+ `odef` text,
+ `oextra` text,
+ PRIMARY KEY (`opid`, `oname`, `ocontext`),
UNIQUE KEY `oid` (`oid`)
) TYPE=MyISAM;
CREATE TABLE `nucleus_skin` (
- `sdesc` int(11) NOT NULL default '0',
- `stype` varchar(20) NOT NULL default '',
- `scontent` text NOT NULL,
+ `sdesc` int(11) NOT NULL default '0',
+ `stype` varchar(20) NOT NULL default '',
+ `scontent` text NOT NULL,
PRIMARY KEY (`sdesc`,`stype`)
) TYPE=MyISAM;
INSERT INTO `nucleus_skin` VALUES (3, 'index', '<?xml version="1.0" encoding="UTF-8"?>\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>ja</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><%adminurl%>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',
+ `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 `sdname` (`sdname`),
- UNIQUE KEY `sdnumber` (`sdnumber`)
+-- UNIQUE KEY `sdnumber` (`sdnumber`),
+ UNIQUE KEY `sdname` (`sdname`)
) TYPE=MyISAM;
INSERT INTO `nucleus_skin_desc` VALUES (2, 'feeds/atom', 'Atom 1.0 weblog syndication', 'application/atom+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`)
+ `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`)
) TYPE=MyISAM;
INSERT INTO `nucleus_team` VALUES (1, 1, 1);
CREATE TABLE `nucleus_template` (
- `tdesc` int(11) NOT NULL default '0',
+ `tdesc` int(11) NOT NULL default '0',
`tpartname` varchar(64) NOT NULL default '',
- `tcontent` text NOT NULL,
- PRIMARY KEY (`tdesc`,`tpartname`)
+ `tcontent` text NOT NULL,
+ PRIMARY KEY (`tdesc`, `tpartname`)
) TYPE=MyISAM;
INSERT INTO `nucleus_template` VALUES (3, 'ITEM', '<item>\r\n <title><%title(xml)%></title>\r\n <link><%blogurl%>?itemid=<%itemid%></link>\r\n<description><![CDATA[<%body%><%more%>]]></description>\r\n <category><%category%></category>\r\n<comments><%blogurl%>?itemid=<%itemid%></comments>\r\n <pubDate><%date(rfc822)%></pubDate>\r\n</item>');
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`)
+ `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`)
) TYPE=MyISAM;
INSERT INTO `nucleus_template_desc` VALUES (4, 'feeds/atom/modified', 'Atom feeds: Inserts last modification date');
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',
+ `ctime` datetime NOT NULL default '0000-00-00 00:00:00',
+ `member` int(11) NOT NULL default '0',
PRIMARY KEY (`ticket`,`member`)
) TYPE=MyISAM;