Ir para conteúdo

Featured Replies

Postado

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.

Visitante
Responder

Quem Está Navegando 0

  • Nenhum usuário registrado visualizando esta página.

Estatísticas dos Fóruns

  • Tópicos 96.9k
  • Posts 519.6k

Informação Importante

Confirmação de Termo