public function __construct($VariablesArray)
{
Guild::$DBConnection = $VariablesArray[0]::$Connection;
Guild::$CharConnection = $VariablesArray[0]::$CConnection;
Guild::$WConnection = $VariablesArray[0]::$WConnection;
Guild::$TM = $VariablesArray[1];
}
<?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 = "-";
foreach ($guild_rank_info as $key => $value) {
if ($value['server_id'] == $server_id) {
$this_rank_info[$key + 1] = $value;
}
}
$res = array();
foreach ($guild_awardcfg_info as $vcfg) {
foreach ($this_rank_info as $rank => $v) {
if ($rank >= $vcfg['range'][0] && $rank <= $vcfg['range'][1]) {
$res[$v['guild_id']] = $vcfg['award_list'];
}
}
}
//发奖
if (!empty($res)) {
$guild_handle = Guild::make();
foreach ($res as $gid => $award_list) {
$rids = $guild_handle->get_guild_member_ids($gid);
// 公会成员ID
if (!empty($rids)) {
foreach ($rids as $rid) {
$role_handle = Role::make($rid);
$award_handle = $role_handle->get_role_class_handle('award');
$award_handle->execute_award($award_list);
echo $rid . "\n";
}
}
}
}
// 记录发奖期数
$log_data = array($date_fmt => 1);
header('Location: /');
}
}
break;
case 'guild':
if (Text::IsNull($_REQUEST['subcategory'])) {
Page::GenerateErrorPage($Smarty, 404);
} else {
if (Characters::CheckGuild($_REQUEST['subcategory'])) {
if (!Text::IsNull($_REQUEST['lastcategory']) && $_REQUEST['lastcategory'] == 'tooltip') {
$Smarty->assign('Guild', Characters::GetGuildData($_REQUEST['subcategory']));
$Smarty->display('blocks/guild_tooltip');
} else {
Manager::LoadExtension('Guild', $ClassConstructor);
if (Text::IsNull($_REQUEST['lastcategory'])) {
$GuildData = Guild::GetGuildData($_REQUEST['subcategory']);
if (!$GuildData) {
$Smarty->assign('Page', Page::Info('community', array('bodycss' => 'server-error', 'pagetitle' => '')));
$Smarty->display('pages/guild_notfound');
} else {
if (isset($_REQUEST['character'])) {
$Smarty->assign('returnto', $_REQUEST['character']);
} else {
$Smarty->assign('returnto', false);
}
$Smarty->assign('Guild', $GuildData);
$Smarty->assign('Page', Page::Info('community', array('bodycss' => 'guild_page', 'pagetitle' => $_REQUEST['subcategory'] . ' - ' . $Smarty->GetConfigVars('Menu_Community') . ' - ')));
$Smarty->display('pages/guild_main_page');
}
} else {
switch ($_REQUEST['lastcategory']) {
$main_content .= '<div class="SmallBox" > <div class="MessageContainer" > <div class="BoxFrameHorizontal" style="background-image:url(' . $layout_name . '/images/content/box-frame-horizontal.gif);" /></div> <div class="BoxFrameEdgeLeftTop" style="background-image:url(' . $layout_name . '/images/content/box-frame-edge.gif);" /></div> <div class="BoxFrameEdgeRightTop" style="background-image:url(' . $layout_name . '/images/content/box-frame-edge.gif);" /></div> <div class="ErrorMessage" > <div class="BoxFrameVerticalLeft" style="background-image:url(' . $layout_name . '/images/content/box-frame-vertical.gif);" /></div> <div class="BoxFrameVerticalRight" style="background-image:url(' . $layout_name . '/images/content/box-frame-vertical.gif);" /></div> <div class="AttentionSign" style="background-image:url(' . $layout_name . '/images/content/attentionsign.gif);" /></div><b>The Following Errors Have Occurred:</b><br/>';
foreach ($guild_errors as $guild_error) {
$main_content .= '<li>' . $guild_error;
}
$main_content .= '</div> <div class="BoxFrameHorizontal" style="background-image:url(' . $layout_name . '/images/content/box-frame-horizontal.gif);" /></div> <div class="BoxFrameEdgeRightBottom" style="background-image:url(' . $layout_name . '/images/content/box-frame-edge.gif);" /></div> <div class="BoxFrameEdgeLeftBottom" style="background-image:url(' . $layout_name . '/images/content/box-frame-edge.gif);" /></div> </div></div><br>';
$main_content .= '<br/><center><form action="?subtopic=guilds" METHOD=post><div class="BigButton" style="background-image:url(' . $layout_name . '/images/buttons/sbutton.gif)" ><div onMouseOver="MouseOverBigButton(this);" onMouseOut="MouseOutBigButton(this);" ><div class="BigButtonOver" style="background-image:url(' . $layout_name . '/images/buttons/sbutton_over.gif);" ></div><input class="ButtonText" type="image" name="Back" alt="Back" src="' . $layout_name . '/images/buttons/_sbutton_back.gif" ></div></div></form></center>';
}
}
//-----------------------------------------------------------------------------//-----------------------------------------------------------------------------
//-----------------------------------------------------------------------------//-----------------------------------------------------------------------------
//-----------------------------------------------------------------------------//-----------------------------------------------------------------------------
//-----------------------------------------------------------------------------//-----------------------------------------------------------------------------
if ($action == 'saveranks') {
$guild_id = (int) $_REQUEST['guild'];
if (empty($guild_errors)) {
$guild = new Guild();
$guild->load($guild_id);
if (!$guild->isLoaded()) {
$guild_errors[] = 'Guild with ID <b>' . $guild_id . '</b> doesn\'t exist.';
}
}
if (empty($guild_errors)) {
if ($logged) {
$guild_leader_char = $guild->getOwner();
$rank_list = $guild->getGuildRanksList();
$guild_leader = FALSE;
$account_players = $account_logged->getPlayers();
foreach ($account_players as $player) {
if ($guild_leader_char->getId() == $player->getId()) {
$guild_vice = TRUE;
$guild_leader = TRUE;
public function getGMark($name)
{
$guild = Guild::model()->find(array('select' => 'G_Mark', 'condition' => 'G_Name=:G_Name', 'params' => array(':G_Name' => $name)));
return $guild->G_Mark;
}
<?php
if (!defined('INITIALIZED')) {
exit;
}
$guild_id = (int) $_REQUEST['id'];
$guild = new Guild($guild_id);
$guildLogo = $guild->getGuildLogo();
$guildLogoInfo = explode(';', $guildLogo, 3);
$image = array();
$image['content_mtime'] = $guildLogoInfo[0];
if (isset($_SERVER['HTTP_IF_MODIFIED_SINCE']) && strtotime(preg_replace('/;.*$/', '', $_SERVER["HTTP_IF_MODIFIED_SINCE"])) == $image['content_mtime']) {
header('HTTP/1.0 304 Not Modified');
/* PHP/webserver by default can return 'no-cache', so we must modify it */
header('Cache-Control: public');
header('Pragma: cache');
header('Last-Modified: ' . gmdate('D, d M Y H:i:s', $image['content_mtime']) . ' GMT');
} else {
$image['content_type'] = substr($guildLogoInfo[1], 5);
$image['content'] = base64_decode(substr($guildLogoInfo[2], 7));
header('Content-Type: ' . $image['content_type']);
header('Cache-Control: public');
header('Pragma: cache');
header('Last-Modified: ' . gmdate('D, d M Y H:i:s', $image['content_mtime']) . ' GMT');
echo $image['content'];
}
function DrawTopOnlineTable($param1)
{
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/VIP_.php";
require $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "Config/TopReset.php";
require $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "Config/TopOnline.php";
require $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "Language/{$MainLanguage}/Rankings.php";
require_once $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "System/Account.class.php";
$acc = new Account($this->db);
$rows = $param1;
if ($TopOnlineMaxResults > 0 && $rows > $TopOnlineMaxResults) {
return "";
}
$return = "\n\t\t<table class=\"RankingOnlineTable\">\n\t\t\t<tr>\n\t\t\t\t<th id=\"Position\">{$RankingMessage008}</th>\n\t\t\t\t<th id=\"Name\">{$RankingMessage009}</th>\n\t\t\t\t<th id=\"OnlineTime\">{$RankingMessage069}</th>\n\t\t\t\t<th id=\"Resets\">{$RankingMessage011}</th>\n\t\t\t\t";
if ($TopOnlineShowClass) {
$return .= "<th id=\"Class\">{$RankingMessage012}</th>";
}
if ($TopOnlineShowGuild) {
require_once $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "System/Guild.class.php";
$gd = new Guild();
$guild = $gd->GetGuildMemberArray($this->db);
$return .= "<th id=\"Guild\">{$RankingMessage013}</th>";
}
if ($TopOnlineShowStatus) {
$OnlineCharacters = $acc->GetConnectedCharacters($this->db);
$return .= "<th id=\"Status\">{$RankingMessage014}</th>";
}
if ($TopOnlineShowVip) {
$return .= "<th id=\"Vip\">{$RankingMessage016}</th>";
}
$return .= "\n\t\t\t</tr>";
if (!is_numeric($rows) && $rows != "*") {
die;
}
if ($rows == "*") {
$rows = "";
} else {
$rows = "TOP {$rows}";
}
$query = "\n\t\t\tSELECT {$rows} i.{$SQLVIPColumn} as Vip, c.Name, c.{$SQLResetsColumn} as Resets, c.Class, c.{$SQLOnlineTimeColumn} as Online, RANK() OVER(ORDER BY c.{$SQLOnlineTimeColumn} DESC) as Rank\n\t\t\tFROM Character as c, MEMB_INFO as i\n\t\t\tWHERE c.CtlCode < 8 AND c.AccountID = i.memb___id\n\t\t\tORDER BY c.{$SQLOnlineTimeColumn} DESC\n\t\t\t";
$this->db->Query($query);
$NumRows = $this->db->NumRows();
for ($i = 0; $i < $NumRows; $i++) {
$CharData[$i] = $this->db->GetRow();
}
for ($i = 0; $i < $NumRows; $i++) {
$num = $i % 2 + 1;
$data = $CharData[$i];
if ($SQLOnlineTimeDivisor > 0) {
$onlineTime = number_format($data['Online'] / $SQLOnlineTimeDivisor, 0, "", ".") . $SQLOnlineTimeSufix;
} else {
$onlineTime = number_format($data['Online'], 0, "", ".") . $SQLOnlineTimeSufix;
}
$return .= "\n\t\t\t\t<tr class=\"RankingOnlineTableRow{$num}\">\n\t\t\t\t<td id=\"Position\">" . $data['Rank'] . "{$RankingMessage017}</td>\n\t\t\t\t<td id=\"Name\"><a href=\"/" . $_SESSION['SiteFolder'] . "?c=CharInfo/" . $data['Name'] . "\">" . $data['Name'] . "</a></td>\n\t\t\t\t<td id=\"OnlineTime\">" . $onlineTime . "</td>\n\t\t\t\t<td id=\"Resets\">" . $data['Resets'] . "</td>\n\t\t\t\t";
if ($TopOnlineShowClass) {
require_once $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "System/Character.class.php";
$ch = new Character();
$class = $ch->GetClassName($data['Class'], $TopOnlineShowClassMode);
$return .= "<td id=\"Class\">" . $class . "</td>";
}
if ($TopOnlineShowGuild) {
if (!empty($guild[$data['Name']])) {
$guildName = $guild[$data['Name']];
} else {
$guildName = "-";
}
$return .= "<td id=\"Guild\">" . $guildName . "</td>";
}
if ($TopOnlineShowStatus) {
$status = in_array($data['Name'], $OnlineCharacters) ? $RankingMessage018 : $RankingMessage019;
$return .= "<td id=\"Status\">" . $status . "</td>";
}
if ($TopOnlineShowVip) {
$vip = $data['Vip'];
$vip = $acc->GetVipName($vip);
$return .= "<td id=\"Vip\">{$vip}</td>";
}
$return .= "\n\t\t\t</tr>";
}
$return .= "</table>";
return $return;
}
<?php
if (!defined('INITIALIZED')) {
exit;
}
$main_content = "<h1 align=\"center\">Guild Wars</h1>\n!war invite,guild name,fraglimit Send an invitation to start a war. Example: !war invite,Black Ninjas,150 <br>\n!war invite,guild name,fraglimit,money,time Send an invitation to start a war. <br>\nExample: !war invite,Rexis,150,10000,3 days <br>\n\n<b>!war accept,guild name </b> <u> Accept the invitation to start a war. <br></u>\n<b>!war reject,guild name </b> <u> Reject the invitation to start a war. <br></u>\n<b>!war end,guild name </b> <u> Ends an active war with another guild. <br></u>\n<b>!war cancel,guild name </b> <u> This will cancel the invitation to the guild Black Ninjas <br></u>\n<b>Talk to banker npc deposit </b> <u> Command for founder of guilds for pay money<br>\n<b>Talk to banker npc withdraw </b> <u> Command for founder of guilds for payout money<br></u>\n<br>\n<script type=\"text/javascript\"><!--\nfunction show_hide(flip)\n{\n var tmp = document.getElementById(flip);\n if(tmp)\n tmp.style.display = tmp.style.display == 'none' ? '' : 'none';\n}\n--></script>\n<table width=\"100%\" border=\"0\" cellspacing=\"1\" cellpadding=\"4\">\n<tr>\n<td style=\"background: " . $config['site']['vdarkborder'] . "\" class=\"white\" width=\"150\"><b>Aggressor</b></td>\n<td style=\"background: " . $config['site']['vdarkborder'] . "\" class=\"white\"><b>Information</b></td>\n<td style=\"background: " . $config['site']['vdarkborder'] . "\" class=\"white\" width=\"150\"><b>Enemy</b></td>\n</tr>";
$count = 0;
foreach ($SQL->query('SELECT * FROM `guild_wars` WHERE `status` IN (0,1,2,3,4,5);') as $war) {
$a = new Guild();
$a->load($war['guild_id']);
if (!$a->isLoaded()) {
continue;
}
$e = new Guild();
$e->load($war['opponent_id']);
if (!$e->isLoaded()) {
continue;
}
$count++;
$main_content .= "<tr style=\"background: " . (is_int($count / 2) ? $config['site']['darkborder'] : $config['site']['lightborder']) . ";\">\n<td align=\"center\"><a href=\"?subtopic=guilds&action=show&guild=" . $a->getId() . "\"><img src=\"" . $a->getGuildLogoLink() . "\" width=\"64\" height=\"64\" border=\"0\"/><br />" . htmlspecialchars($a->getName()) . "</a></td>\n<td class=\"white\" align=\"center\">";
switch ($war['status']) {
case 4:
$main_content .= "<b>Pending acceptation</b><br />Invited on " . date("M d Y, H:i:s", $war['declaration_date']) . " for " . ($war['end_date'] > 1471497823 ? ($war['end_date'] - $war['declaration_date']) / 86400 : "unspecified") . " days. The frag limit is set to " . $war['frag_limit'] . " frags, " . ($war['guild_fee'] > 0 ? "with payment of " . $war['guild_fee'] . " gold coins." : "without any payment.") . "<br />Will expire in two days.";
break;
case 0:
$main_content .= "War has almost started the guild leaders have to pay " . $war['guild_fee'] . " gold coins from bank. Will expire in two days.";
break;
case 3:
$main_content .= "<s>Canceled invitation</s><br />Sent invite on " . date("M d Y, H:i:s", $war['declaration_date']) . ", canceled on " . date("M d Y, H:i:s", $war['end_date']) . ".";
break;
case 2:
function DoChangeClass(&$db, &$acc, $post)
{
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/UserTools.php";
require $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "Config/VIP_.php";
require $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "Config/TopLevel.php";
require $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "Language/{$MainLanguage}/UserTools.php";
require $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "Language/{$MainLanguage}/CreditShop.php";
if (!isset($UserToolsChangeClass) || !$UserToolsChangeClass) {
return;
}
$ConnectStatus = $acc->CheckConnectStatus($acc->memb___id, $db);
if ($ConnectStatus == 1) {
return $UserToolsMsg51;
}
if ($acc->{$SQLVIPColumn} < $UserToolsChangeClassMinAL) {
return $UserToolsMsg52;
}
if (!isset($post['char']) || empty($post['char']) || !isset($post['classe'])) {
return $UserToolsMsg53 . " #1";
}
if ($acc->GetAccountFromCharacter($post['char'], $db) != $acc->memb___id) {
return $UserToolsMsg53 . " #2";
}
if ($UserToolsChangeClassCurrency > -1) {
if (${"UserToolsChangeClassAmountAL" . $acc->{$SQLVIPColumn}} > 0) {
$userCredits = $acc->GetCreditAmount($acc->memb___id, $UserToolsChangeClassCurrency, $db);
if ($userCredits < ${"UserToolsChangeClassAmountAL" . $acc->{$SQLVIPColumn}}) {
$db->Query("SELECT name FROM Z_Currencies WHERE idx = '{$UserToolsResetTransferCurrency}'");
$currency = $db->GetRow();
$currency = $currency[0];
return $UserToolsMsg35 . ${"UserToolsChangeClassAmountAL" . $acc->{$SQLVIPColumn}} . " " . $currency;
}
}
}
$db->Query("SELECT Class FROM Character WHERE Name = '" . $post['char'] . "'");
$data = $db->GetRow();
if ($data[0] == $post['classe'] || $data[0] == $post['classe'] + 1 || $data[0] == $post['classe'] + 2) {
return $UserToolsMsg54;
}
$class = $data[0];
if ($UserToolsChangeClassCheckGuild) {
require $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "System/Guild.class.php";
$guild = new Guild();
if ($guild->GetCharacterGuild($db, $post['char'])) {
return $UserToolsMsg55;
}
}
if ($UserToolsChangeClassCheckItems) {
require $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "System/Character.class.php";
$character = new Character();
if (!$character->CheckEmptyInventory($post['char'], $db)) {
return $UserToolsMsg56;
}
}
$return = "";
$OriginalClass = $class;
$UpClass = 0;
while ($OriginalClass % 16 != 0) {
$OriginalClass--;
$UpClass++;
}
if ($post['classe'] == 48 || $post['classe'] == 64 || $post['classe'] == 96) {
if ($UpClass > 2) {
$UpClass = 2;
}
}
$NewClass = $post['classe'] + $UpClass;
//Check for wrong class numbers
if ($NewClass == 49 || $NewClass == 51 || $NewClass == 65 || $NewClass == 67 || $NewClass == 97 || $NewClass == 99) {
$NewClass--;
}
//Check for new classe values
if (isset($UserToolsChangeClassMode) && $UserToolsChangeClassMode == true) {
if ($NewClass == 2 || $NewClass == 18 || $NewClass == 34 || $NewClass == 82) {
$NewClass++;
}
}
/////////****************************************************
if ($SQLLevelMasterTable != "Character") {
$db->Query("DELETE FROM {$SQLLevelMasterTable} WHERE {$SQLNameMasterColumn} = '" . $post['char'] . "'");
} else {
$db->Query("UPDATE Character SET {$SQLLevelMasterColumn} = 0 WHERE Name = '" . $post['char'] . "'");
}
/*$db->Query("SELECT * FROM DefaultClassType WHERE Class = '$OriginalClass'");
$defaultData = $db->GetRow();*/
/*$db->Query("SELECT COLUMNPROPERTY( OBJECT_ID('dbo.DefaultClassType'),'MagicList','PRECISION'),COLUMNPROPERTY( OBJECT_ID('dbo.DefaultClassType'),'Quest','PRECISION')");
$data = $db->GetRow();
$MagicListSize = $data[0];
if(strlen($defaultData['MagicList']) == $MagicListSize)
$NewMagicList = bin2hex($defaultData['MagicList']);
else
$NewMagicList = $defaultData['MagicList'];
$QuestSize = $data[1];
if(strlen($defaultData['Quest']) == $QuestSize)
$NewQuest = bin2hex($defaultData['Quest']);
else
$NewQuest = $defaultData['Quest'];*/
$db->Query("UPDATE Character SET MagicList = (SELECT MagicList FROM DefaultClassType WHERE Class = '{$OriginalClass}'), Class = '{$NewClass}', Quest = (SELECT Quest FROM DefaultClassType WHERE Class = '{$OriginalClass}') WHERE Name = '" . $post['char'] . "'");
$acc->ReduceCredits($acc->memb___id, $UserToolsChangeClassCurrency, ${"UserToolsChangeClassAmountAL" . $acc->{$SQLVIPColumn}}, $db);
$db->Query("INSERT INTO Z_ChangeClassLog ([memb___id],[char],[fromClass],[toClass]) VALUES ('{$acc->memb___id}','" . $post['char'] . "','{$class}','{$NewClass}')");
$return = $UserToolsMsg57;
return $return;
}
}
if ($TopPKSwitch == 1) {
$db->Query("SELECT TOP 1 Name, AccountID, Z_RankPK FROM Character ORDER BY Z_RankPK DESC");
$data = $db->GetRow();
$TopPK = $data[0];
$TopPKAcc = $data[1];
}
if ($TopHeroSwitch == 1) {
$db->Query("SELECT TOP 1 Name, AccountID, Z_RankHR FROM Character ORDER BY Z_RankHR DESC");
$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>";
$main_content .= '<br/><center><form action="?subtopic=guilds" METHOD=post><div class="BigButton" style="background-image:url(' . $layout_name . '/images/buttons/sbutton.gif)" ><div onMouseOver="MouseOverBigButton(this);" onMouseOut="MouseOutBigButton(this);" ><div class="BigButtonOver" style="background-image:url(' . $layout_name . '/images/buttons/sbutton_over.gif);" ></div><input class="ButtonText" type="image" name="Back" alt="Back" src="' . $layout_name . '/images/buttons/_sbutton_back.gif" ></div></div></form></center>';
}
}
//-----------------------------------------------------------------------------//-----------------------------------------------------------------------------
//-----------------------------------------------------------------------------//-----------------------------------------------------------------------------
//-----------------------------------------------------------------------------//-----------------------------------------------------------------------------
//-----------------------------------------------------------------------------//-----------------------------------------------------------------------------
if ($action == 'guildwar_invite_guild') {
$guild_id = (int) $_REQUEST['guild'];
$enemy_id = (int) $_REQUEST['enemy'];
if (!$logged) {
$guild_errors[] = 'You are not logged.';
}
if (empty($guild_errors)) {
$guild = new Guild($guild_id);
$enemyGuild = new Guild($enemy_id);
if (!$guild->isLoaded() || !$enemyGuild->isLoaded()) {
$guild_errors[] = 'Guild with ID <b>' . $guild_id . '</b> or ID<b>' . $enemy_id . '</b> doesn\'t exist.';
}
if (empty($guild_errors)) {
$guild_leader_char = $guild->getOwner();
$guild_leader = FALSE;
$account_players = $account_logged->getPlayers();
foreach ($account_players as $player) {
if ($guild_leader_char->getId() == $player->getId()) {
$guild_leader = TRUE;
}
}
if ($guild_leader) {
if ($enemyGuild->getID() != $guild->getID()) {
$currentWars = array();
<?php
echo Character::getAllChars();
?>
</span>
</div>
<div class="stat-row">
<span class="type">
<?php
echo Yii::t('' . Yii::app()->request->cookies['language']->value . '', 'Total guilds');
?>
</span>
<span class="count">
<?php
echo Guild::getAGuilds();
?>
</span>
</div>
<div class="stat-row sm">
<span class="type">
<?php
echo Yii::t('' . Yii::app()->request->cookies['language']->value . '', 'Dark Wizards');
?>
</span>
<span class="count">
<?php
echo Character::getDwStat();
?>
<?php
require_once __DIR__ . '/../inc/header.php';
require_once __DIR__ . '/../inc/classes/guild.php';
$guild = new Guild();
$name = $_GET['name'];
$world = $_GET['world'];
if (!$guild->LoadByName($name, $world, CURRENT_LOCALE)) {
?>
<center>
<img src="//<?php
echo $domain;
?>
/inc/img/no-character.gif" />
<img src="//<?php
echo $domain;
?>
/inc/img/no-character.gif" />
<img src="//<?php
echo $domain;
?>
/inc/img/no-character.gif" />
<p>Guild '<?php
echo $name;
?>
' not found! The guild you are looking for was eaten by Horntail.</p>
</center>
<?php
require_once __DIR__ . '/../inc/footer.php';
die;
}
function members($params){
$guild = Guild::find()->where(array('guildid' => $params['id']))->realm($params['rid'])->first();
$find = Character::find()
->realm($guild->realm->id)
->join("INNER", 'guild_member' ,array('rank','guildid'),'guid')
->where(array('guild_member.guildid' => $guild->guildid))
->order('guild_member.rank');
if(isset($params['page'])) $find->page($params['page']);
$members = $find->all();
$members_count = $find->count();
$data = array(
'members' => $members,
'members_count' => $members_count
);
$this->render_partial("members",$data);
}
<?php
require_once $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "System/MuDatabase.class.php";
$db = new MuDatabase();
require_once $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "System/Account.class.php";
$acc = new Account($db);
require_once $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "System/Guild.class.php";
$gd = new Guild();
$getC = filter_input(INPUT_GET, 'c', FILTER_DEFAULT);
if ($getC == 'GuildInfo') {
$guild = '---';
}
if (substr_count($getC, "/") > 0) {
$url = explode("/", $getC);
$guild = $url[1];
}
$rank = null;
function PegarDadosChar($Name, $Termos)
{
require $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "Config/SQL.php";
require_once $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "System/MuDatabase.class.php";
$db = new MuDatabase();
require_once $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "System/Account.class.php";
$acc = new Account($db);
$db->Query("SELECT cLevel, {$SQLResetsColumn} FROM Character WHERE Name = '{$Name}'");
$data = $db->GetRow();
if ($Termos == 'resets') {
return $data['ResetCount'];
}
if ($Termos == 'level') {
return $data['cLevel'];
