Učitelé
Ucitelé jazyků
Ucitele jizdy
Učitele povolaní
- Bojovnik
- Paladin
- Lovec
- Darebák
- Kněz
- Šaman
- Mág
- Černokněžník
- Druid

Učitelé

Ucitelé jazyků

Učitel jazyků 6000212 (A/H)

Ucitela jazykov je mozne najst v Stormwinde v dome pred vaznicou a v Orgrimmare v casti Drag na poschodi medzi zemepiscami!

Ucitele jizdy

Ucitel jizdy 19054 (A) 20500 (H)

Aliance

/* UCITEL JAZDY ALIANCIA */
UPDATE `pos_world`.`creature_template` SET 
`name` = 'Divokej Bill',
`modelid_A` = '173',
`modelid_A2` = '0', /* 18232 */
`modelid_H` = '173', /* 15502 */
`modelid_H2` = '0', /* 19820 */
`npcflag` = '209' /* 81 */
WHERE `creature_template`.`entry` =19054;
 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`, `reqxp`) VALUES
('19054', '33389', '10000', '0', '0', '0', '1000'); /* NAUCI JAZDENIE */
 
/* HUMANS KONE */
INSERT INTO `npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost` ) VALUES
('19054', '5656', '1', '86400000', '0'); /* Hnedak */
INSERT INTO `npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost` ) VALUES
('19054', '5655', '1', '86400000', '0'); /* Mustang */
INSERT INTO `npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost` ) VALUES
('19054', '2414', '1', '86400000', '0'); /* Flakoun */
INSERT INTO `npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost` ) VALUES
('19054', '2411', '1', '86400000', '0'); /* HNEDAK */

Horda

/* UCITEL JAZDY HORDA */
UPDATE `pos_world`.`creature_template` SET 
`name` = 'Olrokk',
`modelid_A` = '4048',
`modelid_A2` = '0',
`modelid_H` = '4048',
`modelid_H2` = '0',
`npcflag` = '209' /* 81 */ 
WHERE `creature_template`.`entry` =20500;
 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`, `reqxp`) VALUES
('20500', '33389', '10000', '0', '0', '0', '1000'); /* NAUCI JAZDENIE */
 
/* HORDA VLCI */
INSERT INTO `pos_world`.`npc_vendor` (
`entry` ,
`item` ,
`maxcount` ,
`incrtime` ,
`ExtendedCost` 
)
VALUES (
'20500', '46099', '1', '86400000', '0'
); /* Cerny vlk */
INSERT INTO `npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost` ) VALUES
('20500', '5668', '1', '86400000', '0'); /* Hnedy vlk */
INSERT INTO `npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost` ) VALUES
('20500', '5665', '1', '86400000', '0'); /* Sivy vlk */
INSERT INTO `npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost` ) VALUES
('20500', '1132', '1', '86400000', '0'); /* Gastanovy vlk */
INSERT INTO `npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost` ) VALUES
('20500', '29221', '1', '86400000', '0'); /* Cierny pstros */
INSERT INTO `npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost` ) VALUES
('20500', '28927', '1', '86400000', '0'); /* Cerveny pstros */
INSERT INTO `npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost` ) VALUES
('20500', '29222', '1', '86400000', '0'); /* Fialovy pstros */

Učitele povolaní

Obecne sql pro class trainery

 
 UPDATE `pos_world`.`creature_template`  SET
`subname` = 'Ucitel',
`minlevel` = '70',
`maxlevel` = '70',
`minhealth` = '5000',
`maxhealth` = '5000',
`armor` = '15000',
`faction_A` = '35', /*Aliabce - 11  */ 
`faction_H` = '35', /* Horda - 85 */ 
`npcflag` = '51',
`speed` = '1',
`mindmg` = '300',
`maxdmg` = '400',
`attackpower` = '500',
`unit_flags` = '1073741824',
`trainer_type` =  '0',
`trainer_class` = '0', /* Clasa : Warrior 1,Paladin 2,Hunter 3,Rogue 4,Priest 5,Shaman 7,Mage 8,Warlock 9,Druid 11  */ 
`minrangedmg` = '0',
`maxrangedmg` = '0',
`rangedattackpower` = '0',
`flags_extra` = '0' 
WHERE `creature_template`.`entry` =5518 ;

Bojovnik

Rváč 60-64

A: 3144
H: 21330

SQL Dopyt

 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
 
(3144, 1715, 0, 0, 0, 60),
(3144, 694, 0, 0, 0, 61),
(3144, 2764, 0, 0, 0, 61),
(3144, 1464, 0, 0, 0, 62),
(3144, 72, 0, 0, 0, 63),
(3144, 11578, 0, 0, 0, 64),
(3144, 11564, 0, 0, 0, 64);
 
/* Vendor*/
INSERT INTO `pos_world`.`npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost`)VALUES 
(3144, '300099', '0', '0', '0');
 
 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(21330, 1715, 0, 0, 0, 60),
(21330, 694, 0, 0, 0, 61),
(21330, 2764, 0, 0, 0, 61),
(21330, 1464, 0, 0, 0, 62),
(21330, 72, 0, 0, 0, 63),
(21330, 11578, 0, 0, 0, 64),
(21330, 11564, 0, 0, 0, 64);
 
/* Vendor*/
INSERT INTO `pos_world`.`npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost`)VALUES 
(21330, '300099', '0', '0', '0');

Bojovnik 65

A: 5480
H: 11355

SQL Dopyt

INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(5480, 12678, 0, 0, 0, 65),
(5480, 11609, 0, 0, 0, 65),
(5480, 11565, 0, 0, 0, 65),
(5480, 11605, 0, 0, 0, 65),
(5480, 7386, 0, 0, 0, 65);
 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(11355, 12678, 0, 0, 0, 65),
(11355, 11609, 0, 0, 0, 65),
(11355, 11565, 0, 0, 0, 65),
(11355, 11605, 0, 0, 0, 65),
(11355, 7386, 0, 0, 0, 65);

Berserker 66-70

A: 29437 sw
H: 3408 sw

SQL Dopyt

INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(29437, 2458 , 0, 0, 0, 66),
(29437, 11555 , 0, 0, 0, 66),
(29437, 18499 , 0, 0, 0, 68),
(29437, 20661 , 0, 0, 0, 68),
(29437, 47520 , 0, 0, 0, 69),
(29437, 1680 , 0, 0, 0, 70);
 
/* Vendor*/
INSERT INTO `pos_world`.`npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost`)VALUES 
('29437', '300015', '0', '0', '0'),
('29437', '300016', '0', '0', '0');
 
 
 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(3408, 2458, 0, 0, 0, 66),
(3408, 11555, 0, 0, 0, 66),
(3408, 18499, 0, 0, 0, 68),
(3408, 20661, 0, 0, 0, 68),
(3408, 47520, 0, 0, 0, 69),
(3408, 1680, 0, 0, 0, 70);
 
/* Vendor*/
INSERT INTO `pos_world`.`npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost`)VALUES 
('3408', '300015', '0', '0', '0'),
('3408', '300016', '0', '0', '0');

Težkooďenec 66-70

A: 6391 sw
H: 3354 sw

SQL Dopyt

INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(6391, 71, 0, 0, 0, 66),
(6391, 7379, 0, 0, 0, 66),
(6391, 2565, 0, 0, 0, 66),
(6391, 23924, 0, 0, 0, 67),
(6391, 29707, 0, 0, 0, 68),
(6391, 3411, 0, 0, 0, 68),
(6391, 871, 0, 0, 0, 69);
 
/* Vendor*/
INSERT INTO `pos_world`.`npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost`)VALUES 
('6391', '300017', '0', '0', '0');
 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(3354, 71, 0, 0, 0, 66),
(3354, 7379, 0, 0, 0, 66),
(3354, 2565, 0, 0, 0, 66),
(3354, 23924, 0, 0, 0, 67),
(3354, 29707, 0, 0, 0, 68),
(3354, 3411, 0, 0, 0, 68),
(3354, 871, 0, 0, 0, 69);
 
/* Vendor*/
INSERT INTO `pos_world`.`npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost`)VALUES 
('3354', '300017', '0', '0', '0');

Šermíř 66-70

A: 3936 sw
H: 2119 sw

SQL Dopyt

INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(3936, 674, 0, 0, 0, 66),
(3936, 71, 0, 0, 0, 66),
(3936, 2458, 0, 0, 0, 66),
(3936, 676, 0, 0, 0, 67),
(3936, 6552, 0, 0, 0, 67),
(3936, 7384, 0, 0, 0, 68),
(3936, 1719, 0, 0, 0, 68),
(3936, 11600, 0, 0, 0, 69),
(3936, 30330, 0, 0, 0, 70);
 
/* Vendor*/
INSERT INTO `pos_world`.`npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost`)VALUES 
('3936', '300018', '0', '0', '0');
 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(2119, 674, 0, 0, 0, 66),
(2119, 71, 0, 0, 0, 66),
(2119, 2458, 0, 0, 0, 66),
(2119, 676, 0, 0, 0, 67),
(2119, 6552, 0, 0, 0, 67),
(2119, 7384, 0, 0, 0, 68),
(2119, 1719, 0, 0, 0, 68),
(2119, 11600, 0, 0, 0, 69),
(2119, 30330, 0, 0, 0, 70);
 
/* Vendor*/
INSERT INTO `pos_world`.`npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost`)VALUES 
('2119', '300018', '0', '0', '0');

Paladin

Panoš 60-64

A: 1748
H: 17717

SQL Dopyt

 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(1748, 25780, 0, 0, 0, 60),
(1748, 21084, 0, 0, 0, 61),
(1748, 5588, 0, 0, 0, 62),
(1748, 10301, 0, 0, 0, 63),
(1748, 1032, 0, 0, 0, 64);
 
/* Vendor*/
INSERT INTO `pos_world`.`npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost`)VALUES 
('1748', '300019', '0', '0', '0'),
('1748', '300020', '0', '0', '0');
 
 
 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(17717, 25780, 0, 0, 0, 60),
(17717, 21084, 0, 0, 0, 61),
(17717, 5588, 0, 0, 0, 62),
(17717, 10301, 0, 0, 0, 63),
(17717, 1032, 0, 0, 0, 64);
 
/* Vendor*/
INSERT INTO `pos_world`.`npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost`)VALUES 
('17717', '300019', '0', '0', '0'),
('17717', '300020', '0', '0', '0');

Rytíř 65

A: 20349
H: 17099

SQL Dopyt

 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(20349, 5589 , 0, 0, 0, 65),
(20349, 20165 , 0, 0, 0, 65),
(20349, 31789 , 0, 0, 0, 65),
(20349, 20271 , 0, 0, 0, 65),
(20349, 31884, 0, 0, 0, 65),
(20349, 62124 , 0, 0, 0, 65);
 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(17099, 5589 , 0, 0, 0, 65),
(17099, 20165 , 0, 0, 0, 65),
(17099, 31789 , 0, 0, 0, 65),
(17099, 20271 , 0, 0, 0, 65),
(17099, 31884, 0, 0, 0, 65),
(17099, 62124 , 0, 0, 0, 65);

Inkvizitor 66-70

A: 26001 Katedrala
H: 26134 Katedrala

SQL Dopyt

INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(26001, 5502, 0, 0, 0, 66),
(26001, 10326, 0, 0, 0, 66),
(26001, 10312, 0, 0, 0, 67),
(26001, 10318, 0, 0, 0, 68),
(26001, 24274, 0, 0, 0, 69),
(26001, 48943, 0, 0, 0, 70);
 
 
/* Vendor*/
INSERT INTO `pos_world`.`npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost`)VALUES 
('26001', '300021', '0', '0', '0');
 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(26134, 5502, 0, 0, 0, 66),
(26134, 10326, 0, 0, 0, 66),
(26134, 10312, 0, 0, 0, 67),
(26134, 10318, 0, 0, 0, 68),
(26134, 24274, 0, 0, 0, 69),
(26134, 48943, 0, 0, 0, 70);
 
/* Vendor*/
INSERT INTO `pos_world`.`npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost`)VALUES 
('26134', '300021', '0', '0', '0');

Paladin 66-70

A: 27858 Katedrala
H: 16679 Katedrala

SQL Dopyt

INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(27858, 19838, 0, 0, 0, 66),
(27858, 20217, 0, 0, 0, 66),
(27858, 20164, 0, 0, 0, 67),
(27858, 48941, 0, 0, 0, 67),
(27858, 31801, 0, 0, 0, 68),
(27858, 53408, 0, 0, 0, 68),
(27858, 10308, 0, 0, 0, 69),
(27858, 19742, 0, 0, 0, 70);
 
 
/* Vendor*/
INSERT INTO `pos_world`.`npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost`)VALUES 
('27858', '300022', '0', '0', '0');
 
 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(16679, 19838, 0, 0, 0, 66),
(16679, 20217, 0, 0, 0, 66),
(16679, 20164, 0, 0, 0, 67),
(16679, 48941, 0, 0, 0, 67),
(16679, 31801, 0, 0, 0, 68),
(16679, 53408, 0, 0, 0, 68),
(16679, 10308, 0, 0, 0, 69),
(16679, 19742, 0, 0, 0, 70);
 
/* Vendor*/
INSERT INTO `pos_world`.`npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost`)VALUES 
('16679', '300022', '0', '0', '0');

Lovec

Zálesák 60-64

A: 7870
H: 863

SQL Dopyt

 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(7870, 14264, 0, 0, 0, 60),
(7870, 19883, 0, 0, 0, 60),
(7870, 1513, 0, 0, 0, 60),
(7870, 13163, 0, 0, 0, 61),
(7870, 14326, 0, 0, 0, 62),
(7870, 1495, 0, 0, 0, 63),
(7870, 14327, 0, 0, 0, 63),
(7870, 13813, 0, 0, 0, 64),
(7870, 14265, 0, 0, 0, 64);
 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(863, 14264, 0, 0, 0, 60),
(863, 19883, 0, 0, 0, 60),
(863, 1513, 0, 0, 0, 60),
(863, 13163, 0, 0, 0, 61),
(863, 14326, 0, 0, 0, 62),
(863, 1495, 0, 0, 0, 63),
(863, 14327, 0, 0, 0, 63),
(863, 13813, 0, 0, 0, 64),
(863, 14265, 0, 0, 0, 64);

Lovec 65

A: 27467
H: 14441

SQL Dopyt

INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(27467, 781 , 0, 0, 0, 65),
(27467, 5116 , 0, 0, 0, 65),
(27467, 2974 , 0, 0, 0, 65),
(27467, 14324 , 0, 0, 0, 65);
 
/* Vendor*/
INSERT INTO `pos_world`.`npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost`)VALUES 
('27467', '300023', '0', '0', '0');
 
 
 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(14441, 781 , 0, 0, 0, 65),
(14441, 5116 , 0, 0, 0, 65),
(14441, 2974 , 0, 0, 0, 65),
(14441, 14324 , 0, 0, 0, 65);
 
 
/* Vendor*/
INSERT INTO `pos_world`.`npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost`)VALUES 
('14441', '300023', '0', '0', '0');

Ostrostřelec 66-70

A: 27986
H: 3039

SQL Dopyt

INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(27986, 20903, 0, 0, 0, 66),
(27986, 56641, 0, 0, 0, 66),
(27986, 25296, 0, 0, 0, 67),
(27986, 1543, 0, 0, 0, 67),
(27986, 3045, 0, 0, 0, 68),
(27986, 53351, 0, 0, 0, 68),
(27986, 61005, 0, 0, 0, 70),
(27986, 49052, 0, 0, 0, 70);
 
/* Vendor*/
INSERT INTO `pos_world`.`npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost`)VALUES 
('27986', '300024', '0', '0', '0');
 
 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(3039, 20903, 0, 0, 0, 66),
(3039, 56641, 0, 0, 0, 66),
(3039, 25296, 0, 0, 0, 67),
(3039, 1543, 0, 0, 0, 67),
(3039, 3045, 0, 0, 0, 68),
(3039, 53351, 0, 0, 0, 68),
(3039, 61005, 0, 0, 0, 70),
(3039, 49052, 0, 0, 0, 70);
 
/* Vendor*/
INSERT INTO `pos_world`.`npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost`)VALUES 
('3039', '300024', '0', '0', '0');

Hraničář 66-70

A: 4138
H: 1404

SQL Dopyt

INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(4138, 8946, 0, 0, 0, 66),
(4138, 25295, 0, 0, 0, 66),
(4138, 1462, 0, 0, 0, 66),
(4138, 13161, 0, 0, 0, 67),
(4138, 5384, 0, 0, 0, 67),
(4138, 27016, 0, 0, 0, 68),
(4138, 14271, 0, 0, 0, 68),
(4138, 24133, 0, 0, 0, 69);
 
/* Vendor*/
INSERT INTO `pos_world`.`npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost`)VALUES 
('4138', '300025', '0', '0', '0');
 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(1404, 8946, 0, 0, 0, 66),
(1404, 25295, 0, 0, 0, 66),
(1404, 1462, 0, 0, 0, 66),
(1404, 13161, 0, 0, 0, 67),
(1404, 5384, 0, 0, 0, 67),
(1404, 27016, 0, 0, 0, 68),
(1404, 14271, 0, 0, 0, 68),
(1404, 24133, 0, 0, 0, 69);
 
/* Vendor*/
INSERT INTO `pos_world`.`npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost`)VALUES 
('1404', '300025', '0', '0', '0');

Skaut 66-70

A: 715
H: 3352

SQL Dopyt

 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(715, 674, 0, 0, 0, 66),
(715, 20909, 0, 0, 0, 66),
(715, 19503, 0, 0, 0, 67),
(715, 6197, 0, 0, 0, 67),
(715, 5118, 0, 0, 0, 68),
(715, 13161, 0, 0, 0, 68),
(715, 3674 , 0, 0, 0, 69),
(715, 27067, 0, 0, 0, 69),
(715, 61846, 0, 0, 0, 70);
 
 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(3352, 674, 0, 0, 0, 66),
(3352, 20909, 0, 0, 0, 66),
(3352, 19503, 0, 0, 0, 67),
(3352, 6197, 0, 0, 0, 67),
(3352, 5118, 0, 0, 0, 68),
(3352, 13161, 0, 0, 0, 68),
(3352, 3674 , 0, 0, 0, 69),
(3352, 27067, 0, 0, 0, 69),
(3352, 61846, 0, 0, 0, 70);

Darebák

Lump 60-64

A: 12425
H: 2058

SQL Dopyt

 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(12425, 8696, 0, 0, 0, 60),
(12425, 8623, 0, 0, 0, 60),
(12425, 1776, 0, 0, 0, 61),
(12425, 408, 0, 0, 0, 62),
(12425, 8647, 0, 0, 0, 63),
(12425, 48658, 0, 0, 0, 63),
(12425, 11293, 0, 0, 0, 64),
(12425, 11299, 0, 0, 0, 64);
 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(2058, 8696, 0, 0, 0, 60),
(2058, 8623, 0, 0, 0, 60),
(2058, 1776, 0, 0, 0, 61),
(2058, 408, 0, 0, 0, 62),
(2058, 8647, 0, 0, 0, 63),
(2058, 48658, 0, 0, 0, 63),
(2058, 11293, 0, 0, 0, 64),
(2058, 11299, 0, 0, 0, 64);

Lapka 65

A: 639
H: 33436

SQL Dopyt

 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(639, 1766, 0, 0, 0, 65),
(639, 11305, 0, 0, 0, 65),
(639, 1784, 0, 0, 0, 65),
(639, 26889, 0, 0, 0, 65);
 
/* Vendor*/
INSERT INTO `pos_world`.`npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost`)VALUES 
('639', '300026', '0', '0', '0');
 
 
 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(33436, 1766, 0, 0, 0, 65),
(33436, 11305, 0, 0, 0, 65),
(33436, 1784, 0, 0, 0, 65),
(33436, 26889, 0, 0, 0, 65);
 
/* Vendor*/
INSERT INTO `pos_world`.`npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost`)VALUES 
('33436', '300026', '0', '0', '0');

Zloděj 66-70

A: 4215
H: 4582

SQL Dopyt

INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(4215, 814, 0, 0, 0, 66),
(4215, 6770, 0, 0, 0, 66),
(4215, 921, 0, 0, 0, 66),
(4215, 1833, 0, 0, 0, 66),
(4215, 1725, 0, 0, 0, 67),
(4215, 1804, 0, 0, 0, 67),
(4215, 1860, 0, 0, 0, 68),
(4215, 48660, 0, 0, 0, 69),
(4215, 51724, 0, 0, 0, 70);
 
/* Vendor*/
INSERT INTO `pos_world`.`npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost`)VALUES 
('4215', '300027', '0', '0', '0');
 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(4582, 814, 0, 0, 0, 66),
(4582, 6770, 0, 0, 0, 66),
(4582, 921, 0, 0, 0, 66),
(4582, 1833, 0, 0, 0, 66),
(4582, 1725, 0, 0, 0, 67),
(4582, 1804, 0, 0, 0, 67),
(4582, 1860, 0, 0, 0, 68),
(4582, 48660, 0, 0, 0, 69),
(4582, 51724, 0, 0, 0, 70);
 
/* Vendor*/
INSERT INTO `pos_world`.`npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost`)VALUES 
('4582', '300027', '0', '0', '0');

Zabiják 66-70

A: 916
H: 29607

SQL Dopyt

INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(916, 26863, 0, 0, 0, 66),
(916, 26839, 0, 0, 0, 66),
(916, 51722, 0, 0, 0, 66),
(916, 27441, 0, 0, 0, 67),
(916, 2094, 0, 0, 0, 68),
(916, 1725, 0, 0, 0, 68),
(916, 26679, 0, 0, 0, 69),
(916, 48691, 0, 0, 0, 70);
 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(29607, 26863, 0, 0, 0, 66),
(29607, 26839, 0, 0, 0, 66),
(29607, 51722, 0, 0, 0, 66),
(29607, 27441, 0, 0, 0, 67),
(29607, 2094, 0, 0, 0, 68),
(29607, 1725, 0, 0, 0, 68),
(29607, 26679, 0, 0, 0, 69),
(29607, 48691, 0, 0, 0, 70);

ZRUSENO Dobrodruh 66-70

A: 1411
H: 4584

SQL Dopyt

INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(1411, 816, 0, 0, 0, 66),
(1411, 12883, 0, 0, 0, 66),
(1411, 14251, 0, 0, 0, 66),
(1411, 6774, 0, 0, 0, 66),
(1411, 1842, 0, 0, 0, 67),
(1411, 75, 0, 0, 0, 67),
(1411, 13877, 0, 0, 0, 68),
(1411, 14477, 0, 0, 0, 69),
(1411, 14394, 0, 0, 0, 69),
(1411, 13750, 0, 0, 0, 70);
 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(4584, 816, 0, 0, 0, 66),
(4584, 12883, 0, 0, 0, 66),
(4584, 14251, 0, 0, 0, 66),
(4584, 6774, 0, 0, 0, 66),
(4584, 1842, 0, 0, 0, 67),
(4584, 75, 0, 0, 0, 67),
(4584, 13877, 0, 0, 0, 68),
(4584, 14477, 0, 0, 0, 69),
(4584, 14394, 0, 0, 0, 69),
(4584, 13750, 0, 0, 0, 70);

Kněz

Učeň 60-64

A: 2327
H: 2121

SQL Dopyt

 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(2327, 814, 0, 0, 0, 60),
(2327, 6078, 0, 0, 0, 61),
(2327, 527, 0, 0, 0, 62),
(2327, 453, 0, 0, 0, 62),
(2327, 25433, 0, 0, 0, 63),
(2327, 6065, 0, 0, 0, 63),
(2327, 19238, 0, 0, 0, 64);
 
/* Vendor*/
INSERT INTO `pos_world`.`npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost`)VALUES 
('2327', '300028', '0', '0', '0');
 
 
 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(2121, 814, 0, 0, 0, 60),
(2121, 6078, 0, 0, 0, 61),
(2121, 527, 0, 0, 0, 62),
(2121, 453, 0, 0, 0, 62),
(2121, 25433, 0, 0, 0, 63),
(2121, 6065, 0, 0, 0, 63),
(2121, 19238, 0, 0, 0, 64);
 
/* Vendor*/
INSERT INTO `pos_world`.`npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost`)VALUES 
('2121', '300028', '0', '0', '0');

Kněz 65

A: 17104
H: 15284

SQL Dopyt

 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(17104, 7924, 0, 0, 0, 65),
(17104, 7928, 0, 0, 0, 65),
(17104, 7929, 0, 0, 0, 65),
(17104, 6346, 0, 0, 0, 65),
(17104, 15263, 0, 0, 0, 65),
(17104, 2055, 0, 0, 0, 65),
(17104, 10955, 0, 0, 0, 65);
 
/* Vendor*/
INSERT INTO `pos_world`.`npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost`)VALUES 
('17104', '300029', '0', '0', '0');
 
 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(15284, 7924, 0, 0, 0, 65),
(15284, 7928, 0, 0, 0, 65),
(15284, 7929, 0, 0, 0, 65),
(15284, 6346, 0, 0, 0, 65),
(15284, 15263, 0, 0, 0, 65),
(15284, 2055, 0, 0, 0, 65),
(15284, 10955, 0, 0, 0, 65);
 
/* Vendor*/
INSERT INTO `pos_world`.`npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost`)VALUES 
('15284', '300029', '0', '0', '0');

Voodoo 66-70

H: 3995 Park

SQL Dopyt

INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
 
 
(3995, 10909, 0, 0, 0, 66),
(3995, 10888 , 0, 0, 0, 67),
(3995, 10881, 0, 0, 0, 68),
(3995, 605 , 0, 0, 0, 70);
 
/* Vendor*/
INSERT INTO `pos_world`.`npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost`)VALUES 
('3995', '300030', '0', '0', '0'),
('3995', '300031', '0', '0', '0'),
('3995', '300033', '0', '0', '0'),
('3995', '300034', '0', '0', '0');

Cesta Světla 66-70

A: 29087 katedrala
H: 19435 katedrala

SQL Dopyt

INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
 
(29087, 6063, 0, 0, 0, 66),
(29087, 10881, 0, 0, 0, 67),
(29087, 10899, 0, 0, 0, 68),
(29087, 10961, 0, 0, 0, 69);
 
/* Vendor*/
INSERT INTO `pos_world`.`npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost`)VALUES 
('29087', '300035', '0', '0', '0'),
('29087', '300036', '0', '0', '0'),
('29087', '300037', '0', '0', '0'),
('29087', '300038', '0', '0', '0');
 
 
 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
 
(19435, 6063, 0, 0, 0, 66),
(19435, 10881, 0, 0, 0, 67),
(19435, 10899, 0, 0, 0, 68),
(19435, 10961, 0, 0, 0, 69);
 
/* Vendor*/
INSERT INTO `pos_world`.`npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost`)VALUES 
('19435', '300035', '0', '0', '0'),
('19435', '300036', '0', '0', '0'),
('19435', '300037', '0', '0', '0'),
('19435', '300038', '0', '0', '0');

Cesta Elune 66-70

A: 4091 The Park KC

SQL Dopyt

 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
 
(4091, 9473,  0, 0, 0, 66);
 
/* Vendor*/
INSERT INTO `pos_world`.`npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost`)VALUES 
('4091', '300064', '0', '0', '0'),
('4091', '300039', '0', '0', '0'),
('4091', '300040', '0', '0', '0'),
('4091', '300041', '0', '0', '0'),
('4091', '300042', '0', '0', '0'),
('4091', '300043', '0', '0', '0'),
('4091', '300044', '0', '0', '0');

Cesta Temna 66-70

A: 18538 Katedrala
H: 11055 Katedrala

SQL Dopyt

 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(18538, 10892, 0, 0, 0, 66),
(18538, 10946,  0, 0, 0, 66),
(18538, 18807, 0, 0, 0, 67),
(18538, 32379, 0, 0, 0, 69);
 
/* Vendor*/
INSERT INTO `pos_world`.`npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost`)VALUES 
('18538', '300045', '0', '0', '0'),
('18538', '300046', '0', '0', '0'),
('18538', '300047', '0', '0', '0'),
('18538', '300048', '0', '0', '0');
 
 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(11055, 10892, 0, 0, 0, 66),
(11055, 10946,  0, 0, 0, 66),
(11055, 18807, 0, 0, 0, 67),
(11055, 32379, 0, 0, 0, 69);
 
/* Vendor*/
INSERT INTO `pos_world`.`npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost`)VALUES 
('11055', '300045', '0', '0', '0'),
('11055', '300046', '0', '0', '0'),
('11055', '300047', '0', '0', '0'),
('11055', '300048', '0', '0', '0');

Šaman

Učeň 60-64

A: 17204
H: 21024

SQL Dopyt

 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
 
 
(17204, 526, 0, 0, 0, 61),
(17204, 10399 , 0, 0, 0, 62),
(17204, 370, 0, 0, 0, 63),
(17204, 913, 0, 0, 0, 63),
(17204, 905, 0, 0, 0, 64);
 
/* Vendor*/
INSERT INTO `pos_world`.`npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost`)VALUES 
('17204', '300049', '0', '0', '0'),
('17204', '300050', '0', '0', '0');
 
 
 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
 
 
(21024, 526, 0, 0, 0, 61),
(21024, 10399 , 0, 0, 0, 62),
(21024, 370, 0, 0, 0, 63),
(21024, 913, 0, 0, 0, 63),
(21024, 905, 0, 0, 0, 64);
 
/* Vendor*/
INSERT INTO `pos_world`.`npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost`)VALUES 
('21024', '300049', '0', '0', '0'),
('21024', '300050', '0', '0', '0');

Šaman 65

A: 17219
H: 14736

SQL Dopyt

INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
 
(17219, 7924, 0, 0, 0, 65),
(17219, 7928, 0, 0, 0, 65),
(17219, 7929,  0, 0, 0, 65),
(17219, 939, 0, 0, 0, 65),
(17219, 2645, 0, 0, 0, 65),
(17219, 10391, 0, 0, 0, 65),
(17219, 945, 0, 0, 0, 65);
 
 
/* Vendor*/
INSERT INTO `pos_world`.`npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost`)VALUES 
('17219', '300051', '0', '0', '0');
 
 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
 
(14736, 7924, 0, 0, 0, 65),
(14736, 7928, 0, 0, 0, 65),
(14736, 7929,  0, 0, 0, 65),
(14736, 939, 0, 0, 0, 65),
(14736, 2645, 0, 0, 0, 65),
(14736, 10391, 0, 0, 0, 65),
(14736, 945, 0, 0, 0, 65);
 
/* Vendor*/
INSERT INTO `pos_world`.`npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost`)VALUES 
('14736', '300051', '0', '0', '0');

Zaklínač 66-70

A: 18233 PArk
H: 11946 Park

SQL Dopyt

INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(18233 , 25508, 0, 0, 0, 66),
(18233 , 10447, 0, 0, 0, 66),
(18233 , 16342,  0, 0, 0, 67),
(18233 , 57994, 0, 0, 0, 67),
(18233 , 15208, 0, 0, 0, 68),
(18233 , 10605, 0, 0, 0, 69),
(18233 , 8161, 0, 0, 0, 70);
 
/* Vendor*/
INSERT INTO `pos_world`.`npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost`)VALUES 
('18233 ', '300052', '0', '0', '0');
 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(11946, 25508, 0, 0, 0, 66),
(11946, 10447, 0, 0, 0, 66),
(11946, 16342,  0, 0, 0, 67),
(11946, 57994, 0, 0, 0, 67),
(11946, 15208, 0, 0, 0, 68),
(11946, 10605, 0, 0, 0, 69),
(11946, 8161, 0, 0, 0, 70);
 
/* Vendor*/
INSERT INTO `pos_world`.`npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost`)VALUES 
('11946', '300052', '0', '0', '0');

Lěčitel 66-70

A: 17519 Park
H: 3032 Park

SQL Dopyt

INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(17519, 6377, 0, 0, 0, 66),
(17519, 10622, 0, 0, 0, 66),
(17519, 51988,  0, 0, 0, 67),
(17519, 20776, 0, 0, 0, 67),
(17519, 959, 0, 0, 0, 69),
(17519, 25570, 0, 0, 0, 69),
(17519, 32593, 0, 0, 0, 70);
 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(3032, 6377, 0, 0, 0, 66),
(3032, 10622, 0, 0, 0, 66),
(3032, 51988,  0, 0, 0, 67),
(3032, 20776, 0, 0, 0, 67),
(3032, 959, 0, 0, 0, 69),
(3032, 25570, 0, 0, 0, 69),
(3032, 32593, 0, 0, 0, 70);

Mág

Mág 60-64

A: 2415
H: 18527

SQL Dopyt

 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(2415, 8402, 0, 0, 0, 60),
(2415, 8408, 0, 0, 0, 60),
(2415, 8417,  0, 0, 0, 60),
(2415, 8495, 0, 0, 0, 62),
(2415, 475, 0, 0, 0, 62),
(2415, 8457, 0, 0, 0, 63),
(2415, 8461, 0, 0, 0, 63);
 
/* Vendor*/
INSERT INTO `pos_world`.`npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost`)VALUES 
('2415', '300053', '0', '0', '0');
 
 
 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(18527, 8402, 0, 0, 0, 60),
(18527, 8408, 0, 0, 0, 60),
(18527, 8417,  0, 0, 0, 60),
(18527, 8495, 0, 0, 0, 62),
(18527, 475, 0, 0, 0, 62),
(18527, 8457, 0, 0, 0, 63),
(18527, 8461, 0, 0, 0, 63);
 
/* Vendor*/
INSERT INTO `pos_world`.`npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost`)VALUES 
('18527', '300053', '0', '0', '0');

Zkušený mág 65

A: 32741
H: 5498

SQL Dopyt

 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
 
(32741, 1953, 0, 0, 0, 65),
(32741, 13018,  0, 0, 0, 65),
(32741, 10160, 0, 0, 0, 65),
(32741, 10174, 0, 0, 0, 65),
(32741, 527, 0, 0, 0, 65);
 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
 
(5498, 1953, 0, 0, 0, 65),
(5498, 13018,  0, 0, 0, 65),
(5498, 10160, 0, 0, 0, 65),
(5498, 10174, 0, 0, 0, 65),
(5498, 527, 0, 0, 0, 65);

Mág Ledu 66-70

A: 18166 Vež Mágů
H: 7311 Vež Mágů

SQL Dopyt

 
 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(18166, 10181, 0, 0, 0, 66),
(18166, 27088, 0, 0, 0, 66),
(18166, 8462,  0, 0, 0, 66),
(18166, 43008, 0, 0, 0, 67),
(18166, 45438, 0, 0, 0, 69),
(18166, 30455, 0, 0, 0, 70),
(18166, 48945, 0, 0, 0, 70);
 
/* Vendor*/
INSERT INTO `pos_world`.`npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost`)VALUES 
('18166', '300054', '0', '0', '0');
 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(7311, 10181, 0, 0, 0, 66),
(7311, 27088, 0, 0, 0, 66),
(7311, 8462,  0, 0, 0, 66),
(7311, 43008, 0, 0, 0, 67),
(7311, 45438, 0, 0, 0, 69),
(7311, 30455, 0, 0, 0, 70),
(7311, 48945, 0, 0, 0, 70);
 
 
/* Vendor*/
INSERT INTO `pos_world`.`npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost`)VALUES 
('7311', '300054', '0', '0', '0');

Mág Oheňe 66-70

A: 11949 Vež Mágů
H: 3047 Vež Mágů

SQL Dopyt

 
 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(11949, 10149, 0, 0, 0, 66),
(11949, 8458, 0, 0, 0, 66),
(11949, 10207, 0, 0, 0, 67),
(11949, 10199, 0, 0, 0, 68),
(11949, 30482, 0, 0, 0, 69),
(11949, 33041, 0, 0, 0, 70),
(11949, 48947, 0, 0, 0, 70);
 
/* Vendor*/
INSERT INTO `pos_world`.`npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost`)VALUES 
('11949', '300055', '0', '0', '0');
 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(3047, 10149, 0, 0, 0, 66),
(3047, 8458, 0, 0, 0, 66),
(3047, 10207, 0, 0, 0, 67),
(3047, 10199, 0, 0, 0, 68),
(3047, 30482, 0, 0, 0, 69),
(3047, 33041, 0, 0, 0, 70),
(3047, 48947, 0, 0, 0, 70);
 
/* Vendor*/
INSERT INTO `pos_world`.`npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost`)VALUES 
('3047', '300055', '0', '0', '0');

Mág Arkány 66-70

A: 5497 Vež Mágů
H: 16653 Vež Mágů

SQL Dopyt

INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(5497, 10212, 0, 0, 0, 66),
(5497, 2139, 0, 0, 0, 66),
(5497, 27082, 0, 0, 0, 67),
(5497, 12051, 0, 0, 0, 68),
(5497, 43024, 0, 0, 0, 69),
(5497, 38704, 0, 0, 0, 70),
(5497, 30449, 0, 0, 0, 70);
 
 
/* Vendor*/
INSERT INTO `pos_world`.`npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost`)VALUES 
('5497', '300056', '0', '0', '0');
 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(16653, 10212, 0, 0, 0, 66),
(16653, 2139, 0, 0, 0, 66),
(16653, 27082, 0, 0, 0, 67),
(16653, 12051, 0, 0, 0, 68),
(16653, 43024, 0, 0, 0, 69),
(16653, 38704, 0, 0, 0, 70),
(16653, 30449, 0, 0, 0, 70);
 
 
/* Vendor*/
INSERT INTO `pos_world`.`npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost`)VALUES 
('16653', '300056', '0', '0', '0');

Černokněžník

Učeň 60-64

A: 6382
H: 4564

SQL Dopyt

 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
 
(6382, 7641, 0, 0, 0, 60),
(6382, 6205,  0, 0, 0, 61),
(6382, 1086, 0, 0, 0, 61),
(6382, 6223, 0, 0, 0, 62),
(6382, 1490, 0, 0, 0, 62),
(6382, 6229, 0, 0, 0, 63);
 
/* Vendor*/
INSERT INTO `pos_world`.`npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost`)VALUES 
('6382', '300057', '0', '0', '0');
 
 
 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(4564, 7641, 0, 0, 0, 60),
(4564, 6205,  0, 0, 0, 61),
(4564, 1086, 0, 0, 0, 61),
(4564, 6223, 0, 0, 0, 62),
(4564, 1490, 0, 0, 0, 62),
(4564, 6229, 0, 0, 0, 63);
 
/* Vendor*/
INSERT INTO `pos_world`.`npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost`)VALUES 
('4564', '300057', '0', '0', '0');

Černokněžník 65

A: 906
H: 5822

SQL Dopyt

 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
 
(906, 11659, 0, 0, 0, 65),
(906, 7648,  0, 0, 0, 65),
(906, 11719, 0, 0, 0, 65),
(906, 5782, 0, 0, 0, 65),
(906, 11733, 0, 0, 0, 65);
 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
 
(5822, 11659, 0, 0, 0, 65),
(5822, 7648,  0, 0, 0, 65),
(5822, 11719, 0, 0, 0, 65),
(5822, 5782, 0, 0, 0, 65),
(5822, 11733, 0, 0, 0, 65);

Temný mág 66-70

A: 18686 Krypta
H: 5675 Krypta

SQL Dopyt

 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
 
(18686, 11660, 0, 0, 0, 66),
(18686, 7646,  0, 0, 0, 66),
(18686, 11671, 0, 0, 0, 67),
(18686, 8288, 0, 0, 0, 68),
(18686, 47888, 0, 0, 0, 68),
(18686, 60220, 0, 0, 0, 69),
(18686, 30413, 0, 0, 0, 70);
 
/* Vendor*/
INSERT INTO `pos_world`.`npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost`)VALUES 
('18686', '300058', '0', '0', '0');
 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
 
(5675, 11660, 0, 0, 0, 66),
(5675, 7646,  0, 0, 0, 66),
(5675, 11671, 0, 0, 0, 67),
(5675, 8288, 0, 0, 0, 68),
(5675, 47888, 0, 0, 0, 68),
(5675, 60220, 0, 0, 0, 69),
(5675, 30413, 0, 0, 0, 70);
 
/* Vendor*/
INSERT INTO `pos_world`.`npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost`)VALUES 
('5675', '300058', '0', '0', '0');

Nekromant 66-70

A: 28194 Krypta
H: 28383 Krypta

SQL Dopyt

 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
 
(28194, 27220,  0, 0, 0, 66),
(28194, 11739, 0, 0, 0, 67),
(28194, 6789, 0, 0, 0, 67),
(28194, 10955, 0, 0, 0, 68),
(28194, 17928, 0, 0, 0, 69),
(28194, 17926, 0, 0, 0, 70);
 
 
/* Vendor*/
INSERT INTO `pos_world`.`npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost`)VALUES 
('28194', '300059', '0', '0', '0'),
('28194', '300060', '0', '0', '0');
 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
 
(28383, 27220,  0, 0, 0, 66),
(28383, 11739, 0, 0, 0, 67),
(28383, 6789, 0, 0, 0, 67),
(28383, 10955, 0, 0, 0, 68),
(28383, 17928, 0, 0, 0, 69),
(28383, 17926, 0, 0, 0, 70);
 
/* Vendor*/
INSERT INTO `pos_world`.`npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost`)VALUES 
('28383', '300059', '0', '0', '0'),
('28383', '300060', '0', '0', '0');

Druid

Bard 60-64

A: 17841
H: 5769

SQL Dopyt

 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
 
(17841, 814, 0, 0, 0, 60),
(17841, 5234, 0, 0, 0, 60),
(17841, 1430,  0, 0, 0, 61),
(17841, 18658, 0, 0, 0, 62),
(17841, 2090, 0, 0, 0, 63),
(17841, 9884 , 0, 0, 0, 64);
 
/* Vendor*/
INSERT INTO `pos_world`.`npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost`)VALUES 
('17841', '300061', '0', '0', '0'),
('17841', '300062', '0', '0', '0'),
('17841', '300032', '0', '0', '0');
 
 
 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
 
(5769, 814, 0, 0, 0, 60),
(5769, 5234, 0, 0, 0, 60),
(5769, 1430,  0, 0, 0, 61),
(5769, 18658, 0, 0, 0, 62),
(5769, 2090, 0, 0, 0, 63),
(5769, 9884 , 0, 0, 0, 64);
 
/* Vendor*/
INSERT INTO `pos_world`.`npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost`)VALUES 
('5769', '300061', '0', '0', '0'),
('5769', '300062', '0', '0', '0'),
('5769', '300032', '0', '0', '0');

Léčitel 65

A: 3516
H: 3064

SQL Dopyt

 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(3516, 7928, 0, 0, 0, 65),
(3516, 7929, 0, 0, 0, 65),
(3516, 7924, 0, 0, 0, 65),
(3516, 2782, 0, 0, 0, 65),
(3516, 2893,  0, 0, 0, 65),
(3516, 26995, 0, 0, 0, 65),
(3516, 8939, 0, 0, 0, 65),
(3516, 5570, 0, 0, 0, 65);
 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(3064, 7928, 0, 0, 0, 65),
(3064, 7929, 0, 0, 0, 65),
(3064, 7924, 0, 0, 0, 65),
(3064, 2782, 0, 0, 0, 65),
(3064, 2893,  0, 0, 0, 65),
(3064, 26995, 0, 0, 0, 65),
(3064, 8939, 0, 0, 0, 65),
(3064, 5570, 0, 0, 0, 65);

Strom 66-70

A: 29604 The Park KC
H: 8142 The Park KC

SQL Dopyt

 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(29604, 50766, 0, 0, 0, 66),
(29604, 21850, 0, 0, 0, 66),
(29604, 9839, 0, 0, 0, 66),
(29604, 8941, 0, 0, 0, 68),
(29604, 8918, 0, 0, 0, 69),
(29604, 48469, 0, 0, 0, 69),
(29604, 20739, 0, 0, 0, 70),
(29604, 33943, 0, 0, 0, 70);
 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(8142, 50766, 0, 0, 0, 66),
(8142, 21850, 0, 0, 0, 66),
(8142, 9839, 0, 0, 0, 66),
(8142, 8941, 0, 0, 0, 68),
(8142, 8918, 0, 0, 0, 69),
(8142, 48469, 0, 0, 0, 69),
(8142, 20739, 0, 0, 0, 70),
(8142, 33943, 0, 0, 0, 70);

Vítr 66-70

A: 25809 The Park KC
H: 3034 The Park KC

SQL Dopyt

 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(25809, 26992, 0, 0, 0, 66),
(25809, 22812, 0, 0, 0, 66),
(25809, 26989, 0, 0, 0, 66),
(25809, 24975, 0, 0, 0, 67),
(25809, 53307, 0, 0, 0, 69),
(25809, 24977, 0, 0, 0, 69),
(25809, 17402, 0, 0, 0, 70),
(25809, 33943, 0, 0, 0, 70);
 
/* Vendor*/
INSERT INTO `pos_world`.`npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost`)VALUES 
('25809', '300063', '0', '0', '0');
 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(3034, 26992, 0, 0, 0, 66),
(3034, 22812, 0, 0, 0, 66),
(3034, 26989, 0, 0, 0, 66),
(3034, 24975, 0, 0, 0, 67),
(3034, 53307, 0, 0, 0, 69),
(3034, 24977, 0, 0, 0, 69),
(3034, 17402, 0, 0, 0, 70),
(3034, 33943, 0, 0, 0, 70);
 
/* Vendor*/
INSERT INTO `pos_world`.`npc_vendor` (`entry` ,`item` ,`maxcount` ,`incrtime` ,`ExtendedCost`)VALUES 
('3034', '300063', '0', '0', '0');

Medvěd 66-70

H: 3033 The Park KC

SQL Dopyt

 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(3033, 5487, 0, 0, 0, 66),
(3033, 6795, 0, 0, 0, 66),
(3033, 9745, 0, 0, 0, 66),
(3033, 9898,  0, 0, 0, 67),
(3033, 26997, 0, 0, 0, 68),
(3033, 5209, 0, 0, 0, 68),
(3033, 16979, 0, 0, 0, 69),
(3033, 8983, 0, 0, 0, 70);

Kočka 66-70

A: 16721 The Park KC

SQL Dopyt

 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(16721, 768, 0, 0, 0, 66),
(16721, 5215, 0, 0, 0, 66),
(16721, 9850, 0, 0, 0, 66),
(16721, 22828,  0, 0, 0, 67),
(16721, 9830, 0, 0, 0, 68),
(16721, 33357, 0, 0, 0, 68),
(16721, 22570, 0, 0, 0, 69),
(16721, 9827, 0, 0, 0, 70);