Фиксы от smooth.smcorp@gmail.com
http://vk.com/video-69262110_168486278
Видео в ВК полностью рабочий Ульдаман на 100%
SQL Файл в базу world
Файл не хочет заливаться скину текстом
-- Фиксы в Ульдамане
UPDATE `gameobject_template` SET `faction` = 0 WHERE `entry` = 124369;
UPDATE `event_scripts` SET `delay` = 0 WHERE `id` = 2268;
UPDATE `creature_template` SET `MovementType` = 0 WHERE `entry` = 7172;
UPDATE `creature` SET `MovementType` = 0 WHERE `id` = 7172;
UPDATE `creature` SET `spawndist` = 0 WHERE `id` = 7172;
UPDATE `item_template` SET `class` = 5 WHERE `entry` IN (7733, 7740, 7741);
UPDATE `gameobject_template` SET `data1` = 0, `data2` = 0 WHERE `entry` = 133234;
UPDATE `gameobject_template` SET `data1` = 0, `data2` = 0, `ScriptName` = 'go_altar_of_the_keepers' WHERE `entry` = 130511;
-- Фикс Древнего сундука 126260
UPDATE `gameobject` SET `position_x` = -6201.66, `position_y` = -3057.53, `position_z` = 212.239, `orientation` = 2.00618 WHERE `id` = 126260;
-- Фикс выпадение стержня 7741 и медальёна 7740 без квеста 2240
DELETE FROM `conditions` WHERE `SourceEntry` IN (7740, 7741);
UPDATE `creature_template` SET `MovementType` = 0 WHERE `entry` IN (7076, 7077);
UPDATE `creature` SET `position_x` = 120.997, `position_y` = 280.152, `position_z` = -51.6997, `orientation` = 3.61283, `modelid` = 6026, `curhealth` = 349, `spawndist` = 0, `MovementType` = 0 WHERE `guid` = 50380;
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+0, 7076, 70, 1, 1, 6026, 1, 106.737, 290.618, -51.6997, 4.59022, 7200, 0, 0, 349, 0, 0, 0, 0, 0),
(@GUID+1, 7076, 70, 1, 1, 6026, 1, 89.731, 282.814, -51.6997, 5.67232, 7200, 0, 0, 349, 0, 0, 0, 0, 0),
(@GUID+2, 7076, 70, 1, 1, 6026, 1, 102.634, 255.188, -51.6997, 1.48353, 7200, 0, 0, 349, 0, 0, 0, 0, 0),
(@GUID+3, 7076, 70, 1, 1, 6026, 1, 88.0912, 265.328, -51.6997, 0.436332, 7200, 0, 0, 349, 0, 0, 0, 0, 0),
(@GUID+4, 7076, 70, 1, 1, 6026, 1, 119.465, 263.298, -51.6997, 2.56563, 7200, 0, 0, 349, 0, 0, 0, 0, 0);
UPDATE `creature` SET `position_x` = 125.958, `position_y` = 296.112, `position_z` = -52.1213, `orientation` = 3.9619, `modelid` = 6025, `curhealth` = 251, `curmana` = 2975, `spawndist` = 0, `MovementType` = 0 WHERE `guid` = 50390;
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+0, 7077, 70, 1, 1, 6025, 0, 83.3431, 249.266, -52.1213, 0.837758, 7200, 0, 0, 251, 2975, 0, 0, 0, 0),
(@GUID+1, 7077, 70, 1, 1, 6025, 0, 93.7888, 243.029, -52.1213, 1.23918, 7200, 0, 0, 251, 2975, 0, 0, 0, 0),
(@GUID+2, 7077, 70, 1, 1, 6025, 0, 115.438, 302.439, -52.1213, 4.34587, 7200, 0, 0, 251, 2975, 0, 0, 0, 0),
(@GUID+3, 7077, 70, 1, 1, 6025, 0, 103.067, 304.25, -52.1213, 4.74729, 7200, 0, 0, 251, 2975, 0, 0, 0, 0),
(@GUID+4, 7077, 70, 1, 1, 6025, 0, 127.731, 251.6, -52.1213, 2.40855, 7200, 0, 0, 251, 2975, 0, 0, 0, 0),
(@GUID+5, 7077, 70, 1, 1, 6025, 0, 134.081, 262.03, -52.1213, 2.80998, 7200, 0, 0, 251, 2975, 0, 0, 0, 0),
(@GUID+6, 7077, 70, 1, 1, 6025, 0, 74.8823, 283.399, -52.1213, 5.91667, 7200, 0, 0, 251, 2975, 0, 0, 0, 0),
(@GUID+7, 7077, 70, 1, 1, 6025, 0, 105.984, 241.057, -52.1213, 1.64061, 7200, 0, 0, 251, 2975, 0, 0, 0, 0),
(@GUID+8, 7077, 70, 1, 1, 6025, 0, 73.0399, 271.531, -52.1213, 0.017453, 7200, 0, 0, 251, 2975, 0, 0, 0, 0),
(@GUID+9, 7077, 70, 1, 1, 6025, 0, 81.1552, 293.988, -52.1213, 5.51524, 7200, 0, 0, 251, 2975, 0, 0, 0, 0),
(@GUID+10, 7077, 70, 1, 1, 6025, 0, 135.904, 274.323, -52.1213, 3.21141, 7200, 0, 0, 251, 2975, 0, 0, 0, 0);
UPDATE `creature` SET `position_x` = 109.108, `position_y` = 248.539, `position_z` = -52.1147, `orientation` = 2.017188, `modelid` = 5989, `spawndist` = 0, `MovementType` = 0 WHERE `guid` = 123902;
UPDATE `creature` SET `position_x` = 119.824, `position_y` = 253.381, `position_z` = -52.1147, `orientation` = 2.017188, `modelid` = 5989, `spawndist` = 0, `MovementType` = 0 WHERE `guid` = 123903;
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+0, 10120, 70, 1, 1, 5989, 0, 99.735, 297.342, -52.1147, 5.117157, 7200, 0, 0, 5836, 0, 0, 0, 0, 0),
(@GUID+1, 10120, 70, 1, 1, 5989, 0, 89.305, 291.843, -52.1147, 5.117157, 7200, 0, 0, 5836, 0, 0, 0, 0, 0);
DELETE FROM `creature` WHERE `id` = 4855;
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+0, 4855, 70, 1, 1, 11166, 0, 57.4593, 447.311, -40.9598, 0, 7200, 0, 0, 4185, 0, 0, 0, 0, 0),
(@GUID+1, 4855, 70, 1, 1, 11166, 0, 36.2464, 376.018, -38.8766, 2.86234, 7200, 0, 0, 4185, 0, 0, 0, 0, 0),
(@GUID+2, 4855, 70, 1, 1, 11166, 0, 42.0532, 323.202, -42.8722, 2.38446, 7200, 5, 0, 4185, 0, 1, 0, 0, 0),
(@GUID+3, 4855, 70, 1, 1, 11166, 0, 49.3411, 346.228, -40.0877, 3.07178, 7200, 0, 0, 4185, 0, 0, 0, 0, 0),
(@GUID+4, 4855, 70, 1, 1, 11166, 0, 85.4878, 403.676, -38.1789, 6.12611, 7200, 2, 0, 4185, 0, 1, 0, 0, 0),
(@GUID+5, 4855, 70, 1, 1, 11166, 0, 78.8918, 404.942, -38.1789, 5.02655, 7200, 2, 0, 4185, 0, 1, 0, 0, 0),
(@GUID+6, 4855, 70, 1, 1, 11166, 0, 9.28976, 332.21, -38.6322, 5.21853, 7200, 3, 0, 4185, 0, 1, 0, 0, 0),
(@GUID+7, 4855, 70, 1, 1, 11166, 0, 57.9032, 373.95, -38.2499, 4.2516, 7200, 0, 0, 4185, 0, 0, 0, 0, 0),
(@GUID+8, 4855, 70, 1, 1, 11166, 0, 58.6503, 366.721, -38.8707, 0.785398, 7200, 0, 0, 4185, 0, 0, 0, 0, 0),
(@GUID+9, 4855, 70, 1, 1, 11166, 0, 55.4041, 379.024, -38.1699, 2.18166, 7200, 0, 0, 4185, 0, 0, 0, 0, 0),
(@GUID+10, 4855, 70, 1, 1, 11166, 0, 55.8178, 416.082, -41.0342, 2.3869, 7200, 2, 0, 4185, 0, 1, 0, 0, 0),
(@GUID+11, 4855, 70, 1, 1, 11166, 0, 49.7852, 418.467, -40.9534, 0.122173, 7200, 2, 0, 4185, 0, 1, 0, 0, 0),
(@GUID+12, 4855, 70, 1, 1, 11166, 0, 40.1434, 445.185, -40.965, 4.62512, 7200, 2, 0, 4185, 0, 1, 0, 0, 0),
(@GUID+13, 4855, 70, 1, 1, 11166, 0, 39.3714, 313.03, -39.1286, 2.63545, 7200, 0, 0, 4185, 0, 0, 0, 0, 0),
(@GUID+14, 4855, 70, 1, 1, 11166, 0, 49.9951, 309.711, -40.1848, 2.26893, 7200, 0, 0, 4185, 0, 0, 0, 0, 0),
(@GUID+15, 4855, 70, 1, 1, 11166, 0, 40.5816, 359.864, -43.2524, 5.74213, 7200, 2, 0, 4185, 0, 1, 0, 0, 0),
(@GUID+16, 4855, 70, 1, 1, 11166, 0, 36.9656, 331.841, -43.0655, 0.802851, 7200, 4, 0, 4185, 0, 1, 0, 0, 0);
DELETE FROM `creature` WHERE `id` = 4853;
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+0, 4853, 70, 1, 1, 1194, 0, 50.8847, 452.713, -40.9676, 4.50295, 7200, 0, 0, 3405, 1189, 0, 0, 0, 0),
(@GUID+1, 4853, 70, 1, 1, 1194, 0, 30.4951, 475.779, -39.9868, 2.02458, 7200, 0, 0, 3405, 1189, 0, 0, 0, 0),
(@GUID+2, 4853, 70, 1, 1, 1194, 0, 48.8975, 340.68, -40.8543, 2.67035, 7200, 3, 0, 3405, 1189, 1, 0, 0, 0),
(@GUID+3, 4853, 70, 1, 1, 1194, 0, 85.2644, 397.095, -38.1789, 2.3911, 7200, 2, 0, 3405, 1189, 1, 0, 0, 0),
(@GUID+4, 4853, 70, 1, 1, 1194, 0, 16.3417, 332.015, -39.43, 2.47837, 7200, 3, 0, 3405, 1189, 1, 0, 0, 0),
(@GUID+5, 4853, 70, 1, 1, 1194, 0, 62.5257, 377.912, -38.2556, 2.10292, 7200, 2, 0, 3405, 1189, 1, 0, 0, 0),
(@GUID+6, 4853, 70, 1, 1, 1194, 0, 49.4747, 425.58, -40.9556, 3.59538, 7200, 3, 0, 3405, 1189, 1, 0, 0, 0),
(@GUID+7, 4853, 70, 1, 1, 1194, 0, 37.5974, 438.76, -40.9636, 4.7822, 7200, 3, 0, 3405, 1189, 1, 0, 0, 0),
(@GUID+8, 4853, 70, 1, 1, 1194, 0, 43.393, 304.585, -39.5612, 5.48033, 7200, 0, 0, 3405, 1189, 0, 0, 0, 0);
DELETE FROM `creature` WHERE `id` = 4852;
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+0, 4852, 70, 1, 1, 160, 0, -248.191, 240.72, -46.5294, 0.296706, 7200, 0, 0, 3279, 1142, 0, 0, 0, 0),
(@GUID+1, 4852, 70, 1, 1, 160, 0, -258.846, 280.83, -48.5384, 2.79253, 7200, 0, 0, 3279, 1142, 0, 0, 0, 0),
(@GUID+2, 4852, 70, 1, 1, 160, 0, -244.168, 266.766, -50.3178, 3.57792, 7200, 0, 0, 3279, 1142, 0, 0, 0, 0),
(@GUID+3, 4852, 70, 1, 1, 160, 0, -334.994, 80.9996, -51.1472, 0.890118, 7200, 3, 0, 3279, 1142, 1, 0, 0, 0),
(@GUID+4, 4852, 70, 1, 1, 160, 0, -296.946, 140.831, -46.5533, 0.349066, 7200, 2, 0, 3279, 1142, 1, 0, 0, 0),
(@GUID+5, 4852, 70, 1, 1, 160, 0, -350.327, 100.63, -53.0457, 4.71239, 7200, 1, 0, 3279, 1142, 1, 0, 0, 0),
(@GUID+6, 4852, 70, 1, 1, 160, 0, -333.309, 98.8381, -56.0877, 0.418879, 7200, 3, 0, 3279, 1142, 1, 0, 0, 0),
(@GUID+7, 4852, 70, 1, 1, 160, 0, -342.276, 86.0456, -51.8534, 0.645772, 7200, 2, 0, 3279, 1142, 1, 0, 0, 0),
(@GUID+7, 4852, 70, 1, 1, 160, 0, -331.743, 119.006, -53.3566, 0, 7200, 0, 0, 3279, 1142, 0, 0, 0, 0),
(@GUID+8, 4852, 70, 1, 1, 160, 0, -343.784, 120.961, -46.6312, 4.99385, 7200, 3, 0, 3279, 1142, 1, 0, 0, 0),
(@GUID+9, 4852, 70, 1, 1, 160, 0, -174.826, 75.6344, -48.7268, 3.2467, 7200, 3, 0, 3279, 1142, 1, 0, 0, 0),
(@GUID+10, 4852, 70, 1, 1, 160, 0, -172.4, 140.041, -47.3289, 2.60054, 7200, 2, 0, 3279, 1142, 1, 0, 0, 0),
(@GUID+11, 4852, 70, 1, 1, 160, 0, -166.57, 69.4432, -48.7308, 1.53746, 7200, 3, 0, 3279, 1142, 1, 0, 0, 0),
(@GUID+12, 4852, 70, 1, 1, 160, 0, -273.878, 62.1223, -48.7141, 3.41824, 7200, 3, 0, 3279, 1142, 1, 0, 0, 0),
(@GUID+13, 4852, 70, 1, 1, 160, 0, -282.683, 170.546, -47.3271, 2.51327, 7200, 2, 0, 3279, 1142, 1, 0, 0, 0),
(@GUID+14, 4852, 70, 1, 1, 160, 0, -224.209, 134.803, -46.6291, 3.37407, 7200, 2, 0, 3279, 1142, 1, 0, 0, 0),
(@GUID+15, 4852, 70, 1, 1, 160, 0, -210.209, 94.8437, -48.0213, 1.90241, 7200, 2, 0, 3279, 1142, 1, 0, 0, 0),
(@GUID+16, 4852, 70, 1, 1, 160, 0, -271.653, 140.403, -47.324, 1.55334, 7200, 3, 0, 3279, 1142, 1, 0, 0, 0),
(@GUID+17, 4852, 70, 1, 1, 160, 0, -280.366, 87.4282, -48.717, 3.68265, 7200, 2, 0, 3279, 1142, 1, 0, 0, 0),
(@GUID+18, 4852, 70, 1, 1, 160, 0, -245.23, 96.0977, -48.0381, 6.00393, 7200, 2, 0, 3279, 1142, 1, 0, 0, 0),
(@GUID+19, 4852, 70, 1, 1, 160, 0, -174.321, 165.9, -47.3283, 4.43314, 7200, 3, 0, 3279, 1142, 1, 0, 0, 0),
(@GUID+20, 4852, 70, 1, 1, 160, 0, -266.266, 90.8042, -48.711, 0.575959, 7200, 2, 0, 3279, 1142, 1, 0, 0, 0),
(@GUID+21, 4852, 70, 1, 1, 160, 0, -233.511, 170.852, -44.6301, 2.58106, 7200, 2, 0, 3279, 1142, 1, 0, 0, 0);
DELETE FROM `creature` WHERE `id` = 4860;
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+0, 4860, 70, 1, 1, 2234, 0, 152.666, 288.39, -26.5815, 2.01064, 7200, 2, 0, 4377, 0, 1, 0, 0, 0),
(@GUID+1, 4860, 70, 1, 1, 2234, 0, 165.557, 261.435, -29.3548, 2.13883, 7200, 2, 0, 4377, 0, 1, 0, 0, 0),
(@GUID+2, 4860, 70, 1, 1, 2234, 0, 91.5275, 296.61, -26.5047, 0.767945, 7200, 2, 0, 4377, 0, 1, 0, 0, 0),
(@GUID+3, 4860, 70, 1, 1, 2234, 0, 78.6097, 262.243, -26.5881, 4.69281, 7200, 2, 0, 4377, 0, 1, 0, 0, 0),
(@GUID+4, 4860, 70, 1, 1, 2234, 0, 127.47, 224.281, -42.4075, 4.43313, 7200, 2, 0, 4377, 0, 1, 0, 0, 0),
(@GUID+5, 4860, 70, 1, 1, 2234, 0, -39.625, 272.806, -49.0187, 3.26601, 7200, 2, 0, 4377, 0, 1, 0, 0, 0),
(@GUID+6, 4860, 70, 1, 1, 2234, 0, -89.6837, 301.882, -50.1905, 4.79655, 7200, 5, 0, 4377, 0, 1, 0, 0, 0),
(@GUID+7, 4860, 70, 1, 1, 2234, 0, -73.6665, 231.738, -49.7598, 1.1927, 7200, 3, 0, 4377, 0, 1, 0, 0, 0),
(@GUID+8, 4860, 70, 1, 1, 2234, 0, 61.616, 238.023, -52.198, 0.140379, 7200, 2, 0, 4377, 0, 1, 0, 0, 0),
(@GUID+9, 4860, 70, 1, 1, 2234, 0, 76.1654, 213.906, -54.9749, 2.28883, 7200, 3, 0, 4377, 0, 1, 0, 0, 0),
(@GUID+10, 4860, 70, 1, 1, 2234, 0, 113.387, 252.391, -26.5881, 0.518236, 7200, 2, 0, 4377, 0, 1, 0, 0, 0);
DELETE FROM `creature` WHERE `id` = 4861;
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+0, 4861, 70, 1, 1, 1954, 0, -186.122, 284.889, -47.9277, 1.14041, 7200, 3, 0, 4100, 0, 1, 0, 0, 0),
(@GUID+1, 4861, 70, 1, 1, 1954, 0, -69.8894, 358.44, -51.3618, 5.23599, 7200, 5, 0, 4100, 0, 1, 0, 0, 0),
(@GUID+2, 4861, 70, 1, 1, 1954, 0, -123.223, 241.99, -48.1317, 4.47565, 7200, 3, 0, 4100, 0, 1, 0, 0, 0),
(@GUID+3, 4861, 70, 1, 1, 1954, 0, -77.5891, 373.853, -46.2722, 3.1765, 7200, 5, 0, 4100, 0, 1, 0, 0, 0),
(@GUID+4, 4861, 70, 1, 1, 1954, 0, -112.023, 353.095, -45.5119, 1.93731, 7200, 5, 0, 4100, 0, 1, 0, 0, 0),
(@GUID+5, 4861, 70, 1, 1, 1954, 0, -44.2284, 356.997, -47.5747, 0.575959, 7200, 3, 0, 4100, 0, 1, 0, 0, 0),
(@GUID+6, 4861, 70, 1, 1, 1954, 0, -56.0625, 371.559, -50.5752, 3.43001, 7200, 3, 0, 4100, 0, 1, 0, 0, 0),
(@GUID+7, 4861, 70, 1, 1, 1954, 0, -48.6179, 369.872, -49.8161, 4.29351, 7200, 3, 0, 4100, 0, 1, 0, 0, 0);
DELETE FROM `creature` WHERE `id` = 4863;
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+0, 4863, 70, 1, 1, 4486, 0, -178.951, 321.668, -52.6526, 2.72271, 7200, 3, 0, 4008, 0, 1, 0, 0, 0),
(@GUID+1, 4863, 70, 1, 1, 4486, 0, -125.943, 266.856, -45.7099, 3.9619, 7200, 5, 0, 4008, 0, 1, 0, 0, 0),
(@GUID+2, 4863, 70, 1, 1, 4486, 0, -141.03, 312.545, -44.3538, 5.61996, 7200, 5, 0, 4008, 0, 1, 0, 0, 0),
(@GUID+3, 4863, 70, 1, 1, 4486, 0, 59.4307, 453.107, -40.9609, 4.01426, 7200, 0, 0, 4008, 0, 0, 0, 0, 0);
DELETE FROM `creature` WHERE `id` = 4847;
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+0, 4847, 70, 1, 1, 6054, 1, -160.858, 363.96, -33.8446, 4.39823, 7200, 5, 0, 3405, 0, 1, 0, 0, 0),
(@GUID+1, 4847, 70, 1, 1, 6054, 1, -139.421, 370.119, -41.6872, 3.56047, 7200, 0, 0, 3405, 0, 0, 0, 0, 0),
(@GUID+2, 4847, 70, 1, 1, 6054, 1, -137.294, 386.394, -40.2004, 5.96903, 7200, 2, 0, 3405, 0, 1, 0, 0, 0),
(@GUID+3, 4847, 70, 1, 1, 6054, 1, -151.839, 368.456, -33.9654, 5.93412, 7200, 0, 0, 3405, 0, 0, 0, 0, 0),
(@GUID+4, 4847, 70, 1, 1, 6054, 1, -143.07, 389.049, -39.8265, 0.959931, 7200, 3, 0, 3405, 0, 1, 0, 0, 0);
DELETE FROM `creature` WHERE `id` = 4848;
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+0, 4848, 70, 1, 1, 6055, 1, 14.2152, 397.785, -44.0817, 2.02458, 7200, 2, 0, 3405, 0, 1, 0, 0, 0),
(@GUID+1, 4848, 70, 1, 1, 6055, 1, 12.7475, 413.541, -47.7169, 0.087266, 7200, 2, 0, 3405, 0, 1, 0, 0, 0);
DELETE FROM `creature` WHERE `id` = 4849;
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+0, 4849, 70, 1, 1, 6067, 1, 15.0678, 401.771, -44.131, 2.84489, 7200, 2, 0, 4185, 0, 1, 0, 0, 0),
(@GUID+1, 4849, 70, 1, 1, 6067, 1, 7.95455, 412.226, -47.5251, 1.64061, 7200, 2, 0, 4185, 0, 1, 0, 0, 0);
DELETE FROM `creature` WHERE `id` = 4850;
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+0, 4850, 70, 1, 1, 722, 1, -242.073, 241.255, -47.9852, 2.70526, 7200, 0, 0, 4008, 0, 0, 0, 0, 0),
(@GUID+1, 4850, 70, 1, 1, 722, 1, -246.664, 245.974, -46.9168, 5.44543, 7200, 0, 0, 4008, 0, 0, 0, 0, 0),
(@GUID+2, 4850, 70, 1, 1, 722, 1, -265.963, 280.01, -48.3898, 0.767945, 7200, 0, 0, 4008, 0, 0, 0, 0, 0),
(@GUID+3, 4850, 70, 1, 1, 722, 1, -267.258, 286.174, -47.2355, 5.51524, 7200, 0, 0, 4008, 0, 0, 0, 0, 0),
(@GUID+4, 4850, 70, 1, 1, 722, 1, -223.6, 197.962, -44.5323, 3.42085, 7200, 0, 0, 4008, 0, 0, 0, 0, 0),
(@GUID+5, 4850, 70, 1, 1, 722, 1, -211.945, 247.895, -48.5138, 3.89208, 7200, 3, 0, 4008, 0, 1, 0, 0, 0),
(@GUID+6, 4850, 70, 1, 1, 722, 1, -210.824, 242.184, -47.8069, 1.02974, 7200, 3, 0, 4008, 0, 1, 0, 0, 0),
(@GUID+7, 4850, 70, 1, 1, 722, 1, -230.359, 255.139, -49.4661, 6.12611, 7200, 2, 0, 4008, 0, 1, 0, 0, 0),
(@GUID+8, 4850, 70, 1, 1, 722, 1, -232.006, 198.061, -44.532, 2.94961, 7200, 0, 0, 4008, 0, 0, 0, 0, 0),
(@GUID+9, 4850, 70, 1, 1, 722, 1, -250.699, 264.989, -50.2675, 6.05629, 7200, 0, 0, 4008, 0, 0, 0, 0, 0),
(@GUID+10, 4850, 70, 1, 1, 722, 1, -317.726, 117.748, -49.015, 0, 7200, 2, 0, 4008, 0, 1, 0, 0, 0),
(@GUID+11, 4850, 70, 1, 1, 722, 1, -322, 112.267, -54.0304, 5.06145, 7200, 2, 0, 4008, 0, 1, 0, 0, 0),
(@GUID+12, 4850, 70, 1, 1, 722, 1, -338.709, 139.708, -49.575, 4.29351, 7200, 3, 0, 4008, 0, 1, 0, 0, 0),
(@GUID+13, 4850, 70, 1, 1, 722, 1, -305.035, 131.561, -46.5367, 3.56047, 7200, 0, 0, 4008, 0, 0, 0, 0, 0);
ИТО ЭТО НЕ ФЕВСЬ ФИКС ЛИСТ, 30000 символов максимум=(
Знаю С++ Mysql HTML CSS
Короче напишите аську или контакт, я все остальное скину:
Например сделаю вам, чтобы пауки в цлк спускались с паутины на потолке
Если нужно подогнать под Debain Linux нет проблем
Аська 5381135
Контакт vk.com/smo0th
Wow 3.3.5a
Много фиксов уже готовы, все скину если возьмете в команду)
Добавте в аське или вк, я все остальное скину
- - - Updated - - -
ВОТ
