Top guilds';
$mssql_link = @mssql_connect( $servername . "\\" . $dbname , $dbuser, $dbpass );
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 "| # | Name | Won | Lost | Average Wins |
\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 '| '.$i.' | '.$guild['sName'].' | '.$guild['nWarWinCount'].' | '.$guild['nWarLoseCount'].' | '. $average ."% |
\n";
$i++;
}
echo '
';
}
}
?>