0
I'm using Navicat Lite and http://www.trinityco...re_template_tc2 as a guide to use the correct flags.
I'm having an issue getting a spell trainer to work. I'm wanting this trainer to teach players three Companions; Jade Tiger, Onyx Panther, & Zipao Tiger.
creature_template code:
INSERT 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
('420009','0','0','0','0','0','26938','0','0','0',"Emard","Pet Trainer","",'0','80','80','2','35','35','16','1','1.14286','1','3','0','0','0','0','1','0','0','1','0','0','0','2','0','0','0','0','0','0','7','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',"NullAI",'0','3','1','1','1','0','0','0','0','0','0','0','0','1','0','0','0',"",'12340');
npc_trainer code:
INSERT INTO `npc_trainer`(`entry`,`spell`,`spellcost`,`reqskill`,`reqskillvalue`,`reqlevel`) VALUES
('420009','66520','0','0','0','0'), -- Jade Tiger
('420009','67527','0','0','0','0'), -- Onyx Panther
('420009','69539','0','0','0','0'); -- Zipao TigerThe "-- Jade Tiger, -- Onyx Panther, -- Zipao Tiger" lines are not actually in the sql file, I added them to show which was which.The NPC is spawned fine. Level 80 and friendly to A/H. But NO Trainer Icon shows when I hover over him.
ALSO, the worldserver shows:
Creature 252328 (Entry: 420009) have UNIT_NPC_FLAG_TRAINER but have empty trainer spell list.
PLEASE for the love of my sanity, if you fix something I made a mistake on, show me exactly what you changed. lol
What am I doing wrong? More importantly, how the hell do I fix it? lol
Thanks in advance!
Edited by Taligaro, 31 May 2012 - 12:34 AM.
