11.x [v32] GlobalFull 11/12 - New Asuras, Falcons, Warzones 4,5,6 . (Updates Frequentes)

[Wakon 912]

hehehe!!! maravilha... o config.lua eu sei, do mysql eu acho na net algo sobre!! agora só pra "finalizar": eu instalo o tibia 10.78 normal e onde eu coloco tds esses arquivos que fiz o download no começo do tpc?

Junta tudo em uma pasta e abre o servidor, só o site que você instala com o xampp.

[Dhjango 0]

Junta tudo em uma pasta e abre o servidor, só o site que você instala com o xampp.

humm... to começando a entender hehehe!!! eu preciso tirar de dentro das pastas ou vai do jeito que está?

[Wakon 912]

Você só precisa extrair os arquivos para dentro de uma pasta para juntar todos.
 

[Dhjango 0]

fmz... dmr vlws!!! chegando em casa eu vou testar.

[Kanohn 2]

Mitsug,  você apenas alterou em "Definitions.h" a versão, ou fez mais alguma alteração na source?

 

Pois eu ja retirei diversos bugs da source da V11, entao ficaria mais pratico para mim apenas adicionar em definitions..

 

abraços!

[Dhjango 0]

Junta tudo em uma pasta e abre o servidor, só o site que você instala com o xampp.

Tem a necessidade de instalar o site no xampp? não tem como eu criar o char direto pelo account manager?

[Wakon 912]

Nessa versão não tem account manager, tem que criar o site mesmo.

[Dhjango 0]

Nessa versão não tem account manager, tem que criar o site mesmo.

Preciso do ip changer?

Desculpa toda a minha ignorância rss... é que sou novo nesse sistema de ot offline, como estou sem net e tb não tenho pretensões de colocar, resolvi continuar jogando off msm. 

Instalei os arquivos aqui, e aparece o seguinte erro:

Error ID: #C-2 class::configlua - lua config file doesn't existe. Path: /otserv/config.lua

c:\xampp\htdocs\tibiaot\classes/configlua.php line: 24

c:\xampp\htdocs\tibiaot\classes/configlua.php line: 12

c:\xampp\htdocs\tibiaot\system/load.init.php line: 42

c:\xampp\htdocs\tibiaot/index.php line: 18

E não faço a menor ideia de como arrumar Rss!

Editado Maio 21, 2015 por Dhjango (veja o histórico de edições)

[misterjhony 0]

http://img.gforum.tv/ver.php?i=b7f78849d84accc93d6635b7e000cc855cf450e5.jpg

 

alguem me ajuda pelo amor de deuuuuuuuuuuuuuuuuuuuuuuuuuuuus .

 

 

da esse erro e o otserver fecha pff me ajudaaaaa

 

http://img.gforum.tv/ver.php?i=b7f78849d84accc93d6635b7e000cc855cf450e5.jpg

Editado Maio 22, 2015 por misterjhony (veja o histórico de edições)

[PepeHanc 4]

 

Preciso do ip changer?

Desculpa toda a minha ignorância rss... é que sou novo nesse sistema de ot offline, como estou sem net e tb não tenho pretensões de colocar, resolvi continuar jogando off msm. 

Instalei os arquivos aqui, e aparece o seguinte erro:

Error ID: #C-2 class::configlua - lua config file doesn't existe. Path: /otserv/config.lua

c:\xampp\htdocs\tibiaot\classes/configlua.php line: 24

c:\xampp\htdocs\tibiaot\classes/configlua.php line: 12

c:\xampp\htdocs\tibiaot\system/load.init.php line: 42

c:\xampp\htdocs\tibiaot/index.php line: 18

E não faço a menor ideia de como arrumar Rss!

 

use por exemplo assim

$config['site']['serverPath'] = "C:/Users/Casa/Desktop/10.76/";

mas com o destino do seu server

http://img.gforum.tv/ver.php?i=b7f78849d84accc93d6635b7e000cc855cf450e5.jpg

 

alguem me ajuda pelo amor de deuuuuuuuuuuuuuuuuuuuuuuuuuuuus .

 

 

da esse erro e o otserver fecha pff me ajudaaaaa

 

http://img.gforum.tv/ver.php?i=b7f78849d84accc93d6635b7e000cc855cf450e5.jpg

http://www.mediafire.com/download/8rvqs9k0wed803l/Noble+e+Roaring+Lion+xml.rar

baixa o arquivo /\

 

depois adicione os arquivos na pasta monster

 

e depois em monsters.xml

 

<monster name="roaring lion" file="salamanders/roaring lion.xml"/>

<monster name="noble lion" file="salamanders/noble lion.xml"/>

[Dhjango 0]

@PeperHanc essa linha eu coloco no configlua.php? se não, onde eu coloco?

[PepeHanc 4]

@PeperHanc essa linha eu coloco no configlua.php? se não, onde eu coloco?

config.php   :]

[Heliton 1]

no site compativel com esse ot, estou tendo um problema no shop pois com a conta adm do site tento adicionar itens no shop mas n adiciona, da como ação completa mas o item n vai para o shop, alguma soloção?

 

 

__________________________

 

encontrei a solução

era só colocar a linha na tabela z_shop_offer na db

ALTER TABLE `z_shop_offer` ADD `pid` INT( 11 ) NOT NULL DEFAULT '0';

Editado Maio 22, 2015 por Heliton (veja o histórico de edições)

[maper007 12]

ola.. aki ta dizendo q é 10.77... tem como atualizar essa distro compilada ?? obrigado

[Mastersito 0]

alguien que me ayude como poner todo esto junto

[radreot 0]

- Estou com um problema no gesior hora de criar a account

 

O site cria a account normal com o ip local: 127.0.0.1

 

 

Mais quando tento criar pelo ip fixo, fica carregando e fica em branco, sem a conta ser criada

 

- Porem, se a account ja está criada, ele loga normalmente pelo ip fixo, portas 80, 8090, 7171, 7172, 4499, 3306 ja estão desbloquiadas tanto no modem quanto no Firewall

[asctimao12 0]

Bom dia pessoal, 

 

Gostaria que se possível ouvesse um video tutorial passo-a-passo para instalaçao dos novos OTs. Faz muito tempo que não mexo com OT e estou tendo grandes dificuldades em instalar esse OT 10.78 TFS 1.0... Baixei todos os arquivos solicitados e seguindo o tutorial http://www.tibiaking.com/forum/topic/13639-criando-site-para-seu-ot-server-com-vertrigo/consegui chegar no Gesior no STEP4, porem da o que esta em print na imagem em anexo. Pesquisei a respeito e ao que parece meu Database não tem os Char Sample. Por isso esta dando erro, alguem poderia me ajudar. Segue também meu arquivo Install.PHP.

 

Desde já pelo sinceras desculpas se estou postando essa minha dúvida no lugar errado. 

 

<?PHP

error_reporting(E_ALL & ~E_NOTICE);

$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['encryptionType'];

if($ency == 'sha1') 

return sha1($password);

if($ency == 'md5') 

return md5($password);

if($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 </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']['sqlHost'])) 

{

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

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

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

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

}

$sqlitefile = $config['server']['sqliteDatabase'];

if(strtolower($config['server']['encryptionType']) == 'md5')

$encryptionType = 'md5';

if(strtolower($config['server']['encryptionType']) == 'sha1')

$encryptionType = '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-7 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\trunk.r4041\</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']['sqlHost'])) 

{

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

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

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

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

}

$sqlitefile = $config['server']['sqliteDatabase'];

$encryptionType = '';

if(strtolower($config['server']['encryptionType']) == 'md5') 

{

$encryptionType = 'md5';

}

if(strtolower($config['server']['encryptionType']) == 'sha1') 

{

$encryptionType = '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 "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 "created" INTEGER(11) NOT NULL DEFAULT 0;'); } catch(PDOException $error) {}

try { $SQL->query('ALTER TABLE players ADD "nick_verify" VARCHAR(5) NOT NULL DEFAULT 0;'); } 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

try { $SQL->query("ALTER TABLE `accounts` ADD `page_lastday` INT( 11 ) NOT NULL;"); } catch(PDOException $error) {}

try { $SQL->query("ALTER TABLE `accounts` ADD `email_new` VARCHAR( 255 ) NOT NULL;"); } catch(PDOException $error) {}

try { $SQL->query("ALTER TABLE `accounts` ADD `email_new_time` INT( 15 ) NOT NULL;"); } catch(PDOException $error) {}

try { $SQL->query("ALTER TABLE `accounts` ADD `created` INT( 11 ) NOT NULL;"); } catch(PDOException $error) {}

try { $SQL->query("ALTER TABLE `accounts` ADD `rlname` VARCHAR( 255 ) NOT NULL;"); } catch(PDOException $error) {}

try { $SQL->query("ALTER TABLE `accounts` ADD `location` VARCHAR( 255 ) NOT NULL;"); } catch(PDOException $error) {}

try { $SQL->query("ALTER TABLE `accounts` ADD `page_access` INT( 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` INT( 11 ) NOT NULL DEFAULT '0';"); } catch(PDOException $error) {}

try { $SQL->query("ALTER TABLE `accounts` ADD `premium_points` INT( 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;'); } catch(PDOException $error) {}

try { $SQL->query('ALTER TABLE `guilds` ADD `logo_gfx_name` VARCHAR( 255 ) NOT NULL;'); } catch(PDOException $error) {}

echo "Added columns to table <b>guilds</b>.<br/>";

try { $SQL->query("ALTER TABLE `players` ADD `created` INT( 11 ) NOT NULL;"); } catch(PDOException $error) {}

try { $SQL->query("ALTER TABLE `players` ADD `nick_verify` VARCHAR( 5 ) NOT NULL;"); } 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` INT( 11 ) NOT NULL DEFAULT '0';"); } catch(PDOException $error) {}

try { $SQL->query("ALTER TABLE `players` ADD `comment` TEXT NOT NULL;"); } catch(PDOException $error) {}

echo "Added columns to table <b>players</b><br/>";

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;"); } catch(PDOException $error) {}

echo "Added table <b>z_news_big</b> (news).<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 "Added table <b>z_news_tickers</b> (tickers).<br/>"; } catch(PDOException $error) {}

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` 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;'); } catch(PDOException $error) {}

echo 'Added table <b>z_monsters</b> (monsters list).<br/>';

}

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

saveconfig_ini($config['site']);

echo 'All 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, "Gesior ACC - Xart prefix Edition installed!", 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().', "Xart", 1, 0, "Xart prefix Edition!", "Gesior ACC - Xart prefix Edition installed. All options should work fine. Report bugs on http://code.google.com/p/gesior-aac/issues/list.");');

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, 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, comment, created, hide_char, nick_verify) VALUES 

("Rook Sample", 0, 1, 1, 1, 0, 150, 150, 0, 44, 44, 44, 44, 128, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "", 420, 1, "", "", 1, "", "", "", "", "", "", "", 151200000, "", "", "", "", "", "", "", "", "", "", "", "", "",'.time().',1,1)');

echo "Added 'Rook Sample' character.<br/>";

} 

else 

{

echo "Character 'Rook Sample' already in database.<br/>";

}

$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 (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, comment, created, hide_char, nick_verify) VALUES 

("Sorcerer Sample", 0, 1, 1, 1, 1, 150, 150, 0, 44, 44, 44, 44, 128, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "", 420, 1, "", "", 1, "", "", "", "", "", "", "", 151200000, "", "", "", "", "", "", "", "", "", "", "", "", "",'.time().',1,1)');

echo "Added 'Sorcerer Sample' character.<br/>";

} 

else 

{

echo "Character 'Sorcerer Sample' already in database.<br/>";

}

$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 (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, comment, created, hide_char, nick_verify) VALUES 

("Druid Sample", 0, 1, 1, 1, 2, 150, 150, 0, 44, 44, 44, 44, 128, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "", 420, 1, "", "", 1, "", "", "", "", "", "", "", 151200000, "", "", "", "", "", "", "", "", "", "", "", "", "",'.time().',1,1)');

echo "Added 'Druid Sample' character.<br/>";

} 

else 

{

echo "Character 'Druid Sample' already in database.<br/>";

}

$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 (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, comment, created, hide_char, nick_verify) VALUES 

("Paladin Sample", 0, 1, 1, 1, 3, 150, 150, 0, 44, 44, 44, 44, 128, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "", 420, 1, "", "", 1, "", "", "", "", "", "", "", 151200000, "", "", "", "", "", "", "", "", "", "", "", "", "",'.time().',1,1)');

echo "Added 'Paladin Sample' character.<br/>";

} 

else 

{

echo "Character 'Paladin Sample' already in database.<br/>";

}

$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 (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, comment, created, hide_char, nick_verify) VALUES 

("Knight Sample", 0, 1, 1, 1, 4, 150, 150, 0, 44, 44, 44, 44, 128, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "", 420, 1, "", "", 1, "", "", "", "", "", "", "", 151200000, "", "", "", "", "", "", "", "", "", "", "", "", "",'.time().',1,1)');

echo "Added 'Knight Sample' character.<br/>";

} 

else 

{

echo "Character 'Knight Sample' already in database.<br/>";

$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><br/>';

}

}

if($step == '5') 

{

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

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

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

{

echo 'Admin account number is: <b>1</b><br/>Set new password to this account.<br>';

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><br>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", 6);

} 

else

{

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

$account->setPassword($newpass_to_db);

$account->unblock();

$account->save();

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

}

$_SESSION['account'] = 1;

$_SESSION['password'] = $newpass;

$logged = TRUE;

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

echo '<h1>Admin account number: 1<br>Admin account password: '.$_POST['newpass'].'</h1><br/><h3>It\'s end of first part of installation. Installation is blocked. From now don\'t modify file config.ini!<br>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:<br/><b>install = \"no\"</b><br/>to:</br><b>install = \"start\"</b><br/>and enter this site again.";

}

}

?>

[magnous 0]

o meu n esta abrindo, ta dando erro mysql

[cys9211 1]

Please upload compiled 10.78 for windows 64

[Dhjango 0]

Hehehe!!! Ta osso... Queria tanto jogar esse 10.78 offline, já larguei mão do site, o db ele nem conecta, aparece: MySql error MSG: Unknow database 'global-8'

Error: failed to connect to database.

Entrando pelo MySQL, eu vi q tem contas e chares criados. Minhas dúvidas, preciso realmente usar o site? Não posso usar essas ACC e chares já criados? Alguém teria um passo-a-passo de como colocar essa versão para rodar offline, ou ela já configurada pra isso?! Não Manjo nada de programação, sei um pouquinho sobre o phpmyadmin e fuçar em db, agora corrigir esses erros ta osso demais!! Salva eu aee... Rss!