Normal Error ao Instalar Gesior 0.3.8 Do tibiaking !

Sommer · Setembro 17, 2015

Notice: Undefined index: page in C:\xampp\htdocs\install.php on line 40

Notice: Undefined index: page in C:\xampp\htdocs\install.php on line 52

Notice: Undefined index: page in C:\xampp\htdocs\install.php on line 63

Alguem pode me ajudar?

L3K0T · Setembro 17, 2015

ajudo e sei remover esse erro, não o site que vc tenta instalar e sim o xampp erro no php.ini.

Vá em C:\xampp\php, abra o arquivo php.ini procure por error_reporting depois error_reporting = o que tiver lá, mude para error_reporting = E_ALL & ~E_NOTICE "reinicia seu apache" isso ai vlw!!!

Sommer · Setembro 17, 2015

Sim amigo, Mudei tudo conforme vc disse... e continua com o mesmo error =/

L3K0T · Setembro 17, 2015

então n mudo pq isso é no php

Sommer · Setembro 17, 2015

Amigo ... C:\xampp\php ..

tem 2 php.ini parecidos :

1º- php ( arquivo INI-DEVELOPMENT )

2º - php.ini-production ( arquivo INI-DEVELOPMENT )

Mudei nos 2 =[

peckface · Setembro 18, 2015

posta o seu config.php e seu index.php

Sommer · Setembro 18, 2015

Desculpa mas nao sei postar de outro jeito ...

Ai vai, Config.php

<?PHP

$config['site']['check_titles']= FALSE ; /// if true only titles from array belowwill be generated by headline script

$config['site']['allowed_titles'] = array();

//Worlds

$config['site']['worlds'] = array(0 => 'Server Name');

//Others

$config['site']['otslist.eu'] = 101; //server id in otslist.eu to show Players Online Chart (whoisonline.php)

$config['site']['quests'] = array('Annihilator' => 5000,'Demon Helmet' => 2645,'Pits of Inferno' => 5550); // list of quests, 'questname' => storage-id,

//ReCapatha http://recaptcha.net/whyrecaptcha.html

$config['site']['publickey'] = "6LfZAAoAAAAAALswKC2UCdCo_wf3ilh_C0qBhQJs "; // Public Key

$config['site']['privkey'] = "6LfZAAoAAAAAAA7_sZX1ZPomaqqTKBka5t6so0Un";; // Private Key

// ACCOUNT config

$config['site']['one_email'] = 0; // one e-mail can be used only to create one account 0 / 1

$config['site']['verify_code'] = 1; // show verify code to block stupid scripts, set 0 if you have problems with image

$config['site']['email_days_to_change'] = 2; // how many days user need to change e-mail to account - block hackers

$config['site']['newaccount_premdays'] = 10; // how many days receive new account

//Forum

$config['site']['forum_sections'] = array(1 => 'News', 2 => 'Staff Complaints', 3 => 'Tutorials', 4 => 'Pictures', 5 => 'Bug Report', 6 => 'Miscellaneous', 7 => 'Trade');

$config['site']['forum_sections_desc'] = array(1 => 'Here you can comment on the news.', 2 => 'Here you can report complaints about Staff Members.', 3 => 'Here you will find tutorials on things.', 4 => 'This board is all about pictures!', 5 => 'Report bugs in this forum.', 6 => 'Anything that doesn\'t already have a designated forum.', 7 => 'Buy and sell things.');

$config['site']['forum_level_limit'] = 30; // minimum 1 character with 50 lvl on account to post

$config['site']['forum_post_interval'] = 20; // 30 seconds between posts

$config['site']['forum_group_not_blocked'] = 1; // group id of player that can always post, remove post, remove threads

$config['site']['forum_posts_per_page'] = 20;

$config['site']['forum_threads_per_page'] = 20;

// USE ONLY IF YOU CONFIGURED E-MAIL AND IT WORK

$config['site']['create_account_verify_mail'] = 0; // when create account player must use right e-mail, he will receive random password to account like on RL tibia, 1 = yes, 0 = no

$config['site']['generate_new_reckey'] = 0; // let player generate new recovery key, he will receive e-mail with new rec key (not display on page, hacker can't generate rec key)

$config['site']['generate_new_reckey_price'] = 5; // you can get some Premium Points for new rec key

$config['site']['send_mail_when_change_password'] = 0; // send e-mail with new password when change password to account, set 0 if someone abuse to send spam

$config['site']['send_mail_when_generate_reckey'] = 0; // send e-mail with rec key (key is displayed on page anyway when generate), set 0 if someone abuse to send spam

$config['site']['send_register_email'] = 0; // send e-mail when register account

// CHARACTER config, format: ID_of_vocation => 'Name of Character to copy', load vocation name from $vocation_name[0] (below)

$config['site']['newchar_vocations'][0] = array(1 => 'Sorcerer Sample', 2 => 'Druid Sample', 3 => 'Paladin Sample', 4 => 'Knight Sample');

$config['site']['newchar_vocations'][1] = array(1 => 'Sorcerer Sample', 2 => 'Druid Sample', 3 => 'Paladin Sample', 4 => 'Knight Sample');

// sample, if rook only: $config['site']['newchar_vocations'][0] = array(0 => 'Rook Sample');

$config['site']['newchar_towns'][0] = array(2);

$config['site']['newchar_towns'][1] = array(1,2);

// sample, if all players should spawn in one city (city with ID 4): uncoment!!

//$config['site']['newchar_towns'] = array(4);

// list of vocations on ots (world 0)

$vocation_name[0][0] = array(0 => 'None', 1 => 'Sorcerer', 2 => 'Druid', 3 => 'Paladin', 4 => 'Knight'); // id => 'name' , $vocation_name[0] - promotion level 0, $vocation_name[0] - for world ID 0

$vocation_name[0][1] = array(1 => 'Master Sorcerer', 2 => 'Elder Druid', 3 => 'Royal Paladin', 4 => 'Elite Knight'); // id => 'name' , $vocation_name[1] - promotion level 1, $vocation_name[0] - for world ID 0

// list of vocations on ots (world 1)

$vocation_name[1][0] = array(0 => 'None', 1 => 'Sorcerer', 2 => 'Druid', 3 => 'Paladin', 4 => 'Knight'); // id => 'name' , $vocation_name[0] - promotion level 0, $vocation_name[1] - for world ID 1

$vocation_name[1][1] = array(1 => 'Master Sorcerer', 2 => 'Elder Druid', 3 => 'Royal Paladin', 4 => 'Elite Knight'); // id => 'name' , $vocation_name[1] - promotion level 1, $vocation_name[1] - for world ID 1

// list of towns on ots

$towns_list[0] = array(0 => 'Venore', 1 => 'Edron', 2 => 'Thais', 3 => 'Carlin'); // list of towns, id => 'name', $towns_list[0] - for world id 0

$towns_list[1] = array(0 => 'Venore', 1 => 'Edron', 2 => 'Thais', 3 => 'Carlin'); // list of towns, id => 'name', $towns_list[1] - for world id 1

// list of monsters on ots - names blocked, you can generate list of your monsters in acc. maker admin panel ( Reload Monsters )

$config['site']['monsters'] = array("amazon","valkyrie","carrion worm","rotworm","rotworm queen","cockroach","kongra","merlkin","sibang","crystal spider","giant spider","poison spider","scorpion","spider","tarantula","achad","axeitus headbanger","bloodpaw","bovinus","colerian the barbarian","cursed gladiator","frostfur","orcus the cruel","rocky","the hairy one","avalanche","drasilla","grimgor guteater","kreebosh the exile","slim","spirit of earth","spirit of fire","spirit of water","the dark dancer","the hag","darakan the executioner","deathbringer","fallen mooh'tah master ghar","gnorre chyllson","norgle glacierbeard","svoren the mad","the masked marauder","the obliverator","the pit lord","webster","barbarian bloodwalker","barbarian brutetamer","barbarian headsplitter","barbarian skullhunter","bear","panda","polar bear","braindeath","beholder","elder beholder","gazer","chicken","dire penguin","flamingo","parrot","penguin","seagull","terror bird","bazir","infernatil","thul","munster","son of verminor","xenia","zoralurk","big boss trolliver","foreman kneebiter","mad technomancer","man in the cave","lord of the elements","the count","the plasmother","dracola","the abomination","the handmaiden","mr. punish","the countess sorrow","the imperor","massacre","apocalypse","brutus bloodbeard","deadeye devious","demodras","dharalion","fernfang","ferumbras","general murius","ghazbaran","grorlam","lethal lissy","morgaroth","necropharus","orshabaal","ron the ripper","the evil eye","the horned fox","the old widow","tiquandas revenge","apprentice sheng","dog","hellhound","war wolf","winter wolf","wolf","chakoya toolshaper","chakoya tribewarden","chakoya windcaller","blood crab","crab","frost giant","frost giantess","ice golem","yeti","acolyte of the cult","adept of the cult","enlightened of the cult","novice of the cult","ungreez","dark torturer","demon","destroyer","diabolic imp","fire devil","fury","hand of cursed fate","juggernaut","nightmare","plaguesmith","blue djinn","efreet","green djinn","marid","frost dragon","wyrm","sea serpent","dragon lord","dragon","hydra","dragon hatchling","dragon lord hatchling","frost dragon hatchling","dwarf geomancer","dwarf guard","dwarf soldier","dwarf","dworc fleshhunter","dworc venomsniper","dworc voodoomaster","elephant","mammoth","elf arcanist","elf scout","elf","charged energy elemental","energy elemental","massive energy elemental","overcharged energy elemental","energy overlord","cat","lion","tiger","azure frog","coral frog","crimson frog","green frog","orchid frog","toad","jagged earth elemental","muddy earth elemental","earth elemental","massive earth elemental","earth overlord","gargoyle","stone golem","ghost","phantasm","phantasm","pirate ghost","spectre","cyclops smith","cyclops drone","behemoth","cyclops","slick water elemental","roaring water elemental","ice overlord","water elemental","massive water elemental","ancient scarab","butterfly","bug","centipede","exp bug","larva","scarab","wasp","lizard sentinel","lizard snakecharmer","lizard templar","minotaur archer","minotaur guard","minotaur mage","minotaur","squirrel","goblin demon","badger","bat","deer","the halloween hare","hyaena","pig","rabbit","silver rabbit","skunk","wisp","dark monk","monk","tha exp carrier","necromancer","priestess","orc berserker","orc leader","orc rider","orc shaman","orc spearman","orc warlord","orc warrior","orc","goblin leader","goblin scavenger","goblin","goblin assassin","assasin","bandit","black knight","hero","hunter","nomad","smuggler","stalker","poacher","wild warrior","ashmunrah","dipthrah","mahrdis","morguthis","omruc","rahemos","thalas","vashresamun","pirate buccaneer","pirate corsair","pirate cutthroat","pirate marauder","carniphila","spit nettle","fire overlord","massive fire elemental","blistering fire elemental","blazing fire elemental","fire elemental","hellfire fighter","quara constrictor scout","quara hydromancer scout","quara mantassin scout","quara pincher scout","quara predator scout","quara constrictor","quara hydromancer","quara mantassin","quara pincher","quara predator","cave rat","rat","cobra","crocodile","serpent spawn","snake","wyvern","black sheep","sheep","mimic","betrayed wraith","bonebeast","demon skeleton","lost soul","pirate skeleton","skeleton","skeleton warrior","undead dragon","defiler","slime2","slime","bog raider","ice witch","warlock","witch","bones","fluffy","grynch clan goblin","hacker","minishabaal","primitive","tibia bug","undead minion","annihilon","hellgorak","latrivan","madareth","zugurosh","ushuriel","golgordan","thornback tortoise","tortoise","eye of the seven","deathslicer","flamethrower","magicthrower","plaguethrower","poisonthrower","shredderthrower","troll champion","frost troll","island troll","swamp troll","troll","banshee","blightwalker","crypt shambler","ghoul","lich","mummy","vampire","grim reaper","trainer","forest dragon","knight","paladin","druid","sorcerer","guard","mercenary","thief","toxiros","pyramo","lazarus","zathroth","goshnar","durin","demora","orc champion","lumenia","dracula","alezzo","prince almirith","elf warlord","random noob","magebomb");

// list of NPCs on ots - names blocked

$config['site']['npc'] = array('alice', 'oarkhal', 'equer', 'parkhal', 'leoric', 'sarkhal', 'pallo', 'riona', 'her miona', 'varkhal', 'eura', 'blitz', 'markhal', 'wengo', 'larkhal');

$config['site']['max_players_per_account'] = 35; // max. number of characters on account

// GUILDS config

$config['site']['guild_need_level'] = 8; // minimum level to create guild

$config['site']['guild_need_pacc'] = 0; // guild need pacc 0 / 1

$config['site']['guild_image_size_kb'] = 50; // maximum size of image in KB

$config['site']['guild_description_chars_limit'] = 1000; // limit of guild description

$config['site']['guild_description_lines_limit'] = 6; // limit of lines, if description has more lines it will be showed as long text, without 'enters'

$config['site']['guild_motd_chars_limit'] = 150; // limit of MOTD (show in game?)

// E-MAIL config

$config['site']['send_emails'] = 0; // is acc. maker configured to send e-mails?

$config['site']['mail_address'] = "[email protected]"; // e-mail address

$config['site']['smtp_enabled'] = "yes"; // send by smtp or mail function (set 0 if use mail function)

$config['site']['smtp_host'] = "smtp.gmail.com"; // address

$config['site']['smtp_port'] = 465; // port

$config['site']['smtp_auth'] = "yes"; // need authorization? (set 0 if not need auth)

$config['site']['smtp_user'] = "login"; // login

$config['site']['smtp_pass'] = "password"; // password

// ACC MAKER OPTIONS config

$config['site']['access_news'] = 2; // access level needed to edit news

$config['site']['access_admin_panel'] = 3; // access level needed to open admin panel

$config['site']['news_big_limit'] = 3; // limit of news on latest news page

$config['site']['news_ticks_limit'] = 5; // limit of ticker news on latest news page

$config['site']['show_creationdate'] = 1; // show date of character creation 1 = yes, 0 = no (when use Search Player)

$config['site']['last_deaths_limit'] = 40; // max. number of death on last death page

$config['site']['players_group_id_block'] = 4; // don't show in statistics players with group ID higher (or equal) then (show tutors, senior tutors and normal players)

$config['site']['support_group_id'] = 2; // on game masters list show players with group id 2 or higher

$config['site']['shop_system'] = 1; // show server shop page? 1 = yes, 0 = no, use only if you installed LUA scripts of shop

$config['site']['download_page'] = 1; // show download page? 1 = yes, 0 = no

$config['site']['serverinfo_page'] = 1; // show server info page? 1 = yes, 0 = no

$config['site']['verify_code_shop'] = 0; // show verify code when player try to check premium code

$config['site']['gallery_page'] = 0; // show gallery page? 1 = yes, 0 = no

$config['site']['email_lai_sec_interval'] = 180; // time in seconds between e-mails to one account from lost account interface, block spam

$config['site']['show_marriage_info'] = 0; // show marriage, 1 = yes, 0 = no

$config['site']['show_skills_info'] = 0;//show players skills, 1 = yes, 0 = no

$config['site']['show_vip_status'] = 0;// show vip status, 1 = yes, 0 = no

$config['site']['show_vip_storage'] = 0;// the storage of vip

$config['site']['show_outfit'] = 0;// show outfit, 1 = yes, 0 = no

$config['site']['show_signature'] = 0;// show signature, 1 = yes, 0 = no

$config['site']['screenoftheday'] = 0;// show screenshot of the day

$config['site']['worldtransfer'] = 1;//1-Enable/0-Disable Character World Transfer

$config['site']['worldtransferprice'] = 10;//Price for Character World Transfer

$config['site']['transfermonths'] = 6;//Months for which you cannot make World Transfer with a character

// layout, available layouts: rasta,tibiacom,darkritual

$config['site']['layout'] = "tibiacom"; // layout name

?>

e Agr o

Index.php

<?PHP

session_start();

ob_start("ob_gzhandler");

//require('./exaBD.php');

function microtime_float() {

list($usec, $sec) = explode(" ", microtime());

return ((float)$usec + (float)$sec);

}

$time_start = microtime_float();

//##### CONFIG #####

include('config-and-functions.php');

$action = $_REQUEST['action'];

//##### LOGOUT #####

if($action == "logout") {

unset($_SESSION['account']);

unset($_SESSION['password']);

}

//##### LOGIN #####

$logged = FALSE;

if(isset($_SESSION['account'])) {

$account_logged = $ots->createObject('Account');

$account_logged->load($_SESSION['account']);

if($account_logged->isLoaded() && $account_logged->getPassword() == $_SESSION['password']) {

$logged = TRUE;

$group_id_of_acc_logged = $account_logged->getPageAccess();

} else {

$logged = FALSE;

unset($_SESSION['account']);

unset($account_logged);

}

}

$login_account = strtoupper(trim($_POST['account_login']));

$login_password = trim($_POST['password_login']);

if(!$logged && !empty($login_account) && !empty($login_password)) {

$login_password = password_ency($login_password);

$account_logged = $ots->createObject('Account');

$account_logged->find($login_account);

if($account_logged->isLoaded()) {

if($login_password == $account_logged->getPassword()) {

$_SESSION['account'] = $account_logged->getId();

$_SESSION['password'] = $login_password;

$logged = TRUE;

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

$group_id_of_acc_logged = $account_logged->getPageAccess();

} else

$logged = FALSE;

}

}

//#### LOAD PAGE ##########

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

$_REQUEST['subtopic'] = "latestnews";

$subtopic = "latestnews";

}

switch($_REQUEST['subtopic']) {

case "latestnews":

$topic = "Latest News";

$subtopic = "latestnews";

include("latestnews.php");

break;

case "creatures";

$topic = "Creatures";

$subtopic = "creatures";

include("creatures.php");

break;

case "spells";

$topic = "Spells";

$subtopic = "spells";

include("spells.php");

break;

case "bugtracker";

$topic = "Bug Tracker";

$subtopic = "bugtracker";

include("bug.php");

break;

case "experiencetable";

$topic = "Experience Table";

$subtopic = "experiencetable";

include("experiencetable.php");

break;

case "characters";

$topic = "Characters";

$subtopic = "characters";

include("characters.php");

break;

case "whoisonline";

$topic = "Who is online?";

$subtopic = "whoisonline";

include("whoisonline.php");

break;

case "highscores";

$topic = "Highscores";

$subtopic = "highscores";

include("highscores.php");

break;

case "killstatistics";

$topic = "Last Kills";

$subtopic = "killstatistics";

include("killstatistics.php");

break;

case "guilds";

$topic = "Guilds";

$subtopic = "guilds";

include("guilds.php");

break;

case "accountmanagement";

$topic = "Account Management";

$subtopic = "accountmanagement";

include("accountmanagement.php");

break;

case "createaccount";

$topic = "Create Account";

$subtopic = "createaccount";

include("createaccount.php");

break;

case "lostaccount";

$topic = "Lost Account Interface";

$subtopic = "lostaccount";

include("lostaccount.php");

break;

case "tibiarules";

$topic = "Server Rules";

$subtopic = "tibiarules";

include("tibiarules.php");

break;

case "adminpanel":

$topic = "Admin Panel";

$subtopic = "adminpanel";

include("adminpanel.php");

break;

case "confirmacao":

$topic = "Confirmacao";

$subtopic = "confirmacao";

include("confirmacao.php");

break;

case "vantagens":

$topic = "Vantagens";

$subtopic = "vantagens";

include("vantagens.php");

break;

case "forum":

$topic = "Forum";

$subtopic = "forum";

include("forum.php");

break;

case "team";

$subtopic = "team";

$topic = "Gamemasters List";

include("team.php");

break;

case "downloads";

$subtopic = "downloads";

$topic = "Downloads";

include("downloads.php");

break;

case "serverinfo";

$subtopic = "serverinfo";

$topic = "Server Info";

include("serverinfo.php");

break;

case "shopsystem";

$subtopic = "shopsystem";

$topic = "Shop System";

include("shopsystem.php");

break;

case "doacao";

$subtopic = "doacao";

$topic = "Doacao";

include("doacao.php");

break;

case "gallery";

$subtopic = "gallery";

$topic = "Gallery";

include("gallery.php");

break;

case "namelock";

$subtopic = "namelock";

$topic = "Namelock Manager";

include("namelocks.php");

break;

case "archive";

$subtopic = "archive";

$topic = "News Archives";

include("archive.php");

break;

case "mail";

$subtopic = "mail";

$topic = "Mass emails sender";

include("mail.php");

break;

case "shopadmin";

$subtopic = "shopadmin";

$topic = "Shop Admin";

include("shopadmin.php");

break;

case "records";

$subtopic = "records";

$topic = "Players Online Records";

include("records.php");

break;

case "restarter";

$subtopic = "restarter";

$topic = "Restarter";

include("restarter.php");

break;

case "bans";

$subtopic = "bans";

$topic = "Ban List";

include("bans.php");

break;

case "polls";

$topic = "Polls";

$subtopic = "polls";

include("polls.php");

break;

case "changelog";

$topic = "Changelog";

$subtopic = "changelog";

include("changelog.php");

break;

case "fragers";

$topic = "Top Fragers";

$subtopic = "fragers";

include("fragers.php");

break;

case "paypal";

$topic = "Donate via PayPal";

$subtopic = "paypal";

include("paypal.php");

break;

}

if(empty($topic)) {

$title = $GLOBALS['config']['server']["serverName"]." - OTS";

$main_content .= 'Invalid subtopic. Can\'t load page.';

} else {

$title = $GLOBALS['config']['server']["serverName"]." - ".$topic;

}

//#####LAYOUT#####

$layout_header = '<script type=\'text/javascript\'>

function GetXmlHttpObject()

{

var xmlHttp=null;

try

{

xmlHttp=new XMLHttpRequest();

}

catch (e)

{

try

{

xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");

}

catch (e)

{

xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");

}

}

return xmlHttp;

}

function MouseOverBigButton(source)

{

source.firstChild.style.visibility = "visible";

}

function MouseOutBigButton(source)

{

source.firstChild.style.visibility = "hidden";

}

function BigButtonAction(path)

{

window.location = path;

}

var';

if($logged) { $layout_header .= "loginStatus=1; loginStatus='true';"; } else { $layout_header .= "loginStatus=0; loginStatus='false';"; };

$layout_header .= " var activeSubmenuItem='".$subtopic."';</script>";

include($layout_name."/layout.php");

ob_end_flush();

?>

Editado Setembro 18, 2015 por Sommer (veja o histórico de edições)

peckface · Setembro 18, 2015

Qual a versao de TFS q vc usa?

Posta o install.php

Sommer · Setembro 18, 2015

Entao peguei ele com o Tfs 2.0

Como posto ele Aqui sem ter que copiar Tudo? é muito longo ! Tipo spoiler

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

</frameset>

</html>';

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

echo '<h2>MENU</h2> IF NOT INSTALLED: 

<a href="install.php?page=step&step=start" target="step">0. Informations</a> 

<a href="install.php?page=step&step=1" target="step">1. Set server path</a> 

<a href="install.php?page=step&step=2" target="step">2. Check DataBase connection</a> 

<a href="install.php?page=step&step=3&server_conf=yes" target="step">3. Add tables and columns to DB</a> 

<a href="install.php?page=step&step=4&server_conf=yes" target="step">4. Add samples to DB</a> 

<a href="install.php?page=step&step=5&server_conf=yes" target="step">5. Set Admin Account</a> 

FOR ADMINS: 

<a href="index.php?subtopic=adminpanel&action=install_monsters" target="step">6. Load Monsters from OTS</a> 

<a href="index.php?subtopic=adminpanel&action=install_spells" target="step">7. Load Spells from OTS</a> ';

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 '<h1>STEP '.$step.'</h1>Informations ';

echo 'Bem vindo ao Gesior ACC 0.3.8! First do steps 1-5 one by one, later (when you will be logged on admin account) press on links to steps 6-8 to load configuration from OTS.';

}

if($step == '1') {

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

echo '<h1>STEP '.$step.'</h1>Check server configuration ';

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

}

else

{

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

}

}

else

{

echo 'Can\'t load file config.lua from '.$config['site']['server_path'].'config.lua 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: C:\Documents and Settings\Gesior\Desktop\TFS 0.3.6\ or /home/ots/tfs/ 

After install please delate all comments from config.lua

 Example:

<pre>-- Account manager</pre>

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

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

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

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

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,

"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? ";}

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("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? ";}

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,

`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 `zaypay_payment` (

`payID` bigint(30) NOT NULL,

`account_id` int(20) NOT NULL,

`status` varchar(255) NOT NULL,

PRIMARY KEY (`payID`)

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

echo "Added table zaypay_payment. ";

}

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

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,

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

PRIMARY KEY (uid)

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

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 `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=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=0;");

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, "Bem vindo ao Gesior 0.3.8 Edited by Natan Beckman!", 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, 150, 150, 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, 1, 1, 150, 150, 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, 1, 2, 150, 150, 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, 1, 3, 150, 150, 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, 1, 4, 150, 150, 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", 3);

} else {

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

$account->setPassword($newpass_to_db);

$account->unblock();

$account->save();

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

}

$_SESSION['account'] = 1;

$_SESSION['password'] = $newpass;

$logged = TRUE;

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

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

}

?>

peckface · Setembro 18, 2015

apaga tudo oque esta dentro do seu install.php e coloca isso

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

<cke:body>Frames don\'t work. Install Firefox </cke:body>

';
if($_REQUEST['page'] == 'menu')
echo '
MENU
IF NOT INSTALLED:

0. Informations

1. Set server path

2. Check DataBase connection

3. Add tables and columns to DB

4. Add samples to DB

5. Set Admin Account

FOR ADMINS:

6. Load Monsters from OTS

7. Load Spells from OTS
';
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 '
STEP '.$step.'
Informations
';
echo 'Bem vindo ao Gesior ACC 0.3.8! First do steps 1-5 one by one, later (when you will be logged on admin account) press on links to steps 6-8 to load configuration from OTS.';
}
if($step == '1') {
if(isset($_REQUEST['server_path'])) {
echo '
STEP '.$step.'
Check server configuration
';
$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 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: STEP 2 - check database connection';
}
else
{
echo 'File config.lua loaded from '.$config['site']['server_path'].'config.lua and it\'s not valid TFS config.lua file. Go to STEP 1 - select other directory. If it\'s your config.lua file from TFS contact with acc. maker author.';
}
}
else
{
echo 'Can\'t load file config.lua from '.$config['site']['server_path'].'config.lua File doesn\'t exist in selected directory. Go to STEP 1 - select other directory.';
}
}
else
{
echo '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:
-- Account manager
';
}
}
if($step == '2') {
echo '
STEP '.$step.'
Check database connection
';
echo 'If you don\'t see any errors press link to STEP 3 - Add tables and columns to DB. 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');
$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();
$config['site']['install'] = 3;
saveconfig_ini($config['site']);
}
if($step == '3') {
echo '
STEP '.$step.'
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) {}
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,
"gfx_name" VARCHAR(255) NOT NULL)'); } catch(PDOException $error) {}
echo "Added table z_monsters (monsters list).
";
}
elseif($config['server']['sqlType'] == "mysql") {
echo "
Add columns to table accounts
";
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?
";}
echo "
Add columns to table guilds
";
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 "
Add columns to table players
";
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("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?
";}
echo "
Add new tables to database
";
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,
`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 `zaypay_payment` (
`payID` bigint(30) NOT NULL,
`account_id` int(20) NOT NULL,
`status` varchar(255) NOT NULL,
PRIMARY KEY (`payID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;");
echo "Added table zaypay_payment.
";
}
catch(PDOException $error) { echo "Table zaypay_payment not added. Already exist?
";}
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,
`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,
PRIMARY KEY (uid)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;");
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 `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=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=0;");
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 STEP 4 - Add samples';
}
if($step == '4') {
echo '
STEP '.$step.'
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, "Bem vindo ao Gesior 0.3.8 Edited by Natan Beckman!", 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, 150, 150, 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, 1, 1, 150, 150, 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, 1, 2, 150, 150, 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, 1, 3, 150, 150, 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, 1, 4, 150, 150, 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 STEP 5 - Set Admin Account';
} 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 STEP 5 - Set Admin Account
';
}
}
if($step == '5') {
echo '
STEP '.$step.'
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:
(Don\'t give it password to anyone!)';
echo '
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. GO BACK 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", 3);
} else {
$number = $account->create(1,1,1);
$account->setPassword($newpass_to_db);
$account->unblock();
$account->save();
$account->setCustomField("page_access", 3);
}
$_SESSION['account'] = 1;
$_SESSION['password'] = $newpass;
$logged = TRUE;
$account->setCustomField("page_lastday", time());
echo '
Admin account number: 1
Admin account password: '.$_POST['newpass'].'

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.
';
$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.";
}
?>

agora vai na pasta do seu xampp C://xampp/php/php.ini (apaga tudo q tem dentro do php.ini e coloca isso:




;;;;;;;;;;;

; WARNING ;

;;;;;;;;;;;

; This is the default settings file for new PHP installations.

; By default, PHP installs itself with a configuration suitable for

; development purposes, and *NOT* for production purposes.

; For several security-oriented considerations that should be taken

; before going online with your site, please consult php.ini-recommended

; and http://php.net/manual/en/security.php. 



;;;;;;;;;;;;;;;;;;;

; About php.ini ;

;;;;;;;;;;;;;;;;;;;

; This file controls many aspects of PHP's behavior. In order for PHP to

; read it, it must be named 'php.ini'. PHP looks for it in the current

; working directory, in the path designated by the environment variable

; PHPRC, and in the path that was defined in compile time (in that order).

; Under Windows, the compile-time path is the Windows directory. The

; path in which the php.ini file is looked for can be overridden using

; the -c argument in command line mode.

;

; The syntax of the file is extremely simple. Whitespace and Lines

; beginning with a semicolon are silently ignored (as you probably guessed).

; Section headers (e.g. [Foo]) are also silently ignored, even though

; they might mean something in the future.

;

; Directives are specified using the following syntax:

; directive = value

; Directive names are *case sensitive* - foo=bar is different from FOO=bar.

;

; The value can be a string, a number, a PHP constant (e.g. E_ALL or M_PI), one

; of the INI constants (On, Off, True, False, Yes, No and None) or an expression

; (e.g. E_ALL & ~E_NOTICE), or a quoted string ("foo").

;

; Expressions in the INI file are limited to bitwise operators and parentheses:

; | bitwise OR

; & bitwise AND

; ~ bitwise NOT

; ! boolean NOT

;

; Boolean flags can be turned on using the values 1, On, True or Yes.

; They can be turned off using the values 0, Off, False or No.

;

; An empty string can be denoted by simply not writing anything after the equal

; sign, or by using the None keyword:

;

; foo = ; sets foo to an empty string

; foo = none ; sets foo to an empty string

; foo = "none" ; sets foo to the string 'none'

;

; If you use constants in your value, and these constants belong to a

; dynamically loaded extension (either a PHP extension or a Zend extension),

; you may only use these constants *after* the line that loads the extension.

;

;

;;;;;;;;;;;;;;;;;;;

; About this file ;

;;;;;;;;;;;;;;;;;;;

; All the values in the php.ini-dist file correspond to the builtin

; defaults (that is, if no php.ini is used, or if you delete these lines,

; the builtin defaults will be identical).



;;;;;;;;;;;;;;;;;;;;

; Language Options ;

;;;;;;;;;;;;;;;;;;;;


; Enable the PHP scripting language engine under Apache.

engine = On


; Enable compatibility mode with Zend Engine 1 (PHP 4.x)

zend.ze1_compatibility_mode = Off


; Allow the tags are recognized.

; NOTE: Using short tags should be avoided when developing applications or

; libraries that are meant for redistribution, or deployment on PHP

; servers which are not under your control, because short tags may not

; be supported on the target server. For portable, redistributable code,

; be sure not to use short tags.

short_open_tag = On


; Allow ASP-style <% %> tags.

asp_tags = Off


; The number of significant digits displayed in floating point numbers.

precision = 12


; Enforce year 2000 compliance (will cause problems with non-compliant browsers)

y2k_compliance = On


; Output buffering allows you to send header lines (including cookies) even

; after you send body content, at the price of slowing PHP's output layer a

; bit. You can enable output buffering during runtime by calling the output

; buffering functions. You can also enable output buffering for all files by

; setting this directive to On. If you wish to limit the size of the buffer

; to a certain size - you can use a maximum number of bytes instead of 'On', as

; a value for this directive (e.g., output_buffering=4096).

output_buffering = Off


; You can redirect all of the output of your scripts to a function. For

; example, if you set output_handler to "mb_output_handler", character

; encoding will be transparently converted to the specified encoding.

; Setting any output handler automatically turns on output buffering.

; Note: People who wrote portable scripts should not depend on this ini

; directive. Instead, explicitly set the output handler using ob_start().

; Using this ini directive may cause problems unless you know what script

; is doing.

; Note: You cannot use both "mb_output_handler" with "ob_iconv_handler"

; and you cannot use both "ob_gzhandler" and "zlib.output_compression".

; Note: output_handler must be empty if this is set 'On' !!!!

; Instead you must use zlib.output_handler.

;output_handler =


; Transparent output compression using the zlib library

; Valid values for this option are 'off', 'on', or a specific buffer size

; to be used for compression (default is 4KB)

; Note: Resulting chunk size may vary due to nature of compression. PHP

; outputs chunks that are few hundreds bytes each as a result of

; compression. If you prefer a larger chunk size for better

; performance, enable output_buffering in addition.

; Note: You need to use zlib.output_handler instead of the standard

; output_handler, or otherwise the output will be corrupted.

zlib.output_compression = Off


; You cannot specify additional output handlers if zlib.output_compression

; is activated here. This setting does the same as output_handler but in

; a different order.

;zlib.output_handler =


; Implicit flush tells PHP to tell the output layer to flush itself

; automatically after every output block. This is equivalent to calling the

; PHP function flush() after each and every call to print() or echo() and each

; and every HTML block. Turning this option on has serious performance

; implications and is generally recommended for debugging purposes only.

implicit_flush = Off


; The unserialize callback function will be called (with the undefined class'

; name as parameter), if the unserializer finds an undefined class

; which should be instantiated.

; A warning appears if the specified function is not defined, or if the

; function doesn't include/implement the missing class.

; So only set this entry, if you really want to implement such a

; callback-function.

unserialize_callback_func=


; When floats & doubles are serialized store serialize_precision significant

; digits after the floating point. The default value ensures that when floats

; are decoded with unserialize, the data will remain the same.

serialize_precision = 100


; Whether to enable the ability to force arguments to be passed by reference

; at function call time. This method is deprecated and is likely to be

; unsupported in future versions of PHP/Zend. The encouraged method of

; specifying which arguments should be passed by reference is in the function

; declaration. You're encouraged to try and turn this option Off and make

; sure your scripts work properly with it in order to ensure they will work

; with future versions of the language (you will receive a warning each time

; you use this feature, and the argument will be passed by value instead of by

; reference).

allow_call_time_pass_reference = On


;

; Safe Mode

;

safe_mode = Off


; By default, Safe Mode does a UID compare check when

; opening files. If you want to relax this to a GID compare,

; then turn on safe_mode_gid.

safe_mode_gid = Off


; When safe_mode is on, UID/GID checks are bypassed when

; including files from this directory and its subdirectories.

; (directory must also be in include_path or full path must

; be used when including)

safe_mode_include_dir =


; When safe_mode is on, only executables located in the safe_mode_exec_dir

; will be allowed to be executed via the exec family of functions.

safe_mode_exec_dir =


; Setting certain environment variables may be a potential security breach.

; This directive contains a comma-delimited list of prefixes. In Safe Mode,

; the user may only alter environment variables whose names begin with the

; prefixes supplied here. By default, users will only be able to set

; environment variables that begin with PHP_ (e.g. PHP_FOO=BAR).

;

; Note: If this directive is empty, PHP will let the user modify ANY

; environment variable!

safe_mode_allowed_env_vars = PHP_


; This directive contains a comma-delimited list of environment variables that

; the end user won't be able to change using putenv(). These variables will be

; protected even if safe_mode_allowed_env_vars is set to allow to change them.

safe_mode_protected_env_vars = LD_LIBRARY_PATH


; open_basedir, if set, limits all file operations to the defined directory

; and below. This directive makes most sense if used in a per-directory

; or per-virtualhost web server configuration file. This directive is

; *NOT* affected by whether Safe Mode is turned On or Off.

;open_basedir =


; This directive allows you to disable certain functions for security reasons.

; It receives a comma-delimited list of function names. This directive is

; *NOT* affected by whether Safe Mode is turned On or Off.

disable_functions =


; This directive allows you to disable certain classes for security reasons.

; It receives a comma-delimited list of class names. This directive is

; *NOT* affected by whether Safe Mode is turned On or Off.

disable_classes =


; Colors for Syntax Highlighting mode. Anything that's acceptable in

; would work.

;highlight.string = #DD0000

;highlight.comment = #FF9900

;highlight.keyword = #007700

;highlight.bg = #FFFFFF

;highlight.default = #0000BB

;highlight.html = #000000


; If enabled, the request will be allowed to complete even if the user aborts

; the request. Consider enabling it if executing long request, which may end up

; being interrupted by the user or a browser timing out.

; ignore_user_abort = On


;

; Misc

;

; Decides whether PHP may expose the fact that it is installed on the server

; (e.g. by adding its signature to the Web server header). It is no security

; threat in any way, but it makes it possible to determine whether you use PHP

; on your server or not.

expose_php = On



;;;;;;;;;;;;;;;;;;;

; Resource Limits ;

;;;;;;;;;;;;;;;;;;;


max_execution_time = 60 ; Maximum execution time of each script, in seconds

max_input_time = 60 ; Maximum amount of time each script may spend parsing request data

memory_limit = 32M ; Maximum amount of memory a script may consume (16MB)



;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

; Error handling and logging ;

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;


; error_reporting is a bit-field. Or each number up to get desired error

; reporting level

; E_ALL - All errors and warnings (doesn't include E_STRICT)

; E_ERROR - fatal run-time errors

; E_WARNING - run-time warnings (non-fatal errors)

; E_PARSE - compile-time parse errors

; E_NOTICE - run-time notices (these are warnings which often result

; from a bug in your code, but it's possible that it was

; intentional (e.g., using an uninitialized variable and

; relying on the fact it's automatically initialized to an

; empty string)

; E_STRICT - run-time notices, enable to have PHP suggest changes

; to your code which will ensure the best interoperability

; and forward compatibility of your code

; E_CORE_ERROR - fatal errors that occur during PHP's initial startup

; E_CORE_WARNING - warnings (non-fatal errors) that occur during PHP's

; initial startup

; E_COMPILE_ERROR - fatal compile-time errors

; E_COMPILE_WARNING - compile-time warnings (non-fatal errors)

; E_USER_ERROR - user-generated error message

; E_USER_WARNING - user-generated warning message

; E_USER_NOTICE - user-generated notice message

;

; Examples:

;

; - Show all errors, except for notices and coding standards warnings

;

;error_reporting = E_ALL & ~E_NOTICE

;

; - Show all errors, except for notices

;

;error_reporting = E_ALL & ~E_NOTICE | E_STRICT

;

; - Show only errors

;

;error_reporting = E_COMPILE_ERROR|E_ERROR|E_CORE_ERROR

;

; - Show all errors except for notices and coding standards warnings

;

error_reporting = E_ALL & ~E_NOTICE


; Print out errors (as a part of the output). For production web sites,

; you're strongly encouraged to turn this feature off, and use error logging

; instead (see below). Keeping display_errors enabled on a production web site

; may reveal security information to end users, such as file paths on your Web

; server, your database schema or other information.

display_errors = On


; Even when display_errors is on, errors that occur during PHP's startup

; sequence are not displayed. It's strongly recommended to keep

; display_startup_errors off, except for when debugging.

display_startup_errors = Off


; Log errors into a log file (server-specific log, stderr, or error_log (below))

; As stated above, you're strongly advised to use error logging in place of

; error displaying on production web sites.

log_errors = Off


; Set maximum length of log_errors. In error_log information about the source is

; added. The default is 1024 and 0 allows to not apply any maximum length at all.

log_errors_max_len = 1024


; Do not log repeated messages. Repeated errors must occur in same file on same

; line until ignore_repeated_source is set true.

ignore_repeated_errors = Off


; Ignore source of message when ignoring repeated messages. When this setting

; is On you will not log errors with repeated messages from different files or

; sourcelines.

ignore_repeated_source = Off


; If this parameter is set to Off, then memory leaks will not be shown (on

; stdout or in the log). This has only effect in a debug compile, and if

; error reporting includes E_WARNING in the allowed list

report_memleaks = On


; Store the last error/warning message in $php_errormsg (boolean).

track_errors = Off


; Disable the inclusion of HTML tags in error messages.

; Note: Never use this feature for production boxes.

;html_errors = Off


; If html_errors is set On PHP produces clickable error messages that direct

; to a page describing the error or function causing the error in detail.

; You can download a copy of the PHP manual from http://www.php.net/docs.php

; and change docref_root to the base URL of your local copy including the

; leading '/'. You must also specify the file extension being used including

; the dot.

; Note: Never use this feature for production boxes.

;docref_root = "/phpmanual/"

;docref_ext = .html


; String to output before an error message.

;error_prepend_string = ""


; String to output after an error message.

;error_append_string = ""


; Log errors to specified file.

;error_log = "C:\xampp\apache\logs\phperror.log"


; Log errors to syslog (Event Log on NT, not valid in Windows 95).

;error_log = syslog



;;;;;;;;;;;;;;;;;

; Data Handling ;

;;;;;;;;;;;;;;;;;

;

; Note - track_vars is ALWAYS enabled as of PHP 4.0.3


; The separator used in PHP generated URLs to separate arguments.

; Default is "&".

arg_separator.output = "&"


; List of separator(s) used by PHP to parse input URLs into variables.

; Default is "&".

; NOTE: Every character in this directive is considered as separator!

;arg_separator.input = ";&"


; This directive describes the order in which PHP registers GET, POST, Cookie,

; Environment and Built-in variables (G, P, C, E & S respectively, often

; referred to as EGPCS or GPC). Registration is done from left to right, newer

; values override older values.

variables_order = "EGPCS"


; Whether or not to register the EGPCS variables as global variables. You may

; want to turn this off if you don't want to clutter your scripts' global scope

; with user data. This makes most sense when coupled with track_vars - in which

; case you can access all of the GPC variables through the $HTTP_*_VARS[],

; variables.

;

; You should do your best to write your scripts so that they do not require

; register_globals to be on; Using form variables as globals can easily lead

; to possible security problems, if the code is not very well thought of.

register_globals = Off


; Whether or not to register the old-style input arrays, HTTP_GET_VARS

; and friends. If you're not using them, it's recommended to turn them off,

; for performance reasons.

register_long_arrays = On


; This directive tells PHP whether to declare the argv&argc variables (that

; would contain the GET information). If you don't use these variables, you

; should turn it off for increased performance.

register_argc_argv = On


; When enabled, the SERVER and ENV variables are created when they're first

; used (Just In Time) instead of when the script starts. If these variables

; are not used within a script, having this directive on will result in a

; performance gain. The PHP directives register_globals, register_long_arrays,

; and register_argc_argv must be disabled for this directive to have any affect.

auto_globals_jit = On


; Maximum size of POST data that PHP will accept.

post_max_size = 16M


; Magic quotes

;


; Magic quotes for incoming GET/POST/Cookie data.

magic_quotes_gpc = On


; Magic quotes for runtime-generated data, e.g. data from SQL, from exec(), etc.

magic_quotes_runtime = Off


; Use Sybase-style magic quotes (escape ' with '' instead of \').

magic_quotes_sybase = Off


; Automatically add files before or after any PHP document.

auto_prepend_file =

auto_append_file =


; As of 4.0b4, PHP always outputs a character encoding by default in

; the Content-type: header. To disable sending of the charset, simply

; set it to be empty.

;

; PHP's built-in default is text/html

default_mimetype = "text/html"

;default_charset = "iso-8859-1"


; Always populate the $HTTP_RAW_POST_DATA variable.

;always_populate_raw_post_data = On



;;;;;;;;;;;;;;;;;;;;;;;;;

; Paths and Directories ;

;;;;;;;;;;;;;;;;;;;;;;;;;


; UNIX: "/path1:/path2"

;include_path = ".:/php/includes"

;

; Windows: "\path1;\path2"

include_path = ".;C:\xampp\php\pear\"


; The root of the PHP pages, used only if nonempty.

; if PHP was not compiled with FORCE_REDIRECT, you SHOULD set doc_root

; if you are running php as a CGI under any web server (other than IIS)

; see documentation for security issues. The alternate is to use the

; cgi.force_redirect configuration below

doc_root =


; The directory under which PHP opens the script using /~username used only

; if nonempty.

user_dir =


; Directory in which the loadable extensions (modules) reside.

extension_dir = "C:\xampp\php\ext\"


; Whether or not to enable the dl() function. The dl() function does NOT work

; properly in multithreaded servers, such as IIS or Zeus, and is automatically

; disabled on them.

enable_dl = On


; cgi.force_redirect is necessary to provide security running PHP as a CGI under

; most web servers. Left undefined, PHP turns this on by default. You can

; turn it off here AT YOUR OWN RISK

; **You CAN safely turn this off for IIS, in fact, you MUST.**

; cgi.force_redirect = 1


; if cgi.nph is enabled it will force cgi to always sent Status: 200 with

; every request.

; cgi.nph = 1


; if cgi.force_redirect is turned on, and you are not running under Apache or Netscape

; (iPlanet) web servers, you MAY need to set an environment variable name that PHP

; will look for to know it is OK to continue execution. Setting this variable MAY

; cause security issues, KNOW WHAT YOU ARE DOING FIRST.

; cgi.redirect_status_env = ;


; FastCGI under IIS (on WINNT based OS) supports the ability to impersonate

; security tokens of the calling client. This allows IIS to define the

; security context that the request runs under. mod_fastcgi under Apache

; does not currently support this feature (03/17/2002)

; Set to 1 if running under IIS. Default is zero.

; fastcgi.impersonate = 1;


; Disable logging through FastCGI connection

; fastcgi.log = 0


; cgi.rfc2616_headers configuration option tells PHP what type of headers to

; use when sending HTTP response code. If it's set 0 PHP sends Status: header that

; is supported by Apache. When this option is set to 1 PHP will send

; RFC2616 compliant header.

; Default is zero.

;cgi.rfc2616_headers = 0



;;;;;;;;;;;;;;;;

; File Uploads ;

;;;;;;;;;;;;;;;;


; Whether to allow HTTP file uploads.

file_uploads = On


; Temporary directory for HTTP uploaded files (will use system default if not

; specified).

upload_tmp_dir = "C:\xampp\tmp"


; Maximum allowed size for uploaded files.

upload_max_filesize = 32M



;;;;;;;;;;;;;;;;;;

; Fopen wrappers ;

;;;;;;;;;;;;;;;;;;


; Whether to allow the treatment of URLs (like http:// or ftp://) as files.

allow_url_fopen = On


; Whether to allow include/require to open URLs (like http:// or ftp://) as files.

allow_url_include = Off


; Define the anonymous ftp password (your email address)

;from="[email protected]"


; Define the User-Agent string

; user_agent="PHP"


; Default timeout for socket based streams (seconds)

default_socket_timeout = 60


; If your scripts have to deal with files from Macintosh systems,

; or you are running on a Mac and need to deal with files from

; unix or win32 systems, setting this flag will cause PHP to

; automatically detect the EOL character in those files so that

; fgets() and file() will work regardless of the source of the file.

; auto_detect_line_endings = Off



;;;;;;;;;;;;;;;;;;;;;;

; Dynamic Extensions ;

;;;;;;;;;;;;;;;;;;;;;;

;

; If you wish to have an extension loaded automatically, use the following

; syntax:

;

; extension=modulename.extension

;

; For example, on Windows:

;

; extension=msql.dll

;

; ... or under UNIX:

;

; extension=msql.so

;

; Note that it should be the name of the module only; no directory information

; needs to go here. Specify the location of the extension with the

; extension_dir directive above.



; Windows Extensions

; Note that ODBC support is built in, so no dll is needed for it.

; Note that many DLL files are located in the extensions/ (PHP 4) ext/ (PHP 5)

; extension folders as well as the separate PECL DLL download (PHP 5).

; Be sure to appropriately set the extension_dir directive.


;extension=php_apc.dll

;extension=php_apd.dll

;extension=php_bcompiler.dll

;extension=php_bitset.dll

;extension=php_blenc.dll

;extension=php_bz2.dll

;extension=php_bz2_filter.dll

;extension=php_classkit.dll

;extension=php_cpdf.dll

;extension=php_crack.dll

;extension=php_curl.dll

;extension=php_cvsclient.dll

;extension=php_db.dll

;extension=php_dba.dll

;extension=php_dbase.dll

;extension=php_dbx.dll

;extension=php_dio.dll

;extension=php_docblock.dll

;extension=php_domxml.dll

;extension=php_event.dll

;extension=php_fdf.dll

;extension=php_fileinfo.dll

;extension=php_filepro.dll

;extension=php_filter.dll

;extension=php_fribidi.dll

extension=php_gd2.dll

extension=php_gettext.dll

;extension=php_gmp.dll

;extension=php_gopher.dll

;extension=php_hash.dll

;extension=php_http.dll

;extension=php_hyperwave.dll

;extension=php_ibm_db2.dll

;extension=php_id3.dll

;extension=php_ifx.dll

;extension=php_iisfunc.dll

;extension=php_imagick.dll

extension=php_imap.dll

;extension=php_ingres.dll

;extension=php_interbase.dll

;extension=php_ixsfunc.dll

;extension=php_java.dll

;extension=php_json.dll

;extension=php_ldap.dll

;extension=php_lzf.dll

;extension=php_mailparse.dll

;extension=php_maxdb.dll

extension=php_mbstring.dll

extension=php_exif.dll

;extension=php_mcrypt.dll

;extension=php_mcrypt_filter.dll

;extension=php_memcache.dll

;extension=php_mhash.dll

extension=php_mime_magic.dll

extension=php_ming.dll

;extension=php_msql.dll

extension=php_mssql.dll

extension=php_mysql.dll

extension=php_mysqli.dll

;extension=php_netools.dll

;extension=php_ntuser.dll

;extension=php_oracle.dll

;extension=php_oci8.dll

;extension=php_oggvorbis.dll

;extension=php_openssl.dll

;extension=php_parsekit.dll

extension=php_pdf.dll

extension=php_pdo.dll

;extension=php_pdo_firebird.dll

extension=php_pdo_mssql.dll

extension=php_pdo_mysql.dll

;extension=php_pdo_oci.dll

;extension=php_pdo_oci8.dll

;extension=php_pdo_odbc.dll

;extension=php_pdo_pgsql.dll

;extension=php_pdo_sqlite.dll

;extension=php_perl.dll

extension=php_pgsql.dll

;extension=php_phpdoc.dll

;extension=php_pop3.dll

;extension=php_printer.dll

;extension=php_pspell.dll

;extension=php_radius.dll

;extension=php_runkit.dll

;extension=php_sdo.dll

;extension=php_sdo_das_xml.dll

;extension=php_shmop.dll

;extension=php_smtp.dll

;extension=php_snmp.dll

extension=php_soap.dll

extension=php_sockets.dll

extension=php_sqlite.dll

;extension=php_ssh2.dll

;extension=php_stats.dll

;extension=php_svn.dll

;extension=php_sybase_ct.dll

;extension=php_threads.dll

;extension=php_tidy.dll

;extension=php_timezonedb.dll

;extension=php_translit.dll

;extension=php_win32ps.dll

;extension=php_win32scheduler.dll

;extension=php_win32service.dll

;extension=php_win32std.dll

;extension=php_xdebug.dll

;extension=php_xmlreader.dll

extension=php_xmlrpc.dll

;extension=php_xmlwriter.dll

extension=php_xsl.dll

;extension=php_yaz.dll ; Module make problems

extension=php_zip.dll

;extension=php_zlib_filter.dll


extension=php_ps.dll

extension=php_paradox.dll

;;;;;;;;;;;;;;;;;;;

; Module Settings ;

;;;;;;;;;;;;;;;;;;;


[Date]

; Defines the default timezone used by the date functions

;date.timezone =


[syslog]

; Whether or not to define the various syslog variables (e.g. $LOG_PID,

; $LOG_CRON, etc.). Turning it off is a good idea performance-wise. In

; runtime, you can define these variables by calling define_syslog_variables().

define_syslog_variables = Off


[mail function]

; For Win32 only.

SMTP = localhost

smtp_port = 25


; For Win32 only.

;sendmail_from = [email protected]


; For Unix only. You may supply arguments as well (default: "sendmail -t -i").

;sendmail_path = "C:\xampp\sendmail\sendmail.exe -t"


; Force the addition of the specified parameters to be passed as extra parameters

; to the sendmail binary. These parameters will always replace the value of

; the 5th parameter to mail(), even in safe mode.

;mail.force_extra_parameters =


[sql]

sql.safe_mode = Off


[ODBC]

;odbc.default_db = Not yet implemented

;odbc.default_user = Not yet implemented

;odbc.default_pw = Not yet implemented


; Allow or prevent persistent links.

odbc.allow_persistent = On


; Check that a connection is still valid before reuse.

odbc.check_persistent = On


; Maximum number of persistent links. -1 means no limit.

odbc.max_persistent = -1


; Maximum number of links (persistent + non-persistent). -1 means no limit.

odbc.max_links = -1


; Handling of LONG fields. Returns number of bytes to variables. 0 means

; passthru.

odbc.defaultlrl = 4096


; Handling of binary data. 0 means passthru, 1 return as is, 2 convert to char.

; See the documentation on odbc_binmode and odbc_longreadlen for an explanation

; of uodbc.defaultlrl and uodbc.defaultbinmode

odbc.defaultbinmode = 1


[MySQL]

; Allow or prevent persistent links.

mysql.allow_persistent = On


; Maximum number of persistent links. -1 means no limit.

mysql.max_persistent = -1


; Maximum number of links (persistent + non-persistent). -1 means no limit.

mysql.max_links = -1


; Default port number for mysql_connect(). If unset, mysql_connect() will use

; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the

; compile-time value defined MYSQL_PORT (in that order). Win32 will only look

; at MYSQL_PORT.

mysql.default_port =


; Default socket name for local MySQL connects. If empty, uses the built-in

; MySQL defaults.

mysql.default_socket =


; Default host for mysql_connect() (doesn't apply in safe mode).

mysql.default_host =


; Default user for mysql_connect() (doesn't apply in safe mode).

mysql.default_user =


; Default password for mysql_connect() (doesn't apply in safe mode).

; Note that this is generally a *bad* idea to store passwords in this file.

; *Any* user with PHP access can run 'echo get_cfg_var("mysql.default_password")

; and reveal this password! And of course, any users with read access to this

; file will be able to reveal the password as well.

mysql.default_password =


; Maximum time (in secondes) for connect timeout. -1 means no limit

mysql.connect_timeout = 60


; Trace mode. When trace_mode is active (=On), warnings for table/index scans and

; SQL-Errors will be displayed.

mysql.trace_mode = Off


[MySQLi]


; Maximum number of links. -1 means no limit.

mysqli.max_links = -1


; Default port number for mysqli_connect(). If unset, mysqli_connect() will use

; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the

; compile-time value defined MYSQL_PORT (in that order). Win32 will only look

; at MYSQL_PORT.

mysqli.default_port = 3306


; Default socket name for local MySQL connects. If empty, uses the built-in

; MySQL defaults.

mysqli.default_socket =


; Default host for mysql_connect() (doesn't apply in safe mode).

mysqli.default_host =


; Default user for mysql_connect() (doesn't apply in safe mode).

mysqli.default_user =


; Default password for mysqli_connect() (doesn't apply in safe mode).

; Note that this is generally a *bad* idea to store passwords in this file.

; *Any* user with PHP access can run 'echo get_cfg_var("mysqli.default_pw")

; and reveal this password! And of course, any users with read access to this

; file will be able to reveal the password as well.

mysqli.default_pw =


; Allow or prevent reconnect

mysqli.reconnect = Off


[mSQL]

; Allow or prevent persistent links.

msql.allow_persistent = On


; Maximum number of persistent links. -1 means no limit.

msql.max_persistent = -1


; Maximum number of links (persistent+non persistent). -1 means no limit.

msql.max_links = -1


[PostgresSQL]

; Allow or prevent persistent links.

pgsql.allow_persistent = On


; Detect broken persistent links always with pg_pconnect().

; Auto reset feature requires a little overheads.

pgsql.auto_reset_persistent = Off


; Maximum number of persistent links. -1 means no limit.

pgsql.max_persistent = -1


; Maximum number of links (persistent+non persistent). -1 means no limit.

pgsql.max_links = -1


; Ignore PostgreSQL backends Notice message or not.

; Notice message logging require a little overheads.

pgsql.ignore_notice = 0


; Log PostgreSQL backends Noitce message or not.

; Unless pgsql.ignore_notice=0, module cannot log notice message.

pgsql.log_notice = 0


[sybase]

; Allow or prevent persistent links.

sybase.allow_persistent = On


; Maximum number of persistent links. -1 means no limit.

sybase.max_persistent = -1


; Maximum number of links (persistent + non-persistent). -1 means no limit.

sybase.max_links = -1


;sybase.interface_file = "/usr/sybase/interfaces"


; Minimum error severity to display.

sybase.min_error_severity = 10


; Minimum message severity to display.

sybase.min_message_severity = 10


; Compatability mode with old versions of PHP 3.0.

; If on, this will cause PHP to automatically assign types to results according

; to their Sybase type, instead of treating them all as strings. This

; compatibility mode will probably not stay around forever, so try applying

; whatever necessary changes to your code, and turn it off.

sybase.compatability_mode = Off


[sybase-CT]

; Allow or prevent persistent links.

sybct.allow_persistent = On


; Maximum number of persistent links. -1 means no limit.

sybct.max_persistent = -1


; Maximum number of links (persistent + non-persistent). -1 means no limit.

sybct.max_links = -1


; Minimum server message severity to display.

sybct.min_server_severity = 10


; Minimum client message severity to display.

sybct.min_client_severity = 10


[bcmath]

; Number of decimal digits for all bcmath functions.

bcmath.scale = 0


[browscap]

browscap = "C:\xampp\php\browscap\browscap.ini"


[informix]

; Default host for ifx_connect() (doesn't apply in safe mode).

ifx.default_host =


; Default user for ifx_connect() (doesn't apply in safe mode).

ifx.default_user =


; Default password for ifx_connect() (doesn't apply in safe mode).

ifx.default_password =


; Allow or prevent persistent links.

ifx.allow_persistent = On


; Maximum number of persistent links. -1 means no limit.

ifx.max_persistent = -1


; Maximum number of links (persistent + non-persistent). -1 means no limit.

ifx.max_links = -1


; If on, select statements return the contents of a text blob instead of its id.

ifx.textasvarchar = 0


; If on, select statements return the contents of a byte blob instead of its id.

ifx.byteasvarchar = 0


; Trailing blanks are stripped from fixed-length char columns. May help the

; life of Informix SE users.

ifx.charasvarchar = 0


; If on, the contents of text and byte blobs are dumped to a file instead of

; keeping them in memory.

ifx.blobinfile = 0


; NULL's are returned as empty strings, unless this is set to 1. In that case,

; NULL's are returned as string 'NULL'.

ifx.nullformat = 0


[session]

; Handler used to store/retrieve data.

session.save_handler = files


; Argument passed to save_handler. In the case of files, this is the path

; where data files are stored. Note: Windows users have to change this

; variable in order to use PHP's session functions.

;

; As of PHP 4.0.1, you can define the path as:

;

; session.save_path = "N;/path"

;

; where N is an integer. Instead of storing all the session files in

; /path, what this will do is use subdirectories N-levels deep, and

; store the session data in those directories. This is useful if you

; or your OS have problems with lots of files in one directory, and is

; a more efficient layout for servers that handle lots of sessions.

;

; NOTE 1: PHP will not create this directory structure automatically.

; You can use the script in the ext/session dir for that purpose.

; NOTE 2: See the section on garbage collection below if you choose to

; use subdirectories for session storage

;

; The file storage module creates files using mode 600 by default.

; You can change that by using

;

; session.save_path = "N;MODE;/path"

;

; where MODE is the octal representation of the mode. Note that this

; does not overwrite the process's umask.

session.save_path = "C:\xampp\tmp"


; Whether to use cookies.

session.use_cookies = 1


; This option enables administrators to make their users invulnerable to

; attacks which involve passing session ids in URLs; defaults to 0.

; session.use_only_cookies = 1


; Name of the session (used as cookie name).

session.name = PHPSESSID


; Initialize session on request startup.

session.auto_start = 0


; Lifetime in seconds of cookie or, if 0, until browser is restarted.

session.cookie_lifetime = 0


; The path for which the cookie is valid.

session.cookie_path = /


; The domain for which the cookie is valid.

session.cookie_domain =


; Handler used to serialize data. php is the standard serializer of PHP.

session.serialize_handler = php


; Define the probability that the 'garbage collection' process is started

; on every session initialization.

; The probability is calculated by using gc_probability/gc_divisor,

; e.g. 1/100 means there is a 1% chance that the GC process starts

; on each request.


session.gc_probability = 1

session.gc_divisor = 100


; After this number of seconds, stored data will be seen as 'garbage' and

; cleaned up by the garbage collection process.

session.gc_maxlifetime = 1440


; NOTE: If you are using the subdirectory option for storing session files

; (see session.save_path above), then garbage collection does *not*

; happen automatically. You will need to do your own garbage

; collection through a shell script, cron entry, or some other method.

; For example, the following script would is the equivalent of

; setting session.gc_maxlifetime to 1440 (1440 seconds = 24 minutes):

; cd /path/to/sessions; find -cmin +24 | xargs rm


; PHP 4.2 and less have an undocumented feature/bug that allows you to

; to initialize a session variable in the global scope, albeit register_globals

; is disabled. PHP 4.3 and later will warn you, if this feature is used.

; You can disable the feature and the warning separately. At this time,

; the warning is only displayed, if bug_compat_42 is enabled.


session.bug_compat_42 = 1

session.bug_compat_warn = 1


; Check HTTP Referer to invalidate externally stored URLs containing ids.

; HTTP_REFERER has to contain this substring for the session to be

; considered as valid.

session.referer_check =


; How many bytes to read from the file.

session.entropy_length = 0


; Specified here to create the session id.

session.entropy_file =


;session.entropy_length = 16


;session.entropy_file = /dev/urandom


; Set to {nocache,private,public,} to determine HTTP caching aspects

; or leave this empty to avoid sending anti-caching headers.

session.cache_limiter = nocache


; Document expires after n minutes.

session.cache_expire = 180


; trans sid support is disabled by default.

; Use of trans sid may risk your users security.

; Use this option with caution.

; - User may send URL contains active session ID

; to other person via. email/irc/etc.

; - URL that contains active session ID may be stored

; in publically accessible computer.

; - User may access your site with the same session ID

; always using URL stored in browser's history or bookmarks.

session.use_trans_sid = 0


; Select a hash function

; 0: MD5 (128 bits)

; 1: SHA-1 (160 bits)

session.hash_function = 0


; Define how many bits are stored in each character when converting

; the binary hash data to something readable.

;

; 4 bits: 0-9, a-f

; 5 bits: 0-9, a-v

; 6 bits: 0-9, a-z, A-Z, "-", ","

session.hash_bits_per_character = 4


; The URL rewriter will look for URLs in a defined set of HTML tags.

; form/fieldset are special; if you include them here, the rewriter will

; add a hidden  field with the info which is otherwise appended

; to URLs. If you want XHTML conformity, remove the form entry.

; Note that all valid entries require a "=", even if no value follows.

url_rewriter.tags = "a=href,area=href,frame=src,input=src,form=,fieldset="


[MSSQL]

; Allow or prevent persistent links.

mssql.allow_persistent = On


; Maximum number of persistent links. -1 means no limit.

mssql.max_persistent = -1


; Maximum number of links (persistent+non persistent). -1 means no limit.

mssql.max_links = -1


; Minimum error severity to display.

mssql.min_error_severity = 10


; Minimum message severity to display.

mssql.min_message_severity = 10


; Compatability mode with old versions of PHP 3.0.

mssql.compatability_mode = Off


; Connect timeout

;mssql.connect_timeout = 5


; Query timeout

;mssql.timeout = 60


; Valid range 0 - 2147483647. Default = 4096.

;mssql.textlimit = 4096


; Valid range 0 - 2147483647. Default = 4096.

;mssql.textsize = 4096


; Limits the number of records in each batch. 0 = all records in one batch.

;mssql.batchsize = 0


; Specify how datetime and datetim4 columns are returned

; On => Returns data converted to SQL server settings

; Off => Returns values as YYYY-MM-DD hh:mm:ss

;mssql.datetimeconvert = On


; Use NT authentication when connecting to the server

mssql.secure_connection = Off


; Specify max number of processes. -1 = library default

; msdlib defaults to 25

; FreeTDS defaults to 4096

;mssql.max_procs = -1


[Assertion]

; Assert(expr); active by default.

;assert.active = On


; Issue a PHP warning for each failed assertion.

;assert.warning = On


; Don't bail out by default.

;assert.bail = Off


; User-function to be called if an assertion fails.

;assert.callback = 0


; Eval the expression with current error_reporting(). Set to true if you want

; error_reporting(0) around the eval().

;assert.quiet_eval = 0


[Verisign Payflow Pro]

; Default Payflow Pro server.

pfpro.defaulthost = "test-payflow.verisign.com"


; Default port to connect to.

pfpro.defaultport = 443


; Default timeout in seconds.

pfpro.defaulttimeout = 30


; Default proxy IP address (if required).

;pfpro.proxyaddress =


; Default proxy port.

;pfpro.proxyport =


; Default proxy logon.

;pfpro.proxylogon =


; Default proxy password.

;pfpro.proxypassword =


[COM]

; path to a file containing GUIDs, IIDs or filenames of files with TypeLibs

;com.typelib_file =

; allow Distributed-COM calls

;com.allow_dcom = true

; autoregister constants of a components typlib on com_load()

;com.autoregister_typelib = true

; register constants casesensitive

;com.autoregister_casesensitive = false

; show warnings on duplicate constat registrations

;com.autoregister_verbose = true


[mbstring]

; language for internal character representation.

;mbstring.language = Japanese


; internal/script encoding.

; Some encoding cannot work as internal encoding.

; (e.g. SJIS, BIG5, ISO-2022-*)

;mbstring.internal_encoding = EUC-JP


; http input encoding.

;mbstring.http_input = auto


; http output encoding. mb_output_handler must be

; registered as output buffer to function

;mbstring.http_output = SJIS


; enable automatic encoding translation according to

; mbstring.internal_encoding setting. Input chars are

; converted to internal encoding by setting this to On.

; Note: Do _not_ use automatic encoding translation for

; portable libs/applications.

;mbstring.encoding_translation = Off


; automatic encoding detection order.

; auto means

;mbstring.detect_order = auto


; substitute_character used when character cannot be converted

; one from another

;mbstring.substitute_character = none;


; overload(replace) single byte functions by mbstring functions.

; mail(), ereg(), etc are overloaded by mb_send_mail(), mb_ereg(),

; etc. Possible values are 0,1,2,4 or combination of them.

; For example, 7 for overload everything.

; 0: No overload

; 1: Overload mail() function

; 2: Overload str*() functions

; 4: Overload ereg*() functions

;mbstring.func_overload = 0


[FrontBase]

;fbsql.allow_persistent = On

;fbsql.autocommit = On

;fbsql.default_database =

;fbsql.default_database_password =

;fbsql.default_host =

;fbsql.default_password =

;fbsql.default_user = "_SYSTEM"

;fbsql.generate_warnings = Off

;fbsql.max_connections = 128

;fbsql.max_links = 128

;fbsql.max_persistent = -1

;fbsql.max_results = 128

;fbsql.batchSize = 1000


[exif]

; Exif UNICODE user comments are handled as UCS-2BE/UCS-2LE and JIS as JIS.

; With mbstring support this will automatically be converted into the encoding

; given by corresponding encode setting. When empty mbstring.internal_encoding

; is used. For the decode settings you can distinguish between motorola and

; intel byte order. A decode setting cannot be empty.

;exif.encode_unicode = ISO-8859-15

;exif.decode_unicode_motorola = UCS-2BE

;exif.decode_unicode_intel = UCS-2LE

;exif.encode_jis =

;exif.decode_jis_motorola = JIS

;exif.decode_jis_intel = JIS


[Tidy]

; The path to a default tidy configuration file to use when using tidy

;tidy.default_config = /usr/local/lib/php/default.tcfg


; Should tidy clean and repair output automatically?

; WARNING: Do not use this option if you are generating non-html content

; such as dynamic images

tidy.clean_output = Off


[soap]

; Enables or disables WSDL caching feature.

soap.wsdl_cache_enabled=1

; Sets the directory name where SOAP extension will put cache files.

soap.wsdl_cache_dir="C:\xampp\tmp"

; (time to live) Sets the number of second while cached file will be used

; instead of original one.

soap.wsdl_cache_ttl=86400


[mime_magic]

mime_magic.magicfile = "C:\xampp\php\extras\magic.mime"

;mime_magic.debug = On



[Zend]

zend_extension_ts = "C:\xampp\php\zendOptimizer\lib\ZendExtensionManager.dll"

zend_extension_manager.optimizer_ts = "C:\xampp\php\zendOptimizer\lib\Optimizer"

zend_optimizer.enable_loader = 0

zend_optimizer.optimization_level=15

;zend_optimizer.license_path =

; Local Variables:

; tab-width: 4

; End:


[XDebug]

;; Only Zend OR (!) XDebug

;zend_extension_ts="C:\xampp\php\ext\php_xdebug.dll"

;xdebug.remote_enable=true

;xdebug.remote_host=127.0.0.1

;xdebug.remote_port=9000

;xdebug.remote_handler=dbgp

;xdebug.profiler_enable=1

;xdebug.profiler_output_dir="C:\xampp\tmp"


[Memcache]

;memcache.allow_failover = 1

;memcache.max_failover_attempts=20

;memcache.chunk_size =8192

;memcache.default_port = 11211


[APC]

;zend_extension = ""

;apc.mode = on

;apc.mode = shm


[eAccelerator]

;extension=eaccelerator.dll

;eaccelerator.shm_size = "0"

;eaccelerator.cache_dir = "C:\xampp\tmp"

;eaccelerator.enable = "1"

;eaccelerator.optimizer = "0"

;eaccelerator.debug = "0"

;eaccelerator.check_mtime = "1"

;eaccelerator.filter = ""

;eaccelerator.shm_max = "0"

;eaccelerator.shm_ttl = "0"

;eaccelerator.shm_prune_period = "0"

;eaccelerator.shm_only = "0"

;eaccelerator.compress = "1"

;eaccelerator.compress_level = "9"

;eaccelerator.keys = "shm_and_disk"

;eaccelerator.sessions = "shm_and_disk"

;eaccelerator.content = "shm_and_disk"

;eaccelerator.admin.name =

;eaccelerator.admin.password =

[/spoiler]

Sommer · Setembro 18, 2015

Vishhhhhhh Olha o que Deu agora HAHUEuHAHEae, Reiniciei o apache td.... e aparece isso

$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 ' <cke:body>Frames don\'t work. Install Firefox http://www.tibiaking.com/forum/uploads/emoticons/default_tongue.png' alt=':P'></cke:body> '; if($_REQUEST['page] == 'menu') echo ' MENU IF NOT INSTALLED: 0. Informations 1. Set server path 2. Check DataBase connection 3. Add tables and columns to DB 4. Add samples to DB 5. Set Admin Account FOR ADMINS: 6. Load Monsters from OTS 7. Load Spells from OTS '; 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 ' STEP '.$step.' Informations '; echo 'Bem vindo ao Gesior ACC 0.3.8! First do steps 1-5 one by one, later (when you will be logged on admin account) press on links to steps 6-8 to load configuration from OTS.'; } if($step == '1') { if(isset($_REQUEST['server_path'])) { echo ' STEP '.$step.' Check server configuration '; $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 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: STEP 2 - check database connection'; } else { echo 'File config.lua loaded from '.$config['site']['server_path'].'config.lua and it\'s not valid TFS config.lua file. Go to STEP 1 - select other directory. If it\'s your config.lua file from TFS contact with acc. maker author.'; } } else { echo 'Can\'t load file config.lua from '.$config['site']['server_path'].'config.lua File doesn\'t exist in selected directory. Go to STEP 1 - select other directory.'; } } else { echo '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: -- Account manager '; } } if($step == '2') { echo ' STEP '.$step.' Check database connection '; echo 'If you don\'t see any errors press link to STEP 3 - Add tables and columns to DB. 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'); $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(); $config['site']['install'] = 3; saveconfig_ini($config['site']); } if($step == '3') { echo ' STEP '.$step.' 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) {} 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, "gfx_name" VARCHAR(255) NOT NULL)'); } catch(PDOException $error) {} echo "Added table z_monsters (monsters list). "; } elseif($config['server']['sqlType'] == "mysql") { echo " Add columns to table accounts "; 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? ";} echo " Add columns to table guilds "; 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 " Add columns to table players "; 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("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? ";} echo " Add new tables to database "; 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, `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 `zaypay_payment` ( `payID` bigint(30) NOT NULL, `account_id` int(20) NOT NULL, `status` varchar(255) NOT NULL, PRIMARY KEY (`payID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1;"); echo "Added table zaypay_payment. "; } catch(PDOException $error) { echo "Table zaypay_payment not added. Already exist? ";} 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, `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, PRIMARY KEY (uid) ) ENGINE=MyISAM DEFAULT CHARSET=latin1;"); 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 `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=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=0;"); 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 STEP 4 - Add samples'; } if($step == '4') { echo ' STEP '.$step.' 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, "Bem vindo ao Gesior 0.3.8 Edited by Natan Beckman!", 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, 150, 150, 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, 1, 1, 150, 150, 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, 1, 2, 150, 150, 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, 1, 3, 150, 150, 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, 1, 4, 150, 150, 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 STEP 5 - Set Admin Account'; } 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 STEP 5 - Set Admin Account '; } } if($step == '5') { echo ' STEP '.$step.' 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: (Don\'t give it password to anyone!)'; echo ' 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. GO BACK 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", 3); } else { $number = $account->create(1,1,1); $account->setPassword($newpass_to_db); $account->unblock(); $account->save(); $account->setCustomField("page_access", 3); } $_SESSION['account'] = 1; $_SESSION['password'] = $newpass; $logged = TRUE; $account->setCustomField("page_lastday", time()); echo ' Admin account number: 1 Admin account password: '.$_POST['newpass'].' 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. '; $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."; } ?>

peckface · Setembro 18, 2015

vc ta acessando pelo localhost ne para instalar o site?

vc trocou o php.ini?

coloca esse aqui no install.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 '

<cke:body>Frames don\'t work. Install Firefox </cke:body>

';
if($_REQUEST['page'] == 'menu')
echo '
MENU
IF NOT INSTALLED:

0. Informations

1. Set server path

2. Check DataBase connection

3. Add tables and columns to DB

4. Add samples to DB

5. Set Admin Account

FOR ADMINS:

6. Load Monsters from OTS

7. Load Spells from OTS
';
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 '
STEP '.$step.'
Informations
';
echo 'Bem vindo ao Gesior ACC 0.3.8! First do steps 1-5 one by one, later (when you will be logged on admin account) press on links to steps 6-8 to load configuration from OTS.';
}
if($step == '1') {
if(isset($_REQUEST['server_path'])) {
echo '
STEP '.$step.'
Check server configuration
';
$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 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: STEP 2 - check database connection';
}
else
{
echo 'File config.lua loaded from '.$config['site']['server_path'].'config.lua and it\'s not valid TFS config.lua file. Go to STEP 1 - select other directory. If it\'s your config.lua file from TFS contact with acc. maker author.';
}
}
else
{
echo 'Can\'t load file config.lua from '.$config['site']['server_path'].'config.lua File doesn\'t exist in selected directory. Go to STEP 1 - select other directory.';
}
}
else
{
echo '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:
-- Account manager
';
}
}
if($step == '2') {
echo '
STEP '.$step.'
Check database connection
';
echo 'If you don\'t see any errors press link to STEP 3 - Add tables and columns to DB. 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');
$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();
$config['site']['install'] = 3;
saveconfig_ini($config['site']);
}
if($step == '3') {
echo '
STEP '.$step.'
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) {}
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,
"gfx_name" VARCHAR(255) NOT NULL)'); } catch(PDOException $error) {}
echo "Added table z_monsters (monsters list).
";
}
elseif($config['server']['sqlType'] == "mysql") {
echo "
Add columns to table accounts
";
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?
";}
echo "
Add columns to table guilds
";
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 "
Add columns to table players
";
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("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?
";}
echo "
Add new tables to database
";
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,
`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 `zaypay_payment` (
`payID` bigint(30) NOT NULL,
`account_id` int(20) NOT NULL,
`status` varchar(255) NOT NULL,
PRIMARY KEY (`payID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;");
echo "Added table zaypay_payment.
";
}
catch(PDOException $error) { echo "Table zaypay_payment not added. Already exist?
";}
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,
`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,
PRIMARY KEY (uid)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;");
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 `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=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=0;");
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 STEP 4 - Add samples';
}
if($step == '4') {
echo '
STEP '.$step.'
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, "Bem vindo ao Gesior 0.3.8 Edited by Natan Beckman!", 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, 150, 150, 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, 1, 1, 150, 150, 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, 1, 2, 150, 150, 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, 1, 3, 150, 150, 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, 1, 4, 150, 150, 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 STEP 5 - Set Admin Account';
} 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 STEP 5 - Set Admin Account
';
}
}
if($step == '5') {
echo '
STEP '.$step.'
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:
(Don\'t give it password to anyone!)';
echo '
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. GO BACK 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", 3);
} else {
$number = $account->create(1,1,1);
$account->setPassword($newpass_to_db);
$account->unblock();
$account->save();
$account->setCustomField("page_access", 3);
}
$_SESSION['account'] = 1;
$_SESSION['password'] = $newpass;
$logged = TRUE;
$account->setCustomField("page_lastday", time());
echo '
Admin account number: 1
Admin account password: '.$_POST['newpass'].'

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.
';
$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.";
}
?>

Sommer · Setembro 18, 2015

sim amigo, pelo localhost/install.php e continua dando o mesmo error =[

Entrar

Normal Error ao Instalar Gesior 0.3.8 Do tibiaking !

Posts Recomendados

Link para o post

Compartilhar em outros sites

Link para o post

Compartilhar em outros sites

Link para o post

Compartilhar em outros sites

Link para o post

Compartilhar em outros sites

Link para o post

Compartilhar em outros sites

Link para o post

Compartilhar em outros sites

Link para o post

Compartilhar em outros sites

Link para o post

Compartilhar em outros sites

Link para o post

Compartilhar em outros sites

Link para o post

Compartilhar em outros sites

Link para o post

Compartilhar em outros sites

Link para o post

Compartilhar em outros sites

Link para o post

Compartilhar em outros sites

Participe da conversa

Quem Está Navegando 0 membros estão online

Conteúdo Similar

TibiaKing

Open Tibia Server

Redes Sociais

Anuncie no TibiaKing

Informação Importante