SADraco
11.02.2016, 13:12
I have been working a db colaberating with yours and so i am sharing what i have
For the NPC that runs after you when you hit them here is a fix work arround i am using .
-- Training dummies Each Faction starting Zone - Prevents them from running after you
-- ----------------------------------------------------------------------------------
-- ---------------------------------------------------
-- Training Dummy - Northshire Valley - Human Starting
-- ---------------------------------------------------
UPDATE `creature_template` SET `UnitFlags` = 131076, `DynamicFlags` = 4, `ExtraFlags` = 64 WHERE `entry` = 44548;
UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = 44548;
UPDATE `creature` SET `spawntimesecs` = 1 WHERE `id` = 44548;
DELETE FROM `creature_ai_scripts` WHERE (`id`=273831000);
INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES (273831000, 44548, 2, 0, 100, 1, 2, 1, 1000, 1000, 42, 1, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'PSDB');
DELETE FROM `creature_ai_scripts` WHERE (`id`=273831001);
INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES (273831001, 44548, 4, 0, 100, 0, 0, 0, 0, 0, 20, 0, 0, 0, 21, 0, 0, 0, 0, 0, 0, 0, 'PSDB');
-- -----------------------------------------------------------
-- Training Dummy - Darkspear Training Ground - Troll Starting
-- -----------------------------------------------------------
UPDATE `creature_template` SET `UnitFlags` = 131076, `DynamicFlags` = 4, `ExtraFlags` = 64 WHERE `entry` = 38038;
UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = 38038;
UPDATE `creature` SET `spawntimesecs` = 1 WHERE `id` = 38038;
DELETE FROM `creature_ai_scripts` WHERE (`id`=273831002);
INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES (273831002, 38038, 2, 0, 100, 1, 2, 1, 1000, 1000, 42, 1, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'PSDB');
DELETE FROM `creature_ai_scripts` WHERE (`id`=273831003);
INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES (273831003, 38038, 4, 0, 100, 0, 0, 0, 0, 0, 20, 0, 0, 0, 21, 0, 0, 0, 0, 0, 0, 0, 'PSDB');
-- ------------------------------------------------
-- Training Dummy - Valley of Trials - Orc Starting
-- ------------------------------------------------
UPDATE `creature_template` SET `UnitFlags` = 131076, `DynamicFlags` = 4, `ExtraFlags` = 64 WHERE `entry` = 44820;
UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = 44820;
UPDATE `creature` SET `spawntimesecs` = 1 WHERE `id` = 44820;
DELETE FROM `creature_ai_scripts` WHERE (`id`=273831004);
INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES (273831004, 44820, 2, 0, 100, 1, 2, 1, 1000, 1000, 42, 1, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'PSDB');
DELETE FROM `creature_ai_scripts` WHERE (`id`=273831005);
INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES (273831005, 44820, 4, 0, 100, 0, 0, 0, 0, 0, 20, 0, 0, 0, 21, 0, 0, 0, 0, 0, 0, 0, 'PSDB');
-- ------------------------------------------------
-- Training Dummy - Camp Narache - Tauren Starting
-- ------------------------------------------------
UPDATE `creature_template` SET `UnitFlags` = 131076, `DynamicFlags` = 4, `ExtraFlags` = 64 WHERE `entry` = 44848;
UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = 44848;
UPDATE `creature` SET `spawntimesecs` = 1 WHERE `id` = 44848;
DELETE FROM `creature_ai_scripts` WHERE (`id`=273831006);
INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES (273831006, 44848, 2, 0, 100, 1, 2, 1, 1000, 1000, 42, 1, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'PSDB');
DELETE FROM `creature_ai_scripts` WHERE (`id`=273831007);
INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES (273831007, 44848, 4, 0, 100, 0, 0, 0, 0, 0, 20, 0, 0, 0, 21, 0, 0, 0, 0, 0, 0, 0, 'PSDB');
-- ------------------------------------------------
-- Training Dummy - Deathknell - Undead Starting
-- ------------------------------------------------
UPDATE `creature_template` SET `UnitFlags` = 131076, `DynamicFlags` = 4, `ExtraFlags` = 64 WHERE `entry` = 44794;
UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = 44794;
UPDATE `creature` SET `spawntimesecs` = 1 WHERE `id` = 44794;
DELETE FROM `creature_ai_scripts` WHERE (`id`=273831008);
INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES (273831008, 44794, 2, 0, 100, 1, 2, 1, 1000, 1000, 42, 1, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'PSDB');
DELETE FROM `creature_ai_scripts` WHERE (`id`=273831009);
INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES (273831009, 44794, 4, 0, 100, 0, 0, 0, 0, 0, 20, 0, 0, 0, 21, 0, 0, 0, 0, 0, 0, 0, 'PSDB');
-- ------------------------------------------------
-- Training Dummy - Sunstrider Isle - Bloodelf Starting
-- ------------------------------------------------
UPDATE `creature_template` SET `UnitFlags` = 131076, `DynamicFlags` = 4, `ExtraFlags` = 64 WHERE `entry` = 44937;
UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = 44937;
UPDATE `creature` SET `spawntimesecs` = 1 WHERE `id` = 44937;
DELETE FROM `creature_ai_scripts` WHERE (`id`=273831010);
INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES (273831010, 44937, 2, 0, 100, 1, 2, 1, 1000, 1000, 42, 1, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'PSDB');
DELETE FROM `creature_ai_scripts` WHERE (`id`=273831011);
INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES (273831011, 44937, 4, 0, 100, 0, 0, 0, 0, 0, 20, 0, 0, 0, 21, 0, 0, 0, 0, 0, 0, 0, 'PSDB');
-- ------------------------------------------------
-- Training Dummy - Anvilmar - Dwarf Starting
-- ------------------------------------------------
UPDATE `creature_template` SET `UnitFlags` = 131076, `DynamicFlags` = 4, `ExtraFlags` = 64 WHERE `entry` = 44389;
UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = 44389;
UPDATE `creature` SET `spawntimesecs` = 1 WHERE `id` = 44389;
DELETE FROM `creature_ai_scripts` WHERE (`id`=273831012);
INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES (273831012, 44389, 2, 0, 100, 1, 2, 1, 1000, 1000, 42, 1, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'PSDB');
DELETE FROM `creature_ai_scripts` WHERE (`id`=273831013);
INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES (273831013, 44389, 4, 0, 100, 0, 0, 0, 0, 0, 20, 0, 0, 0, 21, 0, 0, 0, 0, 0, 0, 0, 'PSDB');
-- ------------------------------------------------
-- Training Dummy - Aldrassil - Night Elf Starting
-- ------------------------------------------------
UPDATE `creature_template` SET `UnitFlags` = 131076, `DynamicFlags` = 4, `ExtraFlags` = 64 WHERE `entry` = 44616;
UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = 44616;
UPDATE `creature` SET `spawntimesecs` = 1 WHERE `id` = 44616;
DELETE FROM `creature_ai_scripts` WHERE (`id`=273831014);
INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES (273831014, 44616, 2, 0, 100, 1, 2, 1, 1000, 1000, 42, 1, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'PSDB');
DELETE FROM `creature_ai_scripts` WHERE (`id`=273831015);
INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES (273831015, 44616, 4, 0, 100, 0, 0, 0, 0, 0, 20, 0, 0, 0, 21, 0, 0, 0, 0, 0, 0, 0, 'PSDB');
-- ------------------------------------------------
-- Training Dummy - New Tinkertown - Gnome Starting
-- ------------------------------------------------
UPDATE `creature_template` SET `UnitFlags` = 131076, `DynamicFlags` = 4, `ExtraFlags` = 64 WHERE `entry` = 44171;
UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = 44171;
UPDATE `creature` SET `spawntimesecs` = 1 WHERE `id` = 44171;
DELETE FROM `creature_ai_scripts` WHERE (`id`=273831016);
INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES (273831016, 44171, 2, 0, 100, 1, 2, 1, 1000, 1000, 42, 1, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'PSDB');
DELETE FROM `creature_ai_scripts` WHERE (`id`=273831017);
INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES (273831017, 44171, 4, 0, 100, 0, 0, 0, 0, 0, 20, 0, 0, 0, 21, 0, 0, 0, 0, 0, 0, 0, 'PSDB');
-- ------------------------------------------------
-- Training Dummy - New Tinkertown - Gnome Starting
-- ------------------------------------------------
UPDATE `creature_template` SET `UnitFlags` = 131076, `DynamicFlags` = 4, `ExtraFlags` = 64 WHERE `entry` = 44703;
UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = 44703;
UPDATE `creature` SET `spawntimesecs` = 1 WHERE `id` = 44703;
DELETE FROM `creature_ai_scripts` WHERE (`id`=273831018);
INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES (273831018, 44703, 2, 0, 100, 1, 2, 1, 1000, 1000, 42, 1, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'PSDB');
DELETE FROM `creature_ai_scripts` WHERE (`id`=273831019);
INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES (273831019, 44703, 4, 0, 100, 0, 0, 0, 0, 0, 20, 0, 0, 0, 21, 0, 0, 0, 0, 0, 0, 0, 'PSDB');
-- Goblins
-- -------
UPDATE `creature_template` SET `UnitFlags` = 131076, `DynamicFlags` = 4, `ExtraFlags` = 64 WHERE `entry` = 48304;
UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = 48304;
UPDATE `creature` SET `spawntimesecs` = 1 WHERE `id` = 48304;
DELETE FROM `creature_ai_scripts` WHERE (`id`=273831020);
INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES (273831020, 48304, 2, 0, 100, 1, 2, 1, 1000, 1000, 42, 1, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'PSDB');
DELETE FROM `creature_ai_scripts` WHERE (`id`=273831021);
INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES (273831021, 48304, 4, 0, 100, 0, 0, 0, 0, 0, 20, 0, 0, 0, 21, 0, 0, 0, 0, 0, 0, 0, 'PSDB');
-- Night Elfs
-- ----------
UPDATE `creature_template` SET `UnitFlags` = 131076, `DynamicFlags` = 4, `ExtraFlags` = 64 WHERE `entry` = 44614;
UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = 44614;
UPDATE `creature` SET `spawntimesecs` = 1 WHERE `id` = 44614;
DELETE FROM `creature_ai_scripts` WHERE (`id`=273831022);
INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES (273831022, 44614, 2, 0, 100, 1, 2, 1, 1000, 1000, 42, 1, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'PSDB');
DELETE FROM `creature_ai_scripts` WHERE (`id`=273831023);
INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES (273831023, 44614, 4, 0, 100, 0, 0, 0, 0, 0, 20, 0, 0, 0, 21, 0, 0, 0, 0, 0, 0, 0, 'PSDB');
Hope this helps
For the NPC that runs after you when you hit them here is a fix work arround i am using .
-- Training dummies Each Faction starting Zone - Prevents them from running after you
-- ----------------------------------------------------------------------------------
-- ---------------------------------------------------
-- Training Dummy - Northshire Valley - Human Starting
-- ---------------------------------------------------
UPDATE `creature_template` SET `UnitFlags` = 131076, `DynamicFlags` = 4, `ExtraFlags` = 64 WHERE `entry` = 44548;
UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = 44548;
UPDATE `creature` SET `spawntimesecs` = 1 WHERE `id` = 44548;
DELETE FROM `creature_ai_scripts` WHERE (`id`=273831000);
INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES (273831000, 44548, 2, 0, 100, 1, 2, 1, 1000, 1000, 42, 1, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'PSDB');
DELETE FROM `creature_ai_scripts` WHERE (`id`=273831001);
INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES (273831001, 44548, 4, 0, 100, 0, 0, 0, 0, 0, 20, 0, 0, 0, 21, 0, 0, 0, 0, 0, 0, 0, 'PSDB');
-- -----------------------------------------------------------
-- Training Dummy - Darkspear Training Ground - Troll Starting
-- -----------------------------------------------------------
UPDATE `creature_template` SET `UnitFlags` = 131076, `DynamicFlags` = 4, `ExtraFlags` = 64 WHERE `entry` = 38038;
UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = 38038;
UPDATE `creature` SET `spawntimesecs` = 1 WHERE `id` = 38038;
DELETE FROM `creature_ai_scripts` WHERE (`id`=273831002);
INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES (273831002, 38038, 2, 0, 100, 1, 2, 1, 1000, 1000, 42, 1, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'PSDB');
DELETE FROM `creature_ai_scripts` WHERE (`id`=273831003);
INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES (273831003, 38038, 4, 0, 100, 0, 0, 0, 0, 0, 20, 0, 0, 0, 21, 0, 0, 0, 0, 0, 0, 0, 'PSDB');
-- ------------------------------------------------
-- Training Dummy - Valley of Trials - Orc Starting
-- ------------------------------------------------
UPDATE `creature_template` SET `UnitFlags` = 131076, `DynamicFlags` = 4, `ExtraFlags` = 64 WHERE `entry` = 44820;
UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = 44820;
UPDATE `creature` SET `spawntimesecs` = 1 WHERE `id` = 44820;
DELETE FROM `creature_ai_scripts` WHERE (`id`=273831004);
INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES (273831004, 44820, 2, 0, 100, 1, 2, 1, 1000, 1000, 42, 1, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'PSDB');
DELETE FROM `creature_ai_scripts` WHERE (`id`=273831005);
INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES (273831005, 44820, 4, 0, 100, 0, 0, 0, 0, 0, 20, 0, 0, 0, 21, 0, 0, 0, 0, 0, 0, 0, 'PSDB');
-- ------------------------------------------------
-- Training Dummy - Camp Narache - Tauren Starting
-- ------------------------------------------------
UPDATE `creature_template` SET `UnitFlags` = 131076, `DynamicFlags` = 4, `ExtraFlags` = 64 WHERE `entry` = 44848;
UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = 44848;
UPDATE `creature` SET `spawntimesecs` = 1 WHERE `id` = 44848;
DELETE FROM `creature_ai_scripts` WHERE (`id`=273831006);
INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES (273831006, 44848, 2, 0, 100, 1, 2, 1, 1000, 1000, 42, 1, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'PSDB');
DELETE FROM `creature_ai_scripts` WHERE (`id`=273831007);
INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES (273831007, 44848, 4, 0, 100, 0, 0, 0, 0, 0, 20, 0, 0, 0, 21, 0, 0, 0, 0, 0, 0, 0, 'PSDB');
-- ------------------------------------------------
-- Training Dummy - Deathknell - Undead Starting
-- ------------------------------------------------
UPDATE `creature_template` SET `UnitFlags` = 131076, `DynamicFlags` = 4, `ExtraFlags` = 64 WHERE `entry` = 44794;
UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = 44794;
UPDATE `creature` SET `spawntimesecs` = 1 WHERE `id` = 44794;
DELETE FROM `creature_ai_scripts` WHERE (`id`=273831008);
INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES (273831008, 44794, 2, 0, 100, 1, 2, 1, 1000, 1000, 42, 1, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'PSDB');
DELETE FROM `creature_ai_scripts` WHERE (`id`=273831009);
INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES (273831009, 44794, 4, 0, 100, 0, 0, 0, 0, 0, 20, 0, 0, 0, 21, 0, 0, 0, 0, 0, 0, 0, 'PSDB');
-- ------------------------------------------------
-- Training Dummy - Sunstrider Isle - Bloodelf Starting
-- ------------------------------------------------
UPDATE `creature_template` SET `UnitFlags` = 131076, `DynamicFlags` = 4, `ExtraFlags` = 64 WHERE `entry` = 44937;
UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = 44937;
UPDATE `creature` SET `spawntimesecs` = 1 WHERE `id` = 44937;
DELETE FROM `creature_ai_scripts` WHERE (`id`=273831010);
INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES (273831010, 44937, 2, 0, 100, 1, 2, 1, 1000, 1000, 42, 1, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'PSDB');
DELETE FROM `creature_ai_scripts` WHERE (`id`=273831011);
INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES (273831011, 44937, 4, 0, 100, 0, 0, 0, 0, 0, 20, 0, 0, 0, 21, 0, 0, 0, 0, 0, 0, 0, 'PSDB');
-- ------------------------------------------------
-- Training Dummy - Anvilmar - Dwarf Starting
-- ------------------------------------------------
UPDATE `creature_template` SET `UnitFlags` = 131076, `DynamicFlags` = 4, `ExtraFlags` = 64 WHERE `entry` = 44389;
UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = 44389;
UPDATE `creature` SET `spawntimesecs` = 1 WHERE `id` = 44389;
DELETE FROM `creature_ai_scripts` WHERE (`id`=273831012);
INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES (273831012, 44389, 2, 0, 100, 1, 2, 1, 1000, 1000, 42, 1, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'PSDB');
DELETE FROM `creature_ai_scripts` WHERE (`id`=273831013);
INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES (273831013, 44389, 4, 0, 100, 0, 0, 0, 0, 0, 20, 0, 0, 0, 21, 0, 0, 0, 0, 0, 0, 0, 'PSDB');
-- ------------------------------------------------
-- Training Dummy - Aldrassil - Night Elf Starting
-- ------------------------------------------------
UPDATE `creature_template` SET `UnitFlags` = 131076, `DynamicFlags` = 4, `ExtraFlags` = 64 WHERE `entry` = 44616;
UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = 44616;
UPDATE `creature` SET `spawntimesecs` = 1 WHERE `id` = 44616;
DELETE FROM `creature_ai_scripts` WHERE (`id`=273831014);
INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES (273831014, 44616, 2, 0, 100, 1, 2, 1, 1000, 1000, 42, 1, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'PSDB');
DELETE FROM `creature_ai_scripts` WHERE (`id`=273831015);
INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES (273831015, 44616, 4, 0, 100, 0, 0, 0, 0, 0, 20, 0, 0, 0, 21, 0, 0, 0, 0, 0, 0, 0, 'PSDB');
-- ------------------------------------------------
-- Training Dummy - New Tinkertown - Gnome Starting
-- ------------------------------------------------
UPDATE `creature_template` SET `UnitFlags` = 131076, `DynamicFlags` = 4, `ExtraFlags` = 64 WHERE `entry` = 44171;
UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = 44171;
UPDATE `creature` SET `spawntimesecs` = 1 WHERE `id` = 44171;
DELETE FROM `creature_ai_scripts` WHERE (`id`=273831016);
INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES (273831016, 44171, 2, 0, 100, 1, 2, 1, 1000, 1000, 42, 1, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'PSDB');
DELETE FROM `creature_ai_scripts` WHERE (`id`=273831017);
INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES (273831017, 44171, 4, 0, 100, 0, 0, 0, 0, 0, 20, 0, 0, 0, 21, 0, 0, 0, 0, 0, 0, 0, 'PSDB');
-- ------------------------------------------------
-- Training Dummy - New Tinkertown - Gnome Starting
-- ------------------------------------------------
UPDATE `creature_template` SET `UnitFlags` = 131076, `DynamicFlags` = 4, `ExtraFlags` = 64 WHERE `entry` = 44703;
UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = 44703;
UPDATE `creature` SET `spawntimesecs` = 1 WHERE `id` = 44703;
DELETE FROM `creature_ai_scripts` WHERE (`id`=273831018);
INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES (273831018, 44703, 2, 0, 100, 1, 2, 1, 1000, 1000, 42, 1, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'PSDB');
DELETE FROM `creature_ai_scripts` WHERE (`id`=273831019);
INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES (273831019, 44703, 4, 0, 100, 0, 0, 0, 0, 0, 20, 0, 0, 0, 21, 0, 0, 0, 0, 0, 0, 0, 'PSDB');
-- Goblins
-- -------
UPDATE `creature_template` SET `UnitFlags` = 131076, `DynamicFlags` = 4, `ExtraFlags` = 64 WHERE `entry` = 48304;
UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = 48304;
UPDATE `creature` SET `spawntimesecs` = 1 WHERE `id` = 48304;
DELETE FROM `creature_ai_scripts` WHERE (`id`=273831020);
INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES (273831020, 48304, 2, 0, 100, 1, 2, 1, 1000, 1000, 42, 1, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'PSDB');
DELETE FROM `creature_ai_scripts` WHERE (`id`=273831021);
INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES (273831021, 48304, 4, 0, 100, 0, 0, 0, 0, 0, 20, 0, 0, 0, 21, 0, 0, 0, 0, 0, 0, 0, 'PSDB');
-- Night Elfs
-- ----------
UPDATE `creature_template` SET `UnitFlags` = 131076, `DynamicFlags` = 4, `ExtraFlags` = 64 WHERE `entry` = 44614;
UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = 44614;
UPDATE `creature` SET `spawntimesecs` = 1 WHERE `id` = 44614;
DELETE FROM `creature_ai_scripts` WHERE (`id`=273831022);
INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES (273831022, 44614, 2, 0, 100, 1, 2, 1, 1000, 1000, 42, 1, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'PSDB');
DELETE FROM `creature_ai_scripts` WHERE (`id`=273831023);
INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES (273831023, 44614, 4, 0, 100, 0, 0, 0, 0, 0, 20, 0, 0, 0, 21, 0, 0, 0, 0, 0, 0, 0, 'PSDB');
Hope this helps