WoWST.RU

Фикс квеста [Зимняя рыбалка]

STALKER — Sun, 15 Apr 2012 16:32:13 GMT

Фикс правит работу квеста зимняя рыбалка, теперь квест можно пройти по сюжету.
Доступно только для пользователей

Code

DELETE FROM `creature_loot_template` WHERE (`entry`=41762) AND (`item`=69931);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (41762, 69931, 50, 1, 1, 1);

Altershop YTDB 610

STALKER — Fri, 09 Mar 2012 20:06:25 GMT

Altershop YTDB 610 PantadeDogmen ©

Старенький альтершоп,подправленый под 610 базу.
1-все квестовые спелы учаться у тренеров
2-во всех вендорах продаються только самые лучшие вещи,цлк,рубиновое святилище...
3-Шаманы стартуют сразу с тотемами в сумке
4-осколки душ для локов продаються в стаке по 100 шт.
5-так же для любителей бк и классика стоят 3 вендора с т1 т2 и т6
6-в архиве есть файлик,модифицирующий сет т6 в статы сета т 11 цена шмотки 60к хонора
7-cтарт в столицах шторм и оргриммар
8-сет а7 продаеться за хонор,а сет а8 за хонор и ап
9-все дейли квесты и викли в даларане можно выполнять сразу.а не по одному...
10-интрестная красивая расстановка обьектов у шторма и оргри.
11-фиксы PVP маунтов,а так же добавлен маунт 8го сезона арены так как его в базе небыло.
12-Есть вендор со всеми вещами из Sunwell...
13-В игре присутствует меч Shadowmourne-id 36942

Доступно только для пользователейhttp://filebeam.com/e0c91184f192ed65c25af9694568611e

Тренеры (Профессий)

STALKER — Fri, 09 Mar 2012 20:04:53 GMT

Алхимия:

Code

REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) VALUES (70021, 0, 0, 0, 0, 0, 29516, 0, 29516, 0, 'Alchemist Gribble', 'Master Alchemy Trainer', '', 0, 83, 83, 0, 35, 35, 81, 2, 2, 1, 2, 119, 179, 0, 45, 100, 2000, 2000, 2, 2, 8, 0, 2, 0, 0, 0, 95, 143, 36, 7, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 1000, '', 1, 3, 100, 50, 10, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1949, 0, 2, '', 12340);

DELETE FROM `npc_trainer` WHERE (`entry`=70021);
INSERT INTO `npc_trainer` (entry, spell, spellcost, reqskill, reqskillvalue, reqlevel) VALUES
(70021, 2275, 0, 0, 0, 0),
(70021, 2280, 0, 0, 0, 0),
(70021, 2331, 0, 0, 0, 0),
(70021, 2332, 0, 0, 0, 0),
(70021, 2334, 0, 0, 0, 0),
(70021, 2337, 0, 0, 0, 0),
(70021, 3170, 0, 0, 0, 0),
(70021, 3171, 0, 0, 0, 0),
(70021, 3173, 0, 0, 0, 0),
(70021, 3176, 0, 0, 0, 0),
(70021, 3177, 0, 0, 0, 0),
(70021, 3447, 0, 0, 0, 0),
(70021, 3448, 0, 0, 0, 0),
(70021, 3450, 0, 0, 0, 0),
(70021, 3452, 0, 0, 0, 0),
(70021, 3465, 0, 0, 0, 0),
(70021, 7179, 0, 0, 0, 0),
(70021, 7181, 0, 0, 0, 0),
(70021, 7836, 0, 0, 0, 0),
(70021, 7837, 0, 0, 0, 0),
(70021, 7841, 0, 0, 0, 0),
(70021, 7845, 0, 0, 0, 0),
(70021, 11448, 0, 0, 0, 0),
(70021, 11449, 0, 0, 0, 0),
(70021, 11450, 0, 0, 0, 0),
(70021, 11451, 0, 0, 0, 0),
(70021, 11457, 0, 0, 0, 0),
(70021, 11460, 0, 0, 0, 0),
(70021, 11461, 0, 0, 0, 0),
(70021, 11465, 0, 0, 0, 0),
(70021, 11467, 0, 0, 0, 0),
(70021, 11478, 0, 0, 0, 0),
(70021, 11479, 0, 0, 0, 0),
(70021, 11480, 0, 0, 0, 0),
(70021, 11612, 0, 0, 0, 0),
(70021, 12609, 0, 0, 0, 0),
(70021, 15833, 0, 0, 0, 0),
(70021, 17187, 0, 0, 0, 0),
(70021, 17551, 0, 0, 0, 0),
(70021, 17552, 0, 0, 0, 0),
(70021, 17553, 0, 0, 0, 0),
(70021, 17555, 0, 0, 0, 0),
(70021, 17556, 0, 0, 0, 0),
(70021, 17557, 0, 0, 0, 0),
(70021, 17559, 0, 0, 0, 0),
(70021, 17560, 0, 0, 0, 0),
(70021, 17561, 0, 0, 0, 0),
(70021, 17562, 0, 0, 0, 0),
(70021, 17564, 0, 0, 0, 0),
(70021, 17565, 0, 0, 0, 0),
(70021, 17566, 0, 0, 0, 0),
(70021, 17572, 0, 0, 0, 0),
(70021, 17573, 0, 0, 0, 0),
(70021, 17632, 0, 0, 0, 0),
(70021, 22808, 0, 0, 0, 0),
(70021, 25146, 0, 0, 0, 0),
(70021, 28544, 0, 0, 0, 0),
(70021, 28545, 0, 0, 0, 0),
(70021, 28551, 0, 0, 0, 0),
(70021, 28566, 0, 0, 0, 0),
(70021, 28567, 0, 0, 0, 0),
(70021, 28568, 0, 0, 0, 0),
(70021, 28569, 0, 0, 0, 0),
(70021, 28580, 0, 0, 0, 0),
(70021, 28581, 0, 0, 0, 0),
(70021, 28582, 0, 0, 0, 0),
(70021, 28583, 0, 0, 0, 0),
(70021, 28584, 0, 0, 0, 0),
(70021, 28585, 0, 0, 0, 0),
(70021, 28597, 0, 0, 0, 0),
(70021, 28672, 0, 0, 0, 0),
(70021, 28675, 0, 0, 0, 0),
(70021, 28677, 0, 0, 0, 0),
(70021, 29688, 0, 0, 0, 0),
(70021, 32765, 0, 0, 0, 0),
(70021, 33732, 0, 0, 0, 0),
(70021, 33733, 0, 0, 0, 0),
(70021, 33738, 0, 0, 0, 0),
(70021, 33740, 0, 0, 0, 0),
(70021, 33741, 0, 0, 0, 0),
(70021, 38070, 0, 0, 0, 0),
(70021, 39636, 0, 0, 0, 0),
(70021, 39638, 0, 0, 0, 0),
(70021, 45061, 0, 0, 0, 0),
(70021, 47046, 0, 0, 0, 0),
(70021, 47048, 0, 0, 0, 0),
(70021, 47049, 0, 0, 0, 0),
(70021, 47050, 0, 0, 0, 0),
(70021, 51303, 0, 0, 0, 0),
(70021, 51304, 0, 0, 0, 0),
(70021, 53042, 0, 0, 0, 0),
(70021, 53771, 0, 0, 0, 0),
(70021, 53773, 0, 0, 0, 0),
(70021, 53774, 0, 0, 0, 0),
(70021, 53775, 0, 0, 0, 0),
(70021, 53776, 0, 0, 0, 0),
(70021, 53777, 0, 0, 0, 0),
(70021, 53779, 0, 0, 0, 0),
(70021, 53780, 0, 0, 0, 0),
(70021, 53781, 0, 0, 0, 0),
(70021, 53782, 0, 0, 0, 0),
(70021, 53783, 0, 0, 0, 0),
(70021, 53784, 0, 0, 0, 0),
(70021, 53812, 0, 0, 0, 0),
(70021, 53836, 0, 0, 0, 0),
(70021, 53837, 0, 0, 0, 0),
(70021, 53838, 0, 0, 0, 0),
(70021, 53839, 0, 0, 0, 0),
(70021, 53840, 0, 0, 0, 0),
(70021, 53841, 0, 0, 0, 0),
(70021, 53842, 0, 0, 0, 0),
(70021, 53847, 0, 0, 0, 0),
(70021, 53848, 0, 0, 0, 0),
(70021, 53898, 0, 0, 0, 0),
(70021, 53899, 0, 0, 0, 0),
(70021, 53900, 0, 0, 0, 0),
(70021, 53901, 0, 0, 0, 0),
(70021, 53902, 0, 0, 0, 0),
(70021, 53903, 0, 0, 0, 0),
(70021, 53905, 0, 0, 0, 0),
(70021, 54020, 0, 0, 0, 0),
(70021, 54213, 0, 0, 0, 0),
(70021, 54218, 0, 0, 0, 0),
(70021, 57425, 0, 0, 0, 0),
(70021, 57427, 0, 0, 0, 0),
(70021, 58868, 0, 0, 0, 0),
(70021, 58871, 0, 0, 0, 0),
(70021, 60350, 0, 0, 0, 0),
(70021, 60367, 0, 0, 0, 0),
(70021, 60396, 0, 0, 0, 0),
(70021, 60403, 0, 0, 0, 0),
(70021, 60405, 0, 0, 0, 0),
(70021, 60893, 0, 0, 0, 0),
(70021, 62213, 0, 0, 0, 0),
(70021, 62409, 0, 0, 0, 0),
(70021, 63732, 0, 0, 0, 0),
(70021, 66658, 0, 0, 0, 0),
(70021, 66660, 0, 0, 0, 0),
(70021, 66662, 0, 0, 0, 0),
(70021, 66663, 0, 0, 0, 0),
(70021, 66664, 0, 0, 0, 0),
(70021, 67025, 0, 0, 0, 0);

Инженерное дело:

Code

REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) VALUES (70012, 0, 0, 0, 0, 0, 18637, 0, 18637, 0, 'Timofey Oshenko', 'Grand Master Engineering Trainer', '', 0, 83, 83, 2, 35, 35, 81, 2, 2, 1, 2, 340, 510, 0, 127, 100, 2000, 2000, 2, 2, 8, 0, 2, 0, 0, 0, 272, 408, 102, 7, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 1000, '', 0, 3, 100, 50, 10, 0, 0, 0, 0, 0, 0, 0, 0, 1, 3245, 0, 0, '', 12340);

DELETE FROM `npc_trainer` WHERE (`entry`=70012);
INSERT INTO `npc_trainer` (entry, spell, spellcost, reqskill, reqskillvalue, reqlevel) VALUES
(70012, 3922, 0, 0, 0, 0),
(70012, 3923, 0, 0, 0, 0),
(70012, 3924, 0, 0, 0, 0),
(70012, 3925, 0, 0, 0, 0),
(70012, 3926, 0, 0, 0, 0),
(70012, 3929, 0, 0, 0, 0),
(70012, 3930, 0, 0, 0, 0),
(70012, 3931, 0, 0, 0, 0),
(70012, 3932, 0, 0, 0, 0),
(70012, 3934, 0, 0, 0, 0),
(70012, 3936, 0, 0, 0, 0),
(70012, 3937, 0, 0, 0, 0),
(70012, 3938, 0, 0, 0, 0),
(70012, 3941, 0, 0, 0, 0),
(70012, 3942, 0, 0, 0, 0),
(70012, 3945, 0, 0, 0, 0),
(70012, 3946, 0, 0, 0, 0),
(70012, 3947, 0, 0, 0, 0),
(70012, 3949, 0, 0, 0, 0),
(70012, 3950, 0, 0, 0, 0),
(70012, 3953, 0, 0, 0, 0),
(70012, 3955, 0, 0, 0, 0),
(70012, 3956, 0, 0, 0, 0),
(70012, 3958, 0, 0, 0, 0),
(70012, 3961, 0, 0, 0, 0),
(70012, 3962, 0, 0, 0, 0),
(70012, 3963, 0, 0, 0, 0),
(70012, 3965, 0, 0, 0, 0),
(70012, 3967, 0, 0, 0, 0),
(70012, 3973, 0, 0, 0, 0),
(70012, 3977, 0, 0, 0, 0),
(70012, 3978, 0, 0, 0, 0),
(70012, 4039, 0, 0, 0 , 0),
(70012, 4040, 0, 0, 0, 0),
(70012, 4041, 0, 0, 0, 0),
(70012, 6458, 0, 0, 0, 0),
(70012, 7430, 0, 0, 0, 0),
(70012, 8334, 0, 0, 0, 0),
(70012, 8895, 0, 0, 0, 0),
(70012, 9271, 0, 0, 0, 0),
(70012, 12584, 0, 0, 0, 0),
(70012, 12585, 0, 0, 0, 0),
(70012, 12586, 0, 0, 0, 0),
(70012, 12589, 0, 0, 0, 0),
(70012, 12590, 0, 0, 0, 0),
(70012, 12591, 0, 0, 0, 0),
(70012, 12594, 0, 0, 0, 0),
(70012, 12595, 0, 0, 0, 0),
(70012, 12596, 0, 0, 0, 0),
(70012, 12599, 0, 0, 0, 0),
(70012, 12603, 0, 0, 0, 0),
(70012, 12615, 0, 0, 0, 0),
(70012, 12618, 0, 0, 0, 0),
(70012, 12619, 0, 0, 0, 0),
(70012, 12621, 0, 0, 0, 0),
(70012, 12622, 0, 0, 0, 0),
(70012, 12657, 0, 0, 0, 0),
(70012, 12715, 0, 0, 0, 0),
(70012, 12716, 0, 0, 0, 0),
(70012, 12717, 0, 0, 0, 0),
(70012, 12718, 0, 0, 0, 0),
(70012, 12754, 0, 0, 0, 0),
(70012, 12755, 0, 0, 0, 0),
(70012, 12758, 0, 0, 0, 0),
(70012, 12759, 0, 0, 0, 0),
(70012, 12760, 0, 0, 0, 0),
(70012, 12895, 0, 0, 0, 0),
(70012, 12897, 0, 0, 0, 0),
(70012, 12899, 0, 0, 0, 0),
(70012, 12902, 0, 0, 0, 0),
(70012, 12903, 0, 0, 0, 0),
(70012, 12905, 0, 0, 0, 0),
(70012, 12906, 0, 0, 0, 0),
(70012, 12907, 0, 0, 0, 0),
(70012, 12908, 0, 0, 0, 0),
(70012, 13240, 0, 0, 0, 0),
(70012, 15255, 0, 0, 0, 0),
(70012, 19567, 0, 0, 0, 0),
(70012, 19788, 0, 0, 0, 0),
(70012, 19790, 0, 0, 0, 0),
(70012, 19791, 0, 0, 0, 0),
(70012, 19792, 0, 0, 0, 0),
(70012, 19794, 0, 0, 0, 0),
(70012, 19795, 0, 0, 0, 0),
(70012, 19800, 0, 0, 0, 0),
(70012, 19825, 0, 0, 0, 0),
(70012, 23070, 0, 0, 0, 0),
(70012, 23071, 0, 0, 0, 0),
(70012, 30303, 0, 0, 0, 0),
(70012, 30304, 0, 0, 0, 0),
(70012, 30305, 0, 0, 0, 0),
(70012, 30306, 0, 0, 0, 0),
(70012, 30307, 0, 0, 0, 0),
(70012, 30308, 0, 0, 0, 0),
(70012, 30309, 0, 0, 0, 0),
(70012, 30310, 0, 0, 0, 0),
(70012, 30311, 0, 0, 0, 0),
(70012, 30312, 0, 0, 0, 0),
(70012, 30346, 0, 0, 0, 0),
(70012, 30351, 0, 0, 0, 0),
(70012, 30558, 0, 0, 0, 0),
(70012, 30560, 0, 0, 0, 0),
(70012, 30563, 0, 0, 0, 0),
(70012, 30565, 0, 0, 0, 0),
(70012, 30566, 0, 0, 0, 0),
(70012, 30568, 0, 0, 0, 0),
(70012, 30569, 0, 0, 0, 0),
(70012, 30570, 0, 0, 0, 0),
(70012, 30574, 0, 0, 0, 0),
(70012, 30575, 0, 0, 0, 0),
(70012, 39971, 0, 0, 0, 0),
(70012, 40274, 0, 0, 0, 0),
(70012, 41307, 0, 0, 0, 0),
(70012, 41311, 0, 0, 0, 0),
(70012, 41312, 0, 0, 0, 0),
(70012, 41314, 0, 0, 0, 0),
(70012, 41315, 0, 0, 0, 0),
(70012, 41316, 0, 0, 0, 0),
(70012, 41317, 0, 0, 0, 0),
(70012, 41318, 0, 0, 0, 0),
(70012, 41319, 0, 0, 0, 0),
(70012, 41320, 0, 0, 0, 0),
(70012, 41321, 0, 0, 0, 0),
(70012, 44155, 0, 0, 0, 0),
(70012, 51305, 0, 0, 0, 0),
(70012, 53281, 0, 0, 0, 0),
(70012, 54353, 0, 0, 0, 0),
(70012, 54736, 0, 0, 0, 0),
(70012, 54793, 0, 0, 0, 0),
(70012, 54998, 0, 0, 0, 0),
(70012, 54999, 0, 0, 0, 0),
(70012, 55002, 0, 0, 0, 0),
(70012, 55016, 0, 0, 0, 0),
(70012, 56349, 0, 0, 0, 0),
(70012, 56459, 0, 0, 0, 0),
(70012, 56460, 0, 0, 0, 0),
(70012, 56461, 0, 0, 0, 0),
(70012, 56462, 0, 0, 0, 0),
(70012, 56463, 0, 0, 0, 0),
(70012, 56464, 0, 0, 0, 0),
(70012, 56465, 0, 0, 0, 0),
(70012, 56466, 0, 0, 0, 0),
(70012, 56467, 0, 0, 0, 0),
(70012, 56468, 0, 0, 0, 0),
(70012, 56469, 0, 0, 0, 0),
(70012, 56470, 0, 0, 0, 0),
(70012, 56471, 0, 0, 0, 0),
(70012, 56472, 0, 0, 0, 0),
(70012, 56473, 0, 0, 0, 0),
(70012, 56474, 0, 0, 0, 0),
(70012, 56475, 0, 0, 0, 0),
(70012, 56476, 0, 0, 0, 0),
(70012, 56477, 0, 0, 0, 0),
(70012, 56478, 0, 0, 0, 0),
(70012, 56479, 0, 0, 0, 0),
(70012, 56480, 0, 0, 0, 0),
(70012, 56481, 0, 0, 0, 0),
(70012, 56483, 0, 0, 0, 0),
(70012, 56484, 0, 0, 0, 0),
(70012, 56486, 0, 0, 0, 0),
(70012, 56487, 0, 0, 0, 0),
(70012, 56514, 0, 0, 0, 0),
(70012, 56574, 0, 0, 0, 0),
(70012, 60874, 0, 0, 0, 0),
(70012, 61471, 0, 0, 0, 0),
(70012, 61481, 0, 0, 0, 0),
(70012, 61482, 0, 0, 0, 0),
(70012, 61483, 0, 0, 0, 0),
(70012, 62271, 0, 0, 0, 0),
(70012, 63750, 0, 0, 0, 0),
(70012, 63765, 0, 0, 0, 0),
(70012, 63770, 0, 0, 0, 0),
(70012, 67326, 0, 0, 0, 0),
(70012, 67839, 0, 0, 0, 0),
(70012, 67920, 0, 0, 0, 0);

Кожевничество:

Code

REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) VALUES (70015, 0, 0, 0, 0, 0, 22975, 0, 22975, 0, 'Diane Cannings', 'Grand Master Leatherworking Trainer', '', 0, 83, 83, 2, 35, 35, 81, 2, 2, 1, 2, 340, 510, 0, 127, 100, 2000, 2000, 2, 2, 8, 0, 2, 0, 0, 0, 272, 408, 102, 7, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 1000, '', 0, 3, 100, 50, 10, 0, 0, 0, 0, 0, 0, 0, 0, 1, 4493, 0, 0, '', 12340);

DELETE FROM `npc_trainer` WHERE (`entry`=70015);
INSERT INTO `npc_trainer` (entry, spell, spellcost, reqskill, reqskillvalue, reqlevel) VALUES
(70015, 2153, 0, 0, 0, 0),
(70015, 2154, 0, 0, 0, 0),
(70015, 2155, 0, 0, 0, 0),
(70015, 2159, 0, 0, 0, 0),
(70015, 2160, 0, 0, 0, 0),
(70015, 2161, 0, 0, 0, 0),
(70015, 2162, 0, 0, 0, 0),
(70015, 2165, 0, 0, 0, 0),
(70015, 2166, 0, 0, 0, 0),
(70015, 2167, 0, 0, 0, 0),
(70015, 2168, 0, 0, 0, 0),
(70015, 3753, 0, 0, 0, 0),
(70015, 3756, 0, 0, 0, 0),
(70015, 3759, 0, 0, 0, 0),
(70015, 3760, 0, 0, 0, 0),
(70015, 3761, 0, 0, 0, 0),
(70015, 3763, 0, 0, 0, 0),
(70015, 3764, 0, 0, 0, 0),
(70015, 3766, 0, 0, 0, 0),
(70015, 3768, 0, 0, 0, 0),
(70015, 3770, 0, 0, 0, 0),
(70015, 3774, 0, 0, 0, 0),
(70015, 3776, 0, 0, 0, 0),
(70015, 3780, 0, 0, 0, 0),
(70015, 3812, 0, 0, 0, 0),
(70015, 3816, 0, 0, 0, 0),
(70015, 3817, 0, 0, 0, 0),
(70015, 3818, 0, 0, 0, 0),
(70015, 6661, 0, 0, 0, 0),
(70015, 7135, 0, 0, 0, 0),
(70015, 7147, 0, 0, 0, 0),
(70015, 7151, 0, 0, 0, 0),
(70015, 7156, 0, 0, 0, 0),
(70015, 9060, 0, 0, 0, 0),
(70015, 9062, 0, 0, 0, 0),
(70015, 9065, 0, 0, 0, 0),
(70015, 9068, 0, 0, 0, 0),
(70015, 9074, 0, 0, 0, 0),
(70015, 9145, 0, 0, 0, 0),
(70015, 9193, 0, 0, 0, 0),
(70015, 9194, 0, 0, 0, 0),
(70015, 9196, 0, 0, 0, 0),
(70015, 9198, 0, 0, 0, 0),
(70015, 9201, 0, 0, 0, 0),
(70015, 9206, 0, 0, 0, 0),
(70015, 10482, 0, 0, 0, 0),
(70015, 10487, 0, 0, 0, 0),
(70015, 10499, 0, 0, 0, 0),
(70015, 10507, 0, 0, 0, 0),
(70015, 10511, 0, 0, 0, 0),
(70015, 10518, 0, 0, 0, 0),
(70015, 10548, 0, 0, 0, 0),
(70015, 10552, 0, 0, 0, 0),
(70015, 10556, 0, 0, 0, 0),
(70015, 10558, 0, 0, 0, 0),
(70015, 10663, 0, 0, 0, 0),
(70015, 14930, 0, 0, 0, 0),
(70015, 14932, 0, 0, 0, 0),
(70015, 19047, 0, 0, 0, 0),
(70015, 19052, 0, 0, 0, 0),
(70015, 19055, 0, 0, 0, 0),
(70015, 19058, 0, 0, 0, 0),
(70015, 19065, 0, 0, 0, 0),
(70015, 19071, 0, 0, 0, 0),
(70015, 19072, 0, 0, 0, 0),
(70015, 19082, 0, 0, 0, 0),
(70015, 19083, 0, 0, 0, 0),
(70015, 19091, 0, 0, 0, 0),
(70015, 19092, 0, 0, 0, 0),
(70015, 19098, 0, 0, 0, 0),
(70015, 19102, 0, 0, 0, 0),
(70015, 19103, 0, 0, 0, 0),
(70015, 20648, 0, 0, 0, 0),
(70015, 20649, 0, 0, 0, 0),
(70015, 20650, 0, 0, 0, 0),
(70015, 22331, 0, 0, 0, 0),
(70015, 32454, 0, 0, 0, 0),
(70015, 32455, 0, 0, 0, 0),
(70015, 32456, 0, 0, 0, 0),
(70015, 32462, 0, 0, 0, 0),
(70015, 32463, 0, 0, 0, 0),
(70015, 32464, 0, 0, 0, 0),
(70015, 32465, 0, 0, 0, 0),
(70015, 32466, 0, 0, 0, 0),
(70015, 32467, 0, 0, 0, 0),
(70015, 32468, 0, 0, 0, 0),
(70015, 32469, 0, 0, 0, 0),
(70015, 32470, 0, 0, 0, 0),
(70015, 32471, 0, 0, 0, 0),
(70015, 32472, 0, 0, 0, 0),
(70015, 32473, 0, 0, 0, 0),
(70015, 32478, 0, 0, 0, 0),
(70015, 32479, 0, 0, 0, 0),
(70015, 32480, 0, 0, 0, 0),
(70015, 32481, 0, 0, 0, 0),
(70015, 32550, 0, 0, 0, 0),
(70015, 35540, 0, 0, 0, 0),
(70015, 44343, 0, 0, 0, 0),
(70015, 44344, 0, 0, 0, 0),
(70015, 44770, 0, 0, 0, 0),
(70015, 44970, 0, 0, 0, 0),
(70015, 45100, 0, 0, 0, 0),
(70015, 50936, 0, 0, 0, 0),
(70015, 50938, 0, 0, 0, 0),
(70015, 50939, 0, 0, 0, 0),
(70015, 50940, 0, 0, 0, 0),
(70015, 50941, 0, 0, 0, 0),
(70015, 50942, 0, 0, 0, 0),
(70015, 50943, 0, 0, 0, 0),
(70015, 50944, 0, 0, 0, 0),
(70015, 50945, 0, 0, 0, 0),
(70015, 50946, 0, 0, 0, 0),
(70015, 50947, 0, 0, 0, 0),
(70015, 50948, 0, 0, 0, 0),
(70015, 50949, 0, 0, 0, 0),
(70015, 50950, 0, 0, 0, 0),
(70015, 50951, 0, 0, 0, 0),
(70015, 50952, 0, 0, 0, 0),
(70015, 50953, 0, 0, 0, 0),
(70015, 50954, 0, 0, 0, 0),
(70015, 50955, 0, 0, 0, 0),
(70015, 50956, 0, 0, 0, 0),
(70015, 50957, 0, 0, 0, 0),
(70015, 50958, 0, 0, 0, 0),
(70015, 50959, 0, 0, 0, 0),
(70015, 50960, 0, 0, 0, 0),
(70015, 50961, 0, 0, 0, 0),
(70015, 50962, 0, 0, 0, 0),
(70015, 50963, 0, 0, 0, 0),
(70015, 50964, 0, 0, 0, 0),
(70015, 50965, 0, 0, 0, 0),
(70015, 50966, 0, 0, 0, 0),
(70015, 50967, 0, 0, 0, 0),
(70015, 51301, 0, 0, 0, 0),
(70015, 51568, 0, 0, 0, 0),
(70015, 51569, 0, 0, 0, 0),
(70015, 51570, 0, 0, 0, 0),
(70015, 51571, 0, 0, 0, 0),
(70015, 51572, 0, 0, 0, 0),
(70015, 55199, 0, 0, 0, 0),
(70015, 57683, 0, 0, 0, 0),
(70015, 57690, 0, 0, 0, 0),
(70015, 57691, 0, 0, 0, 0),
(70015, 57692, 0, 0, 0, 0),
(70015, 57694, 0, 0, 0, 0),
(70015, 57696, 0, 0, 0, 0),
(70015, 57699, 0, 0, 0, 0),
(70015, 57701, 0, 0, 0, 0),
(70015, 60583, 0, 0, 0, 0),
(70015, 60584, 0, 0, 0, 0),
(70015, 60599, 0, 0, 0, 0),
(70015, 60600, 0, 0, 0, 0),
(70015, 60601, 0, 0, 0, 0),
(70015, 60604, 0, 0, 0, 0),
(70015, 60605, 0, 0, 0, 0),
(70015, 60607, 0, 0, 0, 0),
(70015, 60608, 0, 0, 0, 0),
(70015, 60611, 0, 0, 0, 0),
(70015, 60613, 0, 0, 0, 0),
(70015, 60620, 0, 0, 0, 0),
(70015, 60622, 0, 0, 0, 0),
(70015, 60624, 0, 0, 0, 0),
(70015, 60627, 0, 0, 0, 0),
(70015, 60629, 0, 0, 0, 0),
(70015, 60630, 0, 0, 0, 0),
(70015, 60631, 0, 0, 0, 0),
(70015, 60637, 0, 0, 0, 0),
(70015, 60640, 0, 0, 0, 0),
(70015, 60643, 0, 0, 0, 0),
(70015, 60649, 0, 0, 0, 0),
(70015, 60651, 0, 0, 0, 0),
(70015, 60652, 0, 0, 0, 0),
(70015, 60655, 0, 0, 0, 0),
(70015, 60658, 0, 0, 0, 0),
(70015, 60660, 0, 0, 0, 0),
(70015, 60665, 0, 0, 0, 0),
(70015, 60666, 0, 0, 0, 0),
(70015, 60669, 0, 0, 0, 0),
(70015, 60671, 0, 0, 0, 0),
(70015, 62448, 0, 0, 0, 0),
(70015, 64661, 0, 0, 0, 0),
(70015, 69386, 0, 0, 0, 0),
(70015, 69388, 0, 0, 0, 0);

Эвент "Рыбалка на отлично"

STALKER — Fri, 09 Mar 2012 20:00:31 GMT

Предыстория:

С древнейших времен, как на берегах Великого моря стали организовываться крупные города, горожане стали выбрасывать отходы в эти чистейшие воды. Со временем все эти отходы, обломки, ящики прибило к берегу одного острова...
Шли времена, а тот самый берег стал полностью усыпан этими нечистотами.
Однажды, великим рыболовом, чье имя кроется в самых глубоких впадинах, был найден "..интересный остров, усыпанный интересными предметами... И как бы не закидывал он туда удочку, то сразу же поплавок неистово дергался и выуживал оттуда на редкость диковинную добычу!" - писал он.
Вскоре на остров устремились многие рыболовы со всего мира Warcraft, но так и не смогли обнаружить его. Остров стал легендой!
Прошло время, и о чудо! Остров обнаружен! Все вперед за приключениями!

Описание самого эвента:

Эвент начинается командой event start 80.
Все действие проходит на ГМ острове.
Всем игрокам раздается предмет 43651 - Удочка Умейки
Длительность 30 минут.
Добыча тут хорошая, главный приз Пепел Ал'ара (его дроп 0,1%).

Скрин:

Скачать SQL

Фиксы квестов

STALKER — Fri, 02 Mar 2012 17:28:39 GMT

Фиксы квестов на Озеро Ледяных Оков

Беспощадным пощады не будет

Code

DELETE FROM `creature_questrelation` WHERE `quest`=13177;
  DELETE FROM `gameobject_questrelation` WHERE `quest`=13177;
  UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest`=13177;
  INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (31036, 13177);
  UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=31036;
  DELETE FROM `creature_involvedrelation` WHERE `quest`=13177;
  DELETE FROM `gameobject_involvedrelation` WHERE `quest`=13177;
  INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (31036, 13177);
  UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=31036;
  REPLACE INTO `quest_template` (`entry`, `Method`, `ZoneOrSort`, `SkillOrClassMask`, `MinLevel`, `MaxLevel`, `QuestLevel`, `Type`, `RequiredRaces`, `RequiredSkillValue`, `RepObjectiveFaction`, `RepObjectiveValue`, `RepObjectiveFaction2`, `RepObjectiveValue2`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepFaction`, `RequiredMaxRepValue`, `SuggestedPlayers`, `LimitTime`, `QuestFlags`, `SpecialFlags`, `CharTitleId`, `PlayersSlain`, `BonusTalents`, `RewardArenaPoints`, `PrevQuestId`, `NextQuestId`, `ExclusiveGroup`, `NextQuestInChain`, `RewXPId`, `SrcItemId`, `SrcItemCount`, `SrcSpell`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `RequestItemsText`, `EndText`, `CompletedText`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `ReqItemId1`, `ReqItemId2`, `ReqItemId3`, `ReqItemId4`, `ReqItemId5`, `ReqItemId6`, `ReqItemCount1`, `ReqItemCount2`, `ReqItemCount3`, `ReqItemCount4`, `ReqItemCount5`, `ReqItemCount6`, `ReqSourceId1`, `ReqSourceId2`, `ReqSourceId3`, `ReqSourceId4`, `ReqSourceCount1`, `ReqSourceCount2`, `ReqSourceCount3`, `ReqSourceCount4`, `ReqCreatureOrGOId1`, `ReqCreatureOrGOId2`, `ReqCreatureOrGOId3`, `ReqCreatureOrGOId4`, `ReqCreatureOrGOCount1`, `ReqCreatureOrGOCount2`, `ReqCreatureOrGOCount3`, `ReqCreatureOrGOCount4`, `ReqSpellCast1`, `ReqSpellCast2`, `ReqSpellCast3`, `ReqSpellCast4`, `RewChoiceItemId1`, `RewChoiceItemId2`, `RewChoiceItemId3`, `RewChoiceItemId4`, `RewChoiceItemId5`, `RewChoiceItemId6`, `RewChoiceItemCount1`, `RewChoiceItemCount2`, `RewChoiceItemCount3`, `RewChoiceItemCount4`, `RewChoiceItemCount5`, `RewChoiceItemCount6`, `RewItemId1`, `RewItemId2`, `RewItemId3`, `RewItemId4`, `RewItemCount1`, `RewItemCount2`, `RewItemCount3`, `RewItemCount4`, `RewRepFaction1`, `RewRepFaction2`, `RewRepFaction3`, `RewRepFaction4`, `RewRepFaction5`, `RewRepValueId1`, `RewRepValueId2`, `RewRepValueId3`, `RewRepValueId4`, `RewRepValueId5`, `RewRepValue1`, `RewRepValue2`, `RewRepValue3`, `RewRepValue4`, `RewRepValue5`, `RewHonorAddition`, `RewHonorMultiplier`, `unk0`, `RewOrReqMoney`, `RewMoneyMaxLevel`, `RewSpell`, `RewSpellCast`, `RewMailTemplateId`, `RewMailDelaySecs`, `PointMapId`, `PointX`, `PointY`, `PointOpt`, `DetailsEmote1`, `DetailsEmote2`, `DetailsEmote3`, `DetailsEmote4`, `DetailsEmoteDelay1`, `DetailsEmoteDelay2`, `DetailsEmoteDelay3`, `DetailsEmoteDelay4`, `IncompleteEmote`, `CompleteEmote`, `OfferRewardEmote1`, `OfferRewardEmote2`, `OfferRewardEmote3`, `OfferRewardEmote4`, `OfferRewardEmoteDelay1`, `OfferRewardEmoteDelay2`, `OfferRewardEmoteDelay3`, `OfferRewardEmoteDelay4`, `StartScript`, `CompleteScript`, `WDBVerified`) VALUES (13177, 2, 4197, 0, 78, 0, 80, 41, 1101, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 32968, 1, 0, 0, 0, 0, 0, 0, 13177, 0, 5, 0, 0, 0, 'No Mercy for the Merciless', 'Welcome to the Wintergrasp Fortress, $n. Your mission is simple. Defeat ten of the Horde\'s finest. Now, go! Bring victory to the Alliance!', 'Commander Zanneth in Wintergrasp Fortress wants you to slay 10 members of the Horde.', 'Glorious! Truly, you are among the champions of the Alliance.', 'Well, have you completed your mission?', '', 'Return to Commander Zanneth in Wintergrasp.', 'Horde members slain', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 39019, 0, 0, 0, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 43228, 0, 0, 0, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 30, 0, 74000, 132300, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 12340);

Беспощадным пощады не будет

Code

DELETE FROM `creature_questrelation` WHERE `quest`=13179;
  DELETE FROM `gameobject_questrelation` WHERE `quest`=13179;
  UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest`=13179;
  INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (31036, 13179);
  UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=31036;
  DELETE FROM `creature_involvedrelation` WHERE `quest`=13179;
  DELETE FROM `gameobject_involvedrelation` WHERE `quest`=13179;
  INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (31036, 13179);
  UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=31036;
  REPLACE INTO `quest_template` (`entry`, `Method`, `ZoneOrSort`, `SkillOrClassMask`, `MinLevel`, `MaxLevel`, `QuestLevel`, `Type`, `RequiredRaces`, `RequiredSkillValue`, `RepObjectiveFaction`, `RepObjectiveValue`, `RepObjectiveFaction2`, `RepObjectiveValue2`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepFaction`, `RequiredMaxRepValue`, `SuggestedPlayers`, `LimitTime`, `QuestFlags`, `SpecialFlags`, `CharTitleId`, `PlayersSlain`, `BonusTalents`, `RewardArenaPoints`, `PrevQuestId`, `NextQuestId`, `ExclusiveGroup`, `NextQuestInChain`, `RewXPId`, `SrcItemId`, `SrcItemCount`, `SrcSpell`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `RequestItemsText`, `EndText`, `CompletedText`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `ReqItemId1`, `ReqItemId2`, `ReqItemId3`, `ReqItemId4`, `ReqItemId5`, `ReqItemId6`, `ReqItemCount1`, `ReqItemCount2`, `ReqItemCount3`, `ReqItemCount4`, `ReqItemCount5`, `ReqItemCount6`, `ReqSourceId1`, `ReqSourceId2`, `ReqSourceId3`, `ReqSourceId4`, `ReqSourceCount1`, `ReqSourceCount2`, `ReqSourceCount3`, `ReqSourceCount4`, `ReqCreatureOrGOId1`, `ReqCreatureOrGOId2`, `ReqCreatureOrGOId3`, `ReqCreatureOrGOId4`, `ReqCreatureOrGOCount1`, `ReqCreatureOrGOCount2`, `ReqCreatureOrGOCount3`, `ReqCreatureOrGOCount4`, `ReqSpellCast1`, `ReqSpellCast2`, `ReqSpellCast3`, `ReqSpellCast4`, `RewChoiceItemId1`, `RewChoiceItemId2`, `RewChoiceItemId3`, `RewChoiceItemId4`, `RewChoiceItemId5`, `RewChoiceItemId6`, `RewChoiceItemCount1`, `RewChoiceItemCount2`, `RewChoiceItemCount3`, `RewChoiceItemCount4`, `RewChoiceItemCount5`, `RewChoiceItemCount6`, `RewItemId1`, `RewItemId2`, `RewItemId3`, `RewItemId4`, `RewItemCount1`, `RewItemCount2`, `RewItemCount3`, `RewItemCount4`, `RewRepFaction1`, `RewRepFaction2`, `RewRepFaction3`, `RewRepFaction4`, `RewRepFaction5`, `RewRepValueId1`, `RewRepValueId2`, `RewRepValueId3`, `RewRepValueId4`, `RewRepValueId5`, `RewRepValue1`, `RewRepValue2`, `RewRepValue3`, `RewRepValue4`, `RewRepValue5`, `RewHonorAddition`, `RewHonorMultiplier`, `unk0`, `RewOrReqMoney`, `RewMoneyMaxLevel`, `RewSpell`, `RewSpellCast`, `RewMailTemplateId`, `RewMailDelaySecs`, `PointMapId`, `PointX`, `PointY`, `PointOpt`, `DetailsEmote1`, `DetailsEmote2`, `DetailsEmote3`, `DetailsEmote4`, `DetailsEmoteDelay1`, `DetailsEmoteDelay2`, `DetailsEmoteDelay3`, `DetailsEmoteDelay4`, `IncompleteEmote`, `CompleteEmote`, `OfferRewardEmote1`, `OfferRewardEmote2`, `OfferRewardEmote3`, `OfferRewardEmote4`, `OfferRewardEmoteDelay1`, `OfferRewardEmoteDelay2`, `OfferRewardEmoteDelay3`, `OfferRewardEmoteDelay4`, `StartScript`, `CompleteScript`, `WDBVerified`) VALUES (13179, 2, 4197, 0, 78, 0, 80, 41, 1101, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 32968, 1, 0, 0, 0, 0, 0, 0, 13177, 0, 5, 0, 0, 0, 'No Mercy for the Merciless', 'Welcome to the Wintergrasp, $n. Your mission is simple. Defeat ten of the Horde\'s finest. Now, go! Bring victory to the Alliance!', 'Commander Zanneth in Wintergrasp wants you to slay 10 members of the Horde.', 'Glorious! Truly, you are among the champions of the Alliance.', 'Well, have you completed your mission?', '', 'Return to Commander Zanneth in Wintergrasp.', 'Horde members slain', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 39019, 0, 0, 0, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 43228, 0, 0, 0, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 30, 0, 74000, 132300, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 12340);

Всех убить!

Code

DELETE FROM `creature_questrelation` WHERE `quest`=13178;
  DELETE FROM `gameobject_questrelation` WHERE `quest`=13178;
  UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest`=13178;
  INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (31091, 13178);
  UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=31091;
  DELETE FROM `creature_involvedrelation` WHERE `quest`=13178;
  DELETE FROM `gameobject_involvedrelation` WHERE `quest`=13178;
  INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (31091, 13178);
  UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=31091;
  REPLACE INTO `quest_template` (`entry`, `Method`, `ZoneOrSort`, `SkillOrClassMask`, `MinLevel`, `MaxLevel`, `QuestLevel`, `Type`, `RequiredRaces`, `RequiredSkillValue`, `RepObjectiveFaction`, `RepObjectiveValue`, `RepObjectiveFaction2`, `RepObjectiveValue2`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepFaction`, `RequiredMaxRepValue`, `SuggestedPlayers`, `LimitTime`, `QuestFlags`, `SpecialFlags`, `CharTitleId`, `PlayersSlain`, `BonusTalents`, `RewardArenaPoints`, `PrevQuestId`, `NextQuestId`, `ExclusiveGroup`, `NextQuestInChain`, `RewXPId`, `SrcItemId`, `SrcItemCount`, `SrcSpell`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `RequestItemsText`, `EndText`, `CompletedText`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `ReqItemId1`, `ReqItemId2`, `ReqItemId3`, `ReqItemId4`, `ReqItemId5`, `ReqItemId6`, `ReqItemCount1`, `ReqItemCount2`, `ReqItemCount3`, `ReqItemCount4`, `ReqItemCount5`, `ReqItemCount6`, `ReqSourceId1`, `ReqSourceId2`, `ReqSourceId3`, `ReqSourceId4`, `ReqSourceCount1`, `ReqSourceCount2`, `ReqSourceCount3`, `ReqSourceCount4`, `ReqCreatureOrGOId1`, `ReqCreatureOrGOId2`, `ReqCreatureOrGOId3`, `ReqCreatureOrGOId4`, `ReqCreatureOrGOCount1`, `ReqCreatureOrGOCount2`, `ReqCreatureOrGOCount3`, `ReqCreatureOrGOCount4`, `ReqSpellCast1`, `ReqSpellCast2`, `ReqSpellCast3`, `ReqSpellCast4`, `RewChoiceItemId1`, `RewChoiceItemId2`, `RewChoiceItemId3`, `RewChoiceItemId4`, `RewChoiceItemId5`, `RewChoiceItemId6`, `RewChoiceItemCount1`, `RewChoiceItemCount2`, `RewChoiceItemCount3`, `RewChoiceItemCount4`, `RewChoiceItemCount5`, `RewChoiceItemCount6`, `RewItemId1`, `RewItemId2`, `RewItemId3`, `RewItemId4`, `RewItemCount1`, `RewItemCount2`, `RewItemCount3`, `RewItemCount4`, `RewRepFaction1`, `RewRepFaction2`, `RewRepFaction3`, `RewRepFaction4`, `RewRepFaction5`, `RewRepValueId1`, `RewRepValueId2`, `RewRepValueId3`, `RewRepValueId4`, `RewRepValueId5`, `RewRepValue1`, `RewRepValue2`, `RewRepValue3`, `RewRepValue4`, `RewRepValue5`, `RewHonorAddition`, `RewHonorMultiplier`, `unk0`, `RewOrReqMoney`, `RewMoneyMaxLevel`, `RewSpell`, `RewSpellCast`, `RewMailTemplateId`, `RewMailDelaySecs`, `PointMapId`, `PointX`, `PointY`, `PointOpt`, `DetailsEmote1`, `DetailsEmote2`, `DetailsEmote3`, `DetailsEmote4`, `DetailsEmoteDelay1`, `DetailsEmoteDelay2`, `DetailsEmoteDelay3`, `DetailsEmoteDelay4`, `IncompleteEmote`, `CompleteEmote`, `OfferRewardEmote1`, `OfferRewardEmote2`, `OfferRewardEmote3`, `OfferRewardEmote4`, `OfferRewardEmoteDelay1`, `OfferRewardEmoteDelay2`, `OfferRewardEmoteDelay3`, `OfferRewardEmoteDelay4`, `StartScript`, `CompleteScript`, `WDBVerified`) VALUES (13178, 2, 4197, 0, 78, 0, 80, 41, 690, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 32968, 1, 0, 0, 0, 0, 0, 0, 13178, 0, 5, 0, 0, 0, 'Slay them all!', 'Welcome to the Wintergrasp Fortress, $n. Warlord Garrosh demands one thing: Slay them all!$B$BReturn to me when ten of the strongest members of the Alliance are dead.', 'Commander Dardosh in Wintergrasp Fortress wants you to slay 10 members of the Alliance.', 'Lok\'tar! Victory for the Horde!', 'Well, have you completed your mission?', '', 'Return to Commander Dardosh in Wintergrasp.', 'Alliance members slain', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 31086, 0, 0, 0, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 43228, 0, 0, 0, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 30, 0, 74000, 132300, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 12340);

Всех убить!

Code

DELETE FROM `creature_questrelation` WHERE `quest`=13180;
  DELETE FROM `gameobject_questrelation` WHERE `quest`=13180;
  UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest`=13180;
  INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (31091, 13180);
  UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=31091;
  DELETE FROM `creature_involvedrelation` WHERE `quest`=13180;
  DELETE FROM `gameobject_involvedrelation` WHERE `quest`=13180;
  INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (31091, 13180);
  UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=31091;
  REPLACE INTO `quest_template` (`entry`, `Method`, `ZoneOrSort`, `SkillOrClassMask`, `MinLevel`, `MaxLevel`, `QuestLevel`, `Type`, `RequiredRaces`, `RequiredSkillValue`, `RepObjectiveFaction`, `RepObjectiveValue`, `RepObjectiveFaction2`, `RepObjectiveValue2`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepFaction`, `RequiredMaxRepValue`, `SuggestedPlayers`, `LimitTime`, `QuestFlags`, `SpecialFlags`, `CharTitleId`, `PlayersSlain`, `BonusTalents`, `RewardArenaPoints`, `PrevQuestId`, `NextQuestId`, `ExclusiveGroup`, `NextQuestInChain`, `RewXPId`, `SrcItemId`, `SrcItemCount`, `SrcSpell`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `RequestItemsText`, `EndText`, `CompletedText`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `ReqItemId1`, `ReqItemId2`, `ReqItemId3`, `ReqItemId4`, `ReqItemId5`, `ReqItemId6`, `ReqItemCount1`, `ReqItemCount2`, `ReqItemCount3`, `ReqItemCount4`, `ReqItemCount5`, `ReqItemCount6`, `ReqSourceId1`, `ReqSourceId2`, `ReqSourceId3`, `ReqSourceId4`, `ReqSourceCount1`, `ReqSourceCount2`, `ReqSourceCount3`, `ReqSourceCount4`, `ReqCreatureOrGOId1`, `ReqCreatureOrGOId2`, `ReqCreatureOrGOId3`, `ReqCreatureOrGOId4`, `ReqCreatureOrGOCount1`, `ReqCreatureOrGOCount2`, `ReqCreatureOrGOCount3`, `ReqCreatureOrGOCount4`, `ReqSpellCast1`, `ReqSpellCast2`, `ReqSpellCast3`, `ReqSpellCast4`, `RewChoiceItemId1`, `RewChoiceItemId2`, `RewChoiceItemId3`, `RewChoiceItemId4`, `RewChoiceItemId5`, `RewChoiceItemId6`, `RewChoiceItemCount1`, `RewChoiceItemCount2`, `RewChoiceItemCount3`, `RewChoiceItemCount4`, `RewChoiceItemCount5`, `RewChoiceItemCount6`, `RewItemId1`, `RewItemId2`, `RewItemId3`, `RewItemId4`, `RewItemCount1`, `RewItemCount2`, `RewItemCount3`, `RewItemCount4`, `RewRepFaction1`, `RewRepFaction2`, `RewRepFaction3`, `RewRepFaction4`, `RewRepFaction5`, `RewRepValueId1`, `RewRepValueId2`, `RewRepValueId3`, `RewRepValueId4`, `RewRepValueId5`, `RewRepValue1`, `RewRepValue2`, `RewRepValue3`, `RewRepValue4`, `RewRepValue5`, `RewHonorAddition`, `RewHonorMultiplier`, `unk0`, `RewOrReqMoney`, `RewMoneyMaxLevel`, `RewSpell`, `RewSpellCast`, `RewMailTemplateId`, `RewMailDelaySecs`, `PointMapId`, `PointX`, `PointY`, `PointOpt`, `DetailsEmote1`, `DetailsEmote2`, `DetailsEmote3`, `DetailsEmote4`, `DetailsEmoteDelay1`, `DetailsEmoteDelay2`, `DetailsEmoteDelay3`, `DetailsEmoteDelay4`, `IncompleteEmote`, `CompleteEmote`, `OfferRewardEmote1`, `OfferRewardEmote2`, `OfferRewardEmote3`, `OfferRewardEmote4`, `OfferRewardEmoteDelay1`, `OfferRewardEmoteDelay2`, `OfferRewardEmoteDelay3`, `OfferRewardEmoteDelay4`, `StartScript`, `CompleteScript`, `WDBVerified`) VALUES (13180, 2, 4197, 0, 78, 0, 80, 41, 690, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 32968, 1, 0, 0, 0, 0, 0, 0, 13178, 0, 5, 0, 0, 0, 'Slay them all!', 'Welcome to the Wintergrasp, $n. Warlord Garrosh demands one thing: Slay them all!$B$BReturn to me when ten of the strongest members of the Alliance are dead.', 'Commander Dardosh in Wintergrasp wants you to slay 10 members of the Alliance.', 'Lok\'tar! Victory for the Horde!', 'Well, have you completed your mission?', '', 'Return to Commander Dardosh in Wintergrasp.', 'Alliance members slain', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 31086, 0, 0, 0, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 43228, 0, 0, 0, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 30, 0, 74000, 132300, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 12340);

Горючее для разрушителей

Code

DELETE FROM `creature_questrelation` WHERE `quest`=13191;
  DELETE FROM `gameobject_questrelation` WHERE `quest`=13191;
  UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest`=13191;
  INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (31106, 13191);
  UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=31106;
  DELETE FROM `creature_involvedrelation` WHERE `quest`=13191;
  DELETE FROM `gameobject_involvedrelation` WHERE `quest`=13191;
  INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (31091, 13191);
  UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=31091;
  REPLACE INTO `quest_template` (`entry`, `Method`, `ZoneOrSort`, `SkillOrClassMask`, `MinLevel`, `MaxLevel`, `QuestLevel`, `Type`, `RequiredRaces`, `RequiredSkillValue`, `RepObjectiveFaction`, `RepObjectiveValue`, `RepObjectiveFaction2`, `RepObjectiveValue2`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepFaction`, `RequiredMaxRepValue`, `SuggestedPlayers`, `LimitTime`, `QuestFlags`, `SpecialFlags`, `CharTitleId`, `PlayersSlain`, `BonusTalents`, `RewardArenaPoints`, `PrevQuestId`, `NextQuestId`, `ExclusiveGroup`, `NextQuestInChain`, `RewXPId`, `SrcItemId`, `SrcItemCount`, `SrcSpell`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `RequestItemsText`, `EndText`, `CompletedText`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `ReqItemId1`, `ReqItemId2`, `ReqItemId3`, `ReqItemId4`, `ReqItemId5`, `ReqItemId6`, `ReqItemCount1`, `ReqItemCount2`, `ReqItemCount3`, `ReqItemCount4`, `ReqItemCount5`, `ReqItemCount6`, `ReqSourceId1`, `ReqSourceId2`, `ReqSourceId3`, `ReqSourceId4`, `ReqSourceCount1`, `ReqSourceCount2`, `ReqSourceCount3`, `ReqSourceCount4`, `ReqCreatureOrGOId1`, `ReqCreatureOrGOId2`, `ReqCreatureOrGOId3`, `ReqCreatureOrGOId4`, `ReqCreatureOrGOCount1`, `ReqCreatureOrGOCount2`, `ReqCreatureOrGOCount3`, `ReqCreatureOrGOCount4`, `ReqSpellCast1`, `ReqSpellCast2`, `ReqSpellCast3`, `ReqSpellCast4`, `RewChoiceItemId1`, `RewChoiceItemId2`, `RewChoiceItemId3`, `RewChoiceItemId4`, `RewChoiceItemId5`, `RewChoiceItemId6`, `RewChoiceItemCount1`, `RewChoiceItemCount2`, `RewChoiceItemCount3`, `RewChoiceItemCount4`, `RewChoiceItemCount5`, `RewChoiceItemCount6`, `RewItemId1`, `RewItemId2`, `RewItemId3`, `RewItemId4`, `RewItemCount1`, `RewItemCount2`, `RewItemCount3`, `RewItemCount4`, `RewRepFaction1`, `RewRepFaction2`, `RewRepFaction3`, `RewRepFaction4`, `RewRepFaction5`, `RewRepValueId1`, `RewRepValueId2`, `RewRepValueId3`, `RewRepValueId4`, `RewRepValueId5`, `RewRepValue1`, `RewRepValue2`, `RewRepValue3`, `RewRepValue4`, `RewRepValue5`, `RewHonorAddition`, `RewHonorMultiplier`, `unk0`, `RewOrReqMoney`, `RewMoneyMaxLevel`, `RewSpell`, `RewSpellCast`, `RewMailTemplateId`, `RewMailDelaySecs`, `PointMapId`, `PointX`, `PointY`, `PointOpt`, `DetailsEmote1`, `DetailsEmote2`, `DetailsEmote3`, `DetailsEmote4`, `DetailsEmoteDelay1`, `DetailsEmoteDelay2`, `DetailsEmoteDelay3`, `DetailsEmoteDelay4`, `IncompleteEmote`, `CompleteEmote`, `OfferRewardEmote1`, `OfferRewardEmote2`, `OfferRewardEmote3`, `OfferRewardEmote4`, `OfferRewardEmoteDelay1`, `OfferRewardEmoteDelay2`, `OfferRewardEmoteDelay3`, `OfferRewardEmoteDelay4`, `StartScript`, `CompleteScript`, `WDBVerified`) VALUES (13191, 2, 4197, 0, 78, 0, 80, 41, 690, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 32968, 1, 0, 0, 0, 0, 0, 0, 13191, 0, 5, 0, 0, 0, 'Fueling the Demolishers', 'Lok\'tar, $n! While the battle may be over, we must prepare for the Alliance\'s next assault! Travel to the Cauldron of Flames in south eastern Wintergrasp and retrieve ten eternal embers.$B$BThe embers are mixed in with coal to fuel the Demolishers and Siege Engines. $B$BWe\'ve heard reports of Alliance pigs collecting the embers all day. Slay them and take their embers! If they have already abandoned the area, then be prepared to fight the fire elementals there until you find some!', 'Siegesmith Stronghoof at Wintergrasp Fortress wants you to retrieve 10 Eternal Embers from Alliance players in the Cauldron of Flames.', 'Excellent! This will help us defeat the Alliance in the battles to come!', 'Well? Did you manage to find the embers or did the Alliance beat you to it and leave you crying?', '', 'Return to Siegesmith Stronghoof in Wintergrasp.', '', '', '', '', 43314, 0, 0, 0, 0, 0, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 43228, 0, 0, 0, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 30, 0, 74000, 132300, 0, 0, 0, 0, 571, 4293.47, 1813.27, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 12340);

Горючее для разрушителей

Code

DELETE FROM `creature_questrelation` WHERE `quest`=13200;
  DELETE FROM `gameobject_questrelation` WHERE `quest`=13200;
  UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest`=13200;
  INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (31106, 13200);
  UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=31106;
  DELETE FROM `creature_involvedrelation` WHERE `quest`=13200;
  DELETE FROM `gameobject_involvedrelation` WHERE `quest`=13200;
  INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (31091, 13200);
  UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=31091;
  REPLACE INTO `quest_template` (`entry`, `Method`, `ZoneOrSort`, `SkillOrClassMask`, `MinLevel`, `MaxLevel`, `QuestLevel`, `Type`, `RequiredRaces`, `RequiredSkillValue`, `RepObjectiveFaction`, `RepObjectiveValue`, `RepObjectiveFaction2`, `RepObjectiveValue2`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepFaction`, `RequiredMaxRepValue`, `SuggestedPlayers`, `LimitTime`, `QuestFlags`, `SpecialFlags`, `CharTitleId`, `PlayersSlain`, `BonusTalents`, `RewardArenaPoints`, `PrevQuestId`, `NextQuestId`, `ExclusiveGroup`, `NextQuestInChain`, `RewXPId`, `SrcItemId`, `SrcItemCount`, `SrcSpell`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `RequestItemsText`, `EndText`, `CompletedText`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `ReqItemId1`, `ReqItemId2`, `ReqItemId3`, `ReqItemId4`, `ReqItemId5`, `ReqItemId6`, `ReqItemCount1`, `ReqItemCount2`, `ReqItemCount3`, `ReqItemCount4`, `ReqItemCount5`, `ReqItemCount6`, `ReqSourceId1`, `ReqSourceId2`, `ReqSourceId3`, `ReqSourceId4`, `ReqSourceCount1`, `ReqSourceCount2`, `ReqSourceCount3`, `ReqSourceCount4`, `ReqCreatureOrGOId1`, `ReqCreatureOrGOId2`, `ReqCreatureOrGOId3`, `ReqCreatureOrGOId4`, `ReqCreatureOrGOCount1`, `ReqCreatureOrGOCount2`, `ReqCreatureOrGOCount3`, `ReqCreatureOrGOCount4`, `ReqSpellCast1`, `ReqSpellCast2`, `ReqSpellCast3`, `ReqSpellCast4`, `RewChoiceItemId1`, `RewChoiceItemId2`, `RewChoiceItemId3`, `RewChoiceItemId4`, `RewChoiceItemId5`, `RewChoiceItemId6`, `RewChoiceItemCount1`, `RewChoiceItemCount2`, `RewChoiceItemCount3`, `RewChoiceItemCount4`, `RewChoiceItemCount5`, `RewChoiceItemCount6`, `RewItemId1`, `RewItemId2`, `RewItemId3`, `RewItemId4`, `RewItemCount1`, `RewItemCount2`, `RewItemCount3`, `RewItemCount4`, `RewRepFaction1`, `RewRepFaction2`, `RewRepFaction3`, `RewRepFaction4`, `RewRepFaction5`, `RewRepValueId1`, `RewRepValueId2`, `RewRepValueId3`, `RewRepValueId4`, `RewRepValueId5`, `RewRepValue1`, `RewRepValue2`, `RewRepValue3`, `RewRepValue4`, `RewRepValue5`, `RewHonorAddition`, `RewHonorMultiplier`, `unk0`, `RewOrReqMoney`, `RewMoneyMaxLevel`, `RewSpell`, `RewSpellCast`, `RewMailTemplateId`, `RewMailDelaySecs`, `PointMapId`, `PointX`, `PointY`, `PointOpt`, `DetailsEmote1`, `DetailsEmote2`, `DetailsEmote3`, `DetailsEmote4`, `DetailsEmoteDelay1`, `DetailsEmoteDelay2`, `DetailsEmoteDelay3`, `DetailsEmoteDelay4`, `IncompleteEmote`, `CompleteEmote`, `OfferRewardEmote1`, `OfferRewardEmote2`, `OfferRewardEmote3`, `OfferRewardEmote4`, `OfferRewardEmoteDelay1`, `OfferRewardEmoteDelay2`, `OfferRewardEmoteDelay3`, `OfferRewardEmoteDelay4`, `StartScript`, `CompleteScript`, `WDBVerified`) VALUES (13200, 2, 4197, 0, 78, 0, 80, 41, 690, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 32968, 1, 0, 0, 0, 0, 0, 0, 13191, 0, 5, 0, 0, 0, 'Fueling the Demolishers', 'Lok\'tar, $n! While the battle may have subsided, we must prepare to retake the fortress! Travel to the Cauldron of Flames in south eastern Wintergrasp and retrieve ten eternal embers.$B$BThe embers are mixed in with coal to fuel the Demolishers and Siege Engines. $B$BWe\'ve heard reports of Alliance pigs collecting the embers all day. Slay them and take their embers! If they have already abandoned the area, then be prepared to fight the fire elementals there until you find some!', 'Siegesmith Stronghoof in Wintergrasp wants you to retrieve 10 Eternal Embers from Alliance players at the Cauldron of Flames.', 'Excellent! That should put a dent in their war machines!', 'Well? Did you manage to find the embers or did the Alliance beat you to it and leave you crying?', '', 'Return to Siegesmith Stronghoof in Wintergrasp.', '', '', '', '', 43314, 0, 0, 0, 0, 0, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 43228, 0, 0, 0, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 30, 0, 74000, 132300, 0, 0, 0, 0, 571, 4293.47, 1813.27, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 12340);

Wintergrasp (ОЛО)

STALKER — Fri, 02 Mar 2012 17:25:23 GMT

Wintergrasp by Chaos_UA & TCRC TEAM rev.11413+
Патч можно скачать здесь: https://bitbucket.org/TCRC/patches/changesets
Тестируем, возможны мелкие баги, ну в прочем все должно работать как и на старом ядре.
SQL запрос для патча в комплекте с патчем на ядро!
PS: компиляция сервера без скриптов даст 100% краш в игре

1. Танки уничтожаются при окончании битвы
2. Счетчик танков работает!
3. Анонс на весь мир за 30 и 10 минут до битвы (не близлайк, хотите закоментируйте сами ту часть)
4. Добавлено проверку на высоту и такси при полете над ОЛО. Теперь можно летать по зоне ОЛО во время боя если вы летите выше Z>619.
5. Кик-система игроков ниже 75лвл во время старта битвы телепортирует в Даларан. (не идеально не близлайк, зато работает)
6. Система звуковых сообщений во время старта битвы, и во время атаки разных сооружений. (без понятия как там offlike)
7. Есть Антифарм система но не активна, кому надо разкомментируйте проверочную часть в StartBattle.
8. Введено Телепорт с Даларана на ОЛО во время боя, когда боя нету телепортировать не будет. Спаун порталов пока не реализирован, придется вручную их поставить, и пускай себе стоят. Портирует на базу фракции если вы атакующая сторона и в крепость если вы защитник.
9. Таймер на вкладке БГ теперь всегда показывает время by Null & Kirito! Разработано систему обновления времени by maxdestroyer, доработано вызов обновлений таймера by ChaosUA.
10. Патч совместим с Stand of The Ancient (Берег Древних)
11. Реализировано worldstates - сохранение трех основных параметров ОЛО которые восстанавливаются после краша/рестарта сервера (время, кто защитник, состояние боя) спс Easy. Усовершенствовано by Imprtat
12. Исправлено баг с воскрешением по всей зоне Thx Kitiara
13. Исправлено целителей душ на кладбищах. Теперь на кладбище будут целители лишь для контролирующей фракции (для этого надо разкоментировать код в OutdoorPvPWG.cpp). Thx Kitiara
14. Переделано телепорт систему осадной техники с крепости by maxdestroyer.
15. Добавлено дополнительную защиту на вход в Склеп Аркавона, котрая не впустит атакующую сторону во внутрь.
16. Добавлено поддержку переключения Флагов ОЛО и смену охраны в крепости с помощью фаз. (Фазы А/О 257(256+1)/65(64+1), фаза боя всегда 1)

Надо профиксить:
1. реализация регистрации на бой не в моих силах, так что извиняйте, напрягайте на счет этого кого нить знающего.
2. Во время боя система распределения умерших по кладбищам не идеальна, атакующих часто кидает на кладбище крепости.
3. Инвертированный спаун НПС после смерти
4. Нужно усовершенствовать новую систему телепорта машин
5. Доработать систему смены НПС в крепости
6. Ворлдстейты должны сохранять состояние разрушаемых обектов и мастерских

Фикс Рулетка, PvPRank

STALKER — Fri, 02 Mar 2012 17:21:29 GMT

[blizz]тут есть телепортер, патчи на ботов, рулетку, пвпранги, 2 вида античита, различные патчи на привязку к сети IRC[/blizz]

Скачать

Фиксы кв CATA

STALKER — Fri, 02 Mar 2012 17:19:55 GMT

фикс кв http://ru.wowhead.com/quest=26183

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 (203762, 3, 433, 'Juicy Apple', '', 'Gathering', '', 0, 4, 1, 57197, 0, 0, 0, 0, 0, 259, 203762, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 24982, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 13329);

Красивые спелы (гм)

STALKER — Fri, 02 Mar 2012 17:17:40 GMT

чтоб изучить спел вам нужно прописать команду (.learn и ид спела )
пример (.learn 26662 ).
ид спелов виде красивых молний

63483
63485
63491
63494
63486 .

разные

63489
63492 - смертник
63493
63507
63519
63525
63528 - супер заряд
63533 - штормовая волна
63540 - парализующая область
63546
63547- обезумевшая земля
63550