function start()
{
global $mysql, $_SYSTEM;
$WHERE = "WHERE ";
if ($this->guild > 0) {
$WHERE .= SQL_template(CHAR_GUILD_OFFSET) . ' = ' . $this->guild . ' AND ';
}
if ($this->guid > 0) {
$WHERE .= 'characters.guid = ' . $this->guid . ' AND ';
}
if ($this->class != 0) {
$WHERE .= 'characters.class = ' . $this->class . ' AND ';
}
if ($this->name != '') {
$WHERE .= 'name LIKE \'%' . $this->name . '%\' AND ';
}
$WHERE .= '1=1';
$il = $this->per_page + 1;
$st = $this->per_page * $this->page;
$LIMIT = 'LIMIT ' . $st . ', ' . $il;
$data = array();
$i = 0;
foreach ($_SYSTEM->Realms as $rID => $rName) {
if ($this->Realm != -1 && $rID != $this->Realm) {
continue;
}
$d = $mysql->getRows("SELECT characters.name,characters.race,characters.class,characters.guid,characters.online,\n\t\t\t\tguild_rank.rname,?1 AS level,?2 AS guild,?3 AS honor,?4 AS hk,?5 as gender\n FROM `characters` left join `guild_rank` on ?6 = guild_rank.rid and ?7 = guild_rank.guildid\n\t\t\t\t{$WHERE} {$this->order} {$LIMIT}", SQL_template(CHAR_LEVEL_OFFSET), SQL_template(CHAR_GUILD_OFFSET), SQL_template(CHAR_HONOR_OFFSET), SQL_template(CHAR_HK_OFFSET), CHAR_GENDER_OFFSET, SQL_template(CHAR_GUILD_OFFSET + 1), SQL_template(CHAR_GUILD_OFFSET), 'char_' . $rID);
if (!$d) {
continue;
}
$c = $mysql->query("select count(*) from characters {$WHERE}", 'char_' . $rID);
$this->count += mysql_result($c, 0);
foreach ($d as $char) {
foreach ($char as $key => $value) {
$data[$i][$key] = $value;
}
if ($data[$i]['guild'] == 0) {
$data[$i]['guild'] = 'None';
$data[$i]['guildid'] = 0;
} else {
$g = guild($data[$i]['guild']);
$data[$i]['guild'] = $g->name;
$data[$i]['guildid'] = $g->id;
}
$data[$i]['race_string'] = character::raceToString($data[$i]['race']);
$data[$i]['class_string'] = character::classToString($data[$i]['class']);
if ($data[$i]['honor'] > 2000000000) {
$data[$i]['honor'] = 0;
}
$data[$i]['realm'] = $rName;
$i++;
}
}
return $data;
}
<?php
if ($_GET['name']) {
if (!(int) $_GET['name']) {
$data = $mysql->getRow("select guid from characters where name = '?1'", $_GET['name'], 'char');
$_GET['name'] = (int) $data['guid'];
}
}
$character = character((int) $_GET['name']);
$tp->assign('guid', $character->guid);
$tp->assign('name', $character->name);
$tp->assign('guid', $character->guid);
$tp->assign('level', $character->level);
$tp->assign('portrait_type', $character->level == 80 ? '-80' : ($character->level >= 70 ? '-70' : ($character->level >= 60 ? '' : '-default')));
$tp->assign('faction_name', $character->getAlliance() ? 'horde' : 'alliance');
$race = character::raceToString($character->race);
$tp->assign('race', $race);
if (strtolower($race) == 'undead') {
$race = 'scourge';
}
$tp->assign('race3D', strtolower(str_replace(' ', '', $race)));
$tp->assign('class', $character->classToString($character->class));
$tp->assign('gender_nr', $character->gender);
$tp->assign('gender3D', $character->gender ? 'female' : 'male');
$tp->assign('race_nr', $character->race);
$tp->assign('class_nr', $character->class);
$tp->assign('guild', $character->guild_id ? '<a class="charGuildName" href="guild-info.php?Realm={$realm}&name=' . $character->guild . '&characterName=' . $character->name . '">' . $character->guild . '</a>' : '');
$tp->assign('guildname', $character->guild);
$tp->assign('guildtabdisplay', $character->guild_id ? '' : 'style="display:none;"');
$tp->assign('arenatabdisplay', $character->arena_team[2]['name'] || $character->arena_team[3]['name'] || $character->arena_team[5]['name'] ? '' : 'style="display:none;"');
$tp->assign('guild_name', $character->guild_id ? $character->guild : 'None');
$tp->assign('place', $place);
$tp->assign('rank_border', $rank[2]);
$tp->assign('wg', $r['games']);
$tp->assign('ww', $r['wins']);
$tp->assign('wl', $r['games'] - $r['wins']);
$tp->assign('wp', $r['games'] ? round($r['wins'] / $r['games'] * 100) : 0);
$tp->assign('wr', $r['rating']);
$tp->assign('sg', $r['played']);
$tp->assign('sw', $r['wins2']);
$tp->assign('sl', $r['played'] - $r['wins2']);
$tp->assign('sp', $r['played'] ? round($r['wins2'] / $r['played'] * 100) : 0);
$icon = getSmallArenaIcon($r);
$tp->assign('icon', $icon);
$m = $mysql->getRows("select arena_team_member.*,characters.name,characters.race,characters.class,?3 as level,?4 as gender,guild.name as gname from arena_team_member inner join characters on arena_team_member.guid= characters.guid left join guild on guild.guildid = ?2 where arena_team_member.arenateamid = ?1", $r['arenateamid'], SQL_template(CHAR_GUILD_OFFSET), SQL_template(CHAR_LEVEL_OFFSET), CHAR_GENDER_OFFSET, 'char');
if ($m) {
foreach ($m as $member) {
$team_faction = character::getAlliance($member['race']);
$table .= '<tr><td><a href="character-sheet.php?Realm={$realm}&name=' . $member['name'] . '">' . $member['name'] . '</a></td>';
$table .= '<td>' . ($member['gname'] ? '<a href="guild-info.php?Realm={$realm}&name=' . $member['gname'] . '">' . $member['gname'] . '</a>' : 'None') . '</td>';
$table .= '<td><img class="staticTip" onmouseover="setTipText(\'' . character::raceToString($member['race']) . '\');" src="images/icons/race/' . $member['race'] . '-' . $member['gender'] . '.gif"> <img class="staticTip" onmouseover="setTipText(\'' . character::classToString($member['class']) . '\');" src="images/icons/class/' . $member['class'] . '.gif"></td>';
$table .= '<td class="rightNum">' . $member['played_season'] . '</td><td class="rightNum" style="color: #678705;">' . $member['wons_season'] . '</td><td class="rightNum" style="color: #9A1401;">' . ($member['played_season'] - $member['wons_season']) . '</td><td class="rightNum">' . ($member['played_season'] ? round($member['wons_season'] / $member['played_season'] * 100) : 0) . '%</td><td class="rightNum">' . $member['personal_rating'] . '</td></tr>';
}
} else {
$table = '<tr><td colspan="8">No members</td></tr>';
}
$tp->assign('table', $table);
$tp->assign('faction', $team_faction);
$tp->assign('realm', $_SYSTEM->Realms[$_SYSTEM->Realm]);
$c->assign('content', $tp->output);
$c->display();
$_SYSTEM->printFooter();
function start()
{
global $mysql, $_SYSTEM;
$WHERE = "WHERE ";
if ($this->guild > 0) {
$WHERE .= 'guild_member.guildid = ' . $this->guild . ' AND ';
}
if ($this->guid > 0) {
$WHERE .= 'characters.guid = ' . $this->guid . ' AND ';
}
if ($this->class != 0) {
$WHERE .= 'characters.class = ' . $this->class . ' AND ';
}
if ($this->name != '') {
$WHERE .= 'characters.name LIKE \'%' . $this->name . '%\' AND ';
}
$WHERE .= '1=1';
$il = $this->per_page;
$st = $this->per_page * $this->page;
$LIMIT = 'LIMIT ' . $st . ', ' . $il;
$data = array();
$i = 0;
foreach ($_SYSTEM->Realms as $rID => $rName) {
if ($this->Realm != -1 && $rID != $this->Realm) {
continue;
}
$d = $mysql->getRows("SELECT characters.name,characters.race,characters.class,characters.guid,characters.online,\n\t\t\t\tguild_rank.rname,guild_rank.rid,?1 AS level,guild_member.guildid AS guildid,totalHonorPoints as honor,totalKills as hk,?3 as gender,guild.name as guild\n FROM `characters` left join guild_member on characters.guid = guild_member.guid\n left join guild on guild.guildid = guild_member.guildid\n left join `guild_rank` on guild_member.rank = guild_rank.rid and guild_member.guildid = guild_rank.guildid\n\t\t\t\t{$WHERE} {$this->order} {$LIMIT}", SQL_template(CHAR_LEVEL_OFFSET), SQL_template(CHAR_GUILD_OFFSET), CHAR_GENDER_OFFSET, SQL_template(CHAR_GUILD_OFFSET + 1), 'char_' . $rID);
if (!$d) {
continue;
}
$c = $mysql->query("select count(*) from characters left join guild_member on characters.guid = guild_member.guid\n left join guild on guild.guildid = guild_member.guildid\n left join `guild_rank` on guild_member.rank = guild_rank.rid and guild_member.guildid = guild_rank.guildid {$WHERE}", 'char_' . $rID);
$this->count += mysql_result($c, 0);
foreach ($d as $char) {
foreach ($char as $key => $value) {
$data[$i][$key] = $value;
}
if ($data[$i]['guildid'] == 0) {
$data[$i]['guild'] = ' None';
$data[$i]['guildid'] = 0;
} else {
if ($data[$i]['rid'] == '') {
//$v = $mysql->getRow("select rname from guild_rank where rid = '1' and guildid = ?1",$this->guild,'char_'.$rID);
$data[$i]['rname'] = 'Guild Master';
$data[$i]['rid'] = '0';
}
}
$data[$i]['race_string'] = character::raceToString($data[$i]['race']);
$data[$i]['class_string'] = character::classToString($data[$i]['class']);
if ($data[$i]['honor'] > 2000000000) {
$data[$i]['honor'] = 0;
}
$data[$i]['realm'] = $rName;
$i++;
}
}
return $data;
}
<?php
$tp = new template();
$tp->add('guild');
$guild = guild($_GET['guild']);
if ($guild->id == -1) {
$_SYSTEM->error('Guild not found!');
}
$tp->assign('name', $guild->name);
$tp->assign('gm_id', $guild->leader_id);
$tp->assign('gm', $guild->leader);
$tp->assign('faction', $guild->faction ? $_LANGUAGE->text['horde'] : $_LANGUAGE->text['alliance']);
$tp->assign('alliance', $guild->faction);
$tp->assign('gender_nr', $guild->leader_gender);
$tp->assign('members', $guild->members);
$tp->assign('race_nr', $guild->leader_race);
$tp->assign('class_nr', $guild->leader_class);
$tp->assign('realm', $guild->realm);
$tp->assign('realmid', $guild->realmID);
$tp->assign('race', $_LANGUAGE->text[character::raceToString($guild->leader_race)]);
$tp->assign('class', $_LANGUAGE->text[character::classToString($guild->leader_class)]);
$_LANGUAGE->translate($tp);
$tp->display();
//$tp->add('table');
$tp->add('pvp_table');
$s = new search_character();
$s->set_sort('hk', 1);
$s->per_page = 50;
$s->Realm = $_SYSTEM->Realm;
$data = $s->start();
$realms = '<h2>PvP Top 50: <i>' . $_SYSTEM->Realms[$_SYSTEM->Realm] . '</i></h2>
<span class="page-subheader">(Realms: ';
foreach ($_SYSTEM->Realms as $key => $value) {
$realms .= '<a href="' . $_DOMAIN . 'index.php?act=pvp&Realm=' . $value . '">' . $value . '</a> |';
}
$tp->assign('realms', substr($realms, 0, -1) . ')</span>');
$i = 1;
foreach ($data as $char) {
$add .= '<tr class="csearch-results-table-item"><td class="">' . $i++ . '.</td>
<td class=""><img alt="" src="' . $_DOMAIN . 'images/icons/' . character::getAlliance($char['race']) . '.png"> <a href="' . $_DOMAIN . 'index.php?character=' . $char['guid'] . '&Realm=' . $char['realm'] . '">' . $char['name'] . '</a></td>
<td class="">' . $char['level'] . '</td>
<td class="rightalign nopadding">
<img onMouseOut="tooltip_hide()" onMouseOver="tooltip(\'' . $_LANGUAGE->text[character::raceToString($char['race'])] . '\')" alt="" src="' . $_DOMAIN . 'images/icons/race/' . $char['race'] . '-' . $char['gender'] . '.gif"></td>
<td class="leftalign nopadding">
<img onMouseOut="tooltip_hide()" onMouseOver="tooltip(\'' . $_LANGUAGE->text[character::classToString($char['class'])] . '\')" alt="" src="' . $_DOMAIN . 'images/icons/class/' . $char['class'] . '.gif"></td>
<td class="">' . ($char['guildid'] ? '<a href="' . $_DOMAIN . 'index.php?guild=' . $char['guildid'] . '">' : '') . $char['guild'] . ($char['guildid'] ? '</a>' : '') . '</td>
<td class="">' . $char['hk'] . '</td>
<td class="">' . $char['honor'] . '</td>
</tr>';
}
$tp->assign('ranking', $add);
$_LANGUAGE->translate($tp);
$tp->display();
