diff options
| author | Vincent-Michael <Vincent_Michael@gmx.de> | 2014-07-07 09:58:43 +0200 |
|---|---|---|
| committer | Vincent-Michael <Vincent_Michael@gmx.de> | 2014-07-07 09:58:43 +0200 |
| commit | 9799a88c8dcc450ef827e52ddcd04172c9a9b8ce (patch) | |
| tree | b3e270a2ce3c1fca8d94f27c465d70988734ee0d /sql | |
| parent | 79286ef743e23250d194da225f93dad9686ac202 (diff) | |
| parent | a6494375f9839b8c428c8daa508b9ca93caa0575 (diff) | |
Merge branch 'master' of github.com:TrinityCore/TrinityCore into 4.3.4
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/2014_07_06_01_world_misc.sql | 10 | ||||
| -rw-r--r-- | sql/updates/world/2014_07_06_02_world_misc.sql | 4 |
2 files changed, 14 insertions, 0 deletions
diff --git a/sql/updates/world/2014_07_06_01_world_misc.sql b/sql/updates/world/2014_07_06_01_world_misc.sql new file mode 100644 index 00000000000..ff7e226bdd9 --- /dev/null +++ b/sql/updates/world/2014_07_06_01_world_misc.sql @@ -0,0 +1,10 @@ +-- +SET @GUID=5412; + +DELETE FROM `gameobject` WHERE `id`=188367; +INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES +(@GUID,188367,571,1,1,5048.28,-4817.63,219.778,2.49582,0,0,0,1,-60,255,1,0); + +DELETE FROM `event_scripts` WHERE `id`=17566; +INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES +(17566,0,9,@GUID,60,0,0,0,0,0); diff --git a/sql/updates/world/2014_07_06_02_world_misc.sql b/sql/updates/world/2014_07_06_02_world_misc.sql new file mode 100644 index 00000000000..7ff6e74d003 --- /dev/null +++ b/sql/updates/world/2014_07_06_02_world_misc.sql @@ -0,0 +1,4 @@ +-- +UPDATE `creature_template` SET `npcflag`=16777216 WHERE `entry`=25743; +DELETE FROM `creature_loot_template` WHERE `entry`=25802 AND `item`=35234; +UPDATE `item_template` SET `flagsCustom`=1 WHERE `entry`=44834; |