<div class="table_header"> Guild Search Results </div> <div class="table_content"> <?php if ($results != '') { ?> <?php foreach ($results as $result) { extract($result); ?> <a href="index.php?editor=guild&guildid=<?php echo $guild_id; ?> "><?php echo getPlayerName($char_id) . " (" . $char_id . ") - " . getGuildName($guild_id) . " (" . $guild_id . ")" . "</a><br />"; ?> <?php } ?> <?php } ?> <?php if ($results == '') { ?> Your search produced no results! <?php } ?> </div>
echo $z; ?> <br/> Heading: <?php echo $heading; ?> <br/> <center>[<a href="index.php?editor=player&playerid=<?php echo $id; ?> &action=5">Move Player</a>]</center> </fieldset> <fieldset> <legend><strong>Guild Info</strong></legend> Guild: <?php echo $guild_id > 0 ? '<a href="index.php?editor=guild&guildid=' . $guild_id . '">' . getGuildName($guild_id) . '</a>' : "None"; ?> <br/> Guild Rank: <?php echo $guild_id > 0 ? $guild_rank : "N/A"; ?> <br/> Guild Banker: <?php echo $guild_id > 0 ? $yesno[$guild_banker] : "N/A"; ?> <br/> </fieldset> <fieldset> <legend><strong>Vitals</strong></legend> HP: <?php echo $cur_hp;
} if ($npcid != '' && $npcid != 'ID' && $editor != 'altcur' && $editor != 'qglobal') { $breadcrumbs .= " >> " . getNPCName($npcid) . " ({$npcid})"; } if ($fid != '') { $breadcrumbs .= " >> " . getFactionName($fid); } if ($tskid != '') { $breadcrumbs .= " >> " . getTaskTitle($tskid); } if ($ts != '') { $breadcrumbs .= " >> " . "<a href='index.php?editor=" . $editor . "&ts=" . $ts . "'>" . $tradeskills[$ts] . "</a>"; } if ($rec != '0') { $breadcrumbs .= " >> " . getRecipeName($rec); } if ($spellset != '') { $breadcrumbs .= " >> " . getSpellsetName($spellset); } if ($playerid != '' && $playerid != 'Player ID') { $breadcrumbs .= " >> <a href='index.php?editor=" . $editor . "&playerid=" . $playerid . "'>" . getPlayerName($playerid) . " ({$playerid})</a>"; } if ($acctid != '') { $breadcrumbs .= " >> " . getAccountName($acctid) . " ({$acctid})"; } if ($guildid != '') { $breadcrumbs .= " >> " . getGuildName($guildid) . " ({$guildid})"; } if ($aaid != '') { $breadcrumbs .= " >> " . getAAName($aaid) . " ({$aaid})"; }
function getTop100Players() { global $db, $players_group_and_order, $armory_url, $ALLIANCE, $HORDE, $ALLIANCE_RACES, $HORDE_RACES; $query = sprintf("SELECT character_guid, count(character_guid) AS count, characters.name as character_name, characters.level as character_level FROM pvpstats_players INNER JOIN pvpstats_battlegrounds ON pvpstats_players.battleground_id = pvpstats_battlegrounds.id INNER JOIN characters ON pvpstats_players.character_guid = characters.guid WHERE characters.deleteDate IS NULL AND pvpstats_players.winner = 1 %s LIMIT 0,100", $players_group_and_order); $result = $db->query($query); if (!$result) { die("Error querying: " . $query); } $row = $result->fetch_array(); if ($row == null) { return; } $position = 1; if (!isset($armory_url) || $armory_url == "") { $player_name = sprintf("<span style=\"color: %s; \"><strong>%s</strong></a>", getPlayerColor($row['character_guid']), $row['character_name']); } else { $player_name = sprintf("<a style=\"color: %s; \" target=\"_blank\" href=\"%s%s\"><strong>%s</strong></a>", getPlayerColor($row['character_guid']), $armory_url, $row['character_name'], $row['character_name']); } $player_guild = getPlayerGuild($row['character_guid']); $guild_name = getGuildName($player_guild); printf("<tr><td>%d</td><td>%s</td><td style=\"min-width: 46px; padding-left: 0; padding-right: 0;\"><img src=\"img/class/%d.gif\"> <img src=\"img/race/%d-%d.gif\"></td><td>%s</td><td><strong><a href=\"#%s\"><span style=\"color: %s\">%s</span></a></strong></td><td>%d</td></tr>", $position, $player_name, getPlayerClass($row['character_guid']), getPlayerRace($row['character_guid']), getPlayerGender($row['character_guid']), $row['character_level'], $guild_name, getGuildColor($player_guild), $guild_name, $row['count']); $prev_score = $row['count']; if (!isset($armory_url) || $armory_url == "") { while (($row = $result->fetch_array()) != null) { if ($prev_score != $row['count']) { $position++; } $player_name = sprintf("<span style=\"color: %s; \"><strong>%s</strong></a>", getPlayerColor($row['character_guid']), $row['character_name']); $player_guild = getPlayerGuild($row['character_guid']); $guild_name = getGuildName($player_guild); printf("<tr><td>%d</td><td>%s</td><td style=\"min-width: 46px; padding-left: 0; padding-right: 0;\"><img src=\"img/class/%d.gif\"> <img src=\"img/race/%d-%d.gif\"></td><td>%s</td><td><strong><a href=\"#%s\"><span style=\"color: %s\">%s</span></a></strong></td><td>%d</td></tr>", $position, $player_name, getPlayerClass($row['character_guid']), getPlayerRace($row['character_guid']), getPlayerGender($row['character_guid']), $row['character_level'], $guild_name, getGuildColor($player_guild), $guild_name, $row['count']); $prev_score = $row['count']; } } else { while (($row = $result->fetch_array()) != null) { if ($prev_score != $row['count']) { $position++; } $player_name = sprintf("<a style=\"color: %s; \" target=\"_blank\" href=\"%s%s\"><strong>%s</strong></a>", getPlayerColor($row['character_guid']), $armory_url, $row['character_name'], $row['character_name']); $player_guild = getPlayerGuild($row['character_guid']); $guild_name = getGuildName($player_guild); printf("<tr><td>%d</td><td>%s</td><td style=\"min-width: 46px; padding-left: 0; padding-right: 0;\"><img src=\"img/class/%d.gif\"> <img src=\"img/race/%d-%d.gif\"></td><td>%s</td><td><strong><a href=\"#%s\"><span style=\"color: %s\">%s</span></a></strong></td><td>%d</td></tr>", $position, $player_name, getPlayerClass($row['character_guid']), getPlayerRace($row['character_guid']), getPlayerGender($row['character_guid']), $row['character_level'], $guild_name, getGuildColor($player_guild), $guild_name, $row['count']); $prev_score = $row['count']; } } }
if ($vars) { foreach ($vars as $key => $value) { $body->set($key, $value); } } } else { $body = new Template("templates/guild/guild.default.tmpl.php"); } break; case 1: // Edit Guild Info check_admin_authorization(); $body = new Template("templates/guild/guild.edit.tmpl.php"); $body->set('guildid', $guildid); $body->set('yesno', $yesno); $body->set('guildname', getGuildName($guildid)); $vars = guild_info(); if ($vars) { foreach ($vars as $key => $value) { $body->set($key, $value); } } break; case 2: // Search Guilds check_admin_authorization(); $body = new Template("templates/guild/guild.searchresults.byguild.tmpl.php"); if (isset($_GET['guild_id']) && $_GET['guild_id'] != "Guild ID") { $results = search_guilds_by_id(); } elseif (isset($_GET['search']) && $_GET['search'] != "Guild Name" && $_GET['search'] != '') { $results = search_guilds();