Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?
- $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");
- $castles=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 guild_castle.castle_id
- ORDER BY breaks DESC");
- $guilds=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");
- $breakers=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");
- ?>
- <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;
- while( $castle = mysql_fetch_array($castles) )
- {
- $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['economy']."</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;
- while( $breaker = mysql_fetch_array($breakers) )
- {
- $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;
- while( $guild = mysql_fetch_array($guilds) )
- {
- $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>";
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement