Multi Game Support

Matze167435 · 25. Dezember 2017, 21:08

Yes, this is exactly what I meant.

I decided to post the request the game makes and the server's answer:

Request:

Quellcode

Hypertext Transfer Protocol
POST /SakeStorageServer/StorageServer.asmx HTTP/1.1\r\n
Host: playgroundds.secure.sake.gs.nintendowifi.net\r\n
User-Agent: GameSpyHTTP/1.0\r\n
Connection: close\r\n
Content-Length: 1362\r\n
Content-Type: text/xml\r\n
SOAPAction: "http://gamespy.net/sake/GetSpecificRecords"\r\n
\r\n
[Full request URI: http://playgroundds.secure.sake.gs.nintendowifi.net/SakeStorageServer/StorageServer.asmx]
[HTTP request 1/1]
[Response in frame: 1373]
File Data: 1362 bytes
eXtensible Markup Language
<?xml
<SOAP-ENV:Envelope
xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:ns1="http://gamespy.net/sake">
<SOAP-ENV:Body>
<ns1:GetSpecificRecords>
<ns1:gameid>
2999
</ns1:gameid>
<ns1:secretKey>
o6JWLk
</ns1:secretKey>
<ns1:loginTicket>
23c7859f2bb036e5D5Ndqb5N
</ns1:loginTicket>
<ns1:tableid>
tblMapInfo
</ns1:tableid>
<ns1:recordids>
<ns1:int>
0
</ns1:int>
<ns1:int>
0
</ns1:int>
<ns1:int>
0
</ns1:int>
<ns1:int>
0
</ns1:int>
<ns1:int>
0
</ns1:int>
<ns1:int>
0
</ns1:int>
<ns1:int>
225494
</ns1:int>
<ns1:int>
391396
</ns1:int>
<ns1:int>
0
</ns1:int>
<ns1:int>
274224
</ns1:int>
<ns1:int>
0
</ns1:int>
<ns1:int>
274212
</ns1:int>
<ns1:int>
0
</ns1:int>
<ns1:int>
0
</ns1:int>
<ns1:int>
274205
</ns1:int>
<ns1:int>
0
</ns1:int>
<ns1:int>
0
</ns1:int>
<ns1:int>
0
</ns1:int>
<ns1:int>
391373
</ns1:int>
<ns1:int>
391805
</ns1:int>
<ns1:int>
0
</ns1:int>
<ns1:int>
0
</ns1:int>
<ns1:int>
1013
</ns1:int>
<ns1:int>
0
</ns1:int>
<ns1:int>
0
</ns1:int>
</ns1:recordids>
<ns1:fields>
<ns1:string>
recordid
</ns1:string>
<ns1:string>
approval_recordid
</ns1:string>
<ns1:string>
num_ratings
</ns1:string>
<ns1:string>
average_rating
</ns1:string>
<ns1:string>
stat_fileid.downloads
</ns1:string>
</ns1:fields>
</ns1:GetSpecificRecords>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>

Alles anzeigen

SAKE's answer:

Quellcode

Hypertext Transfer Protocol
HTTP/1.1 200 OK\r\n
Date: Mon, 25 Dec 2017 14:47:35 GMT\r\n
Server: Apache/2.4.6 (Linux/SUSE)\r\n
X-Powered-By: PHP/5.4.20\r\n
Content-Length: 805\r\n
Connection: close\r\n
Content-Type: text/xml; charset=utf-8\r\n
\r\n
[HTTP response 1/1]
[Time since request: 0.173238000 seconds]
[Request in frame: 1363]
File Data: 805 bytes
eXtensible Markup Language
<?xml
<soap:Envelope
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
<soap:Body>
<GetSpecificRecordsResponse
xmlns="http://gamespy.net/sake">
<GetSpecificRecordsResult>
Success
</GetSpecificRecordsResult>
<values>
<ArrayOfRecordValue>
<RecordValue>
<intValue>
<value>
1013
</value>
</intValue>
</RecordValue>
<RecordValue>
<asciiStringValue>
<value>
</value>
</asciiStringValue>
</RecordValue>
<RecordValue>
<intValue>
<value>
</value>
</intValue>
</RecordValue>
<RecordValue>
<asciiStringValue>
<value>
</value>
</asciiStringValue>
</RecordValue>
<RecordValue>
<intValue>
<value>
0
</value>
</intValue>
</RecordValue>
</ArrayOfRecordValue>
</values>
</GetSpecificRecordsResponse>
</soap:Body>
</soap:Envelope>

Alles anzeigen

The game is trying to get information about the levels that I uploaded. The nwfc recordids don't seem to cause issues since I can login fine if I have no level uploaded to Wiimmfi. In this case SAKE's answer will be empty which appears to be fine. If a level is uploaded it finds it in the database and returns information but it seems to be incomplete since some values are completely empty. After this the game displays the error code.

Billy549 · 26. Dezember 2017, 00:52

Since we're all doing SAKE talk: (cc @Wiimm ofc)
micchannelwii (Also known lovingly as Wii Speak Channel, or the channel from hell) seems to now want an extra query Wiimmfi doesn't support;

After clearing my savedata and connecting, my Wii sends this:

Quellcode

POST /SakeStorageServer/StorageServer.asmx HTTP/1.1
Host: micchannelwii.sake.gs.wiimmfi.de
User-Agent: GameSpyHTTP/1.0
Connection: close
Content-Length: 613
Content-Type: text/xml
SOAPAction: "http://gamespy.net/sake/RateRecord"
<?xml version="1.0" encoding="UTF-8"?><SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:ns1="http://gamespy.net/sake"><SOAP-ENV:Body><ns1:RateRecord><ns1:gameid>2253</ns1:gameid><ns1:secretKey>wkvBfX</ns1:secretKey><ns1:loginTicket>23c7e3c61aa386ddZQoVZnGa</ns1:loginTicket><ns1:tableid>userinfo</ns1:tableid><ns1:recordid>1002</ns1:recordid><ns1:rating>0</ns1:rating></ns1:RateRecord></SOAP-ENV:Body></SOAP-ENV:Envelope>

However, the server returns:

HTML-Quellcode

HTTP/1.1 404 Not Found
Date: Mon, 25 Dec 2017 23:48:43 GMT
Server: Apache/2.4.6 (Linux/SUSE)
X-Powered-By: PHP/5.4.20
Sake-File-Result: 7
Content-Length: 128
Connection: close
Content-Type: text/html; charset=utf-8
<html>
<head><title>404 Not Found</title></head>
<body bgcolor="white">
<center><h1>404 Not Found</h1></center>
</body>
</html>

Alles anzeigen

While I can't confirm that's the specific error (since I want to be annoying and please clear out all database records so Larsen and I can start afresh with fresh dumps), it'd be nice for this to be implemented to see if it fixes the error.

Leseratte · 26. Dezember 2017, 01:04

Record rating isn't implemented in Wiimmfi SAKE (and also not implemented in AltWFC SAKE). A Nintendo dump (from the original servers) of any rating request would be helpful ...

We could try returning the errors "AlreadyRated" or "NotRateable" to see what the game does about that, but I doubt that'll work.

Billy549 · 26. Dezember 2017, 01:06

Leseratte schrieb:

Record rating isn't implemented in Wiimmfi SAKE (and also not implemented in AltWFC SAKE). A Nintendo dump (from the original servers) of any rating request would be helpful ...

Sadly, we don't seem to have that; wasn't gamespy.net/sake/ archived back when we found it?

Leseratte · 26. Dezember 2017, 01:18

I don't know ...

@Wiimm these two blocks of code from the Gamespy SDK might help with that rankings record.

C-Quellcode: sake/sake.h

///////////////////////////////////////////////////////////////////////////////
// rate record
typedef struct
{
char *mTableId;
int mRecordId;
gsi_u8 mRating;
} SAKERateRecordInput;
typedef struct
{
int mNumRatings;
float mAverageRating;
} SAKERateRecordOutput;
SAKERequest SAKE_CALL sakeRateRecord(SAKE sake, SAKERateRecordInput *input, SAKERequestCallback callback, void *userData);

Alles anzeigen

C-Quellcode: sake/sakeRequestMisc.c

///////////////////////////////////////////////////////////////////////////////
///////////////////////////////////////////////////////////////////////////////
// Rate Record
static SAKEStartRequestResult SAKE_CALL sakeiRateRecordValidateInput(SAKERequest request)
{
SAKERateRecordInput *input = (SAKERateRecordInput *)request->mInput;
// check the tableid
if(!input->mTableId)
return SAKEStartRequestResult_BAD_TABLEID;
return SAKEStartRequestResult_SUCCESS;
}
static SAKEStartRequestResult SAKE_CALL sakeiRateRecordFillSoapRequest(SAKERequest request)
{
SAKERateRecordInput *input = (SAKERateRecordInput *)request->mInput;
// write the table id
gsXmlWriteStringElement(request->mSoapRequest, GSI_SAKE_SERVICE_NAMESPACE, "tableid", input->mTableId);
// write the recordid
gsXmlWriteIntElement(request->mSoapRequest, GSI_SAKE_SERVICE_NAMESPACE, "recordid", (gsi_u32)input->mRecordId);
// write the rating
gsXmlWriteIntElement(request->mSoapRequest, GSI_SAKE_SERVICE_NAMESPACE, "rating", (gsi_u32)input->mRating);
return SAKEStartRequestResult_SUCCESS;
}
static SAKERequestResult sakeiRateRecordProcessSoapResponse(SAKERequest request)
{
SAKERateRecordOutput *output = (SAKERateRecordOutput *)request->mOutput;
if(gsi_is_false(gsXmlReadChildAsInt(request->mSoapResponse, "numRatings", &output->mNumRatings)) ||
gsi_is_false(gsXmlReadChildAsFloat(request->mSoapResponse, "averageRating", &output->mAverageRating)))
{
return SAKERequestResult_MALFORMED_RESPONSE;
}
return SAKERequestResult_SUCCESS;
}
SAKEStartRequestResult SAKE_CALL sakeiStartRateRecordRequest(SAKERequest request)
{
static SAKEIRequestInfo info =
{
sizeof(SAKERateRecordOutput),
SAKEI_FUNC_NAME_STRINGS("RateRecord"),
sakeiRateRecordValidateInput,
sakeiRateRecordFillSoapRequest,
sakeiRateRecordProcessSoapResponse
};
return sakeiStartRequest(request, &info);
}

Alles anzeigen

So this thing is basically rating a record, and wants an average rating and the number of ratings returned, so that table needs two more columns (current avg. and number of ratings) and that average value calculation needs to be added to SAKE.

Wiimm · 26. Dezember 2017, 01:18

I'll continue my SAKE work in 2 days.

Billy549 · 26. Dezember 2017, 05:45

Wiimm schrieb:

I'll continue my SAKE work in 2 days.

Of course, no worries; enjoy the time off with your family, that's more important than this c:

Metaridley · 26. Dezember 2017, 07:40

Metaridley schrieb:

Wiimm schrieb:

Quellcode

x # grep '<<' *.txt

digistoryds.txt:GAME TEST <<ID3>>P <<TITLE>> (PAL)

digistoryds.txt:GAME TEST <<ID3>>E <<TITLE>> (USA)

digistoryds.txt:GAME TEST <<ID3>>K <<TITLE>> (Korea)

digiwrldds.txt:GAME TEST <<ID3>>J <<TITLE>> (Japan)

digiwrldds.txt:GAME TEST <<ID3>>P <<TITLE>> (PAL)

digiwrldds.txt:GAME TEST <<ID3>>K <<TITLE>> (Korea)

the thing is = the game has no pal, korea etc. release - and in the template states "don't remove regions"so... yeah that make absolute no sense to me, so... either i delete everything besides the USA (or JAP in case of DW Story) or i paste everything into the IDE3/TITLE fields but then there are no region codes for the others outside of US or Jap (there are no ADNK or ADNP)

A Description for 1-Region Only games would be nice...

I hope anybody here can explain me in detail what i've made wrong. i describe here my understanding of the the workaround but it doesn't rly help

back in the day when i write the file for bleach versus crusade on wii, i deleted every region line except for japanese and it worked, but since the template is updated, the statement of "don't remove regions" confuse me rly hard

Wiimm · 26. Dezember 2017, 21:54

Leseratte schrieb:

so that table needs two more columns

Or an extra table to store each vote and let aggregate it by SQL server on read. With this construction, votes are editable (if Wii supports it) and can also be banned.

@Metaridley
Study the top of _template.txt

Wiimm · 27. Dezember 2017, 02:32

Tomorrow I will clean all tables of Mario vs. Donkey Kong. Any veto?

Then I will start to think about a rating function, but I have no idea about the reply of the server. I can guess a xml structure, that's all.
I think, a rating tables is build at least by following members:
* recordid
* ownerid
* rating
* timestamp

Metaridley · 27. Dezember 2017, 02:59

Ok so i get no explanations here and the head of the template don't rly replied "my question" that i ask times over times here, i search a few other templates in this thread before and yeah... it's against my logic but hey nobody can me answer that correctly.

I've paste now the follow things in "both" templates

"
GAME TEST ADNJ Digimon Story (Japan)
GAME TEST ADNP Digimon World DS (PAL)
GAME TEST ADNE Digimon World DS (USA)
GAME TEST ADNK Digimon Story (Korea)
"

and please try to enabled them.

BUT it don't explain anything to me = D.Story and D.World DS are technically the same game but there two different games because of region restrictions they can't communicate together (something like DBZ B.Tenkaichi 3 and DBZ Sparking Meteor also the same games but they can't connect with the each other because different regions)

so THAT confuses me too, and ALSO the game never came out in korea or pal regions so it makes no sense to me why the template want region codes like "ADNP" they not exist.

as another example, here the ID list from BT3 from the wiimmfi game history

GAME PART RDSE Dragon Ball Z Budokai Tenkaichi 3 (USA)
GAME PART RDSP Dragon Ball Z Budokai Tenkaichi 3 (PAL)

no japanese, no korean

and here from Sparking Meteor

GAME TEST RDSJ Dragon Ball Z Budokai Tenkaichi 3 (JAP)

no US, no PAL, no Korean

So and in the new template you shouldn't delete any of the four rows?sry but it's for a noob they ask for one game to add and write a template in 1-2 years is confusing as hell

i don't want to rant here, i only want understand the logic behind that...

Matze167435 · 27. Dezember 2017, 11:36

Wiimm schrieb:

Tomorrow I will clean all tables of Mario vs. Donkey Kong. Any veto?

No veto from me

Edit: I forgot: Don't clear tblregioninfo please or the game will freeze again. Instead it would be nice if you would add this if you didn't do it yet:

Wiimm schrieb:

Quellcode

+------------+------------+--------+----------+--------+-----------------+-------------+

| _created | _updated | _count | recordid | region | allowed_regions | min_ratings |

+------------+------------+--------+----------+--------+-----------------+-------------+

| 1514231549 | 1514231549 | 1 | 1 | 3 | 1 | 1 |

| 1514231549 | 1514231549 | 1 | 2 | 3 | 2 | 1 |

| 1514231549 | 1514231549 | 1 | 3 | 3 | 3 | 1 |

| 1514231549 | 1514231549 | 1 | 4 | 3 | 4 | 1 |

| 1514231549 | 1514231549 | 1 | 5 | 3 | 5 | 1 |

+------------+------------+--------+----------+--------+-----------------+-------------+

Wiimm · 27. Dezember 2017, 17:52

I have now analyzed all rating requests and want to implement it like this:

1.)
The result data types for ratings are:
* intValue num_ratings
* floatValue average_rating

I have already activated theses members for tables
* playgroundds_tbljoinmapplayerinfo
* playgroundds_tblmapinfo
* playgroundds_tblmapinfx
* playgroundds_tblnintendomapinfo
* speak_userinfo
Compare wiimmfi.de/sake-storage/
So the empty result of Matze167435's dump are replaced by numbers -> try again.

2.)
For table with rating support I'll implement a secondary table with at least
* recordid
* ownerid
* rating
* invalid
Each time a rating arrived, the summary values of the base tables (num_ratings+average_rating) are updated too. This redundancy makes the read access for a base table much easier (no extra programming needed).

This is the next step to implement. I do it maybe in the evening (in 4-5h) ore more likely tomorrow.

Matze167435 · 27. Dezember 2017, 18:12

Unfortunately still error code 40956.

Billy549 · 27. Dezember 2017, 18:16

Wiimm schrieb:

2.)

For table with rating support I'll implement a secondary table with at least
* recordid
* ownerid
* rating
* invalid
Each time a rating arrived, the summary values of the base tables (num_ratings+average_rating) are updated too. This redundancy makes the read access for a base table much easier (no extra programming needed).

This is the next step to implement. I to it maybe in the evening (in 4-5h) ore more likely tomorrow.

Awesome! TY :3

Wiimm · 27. Dezember 2017, 18:16

First: I forgotten to list table "speak_userinfo" in post above.

@Metaridley
Is it really so difficult to follow intructions like

Quellcode

# 1x <<TYPE>> : Game type: NDS | Wii | DSiWare | WiiWare | Mix

... or ...

Quellcode

GAMETYPE <type>
Define the game type. Possible are 'NDS', 'Wii', 'DSiWare', 'WiiWare' and
'Mix'. 'Mix' enables dual console (NDS and Wii) logins.

... and not to write "GAMETYPE Nintendo DS"?

Anyway, games activated.

Matze167435 · 27. Dezember 2017, 19:10

The values are still empty:

Quellcode

Hypertext Transfer Protocol
HTTP/1.1 200 OK\r\n
Date: Wed, 27 Dec 2017 17:58:38 GMT\r\n
Server: Apache/2.4.6 (Linux/SUSE)\r\n
X-Powered-By: PHP/5.4.20\r\n
Content-Length: 793\r\n
Connection: close\r\n
Content-Type: text/xml; charset=utf-8\r\n
\r\n
[HTTP response 1/1]
[Time since request: 2.282535000 seconds]
[Request in frame: 616]
File Data: 793 bytes
eXtensible Markup Language
<?xml
<soap:Envelope
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
<soap:Body>
<GetSpecificRecordsResponse
xmlns="http://gamespy.net/sake">
<GetSpecificRecordsResult>
Success
</GetSpecificRecordsResult>
<values>
<ArrayOfRecordValue>
<RecordValue>
<intValue>
<value>
1002
</value>
</intValue>
</RecordValue>
<RecordValue>
<asciiStringValue>
<value>
</value>
</asciiStringValue>
</RecordValue>
<RecordValue>
<intValue>
<value>
</value>
</intValue>
</RecordValue>
<RecordValue>
<floatValue>
<value>
</value>
</floatValue>
</RecordValue>
<RecordValue>
<intValue>
<value>
0
</value>
</intValue>
</RecordValue>
</ArrayOfRecordValue>
</values>
</GetSpecificRecordsResponse>
</soap:Body>
</soap:Envelope>

Alles anzeigen

Billy549 · 27. Dezember 2017, 20:10

Also, Wiimm, I'd like to thank you for making tokens contain information we need about users; Sepalani has started work on TCP GameStats which can use actual user-data thanks to the PID (in other words please don't change the tokens, they're completely fine and work well)

Metaridley · 27. Dezember 2017, 21:21

@Wiimm ups sry i forgot that but thanks for enable the games!

I tested them and i've updated the templates for the testing report

Connecting to the server and Friend Codes are working fine but Digimon Matching don't work. I only could test it with my 3DS and desmume wifi emulator (metroid prime hunters works fine in wifi mode with this setup). maybe someone can help out with testing. The clients find themself and around after 1 min they got disconnected

Billy549 · 27. Dezember 2017, 22:07

Metaridley schrieb:

@Wiimm ups sry i forgot that but thanks for enable the games!

I tested them and i've updated the templates for the testing report

Connecting to the server and Friend Codes are working fine but Digimon Matching don't work. I only could test it with my 3DS and desmume wifi emulator (metroid prime hunters works fine in wifi mode with this setup). maybe someone can help out with testing. The clients find themself and around after 1 min they got disconnected.

Sure, I can help test. Send me a DM (if you have Discord or similar please send your name across, if not, no worries!)

Billy549 · 27. Dezember 2017, 22:48

[Sorry for double post!]
Thanks to @Sepalani 's hard work, we now have non-dummy responses for GAMESTATS/TCP!
This means that for Boom (Fortune) Street no longer shows MAX, and instead now shows the real user's Mii! (This does mean it takes a second or too for it to load but that's fine :P)

larsenv · 28. Dezember 2017, 00:11

Can confirm Digimon Matching works (Thanks @PokeAcer ) - seems to be FULL support then, @Wiimm ?

Also, TV Show King 2 should be set to FULL now, rankings work.

Metaridley · 28. Dezember 2017, 01:25

larsenv schrieb:

Can confirm Digimon Matching works (Thanks @PokeAcer ) - seems to be FULL support then, @Wiimm ?

Also, TV Show King 2 should be set to FULL now, rankings work.

have you tested both (DWorld DS US and Story Jap)?

Billy549 · 28. Dezember 2017, 04:32

Metaridley schrieb:

larsenv schrieb:

Can confirm Digimon Matching works (Thanks @PokeAcer ) - seems to be FULL support then, @Wiimm ?

Also, TV Show King 2 should be set to FULL now, rankings work.

have you tested both (DWorld DS US and Story Jap)?

USA was tested; Japanese we need to find a 100% save for.

Wiimmfi Services had a forced Azure maintenance; it was either do it now or wait a week and it does it randomly and breaks. I've restarted everything:
DLS1, DLS2, GAMESTATS/TCP, GAMESTATS/HTTP, Peerchat, all running again, and hopefully running fine. @Wiimm around February I will have to move hosts, but I already know where i am moving and i'll start setting it up on Feb 1 - I'll DM you the new IP to change accordingly for

Wiimm · 28. Dezember 2017, 12:12

Metaridley schrieb:

I tested them and i've updated the templates for the testing report

Better is to tell me the changes, because I use a modified version of the file.

Multi Game Support

Quellcode

Quellcode

Quellcode

HTML-Quellcode

Leseratte schrieb:

C-Quellcode: sake/sake.h

C-Quellcode: sake/sakeRequestMisc.c

Wiimm schrieb:

Metaridley schrieb:

Wiimm schrieb:

Quellcode

Leseratte schrieb:

Wiimm schrieb:

Wiimm schrieb:

Quellcode

Wiimm schrieb:

Quellcode

Quellcode

Quellcode

Metaridley schrieb:

larsenv schrieb:

Metaridley schrieb:

larsenv schrieb:

Metaridley schrieb:

Teilen

Benutzer online 5