Ir para conteúdo

mattheusnivel

Membro
  • Registro em

  • Última visita

Tudo que mattheusnivel postou

  1. Troca as scripts <tag> manamultiplier= <tag/> por "manamultiplier="1.4""
  2. mattheusnivel postou uma resposta no tópico em Suporte Tibia OTServer
    MEU SERVIDOR ESTÁ FECHANDO QUANDO O SERVER SALVA, ISSO COM VÁRIAS COMPILAÇÕES! DIVERSAS VERSÕES!
  3. Me arruma a a pasta Data que eu compilo a distro pra windows... e um gesior tbm...
  4. mattheusnivel postou uma resposta no tópico em Suporte Tibia OTServer
    Qual me recomenda ?
  5. mattheusnivel postou uma resposta no tópico em Suporte Tibia OTServer
    Obrigado.
  6. mattheusnivel postou uma resposta no tópico em Suporte Tibia OTServer
    Aparece isso: AAC installation is disabled. To enable it make file install.php in main AAC directory and put there your IP. Olha: Install.php: <?PHP // comment to show E_NOTICE [undefinied variable etc.], comment if you want make script and see all errors error_reporting(E_ALL ^ E_STRICT ^ E_NOTICE); 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 0.3.6 and TFS 0.4 up to revision 3702</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(); } 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]['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'; $account = new Account(1, Account::LOADTYPE_NAME); if(!$account->isLoaded()) { $account->setName(1); $account->setPassword(1); $account->setMail(rand(0,999999) . '@gmail.com'); $account->setPageAccess(3); $account->setFlag('unknown'); $account->setCreateIP(Visitor::getIP()); $account->setCreateDate(time()); $account->save(); } $newPlayer = new Player('Account Manager', Player::LOADTYPE_NAME); if(!$newPlayer->isLoaded()) { $newPlayer->setComment(''); $newPlayer->setName('Account Manager'); $newPlayer->setAccountID($account->getID()); $newPlayer->setLevel(8); $newPlayer->setExperience(4200); $newPlayer->setGroupID(1); $newPlayer->setVocation(0); $newPlayer->setHealth(185); $newPlayer->setHealthMax(185); $newPlayer->setMana(35); $newPlayer->setManaMax(35); $newPlayer->setTown(1); $newPlayer->setSoul(100); $newPlayer->setCapacity(420); $newPlayer->setSave(1); $newPlayer->setStamina(2520); $newPlayer->setLookType(128); $newPlayer->setLookBody(44); $newPlayer->setLookFeet(98); $newPlayer->setLookHead(15); $newPlayer->setLookLegs(76); $newPlayer->setSkill(0, 10); $newPlayer->setSkill(1, 10); $newPlayer->setSkill(2, 10); $newPlayer->setSkill(3, 10); $newPlayer->setSkill(4, 10); $newPlayer->setSkill(5, 10); $newPlayer->setSkill(6, 10); $newPlayer->setSkillCount(0, 0); $newPlayer->setSkillCount(1, 0); $newPlayer->setSkillCount(2, 0); $newPlayer->setSkillCount(3, 0); $newPlayer->setSkillCount(4, 0); $newPlayer->setSkillCount(5, 0); $newPlayer->setSkillCount(6, 0); $newPlayer->save(); } 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.'); } } } }
  7. mattheusnivel postou uma resposta no tópico em Suporte Tibia OTServer
    Vou testar aqui, tem como me arrumar as DLLS que falta pra rodar o distro ?
  8. mattheusnivel postou uma resposta no tópico em Suporte Tibia OTServer
    tem como me ajudar a fazer isso ? :/
  9. mattheusnivel postou uma resposta no tópico em Suporte Tibia OTServer
    não, au apenas extrai para o HTDOCS Outro erro que acontece é esse: Error occured! Error ID: #C-2 More info: ERROR: #C-2 : Class::ConfigLUA - LUA config file doesn't exist. Path: /otserv/config.lua File: C:\xampp\htdocs\classes/configlua.php Line: 24 File: C:\xampp\htdocs\classes/configlua.php Line: 12 File: C:\xampp\htdocs\system/load.init.php Line: 42 File: C:\xampp\htdocs/index.php Line: 18
  10. mattheusnivel postou uma resposta no tópico em Suporte Tibia OTServer
    o Install.Php da erro http://imgur.com/SOOvzMU
  11. mattheusnivel postou uma resposta no tópico em Suporte Tibia OTServer
    Nenhuma diferença.
  12. mattheusnivel postou uma resposta no tópico em Suporte Tibia OTServer
    <tag> <?PHP //######################## SHOW TICKERS AND NEWS ####################### $time = time(); $query = $SQL->query("SELECT * FROM `players` ORDER BY `experience` DESC")->fetch(); $query2 = $SQL->query('SELECT `id`, `name` FROM `players` ORDER BY `id` DESC LIMIT 1;')->fetch(); $housesfree = $SQL->query('SELECT COUNT(*) FROM `houses` WHERE `owner`=0;')->fetch(); $housesrented = $SQL->query('SELECT COUNT(*) FROM `houses` WHERE `owner`=1;')->fetch(); $players = $SQL->query('SELECT COUNT(*) FROM `players` WHERE `id`>0;')->fetch(); $accounts = $SQL->query('SELECT COUNT(*) FROM `accounts` WHERE `id`>0;')->fetch(); //$banned = $SQL->query('SELECT COUNT(*) FROM `bans` WHERE `id`>0;')->fetch(); $guilds = $SQL->query('SELECT COUNT(*) FROM `guilds` WHERE `id`>0;')->fetch(); ///End Queries /// // top kills - guilds $main_content .= '<div class="NewsHeadline"> <div class="NewsHeadlineBackground" style="background-image:url(' . $layout_name . '/images/news/newsheadline_background.gif)"> <table border="0"> <tr> <td style="text-align: center; font-weight: bold;"> <font color="white">Most powerfull guilds</font> </td> </tr> </table> </div> </div> <table border="0" cellspacing="3" cellpadding="4" width="100%"> <tr>'; foreach($SQL->query('SELECT `g`.`id` AS `id`, `g`.`name` AS `name`, `g`.`logo_gfx_name` AS `logo`, COUNT(`g`.`name`) as `frags` FROM `killers` k LEFT JOIN `player_killers` pk ON `k`.`id` = `pk`.`kill_id` LEFT JOIN `players` p ON `pk`.`player_id` = `p`.`id` LEFT JOIN `guild_ranks` gr ON `p`.`rank_id` = `gr`.`id` LEFT JOIN `guilds` g ON `gr`.`guild_id` = `g`.`id` WHERE `k`.`unjustified` = 1 AND `k`.`final_hit` = 1 GROUP BY `name` ORDER BY `frags` DESC, `name` ASC LIMIT 0, 3;') as $guild) $main_content .= ' <td style="width: 25%; text-align: center;"> <a href="?subtopic=guilds&action=show&guild=' . $guild['id'] . '"><img src=guild_image.php?id=' . $guild['id] . '" width="64" height="64" border="0"/> <br />' . $guild['name'] . '</a><br />' . $guild['frags'] . ' kills </td>'; $main_content .= ' </tr> </table>'; $main_content .= '<table bgcolor='.$config['site']['darkborder'].' border=0 cellpadding=4 cellspacing=1 width=100%> <tr bgcolor='. $config['site']['vdarkborder'] .'><td align=center" class=white colspan=1><b>Welcome to '.$config['server]['serverName'].'</b></td></tr> <tr><td><table border=0 cellpadding=1 cellspacing=1 width=100%> <tr bgcolor='. $config['site']['lightborder'] .'><td><center>Last joined us: <a href=?subtopic=characters&name='.urlencode($query2['name]).'">'.$query2['name'].'</a>, player number '.$query2['id'].'. Welcome and wish you a nice game!</center></td></tr> <tr bgcolor='. $config['site']['lightborder'] .'><td><center>Currently, the best player on the server is: <a href=index.php?subtopic=characters&name='.urlencode($query['name]).'"> '.$query['name'].'</a> ('.urlencode($query['level']).'). Congratulations!</center></td></tr> <table border=0 cellpadding=0 cellspacing=1 width=100%> <tr bgcolor='. $config['site']['lightborder'] .'><td><center><b>Free Houses:</b> '.$housesfree[0].'</center></td> <td><center><b>Rented Houses:</b> '.$housesrented[0].'</center></td></tr> <tr bgcolor='. $config['site']['lightborder'] .'><td><center><b>Accounts</b> in database: '.$accounts[0].'</center></td> <td><center><b>Players</b> in database: '.$players[0].'</center></td></tr> <tr bgcolor='. $config['site']['lightborder'] .'><td><center><b>Banned</b> accounts: '.$banned[0].'</center></td> <td><center><b>Guilds</b> in databese: '.$guilds[0].'</center></td></tr> </table></td></tr></table>'; if($action == "") { //show tickers if any in database or not blocked (tickers limit = 0) $tickers = $SQL->query('SELECT * FROM `z_news_tickers` WHERE hide_ticker != 1 ORDER BY date DESC LIMIT 4;'); $number_of_tickers = 0; if(is_object($tickers)) { foreach($tickers as $ticker) { if(is_int($number_of_tickers / 2)) $color = "Odd"; else $color = "Even"; $tickers_to_add .= '<div id="TickerEntry-'.$number_of_tickers.'" class="Row" onclick=\'TickerAction("TickerEntry-'.$number_of_tickers.'")\'> <div class="'.$color.'"> <div class="NewsTickerIcon" style="background-image: url('.$layout_name.'/images/news/icon_'.$ticker['image_id'].'.gif);"></div> <div id="TickerEntry-'.$number_of_tickers.'-Button" class="NewsTickerExtend" style="background-image: url('.$layout_name.'/images/general/plus.gif);"></div> <div class="NewsTickerText"> <span class="NewsTickerDate">'.date("j M Y", $ticker['date']).' -</span> <div id="TickerEntry-'.$number_of_tickers.'-ShortText" class="NewsTickerShortText">'; //if admin show button to delete (hide) ticker if($group_id_of_acc_logged >= $config['site']['access_admin_panel']) { $tickers_to_add .= '<a href="?subtopic=latestnews&action=deleteticker&id='.$ticker['date'].'"><img src="'.$layout_name.'/images/news/delete.png" border="0"></a>'; } $tickers_to_add .= short_text($ticker['text'], 60).'</div> <div id="TickerEntry-'.$number_of_tickers.'-FullText" class="NewsTickerFullText">'; //if admin show button to delete (hide) ticker if($group_id_of_acc_logged >= $config['site']['access_admin_panel']) { $tickers_to_add .= '<a href="?subtopic=latestnews&action=deleteticker&id='.$ticker['date'].'"><img src="'.$layout_name.'/images/news/delete.png" border="0"></a>'; } $tickers_to_add .= $ticker['text'].'</div> </div> </div> </div>'; $number_of_tickers++; } } if(!empty($tickers_to_add)) { //show table with tickers $news_content .= '<div id="newsticker" class="Box"> <div class="Corner-tl" style="background-image: url('.$layout_name.'/images/content/corner-tl.gif);"></div> <div class="Corner-tr" style="background-image: url('.$layout_name.'/images/content/corner-tr.gif);"></div> <div class="Border_1" style="background-image: url('.$layout_name.'/images/content/border-1.gif);"></div> <div class="BorderTitleText" style="background-image: url('.$layout_name.'/images/content/title-background-green.gif);"></div> <img class="Title" src="'.$layout_name.'/images/header/headline-newsticker.gif" alt="Contentbox headline"> <div class="Border_2"> <div class="Border_3"> <div class="BoxContent" style="background-image: url('.$layout_name.'/images/content/scroll.gif);">'; if($group_id_of_acc_logged >= $config['site']['access_admin_panel']) $news_content .= '<script type="text/javascript"> var showednewticker_state = "0"; function showNewTickerForm() { if(showednewticker_state == "0") { document.getElementById("newtickerform").innerHTML = \'<form action="?subtopic=latestnews&action=newticker" method="post" ><table border="0"><tr><td bgcolor="D4C0A1" align="center"><b>Select icon:</b></td><td><table border="0" bgcolor="F1E0C6"><tr><td><img src="http://otland.net/images/news/icon_0.gif"width="20"></td><td><img src="http://otland.net/images/news/icon_1.gif" width="20"></td><td><img src="http://otland.net/images/news/icon_2.gif" width="20"></td><td><img src="http://otland.net/images/news/icon_3.gif" width="20"></td><td><img src="http://otland.net/images/news/icon_4.gif" width="20"></td></tr><tr><td><input type="radio" name="icon_id" value="0" checked="checked"></td><td><input type="radio" name="icon_id" value="1"></td><td><input type="radio" name="icon_id" value="2"></td><td><input type="radio" name="icon_id" value="3"></td><td><input type="radio" name="icon_id" value="4"></td></tr></table></td></tr><tr><td align="center" bgcolor="D4C0A1"><b>New<br>ticker<br>text:</b></td><td bgcolor="F1E0C6"><textarea name="new_ticker" rows="3" cols="45"></textarea></td></tr><tr><td><div class="BigButton" style="background-image:url('.$layout_name.'/images/buttons/sbutton.gif)" ><div onMouseOver="MouseOverBigButton(this);" onMouseOut="MouseOutBigButton(this);" ><div class="BigButtonOver" style="background-image:url('.$layout_name.'/images/buttons/sbutton_over.gif);" ></div><input class="ButtonText" type="image" name="Submit" alt="Submit" src="'.$layout_name.'/images/buttons/_sbutton_submit.gif" ></div></div></form><div class="BigButton" style="background-image:url('.$layout_name.'/images/buttons/sbutton.gif)" ><div onMouseOver="MouseOverBigButton(this);" onMouseOut="MouseOutBigButton(this);" ><div class="BigButtonOver" style="background-image:url('.$layout_name.'/images/buttons/sbutton_over.gif);" ></div><img class="ButtonText" id="AddTicker" src="'.$layout_name.'/images/buttons/_sbutton_cancel.gif" onClick="showNewTickerForm()" alt="AddTicker" /></div></div></td></tr></table>\'; document.getElementById("jajo").innerHTML = \'\'; showednewticker_state = "1"; } else { document.getElementById("newtickerform").innerHTML = \'\'; document.getElementById("jajo").innerHTML = \'<div class="BigButton" style="background-image:url('.$layout_name.'/images/buttons/sbutton.gif)" ><div onMouseOver="MouseOverBigButton(this);" onMouseOut="MouseOutBigButton(this);" ><div class="BigButtonOver" style="background-image:url('.$layout_name.'/images/buttons/sbutton_over.gif);" ></div><img class="ButtonText" id="AddTicker" src="'.$layout_name.'/images/buttons/addticker.gif" onClick="showNewTickerForm()" alt="AddTicker" /></div></div>\'; showednewticker_state = "0"; } } </script><div id="newtickerform"></div><div id="jajo"><div class="BigButton" style="background-image:url('.$layout_name.'/images/buttons/sbutton.gif)" ><div onMouseOver="MouseOverBigButton(this);" onMouseOut="MouseOutBigButton(this);" ><div class="BigButtonOver" style="background-image:url('.$layout_name.'/images/buttons/sbutton_over.gif);" ></div><img class="ButtonText" id="AddTicker" src="'.$layout_name.'/images/buttons/addticker.gif" onClick="showNewTickerForm()" alt="AddTicker" /></div></div></div><hr/>'; //add tickers list $news_content .= $tickers_to_add; //koniec $news_content .= '</div> </div> </div> <div class="Border_1" style="background-image: url('.$layout_name.'/images/content/border-1.gif);"></div> <div class="CornerWrapper-b"><div class="Corner-bl" style="background-image: url('.$layout_name.'/images/content/corner-bl.gif);"></div></div> <div class="CornerWrapper-b"><div class="Corner-br" style="background-image: url('.$layout_name.'/images/content/corner-br.gif);"></div></div> </div>'; } } //##################### ADD NEW TICKER ##################### if($action == "newticker") { if($group_id_of_acc_logged >= $config['site']['access_tickers']) { $ticker_text = stripslashes(trim($_POST['new_ticker'])); $ticker_icon = (int) $_POST['icon_id']; if(empty($ticker_text)) { $main_content .= 'You can\'t add empty ticker.'; } else { if(empty($ticker_icon)) { $ticker_icon = 0; } $SQL->query('INSERT INTO '.$SQL->tableName('z_news_tickers').' (date, author, image_id, text, hide_ticker) VALUES ('.$SQL->quote($time).', '.$account_logged->getId().', '.$ticker_icon.', '.$SQL->quote($ticker_text).', 0)'); $main_content .= '<center><h2><font color="red">Added new ticker:</font></h2></center><hr/><div id="newsticker" class="Box"><div id="TickerEntry-1" class="Row" onclick=\'TickerAction("TickerEntry-1")\'> <div class="Odd"> <div class="NewsTickerIcon" style="background-image: url('.$layout_name.'/images/news/icon_'.$ticker['image_id'].'.gif);"></div> <div id="TickerEntry-1-Button" class="NewsTickerExtend" style="background-image: url('.$layout_name.'/images/general/plus.gif);"></div> <div class="NewsTickerText"> <span class="NewsTickerDate">'.date("j M Y", $time).' -</span> <div id="TickerEntry-1-ShortText" class="NewsTickerShortText">'; $main_content .= '<a href="?subtopic=latestnews&action=deleteticker&id='.$time.'"><img src="'.$layout_name.'/images/news/delete.png" border="0"></a>'; $main_content .= short_text($ticker_text, 60).'</div> <div id="TickerEntry-1-FullText" class="NewsTickerFullText">'; $main_content .= '<a href="?subtopic=latestnews&action=deleteticker&id='.$time.'"><img src="'.$layout_name.'/images/news/delete.png" border="0"></a>'; $main_content .= $ticker_text.'</div> </div> </div> </div></div><hr/>'; } } else { $main_content .= 'You don\'t have admin rights. You can\'t add new ticker.'; } $main_content .= '<form action="?subtopic=latestnews" METHOD=post><div class="BigButton" style="background-image:url('.$layout_name.'/images/buttons/sbutton.gif)" ><div onMouseOver="MouseOverBigButton(this);" onMouseOut="MouseOutBigButton(this);" ><div class="BigButtonOver" style="background-image:url('.$layout_name.'/images/buttons/sbutton_over.gif);" ></div><input class="ButtonText" type="image" name="Back" alt="Back" src="'.$layout_name.'/images/buttons/_sbutton_back.gif" ></div></div></form>'; } //#################### DELETE (HIDE only!) TICKER ############################ if($action == "deleteticker") { if($group_id_of_acc_logged >= $config['site']['access_tickers']) { header("Location: "); $date = (int) $_REQUEST['id']; $SQL->query('UPDATE '.$SQL->tableName('z_news_tickers').' SET hide_ticker = 1 WHERE '.$SQL->fieldName('date').' = '.$date.';'); $main_content .= '<center>News tickets with <b>date '.date("j F Y, g:i a", $date).'</b> has been deleted.<form action="?subtopic=latestnews" METHOD=post><div class="BigButton" style="background-image:url('.$layout_name.'/images/buttons/sbutton.gif)" ><div onMouseOver="MouseOverBigButton(this);" onMouseOut="MouseOutBigButton(this);" ><div class="BigButtonOver" style="background-image:url('.$layout_name.'/images/buttons/sbutton_over.gif);" ></div><input class="ButtonText" type="image" name="Back" alt="Back" src="'.$layout_name.'/images/buttons/_sbutton_back.gif" ></div></div></form></center>'; } else { $main_content .= '<center>You don\'t have admin rights. You can\'t delete tickers.<form action="?subtopic=latestnews" METHOD=post><div class="BigButton" style="background-image:url('.$layout_name.'/images/buttons/sbutton.gif)" ><div onMouseOver="MouseOverBigButton(this);" onMouseOut="MouseOutBigButton(this);" ><div class="BigButtonOver" style="background-image:url('.$layout_name.'/images/buttons/sbutton_over.gif);" ></div><input class="ButtonText" type="image" name="Back" alt="Back" src="'.$layout_name.'/images/buttons/_sbutton_back.gif" ></div></div></form></center>'; } } if($group_id_of_acc_logged >= $config['site']['access_admin_panel']){$main_content .= '<a href="?subtopic=forum&action=new_topic&section_id=1">Add new news</a>';} $zapytanie = $SQL->query("SELECT `z_forum`.`post_topic`, `z_forum`.`author_guid`, `z_forum`.`post_date`, `z_forum`.`post_text`, `z_forum`.`id`, `z_forum`.`replies`, `players`.`name` FROM `z_forum`, `players` WHERE `section` = '1' AND `z_forum`.`id` = `first_post` AND `players`.`id` = `z_forum`.`author_guid` ORDER BY `post_date` DESC LIMIT 6;")->fetchAll(); foreach ($zapytanie as $row) { $BB = array( '/\[b\](.*?)\[\/b\]/is' => '<strong>$1</strong>', '/\
  13. mattheusnivel postou uma resposta no tópico em Suporte Tibia OTServer
    Ai http://imgur.com/SOOvzMU
  14. mattheusnivel postou uma resposta no tópico em Suporte Tibia OTServer
    Vou postar o Print.
  15. mattheusnivel postou uma resposta no tópico em Suporte Tibia OTServer
    Esse site da erro aqui em casa...
  16. mattheusnivel postou uma resposta no tópico em Suporte Tibia OTServer
    64 Bits, se me der as sources e um tutorial eu Compilo
  17. mattheusnivel postou uma resposta no tópico em Suporte Tibia OTServer
    Vim aqui pedir um Mapa global 10.53 Full com a Distro para Windows e as DLLS já inclusas. Com site e a database inclusos no Download

Informação Importante

Confirmação de Termo