echo '</table>';
}
// Create guild members list report
$show_fields = array('PL_REPORT_LEVEL', 'PL_REPORT_RACE', 'PL_REPORT_CLASS', 'PL_REPORT_NAME', 'PL_REPORT_GRANK', 'PL_REPORT_NOTE');
$members =& new PlayerReportGenerator('guild');
$members->disableMark();
$members->Init($show_fields, $FindRefrence, 'guildMembers', $config['fade_limit'], 'name');
$members->guildMembers($guildid);
$members->createReport($lang['guild_members']);
}
} else {
$page = intval(@$_REQUEST['page']);
$sort = @$_REQUEST['sort'];
$FindRefrence = "?guild";
$sortstr = "";
$rows = $cDB->selectPage($number, "SELECT *\n\t FROM `guild`\n\t LIMIT ?d, ?d", getPageOffset($page), $config['fade_limit']);
if ($rows) {
echo "<table class=report width=500>";
echo "<tbody>";
echo "<tr><td colspan=5 class=head>{$lang['guild_list']} {$number}</td></tr>\n";
// Делаем ссылку для сортировки
$SortRefrence = $FindRefrence;
if ($page > 1) {
$SortRefrence .= "&page={$page}";
}
echo "<tr>";
echo "<th></th>";
echo "<th width=100%>{$lang['guild_name']}</th>";
echo "<th>{$lang['guild_create']}</th>";
echo "<th>{$lang['guild_leader']}</th>";
echo "<th></th>";
$filter = substr($filter, 5);
// Sort method
$sort = @$_REQUEST['sort'];
$sort_str = " order by `name`";
if ($sort == "name") {
$sort_str = " order by `name`";
} else {
if ($sort == "id") {
$sort_str = " order by `id`";
} else {
$sort_str = " order by `name`";
}
}
$rows = 0;
if ($filter != "") {
$rows = $wDB->selectPage($number, "SELECT * FROM `wowd_itemset` WHERE\n{$filter}\n{$sort_str} LIMIT ?d, ?d", getPageOffset($page), $config['fade_limit']);
}
if (!$rows || $number == 0) {
echo $lang['not_found'];
} else {
echo "<table class=report width=500>\n";
echo "<tbody>\n";
echo "<tr><td colspan=4 class=head>{$lang['item_set']}</td></tr>\n";
// Делаем ссылку для сортировки
$SortRefrence = $FindRefrence;
if ($page > 1) {
$SortRefrence .= "&page={$page}";
}
echo "<tr>";
echo "<th><a href=\"{$SortRefrence}\">{$lang['set_name']}</a></th>";
echo "<th width=260px>Items</th>";
include_once "include/functions.php";
$page = intval(@$_REQUEST['page']);
$type = @$_REQUEST['auction'];
switch ($type) {
case "Alliance":
$houseid = "(houseid=1 or houseid=2 or houseid=3)";
break;
case "Horde":
$houseid = "(houseid=4 or houseid=5 or houseid=6)";
break;
default:
$type = "Blackwater";
$houseid = "(houseid=7)";
break;
}
$rows = $cDB->selectPage($number, "SELECT\n`auction`.`id`,\n`auction`.`itemguid`,\n`auction`.`item_template`,\n`auction`.`itemowner`,\n`auction`.`buyoutprice`,\n`auction`.`time`,\n`auction`.`buyguid`,\n`auction`.`lastbid`,\n`auction`.`startbid`,\n`auction`.`deposit`,\n`auction`.`houseid`,\n\n(SUBSTRING_INDEX( SUBSTRING_INDEX(`item_instance`.`data` , ' ' , ?d) , ' ' , -1 )+0) AS `itementry`,\n`item_instance`.`data`,\n`item_instance`.`owner_guid`\nFROM\n `auction`\n left join\n `item_instance`\n ON `auction`.`itemguid` = `item_instance`.`guid`\nWHERE\n {$houseid}\nLIMIT ?d, ?d", ITEM_FIELD_ENTRY + 1, getPageOffset($page), $config['fade_limit']);
echo "<table class=report width=500>";
echo "<tbody>";
echo "<tr><td colspan=4 class=head>";
echo "<img src=\"images/gold.gif\">";
echo "<a href=\"?auction=Alliance\" style=\"Text-decoration: none; color:gold;\"> {$lang['Alliance']} </a>";
echo "<img src=\"images/gold.gif\">";
echo "<a href=\"?auction=Horde\" style=\"Text-decoration: none; color:gold;\"> {$lang['Horde']} </a>";
echo "<img src=\"images/gold.gif\">";
echo "<a href=\"?auction=Blackwater\" style=\"Text-decoration: none; color:gold;\"> {$lang['Blackwater']} </a>";
echo "<img src=\"images/gold.gif\">";
echo "</td></tr>";
if ($rows) {
echo "<tr><td colspan=4 class=head>{$number} {$lang['items']}</td></tr>";
echo "<tr>";
echo "<th width=1px></th>";