[Help]Custom Trainer Ascent 

R

Razial7

Newbie Spellweaver
10 Happy Years
Joined
Oct 27, 2008
Messages
59
Reaction score
0
I've been trying to get this working for 2 days now, and I have no idea what is wrong. I've searched this site and the net for any help, and found a couple of things but im still at an end. Can anyone help me with this? Here is the sql file I wrote, oh i read that u need to get the trainer version of the spell for it to work; they can be found at wowhead in the uncatagorized spell section. So back on point, it spawns the npc as a trainer but no spell show up to be trained.

Just in case its relevent the class trainer is for a priest but the spells are from various classes



REPLACE INTO `creature_names` VALUES ('500000', 'Lady Burnshield', 'Battle Mage Trainer', '', '16', '4', '0', '3', '0', null, '11657', '0', '0', '0', '1', '1', '0', '0');

REPLACE INTO `creature_proto` VALUES ('500000', '100', '100', '1604', '1000000', '1000000', '1000000', '1', '16', '1000', '0', '1000', '1000', '0', '0', '0', '0', '5', '500', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3', '8', '0', '0', '2.5', '8', '14', '0', '0', '0', '0', '0', '0', '0');

REPLACE INTO `trainer_defs` VALUES ('500000', '0', '0', '5', '0', '0', '0', '0', 'Come $N, Your training is overdue!', '0', '0');

REPLACE INTO `trainer_spells` VALUES ('500000', '0', '686','0','0','0','0','1','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','695','9','686','0','0','6','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','705','540','695','0','0','12','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','1088','2000','705','0','0','20','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','1106','6300','1088','0','0','28','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','7641','11000','1106','0','0','36','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','11659','20000','7641','0','0','44','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','11660','25000','11659','0','0','52','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','11661','400000','11660','0','0','60','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','25307','500000','11661','0','0','62','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','27209','600000','25307','0','0','69','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','47808','900000','27209','0','0','74','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','47809','1200000','47808','0','0','79','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','8017','0','0','0','0','1','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','8018','200','8017','0','0','8','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','8019','1350','8018','0','0','16','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','10399','3600','8019','0','0','24','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','327','1620','0','0','0','18','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','1472','0','0','0','0','1','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','1473','810','1459','0','0','14','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','1474','5000','1460','0','0','28','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','1475','7000','1461','0','0','42','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','10158','60200','10156','0','0','56','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','27393','88000','10157','0','0','70','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','42999','100000','27126','0','0','80','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','1953','1800','0','0','0','20','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','5384','7200','0','0','0','24','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','2974','540','0','0','0','12','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','46584','360','0','0','0','10','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','51722','1800','0','0','0','20','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','1706','6500','0','0','0','34','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','122','360','0','0','0','10','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','865','6000','122','0','0','26','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','6131','6800','865','0','0','40','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','10230','59500','6131','0','0','54','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','27088','75000','10230','0','0','67','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000', '0', '686','0','0','0','0','1','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','695','9','686','0','0','6','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','705','540','695','0','0','12','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','1088','2000','705','0','0','20','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','1106','6300','1088','0','0','28','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','7641','11000','1106','0','0','36','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','11659','20000','7641','0','0','44','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','11660','25000','11659','0','0','52','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','11661','400000','11660','0','0','60','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','25307','500000','11661','0','0','62','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','27209','600000','25307','0','0','69','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','47808','900000','27209','0','0','74','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','47809','1200000','47808','0','0','79','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','8017','0','0','0','0','1','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','8018','200','8017','0','0','8','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','8019','1350','8018','0','0','16','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','10399','3600','8019','0','0','24','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','327','1620','0','0','0','18','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','1472','0','0','0','0','1','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','1473','810','1459','0','0','14','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','1474','5000','1460','0','0','28','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','1475','7000','1461','0','0','42','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','10158','60200','10156','0','0','56','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','27393','88000','10157','0','0','70','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','42999','100000','27126','0','0','80','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','1953','1800','0','0','0','20','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','5384','7200','0','0','0','24','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','2974','540','0','0','0','12','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','46584','360','0','0','0','10','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','51722','1800','0','0','0','20','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','1706','6500','0','0','0','34','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','122','360','0','0','0','10','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','865','6000','122','0','0','26','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','6131','6800','865','0','0','40','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','10230','59500','6131','0','0','54','0','0');
REPLACE INTO `trainer_spells` VALUES ('500000','0','27088','75000','10230','0','0','67','0','0');
 
You must log in or register to reply here.

RaGEZONE Sponsor

    HyperFilter

About RaGEZONE

RaGEZONE® is the top forum for MMO, MMORPG, and mobile game development. We provide binaries, source codes, and tutorials for your favorite games, making it the go-to resource for developers and fans. You can also find and share private servers, fostering a vibrant gamer community.

Forum Statistics

Members online
879
Guests online
2,284
Total visitors
3,163
Totals may include hidden visitors.

RaGEZONE Partners

    nongamstopbets.com UK sites not on GamStop Casino Deps NZ
Back