diff options
| author | Nay <dnpd.dd@gmail.com> | 2013-08-09 14:20:58 +0100 |
|---|---|---|
| committer | Nay <dnpd.dd@gmail.com> | 2013-08-09 14:21:34 +0100 |
| commit | 32c8555e1ecf264862338b44425f101894caa47c (patch) | |
| tree | 965cbd5fd6a025584fb10f7db3a621f064338ae3 /sql/updates | |
| parent | 92fdb7aed16d1d0869aaa6d93f82a5478a018ffc (diff) | |
DB/NPCs: Remove AIName from npcs that do not have EAI or SAI scripts
Closes #10483
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/world/2013_08_06_05_world_misc.sql | 2 | ||||
| -rw-r--r-- | sql/updates/world/2013_08_09_06_world_ainame.sql | 8 |
2 files changed, 9 insertions, 1 deletions
diff --git a/sql/updates/world/2013_08_06_05_world_misc.sql b/sql/updates/world/2013_08_06_05_world_misc.sql index 15193cc2d09..505cb81e882 100644 --- a/sql/updates/world/2013_08_06_05_world_misc.sql +++ b/sql/updates/world/2013_08_06_05_world_misc.sql @@ -88,7 +88,7 @@ INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position (@NEXT+70, 30593, 571, 1, 64, 6236.617383, 113.980854, 380.351959, 5.6035, 5, 60, 0, 1); -- Frostbrood Destroyers 5 -UPDATE `creature_template` SET `maxlevel`=80,`minlevel`=80,`exp`=2,`InhabitType`=7,`speed_walk`=3,`mindmg` = 1170,`dmg_multiplier` = 2,`attackpower` = 342,`maxdmg` = 3470,`movementtype`=1,`faction_A`=2068, `faction_H`=2068,`AIName`= 'SmartAI' WHERE `entry`= 30575; +UPDATE `creature_template` SET `maxlevel`=80,`minlevel`=80,`exp`=2,`InhabitType`=7,`speed_walk`=3,`mindmg` = 1170,`dmg_multiplier` = 2,`attackpower` = 342,`maxdmg` = 3470,`movementtype`=1,`faction_A`=2068, `faction_H`=2068 WHERE `entry`= 30575; DELETE FROM `creature` WHERE `id`=30575; INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `MovementType`) VALUES (@NEXT+71, 30575,571,1,64,6097.870117, 58.331299, 380.506012, 0.138359, 75,20,1), diff --git a/sql/updates/world/2013_08_09_06_world_ainame.sql b/sql/updates/world/2013_08_09_06_world_ainame.sql new file mode 100644 index 00000000000..fd25f912bd7 --- /dev/null +++ b/sql/updates/world/2013_08_09_06_world_ainame.sql @@ -0,0 +1,8 @@ +UPDATE `creature_template` SET `AIName`='' WHERE `entry`=29400; -- Corrupted Scarlet Onslaught (EAI) +UPDATE `creature_template` SET `AIName`='' WHERE `entry`=29403; -- Onslaught Gryphon (SAI) +UPDATE `creature_template` SET `AIName`='' WHERE `entry`=30210; -- Hodir's Helm KC Bunny (SAI) +UPDATE `creature_template` SET `AIName`='' WHERE `entry`=30575; -- Frostbrood Destroyer (SAI) +UPDATE `creature_template` SET `AIName`='' WHERE `entry`=30841; -- Death Gate (Mograine) (SAI) +UPDATE `creature_template` SET `AIName`='' WHERE `entry`=30850; -- Death Gate (Munch) (SAI) +UPDATE `creature_template` SET `AIName`='' WHERE `entry`=30852; -- Death Gate (Jayde) (SAI) +UPDATE `creature_template` SET `AIName`='' WHERE `entry`=34885; -- Dame Evniki Kapsalis (SAI) |