-- -- trainers data. -- -- Riding Instructors UPDATE `creature_template` SET`ScriptName` = 'trainer_raptor' WHERE `entry` = 7953; UPDATE `creature_template` SET`ScriptName` = 'trainer_nightsaber' WHERE `entry` = 4753; UPDATE `creature_template` SET`ScriptName` = 'trainer_undeadhorse' WHERE `entry` = 4773; UPDATE `creature_template` SET`ScriptName` = 'trainer_wolf' WHERE `entry` = 4752; UPDATE `creature_template` SET`ScriptName` = 'trainer_kodo' WHERE `entry` = 3690; UPDATE `creature_template` SET`ScriptName` = 'trainer_horse' WHERE `entry` = 4732; UPDATE `creature_template` SET`ScriptName` = 'trainer_ram' WHERE `entry` = 4772; UPDATE `creature_template` SET`ScriptName` = 'trainer_mechanostrider' WHERE `entry` = 7954; -- -- guards data. -- UPDATE `creature_template` SET`ScriptName` = 'guard_orgrimmar' WHERE `entry` = 3296; UPDATE `creature_template` SET`ScriptName` = 'guard_stormwind' WHERE `entry` = 1423; UPDATE `creature_template` SET`ScriptName` = 'guard_darnassus' WHERE `entry` = 4262; UPDATE `creature_template` SET`ScriptName` = 'guard_teldrassil' WHERE `entry` = 3571; UPDATE `creature_template` SET`ScriptName` = 'guard_ironforge' WHERE `entry` = 5595; UPDATE `creature_template` SET`ScriptName` = 'guard_undercity' WHERE `entry` = 5624; UPDATE `creature_template` SET`ScriptName` = 'guard_bluffwatcher' WHERE `entry` = 3084; UPDATE `creature_template` SET`ScriptName` = 'guard_razorhill' WHERE `entry` = 5953; UPDATE `creature_template` SET`ScriptName` = 'guard_mulgore' WHERE `entry` = 3209 OR `entry` = 3210 OR `entry` = 3211 OR `entry` = 3212 OR `entry` = 3213 OR `entry` = 3214 OR `entry` = 3215 OR `entry` = 3217 OR `entry` = 3218 OR `entry` = 3219 OR `entry` = 3220 OR `entry` = 3221 OR `entry` = 3222 OR `entry` = 3223 OR `entry` = 3224; -- -- Honor data. -- UPDATE `creature_template` SET`ScriptName` = 'private_alliance' WHERE `entry` = 40100; UPDATE `creature_template` SET`ScriptName` = 'corporal_alliance' WHERE `entry` = 40101; UPDATE `creature_template` SET`ScriptName` = 'sergeant_alliance' WHERE `entry` = 40102; UPDATE `creature_template` SET`ScriptName` = 'master_sergeant_alliance' WHERE `entry` = 40103; UPDATE `creature_template` SET`ScriptName` = 'sergeant_major_alliance' WHERE `entry` = 40104; UPDATE `creature_template` SET`ScriptName` = 'knight_alliance' WHERE `entry` = 40105; UPDATE `creature_template` SET`ScriptName` = 'knight_lieutenant_alliance' WHERE `entry` = 40106; UPDATE `creature_template` SET`ScriptName` = 'knight_captain_alliance' WHERE `entry` = 40107; UPDATE `creature_template` SET`ScriptName` = 'knight_champion_alliance' WHERE `entry` = 40108; UPDATE `creature_template` SET`ScriptName` = 'lieutenant_commander_alliance' WHERE `entry` = 40109; UPDATE `creature_template` SET`ScriptName` = 'commander_alliance' WHERE `entry` = 40110; UPDATE `creature_template` SET`ScriptName` = 'marshal_alliance' WHERE `entry` = 40111; UPDATE `creature_template` SET`ScriptName` = 'field_marshal_alliance' WHERE `entry` = 40112; UPDATE `creature_template` SET`ScriptName` = 'grand_marshal_alliance' WHERE `entry` = 40113; UPDATE `creature_template` SET`ScriptName` = 'scout_horde' WHERE `entry` = 40200; UPDATE `creature_template` SET`ScriptName` = 'grunt_horde' WHERE `entry` = 40201; UPDATE `creature_template` SET`ScriptName` = 'sergeant_horde' WHERE `entry` = 40202; UPDATE `creature_template` SET`ScriptName` = 'senior_sergeant_horde' WHERE `entry` = 40203; UPDATE `creature_template` SET`ScriptName` = 'first_sergeant_horde' WHERE `entry` = 40204; UPDATE `creature_template` SET`ScriptName` = 'stone_guard_horde' WHERE `entry` = 40205; UPDATE `creature_template` SET`ScriptName` = 'blood_guard_horde' WHERE `entry` = 40206; UPDATE `creature_template` SET`ScriptName` = 'legionnaire_horde' WHERE `entry` = 40207; UPDATE `creature_template` SET`ScriptName` = 'centurion_horde' WHERE `entry` = 40208; UPDATE `creature_template` SET`ScriptName` = 'champion_horde' WHERE `entry` = 40209; UPDATE `creature_template` SET`ScriptName` = 'lieutenant_general_horde' WHERE `entry` = 40210; UPDATE `creature_template` SET`ScriptName` = 'general_horde' WHERE `entry` = 40211; UPDATE `creature_template` SET`ScriptName` = 'warlord_horde' WHERE `entry` = 40212; UPDATE `creature_template` SET`ScriptName` = 'high_warlord_horde' WHERE `entry` = 40213; -- -- others data. -- UPDATE `creature_template` SET`ScriptName` = 'zeppelinmaster' WHERE `entry` = 9564 OR `entry` = 9566 OR `entry` = 12136 OR `entry` = 12137 OR `entry` = 3149 OR `entry` = 3150 OR `entry` = 3320; UPDATE `creature_template` SET`ScriptName` = 'shipmaster' WHERE `entry` = 9558 OR `entry` = 9559; UPDATE `creature_template` SET`ScriptName` = 'battlemaster' WHERE `entry` = 12198 OR `entry` = 14982 OR `entry` = 857 OR `entry` = 12197 OR `entry` = 7427 OR `entry` = 347 OR `entry` = 15007 OR `entry` = 2804; UPDATE `creature_template` SET`ScriptName` = 'guildmaster' WHERE `entry` = 4974 OR `entry` = 5054 OR `entry` = 4613; -- -- custom data. -- UPDATE `creature_template` SET`ScriptName` = 'marshal_mcbride' WHERE `entry` = 197; UPDATE `creature_template` SET`ScriptName` = 'skorn_whitecloud' WHERE `entry` = 3052; UPDATE `creature_template` SET`ScriptName` = 'kobold' WHERE `entry` = 257;