diff options
| -rw-r--r-- | sql/base/world_database.sql | 30 | ||||
| -rw-r--r-- | sql/updates/9712_world_spell_threat.sql | 76 |
2 files changed, 106 insertions, 0 deletions
diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql index 0cde2c20516..10c64ebfba8 100644 --- a/sql/base/world_database.sql +++ b/sql/base/world_database.sql @@ -14554,6 +14554,36 @@ CREATE TABLE `spell_threat` ( LOCK TABLES `spell_threat` WRITE; /*!40000 ALTER TABLE `spell_threat` DISABLE KEYS */; INSERT INTO `spell_threat` VALUES (78,20),(284,39),(285,59),(770,108),(1608,78),(1672,180),(1715,61),(6572,155),(6574,195),(6809,89),(7372,101),(7373,141),(7379,235),(7386,100),(7405,140),(8380,180),(8972,118),(9745,148),(9880,178),(9881,207),(11556,43),(11564,98),(11565,118),(11566,137),(11567,145),(11596,220),(11597,261),(11600,275),(11601,315),(11775,395),(14921,415),(17735,200),(17750,300),(17751,450),(17752,600),(20736,100),(23922,160),(23923,190),(23924,220),(23925,250),(24394,580),(24583,5),(25286,175),(25288,355),(25289,60),(20243,101),(30016,101),(30022,101),(29707,196),(30324,220),(26996,176),(25258,286),(30356,323),(25269,400),(30357,483),(29704,230),(25225,300),(20569,100),(25231,130),(33745,285),(16857,108),(6343,17),(8198,40),(8204,64),(8205,96),(11580,143),(11581,180),(25264,215),(33878,129),(33986,180),(33987,232),(20925,20),(20927,30),(20928,40),(27179,54),(2139,300); +INSERT INTO `spell_threat` VALUES +(6673,1), +(5242,12), +(6192,22), +(11549,32), +(11550,42), +(11551,52), +(2048,69), +(47436,78), +(47519,175), +(47520,225), +(469,68), +(47439,77), +(47440,80), +(25202,49), +(25203,56), +(47437,63), +(47497,101), +(47498,101), +(47449,233), +(47450,259), +(57823,530), +(12797,25), +(12799,25), +(72,36), +(47487,546), +(47488,770), +(47467,345), +(47501,457), +(47502,555); /*!40000 ALTER TABLE `spell_threat` ENABLE KEYS */; UNLOCK TABLES; diff --git a/sql/updates/9712_world_spell_threat.sql b/sql/updates/9712_world_spell_threat.sql new file mode 100644 index 00000000000..b66444ee913 --- /dev/null +++ b/sql/updates/9712_world_spell_threat.sql @@ -0,0 +1,76 @@ +-- Battle Shout +DELETE FROM `spell_threat` WHERE `entry` IN (6673,5242,6192,11549,11550,11551,2048,47436); +INSERT INTO `spell_threat`(`entry`,`Threat`) VALUES +(6673,1), -- Rank 1 +(5242,12), -- Rank 2 +(6192,22), -- Rank 3 +(11549,32), -- Rank 4 +(11550,42), -- Rank 5 +(11551,52), -- Rank 6 , Rank 7 already in tdb +(2048,69), -- Rank 8 +(47436,78); -- Rank 9 + +-- Cleave +DELETE FROM `spell_threat` WHERE `entry` IN (47519,47520); +INSERT INTO `spell_threat`(`entry`,`Threat`) VALUES +(47519,175), -- Rank 7 +(47520,225); -- Rank 8 + +-- Commanding Shout +DELETE FROM `spell_threat` WHERE `entry` IN (469,47439,47440); +INSERT INTO `spell_threat`(`entry`,`Threat`) VALUES +(469,68), -- Rank 1 +(47439,77), -- Rank 2 +(47440,80); -- Rank 3 + +-- Demoralizing Shout +DELETE FROM `spell_threat` WHERE `entry` IN (25202,25203,47437); +INSERT INTO `spell_threat`(`entry`,`Threat`) VALUES +(25202,49), -- Rank 6 +(25203,56), -- Rank 7 +(47437,63); -- Rank 8 + +-- Devastate +DELETE FROM `spell_threat` WHERE `entry` IN (47497,47498); +INSERT INTO `spell_threat`(`entry`,`Threat`) VALUES +(47497,101), -- Rank 4 +(47498,101); -- Rank 5 + +-- Heroic Strike +DELETE FROM `spell_threat` WHERE `entry` IN (47449,47450); +INSERT INTO `spell_threat`(`entry`,`Threat`) VALUES +(47449,233), -- Rank 12 +(47450,259); -- Rank 13 + +-- Revenge +DELETE FROM `spell_threat` WHERE `entry` IN (57823); +INSERT INTO `spell_threat`(`entry`,`Threat`) VALUES +(57823,530); -- Rank 9 + +-- Improved Revenge (Talented) +DELETE FROM `spell_threat` WHERE `entry` IN (12797,12799); + INSERT INTO `spell_threat`(`entry`,`Threat`) VALUES +(12797,25), -- Rank 1 +(12799,25); -- Rank 2 + +-- Shield Bash +DELETE FROM `spell_threat` WHERE `entry`=72; +INSERT INTO `spell_threat`(`entry`,`Threat`) VALUES +(72,36); + +-- Shield Slam +DELETE FROM `spell_threat` WHERE `entry` IN (47487,47488); +INSERT INTO `spell_threat`(`entry`,`Threat`) VALUES +(47487,546), -- Rank 7 +(47488,770); -- Rank 8 + +-- Sunder Armor (rank 7) +DELETE FROM `spell_threat` WHERE `entry`=47467; +INSERT INTO `spell_threat`(`entry`,`Threat`) VALUES +(47467,345); + +-- Thunder Clap +DELETE FROM `spell_threat` WHERE `entry` IN (47501,47502); +INSERT INTO `spell_threat`(`entry`,`Threat`) VALUES +(47501,457), -- Rank 8 +(47502,555); -- Rank 9 |