aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorfunjoker <funjoker109@gmail.com>2020-08-03 00:40:05 +0200
committerfunjoker <funjoker109@gmail.com>2020-08-03 00:40:05 +0200
commit7f664e010cba994b46dc4bec6c3aae136c77577f (patch)
tree46f6368956aba8ac24bc69972390a7a1828dfc03
parentaad66a5803fe2d383798c0e3176301dbead2cac8 (diff)
DB/Hotfixes: Fix some mistakes
-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;