From f507737ecff5d564da999c56d672274387d70ec2 Mon Sep 17 00:00:00 2001 From: sirikfoll Date: Fri, 22 Jun 2018 13:47:02 -0300 Subject: Scripts/TheSlavePens: Boss Ahune fixes and updates Fixes some visual problems Fixes encounter start Updated codestyle Closes #22071 (cherry picked from commit 35ba5aa138edc84dfdeb48ace88b12d521d31fa3) --- .../master/2021_09_29_09_world_2018_06_22_00_world.sql | 13 +++++++++++++ 1 file changed, 13 insertions(+) create mode 100644 sql/updates/world/master/2021_09_29_09_world_2018_06_22_00_world.sql (limited to 'sql') diff --git a/sql/updates/world/master/2021_09_29_09_world_2018_06_22_00_world.sql b/sql/updates/world/master/2021_09_29_09_world_2018_06_22_00_world.sql new file mode 100644 index 00000000000..002f6ce843d --- /dev/null +++ b/sql/updates/world/master/2021_09_29_09_world_2018_06_22_00_world.sql @@ -0,0 +1,13 @@ +DELETE FROM `creature` WHERE `guid` IN(73427,73428); +INSERT INTO `creature` (`guid`,`id`,`map`,`zoneId`,`areaId`,`spawnDifficulties`,`phaseId`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`,`ScriptName`,`VerifiedBuild`) VALUES +(73427,26121,547,0,0,'19',0,0,0,-69.8121,-162.4954,-2.30451,1.710423,300,0,0,1,1,0,0,0,0,'',0), +(73428,26120,547,0,0,'19',0,0,0,-98.1029,-230.7864,-10.8085,1.448623,300,0,0,1,1,0,0,0,0,'',0); + +DELETE FROM `game_event_creature` WHERE `eventEntry`=1 AND `guid` IN(73427,73428); +INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES +(1,73427), +(1,73428); + +DELETE FROM `creature_template_movement` WHERE `CreatureId`=26120; +INSERT INTO `creature_template_movement` (`CreatureId`, `Ground`, `Swim`, `Flight`, `Rooted`) VALUES +(26120,0,0,1,0); -- cgit v1.2.3