DB/Locales: Add some missing item deDE locales

Closes #25830

1 files changed, 98 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2021_01_11_04_world_335.sql b/sql/updates/world/3.3.5/2021_01_11_04_world_335.sql
new file mode 100644
index 00000000000..d54ca498f70
--- /dev/null
+++ b/sql/updates/world/3.3.5/2021_01_11_04_world_335.sql
@@ -0,0 +1,98 @@
+-- Item 15054 - add missing data
+-- https://de.classic.wowhead.com/item=15054/vulkanische-gamaschen
+-- https://de.wowhead.com/item=15054/vulkanische-gamaschen?bonus=6882
+-- old GTDB WotLK Files
+DELETE FROM `item_template_locale` WHERE `ID` = 15054 AND `locale` = 'deDE';
+INSERT INTO `item_template_locale` (`ID`, `locale`, `Name`, `Description`, `VerifiedBuild`) VALUES
+(15054, 'deDE', 'Vulkanische Gamaschen', '', 0);
+DELETE FROM `item_set_names_locale` WHERE `ID` = 15054 AND `locale` = 'deDE';
+INSERT INTO `item_set_names_locale` (`ID`, `locale`, `Name`, `VerifiedBuild`) VALUES
+(15054, 'deDE', 'Vulkanische Gamaschen', 0);
+
+-- Item 22095 - add missing data
+-- https://de.classic.wowhead.com/item=22095/bindungen-der-fünf-donner
+-- https://de.wowhead.com/item=22095/bindungen-der-fünf-donner
+-- old GTDB WotLK Files
+DELETE FROM `item_template_locale` WHERE `ID` = 22095 AND `locale` = 'deDE';
+INSERT INTO `item_template_locale` (`ID`, `locale`, `Name`, `Description`, `VerifiedBuild`) VALUES
+(22095, 'deDE', 'Bindungen der fünf Donner', '', 0);
+DELETE FROM `item_set_names_locale` WHERE `ID` = 22095 AND `locale` = 'deDE';
+INSERT INTO `item_set_names_locale` (`ID`, `locale`, `Name`, `VerifiedBuild`) VALUES
+(22095, 'deDE', 'Bindungen der fünf Donner', 0);
+
+-- Item 22096 - add missing data
+-- https://de.classic.wowhead.com/item=22096/stiefel-der-fünf-donner
+-- https://de.wowhead.com/item=22096/stiefel-der-fünf-donner
+-- old GTDB WotLK Files
+DELETE FROM `item_template_locale` WHERE `ID` = 22096 AND `locale` = 'deDE';
+INSERT INTO `item_template_locale` (`ID`, `locale`, `Name`, `Description`, `VerifiedBuild`) VALUES
+(22096, 'deDE', 'Stiefel der fünf Donner', '', 0);
+DELETE FROM `item_set_names_locale` WHERE `ID` = 22096 AND `locale` = 'deDE';
+INSERT INTO `item_set_names_locale` (`ID`, `locale`, `Name`, `VerifiedBuild`) VALUES
+(22096, 'deDE', 'Stiefel der fünf Donner', 0);
+
+-- Item 22097 - add missing data
+-- https://de.classic.wowhead.com/item=22097/helmkappe-der-fünf-donner
+-- https://de.wowhead.com/item=22097/helmkappe-der-fünf-donner
+-- old GTDB WotLK Files
+DELETE FROM `item_template_locale` WHERE `ID` = 22097 AND `locale` = 'deDE';
+INSERT INTO `item_template_locale` (`ID`, `locale`, `Name`, `Description`, `VerifiedBuild`) VALUES
+(22097, 'deDE', 'Helmkappe der fünf Donner', '', 0);
+DELETE FROM `item_set_names_locale` WHERE `ID` = 22097 AND `locale` = 'deDE';
+INSERT INTO `item_set_names_locale` (`ID`, `locale`, `Name`, `VerifiedBuild`) VALUES
+(22097, 'deDE', 'Helmkappe der fünf Donner', 0);
+
+-- Item 22098 - add missing data
+-- https://de.classic.wowhead.com/item=22098/kordel-der-fünf-donner
+-- https://de.wowhead.com/item=22098/kordel-der-fünf-donner
+-- old GTDB WotLK Files
+DELETE FROM `item_template_locale` WHERE `ID` = 22098 AND `locale` = 'deDE';
+INSERT INTO `item_template_locale` (`ID`, `locale`, `Name`, `Description`, `VerifiedBuild`) VALUES
+(22098, 'deDE', 'Kordel der fünf Donner', '', 0);
+DELETE FROM `item_set_names_locale` WHERE `ID` = 22098 AND `locale` = 'deDE';
+INSERT INTO `item_set_names_locale` (`ID`, `locale`, `Name`, `VerifiedBuild`) VALUES
+(22098, 'deDE', 'Kordel der fünf Donner', 0);
+
+-- Item 22099 - add missing data
+-- https://de.classic.wowhead.com/item=22099/stulpen-der-fünf-donner
+-- https://de.wowhead.com/item=22099/stulpen-der-fünf-donner
+-- old GTDB WotLK Files
+DELETE FROM `item_template_locale` WHERE `ID` = 22099 AND `locale` = 'deDE';
+INSERT INTO `item_template_locale` (`ID`, `locale`, `Name`, `Description`, `VerifiedBuild`) VALUES
+(22099, 'deDE', 'Stulpen der fünf Donner', '', 0);
+DELETE FROM `item_set_names_locale` WHERE `ID` = 22099 AND `locale` = 'deDE';
+INSERT INTO `item_set_names_locale` (`ID`, `locale`, `Name`, `VerifiedBuild`) VALUES
+(22099, 'deDE', 'Stulpen der fünf Donner', 0);
+
+-- Item 22100 - add missing data
+-- https://de.classic.wowhead.com/item=22100/kilt-der-fünf-donner
+-- https://de.wowhead.com/item=22100/kilt-der-fünf-donner
+-- old GTDB WotLK Files
+DELETE FROM `item_template_locale` WHERE `ID` = 22100 AND `locale` = 'deDE';
+INSERT INTO `item_template_locale` (`ID`, `locale`, `Name`, `Description`, `VerifiedBuild`) VALUES
+(22100, 'deDE', 'Kilt der fünf Donner', '', 0);
+DELETE FROM `item_set_names_locale` WHERE `ID` = 22100 AND `locale` = 'deDE';
+INSERT INTO `item_set_names_locale` (`ID`, `locale`, `Name`, `VerifiedBuild`) VALUES
+(22100, 'deDE', 'Kilt der fünf Donner', 0);
+
+-- Item 22101 - add missing data
+-- https://de.classic.wowhead.com/item=22101/schulterstücke-der-fünf-donner
+-- https://de.wowhead.com/item=22101/schulterstücke-der-fünf-donner
+-- old GTDB WotLK Files
+DELETE FROM `item_template_locale` WHERE `ID` = 22101 AND `locale` = 'deDE';
+INSERT INTO `item_template_locale` (`ID`, `locale`, `Name`, `Description`, `VerifiedBuild`) VALUES
+(22101, 'deDE', 'Schulterstücke der fünf Donner', '', 0);
+DELETE FROM `item_set_names_locale` WHERE `ID` = 22101 AND `locale` = 'deDE';
+INSERT INTO `item_set_names_locale` (`ID`, `locale`, `Name`, `VerifiedBuild`) VALUES
+(22101, 'deDE', 'Schulterstücke der fünf Donner', 0);
+
+-- Item 22102 - add missing data
+-- https://de.classic.wowhead.com/item=22102/weste-der-fünf-donner
+-- https://de.wowhead.com/item=22102/weste-der-fünf-donner
+-- old GTDB WotLK Files
+DELETE FROM `item_template_locale` WHERE `ID` = 22102 AND `locale` = 'deDE';
+INSERT INTO `item_template_locale` (`ID`, `locale`, `Name`, `Description`, `VerifiedBuild`) VALUES
+(22102, 'deDE', 'Weste der fünf Donner', '', 0);
+DELETE FROM `item_set_names_locale` WHERE `ID` = 22102 AND `locale` = 'deDE';
+INSERT INTO `item_set_names_locale` (`ID`, `locale`, `Name`, `VerifiedBuild`) VALUES
+(22102, 'deDE', 'Weste der fünf Donner', 0);