cimmeria escribió:gracias va perfecto pero aora lo que pasa no me refleja los premiados en la web :S como podriamos areglar eso te dejo el lotery de la web
<?PHP
//Criado por Dhenyz Shady from shadyroom.blogspot.com
//Favor manter os créditos / Please keep the credits
//Use e abuse / Enjoy!
header("Content-Type: text/html; charset=ISO-8859-1",true) ;
$lotterys = $SQL->query("SELECT `id`, `name`, `item` FROM lottery ORDER BY `id` ASC LIMIT 20;");$players = 0;
$main_content .= ' <h1><center>- '.$config['server']['serverName'].' Lottery System -</center></h1>
Esse sistema sorteia de <b>3 em 3hrs</b> um player <font color="green">ONLINE</font> no servidor para dar um item a ele, e os items disponíveis na loteria são:
<br></br>
<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR="'.$config['site']['vdarkborder'].'"><TD CLASS=white><B>Itens Sorteados:</B></TD></TR></TABLE>
<table border="1" width="100%">
<tr>
<td><p align="center"><img src="images/items/2493.gif"</img><br /> Demon Helmet</p></td>
<td>You see a demon helmet (Arm:10).
It weighs 29.50 oz.</td>
</tr>
<tr>
<td><p align="center"><img src="images/items/2494.gif"</img><br /> Demon Armor</p></td>
<td>You see a demon armor (Arm:16).
It weighs 80.00 oz.</td>
</tr>
<tr>
<td><p align="center"><img src="images/items/2495.gif"</img><br /> Demon Legs </p></td>
<td>You see demon legs (Arm:9).
It weighs 54.00 oz.</td>
</tr>
<tr>
<td><p align="center"><img src="images/items/2195.gif"</img><br /> Boots of haste</p></td>
<td>You see boots of haste (speed +15).
It weighs 7.50 oz.</td>
</tr>
<tr>
<td><p align="center"><img src="images/items/2514.gif"</img><br /> Mastermind Shield</p></td>
<td>You see a mastermind shield (Def:37).
It weighs 57.00 oz.</td>
</tr>
<tr>
<td><p align="center"><img src="images/items/2520.gif"</img><br /> Demon Shield</p></td>
<td>You see a demon shield (Def:35).
It weighs 38.00 oz.</td>
</tr>
<tr>
<td><p align="center"><img src="images/items/2472.gif"</img><br /> Magic Plate Armor</p></td>
<td>You see a magic plate armor (Arm:17).
It can only be wielded properly by elite knights and royal paladins.
It weighs 85.00 oz.</td>
</tr>
<tr>
<td><p align="center"><img src="images/items/2470.gif"</img><br /> Golden Legs </p></td>
<td>You see golden legs (Arm:9).
It can only be wielded properly by elite knights and royal paladins.
It weighs 54.00 oz.</td>
</tr>
<tr>
<td><p align="center"><img src="images/items/2160.gif"</img><br /> 100 Crystal coins</p></td>
<td>100,000 Gold.</td>
</tr>
</table>
<br />';
if(empty($lotterys))
{
$main_content .= '<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR="'.$config['site']['vdarkborder'].'"><TD CLASS=white><b>Auctions</b></td></TR><TR BGCOLOR='.$config['site']['darkborder'].'><TD>Currently is no one active Auction.</TD></TR></TABLE>';
$main_content .= '<br /><p align="right"><small></small></p>';
}
else
{
foreach($lotterys as $lotterys) {
$players++;
if(is_int($players / 2))
$bgcolor = $config['site']['lightborder'];
else
$bgcolor = $config['site']['darkborder'];
$cost = round($auction['cost']/1000, 2);
$content .= '<TR BGCOLOR='.$bgcolor.'><TD><center>'.$lottery['id'].'</center></TD><TD><center>'.$lottery['item'].'</center></TD><TD><center><a href="?subtopic=characters&name='.urlencode($lottery['name']).'">'.$lottery['name'].'</a></center></TD></TR>';
}
$main_content .= 'Os ultimos 20 sorteios:<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR="'.$config['site']['vdarkborder'].'"><TD CLASS=white><b><center>ID</center></b></TD><TD class="white"><b><center>Item</center></b></TD><TD class="white"><b><center>Sortudo</center></b></td></TR>'.$content.'</TABLE>';
$main_content .= '';
}
?>
Resultado:
[Tienes que estar registrado y conectado para ver este vínculo]