Sociopataa

sem duvida alguma

1ºcrie um ip fixo no no-ip, coloque ele no config.lua 2ºlibere as portas do seu modem elas são a 8090 e 80 3ºlibere as portas do xammp e tente entrar no site com o servidor online e o programa do no -ip aberto pelo ip q vc criou

veja se o nome do database esta certo e a senha tbm e quando vc cria a databse pede um ip esse ip éo 127.0.0.1

vc ja rodou a coluna na DB?

quando vc importar vc ja executa na aba SQL

execute isso no seu phpmyadmin ALTER TABLE z_forum ADD icon_id int(3);

gesior ou modern?

antes de tocar tenta executar isso no phmyadmin DROP TRIGGER IF EXISTS `oncreate_players`; DELIMITER // CREATE TRIGGER `oncreate_players` AFTER INSERT ON `players` FOR EACH ROW BEGIN INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 0, 10); INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 1, 10); INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 2, 10); INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 3, 10); INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 4, 10); INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 5, 10); INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 6, 10); END // DELIMITER ; DROP TRIGGER IF EXISTS `ondelete_players`; DELIMITER // CREATE TRIGGER `ondelete_players` BEFORE DELETE ON `players` FOR EACH ROW BEGIN DELETE FROM `bans` WHERE `type` = 2 AND `value` = OLD.`id`; UPDATE `houses` SET `owner` = 0 WHERE `owner` = OLD.`id`; END // DELIMITER ; CREATE TABLE IF NOT EXISTS `player_skills` ( `player_id` int(11) NOT NULL DEFAULT '0', `skillid` tinyint(2) NOT NULL DEFAULT '0', `value` int(10) unsigned NOT NULL DEFAULT '0', `count` int(10) unsigned NOT NULL DEFAULT '0', UNIQUE KEY `player_id_2` (`player_id`,`skillid`), KEY `player_id` (`player_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

para arrumar isso roda isso na sua db no phpmyadmin na aba SQL ALTER TABLE `accounts` ADD `vip_time` int(11) NOT NULL DEFAULT 0;

tente trocar o ip do dedicado

q gesior vc eta usando?qual a versão do xammp?

<!--?PHP $name = stripslashes(ucwords(strtolower(trim($_REQUEST['name'])))); if(empty($name)) { $main_content .= 'Here you can get detailed information about a certain player on '.$config['server']['serverName'].'.<BR--> <form action="?subtopic=characters" method="post"><table border="0" cellpadding="4" cellspacing="1" width="100%"><tbody><tr><td class="white" bgcolor="'.$config['site']['vdarkborder'].'"><b>Search Character</b></td></tr><tr><td bgcolor="'.$config['site']['darkborder'].'"><table border="0" cellpadding="1"><tbody><tr><td>Name:</td><td><input name="name" value="" size="29" maxlength="29"></td><td><input name="Submit" src="%27.$layout_name.%27/images/buttons/sbutton_submit.gif" height="18" border="0" type="image" width="120"></td></tr></tbody></table></td></tr></tbody></table></form>'; } else { if(check_name($name)) { $player = $ots->createObject('Player'); $player->find($name); if($player->isLoaded()) { $account = $player->getAccount(); $main_content .= '<table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td><img src="%27.$layout_name.%27/images/general/blank.gif" height="1" border="0" width="10"></td><td>'; if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++; $main_content .= ''; if($player->getOldName()) { if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++; if($player->isNameLocked()) $main_content .= ''; else $main_content .= ''; } // BEGIN Position Showing *** Fixed by jerryb1988 from otfans.net $group = $player->getGroup(); if ($group == 2){$group_name = 'Tutor';} if ($group == 3){$group_name = 'Senior Tutor';} if ($group == 4){$group_name = 'Gamemaster';} if ($group == 5){$group_name = 'Community Manager';} if ($group == 6){$group_name = 'GOD';} if($group != 1) { if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++; $main_content .= ''; } // END Position Showing if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++; $main_content .= ''; if($config['site']['show_marriage_info']) { if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++; $main_content .= ''; else $main_content .= 'single'; } if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++; $main_content .= ''; if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++; $main_content .= ''; if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++; $main_content .= ''; if(!empty($towns_list[$player->getWorld()][$player->getTownId()])) { if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++; $main_content .= ''; if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++; $main_content .= ''; } $rank_of_player = $player->getRank(); if(!empty($rank_of_player)) { { $guild_id = $rank_of_player->getGuild()->getId(); $guild_name = $rank_of_player->getGuild()->getName(); if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++; $main_content .= ''; } } if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++; $lastlogin = $player->getLastLogin(); if(empty($lastlogin)) $main_content .= ''; else $main_content .= ''; if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++; if($config['site']['show_creationdate'] && $player->getCreated()) { $main_content .= ''; } if($config['site']['show_vip_status']) { $id = $player->getCustomField("id"); if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++; $main_content .= ''; $vip = $SQL->query('SELECT * FROM player_storage WHERE player_id = '.$id.' AND `key` = '.$config['site']['show_vip_storage'].';')->fetch(); if($vip == false) { $main_content .= ''; } else { $main_content .= ''; } $comment = parseubb($player->getComment()); $newlines = array("\r\n", "\n", "\r"); $comment_with_lines = str_replace($newlines, '<br>', $comment, $count); if($count < 50) $comment = $comment_with_lines; if(!empty($comment)) { if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++; $main_content .= ''; } } //Outfit shower by Pening edited by loleslav //Show or hide by Zakius if($config['site']['show_outfit'] and $player->getCustomField( 'show_outfit' ) == 1) { $id = $player->getCustomField("id"); $main_content .= ''; } } } $main_content .= ''; //end Outfit shower by Pening edited by loleslav if($config['site']['show_signature']) { // Signature by makr0mango. function randomSignature( $folder ) { $files = scandir ( "./$folder/" ); $signature = array(); foreach ( $files as $file ): if ( substr ( strtolower ( $file ) , -4 ) == ".png" ) $signature[] = $file; endforeach; return rand(0,count($signature)-1); } $random = randomSignature("signatures"); $main_content .= '<br><table border="0" cellpadding="4" cellspacing="1" width="100%"><tbody><tr site']['vdarkborder'].'="" bgcolor=".$config["><td colspan="2" class="white"><b>Character Information</b></td></tr><tr bgcolor="'.$bgcolor.'"><td width="20%">Name:</td><td><font color="'; $main_content .= ($player->isOnline()) ? 'green' : 'red'; $main_content .= '"><b>'.$player->getName().'</b></font>'; if($player->isDeleted()) $main_content .= '<font color="red"> [DELETED]</font>'; if($player->isNameLocked()) $main_content .= '<font color="red"> [NAMELOCK]</font>'; $main_content .= '</td></tr><tr bgcolor="'.$bgcolor.'"><td>Proposition:</td><td>'.$player->getOldName().'</td></tr><tr bgcolor="'.$bgcolor.'"><td>Old name:</td><td>'.$player->getOldName().'</td></tr><tr bgcolor="'.$bgcolor.'"><td>Position:</td><td>'.$group_name.'</td></tr><tr bgcolor="'.$bgcolor.'"><td>Sex:</td><td>'; $main_content .= ($player->getSex() == 0) ? 'female' : 'male'; $main_content .= '</td></tr><tr bgcolor="'.$bgcolor.'"><td>Marital status:</td><td>'; $marriage = new OTS_Player(); $marriage->load($player->getMarriage()); if($marriage->isLoaded()) $main_content .= 'married to <a href="?subtopic=characters&name=%27.urlencode%28$marriage-%3EgetName%28%29%29.%27"><b>'.$marriage->getName().'</b></a></td></tr><tr bgcolor="'.$bgcolor.'"><td>Profession:</td><td>'.$vocation_name[$player->getWorld()][$player->getPromotion()][$player->getVocation()].'</td></tr><tr bgcolor="'.$bgcolor.'"><td>Level:</td><td>'.$player->getLevel().'</td></tr><tr bgcolor="'.$bgcolor.'"><td>World:</td><td>'.$config['site']['worlds'][$player->getWorld()].'</td></tr><tr bgcolor="'.$bgcolor.'"><td>Residence:</td><td>'.$towns_list[$player->getWorld()][$player->getTownId()].'</td></tr><tr bgcolor="'.$bgcolor.'"><td>Balance:</td><td>'.$player->getBalance().' Gold Coins.</td></tr><tr bgcolor="'.$bgcolor.'"><td>Guild Membership:</td><td>'.$rank_of_player->getName().' of the <a href="?subtopic=guilds&action=show&guild=%27.$guild_id.%27">'.$guild_name.'</a></td></tr><tr bgcolor="'.$bgcolor.'"><td>Last login:</td><td>Never logged in.</td></tr><tr bgcolor="'.$bgcolor.'"><td>Last login:</td><td>'.date("j F Y, g:i a", $lastlogin).'</td></tr><tr bgcolor="'.$bgcolor.'"><td>Created:</td><td>'.date("j F Y, g:i a", $player->getCreated()).'</td></tr><tr bgcolor="'.$bgcolor.'"><td width="10%">Vip Status:</td><td><span class="red"><b>NOT VIP</b></span></td></tr><tr><td><span class="green"><b>VIP</b></span></td></tr><tr bgcolor="'.$bgcolor.'"><td valign="top">Comment:</td><td>'.$comment.'</td></tr><tr><td bgcolor="'.$config['site']['darkborder'].'">Outfit:'; $listaddon = array('128','129','130','131','132','133','134','135','136','137','138','139','140','141','142','143','144','145','146','147','148','149','150','151','152','153','154','155','158','159','251','252','268','269','270','273','278','279','288','289','302','324','325'); $lookadd = array('0','1','2','3'); foreach ($listaddon as $pid => $name) foreach ($lookadd as $addo => $name) { $addon1 = $SQL->query('SELECT * FROM players WHERE id = '.$id.' AND looktype = '.$listaddon[$pid].' AND lookaddons = '.$lookadd[$addo].';')->fetch(); if($addon1[looktype] == true ) { $finaddon = $addon1[looktype] + $addon1[lookaddons] * 300; $main_content .= '</td><td with="50%" style="background-color: '.$config['site']['darkborder'].'"><center><img src="images/addons/%27.$finaddon.%27.gif"></center></td></tr><tr></tr><tr></tr><tr></tr></tbody></table>'; $main_content .= ""; $main_content .= ""; $main_content .= ""; $main_content .= '<table border="0" cellpadding="4" cellspacing="1" width="100%"><tbody><tr site']['vdarkborder'].'="" bgcolor=".$config["><td colspan=2" class="white"><b>Signature</b></td></tr><tr bgcolor=".$config['site]['darkborder']."><td width="20%">Forum Link:</td><td><input size="75" onclick="this.select();" value="[url=\"http://" . $_SERVER[" http_host']="" .="" "\"]http:="" "="" $_server['http_host']="" signature.php?character=" .$player->getName(). " &image=" . $random . " [="" img][="" url]'="" type="text"></td></tr><tr bgcolor=".$config['site']['lightborder']."><td width="20%">Direct Link:</td><td><input size="75" onclick="this.select();" value="http://" . $_SERVER[" http_host']="" .="" "="" signature.php?character=" .$player->getName(). " &image=" . $random . " '="" type="text"></td></tr><tr bgcolor=".$config['site']['darkborder']."><td colspan="2" style="text-align: center;"><img src="signature.php?character=%22%20.$player-%3EgetName%28%29.%20%22&image=%22%20.%20$random%20.%20%22"></td></tr></tbody></table>'; // Signature by makr0mango. } //modified status scripts by ballack13 $main_content .= ''; //equipment shower by ballack13 if ($player->getCustomField( 'show_eq' ) == 1) { $id = $player->getCustomField("id"); $number_of_items = 1; $main_content .= '';} if ($player->getCustomField( 'show_bars' ) == 1) { //Hp/Mana/Exp Status by ballack13 $hp = ($player->getHealth() / $player->getHealthMax() * 100); $main_content .= '<table width="100%"><tbody><tr><td align="center">'; $list = array('2','1','3','6','4','5','9','7','10','8'); foreach ($list as $pid => $name) { $top = $SQL->query('SELECT * FROM player_items WHERE player_id = '.$id.' AND pid = '.$list[$pid].';')->fetch(); if($top[itemtype] == false) { if($list[$pid] == '8') { $main_content .= ''; } if(is_int($number_of_items / 3)){ $main_content .= ''; } else { $main_content .= ''; } $number_of_items++; } else { if($list[$pid] == '8') { $main_content .= ''; } if(is_int($number_of_items / 3)) $main_content .= ''; else $main_content .= ''; $number_of_items++; } if($list[$pid] == '8') { $main_content .= ''; } } $main_content .= '<table with="100%" style="border: solid 1px #888888;" cellspacing="1"><tbody><tr><td style="background-color: '.$config['site']['darkborder'].'; text-align: center;">Soul:<br>'.$player->getSoul().'</td><td style="background-color: '.$config['site']['darkborder'].'; text-align: center;"><img src="images/items/%27.$list[$pid].%27.gif"></td></tr><tr><td style="background-color: '.$config['site']['darkborder'].'; text-align: center;"><img src="images/items/%27.$list[$pid].%27.gif"></td><td style="background-color: '.$config['site']['darkborder'].'; text-align: center;">Soul:<br>'.$player->getSoul().'</td><td style="background-color: '.$config['site']['darkborder'].'; text-align: center;"><img src="images/items/%27.$top[itemtype].%27.gif" width="45"></td></tr><tr><td style="background-color: '.$config['site']['darkborder'].'; text-align: center;"><img src="images/items/%27.$top[itemtype].%27.gif" width="45"></td><td style="background-color: '.$config['site']['darkborder'].'; text-align: center;">Cap:<br>'.$player->getCap().'</td></tr></tbody></table></td><td align="center">'; $next = ($player->getLevel() + 1); $exp = ((50 / 3) * ($player->getLevel() * $player->getLevel() * $player->getLevel()) - (100 * ($player->getLevel() * $player->getLevel())) + ((850/3) * $player->getLevel()) - 200); $expnext = ((50 / 3) * ($next * $next * $next) - (100 * ($next * $next)) + ((850/3) * $next) - 200 - $player->getExperience()); $expresult = ($expnext / (($expnext + $player->getExperience()) - $exp) * 100); $main_content .= '<table width="100%"><tbody><tr><td align="center">'; if ($player->getManaMax() > 0) { $mana = ($player->getMana() / $player->getManaMax() * 100); $main_content .= ''; } else { $main_content .= ''; } $main_content .= '<table cellpadding="4" cellspacing="1"><tbody><tr><td align="left" bgcolor="#D4C0A1" width="20%"><b>Player Health:</b></td> <td align="left" bgcolor="#D4C0A1">'.$player->getHealth().'/'.$player->getHealthMax().'<div style="width: 100%; height: 3px; border: 1px solid #000;"><div style="background: red; width: '.$hp.'%; height: 3px;"></div></div></td></tr><tr><td align="left" bgcolor="#F1E0C6"><b>Player Mana:</b></td><td align="left" bgcolor="#F1E0C6">'.$player->getMana().'/'.$player->getManaMax().'<div style="width: 100%; height: 3px; border: 1px solid #000;"><div style="background: blue; width: '.$mana.'%; height: 3px;"></div></div></td></tr><tr><td align="left" bgcolor="#F1E0C6"><b>Player Mana:</b></td><td align="left" bgcolor="#F1E0C6">0/0<div style="width: 100%; height: 3px; border: 1px solid #000;"><div style="background: blue; width: 100%; height: 3px;"></div></div></td></tr></tbody></table></td></tr><tr></tr><tr></tr></tbody></table><table cellpadding="4" cellspacing="1"><tbody><tr><td align="left" bgcolor="'.$config['site']['lightborder'].'" width="20%"><b>Player Level:</b></td><td align="left" bgcolor="'.$config['site']['lightborder'].'">'.$player->getLevel().'</td></tr> <tr><td align="left" bgcolor="'.$config['site']['darkborder'].'"><b>Player Experience:</b></td><td align="left" bgcolor="'.$config['site']['darkborder'].'">'.$player->getExperience().' EXP.</td></tr> <tr><td align="left" bgcolor="'.$config['site']['lightborder'].'"><b>To Next Level:</b></td><td align="left" bgcolor="'.$config['site']['lightborder'].'">You need <b>'.$exp.' EXP</b> to Level <b>'.$next.'</b>.<div title="99.320604545 %" style="width: 100%; height: 3px; border: 1px solid #000;"><div style="background: red; width: '.$expresult.'%; height: 3px;"></div></div></td></tr></tbody></table></td></tr></tbody></table></td></tr></tbody></table>'; } if($config['site']['show_skills_info'] and $player->getCustomField( 'show_skills' ) == 1) { //Skills Pics v2. Table borders optimized by Absolute Mango $main_content .= '<br><table align="center" border="0" cellpadding="0" cellspacing="0" width="200"><caption><strong>Skills</strong></caption><tbody><tr> <td align="center"><a href="?subtopic=highscores&list=experience"><img src="images/skills/level.png" style="border: none;"></a></td> <td align="center"><a href="?subtopic=highscores&list=magic"><img src="images/skills/ml.png" style="border: none;"></a></td> <td align="center"><a href="?subtopic=highscores&list=fist"><img src="images/skills/fist.png" style="border: none;"></a></td> <td align="center"><a href="?subtopic=highscores&list=club"><img src="images/skills/club.png" style="border: none;"></a></td> <td align="center"><a href="?subtopic=highscores&list=sword"><img src="images/skills/sword.png" style="border: none;"></a></td> <td align="center"><a href="?subtopic=highscores&list=axe"><img src="images/skills/axe.png" style="border: none;"></a></td> <td align="center"><a href="?subtopic=highscores&list=distance"><img src="images/skills/dist.png" style="border: none;"></a></td> <td align="center"><a href="?subtopic=highscores&list=shield"><img src="images/skills/def.png" style="border: none;"></a></td> <td align="center"><a href="?subtopic=highscores&list=fishing"><img src="images/skills/fish.png" style="border: none;"></a></td> </tr></tbody></table> <table align="center" border="1" cellpadding="0" cellspacing="0" width="360"><tbody><tr></tr><tr bgcolor="'.$config['site']['darkborder'].'"> <td align="center" width="38"><strong>Level</strong></td> <td align="center" width="38"><strong>ML</strong></td> <td align="center" width="42"><strong>Fist</strong></td> <td align="center" width="40"><strong>Club</strong></td> <td align="center" width="38"><strong>Swrd</strong></td> <td align="center" width="38"><strong>Axe</strong></td> <td align="center" width="38"><strong>Dist</strong></td> <td align="center" width="38"><strong>Shield</strong></td> <td align="center" width="38"><strong>Fish</strong></td> </tr> <tr bgcolor="'.$config['site']['lightborder'].'"> <td align="center" width="38">'.$player->getLevel().'</td> <td align="center" width="38">'.$player->getMagLevel().'</td> <td align="center" width="38">'.$player->getSkill(0).'</td> <td align="center" width="38">'.$player->getSkill(1).'</td> <td align="center" width="38">'.$player->getSkill(2).'</td> <td align="center" width="38">'.$player->getSkill(3).'</td> <td align="center" width="38">'.$player->getSkill(4).'</td> <td align="center" width="38">'.$player->getSkill(5).'</td> <td align="center" width="38">'.$player->getSkill(6).'</td> </tr></tbody></table><div table="" align="center">&nbsp;<br>&nbsp;</div>'; //skill script end } //quest status by ballack13 if ($player->getCustomField( 'show_quests' ) == 1) { $id = $player->getCustomField("id"); $number_of_quests = 0; $main_content .= ''; $quests = $config['site']['quests']; foreach ($quests as $storage => $name) { if(is_int($number_of_quests / 2)) $bgcolor = $config['site']['darkborder']; else $bgcolor = $config['site']['lightborder']; $number_of_quests++; $main_content .= ''; $quest = $SQL->query('SELECT * FROM player_storage WHERE player_id = '.$id.' AND `key` = '.$quests[$storage].';')->fetch(); if($quest == false) { $main_content .= ''; } else { $main_content .= ''; } } $main_content .= '<table border="0" cellpadding="4" cellspacing="1" width="100%"><tbody><tr site']['vdarkborder'].'="" bgcolor=".$config["><td colspan=2" class="white" align="left"><b>Quests</b></td></tr><tr bgcolor="'.$bgcolor.'"><td width="95%">'.$storage.'</td><td><img src="images/false.png"></td></tr><tr><td><img src="images/true.png"></td></tr></tbody></table><br>';} $deads = 0; //deaths list $player_deaths = $SQL->query('SELECT `id`, `date`, `level` FROM `player_deaths` WHERE `player_id` = '.$player->getId().' ORDER BY `date` DESC LIMIT 0,10;'); foreach($player_deaths as $death) { if(is_int($number_of_rows / 2)) $bgcolor = $config['site]['darkborder']; else $bgcolor = $config['site']['lightborder']; $number_of_rows++; $deads++; $dead_add_content .= " ".date("j M Y, H:i", $death['date'])." "; $killers = $SQL->query("SELECT environment_killers.name AS monster_name, players.name AS player_name, players.deleted AS player_exists FROM killers LEFT JOIN environment_killers ON killers.id = environment_killers.kill_id LEFT JOIN player_killers ON killers.id = player_killers.kill_id LEFT JOIN players ON players.id = player_killers.player_id WHERE killers.death_id = ".$SQL->quote($death['id'])." ORDER BY killers.final_hit DESC, killers.id ASC")->fetchAll(); $i = 0; $count = count($killers); foreach($killers as $killer) { $i++; if(in_array($i, array(1, $count))) $killer['monster_name'] = str_replace(array("an ", "a "), array("", ""), $killer['monster_name']); if($killer['player_name'] != "") { if($i == 1) $dead_add_content .= "Killed at level <b>".$death['level']."</b> by "; else if($i == $count) $dead_add_content .= " and by "; else $dead_add_content .= ", "; if($killer['monster_name'] != "") $dead_add_content .= $killer['monster_name']." summoned by "; if($killer['player_exists'] == 0) $dead_add_content .= "<a href="%5C%22index.php?subtopic=characters&name=%22.urlencode%28$killer[%27player_name%27]%29.%22%5C%22">"; $dead_add_content .= $killer['player_name']; if($killer['player_exists'] == 0) $dead_add_content .= "</a>"; } else { if($i == 1) $dead_add_content .= "Died at level <b>".$death['level']."</b> by "; else if($i == $count) $dead_add_content .= " and by "; else $dead_add_content .= ", "; $dead_add_content .= $killer['monster_name']; } if($i == $count) $dead_add_content .= "."; } $dead_add_content .= "."; } if($deads > 0) $main_content .= '' . $dead_add_content . '<table border="0" cellpadding="4" cellspacing="1" width="100%"><tbody><tr site']['vdarkborder'].'="" bgcolor=".$config["><td colspan=2" class="white"><b>Deaths</b></td></tr></tbody></table><br>'; //end if(!$player->getHideChar()) { $main_content .= '<table border="0"><tbody><tr><td></td></tr></tbody></table>'; if($account->getRLName()) { if(is_int($number_of_rows / 2)) { $bgcolor = $config['site]['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++; $main_content .= ''; } if($account->getLocation()) { if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++; $main_content .= ''; } if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++; if($account->getLastLogin()) $main_content .= ''; else $main_content .= ''; if($account->getCreated()) { if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++; $main_content .= ''; } if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++; $main_content .= '<table border="0" cellpadding="4" cellspacing="1" width="100%"><tbody><tr site']['vdarkborder'].'="" bgcolor=".$config["><td colspan=2" class="white"><b>Account Information</b></td></tr><tr site]['lightborder'].'="" bgcolor=".$config["><td width=20%">Real name:</td><td>'.$account->getRLName().'</td></tr><tr site]['darkborder'].'="" bgcolor=".$config["><td width=20%">Location:</td><td>'.$account->getLocation().'</td></tr><tr site]['lightborder'].'="" bgcolor=".$config["><td width=20%">Last login:</td><td>'.date("j F Y, g:i a", $account->getLastLogin()).'</td></tr><tr site]['lightborder'].'="" bgcolor=".$config["><td width=20%">Last login:</td><td>Never logged in.</td></tr><tr site]['lightborder'].'="" bgcolor=".$config["><td width=20%">Created:</td><td>'.date("j F Y, g:i a", $account->getCreated()).'</td></tr><tr bgcolor="'.$bgcolor.'"><td>Account Status:</td><td>'; $main_content .= ($account->isPremium()) ? '<b><font color="green">Premium Account</font></b>' : '<b><font color="red">Free Account</font></b>'; if($account->isBanned()) if($account->getBanTime() > 0) $main_content .= '<font color="red"> [banished until '.date("j F Y, G:i", $account->getBanTime()).]</font>'; else $main_content .= '<font color="red"> [banished FOREVER]</font>'; $main_content .= '</td></tr></tbody></table>'; $main_content .= '<br><table border="0"><tbody><tr><td></td></tr></tbody></table>'; $account_players = $account->getPlayersList(); $account_players->orderBy('name'); $player_number = 0; foreach($account_players as $player_list) { if(!$player_list->getHideChar()) { $player_number++; if(is_int($player_number / 2)) $bgcolor = $config['site']['darkborder']; else $bgcolor = $config['site']['lightborder']; if(!$player_list->isOnline()) $player_list_status = '<font color="red">Offline</font>'; else $player_list_status = '<font color="green">Online</font>'; $main_content .= ''; } } $main_content .= '<table border="0" cellpadding="4" cellspacing="1" width="100%"><tbody><tr site']['vdarkborder'].'="" bgcolor=".$config["><td colspan=5" class="white"><b>Characters</b></td></tr> <tr site]['darkborder'].'="" bgcolor=".$config["><td><b>Name</b></td><td><b>World</b></td><td><b>Level</b></td><td><b>Status</b></td><td><b> </b></td></tr><tr bgcolor="'.$bgcolor.'"><td width="52%"><nobr>'.$player_number.'. '.$player_list->getName(); $main_content .= ($player_list->isDeleted()) ? '<font color="red"> [DELETED]</font>' : ''; $main_content .= '</nobr></td><td width="15%">'.$config['site']['worlds'][$player_list->getWorld()].'</td><td width="25%">'.$player_list->getLevel().' '.$vocation_name[$player_list->getWorld()][$player_list->getPromotion()][$player_list->getVocation()].'</td><td width="8%"><b>'.$player_list_status.'</b></td><td><table border="0" cellpadding="0" cellspacing="0"><form action="?subtopic=characters" method="post"></form><tbody><tr><td><input name="name" value="'.$player_list->getName().'" type="hidden"><input name="View '.$player_list->getName().'" alt="View '.$player_list->getName().'" src="%27.$layout_name.%27/images/buttons/sbutton_view.gif" height="18" border="0" type="image" width="120"></td></tr></tbody></table></td></tr></tbody></table><img src="%27.$layout_name.%27/images/general/blank.gif" height="1" border="0" width="10">'; } $main_content .= '<br><br><form action="?subtopic=characters" method="post"><table border="0" cellpadding="4" cellspacing="1" width="100%"><tbody><tr><td class="white" bgcolor="'.$config['site']['vdarkborder'].'"><b>Search Character</b></td></tr><tr><td bgcolor="'.$config['site']['darkborder'].'"><table border="0" cellpadding="1"><tbody><tr><td>Name:</td><td><input name="name" value="" size="29" maxlength="29"></td><td><input name="Submit" src="%27.$layout_name.%27/images/buttons/sbutton_submit.gif" height="18" border="0" type="image" width="120"></td></tr></tbody></table></td></tr></tbody></table></form>'; $main_content .= ''; } else $search_errors[] = 'Character <b>'.$name.'</b> does not exist.'; } else $search_errors[] = 'This name contains invalid letters. Please use only A-Z, a-z and space.'; if(!empty($search_errors)) { $main_content .= '<div class="SmallBox"> <div class="MessageContainer"> <div class="BoxFrameHorizontal" style="background-image:url('.$layout_name.'/images/content/box-frame-horizontal.gif);"></div> <div class="BoxFrameEdgeLeftTop" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);"></div> <div class="BoxFrameEdgeRightTop" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);"></div> <div class="ErrorMessage"> <div class="BoxFrameVerticalLeft" style="background-image:url('.$layout_name.'/images/content/box-frame-vertical.gif);"></div> <div class="BoxFrameVerticalRight" style="background-image:url('.$layout_name.'/images/content/box-frame-vertical.gif);"></div> <div class="AttentionSign" style="background-image:url('.$layout_name.'/images/content/attentionsign.gif);"></div><b>The Following Errors Have Occurred:</b><br>'; foreach($search_errors as $search_error) $main_content .= '<li>'.$search_error; $main_content .= '</li></div> <div class="BoxFrameHorizontal" style="background-image:url('.$layout_name.'/images/content/box-frame-horizontal.gif);"></div> <div class="BoxFrameEdgeRightBottom" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);"></div> <div class="BoxFrameEdgeLeftBottom" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);"></div> </div></div><br>'; $main_content .= '<br><form action="?subtopic=characters" method="post"><table border="0" cellpadding="4" cellspacing="1" width="100%"><tbody><tr><td class="white" bgcolor="'.$config['site']['vdarkborder'].'"><b>Search Character</b></td></tr><tr><td bgcolor="'.$config['site']['darkborder'].'"><table border="0" cellpadding="1"><tbody><tr><td>Name:</td><td><input name="name" value="" size="29" maxlength="29"></td><td><input name="Submit" src="%27.$layout_name.%27/images/buttons/sbutton_submit.gif" height="18" border="0" type="image" width="120"></td></tr></tbody></table></td></tr></tbody></table></form>'; } } ?>

ja testou o gesior eo xammp q recomendei? adicionado!!!

importe o mysql.sql qual a versão do seu xammp?1.6.5?se for troque para a 1.7.3 caso os erros continuem me add no msn e faço o site para vc ou ensino passo a passo

poste o characters.php

fera fale o erro neh aff

server off e ja foi comprovado q entro masi de 6 players?

ss do erro é bom '-'

xampp\htdocs\layouts\tibiacom\layout.php procure: if($config['status']['serverStatus_online'] == 1) mude if($config['status']['serverStatus_online'] >= 0) Agora, adicione ainda no layout.php, antes da tag <head> o seguinte script: <?PHP $update_interval = 10; if(count($config['site']['worlds']) > 1) { $worlds .= '<i>Select world:</i> '; foreach($config['site']['worlds'] as $id => $world_n) { $worlds .= ' <a href="?subtopic=whoisonline&world='.$id.'">'.$world_n.'</a> , '; if($id == (int) $_GET['world']) { $world_id = $id; $world_name = $world_n; } } $main_content .= substr($worlds, 0, strlen($worlds)-3); } if(!isset($world_id)) { $world_id = 0; $world_name = $config['server']['serverName']; } $order = $_REQUEST['order']; if($order == 'level') $orderby = 'level'; elseif($order == 'vocation') $orderby = 'vocation'; if(empty($orderby)) $orderby = 'name'; $tmp_file_name = 'cache/whoisonline-'.$orderby.'-'.$world_id.'.tmp'; if(file_exists($tmp_file_name) && filemtime($tmp_file_name) > (time() - $update_interval)) { $tmp_file_content = explode(",", file_get_contents($tmp_file_name)); $number_of_players_online = $tmp_file_content[0]; $players_rows = $tmp_file_content[1]; } else { $players_online_data = $SQL->query('SELECT * FROM players WHERE world_id = '.(int) $world_id.' AND online > 0 ORDER BY '.$orderby); $number_of_players_online = 0; foreach($players_online_data as $player) { $number_of_players_online++; $acc = $SQL->query('SELECT * FROM '.$SQL->tableName('accounts').' WHERE '.$SQL->fieldName('id').' = '.$player['account_id'].'')->fetch(); if(is_int($number_of_players_online / 2)) $bgcolor = $config['site']['darkborder']; else $bgcolor = $config['site']['lightborder']; $rs = ""; if ($player['skulltime'] > 0 && $player['skull'] == 3) $rs = "<img style='border: 0;' src='./images/whiteskull.gif'/>"; elseif ($player['skulltime'] = $player['skull'] == 4) $rs = "<img style='border: 0;' src='./images/redskull.gif'/>"; elseif ($player['skulltime'] = $player['skull'] == 5) $rs = "<img style='border: 0;' src='./images/blackskull.gif'/>"; $players_rows .= '<TR BGCOLOR='.$bgcolor.'><TD WIDTH=10%><image src="images/flags/'.$acc['flag'].'.png"/></TD><TD WIDTH=70%><A HREF="?subtopic=characters&name='.urlencode($player['name']).'">'.$player['name'].$rs.'</A></TD><TD WIDTH=10%>'.$player['level'].'</TD><TD WIDTH=20%>'.$vocation_name[$world_id][$player['promotion']][$player['vocation']].'</TD></TR>'; } }

execute no phpmyadmin ALTER TABLE z_forum ADD icon_id int(3);

[GESIOR ACC] Elemental Template

http://www.xtibia.com/forum/topic/143830-gesior-acc-configurando-lost-account/

vai em config.php e procura por $config['site']['access_tickers'] = 3; mude para 6 seria isso trojan?

temandei uma pm com o meu video q fiz sobre proteção de site

nao é o accountmangnamente e sim o confi.php o certo de ele postar