<?php
if (!@(require "Config/Main.php")) {
die;
}
require_once $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "System/MuDatabase.class.php";
$db = new MuDatabase();
require_once $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "System/Guild.class.php";
$gd = new Guild();
$db->Query("SELECT g.G_Name,g.G_Master,g.G_Mark,cs.Points,g.Number FROM Guild g, Z_CastleSiegeWins cs WHERE g.G_Name = cs.Guild AND g.G_Name = (SELECT OWNER_GUILD FROM MuCastle_DATA)");
if ($db->NumRows() > 0) {
$data = $db->GetRow();
$CSOwner = $data[0];
$CSKing = $data[1];
$CSMark = $gd->PrintGuildMark(bin2hex($data[2]), 96);
$CSWins = $data[3];
$CSOwnersNumber = $data[4];
$db->Query("SELECT g.G_Name, COUNT(m.G_Name) FROM Guild g, GuildMember m WHERE g.G_Name = m.G_Name AND g.G_Union = '{$CSOwnersNumber}' GROUP BY g.G_Name");
$NumAllies = $db->NumRows();
$CSAllies = array();
$CSMembers = 0;
for ($i = 0; $i < $NumAllies; $i++) {
$result = $db->GetRow();
if ($result[0] != $CSOwner) {
$CSAllies[$i] = $result[0];
}
$CSMembers += $result[1];
}
} else {
$CSOwner = "-";
$CSKing = "-";
$data = $db->GetRow();
$TopHR = $data[0];
$TopHRAcc = $data[1];
}
if ($TopGuildCastleSwitch == 1) {
require_once $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "System/Guild.class.php";
$gd = new Guild();
$db->Query("SELECT TOP 1 Guild FROM Z_CastleSiegeWins ORDER BY Points DESC, idx DESC");
if ($db->NumRows() > 0) {
$data = $db->GetRow();
$TopGuild = $data[0];
$db->Query("SELECT G_Mark FROM Guild WHERE G_Name = '{$TopGuild}'");
$data = $db->GetRow();
//$TopGuildMark = "<img src=/" . $_SESSION['SiteFolder'] . "System/GuildMark.php?code=". bin2hex($data[0]) ."&size=$UsersImageWidth\" />";
$MarkCode = bin2hex($data[0]);
$TopGuildMark = $gd->PrintGuildMark($MarkCode, $UsersImageWidth);
} else {
$TopGuild = "-";
$TopGuildMark = "-";
}
}
echo "<style>{$CSScode}</style>";
?>
<table class="generalTable">
<tr>
<?php
if ($TopResetSwitch == 1) {
?>
<td valign="top">
<table class="individualTable">
<tr><td align="center" valign="bottom" nowrap="true" class="headers"><?php
function DrawTopGuildsTable($param1, $param2)
{
require $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "Config/Main.php";
require $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "Config/SQL.php";
require $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "Config/TopGuilds.php";
require $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "Language/{$MainLanguage}/Rankings.php";
$criteria = $param1;
$rows = $param2;
if ($TopGuildsMaxResults > 0 && $rows > $TopGuildsMaxResults) {
return "";
}
if (!is_numeric($rows) && $rows != "*") {
die;
}
if ($rows == "*") {
$rows = "";
} else {
$rows = "TOP {$rows}";
}
switch ($criteria) {
default:
case "resets":
$query = "\n\t\t\t\t\tSELECT {$rows} m.G_Name as Guild, SUM(c.{$SQLResetsColumn}) as Points, RANK() OVER(ORDER BY SUM(c.{$SQLResetsColumn}) DESC) as Rank\n\t\t\t\t\tFROM GuildMember m, Character c\n\t\t\t\t\tWHERE m.Name = c.Name\n\t\t\t\t\tGROUP BY m.G_Name\n\t\t\t\t\tHAVING SUM(c.{$SQLResetsColumn}) > 0\n\t\t\t\t\tORDER BY SUM(c.{$SQLResetsColumn}) DESC\n\t\t\t\t";
break;
case "score":
$query = "\n\t\t\t\t\tSELECT {$rows} G_Name as Guild, G_Score as Points, RANK() OVER(ORDER BY G_Score DESC) as Rank\n\t\t\t\t\tFROM Guild\n\t\t\t\t\tWHERE G_Score > 0\n\t\t\t\t\tORDER BY G_Score DESC\n\t\t\t\t\t";
break;
case "cs":
$query = "SELECT Guild, Points, RANK() OVER(ORDER BY Points DESC) as Rank FROM Z_CastleSiegeWins WHERE Guild IN (SELECT G_Name FROM Guild) ORDER BY Points DESC";
break;
}
$return = "\n\t\t<table class=\"RankingGuildsTable\">\n\t\t\t<tr>\n\t\t\t\t<th id=\"Position\">{$RankingMessage008}</th>\n\t\t\t\t<th id=\"Guild\">{$RankingMessage028}</th>";
if ($TopGuildsShowMaster) {
$return .= "<th id=\"Master\">{$RankingMessage029}</th>";
}
if ($TopGuildsShowAssistant) {
$return .= "<th id=\"Assistant\">{$RankingMessage030}</th>";
}
if ($TopGuildsShowBattleMrs) {
$return .= "<th id=\"Battle\">{$RankingMessage031}</th>";
}
if ($param1 == "resets") {
$return .= "<th id=\"Resets\">{$RankingMessage032}</th>";
}
if ($param1 == "score") {
$return .= "<th id=\"Score\">{$RankingMessage033}</th>";
}
if ($param1 == "cs") {
$return .= "<th id=\"CSWins\">{$RankingMessage034}</th>";
}
if ($TopGuildsShowMembers) {
$return .= "<th id=\"Members\">{$RankingMessage035}</th>";
}
if ($TopGuildsShowLogo) {
$return .= "<th id=\"Mark\">{$RankingMessage036}</th>";
}
$return .= "\n\t\t\t</tr>";
$queryMembers = "SELECT G_Name,COUNT(G_Status) as Members FROM GuildMember GROUP BY G_Name";
$this->db->Query($queryMembers);
$MembersRows = $this->db->NumRows();
for ($i = 0; $i < $MembersRows; $i++) {
$data = $this->db->GetRow();
$GuildData[$data['G_Name']]['Members'] = $data['Members'];
}
$queryArray = "\n\t\t\t\tSELECT g.G_Name, g.G_Mark, g.G_Score, m.Name, m.G_Status\n\t\t\t\tFROM Guild g, GuildMember m\n\t\t\t\tWHERE g.G_Name = m.G_Name\n\t\t\t";
$this->db->Query($queryArray);
$GuildRows = $this->db->NumRows();
for ($i = 0; $i < $GuildRows; $i++) {
$data = $this->db->GetRow();
if (empty($GuildData[$data['G_Name']]['G_Mark'])) {
$GuildData[$data['G_Name']]['Master'] = "-";
$GuildData[$data['G_Name']]['Assistant'] = "-";
$GuildData[$data['G_Name']]['Battle'] = array();
$GuildData[$data['G_Name']]['G_Mark'] = bin2hex($data['G_Mark']);
}
switch ($data['G_Status']) {
case 0:
if ($GuildData[$data['G_Name']]['Master'] == "-") {
$GuildData[$data['G_Name']]['Master'] = $data['Name'];
}
break;
case 32:
array_push($GuildData[$data['G_Name']]['Battle'], $data['Name']);
break;
case 64:
$GuildData[$data['G_Name']]['Assistant'] = $data['Name'];
break;
case 128:
$GuildData[$data['G_Name']]['Master'] = $data['Name'];
break;
}
}
$this->db->Query($query);
$NumRows = $this->db->NumRows();
for ($i = 0; $i < $NumRows; $i++) {
$num = $i % 2 + 1;
$data = $this->db->GetRow();
$return .= "\t\t\t\t\n\t\t\t\t<tr class=\"RankingGuildsTableRow{$num}\">\n\t\t\t\t<td id=\"Position\">" . $data['Rank'] . "{$RankingMessage017}</td>\n\t\t\t\t<td id=\"Guild\">" . $data['Guild'] . "</td>";
if ($TopGuildsShowMaster) {
$return .= "<td id=\"Master\">" . $GuildData[$data['Guild']]['Master'] . "</td>";
}
if ($TopGuildsShowAssistant) {
$return .= "<td id=\"Assistant\">" . $GuildData[$data['Guild']]['Assistant'] . "</td>";
}
if ($TopGuildsShowBattleMrs) {
$return .= "<td id=\"Battle\">";
if (count($GuildData[$data['Guild']]['Battle']) > 0) {
$return .= implode($TopGuildsBattleSepar, $GuildData[$data['Guild']]['Battle']);
} else {
$return .= "-";
}
}
$return .= "</td>";
if ($param1 == "resets") {
$return .= "<td id=\"Resets\">" . number_format($data['Points'], 0, "", ".") . "</td>";
}
if ($param1 == "score") {
$return .= "<td id=\"Score\">" . number_format($data['Points'], 0, "", ".") . "</td>";
}
if ($param1 == "cs") {
$return .= "<td id=\"CSWins\">" . number_format($data['Points'], 0, "", ".") . "</td>";
}
if ($TopGuildsShowMembers) {
$return .= "<td id=\"Members\">" . $GuildData[$data['Guild']]['Members'] . "</td>";
}
if ($TopGuildsShowLogo) {
require_once $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "System/Guild.class.php";
$gd = new Guild();
//$return .= "<td id=\"Mark\"><img src=\"". str_replace("/index.php","",$_SERVER['PHP_SELF']) ."/System/GuildMark.php?code=". $GuildData[$data['Guild']]['G_Mark'] ."&size=$TopGuildsLogoSize\" /></td>";
$return .= "<td id=\"Mark\">";
$return .= $gd->PrintGuildMark($GuildData[$data['Guild']]['G_Mark'], $TopGuildsLogoSize);
$return .= "</td>";
}
$return .= "\n\t\t\t</tr>";
}
$return .= "</table>";
return $return;
}
$db->Query("SELECT * FROM Guild WHERE G_Name = '{$guild}'");
$NumRows = $db->NumRows();
$data = $db->GetRow();
if ($NumRows <= 0) {
$error = "<tr><td colspan='6'><div class='alert alert-danger' style='margin:0px;'>A Guild <b>{$guild}</b> não foi encontrada no banco de dados...</div></td></tr>";
$Guild = "{$guild}";
$GuildInfo = "";
$logo = "";
$G_Member = "-";
$G_Notice = "-";
$G_Score = "-";
$G_Master = "-";
} else {
$error = "";
$Guild = "{$guild}";
$logo = $gd->PrintGuildMark(bin2hex($data['G_Mark']), 150);
$G_Master = $data['G_Master'];
$G_Score = $data['G_Score'];
$G_Notice = $data['G_Notice'];
$db->Query("SELECT Name, G_Status FROM GuildMember WHERE G_Name = '{$guild}' ORDER BY G_Status DESC");
$NumRows1 = $db->NumRows();
$G_Member = $NumRows1;
$GuildInfo = "";
while ($data1 = $db->GetRow()) {
$rank++;
switch ($data1['G_Status']) {
case 128:
$gstatus = 'Guild Master';
break;
case 64:
$gstatus = 'Assistente';
