elite*gold: 0
Join Date: Nov 2009
Posts: 146
Received Thanks: 18
|
ok "200designer" versuch nun mal das zu batchen ob dein core das annimmt. Wenn nicht, dann versuch mal raus zu bekommen was du fürn core hast.
DELETE FROM `creature_template` WHERE (`entry`=800107);
REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `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`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (800107, 0, 0, 0, 0, 0, 24806, 0, 24806, 0, 'Alchemielehrer', 'Beruflehrer', '', 0, 80, 80, 3748, 3748, 3748, 3748, 3748, 35, 35, 3283, 1.05, 0.8, 2, 146, 192, 0, 238, 1, 200, 0, 2, 4096, 0, 0, 2, 0, 0, 0, 167, 24, 238, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 2, '');
INSERT INTO `npc_trainer` (entry, spell, spellcost, reqskill, reqskillvalue, reqlevel) VALUES
(800107, 2275, 10, 0, 0, 5),
(800107, 2280, 500, 171, 50, 10),
(800107, 2331, 100, 171, 25, 0),
(800107, 2332, 150, 171, 40, 0),
(800107, 2334, 250, 171, 50, 0),
(800107, 2337, 1000, 171, 55, 0),
(800107, 3170, 50, 171, 15, 0),
(800107, 3171, 500, 171, 90, 0),
(800107, 3173, 1500, 171, 120, 0),
(800107, 3176, 1500, 171, 125, 0),
(800107, 3177, 2000, 171, 130, 0),
(800107, 3447, 4000, 171, 110, 0),
(800107, 3448, 5000, 171, 165, 0),
(800107, 3450, 6000, 171, 175, 0),
(800107, 3452, 5000, 171, 160, 0),
(800107, 3465, 5000, 171, 125, 20),
(800107, 7179, 450, 171, 90, 0),
(800107, 7181, 5000, 171, 155, 0),
(800107, 7836, 250, 171, 80, 0),
(800107, 7837, 1000, 171, 130, 0),
(800107, 7841, 1000, 171, 100, 0),
(800107, 7845, 3000, 171, 140, 0),
(800107, 11448, 9000, 171, 205, 0),
(800107, 11449, 6500, 171, 185, 0),
(800107, 11450, 7500, 171, 195, 0),
(800107, 11451, 8000, 171, 205, 0),
(800107, 11457, 10000, 171, 215, 0),
(800107, 11460, 5000, 171, 230, 0),
(800107, 11461, 10000, 171, 235, 0),
(800107, 11465, 12000, 171, 235, 0),
(800107, 11467, 12000, 171, 240, 0),
(800107, 11478, 14000, 171, 250, 0),
(800107, 11612, 50000, 171, 200, 35),
(800107, 12609, 8000, 171, 200, 0),
(800107, 15833, 10000, 171, 230, 0),
(800107, 17551, 15000, 171, 250, 0),
(800107, 17552, 15000, 171, 255, 0),
(800107, 17553, 15000, 171, 260, 0),
(800107, 17555, 15000, 171, 270, 0),
(800107, 17556, 20000, 171, 275, 0),
(800107, 17557, 20000, 171, 275, 0),
(800107, 17572, 20000, 171, 285, 0),
(800107, 17573, 20000, 171, 285, 0),
(800107, 22808, 10000, 171, 215, 0),
(800107, 28544, 25000, 171, 305, 0),
(800107, 28545, 25000, 171, 310, 0),
(800107, 28551, 50000, 171, 325, 0),
(800107, 28597, 100000, 171, 275, 50),
(800107, 33732, 20000, 171, 300, 0),
(800107, 33733, 25000, 171, 310, 0),
(800107, 33738, 20000, 171, 300, 0),
(800107, 33740, 20000, 171, 300, 0),
(800107, 33741, 30000, 171, 315, 0),
(800107, 38070, 20000, 171, 325, 0),
(800107, 39636, 25000, 171, 310, 0),
(800107, 39638, 30000, 171, 320, 0),
(800107, 45061, 30000, 171, 325, 0),
(800107, 51303, 350000, 171, 350, 65),
(800107, 53042, 10000, 171, 50, 0);
|