sepalani/GamestatsHTTP

ms2012wii 98070/90040

Closed this issue · 3 comments

Logs:

[ms2012wii] Handle put2.asp?pid=600259634&hash=3bd5c828607f2e0ac5caf0d1c749a15c9ca25876&data=KupN5C0lA97P42lWsuxpTJeMGlDnDIFJRiMdDQqE9nGPq-bD9_snvuvdHMme_mNX2Dv6CgZwZ-qS
127.0.0.1 - - [02/Jul/2017 22:21:13] Put2 request for ms2012wii: {'hash': ['3bd5c828607f2e0ac5caf0d1c749a15c9ca25876'], 'pid': ['600259634'], 'data': ['KupN5C0lA97P42lWsuxpTJeMGlDnDIFJRiMdDQqE9nGPq-bD9_snvuvdHMme_mNX2Dv6CgZwZ-qS']}
127.0.0.1 - - [02/Jul/2017 22:21:13] "GET /ms2012wii/web/client/put2.asp?pid=600259634&hash=3bd5c828607f2e0ac5caf0d1c749a15c9ca25876&data=KupN5C0lA97P42lWsuxpTJeMGlDnDIFJRiMdDQqE9nGPq-bD9_snvuvdHMme_mNX2Dv6CgZwZ-qS HTTP/1.1" 200 -
[ms2012wii] GET /web/client/get2.asp?pid=600259634
Key: GamestatsKey(salt='PHGNtRfxhuYjQYHfzDng', constants=GamestatsKeyConstants(x=60069, y=30413, z=134217728, checksum_secret=719997155))
[ms2012wii] Handle get2.asp?pid=600259634
127.0.0.1 - - [02/Jul/2017 22:21:14] "GET /ms2012wii/web/client/get2.asp?pid=600259634 HTTP/1.1" 200 -
[ms2012wii] GET /web/client/get2.asp?pid=600259634&hash=818edb033e7ef3652063755154c2ab7ce39cbdf9&data=KupKfNBDTD2NhdC1XuLkW-kr0Nr624eFT68rO5FCopu761mILdVX4A==
Key: GamestatsKey(salt='PHGNtRfxhuYjQYHfzDng', constants=GamestatsKeyConstants(x=60069, y=30413, z=134217728, checksum_secret=719997155))
[ms2012wii] Handle get2.asp?pid=600259634&hash=818edb033e7ef3652063755154c2ab7ce39cbdf9&data=KupKfNBDTD2NhdC1XuLkW-kr0Nr624eFT68rO5FCopu761mILdVX4A==
127.0.0.1 - - [02/Jul/2017 22:21:14] Get2 request for ms2012wii: {'hash': ['818edb033e7ef3652063755154c2ab7ce39cbdf9'], 'pid': ['600259634'], 'data': ['KupKfNBDTD2NhdC1XuLkW-kr0Nr624eFT68rO5FCopu761mILdVX4A==']}
127.0.0.1 - - [02/Jul/2017 22:21:14] "GET /ms2012wii/web/client/get2.asp?pid=600259634&hash=818edb033e7ef3652063755154c2ab7ce39cbdf9&data=KupKfNBDTD2NhdC1XuLkW-kr0Nr624eFT68rO5FCopu761mILdVX4A== HTTP/1.1" 200 -
[ms2012wii] GET /web/client/put2.asp?pid=600259634
Key: GamestatsKey(salt='PHGNtRfxhuYjQYHfzDng', constants=GamestatsKeyConstants(x=60069, y=30413, z=134217728, checksum_secret=719997155))
[ms2012wii] Handle put2.asp?pid=600259634
127.0.0.1 - - [02/Jul/2017 22:21:17] "GET /ms2012wii/web/client/put2.asp?pid=600259634 HTTP/1.1" 200 -
[ms2012wii] GET /web/client/put2.asp?pid=600259634&hash=1efe82c0905aa7e930a1edd8e2c5e202fed8b786&data=KupN6IT5_Cvtifff3fYBTY21SksWwukMkqCiNm9JtDGOVeejx5bVYuaxd_ZW1fK2KEpC6qWlfgz-
Key: GamestatsKey(salt='PHGNtRfxhuYjQYHfzDng', constants=GamestatsKeyConstants(x=60069, y=30413, z=134217728, checksum_secret=719997155))
[ms2012wii] Handle put2.asp?pid=600259634&hash=1efe82c0905aa7e930a1edd8e2c5e202fed8b786&data=KupN6IT5_Cvtifff3fYBTY21SksWwukMkqCiNm9JtDGOVeejx5bVYuaxd_ZW1fK2KEpC6qWlfgz-
127.0.0.1 - - [02/Jul/2017 22:21:17] Put2 request for ms2012wii: {'hash': ['1efe82c0905aa7e930a1edd8e2c5e202fed8b786'], 'pid': ['600259634'], 'data': ['KupN6IT5_Cvtifff3fYBTY21SksWwukMkqCiNm9JtDGOVeejx5bVYuaxd_ZW1fK2KEpC6qWlfgz-']}
127.0.0.1 - - [02/Jul/2017 22:21:17] "GET /ms2012wii/web/client/put2.asp?pid=600259634&hash=1efe82c0905aa7e930a1edd8e2c5e202fed8b786&data=KupN6IT5_Cvtifff3fYBTY21SksWwukMkqCiNm9JtDGOVeejx5bVYuaxd_ZW1fK2KEpC6qWlfgz- HTTP/1.1" 200 -
[ms2012wii] GET /web/client/get2.asp?pid=600259634
Key: GamestatsKey(salt='PHGNtRfxhuYjQYHfzDng', constants=GamestatsKeyConstants(x=60069, y=30413, z=134217728, checksum_secret=719997155))
[ms2012wii] Handle get2.asp?pid=600259634
127.0.0.1 - - [02/Jul/2017 22:21:18] "GET /ms2012wii/web/client/get2.asp?pid=600259634 HTTP/1.1" 200 -
[ms2012wii] GET /web/client/get2.asp?pid=600259634&hash=81788580f0bf48c722c42468590bdc533aa0cf0a&data=KupKfNBDTD2NhdC1XuLkW-kr0Nr624eFT68rO5FCopu761mILdVX4A==
Key: GamestatsKey(salt='PHGNtRfxhuYjQYHfzDng', constants=GamestatsKeyConstants(x=60069, y=30413, z=134217728, checksum_secret=719997155))
[ms2012wii] Handle get2.asp?pid=600259634&hash=81788580f0bf48c722c42468590bdc533aa0cf0a&data=KupKfNBDTD2NhdC1XuLkW-kr0Nr624eFT68rO5FCopu761mILdVX4A==
127.0.0.1 - - [02/Jul/2017 22:21:18] Get2 request for ms2012wii: {'hash': ['81788580f0bf48c722c42468590bdc533aa0cf0a'], 'pid': ['600259634'], 'data': ['KupKfNBDTD2NhdC1XuLkW-kr0Nr624eFT68rO5FCopu761mILdVX4A==']}
127.0.0.1 - - [02/Jul/2017 22:21:18] "GET /ms2012wii/web/client/get2.asp?pid=600259634&hash=81788580f0bf48c722c42468590bdc533aa0cf0a&data=KupKfNBDTD2NhdC1XuLkW-kr0Nr624eFT68rO5FCopu761mILdVX4A== HTTP/1.1" 200 -

90040 has also been seen:

[ms2012wii] GET /web/client/get2.asp?pid=600259722
Key: GamestatsKey(salt='PHGNtRfxhuYjQYHfzDng', constants=GamestatsKeyConstants(x=60069, y=30413, z=134217728, checksum_secret=719997155))
[ms2012wii] Handle get2.asp?pid=600259722
127.0.0.1 - - [02/Jul/2017 23:40:07] "GET /ms2012wii/web/client/get2.asp?pid=600259722 HTTP/1.1" 200 -
[ms2012wii] GET /web/client/get2.asp?pid=600259722&hash=fd6128f6617d78a3e5f3f8ef6c29b835d8b52a48&data=KupKFc_cXPV5jifgZ71QfYRdc_5hQyzn65f2fJt7CIwg_G18jT1klg==
Key: GamestatsKey(salt='PHGNtRfxhuYjQYHfzDng', constants=GamestatsKeyConstants(x=60069, y=30413, z=134217728, checksum_secret=719997155))
[ms2012wii] Handle get2.asp?pid=600259722&hash=fd6128f6617d78a3e5f3f8ef6c29b835d8b52a48&data=KupKFc_cXPV5jifgZ71QfYRdc_5hQyzn65f2fJt7CIwg_G18jT1klg==
127.0.0.1 - - [02/Jul/2017 23:40:07] Get2 request for ms2012wii: {'hash': ['fd6128f6617d78a3e5f3f8ef6c29b835d8b52a48'], 'pid': ['600259722'], 'data': ['KupKFc_cXPV5jifgZ71QfYRdc_5hQyzn65f2fJt7CIwg_G18jT1klg==']}
127.0.0.1 - - [02/Jul/2017 23:40:07] "GET /ms2012wii/web/client/get2.asp?pid=600259722&hash=fd6128f6617d78a3e5f3f8ef6c29b835d8b52a48&data=KupKFc_cXPV5jifgZ71QfYRdc_5hQyzn65f2fJt7CIwg_G18jT1klg== HTTP/1.1" 200 -

PCAP: https://cdn.discordapp.com/attachments/331096011260821507/331217755103690754/wii.pcap

90040 does not occur when there are no rankings:

Key: GamestatsKey(salt='PHGNtRfxhuYjQYHfzDng', constants=GamestatsKeyConstants(x=60069, y=30413, z=134217728, checksum_secret=719997155))
[ms2012wii] Handle get2.asp?pid=600259722
127.0.0.1 - - [04/Jul/2017 04:09:40] "GET /ms2012wii/web/client/get2.asp?pid=600259722 HTTP/1.1" 200 -
[ms2012wii] GET /web/client/get2.asp?pid=600259722&hash=12c941f8975af3ac32f1a30a97b609bd25a6392a&data=KupL5MPAVWQPTEOooedXhMhJwmzx-ihnj2yrbMYZ7xxo3HHDP48JkQ==
Key: GamestatsKey(salt='PHGNtRfxhuYjQYHfzDng', constants=GamestatsKeyConstants(x=60069, y=30413, z=134217728, checksum_secret=719997155))
[ms2012wii] Handle get2.asp?pid=600259722&hash=12c941f8975af3ac32f1a30a97b609bd25a6392a&data=KupL5MPAVWQPTEOooedXhMhJwmzx-ihnj2yrbMYZ7xxo3HHDP48JkQ==
127.0.0.1 - - [04/Jul/2017 04:09:40] Get2 request for ms2012wii: {'hash': ['12c941f8975af3ac32f1a30a97b609bd25a6392a'], 'pid': ['600259722'], 'data': ['KupL5MPAVWQPTEOooedXhMhJwmzx-ihnj2yrbMYZ7xxo3HHDP48JkQ==']}
127.0.0.1 - - [04/Jul/2017 04:09:40] "GET /ms2012wii/web/client/get2.asp?pid=600259722&hash=12c941f8975af3ac32f1a30a97b609bd25a6392a&data=KupL5MPAVWQPTEOooedXhMhJwmzx-ihnj2yrbMYZ7xxo3HHDP48JkQ== HTTP/1.1" 200 -

and:

[ms2012wii] Handle get2.asp?pid=600259722&hash=d241c813d388ea79f6a0151528201ee1f2742310&data=KupKFc_cXPV5jifgZ71QfYRdc_5hQyzn65f2fJt7CIwg_G18jT1klg==
127.0.0.1 - - [04/Jul/2017 04:06:59] Get2 request for ms2012wii: {'hash': ['d241c813d388ea79f6a0151528201ee1f2742310'], 'pid': ['600259722'], 'data': ['KupKFc_cXPV5jifgZ71QfYRdc_5hQyzn65f2fJt7CIwg_G18jT1klg==']}
127.0.0.1 - - [04/Jul/2017 04:06:59] "GET /ms2012wii/web/client/get2.asp?pid=600259722&hash=d241c813d388ea79f6a0151528201ee1f2742310&data=KupKFc_cXPV5jifgZ71QfYRdc_5hQyzn65f2fJt7CIwg_G18jT1klg== HTTP/1.1" 200 -
[ms2012wii] GET /web/client/get2.asp?pid=600259722
Key: GamestatsKey(salt='PHGNtRfxhuYjQYHfzDng', constants=GamestatsKeyConstants(x=60069, y=30413, z=134217728, checksum_secret=719997155))
[ms2012wii] Handle get2.asp?pid=600259722
127.0.0.1 - - [04/Jul/2017 04:08:19] "GET /ms2012wii/web/client/get2.asp?pid=600259722 HTTP/1.1" 200 -
[ms2012wii] GET /web/client/get2.asp?pid=600259722&hash=da324a7587bbfb677e165b640629c12975d3a725&data=KupL59KH_l1x0JnBxOBlg25rHe-KNBoUEM7HjftmIWym03Br49tGVQ==
Key: GamestatsKey(salt='PHGNtRfxhuYjQYHfzDng', constants=GamestatsKeyConstants(x=60069, y=30413, z=134217728, checksum_secret=719997155))
[ms2012wii] Handle get2.asp?pid=600259722&hash=da324a7587bbfb677e165b640629c12975d3a725&data=KupL59KH_l1x0JnBxOBlg25rHe-KNBoUEM7HjftmIWym03Br49tGVQ==
127.0.0.1 - - [04/Jul/2017 04:08:19] Get2 request for ms2012wii: {'hash': ['da324a7587bbfb677e165b640629c12975d3a725'], 'pid': ['600259722'], 'data': ['KupL59KH_l1x0JnBxOBlg25rHe-KNBoUEM7HjftmIWym03Br49tGVQ==']}
127.0.0.1 - - [04/Jul/2017 04:08:19] "GET /ms2012wii/web/client/get2.asp?pid=600259722&hash=da324a7587bbfb677e165b640629c12975d3a725&data=KupL59KH_l1x0JnBxOBlg25rHe-KNBoUEM7HjftmIWym03Br49tGVQ== HTTP/1.1" 200 -

It seems this case was because of corrupted data stored in the ranking table. Getting rid of them fixed the issue. Feel free to re-open if it still happens.