diff options
| -rw-r--r-- | sql/updates/world/2011_06_14_00_world_misc.sql | 2 | ||||
| -rw-r--r-- | sql/updates/world/2011_06_14_02_world_misc.sql | 8 | ||||
| -rw-r--r-- | sql/updates/world/2011_06_14_03_world_npc_spellclick_spells.sql | 3 |
3 files changed, 8 insertions, 5 deletions
diff --git a/sql/updates/world/2011_06_14_00_world_misc.sql b/sql/updates/world/2011_06_14_00_world_misc.sql index 89b41f3586f..1300ffb2ae7 100644 --- a/sql/updates/world/2011_06_14_00_world_misc.sql +++ b/sql/updates/world/2011_06_14_00_world_misc.sql @@ -1,5 +1,5 @@ UPDATE `creature_template` set `VehicleId` = 129 WHERE `entry` = 28710; -UPDATE `creature_template` set `npcflag` = 0x1000000 WHERE `entry` IN (28710,29838,33114,33167,34161); +UPDATE `creature_template` set `npcflag`=`npcflag`|0x1000000 WHERE `entry` IN (28710,29838,33114,33167,34161); DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` IN (28710,29838,33114,33167,34161); INSERT INTO `npc_spellclick_spells` VALUES diff --git a/sql/updates/world/2011_06_14_02_world_misc.sql b/sql/updates/world/2011_06_14_02_world_misc.sql index e72cc11ac1f..46a981df4f7 100644 --- a/sql/updates/world/2011_06_14_02_world_misc.sql +++ b/sql/updates/world/2011_06_14_02_world_misc.sql @@ -6,9 +6,9 @@ UPDATE `creature_template` set `VehicleId` = 301 WHERE `entry` = 32344; UPDATE `creature_template` set `npcflag`=`npcflag`|0x1000000 WHERE `entry` IN (25762,27131,31110,31137,31157,31262,31406,31407,31408,31409,32490,31583,31830,31881,31884,32225,32227,32292,32344,37968); -DELETE FROM npc_spellclick_spells WHERE npc_entry IN +DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` IN (25762,27131,31110,31137,31157,31262,31406,31407,31408,31409,32490,31583,31830,31881,31884,32225,32227,32292,32344,37968); -INSERT INTO npc_spellclick_spells VALUES +INSERT INTO `npc_spellclick_spells` VALUES (25762,43671,0,0,0,1,0,0,0), (27131,48754,0,0,0,1,0,0,0), (31110,46598,0,0,0,1,0,0,0), -- maybe missed quest data @@ -31,9 +31,9 @@ INSERT INTO npc_spellclick_spells VALUES (32344,46598,0,0,0,1,0,0,0), (37968,46598,0,0,0,1,0,0,0); -DELETE FROM vehicle_template_accessory WHERE entry IN +DELETE FROM `vehicle_template_accessory` WHERE `entry` IN (29931,31262,31406,31583,31881,31884,32225,32227,32490,32344); -INSERT INTO vehicle_template_accessory VALUES +INSERT INTO `vehicle_template_accessory` VALUES (29931,29982,0,0,'Drakkari Rider on Drakkari Rhino',6,300), (29931,29982,1,0,'Drakkari Rider on Drakkari Rhino',6,300), (29931,29982,2,0,'Drakkari Rider on Drakkari Rhino',6,300), diff --git a/sql/updates/world/2011_06_14_03_world_npc_spellclick_spells.sql b/sql/updates/world/2011_06_14_03_world_npc_spellclick_spells.sql new file mode 100644 index 00000000000..400dafdf7de --- /dev/null +++ b/sql/updates/world/2011_06_14_03_world_npc_spellclick_spells.sql @@ -0,0 +1,3 @@ +DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` = 34793; +INSERT INTO `npc_spellclick_spells` VALUES +(34793,66245,0,0,0,1,0,0,0); |