Exemplo n.º 1
0
}
$query = "SELECT `item_name`, `item_buyer`, `item_value` FROM " . $addon_conf['DKPStats']['eqdkp_prefix'] . "items ORDER BY item_date DESC limit 50";
if ($roster_conf['sqldebug']) {
    print "<!-- {$query} -->\n";
}
echo border('syellow', 'start', $title);
// Make a table to hold the content
echo '<table cellpadding="0" cellspacing="0" width="250px" class="membersList">';
$result = $eqdkpdb->query($query) or die_quietly($eqdkpdb->error(), 'Database Error', basename(__FILE__), __LINE__, $query);
$rownum = 1;
while ($row = $eqdkpdb->fetch_array($result)) {
    // Open a new Row
    echo '<tr>';
    // Display the item in second column
    $loot_item = '[item]' . stripslashes($row['item_name']) . '[/item]';
    echo itemstats_parse('<td class="membersRow' . $rownum . '">' . utf8_decode($loot_item));
    // Check if char is in guild
    $gquery = 'SELECT member_id FROM ' . ROSTER_MEMBERSTABLE . ' WHERE name= \'' . $row['item_buyer'] . '\'';
    if ($roster_conf['sqldebug']) {
        print "<!-- {$gquery} -->\n";
    }
    $gid_result = $wowdb->query($gquery) or die_quietly($wowdb->error(), 'Database Error', basename(__FILE__), __LINE__, $gquery);
    $gid = $wowdb->fetch_array($gid_result);
    if ($gid[0] != '') {
        // Check if charinfo exists
        $query = 'SELECT member_id FROM ' . ROSTER_PLAYERSTABLE . ' WHERE name= \'' . $row['item_buyer'] . '\'';
        if ($roster_conf['sqldebug']) {
            print "<!-- {$query} -->\n";
        }
        $id_result = $wowdb->query($query) or die_quietly($wowdb->error(), 'Database Error', basename(__FILE__), __LINE__, $query);
        $id = $wowdb->fetch_array($id_result);
Exemplo n.º 2
0
function showLoot($color)
{
    global $wowdb, $roster_conf, $wordings, $rt_wordings, $db_prefix, $zone, $boss;
    // Check if we have a Zone Filter
    $zone_where = '';
    if ($zone != '') {
        $zone_where = ' AND zone = \'' . $zone . '\' ';
    }
    // Check if we have a Boss Filter
    $boss_where = '';
    if ($boss != '') {
        $boss_where = ' AND boss = \'' . $boss . '\' ';
    }
    // Check if their is loot
    $query = 'SELECT count(itemname) FROM `' . $db_prefix . 'raiditems` WHERE color = \'' . $color . '\'' . $zone_where . $boss_where . ' GROUP BY itemname ORDER BY color DESC, itemname ASC' . $limit;
    if ($roster_conf['sqldebug']) {
        print "<!-- {$query} -->\n";
    }
    $result = $wowdb->query($query) or die_quietly($wowdb->error(), 'Database Error', basename(__FILE__), __LINE__, $query);
    $loot_count = $wowdb->fetch_array($result);
    if ($loot_count['0'] != 0) {
        // Display the Top / left side of the Stylish Border
        echo border('syellow', 'start', $rt_wordings[$roster_conf['roster_lang']]['LootTypes'][$color]);
        // Make a table to hold the content
        echo '<table cellpadding="0" cellspacing="0" class="membersList">';
        // Check if we have a Zone Filter
        $zone_where = '';
        if ($zone != '') {
            $zone_where = ' AND zone = \'' . $zone . '\' ';
        }
        //$limit = ' limit 25';
        // Get all loot
        $query = 'SELECT itemname, name, number, loottime FROM `' . $db_prefix . 'raiditems` WHERE color = \'' . $color . '\'' . $zone_where . $boss_where . ' GROUP BY itemname ORDER BY itemname ASC' . $limit;
        if ($roster_conf['sqldebug']) {
            print "<!-- {$query} -->\n";
        }
        $result = $wowdb->query($query) or die_quietly($wowdb->error(), 'Database Error', basename(__FILE__), __LINE__, $query);
        $rownum = 1;
        while ($row = $wowdb->fetch_array($result)) {
            // Open a new Row
            echo '<tr>';
            // Display the loot
            $loot_item = '[item]' . $row['itemname'] . '[/item]';
            echo '<td class="membersRowRight' . $rownum . '">';
            echo itemstats_parse(utf8_decode($loot_item));
            // Display the count
            $count = 0;
            $cquery = 'SELECT number FROM `' . $db_prefix . 'raiditems` WHERE itemname = \'' . $wowdb->escape($row['itemname']) . '\'' . $boss_where;
            $cresult = $wowdb->query($cquery) or die_quietly($wowdb->error(), 'Database Error', basename(__FILE__), __LINE__, $cquery);
            while ($crow = $wowdb->fetch_array($cresult)) {
                $count += $crow['number'];
            }
            echo ' x' . $count . '</td>';
            // Close the Row
            echo '</tr>';
            switch ($rownum) {
                case 1:
                    $rownum = 2;
                    break;
                default:
                    $rownum = 1;
            }
        }
        // Add total loot at bottom
        $lquery = 'SELECT sum(number) FROM `' . $db_prefix . 'raiditems` WHERE color = \'' . $color . '\'';
        $lresult = $wowdb->query($lquery) or die_quietly($wowdb->error(), 'Database Error', basename(__FILE__), __LINE__, $lquery);
        $lrow = $wowdb->fetch_array($lresult);
        $tquery = 'SELECT sum(number) FROM `' . $db_prefix . 'raiditems` WHERE color = \'' . $color . '\'' . $zone_where . $boss_where;
        $tresult = $wowdb->query($tquery) or die_quietly($wowdb->error(), 'Database Error', basename(__FILE__), __LINE__, $tquery);
        $trow = $wowdb->fetch_array($tresult);
        echo '<tr><th class="membersHeaderRight">' . $rt_wordings[$roster_conf['roster_lang']]['TotalDrop'] . ': ' . $trow['0'] . ' | ' . $rt_wordings[$roster_conf['roster_lang']]['LootTypes'][$color] . ': ' . $lrow['0'] . '</th></tr>';
        // Close the table
        echo '</table>';
        // Display the Right side / Bottom of the Stylish Border
        echo border('syellow', 'end');
    }
}