diff options
| author | Motive <42782517+motivewc@users.noreply.github.com> | 2024-08-28 13:59:19 -0400 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2024-08-28 19:59:19 +0200 |
| commit | 6b2d12206c56222ddd7877a786d11701396fc63f (patch) | |
| tree | 710c46fb031ae934c93b8b184947d8f4d0068d6b | |
| parent | 1f0a62bde5b927392a58e95a87d4d8bd93438d7e (diff) | |
Core: Allow macOS arm64 client to connect (#30173)
| -rw-r--r-- | sql/base/auth_database.sql | 572 | ||||
| -rw-r--r-- | sql/updates/auth/master/2024_08_28_01_auth.sql | 6 | ||||
| -rw-r--r-- | src/server/bnetserver/Server/Session.cpp | 2 | ||||
| -rw-r--r-- | src/server/game/Server/WorldSocket.cpp | 4 | ||||
| -rw-r--r-- | src/server/shared/Realm/RealmList.cpp | 8 | ||||
| -rw-r--r-- | src/server/shared/Realm/RealmList.h | 1 |
6 files changed, 305 insertions, 288 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql index 5d86f1562ec..418c9bb13f6 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -513,6 +513,7 @@ CREATE TABLE `build_info` ( `winAuthSeed` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `win64AuthSeed` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `mac64AuthSeed` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `macArmAuthSeed` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `winChecksumSeed` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `macChecksumSeed` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`build`) @@ -526,290 +527,290 @@ CREATE TABLE `build_info` ( LOCK TABLES `build_info` WRITE; /*!40000 ALTER TABLE `build_info` DISABLE KEYS */; INSERT INTO `build_info` VALUES -(5875,1,12,1,NULL,NULL,NULL,NULL,'95EDB27C7823B363CBDDAB56A392E7CB73FCCA20','8D173CC381961EEBABF336F5E6675B101BB513E5'), -(6005,1,12,2,NULL,NULL,NULL,NULL,NULL,NULL), -(6141,1,12,3,NULL,NULL,NULL,NULL,NULL,NULL), -(8606,2,4,3,NULL,NULL,NULL,NULL,'319AFAA3F2559682F9FF658BE01456255F456FB1','D8B0ECFE534BC1131E19BAD1D4C0E813EEE4994F'), -(9947,3,1,3,NULL,NULL,NULL,NULL,NULL,NULL), -(10505,3,2,2,'a',NULL,NULL,NULL,NULL,NULL), -(11159,3,3,0,'a',NULL,NULL,NULL,NULL,NULL), -(11403,3,3,2,NULL,NULL,NULL,NULL,NULL,NULL), -(11723,3,3,3,'a',NULL,NULL,NULL,NULL,NULL), -(12340,3,3,5,'a',NULL,NULL,NULL,'CDCBBD5188315E6B4D19449D492DBCFAF156A347','B706D13FF2F4018839729461E3F8A0E2B5FDC034'), -(13623,4,0,6,'a',NULL,NULL,NULL,NULL,NULL), -(13930,3,3,5,'a',NULL,NULL,NULL,NULL,NULL), -(14545,4,2,2,NULL,NULL,NULL,NULL,NULL,NULL), -(15595,4,3,4,NULL,NULL,NULL,NULL,NULL,NULL), -(19116,6,0,3,NULL,NULL,NULL,NULL,NULL,NULL), -(19243,6,0,3,NULL,NULL,NULL,NULL,NULL,NULL), -(19342,6,0,3,NULL,NULL,NULL,NULL,NULL,NULL), -(19702,6,1,0,NULL,NULL,NULL,NULL,NULL,NULL), -(19802,6,1,2,NULL,NULL,NULL,NULL,NULL,NULL), -(19831,6,1,2,NULL,NULL,NULL,NULL,NULL,NULL), -(19865,6,1,2,NULL,NULL,NULL,NULL,NULL,NULL), -(20182,6,2,0,'a',NULL,NULL,NULL,NULL,NULL), -(20201,6,2,0,NULL,NULL,NULL,NULL,NULL,NULL), -(20216,6,2,0,NULL,NULL,NULL,NULL,NULL,NULL), -(20253,6,2,0,NULL,NULL,NULL,NULL,NULL,NULL), -(20338,6,2,0,NULL,NULL,NULL,NULL,NULL,NULL), -(20444,6,2,2,NULL,NULL,NULL,NULL,NULL,NULL), -(20490,6,2,2,'a',NULL,NULL,NULL,NULL,NULL), -(20574,6,2,2,'a',NULL,NULL,NULL,NULL,NULL), -(20726,6,2,3,NULL,NULL,NULL,NULL,NULL,NULL), -(20779,6,2,3,NULL,NULL,NULL,NULL,NULL,NULL), -(20886,6,2,3,NULL,NULL,NULL,NULL,NULL,NULL), -(21355,6,2,4,NULL,NULL,NULL,NULL,NULL,NULL), -(21463,6,2,4,NULL,NULL,NULL,NULL,NULL,NULL), -(21742,6,2,4,NULL,NULL,NULL,NULL,NULL,NULL), -(22248,7,0,3,NULL,NULL,NULL,NULL,NULL,NULL), -(22293,7,0,3,NULL,NULL,NULL,NULL,NULL,NULL), -(22345,7,0,3,NULL,NULL,NULL,NULL,NULL,NULL), -(22410,7,0,3,NULL,NULL,NULL,NULL,NULL,NULL), -(22423,7,0,3,NULL,NULL,NULL,NULL,NULL,NULL), -(22498,7,0,3,NULL,NULL,NULL,NULL,NULL,NULL), -(22522,7,0,3,NULL,NULL,NULL,NULL,NULL,NULL), -(22566,7,0,3,NULL,NULL,NULL,NULL,NULL,NULL), -(22594,7,0,3,NULL,NULL,NULL,NULL,NULL,NULL), -(22624,7,0,3,NULL,NULL,NULL,NULL,NULL,NULL), -(22747,7,0,3,NULL,NULL,NULL,NULL,NULL,NULL), -(22810,7,0,3,NULL,NULL,NULL,NULL,NULL,NULL), -(22900,7,1,0,NULL,NULL,NULL,NULL,NULL,NULL), -(22908,7,1,0,NULL,NULL,NULL,NULL,NULL,NULL), -(22950,7,1,0,NULL,NULL,NULL,NULL,NULL,NULL), -(22995,7,1,0,NULL,NULL,NULL,NULL,NULL,NULL), -(22996,7,1,0,NULL,NULL,NULL,NULL,NULL,NULL), -(23171,7,1,0,NULL,NULL,NULL,NULL,NULL,NULL), -(23222,7,1,0,NULL,NULL,NULL,NULL,NULL,NULL), -(23360,7,1,5,NULL,NULL,NULL,NULL,NULL,NULL), -(23420,7,1,5,NULL,NULL,NULL,NULL,NULL,NULL), -(23911,7,2,0,NULL,NULL,NULL,NULL,NULL,NULL), -(23937,7,2,0,NULL,NULL,NULL,NULL,NULL,NULL), -(24015,7,2,0,NULL,NULL,NULL,NULL,NULL,NULL), -(24330,7,2,5,NULL,NULL,NULL,NULL,NULL,NULL), -(24367,7,2,5,NULL,NULL,NULL,NULL,NULL,NULL), -(24415,7,2,5,NULL,NULL,NULL,NULL,NULL,NULL), -(24430,7,2,5,NULL,NULL,NULL,NULL,NULL,NULL), -(24461,7,2,5,NULL,NULL,NULL,NULL,NULL,NULL), -(24742,7,2,5,NULL,NULL,NULL,NULL,NULL,NULL), -(25549,7,3,2,NULL,'FE594FC35E7F9AFF86D99D8A364AB297','1252624ED8CBD6FAC7D33F5D67A535F3','66FC5E09B8706126795F140308C8C1D8',NULL,NULL), -(25996,7,3,5,NULL,'23C59C5963CBEF5B728D13A50878DFCB','C7FF932D6A2174A3D538CA7212136D2B','210B970149D6F56CAC9BADF2AAC91E8E',NULL,NULL), -(26124,7,3,5,NULL,'F8C05AE372DECA1D6C81DA7A8D1C5C39','46DF06D0147BA67BA49AF553435E093F','C9CA997AB8EDE1C65465CB2920869C4E',NULL,NULL), -(26365,7,3,5,NULL,'2AAC82C80E829E2CA902D70CFA1A833A','59A53F307288454B419B13E694DF503C','DBE7F860276D6B400AAA86B35D51A417',NULL,NULL), -(26654,7,3,5,NULL,'FAC2D693E702B9EC9F750F17245696D8','A752640E8B99FE5B57C1320BC492895A','9234C1BD5E9687ADBD19F764F2E0E811',NULL,NULL), -(26822,7,3,5,NULL,'283E8D77ECF7060BE6347BE4EB99C7C7','2B05F6D746C0C6CC7EF79450B309E595','91003668C245D14ECD8DF094E065E06B',NULL,NULL), -(26899,7,3,5,NULL,'F462CD2FE4EA3EADF875308FDBB18C99','3551EF0028B51E92170559BD25644B03','8368EFC2021329110A16339D298200D4',NULL,NULL), -(26972,7,3,5,NULL,'797ECC19662DCBD5090A4481173F1D26','6E212DEF6A0124A3D9AD07F5E322F7AE','341CFEFE3D72ACA9A4407DC535DED66A',NULL,NULL), -(28153,8,0,1,NULL,NULL,'DD626517CC6D31932B479934CCDC0ABF',NULL,NULL,NULL), -(30706,8,1,5,NULL,NULL,'BB6D9866FE4A19A568015198783003FC',NULL,NULL,NULL), -(30993,8,2,0,NULL,NULL,'2BAD61655ABC2FC3D04893B536403A91',NULL,NULL,NULL), -(31229,8,2,0,NULL,NULL,'8A46F23670309F2AAE85C9A47276382B',NULL,NULL,NULL), -(31429,8,2,0,NULL,NULL,'7795A507AF9DC3525EFF724FEE17E70C',NULL,NULL,NULL), -(31478,8,2,0,NULL,NULL,'7973A8D54BDB8B798D9297B096E771EF',NULL,NULL,NULL), -(32305,8,2,5,NULL,NULL,'21F5A6FC7AD89FBF411FDA8B8738186A',NULL,NULL,NULL), -(32494,8,2,5,NULL,NULL,'58984ACE04919401835C61309A848F8A',NULL,NULL,NULL), -(32580,8,2,5,NULL,NULL,'87C2FAA0D7931BF016299025C0DDCA14',NULL,NULL,NULL), -(32638,8,2,5,NULL,NULL,'5D07ECE7D4A867DDDE615DAD22B76D4E',NULL,NULL,NULL), -(32722,8,2,5,NULL,NULL,'1A09BE1D38A122586B4931BECCEAD4AA',NULL,NULL,NULL), -(32750,8,2,5,NULL,NULL,'C5CB669F5A5B237D1355430877173207','EF1F4E4D099EA2A81FD4C0DEBC1E7086',NULL,NULL), -(32978,8,2,5,NULL,NULL,'76AE2EA03E525D97F5688843F5489000','1852C1F847E795D6EB45278CD433F339',NULL,NULL), -(33369,8,3,0,NULL,NULL,'5986AC18B04D3C403F56A0CF8C4F0A14','F5A849C70A1054F07EA3AB833EBF6671',NULL,NULL), -(33528,8,3,0,NULL,NULL,'0ECE033CA9B11D92F7D2792C785B47DF',NULL,NULL,NULL), -(33724,8,3,0,NULL,NULL,'38F7BBCF284939DD20E8C64CDBF9FE77',NULL,NULL,NULL), -(33775,8,3,0,NULL,NULL,'B826300A8449ED0F6EF16EA747FA2D2E','354D2DE619D124EE1398F76B0436FCFC',NULL,NULL), -(33941,8,3,0,NULL,NULL,'88AF1A36D2770D0A6CA086497096A889',NULL,NULL,NULL), -(34220,8,3,0,NULL,NULL,'B5E35B976C6BAF82505700E7D9666A2C',NULL,NULL,NULL), -(34601,8,3,0,NULL,NULL,'0D7DF38F725FABA4F009257799A10563',NULL,NULL,NULL), -(34769,8,3,0,NULL,NULL,'93F9B9AF6397E3E4EED94D36D16907D2',NULL,NULL,NULL), -(34963,8,3,0,NULL,NULL,'7BA50C879C5D04221423B02AC3603A11','C5658A17E702163447BAAAE46D130A1B',NULL,NULL), -(35249,8,3,7,NULL,NULL,'C7B11F9AE9FF1409F5582902B3D10D1C',NULL,NULL,NULL), -(35284,8,3,7,NULL,NULL,'EA3818E7DCFD2009DBFC83EE3C1E4F1B','A6201B0AC5A73D13AB2FDCC79BB252AF',NULL,NULL), -(35435,8,3,7,NULL,NULL,'BB397A92FE23740EA52FC2B5BA2EC8E0','8FE657C14A46BCDB2CE6DA37E430450E',NULL,NULL), -(35662,8,3,7,NULL,NULL,'578BC94870C278CB6962F30E6DC203BB','5966016C368ED9F7AAB603EE6703081C',NULL,NULL), -(36753,9,0,2,NULL,NULL,'386FDE8559B5EAD67B791B490B200B88',NULL,NULL,NULL), -(36839,9,0,2,NULL,NULL,'356EB4412B8EFCF72E3AF50D5181D529',NULL,NULL,NULL), -(36949,9,0,2,NULL,NULL,'51C074CD8A09A75384B9B44188C56981',NULL,NULL,NULL), -(37142,9,0,2,NULL,NULL,'5D9CFB3139F0D1B6C2B304261F9EABC9',NULL,NULL,NULL), -(37176,9,0,2,NULL,NULL,'3C725EA504EC3DAED143EB6FF3B48CDA',NULL,NULL,NULL), -(37474,9,0,2,NULL,NULL,'0DE685BBB0551086E7FBDC0B4BB06A5B','024C9BE7E44237B7E81C6D42E678D433',NULL,NULL), -(38134,9,0,5,NULL,NULL,'32275ED0F13B357C28BDB0E611EF9E31',NULL,NULL,NULL), -(38556,9,0,5,NULL,NULL,'EC7D5AF64364AC3E7181F3FBA1B3A882',NULL,NULL,NULL), -(39653,9,1,0,NULL,NULL,'10D015AB1EEB91310428D9C57EE24632',NULL,NULL,NULL), -(39804,9,1,0,NULL,NULL,'E42D2BBA12ED260A76F9B1E477E19EA5',NULL,NULL,NULL), -(40000,9,1,0,NULL,NULL,'4CB1433AB637F09F03FBBD1B221B04B0',NULL,NULL,NULL), -(40120,9,1,0,NULL,NULL,'04F47EAEFD8BDEFE14AA0350EA336678','853F0F2985CEAED46DF422583CD07A7C',NULL,NULL), -(40443,9,1,0,NULL,NULL,'8597BB43E8AB38C85504E8BFB72ABBF5',NULL,NULL,NULL), -(40593,9,1,0,NULL,NULL,'BA14570F2D62D5F61953394164A8DAE2',NULL,NULL,NULL), -(40725,9,1,0,NULL,NULL,'C1EBDBEB9BB2956EBCCEF7C9D27A1B3B',NULL,NULL,NULL), -(40906,9,1,5,NULL,NULL,'F5FC259C8635488AFE0D0CD023F361D4',NULL,NULL,NULL), -(40944,9,1,5,NULL,NULL,'368FC7FABAF487A8A049C11970657074',NULL,NULL,NULL), -(40966,9,1,5,NULL,NULL,'D90F47AF21F381D2D8F3763B994BAC88',NULL,NULL,NULL), -(41031,9,1,5,NULL,NULL,'019A0FACD6B0D6374B7BA69A5B677449',NULL,NULL,NULL), -(41079,9,1,5,NULL,NULL,'F8853CF823BC0BBE8A9677A762DFAEE1',NULL,NULL,NULL), -(41288,9,1,5,NULL,NULL,'871C0C9691DBC536EB24B68EC73FAD5B',NULL,NULL,NULL), -(41323,9,1,5,NULL,NULL,'E53D0DF1FAC1A59A1C8071B295A04A1D',NULL,NULL,NULL), -(41359,9,1,5,NULL,NULL,'5F8D7F2A690A4375A1B52A28D6D681FA',NULL,NULL,NULL), -(41488,9,1,5,NULL,NULL,'1BC91EC368705815F3F532B553DAD981',NULL,NULL,NULL), -(41793,9,1,5,NULL,NULL,'B3B47DA3B7615570742A55B96614EE1C',NULL,NULL,NULL), -(42010,9,1,5,NULL,NULL,'302970161D16417B5BE553CC530E011A',NULL,NULL,NULL), -(42423,9,2,0,NULL,NULL,'0B03614A7E94DD57548596BE420E9DC2',NULL,NULL,NULL), -(42488,9,2,0,NULL,NULL,'A78755E6928D83A271C5D1EE3CDB6F15',NULL,NULL,NULL), -(42521,9,2,0,NULL,NULL,'5FE6C12FC407C6B15B4A5D3B5B4A5D3B',NULL,NULL,NULL), -(42538,9,2,0,NULL,NULL,'71A7504BD53F8DE518F24265D37310AE',NULL,NULL,NULL), -(42560,9,2,0,NULL,NULL,'115FE8C38A8D67CA4664BB192E0F0DFE',NULL,NULL,NULL), -(42614,9,2,0,NULL,NULL,'772BE726FEEF42124255D2EA7973CA18',NULL,NULL,NULL), -(42698,9,2,0,NULL,NULL,'B4497B1CD11FC974C5FB09548AC27269',NULL,NULL,NULL), -(42825,9,2,0,NULL,NULL,'A14DA228C6A6AFF1DDBA51218939E557',NULL,NULL,NULL), -(42852,9,2,0,NULL,NULL,'DE9F9F0C3CC8FD54D3AFF99CEFFCE129',NULL,NULL,NULL), -(42937,9,2,0,NULL,NULL,'F5FC75E70874752C92846B3333920E63',NULL,NULL,NULL), -(42979,9,2,0,NULL,NULL,'E1DD38AE6450FC4D2AE4609233C59E54',NULL,NULL,NULL), -(43114,9,2,0,NULL,NULL,'F75C9380CCB24A48A24EEE52C1594A7E',NULL,NULL,NULL), -(43206,9,2,0,NULL,NULL,'DDE806532C7704FFB75F256DC5F1F3D9',NULL,NULL,NULL), -(43340,9,2,0,NULL,NULL,'70E46D2D888E84DF9316EA849B068CF4',NULL,NULL,NULL), -(43345,9,2,0,NULL,NULL,'D911ABFCDA030DEE8CAF4EE3F60DEE13',NULL,NULL,NULL), -(43971,9,2,5,NULL,NULL,'681CF99E61FB0005A5C7D31D0AAD1ED9',NULL,NULL,NULL), -(44015,9,2,5,NULL,NULL,'FCF0BDA7C98BFEF92AE6D8C39A217ABD',NULL,NULL,NULL), -(44061,9,2,5,NULL,NULL,'FD2B5C0B3293FE0E9CAA6EB0B7788119',NULL,NULL,NULL), -(44127,9,2,5,NULL,NULL,'787887CEC9FCC9B516481F60E4FC34A8',NULL,NULL,NULL), -(44232,9,2,5,NULL,NULL,'81F0A71DF7E9873BB3750022D64D33CF',NULL,NULL,NULL), -(44325,9,2,5,NULL,NULL,'138A7D524D268A7F9934C3D148E8F01B',NULL,NULL,NULL), -(44730,9,2,5,NULL,NULL,'FC0B18C47BB4C79F4300CA0FF3E5CAC7',NULL,NULL,NULL), -(44908,9,2,5,NULL,NULL,'BFFAEC40C9BCD591C7C959A9D5A8BA8C',NULL,NULL,NULL), -(45114,9,2,7,NULL,NULL,'D7AFE240BD00F06C30D0C2D16E54A8BE',NULL,NULL,NULL), -(45161,9,2,7,NULL,NULL,'74BD2E787A98B145B063BDA9A98F6CBD',NULL,NULL,NULL), -(45338,9,2,7,NULL,NULL,'5CE2094A41B61EDA9DF56378BC3B1DE0',NULL,NULL,NULL), -(45745,9,2,7,NULL,NULL,'0F6DC90161694D765A595A3AF603166B',NULL,NULL,NULL), -(46479,10,0,2,NULL,NULL,'CB9AF4D89B60A3ABA288D395D315D932',NULL,NULL,NULL), -(46658,10,0,2,NULL,NULL,'3F8EFB085428D75360E9EFE25CD8639A',NULL,NULL,NULL), -(46689,10,0,2,NULL,NULL,'D9A11D188D6AD60906F5467510EFD3AA',NULL,NULL,NULL), -(46702,10,0,2,NULL,NULL,'01B4D1688FF97DC9AAFCCD0A0B842C0B',NULL,NULL,NULL), -(46741,10,0,2,NULL,NULL,'4C0F4A7EC2098AF1FBA745848EC79A78',NULL,NULL,NULL), -(46801,10,0,2,NULL,NULL,'E6AC18D1EA5D36ABFFAE5EDED80630DF',NULL,NULL,NULL), -(46879,10,0,2,NULL,NULL,'EFEC43936051DD1A210633AF1F6B63DB',NULL,NULL,NULL), -(46924,10,0,2,NULL,NULL,'E6CE0B1A8119F069ECF1E7DBAA7BB2F8',NULL,NULL,NULL), -(47067,10,0,2,NULL,NULL,'63862CFCDEA6BD2BD7F740EB36B65657',NULL,NULL,NULL), -(47187,10,0,2,NULL,NULL,'711F8455C5000C237292E1E6E90631E1',NULL,NULL,NULL), -(47213,10,0,2,NULL,NULL,'23C50D88CEAC0A8696ADDE8DD244D4A2',NULL,NULL,NULL), -(47631,10,0,2,NULL,NULL,'F986AB91D0AEB20822EFB72F4256713C',NULL,NULL,NULL), -(47777,10,0,5,NULL,NULL,'A88C04915AB9E035A104E55C4DCF5F9F',NULL,NULL,NULL), -(47799,10,0,5,NULL,NULL,'7364EB093C23DB2CDC9513D5A7B4933E',NULL,NULL,NULL), -(47825,10,0,5,NULL,NULL,'82A3B94E5E727AF3A208B471FF2054C0',NULL,NULL,NULL), -(47849,10,0,5,NULL,NULL,'DD8BBE2087A28C0AF4984CBE23A1C707',NULL,NULL,NULL), -(47871,10,0,5,NULL,NULL,'8E4F7D30EE4982B02B3B3F8837C2C4F2',NULL,NULL,NULL), -(47884,10,0,5,NULL,NULL,'2B7A002BC359F2C31104BC2DE04302BF',NULL,NULL,NULL), -(47936,10,0,5,NULL,NULL,'833D30D8FBC43B3FAE99CD3898D70849',NULL,NULL,NULL), -(47967,10,0,5,NULL,NULL,'CFE225D0089E224D9E7541D3B5C26478',NULL,NULL,NULL), -(48001,10,0,5,NULL,NULL,'4B0260A37BD95B615E71048469E6D5BB',NULL,NULL,NULL), -(48069,10,0,5,NULL,NULL,'558CDF958FA082E95849779C7C6945E5',NULL,NULL,NULL), -(48317,10,0,5,NULL,NULL,'C096E37B45B43244E9C79916604DD4AF',NULL,NULL,NULL), -(48397,10,0,5,NULL,NULL,'64BA8779EAA97E6C57982B6B1A5B32E7',NULL,NULL,NULL), -(48526,10,0,5,NULL,NULL,'D5B7D3303A2A741E6913EE1AEB0BCB65',NULL,NULL,NULL), -(48676,10,0,7,NULL,NULL,'E059FB74DFF6438CC20C7F28900F64CA',NULL,NULL,NULL), -(48749,10,0,7,NULL,NULL,'92DBCCA0E33DFB8A17A2B6A39246B288',NULL,NULL,NULL), -(48838,10,0,7,NULL,NULL,'9E6F4E1E46EF228D2DE90F7BC48AAA96',NULL,NULL,NULL), -(48865,10,0,7,NULL,NULL,'4B774ABE7B34D6702571B4279A4B6A13',NULL,NULL,NULL), -(48892,10,0,7,NULL,NULL,'AA31BF27458321B03A1A346964DD7B9D',NULL,NULL,NULL), -(48966,10,0,7,NULL,NULL,'823142CA131FBB715FF55D4343E55C6D',NULL,NULL,NULL), -(48999,10,0,7,NULL,NULL,'79BA6FF0F9672EEF875F64155C8B62D4',NULL,NULL,NULL), -(49267,10,0,7,NULL,NULL,'EEE77EA5A216E0731ADBB41AEFB1DF31',NULL,NULL,NULL), -(49318,10,1,0,NULL,NULL,'AF439AEE62EE48B36C1725111E3D9BBF',NULL,NULL,NULL), -(49343,10,0,7,NULL,NULL,'301A0B4C0942B9B6F605B903AD6C1F60',NULL,NULL,NULL), -(49407,10,1,0,NULL,NULL,'6413820DC9885BB0693B37090CBB2F30',NULL,NULL,NULL), -(49426,10,1,0,NULL,NULL,'D85EDFBFE9A94A55E2B4510BE41C19B2',NULL,NULL,NULL), -(49444,10,1,0,NULL,NULL,'363B2B05285BDD8857419D2866316D3C',NULL,NULL,NULL), -(49474,10,1,0,NULL,NULL,'44A7D2B352EE3D098A3CB4C2F1065E37',NULL,NULL,NULL), -(49570,10,1,0,NULL,NULL,'B024DE67ACAEB9E8EE6DB38DC53E8281',NULL,NULL,NULL), -(49679,10,1,0,NULL,NULL,'9CE59B68D8797EBF00581F41138F4316',NULL,NULL,NULL), -(49741,10,1,0,NULL,NULL,'0EF181E2BB0E946CF3B7422ADEB6CD1A',NULL,NULL,NULL), -(49801,10,1,0,NULL,NULL,'0832179567B66CA85DBD5678B604C683',NULL,NULL,NULL), -(49890,10,1,0,NULL,NULL,'22A5B8A1EB797A64995F705B3DBCB14C',NULL,NULL,NULL), -(50000,10,1,0,NULL,NULL,'02F06FFA2296FD66384295DBFD5A4C91',NULL,NULL,NULL), -(50401,10,1,5,NULL,NULL,'3EEF52D902CCE81D16D0E255F0AA4938',NULL,NULL,NULL), -(50438,10,1,5,NULL,NULL,'0B5F68F06B129CB4C57702F6D30F260B',NULL,NULL,NULL), -(50467,10,1,5,NULL,NULL,'5E996B1CDCEE68432D6340138E68D1EB',NULL,NULL,NULL), -(50469,10,1,5,NULL,NULL,'1768CCB6589E16AB3BEFA9D608A393A2',NULL,NULL,NULL), -(50504,10,1,5,NULL,NULL,'7D5FD20C0B32C9AF5DD65433B391D49C',NULL,NULL,NULL), -(50585,10,1,5,NULL,NULL,'C4F7CC38A3B84935A485F7EDAD3E764B',NULL,NULL,NULL), -(50622,10,1,5,NULL,NULL,'D23A26FD75FD9A6073EB7060AA28E6A7',NULL,NULL,NULL), -(50747,10,1,5,NULL,NULL,'2D3C386A9C45C27304ED3A3C6EB3F7C8',NULL,NULL,NULL), -(50791,10,1,5,NULL,NULL,'0BE7D0BB07EF37C25CBC682409091EA0',NULL,NULL,NULL), -(51130,10,1,5,NULL,NULL,'44CD2C91E4F0655DA387483726CE4035',NULL,NULL,NULL), -(51187,10,1,7,NULL,NULL,'74E2055D3965269447B5CB1B31FC71C6',NULL,NULL,NULL), -(51237,10,1,7,NULL,NULL,'C8660A21B766646FBD67F481CFCF55C3',NULL,NULL,NULL), -(51261,10,1,7,NULL,NULL,'1BEBB57AE450331E9F8C301AA7876FAB',NULL,NULL,NULL), -(51313,10,1,7,NULL,NULL,'35419ED0AB16735CF720858F45DC300C',NULL,NULL,NULL), -(51421,10,1,7,NULL,NULL,'45E24D6F3335269787DF2B2063939002',NULL,NULL,NULL), -(51485,10,1,7,NULL,NULL,'EC549E1D0A5DD85C03E7A9D93B7DC6D1',NULL,NULL,NULL), -(51536,10,1,7,NULL,NULL,'570EEA10A8EC169C3FF9621D1B635BB4',NULL,NULL,NULL), -(51754,10,1,7,NULL,NULL,'BED5A861C071AB41FEF6087E0C37BB1A',NULL,NULL,NULL), -(51886,10,1,7,NULL,NULL,'09CF8919FD2EABDEAEBC0C810F53B511',NULL,NULL,NULL), -(51972,10,1,7,NULL,NULL,'444DC7EF3544B6670C18884DADA00428',NULL,NULL,NULL), -(52038,10,2,0,NULL,NULL,'A8EF004ADED8A3AFF5A67D2BB8D95795',NULL,NULL,NULL), -(52068,10,2,0,NULL,NULL,'A44F842BACCC7EE8E2975FAF01F12474',NULL,NULL,NULL), -(52095,10,2,0,NULL,NULL,'BA36382887D16D274EA9149695F0C9C8',NULL,NULL,NULL), -(52106,10,2,0,NULL,NULL,'95F43869B7D881212CBC1690B8F393ED',NULL,NULL,NULL), -(52129,10,2,0,NULL,NULL,'02DD842F2A7162EEB8FD5B9D325606F8',NULL,NULL,NULL), -(52148,10,2,0,NULL,NULL,'8A969717C8CDC6E7FF4C54D5CB00C224',NULL,NULL,NULL), -(52188,10,2,0,NULL,NULL,'977DF9993E94855DED5E328BA7A2F21F',NULL,NULL,NULL), -(52301,10,2,0,NULL,NULL,'821AA3BB237B400B82F44970250539AA',NULL,NULL,NULL), -(52393,10,2,0,NULL,NULL,'B013ED23B7EF51B29A45594D9BBB0D03',NULL,NULL,NULL), -(52485,10,2,0,NULL,NULL,'5805CEB4650730AE489258DD30E34441',NULL,NULL,NULL), -(52545,10,2,0,NULL,NULL,'FB52179A8355A46EDBFBDC8E8E5CDAFD',NULL,NULL,NULL), -(52607,10,2,0,NULL,NULL,'8F002E4AADCAEABB08ABC2880B31AD60',NULL,NULL,NULL), -(52649,10,2,0,NULL,NULL,'D0B779FBECEBC1ED5A85D83F03C8A75B',NULL,NULL,NULL), -(52808,10,2,0,NULL,NULL,'6276712B6C8AEA21CD5D94D52FEE70EE',NULL,NULL,NULL), -(52902,10,2,5,NULL,NULL,'D4F0A24CDF165628538C1C387A326AF3',NULL,NULL,NULL), -(52968,10,2,5,NULL,NULL,'2D247FD440C44D4F1BF80B075B8720F2',NULL,NULL,NULL), -(52983,10,2,5,NULL,NULL,'B1E5ADA5FDD06C9AB5E5D8A6983324AC',NULL,NULL,NULL), -(53007,10,2,5,NULL,NULL,'A21AFB4D381C56AF471D994258C0EEF5',NULL,NULL,NULL), -(53040,10,2,5,NULL,NULL,'2F1283BF7B7F307B70DBBD75CC42D7C3',NULL,NULL,NULL), -(53104,10,2,5,NULL,NULL,'DBD79EC8DF044B53C78931B985CAB406',NULL,NULL,NULL), -(53162,10,2,5,NULL,NULL,'8A67511FBF8984EEE2B630F7CB23376A',NULL,NULL,NULL), -(53212,10,2,5,NULL,NULL,'08761EFF2F9B639364B9A9FBFFFFB949',NULL,NULL,NULL), -(53262,10,2,5,NULL,NULL,'614A72D53126348A4927EC0F53FD2B7A',NULL,NULL,NULL), -(53441,10,2,5,NULL,NULL,'BFDD7D0FE87D5F75E6DEB4F5C99D7C99',NULL,NULL,NULL), -(53584,10,2,5,NULL,NULL,'CDD7A93659A03460B5A6CE1C4ACE5554',NULL,NULL,NULL), -(53840,10,2,6,NULL,NULL,'AC97D745C60DD3DC5F973E55C0E3649E',NULL,NULL,NULL), -(53877,10,2,6,NULL,NULL,'16320F95B63846A2276E1D2612C34AD4',NULL,NULL,NULL), -(53913,10,2,6,NULL,NULL,'475680680B2192EBCF6744D14F755199',NULL,NULL,NULL), -(53989,10,2,6,NULL,NULL,'3AEB90ACB9E18B88BA1021F52D51B857',NULL,NULL,NULL), -(54070,10,2,6,NULL,NULL,'FDA08264B7587250CF78F9B960218169',NULL,NULL,NULL), -(54205,10,2,6,NULL,NULL,'589D59EB3F0D6D77C2175D9302F78FDD',NULL,NULL,NULL), -(54358,10,2,6,NULL,NULL,'89C733D366E845FB9264404CD48CCA89',NULL,NULL,NULL), -(54499,10,2,6,NULL,NULL,'6AC1F6180FC4C390F782DB933BD83326',NULL,NULL,NULL), -(54577,10,2,7,NULL,NULL,'CBBBBBFFB2C652F0F4A7848D86E1B063',NULL,NULL,NULL), -(54601,10,2,7,NULL,NULL,'F8B866CF7DB9A12273F35B3929627375',NULL,NULL,NULL), -(54604,10,2,7,NULL,NULL,'A5FF4CE535F69D4D7F638CB2C11F2243',NULL,NULL,NULL), -(54630,10,2,7,NULL,NULL,'F37935510BA6B559363C160E1DF18230',NULL,NULL,NULL), -(54673,10,2,7,NULL,NULL,'AF8B9C8A9C6128498E85228B965A004D',NULL,NULL,NULL), -(54717,10,2,7,NULL,NULL,'862BBA15158DFF6B56BCF71C1B34D41A',NULL,NULL,NULL), -(54736,10,2,7,NULL,NULL,'FE58F039D91E1C248886A2828127CA2F',NULL,NULL,NULL), -(54762,10,2,7,NULL,NULL,'5F7FDA560030255445B713456A286CFA',NULL,NULL,NULL), -(54847,10,2,7,NULL,NULL,'32FDA0353160EC51EB36195CFACEF2B7',NULL,NULL,NULL), -(54904,10,2,7,NULL,NULL,'09CBEC3C0DEA28BCA79F1FD9B879B0E3',NULL,NULL,NULL), -(54988,10,2,7,NULL,NULL,'8F2791553226871977B4F9D7F1137311',NULL,NULL,NULL), -(55142,10,2,7,NULL,NULL,'298B99B5AD67EA3D2AB4B3E07A415305',NULL,NULL,NULL), -(55165,10,2,7,NULL,NULL,'26D4D1C01434A8A6723DCABC944B6FD0',NULL,NULL,NULL), -(55261,10,2,7,NULL,NULL,'84E153A3DD1F8249274B91047AAC7AED',NULL,NULL,NULL), -(55461,10,2,7,NULL,NULL,'C4522674F854EFECC76C898EC9545099',NULL,NULL,NULL), -(55664,10,2,7,NULL,NULL,'DBCA58486FAAA0FE54EA287A3047E923',NULL,NULL,NULL), -(55666,11,0,0,NULL,NULL,'F7E5A88E4D3615B652C8B9D76E7F617C',NULL,NULL,NULL), -(55792,11,0,0,NULL,NULL,'C4DECDAA44BC548FF09EF3BB837D2147',NULL,NULL,NULL), -(55793,11,0,0,NULL,NULL,'F9CF3232AD1C38C2028668D5BB64198F',NULL,NULL,NULL), -(55818,11,0,0,NULL,NULL,'903A9B546248F71B16D9D9B06A072C24',NULL,NULL,NULL), -(55824,11,0,0,NULL,NULL,'8A6F13269A2896067A1E88789FB41BA7',NULL,NULL,NULL), -(55846,11,0,0,NULL,NULL,'BB5E1BED705872C226834B95A9E9F8A9',NULL,NULL,NULL), -(55933,11,0,0,NULL,NULL,'C34D42CB351C400D1319D221197CF18D',NULL,NULL,NULL), -(55939,11,0,0,NULL,NULL,'91529F4CE41DE4E54E132660ACDCADC5',NULL,NULL,NULL), -(55960,11,0,0,NULL,NULL,'078C056CFC7B371BDE1BAF308E6C19AF',NULL,NULL,NULL), -(56008,11,0,0,NULL,NULL,'00FCD6BFFCCCBA7A8E71E307EA6EBD0C',NULL,NULL,NULL), -(55959,11,0,2,NULL,NULL,'ED57E0538FD1CE99B171BE34823148A9',NULL,NULL,NULL), -(56110,11,0,2,NULL,NULL,'800BCA228E2FAE37ED160F3C09E21F3A',NULL,NULL,NULL), -(56162,11,0,2,NULL,NULL,'6F5C93BA436665A94DB67CE5361D4EA8',NULL,NULL,NULL), -(56196,11,0,2,NULL,NULL,'81FC14274BFF0347FFF9C8B1AA6BED9B',NULL,NULL,NULL), -(56263,11,0,2,NULL,NULL,'EA8472C99236CC617BF518A924014D56',NULL,NULL,NULL), -(56288,11,0,2,NULL,NULL,'03544E35D0480938E5C1238B3A26BDDD',NULL,NULL,NULL), -(56311,11,0,2,NULL,NULL,'AC6415575AEE4D32735FFAD0C57226B2',NULL,NULL,NULL), -(56313,11,0,2,NULL,NULL,'EAF769009A9AD3B1AA0414E1C344074B',NULL,NULL,NULL); +(5875,1,12,1,NULL,NULL,NULL,NULL,NULL,'95EDB27C7823B363CBDDAB56A392E7CB73FCCA20','8D173CC381961EEBABF336F5E6675B101BB513E5'), +(6005,1,12,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(6141,1,12,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(8606,2,4,3,NULL,NULL,NULL,NULL,NULL,'319AFAA3F2559682F9FF658BE01456255F456FB1','D8B0ECFE534BC1131E19BAD1D4C0E813EEE4994F'), +(9947,3,1,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(10505,3,2,2,'a',NULL,NULL,NULL,NULL,NULL,NULL), +(11159,3,3,0,'a',NULL,NULL,NULL,NULL,NULL,NULL), +(11403,3,3,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(11723,3,3,3,'a',NULL,NULL,NULL,NULL,NULL,NULL), +(12340,3,3,5,'a',NULL,NULL,NULL,NULL,'CDCBBD5188315E6B4D19449D492DBCFAF156A347','B706D13FF2F4018839729461E3F8A0E2B5FDC034'), +(13623,4,0,6,'a',NULL,NULL,NULL,NULL,NULL,NULL), +(13930,3,3,5,'a',NULL,NULL,NULL,NULL,NULL,NULL), +(14545,4,2,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(15595,4,3,4,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(19116,6,0,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(19243,6,0,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(19342,6,0,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(19702,6,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(19802,6,1,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(19831,6,1,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(19865,6,1,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(20182,6,2,0,'a',NULL,NULL,NULL,NULL,NULL,NULL), +(20201,6,2,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(20216,6,2,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(20253,6,2,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(20338,6,2,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(20444,6,2,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(20490,6,2,2,'a',NULL,NULL,NULL,NULL,NULL,NULL), +(20574,6,2,2,'a',NULL,NULL,NULL,NULL,NULL,NULL), +(20726,6,2,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(20779,6,2,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(20886,6,2,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(21355,6,2,4,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(21463,6,2,4,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(21742,6,2,4,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(22248,7,0,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(22293,7,0,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(22345,7,0,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(22410,7,0,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(22423,7,0,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(22498,7,0,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(22522,7,0,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(22566,7,0,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(22594,7,0,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(22624,7,0,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(22747,7,0,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(22810,7,0,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(22900,7,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(22908,7,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(22950,7,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(22995,7,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(22996,7,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(23171,7,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(23222,7,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(23360,7,1,5,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(23420,7,1,5,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(23911,7,2,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(23937,7,2,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(24015,7,2,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(24330,7,2,5,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(24367,7,2,5,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(24415,7,2,5,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(24430,7,2,5,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(24461,7,2,5,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(24742,7,2,5,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(25549,7,3,2,NULL,'FE594FC35E7F9AFF86D99D8A364AB297','1252624ED8CBD6FAC7D33F5D67A535F3','66FC5E09B8706126795F140308C8C1D8',NULL,NULL,NULL), +(25996,7,3,5,NULL,'23C59C5963CBEF5B728D13A50878DFCB','C7FF932D6A2174A3D538CA7212136D2B','210B970149D6F56CAC9BADF2AAC91E8E',NULL,NULL,NULL), +(26124,7,3,5,NULL,'F8C05AE372DECA1D6C81DA7A8D1C5C39','46DF06D0147BA67BA49AF553435E093F','C9CA997AB8EDE1C65465CB2920869C4E',NULL,NULL,NULL), +(26365,7,3,5,NULL,'2AAC82C80E829E2CA902D70CFA1A833A','59A53F307288454B419B13E694DF503C','DBE7F860276D6B400AAA86B35D51A417',NULL,NULL,NULL), +(26654,7,3,5,NULL,'FAC2D693E702B9EC9F750F17245696D8','A752640E8B99FE5B57C1320BC492895A','9234C1BD5E9687ADBD19F764F2E0E811',NULL,NULL,NULL), +(26822,7,3,5,NULL,'283E8D77ECF7060BE6347BE4EB99C7C7','2B05F6D746C0C6CC7EF79450B309E595','91003668C245D14ECD8DF094E065E06B',NULL,NULL,NULL), +(26899,7,3,5,NULL,'F462CD2FE4EA3EADF875308FDBB18C99','3551EF0028B51E92170559BD25644B03','8368EFC2021329110A16339D298200D4',NULL,NULL,NULL), +(26972,7,3,5,NULL,'797ECC19662DCBD5090A4481173F1D26','6E212DEF6A0124A3D9AD07F5E322F7AE','341CFEFE3D72ACA9A4407DC535DED66A',NULL,NULL,NULL), +(28153,8,0,1,NULL,NULL,'DD626517CC6D31932B479934CCDC0ABF',NULL,NULL,NULL,NULL), +(30706,8,1,5,NULL,NULL,'BB6D9866FE4A19A568015198783003FC',NULL,NULL,NULL,NULL), +(30993,8,2,0,NULL,NULL,'2BAD61655ABC2FC3D04893B536403A91',NULL,NULL,NULL,NULL), +(31229,8,2,0,NULL,NULL,'8A46F23670309F2AAE85C9A47276382B',NULL,NULL,NULL,NULL), +(31429,8,2,0,NULL,NULL,'7795A507AF9DC3525EFF724FEE17E70C',NULL,NULL,NULL,NULL), +(31478,8,2,0,NULL,NULL,'7973A8D54BDB8B798D9297B096E771EF',NULL,NULL,NULL,NULL), +(32305,8,2,5,NULL,NULL,'21F5A6FC7AD89FBF411FDA8B8738186A',NULL,NULL,NULL,NULL), +(32494,8,2,5,NULL,NULL,'58984ACE04919401835C61309A848F8A',NULL,NULL,NULL,NULL), +(32580,8,2,5,NULL,NULL,'87C2FAA0D7931BF016299025C0DDCA14',NULL,NULL,NULL,NULL), +(32638,8,2,5,NULL,NULL,'5D07ECE7D4A867DDDE615DAD22B76D4E',NULL,NULL,NULL,NULL), +(32722,8,2,5,NULL,NULL,'1A09BE1D38A122586B4931BECCEAD4AA',NULL,NULL,NULL,NULL), +(32750,8,2,5,NULL,NULL,'C5CB669F5A5B237D1355430877173207','EF1F4E4D099EA2A81FD4C0DEBC1E7086',NULL,NULL,NULL), +(32978,8,2,5,NULL,NULL,'76AE2EA03E525D97F5688843F5489000','1852C1F847E795D6EB45278CD433F339',NULL,NULL,NULL), +(33369,8,3,0,NULL,NULL,'5986AC18B04D3C403F56A0CF8C4F0A14','F5A849C70A1054F07EA3AB833EBF6671',NULL,NULL,NULL), +(33528,8,3,0,NULL,NULL,'0ECE033CA9B11D92F7D2792C785B47DF',NULL,NULL,NULL,NULL), +(33724,8,3,0,NULL,NULL,'38F7BBCF284939DD20E8C64CDBF9FE77',NULL,NULL,NULL,NULL), +(33775,8,3,0,NULL,NULL,'B826300A8449ED0F6EF16EA747FA2D2E','354D2DE619D124EE1398F76B0436FCFC',NULL,NULL,NULL), +(33941,8,3,0,NULL,NULL,'88AF1A36D2770D0A6CA086497096A889',NULL,NULL,NULL,NULL), +(34220,8,3,0,NULL,NULL,'B5E35B976C6BAF82505700E7D9666A2C',NULL,NULL,NULL,NULL), +(34601,8,3,0,NULL,NULL,'0D7DF38F725FABA4F009257799A10563',NULL,NULL,NULL,NULL), +(34769,8,3,0,NULL,NULL,'93F9B9AF6397E3E4EED94D36D16907D2',NULL,NULL,NULL,NULL), +(34963,8,3,0,NULL,NULL,'7BA50C879C5D04221423B02AC3603A11','C5658A17E702163447BAAAE46D130A1B',NULL,NULL,NULL), +(35249,8,3,7,NULL,NULL,'C7B11F9AE9FF1409F5582902B3D10D1C',NULL,NULL,NULL,NULL), +(35284,8,3,7,NULL,NULL,'EA3818E7DCFD2009DBFC83EE3C1E4F1B','A6201B0AC5A73D13AB2FDCC79BB252AF',NULL,NULL,NULL), +(35435,8,3,7,NULL,NULL,'BB397A92FE23740EA52FC2B5BA2EC8E0','8FE657C14A46BCDB2CE6DA37E430450E',NULL,NULL,NULL), +(35662,8,3,7,NULL,NULL,'578BC94870C278CB6962F30E6DC203BB','5966016C368ED9F7AAB603EE6703081C',NULL,NULL,NULL), +(36753,9,0,2,NULL,NULL,'386FDE8559B5EAD67B791B490B200B88',NULL,NULL,NULL,NULL), +(36839,9,0,2,NULL,NULL,'356EB4412B8EFCF72E3AF50D5181D529',NULL,NULL,NULL,NULL), +(36949,9,0,2,NULL,NULL,'51C074CD8A09A75384B9B44188C56981',NULL,NULL,NULL,NULL), +(37142,9,0,2,NULL,NULL,'5D9CFB3139F0D1B6C2B304261F9EABC9',NULL,NULL,NULL,NULL), +(37176,9,0,2,NULL,NULL,'3C725EA504EC3DAED143EB6FF3B48CDA',NULL,NULL,NULL,NULL), +(37474,9,0,2,NULL,NULL,'0DE685BBB0551086E7FBDC0B4BB06A5B','024C9BE7E44237B7E81C6D42E678D433',NULL,NULL,NULL), +(38134,9,0,5,NULL,NULL,'32275ED0F13B357C28BDB0E611EF9E31',NULL,NULL,NULL,NULL), +(38556,9,0,5,NULL,NULL,'EC7D5AF64364AC3E7181F3FBA1B3A882',NULL,NULL,NULL,NULL), +(39653,9,1,0,NULL,NULL,'10D015AB1EEB91310428D9C57EE24632',NULL,NULL,NULL,NULL), +(39804,9,1,0,NULL,NULL,'E42D2BBA12ED260A76F9B1E477E19EA5',NULL,NULL,NULL,NULL), +(40000,9,1,0,NULL,NULL,'4CB1433AB637F09F03FBBD1B221B04B0',NULL,NULL,NULL,NULL), +(40120,9,1,0,NULL,NULL,'04F47EAEFD8BDEFE14AA0350EA336678','853F0F2985CEAED46DF422583CD07A7C',NULL,NULL,NULL), +(40443,9,1,0,NULL,NULL,'8597BB43E8AB38C85504E8BFB72ABBF5',NULL,NULL,NULL,NULL), +(40593,9,1,0,NULL,NULL,'BA14570F2D62D5F61953394164A8DAE2',NULL,NULL,NULL,NULL), +(40725,9,1,0,NULL,NULL,'C1EBDBEB9BB2956EBCCEF7C9D27A1B3B',NULL,NULL,NULL,NULL), +(40906,9,1,5,NULL,NULL,'F5FC259C8635488AFE0D0CD023F361D4',NULL,NULL,NULL,NULL), +(40944,9,1,5,NULL,NULL,'368FC7FABAF487A8A049C11970657074',NULL,NULL,NULL,NULL), +(40966,9,1,5,NULL,NULL,'D90F47AF21F381D2D8F3763B994BAC88',NULL,NULL,NULL,NULL), +(41031,9,1,5,NULL,NULL,'019A0FACD6B0D6374B7BA69A5B677449',NULL,NULL,NULL,NULL), +(41079,9,1,5,NULL,NULL,'F8853CF823BC0BBE8A9677A762DFAEE1',NULL,NULL,NULL,NULL), +(41288,9,1,5,NULL,NULL,'871C0C9691DBC536EB24B68EC73FAD5B',NULL,NULL,NULL,NULL), +(41323,9,1,5,NULL,NULL,'E53D0DF1FAC1A59A1C8071B295A04A1D',NULL,NULL,NULL,NULL), +(41359,9,1,5,NULL,NULL,'5F8D7F2A690A4375A1B52A28D6D681FA',NULL,NULL,NULL,NULL), +(41488,9,1,5,NULL,NULL,'1BC91EC368705815F3F532B553DAD981',NULL,NULL,NULL,NULL), +(41793,9,1,5,NULL,NULL,'B3B47DA3B7615570742A55B96614EE1C',NULL,NULL,NULL,NULL), +(42010,9,1,5,NULL,NULL,'302970161D16417B5BE553CC530E011A',NULL,NULL,NULL,NULL), +(42423,9,2,0,NULL,NULL,'0B03614A7E94DD57548596BE420E9DC2',NULL,NULL,NULL,NULL), +(42488,9,2,0,NULL,NULL,'A78755E6928D83A271C5D1EE3CDB6F15',NULL,NULL,NULL,NULL), +(42521,9,2,0,NULL,NULL,'5FE6C12FC407C6B15B4A5D3B5B4A5D3B',NULL,NULL,NULL,NULL), +(42538,9,2,0,NULL,NULL,'71A7504BD53F8DE518F24265D37310AE',NULL,NULL,NULL,NULL), +(42560,9,2,0,NULL,NULL,'115FE8C38A8D67CA4664BB192E0F0DFE',NULL,NULL,NULL,NULL), +(42614,9,2,0,NULL,NULL,'772BE726FEEF42124255D2EA7973CA18',NULL,NULL,NULL,NULL), +(42698,9,2,0,NULL,NULL,'B4497B1CD11FC974C5FB09548AC27269',NULL,NULL,NULL,NULL), +(42825,9,2,0,NULL,NULL,'A14DA228C6A6AFF1DDBA51218939E557',NULL,NULL,NULL,NULL), +(42852,9,2,0,NULL,NULL,'DE9F9F0C3CC8FD54D3AFF99CEFFCE129',NULL,NULL,NULL,NULL), +(42937,9,2,0,NULL,NULL,'F5FC75E70874752C92846B3333920E63',NULL,NULL,NULL,NULL), +(42979,9,2,0,NULL,NULL,'E1DD38AE6450FC4D2AE4609233C59E54',NULL,NULL,NULL,NULL), +(43114,9,2,0,NULL,NULL,'F75C9380CCB24A48A24EEE52C1594A7E',NULL,NULL,NULL,NULL), +(43206,9,2,0,NULL,NULL,'DDE806532C7704FFB75F256DC5F1F3D9',NULL,NULL,NULL,NULL), +(43340,9,2,0,NULL,NULL,'70E46D2D888E84DF9316EA849B068CF4',NULL,NULL,NULL,NULL), +(43345,9,2,0,NULL,NULL,'D911ABFCDA030DEE8CAF4EE3F60DEE13',NULL,NULL,NULL,NULL), +(43971,9,2,5,NULL,NULL,'681CF99E61FB0005A5C7D31D0AAD1ED9',NULL,NULL,NULL,NULL), +(44015,9,2,5,NULL,NULL,'FCF0BDA7C98BFEF92AE6D8C39A217ABD',NULL,NULL,NULL,NULL), +(44061,9,2,5,NULL,NULL,'FD2B5C0B3293FE0E9CAA6EB0B7788119',NULL,NULL,NULL,NULL), +(44127,9,2,5,NULL,NULL,'787887CEC9FCC9B516481F60E4FC34A8',NULL,NULL,NULL,NULL), +(44232,9,2,5,NULL,NULL,'81F0A71DF7E9873BB3750022D64D33CF',NULL,NULL,NULL,NULL), +(44325,9,2,5,NULL,NULL,'138A7D524D268A7F9934C3D148E8F01B',NULL,NULL,NULL,NULL), +(44730,9,2,5,NULL,NULL,'FC0B18C47BB4C79F4300CA0FF3E5CAC7',NULL,NULL,NULL,NULL), +(44908,9,2,5,NULL,NULL,'BFFAEC40C9BCD591C7C959A9D5A8BA8C',NULL,NULL,NULL,NULL), +(45114,9,2,7,NULL,NULL,'D7AFE240BD00F06C30D0C2D16E54A8BE',NULL,NULL,NULL,NULL), +(45161,9,2,7,NULL,NULL,'74BD2E787A98B145B063BDA9A98F6CBD',NULL,NULL,NULL,NULL), +(45338,9,2,7,NULL,NULL,'5CE2094A41B61EDA9DF56378BC3B1DE0',NULL,NULL,NULL,NULL), +(45745,9,2,7,NULL,NULL,'0F6DC90161694D765A595A3AF603166B',NULL,NULL,NULL,NULL), +(46479,10,0,2,NULL,NULL,'CB9AF4D89B60A3ABA288D395D315D932',NULL,NULL,NULL,NULL), +(46658,10,0,2,NULL,NULL,'3F8EFB085428D75360E9EFE25CD8639A',NULL,NULL,NULL,NULL), +(46689,10,0,2,NULL,NULL,'D9A11D188D6AD60906F5467510EFD3AA',NULL,NULL,NULL,NULL), +(46702,10,0,2,NULL,NULL,'01B4D1688FF97DC9AAFCCD0A0B842C0B',NULL,NULL,NULL,NULL), +(46741,10,0,2,NULL,NULL,'4C0F4A7EC2098AF1FBA745848EC79A78',NULL,NULL,NULL,NULL), +(46801,10,0,2,NULL,NULL,'E6AC18D1EA5D36ABFFAE5EDED80630DF',NULL,NULL,NULL,NULL), +(46879,10,0,2,NULL,NULL,'EFEC43936051DD1A210633AF1F6B63DB',NULL,NULL,NULL,NULL), +(46924,10,0,2,NULL,NULL,'E6CE0B1A8119F069ECF1E7DBAA7BB2F8',NULL,NULL,NULL,NULL), +(47067,10,0,2,NULL,NULL,'63862CFCDEA6BD2BD7F740EB36B65657',NULL,NULL,NULL,NULL), +(47187,10,0,2,NULL,NULL,'711F8455C5000C237292E1E6E90631E1',NULL,NULL,NULL,NULL), +(47213,10,0,2,NULL,NULL,'23C50D88CEAC0A8696ADDE8DD244D4A2',NULL,NULL,NULL,NULL), +(47631,10,0,2,NULL,NULL,'F986AB91D0AEB20822EFB72F4256713C',NULL,NULL,NULL,NULL), +(47777,10,0,5,NULL,NULL,'A88C04915AB9E035A104E55C4DCF5F9F',NULL,NULL,NULL,NULL), +(47799,10,0,5,NULL,NULL,'7364EB093C23DB2CDC9513D5A7B4933E',NULL,NULL,NULL,NULL), +(47825,10,0,5,NULL,NULL,'82A3B94E5E727AF3A208B471FF2054C0',NULL,NULL,NULL,NULL), +(47849,10,0,5,NULL,NULL,'DD8BBE2087A28C0AF4984CBE23A1C707',NULL,NULL,NULL,NULL), +(47871,10,0,5,NULL,NULL,'8E4F7D30EE4982B02B3B3F8837C2C4F2',NULL,NULL,NULL,NULL), +(47884,10,0,5,NULL,NULL,'2B7A002BC359F2C31104BC2DE04302BF',NULL,NULL,NULL,NULL), +(47936,10,0,5,NULL,NULL,'833D30D8FBC43B3FAE99CD3898D70849',NULL,NULL,NULL,NULL), +(47967,10,0,5,NULL,NULL,'CFE225D0089E224D9E7541D3B5C26478',NULL,NULL,NULL,NULL), +(48001,10,0,5,NULL,NULL,'4B0260A37BD95B615E71048469E6D5BB',NULL,NULL,NULL,NULL), +(48069,10,0,5,NULL,NULL,'558CDF958FA082E95849779C7C6945E5',NULL,NULL,NULL,NULL), +(48317,10,0,5,NULL,NULL,'C096E37B45B43244E9C79916604DD4AF',NULL,NULL,NULL,NULL), +(48397,10,0,5,NULL,NULL,'64BA8779EAA97E6C57982B6B1A5B32E7',NULL,NULL,NULL,NULL), +(48526,10,0,5,NULL,NULL,'D5B7D3303A2A741E6913EE1AEB0BCB65',NULL,NULL,NULL,NULL), +(48676,10,0,7,NULL,NULL,'E059FB74DFF6438CC20C7F28900F64CA',NULL,NULL,NULL,NULL), +(48749,10,0,7,NULL,NULL,'92DBCCA0E33DFB8A17A2B6A39246B288',NULL,NULL,NULL,NULL), +(48838,10,0,7,NULL,NULL,'9E6F4E1E46EF228D2DE90F7BC48AAA96',NULL,NULL,NULL,NULL), +(48865,10,0,7,NULL,NULL,'4B774ABE7B34D6702571B4279A4B6A13',NULL,NULL,NULL,NULL), +(48892,10,0,7,NULL,NULL,'AA31BF27458321B03A1A346964DD7B9D',NULL,NULL,NULL,NULL), +(48966,10,0,7,NULL,NULL,'823142CA131FBB715FF55D4343E55C6D',NULL,NULL,NULL,NULL), +(48999,10,0,7,NULL,NULL,'79BA6FF0F9672EEF875F64155C8B62D4',NULL,NULL,NULL,NULL), +(49267,10,0,7,NULL,NULL,'EEE77EA5A216E0731ADBB41AEFB1DF31',NULL,NULL,NULL,NULL), +(49318,10,1,0,NULL,NULL,'AF439AEE62EE48B36C1725111E3D9BBF',NULL,NULL,NULL,NULL), +(49343,10,0,7,NULL,NULL,'301A0B4C0942B9B6F605B903AD6C1F60',NULL,NULL,NULL,NULL), +(49407,10,1,0,NULL,NULL,'6413820DC9885BB0693B37090CBB2F30',NULL,NULL,NULL,NULL), +(49426,10,1,0,NULL,NULL,'D85EDFBFE9A94A55E2B4510BE41C19B2',NULL,NULL,NULL,NULL), +(49444,10,1,0,NULL,NULL,'363B2B05285BDD8857419D2866316D3C',NULL,NULL,NULL,NULL), +(49474,10,1,0,NULL,NULL,'44A7D2B352EE3D098A3CB4C2F1065E37',NULL,NULL,NULL,NULL), +(49570,10,1,0,NULL,NULL,'B024DE67ACAEB9E8EE6DB38DC53E8281',NULL,NULL,NULL,NULL), +(49679,10,1,0,NULL,NULL,'9CE59B68D8797EBF00581F41138F4316',NULL,NULL,NULL,NULL), +(49741,10,1,0,NULL,NULL,'0EF181E2BB0E946CF3B7422ADEB6CD1A',NULL,NULL,NULL,NULL), +(49801,10,1,0,NULL,NULL,'0832179567B66CA85DBD5678B604C683',NULL,NULL,NULL,NULL), +(49890,10,1,0,NULL,NULL,'22A5B8A1EB797A64995F705B3DBCB14C',NULL,NULL,NULL,NULL), +(50000,10,1,0,NULL,NULL,'02F06FFA2296FD66384295DBFD5A4C91',NULL,NULL,NULL,NULL), +(50401,10,1,5,NULL,NULL,'3EEF52D902CCE81D16D0E255F0AA4938',NULL,NULL,NULL,NULL), +(50438,10,1,5,NULL,NULL,'0B5F68F06B129CB4C57702F6D30F260B',NULL,NULL,NULL,NULL), +(50467,10,1,5,NULL,NULL,'5E996B1CDCEE68432D6340138E68D1EB',NULL,NULL,NULL,NULL), +(50469,10,1,5,NULL,NULL,'1768CCB6589E16AB3BEFA9D608A393A2',NULL,NULL,NULL,NULL), +(50504,10,1,5,NULL,NULL,'7D5FD20C0B32C9AF5DD65433B391D49C',NULL,NULL,NULL,NULL), +(50585,10,1,5,NULL,NULL,'C4F7CC38A3B84935A485F7EDAD3E764B',NULL,NULL,NULL,NULL), +(50622,10,1,5,NULL,NULL,'D23A26FD75FD9A6073EB7060AA28E6A7',NULL,NULL,NULL,NULL), +(50747,10,1,5,NULL,NULL,'2D3C386A9C45C27304ED3A3C6EB3F7C8',NULL,NULL,NULL,NULL), +(50791,10,1,5,NULL,NULL,'0BE7D0BB07EF37C25CBC682409091EA0',NULL,NULL,NULL,NULL), +(51130,10,1,5,NULL,NULL,'44CD2C91E4F0655DA387483726CE4035',NULL,NULL,NULL,NULL), +(51187,10,1,7,NULL,NULL,'74E2055D3965269447B5CB1B31FC71C6',NULL,NULL,NULL,NULL), +(51237,10,1,7,NULL,NULL,'C8660A21B766646FBD67F481CFCF55C3',NULL,NULL,NULL,NULL), +(51261,10,1,7,NULL,NULL,'1BEBB57AE450331E9F8C301AA7876FAB',NULL,NULL,NULL,NULL), +(51313,10,1,7,NULL,NULL,'35419ED0AB16735CF720858F45DC300C',NULL,NULL,NULL,NULL), +(51421,10,1,7,NULL,NULL,'45E24D6F3335269787DF2B2063939002',NULL,NULL,NULL,NULL), +(51485,10,1,7,NULL,NULL,'EC549E1D0A5DD85C03E7A9D93B7DC6D1',NULL,NULL,NULL,NULL), +(51536,10,1,7,NULL,NULL,'570EEA10A8EC169C3FF9621D1B635BB4',NULL,NULL,NULL,NULL), +(51754,10,1,7,NULL,NULL,'BED5A861C071AB41FEF6087E0C37BB1A',NULL,NULL,NULL,NULL), +(51886,10,1,7,NULL,NULL,'09CF8919FD2EABDEAEBC0C810F53B511',NULL,NULL,NULL,NULL), +(51972,10,1,7,NULL,NULL,'444DC7EF3544B6670C18884DADA00428',NULL,NULL,NULL,NULL), +(52038,10,2,0,NULL,NULL,'A8EF004ADED8A3AFF5A67D2BB8D95795',NULL,NULL,NULL,NULL), +(52068,10,2,0,NULL,NULL,'A44F842BACCC7EE8E2975FAF01F12474',NULL,NULL,NULL,NULL), +(52095,10,2,0,NULL,NULL,'BA36382887D16D274EA9149695F0C9C8',NULL,NULL,NULL,NULL), +(52106,10,2,0,NULL,NULL,'95F43869B7D881212CBC1690B8F393ED',NULL,NULL,NULL,NULL), +(52129,10,2,0,NULL,NULL,'02DD842F2A7162EEB8FD5B9D325606F8',NULL,NULL,NULL,NULL), +(52148,10,2,0,NULL,NULL,'8A969717C8CDC6E7FF4C54D5CB00C224',NULL,NULL,NULL,NULL), +(52188,10,2,0,NULL,NULL,'977DF9993E94855DED5E328BA7A2F21F',NULL,NULL,NULL,NULL), +(52301,10,2,0,NULL,NULL,'821AA3BB237B400B82F44970250539AA',NULL,NULL,NULL,NULL), +(52393,10,2,0,NULL,NULL,'B013ED23B7EF51B29A45594D9BBB0D03',NULL,NULL,NULL,NULL), +(52485,10,2,0,NULL,NULL,'5805CEB4650730AE489258DD30E34441',NULL,NULL,NULL,NULL), +(52545,10,2,0,NULL,NULL,'FB52179A8355A46EDBFBDC8E8E5CDAFD',NULL,NULL,NULL,NULL), +(52607,10,2,0,NULL,NULL,'8F002E4AADCAEABB08ABC2880B31AD60',NULL,NULL,NULL,NULL), +(52649,10,2,0,NULL,NULL,'D0B779FBECEBC1ED5A85D83F03C8A75B',NULL,NULL,NULL,NULL), +(52808,10,2,0,NULL,NULL,'6276712B6C8AEA21CD5D94D52FEE70EE',NULL,NULL,NULL,NULL), +(52902,10,2,5,NULL,NULL,'D4F0A24CDF165628538C1C387A326AF3',NULL,NULL,NULL,NULL), +(52968,10,2,5,NULL,NULL,'2D247FD440C44D4F1BF80B075B8720F2',NULL,NULL,NULL,NULL), +(52983,10,2,5,NULL,NULL,'B1E5ADA5FDD06C9AB5E5D8A6983324AC',NULL,NULL,NULL,NULL), +(53007,10,2,5,NULL,NULL,'A21AFB4D381C56AF471D994258C0EEF5',NULL,NULL,NULL,NULL), +(53040,10,2,5,NULL,NULL,'2F1283BF7B7F307B70DBBD75CC42D7C3',NULL,NULL,NULL,NULL), +(53104,10,2,5,NULL,NULL,'DBD79EC8DF044B53C78931B985CAB406',NULL,NULL,NULL,NULL), +(53162,10,2,5,NULL,NULL,'8A67511FBF8984EEE2B630F7CB23376A',NULL,NULL,NULL,NULL), +(53212,10,2,5,NULL,NULL,'08761EFF2F9B639364B9A9FBFFFFB949',NULL,NULL,NULL,NULL), +(53262,10,2,5,NULL,NULL,'614A72D53126348A4927EC0F53FD2B7A',NULL,NULL,NULL,NULL), +(53441,10,2,5,NULL,NULL,'BFDD7D0FE87D5F75E6DEB4F5C99D7C99',NULL,NULL,NULL,NULL), +(53584,10,2,5,NULL,NULL,'CDD7A93659A03460B5A6CE1C4ACE5554',NULL,NULL,NULL,NULL), +(53840,10,2,6,NULL,NULL,'AC97D745C60DD3DC5F973E55C0E3649E',NULL,NULL,NULL,NULL), +(53877,10,2,6,NULL,NULL,'16320F95B63846A2276E1D2612C34AD4',NULL,NULL,NULL,NULL), +(53913,10,2,6,NULL,NULL,'475680680B2192EBCF6744D14F755199',NULL,NULL,NULL,NULL), +(53989,10,2,6,NULL,NULL,'3AEB90ACB9E18B88BA1021F52D51B857',NULL,NULL,NULL,NULL), +(54070,10,2,6,NULL,NULL,'FDA08264B7587250CF78F9B960218169',NULL,NULL,NULL,NULL), +(54205,10,2,6,NULL,NULL,'589D59EB3F0D6D77C2175D9302F78FDD',NULL,NULL,NULL,NULL), +(54358,10,2,6,NULL,NULL,'89C733D366E845FB9264404CD48CCA89',NULL,NULL,NULL,NULL), +(54499,10,2,6,NULL,NULL,'6AC1F6180FC4C390F782DB933BD83326',NULL,NULL,NULL,NULL), +(54577,10,2,7,NULL,NULL,'CBBBBBFFB2C652F0F4A7848D86E1B063',NULL,NULL,NULL,NULL), +(54601,10,2,7,NULL,NULL,'F8B866CF7DB9A12273F35B3929627375',NULL,NULL,NULL,NULL), +(54604,10,2,7,NULL,NULL,'A5FF4CE535F69D4D7F638CB2C11F2243',NULL,NULL,NULL,NULL), +(54630,10,2,7,NULL,NULL,'F37935510BA6B559363C160E1DF18230',NULL,NULL,NULL,NULL), +(54673,10,2,7,NULL,NULL,'AF8B9C8A9C6128498E85228B965A004D',NULL,NULL,NULL,NULL), +(54717,10,2,7,NULL,NULL,'862BBA15158DFF6B56BCF71C1B34D41A',NULL,NULL,NULL,NULL), +(54736,10,2,7,NULL,NULL,'FE58F039D91E1C248886A2828127CA2F',NULL,NULL,NULL,NULL), +(54762,10,2,7,NULL,NULL,'5F7FDA560030255445B713456A286CFA',NULL,NULL,NULL,NULL), +(54847,10,2,7,NULL,NULL,'32FDA0353160EC51EB36195CFACEF2B7',NULL,NULL,NULL,NULL), +(54904,10,2,7,NULL,NULL,'09CBEC3C0DEA28BCA79F1FD9B879B0E3',NULL,NULL,NULL,NULL), +(54988,10,2,7,NULL,NULL,'8F2791553226871977B4F9D7F1137311',NULL,NULL,NULL,NULL), +(55142,10,2,7,NULL,NULL,'298B99B5AD67EA3D2AB4B3E07A415305',NULL,NULL,NULL,NULL), +(55165,10,2,7,NULL,NULL,'26D4D1C01434A8A6723DCABC944B6FD0',NULL,NULL,NULL,NULL), +(55261,10,2,7,NULL,NULL,'84E153A3DD1F8249274B91047AAC7AED',NULL,NULL,NULL,NULL), +(55461,10,2,7,NULL,NULL,'C4522674F854EFECC76C898EC9545099',NULL,NULL,NULL,NULL), +(55664,10,2,7,NULL,NULL,'DBCA58486FAAA0FE54EA287A3047E923',NULL,NULL,NULL,NULL), +(55666,11,0,0,NULL,NULL,'F7E5A88E4D3615B652C8B9D76E7F617C',NULL,NULL,NULL,NULL), +(55792,11,0,0,NULL,NULL,'C4DECDAA44BC548FF09EF3BB837D2147',NULL,NULL,NULL,NULL), +(55793,11,0,0,NULL,NULL,'F9CF3232AD1C38C2028668D5BB64198F',NULL,NULL,NULL,NULL), +(55818,11,0,0,NULL,NULL,'903A9B546248F71B16D9D9B06A072C24',NULL,NULL,NULL,NULL), +(55824,11,0,0,NULL,NULL,'8A6F13269A2896067A1E88789FB41BA7',NULL,NULL,NULL,NULL), +(55846,11,0,0,NULL,NULL,'BB5E1BED705872C226834B95A9E9F8A9',NULL,NULL,NULL,NULL), +(55933,11,0,0,NULL,NULL,'C34D42CB351C400D1319D221197CF18D',NULL,NULL,NULL,NULL), +(55939,11,0,0,NULL,NULL,'91529F4CE41DE4E54E132660ACDCADC5',NULL,NULL,NULL,NULL), +(55959,11,0,2,NULL,NULL,'ED57E0538FD1CE99B171BE34823148A9',NULL,NULL,NULL,NULL), +(55960,11,0,0,NULL,NULL,'078C056CFC7B371BDE1BAF308E6C19AF',NULL,NULL,NULL,NULL), +(56008,11,0,0,NULL,NULL,'00FCD6BFFCCCBA7A8E71E307EA6EBD0C',NULL,NULL,NULL,NULL), +(56110,11,0,2,NULL,NULL,'800BCA228E2FAE37ED160F3C09E21F3A',NULL,NULL,NULL,NULL), +(56162,11,0,2,NULL,NULL,'6F5C93BA436665A94DB67CE5361D4EA8',NULL,NULL,NULL,NULL), +(56196,11,0,2,NULL,NULL,'81FC14274BFF0347FFF9C8B1AA6BED9B',NULL,'778F6A5DF79A4EF1B86F651F3B303CE7',NULL,NULL), +(56263,11,0,2,NULL,NULL,'EA8472C99236CC617BF518A924014D56',NULL,NULL,NULL,NULL), +(56288,11,0,2,NULL,NULL,'03544E35D0480938E5C1238B3A26BDDD',NULL,'41710C793EF021721F14B06EC1896D3F',NULL,NULL), +(56311,11,0,2,NULL,NULL,'AC6415575AEE4D32735FFAD0C57226B2',NULL,'412D3200715AAFDC0522DF031A941F0E',NULL,NULL), +(56313,11,0,2,NULL,NULL,'EAF769009A9AD3B1AA0414E1C344074B',NULL,'A83ED19EE659BC95CC322D1E49BDEDBB',NULL,NULL); /*!40000 ALTER TABLE `build_info` ENABLE KEYS */; UNLOCK TABLES; @@ -2882,7 +2883,8 @@ INSERT INTO `updates` VALUES ('2024_08_23_00_auth.sql','A591DA576EAEA3F48AB9E8269A2E4071B2C3C930','RELEASED','2024-08-23 17:35:52',0), ('2024_08_23_01_auth.sql','1ABD54E76B2D6712BF3DE06DD60A18C38BCF9CF1','RELEASED','2024-08-23 19:59:36',0), ('2024_08_24_00_auth.sql','6D2CE419F8E8512051B63D0F68B30BAA769F9D4A','RELEASED','2024-08-24 10:23:33',0), -('2024_08_28_00_auth.sql','F39CA1C18CAC207418C3D3703DA0F038471D308A','RELEASED','2024-08-28 10:50:31',0); +('2024_08_28_00_auth.sql','F39CA1C18CAC207418C3D3703DA0F038471D308A','RELEASED','2024-08-28 10:50:31',0), +('2024_08_28_01_auth.sql','BC5D74553AF2D92606F55C1C462D2700FE73BD34','RELEASED','2024-08-28 14:55:05',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; diff --git a/sql/updates/auth/master/2024_08_28_01_auth.sql b/sql/updates/auth/master/2024_08_28_01_auth.sql new file mode 100644 index 00000000000..7e547d9cc4a --- /dev/null +++ b/sql/updates/auth/master/2024_08_28_01_auth.sql @@ -0,0 +1,6 @@ +ALTER TABLE `build_info` ADD `macArmAuthSeed` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL AFTER `mac64AuthSeed`; + +UPDATE `build_info` SET `macArmAuthSeed`='778F6A5DF79A4EF1B86F651F3B303CE7' WHERE `build`=56196; +UPDATE `build_info` SET `macArmAuthSeed`='41710C793EF021721F14B06EC1896D3F' WHERE `build`=56288; +UPDATE `build_info` SET `macArmAuthSeed`='412D3200715AAFDC0522DF031A941F0E' WHERE `build`=56311; +UPDATE `build_info` SET `macArmAuthSeed`='A83ED19EE659BC95CC322D1E49BDEDBB' WHERE `build`=56313; diff --git a/src/server/bnetserver/Server/Session.cpp b/src/server/bnetserver/Server/Session.cpp index 46fd1d1479a..c3aaa972160 100644 --- a/src/server/bnetserver/Server/Session.cpp +++ b/src/server/bnetserver/Server/Session.cpp @@ -219,7 +219,7 @@ uint32 Battlenet::Session::HandleLogon(authentication::v1::LogonRequest const* l return ERROR_BAD_PROGRAM; } - if (logonRequest->platform() != "Win" && logonRequest->platform() != "Wn64" && logonRequest->platform() != "Mc64") + if (logonRequest->platform() != "Win" && logonRequest->platform() != "Wn64" && logonRequest->platform() != "Mc64" && logonRequest->platform() != "MacA") { TC_LOG_DEBUG("session", "[Battlenet::LogonRequest] {} attempted to log in from an unsupported platform (using {})!", GetClientInfo(), logonRequest->platform()); return ERROR_BAD_PLATFORM; diff --git a/src/server/game/Server/WorldSocket.cpp b/src/server/game/Server/WorldSocket.cpp index 68783a321ae..f583c488367 100644 --- a/src/server/game/Server/WorldSocket.cpp +++ b/src/server/game/Server/WorldSocket.cpp @@ -713,6 +713,8 @@ void WorldSocket::HandleAuthSessionCallback(std::shared_ptr<WorldPackets::Auth:: digestKeyHash.UpdateData(buildInfo->Win64AuthSeed.data(), buildInfo->Win64AuthSeed.size()); else if (account.Game.OS == "Mc64") digestKeyHash.UpdateData(buildInfo->Mac64AuthSeed.data(), buildInfo->Mac64AuthSeed.size()); + else if (account.Game.OS == "MacA") + digestKeyHash.UpdateData(buildInfo->MacArmAuthSeed.data(), buildInfo->MacArmAuthSeed.size()); digestKeyHash.Finalize(); @@ -790,7 +792,7 @@ void WorldSocket::HandleAuthSessionCallback(std::shared_ptr<WorldPackets::Auth:: // Must be done before WorldSession is created bool wardenActive = sWorld->getBoolConfig(CONFIG_WARDEN_ENABLED); - if (wardenActive && account.Game.OS != "Win" && account.Game.OS != "Wn64" && account.Game.OS != "Mc64") + if (wardenActive && account.Game.OS != "Win" && account.Game.OS != "Wn64" && account.Game.OS != "Mc64" && account.Game.OS != "MacA") { SendAuthResponseError(ERROR_DENIED); TC_LOG_ERROR("network", "WorldSocket::HandleAuthSession: Client {} attempted to log in using invalid client OS ({}).", address, account.Game.OS); diff --git a/src/server/shared/Realm/RealmList.cpp b/src/server/shared/Realm/RealmList.cpp index 2568a859f88..fd1e6e3a165 100644 --- a/src/server/shared/Realm/RealmList.cpp +++ b/src/server/shared/Realm/RealmList.cpp @@ -82,7 +82,7 @@ void RealmList::Close() void RealmList::LoadBuildInfo() { // 0 1 2 3 4 5 6 - if (QueryResult result = LoginDatabase.Query("SELECT majorVersion, minorVersion, bugfixVersion, hotfixVersion, build, win64AuthSeed, mac64AuthSeed FROM build_info ORDER BY build ASC")) + if (QueryResult result = LoginDatabase.Query("SELECT majorVersion, minorVersion, bugfixVersion, hotfixVersion, build, win64AuthSeed, mac64AuthSeed, macArmAuthSeed FROM build_info ORDER BY build ASC")) { do { @@ -111,6 +111,12 @@ void RealmList::LoadBuildInfo() else build.Mac64AuthSeed = { }; + std::string macArmAuthSeedHexStr = fields[7].GetString(); + if (macArmAuthSeedHexStr.length() == build.MacArmAuthSeed.size() * 2) + HexStrToByteArray(macArmAuthSeedHexStr, build.MacArmAuthSeed); + else + build.MacArmAuthSeed = { }; + } while (result->NextRow()); } } diff --git a/src/server/shared/Realm/RealmList.h b/src/server/shared/Realm/RealmList.h index 3cbbb97c316..b61ad502877 100644 --- a/src/server/shared/Realm/RealmList.h +++ b/src/server/shared/Realm/RealmList.h @@ -38,6 +38,7 @@ struct RealmBuildInfo std::array<char, 4> HotfixVersion; std::array<uint8, 16> Win64AuthSeed; std::array<uint8, 16> Mac64AuthSeed; + std::array<uint8, 16> MacArmAuthSeed; }; namespace bgs::protocol::game_utilities::v1 |