<?php
// CONFIG
$odbc_host = 'SQLDingsda\DeinMSSQLServer';
$odbc_user = 'sa';
$odbc_pass = 'Dein Passwort';
// CONFIG END
echo '<h1>Top 100 Players</h1>';
$odbc_link = odbc_connect ( "Driver={SQL Server};Server=".$odbc_host.";Database=w00_Charact er;" , $odbc_user , $odbc_pass );
$sql[1] = 'SELECT TOP 100 nCharNo, sID, nExp , nLevel FROM tCharacter WHERE nAdminLevel = 0 AND bDeleted = 0 ORDER BY nExp DESC';
$rs[1] = odbc_exec ( $odbc_link , $sql[1] );
if ( !$rs[1] )
{
exit ( 'Error in SQL' );
}
$i = 1;
echo '<table width="100%">';
echo ' <tr>';
echo ' <td>';
echo ' #';
echo ' </td>';
echo ' <td>';
echo ' Name';
echo ' </td>';
echo ' <td>';
echo ' Exp';
echo ' </td>';
echo ' <td>';
echo ' Level';
echo ' </td>';
echo ' <td>';
echo ' Class';
echo ' </td>';
echo ' <td>';
echo ' Guild';
echo ' </td>';
echo ' </tr>';
while ( odbc_fetch_row ( $rs[1] ) )
{
$sID = odbc_result ( $rs[1] , 'sID' );
$nExp = odbc_result ( $rs[1] , 'nExp' );
$nLevel = odbc_result ( $rs[1] , 'nLevel' );
$nName = 'No Guild';
$sID = str_replace ( '?', '†', str_replace ( '?' , 'ä' , str_replace ( '?' , 'Ä' , str_replace ( '?' , 'ö' , str_replace ( '?' , 'Ö' , str_replace ( '?' , 'ü' , str_replace ( '?' , 'Ü' , str_replace ( '?' , 'ß' , $sID ) ) ) ) ) ) ) );
$nCharNo = odbc_result ( $rs[1] , 'nCharNo' );
$sql[2] = 'SELECT TOP 1 nNo FROM tGuildMember WHERE nCharNo = '.$nCharNo;
$rs[2] = odbc_exec ( $odbc_link , $sql[2] );
if ( !$rs[2] )
{
exit ( 'Error in SQL' );
}
while ( odbc_fetch_row ( $rs[2] ) )
{
$nNo = odbc_result ( $rs[2] , 'nNo' );
$sql[3] = 'SELECT TOP 1 sName FROM tGuild WHERE nNo = '.$nNo;
$rs[3] = odbc_exec ( $odbc_link , $sql[3] );
while ( odbc_fetch_row ( $rs[3] ) )
{
$nName = odbc_result ( $rs[3] , 'sName' );
}
}
$sql[4] = 'SELECT TOP 1 nClass FROM tCharacterShape WHERE nCharNo = '.$nCharNo;
$rs[4] = odbc_exec ( $odbc_link , $sql[4] );
if ( !$rs[4] )
{
exit ( 'Error in SQL' );
}
while ( odbc_fetch_row ( $rs[4] ) )
{
$nClass = odbc_result ( $rs[4] , 'nClass' );
}
switch ($nClass)
{
//Fighter
case 1:
$nClass = 'Fighter';
break;
case 2:
$nClass = 'Clever Fighter';
break;
case 3:
$nClass = 'Warrior';
break;
case 4:
$nClass = 'Gladiator';
break;
case 5:
$nClass = 'Knight';
break;
//Cleric
case 6:
$nClass = 'Cleric';
break;
case 7:
$nClass = 'High Cleric';
break;
case 8:
$nClass = 'Paladin';
break;
case 9:
$nClass = 'Holy Knight';
break;
case 10:
$nClass = 'Guardian';
break;
//Jäger
case 11:
$nClass = 'Archer';
break;
case 12:
$nClass = 'Hawk Archer';
break;
case 13:
$nClass = 'Scout';
break;
case 14:
$nClass = 'Sharpshooter';
break;
case 15:
$nClass = 'Ranger';
break;
//Mage
case 16:
$nClass = 'Mage';
break;
case 17:
$nClass = 'Wiz Mage';
break;
case 18:
$nClass = 'Enchanter';
break;
case 19:
$nClass = 'Warlock';
break;
case 20:
$nClass = 'Wizard';
break;
//Trickster
case 21:
$nClass = 'Trickster';
break;
case 22:
$nClass = 'Gambit';
break;
case 23:
$nClass = 'Renegade';
break;
case 24:
$nClass = 'Spectre';
break;
case 25:
$nClass = 'Reaper';
break;
//Standart
default:
$nClass = 'WeilBaum.';
break;
}
echo ' <tr>';
echo ' <td>';
echo ' '.$i;
echo ' </td>';
echo ' <td>';
echo ' '.$sID;
echo ' </td>';
echo ' <td>';
echo ' '.$nExp;
echo ' </td>';
echo ' <td>';
echo ' '.$nLevel;
echo ' </td>';
echo ' <td>';
echo ' '.$nClass;
echo ' </td>';
echo ' <td>';
echo ' '.$nName;
echo ' </td>';
echo ' </tr>';
$i++;
}
odbc_close ( $odbc_link );
echo '</table>';
?>
