Tak vam sem házím CZLukas's DK Trainer SQL Repack
Je to Illidan na polovicni velikost - zatím má jen kouzla Summon Deathrider a Army of Dead. - ostatní napřed vyzkouším jestli se házej do správného Tabu ve Spellbooku.
Všechny spelly je možno učit na lvl 55 za 10 goldů - ranky nemám odskoušeny
pridate ho pomoci
.npc add 66666
Tu mate nake obrazky:
POZOR!!!!! - Obrazky jiz nejsou aktualni - upravil jsem SQLka, takze ted trainer vypada jako arthas ale bez lich king helmy !!!!!
A tady uz SQL:
Toto vytvoří Trainera:
INSERT INTO `creature_template` VALUES ('66666', '2629', '0', '2629', '0', 'Veteran DeathKnight', 'Deathknight trainer', null, '80', '80', '999999', '999999', '0', '0', '1', '814', '814', '19', '1', '1', '0', '100', '110', '0', '800', '2500', '2500', '0', '0', '0', '0', '0', '6', '0', '200', '250', '800', '7', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '3', '0', '1', '0', '0', '');
A toto mu přiřadí kouzla:
INSERT INTO `npc_trainer` VALUES ('6666', '42650', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '48778', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '43265', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '45462', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '45463', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '45477', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '45524', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '45843', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '45902', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '46584', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '47528', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '48263', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '48265', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '48266', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '48707', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '48721', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '48743', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '48766', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '48982', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '49005', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '49013', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '49016', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '49020', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '49039', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '49142', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '49143', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '49184', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '49206', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '49222', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '49576', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '49896', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '49903', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '49904', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '49910', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '49911', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '49912', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '49917', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '49918', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '49919', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '49920', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '49921', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '49923', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '49924', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '49926', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '49927', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '49928', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '49929', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '49930', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '49932', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '49933', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '49934', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '49936', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '49937', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '49938', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '49939', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '49940', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '49941', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '49998', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '49999', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '47476', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '47541', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '48792', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '49028', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '49158', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '49194', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '49203', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '49796', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '49892', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '49893', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '49894', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '49895', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '49913', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '49914', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '49915', '100000', '0', '0', '55');
INSERT INTO `npc_trainer` VALUES ('66666', '49916', '100000', '0', '0', '55');
- ty kouzla jsou vsecky pokud ja vim, takze tam jsou i kouzla za talenty (tim nemyslim Improwed, ale treba talentove ultimatky atd...)
-- vsem se omlouvam zapomel sem dopsat jednu 6tku ted uz to pojede :D:D
--- upraveny SQLka od trenera - ted vypada spis jako deathknight