diff options
| author | Azcobu <81782124+Azcobu@users.noreply.github.com> | 2021-06-20 01:02:52 +0930 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2021-06-19 17:32:52 +0200 |
| commit | 650ba7f96ace776aa77233a8dbc45b6e66c28e54 (patch) | |
| tree | 06dd69b7faf1ca69c73a4e62bb282b43ddda187b | |
| parent | 7d77c245f082c84010594ea770234b93cee37575 (diff) | |
fix(DB/loot): delete overlevelled items from NPC RLTs (#6335)
| -rw-r--r-- | data/sql/updates/pending_db_world/rev_1623568768400505753.sql | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/data/sql/updates/pending_db_world/rev_1623568768400505753.sql b/data/sql/updates/pending_db_world/rev_1623568768400505753.sql new file mode 100644 index 0000000000..8e391c2d88 --- /dev/null +++ b/data/sql/updates/pending_db_world/rev_1623568768400505753.sql @@ -0,0 +1,13 @@ +INSERT INTO `version_db_world` (`sql_rev`) VALUES ('1623568768400505753'); + +-- Deletes RLT 24054 from lvl 12 Gamon, ID 6466 (96 items/25 level gap) +DELETE FROM `creature_loot_template` WHERE `Entry` = 6466 AND `Reference` = 24054; + +-- Deletes RLT 24042 from lvl 24 Galak Packhound, ID 4250 (12 items/21 level gap) +DELETE FROM `creature_loot_template` WHERE `Entry` = 4250 AND `Reference` = 24042; + +-- Deletes RLT 24056 from lvl 21 Syndicate Rogue, ID 2260 (92 items/17 level gap) +DELETE FROM `creature_loot_template` WHERE `Entry` = 2260 AND `Reference` = 24056; + +-- Deletes RLT 24025 from lvl 37 Rigglefuzz, ID 2817 (108 items/14 level gap) +DELETE FROM `creature_loot_template` WHERE `Entry` = 2817 AND `Reference` = 24025; |