[TFS 1.0] Gesior AAC

[Bruno Carvalho 837]

Olá galera, ultimamente está saindo várias novidades para os servidores e eu estou atualizando para os brasileiros :3

 

Você sabia que o gesior também migrou para o GitHub?

Bom, ele migrou e agora está atualizando para todas as versões :3

 

Download:

TFS 1.0: https://github.com/gesior/Gesior2012/tree/TFS-1.0

TFS 0.4: https://github.com/gesior/Gesior2012/tree/TFS-0.4_rev_3703+

TFS 0.3.6: https://github.com/gesior/Gesior2012/tree/TFS-0.3.6_and_0.4_to_rev_3703

TFS 0.2.13+: https://github.com/gesior/Gesior2012/tree/TFS-0.2.13+

TFS 0.2.11-: https://github.com/gesior/Gesior2012/tree/TFS-0.2.11_and_older

 

É só baixar e se divertir pois os mais recentes vem com correções de bugs e muito mais :3

[Visitante]

É muito bom ver que o Gesior continua firme e forte.

[kinglekke 6]

eu to com 1 erro nas vocation da tfs 1.0 , pode me ajudar ? , os player nao consegue criar os character pq diz que a vocation nao existe ajuda aew

[brunaosbo 1]

Boa Tarde Pessoa

Seguinte Faz dias que estou tentando entrar no servidor

Mais Não consigo devido alguns bugs do geisor

Por favor se alguem poder me ajudar , estou loucoooo para testar esse mega servidor

 

Meu problema éo seguinte:

 

 

Error occured!

Error ID: #C-5
More info: ERROR: #C-5 : Class::ConfigPHP - Key passwordType doesn't exist.

File: C:\xammp\xampp\htdocs\classes/configphp.php   Line: 96
File: C:\xammp\xampp\htdocs/install.php   Line: 176

[Bruno Carvalho 837]

Tente deixar o seu config.lua assim:

-- MySQL
mysqlHost = "127.0.0.1 ou localhost" -- fica  seu critério.
mysqlUser = "root"
mysqlPass = "SENHA"
mysqlDatabase = "DATABASE"
mysqlPort = 3306
passwordType = "sha1"

[gabrielzapto 11]

aqui o meu da o seguinte erro 

 

STEP 3

Add tables and columns to DB
Installer try to add new tables and columns to database.

Query: ALTER TABLE `accounts` ADD `key` VARCHAR(20) NOT NULL DEFAULT '0' SQLSTATE: 42S21 Driver code: 1060 Error message: Duplicate column name 'key'

Could not add column key to table accounts. Already exist?

Query: ALTER TABLE `accounts` ADD `email_new` VARCHAR(255) NOT NULL DEFAULT '' SQLSTATE: 42S21 Driver code: 1060 Error message: Duplicate column name 'email_new'

Could not add column email_new to table accounts. Already exist?

Query: ALTER TABLE `accounts` ADD `email_new_time` INT(11) NOT NULL DEFAULT '0'

[kinglekke 6]

TEP 4

Add samples to DB:
Query: SELECT `id`, `name`, `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`, `lastlogout`, `blessings`, `balance`, `stamina`, `skill_fist`, `skill_fist_tries`, `skill_club`, `skill_club_tries`, `skill_sword`, `skill_sword_tries`, `skill_axe`, `skill_axe_tries`, `skill_dist`, `skill_dist_tries`, `skill_shielding`, `skill_shielding_tries`, `skill_fishing`, `skill_fishing_tries`, `deleted`, `create_ip`, `create_date`, `comment`, `hide_char` FROM `players` WHERE `name` = 'Account Manager'
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT `id`, `name`, `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`, `lastlogout`, `blessings`, `balance`, `stamina`, `skill_fist`, `skill_fist_tries`, `skill_club`, `skill_club_tries`, `skill_sword`, `skill_sword_tries`, `skill_axe`, `skill_axe_tries`, `skill_dist`, `skill_dist_tries`, `skill_shielding`, `skill_shielding_tries`, `skill_fishing`, `skill_fishing_tries`, `deleted`, `create_ip`, `create_date`, `comment`, `hide_char` FROM `players` WHERE `name` = 'Rook Sample'
SQLSTATE: 00000
Driver code:
Error message:
Sample character: Rook Sample already exist in database
Query: SELECT `id`, `name`, `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`, `lastlogout`, `blessings`, `balance`, `stamina`, `skill_fist`, `skill_fist_tries`, `skill_club`, `skill_club_tries`, `skill_sword`, `skill_sword_tries`, `skill_axe`, `skill_axe_tries`, `skill_dist`, `skill_dist_tries`, `skill_shielding`, `skill_shielding_tries`, `skill_fishing`, `skill_fishing_tries`, `deleted`, `create_ip`, `create_date`, `comment`, `hide_char` FROM `players` WHERE `name` = 'Sorcerer Sample'
SQLSTATE: 00000
Driver code:
Error message:
Sample character: Sorcerer Sample already exist in database
Query: SELECT `id`, `name`, `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`, `lastlogout`, `blessings`, `balance`, `stamina`, `skill_fist`, `skill_fist_tries`, `skill_club`, `skill_club_tries`, `skill_sword`, `skill_sword_tries`, `skill_axe`, `skill_axe_tries`, `skill_dist`, `skill_dist_tries`, `skill_shielding`, `skill_shielding_tries`, `skill_fishing`, `skill_fishing_tries`, `deleted`, `create_ip`, `create_date`, `comment`, `hide_char` FROM `players` WHERE `name` = 'Druid Sample'
SQLSTATE: 00000
Driver code:
Error message:
Sample character: Druid Sample already exist in database
Query: SELECT `id`, `name`, `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`, `lastlogout`, `blessings`, `balance`, `stamina`, `skill_fist`, `skill_fist_tries`, `skill_club`, `skill_club_tries`, `skill_sword`, `skill_sword_tries`, `skill_axe`, `skill_axe_tries`, `skill_dist`, `skill_dist_tries`, `skill_shielding`, `skill_shielding_tries`, `skill_fishing`, `skill_fishing_tries`, `deleted`, `create_ip`, `create_date`, `comment`, `hide_char` FROM `players` WHERE `name` = 'Paladin Sample'
SQLSTATE: 00000
Driver code:
Error message:
Sample character: Paladin Sample already exist in database
Query: SELECT `id`, `name`, `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`, `lastlogout`, `blessings`, `balance`, `stamina`, `skill_fist`, `skill_fist_tries`, `skill_club`, `skill_club_tries`, `skill_sword`, `skill_sword_tries`, `skill_axe`, `skill_axe_tries`, `skill_dist`, `skill_dist_tries`, `skill_shielding`, `skill_shielding_tries`, `skill_fishing`, `skill_fishing_tries`, `deleted`, `create_ip`, `create_date`, `comment`, `hide_char` FROM `players` WHERE `name` = 'Knight Sample'
SQLSTATE: 00000
Driver code:
Error message:
Sample character: Knight Sample already exist in database

 

 

 

ajuda aew

[gabrielzapto 11]

Onde fica o config.ini desse geisor ?

ja procurei em todas pastas e nada

Por favor preciso desativar o install

[delpriore 0]

Na hora de instalar da erro.... aparece seguinte mensagem quando chega na etapa 4*

 

Add samples to DB:

Query: SELECT `id`, `name`, `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`, `lastlogout`, `blessings`, `balance`, `stamina`, `skill_fist`, `skill_fist_tries`, `skill_club`, `skill_club_tries`, `skill_sword`, `skill_sword_tries`, `skill_axe`, `skill_axe_tries`, `skill_dist`, `skill_dist_tries`, `skill_shielding`, `skill_shielding_tries`, `skill_fishing`, `skill_fishing_tries`, `deleted`, `create_ip`, `create_date`, `comment`, `hide_char` FROM `players` WHERE `name` = 'Account Manager' SQLSTATE: 00000 Driver code:   Error message:   Error occured!

Error ID: 
More info: Character Account Manager does not exist. Cannot install sample characters!

File: C:\xampp\htdocs/install.php   Line: 374

 

Ajudem por favor...

Editado Dezembro 19, 2013 por delpriore (veja o histórico de edições)

[Erimyth 95]

Resolvido se poder ajudar nesse -'

http://www.tibiaking.com/forum/topic/29928-ajuda-gesior-1030/

Editado Dezembro 31, 2013 por Erimyth (veja o histórico de edições)

[alissonfgp 118]

Na hora de instalar da erro.... aparece seguinte mensagem quando chega na etapa 4*

 

Add samples to DB:

Query: SELECT `id`, `name`, `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`, `lastlogout`, `blessings`, `balance`, `stamina`, `skill_fist`, `skill_fist_tries`, `skill_club`, `skill_club_tries`, `skill_sword`, `skill_sword_tries`, `skill_axe`, `skill_axe_tries`, `skill_dist`, `skill_dist_tries`, `skill_shielding`, `skill_shielding_tries`, `skill_fishing`, `skill_fishing_tries`, `deleted`, `create_ip`, `create_date`, `comment`, `hide_char` FROM `players` WHERE `name` = 'Account Manager' SQLSTATE: 00000 Driver code:   Error message:   Error occured!

Error ID: 

More info: Character Account Manager does not exist. Cannot install sample characters!

File: C:\xampp\htdocs/install.php   Line: 374

 

Ajudem por favor...

 

para gesior 1.0 troque sua install.php por essa, removi uns bugs desse tipo

 

<?PHP

define('INITIALIZED', true);

define('ONLY_PAGE', false);

if(!file_exists('install.txt'))

{

    echo('AAC installation is disabled. To enable it make file <b>install.php</b> in main AAC directory and put there your IP.');

    exit;

}

$installIP = trim(file_get_contents('install.txt'));

if($installIP != $_SERVER['REMOTE_ADDR'])

{

    echo('In file <b>install.txt</b> must be your IP!<br />In file is:<br /><b>' . $installIP . '</b><br />Your IP is:<br /><b>' . $_SERVER['REMOTE_ADDR'] . '</b>');

    exit;

}

$time_start = microtime(true);

session_start();

function autoLoadClass($className)

{

    if(!class_exists($className))

        if(file_exists('./classes/' . strtolower($className) . '.php'))

            include_once('./classes/' . strtolower($className) . '.php');

        else

            new Error_Critic('#E-7', 'Cannot load class <b>' . $className . '</b>, file <b>./classes/class.' . strtolower($className) . '.php</b> doesn\'t exist');

}

spl_autoload_register('autoLoadClass');

//load acc. maker config to $config['site']

$config = array();

include('./config/config.php');

if(function_exists('get_magic_quotes_gpc') && get_magic_quotes_gpc())

{

    $process = array(&$_GET, &$_POST, &$_COOKIE, &$_REQUEST);

    while(list($key, $val) = each($process))

    {

        foreach ($val as $k => $v)

        {

            unset($process[$key][$k]);

            if(is_array($v))

            {

                $process[$key][stripslashes($k)] = $v;

                $process[] = &$process[$key][stripslashes($k)];

            }

            else

                $process[$key][stripslashes($k)] = stripslashes($v);

        }

    }

    unset($process);

}

$page = '';

if(isset($_REQUEST['page']))

    $page = $_REQUEST['page'];

$step = 'start';

if(isset($_REQUEST['step']))

    $step = $_REQUEST['step'];

// load server path

function getServerPath()

{

    $config = array();

    include('./config/config.php');

    return $config['site']['serverPath'];

}

// save server path

function setServerPath($newPath)

{

    $file = fopen("./config/config.php", "r");

    $lines = array();

    while (!feof($file)) {

        $lines[] = fgets($file);

    }

    fclose($file);

    $newConfig = array();

    foreach ($lines as $i => $line)

    {

        if(substr($line, 0, strlen('$config[\'site\'][\'serverPath\']')) == '$config[\'site\'][\'serverPath\']')

            $newConfig[] = '$config[\'site\'][\'serverPath\'] = "' . str_replace('"', '\"' , $newPath) . '";' . PHP_EOL; // do something with each line from text file here

        else

            $newConfig[] = $line;

    }

    Website::putFileContents("./config/config.php", implode('', $newConfig));

}

if($page == '')

{

    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=start" />

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

    </frameset>

    </html>';

}

elseif($page == 'menu')

{

    echo '<h2>MENU</h2><br>

    <b>IF NOT INSTALLED:</b><br>

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

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

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

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

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

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

    <b>Author:</b><br>

    Gesior<br>

    Compatible with TFS 1.0</a>';

}

elseif($page == 'step')

{

    if($step >= 2 && $step <= 5)

    {

        //load server config $config['server']

        if(Website::getWebsiteConfig()->getValue('useServerConfigCache'))

        {

            // use cache to make website load faster

            if(Website::fileExists('./config/server.config.php'))

            {

                $tmp_php_config = new ConfigPHP('./config/server.config.php');

                $config['server'] = $tmp_php_config->getConfig();

            }

            else

            {

                // if file isn't cache we should load .lua file and make .php cache

                $tmp_lua_config = new ConfigLUA(Website::getWebsiteConfig()->getValue('serverPath') . 'config.lua');

                $config['server'] = $tmp_lua_config->getConfig();

                $tmp_php_config = new ConfigPHP();

                $tmp_php_config->setConfig($tmp_lua_config->getConfig());

                $tmp_php_config->saveToFile('./config/server.config.php');

            }

        }

        else

        {

            $tmp_lua_config = new ConfigLUA(Website::getWebsiteConfig()->getValue('serverPath') . 'config.lua');

            $config['server'] = $tmp_lua_config->getConfig();

        }

        if(Website::getServerConfig()->isSetKey('mysqlHost'))

        {

            define('SERVERCONFIG_SQL_HOST', 'mysqlHost');

            define('SERVERCONFIG_SQL_PORT', 'mysqlPort');

            define('SERVERCONFIG_SQL_USER', 'mysqlUser');

            define('SERVERCONFIG_SQL_PASS', 'mysqlPass');

            define('SERVERCONFIG_SQL_DATABASE', 'mysqlDatabase');

            define('SERVERCONFIG_SQLITE_FILE', 'sqlFile');

        }

        else

            new Error_Critic('#E-3', 'There is no key <b>mysqlHost</b> in server config', array(new Error('INFO', 'use server config cache: <b>' . (Website::getWebsiteConfig()->getValue('useServerConfigCache') ? 'true' : 'false') . '</b>')));

        Website::setDatabaseDriver(Database::DB_MYSQL);

        if(Website::getServerConfig()->isSetKey(SERVERCONFIG_SQL_HOST))

            Website::getDBHandle()->setDatabaseHost(Website::getServerConfig()->getValue(SERVERCONFIG_SQL_HOST));

        else

            new Error_Critic('#E-7', 'There is no key <b>' . SERVERCONFIG_SQL_HOST . '</b> in server config file.');

        if(Website::getServerConfig()->isSetKey(SERVERCONFIG_SQL_PORT))

            Website::getDBHandle()->setDatabasePort(Website::getServerConfig()->getValue(SERVERCONFIG_SQL_PORT));

        else

            new Error_Critic('#E-7', 'There is no key <b>' . SERVERCONFIG_SQL_PORT . '</b> in server config file.');

        if(Website::getServerConfig()->isSetKey(SERVERCONFIG_SQL_DATABASE))

            Website::getDBHandle()->setDatabaseName(Website::getServerConfig()->getValue(SERVERCONFIG_SQL_DATABASE));

        else

            new Error_Critic('#E-7', 'There is no key <b>' . SERVERCONFIG_SQL_DATABASE . '</b> in server config file.');

        if(Website::getServerConfig()->isSetKey(SERVERCONFIG_SQL_USER))

            Website::getDBHandle()->setDatabaseUsername(Website::getServerConfig()->getValue(SERVERCONFIG_SQL_USER));

        else

            new Error_Critic('#E-7', 'There is no key <b>' . SERVERCONFIG_SQL_USER . '</b> in server config file.');

        if(Website::getServerConfig()->isSetKey(SERVERCONFIG_SQL_PASS))

            Website::getDBHandle()->setDatabasePassword(Website::getServerConfig()->getValue(SERVERCONFIG_SQL_PASS));

        else

            new Error_Critic('#E-7', 'There is no key <b>' . SERVERCONFIG_SQL_PASS . '</b> in server config file.');

        Website::setPasswordsEncryption(Website::getServerConfig()->getValue('passwordType'));

        $SQL = Website::getDBHandle();

Website::getDBHandle()->setPrintQueries(true);

    }

    if($step == 'start')

    {

        echo '<h1>STEP '.$step.'</h1>Informations<br>';

        echo 'Welcome to Gesior Account Maker installer. <b>After 5 simple steps account maker will be ready to use!</b><br />';

        // check access to write files

        $writeable = array('config/config.php', 'cache', 'cache/flags', 'cache/DONT_EDIT_usercounter.txt', 'cache/DONT_EDIT_serverstatus.txt', 'custom_scripts', 'install.txt');

        foreach($writeable as $fileToWrite)

        {

            if(is_writable($fileToWrite))

                echo '<span style="color:green">CAN WRITE TO FILE: <b>' . $fileToWrite . '</b></span><br />';

            else

                echo '<span style="color:red">CANNOT WRITE TO FILE: <b>' . $fileToWrite . '</b> - edit file access for PHP [on linux: chmod]</span><br />';

        }

    }

    elseif($step == 1)

    {

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

        {

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

            $path = $_REQUEST['server_path'];

            $path = trim($path)."\\";

            $path = str_replace("\\\\", "/", $path);

            $path = str_replace("\\", "/", $path);

            $path = str_replace("//", "/", $path);

            setServerPath($path);

            $tmp_lua_config = new ConfigLUA($path . 'config.lua');

            $config['server'] = $tmp_lua_config->getConfig();

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

            {

                echo 'File <b>config.lua</b> loaded from <font color="red"><i>'.$path.'config.lua</i></font>. It looks like fine server config file. Now you can check database connection: <a href="install.php?page=step&step=2">STEP 2 - check database connection</a>';

            }

            else

            {

                echo 'File <b>config.lua</b> loaded from <font color="red"><i>'.$path.'config.lua</i></font> and it\'s not valid TFS config.lua file. <a href="install.php?page=step&step=1">Go to STEP 1 - select other directory.</a> If it\'s your config.lua file from TFS contact with acc. maker author.';

            }

        }

        else

        {

            echo 'Please write you TFS directory below. Like: <i>C:\Documents and Settings\Gesior\Desktop\TFS 0.2.9\</i><form action="install.php">

            <input type="text" name="server_path" size="90" value="'.htmlspecialchars(getServerPath()).'" /><input type="hidden" name="page" value="step" /><input type="hidden" name="step" value="1" /><input type="submit" value="Set server path" />

            </form>';

        }

    }

    elseif($step == 2)

    {

        echo '<h1>STEP '.$step.'</h1>Check database connection<br>';

        echo 'If you don\'t see any errors press <a href="install.php?page=step&step=3">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.<br />';

        $SQL->connect(); // show errors if can't connect

    }

    elseif($step == 3)

    {

        echo '<h1>STEP '.$step.'</h1>Add tables and columns to DB<br>';

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

        $columns = array();

        //$columns[] = array('table', 'name_of_column', 'type', 'length', 'default');

        $columns[] = array('accounts', 'key', 'VARCHAR', '20', '0');

        $columns[] = array('accounts', 'email_new', 'VARCHAR', '255', '');

        $columns[] = array('accounts', 'email_new_time', 'INT', '11', '0');

        $columns[] = array('accounts', 'rlname', 'VARCHAR', '255', '');

        $columns[] = array('accounts', 'location', 'VARCHAR', '255', '');

        $columns[] = array('accounts', 'page_access', 'INT', '11', '0');

        $columns[] = array('accounts', 'email_code', 'VARCHAR', '255', '');

        $columns[] = array('accounts', 'next_email', 'INT', '11', '0');

        $columns[] = array('accounts', 'premium_points', 'INT', '11', '0');

        $columns[] = array('accounts', 'create_date', 'INT', '11', '0');

        $columns[] = array('accounts', 'create_ip', 'INT', '11', '0');

        $columns[] = array('accounts', 'last_post', 'INT', '11', '0');

        $columns[] = array('accounts', 'flag', 'VARCHAR', '80', '');

        $columns[] = array('guilds', 'description', 'TEXT', '', '');

        $columns[] = array('guilds', 'guild_logo', 'MEDIUMBLOB', '', NULL);

        $columns[] = array('guilds', 'create_ip', 'INT', '11', '0');

        $columns[] = array('guilds', 'balance', 'BIGINT UNSIGNED', '', '0');

        $columns[] = array('players', 'deleted', 'TINYINT', '1', '0');

        $columns[] = array('players', 'description', 'VARCHAR', '255', '');

        $columns[] = array('players', 'comment', 'TEXT', '', '');

        $columns[] = array('players', 'create_ip', 'INT', '11', '0');

        $columns[] = array('players', 'create_date', 'INT', '11', '0');

        $columns[] = array('players', 'hide_char', 'INT', '11', '0');

        $tables = array();

        // mysql tables

        $tables[Database::DB_MYSQL]['z_ots_comunication'] = "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=InnoDB DEFAULT CHARSET=latin1;";

        $tables[Database::DB_MYSQL]['z_shop_offer'] = "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,

                              PRIMARY KEY  (`id`)

                            ) ENGINE=InnoDB DEFAULT CHARSET=latin1;";

        $tables[Database::DB_MYSQL]['z_shop_history_item'] = "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` varchar(255) NOT NULL default '',

                              `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=InnoDB DEFAULT CHARSET=latin1;";

        $tables[Database::DB_MYSQL]['accounts'] = "INSERT INTO `accounts` (`id`, `name`, `password`, `type`, `premdays`, `lastday`, `email`, `creation`, `key`, `email_new`, `email_new_time`, `rlname`, `location`, `page_access`, `email_code`, `next_email`, `premium_points`, `create_date`, `create_ip`, `last_post`, `flag`) VALUES

(1, '1', '65d4sa65d4cas', 1, 0, 0, '', 0, '0', '', 0, '', '', 3, '', 0, 10, 0, 0, 0, 'unknown')";

        $tables[Database::DB_MYSQL]['players'] = "INSERT INTO `players` (`id`, `name`, `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`, `lastlogout`, `blessings`, `onlinetime`, `deletion`, `balance`, `offlinetraining_time`, `offlinetraining_skill`, `stamina`, `skill_fist`, `skill_fist_tries`, `skill_club`, `skill_club_tries`, `skill_sword`, `skill_sword_tries`, `skill_axe`, `skill_axe_tries`, `skill_dist`, `skill_dist_tries`, `skill_shielding`, `skill_shielding_tries`, `skill_fishing`, `skill_fishing_tries`, `deleted`, `description`, `comment`, `create_ip`, `create_date`, `hide_char`) VALUES

(1, 'Account Manager', 1, 1, 1, 0, 150, 150, 0, 0, 0, 0, 0, 136, 0, 0, 0, 0, 0, 0, 6, 0, 0, 0, '', 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 43200, -1, 2520, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 0, '', '', 0, 0, 0)";

        $tables[Database::DB_MYSQL]['z_forum'] = "CREATE TABLE `z_forum` (

                              `id` int(11) NOT NULL auto_increment,

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

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

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

                              `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(15) NOT NULL default '0.0.0.0',

                              PRIMARY KEY  (`id`),

                              KEY `section` (`section`)

                            ) ENGINE=InnoDB DEFAULT CHARSET=latin1;";

        

        foreach($columns as $column)

        {

            if($column[4] === NULL && $SQL->query('ALTER TABLE ' . $SQL->tableName($column[0]) . ' ADD ' . $SQL->fieldName($column[1]) . ' ' . $column[2] . '  NULL DEFAULT NULL') !== false)

                echo "<span style=\"color:green\">Column <b>" . $column[1] . "</b> added to table <b>" . $column[0] . "</b>.</span><br />";

            elseif($SQL->query('ALTER TABLE ' . $SQL->tableName($column[0]) . ' ADD ' . $SQL->fieldName($column[1]) . ' ' . $column[2] . '' . (($column[3] == '') ? '' : '(' . $column[3] . ')') . ' NOT NULL DEFAULT \'' . $column[4] . '\'') !== false)

                echo "<span style=\"color:green\">Column <b>" . $column[1] . "</b> added to table <b>" . $column[0] . "</b>.</span><br />";

            else

                echo "Could not add column <b>" . $column[1] . "</b> to table <b>" . $column[0] . "</b>. Already exist?<br />";

        }

        foreach($tables[$SQL->getDatabaseDriver()] as $tableName => $tableQuery)

        {

            if($SQL->query($tableQuery) !== false)

                echo "<span style=\"color:green\">Table <b>" . $tableName . "</b> created.</span><br />";

            else

                echo "Could not create table <b>" . $tableName . "</b>. Already exist?<br />";

        }

        echo 'Tables and columns added to database.<br>Go to <a href="install.php?page=step&step=4">STEP 4 - Add samples</a>';

    }

    elseif($step == 4)

    {

        echo '<h1>STEP '.$step.'</h1>Add samples to DB:<br>';

        $samplePlayers = array();

        $samplePlayers[0] = 'Rook Sample';

        $samplePlayers[1] = 'Sorcerer Sample';

        $samplePlayers[2] = 'Druid Sample';

        $samplePlayers[3] = 'Paladin Sample';

        $samplePlayers[4] = 'Knight Sample';

        $newPlayer = new Player('Account Manager', Player::LOADTYPE_NAME);

        if($newPlayer->isLoaded())

        {

            foreach($samplePlayers as $vocationID => $name)

            {

                $samplePlayer = new Player($name, Player::LOADTYPE_NAME);

                if(!$samplePlayer->isLoaded())

                {

                    $samplePlayer = new Player('Account Manager', Player::LOADTYPE_NAME);

                    $samplePlayer->setID(null); // save as new player, not edited

                    $samplePlayer->setName($name);

                    $samplePlayer->setVocation($vocationID);

                    $samplePlayer->setGroupID(1);

                    $samplePlayer->setLookType(128);

                    $samplePlayer->save();

                    echo '<span style="color:green">Added sample character: </span><span style="color:green;font-weight:bold">' . $name . '</span><br/>';

                }

                else

                    echo 'Sample character: <span style="font-weight:bold">' . $name . '</span> already exist in database<br/>';

            }

        }

        else

            new Error_Critic('', 'Character <i>Account Manager</i> does not exist. Cannot install sample characters!');

    }

    elseif($step == 5)

    {

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

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

        {

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

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

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

        }

        else

        {

            include_once('./system/load.compat.php');

            $newpass = trim($_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">GO BACK</a> and write other password.';

            else

            {

                //create / set pass to admin account

                $account = new Account(1, Account::LOADTYPE_NAME);

                if($account->isLoaded())

                {

                    $account->setPassword($newpass); // setPassword encrypt it to ots encryption

                    $account->setPageAccess(3);

                    $account->setFlag('unknown');

                    $account->save();

                }

                else

                {

                    $newAccount = new Account();

                    $newAccount->setName(1);

                    $newAccount->setPassword($newpass); // setPassword encrypt it to ots encryption

                    $newAccount->setMail(rand(0,999999) . '@gmail.com');

                    $newAccount->setPageAccess(3);

                    $newAccount->setGroupID(1);

                    $newAccount->setFlag('unknown');

                    $newAccount->setCreateIP(Visitor::getIP());

                    $newAccount->setCreateDate(time());

                }

                $_SESSION['account'] = 1;

                $_SESSION['password'] = $newpass;

                $logged = TRUE;

                echo '<h1>Admin account login: 1<br>Admin account password: '.$newpass.'</h1><br/><h3>It\'s end of installation. Installation is blocked!</h3>';

                if(!unlink('install.txt'))

                    new Error_Critic('', 'Cannot remove file <i>install.txt</i>. You must remove it to disable installer. I recommend you to go to step <i>0</i> and check if any other file got problems with WRITE permission.');

            }

        }

    }

}

[Avuenja 322]

Excelente Bruno! Parabéns, irei testar aqui! Thanks

[soares000 0]

Estou usando o geisor 1.0 e da o seguinte erro na 2ª etapa :

 

Error occured!

Error ID: #C-5
More info: ERROR: #C-5 : Class::ConfigPHP - Key useServerConfigCache doesn't exist.

File: C:\xampp\htdocs\classes/configphp.php   Line: 96
File: C:\xampp\htdocs/install.php   Line: 120

[ospirata 0]

o meu apresenta esse:

 

Error occured!

Error ID: 
More info: CANNOT CONNECT TO DATABASE: SQLSTATE[42000] [1102] Incorrect database name 'website.sql'

File: C:\Program Files (x86)\VertrigoServ\www\classes/database_mysql.php   Line: 22
File: C:\Program Files (x86)\VertrigoServ\www/install.php   Line: 228

 

Mesmo usando o install.php que alissonfgp colocou no dia 31/12/2013.

 

--- Edit

 

Erro tava na minha cara... kk

 

Consegui, só que tenho que arruma aquela coluna skill_fist em field list

Editado Janeiro 9, 2014 por ospirata (veja o histórico de edições)

[Jamison Collins 387]

 o título está errado, é Gesior "AAC".

O Gesior AAC tem bootstrap? 

[Bruno Carvalho 837]

 o título está errado, é Gesior "AAC".

O Gesior AAC tem bootstrap? 

Sério? Minha vida foi uma mentira? 'o

[Jamison Collins 387]

Sim, foi uma mentira...
@Dúvida_do_conteúdo

O Gesior AAC possui bootstrap ?

[Avuenja 322]

Não Collins, gesior não possui bootstrap... xD

[lusgo 2]

para gesior 1.0 troque sua install.php por essa, removi uns bugs desse tipo

 

<?PHP

define('INITIALIZED', true);

define('ONLY_PAGE', false);

if(!file_exists('install.txt'))

{

    echo('AAC installation is disabled. To enable it make file <b>install.php</b> in main AAC directory and put there your IP.');

    exit;

}

$installIP = trim(file_get_contents('install.txt'));

if($installIP != $_SERVER['REMOTE_ADDR'])

{

    echo('In file <b>install.txt</b> must be your IP!<br />In file is:<br /><b>' . $installIP . '</b><br />Your IP is:<br /><b>' . $_SERVER['REMOTE_ADDR'] . '</b>');

    exit;

}

$time_start = microtime(true);

session_start();

function autoLoadClass($className)

{

    if(!class_exists($className))

        if(file_exists('./classes/' . strtolower($className) . '.php'))

            include_once('./classes/' . strtolower($className) . '.php');

        else

            new Error_Critic('#E-7', 'Cannot load class <b>' . $className . '</b>, file <b>./classes/class.' . strtolower($className) . '.php</b> doesn\'t exist');

}

spl_autoload_register('autoLoadClass');

//load acc. maker config to $config['site']

$config = array();

include('./config/config.php');

if(function_exists('get_magic_quotes_gpc') && get_magic_quotes_gpc())

{

    $process = array(&$_GET, &$_POST, &$_COOKIE, &$_REQUEST);

    while(list($key, $val) = each($process))

    {

        foreach ($val as $k => $v)

        {

            unset($process[$key][$k]);

            if(is_array($v))

            {

                $process[$key][stripslashes($k)] = $v;

                $process[] = &$process[$key][stripslashes($k)];

            }

            else

                $process[$key][stripslashes($k)] = stripslashes($v);

        }

    }

    unset($process);

}

$page = '';

if(isset($_REQUEST['page']))

    $page = $_REQUEST['page'];

$step = 'start';

if(isset($_REQUEST['step']))

    $step = $_REQUEST['step'];

// load server path

function getServerPath()

{

    $config = array();

    include('./config/config.php');

    return $config['site']['serverPath'];

}

// save server path

function setServerPath($newPath)

{

    $file = fopen("./config/config.php", "r");

    $lines = array();

    while (!feof($file)) {

        $lines[] = fgets($file);

    }

    fclose($file);

    $newConfig = array();

    foreach ($lines as $i => $line)

    {

        if(substr($line, 0, strlen('$config[\'site\'][\'serverPath\']')) == '$config[\'site\'][\'serverPath\']')

            $newConfig[] = '$config[\'site\'][\'serverPath\'] = "' . str_replace('"', '\"' , $newPath) . '";' . PHP_EOL; // do something with each line from text file here

        else

            $newConfig[] = $line;

    }

    Website::putFileContents("./config/config.php", implode('', $newConfig));

}

if($page == '')

{

    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=start" />

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

    </frameset>

    </html>';

}

elseif($page == 'menu')

{

    echo '<h2>MENU</h2><br>

    <b>IF NOT INSTALLED:</b><br>

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

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

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

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

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

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

    <b>Author:</b><br>

    Gesior<br>

    Compatible with TFS 1.0</a>';

}

elseif($page == 'step')

{

    if($step >= 2 && $step <= 5)

    {

        //load server config $config['server']

        if(Website::getWebsiteConfig()->getValue('useServerConfigCache'))

        {

            // use cache to make website load faster

            if(Website::fileExists('./config/server.config.php'))

            {

                $tmp_php_config = new ConfigPHP('./config/server.config.php');

                $config['server'] = $tmp_php_config->getConfig();

            }

            else

            {

                // if file isn't cache we should load .lua file and make .php cache

                $tmp_lua_config = new ConfigLUA(Website::getWebsiteConfig()->getValue('serverPath') . 'config.lua');

                $config['server'] = $tmp_lua_config->getConfig();

                $tmp_php_config = new ConfigPHP();

                $tmp_php_config->setConfig($tmp_lua_config->getConfig());

                $tmp_php_config->saveToFile('./config/server.config.php');

            }

        }

        else

        {

            $tmp_lua_config = new ConfigLUA(Website::getWebsiteConfig()->getValue('serverPath') . 'config.lua');

            $config['server'] = $tmp_lua_config->getConfig();

        }

        if(Website::getServerConfig()->isSetKey('mysqlHost'))

        {

            define('SERVERCONFIG_SQL_HOST', 'mysqlHost');

            define('SERVERCONFIG_SQL_PORT', 'mysqlPort');

            define('SERVERCONFIG_SQL_USER', 'mysqlUser');

            define('SERVERCONFIG_SQL_PASS', 'mysqlPass');

            define('SERVERCONFIG_SQL_DATABASE', 'mysqlDatabase');

            define('SERVERCONFIG_SQLITE_FILE', 'sqlFile');

        }

        else

            new Error_Critic('#E-3', 'There is no key <b>mysqlHost</b> in server config', array(new Error('INFO', 'use server config cache: <b>' . (Website::getWebsiteConfig()->getValue('useServerConfigCache') ? 'true' : 'false') . '</b>')));

        Website::setDatabaseDriver(Database::DB_MYSQL);

        if(Website::getServerConfig()->isSetKey(SERVERCONFIG_SQL_HOST))

            Website::getDBHandle()->setDatabaseHost(Website::getServerConfig()->getValue(SERVERCONFIG_SQL_HOST));

        else

            new Error_Critic('#E-7', 'There is no key <b>' . SERVERCONFIG_SQL_HOST . '</b> in server config file.');

        if(Website::getServerConfig()->isSetKey(SERVERCONFIG_SQL_PORT))

            Website::getDBHandle()->setDatabasePort(Website::getServerConfig()->getValue(SERVERCONFIG_SQL_PORT));

        else

            new Error_Critic('#E-7', 'There is no key <b>' . SERVERCONFIG_SQL_PORT . '</b> in server config file.');

        if(Website::getServerConfig()->isSetKey(SERVERCONFIG_SQL_DATABASE))

            Website::getDBHandle()->setDatabaseName(Website::getServerConfig()->getValue(SERVERCONFIG_SQL_DATABASE));

        else

            new Error_Critic('#E-7', 'There is no key <b>' . SERVERCONFIG_SQL_DATABASE . '</b> in server config file.');

        if(Website::getServerConfig()->isSetKey(SERVERCONFIG_SQL_USER))

            Website::getDBHandle()->setDatabaseUsername(Website::getServerConfig()->getValue(SERVERCONFIG_SQL_USER));

        else

            new Error_Critic('#E-7', 'There is no key <b>' . SERVERCONFIG_SQL_USER . '</b> in server config file.');

        if(Website::getServerConfig()->isSetKey(SERVERCONFIG_SQL_PASS))

            Website::getDBHandle()->setDatabasePassword(Website::getServerConfig()->getValue(SERVERCONFIG_SQL_PASS));

        else

            new Error_Critic('#E-7', 'There is no key <b>' . SERVERCONFIG_SQL_PASS . '</b> in server config file.');

        Website::setPasswordsEncryption(Website::getServerConfig()->getValue('passwordType'));

        $SQL = Website::getDBHandle();

Website::getDBHandle()->setPrintQueries(true);

    }

    if($step == 'start')

    {

        echo '<h1>STEP '.$step.'</h1>Informations<br>';

        echo 'Welcome to Gesior Account Maker installer. <b>After 5 simple steps account maker will be ready to use!</b><br />';

        // check access to write files

        $writeable = array('config/config.php', 'cache', 'cache/flags', 'cache/DONT_EDIT_usercounter.txt', 'cache/DONT_EDIT_serverstatus.txt', 'custom_scripts', 'install.txt');

        foreach($writeable as $fileToWrite)

        {

            if(is_writable($fileToWrite))

                echo '<span style="color:green">CAN WRITE TO FILE: <b>' . $fileToWrite . '</b></span><br />';

            else

                echo '<span style="color:red">CANNOT WRITE TO FILE: <b>' . $fileToWrite . '</b> - edit file access for PHP [on linux: chmod]</span><br />';

        }

    }

    elseif($step == 1)

    {

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

        {

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

            $path = $_REQUEST['server_path'];

            $path = trim($path)."\\";

            $path = str_replace("\\\\", "/", $path);

            $path = str_replace("\\", "/", $path);

            $path = str_replace("//", "/", $path);

            setServerPath($path);

            $tmp_lua_config = new ConfigLUA($path . 'config.lua');

            $config['server'] = $tmp_lua_config->getConfig();

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

            {

                echo 'File <b>config.lua</b> loaded from <font color="red"><i>'.$path.'config.lua</i></font>. It looks like fine server config file. Now you can check database connection: <a href="install.php?page=step&step=2">STEP 2 - check database connection</a>';

            }

            else

            {

                echo 'File <b>config.lua</b> loaded from <font color="red"><i>'.$path.'config.lua</i></font> and it\'s not valid TFS config.lua file. <a href="install.php?page=step&step=1">Go to STEP 1 - select other directory.</a> If it\'s your config.lua file from TFS contact with acc. maker author.';

            }

        }

        else

        {

            echo 'Please write you TFS directory below. Like: <i>C:\Documents and Settings\Gesior\Desktop\TFS 0.2.9\</i><form action="install.php">

            <input type="text" name="server_path" size="90" value="'.htmlspecialchars(getServerPath()).'" /><input type="hidden" name="page" value="step" /><input type="hidden" name="step" value="1" /><input type="submit" value="Set server path" />

            </form>';

        }

    }

    elseif($step == 2)

    {

        echo '<h1>STEP '.$step.'</h1>Check database connection<br>';

        echo 'If you don\'t see any errors press <a href="install.php?page=step&step=3">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.<br />';

        $SQL->connect(); // show errors if can't connect

    }

    elseif($step == 3)

    {

        echo '<h1>STEP '.$step.'</h1>Add tables and columns to DB<br>';

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

        $columns = array();

        //$columns[] = array('table', 'name_of_column', 'type', 'length', 'default');

        $columns[] = array('accounts', 'key', 'VARCHAR', '20', '0');

        $columns[] = array('accounts', 'email_new', 'VARCHAR', '255', '');

        $columns[] = array('accounts', 'email_new_time', 'INT', '11', '0');

        $columns[] = array('accounts', 'rlname', 'VARCHAR', '255', '');

        $columns[] = array('accounts', 'location', 'VARCHAR', '255', '');

        $columns[] = array('accounts', 'page_access', 'INT', '11', '0');

        $columns[] = array('accounts', 'email_code', 'VARCHAR', '255', '');

        $columns[] = array('accounts', 'next_email', 'INT', '11', '0');

        $columns[] = array('accounts', 'premium_points', 'INT', '11', '0');

        $columns[] = array('accounts', 'create_date', 'INT', '11', '0');

        $columns[] = array('accounts', 'create_ip', 'INT', '11', '0');

        $columns[] = array('accounts', 'last_post', 'INT', '11', '0');

        $columns[] = array('accounts', 'flag', 'VARCHAR', '80', '');

        $columns[] = array('guilds', 'description', 'TEXT', '', '');

        $columns[] = array('guilds', 'guild_logo', 'MEDIUMBLOB', '', NULL);

        $columns[] = array('guilds', 'create_ip', 'INT', '11', '0');

        $columns[] = array('guilds', 'balance', 'BIGINT UNSIGNED', '', '0');

        $columns[] = array('players', 'deleted', 'TINYINT', '1', '0');

        $columns[] = array('players', 'description', 'VARCHAR', '255', '');

        $columns[] = array('players', 'comment', 'TEXT', '', '');

        $columns[] = array('players', 'create_ip', 'INT', '11', '0');

        $columns[] = array('players', 'create_date', 'INT', '11', '0');

        $columns[] = array('players', 'hide_char', 'INT', '11', '0');

        $tables = array();

        // mysql tables

        $tables[Database::DB_MYSQL]['z_ots_comunication'] = "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=InnoDB DEFAULT CHARSET=latin1;";

        $tables[Database::DB_MYSQL]['z_shop_offer'] = "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,

                              PRIMARY KEY  (`id`)

                            ) ENGINE=InnoDB DEFAULT CHARSET=latin1;";

        $tables[Database::DB_MYSQL]['z_shop_history_item'] = "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` varchar(255) NOT NULL default '',

                              `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=InnoDB DEFAULT CHARSET=latin1;";

        $tables[Database::DB_MYSQL]['accounts'] = "INSERT INTO `accounts` (`id`, `name`, `password`, `type`, `premdays`, `lastday`, `email`, `creation`, `key`, `email_new`, `email_new_time`, `rlname`, `location`, `page_access`, `email_code`, `next_email`, `premium_points`, `create_date`, `create_ip`, `last_post`, `flag`) VALUES

(1, '1', '65d4sa65d4cas', 1, 0, 0, '', 0, '0', '', 0, '', '', 3, '', 0, 10, 0, 0, 0, 'unknown')";

        $tables[Database::DB_MYSQL]['players'] = "INSERT INTO `players` (`id`, `name`, `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`, `lastlogout`, `blessings`, `onlinetime`, `deletion`, `balance`, `offlinetraining_time`, `offlinetraining_skill`, `stamina`, `skill_fist`, `skill_fist_tries`, `skill_club`, `skill_club_tries`, `skill_sword`, `skill_sword_tries`, `skill_axe`, `skill_axe_tries`, `skill_dist`, `skill_dist_tries`, `skill_shielding`, `skill_shielding_tries`, `skill_fishing`, `skill_fishing_tries`, `deleted`, `description`, `comment`, `create_ip`, `create_date`, `hide_char`) VALUES

(1, 'Account Manager', 1, 1, 1, 0, 150, 150, 0, 0, 0, 0, 0, 136, 0, 0, 0, 0, 0, 0, 6, 0, 0, 0, '', 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 43200, -1, 2520, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 0, '', '', 0, 0, 0)";

        $tables[Database::DB_MYSQL]['z_forum'] = "CREATE TABLE `z_forum` (

                              `id` int(11) NOT NULL auto_increment,

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

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

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

                              `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(15) NOT NULL default '0.0.0.0',

                              PRIMARY KEY  (`id`),

                              KEY `section` (`section`)

                            ) ENGINE=InnoDB DEFAULT CHARSET=latin1;";

        

        foreach($columns as $column)

        {

            if($column[4] === NULL && $SQL->query('ALTER TABLE ' . $SQL->tableName($column[0]) . ' ADD ' . $SQL->fieldName($column[1]) . ' ' . $column[2] . '  NULL DEFAULT NULL') !== false)

                echo "<span style=\"color:green\">Column <b>" . $column[1] . "</b> added to table <b>" . $column[0] . "</b>.</span><br />";

            elseif($SQL->query('ALTER TABLE ' . $SQL->tableName($column[0]) . ' ADD ' . $SQL->fieldName($column[1]) . ' ' . $column[2] . '' . (($column[3] == '') ? '' : '(' . $column[3] . ')') . ' NOT NULL DEFAULT \'' . $column[4] . '\'') !== false)

                echo "<span style=\"color:green\">Column <b>" . $column[1] . "</b> added to table <b>" . $column[0] . "</b>.</span><br />";

            else

                echo "Could not add column <b>" . $column[1] . "</b> to table <b>" . $column[0] . "</b>. Already exist?<br />";

        }

        foreach($tables[$SQL->getDatabaseDriver()] as $tableName => $tableQuery)

        {

            if($SQL->query($tableQuery) !== false)

                echo "<span style=\"color:green\">Table <b>" . $tableName . "</b> created.</span><br />";

            else

                echo "Could not create table <b>" . $tableName . "</b>. Already exist?<br />";

        }

        echo 'Tables and columns added to database.<br>Go to <a href="install.php?page=step&step=4">STEP 4 - Add samples</a>';

    }

    elseif($step == 4)

    {

        echo '<h1>STEP '.$step.'</h1>Add samples to DB:<br>';

        $samplePlayers = array();

        $samplePlayers[0] = 'Rook Sample';

        $samplePlayers[1] = 'Sorcerer Sample';

        $samplePlayers[2] = 'Druid Sample';

        $samplePlayers[3] = 'Paladin Sample';

        $samplePlayers[4] = 'Knight Sample';

        $newPlayer = new Player('Account Manager', Player::LOADTYPE_NAME);

        if($newPlayer->isLoaded())

        {

            foreach($samplePlayers as $vocationID => $name)

            {

                $samplePlayer = new Player($name, Player::LOADTYPE_NAME);

                if(!$samplePlayer->isLoaded())

                {

                    $samplePlayer = new Player('Account Manager', Player::LOADTYPE_NAME);

                    $samplePlayer->setID(null); // save as new player, not edited

                    $samplePlayer->setName($name);

                    $samplePlayer->setVocation($vocationID);

                    $samplePlayer->setGroupID(1);

                    $samplePlayer->setLookType(128);

                    $samplePlayer->save();

                    echo '<span style="color:green">Added sample character: </span><span style="color:green;font-weight:bold">' . $name . '</span><br/>';

                }

                else

                    echo 'Sample character: <span style="font-weight:bold">' . $name . '</span> already exist in database<br/>';

            }

        }

        else

            new Error_Critic('', 'Character <i>Account Manager</i> does not exist. Cannot install sample characters!');

    }

    elseif($step == 5)

    {

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

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

        {

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

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

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

        }

        else

        {

            include_once('./system/load.compat.php');

            $newpass = trim($_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">GO BACK</a> and write other password.';

            else

            {

                //create / set pass to admin account

                $account = new Account(1, Account::LOADTYPE_NAME);

                if($account->isLoaded())

                {

                    $account->setPassword($newpass); // setPassword encrypt it to ots encryption

                    $account->setPageAccess(3);

                    $account->setFlag('unknown');

                    $account->save();

                }

                else

                {

                    $newAccount = new Account();

                    $newAccount->setName(1);

                    $newAccount->setPassword($newpass); // setPassword encrypt it to ots encryption

                    $newAccount->setMail(rand(0,999999) . '@gmail.com');

                    $newAccount->setPageAccess(3);

                    $newAccount->setGroupID(1);

                    $newAccount->setFlag('unknown');

                    $newAccount->setCreateIP(Visitor::getIP());

                    $newAccount->setCreateDate(time());

                }

                $_SESSION['account'] = 1;

                $_SESSION['password'] = $newpass;

                $logged = TRUE;

                echo '<h1>Admin account login: 1<br>Admin account password: '.$newpass.'</h1><br/><h3>It\'s end of installation. Installation is blocked!</h3>';

                if(!unlink('install.txt'))

                    new Error_Critic('', 'Cannot remove file <i>install.txt</i>. You must remove it to disable installer. I recommend you to go to step <i>0</i> and check if any other file got problems with WRITE permission.');

            }

        }

    }

}

 

No caso eu também estou com o erro "File: C:\xampp\htdocs/install.php   Line: 374", entretanto se eu modificar o instal.php ele obtêm um novo erro, o "File: C:\xampp\htdocs/install.php Line: 381". Tem como alguém me ajudar?

[Povildo 23]

BUG!

 

Error occured!
Error ID: #C-5
More info: ERROR: #C-5 : Class::ConfigPHP - Key passwordType doesn't exist.

File: C:\xampp\htdocs\sv1\classes/configphp.php Line: 96
File: C:\xampp\htdocs\sv1/install.php Line: 178