Top guilds'; $mssql_link = mssql_connect( 'STORMY-PC\SQLEXPRESS', 'sa', 'Mitek2011' ); if ( !$mssql_link ) { showMessage( 'info', 'Top Guild list is temporarly offline' ); } else { $selectGuilds = mssql_query( "EXEC World00_Character..gilden_umlautefiltern" ); $i = 1; echo "\n"; echo "\n"; while ( $guild = mssql_fetch_array( $selectGuilds ) ) { $guild["sName"] = str_replace("ä", "ä", str_replace("Ä", "Ä", str_replace("ö", "ö", str_replace("Ö", "Ö", str_replace("ü", "ü", str_replace("Ü", "Ü", str_replace("ß", "ß", $guild["sName"]))))))); if($guild['nWarWinCount'] > 0)$average = round($guild['nWarWinCount'] / ($guild['nWarWinCount'] + $guild['nWarLoseCount']), 3)*100; else $average = 0; echo '\n"; $i++; } echo '
#NameWonLostAverage Wins
'.$i.''.$guild['sName'].''.$guild['nWarWinCount'].''.$guild['nWarLoseCount'].''. $average ."%
'; } } ?>