diff options
| author | zxbiohazardzx <zxbiohazardzx@gmail.com> | 2012-02-12 22:22:35 +0100 |
|---|---|---|
| committer | ZxBiohazardZx <zxbiohazardzx@gmail.com> | 2012-02-12 22:22:35 +0100 |
| commit | bc05042775f35a9abe2d422bd77e5c0492f55f7f (patch) | |
| tree | c6e8a285bff3de459079724e05c9f468a1cb823b | |
| parent | b51dc186ea795fa6c50bf587eb229f23a8b9985d (diff) | |
Codestyle: Cleanups (thx Svannon for spotting the issue here)
| -rw-r--r-- | sql/updates/world/2012_02_12_02_world_creature.sql | 2 | ||||
| -rw-r--r-- | sql/updates/world/2012_02_12_03_world_waypoint_data.sql | 6 |
2 files changed, 4 insertions, 4 deletions
diff --git a/sql/updates/world/2012_02_12_02_world_creature.sql b/sql/updates/world/2012_02_12_02_world_creature.sql index ef62989c4f0..75beec97d67 100644 --- a/sql/updates/world/2012_02_12_02_world_creature.sql +++ b/sql/updates/world/2012_02_12_02_world_creature.sql @@ -2,7 +2,7 @@ SET @GUID := 40489; SET @NPC :=3254; DELETE FROM `creature` WHERE `guid` BETWEEN @GUID AND @GUID+7; -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 +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 ,@NPC,1,1,1,0,0, 10.3997021, -2316.43555, 92.1945343, 2.91896486,120,0,0,1,0,0,0,0,0), (@GUID+1,@NPC,1,1,1,0,0,346.736572 , -2606.38916, 91.7916641, 1.58010352,120,0,0,1,0,0,0,0,0), (@GUID+2,@NPC,1,1,1,0,0, 83.07206 , -2545.2085 , 98.107666 , 1.86412442,120,0,0,1,0,0,0,0,0), diff --git a/sql/updates/world/2012_02_12_03_world_waypoint_data.sql b/sql/updates/world/2012_02_12_03_world_waypoint_data.sql index 8f1b93214c9..e47572b2074 100644 --- a/sql/updates/world/2012_02_12_03_world_waypoint_data.sql +++ b/sql/updates/world/2012_02_12_03_world_waypoint_data.sql @@ -1,5 +1,5 @@ SET @NPC := 26841; -SET @GUID := 40496; -- need 9 +SET @GUID := 40497; -- need 9 SET @SPAWN0 := (@GUID )*10; SET @SPAWN1 := (@GUID+1)*10; @@ -23,7 +23,7 @@ INSERT INTO creature (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equip (@GUID+7,@NPC,571,1,1,0,0,3995.586,447.6094,88.55691,1.320955,120,0,0,1,0,0,0,0,0), (@GUID+8,@NPC,571,1,1,0,0,3869.004,707.384,134.3378,4.695541,120,0,0,1,0,0,0,0,0); -DELETE FROM `creature_addon` WHERE `guid` IN (@GUID,@GUID+1,@GUID+2,@GUID+3,@GUID+6,@GUID+7); +DELETE FROM `creature_addon` WHERE `guid` BETWEEN @GUID AND @GUID+8; INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@GUID ,@SPAWN0,0,0,0,0,''), (@GUID+1,@SPAWN1,0,0,0,0,''), @@ -35,7 +35,7 @@ INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote` (@GUID+7,@SPAWN7,0,0,0,0,''), (@GUID+8,@SPAWN8,0,0,0,0,''); -DELETE FROM `waypoint_data` WHERE `id` IN (@NPC1,@NPC2,@NPC3,@NPC4,@NPC5,@NPC6); +DELETE FROM `waypoint_data` WHERE `id` IN (@SPAWN0,@SPAWN1,@SPAWN2,@SPAWN3,@SPAWN4,@SPAWN5,@SPAWN6,@SPAWN7,@SPAWN8); INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES -- 1st (@SPAWN0,0,4716.777,833.6211,169.0006,0,0,0,0,100,0), |