예제 #1
0
            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>";
예제 #2
0
$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>";
예제 #3
0
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;\">&nbsp;{$lang['Alliance']}&nbsp;</a>";
echo "<img src=\"images/gold.gif\">";
echo "<a href=\"?auction=Horde\" style=\"Text-decoration: none; color:gold;\">&nbsp;{$lang['Horde']}&nbsp;</a>";
echo "<img src=\"images/gold.gif\">";
echo "<a href=\"?auction=Blackwater\" style=\"Text-decoration: none; color:gold;\">&nbsp;{$lang['Blackwater']}&nbsp;</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>";