Scripts para usar em seu websites [2]

**' Ashe** · 17 de Julho 2017

Reset

QUOTE

< ?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];