NPC ID for horse riding and undead riding

[gforcegts]

whats the id for the Humans Horse riding trainer and the undead horse riding trainers cuase i can buy the horse for the humans but i cant learn the horse riding skill..it just says uknown wen i talk to the other guy near the stable. Cuase i think mine is messed up in the game...

[MentaL]

[scrat55]

first try to update your npc_trainer.sql files with the newest ones and get the newest CORE it might help.

If not here is a fix for the newest 1.12.2 riding system:

#--- Fix for trainers and mounts to bring up to date with 1.12.2 mount system (tested on SDB 0.5.2)

#--- spells on Ultham Ironhorn (Ram Trainer)
DELETE FROM npc_trainer WHERE entry=4772;
INSERT INTO npc_trainer VALUES
(4772, 33389, 900000, 0, 0, 0, 40),
(4772, 33392, 8000000, 33388, 762, 0, 60);

#--- spell costs (SDB 0.5.2 has prices with 20% rep and honor discount)
UPDATE npc_trainer SET spellcost=900000 WHERE spell=33389;
UPDATE npc_trainer SET spellcost=9000000 WHERE spell=33392;

#--- All (In official the mounts don't actually *require* the riding spell, just the riding SKILL)
UPDATE item_template SET requiredspell=0, bonding=1 WHERE spellcategory_1=330;

#--- PvP mounts
UPDATE item_template SET quality=4, buyprice=100000, requiredskill=762, requiredskillrank=75 WHERE spellcategory_1=330 AND requiredhonorrank=11;

#--- Level 40 Mounts
UPDATE item_template SET quality=3, buyprice=100000, sellprice=25000, requiredskill=762, requiredskillrank=75 WHERE spellcategory_1=330 AND requiredlevel=40 AND requiredhonorrank=0;

#--- Level 60 Mounts
UPDATE item_template SET quality=4, buyprice=1000000, requiredskill=762, requiredskillrank=150 WHERE spellcategory_1=330 AND requiredlevel=60 AND NOT allowablerace=-1;

#--- Quest/Drop Mounts
UPDATE item_template SET buyprice=0 WHERE spellcategory_1=330 AND allowablerace=-1;

#--- Stormpike Battle Charger
UPDATE item_template SET buyprice=100000, requiredskill=762, requiredskillrank=150 WHERE entry=19030;

~ Regards to SDB community

[gforcegts]

first try to update your npc_trainer.sql files with the newest ones and get the newest CORE it might help.

If not here is a fix for the newest 1.12.2 riding system:

#--- Fix for trainers and mounts to bring up to date with 1.12.2 mount system (tested on SDB 0.5.2)
 
#--- spells on Ultham Ironhorn (Ram Trainer)
DELETE FROM npc_trainer WHERE entry=4772;
INSERT INTO npc_trainer VALUES
(4772, 33389, 900000, 0, 0, 0, 40),
(4772, 33392, 8000000, 33388, 762, 0, 60);
 
#--- spell costs (SDB 0.5.2 has prices with 20% rep and honor discount)
UPDATE npc_trainer SET spellcost=900000 WHERE spell=33389;
UPDATE npc_trainer SET spellcost=9000000 WHERE spell=33392;
 
#--- All (In official the mounts don't actually *require* the riding spell, just the riding SKILL)
UPDATE item_template SET requiredspell=0, bonding=1 WHERE spellcategory_1=330;
 
#--- PvP mounts
UPDATE item_template SET quality=4, buyprice=100000, requiredskill=762, requiredskillrank=75 WHERE spellcategory_1=330 AND requiredhonorrank=11;
 
#--- Level 40 Mounts
UPDATE item_template SET quality=3, buyprice=100000, sellprice=25000, requiredskill=762, requiredskillrank=75 WHERE spellcategory_1=330 AND requiredlevel=40 AND requiredhonorrank=0;
 
#--- Level 60 Mounts
UPDATE item_template SET quality=4, buyprice=1000000, requiredskill=762, requiredskillrank=150 WHERE spellcategory_1=330 AND requiredlevel=60 AND NOT allowablerace=-1;
 
#--- Quest/Drop Mounts
UPDATE item_template SET buyprice=0 WHERE spellcategory_1=330 AND allowablerace=-1;
 
#--- Stormpike Battle Charger
UPDATE item_template SET buyprice=100000, requiredskill=762, requiredskillrank=150 WHERE entry=19030;

~ Regards to SDB community

Hmm i tried but when i talk to the horse guy it says Unknown.. i cant learn the riding skill?or is ther eanother guy i can talk to

[scrat55]

go to your game folder and delete the contenent of the WDB and WTF folders. it might fix it...

[gforcegts]

go to your game folder and delete the contenent of the WDB and WTF folders. it might fix it...

Hmm mabe im at the wrong place im at menethil harbor theres a horse breeder and stuff were is the horse instructer tho

[kiasta]

Goto Gadgetzan there is a trainer there i believe or was it Ironforge...havent played blizz in quite a while lol