diff options
author | Dr-J <daniel.jarrott0@gmail.com> | 2016-05-30 14:34:32 +0200 |
---|---|---|
committer | joschiwald <joschiwald.trinity@gmail.com> | 2017-01-11 20:13:03 +0100 |
commit | 58e7aff4dd3240e080e86b798b825945807c645e (patch) | |
tree | e16c41a02ebcb166642b295ad3c80265758da83e | |
parent | 521fa25642e6c374221a4d4674cecbb3d7ed6b6b (diff) |
DB/Misc: Miscellenous Fixes
1) Fix http://www.wowhead.com/quest=1144/willix-the-importer so this quest does not complete as soon as taken so that players actually have to do the escort before been able to return quest
2) Remove XP at kill from several creatures which dont give xp on retail
3) Put alliance/horde versions of Reigns of the Grand War Mammoth (VOA) into seperate loot groups so chance for drop is actually 1% rather than been 1% chance of reference loot been called then been a 50/50 chance of which factions mount dropped which in fact reduced chance to 0.5% as if opposite factions dropped then not visible
4) Update to text target for one text from Rohin the Decaying
5) Move spell focus for http://www.wowhead.com/quest=12569/crocolisk-mastery-the-ambush so its on top of log and not behind it so position matches doing quest on retail
(cherry picked from commit f941dad158a4bce837e5ab89d4af5502b33570b7)
-rw-r--r-- | sql/updates/world/master/2017_01_11_03_world_2016_05_30_09_world.sql | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_01_11_03_world_2016_05_30_09_world.sql b/sql/updates/world/master/2017_01_11_03_world_2016_05_30_09_world.sql new file mode 100644 index 00000000000..38f95ee6c0b --- /dev/null +++ b/sql/updates/world/master/2017_01_11_03_world_2016_05_30_09_world.sql @@ -0,0 +1,5 @@ +-- UPDATE `quest_template_addon` SET `SpecialFlags`=2 WHERE `ID`=1144; +UPDATE `creature_template` SET `flags_extra`=64 WHERE `entry` IN(28111,28112,28078,28079,23667, 23668, 32669,28844,28843,24199,24198,23564); +UPDATE `reference_loot_template` SET `GroupId`=2 WHERE `Entry`=34203 AND `Item`=43959; +UPDATE `smart_scripts` SET `target_type`=12, `target_param1`=1 WHERE `entryorguid`=2735500 AND `source_type`=9 AND `id`=5 AND `link`=0; +UPDATE `gameobject` SET `position_x`=5445.057129, `position_y`=4908.831543, `position_z`=-189.508224 WHERE `guid`=99748; |