diff options
| author | Discover <amort11@hotmail.com> | 2012-01-19 09:00:08 +0100 |
|---|---|---|
| committer | ZxBiohazardZx <zxbiohazardzx@gmail.com> | 2012-01-19 09:00:08 +0100 |
| commit | b0aa7f38d6e16f65044e283e89e828e3bf91bd79 (patch) | |
| tree | 41774689c39ddbfbe8b59a7ca9303d3b7eff182a | |
| parent | 52697dee0c9bb527812f5c9fffa253e0f0939f5f (diff) | |
DB/Quest: remove Special Flags for Seers Relic
Closes #3890
| -rw-r--r-- | sql/updates/world/2012_01_19_01_world_sai.sql | 2 | ||||
| -rw-r--r-- | sql/updates/world/2012_01_19_02_world_quest_template.sql | 1 |
2 files changed, 2 insertions, 1 deletions
diff --git a/sql/updates/world/2012_01_19_01_world_sai.sql b/sql/updates/world/2012_01_19_01_world_sai.sql index e45f535b219..94e8c08292b 100644 --- a/sql/updates/world/2012_01_19_01_world_sai.sql +++ b/sql/updates/world/2012_01_19_01_world_sai.sql @@ -24,7 +24,7 @@ INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`, (13,0,@SPELL_READ_PRONOUNCEMENT,18,1,@ENTRY,"Read Pronouncement targets Hodir's Helm KC Bunny"); -- Spawn a helm bunny -SET @GUID := 20466; -- gap +SET @GUID := 40266; -- gap DELETE FROM `creature` WHERE `id`=@ENTRY; INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`) VALUES (@GUID,@ENTRY,571,1,1,0,0,7390.14,-2725.38,874.256,2.90103,300,0,0,42,0,0,0,0,0); diff --git a/sql/updates/world/2012_01_19_02_world_quest_template.sql b/sql/updates/world/2012_01_19_02_world_quest_template.sql new file mode 100644 index 00000000000..4668bb1bc2e --- /dev/null +++ b/sql/updates/world/2012_01_19_02_world_quest_template.sql @@ -0,0 +1 @@ +UPDATE `quest_template` SET `SpecialFlags`=0 WHERE `entry`=9545; |