<?
$user="XXX";
$password="XXX";
$database="anrosite_rodb";
$mysql_ip="127.0.0.1";
mysql_connect($mysql_ip,$user,$password);
@mysql_select_db($database) or die("Unable to select database");
$castle_name = Array (
0 => "Neuschwanstein",
1 => "Hohenschwangau",
2 => "Nuenberg",
3 => "Wuerzburg",
4 => "Rothenburg",
5 => "Repherion",
6 => "Eeyolbriggar",
7 => "Yesnelph",
8 => "Bergel",
9 => "Mersetzdeitz",
10 => "Bright Arbor",
11 => "Scarlet Palace",
12 => "Holy Shadow",
13 => "Sacred Altar",
14 => "Bamboo Grove Hill",
15 => "Kriemhild",
16 => "Swanhild",
17 => "Fadhgridh",
18 => "Skoegul",
19 => "Gondul",
20 => "Earth",
21 => "Air",
22 => "Water",
23 => "Fire",
24 => "Himinn",
25 => "Andlangr",
26 => "Viblainn",
27 => "Hljod",
28 => "Skidbladnir",
29 => "Mardol",
30 => "Cyr",
31 => "Horn",
32 => "Gefn",
33 => "Bandis");
$sql=mysql_query("
SELECT
	woe_guild_breaks.castle_id,
	woe_guild_breaks.guild_id,
	guild_castle.economy,
	guild_castle.defense,
	guild.name AS guild_name,
	COUNT(woe_guild_breaks.id) AS breaks
FROM
	woe_guild_breaks,
	guild_castle,
	guild
WHERE
	woe_guild_breaks.castle_id = guild_castle.castle_id
GROUP BY woe_guild_breaks.castle_id
ORDER BY breaks DESC");
$castles = mysql_fetch_array($sql);
$sql=mysql_query("
SELECT
	woe_guild_breaks.guild_id,
	guild.name AS guild_name,
	COUNT(woe_guild_breaks.guild_id) AS breaks
FROM
	woe_guild_breaks,
	guild
WHERE
	woe_guild_breaks.guild_id= guild.guild_id
GROUP BY woe_guild_breaks.guild_id
ORDER BY breaks DESC");
$guilds = mysql_fetch_array($sql);
$sql=mysql_query("
SELECT
	char.name,
	char.class,
	guild.name AS guild_name,
	guild.guild_id,
	char.empbreak
FROM
	`char`,
	guild
WHERE
	char.guild_id = guild.guild_id
AND
	char.empbreak > 0
ORDER BY char.empbreak DESC
LIMIT 10");
$breakers = mysql_fetch_array($sql);
?>
<h3>Castles</h3>
<?
echo "<table><tr><td>Rank</td><td>Castle</td><td colspan=2>Current Owner</td><td>Economy</td><td>Defence</td><td>Breaks</td></tr>";
$i=0;
foreach( $castles as $castle )
{
$i++;
	echo "<tr><td>".$i."</td>";
	echo "<td>".$castle_name[$castle['castle_id']]."</td>";
	echo "<td><img src=\"".$this->emblem($castle['guild_id'])."\"></td>";
	echo "<td>".$castle['guild_name']."</td>";
	echo "<td>".$castle['echonomy']."</td>";
	echo "<td>".$castle['defence']."</td>";
	echo "<td>".$castle['breaks']."</td></tr>";
}
echo "</table>";
?>
<h3>Breakers</h3>
<?
echo "<table><tr><td>Rank</td><td>Name</td><td>Class</td><td colspan=2>Guild</td><td>Castle Conquered</td></tr>";
$i=0;
foreach( $breakers AS $breaker )
{
$i++;
	echo "<tr><td>".$i."</td>";
	echo "<td>".$breaker['name']."</td>";
	echo "<td>".$this->jobClassText($breaker['class'])."</td>";
	echo "<td><img src=\"".$this->emblem($breaker['guild_id'])."\"></td>";
	echo "<td>".$breaker['guild_name']."</td>";
	echo "<td>".$breaker['empbreak']."</td></tr>";
}
echo "</table>";
?>
<h3>Guilds</h3>
<?
echo "<table><tr><td>Rank</td><td colspan=2>Guild</td><td>Breaks</td></tr>";
$i=0;
foreach( $guilds as $guild )
{
$i++;
	echo "<tr><td>".$i."</td>";
	echo "<td><img src=\"".$this->emblem($guild['guild_id'])."\"></td>";
	echo "<td>".$guild['guild_name']."</td>";
	echo "<td>".$guild['breaks']."</td></tr>";
}
echo "</table>";
?>