Čuz lidi mam takovej problém stahnul jsem si univerzalního trainera a mě netrénuje tak sem hazim sql a jestli mi někdo poradi distak diky
insert INTO `creature_template` (`entry`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `faction_A`, `faction_H`, `npcflag`, `speed`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `baseattacktime`, `rangeattacktime`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `RacialLeader`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (200985, 'Vseho Trainer', 'Destiny World', '', 80, 80, 35, 35, 81, 1.48, 1, 0, 38, 57, 0, 14, 2000, 2000, 4608, 0, 0, 2, 0, 0, 0, 30, 46, 11, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 1, 3, 0, 1, 3790, 0, 2, '');
DELETE FROM `npc_trainer` WHERE (`entry`=200985);
INSERT INTO `npc_trainer` (entry, spell, spellcost, reqskill, reqskillvalue, reqlevel) VALUES
(200985, 99, 300, 0, 0, 10),
(200985, 339, 200, 0, 0, 8),
(200985, 467, 100, 0, 0, 6),
(200985, 740, 6000, 0, 0, 30),
(200985, 768, 2000, 0, 0, 20),
(200985, 769, 10000, 0, 0, 34),
(200985, 770, 1900, 0, 0, 18),
(200985, 774, 100, 0, 0, 4),
(200985, 779, 1800, 0, 0, 16),
(200985, 780, 4000, 0, 0, 24),
(200985, 782, 900, 0, 0, 14),
(200985, 783, 6000, 0, 0, 16),
(200985, 1058, 300, 0, 0, 10),
(200985, 1062, 1900, 0, 0, 18),
(200985, 1066, 1600, 0, 0, 16),
(200985, 1075, 4000, 0, 0, 24),
(200985, 1079, 2000, 0, 0, 20),
(200985, 1082, 2000, 0, 0, 20),
(200985, 1126, 10, 0, 0, 0),
(200985, 1430, 1800, 0, 0, 16),
(200985, 1735, 2000, 0, 0, 20),
(200985, 1822, 4000, 0, 0, 24),
(200985, 1823, 10000, 0, 0, 34),
(200985, 1824, 18000, 0, 0, 44),
(200985, 1850, 4500, 0, 0, 26),
(200985, 2090, 3000, 0, 0, 22),
(200985, 2091, 5000, 0, 0, 28),
(200985, 2637, 1900, 0, 0, 18),
(200985, 2782, 4000, 0, 0, 24),
(200985, 2893, 4500, 0, 0, 26),
(200985, 2908, 3000, 0, 0, 22),
(200985, 2912, 2000, 0, 0, 20),
(200985, 3029, 5000, 0, 0, 28),
(200985, 3627, 10000, 0, 0, 34),
(200985, 5177, 100, 0, 0, 6),
(200985, 5178, 900, 0, 0, 14),
(200985, 5179, 3000, 0, 0, 22),
(200985, 5180, 6000, 0, 0, 30),
(200985, 5186, 200, 0, 0, 8),
(200985, 5187, 900, 0, 0, 14),
(200985, 5188, 2000, 0, 0, 20),
(200985, 5189, 4500, 0, 0, 26),
(200985, 5195, 5000, 0, 0, 28),
(200985, 5196, 12000, 0, 0, 38),
(200985, 5201, 12000, 0, 0, 38),
(200985, 5209, 5000, 0, 0, 28),
(200985, 5211, 900, 0, 0, 14),
(200985, 5215, 2000, 0, 0, 20),
(200985, 5217, 4000, 0, 0, 24),
(200985, 5221, 3000, 0, 0, 22),
(200985, 5225, 8000, 0, 0, 32),
(200985, 5229, 800, 0, 0, 12),
(200985, 5232, 300, 0, 0, 10),
(200985, 5234, 6000, 0, 0, 30),
(200985, 6756, 2000, 0, 0, 20),
(200985, 6778, 8000, 0, 0, 32),
(200985, 6780, 12000, 0, 0, 38),
(200985, 6783, 14000, 0, 0, 40),
(200985, 6785, 8000, 0, 0, 32),
(200985, 6787, 16000, 0, 0, 42),
(200985, 6793, 11000, 0, 0, 36),
(200985, 6798, 6000, 0, 0, 30),
(200985, 6800, 6000, 0, 0, 30),
(200985, 6808, 1900, 0, 0, 18),
prominte ale databazi u sebe nemam takze ji budu muset zjistit a spravce je off takze to bude chvili trvat