<?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';