jestli myslis tohodle na stance tak tady ho mas:-)
-- 13.8.2008 21:52:57
DELETE FROM `creature_template` WHERE (`entry`=123456);
INSERT INTO `creature_template` (`entry`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `baseattacktime`, `rangeattacktime`, `flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `class`, `race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `flag1`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `RacialLeader`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `ScriptName`) VALUES (123456, 17212, 0, 17212, 0, 'Stance Trainer', 'Warrior Trainer', '', 40, 40, 1500, 1500, 0, 0, 20, 35, 35, 19, 1.125, 1, 0, 12, 42, 0, 185, 2000, 0, 4608, 0, 0, 0, 0, 1, 0, 0, 0, 100, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 1, 3, 0, 1, 0, 0, '');
-- 13.8.2008 22:33:03
DELETE FROM `npc_trainer` WHERE (`entry`=123456);
INSERT INTO `npc_trainer` (entry, spell, spellcost, reqskill, reqskillvalue, reqlevel) VALUES
(123456, 2458, 0, 0, 0, 1),
(123456, 355, 0, 0, 0, 1),
(123456, 71, 0, 0, 0, 1);