From b1eee7cf8e3c08145281c0926a30525fa30bcc0e Mon Sep 17 00:00:00 2001 From: Malcrom Date: Tue, 13 Nov 2012 09:18:24 -0330 Subject: DB/waypoints: Fix last commit --- sql/updates/world/2012_11_13_00_world_waypoints.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'sql') diff --git a/sql/updates/world/2012_11_13_00_world_waypoints.sql b/sql/updates/world/2012_11_13_00_world_waypoints.sql index ade83d858e5..5e4c0aeae13 100644 --- a/sql/updates/world/2012_11_13_00_world_waypoints.sql +++ b/sql/updates/world/2012_11_13_00_world_waypoints.sql @@ -1,7 +1,7 @@ -- Pathing for Ol' Sooty Entry: 1225 SET @NPC := 8877; SET @PATH := @NPC * 10; -UPDATE `creature` SET `spawntimesecs`=1200 `spawndist`=0,`MovementType`=2,`position_x`=-5716.181152,`position_y`=-3110.810791,`position_z`=316.686523 WHERE `guid`=@NPC; +UPDATE `creature` SET `spawntimesecs`=1200,`spawndist`=0,`MovementType`=2,`position_x`=-5716.181152,`position_y`=-3110.810791,`position_z`=316.686523 WHERE `guid`=@NPC; DELETE FROM `creature_addon` WHERE `guid`=@NPC; INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, ''); DELETE FROM `waypoint_data` WHERE `id`=@PATH; -- cgit v1.2.3