diff options
author | AzerothCoreBot <azerothcorebot@gmail.com> | 2023-01-28 10:09:32 +0000 |
---|---|---|
committer | AzerothCoreBot <azerothcorebot@gmail.com> | 2023-01-28 10:09:32 +0000 |
commit | 3d0fa25fb8aaec674f165158ba50fee8651f3403 (patch) | |
tree | c0ca4ac648c6ae67348b69dd784f19b1a6131877 | |
parent | ae2e3a4e358fd8d5fda8155e464d18cfacfcc053 (diff) |
chore(DB): import pending files
Referenced commit(s): ae2e3a4e358fd8d5fda8155e464d18cfacfcc053
-rw-r--r-- | data/sql/updates/db_world/2023_01_28_00.sql (renamed from data/sql/updates/pending_db_world/MottRaptor.sql) | 1 | ||||
-rw-r--r-- | data/sql/updates/db_world/2023_01_28_01.sql (renamed from data/sql/updates/pending_db_world/rev_1669573700722721000.sql) | 1 | ||||
-rw-r--r-- | data/sql/updates/db_world/2023_01_28_02.sql (renamed from data/sql/updates/pending_db_world/rev_1670234616926682404.sql) | 1 | ||||
-rw-r--r-- | data/sql/updates/db_world/2023_01_28_03.sql (renamed from data/sql/updates/pending_db_world/rev_1671373040976858200.sql) | 1 | ||||
-rw-r--r-- | data/sql/updates/db_world/2023_01_28_04.sql (renamed from data/sql/updates/pending_db_world/rev_1673692538921177900.sql) | 1 | ||||
-rw-r--r-- | data/sql/updates/db_world/2023_01_28_05.sql (renamed from data/sql/updates/pending_db_world/rev_1674524357697119400.sql) | 1 | ||||
-rw-r--r-- | data/sql/updates/db_world/2023_01_28_06.sql (renamed from data/sql/updates/pending_db_world/rev_1674795014172966200.sql) | 1 | ||||
-rw-r--r-- | data/sql/updates/db_world/2023_01_28_07.sql (renamed from data/sql/updates/pending_db_world/scarab-gong.sql) | 1 | ||||
-rw-r--r-- | data/sql/updates/db_world/2023_01_28_08.sql (renamed from data/sql/updates/pending_db_world/talin-keeneye-esesmx.sql) | 1 | ||||
-rw-r--r-- | data/sql/updates/db_world/2023_01_28_09.sql (renamed from data/sql/updates/pending_db_world/tower-althalaxx-ruru.sql) | 1 |
10 files changed, 10 insertions, 0 deletions
diff --git a/data/sql/updates/pending_db_world/MottRaptor.sql b/data/sql/updates/db_world/2023_01_28_00.sql index c1854c4aec..7503efa3c0 100644 --- a/data/sql/updates/pending_db_world/MottRaptor.sql +++ b/data/sql/updates/db_world/2023_01_28_00.sql @@ -1,3 +1,4 @@ +-- DB update 2023_01_25_03 -> 2023_01_28_00 DELETE FROM `reference_loot_template` WHERE `entry` = 45002 AND `item` in (24063, 24065); INSERT INTO `reference_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES (45002, 24063, 24063, 3, 0, 1, 1, 1, 1, '(ReferenceTable)'); diff --git a/data/sql/updates/pending_db_world/rev_1669573700722721000.sql b/data/sql/updates/db_world/2023_01_28_01.sql index 6249769f9e..e03cddc89e 100644 --- a/data/sql/updates/pending_db_world/rev_1669573700722721000.sql +++ b/data/sql/updates/db_world/2023_01_28_01.sql @@ -1,3 +1,4 @@ +-- DB update 2023_01_28_00 -> 2023_01_28_01 -- Changed Violet Hold door to Smart_Script DELETE FROM `smart_scripts` WHERE `entryorguid` = 193020; INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `event_param5`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES diff --git a/data/sql/updates/pending_db_world/rev_1670234616926682404.sql b/data/sql/updates/db_world/2023_01_28_02.sql index c650b465e0..39465bf155 100644 --- a/data/sql/updates/pending_db_world/rev_1670234616926682404.sql +++ b/data/sql/updates/db_world/2023_01_28_02.sql @@ -1,3 +1,4 @@ +-- DB update 2023_01_28_01 -> 2023_01_28_02 -- Add Chinese translation of Wand of Allistarj DELETE FROM `item_template_locale` WHERE `ID`=13065 AND `locale` = 'zhCN'; INSERT INTO `item_template_locale` (`ID`, `locale`, `Name`, `Description`, `VerifiedBuild`) VALUES diff --git a/data/sql/updates/pending_db_world/rev_1671373040976858200.sql b/data/sql/updates/db_world/2023_01_28_03.sql index 56ba0d9a67..032829ffc2 100644 --- a/data/sql/updates/pending_db_world/rev_1671373040976858200.sql +++ b/data/sql/updates/db_world/2023_01_28_03.sql @@ -1,3 +1,4 @@ +-- DB update 2023_01_28_02 -> 2023_01_28_03 DELETE FROM `item_template_locale` WHERE `ID` = 11000 AND `locale` IN ('esES', 'esMX'); INSERT INTO `item_template_locale` (`ID`, `locale`, `Name`, `Description`, `VerifiedBuild`) VALUES (11000, 'esES', 'Llave Sombratiniebla', 'Maestro de la llave de las Profundidades, Cortesía de F.F.F.', 0), diff --git a/data/sql/updates/pending_db_world/rev_1673692538921177900.sql b/data/sql/updates/db_world/2023_01_28_04.sql index 8fa082ff02..2c9e4a97bb 100644 --- a/data/sql/updates/pending_db_world/rev_1673692538921177900.sql +++ b/data/sql/updates/db_world/2023_01_28_04.sql @@ -1,2 +1,3 @@ +-- DB update 2023_01_28_03 -> 2023_01_28_04 -- UPDATE `spell_proc_event` SET `SpellFamilyMask1`=16777216 WHERE `entry`=-51521; diff --git a/data/sql/updates/pending_db_world/rev_1674524357697119400.sql b/data/sql/updates/db_world/2023_01_28_05.sql index d2bdcd2a64..491d67ee87 100644 --- a/data/sql/updates/pending_db_world/rev_1674524357697119400.sql +++ b/data/sql/updates/db_world/2023_01_28_05.sql @@ -1,2 +1,3 @@ +-- DB update 2023_01_28_04 -> 2023_01_28_05 -- UPDATE `creature_template` SET `mechanic_immune_mask` = `mechanic_immune_mask`|1|2|4|8|16|32|64|1024|65536|4194304|8388608|67108864 WHERE `entry` IN (15725, 15728, 15334, 15726, 15802); diff --git a/data/sql/updates/pending_db_world/rev_1674795014172966200.sql b/data/sql/updates/db_world/2023_01_28_06.sql index 37999b8c5e..d6df348de6 100644 --- a/data/sql/updates/pending_db_world/rev_1674795014172966200.sql +++ b/data/sql/updates/db_world/2023_01_28_06.sql @@ -1,3 +1,4 @@ +-- DB update 2023_01_28_05 -> 2023_01_28_06 -- DELETE FROM `creature_onkill_reputation` WHERE `creature_id` = 18413; diff --git a/data/sql/updates/pending_db_world/scarab-gong.sql b/data/sql/updates/db_world/2023_01_28_07.sql index f08554a05a..951b64f1ee 100644 --- a/data/sql/updates/pending_db_world/scarab-gong.sql +++ b/data/sql/updates/db_world/2023_01_28_07.sql @@ -1 +1,2 @@ +-- DB update 2023_01_28_06 -> 2023_01_28_07 UPDATE `gameobject_template` SET `type` = 2 WHERE `entry` = 180717; diff --git a/data/sql/updates/pending_db_world/talin-keeneye-esesmx.sql b/data/sql/updates/db_world/2023_01_28_08.sql index f06a9806fe..38f1535197 100644 --- a/data/sql/updates/pending_db_world/talin-keeneye-esesmx.sql +++ b/data/sql/updates/db_world/2023_01_28_08.sql @@ -1,3 +1,4 @@ +-- DB update 2023_01_28_07 -> 2023_01_28_08 DELETE FROM `npc_text_locale` WHERE `ID` = 50022 AND `Locale` IN ('esES', 'esMX'); INSERT INTO `npc_text_locale` (`ID`, `Locale`, `Text0_0`) VALUES (50022, 'esES', '¡Saludos, $c! Un día perfecto para ir a cazar, ¿no te parece? He estado teniendo bastante suerte con los jabalíes. ¿Te gustaría intentarlo?'), diff --git a/data/sql/updates/pending_db_world/tower-althalaxx-ruru.sql b/data/sql/updates/db_world/2023_01_28_09.sql index 38223aced7..202022d128 100644 --- a/data/sql/updates/pending_db_world/tower-althalaxx-ruru.sql +++ b/data/sql/updates/db_world/2023_01_28_09.sql @@ -1 +1,2 @@ +-- DB update 2023_01_28_08 -> 2023_01_28_09 UPDATE `quest_template_locale` SET `ObjectiveText1` = 'Освободите душу высокорожденного на Ночной поляне', `ObjectiveText2` = 'Освободите душу высокорожденного в Сатирнааре' WHERE `ID` = 1140 AND `locale` = 'ruRU'; |