pedido Rank de Storage [rep+?]

[20cm 70]

Alguém consegue fazer um script pra mim que mostra um rank de uma storage que eu defina ? do maior pro menor (digo no site)

 

tipo assim:

 

Ali no storage é o storage do jogador ^^ (como se o Lepsiu tivesse o value 604530353 na storage xxx )

 

 

valendo rep+ hein ? quem ajudar ganha um beiijinho tbm s2

qualquer coisa pode me adc no msn : eitorlaba@hotmail.com

 

;;;

[Piabeta Kun 359]

Estarei vendo isso pra voce!

 

Apenas aguarde!

[Oneshot 732]

<?PHP
$storage_number = 2000;

$values = $SQL->query("SELECT name, level, value FROM players, player_storage WHERE players.id = player_storage.player_id AND player_storage.key = ".$storage_number." ORDER BY value DESC LIMIT 100");

$main_content .= "<TABLE BORDER=0 CELLPADDING=0 CELLSPACING=0 WIDTH=100%><TR><TD><CENTER><H2>Storage Ranking</H2></CENTER><BR>";
$main_content .= "<TABLE BORDER=0 CELLPADDING=4 CELLSPACING=1 WIDTH=100%></TABLE><TABLE BORDER=0 CELLPADDING=4 CELLSPACING=1 WIDTH=100%><TR BGCOLOR='".$config['site']['vdarkborder']."'><TD WIDTH=10% CLASS=whites><B>Rank</B></TD><TD WIDTH=50% CLASS=whites><B>Name</B></TD><TD WIDTH=10% CLASS=whites><B>Level</B></TD><TD WIDTH=30% CLASS=whites><B>Value</B></TD>";
foreach($values as $value)
{
if(!is_int($number_of_rows /2))
{
	$bgcolor = $config["site"]["darkborder"];
}
else
{
	$bgcolor = $config["site"]["lightborder"];
}
$number_of_rows++;
$main_content .= '<TR BGCOLOR="'.$bgcolor.'"><TD>'.$number_of_rows.'</TD><TD><a href="?subtopic=characters&name='.urlencode($value["name"]).'">'.$value["name"].'</a></TD><TD>'.$value["level"].'</TD><TD>'.$value["value"].'</TD></TR>';
}
$main_content .= "</TR></TABLE>";


$main_content .= "</TR></TABLE>";

?>

 

Pra Gesior AAC.

 

Abraços.

Editado Dezembro 22, 2012 por Oneshot

[20cm 70]

<?PHP
$storage_number = 2000;

$values = $SQL->query("SELECT name, level, value FROM players, player_storage WHERE players.id = player_storage.player_id AND player_storage.key = ".$storage_number." ORDER BY value DESC LIMIT 100");

$main_content .= "<TABLE BORDER=0 CELLPADDING=0 CELLSPACING=0 WIDTH=100%><TR><TD><CENTER><H2>Storage Ranking</H2></CENTER><BR>";
$main_content .= "<TABLE BORDER=0 CELLPADDING=4 CELLSPACING=1 WIDTH=100%></TABLE><TABLE BORDER=0 CELLPADDING=4 CELLSPACING=1 WIDTH=100%><TR BGCOLOR='".$config['site']['vdarkborder']."'><TD WIDTH=10% CLASS=whites><B>Rank</B></TD><TD WIDTH=50% CLASS=whites><B>Name</B></TD><TD WIDTH=10% CLASS=whites><B>Level</B></TD><TD WIDTH=30% CLASS=whites><B>Value</B></TD>";
foreach($values as $value)
{
if(!is_int($number_of_rows /2))
{
	$bgcolor = $config["site"]["darkborder"];
}
else
{
	$bgcolor = $config["site"]["lightborder"];
}
$number_of_rows++;
$main_content .= '<TR BGCOLOR="'.$bgcolor.'"><TD>'.$number_of_rows.'</TD><TD><a href="?subtopic=characters&name='.urlencode($value["name"]).'">'.$value["name"].'</a></TD><TD>'.$value["level"].'</TD><TD>'.$value["value"].'</TD></TR>';
}
$main_content .= "</TR></TABLE>";


$main_content .= "</TR></TABLE>";

?>

 

Pra Gesior AAC.

 

Abraços.

 

Boa, obrigado. Adaptei pois troquei a storage por uma coluna no players, mas vai ficar salvo. rep dada

[Piabeta Kun 359]

atendd movid0!