} $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);
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'); } }