.:Hilfe:. Lehrer NPC

[wow-player]

Moin Moin

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

 Spoiler

-- 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);

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

[°"Crazy"°]

schon cache gelöscht und server restartet?

[wow-player]

jup das mit dem cache löschen habe ich mir jetzt langsam auch ahngewöhnt weil das schon öfters das problem war ^^

ist sonst niemand da der eine idee hat ?

[°"Crazy"°]

/*
Created by Crazy - e*pvp
Support des Scripts unter: http://www.elitepvpers.com/forum/members/2653940--crazy-.html
*/

SET @entry = '';
SET @name = '';
SET @subname = '';
SET @displayID = '';


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`, `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`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES 
(@entry, 0, 0, 0, 0, 0, @displayID, 0, 0, 0, @name, @subname, '', @entry, 80, 80, 0, 35, 35, 16, 1, 0, 1000, 2000, 0, 1000, 20, 2000, 2000, 2, 0, 8, 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, '', 0, 3, 10, 10, 0, 0, 0, 0, 0, 0, 0, 0, 1, 637, 0, 2, '');

DELETE FROM `npc_trainer` WHERE (`entry`=@entry);
INSERT INTO `npc_trainer` (entry, spell, spellcost, reqskill, reqskillvalue, reqlevel) VALUES 
(@entry, 71, 10000, 0, 0, 0),
(@entry, 355, 10000, 0, 0, 0),
(@entry, 688, 10000, 0, 0, 0),
(@entry, 691, 10000, 0, 0, 0),
(@entry, 697, 10000, 0, 0, 0),
(@entry, 712, 10000, 0, 0, 0),
(@entry, 883, 10000, 0, 0, 0),
(@entry, 982, 10000, 0, 0, 0),
(@entry, 1515, 10000, 0, 0, 0),
(@entry, 2458, 10000, 0, 0, 0),
(@entry, 2641, 10000, 0, 0, 0),
(@entry, 5394, 10000, 0, 0, 0),
(@entry, 5487, 10000, 0, 0, 0),
(@entry, 6795, 10000, 0, 0, 0),
(@entry, 6807, 10000, 0, 0, 0),
(@entry, 6991, 10000, 0, 0, 0),
(@entry, 7328, 10000, 0, 0, 0),
(@entry, 8071, 10000, 0, 0, 0);


DELETE FROM `gossip_menu` WHERE (`entry`=@entry);
INSERT INTO `gossip_menu` VALUES (@entry, 6289);


DELETE FROM `gossip_menu_option` WHERE (`menu_id`=@entry);
INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `box_coded`, `box_money`, `box_text`) VALUES
(@entry, 0, 3, 'Neue Waffen lernen', 5, 16, 0, 0, 0, 0, NULL);

/*
Created by Crazy - e*pvp
Support des Scripts unter: http://www.elitepvpers.com/forum/members/2653940--crazy-.html
*/

Das sollte funktionieren.