aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sql/updates/hotfixes/master/2020_08_02_02_hotifxes.sql35
1 files changed, 35 insertions, 0 deletions
diff --git a/sql/updates/hotfixes/master/2020_08_02_02_hotifxes.sql b/sql/updates/hotfixes/master/2020_08_02_02_hotifxes.sql
new file mode 100644
index 00000000000..17e247c93d0
--- /dev/null
+++ b/sql/updates/hotfixes/master/2020_08_02_02_hotifxes.sql
@@ -0,0 +1,35 @@
+UPDATE `item_sparse` SET `Description`='', `Display3`='', `Display2`='', `Display1`='' WHERE `VerifiedBuild`>0 AND `ID`=87487;
+UPDATE `item_sparse` SET `Display3`='', `Display2`='', `Display1`='' WHERE `VerifiedBuild`>0 AND `ID`=127918;
+UPDATE `item_sparse` SET `Description`='', `Display3`='', `Display2`='', `Display1`='' WHERE `VerifiedBuild`>0 AND `ID`=136605;
+UPDATE `item_sparse` SET `Display3`='', `Display2`='', `Display1`='' WHERE `VerifiedBuild`>0 AND `ID`=137706;
+UPDATE `item_sparse` SET `Display3`='', `Display2`='', `Display1`='' WHERE `VerifiedBuild`>0 AND `ID`=137826;
+UPDATE `item_sparse` SET `Display3`='', `Display2`='', `Display1`='' WHERE `VerifiedBuild`>0 AND `ID`=137829;
+UPDATE `item_sparse` SET `Display3`='', `Display2`='', `Display1`='' WHERE `VerifiedBuild`>0 AND `ID`=137831;
+UPDATE `item_sparse` SET `Display3`='', `Display2`='', `Display1`='' WHERE `VerifiedBuild`>0 AND `ID`=137869;
+UPDATE `item_sparse` SET `Display3`='', `Display2`='', `Display1`='' WHERE `VerifiedBuild`>0 AND `ID`=137881;
+UPDATE `item_sparse` SET `Display3`='', `Display2`='', `Display1`='' WHERE `VerifiedBuild`>0 AND `ID`=137885;
+UPDATE `item_sparse` SET `Display3`='', `Display2`='', `Display1`='' WHERE `VerifiedBuild`>0 AND `ID`=137901;
+UPDATE `item_sparse` SET `Display3`='', `Display2`='', `Display1`='' WHERE `VerifiedBuild`>0 AND `ID`=137913;
+UPDATE `item_sparse` SET `Display3`='', `Display2`='', `Display1`='' WHERE `VerifiedBuild`>0 AND `ID`=137917;
+UPDATE `item_sparse` SET `Display3`='', `Display2`='', `Display1`='' WHERE `VerifiedBuild`>0 AND `ID`=137932;
+UPDATE `item_sparse` SET `Display3`='', `Display2`='', `Display1`='' WHERE `VerifiedBuild`>0 AND `ID`=137934;
+UPDATE `item_sparse` SET `Display3`='', `Display2`='', `Display1`='' WHERE `VerifiedBuild`>0 AND `ID`=137954;
+UPDATE `item_sparse` SET `Display3`='', `Display2`='', `Display1`='' WHERE `VerifiedBuild`>0 AND `ID`=137962;
+UPDATE `item_sparse` SET `Display3`='', `Display2`='', `Display1`='' WHERE `VerifiedBuild`>0 AND `ID`=137966;
+UPDATE `item_sparse` SET `Display3`='', `Display2`='', `Display1`='' WHERE `VerifiedBuild`>0 AND `ID`=138016;
+UPDATE `item_sparse` SET `Description`='', `Display3`='', `Display2`='', `Display1`='' WHERE `VerifiedBuild`>0 AND `ID`=139344;
+UPDATE `item_sparse` SET `Description`='', `Display3`='', `Display2`='', `Display1`='' WHERE `VerifiedBuild`>0 AND `ID`=139345;
+UPDATE `item_sparse` SET `Description`='', `Display3`='', `Display2`='', `Display1`='' WHERE `VerifiedBuild`>0 AND `ID`=139346;
+UPDATE `item_sparse` SET `Description`='', `Display3`='', `Display2`='', `Display1`='' WHERE `VerifiedBuild`>0 AND `ID`=139347;
+UPDATE `item_sparse` SET `Description`='', `Display3`='', `Display2`='', `Display1`='' WHERE `VerifiedBuild`>0 AND `ID`=139411;
+UPDATE `item_sparse` SET `Description`='', `Display3`='', `Display2`='', `Display1`='' WHERE `VerifiedBuild`>0 AND `ID`=139412;
+UPDATE `item_sparse` SET `Description`='', `Display3`='', `Display2`='', `Display1`='' WHERE `VerifiedBuild`>0 AND `ID`=139422;
+UPDATE `item_sparse` SET `Description`='', `Display3`='', `Display2`='', `Display1`='' WHERE `VerifiedBuild`>0 AND `ID`=139425;
+UPDATE `item_sparse` SET `Description`='', `Display3`='', `Display2`='', `Display1`='' WHERE `VerifiedBuild`>0 AND `ID`=139431;
+UPDATE `item_sparse` SET `Display3`='', `Display2`='', `Display1`='' WHERE `VerifiedBuild`>0 AND `ID`=141038;
+UPDATE `item_sparse` SET `Display3`='', `Display2`='', `Display1`='' WHERE `VerifiedBuild`>0 AND `ID`=141057;
+UPDATE `item_sparse` SET `Display3`='', `Display2`='', `Display1`='' WHERE `VerifiedBuild`>0 AND `ID`=141058;
+UPDATE `item_sparse` SET `Display3`='', `Display2`='', `Display1`='' WHERE `VerifiedBuild`>0 AND `ID`=141065;
+UPDATE `item_sparse` SET `Display3`='', `Display2`='', `Display1`='' WHERE `VerifiedBuild`>0 AND `ID`=141850;
+UPDATE `item_sparse` SET `Display3`='', `Display2`='', `Display1`='' WHERE `VerifiedBuild`>0 AND `ID`=168043;
+UPDATE `item_sparse` SET `Display3`='', `Display2`='', `Display1`='' WHERE `VerifiedBuild`>0 AND `ID`=173937;