Если 3.х.х версия клиента, то зачем
Код:
-- Poisons
REPLACE INTO `npc_trainer` SELECT `entry`, '2842', '20000', '0', '0', '10' FROM `creature_template` WHERE `subname`='Rogue Trainer';
-- Instant Poison
REPLACE INTO `npc_trainer` SELECT `entry`, '8681', '20000', '0', '0', '10' FROM `creature_template` WHERE `subname`='Rogue Trainer';
например?
Код:
-- Summon Imp
REPLACE INTO `npc_trainer` SELECT `entry`, '688', '1', '0', '0', '1' FROM `creature_template` WHERE `subname`='Warlock Trainer';
итак с 330 учится у тренера за 90(вроде) меди
Код:
-- Swift Flight Form
REPLACE INTO `npc_trainer` SELECT `entry`, '40120', '200000', '0', '0', '70' FROM `creature_template` WHERE `subname`='Druid Trainer';
-- Summon Felsteed
REPLACE INTO `npc_trainer` SELECT `entry`, '5784', '200000', '0', '0', '40' FROM `creature_template` WHERE `subname`='Warlock Trainer';
-- Summon Dreadsteed
REPLACE INTO `npc_trainer` SELECT `entry`, '23161', '1000000', '0', '0', '60' FROM `creature_template` WHERE `subname`='Warlock Trainer';
-- Summon Warhorse
REPLACE INTO `npc_trainer` SELECT `entry`, '13819', '200000', '0', '0', '40' FROM `creature_template` WHERE `subname`='Paladin Trainer' AND NOT `faction_A`='1604';
REPLACE INTO `npc_trainer` SELECT `entry`, '13819', '200000', '0', '0', '40' FROM `creature_template` WHERE `subname`='Paladin Trainer' AND `faction_A`='1604';
-- Summon Charger
REPLACE INTO `npc_trainer` SELECT `entry`, '23214', '1000000', '0', '0', '60' FROM `creature_template` WHERE `subname`='Paladin Trainer' AND NOT `faction_A`='1604';
REPLACE INTO `npc_trainer` SELECT `entry`, '23214', '1000000', '0', '0', '60' FROM `creature_template` WHERE `subname`='Paladin Trainer' AND `faction_A`='1604';
тоже у тренера + с недавних пор уровни, с которых классовые маунты доступны, сменились.