Воскресенье, 13.07.2025, 12:53
[ Новые сообщения · Участники · Правила форума · Поиск · RSS ]
  • Страница 1 из 1
  • 1
Форум » MaNGOS » фиксы MaNGOS » Квесты,Мобы,Итемы,Фазы,Эвенты [множество фиксов здесь]
Квесты,Мобы,Итемы,Фазы,Эвенты [множество фиксов здесь]
aleksey38Дата: Вторник, 29.03.2011, 13:08 | Сообщение # 1
Группа: Заблокированные
Сообщений: 39
Награды: 1
Репутация: 0
Статус: Offline

Дроп С мобов!
Quote
-- Ключ Куэрго
DELETE FROM `creature_loot_template` WHERE (`entry`=7902) AND (`item`=9275);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (7902, 9275, 28, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=7899) AND (`item`=9275);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (7899, 9275, 28, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=7901) AND (`item`=9275);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (7901, 9275, 25, 0, 1, 1, 0, 0, 0);

-- Шляпа пирата Южных морей
DELETE FROM `creature_loot_template` WHERE (`entry`=7855) AND (`item`=20519);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (7855, 20519, -25, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=7856) AND (`item`=20519);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (7856, 20519, -24, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=7858) AND (`item`=20519);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (7858, 20519, -21, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=7857) AND (`item`=20519);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (7857, 20519, -21, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=7883) AND (`item`=20519);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (7883, 20519, -20, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=8203) AND (`item`=20519);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (8203, 20519, -16, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=15685) AND (`item`=20519);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (15685, 20519, -10, 0, 1, 1, 0, 0, 0);

-- Бурдюк с водой Скитальцев Пустыни
DELETE FROM `creature_loot_template` WHERE (`entry`=7805) AND (`item`=8483);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (7805, 8483, -39, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=5615) AND (`item`=8483);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (5615, 8483, -38, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=5623) AND (`item`=8483);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (5623, 8483, -38, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=5616) AND (`item`=8483);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (5616, 8483, -38, 0, 1, 3, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=5617) AND (`item`=8483);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (5617, 8483, -38, 0, 1, 3, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=5618) AND (`item`=8483);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (5618, 8483, -38, 0, 1, 1, 0, 0, 0);

================================================================================================
Огрримар Фикс Мобов Правельность мобов где они должны стоять!
Quote

-- Оргриммар
-- Харрук (офф)
UPDATE creature SET position_x = '273.168976', position_y = '-4713.710449', position_z = '11.627667', orientation = '1.101132' WHERE guid = '37927';
-- Джо'ма (офф)
UPDATE creature SET position_x = '1839.458496', position_y = '-4466.385254', position_z = '47.416718', orientation = '3.335550' WHERE guid = '154663';
-- Белгром Каменная Булава (офф)
UPDATE creature SET position_x = '1953.493042', position_y = '-4735.413086', position_z = '48.314331', orientation = '1.046110' WHERE guid = '40495';
-- Ордынский Вестник Войны (офф)
UPDATE creature SET position_x = '1988.952515', position_y = '-4799.268066', position_z = '55.818367', orientation = '2.320023' WHERE guid = '40522';
-- Зеггон Трестокун (офф)
UPDATE creature SET position_x = '1987.763184', position_y = '-4813.386719', position_z = '56.765160', orientation = '1.770240' WHERE guid = '85513';
-- Андрисса (офф)
UPDATE creature SET position_x = '2002.502075', position_y = '-4791.190430', position_z = '56.764801', orientation = '3.179264' WHERE guid = '284937';
-- Атурк Наковальня (офф)
UPDATE creature SET position_x = '2054.506104', position_y = '-4817.099121', position_z = '22.786383', orientation = '0.578818' WHERE guid = '102514';
-- Орокк Омош (офф)
UPDATE creature SET position_x = '2062.265137', position_y = '-4792.109863', position_z = '22.981644', orientation = '5.888895' WHERE guid = '40597';
-- Шанкис (офф)
UPDATE creature SET position_x = '1995.290771', position_y = '-4662.221680', position_z = '26.819860', orientation = '1.229912' WHERE guid = '40526';
-- Зас'тиш (офф)
UPDATE creature SET position_x = '1991.060181', position_y = '-4652.371582', position_z = '27.069012', orientation = '6.272167' WHERE guid = '284933';
-- Мурчаль (офф)
DELETE FROM creature WHERE guid = '4456716';
INSERT INTO creature VALUES (4456716,15186,1,1,1,0,3915,1991.73,-4651.38,27.0136,6.11115,25,0,0,42,0,0,0);
-- Гурчаль (офф)
DELETE FROM creature WHERE guid = '4456718';
INSERT INTO creature VALUES (4456718,16069,1,1,1,0,3915,1989.66,-4657.17,27.346,0.607085,25,0,0,42,0,0,0);
-- Ксон'ча (офф)
UPDATE creature SET position_x = '2140.487061', position_y = '-4651.901367', position_z = '50.234417', orientation = '1.927016' WHERE guid = '40676';
-- Огунаро Волкопас (офф)
UPDATE creature SET position_x = '2160.095947', position_y = '-4654.399414', position_z = '49.623714', orientation = '2.857707' WHERE guid = '40698';
-- Волки (офф)
DELETE FROM creature WHERE guid = '40692';
DELETE FROM creature_addon WHERE guid = '40692';
DELETE FROM creature_movement WHERE id = '40692';
DELETE FROM game_event_creature WHERE guid = '40692';
DELETE FROM game_event_model_equip WHERE guid = '40692';
DELETE FROM creature WHERE guid = '40706';
DELETE FROM creature_addon WHERE guid = '40706';
DELETE FROM creature_movement WHERE id = '40706';
DELETE FROM game_event_creature WHERE guid = '40706';
DELETE FROM game_event_model_equip WHERE guid = '40706';
DELETE FROM creature WHERE guid = '40704';
DELETE FROM creature_addon WHERE guid = '40704';
DELETE FROM creature_movement WHERE id = '40704';
DELETE FROM game_event_creature WHERE guid = '40704';
DELETE FROM game_event_model_equip WHERE guid = '40704';
DELETE FROM creature WHERE guid = '40693';
DELETE FROM creature_addon WHERE guid = '40693';
DELETE FROM creature_movement WHERE id = '40693';
DELETE FROM game_event_creature WHERE guid = '40693';
DELETE FROM game_event_model_equip WHERE guid = '40693';
UPDATE creature SET position_x = '2155.091309', position_y = '-4649.602539', position_z = '49.996510', orientation = '5.108641' WHERE guid = '40695';
-- Казул (офф)
UPDATE creature SET position_x = '1838.718994', position_y = '-4341.520020', position_z = '-15.475355', orientation = '3.528423' WHERE guid = '40393';
-- Кургул (офф)
UPDATE creature SET position_x = '1836.726196', position_y = '-4346.905273', position_z = '-14.854283', orientation = '3.654094' WHERE guid = '40397';
-- Кор'хус (офф)
UPDATE creature SET position_x = '1767.226440', position_y = '-4367.143066', position_z = '-16.019903', orientation = '5.530743' WHERE guid = '40310';
-- Кор'гхан (офф)
UPDATE creature SET position_x = '1805.453491', position_y = '-4285.564453', position_z = '6.843641', orientation = '3.251528' WHERE guid = '40319';
-- Гест (офф)
UPDATE creature SET position_x = '1792.051636', position_y = '-4278.662598', position_z = '7.283041', orientation = '4.763422' WHERE guid = '40356';
-- Кардрис Сновидец (офф)
UPDATE creature SET position_x = '1933.414307', position_y = '-4224.869629', position_z = '42.095337', orientation = '0.164915' WHERE guid = '40482';
-- Шиан'цу (офф)
UPDATE creature SET position_x = '1933.002808', position_y = '-4211.210449', position_z = '42.095711', orientation = '0.003906' WHERE guid = '40487';
-- Огнир Хранитель Огня (офф)
UPDATE creature SET position_x = '1921.294189', position_y = '-4212.276855', position_z = '42.095711', orientation = '5.354819' WHERE guid = '40455';
-- Кор'кронский гвардеец (офф)
UPDATE creature SET position_x = '1912.393188', position_y = '-4124.594727', position_z = '43.031418', orientation = '5.068145' WHERE guid = '40453';
-- Посол Певица Рассвета (офф)
UPDATE creature SET position_x = '1914.924438', position_y = '-4124.106445', position_z = '42.991863', orientation = '5.068148' WHERE guid = '55704';
-- Наставник Огненор (офф)
UPDATE creature SET position_x = '1939.075684', position_y = '-4133.517090', position_z = '40.917095', orientation = '4.039293' WHERE guid = '283828';
-- Отважный страж-рыцарь крови (офф)
DELETE FROM creature WHERE guid = '4456719';
INSERT INTO creature VALUES (4456719,23131,1,1,1,0,491,1938.63,-4131.95,40.9132,4.13746,25,0,0,4400,3155,0,0);
UPDATE creature SET position_x = '1940.688110', position_y = '-4133.651855', position_z = '40.920368', orientation = '4.039280' WHERE guid = '284655';
-- Вол'джин (офф)
UPDATE creature SET position_x = '1934.175049', position_y = '-4162.474121', position_z = '40.912605', orientation = '2.503833' WHERE guid = '40480';
-- Эйтригг (офф)
UPDATE creature SET position_x = '1906.457397', position_y = '-4161.517090', position_z = '40.919971', orientation = '0.858423' WHERE guid = '40484';
-- Моквар (офф)
UPDATE creature SET position_x = '1916.160400', position_y = '-4171.102539', position_z = '40.923264', orientation = '0.840355' WHERE guid = '51370';
-- Магениус (офф)
UPDATE creature SET position_x = '1890.352661', position_y = '-4321.363281', position_z = '23.169222', orientation = '4.508174' WHERE guid = '40441';
-- Энио (офф)
UPDATE creature SET position_x = '1472.646484', position_y = '-4224.073242', position_z = '42.959274', orientation = '2.067924' WHERE guid = '40050';
-- Продавец пива (офф)
DELETE FROM creature WHERE guid = '153999';
DELETE FROM creature_addon WHERE guid = '153999';
DELETE FROM creature_movement WHERE id = '153999';
DELETE FROM game_event_creature WHERE guid = '153999';
DELETE FROM game_event_model_equip WHERE guid = '153999';
-- Арнок (офф)
UPDATE creature SET position_x = '1482.352661', position_y = '-4159.618652', position_z = '43.793873', orientation = '0.704466' WHERE guid = '40065';

Поправил Минералы и Gold Vein
В Wetlands добавила 2 Голд Вейна (1734):

Code
INSERT INTO gameobject VALUES (802854, 1734, 0, 1, 1, -3534.04, -2400.71, 67.4701, 2.99661, 0, 0, 0.997374, 0.0724284, 1800, 100, 1);
INSERT INTO gameobject VALUES (802855, 1734, 0, 1, 1, -3423.74, -2121.62, 97.3274, 3.62807, 0, 0, 0.970563, -0.240847, 1800, 100, 1);

================================================================================================
Honor Quests for TBC
Code

UPDATE `quest_template` SET `ExclusiveGroup` = 11335 WHERE `entry` IN (11335, 11336, 11337, 11338);
UPDATE `quest_template` SET `ExclusiveGroup` = 11339 WHERE `entry` IN (11339, 11340, 11341, 11342);

Добавлено (31.05.2010, 19:26)
---------------------------------------------
Death Knights, quests auras севодня вам подарок smile
Quote

DELETE FROM `spell_area` WHERE `spell` IN (58354,58530,58551,58361);
INSERT INTO `spell_area` VALUES
/* spell, area, q_start, qs_active, q_end, aura, race, gender, autocast */
(58354, 4281, 13165, 1, 13188, 0, 1101, 2, 1), /* Chapter V at map 0 Acherus: The Ebon Hold*/
(58354, 4281, 13165, 1, 13189, 0, 690, 2, 1), /* Chapter V at map 0 Acherus: The Ebon Hold*/
(58530, 0, 13165, 0, 13188, -58354, 1101, 2, 1), /* Return to Stormwind (in all zones except where Chapter V applied)*/
(58551, 0, 13165, 0, 13189, -58354, 690, 2, 1), /* Return to Orgrimmar (in all zones except where Chapter V applied)*/
(58361, 4281, 13166, 1, 13166, 0, 0, 2, 1); /* The Might of Mograine, static version */

Добавлено (31.05.2010, 19:28)
---------------------------------------------
Удаление некоторых ГО и Gold Vein in Badlands 11 просто напросто лишние ГО удаление их!
Code

DELETE FROM gameobject WHERE guid = '11039';
DELETE FROM gameobject WHERE guid = '13491';
DELETE FROM gameobject WHERE guid = '3370';
DELETE FROM gameobject WHERE guid = '9291';
DELETE FROM gameobject WHERE guid = '8454';
DELETE FROM gameobject WHERE guid = '9139';
DELETE FROM gameobject WHERE guid = '3130';
DELETE FROM gameobject WHERE guid = '6962';
DELETE FROM gameobject WHERE guid = '1109';
DELETE FROM gameobject WHERE guid = '2617';
DELETE FROM gameobject WHERE guid = '12460';

Добавлено (31.05.2010, 19:30)
---------------------------------------------
Один Goldthorn (2046) висел в воздухе высоко над землей
Quote

DELETE FROM gameobject WHERE guid = '2764';

Ну и расставил 115 Gold Vein (1734)

INSERT INTO gameobject VALUES (821054, 1734, 0, 1, 1, -7329.57, -2272.38, 241.198, 4.24853, 0, 0, 0.850706, -0.525643, 1800, 100, 1);
INSERT INTO gameobject VALUES (821055, 1734, 0, 1, 1, -7378.71, -2331.15, 244.013, 4.72056, 0, 0, 0.704213, -0.709989, 1800, 100, 1);
INSERT INTO gameobject VALUES (821056, 1734, 0, 1, 1, -7430.11, -2330.57, 241.005, 3.60136, 0, 0, 0.973692, -0.227866, 1800, 100, 1);
INSERT INTO gameobject VALUES (821057, 1734, 0, 1, 1, -7390.57, -2296.99, 237.953, 0.970282, 0, 0, 0.466333, 0.884609, 1800, 100, 1);
INSERT INTO gameobject VALUES (821058, 1734, 0, 1, 1, -7336.4, -2262.49, 241.012, 1.88449, 0, 0, 0.808879, 0.587975, 1800, 100, 1);
INSERT INTO gameobject VALUES (821059, 1734, 0, 1, 1, -7361.36, -2263.64, 235.885, 1.16663, 0, 0, 0.550795, 0.834641, 1800, 100, 1);
INSERT INTO gameobject VALUES (821060, 1734, 0, 1, 1, -7379.6, -2267.56, 235.572, 3.38695, 0, 0, 0.992484, -0.122373, 1800, 100, 1);
INSERT INTO gameobject VALUES (821061, 1734, 0, 1, 1, -7409.7, -2261.8, 235.802, 2.21435, 0, 0, 0.89444, 0.447188, 1800, 100, 1);
INSERT INTO gameobject VALUES (821062, 1734, 0, 1, 1, -7411.13, -2266.71, 235.042, 2.21435, 0, 0, 0.89444, 0.447188, 1800, 100, 1);
INSERT INTO gameobject VALUES (821063, 1734, 0, 1, 1, -7385.82, -2235.96, 233.644, 0.538314, 0, 0, 0.265919, 0.963995, 1800, 100, 1);
INSERT INTO gameobject VALUES (821064, 1734, 0, 1, 1, -7389.63, -2233.87, 233.691, 1.65672, 0, 0, 0.736824, 0.676084, 1800, 100, 1);
INSERT INTO gameobject VALUES (821065, 1734, 0, 1, 1, -7449.05, -2273.72, 231.255, 5.89866, 0, 0, 0.191082, -0.981574, 1800, 100, 1);
INSERT INTO gameobject VALUES (821066, 1734, 0, 1, 1, -7477.28, -2285.68, 233.444, 5.46826, 0, 0, 0.396283, -0.918129, 1800, 100, 1);
INSERT INTO gameobject VALUES (821067, 1734, 0, 1, 1, -7472.14, -2246.85, 236.677, 1.52556, 0, 0, 0.690933, 0.722919, 1800, 100, 1);
INSERT INTO gameobject VALUES (821068, 1734, 0, 1, 1, -7415.96, -2457.2, 326.585, 0.897238, 0, 0, 0.433722, 0.901047, 1800, 100, 1);
INSERT INTO gameobject VALUES (821069, 1734, 0, 1, 1, -7347.88, -2476.49, 318.643, 4.57369, 0, 0, 0.754406, -0.656408, 1800, 100, 1);
INSERT INTO gameobject VALUES (821070, 1734, 0, 1, 1, -7316.84, -2453.59, 302.541, 5.78242, 0, 0, 0.247776, -0.968817, 1800, 100, 1);
INSERT INTO gameobject VALUES (821071, 1734, 0, 1, 1, -7245.73, -2454.09, 261.579, 6.22459, 0, 0, 0.0292912, -0.999571, 1800, 100, 1);
INSERT INTO gameobject VALUES (821072, 1734, 0, 1, 1, -7184.52, -2366.34, 241.805, 1.18312, 0, 0, 0.557657, 0.830071, 1800, 100, 1);
INSERT INTO gameobject VALUES (821073, 1734, 0, 1, 1, -7219.88, -2176.04, 300.166, 5.79106, 0, 0, 0.243589, -0.969878, 1800, 100, 1);
INSERT INTO gameobject VALUES (821074, 1734, 0, 1, 1, -7164.43, -2232.91, 295.309, 3.87861, 0, 0, 0.932866, -0.360224, 1800, 100, 1);
INSERT INTO gameobject VALUES (821075, 1734, 0, 1, 1, -7104.78, -2259.33, 277.37, 0.499827, 0, 0, 0.24732, 0.968934, 1800, 100, 1);
INSERT INTO gameobject VALUES (821076, 1734, 0, 1, 1, -6975.12, -2306.46, 255.739, 1.75018, 0, 0, 0.767602, 0.640927, 1800, 100, 1);
INSERT INTO gameobject VALUES (821077, 1734, 0, 1, 1, -6985.39, -2309.75, 250.395, 1.3457, 0, 0, 0.623218, 0.782048, 1800, 100, 1);
INSERT INTO gameobject VALUES (821078, 1734, 0, 1, 1, -6864.67, -2401.25, 250.799, 0.0152364, 0, 0, 0.00761812, 0.999971, 1800, 100, 1);
INSERT INTO gameobject VALUES (821079, 1734, 0, 1, 1, -6810.45, -2346.51, 277.779, 0.87996, 0, 0, 0.425921, 0.90476, 1800, 100, 1);
INSERT INTO gameobject VALUES (821080, 1734, 0, 1, 1, -6801.69, -2353.91, 284.909, 1.32607, 0, 0, 0.61551, 0.788129, 1800, 100, 1);
INSERT INTO gameobject VALUES (821081, 1734, 0, 1, 1, -6797.56, -2454.16, 263.983, 5.19337, 0, 0, 0.518339, -0.855175, 1800, 100, 1);
INSERT INTO gameobject VALUES (821082, 1734, 0, 1, 1, -6787.22, -2450.66, 266.357, 0.495904, 0, 0, 0.245419, 0.969417, 1800, 100, 1);
INSERT INTO gameobject VALUES (821083, 1734, 0, 1, 1, -6707.71, -2445.43, 281.948, 1.99601, 0, 0, 0.840393, 0.541978, 1800, 100, 1);
INSERT INTO gameobject VALUES (821084, 1734, 0, 1, 1, -6554.96, -2430.14, 294.574, 0.0568657, 0, 0, 0.028429, 0.999596, 1800, 100, 1);
INSERT INTO gameobject VALUES (821085, 1734, 0, 1, 1, -6517.79, -2460.89, 307.876, 4.51321, 0, 0, 0.773906, -0.633301, 1800, 100, 1);
INSERT INTO gameobject VALUES (821086, 1734, 0, 1, 1, -6475.59, -2380.36, 300.708, 1.52085, 0, 0, 0.689229, 0.724544, 1800, 100, 1);
INSERT INTO gameobject VALUES (821087, 1734, 0, 1, 1, -6546.56, -2449.97, 299.2, 5.89238, 0, 0, 0.194162, -0.980969, 1800, 100, 1);
INSERT INTO gameobject VALUES (821088, 1734, 0, 1, 1, -6548.19, -2453.82, 299.425, 6.2034, 0, 0, 0.0398839, -0.999204, 1800, 100, 1);
INSERT INTO gameobject VALUES (821089, 1734, 0, 1, 1, -6421.53, -2479.55, 336.172, 4.97503, 0, 0, 0.608426, -0.79361, 1800, 100, 1);
INSERT INTO gameobject VALUES (821090, 1734, 0, 1, 1, -6460.61, -2489.19, 307.99, 4.9821, 0, 0, 0.605618, -0.795756, 1800, 100, 1);
INSERT INTO gameobject VALUES (821091, 1734, 0, 1, 1, -6771.98, -2846.98, 246.912, 1.32922, 0, 0, 0.616751, 0.787159, 1800, 100, 1);
INSERT INTO gameobject VALUES (821092, 1734, 0, 1, 1, -6750.05, -2930.03, 249.829, 5.11719, 0, 0, 0.550529, -0.834816, 1800, 100, 1);
INSERT INTO gameobject VALUES (821093, 1734, 0, 1, 1, -6793.85, -2964.61, 249.311, 3.36654, 0, 0, 0.993682, -0.112235, 1800, 100, 1);
INSERT INTO gameobject VALUES (821094, 1734, 0, 1, 1, -6614.25, -2887.5, 261.992, 5.54916, 0, 0, 0.358828, -0.933404, 1800, 100, 1);
INSERT INTO gameobject VALUES (821095, 1734, 0, 1, 1, -6516.52, -2962, 277.047, 0.306628, 0, 0, 0.152714, 0.98827, 1800, 100, 1);
INSERT INTO gameobject VALUES (821096, 1734, 0, 1, 1, -6693.63, -3016.3, 261.488, 3.46471, 0, 0, 0.986977, -0.160859, 1800, 100, 1);
INSERT INTO gameobject VALUES (821097, 1734, 0, 1, 1, -6712.58, -3175.5, 263.93, 4.59176, 0, 0, 0.748444, -0.663198, 1800, 100, 1);
INSERT INTO gameobject VALUES (821098, 1734, 0, 1, 1, -6895.32, -2792.96, 243.431, 1.09124, 0, 0, 0.518948, 0.854806, 1800, 100, 1);
INSERT INTO gameobject VALUES (821099, 1734, 0, 1, 1, -6902.1, -2660.43, 249.495, 2.51281, 0, 0, 0.950985, 0.309237, 1800, 100, 1);
INSERT INTO gameobject VALUES (821100, 1734, 0, 1, 1, -6906.17, -2581.39, 248.737, 3.49063, 0, 0, 0.98481, -0.173635, 1800, 100, 1);
INSERT INTO gameobject VALUES (821101, 1734, 0, 1, 1, -6960.47, -2583.22, 279.506, 4.71193, 0, 0, 0.70727, -0.706943, 1800, 100, 1);
INSERT INTO gameobject VALUES (821102, 1734, 0, 1, 1, -7056.29, -2521.08, 271.607, 2.52459, 0, 0, 0.95279, 0.30363, 1800, 100, 1);
INSERT INTO gameobject VALUES (821103, 1734, 0, 1, 1, -7131.2, -2541.83, 300.039, 2.22064, 0, 0, 0.895841, 0.444374, 1800, 100, 1);
INSERT INTO gameobject VALUES (821104, 1734, 0, 1, 1, -7254.17, -2585.3, 287.202, 2.85289, 0, 0, 0.989599, 0.143851, 1800, 100, 1);
INSERT INTO gameobject VALUES (821105, 1734, 0, 1, 1, -7177.84, -2727.8, 265.317, 4.95933, 0, 0, 0.614639, -0.788808, 1800, 100, 1);
INSERT INTO gameobject VALUES (821106, 1734, 0, 1, 1, -7106.43, -2638.14, 264.88, 4.8965, 0, 0, 0.639113, -0.769113, 1800, 100, 1);
INSERT INTO gameobject VALUES (821107, 1734, 0, 1, 1, -7077.71, -2695.06, 256.118, 1.21926, 0, 0, 0.572565, 0.819859, 1800, 100, 1);
INSERT INTO gameobject VALUES (821108, 1734, 0, 1, 1, -6997.29, -2664.46, 297.205, 3.06574, 0, 0, 0.999281, 0.0379197, 1800, 100, 1);
INSERT INTO gameobject VALUES (821109, 1734, 0, 1, 1, -7003.28, -2658.32, 296.287, 5.00489, 0, 0, 0.596513, -0.802603, 1800, 100, 1);
INSERT INTO gameobject VALUES (821110, 1734, 0, 1, 1, -6998.16, -2748.07, 248.786, 3.30215, 0, 0, 0.99678, -0.0801901, 1800, 100, 1);
INSERT INTO gameobject VALUES (821111, 1734, 0, 1, 1, -7096.79, -2871.14, 242.775, 5.90024, 0, 0, 0.190303, -0.981725, 1800, 100, 1);
INSERT INTO gameobject VALUES (821112, 1734, 0, 1, 1, -7158.56, -2867.37, 251.054, 2.86468, 0, 0, 0.99043, 0.138015, 1800, 100, 1);
INSERT INTO gameobject VALUES (821113, 1734, 0, 1, 1, -7162.4, -2871.42, 255.557, 2.86468, 0, 0, 0.99043, 0.138015, 1800, 100, 1);
INSERT INTO gameobject VALUES (821114, 1734, 0, 1, 1, -7146.51, -2996.19, 263.566, 4.17001, 0, 0, 0.870682, -0.491847, 1800, 100, 1);
INSERT INTO gameobject VALUES (821115, 1734, 0, 1, 1, -7184.22, -3134.29, 275.24, 4.44804, 0, 0, 0.794128, -0.607751, 1800, 100, 1);
INSERT INTO gameobject VALUES (821116, 1734, 0, 1, 1, -7192.19, -3127.21, 287.018, 4.48103, 0, 0, 0.783997, -0.620765, 1800, 100, 1);
INSERT INTO gameobject VALUES (821117, 1734, 0, 1, 1, -7113.22, -3175.13, 242.356, 1.99289, 0, 0, 0.839544, 0.543292, 1800, 100, 1);
INSERT INTO gameobject VALUES (821118, 1734, 0, 1, 1, -7159.41, -3204.62, 251.052, 3.35555, 0, 0, 0.994283, -0.106776, 1800, 100, 1);
INSERT INTO gameobject VALUES (821119, 1734, 0, 1, 1, -7247.55, -3126.34, 316.012, 5.77222, 0, 0, 0.252712, -0.967542, 1800, 100, 1);
INSERT INTO gameobject VALUES (821120, 1734, 0, 1, 1, -7177.24, -3357.58, 252.594, 4.0789, 0, 0, 0.892177, -0.451686, 1800, 100, 1);
INSERT INTO gameobject VALUES (821121, 1734, 0, 1, 1, -7345.91, -3478.9, 336.196, 3.96659, 0, 0, 0.916122, -0.4009, 1800, 100, 1);
INSERT INTO gameobject VALUES (821122, 1734, 0, 1, 1, -7251.39, -3465.28, 311.933, 5.01196, 0, 0, 0.593671, -0.804708, 1800, 100, 1);
INSERT INTO gameobject VALUES (821123, 1734, 0, 1, 1, -7146.29, -3491.21, 261.902, 5.52325, 0, 0, 0.37089, -0.928677, 1800, 100, 1);
INSERT INTO gameobject VALUES (821124, 1734, 0, 1, 1, -7117.95, -3609.61, 261.867, 1.41013, 0, 0, 0.648082, 0.761571, 1800, 100, 1);
INSERT INTO gameobject VALUES (821125, 1734, 0, 1, 1, -7095.52, -3688.28, 253.619, 3.65244, 0, 0, 0.967556, -0.252655, 1800, 100, 1);
INSERT INTO gameobject VALUES (821126, 1734, 0, 1, 1, -7090.73, -3698.87, 257.359, 5.39838, 0, 0, 0.428112, -0.903726, 1800, 100, 1);
INSERT INTO gameobject VALUES (821127, 1734, 0, 1, 1, -6952.59, -3593.57, 241.667, 6.17592, 0, 0, 0.0536048, -0.998562, 1800, 100, 1);
INSERT INTO gameobject VALUES (821128, 1734, 0, 1, 1, -6946.92, -3663.35, 255.161, 4.92557, 0, 0, 0.627866, -0.778322, 1800, 100, 1);
INSERT INTO gameobject VALUES (821129, 1734, 0, 1, 1, -6997.02, -3862.6, 296.004, 0.531268, 0, 0, 0.262521, 0.964926, 1800, 100, 1);
INSERT INTO gameobject VALUES (821130, 1734, 0, 1, 1, -6905.56, -3888.5, 275.465, 1.14309, 0, 0, 0.540932, 0.841066, 1800, 100, 1);
INSERT INTO gameobject VALUES (821131, 1734, 0, 1, 1, -6987.29, -3969.51, 274.928, 3.64929, 0, 0, 0.967952, -0.251133, 1800, 100, 1);
INSERT INTO gameobject VALUES (821132, 1734, 0, 1, 1, -6980.09, -4087.76, 279.826, 2.16332, 0, 0, 0.882739, 0.469864, 1800, 100, 1);
INSERT INTO gameobject VALUES (821133, 1734, 0, 1, 1, -6973.48, -4072.09, 278.91, 0.451151, 0, 0, 0.223667, 0.974666, 1800, 100, 1);
INSERT INTO gameobject VALUES (821134, 1734, 0, 1, 1, -6878.39, -4144.56, 278.657, 2.84661, 0, 0, 0.989143, 0.146955, 1800, 100, 1);
INSERT INTO gameobject VALUES (821135, 1734, 0, 1, 1, -6811.75, -4040.05, 266.576, 3.65558, 0, 0, 0.967159, -0.254173, 1800, 100, 1);
INSERT INTO gameobject VALUES (821136, 1734, 0, 1, 1, -6798.78, -4167.57, 269.25, 0.00269127, 0, 0, 0.00134563, 0.999999, 1800, 100, 1);
INSERT INTO gameobject VALUES (821137, 1734, 0, 1, 1, -6695, -4017.82, 266.809, 2.55445, 0, 0, 0.957217, 0.289372, 1800, 100, 1);
INSERT INTO gameobject VALUES (821138, 1734, 0, 1, 1, -6703.06, -4016.42, 268.47, 3.42546, 0, 0, 0.989944, -0.141456, 1800, 100, 1);
INSERT INTO gameobject VALUES (821139, 1734, 0, 1, 1, -6653.77, -4029.87, 269.413, 0.985227, 0, 0, 0.47293, 0.8811, 1800, 100, 1);
INSERT INTO gameobject VALUES (821140, 1734, 0, 1, 1, -6646.99, -4033.67, 267.629, 1.30253, 0, 0, 0.606192, 0.795318, 1800, 100, 1);
INSERT INTO gameobject VALUES (821141, 1734, 0, 1, 1, -6613.19, -4025.58, 269.628, 0.341201, 0, 0, 0.169774, 0.985483, 1800, 100, 1);
INSERT INTO gameobject VALUES (821142, 1734, 0, 1, 1, -6636.95, -4133.6, 277.628, 4.5525, 0, 0, 0.761316, -0.648381, 1800, 100, 1);
INSERT INTO gameobject VALUES (821143, 1734, 0, 1, 1, -6551.71, -4159.52, 288.595, 5.9403, 0, 0, 0.170602, -0.98534, 1800, 100, 1);
INSERT INTO gameobject VALUES (821144, 1734, 0, 1, 1, -6437.76, -4170.46, 295.72, 4.41113, 0, 0, 0.805208, -0.592993, 1800, 100, 1);
INSERT INTO gameobject VALUES (821145, 1734, 0, 1, 1, -6444.91, -4054.17, 276.617, 1.83189, 0, 0, 0.793138, 0.609042, 1800, 100, 1);
INSERT INTO gameobject VALUES (821146, 1734, 0, 1, 1, -6442.1, -4064.66, 274.389, 1.83189, 0, 0, 0.793138, 0.609042, 1800, 100, 1);
INSERT INTO gameobject VALUES (821147, 1734, 0, 1, 1, -6466.52, -3891.4, 323.375, 3.48672, 0, 0, 0.985148, -0.171708, 1800, 100, 1);
INSERT INTO gameobject VALUES (821148, 1734, 0, 1, 1, -6456.61, -3880.87, 317.362, 2.49633, 0, 0, 0.948405, 0.317062, 1800, 100, 1);
INSERT INTO gameobject VALUES (821149, 1734, 0, 1, 1, -6608.55, -3704.71, 267.735, 5.43137, 0, 0, 0.41315, -0.910663, 1800, 100, 1);
INSERT INTO gameobject VALUES (821286, 1734, 0, 1, 1, -6742.8, -3791.05, 266.016, 5.92819, 0, 0, 0.176568, -0.984288, 1800, 100, 1);
INSERT INTO gameobject VALUES (821287, 1734, 0, 1, 1, -6815.85, -3642.47, 265.891, 3.58613, 0, 0, 0.9754, -0.220444, 1800, 100, 1);
INSERT INTO gameobject VALUES (821288, 1734, 0, 1, 1, -6642.48, -3542.16, 254.495, 5.93761, 0, 0, 0.171927, -0.98511, 1800, 100, 1);
INSERT INTO gameobject VALUES (821289, 1734, 0, 1, 1, -6471.42, -3375.27, 255.782, 1.0705, 0, 0, 0.510057, 0.86014, 1800, 100, 1);
INSERT INTO gameobject VALUES (821290, 1734, 0, 1, 1, -6770.48, -3355.61, 248.251, 3.26334, 0, 0, 0.998148, -0.0608338, 1800, 100, 1);
INSERT INTO gameobject VALUES (821291, 1734, 0, 1, 1, -6771.27, -3349.13, 247.434, 3.26334, 0, 0, 0.998148, -0.0608338, 1800, 100, 1);
INSERT INTO gameobject VALUES (821292, 1734, 0, 1, 1, -6861.75, -3299.52, 269.344, 2.57533, 0, 0, 0.960185, 0.279365, 1800, 100, 1);
INSERT INTO gameobject VALUES (821293, 1734, 0, 1, 1, -6794.62, -3199.73, 264.612, 1.42786, 0, 0, 0.654809, 0.755795, 1800, 100, 1);
INSERT INTO gameobject VALUES (821294, 1734, 0, 1, 1, -6878.24, -3123.19, 262.519, 3.38507, 0, 0, 0.992599, -0.121439, 1800, 100, 1);
INSERT INTO gameobject VALUES (821295, 1734, 0, 1, 1, -6979.8, -3107.82, 257.95, 5.39883, 0, 0, 0.427907, -0.903823, 1800, 100, 1);
INSERT INTO gameobject VALUES (821296, 1734, 0, 1, 1, -6973.45, -3115.57, 264.438, 5.39883, 0, 0, 0.427907, -0.903823, 1800, 100, 1);
INSERT INTO gameobject VALUES (821297, 1734, 0, 1, 1, -6715.33, -3185.53, 268.149, 4.49091, 0, 0, 0.780919, -0.624632, 1800, 100, 1);
INSERT INTO gameobject VALUES (821298, 1734, 0, 1, 1, -6298.39, -3561.7, 253.729, 5.45774, 0, 0, 0.401106, -0.916031, 1800, 100, 1);
INSERT INTO gameobject VALUES (821299, 1734, 0, 1, 1, -6298.91, -3569.21, 256.123, 5.45774, 0, 0, 0.401106, -0.916031, 1800, 100, 1);
INSERT INTO gameobject VALUES (821300, 1734, 0, 1, 1, -6229.48, -3471.97, 251.641, 6.24078, 0, 0, 0.0212016, -0.999775, 1800, 100, 1);
INSERT INTO gameobject VALUES (821301, 1734, 0, 1, 1, -6176.28, -3375.48, 243.207, 1.45692, 0, 0, 0.665721, 0.746201, 1800, 100, 1);
INSERT INTO gameobject VALUES (821302, 1734, 0, 1, 1, -6169.61, -3363.01, 251.111, 1.1459, 0, 0, 0.542114, 0.840305, 1800, 100, 1);
INSERT INTO gameobject VALUES (821303, 1734, 0, 1, 1, -6118.55, -3429.88, 258.934, 5.41297, 0, 0, 0.421508, -0.906824, 1800, 100, 1);
INSERT INTO gameobject VALUES (821304, 1734, 0, 1, 1, -6117.13, -3434.42, 260.968, 5.41297, 0, 0, 0.421508, -0.906824, 1800, 100, 1);
Quote

Добавлено (31.05.2010, 19:31)
---------------------------------------------

 
Форум » MaNGOS » фиксы MaNGOS » Квесты,Мобы,Итемы,Фазы,Эвенты [множество фиксов здесь]
  • Страница 1 из 1
  • 1
Поиск: