aboutsummaryrefslogtreecommitdiff
path: root/src/server/game/Handlers/AddonHandler.cpp
diff options
context:
space:
mode:
authorNay <dnpd.dd@gmail.com>2013-01-29 23:48:39 +0000
committerNay <dnpd.dd@gmail.com>2013-01-29 23:48:39 +0000
commit02814975732f8e919d33ff8f2cbaf98f13e04f91 (patch)
treee90f89cdda5ff863dbd248e718f52c54e6506c0f /src/server/game/Handlers/AddonHandler.cpp
parentea9c6524dd4209c0074faecdf48d53b006fe6f5d (diff)
DB/Loot: Fix 9 drop chance in gameobject_template (7 quests should be fixed by this)
If a GO with flags 4 drops a quest item, ChanceOrQuestChance for that items needs to be negative Query used to find the issue: ``` SELECT * FROM `gameobject_loot_template` WHERE (`item` IN (SELECT `questItem1` FROM `gameobject_template` WHERE (`flags` & 4) != 0) OR `item` IN (SELECT `questItem2` FROM `gameobject_template` WHERE (`flags` & 4) != 0) OR `item` IN (SELECT `questItem3` FROM `gameobject_template` WHERE (`flags` & 4) != 0) OR `item` IN (SELECT `questItem4` FROM `gameobject_template` WHERE (`flags` & 4) != 0) OR `item` IN (SELECT `questItem5` FROM `gameobject_template` WHERE (`flags` & 4) != 0) OR `item` IN (SELECT `questItem6` FROM `gameobject_template` WHERE (`flags` & 4) != 0)) AND `ChanceOrQuestChance` > 0; ```
Diffstat (limited to 'src/server/game/Handlers/AddonHandler.cpp')
0 files changed, 0 insertions, 0 deletions