diff options
| author | Malcrom <malcromdev@gmail.com> | 2011-05-25 01:05:10 +0700 |
|---|---|---|
| committer | tobmaps <spambot42@yandex.ru> | 2011-05-25 01:05:10 +0700 |
| commit | 98e1bb0cd0c65491ec0322727a51ad3ab984f1fe (patch) | |
| tree | 7a1fe15ccdb06abb9ec38c026ade8470fff229f4 | |
| parent | 7c4a37464d945ded1663c97f47705fc2ac8e739f (diff) | |
DB/SQL: Fix another sql import error
| -rw-r--r-- | sql/updates/world/2011_05_24_11_world_sai.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/sql/updates/world/2011_05_24_11_world_sai.sql b/sql/updates/world/2011_05_24_11_world_sai.sql index 80257b36f2a..dc4d2a17184 100644 --- a/sql/updates/world/2011_05_24_11_world_sai.sql +++ b/sql/updates/world/2011_05_24_11_world_sai.sql @@ -19,7 +19,7 @@ INSERT INTO `creature_template_addon` (`entry`,`bytes1`,`bytes2`) VALUES (@ENTRY,50331648,1); -- Plagued Proto-Dragon -- Pathing for Plagued Proto-Dragon Entry: 23680 SET @NPC := 107626; -SET @PATH := @GUID * 10; +SET @PATH := @NPC * 10; UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=847.8322,`position_y`=-4441.198,`position_z`=159.749 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, ''); |