STALKER |
Дата: Суббота, 10.03.2012, 00:04 | Сообщение # 1 Offline |
| Алхимия:
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 |
Дата: Суббота, 10.03.2012, 00:04 | Сообщение # 2 Offline |
| Кузнечное дело: 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 (70011, 0, 0, 0, 0, 0,
18593, 0, 18593, 0, 'Alard Schmied', 'Grand Master Blacksmithing Trainer', '', 0, 83, 83, 2, 35, 35, 81, 2, 2, 1, 2, 340, 510, 0,
127, 100, 2000, 2000, 1, 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, 0, 10, 0, 0, 0, 0, 0, 0, 0, 0, 1, 4321, 0, 0, '', 12340);
DELETE FROM `npc_trainer` WHERE (`entry`=70011); INSERT INTO `npc_trainer` (entry, spell, spellcost, reqskill, reqskillvalue, reqlevel) VALUES (70011, 2020, 0, 0, 0, 0), (70011, 2021, 0, 0, 0, 0), (70011, 2661, 0, 0, 0, 0), (70011, 2662, 0, 0, 0, 0), (70011, 2664, 0, 0, 0, 0), (70011, 2665, 0, 0, 0, 0), (70011, 2666, 0, 0, 0, 0), (70011, 2668, 0, 0, 0, 0), (70011, 2670, 0, 0, 0, 0), (70011, 2672, 0, 0, 0, 0), (70011, 2674, 0, 0, 0, 0), (70011, 2675, 0, 0, 0, 0), (70011, 2737, 0, 0, 0, 0), (70011, 2738, 0, 0, 0, 0), (70011, 2739, 0, 0, 0, 0), (70011, 2740, 0, 0, 0, 0), (70011, 2741, 0, 0, 0, 0), (70011, 2742, 0, 0, 0, 0), (70011, 3116, 0, 0, 0, 0), (70011, 3117, 0, 0, 0, 0), (70011, 3292, 0, 0, 0, 0), (70011, 3293, 0, 0, 0, 0), (70011, 3294, 0, 0, 0, 0), (70011, 3296, 0, 0, 0, 0), (70011, 3319, 0, 0, 0, 0), (70011, 3320, 0, 0, 0, 0), (70011, 3323, 0, 0, 0, 0), (70011, 3324, 0, 0, 0, 0), (70011, 3326, 0, 0, 0, 0), (70011, 3328, 0, 0, 0, 0), (70011, 3331, 0, 0, 0, 0), (70011, 3333, 0, 0, 0, 0), (70011, 3337, 0, 0, 0, 0), (70011, 3491, 0, 0, 0, 0), (70011, 3501, 0, 0, 0, 0), (70011, 3502, 0, 0, 0, 0), (70011, 3506, 0, 0, 0, 0), (70011, 3508, 0, 0, 0, 0), (70011, 3539, 0, 0, 0, 0), (70011, 6517, 0, 0, 0, 0), (70011, 7223, 0, 0, 0, 0), (70011, 7408, 0, 0, 0, 0), (70011, 7817, 0, 0, 0, 0), (70011, 7818, 0, 0, 0, 0), (70011, 8768, 0, 0, 0, 0), (70011, 8880, 0, 0, 0, 0), (70011, 9786, 0, 0, 0, 0), (70011, 9916, 0, 0, 0, 0), (70011, 9918, 0, 0, 0, 0), (70011, 9920, 0, 0, 0, 0), (70011, 9921, 0, 0, 0, 0), (70011, 9926, 0, 0, 0, 0), (70011, 9928, 0, 0, 0, 0), (70011, 9931, 0, 0, 0, 0), (70011, 9935, 0, 0, 0, 0), (70011, 9959, 0, 0, 0, 0), (70011, 9961, 0, 0, 0, 0), (70011, 9968, 0, 0, 0, 0), (70011, 9983, 0, 0, 0, 0), (70011, 9985, 0, 0, 0, 0), (70011, 9986, 0, 0, 0, 0), (70011, 9987, 0, 0, 0, 0), (70011, 9993, 0, 0, 0, 0), (70011, 10001, 0, 0, 0, 0), (70011, 14379, 0, 0, 0, 0), (70011, 14380, 0, 0, 0, 0), (70011, 15972, 0, 0, 0, 0), (70011, 16639, 0, 0, 0, 0), (70011, 16640, 0, 0, 0, 0), (70011, 16641, 0, 0, 0, 0), (70011, 19666, 0, 0, 0, 0), (70011, 19667, 0, 0, 0, 0), (70011, 19668, 0, 0, 0, 0), (70011, 19669, 0, 0, 0, 0), (70011, 20201, 0, 0, 0, 0), (70011, 29545, 0, 0, 0, 0), (70011, 29547, 0, 0, 0, 0), (70011, 29548, 0, 0, 0, 0), (70011, 29549, 0, 0, 0, 0), (70011, 29550, 0, 0, 0, 0), (70011, 29551, 0, 0, 0, 0), (70011, 29552, 0, 0, 0, 0), (70011, 29553, 0, 0, 0, 0), (70011, 29556, 0, 0, 0, 0), (70011, 29557, 0, 0, 0, 0), (70011, 29558, 0, 0, 0, 0), (70011, 29565, 0, 0, 0, 0), (70011, 29654, 0, 0, 0, 0), (70011, 29845, 0, 0, 0, 0), (70011, 32284, 0, 0, 0, 0), (70011, 32655, 0, 0, 0, 0), (70011, 34607, 0, 0, 0, 0), (70011, 34979, 0, 0, 0, 0), (70011, 34981, 0, 0, 0, 0), (70011, 34982, 0, 0, 0, 0), (70011, 34983, 0, 0, 0, 0), (70011, 51298, 0, 0, 0, 0), (70011, 52567, 0, 0, 0, 0), (70011, 52568, 0, 0, 0, 0), (70011, 52569, 0, 0, 0, 0), (70011, 52570, 0, 0, 0, 0), (70011, 52571, 0, 0, 0, 0), (70011, 52572, 0, 0, 0, 0), (70011, 54550, 0, 0, 0, 0), (70011, 54551, 0, 0, 0, 0), (70011, 54552, 0, 0, 0, 0), (70011, 54553, 0, 0, 0, 0), (70011, 54554, 0, 0, 0, 0), (70011, 54555, 0, 0, 0, 0), (70011, 54556, 0, 0, 0, 0), (70011, 54557, 0, 0, 0, 0), (70011, 54917, 0, 0, 0, 0), (70011, 54918, 0, 0, 0, 0), (70011, 54941, 0, 0, 0, 0), (70011, 54944, 0, 0, 0, 0), (70011, 54945, 0, 0, 0, 0), (70011, 54946, 0, 0, 0, 0), (70011, 54947, 0, 0, 0, 0), (70011, 54948, 0, 0, 0, 0), (70011, 54949, 0, 0, 0, 0), (70011, 55013, 0, 0, 0, 0), (70011, 55014, 0, 0, 0, 0), (70011, 55015, 0, 0, 0, 0), (70011, 55017, 0, 0, 0, 0), (70011, 55055, 0, 0, 0, 0), (70011, 55056, 0, 0, 0, 0), (70011, 55057, 0, 0, 0, 0), (70011, 55058, 0, 0, 0, 0), (70011, 55174, 0, 0, 0, 0), (70011, 55177, 0, 0, 0, 0), (70011, 55179, 0, 0, 0, 0), (70011, 55181, 0, 0, 0, 0), (70011, 55182, 0, 0, 0, 0), (70011, 55200, 0, 0, 0, 0), (70011, 55201, 0, 0, 0, 0), (70011, 55202, 0, 0, 0, 0), (70011, 55203, 0, 0, 0, 0), (70011, 55204, 0, 0, 0, 0), (70011, 55206, 0, 0, 0, 0), (70011, 55298, 0, 0, 0, 0), (70011, 55300, 0, 0, 0, 0), (70011, 55301, 0, 0, 0, 0), (70011, 55302, 0, 0, 0, 0), (70011, 55303, 0, 0, 0, 0), (70011, 55304, 0, 0, 0, 0), (70011, 55305, 0, 0, 0, 0), (70011, 55306, 0, 0, 0, 0), (70011, 55307, 0, 0, 0, 0), (70011, 55308, 0, 0, 0, 0), (70011, 55309, 0, 0, 0, 0), (70011, 55310, 0, 0, 0, 0), (70011, 55311, 0, 0, 0, 0), (70011, 55312, 0, 0, 0, 0), (70011, 55369, 0, 0, 0, 0), (70011, 55370, 0, 0, 0, 0), (70011, 55371, 0, 0, 0, 0), (70011, 55372, 0, 0, 0, 0), (70011, 55373, 0, 0, 0, 0), (70011, 55374, 0, 0, 0, 0), (70011, 55375, 0, 0, 0, 0), (70011, 55376, 0, 0, 0, 0), (70011, 55377, 0, 0, 0, 0), (70011, 55628, 0, 0, 0, 0), (70011, 55641, 0, 0, 0, 0), (70011, 55656, 0, 0, 0, 0), (70011, 55732, 0, 0, 0, 0), (70011, 55834, 0, 0, 0, 0), (70011, 55835, 0, 0, 0, 0), (70011, 55839, 0, 0, 0, 0), (70011, 56234, 0, 0, 0, 0), (70011, 56280, 0, 0, 0, 0), (70011, 56357, 0, 0, 0, 0), (70011, 56400, 0, 0, 0, 0), (70011, 56549, 0, 0, 0, 0), (70011, 56550, 0, 0, 0, 0), (70011, 56551, 0, 0, 0, 0), (70011, 56552, 0, 0, 0, 0), (70011, 56553, 0, 0, 0, 0), (70011, 56554, 0, 0, 0, 0), (70011, 56555, 0, 0, 0, 0), (70011, 56556, 0, 0, 0, 0), (70011, 59405, 0, 0, 0, 0), (70011, 59406, 0, 0, 0, 0), (70011, 59436, 0, 0, 0, 0), (70011, 59438, 0, 0, 0, 0), (70011, 59440, 0, 0, 0, 0), (70011, 59441, 0, 0, 0, 0), (70011, 59442, 0, 0, 0, 0), (70011, 61008, 0, 0, 0, 0), (70011, 61009, 0, 0, 0, 0), (70011, 61010, 0, 0, 0, 0), (70011, 63182, 0, 0, 0, 0);
|
|
| |