Wise
03-03-13, 01:53 PM
GM spell trainer
This is a redo of an old vendor I made long time ago
This trainer actually teaches you the spells at a cost. But cost can be edited to fit what you want.
1. Copy the below sqls
2. Change the entry3009to fit into your database.
3009 is the npc entry #
3. Change the number 9000000 to the amount of gold you want it to cost.
Notice for noobs:
gold is like this...
1= 1 copper
10=10 coppper
100= 1 silver
1000 = 10 silver
10000 = 1gold
and so on...
NSERT INTO `creature_names` VALUES ('3009', 'Bena Winterhoof', 'GM Trainer', '', '0', '7', '0', '0',
'0', '0', '2108', '0', '0', '0', '1.1', '1', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `creature_proto` VALUES ('3009', '255', '35', '35', '1342', '1342', '0', '1', '51', '1660',
'0', '48', '69', '0', '0', '0', '0', '360000', '1387', '0', '0', '0', '0', '0', '0', '3.75', '0.8725',
'0', '0', '0', '0', '2.5', '8', '14', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '32377', '9000000', '0', '0', '0', '5', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '30450', '9000000', '0', '0', '0', '10', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '27371', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '27369', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '27368', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '11', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '23187', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '23965', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '29618', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '30522', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '32139', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '35132', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '36720', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '36829', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '36935', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '37091', '9000000', '0', '0', '0', '20', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '37667', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '37674', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '38509', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '38285', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '38897', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '38930', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '38976', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '40080', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '40631', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '40736', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '41245', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '41346', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '41966', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '30360', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '25206', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '30362', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '34923', '9000000', '0', '0', '0', '35', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '25370', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '25224', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '25220', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '25390', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '25382', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '28277', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '25313', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '27379', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '33942', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '33935', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '32435', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '32443', '9000000', '0', '0', '0', '0', '0', '0');
Or download from here.
Filebeam (http://filebeam.com/9943b3b40dd75d6dbc4c7115ab6da400)
password- arcemu
maker : chaotic3d
12866
This is a redo of an old vendor I made long time ago
This trainer actually teaches you the spells at a cost. But cost can be edited to fit what you want.
1. Copy the below sqls
2. Change the entry3009to fit into your database.
3009 is the npc entry #
3. Change the number 9000000 to the amount of gold you want it to cost.
Notice for noobs:
gold is like this...
1= 1 copper
10=10 coppper
100= 1 silver
1000 = 10 silver
10000 = 1gold
and so on...
NSERT INTO `creature_names` VALUES ('3009', 'Bena Winterhoof', 'GM Trainer', '', '0', '7', '0', '0',
'0', '0', '2108', '0', '0', '0', '1.1', '1', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `creature_proto` VALUES ('3009', '255', '35', '35', '1342', '1342', '0', '1', '51', '1660',
'0', '48', '69', '0', '0', '0', '0', '360000', '1387', '0', '0', '0', '0', '0', '0', '3.75', '0.8725',
'0', '0', '0', '0', '2.5', '8', '14', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '32377', '9000000', '0', '0', '0', '5', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '30450', '9000000', '0', '0', '0', '10', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '27371', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '27369', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '27368', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '11', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '23187', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '23965', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '29618', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '30522', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '32139', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '35132', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '36720', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '36829', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '36935', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '37091', '9000000', '0', '0', '0', '20', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '37667', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '37674', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '38509', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '38285', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '38897', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '38930', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '38976', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '40080', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '40631', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '40736', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '41245', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '41346', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '41966', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '30360', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '25206', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '30362', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '34923', '9000000', '0', '0', '0', '35', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '25370', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '25224', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '25220', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '25390', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '25382', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '28277', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '25313', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '27379', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '33942', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '33935', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '32435', '9000000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('3009', '0', '32443', '9000000', '0', '0', '0', '0', '0', '0');
Or download from here.
Filebeam (http://filebeam.com/9943b3b40dd75d6dbc4c7115ab6da400)
password- arcemu
maker : chaotic3d
12866