03-06-2014, 01:39 PM
|
|
Project Manager
Join Date: Oct 2009
Posts: 14,645
|
|
Quote:
select i.id,i.name,i.maxcharges from items i left join lootdrop_entries le on (le.item_id = i.id) where i.maxcharges > '0' and i.maxcharges <> le.item_charges
25205 Iron Scroll of War 2 1
30106 Woven Frost Giant Beard 5 1
25648 Crystalline Silk Net 2 1
30108 Braided Beard of the Coldain 5 1
10380 Rod of Drones 5 1
|
Fixed, pending update |
|
|
|