Ich habe mir gestern einen NPC geholt der den Playern fehlende Spells beibringen soll. Das Problem ist das die Spells beim NPC nicht angezeig werden. Ich benutze eine Trinity Core auf dem Patch 3.3.5a.
Hier ist der SQL inhalt
-- Clean before inserting new NPC,spells & skills.
DELETE FROM `creature` WHERE `id`=500146;
DELETE FROM `creature_template` WHERE `entry`=500146;
-- Create Trainer NPC
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`,`ty pe`,`type_flags`,`lootid`,`pickpocketloot`,`skinlo ot`,`resistance1`,`resistance2`,`resistance3`,`res istance4`,`resistance5`,`resistance6`,`spell1`,`sp ell2`,`spell3`,`spell4`,`spell5`,`spell6`,`spell7` ,`spell8`,`PetSpellDataId`,`VehicleId`,`mingold`,` maxgold`,`AIName`,`MovementType`,`InhabitType`,`He alth_mod`,`Mana_mod`,`Armor_mod`,`RacialLeader`,`q uestItem1`,`questItem2`,`questItem3`,`questItem4`, `questItem5`,`questItem6`,`movementId`,`RegenHealt h`,`equipment_id`,`mechanic_immune_mask`,`flags_ex tra`,`ScriptName`,`WDBVerified`) VALUES
(500146, -- entry
0, -- difficulty_entry_1
0, -- difficulty_entry_2
0, -- difficulty_entry_3
0, -- KillCredit1
0, -- KillCredit2
18239, -- modelid1
0, -- modelid2
0, -- modelid3
0, -- modelid4
'Fehlende Spells', -- name
'Blue-Shadow', -- subname
'', -- IconeName
0, -- gossip_menu_id
80, -- minlevel
80, -- maxlevel
0, -- exp
35, -- faction_A
35, -- faction_h
51, -- npcflag
1, -- speed_walk
1, -- speed_run
1, -- scale
0, -- rank
1755, -- mindmg
1755, -- maxdmg
0, -- dmgschool
1504, -- attackpower
1, -- dmg_multiplier
1500, -- baseattacktime
0, -- rangeattacktime
2, -- unit_class
0, -- unit_flags
0, -- dynamicflags
0, -- family
2, -- trainer_type
0, -- trainer_spell
0, -- trainer_class
0, -- trainer_race
0, -- minrangedmg
0, -- maxrangedmg
0, -- rangedattackpower
7, -- type
0, -- type_flags
0, -- lootid
0, -- pickpocketloot
0, -- skinloot
0, -- resistance1
0, -- resistance2
0, -- resistance3
0, -- resistance4
0, -- resistance5
0, -- resistance6
0, -- spell1
0, -- spell2
0, -- spell3
0, -- spell4
0, -- spell5
0, -- spell6
0, -- spell7
0, -- spell8
0, -- PetSpellDataId
0, -- VehicleId
0, -- mingold
0, -- maxgold
'', -- AIName
0, -- MovementType
3, -- InhabitType
1, -- Health_mod
1, -- Mana_mod
1, -- Armor_mod
0, -- RacialLeader
0, -- questItem1
0, -- questItem2
0, -- questItem3
0, -- questItem4
0, -- questItem5
0, -- questItem6
0, -- movementId
1, -- RegenHealth
0, -- equipment_id
0, -- mechanic_immune_mask
0, -- flags_extra
'', -- ScriptName
1); -- WDBVerified
-- Create Spells
DELETE FROM `npc_trainer` WHERE (`entry`=500146);
INSERT INTO `npc_trainer` (entry, spell, spellcost, reqskill, reqskillvalue, reqlevel) VALUES
(500146, 71, 10000, 0, 0, 0),
(500146, 355, 10000, 0, 0, 0),
(500146, 688, 10000, 0, 0, 0),
(500146, 691, 10000, 0, 0, 0),
(500146, 697, 10000, 0, 0, 0),
(500146, 712, 10000, 0, 0, 0),
(500146, 883, 10000, 0, 0, 0),
(500146, 982, 10000, 0, 0, 0),
(500146, 1515, 10000, 0, 0, 0),
(500146, 2458, 10000, 0, 0, 0),
(500146, 2641, 10000, 0, 0, 0),
(500146, 5394, 10000, 0, 0, 0),
(500146, 5487, 10000, 0, 0, 0),
(500146, 6795, 10000, 0, 0, 0),
(500146, 6807, 10000, 0, 0, 0),
(500146, 6991, 10000, 0, 0, 0),
(500146, 7328, 10000, 0, 0, 0),
(500146, 8071, 10000, 0, 0, 0);
DELETE FROM `creature` WHERE `id`=500146;
DELETE FROM `creature_template` WHERE `entry`=500146;
-- Create Trainer NPC
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`,`ty pe`,`type_flags`,`lootid`,`pickpocketloot`,`skinlo ot`,`resistance1`,`resistance2`,`resistance3`,`res istance4`,`resistance5`,`resistance6`,`spell1`,`sp ell2`,`spell3`,`spell4`,`spell5`,`spell6`,`spell7` ,`spell8`,`PetSpellDataId`,`VehicleId`,`mingold`,` maxgold`,`AIName`,`MovementType`,`InhabitType`,`He alth_mod`,`Mana_mod`,`Armor_mod`,`RacialLeader`,`q uestItem1`,`questItem2`,`questItem3`,`questItem4`, `questItem5`,`questItem6`,`movementId`,`RegenHealt h`,`equipment_id`,`mechanic_immune_mask`,`flags_ex tra`,`ScriptName`,`WDBVerified`) VALUES
(500146, -- entry
0, -- difficulty_entry_1
0, -- difficulty_entry_2
0, -- difficulty_entry_3
0, -- KillCredit1
0, -- KillCredit2
18239, -- modelid1
0, -- modelid2
0, -- modelid3
0, -- modelid4
'Fehlende Spells', -- name
'Blue-Shadow', -- subname
'', -- IconeName
0, -- gossip_menu_id
80, -- minlevel
80, -- maxlevel
0, -- exp
35, -- faction_A
35, -- faction_h
51, -- npcflag
1, -- speed_walk
1, -- speed_run
1, -- scale
0, -- rank
1755, -- mindmg
1755, -- maxdmg
0, -- dmgschool
1504, -- attackpower
1, -- dmg_multiplier
1500, -- baseattacktime
0, -- rangeattacktime
2, -- unit_class
0, -- unit_flags
0, -- dynamicflags
0, -- family
2, -- trainer_type
0, -- trainer_spell
0, -- trainer_class
0, -- trainer_race
0, -- minrangedmg
0, -- maxrangedmg
0, -- rangedattackpower
7, -- type
0, -- type_flags
0, -- lootid
0, -- pickpocketloot
0, -- skinloot
0, -- resistance1
0, -- resistance2
0, -- resistance3
0, -- resistance4
0, -- resistance5
0, -- resistance6
0, -- spell1
0, -- spell2
0, -- spell3
0, -- spell4
0, -- spell5
0, -- spell6
0, -- spell7
0, -- spell8
0, -- PetSpellDataId
0, -- VehicleId
0, -- mingold
0, -- maxgold
'', -- AIName
0, -- MovementType
3, -- InhabitType
1, -- Health_mod
1, -- Mana_mod
1, -- Armor_mod
0, -- RacialLeader
0, -- questItem1
0, -- questItem2
0, -- questItem3
0, -- questItem4
0, -- questItem5
0, -- questItem6
0, -- movementId
1, -- RegenHealth
0, -- equipment_id
0, -- mechanic_immune_mask
0, -- flags_extra
'', -- ScriptName
1); -- WDBVerified
-- Create Spells
DELETE FROM `npc_trainer` WHERE (`entry`=500146);
INSERT INTO `npc_trainer` (entry, spell, spellcost, reqskill, reqskillvalue, reqlevel) VALUES
(500146, 71, 10000, 0, 0, 0),
(500146, 355, 10000, 0, 0, 0),
(500146, 688, 10000, 0, 0, 0),
(500146, 691, 10000, 0, 0, 0),
(500146, 697, 10000, 0, 0, 0),
(500146, 712, 10000, 0, 0, 0),
(500146, 883, 10000, 0, 0, 0),
(500146, 982, 10000, 0, 0, 0),
(500146, 1515, 10000, 0, 0, 0),
(500146, 2458, 10000, 0, 0, 0),
(500146, 2641, 10000, 0, 0, 0),
(500146, 5394, 10000, 0, 0, 0),
(500146, 5487, 10000, 0, 0, 0),
(500146, 6795, 10000, 0, 0, 0),
(500146, 6807, 10000, 0, 0, 0),
(500146, 6991, 10000, 0, 0, 0),
(500146, 7328, 10000, 0, 0, 0),
(500146, 8071, 10000, 0, 0, 0);
Ich hoffe das mir jemand helfen kann . ich habe das gefühl das ist einfach nur n kleiner fehler, und ich bin zu dumm ihn zu finden ^^
Liebe grüße
Mitch