OSDN Git Service

change create blog link code on <%bloglist%> for event_GenerateURL
[nucleus-jp/nucleus-jp-ancient.git] / euc / install.php
index d6ffea5..8af4d25 100755 (executable)
-<?php\r
-       /**\r
-         * Nucleus: PHP/MySQL Weblog CMS (http://nucleuscms.org/)\r
-         * Copyright (C) 2002-2005 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
-         * as published by the Free Software Foundation; either version 2\r
-         * of the License, or (at your option) any later version.\r
-         * (see nucleus/documentation/index.html#license for more info)\r
-         * This script will install the Nucleus tables in your SQL-database, and initialize the data in\r
-         * those tables.\r
-         *\r
-         * Below is a friendly way of letting users on non-php systems know that Nucleus won't run there.\r
-         *\r
-         * ?><div style="font-size: xx-large;">If you see this text in your browser when you open <i>install.php</i>, your web server is not able to run PHP-scripts, and therefor Nucleus will not be able to run there. </div><div style="display: none"><?php         */\r
-\r
-       /*\r
-               This part of the install.php code allows for customization of the install process.\r
-               When distributing plugins or skins together with a Nucleus installation, the\r
-               configuration below will instruct to install them\r
-\r
-               -- Start Of Configurable Part --\r
-       */\r
-\r
-               // array with names of plugins to install. Plugin files must be present in the nucleus/plugin/\r
-               // directory.\r
-               //\r
-               // example:\r
-               //     array('NP_TrackBack', 'NP_MemberGoodies')\r
-               $aConfPlugsToInstall = array('NP_SkinFiles');\r
-\r
-\r
-               // array with skins to install. skins must be present under the skins/ directory with\r
-               // a subdirectory having the same name that contains a skinbackup.xml file\r
-               //\r
-               // example:\r
-               //     array('base','rsd')\r
-               $aConfSkinsToImport = array('default');\r
-\r
-       /*\r
-               -- End Of Configurable Part --\r
-       */\r
-\r
-       // don't give warnings for uninitialized vars\r
-       error_reporting(E_ERROR | E_WARNING | E_PARSE);\r
-\r
-       // make sure there's no unnecessary escaping:\r
-       set_magic_quotes_runtime(0);\r
-\r
-  // if there are some plugins or skins to import, do not include vars\r
-  // in globalfunctions.php again... so set a flag\r
-       if ((count($aConfPlugsToInstall) > 0) || (count($aConfSkinsToImport) > 0)) {\r
-         global $CONF;\r
-         $CONF['installscript']=1;\r
-       }\r
-  if (phpversion() >= '4.1.0')\r
-         include_once('nucleus/libs/vars4.1.0.php');\r
-  else\r
-         include_once('nucleus/libs/vars4.0.6.php');\r
-\r
-       // check if mysql support is installed\r
-       if (!function_exists('mysql_query'))\r
-               _doError('Your PHP version does not have support for MySQL :(');\r
-\r
-       if (postVar('action') == 'go')\r
-               doInstall();\r
-       else\r
-               showInstallForm();\r
-       exit;\r
-\r
-       function showInstallForm() {\r
-\r
-               // 0. pre check if all necessary files exist\r
-               doCheckFiles();\r
-\r
-       ?>\r
-       <!DOCTYPE html\r
-       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=EUC-JP" />\r
-               <title>Nucleus¤Î¥¤¥ó¥¹¥È¡¼¥ë</title>\r
-               <style type="text/css"><!--\r
-                       @import url('nucleus/documentation/styles/manual.css');\r
-               --></style>\r
-               <script type="text/javascript"><!--\r
-                       // function to make sure the submit button only gets pressed once\r
-                       var submitcount=0;\r
-                       function checkSubmit() {\r
-                               if (submitcount == 0) {\r
-                                       submitcount++;\r
-                                       return true;\r
-                               } else {\r
-                                       return false;\r
-                               }\r
-                       }\r
-               --></script>\r
-       </head>\r
-       <body>\r
-\r
-  <div style='text-align:center'><img src='./nucleus/styles/logo.gif' /></div> <!-- Nucleus logo -->\r
-\r
-       <form method="post" action="install.php">\r
-\r
-       <h1>Install Nucleus</h1>\r
-\r
-       <p>\r
-       ¤³¤Î¥¹¥¯¥ê¥×¥È¤ÏNucleus¤Î¥¤¥ó¥¹¥È¡¼¥ë¤ò¼ê½õ¤±¤·¤Þ¤¹¡£MySQL¥Æ¡¼¥Ö¥ë¤Î¥»¥Ã¥È¥¢¥Ã¥×¤È¡¢<i>config.php</i>¤ËÆþÎϤ¹¤ë¤¿¤á¤Î¾ðÊó¤òɽ¼¨¤·¤Þ¤¹¡Êconfig.php¤Î¥Ñ¡¼¥ß¥Ã¥·¥ç¥ó¤ò0666¤Ë¤·¤Æ¤ª¤±¤Ð¡¢¸å¼Ô¤Îºî¶È¤Ï¼«Æ°Åª¤Ë¹Ô¤ï¤ì¤Þ¤¹¡Ë¡£¤³¤ì¤ò¤Ê¤¹°Ù¤Ë¡¢¤¤¤¯¤Ä¤«¤Î¾ðÊó¤òÆþÎϤ¹¤ëɬÍפ¬¤¢¤ê¤Þ¤¹¡£\r
-       </p>\r
-\r
-       <p>\r
-       ¤¹¤Ù¤Æ¤ÎÍó¤ÎÆþÎϤ¬É¬ÍפǤ¹¡£¥ª¥×¥·¥ç¥ó¾ðÊó¤Ï¥¤¥ó¥¹¥È¡¼¥ë¤¬´°Î»¤·¤¿¤é¡¢Nucleus¤Î´ÉÍýÎΰ褫¤éÀßÄê²Äǽ¤Ç¤¹¡£\r
-       </p>\r
-\r
-       <h1>PHP &amp; MySQL Versions</h1>\r
-\r
-       <p>\r
-               °Ê²¼¤Ï¤¢¤Ê¤¿¤Î¥¦¥§¥Ö¥Û¥¹¥È¤Ë¤ª¤±¤ëPHP¥¤¥ó¥¿¡¼¥×¥ê¥¿¡¼¤ÈMySQL¥µ¡¼¥Ð¡¼¤Î¥Ð¡¼¥¸¥ç¥ó¤Ç¤¹¡£Nucleus¤Î¥µ¥Ý¡¼¥È¥Õ¥©¡¼¥é¥à¤ËÌäÂê¤òÊó¹ð¤¹¤ë¤È¤­¤Ï¡¢¤³¤Î¾ðÊó¤ò½ñ¤­Åº¤¨¤Æ¤¯¤À¤µ¤¤¡£\r
-       </p>\r
-\r
-       <ul>\r
-               <li>PHP: <?php                  echo phpversion();\r
-                       $minVersion = '4.0.6';\r
-\r
-                       if (phpversion() < $minVersion)\r
-                               echo ' <span class="warning">Ãí°Õ: Nucleus¤ÎÆ°ºî¤Ë¤Ï¾¯¤Ê¤¯¤È¤â¥Ð¡¼¥¸¥ç¥ó ',$minVersion,' ¤¬É¬ÍפȤµ¤ì¤Þ¤¹</span>';\r
-               ?></li>\r
-               <li>MySQL: <?php\r
-                       // note: this piece of code is taken from phpMyAdmin\r
-\r
-                       $result = @mysql_query('SELECT VERSION() AS version');\r
-                       if ($result != FALSE && @mysql_num_rows($result) > 0) {\r
-                               $row   = mysql_fetch_array($result);\r
-                               $match = explode('.', $row['version']);\r
-                       } else {\r
-                               $result = @mysql_query('SHOW VARIABLES LIKE \'version\'');\r
-                               if ($result != FALSE && @mysql_num_rows($result) > 0){\r
-                                       $row   = mysql_fetch_row($result);\r
-                                       $match = explode('.', $row[1]);\r
-                               } else {\r
-                                       $match[0] = '?';\r
-                                       $match[1] = '?';\r
-                                       $match[2] = '?';\r
-                               }\r
-                       }\r
-\r
-                       if (!isset($match) || !isset($match[0])) {\r
-                               $match[0] = 3;\r
-                       }\r
-                       if (!isset($match[1])) {\r
-                               $match[1] = 21;\r
-                       }\r
-                       if (!isset($match[2])) {\r
-                               $match[2] = 0;\r
-                       }\r
-\r
-                       if ($match[0] != '?') {\r
-                               $match[0] = intval($match[0]);\r
-                               $match[1] = intval($match[1]);\r
-                       }\r
-\r
-                       $mysqlVersion = implode($match, '.');\r
-                       $minVersion = '3.23';\r
-\r
-                       echo $mysqlVersion;\r
-\r
-                       if ($mysqlVersion < $minVersion)\r
-                               echo ' <span class="warning">Ãí°Õ: Nucleus¤ÎÆ°ºî¤Ë¤Ï¾¯¤Ê¤¯¤È¤â¥Ð¡¼¥¸¥ç¥ó ',$minVersion,' ¤¬É¬ÍפȤµ¤ì¤Þ¤¹</span>';\r
-               ?></li>\r
-       </ul>\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
-?>\r
-       <h1><i>config.php</i>¤Î¼«Æ°¥¢¥Ã¥×¥Ç¡¼¥È</h1>\r
-\r
-       <p>\r
-       ¤â¤·<em>config.php</em>¤ò¼«Æ°Åª¤Ë¹¹¿·¤¹¤ë¤è¤¦¤Ë¤·¤¿¤¤¤Ê¤é¡¢½ñ¤­¹þ¤ß²Äǽ¤Ë¤¹¤ëɬÍפ¬¤¢¤ê¤Þ¤¹¡£<em>config.php</em>¤Î¥Ñ¡¼¥ß¥Ã¥·¥ç¥ó¤ò<strong>666</strong>¤Ë¤·¤Æ¤¯¤À¤µ¤¤¡£Nucleus¤Î¥¤¥ó¥¹¥È¡¼¥ëÀ®¸ù¸å¤Ë¡¢¥Ñ¡¼¥ß¥Ã¥·¥ç¥ó¤ò<strong>444</strong>¤ËÌᤵ¤Ê¤±¤ì¤Ð¤Ê¤ê¤Þ¤»¤ó¡Ê<a href="nucleus/documentation/tips.html#filepermissions">¥Ñ¡¼¥ß¥Ã¥·¥ç¥óÊѹ¹¤Î´Ê°×¥¬¥¤¥É</a>¡Ë¡£\r
-       </p>\r
-\r
-       <p>\r
-       ¤â¤·¥Õ¥¡¥¤¥ë¤Ë½ñ¤­¹þ¤Þ¤Ê¤¤¤È¤¤¤¦ÁªÂò¤ò¤·¤¿¡Ê¤¢¤ë¤¤¤Ï¹Ô¤¨¤Ê¤¤¡Ë¾ì¹ç¡§¤´¿´Çۤʤ¯¡£¥¤¥ó¥¹¥È¡¼¥ë¤Î²áÄø¤Ç<em>config.php</em>¤ÎÃæ¿È¤¬Ä󶡤µ¤ì¤Þ¤¹¡£¤Ç¤¹¤«¤é¡¢¤½¤ì¤ò¤´¼«¿È¤Ç¥¢¥Ã¥×¥í¡¼¥É¤·¤Æ¤¯¤À¤µ¤¤¡£\r
-       </p>\r
-\r
-<?php } ?>\r
-\r
-       <h1>MySQL¤Î¥í¥°¥¤¥ó¥Ç¡¼¥¿</h1>\r
-\r
-       <p>\r
-       MySQL¤Î¥Ç¡¼¥¿¤ò°Ê²¼¤ËÆþÎϤ·¤Æ¤¯¤À¤µ¤¤¡£¤½¤ì¤é¤Ï¥Ç¡¼¥¿¥Ù¡¼¥¹¡¦¥Æ¡¼¥Ö¥ë¤òºîÀ®¤·¾ðÊó¤òÆþÎϤ¹¤ë¤¿¤á¤ËɬÍפʤâ¤Î¤Ç¤¹¡£¸å¤Ç¡¢<i>config.php</i>¤Ë¤âµ­Æþ¤¹¤ëɬÍפ¬¤¢¤ê¤Þ¤¹¡Ê¾åµ­¤Î¼«Æ°¥¢¥Ã¥×¥Ç¡¼¥È¤òÍøÍѤ¹¤ë¾ì¹ç¡¢¤½¤Î¼ê½ç¤Ï¾Êά¤µ¤ì¤Þ¤¹¡Ë¡£\r
-       </p>\r
-\r
-       <p>\r
-       ¤â¤·¤³¤Î¾ðÊ󤬤狼¤é¤Ê¤±¤ì¤Ð¡¢¥·¥¹¥Æ¥à´ÉÍý¼Ô¤«¥Û¥¹¥Æ¥£¥ó¥°¸µ¤ËÏ¢Íí¤ò¤È¤Ã¤Æ¤¯¤À¤µ¤¤¡£¤Û¤È¤ó¤É¤Î¾ì¹ç¡¢¥Û¥¹¥È̾¤Ï'localhost'¤Ç¤¹¡£¤â¤·Nucleus¤¬¤¢¤Ê¤¿¤Î¥µ¡¼¥Ð¤ÎPHPÀßÄ꤫¤é'default MySQL host'¤ò¸¡ÃΤ·¤¿¤Ê¤é¡¢'¥Û¥¹¥È̾'¤Ë´û¤Ëµ­Æþ¤µ¤ì¤Æ¤¤¤ë¤Ï¤º¤Ç¤¹¡£¤â¤Ã¤È¤â¡¢¤³¤Î¾ðÊó¤¬Àµ³Î¤Ç¤¢¤ë¤È¤¤¤¦ÊݾڤϤ¢¤ê¤Þ¤»¤ó¡£\r
-       </p>\r
-\r
-       <fieldset>\r
-               <legend>´ðËܤΥǡ¼¥¿¥Ù¡¼¥¹ÀßÄê</legend>\r
-               <table><tr>\r
-                       <td>¥Û¥¹¥È̾¡§</td>\r
-                       <td><input name="mySQL_host" value="<?php echo htmlspecialchars(@ini_get('mysql.default_host'))?>" /></td>\r
-               </tr><tr>\r
-                       <td>¥æ¡¼¥¶¡¼Ì¾¡§</td>\r
-                       <td><input name="mySQL_user" /></td>\r
-               </tr><tr>\r
-                       <td>¥Ñ¥¹¥ï¡¼¥É¡§</td>\r
-                       <td><input name="mySQL_password" type="password" /></td>\r
-               </tr><tr>\r
-                       <td>¥Ç¡¼¥¿¥Ù¡¼¥¹Ì¾¡§</td>\r
-                       <td><input name="mySQL_database" /> (<input name="mySQL_create" value="1" type="checkbox" id="mySQL_create"><label for="mySQL_create" />¥Ç¡¼¥¿¥Ù¡¼¥¹¤òºîÀ®¤¹¤ëɬÍפ¬¤¢¤ë</label>)</td>\r
-               </tr></table>\r
-       </fieldset>\r
-\r
-       <fieldset>\r
-               <legend>¹âÅù¤Ê¥Ç¡¼¥¿¥Ù¡¼¥¹ÀßÄê</legend>\r
-               <table><tr>\r
-                       <td><input name="mySQL_usePrefix" value="1" type="checkbox" id="mySQL_usePrefix"><label for="mySQL_usePrefix" />¥Æ¡¼¥Ö¥ë¡¦¥×¥ê¥Õ¥£¥Ã¥¯¥¹¤òÍøÍÑ</label></td>\r
-                       <td><input name="mySQL_tablePrefix" value="" /></td>\r
-               </tr></table>\r
-               <p>°ì¤Ä¤Î¥Ç¡¼¥¿¥Ù¡¼¥¹¤ËÊ£¿ô¤ÎNucleus¤ò¥¤¥ó¥¹¥È¡¼¥ë¤·¤Æ¤ª¤ê¡¢¼«Ê¬¤¬²¿¤ò¤ä¤Ã¤Æ¤¤¤ë¤Î¤«Íý²ò¤µ¤ì¤Æ¤¤¤ë¾ì¹ç¤ò½ü¤¤¤Æ¤Ï¡¢<strong>¤³¤ì¤òÊѹ¹¤¹¤ëɬÍפϤ¢¤ê¤Þ¤»¤ó</strong>¡£</p>\r
-               <p>Nucleus¤Ë¤è¤Ã¤ÆÀ¸À®¤µ¤ì¤¿¤¹¤Ù¤Æ¤Î¥Ç¡¼¥¿¥Ù¡¼¥¹¥Æ¡¼¥Ö¥ë¤Ï¡¢¤³¤Î¥×¥ê¥Õ¥£¥Ã¥¯¥¹¤¬Æ¬¤Ë¤Ä¤­¤Þ¤¹¡£</p>\r
-       </fieldset>\r
-\r
-       <h1>¥Ç¥£¥ì¥¯¥È¥ê¤ÈURL</h1>\r
-\r
-       <p>\r
-       ¤³¤Î¥¤¥ó¥¹¥È¡¼¥ë¥¹¥¯¥ê¥×¥È¤ÏNucleus¤¬¥¤¥ó¥¹¥È¡¼¥ë¤µ¤ì¤Æ¤¤¤ë¥Ç¥£¥ì¥¯¥È¥ê¤ÈURL¤ò¸«¤Ä¤±¤è¤¦¤È¤·¤Þ¤·¤¿¡£²¼¤ÎÃͤò¥Á¥§¥Ã¥¯¤·¤ÆɬÍפʤéÄûÀµ¤·¤Æ¤¯¤À¤µ¤¤¡£¥Õ¥¡¥¤¥ë¤Ø¤Î¥Ñ¥¹¤ÈURL¤Ï¥¹¥é¥Ã¥·¥å'/'¤Ç½ª¤ï¤é¤Ê¤¯¤Æ¤Ï¤Ê¤ê¤Þ¤»¤ó¡£\r
-       </p>\r
-\r
-       <fieldset>\r
-               <legend>URLs and directories</legend>\r
-               <table><tr>\r
-                       <td>Site <strong>URL</strong>:</td>\r
-                       <td>\r
-                                       <input name="IndexURL" size="60" value="<?php                                   $url = "http://" . serverVar('HTTP_HOST') . serverVar('PHP_SELF');\r
-                                       $url = str_replace("install.php",'',$url);\r
-                                       $url = str_replace("\\","/",$url);\r
-                                       // add slash at end if necessary\r
-                                       if (!endsWithSlash($url)) $url .= '/';\r
-                                       echo $url;\r
-                               ?>" />\r
-                       </td>\r
-               </tr><tr>\r
-                       <td>Admin-area <strong>URL</strong>:</td>\r
-                       <td><input name="AdminURL" size="60" value="<?php                                       if ($url) echo $url . 'nucleus/';\r
-                               ?>" />\r
-                       </td>\r
-               </tr><tr>\r
-                       <td>Admin-area <strong>path</strong>:</td>\r
-                       <td><input name="AdminPath" size="60" value="<?php                                      $path = str_replace("install.php",'',serverVar('SCRIPT_FILENAME'));\r
-                                       $path = str_replace("\\","/",$path);\r
-                                       // add slash at end if necessary\r
-                                       if (!endsWithSlash($path)) $path .= '/';\r
-                                       if($path) echo  $path . 'nucleus/';\r
-                               ?>" />\r
-                       </td>\r
-               </tr><tr>\r
-                       <td>Media files <strong>URL</strong>:</td>\r
-                       <td><input name="MediaURL" size="60" value="<?php                                       if ($url) echo $url . 'media/';\r
-                               ?>" />\r
-                       </td>\r
-               </tr><tr>\r
-                       <td>Media directory <strong>path</strong>:</td>\r
-                       <td><input name="MediaPath" size="60" value="<?php                                      $path = str_replace("install.php",'',serverVar('SCRIPT_FILENAME'));\r
-                                       $path = str_replace("\\","/",$path);\r
-                                       // add slash at end if necessary\r
-                                       if (!endsWithSlash($path)) $path .= '/';\r
-                                       if ($path) echo $path . 'media/';\r
-                               ?>" />\r
-                       </td>\r
-               </tr><tr>\r
-                       <td>Extra skin files <strong>URL</strong>:</td>\r
-                       <td><input name="SkinsURL" size="60" value="<?php                                       if ($url) echo $url . 'skins/';\r
-                               ?>" />\r
-                               <br />(¥¤¥ó¥Ý¡¼¥È¤µ¤ì¤¿¥¹¥­¥ó¤¬»ÈÍÑ)\r
-                       </td>\r
-               </tr><tr>\r
-                       <td>Extra skin files directory <strong>path</strong>:</td>\r
-                       <td><input name="SkinsPath" size="60" value="<?php                              $path = str_replace("install.php",'',serverVar('SCRIPT_FILENAME'));\r
-                               $path = str_replace("\\","/",$path);\r
-                               // add slash at end if necessary\r
-                               if (!endsWithSlash($path)) $path .= '/';\r
-                               if ($path) echo $path . 'skins/';\r
-                               ?>" />\r
-                               <br />(¥¤¥ó¥Ý¡¼¥È¤µ¤ì¤¿¥¹¥­¥ó¤Î¥Õ¥¡¥¤¥ëÎà¤òÃÖ¤¯¾ì½ê)\r
-                       </td>\r
-               </tr><tr>\r
-                       <td>Plugin files <strong>URL</strong>:</td>\r
-                       <td><input name="PluginURL" size="60" value="<?php                                      if ($url) echo $url . 'nucleus/plugins/';\r
-                               ?>" />\r
-                       </td>\r
-               </tr><tr>\r
-                       <td>Action <strong>URL</strong>:</td>\r
-                       <td><input name="ActionURL" size="60" value="<?php                                      if ($url) echo $url . 'action.php';\r
-                               ?>" />\r
-                               <br />(<tt>action.php</tt>¤Ø¤Îhttp://¤«¤é»Ï¤Þ¤ëURL)\r
-                       </td>\r
-               </tr></table>\r
-       </fieldset>\r
-\r
-       <p class="note">\r
-       <strong>ÉÕµ­:</strong> ÁêÂХѥ¹¤Ç¤Ï¤Ê¤¯<strong>ÀäÂХѥ¹¤ò»È¤Ã¤Æ¤¯¤À¤µ¤¤</strong>¡£Ä̾ÀäÂХѥ¹¤Ï<tt>/home/username/public_html/</tt>¤Î¤è¤¦¤Ê·Á¤ò¤È¤ê¤Þ¤¹¡£Unix¥·¥¹¥Æ¥à¡Ê¤Û¤È¤ó¤É¤Î¥µ¡¼¥Ð¡¼¤¬¤½¤¦¤Ç¤¹¡Ë¤Ë¤ª¤¤¤Æ¡¢¥Ñ¥¹¤Ï¥¹¥é¥Ã¥·¥å¤«¤é»Ï¤Þ¤ê¤Þ¤¹¡£¤â¤·¤³¤ì¤é¤Î¾ðÊóÆþÎϤËÌäÂ꤬À¸¤¸¤¿¤é¡¢¤¢¤Ê¤¿¤Î¥µ¡¼¥Ð´ÉÍý¼Ô¤Ë¤¿¤º¤Í¤ë¤Ù¤­¤Ç¤¹¡£\r
-       </p>\r
-\r
-       <h1>´ÉÍý¸¢¸Â¤ò¤â¤Ä¥æ¡¼¥¶¡¼</h1>\r
-\r
-       <p>°Ê²¼¤Ë¡¢¥µ¥¤¥È¤ÎºÇ½é¤Î¥æ¡¼¥¶¡¼¤òºîÀ®¤¹¤ë¤¿¤á¤Î¤¤¤¯¤Ä¤«¤Î¾ðÊó¤òÆþÎϤ·¤Æ¤¯¤À¤µ¤¤¡£</p>\r
-\r
-       <fieldset>\r
-               <legend>´ÉÍý¸¢¸Â¤ò»ý¤Ä¥æ¡¼¥¶¡¼</legend>\r
-               <table><tr>\r
-                       <td>ɽ¼¨¤µ¤ì¤ë̾Á°¡§</td>\r
-                       <td>\r
-                               <input name="User_name" value="" />\r
-                               <small>(µö²Ä¤µ¤ì¤ëʸ»ú¡§a-z ¤È 0-9¡¢ºÇ½é¤ÈºÇ¸å°Ê³°¤Î¥¹¥Ú¡¼¥¹)</small>\r
-                       </td>\r
-               </tr><tr>\r
-                       <td>ËÜ̾¡Ê¥Ï¥ó¥É¥ë̾¡Ë¡§</td>\r
-                       <td><input name="User_realname" value="" /></td>\r
-               </tr><tr>\r
-                       <td>¥Ñ¥¹¥ï¡¼¥É¡§</td>\r
-                       <td><input name="User_password" type="password" value="" /></td>\r
-               </tr><tr>\r
-                       <td>¥Ñ¥¹¥ï¡¼¥É¤Î³Îǧ¡§</td>\r
-                       <td><input name="User_password2" type="password" value="" /></td>\r
-               </tr><tr>\r
-                       <td>¥á¡¼¥ë¥¢¥É¥ì¥¹¡§</td>\r
-                       <td>\r
-                               <input name="User_email" value="" />\r
-                               <small>(ÍøÍѲÄǽ¤Ê¥á¡¼¥ë¥¢¥É¥ì¥¹¤òÆþ¤ì¤Æ¤¯¤À¤µ¤¤)</small>\r
-                       </td>\r
-               </tr></table>\r
-       </fieldset>\r
-\r
-       <h1>¥¦¥§¥Ö¥í¥°¤Î¥Ç¡¼¥¿</h1>\r
-\r
-       <p>°Ê²¼¤Ë¡¢¥Ç¥Õ¥©¥ë¥È¤Îweblog¤òºîÀ®¤¹¤ë¤¿¤á¤Ë¤¤¤¯¤Ä¤«¤Î¾ðÊó¤òÆþÎϤ·¤Æ¤¯¤À¤µ¤¤¡£¤³¤Îweblog¤Î̾Á°¤Ï¡¢¥µ¥¤¥È̾¤È¤·¤Æ¤âÍøÍѤµ¤ì¤Þ¤¹¡£</p>\r
-\r
-       <fieldset>\r
-               <legend>¥¦¥§¥Ö¥í¥°¤Î¥Ç¡¼¥¿</legend>\r
-               <table><tr>\r
-                       <td>Blog̾¡§</td>\r
-                       <td><input name="Blog_name" size="60" value="My Nucleus CMS" /></td>\r
-               </tr><tr>\r
-                       <td>Blog¤Îû½Ì̾¡§</td>\r
-                       <td>\r
-                               <input name="Blog_shortname" value="mynucleuscms" />\r
-                               <small>(µö²Ä¤µ¤ì¤ëʸ»ú¡§a-z ¤È 0-9¡¢¥¹¥Ú¡¼¥¹¤ÏÉÔ²Ä)</small>\r
-                       </td>\r
-               </tr></table>\r
-       </fieldset>\r
-\r
-       <h1>¥Ç¡¼¥¿¤ÎÁ÷¿®</h1>\r
-\r
-       <p>\r
-       ¾å¤Ë½ñ¤¤¤Æ¤­¤¿¥Ç¡¼¥¿¤¬Àµ¤·¤¤¤«³Î¤«¤á¤Æ¤¯¤À¤µ¤¤¡£¤è¤±¤ì¤Ð¥Ç¡¼¥¿¥Ù¡¼¥¹¡¦¥Æ¡¼¥Ö¥ë¤ÈºÇ½é¤Î¥Ç¡¼¥¿¤òÀßÄꤹ¤ë¤¿¤á¤Ë²¼¤Î¥Ü¥¿¥ó¤ò²¡¤·¤Æ¤¯¤À¤µ¤¤¡£¾¯¤·»þ´Ö¤¬¤«¤«¤ë¤«¤â¤·¤ì¤Þ¤»¤ó¤¬¤´¿ÉÊú¤ò¡£<b>¥Ü¥¿¥ó¤ò¥¯¥ê¥Ã¥¯¤¹¤ë¤Î¤Ï°ì²ó¤À¤±¤Ë¤·¤Æ¤¯¤À¤µ¤¤¡£</b>\r
-       </p>\r
-\r
-       <p>\r
-               <input name="action" value="go" type="hidden" />\r
-               <input type="submit" value="Nucleus CMS¤Î¥¤¥ó¥¹¥È¡¼¥ë" onclick="return checkSubmit();" />\r
-       </p>\r
-\r
-       </form>\r
-\r
-       </body>\r
-       </html>\r
-\r
-\r
-       <?php   }\r
-\r
-       function tableName($unPrefixed)\r
-       {\r
-               global $mysql_usePrefix, $mysql_prefix;\r
-               if ($mysql_usePrefix == 1)\r
-                       return $mysql_prefix . $unPrefixed;\r
-               else\r
-                       return $unPrefixed;\r
-       }\r
-\r
-       function doInstall() {\r
-               global $mysql_usePrefix, $mysql_prefix;\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
-               $config_adminemail      = $user_email;\r
-               $config_sitename        = $blog_name;\r
-\r
-\r
-               $config_indexurl        = str_replace("\\","/",$config_indexurl);\r
-               $config_adminurl        = str_replace("\\","/",$config_adminurl);\r
-               $config_mediaurl        = str_replace("\\","/",$config_mediaurl);\r
-               $config_skinsurl        = str_replace("\\","/",$config_skinsurl);\r
-               $config_pluginurl       = str_replace("\\","/",$config_pluginurl);\r
-               $config_actionurl       = str_replace("\\","/",$config_actionurl);\r
-               $config_adminpath       = str_replace("\\","/",$config_adminpath);\r
-               $config_skinspath       = str_replace("\\","/",$config_skinspath);\r
-\r
-               // 1. check all the data\r
-               $errors = array();\r
-\r
-               if (!$mysql_database)\r
-                       array_push($errors,"mySQL database name missing");\r
-               if (($mysql_usePrefix == 1) && (strlen($mysql_prefix) == 0))\r
-                       array_push($errors,"mySQL prefix was selected, but prefix is empty");\r
-               if (($mysql_usePrefix == 1) && (!eregi('^[a-zA-Z0-9_]+$', $mysql_prefix)))\r
-                       array_push($errors,"mySQL prefix should only contain characters from the ranges A-Z, a-z, 0-9 or underscores");\r
-               if (!endsWithSlash($config_indexurl) || !endsWithSlash($config_adminurl)\r
-                                                    || !endsWithSlash($config_mediaurl)\r
-                                                    || !endsWithSlash($config_pluginurl)\r
-                                                    || !endsWithSlash($config_skinsurl)\r
-                                                               // TODO: add action.php check\r
-                   )\r
-                       array_push($errors,"One of the URLs does not end with a slash, or action url does not end with 'action.php'");\r
-               if (!endsWithSlash($config_adminpath))\r
-                       array_push($errors,"The path of the administration area does not end with a slash");\r
-               if (!endsWithSlash($config_mediapath))\r
-                       array_push($errors,"The media path does not end with a slash");\r
-               if (!endsWithSlash($config_skinspath))\r
-                       array_push($errors,"The skins path does not end with a slash");\r
-               if (!is_dir($config_adminpath))\r
-                       array_push($errors,"The path of the administration area does not exist on your server");\r
-               if (!_isValidMailAddress($user_email))\r
-                       array_push($errors,"Invalid e-mail address given for user");\r
-               if (!_isValidDisplayName($user_name))\r
-                       array_push($errors,"User name is not a valid display name (allowed chars: a-zA-Z0-9 and spaces)");\r
-               if (!$user_password || !$user_password2)\r
-                       array_push($errors, "User password is empty");\r
-               if ($user_password != $user_password2)\r
-                       array_push($errors, "User password do not match");\r
-               if (!_isValidShortName($blog_shortname))\r
-                       array_push($errors, "Invalid short name given for blog (allowed chars: a-z0-9, no spaces)");\r
-               if (sizeof($errors) > 0)\r
-                       showErrorMessages($errors);\r
-\r
-               // 2. try to log in to mySQL\r
-               $connection = @mysql_connect($mysql_host, $mysql_user, $mysql_password);\r
-               if ($connection == false)\r
-                       _doError("Could not connect to mySQL server: " . mysql_error());\r
-\r
-               // 3. try to create database (if needed)\r
-               if ($mysql_create == 1) {\r
-                       mysql_query("CREATE DATABASE " . $mysql_database) or _doError("Could not create database. Make sure you have the rights to do so. SQL error was: " . mysql_error());\r
-               }\r
-\r
-               // 4. try to select database\r
-               mysql_select_db($mysql_database) or _doError("Could not select database. Make sure it exists");\r
-\r
-               // 5. execute queries\r
-               $filename = "install.sql";\r
-               $fd = fopen ($filename, "r");\r
-               $queries = fread ($fd, filesize ($filename));\r
-               fclose ($fd);\r
-\r
-               $queries = split("(;\n|;\r)",$queries);\r
-\r
-               $aTableNames = array(\r
-                       'nucleus_actionlog',\r
-                       'nucleus_ban',\r
-                       'nucleus_blog',\r
-                       'nucleus_category',\r
-                       'nucleus_comment',\r
-                       'nucleus_config',\r
-                       'nucleus_item',\r
-                       'nucleus_karma',\r
-                       'nucleus_member',\r
-                       'nucleus_plugin',\r
-                       'nucleus_skin',\r
-                       'nucleus_template',\r
-                       'nucleus_team',\r
-                       'nucleus_activation',\r
-                       'nucleus_tickets'\r
-// these are unneeded (one of the replacements above takes care of them)\r
-//                     'nucleus_plugin_event',\r
-//                     'nucleus_plugin_option',\r
-//                     'nucleus_plugin_option_desc',\r
-//                     'nucleus_skin_desc',\r
-//                     'nucleus_template_desc',\r
-               );\r
-               $aTableNamesPrefixed = array(\r
-                       $mysql_prefix . 'nucleus_actionlog',\r
-                       $mysql_prefix . 'nucleus_ban',\r
-                       $mysql_prefix . 'nucleus_blog',\r
-                       $mysql_prefix . 'nucleus_category',\r
-                       $mysql_prefix . 'nucleus_comment',\r
-                       $mysql_prefix . 'nucleus_config',\r
-                       $mysql_prefix . 'nucleus_item',\r
-                       $mysql_prefix . 'nucleus_karma',\r
-                       $mysql_prefix . 'nucleus_member',\r
-                       $mysql_prefix . 'nucleus_plugin',\r
-                       $mysql_prefix . 'nucleus_skin',\r
-                       $mysql_prefix . 'nucleus_template',\r
-                       $mysql_prefix . 'nucleus_team',\r
-                       $mysql_prefix . 'nucleus_activation',\r
-                       $mysql_prefix . 'nucleus_tickets'\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
-//                     $mysql_prefix . 'nucleus_plugin_option_desc',\r
-//                     $mysql_prefix . 'nucleus_skin_desc',\r
-//                     $mysql_prefix . 'nucleus_template_desc',\r
-               );\r
-\r
-               for ($idx = 0;$idx<sizeof($queries);$idx++) {\r
-                       $query = trim($queries[$idx]);\r
-                       // echo "QUERY = <small>" . htmlspecialchars($query) . "</small><p>";\r
-                       if ($query) {\r
-                               if ($mysql_usePrefix == 1)\r
-                                       $query = str_replace($aTableNames, $aTableNamesPrefixed, $query);\r
-                               mysql_query($query) or _doError("Error while executing query (<small>" . htmlspecialchars($query) . "</small>): " . mysql_error());\r
-                       }\r
-\r
-               }\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('AdminEmail',      $config_adminemail);\r
-               updateConfig('SiteName',        $config_sitename);\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,"\r
-                      . "     mcanlogin=1"\r
-                      . " WHERE mnumber=1";\r
-               mysql_query($query) or _doError("Error while setting member settings: " . 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
-               mysql_query($query) or _doError("Error while setting weblog settings: " . 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
-               mysql_query($query) or _doError("Error with query: " . mysql_error());\r
-\r
-               global $aConfPlugsToInstall, $aConfSkinsToImport;\r
-               $aSkinErrors = array();\r
-               $aPlugErrors = array();\r
-               if ((count($aConfPlugsToInstall) > 0) || (count($aConfSkinsToImport) > 0)) {\r
-                       // 10. set global variables\r
-                       global $MYSQL_HOST, $MYSQL_USER, $MYSQL_PASSWORD, $MYSQL_DATABASE, $MYSQL_PREFIX;\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
-                       global $DIR_NUCLEUS, $DIR_MEDIA, $DIR_SKINS, $DIR_PLUGINS, $DIR_LANG, $DIR_LIBS;\r
-                       $DIR_NUCLEUS = $config_adminpath;\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
-\r
-                       // close database connection (needs to be closed if we want to include globalfunctions.php)\r
-                       mysql_close();\r
-\r
-                       $manager = '';\r
-                       include_once($DIR_LIBS . 'globalfunctions.php');\r
-\r
-                       // 11. install custom skins\r
-                       $aSkinErrors = installCustomSkins($manager);\r
-\r
-                       // 12. install custom plugins\r
-                       $aPlugErrors = installCustomPlugs($manager);\r
-\r
-               }\r
-\r
-\r
-               // 12. Write config file ourselves (if possible)\r
-               $bConfigWritten = 0;\r
-               if (@file_exists('config.php') && is_writable('config.php') && $fp = @fopen('config.php', 'w')) {\r
-                       $config_data = "<" . "?php \n";\r
-                       $config_data .= "\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_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 .= "\n";\r
-                       $config_data .= "       // extra skin files for imported skins\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 .= "\n";\r
-                       $config_data .= "       // include libs\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 .= "       }\n";\r
-                       $config_data .= "?" . ">";\r
-\r
-                       $result = @fputs($fp, $config_data, strlen($config_data));\r
-                       fclose($fp);\r
-\r
-                       if ($result)\r
-                               $bConfigWritten = 1;\r
-               }\r
-\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=EUC-JP" />\r
-                       <title>Nucleus¤Î¥¤¥ó¥¹¥È¡¼¥ë</title>\r
-                       <style>\r
-                               @import url('nucleus/styles/manual.css');\r
-                       </style>\r
-               </head>\r
-               <body>\r
-               <div style='text-align:center'><img src='./nucleus/styles/logo.gif' /></div> <!-- Nucleus logo -->\r
-<?php\r
-       $aAllErrors = array_merge($aSkinErrors, $aPlugErrors);\r
-       if (count($aAllErrors) > 0) {\r
-               echo '<h1>Skin/Plugin Install errors</h1>';\r
-               echo '<ul><li>'.implode('</li><li>', $aAllErrors).'</li></ul>';\r
-       }\r
-\r
-       if (!$bConfigWritten) { ?>\r
-                       <h1>¥¤¥ó¥¹¥È¡¼¥ë¤Ï¤Û¤Ü´°Î»¤·¤Þ¤·¤¿¡ª</h1>\r
-                       <p>\r
-                       ¥Ç¡¼¥¿¥Ù¡¼¥¹¥Æ¡¼¥Ö¥ë¤Î½é´üÃÍÆþÎϤ¬À®¸ù¤·¤Þ¤·¤¿¡£¸å¤Ï<i>config.php</i>¤ò½ñ¤­´¹¤¨¤ë¤À¤±¤Ç¤¹¡£°Ê²¼¤Ë½ñ¤­´¹¤¨¤ë¤Ù¤­ÆâÍƤòɽ¼¨¤·¤Þ¤¹¡Êmysql¤Î¥Ñ¥¹¥ï¡¼¥É¤Ï¥Þ¥¹¥¯¤µ¤ì¤Æ¤¤¤Þ¤¹¡£¤³¤³¤Ï¼ÂºÝ¤Î¤â¤Î¤Ë½ñ¤­´¹¤¨¤Æ¤¯¤À¤µ¤¤¡Ë\r
-                       </p>\r
-\r
-                       <pre>\r
-&lt;?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_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
-\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
-\r
-       // extra skin files for imported skins\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
-\r
-       // include libs\r
-       include($DIR_LIBS.'globalfunctions.php');\r
-       if (!extension_loaded('mbstring')) {\r
-               include($DIR_LIBS.'mb_emulator/mb-emulator.php');\r
-       }\r
-?&gt;\r
-                       </pre>\r
-\r
-                       <p>¤¢¤Ê¤¿¤Î¥³¥ó¥Ô¥å¡¼¥¿¾å¤Î¥Õ¥¡¥¤¥ë¤ò½ñ¤­´¹¤¨¤¿¤é¡¢FTP¤ò»È¤Ã¤Æ¥¦¥§¥Ö¥µ¡¼¥Ð¤Ë¥¢¥Ã¥×¥í¡¼¥É¤·¤Æ¤¯¤À¤µ¤¤¡£ASCII¥â¡¼¥É¤ÇÁ÷¿®¤·¤Æ¥Õ¥¡¥¤¥ë¤ò¾å½ñ¤­¤·¤Þ¤¹¡£\r
-                       </p>\r
-\r
-                       <div class="note">\r
-                       <b>ÉÕµ­:</b> <i>config.php</i>¤ÎºÇ½é¤ä½ª¤ï¤ê¤Ë¥¹¥Ú¡¼¥¹¤ò¶õ¤±¤Ê¤¤¤è¤¦¤Ë¤·¤Þ¤·¤ç¤¦¡£¼Â¹Ô»þ¤Ë¥¨¥é¡¼¤ò°ú¤­µ¯¤³¤¹¸¶°ø¤È¤Ê¤ê¤Þ¤¹¡£\r
-                       <br />\r
-                       ¤·¤¿¤¬¤Ã¤Æ¡¢config.php¤ÎºÇ½é¤Îʸ»ú¤Ï "&lt;"¤ÇºÇ¸å¤Îʸ»ú¤Ï"&gt;"¤È¤·¤Ê¤±¤ì¤Ð¤Ê¤ê¤Þ¤»¤ó¡£\r
-                       </div>\r
-\r
-<?php } else { ?>\r
-                       <h1>¥¤¥ó¥¹¥È¡¼¥ë¤Ï´°Î»¤·¤Þ¤·¤¿¡ª</h1>\r
-\r
-                       <p>Nucleus¤Ï¥¤¥ó¥¹¥È¡¼¥ë¤µ¤ì¡¢<code>config.php</code>¤Ï¥¢¥Ã¥×¥Ç¡¼¥È¤µ¤ì¤Þ¤·¤¿¡£</p>\r
-\r
-                       <p>¥»¥­¥å¥ê¥Æ¥£¤Î¤¿¤á<code>config.php</code>¤Î¥Ñ¡¼¥ß¥Ã¥·¥ç¥ó¤ò444¤ËÌ᤹¤³¤È¤ò˺¤ì¤Ê¤¤¤Ç¤¯¤À¤µ¤¤(<a href="nucleus/documentation/tips.html#filepermissions">¥Ñ¡¼¥ß¥Ã¥·¥ç¥óÊѹ¹¤Î´Ê°×¥¬¥¤¥É</a>)¡£</p>\r
-<?php } ?>\r
-                       <h1>¥¤¥ó¥¹¥È¡¼¥ë¥Õ¥¡¥¤¥ë¤Îºï½ü</h1>\r
-\r
-                       <p>¥¦¥§¥Ö¥µ¡¼¥Ð¤«¤é¼¡¤Î¥Õ¥¡¥¤¥ë¤òºï½ü¤·¤Æ¤¯¤À¤µ¤¤¡§</p>\r
-\r
-                       <ul>\r
-                               <li><b>install.sql</b>¡§¥Æ¡¼¥Ö¥ë¤Î¹½Â¤¤òÆâÊñ¤¹¤ë¥Õ¥¡¥¤¥ë</li>\r
-                               <li><b>install.php</b>¡§¤³¤Î¥Õ¥¡¥¤¥ë</li>\r
-                       </ul>\r
-\r
-                       <p>¤â¤·¤³¤ì¤é¤Î¥Õ¥¡¥¤¥ë¤òºï½ü¤·¤Æ¤¤¤Ê¤±¤ì¤Ð¡¢´ÉÍýÎΰè¤ò³«¤¯¤³¤È¤¬½ÐÍè¤Þ¤»¤ó¡£</p>\r
-\r
-                       <h1>¥¦¥§¥Ö¥µ¥¤¥È¤Î³Îǧ</h1>\r
-                       <p>\r
-                       ¥¦¥§¥Ö¥µ¥¤¥È¤ò»È¤¦½àÈ÷¤¬À°¤¤¤Þ¤·¤¿¡£\r
-                       <ul>\r
-                               <li><a href="<?php echo $config_adminurl?>">´ÉÍýÎΰè¤Ë¥í¥°¥¤¥ó¤·¤Æ¥µ¥¤¥È¤ÎÀßÄê¤ò¹Ô¤¦</a></li>\r
-                               <li><a href="<?php echo $config_indexurl?>">¤¹¤°¤Ë¥µ¥¤¥È¤Ø¹Ô¤Ã¤Æ¤ß¤ë</a></li>\r
-                       </ul>\r
-                       </p>\r
-\r
-               </body>\r
-               </html>\r
-               <?php\r
-       }\r
-\r
-\r
-       function installCustomPlugs(&$manager) {\r
-               global $aConfPlugsToInstall, $DIR_LIBS;\r
-\r
-               $aErrors = array();\r
-\r
-               if (count($aConfPlugsToInstall) == 0)\r
-                       return $aErrors;\r
-\r
-               $numCurrent = mysql_num_rows(sql_query('SELECT * FROM '.sql_table('plugin')));\r
-\r
-               foreach ($aConfPlugsToInstall as $plugName) {\r
-                       // do this before calling getPlugin (in case the plugin id is used there)\r
-                       $query = 'INSERT INTO '.sql_table('plugin').' (porder, pfile) VALUES ('.(++$numCurrent).',"'.addslashes($plugName).'")';\r
-                       sql_query($query);\r
-\r
-                       // get and install the plugin\r
-                       $plugin =& $manager->getPlugin($plugName);\r
-                       if (!$plugin) {\r
-                               sql_query('DELETE FROM ' . sql_table('plugin') . ' WHERE pfile=\''. addslashes($plugName).'\'');\r
-                               $numCurrent--;\r
-                               array_push($aErrors, 'Unable to install plugin ' . $plugName);\r
-                               continue;\r
-                       }\r
-                       $plugin->install();\r
-               }\r
-\r
-               // SYNC PLUGIN EVENT LIST\r
-               sql_query('DELETE FROM '.sql_table('plugin_event'));\r
-               // loop over all installed plugins\r
-               $res = sql_query('SELECT pid, pfile FROM '.sql_table('plugin'));\r
-               while($o = mysql_fetch_object($res)) {\r
-                       $pid = $o->pid;\r
-                       $plug =& $manager->getPlugin($o->pfile);\r
-                       if ($plug)\r
-                       {\r
-                               $eventList = $plug->getEventList();\r
-                               foreach ($eventList as $eventName) \r
-                                       sql_query('INSERT INTO '.sql_table('plugin_event').' (pid, event) VALUES ('.$pid.', \''.$eventName.'\')');\r
-                       }\r
-               }\r
-\r
-               return $aErrors;\r
-       }\r
-\r
-       function installCustomSkins(&$manager) {\r
-               global $aConfSkinsToImport, $DIR_LIBS, $DIR_SKINS;\r
-\r
-               $aErrors = array();\r
-\r
-               if (count($aConfSkinsToImport) == 0)\r
-                       return $aErrors;\r
-\r
-               // load skinie class\r
-               include_once($DIR_LIBS . 'skinie.php');\r
-\r
-               $importer = new SKINIMPORT();\r
-\r
-               foreach ($aConfSkinsToImport as $skinName) {\r
-                       $importer->reset();\r
-\r
-                       $skinFile = $DIR_SKINS . $skinName . '/skinbackup.xml';\r
-                       if (!@file_exists($skinFile)) {\r
-                               array_push($aErrors, 'Unable to import ' . $skinFile . ' : file does not exist');\r
-                               continue;\r
-                       }\r
-                       $error = $importer->readFile($skinFile);\r
-                       if ($error) {\r
-                               array_push($aErrors, 'Unable to import ' . $skinName . ' : ' . $error);\r
-                               continue;\r
-                       }\r
-                       $error = $importer->writeToDatabase(1);\r
-                       if ($error) {\r
-                               array_push($aErrors, 'Unable to import ' . $skinName . ' : ' . $error);\r
-                               continue;\r
-                       }\r
-               }\r
-\r
-               return $aErrors;\r
-       }\r
-\r
-       // give an error if one or more nucleus are not accessible\r
-       function doCheckFiles() {\r
-               $missingfiles = array();\r
-\r
-               if (!is_readable('install.sql'))\r
-                       array_push($missingfiles, "File <b>install.sql</b> is missing or not readable");\r
-               if (!is_readable('index.php'))\r
-                       array_push($missingfiles, "File <b>index.php</b> is missing or not readable");\r
-               if (!is_readable('action.php'))\r
-                       array_push($missingfiles, "File <b>action.php</b> is missing or not readable");\r
-               if (!is_readable('nucleus/index.php'))\r
-                       array_push($missingfiles, "File <b>nucleus/index.php</b> is missing or not readable");\r
-               if (!is_readable('nucleus/libs/globalfunctions.php'))\r
-                       array_push($missingfiles, "File <b>nucleus/libs/globalfunctions.php</b> is missing or not readable");\r
-               if (!is_readable('nucleus/libs/ADMIN.php'))\r
-                       array_push($missingfiles, "File <b>nucleus/libs/ADMIN.php</b> is missing or not readable");\r
-               if (!is_readable('nucleus/libs/BLOG.php'))\r
-                       array_push($missingfiles, "File <b>nucleus/libs/BLOG.php</b> is missing or not readable");\r
-               if (!is_readable('nucleus/libs/COMMENT.php'))\r
-                       array_push($missingfiles, "File <b>nucleus/libs/COMMENT.php</b> is missing or not readable");\r
-               if (!is_readable('nucleus/libs/COMMENTS.php'))\r
-                       array_push($missingfiles, "File <b>nucleus/libs/COMMENTS.php</b> is missing or not readable");\r
-               if (!is_readable('nucleus/libs/ITEM.php'))\r
-                       array_push($missingfiles, "File <b>nucleus/libs/ITEM.php</b> is missing or not readable");\r
-               if (!is_readable('nucleus/libs/MEMBER.php'))\r
-                       array_push($missingfiles, "File <b>nucleus/libs/MEMBER.php</b> is missing or not readable");\r
-               if (!is_readable('nucleus/libs/SKIN.php'))\r
-                       array_push($missingfiles, "File <b>nucleus/libs/SKIN.php</b> is missing or not readable");\r
-               if (!is_readable('nucleus/libs/TEMPLATE.php'))\r
-                       array_push($missingfiles, "File <b>nucleus/libs/TEMPLATE.php</b> is missing or not readable");\r
-               if (!is_readable('nucleus/libs/MEDIA.php'))\r
-                       array_push($missingfiles, "File <b>nucleus/libs/MEDIA.php</b> is missing or not readable");\r
-               if (!is_readable('nucleus/libs/ACTIONLOG.php'))\r
-                       array_push($missingfiles, "File <b>nucleus/libs/ACTIONLOG.php</b> is missing or not readable");\r
-               if (!is_readable('nucleus/media.php'))\r
-                       array_push($missingfiles, "File <b>nucleus/media.php</b> is missing or not readable");\r
-\r
-\r
-               if (sizeof($missingfiles) > 0)\r
-                       showErrorMessages($missingfiles);\r
-\r
-\r
-       }\r
-\r
-       function updateConfig($name, $val) {\r
-               $name = addslashes($name);\r
-               $val = trim(addslashes($val));\r
-\r
-               $query = 'UPDATE ' . tableName('nucleus_config')\r
-                      . " SET value='$val'"\r
-                      . " WHERE name='$name'";\r
-\r
-               mysql_query($query) or _doError("Query error while trying to update config: " . mysql_error());\r
-               return mysql_insert_id();\r
-       }\r
-\r
-       function endsWithSlash($s) {\r
-               return (strrpos($s,'/') == strlen($s) - 1);\r
-       }\r
-\r
-       /**\r
-         * Checks if email address is valid\r
-         */\r
-       function _isValidMailAddress($address) {\r
-               if (preg_match("/^[a-zA-Z0-9\._-]+@+[A-Za-z0-9\._-]+\.+[A-Za-z]{2,4}$/", $address))\r
-                       return 1;\r
-               else\r
-                       return 0;\r
-       }\r
-\r
-       // returns true if the given string is a valid shortname\r
-       // (to check short blog names and nicknames)\r
-       // logic: starts and ends with a non space, can contain spaces in between\r
-       //        min 2 chars\r
-       function _isValidShortName($name) {\r
-               if (eregi("^[a-z0-9]+$", $name))\r
-                       return 1;\r
-               else\r
-                       return 0;\r
-       }\r
-\r
-\r
-\r
-       // returns true if the given string is a valid display name\r
-       // (to check nicknames)\r
-       function _isValidDisplayName($name) {\r
-               if (eregi("^[a-z0-9]+[a-z0-9 ]*[a-z0-9]+$", $name))\r
-                       return 1;\r
-               else\r
-                       return 0;\r
-       }\r
-\r
-       function _doError($msg) {\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=EUC-JP" />\r
-                       <title>Nucleus Install</title>\r
-                       <style>\r
-                               @import url('nucleus/styles/manual.css');\r
-                       </style>\r
-               </head>\r
-               <body>\r
-                 <div style='text-align:center'><img src='./nucleus/styles/logo.gif' /></div> <!-- Nucleus logo -->\r
-                       <h1>Error!</h1>\r
-                       <p>\r
-                       Error message was: "<?php echo $msg?>";\r
-                       </p>\r
-\r
-                       <p>\r
-                       <a href="install.php" onclick="history.back();return false;">Go Back</a>\r
-                       </p>\r
-               </body>\r
-               </html>\r
-               <?php           exit;\r
-       }\r
-\r
-       function showErrorMessages($errors) {\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=EUC-JP" />\r
-                       <title>Nucleus Install</title>\r
-                       <style>\r
-                               @import url('nucleus/styles/manual.css');\r
-                       </style>\r
-               </head>\r
-               <body>\r
-                 <div style='text-align:center'><img src='./nucleus/styles/logo.gif' /></div> <!-- Nucleus logo -->\r
-                       <h1>Errors!</h1>\r
-                       <p>\r
-                       Errors were found:\r
-                       </p>\r
-\r
-                       <ul>\r
-                       <?php   while($msg = array_shift($errors))\r
-                                       echo "<li>$msg</li>";\r
-                       ?>\r
-                       </ul>\r
-\r
-                       <p>\r
-                       <a href="install.php" onclick="history.back();return false;">Go Back</a>\r
-                       </p>\r
-               </body>\r
-               </html>\r
-               <?php           exit;\r
-       }\r
-\r
-\r
-       /* for the non-php systems that decide to show the contents:\r
-          ?></div><?php        */\r
-\r
-?>\r
+<?php
+/*
+ * Nucleus: PHP/MySQL Weblog CMS (http://nucleuscms.org/)
+ * Copyright (C) 2002-2007 The Nucleus Group
+ *
+ * This program is free software; you can redistribute it and/or
+ * modify it under the terms of the GNU General Public License
+ * as published by the Free Software Foundation; either version 2
+ * of the License, or (at your option) any later version.
+ * (see nucleus/documentation/index.html#license for more info)
+ * This script will install the Nucleus tables in your SQL-database, and initialize the data in
+ * those tables.
+ *
+ * Below is a friendly way of letting users on non-php systems know that Nucleus won't run there.
+ * ?><div style="font-size: xx-large;">If you see this text in your browser when you open <i>install.php</i>, your web server is not able to run PHP-scripts, and therefor Nucleus will not be able to run there. </div><div style="display: none"><?php
+ */
+
+/**
+ * @license http://nucleuscms.org/license.txt GNU General Public License
+ * @copyright Copyright (C) 2002-2007 The Nucleus Group
+ * @version $Id: install.php,v 1.5 2007-04-04 07:52:04 kimitake Exp $
+ * $NucleusJP: install.php,v 1.7 2007/02/04 06:28:44 kimitake Exp $
+ */
+
+/*
+       This part of the install.php code allows for customization of the install process.
+       When distributing plugins or skins together with a Nucleus installation, the
+       configuration below will instruct to install them
+
+       -- Start Of Configurable Part --
+*/
+
+// array with names of plugins to install. Plugin files must be present in the nucleus/plugin/
+// directory.
+//
+// example:
+//     array('NP_TrackBack', 'NP_MemberGoodies')
+$aConfPlugsToInstall = array('NP_SkinFiles');
+
+
+// array with skins to install. skins must be present under the skins/ directory with
+// a subdirectory having the same name that contains a skinbackup.xml file
+//
+// example:
+//     array('base','rsd')
+$aConfSkinsToImport = array('default');
+
+/*
+       -- End Of Configurable Part --
+*/
+
+// don't give warnings for uninitialized vars
+error_reporting(E_ERROR | E_WARNING | E_PARSE);
+
+// make sure there's no unnecessary escaping:
+set_magic_quotes_runtime(0);
+
+// if there are some plugins or skins to import, do not include vars
+// in globalfunctions.php again... so set a flag
+if ((count($aConfPlugsToInstall) > 0) || (count($aConfSkinsToImport) > 0) ) {
+       global $CONF;
+       $CONF['installscript'] = 1;
+}
+
+if (phpversion() >= '4.1.0') {
+       include_once('nucleus/libs/vars4.1.0.php');
+} else {
+       include_once('nucleus/libs/vars4.0.6.php');
+}
+
+include_once('nucleus/libs/mysql.php');
+
+// check if mysql support is installed
+       if (!function_exists('mysql_query') ) {
+               _doError('Your PHP version does not have support for MySQL :(');
+       }
+
+       if (postVar('action') == 'go') {
+               doInstall();
+       } else {
+               showInstallForm();
+       }
+
+       exit;
+
+function showInstallForm() {
+       // 0. pre check if all necessary files exist
+       doCheckFiles();
+
+       ?>
+       <!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">
+       <head>
+               <meta http-equiv="content-type" content="application/xhtml+xml; charset=EUC-JP" />
+               <title>Nucleus¤Î¥¤¥ó¥¹¥È¡¼¥ë</title>
+               <style type="text/css"><!--
+                       @import url('nucleus/documentation/styles/manual.css');
+               --></style>
+               <script type="text/javascript"><!--
+                       var submitcount = 0;
+
+                       // function to make sure the submit button only gets pressed once
+                       function checkSubmit() {
+                               if (submitcount == 0) {
+                                       submitcount++;
+                                       return true;
+                               } else {
+                                       return false;
+                               }
+                       }
+               --></script>
+       </head>
+       <body>
+               <div style="text-align:center"><img src="./nucleus/styles/logo.gif" /></div> <!-- Nucleus logo -->
+               <form method="post" action="install.php">
+
+               <h1>Install Nucleus</h1>
+
+               <p>¤³¤Î¥¹¥¯¥ê¥×¥È¤ÏNucleus¤Î¥¤¥ó¥¹¥È¡¼¥ë¤ò¼ê½õ¤±¤·¤Þ¤¹¡£MySQL¥Æ¡¼¥Ö¥ë¤Î¥»¥Ã¥È¥¢¥Ã¥×¤È¡¢<i>config.php</i>¤ËÆþÎϤ¹¤ë¤¿¤á¤Î¾ðÊó¤òɽ¼¨¤·¤Þ¤¹¡Êconfig.php¤Î¥Ñ¡¼¥ß¥Ã¥·¥ç¥ó¤ò0666¤Ë¤·¤Æ¤ª¤±¤Ð¡¢¸å¼Ô¤Îºî¶È¤Ï¼«Æ°Åª¤Ë¹Ô¤ï¤ì¤Þ¤¹¡Ë¡£¤³¤ì¤ò¤Ê¤¹°Ù¤Ë¡¢¤¤¤¯¤Ä¤«¤Î¾ðÊó¤òÆþÎϤ¹¤ëɬÍפ¬¤¢¤ê¤Þ¤¹¡£</p>
+
+               <p>¤¹¤Ù¤Æ¤ÎÍó¤ÎÆþÎϤ¬É¬ÍפǤ¹¡£¥ª¥×¥·¥ç¥ó¾ðÊó¤Ï¥¤¥ó¥¹¥È¡¼¥ë¤¬´°Î»¤·¤¿¤é¡¢Nucleus¤Î´ÉÍýÎΰ褫¤éÀßÄê²Äǽ¤Ç¤¹¡£</p>
+
+               <h1>PHP &amp; MySQL Versions</h1>
+
+               <p>°Ê²¼¤Ï¤¢¤Ê¤¿¤Î¥¦¥§¥Ö¥Û¥¹¥È¤Ë¤ª¤±¤ëPHP¥¤¥ó¥¿¡¼¥×¥ê¥¿¡¼¤ÈMySQL¥µ¡¼¥Ð¡¼¤Î¥Ð¡¼¥¸¥ç¥ó¤Ç¤¹¡£Nucleus¤Î¥µ¥Ý¡¼¥È¥Õ¥©¡¼¥é¥à¤ËÌäÂê¤òÊó¹ð¤¹¤ë¤È¤­¤Ï¡¢¤³¤Î¾ðÊó¤ò½ñ¤­Åº¤¨¤Æ¤¯¤À¤µ¤¤¡£</p>
+
+               <ul>
+                       <li>PHP:
+
+<?php
+       echo phpversion();
+       $minVersion = '4.0.6';
+
+       if (phpversion() < $minVersion) {
+               echo ' <span class="warning">Ãí°Õ: Nucleus¤ÎÆ°ºî¤Ë¤Ï¾¯¤Ê¤¯¤È¤â¥Ð¡¼¥¸¥ç¥ó ',$minVersion,' ¤¬É¬ÍפȤµ¤ì¤Þ¤¹</span>';
+       }
+?>
+
+                       </li>
+                       <li>MySQL:
+
+<?php
+       // note: this piece of code is taken from phpMyAdmin
+       $result = @mysql_query('SELECT VERSION() AS version');
+
+       if ($result != FALSE && @mysql_num_rows($result) > 0) {
+               $row = mysql_fetch_array($result);
+               $match = explode('.', $row['version']);
+       } else {
+               $result = @mysql_query('SHOW VARIABLES LIKE \'version\'');
+
+               if ($result != FALSE && @mysql_num_rows($result) > 0) {
+                       $row = mysql_fetch_row($result);
+                       $match = explode('.', $row[1]);
+               } else {
+                       $match[0] = '?';
+                       $match[1] = '?';
+                       $match[2] = '?';
+               }
+       }
+
+       if (!isset($match) || !isset($match[0]) ) {
+               $match[0] = 3;
+       }
+
+       if (!isset($match[1]) ) {
+               $match[1] = 21;
+       }
+
+       if (!isset($match[2]) ) {
+               $match[2] = 0;
+       }
+
+       if ($match[0] != '?') {
+               $match[0] = intval($match[0]);
+               $match[1] = intval($match[1]);
+       }
+
+       $mysqlVersion = implode($match, '.');
+       $minVersion = '3.23';
+
+       echo $mysqlVersion;
+
+       if ($mysqlVersion < $minVersion) {
+               echo ' <span class="warning">Ãí°Õ: Nucleus¤ÎÆ°ºî¤Ë¤Ï¾¯¤Ê¤¯¤È¤â¥Ð¡¼¥¸¥ç¥ó ',$minVersion,' ¤¬É¬ÍפȤµ¤ì¤Þ¤¹</span>';
+       }
+?>
+
+                       </li>
+               </ul>
+
+<?php
+       // tell people how they can have their config file filled out automatically
+       if (@file_exists('config.php') && @!is_writable('config.php') ) {
+?>
+
+               <h1><i>config.php</i>¤Î¼«Æ°¥¢¥Ã¥×¥Ç¡¼¥È</h1>
+
+               <p>¤â¤·<em>config.php</em>¤ò¼«Æ°Åª¤Ë¹¹¿·¤¹¤ë¤è¤¦¤Ë¤·¤¿¤¤¤Ê¤é¡¢½ñ¤­¹þ¤ß²Äǽ¤Ë¤¹¤ëɬÍפ¬¤¢¤ê¤Þ¤¹¡£<em>config.php</em>¤Î¥Ñ¡¼¥ß¥Ã¥·¥ç¥ó¤ò<strong>666</strong>¤Ë¤·¤Æ¤¯¤À¤µ¤¤¡£Nucleus¤Î¥¤¥ó¥¹¥È¡¼¥ëÀ®¸ù¸å¤Ë¡¢¥Ñ¡¼¥ß¥Ã¥·¥ç¥ó¤ò<strong>444</strong>¤ËÌᤵ¤Ê¤±¤ì¤Ð¤Ê¤ê¤Þ¤»¤ó¡Ê<a href="nucleus/documentation/tips.html#filepermissions">¥Ñ¡¼¥ß¥Ã¥·¥ç¥óÊѹ¹¤Î´Ê°×¥¬¥¤¥É</a>¡Ë¡£</p>
+
+               <p>¤â¤·¥Õ¥¡¥¤¥ë¤Ë½ñ¤­¹þ¤Þ¤Ê¤¤¤È¤¤¤¦ÁªÂò¤ò¤·¤¿¡Ê¤¢¤ë¤¤¤Ï¹Ô¤¨¤Ê¤¤¡Ë¾ì¹ç¡§¤´¿´Çۤʤ¯¡£¥¤¥ó¥¹¥È¡¼¥ë¤Î²áÄø¤Ç<em>config.php</em>¤ÎÃæ¿È¤¬Ä󶡤µ¤ì¤Þ¤¹¡£¤Ç¤¹¤«¤é¡¢¤½¤ì¤ò¤´¼«¿È¤Ç¥¢¥Ã¥×¥í¡¼¥É¤·¤Æ¤¯¤À¤µ¤¤¡£</p>
+
+<?php } ?>
+
+               <h1>MySQL¤Î¥í¥°¥¤¥ó¥Ç¡¼¥¿</h1>
+
+               <p>MySQL¤Î¥Ç¡¼¥¿¤ò°Ê²¼¤ËÆþÎϤ·¤Æ¤¯¤À¤µ¤¤¡£¤½¤ì¤é¤Ï¥Ç¡¼¥¿¥Ù¡¼¥¹¡¦¥Æ¡¼¥Ö¥ë¤òºîÀ®¤·¾ðÊó¤òÆþÎϤ¹¤ë¤¿¤á¤ËɬÍפʤâ¤Î¤Ç¤¹¡£¸å¤Ç¡¢<i>config.php</i>¤Ë¤âµ­Æþ¤¹¤ëɬÍפ¬¤¢¤ê¤Þ¤¹¡Ê¾åµ­¤Î¼«Æ°¥¢¥Ã¥×¥Ç¡¼¥È¤òÍøÍѤ¹¤ë¾ì¹ç¡¢¤½¤Î¼ê½ç¤Ï¾Êά¤µ¤ì¤Þ¤¹¡Ë¡£</p>
+
+               <p>¤â¤·¤³¤Î¾ðÊ󤬤狼¤é¤Ê¤±¤ì¤Ð¡¢¥·¥¹¥Æ¥à´ÉÍý¼Ô¤«¥Û¥¹¥Æ¥£¥ó¥°¸µ¤ËÏ¢Íí¤ò¤È¤Ã¤Æ¤¯¤À¤µ¤¤¡£¤Û¤È¤ó¤É¤Î¾ì¹ç¡¢¥Û¥¹¥È̾¤Ï'localhost'¤Ç¤¹¡£¤â¤·Nucleus¤¬¤¢¤Ê¤¿¤Î¥µ¡¼¥Ð¤ÎPHPÀßÄ꤫¤é'default MySQL host'¤ò¸¡ÃΤ·¤¿¤Ê¤é¡¢'¥Û¥¹¥È̾'¤Ë´û¤Ëµ­Æþ¤µ¤ì¤Æ¤¤¤ë¤Ï¤º¤Ç¤¹¡£¤â¤Ã¤È¤â¡¢¤³¤Î¾ðÊó¤¬Àµ³Î¤Ç¤¢¤ë¤È¤¤¤¦ÊݾڤϤ¢¤ê¤Þ¤»¤ó¡£</p>
+
+               <fieldset>
+                       <legend>´ðËܤΥǡ¼¥¿¥Ù¡¼¥¹ÀßÄê</legend>
+                       <table>
+                               <tr>
+                                       <td>¥Û¥¹¥È̾¡§</td>
+                                       <td><input name="mySQL_host" value="<?php echo htmlspecialchars(@ini_get('mysql.default_host') )?>" /></td>
+                               </tr>
+                               <tr>
+                                       <td>¥æ¡¼¥¶¡¼Ì¾¡§</td>
+                                       <td><input name="mySQL_user" /></td>
+                               </tr>
+                               <tr>
+                                       <td>¥Ñ¥¹¥ï¡¼¥É¡§</td>
+                                       <td><input name="mySQL_password" type="password" /></td>
+                               </tr>
+                               <tr>
+                                       <td>¥Ç¡¼¥¿¥Ù¡¼¥¹Ì¾¡§</td>
+                                       <td><input name="mySQL_database" /> (<input name="mySQL_create" value="1" type="checkbox" id="mySQL_create"><label for="mySQL_create" />¥Ç¡¼¥¿¥Ù¡¼¥¹¤òºîÀ®¤¹¤ëɬÍפ¬¤¢¤ë</label>)</td>
+                               </tr>
+                       </table>
+               </fieldset>
+
+               <fieldset>
+                       <legend>¹âÅù¤Ê¥Ç¡¼¥¿¥Ù¡¼¥¹ÀßÄê</legend>
+                       <table>
+                               <tr>
+                                       <td><input name="mySQL_usePrefix" value="1" type="checkbox" id="mySQL_usePrefix"><label for="mySQL_usePrefix" />¥Æ¡¼¥Ö¥ë¡¦¥×¥ê¥Õ¥£¥Ã¥¯¥¹¤òÍøÍÑ</label></td>
+                                       <td><input name="mySQL_tablePrefix" value="" /></td>
+                               </tr>
+                       </table>
+
+                       <p>°ì¤Ä¤Î¥Ç¡¼¥¿¥Ù¡¼¥¹¤ËÊ£¿ô¤ÎNucleus¤ò¥¤¥ó¥¹¥È¡¼¥ë¤·¤Æ¤ª¤ê¡¢¼«Ê¬¤¬²¿¤ò¤ä¤Ã¤Æ¤¤¤ë¤Î¤«Íý²ò¤µ¤ì¤Æ¤¤¤ë¾ì¹ç¤ò½ü¤¤¤Æ¤Ï¡¢<strong>¤³¤ì¤òÊѹ¹¤¹¤ëɬÍפϤ¢¤ê¤Þ¤»¤ó</strong>¡£</p>
+                       <p>Nucleus¤Ë¤è¤Ã¤ÆÀ¸À®¤µ¤ì¤¿¤¹¤Ù¤Æ¤Î¥Ç¡¼¥¿¥Ù¡¼¥¹¥Æ¡¼¥Ö¥ë¤Ï¡¢¤³¤Î¥×¥ê¥Õ¥£¥Ã¥¯¥¹¤¬Æ¬¤Ë¤Ä¤­¤Þ¤¹¡£</p>
+               </fieldset>
+
+       <h1>¥Ç¥£¥ì¥¯¥È¥ê¤ÈURL</h1>
+
+       <p>¤³¤Î¥¤¥ó¥¹¥È¡¼¥ë¥¹¥¯¥ê¥×¥È¤ÏNucleus¤¬¥¤¥ó¥¹¥È¡¼¥ë¤µ¤ì¤Æ¤¤¤ë¥Ç¥£¥ì¥¯¥È¥ê¤ÈURL¤ò¸«¤Ä¤±¤è¤¦¤È¤·¤Þ¤·¤¿¡£²¼¤ÎÃͤò¥Á¥§¥Ã¥¯¤·¤ÆɬÍפʤéÄûÀµ¤·¤Æ¤¯¤À¤µ¤¤¡£¥Õ¥¡¥¤¥ë¤Ø¤Î¥Ñ¥¹¤ÈURL¤Ï¥¹¥é¥Ã¥·¥å'/'¤Ç½ª¤ï¤é¤Ê¤¯¤Æ¤Ï¤Ê¤ê¤Þ¤»¤ó¡£</p>
+
+<?php
+
+       // no need to this all! dirname(__FILE__) is all we need -- moraes
+       /*
+       // discover full path
+       $fullPath = serverVar('PATH_TRANSLATED');
+
+       if ($fullPath == '') {
+               $fullPath = serverVar('SCRIPT_FILENAME');
+       }
+
+       $basePath = str_replace('install.php', '', $fullPath);
+       $basePath = replaceDoubleBackslash($basePath);
+       $basePath = replaceDoubleBackslash($basePath);
+
+       // add slash at end if necessary
+       if (!endsWithSlash($basePath) ) {
+               $basePath .= '/';
+       }
+       */
+
+       $basePath = dirname(__FILE__) . '/';
+?>
+
+               <fieldset>
+                       <legend>URLs and directories</legend>
+                       <table>
+                               <tr>
+                                       <td>Site <strong>URL</strong>:</td>
+                                       <td><input name="IndexURL" size="60" value="<?php
+                                               $url = 'http://' . serverVar('HTTP_HOST') . serverVar('PHP_SELF');
+                                               $url = str_replace('install.php', '', $url);
+                                               $url = replaceDoubleBackslash($url);
+
+                                               // add slash at end if necessary
+                                               if (!endsWithSlash($url) ) {
+                                                       $url .= '/';
+                                               }
+
+                                               echo $url; ?>" /></td>
+                               </tr>
+                               <tr>
+                                       <td>Admin-area <strong>URL</strong>:</td>
+                                       <td><input name="AdminURL" size="60" value="<?php
+                                               if ($url) {
+                                                       echo $url, 'nucleus/';
+                                               } ?>" /></td>
+                               </tr>
+                               <tr>
+                                       <td>Admin-area <strong>path</strong>:</td>
+                                       <td><input name="AdminPath" size="60" value="<?php
+                                               if($basePath) {
+                                                       echo $basePath, 'nucleus/';
+                                               } ?>" /></td>
+                               </tr>
+                               <tr>
+                                       <td>Media files <strong>URL</strong>:</td>
+                                       <td><input name="MediaURL" size="60" value="<?php
+                                               if ($url) {
+                                                       echo $url, 'media/';
+                                               } ?>" /></td>
+                               </tr>
+                               <tr>
+                                       <td>Media directory <strong>path</strong>:</td>
+                                       <td><input name="MediaPath" size="60" value="<?php
+                                               if ($basePath) {
+                                                       echo $basePath, 'media/';
+                                               } ?>" /></td>
+                               </tr>
+                               <tr>
+                                       <td>Extra skin files <strong>URL</strong>:</td>
+                                       <td><input name="SkinsURL" size="60" value="<?php
+                                               if ($url) {
+                                                       echo $url, 'skins/';
+                                               } ?>" />
+                                               <br />(¥¤¥ó¥Ý¡¼¥È¤µ¤ì¤¿¥¹¥­¥ó¤¬»ÈÍÑ)
+                                       </td>
+                               </tr>
+                               <tr>
+                                       <td>Extra skin files directory <strong>path</strong>:</td>
+                                       <td><input name="SkinsPath" size="60" value="<?php
+                                               if ($basePath) {
+                                                       echo $basePath, 'skins/';
+                                               } ?>" />
+                                               <br />(¥¤¥ó¥Ý¡¼¥È¤µ¤ì¤¿¥¹¥­¥ó¤Î¥Õ¥¡¥¤¥ëÎà¤òÃÖ¤¯¾ì½ê)
+                                       </td>
+                               </tr>
+                               <tr>
+                                       <td>Plugin files <strong>URL</strong>:</td>
+                                       <td><input name="PluginURL" size="60" value="<?php
+                                               if ($url) {
+                                                       echo $url, 'nucleus/plugins/';
+                                               } ?>" /></td>
+                               </tr>
+                               <tr>
+                                       <td>Action <strong>URL</strong>:</td>
+                                       <td><input name="ActionURL" size="60" value="<?php
+                                               if ($url) {
+                                                       echo $url, 'action.php';
+                                               } ?>" />
+                                               <br />(<tt>action.php</tt>¤Ø¤Îhttp://¤«¤é»Ï¤Þ¤ëURL)
+                                       </td>
+                               </tr>
+                       </table>
+               </fieldset>
+
+               <p class="note"><strong>ÉÕµ­:</strong> ÁêÂХѥ¹¤Ç¤Ï¤Ê¤¯<strong>ÀäÂХѥ¹¤ò»È¤Ã¤Æ¤¯¤À¤µ¤¤</strong>¡£Ä̾ÀäÂХѥ¹¤Ï<tt>/home/username/public_html/</tt>¤Î¤è¤¦¤Ê·Á¤ò¤È¤ê¤Þ¤¹¡£Unix¥·¥¹¥Æ¥à¡Ê¤Û¤È¤ó¤É¤Î¥µ¡¼¥Ð¡¼¤¬¤½¤¦¤Ç¤¹¡Ë¤Ë¤ª¤¤¤Æ¡¢¥Ñ¥¹¤Ï¥¹¥é¥Ã¥·¥å¤«¤é»Ï¤Þ¤ê¤Þ¤¹¡£¤â¤·¤³¤ì¤é¤Î¾ðÊóÆþÎϤËÌäÂ꤬À¸¤¸¤¿¤é¡¢¤¢¤Ê¤¿¤Î¥µ¡¼¥Ð´ÉÍý¼Ô¤Ë¤¿¤º¤Í¤ë¤Ù¤­¤Ç¤¹¡£</p>
+
+               <h1>´ÉÍý¸¢¸Â¤ò¤â¤Ä¥æ¡¼¥¶¡¼</h1>
+
+               <p>°Ê²¼¤Ë¡¢¥µ¥¤¥È¤ÎºÇ½é¤Î¥æ¡¼¥¶¡¼¤òºîÀ®¤¹¤ë¤¿¤á¤Î¤¤¤¯¤Ä¤«¤Î¾ðÊó¤òÆþÎϤ·¤Æ¤¯¤À¤µ¤¤¡£</p>
+
+               <fieldset>
+                       <legend>´ÉÍý¸¢¸Â¤ò»ý¤Ä¥æ¡¼¥¶¡¼</legend>
+                       <table>
+                               <tr>
+                                       <td>ɽ¼¨¤µ¤ì¤ë̾Á°¡§</td>
+                                       <td><input name="User_name" value="" /> <small>(µö²Ä¤µ¤ì¤ëʸ»ú¡§a-z ¤È 0-9¡¢ºÇ½é¤ÈºÇ¸å°Ê³°¤Î¥¹¥Ú¡¼¥¹)</small></td>
+                               </tr>
+                               <tr>
+                                       <td>ËÜ̾¡Ê¥Ï¥ó¥É¥ë̾¡Ë¡§</td>
+                                       <td><input name="User_realname" value="" /></td>
+                               </tr>
+                               <tr>
+                                       <td>¥Ñ¥¹¥ï¡¼¥É¡§</td>
+                                       <td><input name="User_password" type="password" value="" /></td>
+                               </tr>
+                               <tr>
+                                       <td>¥Ñ¥¹¥ï¡¼¥É¤Î³Îǧ¡§</td>
+                                       <td><input name="User_password2" type="password" value="" /></td>
+                               </tr>
+                               <tr>
+                                       <td>¥á¡¼¥ë¥¢¥É¥ì¥¹¡§</td>
+                                       <td><input name="User_email" value="" /> <small>(ÍøÍѲÄǽ¤Ê¥á¡¼¥ë¥¢¥É¥ì¥¹¤òÆþ¤ì¤Æ¤¯¤À¤µ¤¤)</small></td>
+                               </tr>
+                       </table>
+               </fieldset>
+
+               <h1>¥¦¥§¥Ö¥í¥°¤Î¥Ç¡¼¥¿</h1>
+
+               <p>°Ê²¼¤Ë¡¢¥Ç¥Õ¥©¥ë¥È¤Îweblog¤òºîÀ®¤¹¤ë¤¿¤á¤Ë¤¤¤¯¤Ä¤«¤Î¾ðÊó¤òÆþÎϤ·¤Æ¤¯¤À¤µ¤¤¡£¤³¤Îweblog¤Î̾Á°¤Ï¡¢¥µ¥¤¥È̾¤È¤·¤Æ¤âÍøÍѤµ¤ì¤Þ¤¹¡£</p>
+
+               <fieldset>
+                       <legend>¥¦¥§¥Ö¥í¥°¤Î¥Ç¡¼¥¿</legend>
+                       <table>
+                               <tr>
+                                       <td>Blog̾¡§</td>
+                                       <td><input name="Blog_name" size="60" value="My Nucleus CMS" /></td>
+                               </tr>
+                               <tr>
+                                       <td>Blog¤Îû½Ì̾¡§</td>
+                                       <td><input name="Blog_shortname" value="mynucleuscms" /> <small>(µö²Ä¤µ¤ì¤ëʸ»ú¡§a-z ¤È 0-9¡¢¥¹¥Ú¡¼¥¹¤ÏÉÔ²Ä)</small></td>
+                               </tr>
+                       </table>
+               </fieldset>
+
+               <h1>¥Ç¡¼¥¿¤ÎÁ÷¿®</h1>
+
+               <p>¾å¤Ë½ñ¤¤¤Æ¤­¤¿¥Ç¡¼¥¿¤¬Àµ¤·¤¤¤«³Î¤«¤á¤Æ¤¯¤À¤µ¤¤¡£¤è¤±¤ì¤Ð¥Ç¡¼¥¿¥Ù¡¼¥¹¡¦¥Æ¡¼¥Ö¥ë¤ÈºÇ½é¤Î¥Ç¡¼¥¿¤òÀßÄꤹ¤ë¤¿¤á¤Ë²¼¤Î¥Ü¥¿¥ó¤ò²¡¤·¤Æ¤¯¤À¤µ¤¤¡£¾¯¤·»þ´Ö¤¬¤«¤«¤ë¤«¤â¤·¤ì¤Þ¤»¤ó¤¬¤´¿ÉÊú¤ò¡£<b>¥Ü¥¿¥ó¤ò¥¯¥ê¥Ã¥¯¤¹¤ë¤Î¤Ï°ì²ó¤À¤±¤Ë¤·¤Æ¤¯¤À¤µ¤¤¡£</b></p>
+
+               <p><input name="action" value="go" type="hidden" /> <input type="submit" value="Nucleus CMS¤Î¥¤¥ó¥¹¥È¡¼¥ë" onclick="return checkSubmit();" /></p>
+
+               </form>
+       </body>
+</html>
+
+<?php }
+
+function tableName($unPrefixed) {
+       global $mysql_usePrefix, $mysql_prefix;
+
+       if ($mysql_usePrefix == 1) {
+               return $mysql_prefix . $unPrefixed;
+       } else {
+               return $unPrefixed;
+       }
+}
+
+function doInstall() {
+       global $mysql_usePrefix, $mysql_prefix;
+
+       // 0. put all POST-vars into vars
+       $mysql_host = postVar('mySQL_host');
+       $mysql_user = postVar('mySQL_user');
+       $mysql_password = postVar('mySQL_password');
+       $mysql_database = postVar('mySQL_database');
+       $mysql_create = postVar('mySQL_create');
+       $mysql_usePrefix = postVar('mySQL_usePrefix');
+       $mysql_prefix = postVar('mySQL_tablePrefix');
+       $config_indexurl = postVar('IndexURL');
+       $config_adminurl = postVar('AdminURL');
+       $config_adminpath = postVar('AdminPath');
+       $config_mediaurl = postVar('MediaURL');
+       $config_skinsurl = postVar('SkinsURL');
+       $config_pluginurl = postVar('PluginURL');
+       $config_actionurl = postVar('ActionURL');
+       $config_mediapath = postVar('MediaPath');
+       $config_skinspath = postVar('SkinsPath');
+       $user_name = postVar('User_name');
+       $user_realname = postVar('User_realname');
+       $user_password = postVar('User_password');
+       $user_password2 = postVar('User_password2');
+       $user_email = postVar('User_email');
+       $blog_name = postVar('Blog_name');
+       $blog_shortname = postVar('Blog_shortname');
+       $config_adminemail = $user_email;
+       $config_sitename = $blog_name;
+
+       $config_indexurl = replaceDoubleBackslash($config_indexurl);
+       $config_adminurl = replaceDoubleBackslash($config_adminurl);
+       $config_mediaurl = replaceDoubleBackslash($config_mediaurl);
+       $config_skinsurl = replaceDoubleBackslash($config_skinsurl);
+       $config_pluginurl = replaceDoubleBackslash($config_pluginurl);
+       $config_actionurl = replaceDoubleBackslash($config_actionurl);
+       $config_adminpath = replaceDoubleBackslash($config_adminpath);
+       $config_skinspath = replaceDoubleBackslash($config_skinspath);
+
+       // 1. check all the data
+       $errors = array();
+
+       if (!$mysql_database) {
+               array_push($errors, 'mySQL database name missing');
+       }
+
+       if (($mysql_usePrefix == 1) && (strlen($mysql_prefix) == 0) ) {
+               array_push($errors, 'mySQL prefix was selected, but prefix is empty');
+       }
+
+       if (($mysql_usePrefix == 1) && (!eregi('^[a-zA-Z0-9_]+$', $mysql_prefix) ) ) {
+               array_push($errors, 'mySQL prefix should only contain characters from the ranges A-Z, a-z, 0-9 or underscores');
+       }
+
+       // TODO: add action.php check
+       if (!endsWithSlash($config_indexurl) || !endsWithSlash($config_adminurl) || !endsWithSlash($config_mediaurl) || !endsWithSlash($config_pluginurl) || !endsWithSlash($config_skinsurl) ) {
+               array_push($errors, 'One of the URLs does not end with a slash, or action url does not end with \'action.php\'');
+       }
+
+       if (!endsWithSlash($config_adminpath) ) {
+               array_push($errors, 'The path of the administration area does not end with a slash');
+       }
+
+       if (!endsWithSlash($config_mediapath) ) {
+               array_push($errors, 'The media path does not end with a slash');
+       }
+
+       if (!endsWithSlash($config_skinspath) ) {
+               array_push($errors, 'The skins path does not end with a slash');
+       }
+
+       if (!is_dir($config_adminpath) ) {
+               array_push($errors, 'The path of the administration area does not exist on your server');
+       }
+
+       if (!_isValidMailAddress($user_email) ) {
+               array_push($errors, 'Invalid e-mail address given for user');
+       }
+
+       if (!_isValidDisplayName($user_name) ) {
+               array_push($errors, 'User name is not a valid display name (allowed chars: a-zA-Z0-9 and spaces)');
+       }
+
+       if (!$user_password || !$user_password2) {
+               array_push($errors, 'User password is empty');
+       }
+
+       if ($user_password != $user_password2) {
+               array_push($errors, 'User password do not match');
+       }
+
+       if (!_isValidShortName($blog_shortname) ) {
+               array_push($errors, 'Invalid short name given for blog (allowed chars: a-z0-9, no spaces)');
+       }
+
+       if (sizeof($errors) > 0) {
+               showErrorMessages($errors);
+       }
+
+       // 2. try to log in to mySQL
+       global $MYSQL_CONN;
+       $MYSQL_CONN = @mysql_connect($mysql_host, $mysql_user, $mysql_password);
+
+       if ($MYSQL_CONN == false) {
+               _doError('Could not connect to mySQL server: ' . mysql_error() );
+       }
+
+       // 3. try to create database (if needed)
+       if ($mysql_create == 1) {
+               mysql_query('CREATE DATABASE ' . $mysql_database) or _doError('Could not create database. Make sure you have the rights to do so. SQL error was: ' . mysql_error() );
+       }
+
+       // 4. try to select database
+       mysql_select_db($mysql_database) or _doError('Could not select database. Make sure it exists');
+
+       // 5. execute queries
+       $filename = 'install.sql';
+       $fd = fopen($filename, 'r');
+       $queries = fread($fd, filesize($filename) );
+       fclose($fd);
+
+       $queries = split("(;\n|;\r)", $queries);
+
+       $aTableNames = array(
+               'nucleus_actionlog',
+               'nucleus_ban',
+               'nucleus_blog',
+               'nucleus_category',
+               'nucleus_comment',
+               'nucleus_config',
+               'nucleus_item',
+               'nucleus_karma',
+               'nucleus_member',
+               'nucleus_plugin',
+               'nucleus_skin',
+               'nucleus_template',
+               'nucleus_team',
+               'nucleus_activation',
+               'nucleus_tickets'
+               );
+// these are unneeded (one of the replacements above takes care of them)
+//                     'nucleus_plugin_event',
+//                     'nucleus_plugin_option',
+//                     'nucleus_plugin_option_desc',
+//                     'nucleus_skin_desc',
+//                     'nucleus_template_desc',
+
+       $aTableNamesPrefixed = array(
+               $mysql_prefix . 'nucleus_actionlog',
+               $mysql_prefix . 'nucleus_ban',
+               $mysql_prefix . 'nucleus_blog',
+               $mysql_prefix . 'nucleus_category',
+               $mysql_prefix . 'nucleus_comment',
+               $mysql_prefix . 'nucleus_config',
+               $mysql_prefix . 'nucleus_item',
+               $mysql_prefix . 'nucleus_karma',
+               $mysql_prefix . 'nucleus_member',
+               $mysql_prefix . 'nucleus_plugin',
+               $mysql_prefix . 'nucleus_skin',
+               $mysql_prefix . 'nucleus_template',
+               $mysql_prefix . 'nucleus_team',
+               $mysql_prefix . 'nucleus_activation',
+               $mysql_prefix . 'nucleus_tickets'
+               );
+// these are unneeded (one of the replacements above takes care of them)
+//                     $mysql_prefix . 'nucleus_plugin_event',
+//                     $mysql_prefix . 'nucleus_plugin_option',
+//                     $mysql_prefix . 'nucleus_plugin_option_desc',
+//                     $mysql_prefix . 'nucleus_skin_desc',
+//                     $mysql_prefix . 'nucleus_template_desc',
+
+       $count = count($queries);
+
+       for ($idx = 0; $idx < $count; $idx++) {
+               $query = trim($queries[$idx]);
+               // echo "QUERY = <small>" . htmlspecialchars($query) . "</small><p>";
+
+               if ($query) {
+
+                       if ($mysql_usePrefix == 1) {
+                                       $query = str_replace($aTableNames, $aTableNamesPrefixed, $query);
+                       }
+
+                       mysql_query($query) or _doError('Error while executing query (<small>' . htmlspecialchars($query) . '</small>): ' . mysql_error() );
+               }
+       }
+
+       // 6. update global settings
+       updateConfig('IndexURL', $config_indexurl);
+       updateConfig('AdminURL', $config_adminurl);
+       updateConfig('MediaURL', $config_mediaurl);
+       updateConfig('SkinsURL', $config_skinsurl);
+       updateConfig('PluginURL', $config_pluginurl);
+       updateConfig('ActionURL', $config_actionurl);
+       updateConfig('AdminEmail', $config_adminemail);
+       updateConfig('SiteName', $config_sitename);
+
+       // 7. update GOD member
+       $query = 'UPDATE ' . tableName('nucleus_member')
+                       . " SET mname='" . addslashes($user_name) . "',"
+                       . " mrealname='" . addslashes($user_realname) . "',"
+                       . " mpassword='" . md5(addslashes($user_password) ) . "',"
+                       . " murl='" . addslashes($config_indexurl) . "',"
+                       . " memail='" . addslashes($user_email) . "',"
+                       . " madmin=1, mcanlogin=1"
+                       . " WHERE mnumber=1";
+
+       mysql_query($query) or _doError('Error while setting member settings: ' . mysql_error() );
+
+       // 8. update weblog settings
+       $query = 'UPDATE ' . tableName('nucleus_blog')
+                       . " SET bname='" . addslashes($blog_name) . "',"
+                       . " bshortname='" . addslashes($blog_shortname) . "',"
+                       . " burl='" . addslashes($config_indexurl) . "'"
+                       . " WHERE bnumber=1";
+
+       mysql_query($query) or _doError('Error while setting weblog settings: ' . mysql_error() );
+
+       // 9. update item date
+       $query = 'UPDATE ' . tableName('nucleus_item')
+                       . " SET itime='" . date('Y-m-d H:i:s', time() ) ."'"
+                       . " WHERE inumber=1";
+
+       mysql_query($query) or _doError('Error with query: ' . mysql_error() );
+
+       global $aConfPlugsToInstall, $aConfSkinsToImport;
+       $aSkinErrors = array();
+       $aPlugErrors = array();
+
+       if ((count($aConfPlugsToInstall) > 0) || (count($aConfSkinsToImport) > 0) ) {
+               // 10. set global variables
+               global $MYSQL_HOST, $MYSQL_USER, $MYSQL_PASSWORD, $MYSQL_DATABASE, $MYSQL_PREFIX;
+
+               $MYSQL_HOST = $mysql_host;
+               $MYSQL_USER = $mysql_user;
+               $MYSQL_PASSWORD = $mysql_password;
+               $MYSQL_DATABASE = $mysql_database;
+               $MYSQL_PREFIX = ($mysql_usePrefix == 1)?$mysql_prefix:'';
+
+               global $DIR_NUCLEUS, $DIR_MEDIA, $DIR_SKINS, $DIR_PLUGINS, $DIR_LANG, $DIR_LIBS;
+
+               $DIR_NUCLEUS = $config_adminpath;
+               $DIR_MEDIA = $config_mediapath;
+               $DIR_SKINS = $config_skinspath;
+               $DIR_PLUGINS = $DIR_NUCLEUS . 'plugins/';
+               $DIR_LANG = $DIR_NUCLEUS . 'language/';
+               $DIR_LIBS = $DIR_NUCLEUS . 'libs/';
+
+               // close database connection (needs to be closed if we want to include globalfunctions.php)
+               mysql_close();
+
+               $manager = '';
+               include_once($DIR_LIBS . 'globalfunctions.php');
+
+               // 11. install custom skins
+               $aSkinErrors = installCustomSkins($manager);
+
+               // 12. install custom plugins
+               $aPlugErrors = installCustomPlugs($manager);
+       }
+
+       // 12. Write config file ourselves (if possible)
+       $bConfigWritten = 0;
+
+       if (@file_exists('config.php') && is_writable('config.php') && $fp = @fopen('config.php', 'w') ) {
+               $config_data = '<' . '?php' . "\n\n";
+               //$config_data .= "\n"; (extraneous, just added extra \n to previous line
+               $config_data .= "       // mySQL connection information\n";
+               $config_data .= "       \$MYSQL_HOST = '" . $mysql_host . "';\n";
+               $config_data .= "       \$MYSQL_USER = '" . $mysql_user . "';\n";
+               $config_data .= "       \$MYSQL_PASSWORD = '" . $mysql_password . "';\n";
+               $config_data .= "       \$MYSQL_DATABASE = '" . $mysql_database . "';\n";
+               $config_data .= "       \$MYSQL_PREFIX = '" . (($mysql_usePrefix == 1)?$mysql_prefix:'') . "';\n";
+               $config_data .= "\n";
+               $config_data .= "       // main nucleus directory\n";
+               $config_data .= "       \$DIR_NUCLEUS = '" . $config_adminpath . "';\n";
+               $config_data .= "\n";
+               $config_data .= "       // path to media dir\n";
+               $config_data .= "       \$DIR_MEDIA = '" . $config_mediapath . "';\n";
+               $config_data .= "\n";
+               $config_data .= "       // extra skin files for imported skins\n";
+               $config_data .= "       \$DIR_SKINS = '" . $config_skinspath . "';\n";
+               $config_data .= "\n";
+               $config_data .= "       // these dirs are normally sub dirs of the nucleus dir, but \n";
+               $config_data .= "       // you can redefine them if you wish\n";
+               $config_data .= "       \$DIR_PLUGINS = \$DIR_NUCLEUS . 'plugins/';\n";
+               $config_data .= "       \$DIR_LANG = \$DIR_NUCLEUS . 'language/';\n";
+               $config_data .= "       \$DIR_LIBS = \$DIR_NUCLEUS . 'libs/';\n";
+               $config_data .= "\n";
+               $config_data .= "       // include libs\n";
+               $config_data .= "       include(\$DIR_LIBS.'globalfunctions.php');\n";
+               $config_data .= "       if (!extension_loaded('mbstring')) {\n";
+               $config_data .= "       include(\$DIR_LIBS.'mb_emulator/mb-emulator.php');\n";
+               $config_data .= "       }\n";
+               $config_data .= "?" . ">";
+
+               $result = @fputs($fp, $config_data, strlen($config_data) );
+               fclose($fp);
+
+               if ($result) {
+                       $bConfigWritten = 1;
+               }
+       }
+
+?>
+<!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">
+<head>
+       <meta http-equiv="Content-Type" content="text/html; charset=EUC-JP" />
+       <title>Nucleus¤Î¥¤¥ó¥¹¥È¡¼¥ë</title>
+       <style>@import url('nucleus/styles/manual.css');</style>
+</head>
+<body>
+       <div style='text-align:center'><img src='./nucleus/styles/logo.gif' /></div> <!-- Nucleus logo -->
+
+<?php
+       $aAllErrors = array_merge($aSkinErrors, $aPlugErrors);
+
+       if (count($aAllErrors) > 0) {
+               echo '<h1>Skin/Plugin Install errors</h1>';
+               echo '<ul><li>' . implode('</li><li>', $aAllErrors) . '</li></ul>';
+       }
+
+       if (!$bConfigWritten) { ?>
+               <h1>¥¤¥ó¥¹¥È¡¼¥ë¤Ï¤Û¤Ü´°Î»¤·¤Þ¤·¤¿¡ª</h1>
+
+               <p>¥Ç¡¼¥¿¥Ù¡¼¥¹¥Æ¡¼¥Ö¥ë¤Î½é´üÃÍÆþÎϤ¬À®¸ù¤·¤Þ¤·¤¿¡£¸å¤Ï<i>config.php</i>¤ò½ñ¤­´¹¤¨¤ë¤À¤±¤Ç¤¹¡£°Ê²¼¤Ë½ñ¤­´¹¤¨¤ë¤Ù¤­ÆâÍƤòɽ¼¨¤·¤Þ¤¹¡Êmysql¤Î¥Ñ¥¹¥ï¡¼¥É¤Ï¥Þ¥¹¥¯¤µ¤ì¤Æ¤¤¤Þ¤¹¡£¤³¤³¤Ï¼ÂºÝ¤Î¤â¤Î¤Ë½ñ¤­´¹¤¨¤Æ¤¯¤À¤µ¤¤¡Ë</p>
+
+               <pre><code>&lt;?php
+       // mySQL connection information
+       $MYSQL_HOST = '<b><?php echo $mysql_host?></b>';
+       $MYSQL_USER = '<b><?php echo $mysql_user?></b>';
+       $MYSQL_PASSWORD = '<i><b>xxxxxxxxxxx</b></i>';
+       $MYSQL_DATABASE = '<b><?php echo $mysql_database?></b>';
+       $MYSQL_PREFIX = '<b><?php echo ($mysql_usePrefix == 1)?$mysql_prefix:''?></b>';
+
+       // main nucleus directory
+       $DIR_NUCLEUS = '<b><?php echo $config_adminpath?></b>';
+
+       // path to media dir
+       $DIR_MEDIA = '<b><?php echo $config_mediapath?></b>';
+
+       // extra skin files for imported skins
+       $DIR_SKINS = '<b><?php echo $config_skinspath?></b>';
+
+       // these dirs are normally sub dirs of the nucleus dir, but
+       // you can redefine them if you wish
+       $DIR_PLUGINS = $DIR_NUCLEUS . 'plugins/';
+       $DIR_LANG = $DIR_NUCLEUS . 'language/';
+       $DIR_LIBS = $DIR_NUCLEUS . 'libs/';
+
+       // include libs
+       include($DIR_LIBS.'globalfunctions.php');
+       if (!extension_loaded('mbstring')) {
+               include($DIR_LIBS.'mb_emulator/mb-emulator.php');
+       }
+?&gt;</code></pre>
+
+       <p>¤¢¤Ê¤¿¤Î¥³¥ó¥Ô¥å¡¼¥¿¾å¤Î¥Õ¥¡¥¤¥ë¤ò½ñ¤­´¹¤¨¤¿¤é¡¢FTP¤ò»È¤Ã¤Æ¥¦¥§¥Ö¥µ¡¼¥Ð¤Ë¥¢¥Ã¥×¥í¡¼¥É¤·¤Æ¤¯¤À¤µ¤¤¡£ASCII¥â¡¼¥É¤ÇÁ÷¿®¤·¤Æ¥Õ¥¡¥¤¥ë¤ò¾å½ñ¤­¤·¤Þ¤¹¡£</p>
+
+       <div class="note">
+               <b>ÉÕµ­:</b> <i>config.php</i>¤ÎºÇ½é¤ä½ª¤ï¤ê¤Ë¥¹¥Ú¡¼¥¹¤ò¶õ¤±¤Ê¤¤¤è¤¦¤Ë¤·¤Þ¤·¤ç¤¦¡£¼Â¹Ô»þ¤Ë¥¨¥é¡¼¤ò°ú¤­µ¯¤³¤¹¸¶°ø¤È¤Ê¤ê¤Þ¤¹¡£<br />
+               ¤·¤¿¤¬¤Ã¤Æ¡¢config.php¤ÎºÇ½é¤Îʸ»ú¤Ï "&lt;"¤ÇºÇ¸å¤Îʸ»ú¤Ï"&gt;"¤È¤·¤Ê¤±¤ì¤Ð¤Ê¤ê¤Þ¤»¤ó¡£
+       </div>
+
+<?php } else { ?>
+
+       <h1>¥¤¥ó¥¹¥È¡¼¥ë¤Ï´°Î»¤·¤Þ¤·¤¿¡ª</h1>
+
+       <p>Nucleus¤Ï¥¤¥ó¥¹¥È¡¼¥ë¤µ¤ì¡¢<code>config.php</code>¤Ï¥¢¥Ã¥×¥Ç¡¼¥È¤µ¤ì¤Þ¤·¤¿¡£</p>
+
+       <p>¥»¥­¥å¥ê¥Æ¥£¤Î¤¿¤á<code>config.php</code>¤Î¥Ñ¡¼¥ß¥Ã¥·¥ç¥ó¤ò444¤ËÌ᤹¤³¤È¤ò˺¤ì¤Ê¤¤¤Ç¤¯¤À¤µ¤¤(<a href="nucleus/documentation/tips.html#filepermissions">¥Ñ¡¼¥ß¥Ã¥·¥ç¥óÊѹ¹¤Î´Ê°×¥¬¥¤¥É</a>)¡£</p>
+
+<?php } ?>
+
+       <h1>¥¤¥ó¥¹¥È¡¼¥ë¥Õ¥¡¥¤¥ë¤Îºï½ü</h1>
+
+       <p>¥¦¥§¥Ö¥µ¡¼¥Ð¤«¤é¼¡¤Î¥Õ¥¡¥¤¥ë¤òºï½ü¤·¤Æ¤¯¤À¤µ¤¤¡§</p>
+
+       <ul>
+               <li><b>install.sql</b>¡§¥Æ¡¼¥Ö¥ë¤Î¹½Â¤¤òÆâÊñ¤¹¤ë¥Õ¥¡¥¤¥ë</li>
+               <li><b>install.php</b>¡§¤³¤Î¥Õ¥¡¥¤¥ë</li>
+       </ul>
+
+       <p>¤â¤·¤³¤ì¤é¤Î¥Õ¥¡¥¤¥ë¤òºï½ü¤·¤Æ¤¤¤Ê¤±¤ì¤Ð¡¢´ÉÍýÎΰè¤ò³«¤¯¤³¤È¤¬½ÐÍè¤Þ¤»¤ó¡£</p>
+
+       <h1>¥¦¥§¥Ö¥µ¥¤¥È¤Î³Îǧ</h1>
+
+       <p>¥¦¥§¥Ö¥µ¥¤¥È¤ò»È¤¦½àÈ÷¤¬À°¤¤¤Þ¤·¤¿¡£
+               <ul>
+                       <li><a href="<?php echo $config_adminurl?>">´ÉÍýÎΰè¤Ë¥í¥°¥¤¥ó¤·¤Æ¥µ¥¤¥È¤ÎÀßÄê¤ò¹Ô¤¦</a></li>
+                       <li><a href="<?php echo $config_indexurl?>">¤¹¤°¤Ë¥µ¥¤¥È¤Ø¹Ô¤Ã¤Æ¤ß¤ë</a></li>
+               </ul>
+       </p>
+
+</body>
+</html>
+
+<?php
+}
+
+function installCustomPlugs(&$manager) {
+       global $aConfPlugsToInstall, $DIR_LIBS;
+
+       $aErrors = array();
+
+       if (count($aConfPlugsToInstall) == 0) {
+               return $aErrors;
+       }
+
+       $res = sql_query('SELECT * FROM ' . sql_table('plugin') );
+       $numCurrent = mysql_num_rows($res);
+
+       foreach ($aConfPlugsToInstall as $plugName) {
+               // do this before calling getPlugin (in case the plugin id is used there)
+               $query = 'INSERT INTO ' . sql_table('plugin') . ' (porder, pfile) VALUES (' . (++$numCurrent) . ', "' . addslashes($plugName) . '")';
+               sql_query($query);
+
+               // get and install the plugin
+               $plugin =& $manager->getPlugin($plugName);
+
+               if (!$plugin) {
+                       sql_query('DELETE FROM ' . sql_table('plugin') . ' WHERE pfile=\'' . addslashes($plugName) . '\'');
+                       $numCurrent--;
+                       array_push($aErrors, 'Unable to install plugin ' . $plugName);
+                       continue;
+               }
+
+               $plugin->install();
+       }
+
+       // SYNC PLUGIN EVENT LIST
+       sql_query('DELETE FROM ' . sql_table('plugin_event') );
+
+       // loop over all installed plugins
+       $res = sql_query('SELECT pid, pfile FROM ' . sql_table('plugin') );
+
+       while($o = mysql_fetch_object($res) ) {
+               $pid = $o->pid;
+               $plug =& $manager->getPlugin($o->pfile);
+
+               if ($plug) {
+                       $eventList = $plug->getEventList();
+
+                       foreach ($eventList as $eventName) {
+                               sql_query('INSERT INTO ' . sql_table('plugin_event') . ' (pid, event) VALUES (' . $pid . ', \'' . $eventName . '\')');
+                       }
+               }
+       }
+
+       return $aErrors;
+}
+
+function installCustomSkins(&$manager) {
+       global $aConfSkinsToImport, $DIR_LIBS, $DIR_SKINS;
+
+       $aErrors = array();
+
+       if (count($aConfSkinsToImport) == 0) {
+               return $aErrors;
+       }
+
+       // load skinie class
+       include_once($DIR_LIBS . 'skinie.php');
+
+       $importer = new SKINIMPORT();
+
+       foreach ($aConfSkinsToImport as $skinName) {
+               $importer->reset();
+               $skinFile = $DIR_SKINS . $skinName . '/skinbackup.xml';
+
+               if (!@file_exists($skinFile) ) {
+                       array_push($aErrors, 'Unable to import ' . $skinFile . ' : file does not exist');
+                       continue;
+               }
+
+               $error = $importer->readFile($skinFile);
+
+               if ($error) {
+                       array_push($aErrors, 'Unable to import ' . $skinName . ' : ' . $error);
+                       continue;
+               }
+
+               $error = $importer->writeToDatabase(1);
+
+               if ($error) {
+                       array_push($aErrors, 'Unable to import ' . $skinName . ' : ' . $error);
+                       continue;
+               }
+       }
+
+       return $aErrors;
+}
+
+// give an error if one or more nucleus are not accessible
+function doCheckFiles() {
+       $missingfiles = array();
+       $files = array(
+               'install.sql',
+               'index.php',
+               'action.php',
+               'nucleus/index.php',
+               'nucleus/libs/globalfunctions.php',
+               'nucleus/libs/ADMIN.php',
+               'nucleus/libs/BLOG.php',
+               'nucleus/libs/COMMENT.php',
+               'nucleus/libs/COMMENTS.php',
+               'nucleus/libs/ITEM.php',
+               'nucleus/libs/MEMBER.php',
+               'nucleus/libs/SKIN.php',
+               'nucleus/libs/TEMPLATE.php',
+               'nucleus/libs/MEDIA.php',
+               'nucleus/libs/ACTIONLOG.php',
+               'nucleus/media.php'
+               );
+
+       $count = count($files);
+
+       for ($i = 0; $i < $count; $i++) {
+               if (!is_readable($files[$i]) ) {
+                       array_push($missingfiles, 'File <b>' . $files[$i] . '</b> is missing or not readable.');
+               }
+       }
+
+// The above code replaces several if statements of the form:
+
+//     if (!is_readable('install.sql') ) {
+//             array_push($missingfiles, 'File <b>install.sql</b> is missing or not readable');
+//     }
+
+       if (count($missingfiles) > 0) {
+               showErrorMessages($missingfiles);
+       }
+}
+
+function updateConfig($name, $val) {
+       $name = addslashes($name);
+       $val = trim(addslashes($val) );
+
+       $query = 'UPDATE ' . tableName('nucleus_config')
+                       . " SET value='$val'"
+                       . " WHERE name='$name'";
+
+       mysql_query($query) or _doError('Query error while trying to update config: ' . mysql_error() );
+       return mysql_insert_id();
+}
+
+function replaceDoubleBackslash($input) {
+       return str_replace('\\', '/', $input);
+}
+
+function endsWithSlash($s) {
+       return (strrpos($s, '/') == strlen($s) - 1);
+}
+
+/**
+ * Checks if email address is valid
+ */
+function _isValidMailAddress($address) {
+       if (preg_match("/^[a-zA-Z0-9\._-]+@+[A-Za-z0-9\._-]+\.+[A-Za-z]{2,4}$/", $address) ) {
+               return 1;
+       } else {
+               return 0;
+       }
+}
+
+// returns true if the given string is a valid shortname
+// (to check short blog names and nicknames)
+// logic: starts and ends with a non space, can contain spaces in between
+//        min 2 chars
+function _isValidShortName($name) {
+       if (eregi("^[a-z0-9]+$", $name) ) {
+               return 1;
+       } else {
+               return 0;
+       }
+}
+
+
+
+// returns true if the given string is a valid display name
+// (to check nicknames)
+function _isValidDisplayName($name) {
+       if (eregi("^[a-z0-9]+[a-z0-9 ]*[a-z0-9]+$", $name) ) {
+               return 1;
+       } else {
+               return 0;
+       }
+}
+
+function _doError($msg) {
+       ?>
+<!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">
+<head>
+       <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
+       <title>Nucleus Install</title>
+       <style>@import url('nucleus/styles/manual.css');</style>
+</head>
+<body>
+       <div style='text-align:center'><img src='./nucleus/styles/logo.gif' /></div> <!-- Nucleus logo -->
+       <h1>Error!</h1>
+
+       <p>Error message was: "<?php echo $msg?>";</p>
+
+       <p><a href="install.php" onclick="history.back();return false;">Go Back</a></p>
+</body>
+</html>
+
+<?php
+       exit;
+}
+
+function showErrorMessages($errors) {
+       ?>
+<!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">
+<head>
+       <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
+       <title>Nucleus Install</title>
+       <style>@import url('nucleus/styles/manual.css');</style>
+</head>
+<body>
+       <div style='text-align:center'><img src='./nucleus/styles/logo.gif' /></div> <!-- Nucleus logo -->
+       <h1>Errors!</h1>
+
+       <p>Errors were found:</p>
+
+       <ul>
+
+<?php
+       while($msg = array_shift($errors) ) {
+               echo '<li>', $msg, '</li>';
+       }
+?>
+
+       </ul>
+
+       <p><a href="install.php" onclick="history.back();return false;">Go Back</a></p>
+</body>
+</html>
+
+<?php
+       exit;
+}
+
+/* for the non-php systems that decide to show the contents:
+?></div><?php  */
+
+?>