Postado Outubro 24, 2013 11 anos Coloquei o Menu "Wars" e o Submenu "Guilds Wars" no site, porém quando eu clico em "Guilds Wars" ele aparece esse error : Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'realserver.guild_wars' doesn't exist' in C:\xampp\htdocs\wars.php:69 Stack trace: #0 C:\xampp\htdocs\wars.php(69): PDO->query('SELECT * FROM `...') #1 C:\xampp\htdocs\index.php(69): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\wars.php on line 69 estou usando esse Script: $main_content = " War System Em Breve Commandos Parametro Descricao /war invite, Guild Enemy Name Guild Name Invita a guild na guerra! Automaticamente sera 100 frags pra acaba a war. /war invite, Guild Enemy Name, 300 Guild Name, Frags Invita a guild na guerra com 300 de frag pra acaba a war /war invite, Guild Enemy Name, 300, 100000 n/d Invita a guild na guerra com 300 frags pra termina a war e com aposta de 100000 gold coins. /war accept, Guild Enemy Name Guild Name Aceita o convite de guerra. /war cancel, Guild Enemy Name Guild Name Cancelar o convite de guerra. /war reject, Guild Enemy Name Guild Name Rejeita o convite de guerra. /balance n/d Ve a quantidade de dinheiro da guild na war. /balance donate value Value Fazer uma doacao pra sua guild. (todos os membros pode doar) /balance pick value Value Withdraw a value of money from your guild balance. Membros da Guild Inimigos Outras Wars "; $count = 1; foreach($SQL->query('SELECT * FROM `guild_wars` WHERE `status` IN (1,4) OR ((`end` >= (UNIX_TIMESTAMP() - 604800) OR `end` = 0) AND `status` IN (0,5));') as $war) { $a = $ots->createObject('Guild'); $a->load($war['guild_id']); if(!$a->isLoaded()) continue; $e = $ots->createObject('Guild'); $e->load($war['enemy_id']); if(!$e->isLoaded()) continue; $alogo = $a->getCustomField('logo_gfx_name'); if(empty($alogo) || !file_exists('guilds/' . $alogo)) $alogo = 'default_logo.gif'; $elogo = $e->getCustomField('logo_gfx_name'); if(empty($elogo) || !file_exists('guilds/' . $elogo)) $elogo = 'default_logo.gif'; $count++; $main_content .= " "; } if($count == 0) $main_content .= " "; $main_content .= " Estatisticas switch($war['status']) { case 0: { $main_content .= "Pending acceptation Invited on " . date("M d Y, H:i:s", $war['begin']) . " for " . ($war['end'] > 0 ? (($war['end'] - $war['begin']) / 86400) : "unspecified") . " days. The frag limit is set to " . $war['frags'] . " frags, " . ($war['payment'] > 0 ? "with payment of " . $war['payment'] . " bronze coins." : "without any payment.")." Will expire in three days."; break; } case 3: { $main_content .= "Canceled invitation Sent invite on " . date("M d Y, H:i:s", $war['begin']) . ", canceled on " . date("M d Y, H:i:s", $war['end']) . "."; break; } case 2: { $main_content .= "Rejected invitation Invited on " . date("M d Y, H:i:s", $war['begin']) . ", rejected on " . date("M d Y, H:i:s", $war['end']) . "."; break; } case 1: { $main_content .= "" . $war['enemy_kills'] . "break; } case 4: { $main_content .= "" . $war['enemy_kills'] . "break; } case 5: { $main_content .= "Ended Began on " . date("M d Y, H:i:s", $war['begin']) . ", ended on " . date("M d Y, H:i:s", $war['end']) . ". Frag statistics: " . $war['enemy_kills'] . "."; break; } default: { $main_content .= "Unknown, please contact with gamemaster."; break; } } $main_content .= " "; if(in_array($war['status'], array(1,4,5))) { $deaths = $SQL->query('SELECT `pd`.`id`, `pd`.`date`, `gk`.`guild_id` AS `enemy`, `p`.`name`, `pd`.`level` FROM `guild_kills` gk LEFT JOIN `player_deaths` pd ON `gk`.`death_id` = `pd`.`id` LEFT JOIN `players` p ON `pd`.`player_id` = `p`.`id` WHERE `gk`.`war_id` = ' . $war['id'] . ' AND `p`.`deleted` = 0 ORDER BY `pd`.`date` DESC')->fetchAll(); if(!empty($deaths)) { foreach($deaths as $death) { $killers = $SQL->query('SELECT `p`.`name` AS `player_name`, `p`.`deleted` AS `player_exists`, `k`.`war` AS `is_war` FROM `killers` k LEFT JOIN `player_killers` pk ON `k`.`id` = `pk`.`kill_id` LEFT JOIN `players` p ON `p`.`id` = `pk`.`player_id` WHERE `k`.`death_id` = ' . $death['id'] . ' ORDER BY `k`.`final_hit` DESC, `k`.`id` ASC')->fetchAll(); $count = count($killers); $i = 0; $others = false; $main_content .= date("j M Y, H:i", $death['date']) . " ".$death['name']." "; foreach($killers as $killer) { $i++; if($killer['is_war'] != 0) { if($i == 1) $main_content .= "killed at level ".$death['level']." by "; else if($i == $count && $others == false) $main_content .= " and by "; else $main_content .= ", "; if($killer['player_exists'] == 0) $main_content .= "$main_content .= $killer['player_name']; if($killer['player_exists'] == 0) $main_content .= ""; } else $others = true; if($i == $count) { if($others == true) $main_content .= " and few others"; $main_content .= ". "; } } } } else $main_content .= " There were no frags on this war so far. "; } else $main_content .= " This war did not began yet. "; $main_content .= " ?>
Participe da conversa
Você pode postar agora e se cadastrar mais tarde. Se você tem uma conta, faça o login para postar com sua conta.