diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/7083_world_creature_template.sql | 5 | ||||
| -rw-r--r-- | sql/updates/7091_world_creature_template.sql | 13 |
2 files changed, 13 insertions, 5 deletions
diff --git a/sql/updates/7083_world_creature_template.sql b/sql/updates/7083_world_creature_template.sql deleted file mode 100644 index b8d69da2a09..00000000000 --- a/sql/updates/7083_world_creature_template.sql +++ /dev/null @@ -1,5 +0,0 @@ --- Usually creature_template changes MUST GO to TDB --- creature_template spell1-spell8 are in the exceptions -UPDATE `creature_template` SET `spell8` = 27892 WHERE `entry` IN (16124, 29987); -UPDATE `creature_template` SET `spell8` = 27928 WHERE `entry` IN (16125, 29985); -UPDATE `creature_template` SET `spell8` = 27935 WHERE `entry` IN (16126, 29986); diff --git a/sql/updates/7091_world_creature_template.sql b/sql/updates/7091_world_creature_template.sql new file mode 100644 index 00000000000..f542985a919 --- /dev/null +++ b/sql/updates/7091_world_creature_template.sql @@ -0,0 +1,13 @@ +-- Usually creature_template changes MUST GO to TDB +-- creature_template spell1-spell8 are in the exceptions + +-- Unrelenting Trainee +UPDATE `creature_template` SET `spell1` = 55604, `spell8` = 27892 WHERE `entry` = 16124; +UPDATE `creature_template` SET `spell1` = 55645, `spell2` = 0, `spell8` = 27892 where `entry` = 29987; + +-- Unrelenting Death Knight +UPDATE `creature_template` SET `spell1` = 27825, `spell8` = 27928 WHERE `entry` IN (16125, 29985); + +-- Unrelenting Rider +UPDATE `creature_template` SET `spell1` = 27831, `spell2` = 55606, `spell8` = 27935 where `entry` = 16126; +UPDATE `creature_template` SET `spell1` = 55638, `spell2` = 55608, `spell8` = 27935 where `entry` = 29986; |