diff options
| -rw-r--r-- | sql/updates/hotfixes/master/2020_09_07_01_hotfixes.sql | 218 |
1 files changed, 218 insertions, 0 deletions
diff --git a/sql/updates/hotfixes/master/2020_09_07_01_hotfixes.sql b/sql/updates/hotfixes/master/2020_09_07_01_hotfixes.sql new file mode 100644 index 00000000000..e37f251b2b8 --- /dev/null +++ b/sql/updates/hotfixes/master/2020_09_07_01_hotfixes.sql @@ -0,0 +1,218 @@ +UPDATE `spell_name_locale` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `ID` IN (337816, 337612, 335642, 335152, 335151, 335150, 335149, 335148, 332950, 331973, 328136, 327254, 325947, 325946, 324907, 324906, 324905, 324904, 324903, 324902, 324901, 324900, 324899, 324898, 324897, 324896, 324895, 324894, 324893, 324892, 324891, 324890, 324889, 324888, 324887, 324886, 324885, 324884, 324882, 324881, 324880, 324879, 324877, 324875, 324874, 324870, 324868, 324866, 324865, 324864, 324862, 324861, 324860, 324858, 324857, 324856, 324854, 324853, 324852, 324851, 324850, 324848, 324845, 324839, 324837, 324680, 321748, 321714, 321428, 321201, 321200, 319451, 316661, 315958, 313040, 311204, 306259, 304086, 302166, 301683, 301578, 300932, 300798, 300748, 300692, 299937, 296464, 294479, 294003, 293777, 293072, 292907, 292579, 291435, 275496, 274909, 264663, 256134, 256133, 155347, 155346, 155345, 155344, 155343, 155334, 155333, 155315, 155313, 154275, 154274, 154259, 154253, 120679, 115546, 110556); + +DELETE FROM `spell_name_locale` WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `locale` = 'itIT' AND `VerifiedBuild`>0 AND `ID` = 217506; +INSERT INTO spell_name_locale (`ID`, `locale`, `Name_lang`, `VerifiedBuild`) VALUES +(217506, 'itIT', 'Stomp Fruit Success Dialog Trigger', 35662); + +UPDATE `map_locale` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `ID` = 2268; + +UPDATE `mount_locale` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `ID` IN (1282, 468); + +UPDATE `mail_template_locale` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `ID` = 550; + +UPDATE `player_condition_locale` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `ID` IN (79523, 79522, 79521, 79520, 79519, 79518, 79517, 79516, 79515, 79514, 79513, 79512, 79511, 79510, 79509, 79508, 79507, 79506, 79505, 79504, 79503, 79502, 79501, 79500, 79499, 79498, 79497, 79486, 75191, 75180, 75170, 74078); + +UPDATE `ui_map_locale` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `ID` IN (1574, 1573); + +UPDATE `criteria_tree_locale` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `ID` IN (85138, 85136, 85134, 85132, 85130, 85128, 85126, 85124, 85122, 85120, 85118, 85116, 85114, 85112, 85110, 85108, 85106, 85104, 85102, 85100, 85098, 85096, 85094, 85092, 85090, 85088, 85086, 85084, 85025, 84817, 84816, 84815, 84814, 84813, 84812, 84811, 84810, 84809, 84808, 84755, 82623, 78565, 34935); + +UPDATE `achievement_locale` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `ID` IN (14265, 14264, 14263, 14262, 14261, 14260, 14259, 14258, 14257, 14256, 14255, 14254, 14253, 14252, 14251, 14250, 14249, 14248, 14247, 14246, 14245, 14244, 14243, 14242, 14241, 14240, 14239, 14238, 14212, 6980); + +UPDATE `area_table_locale` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `ID` IN (12825, 10290); + +UPDATE `azerite_essence_power_locale` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `ID` IN (140, 132, 114); + +UPDATE `item_name_description_locale` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `ID` IN (13580, 13579, 13578, 13577, 13576, 13575, 13574, 13573, 13572, 13571, 13570, 13569, 13568, 13567, 13566, 13565, 13521, 13520, 13519, 13518, 13517, 13516, 13513); + +UPDATE `broadcast_text_locale` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `ID` IN (201784, 201778, 201777, 195400, 194274, 183984, 165870, 165246, 165245, 165244, 165243, 165241, 165239, 165237, 141708, 79804, 79799, 79798, 79796, 79795, 79794, 753); + +UPDATE `currency_types_locale` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `ID` = 1803; + +UPDATE `dungeon_encounter_locale` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `ID` = 786; + +UPDATE `item_sparse_locale` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `ID` IN (178015, 178014, 178013, 178012, 178011, 178010, 178009, 178008, 178007, 178006, 178005, 178004, 178003, 178002, 178001, 178000, 177999, 177998, 177997, 177996, 177995, 177994, 177993, 177992, 177991, 177990, 177989, 177988, 177987, 177986, 177985, 177984, 177983, 177982, 177981, 177980, 177979, 177978, 177977, 177976, 177975, 177974, 177973, 177972, 177971, 177970, 177969, 177968, 177967, 177966, 177965, 177964, 177955, 173937, 168043, 141850, 141065, 141058, 141057, 141038, 139431, 139425, 139422, 139412, 139411, 139347, 139346, 139345, 139344, 138016, 137966, 137962, 137954, 137934, 137932, 137917, 137913, 137901, 137885, 137881, 137869, 137831, 137829, 137826, 137706, 127918, 87487); + +UPDATE `item_search_name_locale` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `ID` = 87487; + +UPDATE `gameobjects_locale` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `ID` IN (341828, 341363, 338477); + +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 4146370265 AND `RecordId` = 91772; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 4033975491 AND `RecordId` = 404117; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 4033975491 AND `RecordId` = 403803; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 337816; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 337612; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 335642; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 335152; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 335151; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 335150; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 335149; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 335148; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 332950; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 331973; +UPDATE hotfix_blob SET `Blob` = 0x0041756D656E7461206C61207265707574617A696F6E65206F7474656E75746120636F6E206C652066617A696F6E69206469204C6567696F6E206520426174746C6520666F7220417A65726F74682064656C20247331252E005265707574617A696F6E65206F7474656E75746120636F6E206C652066617A696F6E69206469204C6567696F6E206520426174746C6520666F7220417A65726F74682061756D656E746174612064656C20247331252E00, `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 328136; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 327254; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 325947; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 325946; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 324907; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 324906; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 324905; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 324904; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 324903; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 324902; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 324901; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 324900; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 324899; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 324898; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 324897; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 324896; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 324895; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 324894; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 324893; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 324892; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 324891; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 324890; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 324889; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 324888; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 324887; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 324886; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 324885; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 324884; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 324882; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 324881; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 324880; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 324879; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 324877; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 324875; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 324874; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 324870; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 324868; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 324866; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 324865; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 324864; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 324862; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 324861; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 324860; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 324858; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 324857; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 324856; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 324854; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 324853; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 324852; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 324851; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 324850; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 324848; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 324845; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 324839; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 324837; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 324680; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 321748; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 321714; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 321428; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 321201; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 321200; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 319451; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 316661; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 315958; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 313040; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 311204; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 306259; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 304086; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 302166; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 301683; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 301578; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 300932; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 300798; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 300748; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 300692; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 299937; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 296464; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 294479; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 294003; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 293777; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 293072; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 292907; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 292579; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 291435; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 275496; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 274909; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 264663; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 256134; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 256133; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 155347; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 155346; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 155345; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 155344; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 155343; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 155334; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 155333; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 155315; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 155313; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 154275; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 154274; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 154259; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 154253; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 120679; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 115546; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 110556; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3745449290 AND `RecordId` = 6134; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3386943305 AND `RecordId` = 195997; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3386291891 AND `RecordId` = 174231; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3205218938 AND `RecordId` = 42646; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3205218938 AND `RecordId` = 42645; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3205218938 AND `RecordId` = 42500; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3205218938 AND `RecordId` = 42497; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3205218938 AND `RecordId` = 42496; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3205218938 AND `RecordId` = 41794; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3205218938 AND `RecordId` = 41793; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3205218938 AND `RecordId` = 41792; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3205218938 AND `RecordId` = 41791; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 2948698321 AND `RecordId` = 259; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 2948698321 AND `RecordId` = 249; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 2901650891 AND `RecordId` = 1582; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 2230237587 AND `RecordId` = 1188; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 2230237587 AND `RecordId` = 1162; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 2035710060 AND `RecordId` = 7073; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 2035710060 AND `RecordId` = 7072; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 2035710060 AND `RecordId` = 7071; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 2035710060 AND `RecordId` = 7070; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 2035710060 AND `RecordId` = 7069; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 2035710060 AND `RecordId` = 7050; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 1181150530 AND `RecordId` = 307455; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 813076512 AND `RecordId` = 22909; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 813076512 AND `RecordId` = 22908; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 603412935 AND `RecordId` = 28664; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 603412935 AND `RecordId` = 28663; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 603412935 AND `RecordId` = 28662; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 603412935 AND `RecordId` = 28661; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 603412935 AND `RecordId` = 28660; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 603412935 AND `RecordId` = 28659; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 603412935 AND `RecordId` = 28658; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 603412935 AND `RecordId` = 28657; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 603412935 AND `RecordId` = 28656; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 603412935 AND `RecordId` = 28655; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 603412935 AND `RecordId` = 28654; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 603412935 AND `RecordId` = 28653; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 603412935 AND `RecordId` = 28652; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 603412935 AND `RecordId` = 28651; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 603412935 AND `RecordId` = 28650; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 603412935 AND `RecordId` = 28649; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 603412935 AND `RecordId` = 28648; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 603412935 AND `RecordId` = 28647; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 603412935 AND `RecordId` = 28646; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 603412935 AND `RecordId` = 28645; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 603412935 AND `RecordId` = 28644; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 600565378 AND `RecordId` = 267274; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 600565378 AND `RecordId` = 267271; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 600565378 AND `RecordId` = 267266; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 600565378 AND `RecordId` = 267260; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 517656225 AND `RecordId` = 6688; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 25144992 AND `RecordId` = 2203; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 20077728 AND `RecordId` = 396607; + +DELETE FROM `hotfix_blob` WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3776013982 AND `RecordId` = 217506; +DELETE FROM `hotfix_blob` WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `locale` = 'itIT' AND `VerifiedBuild`>0 AND `TableHash` = 3386943305 AND `RecordId` = 24302; +INSERT INTO hotfix_blob (`TableHash`, `RecordId`, `locale`, `Blob`, `VerifiedBuild`) VALUES +(3776013982, 217506, 'itIT', 0x000000, 35662), +(3386943305, 24302, 'itIT', 0x0401015A0000000000060010000000000000000400000000000004000100000000000000004FE60000, 35662); + +UPDATE `wmo_area_table_locale` SET `VerifiedBuild` = 35662 WHERE `locale` = 'itIT' AND `VerifiedBuild`>0 AND `ID` = 103067; |