Top players';
$mssql_link = mssql_connect( 'STORMY-PC\SQLEXPRESS', 'sa', 'Mitek2011' );
if ( !$mssql_link )
{
showMessage( 'info', 'Top Player list is temporarly offline' );
}
else
{
$selectPlayers = mssql_query( "SELECT TOP 100 sID, nLevel, nFame FROM World00_Character..tCharacter WHERE nAdminLevel = 0 AND bDeleted = 0 ORDER by nLevel DESC" );
$i = 1;
echo '';
echo '| # | Name | Fame | Level |
';
while($player = mssql_fetch_array($selectPlayers))
{
$player["sID"] = str_replace("ä", "ä", str_replace("Ä", "Ä", str_replace("ö", "ö", str_replace("Ö", "Ö", str_replace("ü", "ü", str_replace("Ü", "Ü", str_replace("ß", "ß", $player["sID"])))))));
echo '| '.$i.' | '.$player['sID'].' | '.$player['nFame'].' | '.$player['nLevel'].' |
';
$i++;
}
echo '
';
}
}
?>