aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorsirikfoll <sirikfoll@hotmail.com>2018-06-22 13:47:02 -0300
committerShauren <shauren.trinity@gmail.com>2021-09-29 21:01:25 +0200
commitf507737ecff5d564da999c56d672274387d70ec2 (patch)
tree290d5328dffa8bee93239eeecea72be567b2e569 /sql
parentb3f3dbc663eebc6bd2c34fb9b0f397fb97558fd8 (diff)
Scripts/TheSlavePens: Boss Ahune fixes and updates
Fixes some visual problems Fixes encounter start Updated codestyle Closes #22071 (cherry picked from commit 35ba5aa138edc84dfdeb48ace88b12d521d31fa3)
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/master/2021_09_29_09_world_2018_06_22_00_world.sql13
1 files changed, 13 insertions, 0 deletions
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);