diff options
| -rw-r--r-- | sql/updates/hotfixes/master/2021_08_26_06_hotfixes.sql | 278 |
1 files changed, 278 insertions, 0 deletions
diff --git a/sql/updates/hotfixes/master/2021_08_26_06_hotfixes.sql b/sql/updates/hotfixes/master/2021_08_26_06_hotfixes.sql new file mode 100644 index 00000000000..113dcd59004 --- /dev/null +++ b/sql/updates/hotfixes/master/2021_08_26_06_hotfixes.sql @@ -0,0 +1,278 @@ +DELETE FROM `criteria_tree_locale` WHERE `VerifiedBuild` > 0 AND `locale` = 'koKR' AND `ID` IN (92566); +INSERT INTO `criteria_tree_locale` (`ID`, `locale`, `Description_lang`, `VerifiedBuild`) VALUES +(92566, 'koKR', '', 39804); + +DELETE FROM `player_condition_locale` WHERE `VerifiedBuild` > 0 AND `locale` = 'koKR' AND `ID` IN (89249); +INSERT INTO `player_condition_locale` (`ID`, `locale`, `FailureDescription_lang`, `VerifiedBuild`) VALUES +(89249, 'koKR', '', 39804); + +UPDATE `hotfix_blob` SET `Blob` = 0x554B5F414144435F504F5055505F5445585400EC9B94EB939C20EC98A4EBB88C20EC9B8CED81ACEB9E98ED9484ED8AB8EB8A9420EB8BA4EBA5B820ED948CEBA088EC9DB4EC96B4EC9980EC9D9820EC8381ED98B8EC9E91EC9AA9EC9DB420ED8FACED95A8EB909C20EC98A8EB9DBCEC9DB820EAB28CEC9E84EC9E85EB8B88EB8BA42E20EAB09CEC9DB820ECA095EBB3B420EBB3B4ED98B8EC979020ECA3BCEC9D98ED9598EC8B9CEAB3A020EBAAA8EBA5B4EB8A9420EC82ACEB9E8CEC9790EAB28C20EAB480EBA0A820ECA095EBB3B4EBA5BC20EAB3B5EC9CA0ED9598ECA78020EBA788EC8BADEC8B9CEC98A42E7C6E7C6EEB9890ED959C2C20ECBBA4EBAEA4EB8B88ED8BB020EC868CED86B520ECA095ECB185EC9D8420EC9CA0EB8590ED9598EC8B9CEC96B420EAB4B4EBA1ADED9E982C20EBAAA8EC9A95ECA081EC9DB820ED9689EC9C8420EBB08F20EB8C80ED99942C20EAB8B0ED838020EAB3A0EC9D98ECA081EC9CBCEBA19C20EAB28CEC9E8420EAB2BDED9798EC9D8420ED95B4ECB998EAB1B0EB829820EBB0A9ED95B4ED9598EB8A9420ED9689EB8F99EC9D8420EBB09CEAB2ACED9598EC8BA420EAB2BDEC9AB020EAB28CEC9E8420EB82B420EC8BA0EAB3A020EAB8B0EB8AA5EC9D8420EC9DB4EC9AA9ED95B420ECA09CEBB3B420EBB094EB9E8DEB8B88EB8BA42E20EB8C80ED999420EAB8B0EBA19DEC9D8420EAB280ED86A0ED9598EC97AC20ECA081ECA088ED959C20ECA1B0ECB998EBA5BC20ECB7A8ED9598EAB2A0EC8AB5EB8B88EB8BA42E0001, `VerifiedBuild` = 39804 WHERE (`TableHash` = 3205218938) AND (`RecordId` = 44250) AND (`locale` = 'koKR'); + +DELETE FROM `hotfix_blob` WHERE `TableHash` = 3865974254 AND `RecordId` = 187917 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 3865974254 AND `RecordId` = 187863 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 3865974254 AND `RecordId` = 182247 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 3865974254 AND `RecordId` = 182246 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 3865974254 AND `RecordId` = 182245 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 3865974254 AND `RecordId` = 182244 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 3865974254 AND `RecordId` = 182243 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 3865974254 AND `RecordId` = 182242 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 3865974254 AND `RecordId` = 182241 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 3865974254 AND `RecordId` = 182229 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 3865974254 AND `RecordId` = 182228 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 3865974254 AND `RecordId` = 182227 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 3865974254 AND `RecordId` = 182226 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 3865974254 AND `RecordId` = 182225 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 3865974254 AND `RecordId` = 182224 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 3865974254 AND `RecordId` = 182223 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 3865974254 AND `RecordId` = 177203 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 3865974254 AND `RecordId` = 177202 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 3865974254 AND `RecordId` = 177201 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 3865974254 AND `RecordId` = 177200 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 3865974254 AND `RecordId` = 177199 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 3865974254 AND `RecordId` = 177198 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 3865974254 AND `RecordId` = 177197 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 3865974254 AND `RecordId` = 174303 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 3776013982 AND `RecordId` = 360832 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 3776013982 AND `RecordId` = 360829 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 3776013982 AND `RecordId` = 360749 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 3776013982 AND `RecordId` = 360592 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 3776013982 AND `RecordId` = 358693 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 3776013982 AND `RecordId` = 358692 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 3776013982 AND `RecordId` = 358518 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 3776013982 AND `RecordId` = 357073 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 3776013982 AND `RecordId` = 357069 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 3776013982 AND `RecordId` = 357062 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 3776013982 AND `RecordId` = 357058 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 3776013982 AND `RecordId` = 357052 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 3776013982 AND `RecordId` = 357049 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 3776013982 AND `RecordId` = 357034 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 3776013982 AND `RecordId` = 357031 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 3776013982 AND `RecordId` = 356593 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 3776013982 AND `RecordId` = 356248 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 3776013982 AND `RecordId` = 355741 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 3776013982 AND `RecordId` = 355721 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 3776013982 AND `RecordId` = 354098 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 3776013982 AND `RecordId` = 354058 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 3776013982 AND `RecordId` = 345482 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 3776013982 AND `RecordId` = 341724 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 3776013982 AND `RecordId` = 340433 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 3776013982 AND `RecordId` = 138083 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 3557796329 AND `RecordId` = 3223 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 3557796329 AND `RecordId` = 2477 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 3386943305 AND `RecordId` = 92453 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 3386291891 AND `RecordId` = 93030 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 3205218938 AND `RecordId` = 43120 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 3072882582 AND `RecordId` = 9878 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 3072882582 AND `RecordId` = 8001 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 3072882582 AND `RecordId` = 7998 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 3031818311 AND `RecordId` = 4138 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 3031818311 AND `RecordId` = 4137 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 2939349194 AND `RecordId` = 746 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 2939349194 AND `RecordId` = 744 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 2939349194 AND `RecordId` = 743 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 2381039112 AND `RecordId` = 3271 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 2299908982 AND `RecordId` = 560 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 1385971161 AND `RecordId` = 12023 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 1369604944 AND `RecordId` = 6963 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 1369604944 AND `RecordId` = 6960 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 336222293 AND `RecordId` = 8447 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 336222293 AND `RecordId` = 8446 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 336222293 AND `RecordId` = 8445 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 48336690 AND `RecordId` = 39162 AND `locale` = 'koKR'; +DELETE FROM `hotfix_blob` WHERE `TableHash` = 48336690 AND `RecordId` = 39161 AND `locale` = 'koKR'; +INSERT INTO `hotfix_blob` (`TableHash`, `RecordId`, `locale`, `Blob`, `VerifiedBuild`) VALUES +(3865974254, 187917, 'koKR', 0x00000000, 39804), +(3865974254, 187863, 'koKR', 0x00000000, 39804), +(3865974254, 182247, 'koKR', 0x00000000, 39804), +(3865974254, 182246, 'koKR', 0x00000000, 39804), +(3865974254, 182245, 'koKR', 0x00000000, 39804), +(3865974254, 182244, 'koKR', 0x00000000, 39804), +(3865974254, 182243, 'koKR', 0x00000000, 39804), +(3865974254, 182242, 'koKR', 0x00000000, 39804), +(3865974254, 182241, 'koKR', 0x00000000, 39804), +(3865974254, 182229, 'koKR', 0x00000000, 39804), +(3865974254, 182228, 'koKR', 0x00000000, 39804), +(3865974254, 182227, 'koKR', 0x00000000, 39804), +(3865974254, 182226, 'koKR', 0x00000000, 39804), +(3865974254, 182225, 'koKR', 0x00000000, 39804), +(3865974254, 182224, 'koKR', 0x00000000, 39804), +(3865974254, 182223, 'koKR', 0x00000000, 39804), +(3865974254, 177203, 'koKR', 0x00000000, 39804), +(3865974254, 177202, 'koKR', 0x00000000, 39804), +(3865974254, 177201, 'koKR', 0x00000000, 39804), +(3865974254, 177200, 'koKR', 0x00000000, 39804), +(3865974254, 177199, 'koKR', 0x00000000, 39804), +(3865974254, 177198, 'koKR', 0x00000000, 39804), +(3865974254, 177197, 'koKR', 0x00000000, 39804), +(3865974254, 174303, 'koKR', 0x00000000, 39804), +(3776013982, 360832, 'koKR', 0x000000, 39804), +(3776013982, 360829, 'koKR', 0x0024407370656C6C646573633332333939390000, 39804), +(3776013982, 360749, 'koKR', 0x000000, 39804), +(3776013982, 360592, 'koKR', 0x000000, 39804), +(3776013982, 358693, 'koKR', 0x00246420EB8F99EC958820ECA3BCEC9C8420ED948CEBA088EC9DB4EC96B4EC9D9820EBACBCEBA6AC20EAB3B5EAB2A9EBA0A5EC9D842024733125EBA78CED81BC20ECA69DEAB080EC8B9CED82B5EB8B88EB8BA42E20EC9DB420ED9AA8EAB3BCEB8A9420ECA491ECB2A9EB90A9EB8B88EB8BA42E00EBACBCEBA6AC20ED94BCED95B42024733125EBA78CED81BC20ECA69DEAB08000, 39804), +(3776013982, 358692, 'koKR', 0x00246420EB8F99EC958820ECA3BCEC9C8420ED948CEBA088EC9DB4EC96B4EC9D9820EC9594ED9D9120EAB3B5EAB2A9EBA0A5EC9D842024733125EBA78CED81BC20ECA69DEAB080EC8B9CED82B5EB8B88EB8BA42E20EC9DB420ED9AA8EAB3BCEB8A9420ECA491ECB2A9EB90A9EB8B88EB8BA42E00EC9594ED9D9120ED94BCED95B42024733125EBA78CED81BC20ECA69DEAB08000, 39804), +(3776013982, 358518, 'koKR', 0x00246420EB8F99EC958820EBA8B8EBACB4EBA5B4EB8A9420EBB0B1ED98B820EC89ACEC9794EC9D9820EC9B90EBA0B9EC9D8420EC868CED9998ED95A9EB8B88EB8BA42E20EC9B90EBA0B9EC9D8020ECA3BC20EB8C80EC8381EC9D8420EAB3B5EAB2A9ED9598EAB3A020243132333939364131EBAFB8ED84B020EB82B42033EBAA85EC9D9820ECA081EC9790EAB28C20243132333939397431ECB488EBA788EB8BA420ED98B8EB9E91EC9DB420EBB288EAB09C20EAB3B5EAB2A9EC9CBCEBA19C20243132333939367331EC9D9820EC9E90EC97B020ED94BCED95B4EBA5BC20EC9E85ED9E99EB8B88EB8BA42E0000, 39804), +(3776013982, 357073, 'koKR', 0x007C434646323066663230EC9584ECA78120ED94BCED95B4EBA5BC20EC9E85ED9E88ECA78020EC958AEC9D8020ECA081EC9D8420EAB3B5EAB2A9ED9598EBA9B420243335363336346420EB8F99EC958820EAB3B5EAB2A9EBA0A5EC9DB420247B2473312F3130307D2E3225EBA78CED81BC20ECA69DEAB080ED95A9EB8B88EB8BA42E7C520000, 39804), +(3776013982, 357069, 'koKR', 0x007C434646323066663230EC839DEBAA85EBA0A520EBB984EC9CA8EC9DB420EB8C80EC8381EC9D9820EC839DEBAA85EBA0A520EBB984EC9CA8EBB3B4EB8BA4202473322520EC9DB4EC838120EBA78EEC9CBCEBA9B420EAB3B5EAB2A9EBA0A5EC9DB420247B2473312F3130307D2E3125EBA78CED81BC20ECA69DEAB080ED95A9EB8B88EB8BA42E7C520000, 39804), +(3776013982, 357062, 'koKR', 0x007C434646323066663230EC9584ECA78120ED94BCED95B4EBA5BC20EC9E85ED9E88ECA78020EC958AEC9D8020ECA081EC9D8420EAB3B5EAB2A9ED9598EBA9B420243335363336346420EB8F99EC958820EAB3B5EAB2A9EBA0A5EC9DB420247B2473312F3130307D2E3225EBA78CED81BC20ECA69DEAB080ED95A9EB8B88EB8BA42E7C520000, 39804), +(3776013982, 357058, 'koKR', 0x007C434646323066663230EC839DEBAA85EBA0A520EBB984EC9CA8EC9DB420EB8C80EC8381EC9D9820EC839DEBAA85EBA0A520EBB984EC9CA8EBB3B4EB8BA4202473322520EC9DB4EC838120EBA78EEC9CBCEBA9B420EAB3B5EAB2A9EBA0A5EC9DB420247B2473312F3130307D2E3125EBA78CED81BC20ECA69DEAB080ED95A9EB8B88EB8BA42E7C520000, 39804), +(3776013982, 357052, 'koKR', 0x007C434646323066663230EC9584ECA78120ED94BCED95B4EBA5BC20EC9E85ED9E88ECA78020EC958AEC9D8020ECA081EC9D8420EAB3B5EAB2A9ED9598EBA9B420243335363336346420EB8F99EC958820EAB3B5EAB2A9EBA0A5EC9DB420247B2473312F3130307D2E3225EBA78CED81BC20ECA69DEAB080ED95A9EB8B88EB8BA42E7C520000, 39804), +(3776013982, 357049, 'koKR', 0x007C434646323066663230EC839DEBAA85EBA0A520EBB984EC9CA8EC9DB420EB8C80EC8381EC9D9820EC839DEBAA85EBA0A520EBB984EC9CA8EBB3B4EB8BA4202473322520EC9DB4EC838120EBA78EEC9CBCEBA9B420EAB3B5EAB2A9EBA0A5EC9DB420247B2473312F3130307D2E3125EBA78CED81BC20ECA69DEAB080ED95A9EB8B88EB8BA42E7C520000, 39804), +(3776013982, 357034, 'koKR', 0x007C434646323066663230EC9584ECA78120ED94BCED95B4EBA5BC20EC9E85ED9E88ECA78020EC958AEC9D8020ECA081EC9D8420EAB3B5EAB2A9ED9598EBA9B420243335363336346420EB8F99EC958820EAB3B5EAB2A9EBA0A5EC9DB420247B2473312F3130307D2E3225EBA78CED81BC20ECA69DEAB080ED95A9EB8B88EB8BA42E7C520000, 39804), +(3776013982, 357031, 'koKR', 0x007C434646323066663230EC839DEBAA85EBA0A520EBB984EC9CA8EC9DB420EB8C80EC8381EC9D9820EC839DEBAA85EBA0A520EBB984EC9CA8EBB3B4EB8BA4202473322520EC9DB4EC838120EBA78EEC9CBCEBA9B420EAB3B5EAB2A9EBA0A5EC9DB420247B2473312F3130307D2E3125EBA78CED81BC20ECA69DEAB080ED95A9EB8B88EB8BA42E7C520000, 39804), +(3776013982, 356593, 'koKR', 0x00EC9584EC9DB4ED859C20EBA088EBB2A8EC9DB420EAB080EC9EA520EB82AEEC9D8020ED9884EC9EAC20ECA084EBACB8ED9994EC9AA920EB8F84EAB48020ECA491EC9790EC849C20EAB095ED9994EB909C20EB8F84EAB480EC9D8420EBACB4EC9E91EC9C84EBA19C20ED9598EB829820EBB09CEAB2ACED95A9EB8B88EB8BA42E2028ECB59CEAB3A020EC9584EC9DB4ED859C20EBA088EBB2A820323236290000, 39804), +(3776013982, 356248, 'koKR', 0x00EC9584EC9DB4ED859C20EBA088EBB2A8EC9DB420EAB080EC9EA520EB82AEEC9D8020ED9884EC9EAC20ECA084EBACB8ED9994EC9AA920EB8F84EAB48020ECA491EC9790EC849C20EAB095ED9994EB909C20EB8F84EAB480EC9D8420EBACB4EC9E91EC9C84EBA19C20ED9598EB829820EBB09CEAB2ACED95A9EB8B88EB8BA42E2028ECB59CEAB3A020EC9584EC9DB4ED859C20EBA088EBB2A820323532290000, 39804), +(3776013982, 355741, 'koKR', 0x007C434646323066663230EC9584ECA78120ED94BCED95B4EBA5BC20EC9E85ED9E88ECA78020EC958AEC9D8020ECA081EC9D8420EAB3B5EAB2A9ED9598EBA9B420243335363336346420EB8F99EC958820EAB3B5EAB2A9EBA0A5EC9DB420247B2473312F3130307D2E3225EBA78CED81BC20ECA69DEAB080ED95A9EB8B88EB8BA42E7C520000, 39804), +(3776013982, 355721, 'koKR', 0x007C434646323066663230EC839DEBAA85EBA0A520EBB984EC9CA8EC9DB420EB8C80EC8381EC9D9820EC839DEBAA85EBA0A520EBB984EC9CA8EBB3B4EB8BA4202473322520EC9DB4EC838120EBA78EEC9CBCEBA9B420EAB3B5EAB2A9EBA0A5EC9DB420247B2473312F3130307D2E3225EBA78CED81BC20ECA69DEAB080ED95A9EB8B88EB8BA42E7C520000, 39804), +(3776013982, 354098, 'koKR', 0x00ECBD94EBA5B4EC8B9CEC958420EB8F99EBACBCEC9790EAB28C20EC9D8CEC8B9DEC9D8420ECA48DEB8B88EB8BA42E0000, 39804), +(3776013982, 354058, 'koKR', 0x00EAB5B6ECA3BCEBA6B020ECBD94EBA5B4EC8B9CEC958420EB8F99EBACBCEC9790EAB28C20EB8BA4EAB080EAB080EAB8B020EC9C84ED95B420EAB084EC8B9DEC9D8420EB8D98ECA791EB8B88EB8BA4210000, 39804), +(3776013982, 345482, 'koKR', 0x00EC9584EC9DB4ED859C20EBA088EBB2A8EC9DB420EAB080EC9EA520EB82AEEC9D8020ED9884EC9EAC20ECA084EBACB8ED9994EC9AA920EB8F84EAB48020ECA491EC9790EC849C20EAB095ED9994EB909C20EB8F84EAB480EC9D8420EBACB4EC9E91EC9C84EBA19C20ED9598EB829820EBB09CEAB2ACED95A9EB8B88EB8BA42E2028ECB59CEAB3A020EC9584EC9DB4ED859C20EBA088EBB2A820323236290000, 39804), +(3776013982, 341724, 'koKR', 0x00ECA088EBA9B820EC82ACEC9AA920EC8B9C20EB8BA8EB8BA8ED959C20EC96BCEC9D8CEC9DB420EBB09CEB8F99ED95A020ED9995EBA5A0EC9DB42024733125EBA78CED81BC20ECA69DEAB080ED95A9EB8B88EB8BA42E20EB9890ED959C20EB8BA8EB8BA8ED959C20EC96BCEC9D8CEC9DB420ED999CEC84B1ED9994EB9098EC96B420EC9E88EB8A9420EB8F99EC958820EC9AB8EBB680ECA796EB8A9420ED959CED8C8CEBA5BC20EC82ACEC9AA9ED9598EBA9B420247B2433343137323573312F31307DEC9D9820EBA3AC20EBA788EBA0A5EC9DB420EC839DEC84B1EB90A9EB8B88EB8BA42E0000, 39804), +(3776013982, 340433, 'koKR', 0x00ECA095ECA09CEB909C20EBA0B9EC9DB420EBAAB8EC9D8420ED8380EAB3A020ED9D98EB9FAC20246420EB8F99EC958820EAB3B5EAB2A9EBA0A5EAB3BC20ECB998EC9CA0EB9F89EC9DB42024733125EBA78CED81BC20ECA69DEAB080ED95A9EB8B88EB8BA42E00EAB3B5EAB2A9EBA0A52024733125EBA78CED81BC20ECA69DEAB0800D0AECB998EC9CA0EB9F892024733225EBA78CED81BC20ECA69DEAB08000, 39804), +(3776013982, 138083, 'koKR', 0x00ED9884EC9EAC20EB8C80EC8381EC9D8420EC8B9CECA084EC9E90EC9D9820EBAAA8EC8AB5EC9CBCEBA19C20EBB3B5ECA09CED95A9EB8B88EB8BA42E0000, 39804), +(3557796329, 3223, 'koKR', 0x05000000E1E2000000009642DD000000, 39804), +(3557796329, 2477, 'koKR', 0x08000000D32D050000005842AB000000, 39804), +(3386943305, 92453, 'koKR', 0x00000000000000000E004C0100000000881048400000000000010200000000000001000000000000010000000000666B0100, 39804), +(3386291891, 93030, 'koKR', 0xEBACB4EC87A0EAB080ECA7800000ECA084EC9F81EC9D9820EAB3A0EB8C80ECA095EBA0B90000040400000028FE00000000000000000000000000000000803F0000803F0000803F0000803F000000000000000000000000, 39804), +(3205218938, 43120, 'koKR', 0x5350454C4C5F4641494C45445F435553544F4D5F4552524F525F35323900ED9884EC9EAC20ECA084EBACB8ED9994EC979020EBA79EEB8A9420EBAAA8EB93A020EB8F84EAB480EC9D8420EAB095ED9994ED9598EC9880EC8AB5EB8B88EB8BA42E0001, 39804), +(3072882582, 9878, 'koKR', 0xF50100000000C70C0000, 39804), +(3072882582, 8001, 'koKR', 0xA90100000000C70C0000, 39804), +(3072882582, 7998, 'koKR', 0x110005000000C70C0000, 39804), +(3031818311, 4138, 'koKR', 0x4C00360A670500C70C0000, 39804), +(3031818311, 4137, 'koKR', 0x1200370A670500C70C0000, 39804), +(2939349194, 746, 'koKR', 0xEBAFB8ECA780EC9D9820EC8B9CEC9EA520ED8380EC9E90EBB2A0EC89AC2028EC8BA0ED99942900EC8BA0ED999400020310016300000073008C4E01008909170000050100000000, 39804), +(2939349194, 744, 'koKR', 0xECA780EBB0B0EC9D9820EC84B1EC868C2028EC9881EC9B852900EC9881EC9B850003020F0123000000E2008C4E010092090F00001E0000000000, 39804), +(2939349194, 743, 'koKR', 0xECA780EBB0B0EC9D9820EC84B1EC868C2028EC9DBCEBB0982900EC9DBCEBB0980003010F0123000000D5008C4E010092090E00001E0000000000, 39804), +(2381039112, 3271, 'koKR', 0x00C70C000000000000A70400005407000000000000000000000000000000, 39804), +(2299908982, 560, 'koKR', 0x0000000000, 39804), +(1385971161, 12023, 'koKR', 0x30020000C70C0000, 39804), +(1369604944, 6963, 'koKR', 0x000000000000000000000000000000000000000000000000331B0000FA9800000000162200000000000000002C010000EE02140200003A0B0000000000000000001218, 39804), +(1369604944, 6960, 'koKR', 0x000000000000000000000000000000000000000000000000301B0000210200000000162200000000000000002C010000EE021402000000000000000000000000001218, 39804), +(336222293, 8447, 'koKR', 0x00D000C70C0000, 39804), +(336222293, 8446, 'koKR', 0x001101C70C0000, 39804), +(336222293, 8445, 'koKR', 0x001300C70C0000, 39804), +(48336690, 39162, 'koKR', 0x0000000000000000000040400000C03F000090400000803F00000000000000000000000009000000000000000000000000000000FFFFFFFF00, 39804), +(48336690, 39161, 'koKR', 0x0000000000000000000040400000C03F000090400000803F0000000000000000000000000A000000000000000000000000000000FFFFFFFF00, 39804); + +DELETE FROM `item_search_name_locale` WHERE `VerifiedBuild` > 0 AND `locale` = 'koKR' AND `ID` IN (182247, 182246, 182245, 182244, 182243, 182242, 182241, 182229, 182228, 182227, 182226, 182225, 182224, 182223, 177203, 177202, 177201, 177200, 177199, 177198, 177197, 174303); +INSERT INTO `item_search_name_locale` (`ID`, `locale`, `Display_lang`, `VerifiedBuild`) VALUES +(182247, 'koKR', '시초의 전술가의 팔보호구', 39804), +(182246, 'koKR', '시초의 전술가의 요대', 39804), +(182245, 'koKR', '시초의 전술가의 어깨덮개', 39804), +(182244, 'koKR', '시초의 전술가의 정강이싸개', 39804), +(182243, 'koKR', '시초의 전술가의 건틀릿', 39804), +(182242, 'koKR', '시초의 전술가의 발덮개', 39804), +(182241, 'koKR', '시초의 전술가의 갑옷', 39804), +(182229, 'koKR', '시초의 망령의 손목보호대', 39804), +(182228, 'koKR', '시초의 망령의 허리띠', 39804), +(182227, 'koKR', '시초의 망령의 어깨보호구', 39804), +(182226, 'koKR', '시초의 망령의 짧은바지', 39804), +(182225, 'koKR', '시초의 망령의 교살 장갑', 39804), +(182224, 'koKR', '시초의 망령의 장화', 39804), +(182223, 'koKR', '시초의 망령의 웃옷', 39804), +(177203, 'koKR', '조화로운 인도자의 손목싸개', 39804), +(177202, 'koKR', '조화로운 인도자의 요대', 39804), +(177201, 'koKR', '조화로운 인도자의 어깨보호구', 39804), +(177200, 'koKR', '조화로운 인도자의 다리보호대', 39804), +(177199, 'koKR', '조화로운 인도자의 건틀릿', 39804), +(177198, 'koKR', '조화로운 인도자의 전쟁장화', 39804), +(177197, 'koKR', '조화로운 인도자의 가슴갑옷', 39804), +(174303, 'koKR', '조화로운 제련장인의 새김도끼', 39804); + + +UPDATE `hotfix_optional_data` SET `VerifiedBuild` = 39804 WHERE (`TableHash` = 35137211) AND (`RecordId` = 212142) AND (`locale` = 'koKR') AND (`Key` = 3744420815); +UPDATE `hotfix_optional_data` SET `VerifiedBuild` = 39804 WHERE (`TableHash` = 35137211) AND (`RecordId` = 211463) AND (`locale` = 'koKR') AND (`Key` = 3744420815); +UPDATE `hotfix_optional_data` SET `VerifiedBuild` = 39804 WHERE (`TableHash` = 35137211) AND (`RecordId` = 211262) AND (`locale` = 'koKR') AND (`Key` = 3744420815); +UPDATE `hotfix_optional_data` SET `VerifiedBuild` = 39804 WHERE (`TableHash` = 35137211) AND (`RecordId` = 210350) AND (`locale` = 'koKR') AND (`Key` = 3744420815); +UPDATE `hotfix_optional_data` SET `VerifiedBuild` = 39804 WHERE (`TableHash` = 35137211) AND (`RecordId` = 210349) AND (`locale` = 'koKR') AND (`Key` = 3744420815); +UPDATE `hotfix_optional_data` SET `VerifiedBuild` = 39804 WHERE (`TableHash` = 35137211) AND (`RecordId` = 210338) AND (`locale` = 'koKR') AND (`Key` = 3744420815); +UPDATE `hotfix_optional_data` SET `VerifiedBuild` = 39804 WHERE (`TableHash` = 35137211) AND (`RecordId` = 210336) AND (`locale` = 'koKR') AND (`Key` = 3744420815); +UPDATE `hotfix_optional_data` SET `VerifiedBuild` = 39804 WHERE (`TableHash` = 35137211) AND (`RecordId` = 209146) AND (`locale` = 'koKR') AND (`Key` = 3744420815); +UPDATE `hotfix_optional_data` SET `VerifiedBuild` = 39804 WHERE (`TableHash` = 35137211) AND (`RecordId` = 208310) AND (`locale` = 'koKR') AND (`Key` = 3744420815); + +DELETE FROM `item_sparse_locale` WHERE (`ID` = 136605) AND (`locale` = 'koKR'); + +DELETE FROM `item_sparse_locale` WHERE `VerifiedBuild` > 0 AND `locale` = 'koKR' AND `ID` IN (187917, 187863, 182247, 182246, 182245, 182244, 182243, 182242, 182241, 182229, 182228, 182227, 182226, 182225, 182224, 182223, 177203, 177202, 177201, 177200, 177199, 177198, 177197, 174303); +INSERT INTO `item_sparse_locale` (`ID`, `locale`, `Description_lang`, `Display3_lang`, `Display2_lang`, `Display1_lang`, `Display_lang`, `VerifiedBuild`) VALUES +(187917, 'koKR', '', '', '', '', '미치광이 공작의 차', 39804), +(187863, 'koKR', '열쇠가 존재의 경계를 넘나듭니다. 자세히 보기가 어렵습니다... 아니, 실재하는지조차 구분할 수가 없습니다.', '', '', '', '찰나의 열쇠', 39804), +(182247, 'koKR', '', '', '', '', '시초의 전술가의 팔보호구', 39804), +(182246, 'koKR', '', '', '', '', '시초의 전술가의 요대', 39804), +(182245, 'koKR', '', '', '', '', '시초의 전술가의 어깨덮개', 39804), +(182244, 'koKR', '', '', '', '', '시초의 전술가의 정강이싸개', 39804), +(182243, 'koKR', '', '', '', '', '시초의 전술가의 건틀릿', 39804), +(182242, 'koKR', '', '', '', '', '시초의 전술가의 발덮개', 39804), +(182241, 'koKR', '', '', '', '', '시초의 전술가의 갑옷', 39804), +(182229, 'koKR', '', '', '', '', '시초의 망령의 손목보호대', 39804), +(182228, 'koKR', '', '', '', '', '시초의 망령의 허리띠', 39804), +(182227, 'koKR', '', '', '', '', '시초의 망령의 어깨보호구', 39804), +(182226, 'koKR', '', '', '', '', '시초의 망령의 짧은바지', 39804), +(182225, 'koKR', '', '', '', '', '시초의 망령의 교살 장갑', 39804), +(182224, 'koKR', '', '', '', '', '시초의 망령의 장화', 39804), +(182223, 'koKR', '', '', '', '', '시초의 망령의 웃옷', 39804), +(177203, 'koKR', '', '', '', '', '조화로운 인도자의 손목싸개', 39804), +(177202, 'koKR', '', '', '', '', '조화로운 인도자의 요대', 39804), +(177201, 'koKR', '', '', '', '', '조화로운 인도자의 어깨보호구', 39804), +(177200, 'koKR', '', '', '', '', '조화로운 인도자의 다리보호대', 39804), +(177199, 'koKR', '', '', '', '', '조화로운 인도자의 건틀릿', 39804), +(177198, 'koKR', '', '', '', '', '조화로운 인도자의 전쟁장화', 39804), +(177197, 'koKR', '', '', '', '', '조화로운 인도자의 가슴갑옷', 39804), +(174303, 'koKR', '', '', '', '', '조화로운 제련장인의 새김도끼', 39804); + +DELETE FROM `map_locale` WHERE `VerifiedBuild` > 0 AND `locale` = 'koKR' AND `ID` IN (2450); +INSERT INTO `map_locale` (`ID`, `locale`, `MapName_lang`, `MapDescription0_lang`, `MapDescription1_lang`, `PvpShortDescription_lang`, `PvpLongDescription_lang`, `VerifiedBuild`) VALUES +(2450, 'koKR', '지배의 성소', '', '', '', '', 39804); + +DELETE FROM `spell_name_locale` WHERE `VerifiedBuild` > 0 AND `locale` = 'koKR' AND `ID` IN (360832, 360829, 360749, 360592, 358693, 358692, 358518, 357073, 357069, 357062, 357058, 357052, 357049, 357034, 357031, 356593, 356248, 355741, 355721, 354098, 354058, 345482, 341724, 340433, 138083); +INSERT INTO `spell_name_locale` (`ID`, `locale`, `Name_lang`, `VerifiedBuild`) VALUES +(360832, 'koKR', '짜릿한 호랑이 번개 추진', 39804), +(360829, 'koKR', '강화된 호랑이 번개', 39804), +(360749, 'koKR', 'Kill Credit', 39804), +(360592, 'koKR', 'Spectral Feline', 39804), +(358693, 'koKR', '영혼의 분노', 39804), +(358692, 'koKR', '영혼의 어둠', 39804), +(358518, 'koKR', '백호 쉬엔의 원령', 39804), +(357073, 'koKR', '경악스러운 코르의 조각', 39804), +(357069, 'koKR', '경악스러운 베크의 조각', 39804), +(357062, 'koKR', '불길한 코르의 조각', 39804), +(357058, 'koKR', '불길한 베크의 조각', 39804), +(357052, 'koKR', '황폐한 코르의 조각', 39804), +(357049, 'koKR', '황폐한 베크의 조각', 39804), +(357034, 'koKR', '음산한 코르의 조각', 39804), +(357031, 'koKR', '음산한 베크의 조각', 39804), +(356593, 'koKR', '마력 해체', 39804), +(356248, 'koKR', '저 너머의 결속체', 39804), +(355741, 'koKR', '코르의 조각', 39804), +(355721, 'koKR', '베크의 조각', 39804), +(354098, 'koKR', '간식 주기', 39804), +(354058, 'koKR', '선물', 39804), +(345482, 'koKR', '해방된 현실', 39804), +(341724, 'koKR', '얼어붙은 용사의 분노', 39804), +(340433, 'koKR', '죄악의 몰락지의 은혜', 39804), +(138083, 'koKR', '폭풍과 대지와 불', 39804); + +UPDATE `broadcast_text_locale` SET `VerifiedBuild` = 39804 WHERE `locale` = 'koKR' AND `ID` IN (212589, 212227, 212142, 211907, 211463, 211262, 210756, 210419, 210350, 210349, 210338, 210336, 209648, 209146, 208310, 207999, 202525, 130831, 116249, 56587, 56586, 56585, 56582, 56581, 56312, 56277, 56276, 56270, 56269, 54347, 54338, 53929, 48182, 48181, 48180, 47584, 45365, 31716, 27048, 27046, 27043, 27042, 26970, 26969, 26968, 26967, 26966, 26965, 26964, 26963, 26956, 26936, 26798, 9875, 9874, 9872, 9870); +UPDATE `faction_locale` SET `VerifiedBuild` = 39804 WHERE `VerifiedBuild` > 0 AND `locale` = 'koKR'; +UPDATE `currency_types_locale` SET `VerifiedBuild` = 39804 WHERE `VerifiedBuild` > 0 AND `locale` = 'koKR'; +UPDATE `item_name_description_locale` SET `VerifiedBuild` = 39804 WHERE `VerifiedBuild` > 0 AND `locale` = 'koKR'; +UPDATE `gameobjects_locale` SET `VerifiedBuild` = 39804 WHERE `VerifiedBuild` > 0 AND `locale` = 'koKR'; +UPDATE `hotfix_blob` SET `VerifiedBuild` = 39804 WHERE `VerifiedBuild` > 0 AND `locale` = 'koKR'; +UPDATE `item_sparse_locale` SET `VerifiedBuild` = 39804 WHERE `VerifiedBuild` > 0 AND `locale` = 'koKR'; +UPDATE `friendship_reputation_locale` SET `VerifiedBuild` = 39804 WHERE `VerifiedBuild` > 0 AND `locale` = 'koKR'; +UPDATE `lfg_dungeons_locale` SET `VerifiedBuild` = 39804 WHERE `VerifiedBuild` > 0 AND `locale` = 'koKR'; +UPDATE `mount_locale` SET `VerifiedBuild` = 39804 WHERE `VerifiedBuild` > 0 AND `locale` = 'koKR'; +UPDATE `item_search_name_locale` SET `VerifiedBuild` = 39804 WHERE `VerifiedBuild` > 0 AND `locale` = 'koKR'; +UPDATE `map_locale` SET `VerifiedBuild` = 39804 WHERE `VerifiedBuild` > 0 AND `locale` = 'koKR'; +UPDATE `map_difficulty_locale` SET `VerifiedBuild` = 39804 WHERE `VerifiedBuild` > 0 AND `locale` = 'koKR'; +UPDATE `achievement_locale` SET `VerifiedBuild` = 39804 WHERE `VerifiedBuild` > 0 AND `locale` = 'koKR'; +UPDATE `area_table_locale` SET `VerifiedBuild` = 39804 WHERE `VerifiedBuild` > 0 AND `locale` = 'koKR'; +UPDATE `criteria_tree_locale` SET `VerifiedBuild` = 39804 WHERE `VerifiedBuild` > 0 AND `locale` = 'koKR'; +UPDATE `dungeon_encounter_locale` SET `VerifiedBuild` = 39804 WHERE `VerifiedBuild` > 0 AND `locale` = 'koKR'; +UPDATE `adventure_journal_locale` SET `VerifiedBuild` = 39804 WHERE `VerifiedBuild` > 0 AND `locale` = 'koKR'; +UPDATE `pvp_talent_locale` SET `VerifiedBuild` = 39804 WHERE `VerifiedBuild` > 0 AND `locale` = 'koKR'; +UPDATE `player_condition_locale` SET `VerifiedBuild` = 39804 WHERE `VerifiedBuild` > 0 AND `locale` = 'koKR'; +UPDATE `spell_name_locale` SET `VerifiedBuild` = 39804 WHERE `VerifiedBuild` > 0 AND `locale` = 'koKR'; +UPDATE `toy_locale` SET `VerifiedBuild` = 39804 WHERE `VerifiedBuild` > 0 AND `locale` = 'koKR'; +UPDATE `transmog_set_locale` SET `VerifiedBuild` = 39804 WHERE `VerifiedBuild` > 0 AND `locale` = 'koKR'; +UPDATE `wmo_area_table_locale` SET `VerifiedBuild` = 39804 WHERE `VerifiedBuild` > 0 AND `locale` = 'koKR'; +UPDATE `ui_map_locale` SET `VerifiedBuild` = 39804 WHERE `VerifiedBuild` > 0 AND `locale` = 'koKR'; |