Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?PHP
- $config['site'] = parse_ini_file('config/config.ini');
- session_start();
- //save config in ini file
- function saveconfig_ini($config) {
- $file = fopen("config/config.ini", "w");
- foreach($config as $param => $data) {
- $file_data .= $param.' = "'.str_replace('"', '', $data).'"
- ';
- }
- rewind($file);
- fwrite($file, $file_data);
- fclose($file);
- }
- function check_password($pass)
- {
- $temp = strspn("$pass", "qwertyuiopasdfghjklzxcvbnmQWERTYUIOPASDFGHJKLZXCVBNM1234567890");
- if ($temp != strlen($pass)) {
- return false;
- }
- else
- {
- $ok = "/[a-zA-Z0-9]{1,40}/";
- return (preg_match($ok, $pass))? true: false;
- }
- }
- function password_ency($password)
- {
- $ency = $GLOBALS['passwordency'];
- if($ency == 'sha1')
- return sha1($password);
- elseif($ency == 'md5')
- return md5($password);
- elseif($ency == '')
- return $password;
- }
- if($_REQUEST['page'] == '' && !isset($_REQUEST['step'])) {
- echo '<html>
- <head>
- <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-2" />
- <title>Installation of account maker</title>
- </head>
- <frameset cols="230,*">
- <frame name="menu" src="install.php?page=menu" />
- <frame name="step" src="install.php?page=step&step=0" />
- <noframes><body>Frames don\'t work. Install Firefox :P</body></noframes>
- </frameset>
- </html>';
- }
- if($_REQUEST['page'] == 'menu') {
- echo '<h2>MENU</h2><br>
- <b>IF NOT INSTALLED:</b><br>
- <a href="install.php?page=step&step=start" target="step">0. Informations</a><br>
- <a href="install.php?page=step&step=1" target="step">1. Set server path</a><br>
- <a href="install.php?page=step&step=2" target="step">2. Check DataBase connection</a><br>
- <a href="install.php?page=step&step=3&server_conf=yes" target="step">3. Add tables and columns to DB</a><br>
- <a href="install.php?page=step&step=4&server_conf=yes" target="step">4. Add samples to DB</a><br>
- <a href="install.php?page=step&step=5&server_conf=yes" target="step">5. Set Admin Account</a><br>
- <b>FOR ADMINS:</b><br>
- <a href="index.php?subtopic=adminpanel&action=install_monsters" target="step">6. Load Monsters from OTS</a><br>
- <a href="index.php?subtopic=adminpanel&action=install_spells" target="step">7. Load Spells from OTS</a><br>';
- }
- if($_REQUEST['page'] == 'step') {
- if($config['site']['install'] != "no") {
- if($_REQUEST['server_conf'] == 'yes' || ($_REQUEST['step'] > 2 && $_REQUEST['step'] < 6)) {
- //load server config
- $config['server'] = parse_ini_file($config['site']['server_path'].'config.lua');
- if(isset($config['server']['mysqlHost'])) {
- //new (0.2.6+) ots config.lua file
- $mysqlhost = $config['server']['mysqlHost'];
- $mysqluser = $config['server']['mysqlUser'];
- $mysqlpass = $config['server']['mysqlPass'];
- $mysqldatabase = $config['server']['mysqlDatabase'];
- }
- elseif(isset($config['server']['sqlHost'])) {
- //old (0.2.4) ots config.lua file
- $mysqlhost = $config['server']['sqlHost'];
- $mysqluser = $config['server']['sqlUser'];
- $mysqlpass = $config['server']['sqlPass'];
- $mysqldatabase = $config['server']['sqlDatabase'];
- }
- $sqlitefile = $config['server']['sqliteDatabase'];
- $passwordency = '';
- if(strtolower($config['server']['useMD5Passwords']) == 'yes' || strtolower($config['server']['passwordType']) == 'md5') {
- $passwordency = 'md5';
- }
- if(strtolower($config['server']['passwordType']) == 'sha1') {
- $passwordency = 'sha1';
- }
- // loads #####POT mainfile#####
- include('pot/OTS.php');
- // PDO and POT connects to database
- $ots = POT::getInstance();
- if(strtolower($config['server']['sqlType']) == "mysql")
- {
- //connect to MySQL database
- try
- {
- $ots->connect(POT::DB_MYSQL, array('host' => $mysqlhost, 'user' => $mysqluser, 'password' => $mysqlpass, 'database' => $mysqldatabase) );
- }
- catch(PDOException $error)
- {
- echo 'Database error - can\'t connect to MySQL database. Possible reasons:<br>1. MySQL server is not running on host.<br>2. MySQL user, password, database or host isn\'t configured in: <b>'.$config['site']['server_path'].'config.lua</b> .<br>3. MySQL user, password, database or host is wrong.';
- exit;
- }
- }
- elseif(strtolower($config['server']['sqlType']) == "sqlite")
- {
- //connect to SQLite database
- $link_to_sqlitedatabase = $config['site']['server_path'].$sqlitefile;
- try
- {
- $ots->connect(POT::DB_SQLITE, array('database' => $link_to_sqlitedatabase));
- }
- catch(PDOException $error)
- {
- echo 'Database error - can\'t open SQLite database. Possible reasons:<br><b>'.$link_to_sqlitedatabase.'</b> - file isn\'t valid SQLite database.<br><b>'.$link_to_sqlitedatabase.'</b> - doesn\'t exist.';
- exit;
- }
- }
- else
- {
- echo 'Database error. Unknown database type in <b>'.$config['site']['server_path'].'config.lua</b> . Must be equal to: "<b>mysql</b>" or "<b>sqlite</b>". Now is: "<b>'.strtolower($config['server']['sqlType']).'"</b>';
- exit;
- }
- $SQL = POT::getInstance()->getDBHandle();
- }
- $step = $_REQUEST['step'];
- if(empty($step)) {
- $step = $config['site']['install'];
- }
- if($step == 'start') {
- echo '<h1>STEP '.$step.'</h1>Informations<br>';
- echo 'Welcome to Gesior Account Maker installer. <b>First do steps 1-5 one by one, later (when you will be logged on admin account) press on links to steps 6-11 to load configuration from OTS.</b>';
- }
- if($step == '1') {
- if(isset($_REQUEST['server_path'])) {
- echo '<h1>STEP '.$step.'</h1>Check server configuration<br>';
- $config['site']['server_path'] = $_REQUEST['server_path'];
- $config['site']['server_path'] = trim($config['site']['server_path'])."\\";
- $config['site']['server_path'] = str_replace("\\\\", "/", $config['site']['server_path']);
- $config['site']['server_path'] = str_replace("\\", "/", $config['site']['server_path']);
- $config['site']['server_path'] = str_replace("//", "/", $config['site']['server_path']);
- saveconfig_ini($config['site']);
- if(file_exists($config['site']['server_path'].'config.lua')) {
- $config['server'] = parse_ini_file($config['site']['server_path'].'config.lua');
- if(isset($config['server']['sqlType'])) {
- $config['site']['install'] = 2;
- saveconfig_ini($config['site']);
- echo 'File <b>config.lua</b> loaded from <font color="red"><i>'.$config['site']['server_path'].'config.lua</i></font> and looks like fine server config file. Now you can check database('.$config['server']['sqlType'].') connection: <a href="install.php?page=step&step=2">STEP 2 - check database connection</a>';
- }
- else
- {
- echo 'File <b>config.lua</b> loaded from <font color="red"><i>'.$config['site']['server_path'].'config.lua</i></font> and it\'s not valid TFS config.lua file. <a href="install.php?page=step&step=1">Go to STEP 1 - select other directory.</a> If it\'s your config.lua file from TFS contact with acc. maker author.';
- }
- }
- else
- {
- echo 'Can\'t load file <b>config.lua</b> from <font color="red"><i>'.$config['site']['server_path'].'config.lua</i></font> File doesn\'t exist in selected directory. <a href="install.php?page=step&step=1">Go to STEP 1 - select other directory.</a>';
- }
- }
- else
- {
- echo 'Please write you TFS directory below. Like: <i>C:\Documents and Settings\Gesior\Desktop\TFS 0.2.9\</i><form action="install.php">
- <input type="text" name="server_path" size="90" value="'.$config['site']['server_path'].'" /><input type="hidden" name="page" value="step" /><input type="hidden" name="step" value="1" /><input type="submit" value="Set server path" />
- </form>';
- }
- }
- if($step == '2') {
- echo '<h1>STEP '.$step.'</h1>Check database connection<br>';
- echo 'If you don\'t see any errors press <a href="install.php?page=step&step=3&server_conf=yes">link to STEP 3 - Add tables and columns to DB</a>. If you see some errors it mean server has wrong configuration. Check FAQ or ask author of acc. maker.';
- //load server config
- $config['server'] = parse_ini_file($config['site']['server_path'].'config.lua');
- if(isset($config['server']['mysqlHost'])) {
- //new (0.2.6+) ots config.lua file
- $mysqlhost = $config['server']['mysqlHost'];
- $mysqluser = $config['server']['mysqlUser'];
- $mysqlpass = $config['server']['mysqlPass'];
- $mysqldatabase = $config['server']['mysqlDatabase'];
- }
- elseif(isset($config['server']['sqlHost'])) {
- //old (0.2.4) ots config.lua file
- $mysqlhost = $config['server']['sqlHost'];
- $mysqluser = $config['server']['sqlUser'];
- $mysqlpass = $config['server']['sqlPass'];
- $mysqldatabase = $config['server']['sqlDatabase'];
- }
- $sqlitefile = $config['server']['sqliteDatabase'];
- $passwordency = '';
- if(strtolower($config['server']['useMD5Passwords']) == 'yes' || strtolower($config['server']['passwordType']) == 'md5') {
- $passwordency = 'md5';
- }
- if(strtolower($config['server']['passwordType']) == 'sha1') {
- $passwordency = 'sha1';
- }
- // loads #####POT mainfile#####
- include('pot/OTS.php');
- // PDO and POT connects to database
- $ots = POT::getInstance();
- if(strtolower($config['server']['sqlType']) == "mysql")
- {
- //connect to MySQL database
- try
- {
- $ots->connect(POT::DB_MYSQL, array('host' => $mysqlhost, 'user' => $mysqluser, 'password' => $mysqlpass, 'database' => $mysqldatabase) );
- }
- catch(PDOException $error)
- {
- echo 'Database error - can\'t connect to MySQL database. Possible reasons:<br>1. MySQL server is not running on host.<br>2. MySQL user, password, database or host isn\'t configured in: <b>'.$config['site']['server_path'].'config.lua</b> .<br>3. MySQL user, password, database or host is wrong.';
- exit;
- }
- }
- elseif(strtolower($config['server']['sqlType']) == "sqlite")
- {
- //connect to SQLite database
- $link_to_sqlitedatabase = $config['site']['server_path'].$sqlitefile;
- try
- {
- $ots->connect(POT::DB_SQLITE, array('database' => $link_to_sqlitedatabase));
- }
- catch(PDOException $error)
- {
- echo 'Database error - can\'t open SQLite database. Possible reasons:<br><b>'.$link_to_sqlitedatabase.'</b> - file isn\'t valid SQLite database.<br><b>'.$link_to_sqlitedatabase.'</b> - doesn\'t exist.';
- exit;
- }
- }
- else
- {
- echo 'Database error. Unknown database type in <b>'.$config['site']['server_path'].'config.lua</b> . Must be equal to: "<b>mysql</b>" or "<b>sqlite</b>". Now is: "<b>'.strtolower($config['server']['sqlType']).'"</b>';
- exit;
- }
- $SQL = POT::getInstance()->getDBHandle();
- $config['site']['install'] = 3;
- saveconfig_ini($config['site']);
- }
- if($step == '3') {
- echo '<h1>STEP '.$step.'</h1>Add tables and columns to DB<br>';
- echo 'Installer try to add new tables and columns to database.<br>';
- $config['server'] = parse_ini_file($config['site']['server_path'].'config.lua');
- if($config['server']['sqlType'] == "sqlite") {
- //if sqlite
- try { $SQL->query('ALTER TABLE accounts ADD "key" VARCHAR(255) NOT NULL DEFAULT "";'); } catch(PDOException $error) {}
- try { $SQL->query('ALTER TABLE accounts ADD "page_lastday" INTEGER(11) NOT NULL DEFAULT 0;'); } catch(PDOException $error) {}
- try { $SQL->query('ALTER TABLE accounts ADD "email_new" VARCHAR(255) NOT NULL DEFAULT "";'); } catch(PDOException $error) {}
- try { $SQL->query('ALTER TABLE accounts ADD "email_new_time" INTEGER(15) NOT NULL DEFAULT 0;'); } catch(PDOException $error) {}
- try { $SQL->query('ALTER TABLE accounts ADD "created" INTEGER(11) NOT NULL DEFAULT 0;'); } catch(PDOException $error) {}
- try { $SQL->query('ALTER TABLE accounts ADD "rlname" VARCHAR(255) NOT NULL DEFAULT "";'); } catch(PDOException $error) {}
- try { $SQL->query('ALTER TABLE accounts ADD "location" VARCHAR(255) NOT NULL DEFAULT "";'); } catch(PDOException $error) {}
- try { $SQL->query('ALTER TABLE accounts ADD "page_access" INTEGER(11) NOT NULL DEFAULT 0;'); } catch(PDOException $error) {}
- try { $SQL->query('ALTER TABLE accounts ADD "email_code" VARCHAR(255) NOT NULL DEFAULT 0;'); } catch(PDOException $error) {}
- try { $SQL->query('ALTER TABLE accounts ADD "next_email" INTEGER(11) NOT NULL DEFAULT 0;'); } catch(PDOException $error) {}
- try { $SQL->query('ALTER TABLE accounts ADD "premium_points" INTEGER(11) NOT NULL DEFAULT 0;'); } catch(PDOException $error) {}
- echo "Added columns to table <b>accounts</b>.<br/>";
- try { $SQL->query('ALTER TABLE guilds ADD "description" TEXT NOT NULL DEFAULT "";'); } catch(PDOException $error) {}
- try { $SQL->query('ALTER TABLE guilds ADD "logo_gfx_name" VARCHAR(255) NOT NULL DEFAULT "";'); } catch(PDOException $error) {}
- echo "Added columns to table <b>guilds</b>.<br/>";
- try { $SQL->query('ALTER TABLE players ADD "online" INTEGER(11) NOT NULL DEFAULT 0;'); } catch(PDOException $error) {}
- try { $SQL->query('ALTER TABLE players ADD "created" INTEGER(11) NOT NULL DEFAULT 0;'); } catch(PDOException $error) {}
- try { $SQL->query('ALTER TABLE players ADD "nick_verify" INTEGER(11) NOT NULL DEFAULT 0;'); } catch(PDOException $error) {}
- try { $SQL->query('ALTER TABLE players ADD "old_name" VARCHAR(255) NOT NULL DEFAULT "";'); } catch(PDOException $error) {}
- try { $SQL->query('ALTER TABLE players ADD "hide_char" INTEGER(11) NOT NULL DEFAULT 0;'); } catch(PDOException $error) {}
- try { $SQL->query('ALTER TABLE players ADD "comment" TEXT NOT NULL DEFAULT "";'); } catch(PDOException $error) {}
- echo "Added columns to table <b>players</b>.<br/>";
- try { $SQL->query('CREATE TABLE "z_news_big" (
- "hide_news" INTEGER NOT NULL DEFAULT 0,
- "date" INTEGER NOT NULL,
- "author" VARCHAR(255) NOT NULL,
- "author_id" INTEGER NOT NULL,
- "image_id" INTEGER NOT NULL DEFAULT 0,
- "topic" VARCHAR(255) NOT NULL,
- "text" TEXT NOT NULL);'); } catch(PDOException $error) {}
- echo "Added table <b>z_news_big</b> (news).<br/>";
- try { $SQL->query('CREATE TABLE "z_news_tickers" (
- "date" INTEGER NOT NULL,
- "author" INTEGER NOT NULL,
- "image_id" INTEGER NOT NULL DEFAULT 0,
- "text" TEXT NOT NULL,
- "hide_ticker" INTEGER NOT NULL DEFAULT 0);'); } catch(PDOException $error) {}
- echo "Added table <b>z_news_tickers</b> (tickers).<br/>";
- try { $SQL->query('CREATE TABLE "z_spells" (
- "name" VARCHAR(255) NOT NULL,
- "spell" VARCHAR(255) NOT NULL,
- "spell_type" VARCHAR(255) NOT NULL,
- "mana" INTEGER NOT NULL DEFAULT 0,
- "lvl" INTEGER NOT NULL DEFAULT 0,
- "mlvl" INTEGER NOT NULL DEFAULT 0,
- "soul" INTEGER NOT NULL DEFAULT 0,
- "pacc" VARCHAR(255) NOT NULL,
- "vocations" VARCHAR(255) NOT NULL,
- "conj_count" INTEGER NOT NULL DEFAULT 0,
- "hide_spell" INTEGER NOT NULL DEFAULT 0);'); } catch(PDOException $error) {}
- echo "Added table <b>z_spells</b> (spells list).<br/>";
- try { $SQL->query('CREATE TABLE "z_monsters" (
- "hide_creature" INTEGER NOT NULL DEFAULT 0,
- "name" VARCHAR(255) NOT NULL,
- "mana" INTEGER NOT NULL,
- "exp" INTEGER NOT NULL,
- "health" INTEGER NOT NULL,
- "speed_lvl" INTEGER NOT NULL DEFAULT 1,
- "use_haste" INTEGER NOT NULL,
- "voices" text NOT NULL,
- "immunities" VARCHAR(255) NOT NULL,
- "summonable" INTEGER NOT NULL,
- "convinceable" INTEGER NOT NULL,
- "race" VARCHAR(255) NOT NULL,
- "gfx_name" VARCHAR(255) NOT NULL)'); } catch(PDOException $error) {}
- echo "Added table <b>z_monsters</b> (monsters list).<br/>";
- }
- elseif($config['server']['sqlType'] == "mysql")
- {
- //if mysql
- echo "<h3>Add columns to table <b>accounts</b></h3>";
- try { $SQL->query("ALTER TABLE `accounts` ADD `key` VARCHAR( 20 ) NOT NULL DEFAULT '0';"); echo "<font color=\"green\">Added column</font> <b>key</b> to table <b>accounts</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>key</b> to table <b>accounts</b>, already exist?<br/>";}
- try { $SQL->query("ALTER TABLE `accounts` ADD `page_lastday` INT( 11 ) NOT NULL;"); echo "<font color=\"green\">Added column</font> <b>page_lastday</b> to table <b>accounts</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>page_lastday</b> to table <b>accounts</b>, already exist?<br/>";}
- try { $SQL->query("ALTER TABLE `accounts` ADD `email_new` VARCHAR( 255 ) NOT NULL;"); echo "<font color=\"green\">Added column</font> <b>email_new</b> to table <b>accounts</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>email_new</b> to table <b>accounts</b>, already exist?<br/>";}
- try { $SQL->query("ALTER TABLE `accounts` ADD `email_new_time` INT( 15 ) NOT NULL;"); echo "<font color=\"green\">Added column</font> <b>email_new_time</b> to table <b>accounts</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>email_new_time</b> to table <b>accounts</b>, already exist?<br/>";}
- try { $SQL->query("ALTER TABLE `accounts` ADD `created` INT( 11 ) NOT NULL DEFAULT '0';"); echo "<font color=\"green\">Added column</font> <b>created</b> to table <b>accounts</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>created</b> to table <b>accounts</b>, already exist?<br/>";}
- try { $SQL->query("ALTER TABLE `accounts` ADD `rlname` VARCHAR( 255 ) NOT NULL DEFAULT '';"); echo "<font color=\"green\">Added column</font> <b>rlname</b> to table <b>accounts</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>rlname</b> to table <b>accounts</b>, already exist?<br/>";}
- try { $SQL->query("ALTER TABLE `accounts` ADD `location` VARCHAR( 255 ) NOT NULL DEFAULT '';"); echo "<font color=\"green\">Added column</font> <b>location</b> to table <b>accounts</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>location</b> to table <b>accounts</b>, already exist?<br/>";}
- try { $SQL->query("ALTER TABLE `accounts` ADD `page_access` INT( 11 ) NOT NULL DEFAULT '0';"); echo "<font color=\"green\">Added column</font> <b>page_access</b> to table <b>accounts</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>page_access</b> to table <b>accounts</b>, already exist?<br/>";}
- try { $SQL->query("ALTER TABLE `accounts` ADD `email_code` VARCHAR( 255 ) NOT NULL DEFAULT '0';"); echo "<font color=\"green\">Added column</font> <b>email_code</b> to table <b>accounts</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>email_code</b> to table <b>accounts</b>, already exist?<br/>";}
- try { $SQL->query("ALTER TABLE `accounts` ADD `next_email` INT( 11 ) NOT NULL DEFAULT '0';"); echo "<font color=\"green\">Added column</font> <b>next_email</b> to table <b>accounts</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>next_email</b> to table <b>accounts</b>, already exist?<br/>";}
- try { $SQL->query("ALTER TABLE `accounts` ADD `premium_points` INT( 11 ) NOT NULL DEFAULT '0';"); echo "<font color=\"green\">Added column</font> <b>premium_points</b> to table <b>accounts</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>premium_points</b> to table <b>accounts</b>, already exist?<br/>";}
- echo "<h3>Add columns to table <b>guilds</b></h3>";
- try { $SQL->query('ALTER TABLE `guilds` ADD `description` TEXT NOT NULL DEFAULT "";'); echo "<font color=\"green\">Added column</font> <b>description</b> to table <b>guilds</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>description</b> to table <b>guilds</b>, already exist?<br/>";}
- try { $SQL->query('ALTER TABLE `guilds` ADD `logo_gfx_name` VARCHAR( 255 ) NOT NULL DEFAULT "";'); echo "<font color=\"green\">Added column</font> <b>logo_gfx_name</b> to table <b>guilds</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>logo_gfx_name</b> to table <b>guilds</b>, already exist?<br/>";}
- echo "<h3>Add columns to table <b>players</b></h3>";
- try { $SQL->query("ALTER TABLE `players` ADD `online` INT( 11 ) NOT NULL DEFAULT '0';"); echo "<font color=\"green\">Added column</font> <b>online</b> to table <b>players</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>online</b> to table <b>players</b>, already exist?<br/>";}
- try { $SQL->query("ALTER TABLE `players` ADD `created` INT( 11 ) NOT NULL DEFAULT '0';"); echo "<font color=\"green\">Added column</font> <b>created</b> to table <b>players</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>created</b> to table <b>players</b>, already exist?<br/>";}
- try { $SQL->query("ALTER TABLE `players` ADD `nick_verify` INT( 11 ) NOT NULL DEFAULT '0';"); echo "<font color=\"green\">Added column</font> <b>nick_verify</b> to table <b>players</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>nick_verify</b> to table <b>players</b>, already exist?<br/>";}
- try { $SQL->query("ALTER TABLE `players` ADD `old_name` VARCHAR( 255 ) NOT NULL DEFAULT '';"); echo "<font color=\"green\">Added column</font> <b>old_name</b> to table <b>players</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>old_name</b> to table <b>players</b>, already exist?<br/>";}
- try { $SQL->query("ALTER TABLE `players` ADD `hide_char` INT( 11 ) NOT NULL DEFAULT '0';"); echo "<font color=\"green\">Added column</font> <b>hide_char</b> to table <b>players</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>hide_char</b> to table <b>players</b>, already exist?<br/>";}
- try { $SQL->query("ALTER TABLE `players` ADD `comment` TEXT NOT NULL;"); echo "<font color=\"green\">Added column</font> <b>comment</b> to table <b>players</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>comment</b> to table <b>players</b>, already exist?<br/>";}
- try { $SQL->query("ALTER TABLE `accounts` ADD `vote` INT( 11 ) NOT NULL;"); echo "<font color=\"green\">Added column</font> <b>vote</b> to table <b>players</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>vote</b> to table <b>players</b>, already exist?<br/>";}
- echo "<h3>Add new tables to database</h3>";
- try { $SQL->query("CREATE TABLE `z_news_big` (
- `hide_news` tinyint(1) NOT NULL DEFAULT '0',
- `date` int(11) NOT NULL DEFAULT '0',
- `author` varchar(255) NOT NULL,
- `author_id` int(11) NOT NULL,
- `image_id` int(3) NOT NULL DEFAULT '0',
- `topic` varchar(255) NOT NULL,
- `text` text NOT NULL
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;");
- echo '<font color=\"green\">Added table <b>z_news_big</b></font><br/>';
- } catch(PDOException $error) { echo "<font color=\"red\">Table <b>z_news_big</b> not added.</font> Already exist?<br/>";}
- try { $SQL->query("CREATE TABLE `z_news_tickers` (
- `date` int(11) NOT NULL default '1',
- `author` int(11) NOT NULL,
- `image_id` int(3) NOT NULL default '0',
- `text` text NOT NULL,
- `hide_ticker` tinyint(1) NOT NULL
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;");
- echo '<font color=\"green\">Added table <b>z_news_tickers</b></font><br/>';
- } catch(PDOException $error) { echo "<font color=\"red\">Table <b>z_news_tickers</b> not added.</font> Already exist?<br/>";}
- try { $SQL->query('CREATE TABLE `z_spells` (
- `name` VARCHAR(255) NOT NULL,
- `spell` VARCHAR(255) NOT NULL,
- `spell_type` VARCHAR(255) NOT NULL,
- `mana` INTEGER NOT NULL DEFAULT 0,
- `lvl` INTEGER NOT NULL DEFAULT 0,
- `mlvl` INTEGER NOT NULL DEFAULT 0,
- `soul` INTEGER NOT NULL DEFAULT 0,
- `pacc` VARCHAR(255) NOT NULL,
- `vocations` VARCHAR(255) NOT NULL,
- `conj_count` INTEGER NOT NULL DEFAULT 0,
- `hide_spell` INTEGER NOT NULL DEFAULT 0);');
- echo '<font color=\"green\">Added table <b>z_spells</b></font><br/>';
- } catch(PDOException $error) { echo "<font color=\"red\">Table <b>z_spells</b> not added.</font> Already exist?<br/>";}
- try { $SQL->query('CREATE TABLE `z_monsters` (
- `hide_creature` tinyint(1) NOT NULL default \'0\',
- `name` varchar(255) NOT NULL,
- `mana` int(11) NOT NULL,
- `exp` int(11) NOT NULL,
- `health` int(11) NOT NULL,
- `speed_lvl` int(11) NOT NULL default \'1\',
- `use_haste` tinyint(1) NOT NULL,
- `voices` text NOT NULL,
- `immunities` varchar(255) NOT NULL,
- `summonable` tinyint(1) NOT NULL,
- `convinceable` tinyint(1) NOT NULL,
- `race` varchar(255) NOT NULL,
- `gfx_name` varchar(255) NOT NULL
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;');
- echo"<font color=\"green\">Added table <b>z_monsters</b></font><br/>";
- } catch(PDOException $error) { echo "<font color=\"red\">Table <b>z_monsters</b> not added.</font> Already exist?<br/>";}
- try { $SQL->query("CREATE TABLE `z_ots_comunication` (
- `id` int(11) NOT NULL auto_increment,
- `name` varchar(255) NOT NULL,
- `type` varchar(255) NOT NULL,
- `action` varchar(255) NOT NULL,
- `param1` varchar(255) NOT NULL,
- `param2` varchar(255) NOT NULL,
- `param3` varchar(255) NOT NULL,
- `param4` varchar(255) NOT NULL,
- `param5` varchar(255) NOT NULL,
- `param6` varchar(255) NOT NULL,
- `param7` varchar(255) NOT NULL,
- `delete_it` int(2) NOT NULL default '1',
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;");
- echo "<font color=\"green\">Added table <b>z_ots_comunication</b> (shopsystem).<br/></font>";
- }
- catch(PDOException $error) { echo "<font color=\"red\">Table <b>z_ots_comunication</b> not added.</font> Already exist?<br/>";}
- try { $SQL->query("CREATE TABLE `z_shop_offer` (
- `id` int(11) NOT NULL auto_increment,
- `points` int(11) NOT NULL default '0',
- `itemid1` int(11) NOT NULL default '0',
- `count1` int(11) NOT NULL default '0',
- `itemid2` int(11) NOT NULL default '0',
- `count2` int(11) NOT NULL default '0',
- `offer_type` varchar(255) default NULL,
- `offer_description` text NOT NULL,
- `offer_name` varchar(255) NOT NULL,
- `pid` INT(11) NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;");
- echo "<font color=\"green\">Added table <b>z_shop_offer</b> (shopsystem).<br/></font>";
- }
- catch(PDOException $error) { echo "<font color=\"red\">Table <b>z_shop_offer</b> not added.</font> Already exist?<br/>";}
- try { $SQL->query("CREATE TABLE `z_shop_history_item` (
- `id` int(11) NOT NULL auto_increment,
- `to_name` varchar(255) NOT NULL default '0',
- `to_account` int(11) NOT NULL default '0',
- `from_nick` varchar(255) NOT NULL,
- `from_account` int(11) NOT NULL default '0',
- `price` int(11) NOT NULL default '0',
- `offer_id` int(11) NOT NULL default '0',
- `trans_state` varchar(255) NOT NULL,
- `trans_start` int(11) NOT NULL default '0',
- `trans_real` int(11) NOT NULL default '0',
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;");
- echo "<font color=\"green\">Added table <b>z_shop_history_item</b> (shopsystem).<br/></font>";
- }
- catch(PDOException $error) { echo "<font color=\"red\">Table <b>z_shop_history_item</b> not added.</font> Already exist?<br/>";}
- try { $SQL->query("CREATE TABLE `z_shop_history_pacc` (
- `id` int(11) NOT NULL auto_increment,
- `to_name` varchar(255) NOT NULL default '0',
- `to_account` int(11) NOT NULL default '0',
- `from_nick` varchar(255) NOT NULL,
- `from_account` int(11) NOT NULL default '0',
- `price` int(11) NOT NULL default '0',
- `pacc_days` int(11) NOT NULL default '0',
- `trans_state` varchar(255) NOT NULL,
- `trans_start` int(11) NOT NULL default '0',
- `trans_real` int(11) NOT NULL default '0',
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;");
- echo "<font color=\"green\">Added table <b>z_shop_history_pacc</b> (shopsystem).<br/></font>";
- }
- catch(PDOException $error) { echo "<font color=\"red\">Table <b>z_shop_history_pacc</b> not added.</font> Already exist?<br/>";}
- try { $SQL->query("CREATE TABLE IF NOT EXISTS `z_changelog` (
- `id` int(11) NOT NULL auto_increment,
- `type` varchar(255) NOT NULL default '',
- `where` varchar(255) NOT NULL default '',
- `date` int(11) NOT NULL default '0',
- `description` varchar(255) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=0 ;");
- echo "<font color=\"green\">Added table <b>z_changelog</b> (changelog).<br/></font>";
- }
- catch(PDOException $error) { echo "<font color=\"red\">Table <b>z_changelog</b> not added.</font> Already exist?<br/>";}
- try { $SQL->query("CREATE TABLE `z_polls` (
- `id` int(11) NOT NULL auto_increment,
- `question` varchar(255) NOT NULL,
- `end` int(11) NOT NULL,
- `start` int(11) NOT NULL,
- `answers` int(11) NOT NULL,
- `votes_all` int(11) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;");
- echo "<font color=\"green\">Added table <b>z_polls</b> (poll-system).<br/></font>";
- }
- catch(PDOException $error) { echo "<font color=\"red\">Table <b>z_polls</b> not added.</font> Already exist?<br/>";}
- try { $SQL->query("CREATE TABLE `z_polls_answers` (
- `poll_id` int(11) NOT NULL,
- `answer_id` int(11) NOT NULL,
- `answer` varchar(255) NOT NULL,
- `votes` int(11) NOT NULL
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;");
- echo "<font color=\"green\">Added table <b>z_polls_answers</b> (poll-system).<br/></font>";
- }
- catch(PDOException $error) { echo "<font color=\"red\">Table <b>z_polls_answers</b> not added.</font> Already exist?<br/>";}
- try { $SQL->query("CREATE TABLE `z_bug_tracker` (
- `account` varchar(255) NOT NULL,
- `type` int(11) NOT NULL,
- `status` int(11) NOT NULL,
- `text` text NOT NULL,
- `id` int(11) NOT NULL,
- `subject` varchar(255) NOT NULL,
- `reply` int(11) NOT NULL,
- `who` int(11) NOT NULL,
- `uid` int(11) NOT NULL auto_increment,
- `tag` int(11) NOT NULL,
- PRIMARY KEY (`uid`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;");
- echo "<font color=\"green\">Added table <b>z_bug_tracker</b> (bug tracker).<br/></font>";
- }
- catch(PDOException $error) { echo "<font color=\"red\">Table <b>z_bug_tracker</b> not added.</font> Already exist?<br/>";}
- }
- $config['site']['install'] = 4;
- saveconfig_ini($config['site']);
- echo 'Tables and columns added to database.<br>Go to <a href="install.php?page=step&step=4&server_conf=yes">STEP 4 - Add samples</a>';
- }
- if($step == '4') {
- echo '<h1>STEP '.$step.'</h1>Add samples to DB:<br>';
- $check_news_ticker = $SQL->query('SELECT * FROM z_news_tickers WHERE image_id = 1 AND author = 1 AND hide_ticker = 0 LIMIT 1 OFFSET 0')->fetch();
- if(!isset($check_news_ticker['author'])) {
- $SQL->query('INSERT INTO z_news_tickers (date, author, image_id, text, hide_ticker) VALUES ('.time().', 1, 1, "Hello! Gesior account manager 0.32beta2 installed. Report bugs to gesiorjr@poczta.fm", 0)');
- echo "Added first news ticker.<br/>";
- } else {
- echo "News ticker sample is already in database. New sample is not needed.<br/>";
- }
- $check_news = $SQL->query('SELECT * FROM z_news_big WHERE author = "Gesior" LIMIT 1 OFFSET 0')->fetch();
- if(!isset($check_news['author'])) {
- $SQL->query('INSERT INTO z_news_big (hide_news, date, author, author_id, image_id, topic, text) VALUES (0, '.time().', "Gesior", 1, 0, "New account manager!", "Gesior account manager 0.32beta2 installed. All options should work fine. Report bugs in acc. maker thread");');
- echo "Added first news.<br/>";
- } else {
- echo "News sample is already in database. New sample is not needed.<br/>";
- }
- $check_voc_0 = $SQL->query('SELECT * FROM players WHERE name = "Rook Sample" LIMIT 1 OFFSET 0')->fetch();
- if(!isset($check_voc_0['name'])) {
- $SQL->query('INSERT INTO players (name, group_id, account_id, sex, vocation, experience, level, maglevel, health, healthmax, mana, manamax, manaspent, soul, direction, lookbody, lookfeet, lookhead, looklegs, looktype, lookaddons, posx, posy, posz, cap, lastlogin, lastip, save, conditions, redskulltime, redskull, guildnick, rank_id, town_id, loss_experience, loss_mana, loss_skills, lastlogout, blessings, premend, online, comment, created, hide_char, nick_verify) VALUES ("Rook Sample", 1, 1, 1, 0, 0, 1, 0, 185, 185, 35, 35, 0, 100,"", 44, 44, 44, 44, 128, 0, 0, 0, 0, 420, "", "", 1,"","","","","","1","","","","","","","","",'.time().',1,1)');
- echo "Added 'Rook Sample' character.<br/>";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement