Facebook - Mists of Pandaria
Facebook - Draenor

AbonnentenAbonnenten: 0
LesezeichenLesezeichen: 0
Zugriffe: 466

World of Draenor 6.2.X Skript

Beitragvon Bully » 22. Mai 2016 18:30

Hallo

Hier biete ich Euch ein custom skript für die U-Ban Stormwind nach Eisenschmiede.

http://img.userboard.org/uploads/mi/mid ... emplate.7z

Bild


viel spaß
Vertrauen wird oft dadurch erschöpft, dass es in Anspruch genommen wird.
Bild
Bully
Benutzeravatar
Forum Admin
 
Beiträge: 368
Registriert: 02.2014
Geschlecht: männlich
Wohnort: Dreamland


Re: World of Draenor 6.2.X Skript

Beitragvon Bully » 25. Mai 2016 00:55

wod Schmiedekunst Lehrer

Skript 1
DELETE FROM `npc_trainer` WHERE entry='85917';

INSERT INTO `npc_trainer` VALUES ('85917', '2018', '10', '0', '0', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '2661', '100', '164', '35', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '2662', '50', '164', '1', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '2664', '500', '164', '90', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '2665', '100', '164', '65', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '2666', '200', '164', '70', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '2668', '300', '164', '105', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '2670', '500', '164', '105', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '2672', '500', '164', '120', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '2674', '1000', '164', '125', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '2675', '1000', '164', '145', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '2737', '50', '164', '15', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '2738', '50', '164', '20', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '2739', '50', '164', '25', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '2740', '200', '164', '110', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '2741', '200', '164', '115', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '2742', '200', '164', '120', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '3100', '500', '164', '50', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '3116', '100', '164', '65', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '3117', '1000', '164', '125', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '3292', '500', '164', '95', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '3293', '250', '164', '35', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '3294', '500', '164', '70', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '3296', '1000', '164', '130', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '3319', '50', '164', '20', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '3320', '100', '164', '25', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '3323', '100', '164', '40', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '3324', '200', '164', '45', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '3326', '250', '164', '75', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '3328', '500', '164', '110', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '3331', '500', '164', '130', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '3333', '1000', '164', '135', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '3337', '1000', '164', '125', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '3491', '600', '164', '105', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '3501', '1000', '164', '165', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '3502', '1250', '164', '170', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '3506', '5000', '164', '155', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '3508', '7500', '164', '180', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '3538', '5000', '164', '125', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '6517', '800', '164', '110', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '7223', '1000', '164', '185', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '7408', '300', '164', '65', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '7817', '200', '164', '95', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '8768', '250', '164', '150', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '8880', '100', '164', '30', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '9785', '50000', '164', '200', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '9916', '2500', '164', '200', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '9918', '2500', '164', '200', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '9920', '2500', '164', '200', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '9921', '2500', '164', '200', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '9926', '5000', '164', '205', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '9928', '5000', '164', '205', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '9931', '5000', '164', '210', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '9935', '5000', '164', '215', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '9959', '15000', '164', '230', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '9961', '15000', '164', '230', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '9968', '20000', '164', '235', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '9983', '100', '164', '30', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '9985', '250', '164', '125', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '9986', '500', '164', '130', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '9987', '500', '164', '135', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '9993', '10000', '164', '210', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '10001', '15000', '164', '230', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '15972', '7500', '164', '180', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '16639', '10000', '164', '250', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '16640', '10000', '164', '250', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '16641', '10000', '164', '250', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '16642', '10000', '164', '250', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '16643', '10000', '164', '250', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '16644', '10000', '164', '255', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '16646', '10000', '164', '265', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '16647', '10000', '164', '265', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '16649', '10000', '164', '270', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '16652', '10000', '164', '280', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '16653', '10000', '164', '280', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '16657', '10000', '164', '295', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '16658', '10000', '164', '295', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '16662', '12000', '164', '300', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '16663', '12000', '164', '300', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '16730', '12000', '164', '300', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '16969', '15000', '164', '275', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '16971', '15000', '164', '280', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '19666', '100', '164', '100', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '19667', '250', '164', '150', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '19668', '2500', '164', '200', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '19669', '10000', '164', '275', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '29545', '15000', '164', '300', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '29547', '15000', '164', '305', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '29548', '20000', '164', '315', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '29549', '20000', '164', '315', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '29550', '25000', '164', '325', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '29551', '15000', '164', '300', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '29552', '18000', '164', '310', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '29553', '20000', '164', '315', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '29556', '22000', '164', '320', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '29557', '18000', '164', '310', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '29558', '20000', '164', '315', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '29565', '22000', '164', '320', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '29654', '15000', '164', '300', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '29844', '100000', '164', '275', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '32284', '25000', '164', '325', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '34607', '15000', '164', '300', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '51300', '350000', '164', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '52567', '30000', '164', '370', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '52568', '30000', '164', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '52569', '30000', '164', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '52570', '30000', '164', '375', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '52571', '30000', '164', '370', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '52572', '30000', '164', '360', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '54550', '30000', '164', '360', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '54551', '40000', '164', '395', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '54552', '40000', '164', '400', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '54553', '40000', '164', '400', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '54554', '40000', '164', '395', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '54555', '40000', '164', '405', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '54556', '40000', '164', '405', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '54557', '40000', '164', '390', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '54917', '30000', '164', '375', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '54918', '30000', '164', '380', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '54941', '30000', '164', '385', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '54944', '30000', '164', '385', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '54945', '35000', '164', '390', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '54946', '30000', '164', '395', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '54947', '35000', '164', '395', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '54948', '30000', '164', '400', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '54949', '30000', '164', '400', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '55013', '40000', '164', '390', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '55014', '35000', '164', '410', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '55015', '40000', '164', '415', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '55017', '40000', '164', '410', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '55055', '40000', '164', '395', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '55056', '40000', '164', '400', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '55057', '40000', '164', '405', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '55058', '45000', '164', '415', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '55174', '50000', '164', '390', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '55177', '50000', '164', '395', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '55179', '50000', '164', '400', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '55181', '50000', '164', '405', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '55182', '40000', '164', '410', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '55185', '45000', '164', '415', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '55200', '35000', '164', '380', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '55201', '35000', '164', '380', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '55203', '35000', '164', '385', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '55204', '35000', '164', '390', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '55206', '40000', '164', '405', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '55298', '45000', '164', '420', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '55300', '45000', '164', '420', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '55301', '45000', '164', '420', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '55302', '45000', '164', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '55303', '45000', '164', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '55304', '45000', '164', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '55305', '45000', '164', '420', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '55306', '45000', '164', '420', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '55307', '45000', '164', '420', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '55308', '45000', '164', '420', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '55309', '45000', '164', '420', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '55310', '45000', '164', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '55311', '45000', '164', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '55312', '45000', '164', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '55369', '180000', '164', '440', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '55370', '150000', '164', '440', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '55371', '150000', '164', '440', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '55372', '120000', '164', '440', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '55373', '120000', '164', '440', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '55374', '120000', '164', '440', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '55375', '120000', '164', '440', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '55376', '120000', '164', '440', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '55377', '120000', '164', '440', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '55656', '50000', '164', '415', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '55834', '30000', '164', '360', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '55835', '30000', '164', '370', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '55839', '42000', '164', '420', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '56234', '150000', '164', '440', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '56280', '40000', '164', '410', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '56357', '42000', '164', '420', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '56400', '150000', '164', '440', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '56549', '45000', '164', '420', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '56550', '45000', '164', '420', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '56551', '45000', '164', '420', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '56552', '45000', '164', '420', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '56553', '45000', '164', '420', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '56554', '45000', '164', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '56555', '45000', '164', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '56556', '45000', '164', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '59405', '30000', '164', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '59406', '45000', '164', '430', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '59436', '40000', '164', '395', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '59438', '40000', '164', '400', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '59440', '40000', '164', '405', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '59441', '45000', '164', '415', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '59442', '40000', '164', '410', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '61008', '120000', '164', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '61009', '120000', '164', '420', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '61010', '120000', '164', '420', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '63182', '150000', '164', '440', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '76178', '15000', '164', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '76179', '40000', '164', '440', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '76180', '50000', '164', '450', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '76181', '55000', '164', '460', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '76182', '60000', '164', '470', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '76258', '65000', '164', '480', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '76259', '65000', '164', '490', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '76260', '65000', '164', '490', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '76261', '75000', '164', '500', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '76262', '40000', '164', '440', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '76263', '50000', '164', '450', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '76264', '55000', '164', '460', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '76265', '60000', '164', '470', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '76266', '65000', '164', '480', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '76267', '65000', '164', '490', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '76269', '75000', '164', '500', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '76270', '75000', '164', '500', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '76280', '40000', '164', '440', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '76281', '50000', '164', '450', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '76283', '55000', '164', '460', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '76285', '60000', '164', '470', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '76286', '65000', '164', '480', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '76287', '65000', '164', '480', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '76288', '65000', '164', '490', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '76289', '75000', '164', '500', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '76291', '50000', '164', '450', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '76293', '60000', '164', '470', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '76433', '50000', '164', '460', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '76434', '60000', '164', '470', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '76435', '65000', '164', '480', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '76436', '65000', '164', '480', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '76437', '65000', '164', '480', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '76438', '60000', '164', '475', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '76441', '65000', '164', '490', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '76474', '60000', '164', '470', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '76666', '500000', '164', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '110396', '600000', '164', '500', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '122576', '80000', '164', '550', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '122577', '80000', '164', '540', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '122578', '80000', '164', '550', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '122579', '80000', '164', '525', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '122580', '80000', '164', '530', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '122581', '80000', '164', '500', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '122582', '80000', '164', '530', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '122583', '80000', '164', '525', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '122633', '80000', '164', '500', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '122635', '80000', '164', '540', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '122636', '80000', '164', '545', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '122637', '80000', '164', '545', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '122638', '80000', '164', '545', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '122639', '80000', '164', '560', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '122640', '80000', '164', '565', '0');
INSERT INTO `npc_trainer` VALUES ('85917', '122641', '80000', '164', '565', '0');


Skript 2
DELETE FROM `npc_trainer` WHERE entry='86048';

INSERT INTO `npc_trainer` VALUES ('86048', '2018', '10', '0', '0', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '2661', '100', '164', '35', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '2662', '50', '164', '1', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '2664', '500', '164', '90', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '2665', '100', '164', '65', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '2666', '200', '164', '70', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '2668', '300', '164', '105', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '2670', '500', '164', '105', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '2672', '500', '164', '120', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '2674', '1000', '164', '125', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '2675', '1000', '164', '145', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '2737', '50', '164', '15', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '2738', '50', '164', '20', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '2739', '50', '164', '25', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '2740', '200', '164', '110', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '2741', '200', '164', '115', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '2742', '200', '164', '120', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '3100', '500', '164', '50', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '3116', '100', '164', '65', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '3117', '1000', '164', '125', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '3292', '500', '164', '95', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '3293', '250', '164', '35', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '3294', '500', '164', '70', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '3296', '1000', '164', '130', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '3319', '50', '164', '20', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '3320', '100', '164', '25', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '3323', '100', '164', '40', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '3324', '200', '164', '45', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '3326', '250', '164', '75', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '3328', '500', '164', '110', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '3331', '500', '164', '130', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '3333', '1000', '164', '135', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '3337', '1000', '164', '125', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '3491', '600', '164', '105', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '3501', '1000', '164', '165', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '3502', '1250', '164', '170', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '3506', '5000', '164', '155', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '3508', '7500', '164', '180', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '3538', '5000', '164', '125', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '6517', '800', '164', '110', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '7223', '1000', '164', '185', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '7408', '300', '164', '65', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '7817', '200', '164', '95', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '8768', '250', '164', '150', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '8880', '100', '164', '30', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '9785', '50000', '164', '200', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '9916', '2500', '164', '200', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '9918', '2500', '164', '200', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '9920', '2500', '164', '200', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '9921', '2500', '164', '200', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '9926', '5000', '164', '205', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '9928', '5000', '164', '205', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '9931', '5000', '164', '210', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '9935', '5000', '164', '215', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '9959', '15000', '164', '230', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '9961', '15000', '164', '230', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '9968', '20000', '164', '235', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '9983', '100', '164', '30', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '9985', '250', '164', '125', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '9986', '500', '164', '130', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '9987', '500', '164', '135', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '9993', '10000', '164', '210', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '10001', '15000', '164', '230', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '15972', '7500', '164', '180', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '16639', '10000', '164', '250', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '16640', '10000', '164', '250', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '16641', '10000', '164', '250', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '16642', '10000', '164', '250', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '16643', '10000', '164', '250', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '16644', '10000', '164', '255', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '16646', '10000', '164', '265', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '16647', '10000', '164', '265', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '16649', '10000', '164', '270', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '16652', '10000', '164', '280', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '16653', '10000', '164', '280', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '16657', '10000', '164', '295', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '16658', '10000', '164', '295', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '16662', '12000', '164', '300', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '16663', '12000', '164', '300', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '16730', '12000', '164', '300', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '16969', '15000', '164', '275', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '16971', '15000', '164', '280', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '19666', '100', '164', '100', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '19667', '250', '164', '150', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '19668', '2500', '164', '200', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '19669', '10000', '164', '275', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '29545', '15000', '164', '300', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '29547', '15000', '164', '305', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '29548', '20000', '164', '315', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '29549', '20000', '164', '315', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '29550', '25000', '164', '325', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '29551', '15000', '164', '300', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '29552', '18000', '164', '310', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '29553', '20000', '164', '315', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '29556', '22000', '164', '320', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '29557', '18000', '164', '310', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '29558', '20000', '164', '315', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '29565', '22000', '164', '320', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '29654', '15000', '164', '300', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '29844', '100000', '164', '275', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '32284', '25000', '164', '325', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '34607', '15000', '164', '300', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '51300', '350000', '164', '350', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '52567', '30000', '164', '370', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '52568', '30000', '164', '350', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '52569', '30000', '164', '350', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '52570', '30000', '164', '375', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '52571', '30000', '164', '370', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '52572', '30000', '164', '360', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '54550', '30000', '164', '360', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '54551', '40000', '164', '395', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '54552', '40000', '164', '400', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '54553', '40000', '164', '400', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '54554', '40000', '164', '395', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '54555', '40000', '164', '405', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '54556', '40000', '164', '405', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '54557', '40000', '164', '390', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '54917', '30000', '164', '375', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '54918', '30000', '164', '380', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '54941', '30000', '164', '385', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '54944', '30000', '164', '385', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '54945', '35000', '164', '390', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '54946', '30000', '164', '395', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '54947', '35000', '164', '395', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '54948', '30000', '164', '400', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '54949', '30000', '164', '400', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '55013', '40000', '164', '390', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '55014', '35000', '164', '410', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '55015', '40000', '164', '415', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '55017', '40000', '164', '410', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '55055', '40000', '164', '395', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '55056', '40000', '164', '400', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '55057', '40000', '164', '405', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '55058', '45000', '164', '415', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '55174', '50000', '164', '390', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '55177', '50000', '164', '395', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '55179', '50000', '164', '400', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '55181', '50000', '164', '405', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '55182', '40000', '164', '410', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '55185', '45000', '164', '415', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '55200', '35000', '164', '380', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '55201', '35000', '164', '380', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '55203', '35000', '164', '385', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '55204', '35000', '164', '390', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '55206', '40000', '164', '405', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '55298', '45000', '164', '420', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '55300', '45000', '164', '420', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '55301', '45000', '164', '420', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '55302', '45000', '164', '425', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '55303', '45000', '164', '425', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '55304', '45000', '164', '425', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '55305', '45000', '164', '420', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '55306', '45000', '164', '420', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '55307', '45000', '164', '420', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '55308', '45000', '164', '420', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '55309', '45000', '164', '420', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '55310', '45000', '164', '425', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '55311', '45000', '164', '425', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '55312', '45000', '164', '425', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '55369', '180000', '164', '440', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '55370', '150000', '164', '440', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '55371', '150000', '164', '440', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '55372', '120000', '164', '440', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '55373', '120000', '164', '440', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '55374', '120000', '164', '440', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '55375', '120000', '164', '440', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '55376', '120000', '164', '440', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '55377', '120000', '164', '440', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '55656', '50000', '164', '415', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '55834', '30000', '164', '360', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '55835', '30000', '164', '370', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '55839', '42000', '164', '420', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '56234', '150000', '164', '440', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '56280', '40000', '164', '410', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '56357', '42000', '164', '420', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '56400', '150000', '164', '440', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '56549', '45000', '164', '420', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '56550', '45000', '164', '420', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '56551', '45000', '164', '420', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '56552', '45000', '164', '420', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '56553', '45000', '164', '420', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '56554', '45000', '164', '425', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '56555', '45000', '164', '425', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '56556', '45000', '164', '425', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '59405', '30000', '164', '350', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '59406', '45000', '164', '430', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '59436', '40000', '164', '395', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '59438', '40000', '164', '400', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '59440', '40000', '164', '405', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '59441', '45000', '164', '415', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '59442', '40000', '164', '410', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '61008', '120000', '164', '425', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '61009', '120000', '164', '420', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '61010', '120000', '164', '420', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '63182', '150000', '164', '440', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '76178', '15000', '164', '425', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '76179', '40000', '164', '440', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '76180', '50000', '164', '450', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '76181', '55000', '164', '460', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '76182', '60000', '164', '470', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '76258', '65000', '164', '480', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '76259', '65000', '164', '490', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '76260', '65000', '164', '490', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '76261', '75000', '164', '500', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '76262', '40000', '164', '440', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '76263', '50000', '164', '450', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '76264', '55000', '164', '460', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '76265', '60000', '164', '470', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '76266', '65000', '164', '480', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '76267', '65000', '164', '490', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '76269', '75000', '164', '500', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '76270', '75000', '164', '500', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '76280', '40000', '164', '440', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '76281', '50000', '164', '450', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '76283', '55000', '164', '460', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '76285', '60000', '164', '470', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '76286', '65000', '164', '480', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '76287', '65000', '164', '480', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '76288', '65000', '164', '490', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '76289', '75000', '164', '500', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '76291', '50000', '164', '450', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '76293', '60000', '164', '470', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '76433', '50000', '164', '460', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '76434', '60000', '164', '470', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '76435', '65000', '164', '480', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '76436', '65000', '164', '480', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '76437', '65000', '164', '480', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '76438', '60000', '164', '475', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '76441', '65000', '164', '490', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '76474', '60000', '164', '470', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '76666', '500000', '164', '425', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '110396', '600000', '164', '500', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '122576', '80000', '164', '550', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '122577', '80000', '164', '540', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '122578', '80000', '164', '550', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '122579', '80000', '164', '525', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '122580', '80000', '164', '530', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '122581', '80000', '164', '500', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '122582', '80000', '164', '530', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '122583', '80000', '164', '525', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '122633', '80000', '164', '500', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '122635', '80000', '164', '540', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '122636', '80000', '164', '545', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '122637', '80000', '164', '545', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '122638', '80000', '164', '545', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '122639', '80000', '164', '560', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '122640', '80000', '164', '565', '0');
INSERT INTO `npc_trainer` VALUES ('86048', '122641', '80000', '164', '565', '0');


viel spaß
Vertrauen wird oft dadurch erschöpft, dass es in Anspruch genommen wird.
Bild
Bully
Benutzeravatar
Forum Admin
 
Beiträge: 368
Registriert: 02.2014
Geschlecht: männlich
Wohnort: Dreamland


Re: World of Draenor 6.2.X Skript

Beitragvon craigy108 » 28. Mai 2016 18:07

Thx

habt ihr auch die anderen Berufe ? ist sehr hilfreich gewesen :D
craigy108
Benutzeravatar
 
Beiträge: 81
Registriert: 03.2014
Geschlecht: männlich


Re: World of Draenor 6.2.X Skript

Beitragvon Gerhard Reiss » 29. Mai 2016 10:48

Moin

Hier die restlichen von den Allilehrern, auf Hordeseite dürfte das selbe sein, müßt nur die Npc ID von den jeweiligen Hordelehrern eintragen

Alchemielehrer
DELETE FROM `npc_trainer` WHERE entry='85905';

INSERT INTO `npc_trainer` VALUES ('85905', '2259', '10', '0', '0', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '2331', '100', '171', '25', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '2332', '150', '171', '40', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '2334', '250', '171', '50', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '2337', '1000', '171', '55', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '3101', '500', '171', '50', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '3170', '50', '171', '15', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '3171', '500', '171', '90', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '3173', '1500', '171', '120', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '3176', '1500', '171', '125', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '3177', '2000', '171', '130', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '3447', '4000', '171', '110', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '3448', '5000', '171', '165', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '3449', '5000', '171', '165', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '3450', '6000', '171', '175', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '3452', '5000', '171', '160', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '3464', '5000', '171', '125', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '7179', '450', '171', '90', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '7181', '5000', '171', '155', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '7836', '250', '171', '80', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '7837', '1000', '171', '130', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '7841', '1000', '171', '100', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '7845', '3000', '171', '140', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '11448', '9000', '171', '205', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '11449', '6500', '171', '185', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '11450', '7500', '171', '195', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '11451', '8000', '171', '205', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '11457', '10000', '171', '215', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '11460', '5000', '171', '230', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '11461', '10000', '171', '235', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '11465', '12000', '171', '235', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '11467', '12000', '171', '240', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '11478', '14000', '171', '250', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '11611', '50000', '171', '200', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '12609', '8000', '171', '200', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '15833', '10000', '171', '230', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '17551', '15000', '171', '250', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '17552', '15000', '171', '255', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '17553', '15000', '171', '260', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '17555', '15000', '171', '270', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '17556', '20000', '171', '275', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '17557', '20000', '171', '275', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '17572', '20000', '171', '285', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '17573', '20000', '171', '285', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '22808', '10000', '171', '215', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '28544', '25000', '171', '305', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '28545', '25000', '171', '310', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '28551', '50000', '171', '325', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '28596', '100000', '171', '275', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '33732', '20000', '171', '300', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '33733', '25000', '171', '310', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '33738', '20000', '171', '300', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '33740', '20000', '171', '300', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '33741', '30000', '171', '315', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '38070', '20000', '171', '325', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '39636', '25000', '171', '310', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '39638', '30000', '171', '320', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '45061', '35000', '171', '325', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '51304', '350000', '171', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '53812', '60000', '171', '375', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '53836', '150000', '171', '405', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '53837', '150000', '171', '410', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '53838', '40000', '171', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '53839', '40000', '171', '360', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '53840', '120000', '171', '395', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '53841', '40000', '171', '355', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '53842', '40000', '171', '365', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '53847', '65000', '171', '385', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '53848', '60000', '171', '375', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '53898', '120000', '171', '390', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '53899', '60000', '171', '375', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '53900', '120000', '171', '380', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '53901', '180000', '171', '435', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '53902', '150000', '171', '435', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '53903', '180000', '171', '435', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '53905', '120000', '171', '395', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '54213', '150000', '171', '435', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '54218', '120000', '171', '385', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '57425', '150000', '171', '430', '45');
INSERT INTO `npc_trainer` VALUES ('85905', '57427', '150000', '171', '425', '45');
INSERT INTO `npc_trainer` VALUES ('85905', '58868', '150000', '171', '410', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '58871', '150000', '171', '410', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '60350', '150000', '171', '395', '45');
INSERT INTO `npc_trainer` VALUES ('85905', '60367', '120000', '171', '395', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '60396', '200000', '171', '400', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '60403', '200000', '171', '400', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '60405', '200000', '171', '400', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '60893', '200000', '171', '400', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '62409', '60000', '171', '375', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '63732', '2000', '171', '135', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '66658', '200000', '171', '450', '45');
INSERT INTO `npc_trainer` VALUES ('85905', '66660', '200000', '171', '450', '45');
INSERT INTO `npc_trainer` VALUES ('85905', '66662', '200000', '171', '450', '45');
INSERT INTO `npc_trainer` VALUES ('85905', '66663', '200000', '171', '450', '45');
INSERT INTO `npc_trainer` VALUES ('85905', '66664', '200000', '171', '450', '45');
INSERT INTO `npc_trainer` VALUES ('85905', '78866', '175000', '171', '485', '45');
INSERT INTO `npc_trainer` VALUES ('85905', '80237', '250000', '171', '525', '45');
INSERT INTO `npc_trainer` VALUES ('85905', '80243', '250000', '171', '525', '45');
INSERT INTO `npc_trainer` VALUES ('85905', '80244', '200000', '171', '520', '45');
INSERT INTO `npc_trainer` VALUES ('85905', '80245', '250000', '171', '525', '45');
INSERT INTO `npc_trainer` VALUES ('85905', '80246', '200000', '171', '515', '45');
INSERT INTO `npc_trainer` VALUES ('85905', '80247', '200000', '171', '520', '45');
INSERT INTO `npc_trainer` VALUES ('85905', '80248', '200000', '171', '515', '45');
INSERT INTO `npc_trainer` VALUES ('85905', '80250', '200000', '171', '510', '45');
INSERT INTO `npc_trainer` VALUES ('85905', '80251', '200000', '171', '505', '45');
INSERT INTO `npc_trainer` VALUES ('85905', '80269', '160000', '171', '460', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '80477', '150000', '171', '450', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '80478', '150000', '171', '450', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '80479', '150000', '171', '455', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '80480', '150000', '171', '455', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '80481', '160000', '171', '460', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '80482', '160000', '171', '465', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '80484', '160000', '171', '465', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '80486', '160000', '171', '470', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '80487', '160000', '171', '470', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '80488', '160000', '171', '475', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '80490', '160000', '171', '475', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '80491', '175000', '171', '480', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '80492', '175000', '171', '480', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '80493', '175000', '171', '490', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '80494', '175000', '171', '485', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '80495', '175000', '171', '485', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '80496', '175000', '171', '490', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '80497', '175000', '171', '495', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '80498', '175000', '171', '495', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '80508', '100000', '171', '500', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '80719', '200000', '171', '500', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '80720', '200000', '171', '505', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '80721', '200000', '171', '510', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '80723', '200000', '171', '510', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '80725', '250000', '171', '525', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '80726', '250000', '171', '525', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '80731', '500000', '171', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '93935', '150000', '171', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '94162', '200000', '171', '500', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '96252', '100000', '171', '500', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '96253', '100000', '171', '500', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '96254', '100000', '171', '500', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '105206', '600000', '171', '500', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '114751', '200000', '171', '500', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '114752', '200000', '171', '500', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '114786', '20000', '171', '300', '0');
INSERT INTO `npc_trainer` VALUES ('85905', '136197', '100000', '171', '500', '0');


Alchemierezepte
DELETE FROM `npc_vendor` WHERE entry='87048';

INSERT INTO `npc_vendor` VALUES ('87048', '0', '3371', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87048', '1', '109558', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87048', '2', '112023', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87048', '3', '112024', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87048', '4', '112026', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87048', '5', '112027', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87048', '6', '112030', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87048', '7', '112031', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87048', '8', '112033', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87048', '9', '112034', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87048', '10', '112037', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87048', '11', '112038', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87048', '12', '112039', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87048', '13', '112040', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87048', '14', '112041', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87048', '15', '112042', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87048', '16', '112045', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87048', '17', '112047', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87048', '18', '114028', '0', '0', '0', '1');


Kreuterkundelehrer
DELETE FROM `npc_trainer` WHERE entry='85921';

INSERT INTO `npc_trainer` VALUES ('85921', '2366', '10', '0', '0', '0');
INSERT INTO `npc_trainer` VALUES ('85921', '2368', '500', '182', '50', '0');
INSERT INTO `npc_trainer` VALUES ('85921', '3570', '5000', '182', '125', '0');
INSERT INTO `npc_trainer` VALUES ('85921', '11993', '50000', '182', '200', '0');
INSERT INTO `npc_trainer` VALUES ('85921', '28695', '100000', '182', '275', '0');
INSERT INTO `npc_trainer` VALUES ('85921', '50300', '350000', '182', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85921', '74519', '500000', '182', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85921', '110413', '600000', '182', '500', '0');


Archäologielehrer
DELETE FROM `npc_trainer` WHERE entry='85927';

INSERT INTO `npc_trainer` VALUES ('85927', '78670', '1000', '794', '1', '0');
INSERT INTO `npc_trainer` VALUES ('85927', '88961', '1000', '794', '50', '0');
INSERT INTO `npc_trainer` VALUES ('85927', '89718', '1000', '794', '125', '0');
INSERT INTO `npc_trainer` VALUES ('85927', '89719', '25000', '794', '200', '0');
INSERT INTO `npc_trainer` VALUES ('85927', '89720', '100000', '794', '275', '0');
INSERT INTO `npc_trainer` VALUES ('85927', '89721', '150000', '794', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85927', '89722', '250000', '794', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85927', '110393', '600000', '794', '500', '0');


Archäologiefragmente
DELETE FROM `npc_vendor` WHERE entry='87365';

INSERT INTO `npc_vendor` VALUES ('87365', '0', '87533', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87365', '1', '87534', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87365', '2', '87535', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87365', '3', '87536', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87365', '4', '87537', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87365', '5', '87538', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87365', '6', '87539', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87365', '7', '87540', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87365', '8', '87541', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87365', '9', '117386', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87365', '10', '117387', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87365', '11', '117388', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87365', '12', '117389', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87365', '13', '117390', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87365', '14', '118728', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87365', '15', '118729', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87365', '16', '118730', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87365', '17', '118731', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87365', '18', '118732', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87365', '19', '122606', '0', '0', '0', '1');


Kochkunstlehrer
DELETE FROM `npc_trainer` WHERE entry='85925';

INSERT INTO `npc_trainer` VALUES ('85925', '2539', '50', '185', '10', '0');
INSERT INTO `npc_trainer` VALUES ('85925', '2541', '100', '185', '50', '0');
INSERT INTO `npc_trainer` VALUES ('85925', '2544', '200', '185', '75', '0');
INSERT INTO `npc_trainer` VALUES ('85925', '2546', '150', '185', '80', '0');
INSERT INTO `npc_trainer` VALUES ('85925', '2550', '100', '0', '0', '0');
INSERT INTO `npc_trainer` VALUES ('85925', '3102', '500', '185', '50', '0');
INSERT INTO `npc_trainer` VALUES ('85925', '3399', '450', '185', '150', '0');
INSERT INTO `npc_trainer` VALUES ('85925', '3400', '500', '185', '175', '0');
INSERT INTO `npc_trainer` VALUES ('85925', '3413', '10000', '185', '125', '0');
INSERT INTO `npc_trainer` VALUES ('85925', '4094', '500', '185', '175', '0');
INSERT INTO `npc_trainer` VALUES ('85925', '6412', '50', '185', '10', '0');
INSERT INTO `npc_trainer` VALUES ('85925', '6415', '100', '185', '50', '0');
INSERT INTO `npc_trainer` VALUES ('85925', '6499', '100', '185', '50', '0');
INSERT INTO `npc_trainer` VALUES ('85925', '6500', '300', '185', '125', '0');
INSERT INTO `npc_trainer` VALUES ('85925', '18238', '5000', '185', '225', '0');
INSERT INTO `npc_trainer` VALUES ('85925', '18240', '6000', '185', '240', '0');
INSERT INTO `npc_trainer` VALUES ('85925', '18243', '6500', '185', '250', '0');
INSERT INTO `npc_trainer` VALUES ('85925', '18244', '6500', '185', '250', '0');
INSERT INTO `npc_trainer` VALUES ('85925', '18260', '25000', '185', '200', '0');
INSERT INTO `npc_trainer` VALUES ('85925', '21175', '4000', '185', '200', '0');
INSERT INTO `npc_trainer` VALUES ('85925', '33359', '100000', '185', '275', '0');
INSERT INTO `npc_trainer` VALUES ('85925', '37836', '10', '185', '1', '0');
INSERT INTO `npc_trainer` VALUES ('85925', '42296', '15000', '185', '320', '0');
INSERT INTO `npc_trainer` VALUES ('85925', '42302', '20000', '185', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85925', '42305', '20000', '185', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85925', '45549', '20000', '185', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85925', '45550', '20000', '185', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85925', '45551', '20000', '185', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85925', '45552', '20000', '185', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85925', '45553', '20000', '185', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85925', '45554', '50000', '185', '375', '0');
INSERT INTO `npc_trainer` VALUES ('85925', '45560', '10000', '185', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85925', '45561', '10000', '185', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85925', '45562', '10000', '185', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85925', '45563', '20000', '185', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85925', '45564', '20000', '185', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85925', '45565', '20000', '185', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85925', '45566', '20000', '185', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85925', '45569', '20000', '185', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85925', '46684', '6500', '185', '250', '0');
INSERT INTO `npc_trainer` VALUES ('85925', '46688', '6500', '185', '250', '0');
INSERT INTO `npc_trainer` VALUES ('85925', '51296', '350000', '185', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85925', '58065', '20000', '185', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85925', '64358', '50000', '185', '400', '0');
INSERT INTO `npc_trainer` VALUES ('85925', '88006', '35000', '185', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85925', '88015', '30000', '185', '415', '0');
INSERT INTO `npc_trainer` VALUES ('85925', '88053', '500000', '185', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85925', '93741', '80', '185', '40', '0');
INSERT INTO `npc_trainer` VALUES ('85925', '104237', '40000', '185', '270', '0');
INSERT INTO `npc_trainer` VALUES ('85925', '104297', '40000', '185', '300', '0');
INSERT INTO `npc_trainer` VALUES ('85925', '104381', '600000', '185', '500', '0');


Verzauberkunstlehrer
DELETE FROM `npc_trainer` WHERE entry='85914';

INSERT INTO `npc_trainer` VALUES ('85914', '7411', '10', '0', '0', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '7412', '500', '333', '50', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '7413', '5000', '333', '125', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '7420', '50', '333', '15', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '7426', '100', '333', '40', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '7457', '250', '333', '50', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '7745', '500', '333', '100', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '7748', '250', '333', '60', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '7771', '200', '333', '70', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '7779', '400', '333', '80', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '7788', '500', '333', '90', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '7857', '1000', '333', '120', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '7863', '1400', '333', '125', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '13378', '600', '333', '105', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '13421', '800', '333', '115', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '13485', '1500', '333', '130', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '13501', '1500', '333', '130', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '13503', '2000', '333', '140', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '13529', '2400', '333', '145', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '13538', '2500', '333', '140', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '13607', '2400', '333', '145', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '13622', '2500', '333', '150', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '13626', '2500', '333', '150', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '13631', '2600', '333', '155', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '13635', '2600', '333', '155', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '13637', '2800', '333', '160', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '13640', '2700', '333', '160', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '13642', '2800', '333', '165', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '13644', '2800', '333', '170', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '13646', '2800', '333', '170', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '13648', '2800', '333', '170', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '13659', '3200', '333', '180', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '13661', '3600', '333', '180', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '13663', '3800', '333', '185', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '13693', '4000', '333', '195', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '13695', '4000', '333', '200', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '13700', '4000', '333', '200', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '13746', '4200', '333', '205', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '13815', '4400', '333', '210', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '13822', '4400', '333', '210', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '13836', '4600', '333', '215', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '13858', '4800', '333', '220', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '13887', '5000', '333', '225', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '13890', '5000', '333', '225', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '13905', '5400', '333', '230', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '13917', '5400', '333', '230', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '13920', '50000', '333', '200', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '13935', '5800', '333', '235', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '13937', '6200', '333', '240', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '13939', '6200', '333', '240', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '13941', '6200', '333', '245', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '13943', '6200', '333', '245', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '13948', '6500', '333', '250', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '14293', '50', '333', '10', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '14807', '200', '333', '70', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '14809', '2600', '333', '155', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '14810', '3000', '333', '175', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '17180', '10000', '333', '250', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '17181', '10000', '333', '250', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '20008', '10000', '333', '255', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '20012', '10000', '333', '270', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '20013', '20000', '333', '295', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '20016', '15000', '333', '280', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '20023', '20000', '333', '295', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '20028', '15000', '333', '290', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '27899', '12500', '333', '305', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '27905', '12500', '333', '315', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '27944', '15000', '333', '310', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '27957', '17500', '333', '315', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '27958', '50000', '333', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '27961', '15000', '333', '310', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '28027', '40000', '333', '325', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '28028', '80000', '333', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '28029', '100000', '333', '275', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '33990', '20000', '333', '320', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '33991', '20000', '333', '300', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '33993', '12500', '333', '305', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '33995', '25000', '333', '340', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '33996', '15000', '333', '310', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '34001', '12500', '333', '305', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '34002', '12500', '333', '300', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '34004', '15000', '333', '310', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '42613', '10000', '333', '300', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '42615', '40000', '333', '335', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '44383', '25000', '333', '330', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '44484', '150000', '333', '405', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '44488', '150000', '333', '410', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '44489', '150000', '333', '420', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '44492', '100000', '333', '395', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '44500', '100000', '333', '395', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '44506', '50000', '333', '375', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '44508', '150000', '333', '410', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '44509', '150000', '333', '420', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '44510', '150000', '333', '410', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '44513', '100000', '333', '395', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '44528', '90000', '333', '385', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '44529', '150000', '333', '415', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '44555', '50000', '333', '375', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '44582', '100000', '333', '395', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '44584', '150000', '333', '405', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '44589', '150000', '333', '415', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '44592', '50000', '333', '360', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '44593', '150000', '333', '420', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '44598', '150000', '333', '415', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '44616', '100000', '333', '400', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '44623', '50000', '333', '370', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '44629', '100000', '333', '395', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '44630', '80000', '333', '390', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '44633', '150000', '333', '410', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '44635', '100000', '333', '395', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '47766', '100000', '333', '400', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '47900', '150000', '333', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '51313', '350000', '333', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '60606', '50000', '333', '375', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '60609', '50000', '333', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '60616', '50000', '333', '360', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '60621', '80000', '333', '380', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '60623', '90000', '333', '385', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '60653', '100000', '333', '395', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '60663', '150000', '333', '420', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '60668', '150000', '333', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '62959', '90000', '333', '385', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '63746', '5000', '333', '225', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '69412', '50000', '333', '390', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '74132', '30000', '333', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '74189', '30000', '333', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '74191', '30000', '333', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '74192', '30000', '333', '435', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '74193', '30000', '333', '435', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '74195', '30000', '333', '450', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '74197', '30000', '333', '450', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '74198', '30000', '333', '455', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '74199', '30000', '333', '455', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '74200', '30000', '333', '460', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '74201', '30000', '333', '460', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '74202', '30000', '333', '465', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '74207', '30000', '333', '465', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '74211', '30000', '333', '470', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '74212', '30000', '333', '470', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '74213', '30000', '333', '475', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '74214', '30000', '333', '475', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '74220', '30000', '333', '480', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '74223', '30000', '333', '480', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '74225', '30000', '333', '485', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '74226', '30000', '333', '485', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '74229', '30000', '333', '490', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '74230', '30000', '333', '490', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '74231', '30000', '333', '495', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '74232', '30000', '333', '495', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '74234', '30000', '333', '500', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '74235', '30000', '333', '500', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '74236', '30000', '333', '505', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '74237', '30000', '333', '505', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '74238', '30000', '333', '510', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '74239', '30000', '333', '510', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '74240', '30000', '333', '510', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '74258', '500000', '333', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '95471', '30000', '333', '470', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '104338', '20000', '333', '500', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '104385', '20000', '333', '525', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '104392', '20000', '333', '525', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '104393', '20000', '333', '525', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '104395', '20000', '333', '575', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '104397', '20000', '333', '550', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '104398', '20000', '333', '550', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '104401', '20000', '333', '575', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '104403', '20000', '333', '525', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '104404', '20000', '333', '500', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '104407', '20000', '333', '550', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '104408', '20000', '333', '525', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '104409', '20000', '333', '550', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '104414', '20000', '333', '575', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '104416', '20000', '333', '525', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '104417', '20000', '333', '550', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '104419', '20000', '333', '575', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '104420', '20000', '333', '575', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '104425', '20000', '333', '550', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '104430', '20000', '333', '525', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '104440', '20000', '333', '575', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '104445', '20000', '333', '575', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '104698', '30000', '333', '515', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '110400', '600000', '333', '500', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '116497', '20000', '333', '500', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '116498', '20000', '333', '550', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '116499', '20000', '333', '600', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '118237', '20000', '333', '535', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '118238', '20000', '333', '585', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '118239', '20000', '333', '600', '0');
INSERT INTO `npc_trainer` VALUES ('85914', '130758', '20000', '333', '575', '0');


Verzauberkunstrezepte
DELETE FROM `npc_vendor` WHERE entry='87022';

INSERT INTO `npc_vendor` VALUES ('87022', '0', '38682', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87022', '1', '111922', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87022', '2', '118394', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87022', '3', '118429', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87022', '4', '118430', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87022', '5', '118431', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87022', '6', '118432', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87022', '7', '118433', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87022', '8', '118434', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87022', '9', '118435', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87022', '10', '118436', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87022', '11', '118437', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87022', '12', '118438', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87022', '13', '118439', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87022', '14', '118440', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87022', '15', '118441', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87022', '16', '118442', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87022', '17', '118443', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87022', '18', '118444', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87022', '19', '118445', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87022', '20', '118446', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87022', '21', '118447', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87022', '22', '118453', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87022', '23', '118454', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87022', '24', '118455', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87022', '25', '118456', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87022', '26', '118457', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87022', '27', '118458', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87022', '28', '118460', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87022', '29', '118461', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87022', '30', '118462', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87022', '31', '118463', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87022', '32', '118467', '0', '0', '0', '1');
Bild
Gerhard Reiss
Benutzeravatar
 
Beiträge: 121
Registriert: 02.2014
Geschlecht: nicht angegeben


Re: World of Draenor 6.2.X Skript

Beitragvon Gerhard Reiss » 29. Mai 2016 10:50

Ingenieurskunstlehrer
DELETE FROM `npc_trainer` WHERE entry='85918';

INSERT INTO `npc_trainer` VALUES ('85918', '3922', '115', '202', '30', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '3923', '130', '202', '30', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '3925', '150', '202', '50', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '3929', '250', '202', '65', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '3931', '250', '202', '65', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '3932', '300', '202', '85', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '3934', '400', '202', '100', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '3936', '420', '202', '105', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '3937', '450', '202', '105', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '3938', '450', '202', '105', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '3939', '500', '202', '120', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '3941', '500', '202', '120', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '3942', '500', '202', '125', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '3945', '500', '202', '125', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '3946', '500', '202', '125', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '3949', '550', '202', '130', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '3950', '600', '202', '140', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '3953', '600', '202', '145', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '3955', '750', '202', '150', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '3956', '750', '202', '150', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '3958', '800', '202', '160', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '3961', '900', '202', '170', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '3962', '1000', '202', '175', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '3963', '1000', '202', '175', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '3965', '1200', '202', '185', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '3967', '1400', '202', '190', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '3973', '300', '202', '90', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '3977', '200', '202', '60', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '3978', '475', '202', '110', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '3979', '1200', '202', '180', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '4036', '10', '0', '0', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '4037', '500', '202', '50', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '4038', '5000', '202', '125', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '6458', '400', '202', '135', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '7430', '150', '202', '50', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '8334', '300', '202', '100', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '8895', '2200', '202', '225', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '9271', '500', '202', '150', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '12584', '1000', '202', '150', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '12585', '1000', '202', '175', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '12586', '1000', '202', '175', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '12589', '1300', '202', '195', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '12590', '1000', '202', '175', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '12591', '1500', '202', '200', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '12594', '1600', '202', '205', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '12595', '1600', '202', '205', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '12599', '1800', '202', '215', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '12603', '1800', '202', '215', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '12615', '2500', '202', '225', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '12617', '2200', '202', '230', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '12618', '2200', '202', '230', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '12619', '2400', '202', '235', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '12622', '2800', '202', '245', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '12656', '50000', '202', '200', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '12715', '1000', '202', '205', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '12716', '1500', '202', '205', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '12717', '1500', '202', '205', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '12718', '1500', '202', '205', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '12754', '2600', '202', '235', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '12755', '2400', '202', '230', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '12758', '3000', '202', '245', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '12759', '2800', '202', '240', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '12760', '1500', '202', '205', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '12895', '1500', '202', '205', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '12897', '2200', '202', '215', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '12899', '1500', '202', '205', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '12902', '1800', '202', '210', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '12903', '2000', '202', '215', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '12905', '1500', '202', '210', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '12906', '2400', '202', '230', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '12907', '2600', '202', '235', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '12908', '2800', '202', '240', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '15255', '1500', '202', '200', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '19788', '4000', '202', '250', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '19790', '10000', '202', '260', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '19791', '5000', '202', '260', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '19792', '10000', '202', '260', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '19794', '20000', '202', '270', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '19795', '10000', '202', '275', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '19825', '20000', '202', '290', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '23070', '5000', '202', '250', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '23071', '5000', '202', '260', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '30303', '10000', '202', '300', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '30304', '10000', '202', '300', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '30305', '10000', '202', '300', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '30306', '20000', '202', '325', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '30307', '50000', '202', '340', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '30308', '50000', '202', '340', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '30309', '50000', '202', '340', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '30310', '15000', '202', '300', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '30311', '25000', '202', '325', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '30312', '20000', '202', '320', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '30350', '100000', '202', '275', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '30558', '25000', '202', '325', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '30560', '35000', '202', '340', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '30563', '50000', '202', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '30565', '100000', '202', '375', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '30566', '100000', '202', '375', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '30568', '25000', '202', '325', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '30569', '35000', '202', '340', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '30570', '50000', '202', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '30574', '100000', '202', '375', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '30575', '100000', '202', '375', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '39895', '10000', '202', '275', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '39971', '20000', '202', '335', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '40274', '50000', '202', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '41311', '60000', '202', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '44157', '180000', '202', '375', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '51306', '350000', '202', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '53281', '50000', '202', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '54353', '125000', '202', '400', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '54736', '100000', '202', '390', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '54793', '100000', '202', '380', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '55002', '100000', '202', '380', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '55016', '125000', '202', '405', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '56349', '50000', '202', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '56459', '100000', '202', '375', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '56460', '50000', '202', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '56461', '100000', '202', '375', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '56462', '150000', '202', '435', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '56463', '100000', '202', '375', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '56464', '100000', '202', '375', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '56465', '125000', '202', '420', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '56467', '125000', '202', '420', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '56468', '125000', '202', '405', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '56469', '150000', '202', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '56470', '150000', '202', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '56471', '100000', '202', '390', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '56472', '150000', '202', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '56473', '150000', '202', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '56476', '125000', '202', '410', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '56477', '125000', '202', '415', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '56478', '200000', '202', '430', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '56479', '200000', '202', '450', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '56480', '150000', '202', '440', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '56574', '200000', '202', '440', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '61471', '100000', '202', '390', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '61481', '5000', '202', '420', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '67326', '100000', '202', '410', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '67839', '100000', '202', '410', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '67920', '150000', '202', '435', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '81714', '500000', '202', '525', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '84403', '150000', '202', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '84406', '150000', '202', '440', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '84408', '150000', '202', '450', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '84409', '160000', '202', '455', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '84410', '150000', '202', '450', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '84411', '160000', '202', '465', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '84412', '160000', '202', '475', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '84413', '160000', '202', '475', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '84415', '170000', '202', '475', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '84416', '170000', '202', '475', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '84417', '170000', '202', '495', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '84418', '170000', '202', '475', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '84420', '170000', '202', '490', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '84421', '170000', '202', '490', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '84428', '200000', '202', '515', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '84429', '200000', '202', '505', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '84430', '200000', '202', '510', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '84431', '240000', '202', '525', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '84432', '240000', '202', '525', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '94748', '150000', '202', '445', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '95703', '150000', '202', '440', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '95705', '200000', '202', '500', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '95707', '200000', '202', '500', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '109099', '50000', '202', '550', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '110403', '600000', '202', '500', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '126392', '50000', '202', '550', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '127113', '50000', '202', '500', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '127114', '50000', '202', '500', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '127115', '50000', '202', '560', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '127116', '50000', '202', '525', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '127117', '50000', '202', '600', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '127127', '50000', '202', '525', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '127128', '50000', '202', '550', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '127129', '50000', '202', '600', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '127130', '50000', '202', '525', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '127131', '50000', '202', '550', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '127132', '50000', '202', '570', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '127134', '50000', '202', '550', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '127135', '50000', '202', '575', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '127136', '50000', '202', '525', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '127137', '50000', '202', '565', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '127138', '160000', '202', '600', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '127139', '160000', '202', '600', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '131211', '50000', '202', '550', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '131212', '50000', '202', '550', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '131213', '50000', '202', '550', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '131214', '50000', '202', '550', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '131215', '50000', '202', '550', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '131216', '50000', '202', '550', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '131217', '50000', '202', '550', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '131218', '50000', '202', '550', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '131353', '50000', '202', '500', '0');
INSERT INTO `npc_trainer` VALUES ('85918', '131563', '50000', '202', '550', '0');


Pläne für Ingenieurskunst
DELETE FROM `npc_vendor` WHERE entry='87065';

INSERT INTO `npc_vendor` VALUES ('87065', '0', '90146', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87065', '1', '111921', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87065', '2', '118476', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87065', '3', '118477', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87065', '4', '118478', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87065', '5', '118480', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87065', '6', '118481', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87065', '7', '118484', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87065', '8', '118485', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87065', '9', '118487', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87065', '10', '118488', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87065', '11', '118489', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87065', '12', '118490', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87065', '13', '118491', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87065', '14', '118492', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87065', '15', '118493', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87065', '16', '118495', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87065', '17', '118497', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87065', '18', '118498', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87065', '19', '118499', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87065', '20', '118500', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87065', '21', '119177', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87065', '22', '120267', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87065', '23', '120268', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87065', '24', '128327', '0', '0', '0', '1');


Erste Hilfe
DELETE FROM `npc_trainer` WHERE entry='85930';

INSERT INTO `npc_trainer` VALUES ('85930', '3273', '100', '0', '0', '0');
INSERT INTO `npc_trainer` VALUES ('85930', '3274', '500', '129', '50', '0');
INSERT INTO `npc_trainer` VALUES ('85930', '3276', '100', '129', '40', '0');
INSERT INTO `npc_trainer` VALUES ('85930', '3277', '250', '129', '80', '0');
INSERT INTO `npc_trainer` VALUES ('85930', '3278', '1000', '129', '115', '0');
INSERT INTO `npc_trainer` VALUES ('85930', '7924', '1000', '129', '125', '0');
INSERT INTO `npc_trainer` VALUES ('85930', '7928', '5000', '129', '150', '0');
INSERT INTO `npc_trainer` VALUES ('85930', '7929', '5000', '129', '180', '0');
INSERT INTO `npc_trainer` VALUES ('85930', '7934', '250', '129', '80', '0');
INSERT INTO `npc_trainer` VALUES ('85930', '10840', '10000', '129', '210', '0');
INSERT INTO `npc_trainer` VALUES ('85930', '10841', '10000', '129', '240', '0');
INSERT INTO `npc_trainer` VALUES ('85930', '10846', '25000', '129', '225', '0');
INSERT INTO `npc_trainer` VALUES ('85930', '18629', '20000', '129', '260', '0');
INSERT INTO `npc_trainer` VALUES ('85930', '18630', '20000', '129', '290', '0');
INSERT INTO `npc_trainer` VALUES ('85930', '27028', '100000', '129', '275', '0');
INSERT INTO `npc_trainer` VALUES ('85930', '27032', '20000', '129', '300', '0');
INSERT INTO `npc_trainer` VALUES ('85930', '27033', '40000', '129', '330', '0');
INSERT INTO `npc_trainer` VALUES ('85930', '45542', '150000', '129', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85930', '45545', '40000', '129', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85930', '45546', '60000', '129', '390', '0');
INSERT INTO `npc_trainer` VALUES ('85930', '74556', '60000', '129', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85930', '74557', '80000', '129', '475', '0');
INSERT INTO `npc_trainer` VALUES ('85930', '74558', '15000', '129', '525', '0');
INSERT INTO `npc_trainer` VALUES ('85930', '74559', '250000', '129', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85930', '88893', '80000', '129', '525', '0');
INSERT INTO `npc_trainer` VALUES ('85930', '102697', '90000', '129', '500', '0');
INSERT INTO `npc_trainer` VALUES ('85930', '102698', '110000', '129', '550', '0');
INSERT INTO `npc_trainer` VALUES ('85930', '110406', '300000', '129', '500', '0');


Angellehrer
DELETE FROM `npc_trainer` WHERE entry='85926';

INSERT INTO `npc_trainer` VALUES ('85926', '7620', '100', '356', '0', '1');
INSERT INTO `npc_trainer` VALUES ('85926', '7731', '500', '356', '50', '1');
INSERT INTO `npc_trainer` VALUES ('85926', '7732', '10000', '356', '125', '1');
INSERT INTO `npc_trainer` VALUES ('85926', '18248', '25000', '356', '200', '1');
INSERT INTO `npc_trainer` VALUES ('85926', '33095', '100000', '356', '275', '1');
INSERT INTO `npc_trainer` VALUES ('85926', '51294', '150000', '356', '350', '1');
INSERT INTO `npc_trainer` VALUES ('85926', '88868', '250000', '356', '425', '1');
INSERT INTO `npc_trainer` VALUES ('85926', '110410', '300000', '356', '500', '1');


Inschriftenkundelehrer
DELETE FROM `npc_trainer` WHERE entry='85911';

INSERT INTO `npc_trainer` VALUES ('85911', '45357', '10', '0', '0', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '45358', '500', '773', '50', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '45359', '5000', '773', '125', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '45360', '50000', '773', '200', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '45361', '100000', '773', '275', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '45363', '350000', '773', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '48247', '500', '773', '85', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '48248', '50', '773', '35', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '50598', '400', '773', '75', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '50599', '750', '773', '165', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '50600', '4500', '773', '215', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '50601', '10000', '773', '260', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '50602', '20000', '773', '300', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '50603', '50000', '773', '360', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '50604', '60000', '773', '410', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '50605', '400', '773', '75', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '50606', '750', '773', '160', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '50607', '4500', '773', '210', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '50608', '10000', '773', '255', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '50609', '20000', '773', '295', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '50610', '50000', '773', '355', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '50611', '60000', '773', '405', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '50612', '400', '773', '75', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '50614', '750', '773', '155', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '50616', '4500', '773', '205', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '50617', '10000', '773', '250', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '50618', '20000', '773', '290', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '50619', '50000', '773', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '50620', '60000', '773', '400', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '52739', '150', '773', '35', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '52843', '50', '773', '1', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '53462', '300', '773', '75', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '57703', '400', '773', '85', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '57704', '400', '773', '100', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '57706', '750', '773', '125', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '57707', '750', '773', '150', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '57708', '750', '773', '175', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '57709', '3000', '773', '200', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '57710', '6000', '773', '225', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '57711', '10000', '773', '250', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '57712', '10000', '773', '275', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '57713', '20000', '773', '290', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '57714', '20000', '773', '325', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '57715', '50000', '773', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '57716', '50000', '773', '375', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '58472', '50', '773', '15', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '58473', '400', '773', '85', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '58476', '750', '773', '175', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '58478', '4500', '773', '225', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '58480', '10000', '773', '270', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '58481', '20000', '773', '310', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '58482', '50000', '773', '370', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '58483', '60000', '773', '420', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '58484', '50', '773', '15', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '58485', '400', '773', '80', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '58486', '750', '773', '170', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '58487', '4500', '773', '220', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '58488', '10000', '773', '265', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '58489', '20000', '773', '305', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '58490', '50000', '773', '365', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '58491', '60000', '773', '415', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '58565', '500', '773', '85', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '59387', '3000', '773', '200', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '59475', '750', '773', '125', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '59478', '750', '773', '125', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '59480', '750', '773', '125', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '59484', '750', '773', '175', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '59486', '750', '773', '175', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '59487', '750', '773', '175', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '59489', '6000', '773', '225', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '59490', '6000', '773', '225', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '59491', '6000', '773', '225', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '59493', '10000', '773', '275', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '59494', '10000', '773', '275', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '59495', '20000', '773', '325', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '59496', '20000', '773', '325', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '59497', '60000', '773', '400', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '59498', '60000', '773', '400', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '59502', '10000', '773', '275', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '59503', '20000', '773', '325', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '59504', '60000', '773', '400', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '60336', '3000', '773', '200', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '60337', '50000', '773', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '61117', '75000', '773', '400', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '61118', '75000', '773', '400', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '61119', '75000', '773', '400', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '61120', '75000', '773', '400', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '64053', '50000', '773', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '69385', '120000', '773', '440', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '85785', '120000', '773', '500', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '86004', '80000', '773', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '86005', '90000', '773', '475', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '86008', '500000', '773', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '86375', '75000', '773', '500', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '86401', '75000', '773', '500', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '86402', '75000', '773', '500', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '86403', '75000', '773', '500', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '86609', '80000', '773', '450', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '86615', '200000', '773', '525', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '86616', '90000', '773', '475', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '86640', '90000', '773', '475', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '86641', '120000', '773', '510', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '86642', '120000', '773', '510', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '86643', '120000', '773', '510', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '86648', '90000', '773', '480', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '86649', '120000', '773', '505', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '86652', '150000', '773', '515', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '86653', '150000', '773', '515', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '89244', '100000', '773', '500', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '89368', '80000', '773', '445', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '89369', '80000', '773', '465', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '89370', '80000', '773', '470', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '89371', '80000', '773', '455', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '89372', '80000', '773', '460', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '89373', '80000', '773', '450', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '92026', '400', '773', '75', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '92027', '90000', '773', '475', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '110417', '600000', '773', '500', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '111645', '200000', '773', '500', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '111646', '200000', '773', '500', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '111830', '200000', '773', '600', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '111908', '200000', '773', '560', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '111909', '200000', '773', '560', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '111910', '200000', '773', '560', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '111917', '200000', '773', '560', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '111918', '200000', '773', '560', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '111919', '200000', '773', '560', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '111920', '200000', '773', '560', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '111921', '200000', '773', '560', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '112045', '200000', '773', '580', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '112883', '200000', '773', '500', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '112996', '500000', '773', '525', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '126988', '50000', '773', '600', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '126989', '50000', '773', '600', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '126994', '200000', '773', '570', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '126995', '200000', '773', '570', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '126996', '200000', '773', '570', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '126997', '200000', '773', '570', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '127007', '50000', '773', '600', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '127009', '50000', '773', '600', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '127016', '200000', '773', '540', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '127017', '200000', '773', '540', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '127018', '200000', '773', '540', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '127019', '200000', '773', '540', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '127020', '200000', '773', '575', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '127021', '200000', '773', '575', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '127023', '200000', '773', '575', '0');
INSERT INTO `npc_trainer` VALUES ('85911', '127024', '200000', '773', '575', '0');


Rezepte für Inschriftenkunde
DELETE FROM `npc_vendor` WHERE entry='87063';

INSERT INTO `npc_vendor` VALUES ('87063', '0', '38682', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87063', '1', '111923', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87063', '2', '118060', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87063', '3', '118061', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87063', '4', '118062', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87063', '5', '118063', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87063', '6', '118064', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87063', '7', '118605', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87063', '8', '118606', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87063', '9', '118607', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87063', '10', '118608', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87063', '11', '118610', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87063', '12', '118613', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87063', '13', '118614', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87063', '14', '118615', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87063', '15', '120265', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87063', '16', '120266', '0', '0', '0', '1');


Juwelierskunstlehrer
DELETE FROM `npc_trainer` WHERE entry='85916';

INSERT INTO `npc_trainer` VALUES ('85916', '25229', '10', '0', '0', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '25230', '500', '755', '50', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '25278', '200', '755', '50', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '25280', '200', '755', '50', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '25283', '100', '755', '30', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '25284', '400', '755', '60', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '25287', '400', '755', '70', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '25305', '1000', '755', '90', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '25317', '600', '755', '80', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '25318', '800', '755', '100', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '25321', '1500', '755', '120', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '25490', '300', '755', '50', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '25498', '600', '755', '110', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '25610', '1500', '755', '120', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '25612', '1500', '755', '125', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '25613', '1200', '755', '135', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '25615', '1500', '755', '150', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '25617', '1500', '755', '150', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '25620', '2000', '755', '170', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '25621', '2000', '755', '180', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '26872', '2500', '755', '200', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '26874', '5000', '755', '210', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '26876', '3000', '755', '220', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '26880', '3500', '755', '225', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '26883', '4000', '755', '235', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '26885', '5000', '755', '240', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '26902', '10000', '755', '260', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '26903', '10000', '755', '275', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '26907', '10000', '755', '280', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '26908', '12000', '755', '280', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '26911', '15000', '755', '290', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '26916', '20000', '755', '310', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '26926', '50', '755', '5', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '26927', '300', '755', '50', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '26928', '100', '755', '30', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '28894', '5000', '755', '125', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '28895', '50000', '755', '200', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '28897', '100000', '755', '275', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '28905', '10000', '755', '300', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '28910', '10000', '755', '300', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '28914', '10000', '755', '315', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '28916', '10000', '755', '300', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '28917', '10000', '755', '300', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '28925', '10000', '755', '300', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '28936', '10000', '755', '325', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '28948', '10000', '755', '325', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '28950', '10000', '755', '300', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '28953', '10000', '755', '300', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '31048', '20000', '755', '305', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '31049', '20000', '755', '305', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '31050', '25000', '755', '320', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '31051', '30000', '755', '335', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '31052', '30000', '755', '335', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '31252', '100', '755', '20', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '32178', '100', '755', '20', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '32179', '100', '755', '20', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '32801', '200', '755', '50', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '32807', '600', '755', '110', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '32808', '2000', '755', '175', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '32809', '3500', '755', '225', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '34590', '10000', '755', '300', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '34955', '2500', '755', '180', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '34959', '3000', '755', '200', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '34960', '10000', '755', '280', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '34961', '10000', '755', '290', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '36523', '600', '755', '75', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '36524', '800', '755', '105', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '36525', '4000', '755', '230', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '36526', '10000', '755', '265', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '37818', '500', '755', '65', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '38068', '20000', '755', '325', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '38175', '650', '755', '80', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '40514', '8500', '755', '340', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '41414', '10000', '755', '325', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '41415', '10000', '755', '330', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '41418', '30000', '755', '365', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '41420', '8500', '755', '325', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '41429', '10000', '755', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '47280', '30000', '755', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '51311', '350000', '755', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '53831', '10000', '755', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '53832', '10000', '755', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '53843', '10000', '755', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '53844', '10000', '755', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '53845', '10000', '755', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '53852', '10000', '755', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '53854', '10000', '755', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '53856', '10000', '755', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '53859', '10000', '755', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '53860', '10000', '755', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '53861', '10000', '755', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '53870', '10000', '755', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '53871', '10000', '755', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '53872', '10000', '755', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '53873', '10000', '755', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '53874', '10000', '755', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '53876', '10000', '755', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '53880', '10000', '755', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '53882', '10000', '755', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '53883', '10000', '755', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '53891', '10000', '755', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '53892', '10000', '755', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '53893', '10000', '755', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '53894', '10000', '755', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '53918', '10000', '755', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '53920', '10000', '755', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '53922', '10000', '755', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '53923', '10000', '755', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '53925', '10000', '755', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '53934', '10000', '755', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '53941', '10000', '755', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '54017', '10000', '755', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '55386', '120000', '755', '420', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '55394', '120000', '755', '420', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '55399', '120000', '755', '420', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '55402', '120000', '755', '420', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '56193', '10000', '755', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '56194', '10000', '755', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '56195', '120000', '755', '380', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '56196', '80000', '755', '380', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '56197', '100000', '755', '420', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '56199', '150000', '755', '400', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '56201', '150000', '755', '400', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '56202', '150000', '755', '400', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '56203', '150000', '755', '400', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '56205', '10000', '755', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '56206', '10000', '755', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '56208', '10000', '755', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '56530', '10000', '755', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '56531', '100000', '755', '390', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '58141', '30000', '755', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '58142', '30000', '755', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '58143', '30000', '755', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '58144', '30000', '755', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '58145', '50000', '755', '390', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '58146', '50000', '755', '390', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '59759', '150000', '755', '400', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '62242', '150000', '755', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '62941', '10000', '755', '300', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '63743', '3000', '755', '200', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '64725', '100000', '755', '420', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '64726', '100000', '755', '420', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '64727', '100000', '755', '420', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '64728', '100000', '755', '420', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '73222', '30000', '755', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '73223', '30000', '755', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '73225', '30000', '755', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '73226', '30000', '755', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '73227', '30000', '755', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '73228', '30000', '755', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '73230', '30000', '755', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '73232', '30000', '755', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '73234', '30000', '755', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '73239', '30000', '755', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '73240', '30000', '755', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '73241', '30000', '755', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '73243', '30000', '755', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '73246', '30000', '755', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '73247', '30000', '755', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '73249', '30000', '755', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '73250', '30000', '755', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '73266', '30000', '755', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '73267', '30000', '755', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '73268', '30000', '755', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '73270', '30000', '755', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '73274', '30000', '755', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '73279', '30000', '755', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '73281', '30000', '755', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '73318', '500000', '755', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '73478', '30000', '755', '500', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '73494', '30000', '755', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '73495', '30000', '755', '450', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '73496', '30000', '755', '435', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '73497', '30000', '755', '460', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '73620', '30000', '755', '460', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '73621', '30000', '755', '490', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '73622', '30000', '755', '435', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '99539', '40000', '755', '510', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '99540', '40000', '755', '510', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '99541', '40000', '755', '510', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '99542', '45000', '755', '520', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '99543', '45000', '755', '520', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '99544', '45000', '755', '520', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '107598', '40000', '755', '550', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '107599', '40000', '755', '550', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '107600', '40000', '755', '560', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '107601', '40000', '755', '565', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '107602', '40000', '755', '530', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '107604', '40000', '755', '525', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '107605', '40000', '755', '540', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '107606', '40000', '755', '530', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '107607', '40000', '755', '555', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '107608', '40000', '755', '570', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '107609', '40000', '755', '575', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '107610', '40000', '755', '535', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '107611', '40000', '755', '545', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '107612', '40000', '755', '540', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '107613', '40000', '755', '555', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '107614', '40000', '755', '545', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '107615', '40000', '755', '525', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '107616', '40000', '755', '535', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '107617', '40000', '755', '525', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '107619', '40000', '755', '535', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '107620', '40000', '755', '545', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '107621', '40000', '755', '555', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '107622', '40000', '755', '570', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '107623', '40000', '755', '560', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '107624', '40000', '755', '530', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '107625', '40000', '755', '550', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '107626', '40000', '755', '540', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '107627', '40000', '755', '550', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '107628', '40000', '755', '555', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '107630', '40000', '755', '525', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '107631', '40000', '755', '540', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '107632', '40000', '755', '545', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '107633', '40000', '755', '525', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '107634', '40000', '755', '565', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '107635', '40000', '755', '575', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '107636', '40000', '755', '535', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '107637', '40000', '755', '535', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '107638', '40000', '755', '560', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '107639', '40000', '755', '530', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '107640', '40000', '755', '535', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '107641', '40000', '755', '545', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '107642', '40000', '755', '555', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '107643', '40000', '755', '565', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '107644', '40000', '755', '575', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '107645', '40000', '755', '550', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '107646', '40000', '755', '525', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '107647', '40000', '755', '545', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '107648', '40000', '755', '565', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '107649', '40000', '755', '525', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '107650', '40000', '755', '530', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '107651', '40000', '755', '555', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '107652', '40000', '755', '535', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '107653', '40000', '755', '555', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '107654', '40000', '755', '530', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '107655', '40000', '755', '540', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '107656', '40000', '755', '545', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '107657', '40000', '755', '560', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '107658', '40000', '755', '540', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '107659', '40000', '755', '575', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '107660', '40000', '755', '575', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '107661', '40000', '755', '560', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '107662', '40000', '755', '570', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '107663', '40000', '755', '565', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '107665', '40000', '755', '550', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '107666', '40000', '755', '570', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '107667', '40000', '755', '535', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '110420', '600000', '755', '500', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '122661', '40000', '755', '500', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '122662', '40000', '755', '510', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '122663', '40000', '755', '525', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '130655', '40000', '755', '570', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '130656', '40000', '755', '530', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '131593', '40000', '755', '525', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '131686', '40000', '755', '550', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '131688', '40000', '755', '535', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '131690', '40000', '755', '535', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '131691', '40000', '755', '545', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '131695', '40000', '755', '525', '0');
INSERT INTO `npc_trainer` VALUES ('85916', '131759', '40000', '755', '550', '0');
Bild
Gerhard Reiss
Benutzeravatar
 
Beiträge: 121
Registriert: 02.2014
Geschlecht: nicht angegeben


Re: World of Draenor 6.2.X Skript

Beitragvon Gerhard Reiss » 29. Mai 2016 10:50

Juwelenschliffdesigns
DELETE FROM `npc_vendor` WHERE entry='87052';

INSERT INTO `npc_vendor` VALUES ('87052', '0', '52188', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87052', '1', '115359', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87052', '2', '116078', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87052', '3', '116079', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87052', '4', '116080', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87052', '5', '116090', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87052', '6', '116091', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87052', '7', '116092', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87052', '8', '116093', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87052', '9', '116094', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87052', '10', '116095', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87052', '11', '116096', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87052', '12', '116097', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87052', '13', '116098', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87052', '14', '116099', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87052', '15', '116100', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87052', '16', '116101', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87052', '17', '116102', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87052', '18', '116103', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87052', '19', '116104', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87052', '20', '116105', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87052', '21', '116106', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87052', '22', '116107', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87052', '23', '116108', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87052', '24', '116109', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87052', '25', '116111', '0', '0', '0', '1');


Lederverarbeitungslehrer
DELETE FROM `npc_trainer` WHERE entry='85920';

INSERT INTO `npc_trainer` VALUES ('85920', '2108', '10', '0', '0', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '2153', '50', '165', '15', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '2159', '250', '165', '85', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '2160', '100', '165', '40', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '2161', '100', '165', '55', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '2162', '100', '165', '60', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '2165', '250', '165', '100', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '2166', '450', '165', '120', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '2167', '350', '165', '100', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '2168', '350', '165', '110', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '3104', '500', '165', '50', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '3753', '75', '165', '25', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '3756', '150', '165', '55', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '3759', '200', '165', '75', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '3760', '600', '165', '150', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '3761', '350', '165', '85', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '3763', '300', '165', '80', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '3764', '500', '165', '145', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '3766', '400', '165', '125', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '3768', '500', '165', '130', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '3770', '500', '165', '135', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '3774', '1000', '165', '160', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '3776', '1200', '165', '180', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '3780', '750', '165', '150', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '3811', '5000', '165', '125', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '3816', '50', '165', '35', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '3817', '200', '165', '100', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '3818', '500', '165', '150', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '6661', '2000', '165', '190', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '7135', '400', '165', '115', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '7147', '1000', '165', '160', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '7151', '1200', '165', '175', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '7156', '2400', '165', '190', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '9065', '150', '165', '70', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '9068', '400', '165', '95', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '9074', '500', '165', '120', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '9145', '500', '165', '125', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '9196', '1500', '165', '175', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '9198', '2000', '165', '180', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '9201', '2000', '165', '185', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '9206', '2500', '165', '195', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '10482', '2000', '165', '200', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '10487', '2000', '165', '200', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '10499', '3000', '165', '205', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '10507', '3000', '165', '205', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '10511', '3000', '165', '210', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '10518', '3500', '165', '210', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '10548', '4000', '165', '230', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '10552', '4000', '165', '230', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '10556', '4500', '165', '235', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '10558', '4500', '165', '235', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '10630', '10000', '165', '230', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '10632', '10000', '165', '250', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '10647', '10000', '165', '250', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '10650', '10000', '165', '255', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '10662', '50000', '165', '200', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '19047', '5000', '165', '250', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '19052', '10000', '165', '265', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '19055', '10000', '165', '270', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '19058', '5000', '165', '250', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '19065', '10000', '165', '275', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '19071', '10000', '165', '280', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '19072', '10000', '165', '280', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '19082', '15000', '165', '290', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '19083', '15000', '165', '290', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '19091', '15000', '165', '300', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '19092', '15000', '165', '300', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '19098', '15000', '165', '300', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '19102', '15000', '165', '300', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '19103', '15000', '165', '300', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '20648', '500', '165', '100', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '20649', '1000', '165', '150', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '20650', '4000', '165', '200', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '22331', '5000', '165', '250', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '24654', '50000', '165', '300', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '24655', '30000', '165', '280', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '32454', '10000', '165', '300', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '32455', '20000', '165', '325', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '32456', '15000', '165', '300', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '32462', '15000', '165', '300', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '32463', '18000', '165', '310', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '32464', '20000', '165', '320', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '32465', '25000', '165', '335', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '32466', '15000', '165', '300', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '32467', '18000', '165', '310', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '32468', '20000', '165', '325', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '32469', '25000', '165', '335', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '32470', '15000', '165', '300', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '32471', '18000', '165', '315', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '32472', '20000', '165', '320', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '32473', '25000', '165', '330', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '32478', '15000', '165', '300', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '32479', '18000', '165', '310', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '32480', '20000', '165', '320', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '32481', '25000', '165', '330', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '32549', '100000', '165', '275', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '35540', '20000', '165', '340', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '36074', '10000', '165', '260', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '36075', '10000', '165', '260', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '36076', '10000', '165', '260', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '36077', '40000', '165', '330', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '36078', '40000', '165', '330', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '36079', '40000', '165', '330', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '44770', '50000', '165', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '44970', '50000', '165', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '45100', '15000', '165', '300', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '50936', '80000', '165', '390', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '50938', '30000', '165', '375', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '50939', '30000', '165', '370', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '50940', '30000', '165', '380', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '50941', '30000', '165', '370', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '50942', '30000', '165', '375', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '50943', '30000', '165', '380', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '50944', '30000', '165', '370', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '50945', '30000', '165', '375', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '50946', '30000', '165', '380', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '50947', '30000', '165', '375', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '50948', '30000', '165', '370', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '50949', '30000', '165', '380', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '50950', '30000', '165', '375', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '50951', '30000', '165', '370', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '50952', '30000', '165', '375', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '50953', '30000', '165', '380', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '50954', '30000', '165', '380', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '50955', '30000', '165', '370', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '50956', '30000', '165', '375', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '50957', '30000', '165', '370', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '50958', '30000', '165', '380', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '50959', '30000', '165', '370', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '50960', '30000', '165', '380', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '50961', '30000', '165', '375', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '50962', '50000', '165', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '50963', '80000', '165', '395', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '50964', '50000', '165', '405', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '50965', '80000', '165', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '50966', '50000', '165', '400', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '50967', '80000', '165', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '51302', '350000', '165', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '51568', '100000', '165', '400', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '51569', '80000', '165', '395', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '51570', '80000', '165', '395', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '51571', '30000', '165', '385', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '51572', '30000', '165', '385', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '55199', '80000', '165', '395', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '60599', '30000', '165', '385', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '60600', '30000', '165', '385', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '60601', '80000', '165', '395', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '60604', '80000', '165', '395', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '60605', '100000', '165', '400', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '60607', '30000', '165', '385', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '60608', '30000', '165', '385', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '60611', '80000', '165', '395', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '60613', '80000', '165', '395', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '60620', '100000', '165', '400', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '60622', '30000', '165', '385', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '60624', '30000', '165', '385', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '60627', '80000', '165', '395', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '60629', '80000', '165', '395', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '60630', '80000', '165', '400', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '60631', '80000', '165', '380', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '60637', '200000', '165', '440', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '60640', '200000', '165', '440', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '60643', '50000', '165', '415', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '60649', '100000', '165', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '60651', '100000', '165', '420', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '60652', '100000', '165', '420', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '60655', '200000', '165', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '60658', '200000', '165', '420', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '60660', '100000', '165', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '60665', '100000', '165', '420', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '60666', '80000', '165', '420', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '60669', '100000', '165', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '60671', '100000', '165', '420', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '62448', '80000', '165', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '64661', '50000', '165', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '69386', '200000', '165', '450', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '69388', '200000', '165', '450', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '78379', '75000', '165', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '78380', '75000', '165', '460', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '78388', '75000', '165', '460', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '78396', '75000', '165', '470', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '78398', '75000', '165', '450', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '78399', '75000', '165', '465', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '78405', '75000', '165', '470', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '78406', '85000', '165', '475', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '78407', '75000', '165', '465', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '78410', '75000', '165', '450', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '78411', '85000', '165', '475', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '78415', '75000', '165', '455', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '78416', '75000', '165', '455', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '78419', '85000', '165', '475', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '78420', '85000', '165', '480', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '78423', '85000', '165', '490', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '78424', '85000', '165', '490', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '78427', '85000', '165', '480', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '78428', '85000', '165', '480', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '78432', '85000', '165', '485', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '78433', '85000', '165', '485', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '78436', '85000', '165', '485', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '78437', '85000', '165', '485', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '78438', '85000', '165', '495', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '78439', '85000', '165', '495', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '81199', '500000', '165', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '84950', '75000', '165', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '99535', '100000', '165', '500', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '99536', '100000', '165', '500', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '110423', '600000', '165', '500', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '124124', '50000', '165', '545', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '124125', '50000', '165', '555', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '124126', '50000', '165', '535', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '124567', '70000', '165', '400', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '124568', '70000', '165', '400', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '124569', '70000', '165', '400', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '124571', '50000', '165', '555', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '124572', '50000', '165', '540', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '124573', '50000', '165', '560', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '124574', '50000', '165', '545', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '124575', '50000', '165', '550', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '124576', '50000', '165', '530', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '124577', '50000', '165', '525', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '124578', '50000', '165', '535', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '124579', '50000', '165', '550', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '124580', '50000', '165', '545', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '124581', '50000', '165', '555', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '124582', '50000', '165', '540', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '124583', '50000', '165', '560', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '124584', '50000', '165', '525', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '124585', '50000', '165', '535', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '124586', '50000', '165', '530', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '124627', '50000', '165', '500', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '124628', '50000', '165', '525', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '124635', '50000', '165', '555', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '124636', '50000', '165', '550', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '124637', '50000', '165', '560', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '131865', '50000', '165', '550', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '163216', '75000', '165', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '163218', '75000', '165', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '163220', '50000', '165', '500', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '163222', '50000', '165', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '163223', '50000', '165', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '163224', '50000', '165', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '163225', '10000', '165', '300', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '163226', '10000', '165', '300', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '163228', '10000', '165', '300', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '163229', '10000', '165', '300', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '163230', '10000', '165', '300', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '163231', '10000', '165', '300', '0');
INSERT INTO `npc_trainer` VALUES ('85920', '163232', '10000', '165', '300', '0');


Schnittmuster für Lederverarbeitung
DELETE FROM `npc_vendor` WHERE entry='87057';

INSERT INTO `npc_vendor` VALUES ('87057', '0', '115358', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87057', '1', '116325', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87057', '2', '116326', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87057', '3', '116327', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87057', '4', '116328', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87057', '5', '116329', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87057', '6', '116330', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87057', '7', '116331', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87057', '8', '116332', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87057', '9', '116333', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87057', '10', '116334', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87057', '11', '116335', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87057', '12', '116336', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87057', '13', '116337', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87057', '14', '116338', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87057', '15', '116339', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87057', '16', '116340', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87057', '17', '116341', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87057', '18', '116342', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87057', '19', '116343', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87057', '20', '116344', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87057', '21', '116345', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87057', '22', '116346', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87057', '23', '116347', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87057', '24', '116348', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87057', '25', '116349', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87057', '26', '116350', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87057', '27', '116376', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87057', '28', '120258', '0', '0', '0', '1');


Bergbaulehrer
DELETE FROM `npc_trainer` WHERE entry='85919';

INSERT INTO `npc_trainer` VALUES ('85919', '2575', '10', '0', '0', '0');
INSERT INTO `npc_trainer` VALUES ('85919', '2576', '500', '186', '50', '0');
INSERT INTO `npc_trainer` VALUES ('85919', '2658', '200', '186', '65', '0');
INSERT INTO `npc_trainer` VALUES ('85919', '2659', '200', '186', '50', '0');
INSERT INTO `npc_trainer` VALUES ('85919', '3304', '50', '186', '50', '0');
INSERT INTO `npc_trainer` VALUES ('85919', '3307', '500', '186', '100', '0');
INSERT INTO `npc_trainer` VALUES ('85919', '3308', '600', '186', '115', '0');
INSERT INTO `npc_trainer` VALUES ('85919', '3564', '5000', '186', '125', '0');
INSERT INTO `npc_trainer` VALUES ('85919', '3569', '750', '186', '125', '0');
INSERT INTO `npc_trainer` VALUES ('85919', '10097', '5000', '186', '150', '0');
INSERT INTO `npc_trainer` VALUES ('85919', '10098', '10000', '186', '165', '0');
INSERT INTO `npc_trainer` VALUES ('85919', '10248', '50000', '186', '200', '0');
INSERT INTO `npc_trainer` VALUES ('85919', '16153', '20000', '186', '230', '0');
INSERT INTO `npc_trainer` VALUES ('85919', '29354', '100000', '186', '275', '0');
INSERT INTO `npc_trainer` VALUES ('85919', '29356', '40000', '186', '275', '0');
INSERT INTO `npc_trainer` VALUES ('85919', '29358', '40000', '186', '325', '0');
INSERT INTO `npc_trainer` VALUES ('85919', '29359', '40000', '186', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85919', '29360', '40000', '186', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85919', '29361', '100000', '186', '375', '0');
INSERT INTO `npc_trainer` VALUES ('85919', '29686', '100000', '186', '375', '0');
INSERT INTO `npc_trainer` VALUES ('85919', '35750', '10000', '186', '300', '0');
INSERT INTO `npc_trainer` VALUES ('85919', '35751', '10000', '186', '300', '0');
INSERT INTO `npc_trainer` VALUES ('85919', '49252', '100000', '186', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85919', '49258', '150000', '186', '400', '0');
INSERT INTO `npc_trainer` VALUES ('85919', '50310', '350000', '186', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85919', '55208', '200000', '186', '450', '0');
INSERT INTO `npc_trainer` VALUES ('85919', '55211', '200000', '186', '450', '0');
INSERT INTO `npc_trainer` VALUES ('85919', '70524', '10000', '186', '250', '0');
INSERT INTO `npc_trainer` VALUES ('85919', '74517', '500000', '186', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85919', '74529', '50000', '186', '525', '0');
INSERT INTO `npc_trainer` VALUES ('85919', '74530', '50000', '186', '475', '0');
INSERT INTO `npc_trainer` VALUES ('85919', '74537', '50000', '186', '500', '0');
INSERT INTO `npc_trainer` VALUES ('85919', '84038', '50000', '186', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85919', '102161', '600000', '186', '500', '0');
INSERT INTO `npc_trainer` VALUES ('85919', '102165', '60000', '186', '500', '0');
INSERT INTO `npc_trainer` VALUES ('85919', '102167', '60000', '186', '600', '0');


Kürschnerlehrer
DELETE FROM `npc_trainer` WHERE entry='85923';

INSERT INTO `npc_trainer` VALUES ('85923', '8613', '10', '0', '0', '0');
INSERT INTO `npc_trainer` VALUES ('85923', '8617', '500', '393', '50', '0');
INSERT INTO `npc_trainer` VALUES ('85923', '8618', '5000', '393', '125', '0');
INSERT INTO `npc_trainer` VALUES ('85923', '10768', '50000', '393', '200', '0');
INSERT INTO `npc_trainer` VALUES ('85923', '32678', '100000', '393', '275', '0');
INSERT INTO `npc_trainer` VALUES ('85923', '50305', '350000', '393', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85923', '74522', '500000', '393', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85923', '102216', '600000', '393', '500', '0');


Schneiderlehrer
DELETE FROM `npc_trainer` WHERE entry='85910';

INSERT INTO `npc_trainer` VALUES ('85910', '2385', '50', '197', '10', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '2386', '200', '197', '65', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '2392', '50', '197', '40', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '2393', '25', '197', '1', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '2394', '50', '197', '40', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '2395', '300', '197', '70', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '2396', '200', '197', '70', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '2397', '200', '197', '60', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '2399', '300', '197', '85', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '2401', '300', '197', '95', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '2402', '250', '197', '75', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '2406', '200', '197', '100', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '2964', '100', '197', '75', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '3755', '100', '197', '45', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '3757', '200', '197', '80', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '3813', '800', '197', '150', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '3839', '500', '197', '125', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '3840', '100', '197', '35', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '3841', '200', '197', '60', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '3842', '300', '197', '70', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '3843', '400', '197', '85', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '3845', '300', '197', '80', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '3848', '500', '197', '110', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '3850', '500', '197', '110', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '3852', '750', '197', '130', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '3855', '750', '197', '125', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '3859', '750', '197', '150', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '3861', '1000', '197', '185', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '3865', '1000', '197', '175', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '3866', '250', '197', '110', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '3871', '500', '197', '170', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '3908', '10', '0', '0', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '3909', '500', '197', '50', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '3910', '5000', '197', '125', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '3914', '50', '197', '30', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '6521', '400', '197', '90', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '6690', '1000', '197', '135', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '7623', '50', '197', '30', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '7624', '50', '197', '30', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '8465', '50', '197', '40', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '8467', '250', '197', '110', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '8483', '500', '197', '160', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '8489', '750', '197', '175', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '8758', '600', '197', '140', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '8760', '600', '197', '145', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '8762', '750', '197', '160', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '8764', '900', '197', '170', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '8766', '1000', '197', '175', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '8770', '1000', '197', '190', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '8772', '1000', '197', '175', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '8774', '1000', '197', '180', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '8776', '50', '197', '15', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '8791', '2500', '197', '185', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '8799', '3000', '197', '195', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '8804', '5000', '197', '210', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '12045', '50', '197', '20', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '12046', '300', '197', '75', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '12048', '4000', '197', '205', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '12049', '4000', '197', '205', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '12050', '4000', '197', '210', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '12052', '5000', '197', '210', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '12053', '5000', '197', '215', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '12055', '5500', '197', '215', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '12061', '2500', '197', '215', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '12065', '5000', '197', '225', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '12067', '5000', '197', '225', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '12069', '5000', '197', '225', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '12070', '5000', '197', '225', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '12071', '6000', '197', '225', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '12072', '6000', '197', '230', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '12073', '6000', '197', '230', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '12074', '6000', '197', '230', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '12076', '6500', '197', '235', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '12077', '5000', '197', '235', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '12079', '6500', '197', '235', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '12082', '7000', '197', '240', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '12088', '7500', '197', '245', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '12092', '7500', '197', '250', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '12180', '50000', '197', '200', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '18401', '10000', '197', '250', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '18402', '10000', '197', '255', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '18403', '10000', '197', '255', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '18406', '10000', '197', '260', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '18407', '10000', '197', '260', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '18409', '10000', '197', '265', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '18410', '10000', '197', '265', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '18411', '10000', '197', '265', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '18413', '10000', '197', '270', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '18414', '10000', '197', '270', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '18415', '10000', '197', '270', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '18416', '12500', '197', '275', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '18417', '12500', '197', '275', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '18420', '12500', '197', '275', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '18421', '12500', '197', '275', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '18423', '15000', '197', '280', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '18424', '15000', '197', '280', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '18437', '15000', '197', '285', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '18438', '15000', '197', '285', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '18441', '15000', '197', '290', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '18442', '15000', '197', '290', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '18444', '15000', '197', '295', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '18446', '15000', '197', '300', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '18449', '15000', '197', '300', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '18450', '15000', '197', '300', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '18451', '15000', '197', '300', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '18453', '15000', '197', '300', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '26745', '15000', '197', '300', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '26746', '15000', '197', '315', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '26764', '15000', '197', '310', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '26765', '15000', '197', '310', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '26770', '20000', '197', '320', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '26771', '20000', '197', '325', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '26772', '20000', '197', '335', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '26790', '100000', '197', '275', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '31460', '15000', '197', '300', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '51309', '350000', '197', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '55898', '50000', '197', '360', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '55899', '50000', '197', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '55900', '125000', '197', '400', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '55901', '50000', '197', '395', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '55902', '50000', '197', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '55903', '50000', '197', '360', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '55904', '50000', '197', '360', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '55906', '50000', '197', '375', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '55907', '50000', '197', '380', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '55908', '50000', '197', '370', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '55910', '80000', '197', '385', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '55911', '80000', '197', '390', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '55913', '80000', '197', '385', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '55914', '50000', '197', '395', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '55919', '100000', '197', '395', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '55920', '50000', '197', '400', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '55921', '100000', '197', '405', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '55922', '100000', '197', '405', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '55923', '100000', '197', '410', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '55924', '125000', '197', '410', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '55925', '125000', '197', '415', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '55941', '125000', '197', '420', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '55943', '125000', '197', '415', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '55995', '50000', '197', '400', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '56000', '50000', '197', '400', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '56001', '100000', '197', '415', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '56002', '100000', '197', '415', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '56003', '100000', '197', '415', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '56007', '80000', '197', '410', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '56008', '100000', '197', '400', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '56010', '100000', '197', '400', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '56014', '100000', '197', '390', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '56015', '100000', '197', '395', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '56018', '100000', '197', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '56019', '100000', '197', '420', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '56020', '100000', '197', '420', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '56021', '100000', '197', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '56022', '100000', '197', '420', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '56023', '100000', '197', '420', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '56024', '200000', '197', '440', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '56025', '200000', '197', '435', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '56026', '200000', '197', '440', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '56027', '200000', '197', '435', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '56028', '200000', '197', '440', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '56029', '200000', '197', '435', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '56030', '50000', '197', '380', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '56031', '50000', '197', '350', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '56034', '100000', '197', '405', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '56039', '100000', '197', '405', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '59582', '100000', '197', '415', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '59583', '100000', '197', '415', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '59584', '100000', '197', '420', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '59585', '100000', '197', '420', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '59586', '100000', '197', '420', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '59587', '100000', '197', '420', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '59588', '120000', '197', '420', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '59589', '120000', '197', '420', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '60969', '15000', '197', '300', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '60971', '150000', '197', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '60990', '180000', '197', '420', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '60993', '180000', '197', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '60994', '180000', '197', '420', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '63742', '750', '197', '125', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '64729', '100000', '197', '400', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '64730', '100000', '197', '405', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '74964', '100000', '197', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '75141', '150000', '197', '515', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '75142', '150000', '197', '505', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '75144', '150000', '197', '500', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '75145', '150000', '197', '510', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '75146', '150000', '197', '500', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '75156', '500000', '197', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '75247', '100000', '197', '425', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '75248', '120000', '197', '445', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '75249', '120000', '197', '445', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '75250', '120000', '197', '450', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '75251', '120000', '197', '455', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '75252', '120000', '197', '455', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '75253', '120000', '197', '460', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '75254', '120000', '197', '460', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '75255', '120000', '197', '460', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '75256', '120000', '197', '465', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '75257', '120000', '197', '465', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '75258', '120000', '197', '470', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '75259', '120000', '197', '470', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '75260', '120000', '197', '475', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '75261', '120000', '197', '475', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '75262', '150000', '197', '480', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '75263', '150000', '197', '480', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '75264', '150000', '197', '480', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '75265', '150000', '197', '480', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '75266', '150000', '197', '485', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '75267', '150000', '197', '485', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '75268', '150000', '197', '490', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '75269', '180000', '197', '510', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '75270', '150000', '197', '500', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '75290', '150000', '197', '500', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '75291', '180000', '197', '505', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '75292', '180000', '197', '510', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '75293', '180000', '197', '510', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '75294', '180000', '197', '515', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '75295', '180000', '197', '515', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '75296', '180000', '197', '520', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '75297', '180000', '197', '520', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '94743', '240000', '197', '525', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '99537', '150000', '197', '490', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '110426', '600000', '197', '500', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '125523', '24000', '197', '555', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '125524', '24000', '197', '535', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '125525', '24000', '197', '555', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '125526', '24000', '197', '525', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '125527', '24000', '197', '545', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '125528', '24000', '197', '525', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '125529', '24000', '197', '545', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '125530', '24000', '197', '535', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '125551', '24000', '197', '500', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '125552', '24000', '197', '530', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '125553', '24000', '197', '540', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '125557', '24000', '197', '550', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '130325', '24000', '197', '560', '0');
INSERT INTO `npc_trainer` VALUES ('85910', '134585', '180000', '197', '515', '0');


Schneider Schnittmuster
DELETE FROM `npc_vendor` WHERE entry='87049';

INSERT INTO `npc_vendor` VALUES ('87049', '0', '114852', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87049', '1', '114853', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87049', '2', '114854', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87049', '3', '114855', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87049', '4', '114856', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87049', '5', '114857', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87049', '6', '114858', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87049', '7', '114859', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87049', '8', '114860', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87049', '9', '114861', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87049', '10', '114862', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87049', '11', '114863', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87049', '12', '114864', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87049', '13', '114865', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87049', '14', '114866', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87049', '15', '114871', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87049', '16', '114872', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87049', '17', '114970', '0', '0', '0', '1');
INSERT INTO `npc_vendor` VALUES ('87049', '18', '115357', '0', '0', '0', '1');
Bild
Gerhard Reiss
Benutzeravatar
 
Beiträge: 121
Registriert: 02.2014
Geschlecht: nicht angegeben


Re: World of Draenor 6.2.X Skript

Beitragvon Gerhard Reiss » 29. Mai 2016 12:03

Moin

An Scripte kann ich euch noch anbieten :

Kompletter Spawn von ganz Draenor einschlieslich Dungeons und Raids als Sniffs.
Kompletter Loot von ganz Draenor einschlieslich Dungeons und Raids.
Auf Wunsch auch Smart Scripts.

Allerdings gebe ich euch die Sachen nicht einfach so. Ich möchte auch was von euch dafür sehen.
Uns fehlt noch die Fraktionsauswahl im Pandastartgebiet.
Die zuweisung der Friedhöfe in manchen Gebieten damit man nicht wen man stirbt in Westfahl rauskommt.
Der Haustierkampf usw.

Wenn ihr was zum Tauschen habt könnt ihr uns ansprechen.
Bild
Gerhard Reiss
Benutzeravatar
 
Beiträge: 121
Registriert: 02.2014
Geschlecht: nicht angegeben


Re: World of Draenor 6.2.X Skript

Beitragvon canewadar2 » 29. Mai 2016 19:56

Ich mach euch die Friedhöfe
canewadar2
 
Beiträge: 9
Registriert: 01.2016
Geschlecht: nicht angegeben


Re: World of Draenor 6.2.X Skript

Beitragvon braincore » 29. Jul 2016 22:03

Hallo erst einmal von mir ::) - Habe meine Schüchternheit Überwunden :D - und melde mich mal.

Benötigt ihr noch das Script von den Pandaren? Wo man die Fraktion auswählen kann? Falls ja ich kann es euch gerne geben :)

LG
Brain
braincore
 
Beiträge: 5
Registriert: 11.2014
Geschlecht: nicht angegeben


Re: World of Draenor 6.2.X Skript

Beitragvon Bully » 30. Jul 2016 00:32

hi

Wir haben ein Skript von canewadar
auch wird die quest als complet markiert bei Faction auswalt.

Bild

wen du was besseres hast? ;)
Vertrauen wird oft dadurch erschöpft, dass es in Anspruch genommen wird.
Bild
Bully
Benutzeravatar
Forum Admin
 
Beiträge: 368
Registriert: 02.2014
Geschlecht: männlich
Wohnort: Dreamland


Nächste

Forum Statistiken

Wer ist online?

Mitglieder in diesem Forum: 0 Mitglieder und 1 Gast

Optionen

Zurück zu "Sql skripte & C++"


 
cron