diff options
| -rw-r--r-- | sql/updates/world/2014_12_27_09_world.sql | 67 |
1 files changed, 67 insertions, 0 deletions
diff --git a/sql/updates/world/2014_12_27_09_world.sql b/sql/updates/world/2014_12_27_09_world.sql new file mode 100644 index 00000000000..01e0d0f31ef --- /dev/null +++ b/sql/updates/world/2014_12_27_09_world.sql @@ -0,0 +1,67 @@ +-- +SET @CGUID := 75092; -- Guid range must be changed (used for test purpose) + +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 +(@CGUID+0, 29854, 571, 1, 1, 6712.09, -533.401, 1211.94, 1.69635, 0, 0, 0), +(@CGUID+1, 29854, 571, 1, 1, 6695.85, -487.759, 1195.42, 1.80238, 0, 0, 0), +(@CGUID+2, 29854, 571, 1, 1, 6675.19, -420.657, 1184.11, 3.36925, 0, 15, 1), +(@CGUID+3, 29854, 571, 1, 1, 6647.07, -477.868, 1167.51, 2.68202, 0, 0, 0), +(@CGUID+4, 29854, 571, 1, 1, 6706.95, -521.231, 1211.49, 5.17959, 0, 0, 0), +(@CGUID+5, 29854, 571, 1, 1, 6697.77, -462.455, 1178.17, 5.77257, 0, 0, 0), +(@CGUID+6, 29854, 571, 1, 1, 6671.19, -467.731, 1178.39, 6.27915, 0, 0, 0); + +UPDATE `creature_template` SET `InhabitType`=4 WHERE `entry` IN (29854, 30013); + +DELETE FROM creature WHERE guid IN (99014, 99015, 99017, 99172, 121713, 121358); -- vehicle accessory and wrong spawn + +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); + +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, ''); + +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 +(1017130, 1, 6580.963, -341.5958, 1025.59, 0, 0, 1, 0, 100, 0), +(1017130, 2, 6595.587, -274.2542, 1025.59, 0, 0, 1, 0, 100, 0), +(1017130, 3, 6603.651, -214.6846, 1025.59, 0, 0, 1, 0, 100, 0), +(1017130, 4, 6598.268, -139.6636, 1025.59, 0, 0, 1, 0, 100, 0), +(1017130, 5, 6583.247, -70.26400, 1025.59, 0, 0, 1, 0, 100, 0), +(1017130, 6, 6517.861, -27.37788, 1025.59, 0, 0, 1, 0, 100, 0), +(1017130, 7, 6334.042, -80.26796, 1025.59, 0, 0, 1, 0, 100, 0), +(1017130, 8, 6302.791, -214.7384, 1025.59, 0, 0, 1, 0, 100, 0), +(1017130, 9, 6306.531, -372.1047, 1025.59, 0, 0, 1, 0, 100, 0), +(1017130, 10, 6347.108, -523.2972, 1025.59, 0, 0, 1, 0, 100, 0), +(1017130, 11, 6469.087, -575.7284, 1025.59, 0, 0, 1, 0, 100, 0), +(1017130, 12, 6543.881, -476.6713, 1025.59, 0, 0, 1, 0, 100, 0), +(1017140, 1, 6558.544, -152.0257, 1054.933, 0, 0, 1, 0, 100, 0), +(1017140, 2, 6609.241, -127.7897, 1055.322, 0, 0, 1, 0, 100, 0), +(1017140, 3, 6701.458, -107.1807, 1059.877, 0, 0, 1, 0, 100, 0), +(1017140, 4, 6774.843, -197.2011, 1078.129, 0, 0, 1, 0, 100, 0), +(1017140, 5, 6777.308, -292.3615, 1095.376, 0, 0, 1, 0, 100, 0), +(1017140, 6, 6703.971, -329.4862, 1100.933, 0, 0, 1, 0, 100, 0), +(1017140, 7, 6606.578, -326.3456, 1091.265, 0, 0, 1, 0, 100, 0), +(1017140, 8, 6552.779, -289.719, 1077.712, 0, 0, 1, 0, 100, 0), +(1017140, 9, 6536.85, -189.0296, 1059.237, 0, 0, 1, 0, 100, 0), +(1017150, 1, 6630.098, -152.5961, 999.0965, 0, 0, 1, 0, 100, 0), +(1017150, 2, 6663.148, -136.3936, 999.0965, 0, 0, 1, 0, 100, 0), +(1017150, 3, 6705.553, -94.23096, 999.0965, 0, 0, 1, 0, 100, 0), +(1017150, 4, 6728.896, 43.04465, 999.0965, 0, 0, 1, 0, 100, 0), +(1017150, 5, 6628.838, 175.6433, 999.0965, 0, 0, 1, 0, 100, 0), +(1017150, 6, 6520.246, 148.9764, 999.0965, 0, 0, 1, 0, 100, 0), +(1017150, 7, 6386.172, -22.66618, 999.0965, 0, 0, 1, 0, 100, 0), +(1017150, 8, 6253.463, -195.8139, 999.0965, 0, 0, 1, 0, 100, 0), +(1017150, 9, 6330.91, -276.6109, 999.0965, 0, 0, 1, 0, 100, 0), +(1017150, 10, 6537.496, -198.9901, 999.0965, 0, 0, 1, 0, 100, 0), +(1018010, 1, 6725.225586, -25.534340, 999.721313, 0, 0, 1, 0, 100, 0), +(1018010, 2, 6638.638184, -52.154530, 991.158203, 0, 0, 1, 0, 100, 0), +(1018010, 3, 6567.925293, -153.043152, 1001.600220, 0, 0, 1, 0, 100, 0), +(1018010, 4, 6591.385742, -224.502579, 1003.976013, 0, 0, 1, 0, 100, 0), +(1018010, 5, 6695.518555, -252.929214, 1022.529175, 0, 0, 1, 0, 100, 0), +(1018010, 6, 6802.429199, -243.025558, 1022.408691, 0, 0, 1, 0, 100, 0), +(1018010, 7, 6798.217285, -161.789276, 1046.530518, 0, 0, 1, 0, 100, 0); |