giving the error : Fatal error: Call to a member function query() on a non-object in C:\xampp\htdocs\citywar.php on line 2
line 2 : $consulta = $SQL->query('SELECT * FROM `city_war` ORDER BY `id`');
citywar.php
line 2 : $consulta = $SQL->query('SELECT * FROM `city_war` ORDER BY `id`');
citywar.php
PHP:
<?php
$consulta = $SQL->query('SELECT * FROM `city_war` ORDER BY `id`');
$number_of_rows = 0;
$main_content .= '
<center><h1>City War (Anti-Entrosa)</h1></center>
</br>
<center>
O sistema permite que duas guild duelem sem intromissao de outros jogadores, as guilds terao uma cidade completa e ainda podem optar entre 3 modos de guerra alem de outras configuracoes, confira.
</br></br>
<iframe width="560" height="315" src="https://www.youtube.com/embed/KtFkjBhvUWw" frameborder="0" allowfullscreen></iframe>
</br>
</center>
</br>
<div class="TableContainer">
<div class="CaptionContainer">
<div class="CaptionInnerContainer">
<span class="CaptionEdgeLeftTop" style="background-image:url(./layouts/tibiarl/images/content/box-frame-edge.gif)"></span>
<span class="CaptionEdgeRightTop" style="background-image:url(./layouts/tibiarl/images/content/box-frame-edge.gif)"></span>
<span class="CaptionBorderTop" style="background-image:url(./layouts/tibiarl/images/content/table-headline-border.gif)"></span>
<span class="CaptionVerticalLeft" style="background-image:url(./layouts/tibiarl/images/content/box-frame-vertical.gif)"></span>
<div class="Text">Comandos Disponiveis</div>
<span class="CaptionVerticalRight" style="background-image:url(./layouts/tibiarl/images/content/box-frame-vertical.gif)"></span>
<span class="CaptionBorderBottom" style="background-image:url(./layouts/tibiarl/images/content/table-headline-border.gif)"></span>
<span class="CaptionEdgeLeftBottom" style="background-image:url(./layouts/tibiarl/images/content/box-frame-edge.gif)"></span>
<span class="CaptionEdgeRightBottom" style="background-image:url(./layouts/tibiarl/images/content/box-frame-edge.gif)"></span>
</div>
</div>
<table class="Table1" cellpadding="0" cellspacing="0">
<tbody><tr>
<td>
<div class="InnerTableContainer">
<table width="100%">
<tbody>
<tr style="background-color:#af2126; height:22px;">
<td class="LabelV150"><b><font color="white">-> /citywar invite, guild, cidade, players, modo, tempo </font></b></td>
</tr>
<tr style="background-color:'.$config['site']['lightborder'].';">
<td>
Invite uma guild para um duelo no sistema, com diversas opcoes de parametro disponiveis na tabela.</br></br>
<table>
<tr style="background-color:'.$config['site']['vdarkborder'].';">
<td>
<font color="white"><b>Parametros</b></white>
</td>
</tr>
<tr style="background-color:'.$config['site']['darkborder'].';">
<td>
<b>Guild</b> = nome da guild adversaria.</br>
</td>
</tr>
<tr style="background-color:'.$config['site']['darkborder'].';">
<td>
<b>Cidade</b> = edron ou venore.</br>
</td>
</tr>
<tr style="background-color:'.$config['site']['darkborder'].';">
<td>
<b>Players</b> = 0, 10, 15, 20 ou 30 jogadores permitidos, 0 = infinito.</br>
</td>
</tr>
<tr style="background-color:'.$config['site']['darkborder'].';">
<td>
<b>Modo</b> = 1, 2 ou 3 -- 1 = tradicional, 2 = sem ue, 3 = sem sd.</br
</td>
</tr>
<tr style="background-color:'.$config['site']['darkborder'].';">
<td>
<b>Tempo</b> = 15, 30 ou 60 em minutos.
</td>
</tr>
</table></br>
*Custo do sistema: Baseado no tempo o sistema cobra uma taxa direto do banco do jogador, 15 min = 75k | 30 min = 100k | 60 min = 150k.
</td>
</tr>
<tr style="background-color:#af2126; height:22px;">
<td class="LabelV150"><b><font color="white">-> /citywar accept, nomeguild </font></b></td>
</tr>
<tr style="background-color:'.$config['site']['lightborder'].';">
<td>
Aceita um duelo entre uma guild, cobra uma taxa no banco pelo duelo baseado no tempo.
</td>
</tr>
<tr style="background-color:#af2126; height:22px;">
<td class="LabelV150"><b><font color="white">-> /citywar go </font></b></td>
</tr>
<tr style="background-color:'.$config['site']['lightborder'].';">
<td>
Leva um jogador que esta participando da City War para a cidade respectiva, e necessario estar em uma area PZ.
</td>
</tr>
<tr style="background-color:#af2126; height:22px;">
<td class="LabelV150"><b><font color="white">-> /citywar exit </font></b></td>
</tr>
<tr style="background-color:'.$config['site']['lightborder'].';">
<td>
Retira um jogador do duelo, e necessario estar em uma area PZ.
</td>
</tr>
</tbody></table>
</div>
</td>
</tr>
</tbody></table>
</div>
</br>
</br>
<div class="TableContainer">
<div class="CaptionContainer">
<div class="CaptionInnerContainer">
<span class="CaptionEdgeLeftTop" style="background-image:url(./layouts/tibiarl/images/content/box-frame-edge.gif)"></span>
<span class="CaptionEdgeRightTop" style="background-image:url(./layouts/tibiarl/images/content/box-frame-edge.gif)"></span>
<span class="CaptionBorderTop" style="background-image:url(./layouts/tibiarl/images/content/table-headline-border.gif)"></span>
<span class="CaptionVerticalLeft" style="background-image:url(./layouts/tibiarl/images/content/box-frame-vertical.gif)"></span>
<div class="Text">Ultimos Duelos</div>
<span class="CaptionVerticalRight" style="background-image:url(./layouts/tibiarl/images/content/box-frame-vertical.gif)"></span>
<span class="CaptionBorderBottom" style="background-image:url(./layouts/tibiarl/images/content/table-headline-border.gif)"></span>
<span class="CaptionEdgeLeftBottom" style="background-image:url(./layouts/tibiarl/images/content/box-frame-edge.gif)"></span>
<span class="CaptionEdgeRightBottom" style="background-image:url(./layouts/tibiarl/images/content/box-frame-edge.gif)"></span>
</div>
</div><table class="Table1" cellpadding="0" cellspacing="0">
<tbody><tr>
<td>
<div class="InnerTableContainer">
<table width="100%">
<tbody>
<tr style="background-color:#af2126;">
<td class="LabelV150"><b><font color="white"> <center>Guild Team</font></b></center></td>
<td class="LabelV150"><b><font color="white"><center>Detalhes</center></font></b></td>
<td class="LabelV150"><b><font color="white"><center>Guild Team</center></font></b></td>
</tr>
';
foreach($consulta as $info) {
if ($info['frags_guild1'] > $info['frags_guild2']){
$colort1 = "green";
$colort2 = "red";
}
else{
$colort1 = "red";
$colort2 = "green";
}
if ($info['modo'] == 1) {
$modo = 'tradicional';
}
if ($info['modo'] == 2) {
$modo = 'sem magias de area';
}
if ($info['modo'] == 3) {
$modo = 'sem sudden death rune';
}
if(!is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; }
$number_of_rows++;
$main_content .= '
<tr bgcolor="'.$config['site']['lightborder'].'">
<td></br>
<center>
<h2>'.$info['guild1'].'</h2>
</center>
</td>
<td></br>
<center>
<h1><font color='.$colort1.'>'.$info['frags_guild1'].'</font> x <font color='.$colort2.'>'.$info['frags_guild2'].'</font></h1>
<b>Tempo: </b>'.$info['tempo'].' minutos. </br>
<b>Modo: </b>'.$modo.'.
</center>
</td>
<td></br>
<center>
<h2>'.$info['guild2'].'</h2>
</center>
</td>
</tr>
';
}
$main_content .= '
</tbody></table>
</div>
</td>
</tr>
</tbody></table>
</div>
</br>
<center>Desenvolvido por <a href="http://chaitosoft.com/">ChaitoSoft.com</a>.</center>
';
?>