<?php\r
/*\r
* Nucleus: PHP/MySQL Weblog CMS (http://nucleuscms.org/)\r
- * Copyright (C) 2002-2007 The Nucleus Group\r
+ * Copyright (C) 2002-2009 The Nucleus Group\r
*\r
* This program is free software; you can redistribute it and/or\r
* modify it under the terms of the GNU General Public License\r
\r
/**\r
* @license http://nucleuscms.org/license.txt GNU General Public License\r
- * @copyright Copyright (C) 2002-2007 The Nucleus Group\r
- * @version $Id: install.php,v 1.8 2007-04-25 06:34:29 kimitake Exp $\r
+ * @copyright Copyright (C) 2002-2009 The Nucleus Group\r
+ * @version $Id$\r
* $NucleusJP: install.php,v 1.7 2007/02/04 06:28:44 kimitake Exp $\r
*/\r
\r
//\r
// example:\r
// array('NP_TrackBack', 'NP_MemberGoodies')\r
-$aConfPlugsToInstall = array('NP_SkinFiles');\r
+$aConfPlugsToInstall = array('NP_SkinFiles', 'NP_SecurityEnforcer', 'NP_Text');\r
\r
\r
// array with skins to install. skins must be present under the skins/ directory with\r
include_once('nucleus/libs/vars4.0.6.php');\r
}\r
\r
+// include core classes that are needed for login & plugin handling\r
+// added for 3.5 sql_* wrapper\r
+global $MYSQL_HANDLER;\r
+//set the handler if different from mysql (or mysqli)\r
+//$MYSQL_HANDLER = array('pdo','mysql');\r
+if (!isset($MYSQL_HANDLER))\r
+ $MYSQL_HANDLER = array('mysql','');\r
+include_once('nucleus/libs/sql/'.$MYSQL_HANDLER[0].'.php');\r
+// end new for 3.5 sql_* wrapper\r
include_once('nucleus/libs/mysql.php');\r
\r
// check if mysql support is installed\r
+// this check may not make sense, as is, in a version past 3.5x\r
if (!function_exists('mysql_query') ) {\r
_doError(_ERROR1);\r
}\r
showInstallForm();\r
}\r
\r
- exit;\r
+exit;\r
\r
function showInstallForm() {\r
// 0. pre check if all necessary files exist\r
\r
<?php echo _TEXT1; ?>\r
\r
+ <h1><?php echo _HEADER1_2 ?></h1>\r
+\r
+ <?php echo _TEXT1_2; ?>\r
+\r
+ <fieldset>\r
+ <legend><?php echo _TEXT1_2_TAB_HEAD; ?></legend>\r
+ <table>\r
+ <tr>\r
+ <td><?php echo _TEXT1_2_TAB_FIELD1; ?></td>\r
+ <td>\r
+ <select name="charset" tabindex="10000">\r
+ <option value="utf8" selected="selected">UTF-8</option>\r
+ <option value="ujis" >EUC-JP</option>\r
+ </select>\r
+ </td>\r
+ </tr>\r
+ </table>\r
+ </fieldset>\r
+\r
<h1><?php echo _HEADER2; ?></h1>\r
\r
<?php echo _TEXT2; ?>\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
\r
<?php\r
// note: this piece of code is taken from phpMyAdmin\r
- $result = @mysql_query('SELECT VERSION() AS version');\r
+ $conn = sql_connect_args('localhost','','');\r
+ $result = @sql_query('SELECT VERSION() AS version', $conn);\r
\r
- if ($result != FALSE && @mysql_num_rows($result) > 0) {\r
- $row = mysql_fetch_array($result);\r
+ if ($result != FALSE && @sql_num_rows($result) > 0) {\r
+ $row = sql_fetch_array($result);\r
$match = explode('.', $row['version']);\r
} else {\r
- $result = @mysql_query('SHOW VARIABLES LIKE \'version\'');\r
+ $result = @sql_query('SHOW VARIABLES LIKE \'version\'', $conn);\r
\r
- if ($result != FALSE && @mysql_num_rows($result) > 0) {\r
- $row = mysql_fetch_row($result);\r
+ if ($result != FALSE && @sql_num_rows($result) > 0) {\r
+ $row = sql_fetch_row($result);\r
$match = explode('.', $row[1]);\r
} else {\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
$match = explode('.', $version[0]);\r
\r
}\r
}\r
\r
+ sql_disconnect($conn);\r
$mysqlVersion = implode($match, '.');\r
- $minVersion = '3.23';\r
+ $minVersion = '3.23';\r
\r
if ($mysqlVersion == '0.0.0') {\r
echo _NOTIFICATION1;\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><input name="mySQL_host" value="<?php echo htmlspecialchars(@ini_get('mysql.default_host') )?>" /></td>\r
+ <td><?php echo _TEXT4_TAB_FIELD1; ?></td>\r
+ <td><input name="mySQL_host" value="<?php echo htmlspecialchars(@ini_get('mysql.default_host') )?>" tabindex="10010" /></td>\r
</tr>\r
<tr>\r
- <td><?php echo _TEXT4_TAB_FIELD2; ?>:</td>\r
- <td><input name="mySQL_user" /></td>\r
+ <td><?php echo _TEXT4_TAB_FIELD2; ?></td>\r
+ <td><input name="mySQL_user" tabindex="10020" /></td>\r
</tr>\r
<tr>\r
- <td><?php echo _TEXT4_TAB_FIELD3; ?>:</td>\r
- <td><input name="mySQL_password" type="password" /></td>\r
+ <td><?php echo _TEXT4_TAB_FIELD3; ?></td>\r
+ <td><input name="mySQL_password" type="password" tabindex="10030" /></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" tabindex="10040" /> (<input name="mySQL_create" value="1" type="checkbox" id="mySQL_create" tabindex="10050" /><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_tablePrefix" value="" /></td>\r
+ <td><input name="mySQL_usePrefix" value="1" type="checkbox" id="mySQL_usePrefix" tabindex="10060" /><label for="mySQL_usePrefix"><?php echo _TEXT4_TAB2_FIELD; ?></label></td>\r
+ <td><input name="mySQL_tablePrefix" value="" tabindex="10070" /></td>\r
</tr>\r
</table>\r
\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
$url .= '/';\r
}\r
\r
- echo $url; ?>" /></td>\r
+ echo $url; ?>" tabindex="10080" /></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
- } ?>" /></td>\r
+ echo $url . 'nucleus/';\r
+ } ?>" tabindex="10090" /></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
- } ?>" /></td>\r
+ echo $basePath . 'nucleus/';\r
+ } ?>" tabindex="10100" /></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
- } ?>" /></td>\r
+ echo $url . 'media/';\r
+ } ?>" tabindex="10110" /></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
- } ?>" /></td>\r
+ echo $basePath . 'media/';\r
+ } ?>" tabindex="10120" /></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
- } ?>" />\r
- <br />(used by imported skins)\r
+ echo $url . 'skins/';\r
+ } ?>" tabindex="10130" />\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
- } ?>" />\r
- <br />(<?php echo _TEXT5_TAB_FIELD7_2;?>)\r
+ echo $basePath . 'skins/';\r
+ } ?>" tabindex="10140" />\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
- } ?>" /></td>\r
+ echo $url . 'nucleus/plugins/';\r
+ } ?>" tabindex="10150" /></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
- } ?>" />\r
+ echo $url . 'action.php';\r
+ } ?>" tabindex="10160" />\r
<br />(<?php echo _TEXT5_TAB_FIELD9_2;?>)\r
</td>\r
</tr>\r
<legend><?php echo _TEXT6_TAB_HEAD; ?></legend>\r
<table>\r
<tr>\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
+ <td><?php echo _TEXT6_TAB_FIELD1; ?></td>\r
+ <td><input name="User_name" value="" tabindex="10170" /> <small>(<?php echo _TEXT6_TAB_FIELD1_2; ?>)</small></td>\r
</tr>\r
<tr>\r
- <td><?php echo _TEXT6_TAB_FIELD2; ?>:</td>\r
- <td><input name="User_realname" value="" /></td>\r
+ <td><?php echo _TEXT6_TAB_FIELD2; ?></td>\r
+ <td><input name="User_realname" value="" tabindex="10180" /></td>\r
</tr>\r
<tr>\r
- <td><?php echo _TEXT6_TAB_FIELD3; ?>:</td>\r
- <td><input name="User_password" type="password" value="" /></td>\r
+ <td><?php echo _TEXT6_TAB_FIELD3; ?></td>\r
+ <td><input name="User_password" type="password" value="" tabindex="10190" /></td>\r
</tr>\r
<tr>\r
- <td><?php echo _TEXT6_TAB_FIELD4; ?>:</td>\r
- <td><input name="User_password2" type="password" value="" /></td>\r
+ <td><?php echo _TEXT6_TAB_FIELD4; ?></td>\r
+ <td><input name="User_password2" type="password" value="" tabindex="10200" /></td>\r
</tr>\r
<tr>\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
+ <td><?php echo _TEXT6_TAB_FIELD5; ?></td>\r
+ <td><input name="User_email" value="" tabindex="10210" /> <small>(<?php echo _TEXT6_TAB_FIELD5_2; ?>)</small></td>\r
</tr>\r
</table>\r
</fieldset>\r
<legend><?php echo _TEXT7_TAB_HEAD; ?></legend>\r
<table>\r
<tr>\r
- <td><?php echo _TEXT7_TAB_FIELD1; ?>:</td>\r
- <td><input name="Blog_name" size="60" value="My Nucleus CMS" /></td>\r
+ <td><?php echo _TEXT7_TAB_FIELD1; ?></td>\r
+ <td><input name="Blog_name" size="60" value="My Nucleus CMS" tabindex="10220" /></td>\r
</tr>\r
<tr>\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
+ <td><?php echo _TEXT7_TAB_FIELD2; ?></td>\r
+ <td><input name="Blog_shortname" value="mynucleuscms" tabindex="10230" /> <small>(<?php echo _TEXT7_TAB_FIELD2_2; ?>)</small></td>\r
</tr>\r
</table>\r
</fieldset>\r
<legend><?php echo _TEXT8_TAB_HEADER; ?></legend>\r
<table>\r
<tr>\r
- <td><input name="Weblog_ping" value="1" type="checkbox" id="Weblog_ping" /><?php echo _TEXT8_TAB_FIELD1; ?></td>\r
+ <td><input name="Weblog_ping" value="1" type="checkbox" id="Weblog_ping" tabindex="10240" /><?php echo _TEXT8_TAB_FIELD1; ?></td>\r
</tr>\r
</table>\r
</fieldset>\r
\r
<?php echo _TEXT9; ?>\r
\r
- <p><input name="action" value="go" type="hidden" /> <input type="submit" value="<?php echo _BUTTON1; ?>" onclick="return checkSubmit();" /></p>\r
+ <p><input name="action" value="go" type="hidden" /> <input type="submit" value="<?php echo _BUTTON1; ?>" onclick="return checkSubmit();" tabindex="10250" /></p>\r
\r
</form>\r
</body>\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
+ $charset = postVar('charset');\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
+ $_POST = array();\r
+ if (!extension_loaded('mbstring')) {\r
+ include('nucleus/libs/mb_emulator/mb-emulator.php');\r
+ }\r
+ if ($charset == 'ujis') {\r
+ define('_CHARSET', 'EUC-JP');\r
+ $config_sitename = mb_convert_encoding($config_sitename, _CHARSET, 'UTF-8');\r
+ $user_realname = mb_convert_encoding($user_realname, _CHARSET, 'UTF-8');\r
+ $blog_name = mb_convert_encoding($blog_name, _CHARSET, 'UTF-8');\r
+ } else {\r
+ define('_CHARSET', 'UTF-8');\r
+ }\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
showErrorMessages($errors);\r
}\r
\r
- // 2. try to log in to mySQL\r
+ // 2-1. try to log in to mySQL\r
+\r
global $MYSQL_CONN;\r
- $MYSQL_CONN = @mysql_connect($mysql_host, $mysql_user, $mysql_password);\r
+ // this will need to be changed if we ever allow\r
+ $MYSQL_CONN = @sql_connect_args($mysql_host, $mysql_user, $mysql_password);\r
\r
if ($MYSQL_CONN == false) {\r
- _doError(_ERROR15 . ': ' . mysql_error() );\r
+ _doError(_ERROR15 . ': ' . sql_error() );\r
+ }\r
+\r
+// <add for garble measure>\r
+ // 2-2. set DEFAULT CHARSET and COLLATE\r
+ $mySqlVer = implode('.', array_map('intval', explode('.', mysql_get_server_info($MYSQL_CONN))));\r
+ if ($mySqlVer >= '5.0.7' && phpversion() >= '5.2.3') {\r
+ mysql_set_charset($charset);\r
+ } elseif ($mySqlVer >= '4.1.0') {\r
+ sql_query("SET NAMES " . $charset);\r
}\r
+ $collation = ($charset == 'utf8') ? 'utf8_unicode_ci' : 'ujis_japanese_ci';\r
+// </add for garble measure>*/\r
\r
// 3. try to create database (if needed)\r
if ($mysql_create == 1) {\r
- mysql_query('CREATE DATABASE ' . $mysql_database) or _doError(_ERROR16 . ': ' . mysql_error() );\r
+ $sql = 'CREATE DATABASE '\r
+ . $mysql_database;\r
+// <add for garble measure>\r
+ if ($mySqlVer >= '4.1.0') {\r
+ $sql .= ' DEFAULT CHARACTER SET '\r
+ . $charset\r
+ . ' COLLATE '\r
+ . $collation;\r
+ }\r
+// </add for garble measure>*/\r
+ sql_query($sql,$MYSQL_CONN) or _doError(_ERROR16 . ': ' . sql_error($MYSQL_CONN));\r
}\r
\r
// 4. try to select database\r
- mysql_select_db($mysql_database) or _doError(_ERROR17);\r
+ sql_select_db($mysql_database,$MYSQL_CONN) or _doError(_ERROR17);\r
\r
// 5. execute queries\r
$filename = 'install.sql';\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
if ($mysql_usePrefix == 1) {\r
$query = str_replace($aTableNames, $aTableNamesPrefixed, $query);\r
}\r
+// <add for garble measure>\r
+ if ($mysql_create != 1 && strpos($query, 'CREATE TABLE') === 0 && $mySqlVer >= '4.1.0') {\r
+ $query .= ' DEFAULT CHARACTER SET ' . $charset . ' COLLATE ' . $collation;\r
+ }\r
+// </add for garble measure>*/\r
\r
- mysql_query($query) or _doError(_ERROR30 . ' (<small>' . htmlspecialchars($query) . '</small>): ' . mysql_error() );\r
+ sql_query($query,$MYSQL_CONN) or _doError(_ERROR30 . ' (<small>' . htmlspecialchars($query) . '</small>): ' . sql_error($MYSQL_CONN) );\r
}\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
- mysql_query($newpost) or _doError(_ERROR18 . ' (<small>' . htmlspecialchars($newpost) . '</small>): ' . mysql_error() );\r
+ if ($charset == 'ujis') {\r
+ $itm_title = mb_convert_encoding(_1ST_POST_TITLE, _CHARSET, 'UTF-8');\r
+ $itm_body = mb_convert_encoding(_1ST_POST, _CHARSET, 'UTF-8');\r
+ $itm_more = mb_convert_encoding(_1ST_POST2, _CHARSET, 'UTF-8');\r
+ } else {\r
+ $itm_title = _1ST_POST_TITLE;\r
+ $itm_body = _1ST_POST;\r
+ $itm_more = _1ST_POST2;\r
+ }\r
+ $newpost = "INSERT INTO "\r
+ . tableName('nucleus_item')\r
+ . " VALUES ("\r
+ . "1, "\r
+ . "'" . $itm_title . "',"\r
+ . " '" . $itm_body . "',"\r
+ . " '" . $itm_more . "',"\r
+ . " 1, 1, '2005-08-15 11:04:26', 0, 0, 0, 1, 0, 1);";\r
+ sql_query($newpost,$MYSQL_CONN) or _doError(_ERROR18 . ' (<small>' . htmlspecialchars($newpost) . '</small>): ' . sql_error($MYSQL_CONN) );\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
+ if ($charset == 'ujis') {\r
+ updateConfig('Language', 'japanese-euc');\r
+ }\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
-\r
- mysql_query($query) or _doError(_ERROR19 . ': ' . mysql_error() );\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
+ sql_query($query,$MYSQL_CONN) or _doError(_ERROR19 . ': ' . sql_error($MYSQL_CONN) );\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
+ sql_query($query,$MYSQL_CONN) or _doError(_ERROR20 . ': ' . sql_error($MYSQL_CONN) );\r
+\r
+ // 8-2. update category settings\r
+ if ($charset == 'ujis') {\r
+ $cat_name = mb_convert_encoding(_GENERALCAT_NAME, _CHARSET, 'UTF-8');\r
+ $cat_desc = mb_convert_encoding(_GENERALCAT_DESC, _CHARSET, 'UTF-8');\r
+ } else {\r
+ $cat_name = _GENERALCAT_NAME;\r
+ $cat_desc = _GENERALCAT_DESC;\r
+ }\r
+ $query = 'UPDATE ' . tableName('nucleus_category')\r
+ . " SET cname = '" . $cat_name . "',"\r
+ . " cdesc = '" . $cat_desc . "'"\r
+ . " WHERE"\r
+ . " catid = 1";\r
\r
- mysql_query($query) or _doError(_ERROR20 . ': ' . mysql_error() );\r
+ sql_query($query,$MYSQL_CONN) or _doError(_ERROR20 . ': ' . sql_error($MYSQL_CONN) );\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
+ sql_query($query,$MYSQL_CONN) or _doError(_ERROR21 . ': ' . sql_error($MYSQL_CONN) );\r
\r
global $aConfPlugsToInstall, $aConfSkinsToImport;\r
$aSkinErrors = array();\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
+ sql_close($MYSQL_CONN);\r
\r
$manager = '';\r
include_once($DIR_LIBS . 'globalfunctions.php');\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 .= " // 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 = '" . $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
\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
-\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
+ <li><?php echo _TEXT15_L3; ?></li>\r
</ul>\r
\r
<?php echo _TEXT16; ?>\r
\r
<h1><?php echo _HEADER11; ?></h1>\r
\r
- <p><?php echo _TEXT16; ?>\r
+ <p><?php echo _TEXT16_H; ?>\r
<ul>\r
<li><a href="<?php echo $config_adminurl?>"><?php echo _TEXT16_L1; ?></a></li>\r
<li><a href="<?php echo $config_indexurl?>"><?php echo _TEXT16_L2; ?></a></li>\r
}\r
\r
$res = sql_query('SELECT * FROM ' . sql_table('plugin') );\r
- $numCurrent = mysql_num_rows($res);\r
+ $numCurrent = sql_num_rows($res);\r
\r
foreach ($aConfPlugsToInstall as $plugName) {\r
// do this before calling getPlugin (in case the plugin id is used there)\r
// loop over all installed plugins\r
$res = sql_query('SELECT pid, pfile FROM ' . sql_table('plugin') );\r
\r
- while($o = mysql_fetch_object($res) ) {\r
- $pid = $o->pid;\r
+ while($o = sql_fetch_object($res) ) {\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
\r
function updateConfig($name, $val) {\r
+ global $MYSQL_CONN;\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
+ sql_query($query,$MYSQL_CONN) or _doError(_ERROR26 . ': ' . mysql_error($MYSQL_CONN) );\r
+ return sql_insert_id($MYSQL_CONN);\r
}\r
\r
function replaceDoubleBackslash($input) {\r
<div style='text-align:center'><img src='./nucleus/styles/logo.gif' /></div> <!-- Nucleus logo -->\r
<h1><?php echo _ERROR27; ?></h1>\r
\r
- <p><?php echo _ERROR28; ?>: "<?php echo $msg?>";</p>\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
\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