Квесты,Мобы,Итемы,Фазы,Эвенты [Все Фиксы Здесь]

morgan-sevstar

Дата: Четверг, 19.11.2009, 21:29 | Сообщение # 1

Admin

Группа: Администраторы

Сообщений: 227

[ 2 ]

Статус: Offline

=================================================================================================
Дроп С мобов!

Code

-- Ключ Куэрго
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);

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

Code

-- Оргриммар
-- Харрук (офф)
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';

================================================================================================
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);

Целитель Душ

Code

UPDATE `creature_template` SET minhealth = 4120, maxhealth = 4120, speed = 0.0, scale = 0, rank = 0, mindmg = 0, maxdmg = 0, minrangedmg = 0, maxrangedmg = 0, rangedattackpower = 0 WHERE entry = 6491;
UPDATE `creature` SET curhealth = 4120 WHERE id = 6491;

Безумный дух воды
cам нпц

Code

UPDATE `creature_template` SET `mindmg` = 275, `maxdmg` = 295, `attackpower` = 1150, `minrangedmg` = 0, `maxrangedmg` = 0, `spell1` = 54400, `ScriptName` = 'generic_creature' WHERE `entry` = 16570;

morgan-sevstar

Дата: Четверг, 19.11.2009, 21:30 | Сообщение # 2

Admin

Группа: Администраторы

Сообщений: 227

[ 2 ]

Статус: Offline

Поправил Минералы и 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);

И передвинула 1 Голд Вейн:

Code

DELETE FROM gameobject WHERE guid = '5496';
INSERT INTO gameobject VALUES (5496, 1734, 0, 1, 1, -2844.08, -2992.33, 59.213, 5.76043, 0, 0, 0.258414, -0.966034, 1800, 100, 1);

В Duskwood добавила 4 Голд Вейна (1734):

Code

INSERT INTO gameobject VALUES (802857, 1734, 0, 1, 1, -11043.2, -51.3462, 17.7003, 3.09248, 0, 0, 0.999698, 0.0245547, 1800, 100, 1);
INSERT INTO gameobject VALUES (802858, 1734, 0, 1, 1, -10567.1, -725.964, 70.1982, 1.20045, 0, 0, 0.564829, 0.825208, 1800, 100, 1);
INSERT INTO gameobject VALUES (802861, 1734, 0, 1, 1, -11098.1, -1155.18, 42.4798, 0.102462, 0, 0, 0.0512087, 0.998688, 1800, 100, 1);
INSERT INTO gameobject VALUES (802862, 1734, 0, 1, 1, -11158.6, -1167.57, 42.3274, 3.01472, 0, 0, 0.997989, 0.0633952, 1800, 100, 1);

И передвинула 2 Голд Вйена:

Code

DELETE FROM gameobject WHERE guid = '3385';
INSERT INTO gameobject VALUES (3385, 1734, 0, 1, 1, -10661.6, -891.615, 57.5265, 2.23757, 0, 0, 0.89957, 0.436777, 1800, 100, 1);
DELETE FROM gameobject WHERE guid = '14516';
INSERT INTO gameobject VALUES (14516, 1734, 0, 1, 1, -11009, -990.563, 67.6881, 2.97859, 0, 0, 0.996681, 0.0814115, 1800, 100, 1);

В Eastern Plaguelands добавила 7 Голд Вейнов (1734):

Code

INSERT INTO gameobject VALUES (802863, 1734, 0, 1, 1, 1895.29, -3638.14, 132.566, 2.73963, 0, 0, 0.979871, 0.199633, 1800, 100, 1);
INSERT INTO gameobject VALUES (802864, 1734, 0, 1, 1, 1642.59, -3569.86, 136.493, 4.3819, 0, 0, 0.813791, -0.581158, 1800, 100, 1);
INSERT INTO gameobject VALUES (802865, 1734, 0, 1, 1, 1849.88, -3357.34, 119.168, 0.922217, 0, 0, 0.444941, 0.89556, 1800, 100, 1);
INSERT INTO gameobject VALUES (802866, 1734, 0, 1, 1, 1898.66, -3132.48, 108.096, 4.59553, 0, 0, 0.747194, -0.664606, 1800, 100, 1);
INSERT INTO gameobject VALUES (802867, 1734, 0, 1, 1, 2067.97, -2985.32, 90.9151, 0.322958, 0, 0, 0.160778, 0.986991, 1800, 100, 1);
INSERT INTO gameobject VALUES (802868, 1734, 0, 1, 1, 2224.72, -2743.57, 84.5659, 0.520878, 0, 0, 0.257505, 0.966277, 1800, 100, 1);
INSERT INTO gameobject VALUES (802869, 1734, 0, 1, 1, 1788.21, -2718.1, 87.6156, 1.16491, 0, 0, 0.550075, 0.835115, 1800, 100, 1);

В Stonetalon Mountains добавила 4 Голд Вейна (1734):

Code

INSERT INTO gameobject VALUES (802870, 1734, 1, 1,1,793.431, 1395.21, 0.576849, 5.57467, 0, 0, 0.346894, -0.937904, 1800, 100, 1);
INSERT INTO gameobject VALUES (802872, 1734, 1, 1,1,537.727, 1409.26, 18.8321, 0.134218, 0, 0, 0.0670585, 0.997749, 1800, 100, 1);
INSERT INTO gameobject VALUES (802877, 1734, 1, 1,1,998.437, 1653.53, 11.4899, 4.74765, 0, 0, 0.69453, -0.719463, 1800, 100, 1);
INSERT INTO gameobject VALUES (802878, 1734, 1, 1,1,1394.59, 1514.84, 146.875, 0.442885, 0, 0, 0.219637, 0.975582, 1800, 100, 1);

И переставила 5 Голд Вейнов:

Code

DELETE FROM gameobject WHERE guid = '15019';
INSERT INTO gameobject VALUES (15019, 1734, 1, 1,1,659.925, 1398.88, 23.7537, 4.24656, 0, 0, 0.851223, -0.524804, 1800, 100, 1);
DELETE FROM gameobject WHERE guid = '12357';
INSERT INTO gameobject VALUES (12357, 1734, 1, 1,1,444.309, 1607.92, 26.1591, 3.05904, 0, 0, 0.999148, 0.0412636, 1800, 100, 1);
DELETE FROM gameobject WHERE guid = '11636';
INSERT INTO gameobject VALUES (11636, 1734, 1, 1,1,588.781, 1907.09, 20.2303, 0.913333, 0, 0, 0.440959, 0.897527, 1800, 100, 1);
DELETE FROM gameobject WHERE guid = '4441';
INSERT INTO gameobject VALUES (4441, 1734, 1, 1,1,853.332, 1920.69, 20.9891, 1.54244, 0, 0, 0.69701, 0.717062, 1800, 100, 1);
DELETE FROM gameobject WHERE guid = '14910';
INSERT INTO gameobject VALUES (14910, 1734, 1, 1,1,960.766, 1778.07, 12.4971, 6.01371, 0, 0, 0.134329, -0.990937, 1800, 100, 1);

Поправил Квест
UPDATE `quest_template` SET `ReqCreatureOrGOId1` = -192135, `ReqCreatureOrGOCount1` = 8 WHERE `entry` = 12982;
Все я думаю это все на седня завтро ждем новых фиксов!

morgan-sevstar

Дата: Четверг, 19.11.2009, 21:30 | Сообщение # 3

Admin

Группа: Администраторы

Сообщений: 227

[ 2 ]

Статус: Offline

Ну так последний штрих даларана Порталы на БГ

Code

#-- Alterac Valley
#Wintergrasp
INSERT INTO `battlemaster_entry` (`entry`, `bg_template`) VALUES
(32616, 7);
INSERT INTO `battlemaster_entry` (`entry`, `bg_template`) VALUES
(32617, 7);
#Dalaran
UPDATE `creature_template` SET `IconName` = 'Interact', `faction_A` = 714, `faction_H` = 714 WHERE `entry` = 29669;
UPDATE `creature_template` SET `IconName` = 'Interact', `faction_A` = 534, `faction_H` = 534 WHERE `entry` = 29674;
#поменял местами были попутаны
UPDATE `creature` SET `id`=29669 WHERE `guid` = 137926;
UPDATE `creature` SET `id`=29674 WHERE `guid` = 113465;

#-- Strand of the Ancients
#Wintergrasp
INSERT INTO `battlemaster_entry` (`entry`, `bg_template`) VALUES
(32622, 9);
INSERT INTO `battlemaster_entry` (`entry`, `bg_template`) VALUES
(32623, 9);
#Dalaran
UPDATE `creature_template` SET `IconName` = 'Interact', `faction_A` = 534, `faction_H` = 534 WHERE `entry` = 29671;
UPDATE `creature_template` SET `IconName` = 'Interact', `faction_A` = 714, `faction_H` = 714 WHERE `entry` = 29676;
#орды и альянса стояли в одной точке спауна, перенес на свое место орды
DELETE FROM `creature` WHERE `id`=29676;
INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`sp awndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`) VALUES
(113664, 29676, 571, 1, 1, 0, 0, 5974.76, 544.652, 661.779, 1.97222, 300, 0, 0, 5342, 0, 0, 0);

#-- Eye of the Storm
#Wintergrasp
INSERT INTO `battlemaster_entry` (`entry`, `bg_template`) VALUES
(32620, 1);
INSERT INTO `battlemaster_entry` (`entry`, `bg_template`) VALUES
(32621, 1);
#Dalaran
UPDATE `creature_template` SET `IconName` = 'Interact', `faction_A` = 534, `faction_H` = 534 WHERE `entry` = 29670;
UPDATE `creature_template` SET `IconName` = 'Interact', `faction_A` = 714, `faction_H` = 714 WHERE `entry` = 29675;

#-- Arathi Basin
#Wintergrasp
INSERT INTO `battlemaster_entry` (`entry`, `bg_template`) VALUES
(32618, 3);
INSERT INTO `battlemaster_entry` (`entry`, `bg_template`) VALUES
(32619, 3);
#Dalaran
UPDATE `creature_template` SET `IconName` = 'Interact', `faction_A` = 534, `faction_H` = 534 WHERE `entry` = 29668;
UPDATE `creature_template` SET `IconName` = 'Interact', `faction_A` = 714, `faction_H` = 714 WHERE `entry` = 29673;

#-- Strand of the Ancients
#Wintergrasp
INSERT INTO `battlemaster_entry` (`entry`, `bg_template`) VALUES
(32624, 2);
INSERT INTO `battlemaster_entry` (`entry`, `bg_template`) VALUES
(32625, 2);
#Dalaran
UPDATE `creature_template` SET `IconName` = 'Interact', `faction_A` = 534, `faction_H` = 534, `npcflag` = 1048576, `unit_flags` = 4096, `flags_extra` = 2 WHERE `entry` = 29667;
UPDATE `creature_template` SET `IconName` = 'Interact', `faction_A` = 714, `faction_H` = 714, `npcflag` = 1048576, `unit_flags` = 4096, `flags_extra` = 2 WHERE `entry` = 29672;

#-- расстановка флагов (так как gossip_ом туго поставил все-таки 1048576)
#чтобы отключить ставим `npcflag` = 1048577 будет просто приветствовать
UPDATE `creature_template` SET `npcflag` = 1048576, `unit_flags` = 4096, `flags_extra` = 2  WHERE `entry` in (29667, 29668, 29670, 29671,29672, 29673, 29675, 29676, 32616, 32617,32618,32619,32620,32621,32622,32623,32624,32625);

Правка по оставшимся мобам в Wintergrasp

Code

#-- Wintergrasp
UPDATE `creature_template` SET `faction_A` = 91, `faction_H` = 91, `mindmg` = 315, `maxdmg` = 548, `spell1` = 43543, `ScriptName` = 'generic_creature' WHERE `entry` = 30849;
UPDATE `creature_template` SET `minlevel` = 80, `maxlevel` = 80, `minhealth` = 25200, `maxhealth` = 25200, `minmana` = 3994, `maxmana` = 3994, `armor` = 7600, `faction_A` = 91, `faction_H` = 91, `mindmg` = 370, `maxdmg` = 816 WHERE `entry` = 30876;
UPDATE `creature_template` SET `faction_A` = 91, `faction_H` = 91 WHERE `entry` = 30873;
UPDATE `creature_template` SET `faction_A` = 91, `faction_H` = 91 WHERE `entry` = 30846;
UPDATE `creature_template` SET `faction_A` = 1802, `faction_H` = 1802, `modelid_H2` = 27941, `mindmg` = 217, `maxdmg` = 509, `attackpower` = 1088 WHERE `entry` = 30499;
UPDATE `creature_template` SET `modelid_H2` = 27937 WHERE `entry` = 30400;
UPDATE `creature_template` SET `modelid_H2` = 24468, `faction_A` = 168, `faction_H` = 168 WHERE `entry` = 30845;
UPDATE `creature_template` SET `faction_A` = 91, `faction_H` = 91 WHERE `entry` = 30847;
UPDATE `creature_template` SET `faction_A` = 91, `faction_H` = 91 WHERE `entry` = 30872;
UPDATE `creature_template` SET `minlevel` = 80, `maxlevel` = 80, `minhealth` = 25200, `maxhealth` = 25200, `armor` = 14500, `faction_A` = 91, `faction_H` = 91, `mindmg` = 355, `maxdmg` = 814, `spell1` = 56620, `ScriptName` = 'generic_creature' WHERE `entry` = 30875;
UPDATE `creature_template` SET `modelid_H2` = 25951, `faction_A` = 1891, `faction_H` = 1891, `spell1` = 42648, `spell2` = 11976, `ScriptName` = 'generic_creature' WHERE `entry` = 30740;
UPDATE `creature_template` SET `modelid_H2` = 25951, `minlevel` = 80, `maxlevel` = 80, `minhealth` = 63000, `maxhealth` = 63000, `minmana` = 11982, `maxmana` = 11982, `armor` = 7600, `faction_A` = 1891, `faction_H` = 1891, `mindmg` = 370, `maxdmg` = 816, `spell1` = 11976, `ScriptName` = 'generic_creature' WHERE `entry` = 32308;
UPDATE `creature_template` SET `faction_A` = 91, `faction_H` = 91 WHERE `entry` = 30842;
UPDATE `creature_template` SET `faction_A` = 1978, `faction_H` = 1978, `spell1` = 42648, `spell2` = 11976, mingold = 3340, maxgold = 3346, `ScriptName` = 'generic_creature' WHERE `entry` = 30739;
UPDATE `creature_template` SET `modelid_H2` = 24076, `minlevel` = 80, `maxlevel` = 80, `minhealth` = 63000, `maxhealth` = 63000, `armor` = 14500, `faction_A` = 1978, `faction_H` = 1978, `mindmg` = 355, `maxdmg` = 814, `spell1` = 11976, `ScriptName` = 'generic_creature' WHERE `entry` = 32307;
UPDATE `creature_template` SET `faction_A` = 91, `faction_H` = 91 WHERE `entry` = 30877;
UPDATE `creature_template` SET `type_flags` = 32, `RacialLeader` = 1 WHERE `entry` = 27850;
UPDATE `creature_template` SET `IconName` = 'vehichleCursor' WHERE `entry` = 27881;
UPDATE `creature_template` SET `modelid_A` = 27137, `modelid_H` = 27137, `IconName` = 'Interact' WHERE `entry` = 27852;
UPDATE `creature_template` SET `minhealth` = 50000, `maxhealth` = 50000, `modelid_A` = 27658, `modelid_H` = 27658, `IconName` = 'vehichleCursor' WHERE `entry` = 28094;
UPDATE `creature_template` SET `modelid_A` = 25292, `modelid_H` = 25292, `IconName` = 'vehichleCursor', `minhealth` = 75000, `maxhealth` = 75000 WHERE `entry` = 28312;
UPDATE `creature_template` SET `IconName` = 'vehichleCursor', `minlevel` = 80, `maxlevel` = 80, `minhealth` = 75000, `maxhealth` = 75000, `armor` = 14500, `faction_A` = 714, `faction_H` = 714, `mindmg` = 355, `maxdmg` = 814 WHERE `entry` = 32627;
UPDATE `creature_template` SET `IconName` = 'Gunner', `minhealth` = 50000, `maxhealth` = 50000 WHERE `entry` = 28319;
UPDATE `creature_template` SET `IconName` = 'Gunner', `minlevel` = 80, `maxlevel` = 80, `minhealth` = 50000, `maxhealth` = 50000, `armor` = 14500, `faction_A` = 714, `faction_H` = 714, `mindmg` = 355, `maxdmg` = 814 WHERE `entry` = 32629;

Strand of the Ancients

Code

UPDATE `creature_template` SET `IconName` = 'vehichleCursor', `maxlevel` = 80, `maxhealth` = 65951, `faction_A` = 14, `faction_H` = 14, `maxdmg` = 460, `attackpower` = 1050 WHERE `entry` = 28781;
UPDATE `creature_template` SET `minlevel` = 70, `maxlevel` = 72, `minhealth` = 9610, `maxhealth` = 9610, `armor` = 7600, `faction_A` = 1891, `faction_H` = 1891, `mindmg` = 166, `maxdmg` = 355, `attackpower` = 941 WHERE `entry` = 32657;
UPDATE `creature_template` SET `IconName` = 'vehichleCursor', `maxlevel` = 80, `maxhealth` = 45000, `faction_A` = 534, `faction_H` = 534 WHERE `entry` = 27894;
UPDATE `creature_template` SET `minlevel` = 72, `maxlevel` = 72, `minhealth` = 9610, `maxhealth` = 9610, `armor` = 7600, `faction_A` = 1978, `faction_H` = 1978, `mindmg` = 142, `maxdmg` = 345, `attackpower` = 879 WHERE `entry` = 32659;

morgan-sevstar

Дата: Четверг, 19.11.2009, 21:32 | Сообщение # 4

Admin

Группа: Администраторы

Сообщений: 227

[ 2 ]

Статус: Offline

Удаление некоторых ГО и 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';

Один Goldthorn (2046) висел в воздухе высоко над землей

Code

DELETE FROM gameobject WHERE guid = '2764';

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

Code

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);

morgan-sevstar

Дата: Четверг, 19.11.2009, 21:32 | Сообщение # 5

Admin

Группа: Администраторы

Сообщений: 227

[ 2 ]

Статус: Offline

+ к этому
Gold Vein in Arathi Highlands раставил еще 131 Gold Vein
INSERT INTO gameobject VALUES (810254, 1734, 0, 1, 1, -584.479, -1839.46, 60.5804, 1.1233, 0, 0, 0.532582, 0.846378, 1800, 100, 1);
INSERT INTO gameobject VALUES (810255, 1734, 0, 1, 1, -569.212, -1978.71, 65.5826, 4.9419, 0, 0, 0.621489, -0.783423, 1800, 100, 1);
INSERT INTO gameobject VALUES (810256, 1734, 0, 1, 1, -678.852, -2016.7, 59.6444, 6.05088, 0, 0, 0.11589, -0.993262, 1800, 100, 1);
INSERT INTO gameobject VALUES (810257, 1734, 0, 1, 1, -649.234, -2104.33, 72.7789, 4.52878, 0, 0, 0.768953, -0.639305, 1800, 100, 1);
INSERT INTO gameobject VALUES (810258, 1734, 0, 1, 1, -737.639, -2169.19, 57.6467, 5.13904, 0, 0, 0.541377, -0.84078, 1800, 100, 1);
INSERT INTO gameobject VALUES (810259, 1734, 0, 1, 1, -687.785, -2245.78, 74.5095, 5.40214, 0, 0, 0.42641, -0.90453, 1800, 100, 1);
INSERT INTO gameobject VALUES (810260, 1734, 0, 1, 1, -809.585, -2331.9, 72.431, 3.49206, 0, 0, 0.984686, -0.174336, 1800, 100, 1);
INSERT INTO gameobject VALUES (810261, 1734, 0, 1, 1, -886.959, -2365.08, 67.6451, 3.269, 0, 0, 0.997972, -0.0636618, 1800, 100, 1);
INSERT INTO gameobject VALUES (810262, 1734, 0, 1, 1, -891.835, -2422.24, 63.5749, 4.53035, 0, 0, 0.768451, -0.639909, 1800, 100, 1);
INSERT INTO gameobject VALUES (810263, 1734, 0, 1, 1, -891.395, -2435, 61.5424, 4.88378, 0, 0, 0.64399, -0.765034, 1800, 100, 1);
INSERT INTO gameobject VALUES (810264, 1734, 0, 1, 1, -954.047, -2242.47, 52.3016, 1.96288, 0, 0, 0.8313, 0.555824, 1800, 100, 1);
INSERT INTO gameobject VALUES (810265, 1734, 0, 1, 1, -967.628, -2231.73, 60.629, 2.73336, 0, 0, 0.979241, 0.202702, 1800, 100, 1);
INSERT INTO gameobject VALUES (810266, 1734, 0, 1, 1, -1172.15, -2258.94, 61.4906, 4.61518, 0, 0, 0.740628, -0.671915, 1800, 100, 1);
INSERT INTO gameobject VALUES (810267, 1734, 0, 1, 1, -1210.79, -2090.68, 51.5461, 4.26489, 0, 0, 0.846379, -0.532581, 1800, 100, 1);
INSERT INTO gameobject VALUES (810268, 1734, 0, 1, 1, -1249.8, -2064.62, 50.3023, 2.49774, 0, 0, 0.948628, 0.316394, 1800, 100, 1);
INSERT INTO gameobject VALUES (810269, 1734, 0, 1, 1, -1248.76, -2050.76, 51.3437, 3.56981, 0, 0, 0.977166, -0.212477, 1800, 100, 1);
INSERT INTO gameobject VALUES (810270, 1734, 0, 1, 1, -1225.35, -2058.99, 46.9182, 5.49404, 0, 0, 0.384415, -0.92316, 1800, 100, 1);
INSERT INTO gameobject VALUES (810271, 1734, 0, 1, 1, -1245.86, -2007.63, 43.9869, 2.50089, 0, 0, 0.949124, 0.314902, 1800, 100, 1);
INSERT INTO gameobject VALUES (810272, 1734, 0, 1, 1, -1192.25, -1954.92, 26.6624, 2.61948, 0, 0, 0.966118, 0.258101, 1800, 100, 1);
INSERT INTO gameobject VALUES (810273, 1734, 0, 1, 1, -1200.84, -2055, 40.8337, 4.00178, 0, 0, 0.908926, -0.416957, 1800, 100, 1);
INSERT INTO gameobject VALUES (810274, 1734, 0, 1, 1, -1188.75, -2056.95, 43.0545, 4.81389, 0, 0, 0.670327, -0.742066, 1800, 100, 1);
INSERT INTO gameobject VALUES (810275, 1734, 0, 1, 1, -1142.48, -2088.89, 73.1039, 1.2254, 0, 0, 0.575079, 0.818098, 1800, 100, 1);
INSERT INTO gameobject VALUES (810276, 1734, 0, 1, 1, -929.341, -1973.91, 65.2201, 6.21111, 0, 0, 0.0360308, -0.999351, 1800, 100, 1);
INSERT INTO gameobject VALUES (810277, 1734, 0, 1, 1, -860.814, -1812.04, 47.6072, 1.43746, 0, 0, 0.658428, 0.752643, 1800, 100, 1);
INSERT INTO gameobject VALUES (810278, 1734, 0, 1, 1, -862.343, -1804.31, 48.2087, 2.01237, 0, 0, 0.844797, 0.535088, 1800, 100, 1);
INSERT INTO gameobject VALUES (810279, 1734, 0, 1, 1, -1008.57, -1748.18, 46.1088, 3.48813, 0, 0, 0.985026, -0.172405, 1800, 100, 1);
INSERT INTO gameobject VALUES (810280, 1734, 0, 1, 1, -1018.54, -1752.94, 50.2535, 3.62087, 0, 0, 0.971424, -0.23735, 1800, 100, 1);
INSERT INTO gameobject VALUES (810281, 1734, 0, 1, 1, -932.684, -1564, 54.6593, 1.71157, 0, 0, 0.755084, 0.655628, 1800, 100, 1);
INSERT INTO gameobject VALUES (810282, 1734, 0, 1, 1, -934.252, -1552.94, 59.1453, 1.71157, 0, 0, 0.755084, 0.655628, 1800, 100, 1);
INSERT INTO gameobject VALUES (810283, 1734, 0, 1, 1, -1678.01, -1441.28, 47.4349, 1.49794, 0, 0, 0.680885, 0.732391, 1800, 100, 1);
INSERT INTO gameobject VALUES (810284, 1734, 0, 1, 1, -1830.5, -1442.91, 59.8908, 4.90107, 0, 0, 0.637352, -0.770573, 1800, 100, 1);
INSERT INTO gameobject VALUES (810285, 1734, 0, 1, 1, -2152.04, -1561.94, -47.6998, 5.91267, 0, 0, 0.184202, -0.982888, 1800, 100, 1);
INSERT INTO gameobject VALUES (810286, 1734, 0, 1, 1, -2346.95, -1644.32, -13.7785, 2.57079, 0, 0, 0.959549, 0.28154, 1800, 100, 1);
INSERT INTO gameobject VALUES (810287, 1734, 0, 1, 1, -2361.88, -1754.27, -15.3339, 3.46301, 0, 0, 0.987114, -0.160016, 1800, 100, 1);
INSERT INTO gameobject VALUES (810288, 1734, 0, 1, 1, -2243.17, -1841.11, 0.387506, 4.48245, 0, 0, 0.783554, -0.621324, 1800, 100, 1);
INSERT INTO gameobject VALUES (810289, 1734, 0, 1, 1, -2173.92, -1789.33, -40.554, 5.09507, 0, 0, 0.559729, -0.828676, 1800, 100, 1);
INSERT INTO gameobject VALUES (810290, 1734, 0, 1, 1, -2189.63, -1730.62, -57.168, 2.94701, 0, 0, 0.995271, 0.09714, 1800, 100, 1);
INSERT INTO gameobject VALUES (810291, 1734, 0, 1, 1, -2180.68, -1665.21, -33.8272, 0.965446, 0, 0, 0.464193, 0.885734, 1800, 100, 1);
INSERT INTO gameobject VALUES (810292, 1734, 0, 1, 1, -2112.53, -1624.25, -1.23816, 0.136065, 0, 0, 0.06798, 0.997687, 1800, 100, 1);
INSERT INTO gameobject VALUES (810293, 1734, 0, 1, 1, -1923.62, -1671.74, 58.9442, 3.66957, 0, 0, 0.965357, -0.260933, 1800, 100, 1);
INSERT INTO gameobject VALUES (810294, 1734, 0, 1, 1, -1929.03, -1683.65, 56.4865, 4.53508, 0, 0, 0.766937, -0.641723, 1800, 100, 1);
INSERT INTO gameobject VALUES (810295, 1734, 0, 1, 1, -1850.42, -1762.68, 66.1119, 4.62304, 0, 0, 0.73798, -0.674823, 1800, 100, 1);
INSERT INTO gameobject VALUES (810296, 1734, 0, 1, 1, -1828.93, -1811.66, 62.3482, 4.28061, 0, 0, 0.842166, -0.539218, 1800, 100, 1);
INSERT INTO gameobject VALUES (810297, 1734, 0, 1, 1, -1820.61, -2009.96, 68.2966, 3.28394, 0, 0, 0.997468, -0.0711123, 1800, 100, 1);
INSERT INTO gameobject VALUES (810298, 1734, 0, 1, 1, -1746.66, -2091.55, 70.2322, 5.88046, 0, 0, 0.200002, -0.979795, 1800, 100, 1);
INSERT INTO gameobject VALUES (810299, 1734, 0, 1, 1, -1619.68, -2115.64, 36.5849, 6.00456, 0, 0, 0.138864, -0.990312, 1800, 100, 1);
INSERT INTO gameobject VALUES (810300, 1734, 0, 1, 1, -1654.9, -2208.33, 23.1356, 3.16613, 0, 0, 0.999925, -0.0122671, 1800, 100, 1);
INSERT INTO gameobject VALUES (810301, 1734, 0, 1, 1, -1746.19, -2358.48, 31.7954, 5.34325, 0, 0, 0.452856, -0.891583, 1800, 100, 1);
INSERT INTO gameobject VALUES (810302, 1734, 0, 1, 1, -1828.85, -2642.06, 58.3153, 5.83491, 0, 0, 0.222265, -0.974986, 1800, 100, 1);
INSERT INTO gameobject VALUES (810303, 1734, 0, 1, 1, -2063.41, -2678.13, 88.8456, 2.20716, 0, 0, 0.892825, 0.450405, 1800, 100, 1);
INSERT INTO gameobject VALUES (810304, 1734, 0, 1, 1, -1995.59, -2702.06, 84.9398, 4.0929, 0, 0, 0.888995, -0.457917, 1800, 100, 1);
INSERT INTO gameobject VALUES (810305, 1734, 0, 1, 1, -1974.63, -2760.98, 80.9, 6.27238, 0, 0, 0.00540484, -0.999985, 1800, 100, 1);
INSERT INTO gameobject VALUES (810306, 1734, 0, 1, 1, -1939.72, -2791.22, 85.4187, 3.18419, 0, 0, 0.999773, -0.0212978, 1800, 100, 1);
INSERT INTO gameobject VALUES (810307, 1734, 0, 1, 1, -1986.29, -2805.23, 82.0008, 4.41491, 0, 0, 0.804086, -0.594513, 1800, 100, 1);
INSERT INTO gameobject VALUES (810308, 1734, 0, 1, 1, -2004.96, -2825.69, 76.7799, 3.36562, 0, 0, 0.993733, -0.111779, 1800, 100, 1);
INSERT INTO gameobject VALUES (810309, 1734, 0, 1, 1, -2037.84, -2835.45, 79.6729, 3.76931, 0, 0, 0.951149, -0.308733, 1800, 100, 1);
INSERT INTO gameobject VALUES (810310, 1734, 0, 1, 1, -2070.28, -2812.7, 80.9901, 1.183, 0, 0, 0.557606, 0.830106, 1800, 100, 1);
INSERT INTO gameobject VALUES (810311, 1734, 0, 1, 1, -2049.36, -2787.73, 70.6035, 1.30709, 0, 0, 0.608006, 0.793933, 1800, 100, 1);
INSERT INTO gameobject VALUES (810312, 1734, 0, 1, 1, -2060.47, -2788.89, 68.564, 3.04596, 0, 0, 0.998857, 0.0477958, 1800, 100, 1);
INSERT INTO gameobject VALUES (810313, 1734, 0, 1, 1, -2090.04, -2849.61, 78.3668, 5.09193, 0, 0, 0.561029, -0.827796, 1800, 100, 1);
INSERT INTO gameobject VALUES (810314, 1734, 0, 1, 1, -1964.72, -2874.25, 79.4105, 4.00494, 0, 0, 0.908267, -0.418391, 1800, 100, 1);
INSERT INTO gameobject VALUES (810315, 1734, 0, 1, 1, -1972.98, -2920.26, 80.5534, 4.7495, 0, 0, 0.693867, -0.720103, 1800, 100, 1);
INSERT INTO gameobject VALUES (810316, 1734, 0, 1, 1, -1895.5, -2863.62, 71.7335, 2.55038, 0, 0, 0.956626, 0.291319, 1800, 100, 1);
INSERT INTO gameobject VALUES (810317, 1734, 0, 1, 1, -1893.49, -2870.03, 72.6842, 4.21857, 0, 0, 0.858485, -0.512839, 1800, 100, 1);
INSERT INTO gameobject VALUES (810318, 1734, 0, 1, 1, -1843.42, -2796.13, 64.6282, 1.61262, 0, 0, 0.721738, 0.692167, 1800, 100, 1);
INSERT INTO gameobject VALUES (810319, 1734, 0, 1, 1, -1684.98, -2838.05, 42.8783, 5.80193, 0, 0, 0.238311, -0.971189, 1800, 100, 1);
INSERT INTO gameobject VALUES (810320, 1734, 0, 1, 1, -1654.87, -2841.06, 43.8327, 0.423525, 0, 0, 0.210184, 0.977662, 1800, 100, 1);
INSERT INTO gameobject VALUES (810321, 1734, 0, 1, 1, -1843.96, -2927.45, 72.4504, 1.42726, 0, 0, 0.654583, 0.75599, 1800, 100, 1); [/code]

Code

INSERT INTO gameobject VALUES (810322, 1734, 0, 1, 1, -1908.44, -3044.06, 70.0324, 4.3026, 0, 0, 0.836185, -0.548447, 1800, 100, 1);
INSERT INTO gameobject VALUES (810323, 1734, 0, 1, 1, -1945.39, -3214.91, 79.4335, 3.28002, 0, 0, 0.997606, -0.0691565, 1800, 100, 1);
INSERT INTO gameobject VALUES (810324, 1734, 0, 1, 1, -1911, -3268.89, 71.6783, 5.17754, 0, 0, 0.525093, -0.851045, 1800, 100, 1);
INSERT INTO gameobject VALUES (810325, 1734, 0, 1, 1, -1935.52, -3320.59, 59.1494, 1.15315, 0, 0, 0.545158, 0.838333, 1800, 100, 1);
INSERT INTO gameobject VALUES (810326, 1734, 0, 1, 1, -1973.25, -3304.82, 55.8461, 0.957591, 0, 0, 0.46071, 0.887551, 1800, 100, 1);
INSERT INTO gameobject VALUES (810327, 1734, 0, 1, 1, -1969.67, -3303.98, 57.5226, 3.27452, 0, 0, 0.997792, -0.0664129, 1800, 100, 1);
INSERT INTO gameobject VALUES (810328, 1734, 0, 1, 1, -2030.56, -3301.74, 54.4007, 3.56826, 0, 0, 0.977331, -0.211717, 1800, 100, 1);
INSERT INTO gameobject VALUES (810329, 1734, 0, 1, 1, -2042.84, -3331.85, 59.4237, 4.18322, 0, 0, 0.867414, -0.497588, 1800, 100, 1);
INSERT INTO gameobject VALUES (810330, 1734, 0, 1, 1, -2077.23, -3324.39, 58.9596, 2.56844, 0, 0, 0.959218, 0.282668, 1800, 100, 1);
INSERT INTO gameobject VALUES (810331, 1734, 0, 1, 1, -2099.26, -3325.44, 58.2037, 5.78465, 0, 0, 0.246696, -0.969093, 1800, 100, 1);
INSERT INTO gameobject VALUES (810332, 1734, 0, 1, 1, -2099.76, -3265.7, 51.4927, 1.37621, 0, 0, 0.635073, 0.772452, 1800, 100, 1);
INSERT INTO gameobject VALUES (810333, 1734, 0, 1, 1, -2079.16, -3242.41, 67.2568, 3.18105, 0, 0, 0.999805, -0.0197284, 1800, 100, 1);
INSERT INTO gameobject VALUES (810334, 1734, 0, 1, 1, -2057.51, -3367.62, 60.9919, 3.29179, 0, 0, 0.997181, -0.0750304, 1800, 100, 1);
INSERT INTO gameobject VALUES (810335, 1734, 0, 1, 1, -2029.01, -3345.87, 52.772, 3.94053, 0, 0, 0.921267, -0.388931, 1800, 100, 1);
INSERT INTO gameobject VALUES (810336, 1734, 0, 1, 1, -2106.42, -3353.52, 58.7927, 3.05932, 0, 0, 0.999154, 0.0411264, 1800, 100, 1);
INSERT INTO gameobject VALUES (810337, 1734, 0, 1, 1, -2007.4, -3288.38, 53.9403, 3.07974, 0, 0, 0.999522, 0.0309199, 1800, 100, 1);
INSERT INTO gameobject VALUES (810338, 1734, 0, 1, 1, -2025.16, -3271.62, 56.7679, 0.548404, 0, 0, 0.270779, 0.962642, 1800, 100, 1);
INSERT INTO gameobject VALUES (810339, 1734, 0, 1, 1, -1909.39, -3382.41, 74.5465, 1.33066, 0, 0, 0.617318, 0.786714, 1800, 100, 1);
INSERT INTO gameobject VALUES (810340, 1734, 0, 1, 1, -1854.14, -3406.13, 68.197, 2.73181, 0, 0, 0.979083, 0.203462, 1800, 100, 1);
INSERT INTO gameobject VALUES (810341, 1734, 0, 1, 1, -1803.77, -3289.48, 31.6611, 0.45965, 0, 0, 0.227807, 0.973706, 1800, 100, 1);
INSERT INTO gameobject VALUES (810342, 1734, 0, 1, 1, -1709.77, -3216.6, 36.5553, 4.12353, 0, 0, 0.881876, -0.471482, 1800, 100, 1);
INSERT INTO gameobject VALUES (810343, 1734, 0, 1, 1, -1728.74, -3290.21, 13.6381, 5.97001, 0, 0, 0.15595, -0.987765, 1800, 100, 1);
INSERT INTO gameobject VALUES (810344, 1734, 0, 1, 1, -1755.31, -3378.49, 42.2461, 2.85826, 0, 0, 0.989982, 0.141194, 1800, 100, 1);
INSERT INTO gameobject VALUES (810345, 1734, 0, 1, 1, -1737.57, -3479.52, 58.917, 1.78383, 0, 0, 0.778276, 0.627922, 1800, 100, 1);
INSERT INTO gameobject VALUES (810346, 1734, 0, 1, 1, -1657.36, -3529.02, 74.4952, 5.22702, 0, 0, 0.50388, -0.863774, 1800, 100, 1);
INSERT INTO gameobject VALUES (810347, 1734, 0, 1, 1, -1548.09, -3504.89, 75.2551, 1.11074, 0, 0, 0.52726, 0.849704, 1800, 100, 1);
INSERT INTO gameobject VALUES (810348, 1734, 0, 1, 1, -1510.7, -3389.11, 51.463, 4.17537, 0, 0, 0.869361, -0.494178, 1800, 100, 1);
INSERT INTO gameobject VALUES (810349, 1734, 0, 1, 1, -1516.43, -3397.75, 52.6323, 1.4304, 0, 0, 0.655769, 0.754961, 1800, 100, 1);
INSERT INTO gameobject VALUES (810350, 1734, 0, 1, 1, -1396.52, -3411.59, 51.3148, 0.0590963, 0, 0, 0.0295439, 0.999563, 1800, 100, 1);
INSERT INTO gameobject VALUES (810351, 1734, 0, 1, 1, -1387.23, -3403.53, 53.6782, 3.65622, 0, 0, 0.967077, -0.254484, 1800, 100, 1);
INSERT INTO gameobject VALUES (810352, 1734, 0, 1, 1, -1380.01, -3476.39, 65.9235, 4.47225, 0, 0, 0.786714, -0.617318, 1800, 100, 1);
INSERT INTO gameobject VALUES (810353, 1734, 0, 1, 1, -1336.87, -3425.68, 50.3103, 4.01436, 0, 0, 0.906286, -0.422666, 1800, 100, 1);
INSERT INTO gameobject VALUES (810354, 1734, 0, 1, 1, -1321.87, -3438.27, 48.0453, 4.01436, 0, 0, 0.906286, -0.422666, 1800, 100, 1);
INSERT INTO gameobject VALUES (810355, 1734, 0, 1, 1, -1276.77, -3534.28, 54.8953, 4.87045, 0, 0, 0.649076, -0.760723, 1800, 100, 1);
INSERT INTO gameobject VALUES (810356, 1734, 0, 1, 1, -1181.54, -3664.29, 60.3266, 5.64249, 0, 0, 0.314895, -0.949127, 1800, 100, 1);
INSERT INTO gameobject VALUES (810357, 1734, 0, 1, 1, -1163.68, -3734.54, 110.152, 4.83354, 0, 0, 0.663004, -0.748616, 1800, 100, 1);
INSERT INTO gameobject VALUES (810358, 1734, 0, 1, 1, -1016.95, -3714.02, 93.1587, 6.03991, 0, 0, 0.121339, -0.992611, 1800, 100, 1);
INSERT INTO gameobject VALUES (810359, 1734, 0, 1, 1, -1006.08, -3714.69, 98.4733, 2.53703, 0, 0, 0.95466, 0.297697, 1800, 100, 1);
INSERT INTO gameobject VALUES (810360, 1734, 0, 1, 1, -991.164, -3831.62, 149.687, 5.87262, 0, 0, 0.203843, -0.979003, 1800, 100, 1);
INSERT INTO gameobject VALUES (810361, 1734, 0, 1, 1, -929.206, -3839.14, 147.723, 1.38329, 0, 0, 0.637803, 0.770199, 1800, 100, 1);
INSERT INTO gameobject VALUES (810362, 1734, 0, 1, 1, -944.873, -3874.2, 150.751, 3.33736, 0, 0, 0.995213, -0.0977261, 1800, 100, 1);
INSERT INTO gameobject VALUES (810363, 1734, 0, 1, 1, -968.749, -3871.89, 150.814, 1.82311, 0, 0, 0.790457, 0.612518, 1800, 100, 1);
INSERT INTO gameobject VALUES (810364, 1734, 0, 1, 1, -930.551, -3893.65, 146.975, 4.64033, 0, 0, 0.732119, -0.681177, 1800, 100, 1);
INSERT INTO gameobject VALUES (810365, 1734, 0, 1, 1, -875.386, -3911.5, 134.267, 0.505996, 0, 0, 0.250307, 0.968166, 1800, 100, 1);
INSERT INTO gameobject VALUES (810366, 1734, 0, 1, 1, -898.421, -3966.76, 137.751, 3.83216, 0, 0, 0.94098, -0.338462, 1800, 100, 1);
INSERT INTO gameobject VALUES (810367, 1734, 0, 1, 1, -893.429, -4007.84, 145.349, 3.67115, 0, 0, 0.965151, -0.261695, 1800, 100, 1);
INSERT INTO gameobject VALUES (810368, 1734, 0, 1, 1, -847.208, -3965.5, 150.39, 5.1045, 0, 0, 0.555814, -0.831306, 1800, 100, 1);
INSERT INTO gameobject VALUES (810369, 1734, 0, 1, 1, -802.522, -3906.92, 145.347, 5.78701, 0, 0, 0.245549, -0.969384, 1800, 100, 1);
INSERT INTO gameobject VALUES (810370, 1734, 0, 1, 1, -803.13, -3879.8, 144.968, 2.24016, 0, 0, 0.900134, 0.435612, 1800, 100, 1);
INSERT INTO gameobject VALUES (810371, 1734, 0, 1, 1, -823.511, -3877.12, 145.539, 1.63147, 0, 0, 0.72823, 0.685333, 1800, 100, 1);
INSERT INTO gameobject VALUES (810372, 1734, 0, 1, 1, -889.899, -3861.29, 136.231, 0.449448, 0, 0, 0.222837, 0.974856, 1800, 100, 1);
INSERT INTO gameobject VALUES (810373, 1734, 0, 1, 1, -915.149, -3629.9, 87.2118, 0.0740272, 0, 0, 0.0370051, 0.999315, 1800, 100, 1);
INSERT INTO gameobject VALUES (810374, 1734, 0, 1, 1, -824.908, -3645.55, 91.5435, 5.17911, 0, 0, 0.524421, -0.851459, 1800, 100, 1);
INSERT INTO gameobject VALUES (810375, 1734, 0, 1, 1, -875.924, -3420.8, 82.0327, 0.822512, 0, 0, 0.399761, 0.916619, 1800, 100, 1);
INSERT INTO gameobject VALUES (810376, 1734, 0, 1, 1, -797.903, -3356.23, 80.2336, 5.97865, 0, 0, 0.15168, -0.98843, 1800, 100, 1);
INSERT INTO gameobject VALUES (810377, 1734, 0, 1, 1, -763.002, -3237, 91.6783, 6.28024, 0, 0, 0.00147095, -0.999999, 1800, 100, 1);
INSERT INTO gameobject VALUES (810378, 1734, 0, 1, 1, -908.613, -3070.83, 50.0555, 0.765963, 0, 0, 0.373688, 0.927555, 1800, 100, 1);
INSERT INTO gameobject VALUES (810379, 1734, 0, 1, 1, -969.654, -3191.09, 51.298, 4.38194, 0, 0, 0.813778, -0.581176, 1800, 100, 1);
INSERT INTO gameobject VALUES (810380, 1734, 0, 1, 1, -1186.61, -3084.1, 45.9928, 3.08917, 0, 0, 0.999657, 0.0262073, 1800, 100, 1);
INSERT INTO gameobject VALUES (810381, 1734, 0, 1, 1, -1262.09, -2932.78, 41.0779, 1.63697, 0, 0, 0.730111, 0.683328, 1800, 100, 1);
INSERT INTO gameobject VALUES (810382, 1734, 0, 1, 1, -1308.62, -2827.18, 57.7876, 4.09448, 0, 0, 0.888631, -0.458623, 1800, 100, 1);
INSERT INTO gameobject VALUES (810383, 1734, 0, 1, 1, -990.212, -2583.33, 59.7278, 4.66389, 0, 0, 0.724043, -0.689755, 1800, 100, 1);
INSERT INTO gameobject VALUES (810384, 1734, 0, 1, 1, -924.364, -2776.64, 68.6011, 5.75403, 0, 0, 0.261503, -0.965203, 1800, 100, 1);

morgan-sevstar

Дата: Четверг, 19.11.2009, 21:32 | Сообщение # 6

Admin

Группа: Администраторы

Сообщений: 227

[ 2 ]

Статус: Offline

Читал один форум дума надо это кинуть сюжа так как я это не проверял
Лишние и смена фракции

Code

-- Noxxious Essence
DELETE FROM creature WHERE id = '13736';
-- Порождение Пагубника
DELETE FROM creature WHERE id = '13456';

Не должно быть, первых вообще нету на карте, а вторые призываются Ноксион
Смена фракции:

Code

[code]-- Defias Raider
UPDATE `creature_template` SET `faction_A`='17',`faction_H`='17' WHERE (`entry`='6180');
-- Rohh the Silent
UPDATE `creature_template` SET `faction_A`='39',`faction_H`='39' WHERE (`entry`='947');
-- Defias Messenger
UPDATE `creature_template` SET `faction_A`='14',`faction_H`='14' WHERE (`entry`='550');
-- Stonesplinter Digger
UPDATE `creature_template` SET `faction_A`='59',`faction_H`='59' WHERE (`entry`='1167');
-- Stonesplinter Geomancer
UPDATE `creature_template` SET `faction_A`='59',`faction_H`='59' WHERE (`entry`='1165');

Code

DELETE FROM `creature_loot_template` WHERE (`entry`=13456);

Code

INSERT INTO `creature_loot_template` VALUES
(13456, 17744, 17, 0, 1, 1, 0, 0, 0),
(13456, 17746, 83, 0, 1, 1, 0, 0, 0),
(13456, 17702, -67, 0, 1, 1, 0, 0, 0),
(13456, 14843, 17, 0, 1, 1, 0, 0, 0);

morgan-sevstar

Дата: Четверг, 19.11.2009, 21:33 | Сообщение # 7

Admin

Группа: Администраторы

Сообщений: 227

[ 2 ]

Статус: Offline

Death Knights, quests auras севодня вам подарок smile

Code

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 */

morgan-sevstar

Дата: Четверг, 19.11.2009, 21:33 | Сообщение # 8

Admin

Группа: Администраторы

Сообщений: 227

[ 2 ]

Статус: Offline

Даларан!
http://www.wowhead.com/?npc=28997
http://www.wowhead.com/?npc=28990

Code

UPDATE `creature_template` SET `npcflag` = 4224 WHERE `entry` = 28990;
UPDATE `creature_template` SET `npcflag` = 4224 WHERE `entry` = 28997;

morgan-sevstar

Дата: Четверг, 19.11.2009, 21:33 | Сообщение # 9

Admin

Группа: Администраторы

Сообщений: 227

[ 2 ]

Статус: Offline

исправилен квест по следам бранна

Code

DELETE FROM `gameobject` WHERE `id`=191708;
INSERT INTO `gameobject` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotatio n3`,`spawntimesecs`,`animprogress`,`state`) VALUES
(786349, 191708, 571, 1, 1, 7157.71, -722.593, 893.356, 1.51468, 0, 0, 0.686991, 0.726666, 25, 0, 1);

morgan-sevstar

Дата: Четверг, 19.11.2009, 21:33 | Сообщение # 10

Admin

Группа: Администраторы

Сообщений: 227

[ 2 ]

Статус: Offline

Сунгарас раставил 50 штук

Code

INSERT INTO gameobject VALUES (784879, 142142, 1, 1, 1, -5012.99, 672.3, 43.7553, 4.98788, 0, 0, 0.603315, -0.797503, 2700, 100, 1);
INSERT INTO gameobject VALUES (784880, 142142, 1, 1, 1, -5154.59, 652.851, 50.9956, 2.1149, 0, 0, 0.871105, 0.491097, 2700, 100, 1);
INSERT INTO gameobject VALUES (784881, 142142, 1, 1, 1, -5075.5, 586.712, 25.5484, 6.23745, 0, 0, 0.0228649, -0.999739, 2700, 100, 1);
INSERT INTO gameobject VALUES (784882, 142142, 1, 1, 1, -5006.61, 571.668, 28.2097, 6.12435, 0, 0, 0.079332, -0.996848, 2700, 100, 1);
INSERT INTO gameobject VALUES (784883, 142142, 1, 1, 1, -4907, 514.762, 8.24412, 4.97924, 0, 0, 0.606754, -0.794889, 2700, 100, 1);
INSERT INTO gameobject VALUES (784884, 142142, 1, 1, 1, -4954.48, 414.284, 11.4063, 4.20641, 0, 0, 0.861587, -0.507611, 2700, 100, 1);
INSERT INTO gameobject VALUES (784885, 142142, 1, 1, 1, -4862.91, 221.835, 48.0334, 4.99574, 0, 0, 0.600178, -0.799866, 2700, 100, 1);
INSERT INTO gameobject VALUES (784886, 142142, 1, 1, 1, -5012.26, 251.783, 43.4367, 3.45086, 0, 0, 0.988068, -0.154019, 2700, 100, 1);
INSERT INTO gameobject VALUES (784887, 142142, 1, 1, 1, -5092.73, 238.351, 44.7005, 3.61972, 0, 0, 0.97156, -0.236794, 2700, 100, 1);
INSERT INTO gameobject VALUES (784888, 142142, 1, 1, 1, -5185.29, 310.915, 56.3863, 2.42749, 0, 0, 0.936931, 0.349514, 2700, 100, 1);
INSERT INTO gameobject VALUES (784889, 142142, 1, 1, 1, -5302.76, 455.449, 52.9022, 2.37094, 0, 0, 0.926675, 0.375862, 2700, 100, 1);
INSERT INTO gameobject VALUES (784890, 142142, 1, 1, 1, -5245.32, 590.295, 57.5694, 1.05854, 0, 0, 0.504902, 0.863177, 2700, 100, 1);
INSERT INTO gameobject VALUES (784891, 142142, 1, 1, 1, -5211.35, 528.684, 52.8035, 5.10962, 0, 0, 0.553684, -0.832727, 2700, 100, 1);
INSERT INTO gameobject VALUES (784892, 142142, 1, 1, 1, -5163.89, 435.29, 26.9806, 5.17559, 0, 0, 0.525919, -0.850535, 2700, 100, 1);
INSERT INTO gameobject VALUES (784893, 142142, 1, 1, 1, -5049.7, 381.427, 12.6656, 5.91937, 0, 0, 0.180908, -0.9835, 2700, 100, 1);
INSERT INTO gameobject VALUES (784894, 142142, 1, 1, 1, -4455.43, -117.18, 53.9501, 5.46226, 0, 0, 0.399032, -0.916937, 2700, 100, 1);
INSERT INTO gameobject VALUES (784895, 142142, 1, 1, 1, -4426.42, -288.655, 31.8352, 4.65252, 0, 0, 0.727954, -0.685626, 2700, 100, 1);
INSERT INTO gameobject VALUES (784896, 142142, 1, 1, 1, -4494.77, -524.341, 12.9931, 5.38765, 0, 0, 0.432954, -0.901416, 2700, 100, 1);
INSERT INTO gameobject VALUES (784897, 142142, 1, 1, 1, -4141.18, -557.46, -5.33101, 5.03893, 0, 0, 0.582764, -0.812641, 2700, 100, 1);
INSERT INTO gameobject VALUES (784898, 142142, 1, 1, 1, -4161.37, -414.913, 28.7263, 1.66801, 0, 0, 0.740627, 0.671916, 2700, 100, 1);
INSERT INTO gameobject VALUES (784899, 142142, 1, 1, 1, -4012.11, -263.352, 151.145, 0.00688825, 0, 0, 0.00344412, 0.999994, 2700, 100, 1);
INSERT INTO gameobject VALUES (784900, 142142, 1, 1, 1, -4190.96, -111.489, 58.652, 2.61598, 0, 0, 0.965665, 0.259791, 2700, 100, 1);
INSERT INTO gameobject VALUES (784901, 142142, 1, 1, 1, -4163.92, -21.4499, 68.0353, 2.79898, 0, 0, 0.985363, 0.17047, 2700, 100, 1);
INSERT INTO gameobject VALUES (784902, 142142, 1, 1, 1, -4231.01, 116.323, 57.6709, 2.08034, 0, 0, 0.86249, 0.506074, 2700, 100, 1);
INSERT INTO gameobject VALUES (784903, 142142, 1, 1, 1, -3939.92, 169.829, 111.552, 5.88324, 0, 0, 0.198644, -0.980072, 2700, 100, 1);
INSERT INTO gameobject VALUES (784904, 142142, 1, 1, 1, -3730.82, 177.576, 123.855, 6.09294, 0, 0, 0.0949801, -0.995479, 2700, 100, 1);
INSERT INTO gameobject VALUES (784905, 142142, 1, 1, 1, -4143.41, 399.735, 52.4919, 3.15634, 0, 0, 0.999973, -0.0073714, 2700, 100, 1);
INSERT INTO gameobject VALUES (784906, 142142, 1, 1, 1, -4144.71, 553.096, 70.7765, 1.73712, 0, 0, 0.7634, 0.645926, 2700, 100, 1);
INSERT INTO gameobject VALUES (784907, 142142, 1, 1, 1, -4185.76, 519.007, 59.6901, 3.88126, 0, 0, 0.932388, -0.361459, 2700, 100, 1);
INSERT INTO gameobject VALUES (784908, 142142, 1, 1, 1, -4237.46, 471.824, 53.1098, 3.88126, 0, 0, 0.932388, -0.361459, 2700, 100, 1);
INSERT INTO gameobject VALUES (784909, 142142, 1, 1, 1, -4320.81, 481.339, 56.4592, 2.90815, 0, 0, 0.993196, 0.116457, 2700, 100, 1);
INSERT INTO gameobject VALUES (784910, 142142, 1, 1, 1, -4388.74, 476.711, 51.5163, 3.30478, 0, 0, 0.996673, -0.0815008, 2700, 100, 1);
INSERT INTO gameobject VALUES (784911, 142142, 1, 1, 1, -4398.17, 469.448, 52.3926, 3.30478, 0, 0, 0.996673, -0.0815008, 2700, 100, 1);
INSERT INTO gameobject VALUES (784912, 142142, 1, 1, 1, -4289.02, 599.151, 58.1988, 0.91952, 0, 0, 0.443733, 0.896159, 2700, 100, 1);
INSERT INTO gameobject VALUES (784913, 142142, 1, 1, 1, -4401.28, 598.368, 62.3786, 3.13356, 0, 0, 0.999992, 0.0040173, 2700, 100, 1);
INSERT INTO gameobject VALUES (784914, 142142, 1, 1, 1, -4557.39, 553.331, 63.258, 3.38724, 0, 0, 0.992467, -0.122516, 2700, 100, 1);
INSERT INTO gameobject VALUES (784915, 142142, 1, 1, 1, -4597.29, 728.277, 49.2875, 1.63423, 0, 0, 0.729175, 0.684327, 2700, 100, 1);