OSDN Git Service

インストールスクリプトを統合
[nucleus-jp/nucleus-jp-ancient.git] / utf8 / install.php
index e07ec7d..95e6bdb 100755 (executable)
-<?php
-       /**
-         * Nucleus: PHP/MySQL Weblog CMS (http://nucleuscms.org/)
-         * Copyright (C) 2002-2004 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         */
-
-       /*
-               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();
-
-
-               // 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();
-
-       /*
-               -- 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');
-
-       // 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=UTF-8" />
-               <title>Nucleusのインストール</title>
-               <style type="text/css"><!--
-                       @import url('nucleus/documentation/styles/manual.css');
-               --></style>
-               <script type="text/javascript"><!--
-                       // function to make sure the submit button only gets pressed once
-                       var submitcount=0;
-                       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>
-
-       <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 = str_replace("\\","/",$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                                      $path = str_replace("install.php",'',serverVar('SCRIPT_FILENAME'));
-                                       $path = str_replace("\\","/",$path);
-                                       // add slash at end if necessary
-                                       if (!endsWithSlash($path)) $path .= '/';
-                                       if($path) echo  $path . '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                                      $path = str_replace("install.php",'',serverVar('SCRIPT_FILENAME'));
-                                       $path = str_replace("\\","/",$path);
-                                       // add slash at end if necessary
-                                       if (!endsWithSlash($path)) $path .= '/';
-                                       if ($path) echo $path . '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                              $path = str_replace("install.php",'',serverVar('SCRIPT_FILENAME'));
-                               $path = str_replace("\\","/",$path);
-                               // add slash at end if necessary
-                               if (!endsWithSlash($path)) $path .= '/';
-                               if ($path) echo $path . '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 Weblog" /></td>
-               </tr><tr>
-                       <td>Blogの短縮名:</td>
-                       <td>
-                               <input name="Blog_shortname" value="myweblog" />
-                               <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="Install Nucleus" 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        = str_replace("\\","/",$config_indexurl);
-               $config_adminurl        = str_replace("\\","/",$config_adminurl);
-               $config_mediaurl        = str_replace("\\","/",$config_mediaurl);
-               $config_skinsurl        = str_replace("\\","/",$config_skinsurl);
-               $config_pluginurl       = str_replace("\\","/",$config_pluginurl);
-               $config_actionurl       = str_replace("\\","/",$config_actionurl);
-               $config_adminpath       = str_replace("\\","/",$config_adminpath);
-               $config_skinspath       = str_replace("\\","/",$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");
-               if (!endsWithSlash($config_indexurl) || !endsWithSlash($config_adminurl)
-                                                    || !endsWithSlash($config_mediaurl)
-                                                    || !endsWithSlash($config_pluginurl)
-                                                    || !endsWithSlash($config_skinsurl)
-                                                               // TODO: add action.php check
-                   )
-                       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
-               $connection = @mysql_connect($mysql_host, $mysql_user, $mysql_password);
-               if ($connection == 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',
-               );
-
-               for ($idx = 0;$idx<sizeof($queries);$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";
-                       $config_data .= "\n";
-                       $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=UTF-8" />
-                       <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>
-&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;
-                       </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;
-
-               $numCurrent = mysql_num_rows(sql_query('SELECT * FROM '.sql_table('plugin')));
-
-               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();
-
-               if (!is_readable('install.sql'))
-                       array_push($missingfiles, "File <b>install.sql</b> is missing or not readable");
-               if (!is_readable('index.php'))
-                       array_push($missingfiles, "File <b>index.php</b> is missing or not readable");
-               if (!is_readable('action.php'))
-                       array_push($missingfiles, "File <b>action.php</b> is missing or not readable");
-               if (!is_readable('nucleus/index.php'))
-                       array_push($missingfiles, "File <b>nucleus/index.php</b> is missing or not readable");
-               if (!is_readable('nucleus/libs/globalfunctions.php'))
-                       array_push($missingfiles, "File <b>nucleus/libs/globalfunctions.php</b> is missing or not readable");
-               if (!is_readable('nucleus/libs/ADMIN.php'))
-                       array_push($missingfiles, "File <b>nucleus/libs/ADMIN.php</b> is missing or not readable");
-               if (!is_readable('nucleus/libs/BLOG.php'))
-                       array_push($missingfiles, "File <b>nucleus/libs/BLOG.php</b> is missing or not readable");
-               if (!is_readable('nucleus/libs/COMMENT.php'))
-                       array_push($missingfiles, "File <b>nucleus/libs/COMMENT.php</b> is missing or not readable");
-               if (!is_readable('nucleus/libs/COMMENTS.php'))
-                       array_push($missingfiles, "File <b>nucleus/libs/COMMENTS.php</b> is missing or not readable");
-               if (!is_readable('nucleus/libs/ITEM.php'))
-                       array_push($missingfiles, "File <b>nucleus/libs/ITEM.php</b> is missing or not readable");
-               if (!is_readable('nucleus/libs/MEMBER.php'))
-                       array_push($missingfiles, "File <b>nucleus/libs/MEMBER.php</b> is missing or not readable");
-               if (!is_readable('nucleus/libs/SKIN.php'))
-                       array_push($missingfiles, "File <b>nucleus/libs/SKIN.php</b> is missing or not readable");
-               if (!is_readable('nucleus/libs/TEMPLATE.php'))
-                       array_push($missingfiles, "File <b>nucleus/libs/TEMPLATE.php</b> is missing or not readable");
-               if (!is_readable('nucleus/libs/MEDIA.php'))
-                       array_push($missingfiles, "File <b>nucleus/libs/MEDIA.php</b> is missing or not readable");
-               if (!is_readable('nucleus/libs/ACTIONLOG.php'))
-                       array_push($missingfiles, "File <b>nucleus/libs/ACTIONLOG.php</b> is missing or not readable");
-               if (!is_readable('nucleus/media.php'))
-                       array_push($missingfiles, "File <b>nucleus/media.php</b> is missing or not readable");
-
-
-               if (sizeof($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 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        */
-
+<?php\r
+/*\r
+ * Nucleus: PHP/MySQL Weblog CMS (http://nucleuscms.org/)\r
+ * Copyright (C) 2002-2009 The Nucleus Group\r
+ *\r
+ * This program is free software; you can redistribute it and/or\r
+ * modify it under the terms of the GNU General Public License\r
+ * 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
+ * ?><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
+/**\r
+ * @license http://nucleuscms.org/license.txt GNU General Public License\r
+ * @copyright Copyright (C) 2002-2009 The Nucleus Group\r
+ * @version $Id$\r
+ * $NucleusJP: install.php,v 1.7 2007/02/04 06:28:44 kimitake Exp $\r
+ */\r
+\r
+/*\r
+       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
+include('./install_lang_japanese.php');\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
+\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
+\r
+include_once('nucleus/libs/mysql.php');\r
+\r
+// check if mysql support is installed\r
+       if (!function_exists('mysql_query') ) {\r
+               _doError(_ERROR1);\r
+       }\r
+\r
+       if (postVar('action') == 'go') {\r
+               doInstall();\r
+       } else {\r
+               showInstallForm();\r
+       }\r
+\r
+exit;\r
+\r
+function showInstallForm() {\r
+       // 0. pre check if all necessary files exist\r
+       doCheckFiles();\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="application/xhtml+xml; charset=UTF-8" />\r
+               <title><?php echo _TITLE; ?></title>\r
+               <style type="text/css"><!--\r
+                       @import url('nucleus/documentation/styles/manual.css');\r
+               --></style>\r
+               <script type="text/javascript"><!--\r
+                       var submitcount = 0;\r
+\r
+                       // function to make sure the submit button only gets pressed once\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
+               <div style="text-align:center"><img src="./nucleus/styles/logo.gif" /></div> <!-- Nucleus logo -->\r
+               <form method="post" action="install.php">\r
+\r
+               <h1><?php echo _HEADER1; ?></h1>\r
+\r
+               <?php echo _TEXT1; ?>\r
+\r
+               <h1><?php echo _HEADER1_2 ?></h1>\r
+\r
+               <?php echo _TEXT1_2; ?>\r
+\r
+               <fieldset>\r
+                       <legend><?php echo _TEXT1_2_TAB_HEAD; ?></legend>\r
+                       <table>\r
+                               <tr>\r
+                                       <td><?php echo _TEXT1_2_TAB_FIELD1; ?></td>\r
+                                       <td>\r
+                                               <select name="charset" tabindex="10000">\r
+                                                       <option value="utf8" selected="selected">UTF-8</option>\r
+                                                       <option value="ujis" >EUC-JP</option>\r
+                                               </select>\r
+                                       </td>\r
+                               </tr>\r
+                       </table>\r
+               </fieldset>\r
+\r
+               <h1><?php echo _HEADER2; ?></h1>\r
+\r
+               <?php echo _TEXT2; ?>\r
+\r
+               <ul>\r
+                       <li>PHP:\r
+\r
+<?php\r
+       echo phpversion();\r
+       $minVersion = '4.0.6';\r
+\r
+       if (phpversion() < $minVersion) {\r
+               echo ' <span class="warning" style="display:block">' . sprintf(_TEXT2_WARN, $minVersion) . '</span>';\r
+       } elseif (phpversion() < '5') {\r
+               echo ' <span class="warning" style="display:block">' . _TEXT2_WARN3 . '</span>';\r
+       }\r
+?>\r
+\r
+                       </li>\r
+                       <li>MySQL:\r
+\r
+<?php\r
+       // note: this piece of code is taken from phpMyAdmin\r
+       $result = @mysql_query('SELECT VERSION() AS version');\r
+\r
+       if ($result != FALSE && @mysql_num_rows($result) > 0) {\r
+               $row   = mysql_fetch_array($result);\r
+               $match = explode('.', $row['version']);\r
+       } else {\r
+               $result = @mysql_query('SHOW VARIABLES LIKE \'version\'');\r
+\r
+               if ($result != FALSE && @mysql_num_rows($result) > 0) {\r
+                       $row   = mysql_fetch_row($result);\r
+                       $match = explode('.', $row[1]);\r
+               } else {\r
+                       $output = shell_exec('mysql -V');\r
+                       preg_match('@[0-9]+\.[0-9]+\.[0-9]+@', $output, $version);\r
+                       $match = explode('.', $version[0]);\r
+\r
+                       if ($match[0] == '') {\r
+                               $match[0] = '0';\r
+                               $match[1] = '0';\r
+                               $match[2] = '0';\r
+                       }\r
+               }\r
+       }\r
+\r
+       $mysqlVersion = implode($match, '.');\r
+       $minVersion = '3.23';\r
+\r
+       if ($mysqlVersion == '0.0.0') {\r
+               echo _NOTIFICATION1;\r
+       }\r
+       else {\r
+               echo $mysqlVersion;\r
+       }\r
+\r
+       if ($mysqlVersion < $minVersion) {\r
+               echo ' <span class="warning" style="display:block">' . sprintf(_TEXT2_WARN2, $minVersion) . '</span>';\r
+       }\r
+?>\r
+\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
+\r
+               <h1><?php echo _HEADER3; ?></h1>\r
+\r
+               <?php echo _TEXT3;\r
+\r
+} ?>\r
+\r
+               <h1><?php echo _HEADER4; ?></h1>\r
+\r
+               <?php echo _TEXT4; ?>\r
+\r
+               <fieldset>\r
+                       <legend><?php echo _TEXT4_TAB_HEAD; ?></legend>\r
+                       <table>\r
+                               <tr>\r
+                                       <td><?php echo _TEXT4_TAB_FIELD1; ?></td>\r
+                                       <td><input name="mySQL_host" value="<?php echo htmlspecialchars(@ini_get('mysql.default_host') )?>" tabindex="10010" /></td>\r
+                               </tr>\r
+                               <tr>\r
+                                       <td><?php echo _TEXT4_TAB_FIELD2; ?></td>\r
+                                       <td><input name="mySQL_user" /></td>\r
+                               </tr>\r
+                               <tr>\r
+                                       <td><?php echo _TEXT4_TAB_FIELD3; ?></td>\r
+                                       <td><input name="mySQL_password" type="password" tabindex="10030" /></td>\r
+                               </tr>\r
+                               <tr>\r
+                                       <td><?php echo _TEXT4_TAB_FIELD4; ?></td>\r
+                                       <td><input name="mySQL_database" tabindex="10040" /> (<input name="mySQL_create" value="1" type="checkbox" id="mySQL_create" tabindex="10050" /><label for="mySQL_create"><?php echo _TEXT4_TAB_FIELD4_ADD; ?></label>)</td>\r
+                               </tr>\r
+                       </table>\r
+               </fieldset>\r
+\r
+               <fieldset>\r
+                       <legend><?php echo _TEXT4_TAB2_HEAD; ?></legend>\r
+                       <table>\r
+                               <tr>\r
+                                       <td><input name="mySQL_usePrefix" value="1" type="checkbox" id="mySQL_usePrefix" tabindex="10060" /><label for="mySQL_usePrefix"><?php echo _TEXT4_TAB2_FIELD; ?></label></td>\r
+                                       <td><input name="mySQL_tablePrefix" value="" tabindex="10070" /></td>\r
+                               </tr>\r
+                       </table>\r
+\r
+                       <?php echo _TEXT4_TAB2_ADD; ?>\r
+\r
+               </fieldset>\r
+\r
+       <h1><?php echo _HEADER5; ?></h1>\r
+\r
+       <?php echo _TEXT5; ?>\r
+\r
+<?php\r
+\r
+       // no need to this all! dirname(__FILE__) is all we need -- moraes\r
+       /*\r
+       // discover full path\r
+       $fullPath = serverVar('PATH_TRANSLATED');\r
+\r
+       if ($fullPath == '') {\r
+               $fullPath = serverVar('SCRIPT_FILENAME');\r
+       }\r
+\r
+       $basePath = str_replace('install.php', '', $fullPath);\r
+       $basePath = replaceDoubleBackslash($basePath);\r
+       $basePath = replaceDoubleBackslash($basePath);\r
+\r
+       // add slash at end if necessary\r
+       if (!endsWithSlash($basePath) ) {\r
+               $basePath .= '/';\r
+       }\r
+       */\r
+\r
+       $basePath = dirname(__FILE__) . '/';\r
+?>\r
+\r
+               <fieldset>\r
+                       <legend><?php echo _TEXT5_TAB_HEAD; ?></legend>\r
+                       <table>\r
+                               <tr>\r
+                                       <td><?php echo _TEXT5_TAB_FIELD1; ?></td>\r
+                                       <td><input name="IndexURL" size="60" value="<?php\r
+                                               $url = 'http://' . serverVar('HTTP_HOST') . serverVar('PHP_SELF');\r
+                                               $url = str_replace('install.php', '', $url);\r
+                                               $url = replaceDoubleBackslash($url);\r
+\r
+                                               // add slash at end if necessary\r
+                                               if (!endsWithSlash($url) ) {\r
+                                                       $url .= '/';\r
+                                               }\r
+\r
+                                               echo $url; ?>" tabindex="10080" /></td>\r
+                               </tr>\r
+                               <tr>\r
+                                       <td><?php echo _TEXT5_TAB_FIELD2; ?></td>\r
+                                       <td><input name="AdminURL" size="60" value="<?php\r
+                                               if ($url) {\r
+                                                       echo $url . 'nucleus/';\r
+                                               } ?>" tabindex="10090" /></td>\r
+                               </tr>\r
+                               <tr>\r
+                                       <td><?php echo _TEXT5_TAB_FIELD3; ?></td>\r
+                                       <td><input name="AdminPath" size="60" value="<?php\r
+                                               if($basePath) {\r
+                                                       echo $basePath . 'nucleus/';\r
+                                               } ?>" tabindex="10100" /></td>\r
+                               </tr>\r
+                               <tr>\r
+                                       <td><?php echo _TEXT5_TAB_FIELD4; ?></td>\r
+                                       <td><input name="MediaURL" size="60" value="<?php\r
+                                               if ($url) {\r
+                                                       echo $url . 'media/';\r
+                                               } ?>" tabindex="10110" /></td>\r
+                               </tr>\r
+                               <tr>\r
+                                       <td><?php echo _TEXT5_TAB_FIELD5; ?></td>\r
+                                       <td><input name="MediaPath" size="60" value="<?php\r
+                                               if ($basePath) {\r
+                                                       echo $basePath . 'media/';\r
+                                               } ?>" tabindex="10120" /></td>\r
+                               </tr>\r
+                               <tr>\r
+                                       <td><?php echo _TEXT5_TAB_FIELD6; ?></td>\r
+                                       <td><input name="SkinsURL" size="60" value="<?php\r
+                                               if ($url) {\r
+                                                       echo $url . 'skins/';\r
+                                               } ?>" tabindex="10130" />\r
+                                               <br />(<?php echo _TEXT5_TAB_FIELD7_2; ?>)\r
+                                       </td>\r
+                               </tr>\r
+                               <tr>\r
+                                       <td><?php echo _TEXT5_TAB_FIELD7; ?></td>\r
+                                       <td><input name="SkinsPath" size="60" value="<?php\r
+                                               if ($basePath) {\r
+                                                       echo $basePath . 'skins/';\r
+                                               } ?>" tabindex="10140" />\r
+                                               <br />(<?php echo _TEXT5_TAB_FIELD7_2; ?>)\r
+                                       </td>\r
+                               </tr>\r
+                               <tr>\r
+                                       <td><?php echo _TEXT5_TAB_FIELD8; ?></td>\r
+                                       <td><input name="PluginURL" size="60" value="<?php\r
+                                               if ($url) {\r
+                                                       echo $url . 'nucleus/plugins/';\r
+                                               } ?>" tabindex="10150" /></td>\r
+                               </tr>\r
+                               <tr>\r
+                                       <td><?php echo _TEXT5_TAB_FIELD9; ?></td>\r
+                                       <td><input name="ActionURL" size="60" value="<?php\r
+                                               if ($url) {\r
+                                                       echo $url . 'action.php';\r
+                                               } ?>" tabindex="10160" />\r
+                                               <br />(<?php echo _TEXT5_TAB_FIELD9_2;?>)\r
+                                       </td>\r
+                               </tr>\r
+                       </table>\r
+               </fieldset>\r
+\r
+               <?php echo _TEXT5_2; ?>\r
+\r
+               <h1><? echo _HEADER6; ?></h1>\r
+\r
+               <?php echo _TEXT6; ?>\r
+\r
+               <fieldset>\r
+                       <legend><?php echo _TEXT6_TAB_HEAD; ?></legend>\r
+                       <table>\r
+                               <tr>\r
+                                       <td><?php echo _TEXT6_TAB_FIELD1; ?></td>\r
+                                       <td><input name="User_name" value="" tabindex="10170" /> <small>(<?php echo _TEXT6_TAB_FIELD1_2; ?>)</small></td>\r
+                               </tr>\r
+                               <tr>\r
+                                       <td><?php echo _TEXT6_TAB_FIELD2; ?></td>\r
+                                       <td><input name="User_realname" value="" tabindex="10180" /></td>\r
+                               </tr>\r
+                               <tr>\r
+                                       <td><?php echo _TEXT6_TAB_FIELD3; ?></td>\r
+                                       <td><input name="User_password" type="password" value="" tabindex="10190" /></td>\r
+                               </tr>\r
+                               <tr>\r
+                                       <td><?php echo _TEXT6_TAB_FIELD4; ?></td>\r
+                                       <td><input name="User_password2" type="password" value="" tabindex="10200" /></td>\r
+                               </tr>\r
+                               <tr>\r
+                                       <td><?php echo _TEXT6_TAB_FIELD5; ?></td>\r
+                                       <td><input name="User_email" value="" tabindex="10210" /> <small>(<?php echo _TEXT6_TAB_FIELD5_2; ?>)</small></td>\r
+                               </tr>\r
+                       </table>\r
+               </fieldset>\r
+\r
+               <h1><?php echo _HEADER7; ?></h1>\r
+\r
+               <?php echo _TEXT7; ?>\r
+\r
+               <fieldset>\r
+                       <legend><?php echo _TEXT7_TAB_HEAD; ?></legend>\r
+                       <table>\r
+                               <tr>\r
+                                       <td><?php echo _TEXT7_TAB_FIELD1; ?></td>\r
+                                       <td><input name="Blog_name" size="60" value="My Nucleus CMS" tabindex="10220" /></td>\r
+                               </tr>\r
+                               <tr>\r
+                                       <td><?php echo _TEXT7_TAB_FIELD2; ?></td>\r
+                                       <td><input name="Blog_shortname" value="mynucleuscms" tabindex="10230" /> <small>(<?php echo _TEXT7_TAB_FIELD2_2; ?>)</small></td>\r
+                               </tr>\r
+                       </table>\r
+               </fieldset>\r
+\r
+               <h1><?php echo _HEADER8; ?></h1>\r
+\r
+               <fieldset>\r
+                       <legend><?php echo _TEXT8_TAB_HEADER; ?></legend>\r
+                       <table>\r
+                               <tr>\r
+                                       <td><input name="Weblog_ping" value="1" type="checkbox" id="Weblog_ping" tabindex="10240" /><?php echo _TEXT8_TAB_FIELD1; ?></td>\r
+                               </tr>\r
+                       </table>\r
+               </fieldset>\r
+\r
+               <h1><?php echo _HEADER9; ?></h1>\r
+\r
+               <?php echo _TEXT9; ?>\r
+\r
+               <p><input name="action" value="go" type="hidden" /> <input type="submit" value="<?php echo _BUTTON1; ?>" onclick="return checkSubmit();" tabindex="10250" /></p>\r
+\r
+               </form>\r
+       </body>\r
+</html>\r
+\r
+<?php }\r
+\r
+function tableName($unPrefixed) {\r
+       global $mysql_usePrefix, $mysql_prefix;\r
+\r
+       if ($mysql_usePrefix == 1) {\r
+               return $mysql_prefix . $unPrefixed;\r
+       } else {\r
+               return $unPrefixed;\r
+       }\r
+}\r
+\r
+function doInstall() {\r
+       global $mysql_usePrefix, $mysql_prefix, $weblog_ping;\r
+\r
+       // 0. put all POST-vars into vars\r
+       $mysql_host        = postVar('mySQL_host');\r
+       $mysql_user        = postVar('mySQL_user');\r
+       $mysql_password    = postVar('mySQL_password');\r
+       $mysql_database    = postVar('mySQL_database');\r
+       $mysql_create      = postVar('mySQL_create');\r
+       $mysql_usePrefix   = postVar('mySQL_usePrefix');\r
+       $mysql_prefix      = postVar('mySQL_tablePrefix');\r
+       $config_indexurl   = postVar('IndexURL');\r
+       $config_adminurl   = postVar('AdminURL');\r
+       $config_adminpath  = postVar('AdminPath');\r
+       $config_mediaurl   = postVar('MediaURL');\r
+       $config_skinsurl   = postVar('SkinsURL');\r
+       $config_pluginurl  = postVar('PluginURL');\r
+       $config_actionurl  = postVar('ActionURL');\r
+       $config_mediapath  = postVar('MediaPath');\r
+       $config_skinspath  = postVar('SkinsPath');\r
+       $user_name         = postVar('User_name');\r
+       $user_realname     = postVar('User_realname');\r
+       $user_password     = postVar('User_password');\r
+       $user_password2    = postVar('User_password2');\r
+       $user_email        = postVar('User_email');\r
+       $blog_name         = postVar('Blog_name');\r
+       $blog_shortname    = postVar('Blog_shortname');\r
+       $charset           = postVar('charset');\r
+       $config_adminemail = $user_email;\r
+       $config_sitename   = $blog_name;\r
+       $weblog_ping       = postVar('Weblog_ping');\r
+\r
+       $_POST = array();\r
+       if ($charset == 'ujis') {\r
+               define('_CHARSET', 'EUC-JP');\r
+               $config_sitename = mb_convert_encoding($config_sitename, _CHARSET, 'UTF-8');\r
+               $user_realname  = mb_convert_encoding($user_realname, _CHARSET, 'UTF-8');\r
+               $blog_name      = mb_convert_encoding($blog_name, _CHARSET, 'UTF-8');\r
+       } else {\r
+               define('_CHARSET', 'UTF-8');\r
+       }\r
+\r
+       $config_indexurl   = replaceDoubleBackslash($config_indexurl);\r
+       $config_adminurl   = replaceDoubleBackslash($config_adminurl);\r
+       $config_mediaurl   = replaceDoubleBackslash($config_mediaurl);\r
+       $config_skinsurl   = replaceDoubleBackslash($config_skinsurl);\r
+       $config_pluginurl  = replaceDoubleBackslash($config_pluginurl);\r
+       $config_actionurl  = replaceDoubleBackslash($config_actionurl);\r
+       $config_adminpath  = replaceDoubleBackslash($config_adminpath);\r
+       $config_skinspath  = replaceDoubleBackslash($config_skinspath);\r
+       $config_mediapath  = replaceDoubleBackslash($config_mediapath);\r
+\r
+       // 1. check all the data\r
+       $errors = array();\r
+\r
+       if (!$mysql_database) {\r
+               array_push($errors, _ERROR2);\r
+       }\r
+\r
+       if (($mysql_usePrefix == 1) && (strlen($mysql_prefix) == 0) ) {\r
+               array_push($errors, _ERROR3);\r
+       }\r
+\r
+       if (($mysql_usePrefix == 1) && (!eregi('^[a-zA-Z0-9_]+$', $mysql_prefix) ) ) {\r
+               array_push($errors, _ERROR4);\r
+       }\r
+\r
+       // TODO: add action.php check\r
+       if (!endsWithSlash($config_indexurl) || !endsWithSlash($config_adminurl) || !endsWithSlash($config_mediaurl) || !endsWithSlash($config_pluginurl) || !endsWithSlash($config_skinsurl) ) {\r
+               array_push($errors, _ERROR5);\r
+       }\r
+\r
+       if (!endsWithSlash($config_adminpath) ) {\r
+               array_push($errors, _ERROR6);\r
+       }\r
+\r
+       if (!endsWithSlash($config_mediapath) ) {\r
+               array_push($errors, _ERROR7);\r
+       }\r
+\r
+       if (!endsWithSlash($config_skinspath) ) {\r
+               array_push($errors, _ERROR8);\r
+       }\r
+\r
+       if (!is_dir($config_adminpath) ) {\r
+               array_push($errors, _ERROR9);\r
+       }\r
+\r
+       if (!_isValidMailAddress($user_email) ) {\r
+               array_push($errors, _ERROR10);\r
+       }\r
+\r
+       if (!_isValidDisplayName($user_name) ) {\r
+               array_push($errors, _ERROR11);\r
+       }\r
+\r
+       if (!$user_password || !$user_password2) {\r
+               array_push($errors, _ERROR12);\r
+       }\r
+\r
+       if ($user_password != $user_password2) {\r
+               array_push($errors, _ERROR13);\r
+       }\r
+\r
+       if (!_isValidShortName($blog_shortname) ) {\r
+               array_push($errors, _ERROR14);\r
+       }\r
+\r
+       if (sizeof($errors) > 0) {\r
+               showErrorMessages($errors);\r
+       }\r
+\r
+       // 2-1. try to log in to mySQL\r
+       global $MYSQL_CONN;\r
+       $MYSQL_CONN = @mysql_connect($mysql_host, $mysql_user, $mysql_password);\r
+\r
+       if ($MYSQL_CONN == false) {\r
+               _doError(_ERROR15 . ': ' . mysql_error() );\r
+       }\r
+\r
+/*/ <add for garble measure>\r
+       // 2-2. set DEFAULT CHARSET and COLLATE\r
+       $mySqlVer = implode('.', array_map('intval', explode('.', mysql_get_server_info($MYSQL_CONN))));\r
+       if ($mySqlVer >= '5.0.7' && phpversion() >= '5.2.3') {\r
+               mysql_set_charset($charset);\r
+       } else {\r
+               mysql_query("SET NAMES " . $charset);\r
+       }\r
+       $collation = ($charset == 'utf8') ? 'utf8_unicode_ci' : 'ujis_japanese_ci';\r
+// </add for garble measure>*/\r
+\r
+       // 3. try to create database (if needed)\r
+       if ($mysql_create == 1) {\r
+               $sql = 'CREATE DATABASE '\r
+                        .     $mysql_database\r
+/*/ <add for garble measure>\r
+                        . ' DEFAULT CHARACTER SET '\r
+                        .     $charset\r
+                        . ' COLLATE '\r
+                        .     $collation\r
+// </add for garble measure>*/\r
+                        . '';\r
+               mysql_query($sql) or _doError(_ERROR16 . ': ' . mysql_error());\r
+       }\r
+\r
+       // 4. try to select database\r
+       mysql_select_db($mysql_database) or _doError(_ERROR17);\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
+       );\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
+       );\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
+       $count = count($queries);\r
+\r
+       for ($idx = 0; $idx < $count; $idx++) {\r
+               $query = trim($queries[$idx]);\r
+               // echo "QUERY = <small>" . htmlspecialchars($query) . "</small><p>";\r
+\r
+               if ($query) {\r
+\r
+                       if ($mysql_usePrefix == 1) {\r
+                                       $query = str_replace($aTableNames, $aTableNamesPrefixed, $query);\r
+                       }\r
+                       if ($mysql_create != 1 && strpos($query, 'CREATE TABLE') === 0) {\r
+                               $query .= ' DEFAULT CHARACTER SET ' . $charset . ' COLLATE ' . $collation;\r
+                       }\r
+\r
+                       mysql_query($query) or _doError(_ERROR30 . ' (<small>' . htmlspecialchars($query) . '</small>): ' . mysql_error() );\r
+               }\r
+       }\r
+\r
+       // 5a make first post\r
+       if ($charset == 'ujis') {\r
+               $itm_title = mb_convert_encoding(_1ST_POST_TITLE, _CHARSET, 'UTF-8');\r
+               $itm_body  = mb_convert_encoding(_1ST_POST, _CHARSET, 'UTF-8');\r
+               $itm_more  = mb_convert_encoding(_1ST_POST2, _CHARSET, 'UTF-8');\r
+       } else {\r
+               $itm_title = _1ST_POST_TITLE;\r
+               $itm_body  = _1ST_POST;\r
+               $itm_more  = _1ST_POST2;\r
+       }\r
+       $newpost = "INSERT INTO "\r
+                        . tableName('nucleus_item')\r
+                        . " VALUES ("\r
+                        . "1, "\r
+                        . "'" . $itm_title . "',"\r
+                        . " '" . $itm_body . "',"\r
+                        . " '" . $itm_more . "',"\r
+                        . " 1, 1, '2005-08-15 11:04:26', 0, 0, 0, 1, 0, 1);";\r
+       mysql_query($newpost) or _doError(_ERROR18 . ' (<small>' . htmlspecialchars($newpost) . '</small>): ' . mysql_error() );\r
+\r
+       // 6. update global settings\r
+       updateConfig('IndexURL',   $config_indexurl);\r
+       updateConfig('AdminURL',   $config_adminurl);\r
+       updateConfig('MediaURL',   $config_mediaurl);\r
+       updateConfig('SkinsURL',   $config_skinsurl);\r
+       updateConfig('PluginURL',  $config_pluginurl);\r
+       updateConfig('ActionURL',  $config_actionurl);\r
+       updateConfig('AdminEmail', $config_adminemail);\r
+       updateConfig('SiteName',   $config_sitename);\r
+       if ($charset == 'ujis') {\r
+               updateConfig('Language',   'japanese-euc');\r
+       }\r
+\r
+       // 7. update GOD member\r
+       $query = 'UPDATE ' . tableName('nucleus_member')\r
+                  . " SET mname     = '" . addslashes($user_name) . "',"\r
+                  . " mrealname     = '" . addslashes($user_realname) . "',"\r
+                  . " mpassword     = '" . md5(addslashes($user_password) ) . "',"\r
+                  . " murl          = '" . addslashes($config_indexurl) . "',"\r
+                  . " memail        = '" . addslashes($user_email) . "',"\r
+                  . " madmin        = 1,"\r
+                  . " mcanlogin     = 1"\r
+                  . " WHERE"\r
+                  . " mnumber       = 1";\r
+\r
+       mysql_query($query) or _doError(_ERROR19 . ': ' . mysql_error() );\r
+\r
+       // 8. update weblog settings\r
+       $query = 'UPDATE ' . tableName('nucleus_blog')\r
+                  . " SET bname  = '" . addslashes($blog_name) . "',"\r
+                  . " bshortname = '" . addslashes($blog_shortname) . "',"\r
+                  . " burl       = '" . addslashes($config_indexurl) . "'"\r
+                  . " WHERE"\r
+                  . " bnumber    = 1";\r
+\r
+       mysql_query($query) or _doError(_ERROR20 . ': ' . mysql_error() );\r
+\r
+       // 8-2. update category settings\r
+       if ($charset == 'ujis') {\r
+               $cat_name = mb_convert_encoding(_GENERALCAT_NAME, _CHARSET, 'UTF-8');\r
+               $cat_desc = mb_convert_encoding(_GENERALCAT_DESC, _CHARSET, 'UTF-8');\r
+       } else {\r
+               $cat_name = _GENERALCAT_NAME;\r
+               $cat_desc = _GENERALCAT_DESC;\r
+       }\r
+       $query = 'UPDATE ' . tableName('nucleus_category')\r
+                  . " SET cname  = '" . $cat_name . "',"\r
+                  . " cdesc      = '" . $cat_desc . "'"\r
+                  . " WHERE"\r
+                  . " catid      = 1";\r
+\r
+       mysql_query($query) or _doError(_ERROR20 . ': ' . mysql_error() );\r
+\r
+       // 9. update item date\r
+       $query = 'UPDATE ' . tableName('nucleus_item')\r
+                  . " SET   itime   = '" . date('Y-m-d H:i:s', time() ) ."'"\r
+                  . " WHERE inumber = 1";\r
+\r
+       mysql_query($query) or _doError(_ERROR21 . ': ' . mysql_error() );\r
+\r
+       global $aConfPlugsToInstall, $aConfSkinsToImport;\r
+       $aSkinErrors = array();\r
+       $aPlugErrors = array();\r
+\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
+\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
+\r
+               global $DIR_NUCLEUS, $DIR_MEDIA, $DIR_SKINS, $DIR_PLUGINS, $DIR_LANG, $DIR_LIBS;\r
+\r
+               $DIR_NUCLEUS = $config_adminpath;\r
+               $DIR_MEDIA   = $config_mediapath;\r
+               $DIR_SKINS   = $config_skinspath;\r
+               $DIR_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 NP_Ping, if decided\r
+               if ($weblog_ping == 1) {\r
+                       global $aConfPlugsToInstall;\r
+                       array_push($aConfPlugsToInstall, "NP_Ping");\r
+               }\r
+\r
+               // 13. install custom plugins\r
+               $aPlugErrors = installCustomPlugs($manager);\r
+       }\r
+\r
+       // 14. Write config file ourselves (if possible)\r
+       $bConfigWritten = 0;\r
+\r
+       if (@file_exists('config.php') && is_writable('config.php') && $fp = @fopen('config.php', 'w') ) {\r
+               $config_data = '<' . '?php' . "\n\n";\r
+               //$config_data .= "\n"; (extraneous, just added extra \n to previous line\r
+               $config_data .= "       // mySQL connection information\n";\r
+               $config_data .= "       \$MYSQL_HOST     = '" . $mysql_host . "';\n";\r
+               $config_data .= "       \$MYSQL_USER     = '" . $mysql_user . "';\n";\r
+               $config_data .= "       \$MYSQL_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
+?>\r
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">\r
+<html xmlns="http://www.w3.org/1999/xhtml">\r
+<head>\r
+       <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />\r
+       <title><?php echo _TITLE; ?></title>\r
+       <style>@import url('nucleus/styles/manual.css');</style>\r
+</head>\r
+<body>\r
+       <div style='text-align:center'><img src='./nucleus/styles/logo.gif' /></div> <!-- Nucleus logo -->\r
+\r
+<?php\r
+       $aAllErrors = array_merge($aSkinErrors, $aPlugErrors);\r
+\r
+       if (count($aAllErrors) > 0) {\r
+               echo '<h1>' . _TITLE2 . '</h1>';\r
+               echo '<ul><li>' . implode('</li><li>', $aAllErrors) . '</li></ul>';\r
+       }\r
+\r
+       if (!$bConfigWritten) { ?>\r
+               <h1><?php echo _TITLE3; ?></h1>\r
+\r
+               <? echo _TEXT10; ?>\r
+\r
+               <pre><code>&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;</code></pre>\r
+\r
+       <?php echo _TEXT11; ?>\r
+\r
+       <div class="note">\r
+       <?php echo _TEXT12; ?>\r
+       </div>\r
+\r
+<?php } else { ?>\r
+\r
+       <h1><?php echo _TITLE4; ?></h1>\r
+\r
+       <?php echo _TEXT13; ?>\r
+\r
+<?php } ?>\r
+\r
+       <h1><?php echo _TITLE5; ?></h1>\r
+       \r
+       <?php echo _TEXT14; ?>\r
+\r
+       <ul>\r
+               <li><?php echo _TEXT14_L1; ?></li>\r
+               <li><?php echo _TEXT14_L2; ?></li>\r
+       </ul>\r
+\r
+       <h1><?php echo _HEADER10; ?></h1>\r
+\r
+       <?php echo _TEXT15; ?>\r
+\r
+               <ul>\r
+               <li><?php echo _TEXT15_L1; ?></li>\r
+               <li><?php echo _TEXT15_L2; ?></li>\r
+               </ul>\r
+\r
+       <?php echo _TEXT15_EX; ?>\r
+\r
+       <h1><?php echo _HEADER11; ?></h1>\r
+\r
+       <p><?php echo _TEXT16; ?>\r
+               <ul>\r
+                       <li><a href="<?php echo $config_adminurl?>"><?php echo _TEXT16_L1; ?></a></li>\r
+                       <li><a href="<?php echo $config_indexurl?>"><?php echo _TEXT16_L2; ?></a></li>\r
+               </ul>\r
+       </p>\r
+\r
+</body>\r
+</html>\r
+\r
+<?php\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
+\r
+       $res = sql_query('SELECT * FROM ' . sql_table('plugin') );\r
+       $numCurrent = mysql_num_rows($res);\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
+               $manager->clearCachedInfo('installedPlugins');\r
+               $plugin =& $manager->getPlugin($plugName);\r
+               $plugin->plugid = $numCurrent;\r
+\r
+               if (!$plugin) {\r
+                       sql_query('DELETE FROM ' . sql_table('plugin') . ' WHERE pfile=\'' . addslashes($plugName) . '\'');\r
+                       $numCurrent--;\r
+                       array_push($aErrors, _ERROR22 . $plugName);\r
+                       continue;\r
+               }\r
+\r
+               $plugin->install();\r
+       }\r
+\r
+       // SYNC PLUGIN EVENT LIST\r
+       sql_query('DELETE FROM ' . sql_table('plugin_event') );\r
+\r
+       // loop over all installed plugins\r
+       $res = sql_query('SELECT pid, pfile FROM ' . sql_table('plugin') );\r
+\r
+       while($o = mysql_fetch_object($res) ) {\r
+               $pid  =  $o->pid;\r
+               $plug =& $manager->getPlugin($o->pfile);\r
+\r
+               if ($plug) {\r
+                       $eventList = $plug->getEventList();\r
+\r
+                       foreach ($eventList as $eventName) {\r
+                               sql_query('INSERT INTO ' . sql_table('plugin_event') . ' (pid, event) VALUES (' . $pid . ', \'' . $eventName . '\')');\r
+                       }\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
+\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
+               $skinFile = $DIR_SKINS . $skinName . '/skinbackup.xml';\r
+\r
+               if (!@file_exists($skinFile) ) {\r
+                       array_push($aErrors, _ERROR23_1 . $skinFile . ' : ' . _ERROR23_2);\r
+                       continue;\r
+               }\r
+\r
+               $error = $importer->readFile($skinFile);\r
+\r
+               if ($error) {\r
+                       array_push($aErrors, _ERROR24 . $skinName . ' : ' . $error);\r
+                       continue;\r
+               }\r
+\r
+               $error = $importer->writeToDatabase(1);\r
+\r
+               if ($error) {\r
+                       array_push($aErrors, _ERROR24 . $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
+       $files = array(\r
+               'install.sql',\r
+               'index.php',\r
+               'action.php',\r
+               'nucleus/index.php',\r
+               'nucleus/libs/globalfunctions.php',\r
+               'nucleus/libs/ADMIN.php',\r
+               'nucleus/libs/BLOG.php',\r
+               'nucleus/libs/COMMENT.php',\r
+               'nucleus/libs/COMMENTS.php',\r
+               'nucleus/libs/ITEM.php',\r
+               'nucleus/libs/MEMBER.php',\r
+               'nucleus/libs/SKIN.php',\r
+               'nucleus/libs/TEMPLATE.php',\r
+               'nucleus/libs/MEDIA.php',\r
+               'nucleus/libs/ACTIONLOG.php',\r
+               'nucleus/media.php'\r
+       );\r
+\r
+       $count = count($files);\r
+\r
+       for ($i = 0; $i < $count; $i++) {\r
+               if (!is_readable($files[$i]) ) {\r
+                       array_push($missingfiles, _ERROR25_1 . $files[$i] . _ERROR25_2);\r
+               }\r
+       }\r
+\r
+// The above code replaces several if statements of the form:\r
+\r
+//     if (!is_readable('install.sql') ) {\r
+//             array_push($missingfiles, 'File <b>install.sql</b> is missing or not readable');\r
+//     }\r
+\r
+       if (count($missingfiles) > 0) {\r
+               showErrorMessages($missingfiles);\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(_ERROR26 . ': ' . mysql_error() );\r
+       return mysql_insert_id();\r
+}\r
+\r
+function replaceDoubleBackslash($input) {\r
+       return str_replace('\\', '/', $input);\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
+\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
+\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
+\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=<?php echo _CHARSET ?>" />\r
+       <title><?php echo _TITLE; ?></title>\r
+       <style>@import url('nucleus/styles/manual.css');</style>\r
+</head>\r
+<body>\r
+       <div style='text-align:center'><img src='./nucleus/styles/logo.gif' /></div> <!-- Nucleus logo -->\r
+       <h1><?php echo _ERROR27; ?></h1>\r
+\r
+       <p><?php echo _ERROR28; ?>: "<?php echo $msg?>";</p>\r
+\r
+       <p><a href="install.php" onclick="history.back();"><?php echo _TEXT17; ?></a></p>\r
+</body>\r
+</html>\r
+\r
+<?php\r
+       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=<?php echo _CHARSET ?>" />\r
+       <title><?php echo _TITLE; ?></title>\r
+       <style>@import url('nucleus/styles/manual.css');</style>\r
+</head>\r
+<body>\r
+       <div style='text-align:center'><img src='./nucleus/styles/logo.gif' /></div> <!-- Nucleus logo -->\r
+       <h1><?php echo _ERROR27; ?></h1>\r
+\r
+       <p><?php echo _ERROR29; ?>:</p>\r
+\r
+       <ul>\r
+\r
+<?php\r
+       while($msg = array_shift($errors) ) {\r
+               echo '<li>' . $msg . '</li>';\r
+       }\r
+?>\r
+\r
+       </ul>\r
+\r
+       <p><a href="install.php" onclick="history.back();return false;"><?php echo _TEXT17; ?></a></p>\r
+</body>\r
+</html>\r
+\r
+<?php\r
+       exit;\r
+}\r
+\r
+/* for the non-php systems that decide to show the contents:\r
+?></div><?php  */\r
+\r
 ?>
\ No newline at end of file