diff options
| author | Aokromes <Aokromes@users.noreply.github.com> | 2014-12-27 19:39:15 +0100 |
|---|---|---|
| committer | Aokromes <Aokromes@users.noreply.github.com> | 2014-12-27 19:39:15 +0100 |
| commit | 0ca936dc58776bd7ebdd844b490252a2121ed3dc (patch) | |
| tree | a093bb9b9ea57526622196edaf93d7a1ad12ed70 | |
| parent | f16cb5b61365bfbcd8b209b79f9a2fc856b55816 (diff) | |
Update 2014_12_27_09_world.sql
| -rw-r--r-- | sql/updates/world/2014_12_27_09_world.sql | 11 |
1 files changed, 7 insertions, 4 deletions
diff --git a/sql/updates/world/2014_12_27_09_world.sql b/sql/updates/world/2014_12_27_09_world.sql index 9489845fc6a..89371fff954 100644 --- a/sql/updates/world/2014_12_27_09_world.sql +++ b/sql/updates/world/2014_12_27_09_world.sql @@ -1,5 +1,5 @@ -- -SET @CGUID := 75092; -- Guid range must be changed (used for test purpose) +SET @CGUID := 75092; DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+7; INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `MovementType`) VALUES @@ -19,11 +19,14 @@ DELETE FROM `vehicle_template_accessory` WHERE `entry`= 30013; INSERT INTO `vehicle_template_accessory` (`entry`,`accessory_entry`,`seat_id`,`minion`,`description`,`summontype`,`summontimer`) VALUES (30013,29730,0,1,'Stormcrest Eagle',5,0); -UPDATE `creature` SET movementType=2 WHERE guid IN (101713, 101714, 101715, 101801); +UPDATE `creature` SET movementType=2 WHERE `guid` IN (101713, 101714, 101715, 101801); DELETE FROM `creature_addon` WHERE `guid` IN (101713, 101714, 101715, 101801); -INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote,auras`) VALUES -(101713, 1017130, 0, 0, 1, 0, ''), (101714, 1017140, 0, 0, 1, 0, ''), (101715, 1017150, 0, 0, 1, 0, ''), (101801, 1018010, 0, 0, 1, 0, ''); +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`,`auras`) VALUES +(101713, 1017130, 0, 0, 1, 0, ''), +(101714, 1017140, 0, 0, 1, 0, ''), +(101715, 1017150, 0, 0, 1, 0, ''), +(101801, 1018010, 0, 0, 1, 0, ''); DELETE FROM `waypoint_data` WHERE `id` IN (1017130, 1017140, 1017150, 1018010); INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES |