Erro com Gesior (AJUDA)

kk44 · Abril 17, 2014

Warning: parse_ini_file(/otserv/config.lua) [function.parse-ini-file]: failed to open stream: No such file or directory in C:\Users\Murilo\Desktop\xampp\htdocs\config-and-functions.php on line 13
Database error. Unknown database type in /otserv/config.lua . Must be equal to: "mysql" or "sqlite". Now is: ""

Consegui resolver aquela agr apareceu essa:

Objeto não encontrado!

A URL requisitada não foi encontrada neste servidor. Se você digitou o endereço (URL) manualmente, por favor verifique novamente a sintaxe do endereço.

Se você acredita ter encontrado um problema no servidor, por favor entre em contato com o webmaster.

Error 404 localhost
04/17/14 16:18:12
Apache/2.2.9 (Win32) DAV/2 mod_ssl/2.2.9 OpenSSL/0.9.8i mod_autoindex_color PHP/5.2.6

Treyff · Abril 17, 2014

pelo que me parece voce troco sua config lua e nao tiro os espeços os comentarios por isso bugou!

Voce recebe a config lua assim:

-- The Forgotten Server Config

-- Account manager

accountManager = true

namelockManager = true

newPlayerChooseVoc = false

newPlayerSpawnPosX = 95

newPlayerSpawnPosY = 117

newPlayerSpawnPosZ = 7

newPlayerTownId = 1

newPlayerLevel = 1

newPlayerMagicLevel = 0

generateAccountNumber = false

Agora se tem que apagar tudo oque é comentario e está em verde e esses espaços no config inteiro!

Ficará assim:

accountManager = true

namelockManager = true

newPlayerChooseVoc = false

newPlayerSpawnPosX = 95

newPlayerSpawnPosY = 117

newPlayerSpawnPosZ = 7

newPlayerTownId = 1

newPlayerLevel = 1

newPlayerMagicLevel = 0

generateAccountNumber = false

Agora confere se funcionou não esqueça tambem de ir na sua pasta htdocs>config>config.INI e atualizar a pasta do teu server

se tudo isso não funcionar da uma olhada no seu config lua se a data base usuario e senha estçao corretas!

Vlw se eu ajudei da rep

Editado Abril 17, 2014 por Treyff (veja o histórico de edições)

kk44 · Abril 17, 2014

Ja consertei tdo isso agr deu isso:

STEP 4

Add samples to DB:

Fatal error: Call to a member function query() on a non-object in C:\Users\Murilo\Desktop\xampp\htdocs\install.php on line 619

Aaaa e oq vc falou em cima n tem nada ve

Treyff · Abril 17, 2014

quando se instalo seu site voce coloco no install.php? pois se nao coloco essa é uma boa hora para baixar outro site e instalar tudo dinovo!

então ele vai instalar na sua DB as tabelas que faltam para ele!

kk44 · Abril 17, 2014

ja tentou ajuda mas n sabe de nada

luanluciano93 me ajuda pf

Install.php :

<?PHP

$config['site'] = parse_ini_file('config/config.ini');

session_start();

//save config in ini file

require ("aca.php");

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,*" frameborder="0">

<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 </body></noframes>

</frameset>

</html>';

if($_REQUEST['page'] == 'menu')

echo '<div class="well"><h2>MENU</h2> IF NOT INSTALLED: 

0. Informations 

1. Set server path 

2. Check DataBase connection 

3. Add tables & columns to DB 

4. Add samples to DB 

5. Set Admin Account 

</div>';

if($_REQUEST['page'] == 'step') {

if($config['site']['install'] != "no") {

if($_REQUEST['server_conf'] == 'yes' || ($_REQUEST['step'] > 2 && $_REQUEST['step'] < 6)) {

$config['server'] = parse_ini_file($config['site']['server_path'].'config.lua');

if(isset($config['server']['mysqlHost'])) {

$mysqlhost = $config['server']['mysqlHost'];

$mysqluser = $config['server']['mysqlUser'];

$mysqlpass = $config['server']['mysqlPass'];

$mysqldatabase = $config['server']['mysqlDatabase'];

}

elseif(isset($config['server']['sqlHost'])) {

$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") {

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: 1. MySQL server is not running on host. 2. MySQL user, password, database or host isn\'t configured in: '.$config['site']['server_path'].'config.lua . 3. MySQL user, password, database or host is wrong.';

exit;

}

}

elseif(strtolower($config['server']['sqlType']) == "sqlite") {

$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: '.$link_to_sqlitedatabase.' - file isn\'t valid SQLite database. '.$link_to_sqlitedatabase.' - doesn\'t exist.';

exit;

}

} else {

echo 'Database error. Unknown database type in '.$config['site']['server_path'].'config.lua . Must be equal to: "mysql" or "sqlite". Now is: "'.strtolower($config['server']['sqlType']).'"';

exit;

}

$SQL = POT::getInstance()->getDBHandle();

}

$step = $_REQUEST['step'];

if(empty($step))

$step = $config['site']['install'];

if($step == 'start') {

echo '<div class="well">

<div class="styled_title">

<h1>STEP Start - Informations</h1>

</div>';

echo 'Sejam bem vindos ao Gesior 2.0 Versão 2 (2014)! 

Em 2013 tivemos uma grande taxa de downloads de nossos websites e resolvemos fazer uma segunda parte, na qual o website gesior na versão atual seria modificado 100% para ficar mais parecido com o website da cipsoft (www.tibia.com). Contendo a mesma segurança e sistemas funcionais. 

Estamos modificando muitos erros encontrados a alguns meses atras.

</div>

<form action="gravar.php" method="post">

<div class="well">

<div class="styled_title">

<h1>Server IP</h1>

</div>

<table>

<tr>

<td>

IP/SITE: 

<input type="hidden" name="mensagem" value="'.$_SERVER['HTTP_HOST'].'"/>

<input disabled type="text" name="mensagem" autocomplete="off" placeholder="'.$_SERVER['REMOTE_ADDR'].'" style="padding: 15px; width: 200px;"/> <img src="images/true.png" height="16" style="margin-top: -10px; margin-left: 10px;" />

VERIFICADO

</td>

</tr>

<tr>

<td><input type="submit" class="btn btn-primary" value="Prosseguir" /></td>

</tr>

</table>

</div>

</form>';

}

if($step == '1') {

if(isset($_REQUEST['server_path'])) {

echo '<Div class="well"><div class="styled_title"><h1>STEP '.$step.'</h1></div>Verifique se tudo está correto e tente novamente.</div>';

$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 '<div class="well">File config.lua loaded from '.$config['site']['server_path'].'config.lua 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></div>';

}

else

{

echo '<div class="well">File config.lua loaded from '.$config['site']['server_path'].'config.lua 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.</div>';

}

}

else

{

echo '<div class="well">Can\'t load file config.lua from '.$config['site']['server_path'].'config.lua File doesn\'t exist in selected directory. 

<form action="install.php?page=step&step=1" method="post"><input type="submit" value="Go to STEP 1 - select other directory" class="btn-large btn-primary" /></a></div>';

}

}

else

{

echo '<div class="well">Please write you TFS directory below. Like: C:\Documents and Settings\Gesior\Desktop\TFS 0.3.6\ or /home/ots/tfs/ 

After install please delate all comments from config.lua

 Example:

<code>-- Account manager</code>

<form action="install.php">

<input type="text" name="server_path" size="90" value="'.$config['site']['server_path'].'" style="padding: 14px;" /><input type="hidden" name="page" value="step" /><input type="hidden" name="step" value="1" /> <input type="submit" class="btn" value="Set server path" style="margin-top: -10px;" /></form></div>';

}

}

if($step == '2') {

echo '<div class="well"><h1>STEP '.$step.'</h1>Check database connection ';

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.</div>';

//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');

$ots = POT::getInstance();

if(strtolower($config['server']['sqlType']) == "mysql") {

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: 1. MySQL server is not running on host. 2. MySQL user, password, database or host isn\'t configured in: '.$config['site']['server_path'].'config.lua . 3. MySQL user, password, database or host is wrong.';

exit;

}

}

elseif(strtolower($config['server']['sqlType']) == "sqlite") {

$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: '.$link_to_sqlitedatabase.' - file isn\'t valid SQLite database. '.$link_to_sqlitedatabase.' - doesn\'t exist.';

exit;

}

}

else

{

echo '<div class="well">Banco de dados não consegue conectar-se com o servidor contido no diretorio '.$config['site']['server_path'].'config.lua . As configurações do banco de dados está errada ou corrompida, certifique-se de que o tipo de banco de dados está como MySQL Verificamos, está: "'.strtolower($config['server']['sqlType']).'".</div>';

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 ';

echo 'Installer try to add new tables and columns to database. ';

$config['server'] = parse_ini_file($config['site']['server_path'].'config.lua');

if($config['server']['sqlType'] == "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) {}

try { $SQL->query('ALTER TABLE accounts ADD "vip_time" INTEGER( 11 ) NOT NULL DEFAULT 0;'); } catch(PDOException $error) {}

echo "Added columns to table accounts. ";

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 guilds. ";

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 players. ";

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 z_news_tickers (tickers). ";

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 z_spells (spells list). ";

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,

"loot" text NOT NULL,

"gfx_name" VARCHAR(255) NOT NULL)'); } catch(PDOException $error) {}

echo "Added table z_monsters (monsters list). ";

}

elseif($config['server']['sqlType'] == "mysql") {

echo "<h3>Add columns to table accounts</h3>";

try { $SQL->query("ALTER TABLE `accounts` ADD `page_lastday` INT( 11 ) NOT NULL;"); echo "Added column page_lastday to table accounts ";} catch(PDOException $error) { echo "Can't add column page_lastday to table accounts, already exist? ";}

try { $SQL->query("ALTER TABLE `accounts` ADD `email_new` VARCHAR( 255 ) NOT NULL;"); echo "Added column email_new to table accounts ";} catch(PDOException $error) { echo "Can't add column email_new to table accounts, already exist? ";}

try { $SQL->query("ALTER TABLE `accounts` ADD `email_new_time` INT( 15 ) NOT NULL;"); echo "Added column email_new_time to table accounts ";} catch(PDOException $error) { echo "Can't add column email_new_time to table accounts, already exist? ";}

try { $SQL->query("ALTER TABLE `accounts` ADD `created` INT( 11 ) NOT NULL DEFAULT '0';"); echo "Added column created to table accounts ";} catch(PDOException $error) { echo "Can't add column created to table accounts, already exist? ";}

try { $SQL->query("ALTER TABLE `accounts` ADD `rlname` VARCHAR( 255 ) NOT NULL DEFAULT '';"); echo "Added column rlname to table accounts ";} catch(PDOException $error) { echo "Can't add column rlname to table accounts, already exist? ";}

try { $SQL->query("ALTER TABLE `accounts` ADD `location` VARCHAR( 255 ) NOT NULL DEFAULT '';"); echo "Added column location to table accounts ";} catch(PDOException $error) { echo "Can't add column location to table accounts, already exist? ";}

try { $SQL->query("ALTER TABLE `accounts` ADD `page_access` INT( 11 ) NOT NULL DEFAULT '0';"); echo "Added column page_access to table accounts ";} catch(PDOException $error) { echo "Can't add column page_access to table accounts, already exist? ";}

try { $SQL->query("ALTER TABLE `accounts` ADD `email_code` VARCHAR( 255 ) NOT NULL DEFAULT '0';"); echo "Added column email_code to table accounts ";} catch(PDOException $error) { echo "Can't add column email_code to table accounts, already exist? ";}

try { $SQL->query("ALTER TABLE `accounts` ADD `next_email` INT( 11 ) NOT NULL DEFAULT '0';"); echo "Added column next_email to table accounts ";} catch(PDOException $error) { echo "Can't add column next_email to table accounts, already exist? ";}

try { $SQL->query("ALTER TABLE `accounts` ADD `premium_points` INT( 11 ) NOT NULL DEFAULT '0';"); echo "Added column premium_points to table accounts ";} catch(PDOException $error) { echo "Can't add column premium_points to table accounts, already exist? ";}

try { $SQL->query("ALTER TABLE `accounts` ADD `vote` INT( 11 ) NOT NULL;"); echo "Added column vote to table players ";} catch(PDOException $error) { echo "Can't add column vote to table players, already exist? ";}

try { $SQL->query("ALTER TABLE `accounts` ADD `last_post` INT( 11 ) NOT NULL DEFAULT '0';"); echo "Added column last post to table accounts ";} catch(PDOException $error) { echo "Can't add column last posts to table accounts, already exist? ";}

try { $SQL->query("ALTER TABLE `accounts` ADD `flag` VARCHAR( 255 ) NOT NULL;"); echo "Added column flag to table accounts ";} catch(PDOException $error) { echo "Can't add column flag to table accounts, already exist? ";}

try { $SQL->query("ALTER TABLE `accounts` ADD `vip_time` INT( 11 ) NOT NULL DEFAULT '0';"); echo "Added column vip_time to table accounts ";} catch(PDOException $error) { echo "Can't add column vip_time to table accounts, already exist? ";}

echo "<h3>Add columns to table guilds</h3>";

try { $SQL->query('ALTER TABLE `guilds` ADD `description` TEXT NOT NULL DEFAULT "";'); echo "Added column description to table guilds ";} catch(PDOException $error) { echo "Can't add column description to table guilds, already exist? ";}

try { $SQL->query('ALTER TABLE `guilds` ADD `logo_gfx_name` VARCHAR( 255 ) NOT NULL DEFAULT "";'); echo "Added column logo_gfx_name to table guilds ";} catch(PDOException $error) { echo "Can't add column logo_gfx_name to table guilds, already exist? ";}

echo "<h3>Add columns to table players</h3>";

try { $SQL->query("ALTER TABLE `players` ADD `created` INT( 11 ) NOT NULL DEFAULT '0';"); echo "Added column created to table players ";} catch(PDOException $error) { echo "Can't add column created to table players, already exist? ";}

try { $SQL->query("ALTER TABLE `players` ADD `nick_verify` INT( 11 ) NOT NULL DEFAULT '0';"); echo "Added column nick_verify to table players ";} catch(PDOException $error) { echo "Can't add column nick_verify to table players, already exist? ";}

try { $SQL->query("ALTER TABLE `players` ADD `old_name` VARCHAR( 255 ) NOT NULL DEFAULT '';"); echo "Added column old_name to table players ";} catch(PDOException $error) { echo "Can't add column old_name to table players, already exist? ";}

try { $SQL->query("ALTER TABLE `players` ADD `hide_char` INT( 11 ) NOT NULL DEFAULT '0';"); echo "Added column hide_char to table players ";} catch(PDOException $error) { echo "Can't add column hide_char to table players, already exist? ";}

try { $SQL->query("ALTER TABLE `players` ADD `worldtransfer` int(11) NOT NULL DEFAULT '0';"); echo "Added column worldtransfer to table players ";} catch(PDOException $error) { echo "Can't add column worldtransfer to table players, already exist? ";}

try { $SQL->query("ALTER TABLE `players` ADD `comment` TEXT NOT NULL;"); echo "Added column comment to table players ";} catch(PDOException $error) { echo "Can't add column comment to table players, already exist? ";}

try { $SQL->query("ALTER TABLE `players` ADD `show_outfit` TINYINT( 4 ) NOT NULL DEFAULT '1';"); echo "Added column show_outfit to table players ";} catch(PDOException $error) { echo "Can't add column comment to table players, already exist? ";}

try { $SQL->query("ALTER TABLE `players` ADD `show_eq` TINYINT( 4 ) NOT NULL DEFAULT '1';"); echo "Added column show_eq to table players ";} catch(PDOException $error) { echo "Can't add column comment to table players, already exist? ";}

try { $SQL->query("ALTER TABLE `players` ADD `show_bars` TINYINT( 4 ) NOT NULL DEFAULT '1';"); echo "Added column show_bars to table players ";} catch(PDOException $error) { echo "Can't add column comment to table players, already exist? ";}

try { $SQL->query("ALTER TABLE `players` ADD `show_skills` TINYINT( 4 ) NOT NULL DEFAULT '1';"); echo "Added column show_skills to table players ";} catch(PDOException $error) { echo "Can't add column comment to table players, already exist? ";}

try { $SQL->query("CREATE TABLE IF NOT EXISTS `guild_wars` (

`id` INT NOT NULL AUTO_INCREMENT,

`guild_id` INT NOT NULL,

`enemy_id` INT NOT NULL,

`begin` BIGINT NOT NULL DEFAULT '0',

`end` BIGINT NOT NULL DEFAULT '0',

`frags` INT UNSIGNED NOT NULL DEFAULT '0',

`payment` BIGINT UNSIGNED NOT NULL DEFAULT '0',

`guild_kills` INT UNSIGNED NOT NULL DEFAULT '0',

`enemy_kills` INT UNSIGNED NOT NULL DEFAULT '0',

`status` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',

PRIMARY KEY (`id`),

KEY `status` (`status`),

KEY `guild_id` (`guild_id`),

KEY `enemy_id` (`enemy_id`)

) ENGINE=InnoDB;

ALTER TABLE `guilds` ADD `balance` BIGINT UNSIGNED NOT NULL AFTER `motd`;

CREATE TABLE IF NOT EXISTS `guild_kills` (

`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,

`guild_id` INT NOT NULL,

`war_id` INT NOT NULL,

`death_id` INT NOT NULL

) ENGINE = InnoDB;

ALTER TABLE `killers` ADD `war` INT NOT NULL DEFAULT 0;"); echo "Added column guild war to table ";} catch(PDOException $error) { echo "Can't add column guild war to table, already exist? ";}

try { $SQL->query("ALTER TABLE `players` ADD `show_quests` TINYINT( 4 ) NOT NULL DEFAULT '1';"); echo "Added column show_quests to table players ";} catch(PDOException $error) { echo "Can't add column comment to table players, already exist? ";}

try { $SQL->query("ALTER TABLE `players` ADD `stars` INT( 10 ) NOT NULL DEFAULT '0';"); echo "Added column stars to table players ";} catch(PDOException $error) { echo "Can't add column stars to table players, already exist? ";}

try { $SQL->query("CREATE TABLE `announcements` (`id` INT( 10 ) NOT NULL AUTO_INCREMENT ,`title` VARCHAR( 50 ) NOT NULL ,`text` VARCHAR( 255 ) NOT NULL ,`date` VARCHAR( 20 ) NOT NULL ,`author` VARCHAR( 50 ) NOT NULL ,PRIMARY KEY ( `id` )) ENGINE = MYISAM"); echo "Added column announcements ";} catch(PDOException $error) { echo "Can't add column announcements to table, already exist? ";}

try { $SQL->query("ALTER TABLE `bans` ADD `reason` VARCHAR( 10 ) NOT NULL ;"); echo "Added column reason to table bans ";} catch(PDOException $error) { echo "Can't add column reason to table bans, already exist? ";}

try { $SQL->query("CREATE TABLE IF NOT EXISTS `pagsegurotransacoes` ( `TransacaoID` varchar(36) NOT NULL, `VendedorEmail` varchar(200) NOT NULL, `Referencia` varchar(200) default NULL,

`TipoFrete` char(2) default NULL, `ValorFrete` decimal(10,2) default NULL, `Extras` decimal(10,2) default NULL, `Anotacao` text, `TipoPagamento` varchar(50) NOT NULL,

`StatusTransacao` varchar(50) NOT NULL, `CliNome` varchar(200) NOT NULL, `CliEmail` varchar(200) NOT NULL, `CliEndereco` varchar(200) NOT NULL, `CliNumero` varchar(10) default NULL, `CliComplemento` varchar(100) default NULL, `CliBairro` varchar(100) NOT NULL, `CliCidade` varchar(100) NOT NULL, `CliEstado` char(2) NOT NULL, `CliCEP` varchar(9) NOT NULL, `CliTelefone` varchar(14) default NULL, `NumItens` int(11) NOT NULL, `Data` datetime NOT NULL, `ProdQuantidade_x` int(5) NOT NULL, `status` tinyint(1) unsigned NOT NULL default '0', UNIQUE KEY `TransacaoID` (`TransacaoID`,`StatusTransacao`), KEY `Referencia` (`Referencia`),

KEY `status` (`status`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;"); echo "Sistema PagSeguro automatico instalado! ";} catch(PDOException $error) { echo "Sistema PagSeguro já está instalado no banco de dados ";}

try { $SQL->query("CREATE TABLE IF NOT EXISTS `thanks` (

`id` int(10) NOT NULL auto_increment,

`account_id` varchar(30) NOT NULL,

`forum_id` text NOT NULL,

`player_name` text NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;"); echo "Added column thanks to database ";} catch(PDOException $error) { echo "Can't add column thanks in database, already exist? ";}

try { $SQL->query("INSERT INTO `player_skills` (`player_id`, `skillid`, `value`, `count`) VALUES

(2, 0, 10, 0),

(2, 1, 10, 0),

(2, 2, 10, 0),

(2, 3, 10, 0),

(2, 4, 10, 0),

(2, 5, 10, 0),

(2, 6, 10, 0),

(3, 0, 10, 0),

(3, 1, 10, 0),

(3, 2, 10, 0),

(3, 3, 10, 0),

(3, 4, 10, 0),

(3, 5, 10, 0),

(3, 6, 10, 0),

(4, 0, 10, 0),

(4, 1, 10, 0),

(4, 2, 10, 0),

(4, 3, 10, 0),

(4, 4, 10, 0),

(4, 5, 10, 0),

(4, 6, 10, 0),

(5, 0, 10, 0),

(5, 1, 10, 0),

(5, 2, 10, 0),

(5, 3, 10, 0),

(5, 4, 10, 0),

(5, 5, 10, 0),

(5, 6, 10, 0),

(6, 0, 10, 0),

(6, 1, 10, 0),

(6, 2, 10, 0),

(6, 3, 10, 0),

(6, 4, 10, 0),

(6, 5, 10, 0),

(6, 6, 10, 0);"); echo "Adicionado skills aos samples ";} catch(PDOException $error) { echo "Samples ja tem skills. ";}

echo "<h3>Add new tables to database</h3>";

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 'Added table z_news_tickers ';

} catch(PDOException $error) { echo "Table z_news_tickers not added. Already exist? ";}

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 'Added table z_spells ';

} catch(PDOException $error) { echo "Table z_spells not added. Already exist? ";}

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,

`loot` text NOT NULL,

`gfx_name` varchar(255) NOT NULL

) ENGINE=MyISAM DEFAULT CHARSET=latin1;');

echo"Added table z_monsters ";

} catch(PDOException $error) { echo "Table z_monsters not added. Already exist? ";}

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 "Added table z_ots_comunication (shopsystem). ";

}

catch(PDOException $error) { echo "Table z_ots_comunication not added. Already exist? ";}

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 "Added table z_shop_offer (shopsystem). ";

}

catch(PDOException $error) { echo "Table z_shop_offer not added. Already exist? ";}

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 "Added table z_shop_history_item (shopsystem). ";

}

catch(PDOException $error) { echo "Table z_shop_history_item not added. Already exist? ";}

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 "Added table z_shop_history_pacc (shopsystem). ";

}

catch(PDOException $error) { echo "Table z_shop_history_pacc not added. Already exist? ";}

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 "Added table z_polls (poll-system). ";

}

catch(PDOException $error) { echo "Table z_polls not added. Already exist? ";}

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 "Added table z_polls_answers (poll-system). ";

}

catch(PDOException $error) { echo "Table z_polls_answers not added. Already exist? ";}

try { $SQL->query("CREATE TABLE IF NOT EXISTS `z_bug_logs` (

`id` int(11) NOT NULL auto_increment,

`account_id` int(11) NOT NULL,

`status` tinyint(1) NOT NULL default '0',

`description` text NOT NULL,

`time` int(11) NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;");

echo "Added table z_bug_logs. ";

}

catch(PDOException $error) { echo "Table z_bug_logs not added. Already exist? ";}

try { $SQL->query("CREATE TABLE IF NOT EXISTS `z_bug_logs` (

`id` int(11) NOT NULL auto_increment,

`account_id` int(11) NOT NULL,

`status` tinyint(1) NOT NULL default '0',

`description` text NOT NULL,

`time` int(11) NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;");

echo "Added table z_bug_tracker (bug tracker). ";

}

catch(PDOException $error) { echo "Table z_bug_tracker not added. Already exist? ";}

try { $SQL->query("CREATE TABLE IF NOT EXISTS `z_helpdesk` (

`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,

`priority` int(11) NOT NULL,

`reply` int(11) NOT NULL,

`who` int(11) NOT NULL,

`uid` int(11) NOT NULL AUTO_INCREMENT,

`tag` int(11) NOT NULL,

`registered` int(11) NOT NULL,

PRIMARY KEY (`uid`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=26 ;");

echo "Added table z_changelog (changelog). ";

}

catch(PDOException $error) { echo "Table z_changelog not added. Already exist? ";}

try { $SQL->query("CREATE TABLE `z_forum` (

`id` int(11) NOT NULL auto_increment,

`sticky` tinyint(1) NOT NULL DEFAULT '0',

`closed` tinyint(1) NOT NULL DEFAULT '0',

`first_post` int(11) NOT NULL default '0',

`last_post` int(11) NOT NULL default '0',

`section` int(3) NOT NULL default '0',

`icon_id` int(3) NOT NULL default '1',

`replies` int(20) NOT NULL default '0',

`views` int(20) NOT NULL default '0',

`author_aid` int(20) NOT NULL default '0',

`author_guid` int(20) NOT NULL default '0',

`post_text` text NOT NULL,

`post_topic` varchar(255) NOT NULL,

`post_smile` tinyint(1) NOT NULL default '0',

`post_date` int(20) NOT NULL default '0',

`last_edit_aid` int(20) NOT NULL default '0',

`edit_date` int(20) NOT NULL default '0',

`post_ip` varchar(32) NOT NULL default '0.0.0.0',

PRIMARY KEY (`id`),

KEY `section` (`section`)

) ENGINE=MyISAM AUTO_INCREMENT=1;");

echo "Added table z_forum (forum). ";

}

catch(PDOException $error) { echo "Table z_forum not added. Already exist? ";}

}

$config['site']['install'] = 4;

saveconfig_ini($config['site']);

echo ' Tables and columns added to database. 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: ';

$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, "WELCOME!", 0)');

echo "Added first news ticker. ";

} else {

echo "News ticker sample is already in database. New sample is not needed. ";

}

$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` (`id`, `name`, `world_id`, `group_id`, `account_id`, `level`, `vocation`, `health`, `healthmax`, `experience`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `maglevel`, `mana`, `manamax`, `manaspent`, `soul`, `town_id`, `posx`, `posy`, `posz`, `conditions`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `rank_id`, `guildnick`, `lastlogout`, `blessings`, `balance`, `stamina`, `direction`, `loss_experience`, `loss_mana`, `loss_skills`, `loss_containers`, `loss_items`, `premend`, `online`, `marriage`, `promotion`, `deleted`, `description`, `created`, `nick_verify`, `old_name`, `hide_char`, `comment`) VALUES

(NULL, "Rook Sample", 0, 1, 1, 1, 0, 185, 185, 0, 0, 0, 0, 0, 110, 0, 0, 0, 0, 0, 0, 0, 50, 50, 7, "", 400, 0, 0, 0, 0, 0, 0, 0, "", 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, "", 0, 0, "", 0, "")');

echo "Added 'Rook Sample' character. ";

} else {

echo "Character 'Rook Sample' already in database. ";

}

$check_voc_1 = $SQL->query('SELECT * FROM players WHERE name = "Sorcerer Sample" LIMIT 1 OFFSET 0')->fetch();

if(!isset($check_voc_1['name'])) {

$SQL->query('INSERT INTO `players` (`id`, `name`, `world_id`, `group_id`, `account_id`, `level`, `vocation`, `health`, `healthmax`, `experience`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `maglevel`, `mana`, `manamax`, `manaspent`, `soul`, `town_id`, `posx`, `posy`, `posz`, `conditions`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `rank_id`, `guildnick`, `lastlogout`, `blessings`, `balance`, `stamina`, `direction`, `loss_experience`, `loss_mana`, `loss_skills`, `loss_containers`, `loss_items`, `premend`, `online`, `marriage`, `promotion`, `deleted`, `description`, `created`, `nick_verify`, `old_name`, `hide_char`, `comment`) VALUES

(NULL, "Sorcerer Sample", 0, 1, 1, 8, 1, 185, 185, 0, 0, 0, 0, 0, 110, 0, 0, 0, 0, 0, 0, 0, 50, 50, 7, "", 400, 0, 0, 0, 0, 0, 0, 0, "", 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, "", 0, 0, "", 0, "")');

echo "Added 'Sorcerer Sample' character. ";

} else {

echo "Character 'Sorcerer Sample' already in database. ";

}

$check_voc_2 = $SQL->query('SELECT * FROM players WHERE name = "Druid Sample" LIMIT 1 OFFSET 0')->fetch();

if(!isset($check_voc_2['name'])) {

$SQL->query('INSERT INTO `players` (`id`, `name`, `world_id`, `group_id`, `account_id`, `level`, `vocation`, `health`, `healthmax`, `experience`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `maglevel`, `mana`, `manamax`, `manaspent`, `soul`, `town_id`, `posx`, `posy`, `posz`, `conditions`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `rank_id`, `guildnick`, `lastlogout`, `blessings`, `balance`, `stamina`, `direction`, `loss_experience`, `loss_mana`, `loss_skills`, `loss_containers`, `loss_items`, `premend`, `online`, `marriage`, `promotion`, `deleted`, `description`, `created`, `nick_verify`, `old_name`, `hide_char`, `comment`) VALUES

(NULL, "Druid Sample", 0, 1, 1, 8, 2, 185, 185, 0, 0, 0, 0, 0, 110, 0, 0, 0, 0, 0, 0, 0, 50, 50, 7, "", 400, 0, 0, 0, 0, 0, 0, 0, "", 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, "", 0, 0, "", 0, "")');

echo "Added 'Druid Sample' character. ";

} else {

echo "Character 'Druid Sample' already in database. ";

}

$check_voc_3 = $SQL->query('SELECT * FROM players WHERE name = "Paladin Sample" LIMIT 1 OFFSET 0')->fetch();

if(!isset($check_voc_3['name'])) {

$SQL->query('INSERT INTO `players` (`id`, `name`, `world_id`, `group_id`, `account_id`, `level`, `vocation`, `health`, `healthmax`, `experience`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `maglevel`, `mana`, `manamax`, `manaspent`, `soul`, `town_id`, `posx`, `posy`, `posz`, `conditions`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `rank_id`, `guildnick`, `lastlogout`, `blessings`, `balance`, `stamina`, `direction`, `loss_experience`, `loss_mana`, `loss_skills`, `loss_containers`, `loss_items`, `premend`, `online`, `marriage`, `promotion`, `deleted`, `description`, `created`, `nick_verify`, `old_name`, `hide_char`, `comment`) VALUES

(NULL, "Paladin Sample", 0, 1, 1, 8, 3, 185, 185, 0, 0, 0, 0, 0, 110, 0, 0, 0, 0, 0, 0, 0, 50, 50, 7, "", 400, 0, 0, 0, 0, 0, 0, 0, "", 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, "", 0, 0, "", 0, "")');

echo "Added 'Paladin Sample' character. ";

} else {

echo "Character 'Paladin Sample' already in database. ";

}

$check_voc_4 = $SQL->query('SELECT * FROM players WHERE name = "Knight Sample" LIMIT 1 OFFSET 0')->fetch();

if(!isset($check_voc_4['name'])) {

$SQL->query('INSERT INTO `players` (`id`, `name`, `world_id`, `group_id`, `account_id`, `level`, `vocation`, `health`, `healthmax`, `experience`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `maglevel`, `mana`, `manamax`, `manaspent`, `soul`, `town_id`, `posx`, `posy`, `posz`, `conditions`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `rank_id`, `guildnick`, `lastlogout`, `blessings`, `balance`, `stamina`, `direction`, `loss_experience`, `loss_mana`, `loss_skills`, `loss_containers`, `loss_items`, `premend`, `online`, `marriage`, `promotion`, `deleted`, `description`, `created`, `nick_verify`, `old_name`, `hide_char`, `comment`) VALUES

(NULL, "Knight Sample", 0, 1, 1, 8, 4, 185, 185, 0, 0, 0, 0, 0, 110, 0, 0, 0, 0, 0, 0, 0, 50, 50, 7, "", 400, 0, 0, 0, 0, 0, 0, 0, "", 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, "", 0, 0, "", 0, "")');

echo "Added 'Knight Sample' character. ";

echo 'All samples added to database. Now you can go to <a href="install.php?page=step&step=5&server_conf=yes">STEP 5 - Set Admin Account</a>';

} else {

echo "Character 'Knight Sample' already in database. ";

$config['site']['install'] = 5;

saveconfig_ini($config['site']);

echo 'All samples added to database. Now you can go to <a href="install.php?page=step&step=5&server_conf=yes">STEP 5 - Set Admin Account</a> ';

}

}

if($step == '5') {

echo '<h1>STEP '.$step.'</h1>Set Admin Account ';

$config['server'] = parse_ini_file($config['site']['server_path'].'config.lua');

if(empty($_REQUEST['saveaccpassword'])) {

echo 'Admin account number is: 1 Set new password to this account. ';

echo 'New password: <form action="install.php" method=POST><input type="text" name="newpass" size="35">(Don\'t give it password to anyone!)';

echo '<input type="hidden" name="saveaccpassword" value="yes"><input type="hidden" name="page" value="step"><input type="hidden" name="step" value="5"><input type="submit" value="SET"></form> If account with number 1 doesn\'t exist installator will create it and set your password.';

} else {

$newpass = $_POST['newpass'];

if(!check_password($newpass))

echo 'Password contains illegal characters. Please use only a-Z and 0-9. <a href="install.php?page=step&step=5&server_conf=yes">GO BACK</a> and write other password.';

else

{

$newpass_to_db = password_ency($newpass);

$account = new OTS_Account();

$account->load(1);

if($account->isLoaded()) {

$account->setPassword($newpass_to_db);

$account->save();

$account->setCustomField("page_access", 999999);

$account->setCustomField("created", time());

} else {

$number = $account->create(1,1,1);

$account->setPassword($newpass_to_db);

$account->unblock();

$account->save();

$account->setCustomField("page_access", 999999);

$account->setCustomField("created", time());

}

$_SESSION['account'] = 1;

$_SESSION['password'] = $newpass;

$logged = TRUE;

echo '<h1>Admin account number: 1 Admin account password: '.$_POST['newpass'].'</h1> <h3>It\'s end of first part of installation. Installation is blocked. From now don\'t modify file config.ini! Press links to STEPs 6 and 7 in menu.</h3>';

$config['site']['install'] = 'no';

saveconfig_ini($config['site']);

}

}

}

}

else

echo "Account maker is already installed! To reinstall open file 'config.ini' in directory 'config' and change: install = \"no\" to:install = \"start\" and enter this site again.";

echo '<div style="text-align: center; text-color: #EEE;">All rights reserved VICTOR FASANO RAFUL</div>';

}

?>

Treyff · Abril 17, 2014

amigo voce mudou sua DB e espera que o site saiba instalar sozinho? faz o seguinte na pasta HTDocs>config>config.ini mude "install = "no"" para "install = "yes""

e na pasta Htdocs config and dunctions muda //check install if($config['site']['install'] != "no") para //check install if($config['site']['install'] != "yes")

pronto agora entra no site instala dinovo!

sou admin assim como você eu já tive esses problemas mas não distratei ninguém que já tento me ajudar!

kk44 · Abril 17, 2014

man fica quieto ve o meu segundo post ja to na etapa 4.

n sabe nada de php e qer ajudar

e no config.ini nao é de "no" pra "yes", e sim pra "start"

e no config and functions nao tem nada a ve

luanluciano93 · Abril 17, 2014

1º - NÃO PRECISA FALAR ASSIM COM ELE KK44, ELE SÓ ESTA TENTANDO AJUDAR!

2º - COLOCA AQUELE ARQUIVO GIGANTE EM SPOILER, PELO AMOR DE DEUS!

Pois bem, depois do <?php, coloque isso na linha abaixo define('DEBUG_DATABASE', false);

Assim, este erro acontece quando determinado arquivo (no caso o install.php) precisa de alguma coluna em alguma tabela para funcionar, e acaba que não tendo oque ela precisa, por isso o erro.

Quando acontecer isso, mude para true naquela linha que tu colocou! Ai vai aparecer a query e a coluna que esta faltando em menssage error!

E por favor, harmonia no fórum por favor! ¬¬

kk44 · Abril 17, 2014

continua a msm coisa "

linha 620:

$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();

Entrar

Erro com Gesior (AJUDA)

Posts Recomendados

kk44 1

Link para o post

Compartilhar em outros sites

Treyff 11

Link para o post

Compartilhar em outros sites

kk44 1

Link para o post

Compartilhar em outros sites

Treyff 11

Link para o post

Compartilhar em outros sites

kk44 1

Link para o post

Compartilhar em outros sites

Treyff 11

Link para o post

Compartilhar em outros sites

kk44 1

Link para o post

Compartilhar em outros sites

luanluciano93 1993

Link para o post

Compartilhar em outros sites

kk44 1

Link para o post

Compartilhar em outros sites

Participe da conversa

Quem Está Navegando 0 membros estão online

TibiaKing

Open Tibia Server

Redes Sociais

Anuncie no TibiaKing

Fóruns

Anuncie

Informação Importante