PDA

View Full Version : GM trainer for AreEMU 3.3.5a!



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