|
| 1 | +-- Sergeant Kregga, Captain Kendall, Opportunity and Exploiting an Opening fix by nelegalno |
| 2 | +-- http://www.wowhead.com/zone=210#comments:id=838363 |
| 3 | +-- http://www.wowhead.com/zone=210#comments:id=838364 |
| 4 | +SET @GUID=18; -- Set by TDB team |
| 5 | +SET @ASPELL=59073; |
| 6 | +SET @HSPELL=59087; |
| 7 | +SET @AREA=4522; |
| 8 | + |
| 9 | +-- Sergeant Kregga (31440) |
| 10 | +UPDATE `creature_template` SET `minlevel`=80,`maxlevel`=80,`exp`=2 WHERE `entry`=31440; |
| 11 | +DELETE FROM `creature` WHERE `guid`=@GUID AND `id`=31440; |
| 12 | +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 |
| 13 | +(@GUID,31440,571,1,8,0,0,5874.2,1948.5,516.1,2.8,300,0,0,32000,0,0,0,0,0); |
| 14 | + |
| 15 | +-- Captain Kendall (31444) |
| 16 | +UPDATE `creature` SET `phaseMask`=2 WHERE `id`=31444; |
| 17 | + |
| 18 | +DELETE FROM `spell_area` WHERE `spell`=@HSPELL AND `area`=@AREA; |
| 19 | +DELETE FROM `spell_area` WHERE `spell`=@ASPELL AND `area`=@AREA; |
| 20 | +INSERT INTO `spell_area` (`spell`,`area`,`quest_start`,`quest_end`,`aura_spell`,`racemask`,`gender`,`autocast`,`quest_start_status`,`quest_end_status`) VALUES |
| 21 | +(@HSPELL,@AREA,12899,0,0, 690,2,1,64,43), -- Horde version |
| 22 | +(@ASPELL,@AREA,12898,0,0,1101,2,1,64,43); -- Alliance version |
0 commit comments