| booyoods | Дата: Четвер, 30.06.2011, 06:58 | Сообщение # 1 |
Старший Маршал
Группа: V.I.P
|
заселение хиджала -доработанное заселение хиджала мобами (их настройка) и растановка квестовых го по хиджалу. Расположение руды и травы каты по всем локам кроме ТБ и вайшира (ОДНИМ ФАЙЛОМ)
вендоры хиджалла
Code -- Nenduil Meadowshade <General Goods>
DELETE FROM npc_vendor WHERE entry=43551;
INSERT INTO npc_vendor VALUES
(43551, 0, 17030, 0, 0, 0),
(43551, 0, 17020, 0, 0, 0),
(43551, 0, 3775, 0, 0, 0),
(43551, 0, 2892, 0, 0, 0),
(43551, 0, 58274, 0, 0, 0),
(43551, 0, 6947, 0, 0, 0),
(43551, 0, 17034, 0, 0, 0),
(43551, 0, 5237, 0, 0, 0),
(43551, 0, 58260, 0, 0, 0),
(43551, 0, 17032, 0, 0, 0),
(43551, 0, 17031, 0, 0, 0),
(43551, 0, 58256, 0, 0, 0),
(43551, 0, 58279, 0, 0, 0),
(43551, 0, 10918, 0, 0, 0);
Code -- Inoho Stronghide <Leatherworking Supplies>
DELETE FROM npc_vendor WHERE entry=43550;
INSERT INTO npc_vendor VALUES
(43550, 0, 2325, 0, 0, 0),
(43550, 0, 6260, 0, 0, 0),
(43550, 0, 2320, 0, 0, 0),
(43550, 0, 38426, 0, 0, 0),
(43550, 0, 2321, 0, 0, 0),
(43550, 0, 4340, 0, 0, 0),
(43550, 0, 2605, 0, 0, 0),
(43550, 0, 8343, 0, 0, 0),
(43550, 0, 6261, 0, 0, 0),
(43550, 0, 10290, 0, 0, 0),
(43550, 0, 4342, 0, 0, 0),
(43550, 0, 2604, 0, 0, 0),
(43550, 0, 14341, 0, 0, 0),
(43550, 0, 4289, 0, 0, 0),
(43550, 0, 4291, 0, 0, 0),
(43550, 0, 7005, 0, 0, 0),
(43550, 0, 4341, 0, 0, 0);
Code -- Tomo <General Goods>
DELETE FROM npc_vendor WHERE entry=43381;
INSERT INTO npc_vendor VALUES
(43381, 0, 17030, 0, 0, 0),
(43381, 0, 17020, 0, 0, 0),
(43381, 0, 3775, 0, 0, 0),
(43381, 0, 2892, 0, 0, 0),
(43381, 0, 58274, 0, 0, 0),
(43381, 0, 6947, 0, 0, 0),
(43381, 0, 17034, 0, 0, 0),
(43381, 0, 5237, 0, 0, 0),
(43381, 0, 58260, 0, 0, 0),
(43381, 0, 17032, 0, 0, 0),
(43381, 0, 17031, 0, 0, 0),
(43381, 0, 58256, 0, 0, 0),
(43381, 0, 58279, 0, 0, 0),
(43381, 0, 10918, 0, 0, 0);
Code -- Jalin Lakedeep <Leatherworking Supplies>
DELETE FROM npc_vendor WHERE entry=43380;
INSERT INTO npc_vendor VALUES
(43380, 0, 2325, 0, 0, 0),
(43380, 0, 6260, 0, 0, 0),
(43380, 0, 2320, 0, 0, 0),
(43380, 0, 38426, 0, 0, 0),
(43380, 0, 2321, 0, 0, 0),
(43380, 0, 4340, 0, 0, 0),
(43380, 0, 2605, 0, 0, 0),
(43380, 0, 8343, 0, 0, 0),
(43380, 0, 6261, 0, 0, 0),
(43380, 0, 10290, 0, 0, 0),
(43380, 0, 4342, 0, 0, 0),
(43380, 0, 2604, 0, 0, 0),
(43380, 0, 14341, 0, 0, 0),
(43380, 0, 4289, 0, 0, 0),
(43380, 0, 4291, 0, 0, 0),
(43380, 0, 7005, 0, 0, 0),
(43380, 0, 4341, 0, 0, 0);
Code -- Mirala Fawnsinger <General Goods>
DELETE FROM npc_vendor WHERE entry=43547;
INSERT INTO npc_vendor VALUES
(43547, 0, 17030, 0, 0, 0),
(43547, 0, 17020, 0, 0, 0),
(43547, 0, 3775, 0, 0, 0),
(43547, 0, 2892, 0, 0, 0),
(43547, 0, 58274, 0, 0, 0),
(43547, 0, 6947, 0, 0, 0),
(43547, 0, 17034, 0, 0, 0),
(43547, 0, 5237, 0, 0, 0),
(43547, 0, 58260, 0, 0, 0),
(43547, 0, 17032, 0, 0, 0),
(43547, 0, 17031, 0, 0, 0),
(43547, 0, 58256, 0, 0, 0),
(43547, 0, 58279, 0, 0, 0),
(43547, 0, 10918, 0, 0, 0);
Code -- Jandunel Reedwind <General Goods>
DELETE FROM npc_vendor WHERE entry=50070;
INSERT INTO npc_vendor VALUES
(50070, 0, 17030, 0, 0, 0),
(50070, 0, 17020, 0, 0, 0),
(50070, 0, 3775, 0, 0, 0),
(50070, 0, 2892, 0, 0, 0),
(50070, 0, 58274, 0, 0, 0),
(50070, 0, 6947, 0, 0, 0),
(50070, 0, 17034, 0, 0, 0),
(50070, 0, 5237, 0, 0, 0),
(50070, 0, 58260, 0, 0, 0),
(50070, 0, 17032, 0, 0, 0),
(50070, 0, 17031, 0, 0, 0),
(50070, 0, 58256, 0, 0, 0),
(50070, 0, 58279, 0, 0, 0),
(50070, 0, 10918, 0, 0, 0);
Code -- Motah Tallhorn <General Goods>
DELETE FROM npc_vendor WHERE entry=43555;
INSERT INTO npc_vendor VALUES
(43555, 0, 17030, 0, 0, 0),
(43555, 0, 17020, 0, 0, 0),
(43555, 0, 3775, 0, 0, 0),
(43555, 0, 2892, 0, 0, 0),
(43555, 0, 58274, 0, 0, 0),
(43555, 0, 6947, 0, 0, 0),
(43555, 0, 17034, 0, 0, 0),
(43555, 0, 5237, 0, 0, 0),
(43555, 0, 58260, 0, 0, 0),
(43555, 0, 17032, 0, 0, 0),
(43555, 0, 17031, 0, 0, 0),
(43555, 0, 58256, 0, 0, 0),
(43555, 0, 58279, 0, 0, 0),
(43555, 0, 10918, 0, 0, 0);
Code -- Ildrin Farglade <Leatherworking Supplies>
DELETE FROM npc_vendor WHERE entry=43554;
INSERT INTO npc_vendor VALUES
(43554, 0, 2325, 0, 0, 0),
(43554, 0, 6260, 0, 0, 0),
(43554, 0, 2320, 0, 0, 0),
(43554, 0, 38426, 0, 0, 0),
(43554, 0, 2321, 0, 0, 0),
(43554, 0, 4340, 0, 0, 0),
(43554, 0, 2605, 0, 0, 0),
(43554, 0, 8343, 0, 0, 0),
(43554, 0, 6261, 0, 0, 0),
(43554, 0, 10290, 0, 0, 0),
(43554, 0, 4342, 0, 0, 0),
(43554, 0, 2604, 0, 0, 0),
(43554, 0, 14341, 0, 0, 0),
(43554, 0, 4289, 0, 0, 0),
(43554, 0, 4291, 0, 0, 0),
(43554, 0, 7005, 0, 0, 0),
(43554, 0, 4341, 0, 0, 0);
Заселение подземье
fix фракций орды
Code update `creature_template` set `faction_A`='104', `faction_H`='104' where `faction_A`='76' and `faction_H`='76';
портал в подземье
Code REPLACE INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `faction`, `flags`, `size`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `AIName`, `ScriptName`, `WDBVerified`) VALUES (207689, 22, 9878, 'Portal to Deepholm', '', '', '', 0, 0, 1, 0, 0, 0, 0, 0, 0, 20618, 0, 0, 0, 0, 10464, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 13329);
Code
replace INTO spell_target_position (id, target_map, target_position_x, target_position_y, target_position_z, target_orientation) VALUES
(20618, 646, 993.025, 452.663, -44.2348, 2.5897);
90% заселение ульдум
Скачать
|
| |
|
|
