his page shows the overall top guilds in mutually declared wars and Membership.
|
Total Guilds: $totalguilds Total Chaos Guilds: $chaosguilds Total Order Guilds: $orderguilds
|
EOF;
if ($gp - $guilds_perpage >= 0) {
$num = $gp - $guilds_perpage;
echo " \n";
}
else
echo " ";
$page = intval($gp / $guilds_perpage) + 1;
$pages = ceil($totalguilds / $guilds_perpage);
if ($pages > 1)
echo " Page [$page/$pages] ";
if ($gp + $guilds_perpage < $totalguilds) {
$num = $gp + $guilds_perpage;
echo " \n";
}
echo <<
|
|
|
Guild Name
|
Members
|
Kills
|
EOF;
// Guilds / members
$result = sql_query($link, "SELECT guild_id,guild_name,COUNT(char_guild) AS countofchar_guild,SUM(char_counts) AS countofchar_counts
FROM myrunuo_guilds INNER JOIN myrunuo_characters ON guild_id=char_guild
GROUP BY guild_name ORDER by $sort1 LIMIT $gp,$guilds_perpage");
if (mysql_numrows($result)) {
$num = $gp * $guilds_perpage + 1;
while ($row = mysql_fetch_row($result)) {
$guildid = intval($row[0]);
$name = $row[1];
$members = intval($row[2]);
$kills = intval($row[3]);
echo <<
$num |
$name
|
$members
|
$kills
|
EOF;
$num++;
}
}
else {
echo <<
No matching guilds found.
|
EOF;
}
echo <<
|
EOF;
if ($wp - $guilds_perpage > 0) {
$num = $wp - $guilds_perpage;
echo " \n";
}
else
echo " ";
$page = intval($wp / $guilds_perpage) + 1;
$pages = ceil($totalwar / $guilds_perpage);
if ($pages > 1)
echo " Page [$page/$pages] ";
if ($wp + $guilds_perpage < $totalwar) {
$num = $wp + $guilds_perpage;
echo " \n";
}
echo <<
|
|
|
Guild Name
|
Enemies
|
EOF;
// War guilds / enemies
$result = sql_query($link, "SELECT guild_id,guild_name,COUNT(guild_1) AS countofguild_1
FROM myrunuo_guilds INNER JOIN myrunuo_guilds_wars ON guild_id=guild_1 OR guild_id=guild_2
GROUP BY guild_id,guild_name ORDER by $sort2 LIMIT $wp,$guilds_perpage");
$num = mysql_numrows($result);
if ($num) {
$num = $wp * $guilds_perpage + 1;
while ($row = mysql_fetch_row($result)) {
$guildid = intval($row[0]);
$name = $row[1];
$enemies = intval($row[2]);
echo <<
$num
|
$name
|
$enemies
|
EOF;
$num++;
}
}
else {
echo <<
No matching guilds found. |
EOF;
}
mysql_free_result($result);
mysql_close($link);
if ($timestamp != "")
$dt = date("F j, Y, g:i a", strtotime($timestamp));
else
$dt = date("F j, Y, g:i a");
echo <<
|
|
Last Updated: $dt
|