|
   |
| Модератор форума: Dimitro |
| Форум » TrinityCore » Патчи / Моды / Фиксы для Trinity » Тренеры (Профессий) |
| Тренеры |
http://s018.radikal.ru/i514/1201/2a/730b57ee42c5.jpg пример
Спасибо PanDaemonAeon за паблик альтершоп откуда были взяты материалы для работы))) Алхимия 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); Инжинерное дело 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); Кожевничество 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); Добавлено (07.01.2012, 22:51) 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); Добавлено (07.01.2012, 22:51) 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 (70019, 0, 0, 0, 0, 0, 27153, 0, 27153, 0, 'Johan Barnes', 'Master Enchanting Trainer', '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, 1728, 0, 2, '', 12340); DELETE FROM `npc_trainer` WHERE (`entry`=70019); INSERT INTO `npc_trainer` (entry, spell, spellcost, reqskill, reqskillvalue, reqlevel) VALUES (70019, 7414, 0, 0, 0, 0), (70019, 7415, 0, 0, 0, 0), (70019, 7416, 0, 0, 0, 0), (70019, 7420, 0, 0, 0, 0), (70019, 7426, 0, 0, 0, 0), (70019, 7454, 0, 0, 0, 0), (70019, 7457, 0, 0, 0, 0), (70019, 7745, 0, 0, 0, 0), (70019, 7748, 0, 0, 0, 0), (70019, 7771, 0, 0, 0, 0), (70019, 7779, 0, 0, 0, 0), (70019, 7788, 0, 0, 0, 0), (70019, 7795, 0, 0, 0, 0), (70019, 7857, 0, 0, 0, 0), (70019, 7861, 0, 0, 0, 0), (70019, 7863, 0, 0, 0, 0), (70019, 13378, 0, 0, 0, 0), (70019, 13421, 0, 0, 0, 0), (70019, 13485, 0, 0, 0, 0), (70019, 13501, 0, 0, 0, 0), (70019, 13503, 0, 0, 0, 0), (70019, 13529, 0, 0, 0, 0), (70019, 13538, 0, 0, 0, 0), (70019, 13607, 0, 0, 0, 0), (70019, 13622, 0, 0, 0, 0), (70019, 13626, 0, 0, 0, 0), (70019, 13628, 0, 0, 0, 0), (70019, 13631, 0, 0, 0, 0), (70019, 13635, 0, 0, 0, 0), (70019, 13637, 0, 0, 0, 0), (70019, 13640, 0, 0, 0, 0), (70019, 13642, 0, 0, 0, 0), (70019, 13644, 0, 0, 0, 0), (70019, 13648, 0, 0, 0, 0), (70019, 13657, 0, 0, 0, 0), (70019, 13659, 0, 0, 0, 0), (70019, 13661, 0, 0, 0, 0), (70019, 13663, 0, 0, 0, 0), (70019, 13693, 0, 0, 0, 0), (70019, 13695, 0, 0, 0, 0), (70019, 13700, 0, 0, 0, 0), (70019, 13702, 0, 0, 0, 0), (70019, 13746, 0, 0, 0, 0), (70019, 13794, 0, 0, 0, 0), (70019, 13815, 0, 0, 0, 0), (70019, 13822, 0, 0, 0, 0), (70019, 13836, 0, 0, 0, 0), (70019, 13858, 0, 0, 0, 0), (70019, 13887, 0, 0, 0, 0), (70019, 13890, 0, 0, 0, 0), (70019, 13905, 0, 0, 0, 0), (70019, 13917, 0, 0, 0, 0), (70019, 13921, 0, 0, 0, 0), (70019, 13935, 0, 0, 0, 0), (70019, 13937, 0, 0, 0, 0), (70019, 13939, 0, 0, 0, 0), (70019, 13941, 0, 0, 0, 0), (70019, 13943, 0, 0, 0, 0), (70019, 13948, 0, 0, 0, 0), (70019, 14293, 0, 0, 0, 0), (70019, 14807, 0, 0, 0, 0), (70019, 14809, 0, 0, 0, 0), (70019, 14810, 0, 0, 0, 0), (70019, 17180, 0, 0, 0, 0), (70019, 17181, 0, 0, 0, 0), (70019, 20008, 0, 0, 0, 0), (70019, 20012, 0, 0, 0, 0), (70019, 20013, 0, 0, 0, 0), (70019, 20014, 0, 0, 0, 0), (70019, 20016, 0, 0, 0, 0), (70019, 20023, 0, 0, 0, 0), (70019, 20028, 0, 0, 0, 0), (70019, 27899, 0, 0, 0, 0), (70019, 27905, 0, 0, 0, 0), (70019, 27944, 0, 0, 0, 0), (70019, 27957, 0, 0, 0, 0), (70019, 27958, 0, 0, 0, 0), (70019, 27961, 0, 0, 0, 0), (70019, 28027, 0, 0, 0, 0), (70019, 28028, 0, 0, 0, 0), (70019, 28030, 0, 0, 0, 0), (70019, 32664, 0, 0, 0, 0), (70019, 32667, 0, 0, 0, 0), (70019, 33990, 0, 0, 0, 0), (70019, 33991, 0, 0, 0, 0), (70019, 33993, 0, 0, 0, 0), (70019, 33995, 0, 0, 0, 0), (70019, 33996, 0, 0, 0, 0), (70019, 34001, 0, 0, 0, 0), (70019, 34002, 0, 0, 0, 0), (70019, 34004, 0, 0, 0, 0), (70019, 42613, 0, 0, 0, 0), (70019, 42615, 0, 0, 0, 0), (70019, 44383, 0, 0, 0, 0), (70019, 44484, 0, 0, 0, 0), (70019, 44488, 0, 0, 0, 0), (70019, 44489, 0, 0, 0, 0), (70019, 44492, 0, 0, 0, 0), (70019, 44500, 0, 0, 0, 0), (70019, 44506, 0, 0, 0, 0), (70019, 44508, 0, 0, 0, 0), (70019, 44509, 0, 0, 0, 0), (70019, 44510, 0, 0, 0, 0), (70019, 44513, 0, 0, 0, 0), (70019, 44528, 0, 0, 0, 0), (70019, 44529, 0, 0, 0, 0), (70019, 44555, 0, 0, 0, 0), (70019, 44582, 0, 0, 0, 0), (70019, 44584, 0, 0, 0, 0), (70019, 44589, 0, 0, 0, 0), (70019, 44592, 0, 0, 0, 0), (70019, 44593, 0, 0, 0, 0), (70019, 44598, 0, 0, 0, 0), (70019, 44616, 0, 0, 0, 0), (70019, 44623, 0, 0, 0, 0), (70019, 44629, 0, 0, 0, 0), (70019, 44630, 0, 0, 0, 0), (70019, 44633, 0, 0, 0, 0), (70019, 44635, 0, 0, 0, 0), (70019, 44636, 0, 0, 0, 0), (70019, 44645, 0, 0, 0, 0), (70019, 47766, 0, 0, 0, 0), (70019, 47900, 0, 0, 0, 0), (70019, 51312, 0, 0, 0, 0), (70019, 59636, 0, 0, 0, 0), (70019, 60606, 0, 0, 0, 0), (70019, 60609, 0, 0, 0, 0), (70019, 60616, 0, 0, 0, 0), (70019, 60619, 0, 0, 0, 0), (70019, 60621, 0, 0, 0, 0), (70019, 60623, 0, 0, 0, 0), (70019, 60653, 0, 0, 0, 0), (70019, 60663, 0, 0, 0, 0), (70019, 60668, 0, 0, 0, 0), (70019, 60767, 0, 0, 0, 0), (70019, 62959, 0, 0, 0, 0), (70019, 63746, 0, 0, 0, 0); Добавлено (07.01.2012, 22:52) 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 (70018, 0, 0, 0, 0, 0, 22974, 0, 22974, 0, 'Professor Pallin', 'Grand Master Inscription Trainer', '', 0, 83, 83, 2, 35, 35, 81, 2, 2, 1, 2, 248, 372, 0, 93, 100, 2000, 2000, 8, 2, 8, 0, 2, 0, 0, 0, 198, 298, 74, 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`=70018); INSERT INTO `npc_trainer` (entry, spell, spellcost, reqskill, reqskillvalue, reqlevel) VALUES (70018, 45357, 0, 0, 0, 0), (70018, 45375, 0, 0, 0, 0), (70018, 45376, 0, 0, 0, 0), (70018, 45377, 0, 0, 0, 0), (70018, 45378, 0, 0, 0, 0), (70018, 45379, 0, 0, 0, 0), (70018, 45380, 0, 0, 0, 0), (70018, 48121, 0, 0, 0, 0), (70018, 48247, 0, 0, 0, 0), (70018, 48248, 0, 0, 0, 0), (70018, 50598, 0, 0, 0, 0), (70018, 50599, 0, 0, 0, 0), (70018, 50600, 0, 0, 0, 0), (70018, 50601, 0, 0, 0, 0), (70018, 50602, 0, 0, 0, 0), (70018, 50603, 0, 0, 0, 0), (70018, 50604, 0, 0, 0, 0), (70018, 50605, 0, 0, 0, 0), (70018, 50606, 0, 0, 0, 0), (70018, 50607, 0, 0, 0, 0), (70018, 50608, 0, 0, 0, 0), (70018, 50609, 0, 0, 0, 0), (70018, 50610, 0, 0, 0, 0), (70018, 50611, 0, 0, 0, 0), (70018, 50612, 0, 0, 0, 0), (70018, 50614, 0, 0, 0, 0), (70018, 50616, 0, 0, 0, 0), (70018, 50617, 0, 0, 0, 0), (70018, 50618, 0, 0, 0, 0), (70018, 50619, 0, 0, 0, 0), (70018, 50620, 0, 0, 0, 0), (70018, 52739, 0, 0, 0, 0), (70018, 52840, 0, 0, 0, 0), (70018, 52843, 0, 0, 0, 0), (70018, 53462, 0, 0, 0, 0), (70018, 56943, 0, 0, 0, 0), (70018, 56945, 0, 0, 0, 0), (70018, 56948, 0, 0, 0, 0), (70018, 56951, 0, 0, 0, 0), (70018, 56952, 0, 0, 0, 0), (70018, 56953, 0, 0, 0, 0), (70018, 56955, 0, 0, 0, 0), (70018, 56956, 0, 0, 0, 0), (70018, 56957, 0, 0, 0, 0), (70018, 56959, 0, 0, 0, 0), (70018, 56961, 0, 0, 0, 0), (70018, 56963, 0, 0, 0, 0), (70018, 56968, 0, 0, 0, 0), (70018, 56971, 0, 0, 0, 0), (70018, 56972, 0, 0, 0, 0), (70018, 56973, 0, 0, 0, 0), (70018, 56974, 0, 0, 0, 0), (70018, 56976, 0, 0, 0, 0), (70018, 56978, 0, 0, 0, 0), (70018, 56979, 0, 0, 0, 0), (70018, 56980, 0, 0, 0, 0), (70018, 56981, 0, 0, 0, 0), (70018, 56982, 0, 0, 0, 0), (70018, 56984, 0, 0, 0, 0), (70018, 56985, 0, 0, 0, 0), (70018, 56987, 0, 0, 0, 0), (70018, 56991, 0, 0, 0, 0), (70018, 56994, 0, 0, 0, 0), (70018, 56995, 0, 0, 0, 0), (70018, 56997, 0, 0, 0, 0), (70018, 57000, 0, 0, 0, 0), (70018, 57001, 0, 0, 0, 0), (70018, 57002, 0, 0, 0, 0), (70018, 57003, 0, 0, 0, 0), (70018, 57004, 0, 0, 0, 0), (70018, 57005, 0, 0, 0, 0), (70018, 57006, 0, 0, 0, 0), (70018, 57007, 0, 0, 0, 0), (70018, 57008, 0, 0, 0, 0), (70018, 57009, 0, 0, 0, 0), (70018, 57020, 0, 0, 0, 0), (70018, 57022, 0, 0, 0, 0), (70018, 57023, 0, 0, 0, 0), (70018, 57024, 0, 0, 0, 0), (70018, 57025, 0, 0, 0, 0), (70018, 57026, 0, 0, 0, 0), (70018, 57027, 0, 0, 0, 0), (70018, 57029, 0, 0, 0, 0), (70018, 57030, 0, 0, 0, 0), (70018, 57031, 0, 0, 0, 0), (70018, 57032, 0, 0, 0, 0), (70018, 57033, 0, 0, 0, 0), (70018, 57036, 0, 0, 0, 0), (70018, 57113, 0, 0, 0, 0), (70018, 57114, 0, 0, 0, 0), (70018, 57119, 0, 0, 0, 0), (70018, 57120, 0, 0, 0, 0), (70018, 57121, 0, 0, 0, 0), (70018, 57122, 0, 0, 0, 0), (70018, 57123, 0, 0, 0, 0), (70018, 57125, 0, 0, 0, 0), (70018, 57129, 0, 0, 0, 0), (70018, 57131, 0, 0, 0, 0), (70018, 57132, 0, 0, 0, 0), (70018, 57133, 0, 0, 0, 0), (70018, 57151, 0, 0, 0, 0), (70018, 57154, 0, 0, 0, 0), (70018, 57156, 0, 0, 0, 0), (70018, 57157, 0, 0, 0, 0), (70018, 57158, 0, 0, 0, 0), (70018, 57161, 0, 0, 0, 0), (70018, 57162, 0, 0, 0, 0), (70018, 57163, 0, 0, 0, 0), (70018, 57165, 0, 0, 0, 0), (70018, 57167, 0, 0, 0, 0), (70018, 57168, 0, 0, 0, 0), (70018, 57172, 0, 0, 0, 0), (70018, 57183, 0, 0, 0, 0), (70018, 57184, 0, 0, 0, 0), (70018, 57185, 0, 0, 0, 0), (70018, 57186, 0, 0, 0, 0), (70018, 57187, 0, 0, 0, 0), (70018, 57188, 0, 0, 0, 0), (70018, 57192, 0, 0, 0, 0), (70018, 57194, 0, 0, 0, 0), (70018, 57196, 0, 0, 0, 0), (70018, 57197, 0, 0, 0, 0), (70018, 57198, 0, 0, 0, 0), (70018, 57200, 0, 0, 0, 0), (70018, 57201, 0, 0, 0, 0), (70018, 57210, 0, 0, 0, 0), (70018, 57213, 0, 0, 0, 0), (70018, 57216, 0, 0, 0, 0), (70018, 57219, 0, 0, 0, 0), (70018, 57221, 0, 0, 0, 0), (70018, 57222, 0, 0, 0, 0), (70018, 57224, 0, 0, 0, 0), (70018, 57225, 0, 0, 0, 0), (70018, 57226, 0, 0, 0, 0), (70018, 57227, 0, 0, 0, 0), (70018, 57236, 0, 0, 0, 0), (70018, 57238, 0, 0, 0, 0), (70018, 57239, 0, 0, 0, 0), (70018, 57240, 0, 0, 0, 0), (70018, 57241, 0, 0, 0, 0), (70018, 57242, 0, 0, 0, 0), (70018, 57244, 0, 0, 0, 0), (70018, 57245, 0, 0, 0, 0), (70018, 57246, 0, 0, 0, 0), (70018, 57248, 0, 0, 0, 0), (70018, 57249, 0, 0, 0, 0), (70018, 57251, 0, 0, 0, 0), (70018, 57252, 0, 0, 0, 0), (70018, 57257, 0, 0, 0, 0), (70018, 57259, 0, 0, 0, 0), (70018, 57262, 0, 0, 0, 0), (70018, 57265, 0, 0, 0, 0), (70018, 57266, 0, 0, 0, 0), (70018, 57269, 0, 0, 0, 0), (70018, 57270, 0, 0, 0, 0), (70018, 57271, 0, 0, 0, 0), (70018, 57272, 0, 0, 0, 0), (70018, 57274, 0, 0, 0, 0), (70018, 57275, 0, 0, 0, 0), (70018, 57277, 0, 0, 0, 0), (70018, 57703, 0, 0, 0, 0), (70018, 57704, 0, 0, 0, 0), (70018, 57706, 0, 0, 0, 0), (70018, 57707, 0, 0, 0, 0), (70018, 57708, 0, 0, 0, 0), (70018, 57709, 0, 0, 0, 0), (70018, 57710, 0, 0, 0, 0), (70018, 57711, 0, 0, 0, 0), (70018, 57712, 0, 0, 0, 0), (70018, 57713, 0, 0, 0, 0), (70018, 57714, 0, 0, 0, 0), (70018, 57715, 0, 0, 0, 0), (70018, 57716, 0, 0, 0, 0), (70018, 58472, 0, 0, 0, 0), (70018, 58473, 0, 0, 0, 0), (70018, 58476, 0, 0, 0, 0), (70018, 58478, 0, 0, 0, 0), (70018, 58480, 0, 0, 0, 0), (70018, 58481, 0, 0, 0, 0), (70018, 58482, 0, 0, 0, 0), (70018, 58483, 0, 0, 0, 0), (70018, 58484, 0, 0, 0, 0), (70018, 58485, 0, 0, 0, 0), (70018, 58486, 0, 0, 0, 0), (70018, 58487, 0, 0, 0, 0), (70018, 58488, 0, 0, 0, 0), (70018, 58489, 0, 0, 0, 0), (70018, 58490, 0, 0, 0, 0), (70018, 58491, 0, 0, 0, 0), (70018, 58565, 0, 0, 0, 0), (70018, 59338, 0, 0, 0, 0), (70018, 59339, 0, 0, 0, 0), (70018, 59340, 0, 0, 0, 0), (70018, 59387, 0, 0, 0, 0), (70018, 59475, 0, 0, 0, 0), (70018, 59478, 0, 0, 0, 0), (70018, 59480, 0, 0, 0, 0), (70018, 59484, 0, 0, 0, 0), (70018, 59486, 0, 0, 0, 0), (70018, 59487, 0, 0, 0, 0), (70018, 59488, 0, 0, 0, 0), (70018, 59489, 0, 0, 0, 0), (70018, 59490, 0, 0, 0, 0), (70018, 59491, 0, 0, 0, 0), (70018, 59493, 0, 0, 0, 0), (70018, 59494, 0, 0, 0, 0), (70018, 59495, 0, 0, 0, 0), (70018, 59496, 0, 0, 0, 0), (70018, 59497, 0, 0, 0, 0), (70018, 59498, 0, 0, 0, 0), (70018, 59499, 0, 0, 0, 0), (70018, 59500, 0, 0, 0, 0), (70018, 59501, 0, 0, 0, 0), (70018, 59502, 0, 0, 0, 0), (70018, 59503, 0, 0, 0, 0), (70018, 59504, 0, 0, 0, 0), (70018, 60336, 0, 0, 0, 0), (70018, 60337, 0, 0, 0, 0), (70018, 61117, 0, 0, 0, 0), (70018, 61118, 0, 0, 0, 0), (70018, 61119, 0, 0, 0, 0), (70018, 61120, 0, 0, 0, 0), (70018, 61177, 0, 0, 0, 0), (70018, 61288, 0, 0, 0, 0), (70018, 62162, 0, 0, 0, 0), (70018, 64053, 0, 0, 0, 0), (70018, 64258, 0, 0, 0, 0), (70018, 64259, 0, 0, 0, 0), (70018, 64260, 0, 0, 0, 0), (70018, 64261, 0, 0, 0, 0), (70018, 64262, 0, 0, 0, 0), (70018, 64266, 0, 0, 0, 0), (70018, 64267, 0, 0, 0, 0), (70018, 67600, 0, 0, 0, 0), (70018, 69385, 0, 0, 0, 0); Добавлено (07.01.2012, 22:52) 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 (70017, 0, 0, 0, 0, 0, 26866, 0, 26866, 0, 'Charles Worth', 'Grand Master Tailoring 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`=70017); INSERT INTO `npc_trainer` (entry, spell, spellcost, reqskill, reqskillvalue, reqlevel) VALUES (70017, 2385, 0, 0, 0, 0), (70017, 2386, 0, 0, 0, 0), (70017, 2392, 0, 0, 0, 0), (70017, 2393, 0, 0, 0, 0), (70017, 2394, 0, 0, 0, 0), (70017, 2395, 0, 0, 0, 0), (70017, 2396, 0, 0, 0, 0), (70017, 2397, 0, 0, 0, 0), (70017, 2399, 0, 0, 0, 0), (70017, 2401, 0, 0, 0, 0), (70017, 2402, 0, 0, 0, 0), (70017, 2406, 0, 0, 0, 0), (70017, 2964, 0, 0, 0, 0), (70017, 3755, 0, 0, 0, 0), (70017, 3757, 0, 0, 0, 0), (70017, 3813, 0, 0, 0, 0), (70017, 3839, 0, 0, 0, 0), (70017, 3840, 0, 0, 0, 0), (70017, 3841, 0, 0, 0, 0), (70017, 3842, 0, 0, 0, 0), (70017, 3843, 0, 0, 0, 0), (70017, 3845, 0, 0, 0, 0), (70017, 3848, 0, 0, 0, 0), (70017, 3850, 0, 0, 0, 0), (70017, 3852, 0, 0, 0, 0), (70017, 3855, 0, 0, 0, 0), (70017, 3859, 0, 0, 0, 0), (70017, 3861, 0, 0, 0, 0), (70017, 3865, 0, 0, 0, 0), (70017, 3866, 0, 0, 0, 0), (70017, 3871, 0, 0, 0, 0), (70017, 3911, 0, 0, 0, 0), (70017, 3912, 0, 0, 0, 0), (70017, 3913, 0, 0, 0, 0), (70017, 3914, 0, 0, 0, 0), (70017, 6521, 0, 0, 0, 0), (70017, 6690, 0, 0, 0, 0), (70017, 7623, 0, 0, 0, 0), (70017, 7624, 0, 0, 0, 0), (70017, 8465, 0, 0, 0, 0), (70017, 8467, 0, 0, 0, 0), (70017, 8483, 0, 0, 0, 0), (70017, 8489, 0, 0, 0, 0), (70017, 8758, 0, 0, 0, 0), (70017, 8760, 0, 0, 0, 0), (70017, 8762, 0, 0, 0, 0), (70017, 8764, 0, 0, 0, 0), (70017, 8766, 0, 0, 0, 0), (70017, 8770, 0, 0, 0, 0), (70017, 8772, 0, 0, 0, 0), (70017, 8774, 0, 0, 0, 0), (70017, 8776, 0, 0, 0, 0), (70017, 8791, 0, 0, 0, 0), (70017, 8799, 0, 0, 0, 0), (70017, 8804, 0, 0, 0, 0), (70017, 12045, 0, 0, 0, 0), (70017, 12046, 0, 0, 0, 0), (70017, 12048, 0, 0, 0, 0), (70017, 12049, 0, 0, 0, 0), (70017, 12050, 0, 0, 0, 0), (70017, 12053, 0, 0, 0, 0), (70017, 12061, 0, 0, 0, 0), (70017, 12065, 0, 0, 0, 0), (70017, 12067, 0, 0, 0, 0), (70017, 12069, 0, 0, 0, 0), (70017, 12070, 0, 0, 0, 0), (70017, 12072, 0, 0, 0, 0), (70017, 12073, 0, 0, 0, 0), (70017, 12074, 0, 0, 0, 0), (70017, 12077, 0, 0, 0, 0), (70017, 12079, 0, 0, 0, 0), (70017, 12088, 0, 0, 0, 0), (70017, 12092, 0, 0, 0, 0), (70017, 12181, 0, 0, 0, 0), (70017, 18401, 0, 0, 0, 0), (70017, 18402, 0, 0, 0, 0), (70017, 18403, 0, 0, 0, 0), (70017, 18406, 0, 0, 0, 0), (70017, 18407, 0, 0, 0, 0), (70017, 18409, 0, 0, 0, 0), (70017, 18410, 0, 0, 0, 0), (70017, 18411, 0, 0, 0, 0), (70017, 18413, 0, 0, 0, 0), (70017, 18414, 0, 0, 0, 0), (70017, 18415, 0, 0, 0, 0), (70017, 18416, 0, 0, 0, 0), (70017, 18417, 0, 0, 0, 0), (70017, 18420, 0, 0, 0, 0), (70017, 18421, 0, 0, 0, 0), (70017, 18423, 0, 0, 0, 0), (70017, 18424, 0, 0, 0, 0), (70017, 18437, 0, 0, 0, 0), (70017, 18438, 0, 0, 0, 0), (70017, 18441, 0, 0, 0, 0), (70017, 18442, 0, 0, 0, 0), (70017, 18444, 0, 0, 0, 0), (70017, 18446, 0, 0, 0, 0), (70017, 18449, 0, 0, 0, 0), (70017, 18450, 0, 0, 0, 0), (70017, 18451, 0, 0, 0, 0), (70017, 18453, 0, 0, 0, 0), (70017, 26745, 0, 0, 0, 0), (70017, 26746, 0, 0, 0, 0), (70017, 26764, 0, 0, 0, 0), (70017, 26765, 0, 0, 0, 0), (70017, 26770, 0, 0, 0, 0), (70017, 26771, 0, 0, 0, 0), (70017, 26772, 0, 0, 0, 0), (70017, 26791, 0, 0, 0, 0), (70017, 31460, 0, 0, 0, 0), (70017, 51308, 0, 0, 0, 0), (70017, 55642, 0, 0, 0, 0), (70017, 55769, 0, 0, 0, 0), (70017, 55777, 0, 0, 0, 0), (70017, 55898, 0, 0, 0, 0), (70017, 55899, 0, 0, 0, 0), (70017, 55900, 0, 0, 0, 0), (70017, 55901, 0, 0, 0, 0), (70017, 55902, 0, 0, 0, 0), (70017, 55903, 0, 0, 0, 0), (70017, 55904, 0, 0, 0, 0), (70017, 55906, 0, 0, 0, 0), (70017, 55907, 0, 0, 0, 0), (70017, 55908, 0, 0, 0, 0), (70017, 55910, 0, 0, 0, 0), (70017, 55911, 0, 0, 0, 0), (70017, 55913, 0, 0, 0, 0), (70017, 55914, 0, 0, 0, 0), (70017, 55919, 0, 0, 0, 0), (70017, 55920, 0, 0, 0, 0), (70017, 55921, 0, 0, 0, 0), (70017, 55922, 0, 0, 0, 0), (70017, 55923, 0, 0, 0, 0), (70017, 55924, 0, 0, 0, 0), (70017, 55925, 0, 0, 0, 0), (70017, 55941, 0, 0, 0, 0), (70017, 55943, 0, 0, 0, 0), (70017, 55995, 0, 0, 0, 0), (70017, 56000, 0, 0, |
newow, вроде как в "Портное дело" в последней строке не хватает:
Code 0, 0), Профы не все, а так пасиб - мож когданить пригодится)
Сообщение # 2 написано 11.01.2012 в 02:48
|
Просто кол-во символов в 1 посту ограничено ща остальное что влезет залью)))
Добавлено (14.01.2012, 02:16) 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 (70023, 0, 0, 0, 0, 0, 29774, 0, 29774, 0, 'Timothy Jones', 'Grand Master Jewelcrafting 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, 2029, 0, 0, '', 12340); DELETE FROM `npc_trainer` WHERE (`entry`=70023); INSERT INTO `npc_trainer` (entry, spell, spellcost, reqskill, reqskillvalue, reqlevel) VALUES (70023, 25245, 0, 0, 0, 0), (70023, 25246, 0, 0, 0, 0), (70023, 25278, 0, 0, 0, 0), (70023, 25280, 0, 0, 0, 0), (70023, 25283, 0, 0, 0, 0), (70023, 25284, 0, 0, 0, 0), (70023, 25287, 0, 0, 0, 0), (70023, 25305, 0, 0, 0, 0), (70023, 25317, 0, 0, 0, 0), (70023, 25318, 0, 0, 0, 0), (70023, 25321, 0, 0, 0, 0), (70023, 25490, 0, 0, 0, 0), (70023, 25498, 0, 0, 0, 0), (70023, 25613, 0, 0, 0, 0), (70023, 25615, 0, 0, 0, 0), (70023, 25620, 0, 0, 0, 0), (70023, 25621, 0, 0, 0, 0), (70023, 26872, 0, 0, 0, 0), (70023, 26874, 0, 0, 0, 0), (70023, 26876, 0, 0, 0, 0), (70023, 26880, 0, 0, 0, 0), (70023, 26883, 0, 0, 0, 0), (70023, 26885, 0, 0, 0, 0), (70023, 26902, 0, 0, 0, 0), (70023, 26903, 0, 0, 0, 0), (70023, 26907, 0, 0, 0, 0), (70023, 26908, 0, 0, 0, 0), (70023, 26911, 0, 0, 0, 0), (70023, 26916, 0, 0, 0, 0), (70023, 26926, 0, 0, 0, 0), (70023, 26927, 0, 0, 0, 0), (70023, 26928, 0, 0, 0, 0), (70023, 28896, 0, 0, 0, 0), (70023, 28899, 0, 0, 0, 0), (70023, 28901, 0, 0, 0, 0), (70023, 28903, 0, 0, 0, 0), (70023, 28905, 0, 0, 0, 0), (70023, 28910, 0, 0, 0, 0), (70023, 28914, 0, 0, 0, 0), (70023, 28916, 0, 0, 0, 0), (70023, 28917, 0, 0, 0, 0), (70023, 28925, 0, 0, 0, 0), (70023, 28936, 0, 0, 0, 0), (70023, 28938, 0, 0, 0, 0), (70023, 28948, 0, 0, 0, 0), (70023, 28950, 0, 0, 0, 0), (70023, 28953, 0, 0, 0, 0), (70023, 31048, 0, 0, 0, 0), (70023, 31049, 0, 0, 0, 0), (70023, 31050, 0, 0, 0, 0), (70023, 31051, 0, 0, 0, 0), (70023, 31052, 0, 0, 0, 0), (70023, 31252, 0, 0, 0, 5), (70023, 32178, 0, 0, 0, 0), (70023, 32179, 0, 0, 0, 0), (70023, 32801, 0, 0, 0, 0), (70023, 32807, 0, 0, 0, 0), (70023, 32808, 0, 0, 0, 0), (70023, 32809, 0, 0, 0, 0), (70023, 34069, 0, 0, 0, 0), (70023, 34590, 0, 0, 0, 0), (70023, 34955, 0, 0, 0, 0), (70023, 34959, 0, 0, 0, 0), (70023, 34960, 0, 0, 0, 0), (70023, 34961, 0, 0, 0, 0), (70023, 36523, 0, 0, 0, 0), (70023, 36524, 0, 0, 0, 0), (70023, 36525, 0, 0, 0, 0), (70023, 36526, 0, 0, 0, 0), (70023, 37818, 0, 0, 0, 0), (70023, 38068, 0, 0, 0, 0), (70023, 38175, 0, 0, 0, 0), (70023, 40514, 0, 0, 0, 0), (70023, 41414, 0, 0, 0, 0), (70023, 41415, 0, 0, 0, 0), (70023, 41418, 0, 0, 0, 0), (70023, 41420, 0, 0, 0, 0), (70023, 41429, 0, 0, 0, 0), (70023, 47280, 0, 0, 0, 0), (70023, 51310, 0, 0, 0, 0), (70023, 53831, 0, 0, 0, 0), (70023, 53832, 0, 0, 0, 0), (70023, 53834, 0, 0, 0, 0), (70023, 53835, 0, 0, 0, 0), (70023, 53843, 0, 0, 0, 0), (70023, 53844, 0, 0, 0, 0), (70023, 53845, 0, 0, 0, 0), (70023, 53852, 0, 0, 0, 0), (70023, 53853, 0, 0, 0, 0), (70023, 53854, 0, 0, 0, 0), (70023, 53855, 0, 0, 0, 0), (70023, 53856, 0, 0, 0, 0), (70023, 53859, 0, 0, 0, 0), (70023, 53860, 0, 0, 0, 0), (70023, 53861, 0, 0, 0, 0), (70023, 53862, 0, 0, 0, 0), (70023, 53863, 0, 0, 0, 0), (70023, 53864, 0, 0, 0, 0), (70023, 53866, 0, 0, 0, 0), (70023, 53867, 0, 0, 0, 0), (70023, 53868, 0, 0, 0, 0), (70023, 53870, 0, 0, 0, 0), (70023, 53871, 0, 0, 0, 0), (70023, 53872, 0, 0, 0, 0), (70023, 53873, 0, 0, 0, 0), (70023, 53874, 0, 0, 0, 0), (70023, 53876, 0, 0, 0, 0), (70023, 53878, 0, 0, 0, 0), (70023, 53880, 0, 0, 0, 0), (70023, 53881, 0, 0, 0, 0), (70023, 53882, 0, 0, 0, 0), (70023, 53883, 0, 0, 0, 0), (70023, 53886, 0, 0, 0, 0), (70023, 53887, 0, 0, 0, 0), (70023, 53889, 0, 0, 0, 0), (70023, 53890, 0, 0, 0, 0), (70023, 53891, 0, 0, 0, 0), (70023, 53892, 0, 0, 0, 0), (70023, 53893, 0, 0, 0, 0), (70023, 53894, 0, 0, 0, 0), (70023, 53916, 0, 0, 0, 0), (70023, 53918, 0, 0, 0, 0), (70023, 53920, 0, 0, 0, 0), (70023, 53922, 0, 0, 0, 0), (70023, 53923, 0, 0, 0, 0), (70023, 53925, 0, 0, 0, 0), (70023, 53926, 0, 0, 0, 0), (70023, 53927, 0, 0, 0, 0), (70023, 53928, 0, 0, 0, 0), (70023, 53930, 0, 0, 0, 0), (70023, 53931, 0, 0, 0, 0), (70023, 53934, 0, 0, 0, 0), (70023, 53940, 0, 0, 0, 0), (70023, 53941, 0, 0, 0, 0), (70023, 53947, 0, 0, 0, 0), (70023, 53953, 0, 0, 0, 0), (70023, 53956, 0, 0, 0, 0), (70023, 53969, 0, 0, 0, 0), (70023, 53989, 0, 0, 0, 0), (70023, 54007, 0, 0, 0, 0), (70023, 54017, 0, 0, 0, 0), (70023, 55386, 0, 0, 0, 0), (70023, 55394, 0, 0, 0, 0), (70023, 55399, 0, 0, 0, 0), (70023, 55402, 0, 0, 0, 0), (70023, 56193, 0, 0, 0, 0), (70023, 56194, 0, 0, 0, 0), (70023, 56195, 0, 0, 0, 0), (70023, 56196, 0, 0, 0, 0), (70023, 56197, 0, 0, 0, 0), (70023, 56199, 0, 0, 0, 0), (70023, 56201, 0, 0, 0, 0), (70023, 56202, 0, 0, 0, 0), (70023, 56203, 0, 0, 0, 0), (70023, 56205, 0, 0, 0, 0), (70023, 56206, 0, 0, 0, 0), (70023, 56208, 0, 0, 0, 0), (70023, 56530, 0, 0, 0, 0), (70023, 56531, 0, 0, 0, 0), (70023, 58141, 0, 0, 0, 0), (70023, 58142, 0, 0, 0, 0), (70023, 58143, 0, 0, 0, 0), (70023, 58144, 0, 0, 0, 0), (70023, 58145, 0, 0, 0, 0), (70023, 58146, 0, 0, 0, 0), (70023, 59759, 0, 0, 0, 0), (70023, 62242, 0, 0, 0, 0), (70023, 62941, 0, 0, 0, 0), (70023, 63743, 0, 0, 0, 0), (70023, 64725, 0, 0, 0, 0), (70023, 64726, 0, 0, 0, 0), (70023, 64727, 0, 0, 0, 0), (70023, 64728, 0, 0, 0, 0); Добавлено (14.01.2012, 02:17) 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 (70017, 0, 0, 0, 0, 0, 26866, 0, 26866, 0, 'Charles Worth', 'Grand Master Tailoring 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`=70017); INSERT INTO `npc_trainer` (entry, spell, spellcost, reqskill, reqskillvalue, reqlevel) VALUES (70017, 2385, 0, 0, 0, 0), (70017, 2386, 0, 0, 0, 0), (70017, 2392, 0, 0, 0, 0), (70017, 2393, 0, 0, 0, 0), (70017, 2394, 0, 0, 0, 0), (70017, 2395, 0, 0, 0, 0), (70017, 2396, 0, 0, 0, 0), (70017, 2397, 0, 0, 0, 0), (70017, 2399, 0, 0, 0, 0), (70017, 2401, 0, 0, 0, 0), (70017, 2402, 0, 0, 0, 0), (70017, 2406, 0, 0, 0, 0), (70017, 2964, 0, 0, 0, 0), (70017, 3755, 0, 0, 0, 0), (70017, 3757, 0, 0, 0, 0), (70017, 3813, 0, 0, 0, 0), (70017, 3839, 0, 0, 0, 0), (70017, 3840, 0, 0, 0, 0), (70017, 3841, 0, 0, 0, 0), (70017, 3842, 0, 0, 0, 0), (70017, 3843, 0, 0, 0, 0), (70017, 3845, 0, 0, 0, 0), (70017, 3848, 0, 0, 0, 0), (70017, 3850, 0, 0, 0, 0), (70017, 3852, 0, 0, 0, 0), (70017, 3855, 0, 0, 0, 0), (70017, 3859, 0, 0, 0, 0), (70017, 3861, 0, 0, 0, 0), (70017, 3865, 0, 0, 0, 0), (70017, 3866, 0, 0, 0, 0), (70017, 3871, 0, 0, 0, 0), (70017, 3911, 0, 0, 0, 0), (70017, 3912, 0, 0, 0, 0), (70017, 3913, 0, 0, 0, 0), (70017, 3914, 0, 0, 0, 0), (70017, 6521, 0, 0, 0, 0), (70017, 6690, 0, 0, 0, 0), (70017, 7623, 0, 0, 0, 0), (70017, 7624, 0, 0, 0, 0), (70017, 8465, 0, 0, 0, 0), (70017, 8467, 0, 0, 0, 0), (70017, 8483, 0, 0, 0, 0), (70017, 8489, 0, 0, 0, 0), (70017, 8758, 0, 0, 0, 0), (70017, 8760, 0, 0, 0, 0), (70017, 8762, 0, 0, 0, 0), (70017, 8764, 0, 0, 0, 0), (70017, 8766, 0, 0, 0, 0), (70017, 8770, 0, 0, 0, 0), (70017, 8772, 0, 0, 0, 0), (70017, 8774, 0, 0, 0, 0), (70017, 8776, 0, 0, 0, 0), (70017, 8791, 0, 0, 0, 0), (70017, 8799, 0, 0, 0, 0), (70017, 8804, 0, 0, 0, 0), (70017, 12045, 0, 0, 0, 0), (70017, 12046, 0, 0, 0, 0), (70017, 12048, 0, 0, 0, 0), (70017, 12049, 0, 0, 0, 0), (70017, 12050, 0, 0, 0, 0), (70017, 12053, 0, 0, 0, 0), (70017, 12061, 0, 0, 0, 0), (70017, 12065, 0, 0, 0, 0), (70017, 12067, 0, 0, 0, 0), (70017, 12069, 0, 0, 0, 0), (70017, 12070, 0, 0, 0, 0), (70017, 12072, 0, 0, 0, 0), (70017, 12073, 0, 0, 0, 0), (70017, 12074, 0, 0, 0, 0), (70017, 12077, 0, 0, 0, 0), (70017, 12079, 0, 0, 0, 0), (70017, 12088, 0, 0, 0, 0), (70017, 12092, 0, 0, 0, 0), (70017, 12181, 0, 0, 0, 0), (70017, 18401, 0, 0, 0, 0), (70017, 18402, 0, 0, 0, 0), (70017, 18403, 0, 0, 0, 0), (70017, 18406, 0, 0, 0, 0), (70017, 18407, 0, 0, 0, 0), (70017, 18409, 0, 0, 0, 0), (70017, 18410, 0, 0, 0, 0), (70017, 18411, 0, 0, 0, 0), (70017, 18413, 0, 0, 0, 0), (70017, 18414, 0, 0, 0, 0), (70017, 18415, 0, 0, 0, 0), (70017, 18416, 0, 0, 0, 0), (70017, 18417, 0, 0, 0, 0), (70017, 18420, 0, 0, 0, 0), (70017, 18421, 0, 0, 0, 0), (70017, 18423, 0, 0, 0, 0), (70017, 18424, 0, 0, 0, 0), (70017, 18437, 0, 0, 0, 0), (70017, 18438, 0, 0, 0, 0), (70017, 18441, 0, 0, 0, 0), (70017, 18442, 0, 0, 0, 0), (70017, 18444, 0, 0, 0, 0), (70017, 18446, 0, 0, 0, 0), (70017, 18449, 0, 0, 0, 0), (70017, 18450, 0, 0, 0, 0), (70017, 18451, 0, 0, 0, 0), (70017, 18453, 0, 0, 0, 0), (70017, 26745, 0, 0, 0, 0), (70017, 26746, 0, 0, 0, 0), (70017, 26764, 0, 0, 0, 0), (70017, 26765, 0, 0, 0, 0), (70017, 26770, 0, 0, 0, 0), (70017, 26771, 0, 0, 0, 0), (70017, 26772, 0, 0, 0, 0), (70017, 26791, 0, 0, 0, 0), (70017, 31460, 0, 0, 0, 0), (70017, 51308, 0, 0, 0, 0), (70017, 55642, 0, 0, 0, 0), (70017, 55769, 0, 0, 0, 0), (70017, 55777, 0, 0, 0, 0), (70017, 55898, 0, 0, 0, 0), (70017, 55899, 0, 0, 0, 0), (70017, 55900, 0, 0, 0, 0), (70017, 55901, 0, 0, 0, 0), (70017, 55902, 0, 0, 0, 0), (70017, 55903, 0, 0, 0, 0), (70017, 55904, 0, 0, 0, 0), (70017, 55906, 0, 0, 0, 0), (70017, 55907, 0, 0, 0, 0), (70017, 55908, 0, 0, 0, 0), (70017, 55910, 0, 0, 0, 0), (70017, 55911, 0, 0, 0, 0), (70017, 55913, 0, 0, 0, 0), (70017, 55914, 0, 0, 0, 0), (70017, 55919, 0, 0, 0, 0), (70017, 55920, 0, 0, 0, 0), (70017, 55921, 0, 0, 0, 0), (70017, 55922, 0, 0, 0, 0), (70017, 55923, 0, 0, 0, 0), (70017, 55924, 0, 0, 0, 0), (70017, 55925, 0, 0, 0, 0), (70017, 55941, 0, 0, 0, 0), (70017, 55943, 0, 0, 0, 0), (70017, 55995, 0, 0, 0, 0), (70017, 56000, 0, 0, 0, 0), (70017, 56001, 0, 0, 0, 0), (70017, 56002, 0, 0, 0, 0), (70017, 56003, 0, 0, 0, 0), (70017, 56007, 0, 0, 0, 0), (70017, 56008, 0, 0, 0, 0), (70017, 56010, 0, 0, 0, 0), (70017, 56014, 0, 0, 0, 0), (70017, 56015, 0, 0, 0, 0), (70017, 56018, 0, 0, 0, 0), (70017, 56019, 0, 0, 0, 0), (70017, 56020, 0, 0, 0, 0), (70017, 56021, 0, 0, 0, 0), (70017, 56022, 0, 0, 0, 0), (70017, 56023, 0, 0, 0, 0), (70017, 56024, 0, 0, 0, 0), (70017, 56025, 0, 0, 0, 0), (70017, 56026, 0, 0, 0, 0), (70017, 56027, 0, 0, 0, 0), (70017, 56028, 0, 0, 0, 0), (70017, 56029, 0, 0, 0, 0), (70017, 56030, 0, 0, 0, 0), (70017, 56031, 0, 0, 0, 0), (70017, 56034, 0, 0, 0, 0), (70017, 56039, 0, 0, 0, 0), (70017, 56048, 0, 0, 0, 0), (70017, 59582, 0, 0, 0, 0), (70017, 59583, 0, 0, 0, 0), (70017, 59584, 0, 0, 0, 0), (70017, 59585, 0, 0, 0, 0), (70017, 59586, 0, 0, 0, 0), (70017, 59587, 0, 0, 0, 0), (70017, 59588, 0, 0, 0, 0), (70017, 59589, 0, 0, 0, 0), (70017, 60969, 0, 0, 0, 0), (70017, 60971, 0, 0, 0, 0), (70017, 60990, 0, 0, 0, 0), (70017, 60993, 0, 0, 0, 0), (70017, 60994, 0, 0, 0, 0), (70017, 63742, 0, 0, 0, 0), (70017, 64729, 0, 0, 0, 0), (70017, 64730, 0, 0, 0, 0); Добавлено (14.01.2012, 02:17) 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 (70016, 0, 0, 0, 0, 0, 23590, 0, 23590, 0, 'Derik Marks', 'Grand Master Skinning 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, 339, 0, 0, '', 12340); DELETE FROM `npc_trainer` WHERE (`entry`=70016); INSERT INTO `npc_trainer` (entry, spell, spellcost, reqskill, reqskillvalue, reqlevel) VALUES (70016, 8615, 0, 0, 0, 0), (70016, 8619, 0, 0, 0, 0), (70016, 8620, 0, 0, 0, 0), (70016, 10769, 0, 0, 0, 0), (70016, 32679, 0, 0, 0, 0), (70016, 50307, 0, 0, 0, 0); Добавлено (14.01.2012, 02:19) 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 (200003, 0, 0, 0, 0, 0, 22931, 0, 22931, 0, 'Shmot', 'nolevel', '', 0, 83, 83, 0, 35, 35, 4224, 2, 2, 1, 2, 50, 150, 0, 1000, 100, 2000, 1500, 1, 2, 0, 0, 0, 0, 0, 0, 100, 200, 1000, 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, 1973, 0, 0, '', 12340); DELETE FROM `npc_vendor` WHERE (`entry`=200003); INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (200003, 0, 46111, 0, 0, 0), (200003, 0, 46113, 0, 0, 0), (200003, 0, 46115, 0, 0, 0), (200003, 0, 46116, 0, 0, 0), (200003, 0, 46117, 0, 0, 0), (200003, 0, 46118, 0, 0, 0), (200003, 0, 46119, 0, 0, 0), (200003, 0, 46120, 0, 0, 0), (200003, 0, 46121, 0, 0, 0), (200003, 0, 46122, 0, 0, 0), (200003, 0, 46123, 0, 0, 0), (200003, 0, 46124, 0, 0, 0), (200003, 0, 46125, 0, 0, 0), (200003, 0, 46126, 0, 0, 0), (200003, 0, 46127, 0, 0, 0), (200003, 0, 46129, 0, 0, 0), (200003, 0, 46130, 0, 0, 0), (200003, 0, 46132, 0, 0, 0), (200003, 0, 46133, 0, 0, 0), (200003, 0, 46134, 0, 0, 0), (200003, 0, 46135, 0, 0, 0), (200003, 0, 46136, 0, 0, 0), (200003, 0, 46137, 0, 0, 0), (200003, 0, 46139, 0, 0, 0), (200003, 0, 46140, 0, 0, 0), (200003, 0, 46141, 0, 0, 0), (200003, 0, 46142, 0, 0, 0), (200003, 0, 46143, 0, 0, 0), (200003, 0, 46144, 0, 0, 0), (200003, 0, 46145, 0, 0, 0), (200003, 0, 46146, 0, 0, 0), (200003, 0, 46148, 0, 0, 0), (200003, 0, 46149, 0, 0, 0), (200003, 0, 46150, 0, 0, 0), (200003, 0, 46151, 0, 0, 0), (200003, 0, 46152, 0, 0, 0), (200003, 0, 46153, 0, 0, 0), (200003, 0, 46154, 0, 0, 0), (200003, 0, 46155, 0, 0, 0), (200003, 0, 46156, 0, 0, 0), (200003, 0, 46157, 0, 0, 0), (200003, 0, 46158, 0, 0, 0), (200003, 0, 46159, 0, 0, 0), (200003, 0, 46160, 0, 0, 0), (200003, 0, 46161, 0, 0, 0), (200003, 0, 46162, 0, 0, 0), (200003, 0, 46163, 0, 0, 0), (200003, 0, 46164, 0, 0, 0), (200003, 0, 46165, 0, 0, 0), (200003, 0, 46166, 0, 0, 0), (200003, 0, 46167, 0, 0, 0), (200003, 0, 46168, 0, 0, 0), (200003, 0, 46169, 0, 0, 0), (200003, 0, 46170, 0, 0, 0), (200003, 0, 46172, 0, 0, 0), (200003, 0, 46173, 0, 0, 0), (200003, 0, 46174, 0, 0, 0), (200003, 0, 46175, 0, 0, 0), (200003, 0, 46176, 0, 0, 0), (200003, 0, 46177, 0, 0, 0), (200003, 0, 46178, 0, 0, 0), (200003, 0, 46179, 0, 0, 0), (200003, 0, 46180, 0, 0, 0), (200003, 0, 46181, 0, 0, 0), (200003, 0, 46182, 0, 0, 0), (200003, 0, 46183, 0, 0, 0), (200003, 0, 46184, 0, 0, 0), (200003, 0, 46185, 0, 0, 0), (200003, 0, 46186, 0, 0, 0), (200003, 0, 46187, 0, 0, 0), (200003, 0, 46188, 0, 0, 0), (200003, 0, 46189, 0, 0, 0), (200003, 0, 46190, 0, 0, 0), (200003, 0, 46191, 0, 0, 0), (200003, 0, 46192, 0, 0, 0), (200003, 0, 46193, 0, 0, 0), (200003, 0, 46194, 0, 0, 0), (200003, 0, 46195, 0, 0, 0), (200003, 0, 46196, 0, 0, 0), (200003, 0, 46197, 0, 0, 0), (200003, 0, 46198, 0, 0, 0), (200003, 0, 46199, 0, 0, 0), (200003, 0, 46200, 0, 0, 0), (200003, 0, 46201, 0, 0, 0), (200003, 0, 46202, 0, 0, 0), (200003, 0, 46203, 0, 0, 0), (200003, 0, 46204, 0, 0, 0), (200003, 0, 46205, 0, 0, 0), (200003, 0, 46206, 0, 0, 0), (200003, 0, 46207, 0, 0, 0), (200003, 0, 46208, 0, 0, 0), (200003, 0, 46209, 0, 0, 0), (200003, 0, 46210, 0, 0, 0), (200003, 0, 46211, 0, 0, 0), (200003, 0, 46212, 0, 0, 0); Добавлено (14.01.2012, 02:20) Добавлено (14.01.2012, 02:22) DELETE FROM `item_loot_template` WHERE (`entry`=41426); INSERT INTO `item_loot_template` VALUES (41426, 33447, 100, 1, 0, 5, 5), (41426, 33448, 100, 1, 0, 5, 5), (41426, 40211, 100, 1, 0, 5, 5), (41426, 41427, 100, 1, 0, 5, 5), (41426, 47241, 100, 1, 0, 100, 100), (41426, 49426, 100, 1, 0, 60, 60), (41426, 23162, 100, 1, 0, 1, 1);
Сообщение # 3 написано 14.01.2012 в 02:22
|
| |||
| |||