diff options
| author | Kandera <KanderaDev@gmail.com> | 2012-09-24 13:31:46 -0400 |
|---|---|---|
| committer | Kandera <KanderaDev@gmail.com> | 2012-09-24 13:32:10 -0400 |
| commit | 1b2a010a70ca4462292168da36466341faa537d7 (patch) | |
| tree | fcc4496f90379b051d3cec72c3ecb1c4d0b4bba1 | |
| parent | 4035738a4a665a057a0d0b43a7587a70ed000562 (diff) | |
Db/Misc: remove from previous commit
| -rw-r--r-- | sql/updates/world/2012_09_24_03_world_misc.sql | 11 |
1 files changed, 1 insertions, 10 deletions
diff --git a/sql/updates/world/2012_09_24_03_world_misc.sql b/sql/updates/world/2012_09_24_03_world_misc.sql index 3083b3d11f9..08d697afac5 100644 --- a/sql/updates/world/2012_09_24_03_world_misc.sql +++ b/sql/updates/world/2012_09_24_03_world_misc.sql @@ -34,15 +34,6 @@ UPDATE `item_template` SET `flagsCustom`=flagsCustom|2 WHERE `entry`=18706; -- https://www.youtube.com/watch?v=fkJ3vrwC4q4&feature=player_detailpage#t=170s UPDATE `quest_template` SET `SpecialFlags` = 1 WHERE `Id` = 7838; -SET @CGUID:= xxxxx; --- Spawn Dark Ranger Marrah author Vincent-Michael Closes #7681 -DELETE FROM `creature` WHERE `id` = @ENTRY; -INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `MovementType`) VALUES -(@CGUID, 24137, 574, 3, 1, 183.8515, -76.50119, 15.84287, 3.455082, 7200, 0, 0); -DELETE FROM `creature_template_addon` WHERE `entry` = @ENTRY; -INSERT INTO `creature_template_addon` (`entry`, `mount`, `bytes1`, `bytes2`, `auras`) VALUES -(24137, 0, 0x20000, 0x1, '34189'); - -- Update DisenchantID's to proper values for items from Satchel of Helpful Goods (51999) author Exodius Closes #7572 UPDATE `item_template` SET `DisenchantID`=41 WHERE `entry` IN (51964, 51968, 51978, 51994); @@ -122,4 +113,4 @@ INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type (@NPC2,0,0,1,62,0,100,0,@GOSSIP2,0,0,0,11,25843,1,0,0,0,0,7,0,0,0,0,0,0,0,"Cenarion Scout Azenel – on gossip option select – cast Create Hive'Zora Scout Report"), (@NPC2,0,1,0,61,0,100,0,0,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0,"Cenarion Scout Azenel – Link – close gossip"), (@NPC3,0,0,1,62,0,100,0,@GOSSIP3,0,0,0,11,25845,1,0,0,0,0,7,0,0,0,0,0,0,0,"Cenarion Scout Jalia – on gossip option select – ast Create Hive'Ashi Scout Report"), -(@NPC3,0,1,0,61,0,100,0,0,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0,"Cenarion Scout Jalia – Link – close gossip");
\ No newline at end of file +(@NPC3,0,1,0,61,0,100,0,0,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0,"Cenarion Scout Jalia – Link – close gossip"); |