di12345di
New Member
- Joined
- Aug 1, 2012
- Messages
- 105
- Reaction score
- 0
Please correct the error
Warning: Invalid argument supplied for foreach() in C:\xampp\htdocs\pages\snowballwar.php on line 147
Warning: Invalid argument supplied for foreach() in C:\xampp\htdocs\pages\snowballwar.php on line 225
snowballwar.php
Warning: Invalid argument supplied for foreach() in C:\xampp\htdocs\pages\snowballwar.php on line 147
Warning: Invalid argument supplied for foreach() in C:\xampp\htdocs\pages\snowballwar.php on line 225
snowballwar.php
PHP:
<?php
$consulta = $SQL->query('SELECT `name`,`score`,`data`, `hora` FROM `snowballwar` ORDER BY `id` DESC LIMIT 20;');
$consulta2 = $SQL->query('SELECT * FROM `players` ORDER BY `sbw_points` DESC LIMIT 3;');
$number_of_rows = 0;
$main_content .= '
<center><h2>Evento Snowball War</h2></center><div class="TableContentAndRightShadow" style="background-image:url(./layouts/tibiarl/images/global/content/table-shadow-rm.gif);" >
<div class="TableContentContainer" >
<table class="TableContent" width="100%" style="border:1px solid #faf0d7;" >
<tr>
<td>O evento será executado todos os dias da semana as 16:00 horas.</td>
</tr>
</table>
</div>
</div>
<div class="TableShadowContainer" >
<div class="TableBottomShadow" style="background-image:url(./layouts/tibiarl/images/global/content/table-shadow-bm.gif);" >
<div class="TableBottomLeftShadow" style="background-image:url(./layouts/tibiarl/images/global/content/table-shadow-bl.gif);" ></div>
<div class="TableBottomRightShadow" style="background-image:url(./layouts/tibiarl/images/global/content/table-shadow-br.gif);" ></div>
</div>
</div>
</td>
</tr>
<tr>
<td>
<div class="TableShadowContainerRightTop" >
<div class="TableShadowRightTop" style="background-image:url(./layouts/tibiarl/images/global/content/table-shadow-rt.gif);" ></div>
</div>
<div class="TableContentAndRightShadow" style="background-image:url(./layouts/tibiarl/images/global/content/table-shadow-rm.gif);" >
<div class="TableContentContainer" >
<table class="TableContent" width="100%" style="border:1px solid #faf0d7;" >
</tr>
<td colspan="3" bgcolor="#505050">
<span class="style4">
<font color="white">Só terão três ganhadores, os três que pontuar mais, os prêmios são:</font>
</span>
</td>
</tr>
<tr bgcolor="#f1e0c6">
<td width="15%">
<b>Prêmios:</b></td><td width="80%"><b>1 - </b> <u>25 Mega Coins e 70 Crystal Coins</u><br><b>2 - </b> <u>20 Mega Coins e 50 Crystal Coins</u><br><b>3 - </b> <u>15 Mega Coins e 30 Crystal Coins</u>
</td>
</tr>
</table>
</div>
</div>
<div class="TableShadowContainer" >
<div class="TableBottomShadow" style="background-image:url(./layouts/tibiarl/images/global/content/table-shadow-bm.gif);" >
<div class="TableBottomLeftShadow" style="background-image:url(./layouts/tibiarl/images/global/content/table-shadow-bl.gif);" ></div>
<div class="TableBottomRightShadow" style="background-image:url(./layouts/tibiarl/images/global/content/table-shadow-br.gif);" ></div>
</div>
</div>
</td>
</tr>
</br>
<center>
Seus jogadores irao se divertir em uma emocionante partida de guerra de bolas de neve. O objetivo principal do evento e derrubar o numero maximo de jogadores durante uma partida - atirando bolas de neve contra seus inimigos. O top score points ao final da rodada sera o vencedor.
</br>
<iframe width="560" height="315" src="https://www.youtube.com/embed/hpreUYM7rVI" frameborder="0" allowfullscreen></iframe>
</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">Informacoes</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">#</font></b></td>
<td class="LabelV150"><b><font color="white">Descricao</font></b></td>
</tr>
<tr style="background-color:'.$config['site']['lightborder'].';">
<td>
Atirar
</td>
<td>
Comando "!snowball atirar", lanca 1 bola de neve em seu adversario.
</td>
</tr>
<tr style="background-color:'.$config['site']['lightborder'].';">
<td>
Info. In-game
</td>
<td>
Comando "!snowball info", veja a sua quantia de bolas de neve que voce tem e sua quantia de pontos. Tambem o ranking geral dentro do evento.
</td>
</tr>
<tr style="background-color:'.$config['site']['lightborder'].';">
<td>
Recarregar
</td>
<td>
Se dirija ate ao centro do mapa do evento e recarregue clicando no gerador.
</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">TOP Ranking</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>
';
foreach($consulta2 as $info2) {
if(!is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; }
$number_of_rows++;
$main_content .= '
<td bgcolor="'.$config['site']['lightborder'].'">
<center>
</br>
<a href="index.php?subtopic=characters&name='.urlencode($info2['name']).'">
<b> '.$info2['name'].' </b>
</a>
</br>
<img align="center" src="/images/outfit.php?id='.$info2['looktype'].'&addons='.$info2['lookaddons'].'&head='.$info2['lookhead'].'&body='.$info2['lookbody'].'&legs='.$info2['looklegs'].'&feet='.$info2['lookfeet'].'" width="94" height="94" style="width: 94px; height: 94px; margin-top:-30px; margin-left:-65px; background-repeat: no-repeat;">
</br></br>
';
if ($number_of_rows == 1) {
$main_content .= '
<img align="center" src="http://www.tibiawiki.com.br/images/a/a7/Golden_Goblet.gif" />
';
}
if ($number_of_rows == 2) {
$main_content .= '
<img align="center" src="http://www.tibiawiki.com.br/images/9/90/Silver_Goblet.gif" />
';
}
if ($number_of_rows == 3) {
$main_content .= '
<img align="center" src="http://www.tibiawiki.com.br/images/4/41/Bronze_Goblet.gif" />
';
}
$main_content .= '
</br>
<b>Pontos:</b> ' . $info2['sbw_points'] . '
</td>
</center>
';
}
$main_content .= '
</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 Ganhadores</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">Nome</font></b></td>
<td class="LabelV150"><b><font color="white">Pontos</font></b></td>
<td class="LabelV150"><b><font color="white"> Data - Hora</font></b></td>
</tr>
';
foreach($consulta as $info) {
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>
<a href="index.php?subtopic=characters&name='.urlencode($info['name']).'">
<b> '.$info['name'].' </b></a>
</td>
<td>
' . $info['score'] . '
</td>
<td>
<b> ' . $info['data'] . '</b> - <b>' . $info['hora'] . '</b>
</td>
</tr>
';
}
$main_content .= '
</tbody></table>
</div>
</td>
</tr>
</tbody></table>
</div>
</br>
<br>
<b>Event Coins & NPC Mega Events<br></b>
<br>
<div class="TableContentAndRightShadow" style="background-image:url(./layouts/tibiarl/images/global/content/table-shadow-rm.gif);" >
<div class="TableContentContainer" >
<table class="TableContent" width="100%" style="border:1px solid #faf0d7;" >
<tr>
<td><b>150 Events Coins, + 1 premium point</b><b></b>.</td>
</tr>
</table>
</div>
</div>
<div class="TableShadowContainer" >
<div class="TableBottomShadow" style="background-image:url(./layouts/tibiarl/images/global/content/table-shadow-bm.gif);" >
<div class="TableBottomLeftShadow" style="background-image:url(./layouts/tibiarl/images/global/content/table-shadow-bl.gif);" ></div>
<div class="TableBottomRightShadow" style="background-image:url(./layouts/tibiarl/images/global/content/table-shadow-br.gif);" ></div>
</div>
</div>
</td>
</tr>
<tr>
<td>
<div class="TableShadowContainerRightTop" >
<div class="TableShadowRightTop" style="background-image:url(./layouts/tibiarl/images/global/content/table-shadow-rt.gif);" ></div>
</div>
<div class="TableContentAndRightShadow" style="background-image:url(./layouts/tibiarl/images/global/content/table-shadow-rm.gif);" >
<div class="TableContentContainer" >
<table class="TableContent" width="100%" style="border:1px solid #faf0d7;" >
<tr>
<td width="50%"><b></b></br><img src="snowball.png"></td><td width="50%"></br></td>
</tr>
</table>
</div>
</div>
<br>
';
?>
Last edited: