diff options
| author | Vincent-Michael <Vincent_Michael@gmx.de> | 2014-06-27 19:39:23 +0200 |
|---|---|---|
| committer | Vincent-Michael <Vincent_Michael@gmx.de> | 2014-06-27 19:39:23 +0200 |
| commit | f3de6f028403b6b6eb59b8cb59cb15419ea47932 (patch) | |
| tree | 0b391c0e5c2c344bfb661e42cbd8a680735c9f8e /sql | |
| parent | a2b860b7814ca216565a432e07579dd77f004a86 (diff) | |
| parent | 52023b1e6b1fefaf4be95fa201fc1dd2ecca55a7 (diff) | |
Merge branch 'master' of github.com:TrinityCore/TrinityCore into 4.3.4
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; |