//\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
\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
</tr>\r
<tr>\r
<td><?php echo _TEXT4_TAB_FIELD2; ?></td>\r
- <td><input name="mySQL_user" /></td>\r
+ <td><input name="mySQL_user" tabindex="10020" /></td>\r
</tr>\r
<tr>\r
<td><?php echo _TEXT4_TAB_FIELD3; ?></td>\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
}\r
\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
+// <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
- } else {\r
- mysql_query("SET NAMES " . $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
// 3. try to create database (if needed)\r
if ($mysql_create == 1) {\r
$sql = 'CREATE DATABASE '\r
- . $mysql_database\r
-/*/ <add for garble measure>\r
- . ' DEFAULT CHARACTER SET '\r
- . $charset\r
- . ' COLLATE '\r
- . $collation\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
- . '';\r
- mysql_query($sql) or _doError(_ERROR16 . ': ' . mysql_error());\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
if ($mysql_usePrefix == 1) {\r
$query = str_replace($aTableNames, $aTableNamesPrefixed, $query);\r
}\r
- if ($mysql_create != 1 && strpos($query, 'CREATE TABLE') === 0) {\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
. " '" . $itm_body . "',"\r
. " '" . $itm_more . "',"\r
. " 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
+ 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
. " WHERE"\r
. " mnumber = 1";\r
\r
- mysql_query($query) or _doError(_ERROR19 . ': ' . mysql_error() );\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
. " WHERE"\r
. " bnumber = 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
// 8-2. update category settings\r
if ($charset == 'ujis') {\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
\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
$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 .= " \$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 .= " // 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
<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 _TEXT15_EX; ?>\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
+ while($o = sql_fetch_object($res) ) {\r
$pid = $o->pid;\r
$plug =& $manager->getPlugin($o->pfile);\r
\r
}\r
\r
function updateConfig($name, $val) {\r
+ global $MYSQL_CONN;\r
$name = addslashes($name);\r
$val = trim(addslashes($val) );\r
\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
<!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=<?php echo _CHARSET ?>" />\r
+ <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />\r
<title><?php echo _TITLE; ?></title>\r
<style>@import url('nucleus/styles/manual.css');</style>\r
</head>\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();"><?php echo _TEXT17; ?></a></p>\r
</body>\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=<?php echo _CHARSET ?>" />\r
+ <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />\r
<title><?php echo _TITLE; ?></title>\r
<style>@import url('nucleus/styles/manual.css');</style>\r
</head>\r