Secret Experience

{king} · 22-02-2010, 08:28 PM

Código: [Somente Usuários Registrados Podem Visualizar os Links Desta PáginaClique aqui para se Registrar]

< ?php 
$alogin = "sa"; 
$apass = "Senha do SQL"; 
$db = "MuOnline"; 
$host = "Seu IP Aqui"; 
$msconnect=mssql_connect($host,$alogin,$apass); 
$msdb=mssql_select_db("$db",$msconnect); 
$query = 'select Name,Class,cLevel,Strength,Dexterity,Vitality,Energy,LevelUpPoint,CtlCode,resets 
from Character order by resets desc , cLevel desc'; 
$result = mssql_query( $query ); 
echo '<html>'; 
echo "<head>\n"; 
echo '<body>'; 
echo '<font face=Verdana>'; 
echo '<center><table cellSpacing=1 width=100% align=center>'; 
echo '<tr> 
< td bgcolor=F5F5F5><center><b>Rank</td> 
< td bgcolor=F5F5F5><b>Personagem</td> 
< td bgcolor=F5F5F5><b>Classe</td> 
< td bgcolor=F5F5F5><b>Level</td> 
< td bgcolor=F5F5F5><b>Strenght</td> 
< td bgcolor=F5F5F5><b>Agility</td> 
< td bgcolor=F5F5F5><b>Vitality</td> 
< td bgcolor=F5F5F5><b>Energy</font></td> 
< td bgcolor=F5F5F5><b>Resets</font></td>'; 
//Aqui voce coloca o numero do rank 
//no caso esta top 100 
//se quiser mudar eh soh trocar o 100 pelo numero desejado 
for($i=0;$i < 100;++$i) 
{ 
$row = mssql_fetch_row($result); 
$personag = htmlentities($row[0]); 
echo '<tr><td width=5% bgcolor=F5F5F5><center><b>'; 
echo $i + 1; 
echo 'º</td><td width=21% bgcolor=F5F5F5><table>'; 
echo $personag; 
echo '</table></td><td width=19% bgcolor=F5F5F5>'; 
if($row[8] == 8){ 
echo 'Game Master'; 
} 
else { 
if($row[1] == 0){ 
echo 'Dark Wizard'; 
} 
if($row[1] == 1){ 
echo 'Soul Master'; 
} 
if($row[1] == 16){ 
echo 'Dark Knight'; 
} 
if($row[1] == 17){ 
echo 'Blade Knight'; 
} 
if($row[1] == 32){ 
echo 'Elf'; 
} 
if($row[1] == 33){ 
echo 'Muse Elf'; 
} 
if($row[1] == 48){ 
echo 'Magic Gladiator'; 
} 
if($row[1] == 64){ 
echo 'Dark Lord'; 
} 
} 
echo '</td><td width=8% bgcolor=F5F5F5>'; 
echo $row[2]; 
echo '</td><td width=9% bgcolor=F5F5F5>'; 
echo $row[3]; 
echo '</td><td width=9% bgcolor=F5F5F5>'; 
echo $row[4]; 
echo '</td><td width=9% bgcolor=F5F5F5>'; 
echo $row[5]; 
echo '</td><td width=9% bgcolor=F5F5F5>'; 
echo $row[6]; 
echo '</td><td width=9% bgcolor=F5F5F5>'; 
echo $row[9]; 
echo'</td></tr>'; 
} 
echo '</table>'; 
echo '</body>'; 
echo '</html>'; 
$conn=mssql_close(); 
?>

OBS:Lembrando que para esses scripts funcionarem, é nesessario a conexão com o mssql No Topico A CIMA (CONFIG)