Top Player | Top Guild| Newest Characters

Newest Characters'; $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 sID, dCreateDate, nLevel FROM World00_Character..tCharacter WHERE nAdminLevel = 0 AND bDeleted = 0 ORDER BY dCreateDate DESC' ); $i = 1; echo ''; echo ' '; echo ' '; echo ' '; echo ' '; echo ' '; echo ' '; while($player = mssql_fetch_assoc($selectPlayers)) { $sID = mssql_fetch_assoc ( $player[1] , 'sID' ); $dCreateDate = mssql_fetch_array ( $player[1] , 'dCreateDate' ); $player["sID"] = str_replace("ä", "ä", str_replace("Ä", "Ä", str_replace("ö", "ö", str_replace("Ö", "Ö", str_replace("ü", "ü", str_replace("Ü", "Ü", str_replace("ß", "ß", $player["sID"]))))))); echo ''; $date_time = new DateTime($dCreateDate); echo ''; echo ''; $i++; } mssql_close ( $mssql_link ); echo '
'; echo ' No.'; echo ' '; echo ' '; echo ' '; echo ' Name'; echo ' '; echo ' '; echo ' Level'; echo ' '; echo ' '; echo ' Date'; echo '
'.$i.''.$player['sID'].''.$player['bDeleted'].''.$player['nLevel'].''.$player['dCreateDate'].'
'; } } ?>