diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/2014_06_26_02_world_misc.sql | 7 | ||||
| -rw-r--r-- | sql/updates/world/2014_06_27_00_world_misc.sql | 4 | ||||
| -rw-r--r-- | sql/updates/world/2014_06_27_00_world_smart_scripts.sql | 8 |
3 files changed, 19 insertions, 0 deletions
diff --git a/sql/updates/world/2014_06_26_02_world_misc.sql b/sql/updates/world/2014_06_26_02_world_misc.sql new file mode 100644 index 00000000000..dade11c549d --- /dev/null +++ b/sql/updates/world/2014_06_26_02_world_misc.sql @@ -0,0 +1,7 @@ +-- Pure Energy +SET @ENTRY := 24745; +UPDATE `creature_template` SET `flags_extra`=0 WHERE `entry`=@ENTRY; + +DELETE FROM `creature_template_addon` WHERE `entry`=@ENTRY; +INSERT INTO `creature_template_addon` (`entry`, `mount`, `bytes1`, `bytes2`, `auras`) VALUES +(@ENTRY, 0, 0x0, 0x0, '44326 46156'); diff --git a/sql/updates/world/2014_06_27_00_world_misc.sql b/sql/updates/world/2014_06_27_00_world_misc.sql new file mode 100644 index 00000000000..275ecbbf4a0 --- /dev/null +++ b/sql/updates/world/2014_06_27_00_world_misc.sql @@ -0,0 +1,4 @@ +-- +UPDATE `creature` SET `equipment_id`=0 WHERE `equipment_id`=86 AND `id`=24484; +DELETE FROM `creature_addon` WHERE `guid`=97892; +UPDATE `smart_scripts` SET `link`=0 WHERE `entryorguid`=-126866 AND `source_type`=0 AND `id` IN (7,15); diff --git a/sql/updates/world/2014_06_27_00_world_smart_scripts.sql b/sql/updates/world/2014_06_27_00_world_smart_scripts.sql new file mode 100644 index 00000000000..e1340a68a62 --- /dev/null +++ b/sql/updates/world/2014_06_27_00_world_smart_scripts.sql @@ -0,0 +1,8 @@ +-- +UPDATE `smart_scripts` SET `target_type`=1 WHERE `entryorguid`=27899 AND `source_type`=0 AND `id`=25 AND `link`=0; +UPDATE `smart_scripts` SET `target_type`=1 WHERE `entryorguid`=25773 AND `source_type`=0 AND `id`=2 AND `link`=0; +UPDATE `smart_scripts` SET `target_type`=1 WHERE `entryorguid`=30135 AND `source_type`=0 AND `id`=2 AND `link`=0; +UPDATE `smart_scripts` SET `target_type`=1 WHERE `entryorguid`=29974 AND `source_type`=0 AND `id`=2 AND `link`=0; +UPDATE `smart_scripts` SET `target_type`=1 WHERE `entryorguid`=17299 AND `source_type`=0 AND `id`=0 AND `link`=0; +UPDATE `smart_scripts` SET `target_type`=1 WHERE `entryorguid`=2719901 AND `source_type`=9 AND `id`=7 AND `link`=0; +UPDATE `smart_scripts` SET `target_type`=1 WHERE `entryorguid`=30144 AND `source_type`=0 AND `id`=2 AND `link`=0; |