Friend code web form

Wiimm · 28. April 2014, 16:28

Web Formula

I you want to use your old profiles with the new servers, we must retrieve data from the old servers. Therefore we must know your friend code. So simply follow the instructions of the web formula and add your friend code to our retrieving list:
* Web Formula

Verifying a friend code

I have rewritten the server site script to verify, if a friend code is inserted into the database.
* wiimmfi.de/nick/FRIEND_CODE
Replace the string "FRIEND_CODE" by your friend code or profile id.

Examples:
* wiimmfi.de/nick/0432-5226-7951
* wiimmfi.de/nick/302594991

The answer is a machine readable text line and one of the flowing strings:

"-" (minus sign) : friend code unknown
"retrieved" : friend code was retrieved from the gamespy servers.
"app" : friend code was delivered by the Wii application for MKW.
"created" : A self created friend code.

If a real profile made (done during first login, and removed sometimes on database maintenance), the string ",active" is appended.

FAQ

Why shall I register my friend code?
If you want to use the custom server with your old profile, we need additional login info. It is possible to retrieve it from the original servers until they are discontinued.
Why I must have a friend?
The only thing we can do is retrieving the login data of your registered friends. Once we have retrieved your friends, we also retrieve the data for their friends, and one of them is hopefully you.
Why is May 18 the last day?
The Server shutdown was announced for May 20, but we don't know the exact time. The worst case may be 0:00 at Japan local time. Our deadline of May 18 23:59 (any timezone) gives us at least some hours to retrieve the data.
When will you close the formula?
The formula and the retrieving process will run until the final server shutdown.
Why can't I login with my old profile?
1. Your login data is not retrieved yet.
2. You have no registered friends.
3. You registered friends have not registered you.
4. The database update is only made twice per day.
Why can I login without registering?
1. You have used the DNS redirect a month ago.
2. Any other has you registered.
3. You met me online playing MKWii, I dumped the traffic and the dump is part of my dump archive.
4. Our retrieving process catched you as friend of a friend of a friend of a ...
My game is RMCP, but the formula shows RMCJ
That's correct. To meet online, all player have to use the same game id. And for the most games the Japanese game code is used. However, the game id is only for you. It's a chance to detect typos in your friend code. For the retrieving process we need only the friend code; all other data is replied by the server.
What happens, if I haven't registered my friend code?
If the custom server doesn't know you, you can't login. In this case the only chance is, to create a new profile on the custom server. However, for Mario Kart Wii there exists a homebrew app, that can read the login data from your save game.
I can't play at the custom server, why?
Have you patched your image?
* wiimmfi-patcher, English instructions
* wiimmfi-patcher, German instructions
I have asked for PM support, but no one answered?
The developers spent very very much time into the project. And they are not private supporters. So they ignore such PM silently. If you have questions, read the FAQ and ask the forums.

Xidus · 28. April 2014, 19:35

Any special withes for the web formula? PHP or ASP.Net? MySql or Plain Text Storaging?
Maybe I can create one for you.

Prof. Eibe · 28. April 2014, 19:59

I have started creating a web form with MySQL Storage.
We can list all codes and game_ids as you want.

Prof. Eibe · 28. April 2014, 21:11

Here is the URL:
wifi.profeibe.at/

Most things should work. I´m currently trying to fix a few remaining bugs.

Leseratte · 28. April 2014, 21:15

Maybe you can replace the textbox for the game code with a box where the user could choose the game out of a list. Then the players do not need to find out the game ID.

Prof. Eibe · 28. April 2014, 21:20

I thought about that, but I would need a complete list and I think the dropdown would be to large.
Instead I was thinking about a list with all codes on the bottom of the website but also here I would need this list.

But the input is checked with regular expressions. So the Friendcode has to look like a Friendcode and the Game ID has to be four capital letters. If this isn´t so all incorrect inputs are shown for verifying and only the correct ones are written into the database.

Leseratte · 28. April 2014, 21:21

Maybe you can validate all those friend codes before you put them in the Database?
wiki.tockdom.com/wiki/Friend_code

Prof. Eibe · 28. April 2014, 21:38

I think that should be possible. But I don´t understand everything on this side.

Implementing a check is no problem. But understanding it is^^

Wiimm · 28. April 2014, 21:47

Prof. Eibe schrieb:

Here is the URL:
wifi.profeibe.at/

Most things should work. I´m currently trying to fix a few remaining bugs.

I like it!
But I need a link to a text file (machine readable format). I plan to read the file 4 times a day, check the codes and add them to a never ending process, that collects friend lists.

Leseratte · 28. April 2014, 21:51

You simply have to implement the following function:

Quellcode

u64 pid_to_fc(u32 pid) {
if (pid == 0)
// behaviour observed in MKWii, more likely an error condition
return 0;
else {
u8 buffer[8], md5[16];
// buffer is pid in little endian, followed by RMCJ in little endian
buffer[0] = pid >> 0;
buffer[1] = pid >> 8;
buffer[2] = pid >> 16;
buffer[3] = pid >> 24;
buffer[4] = 'J';
buffer[5] = 'C';
buffer[6] = 'M';
buffer[7] = 'R';
// md5digest computes the digest of the second parameter and stores it in the first.
md5digest(md5, buffer, 8);
return ((u64)(md5[0] >> 1) << 32) | pid;
}
}

Alles anzeigen

(The values in buffer[4] to buffer [7] are the reverse game ID.

Then you take the Friend code (for example 1234-5678-9012), take away the first byte (so it becomes 3197704724), and then put this integer into the function. If the Friendcode is correct, the result is equal to the entered FC.

Prof. Eibe · 28. April 2014, 21:56

What structure should this file have? XML or something different?
Do you have an idea how it should look like?

Does it have to be a .txt file or can it be an explizit output of an php file?
And shall there be only new inputs or also one you have already got?

(Nachmal auf deutsch, weil ich mir bei meinem englisch grad ned 100% sicher bin:
Hast du irgendwelche Vorstellungen, wie das Testfile aufgebaut sein soll? Irgendeine Art XML oder?
Und soll es in ein TXT-File ausgegeben werden oder kann das auch die Textausgabe von einem PHP sein?)

@Leseratte: I will have a closer look on that.

Leseratte · 28. April 2014, 21:59

I think it can be an PHP output, but without any table tags, just a simple text.

I don't think XML or sth like this is needed, simply write a text output (no table) like this:

Quellcode

1234-5678-9012 RMCJ
2109-8765-4321 RMCJ
...

Wiimm · 28. April 2014, 22:03

Prof. Eibe schrieb:

What structure should this file have? XML or something different?
Do you have an idea how it should look like?

Plain text:

Quellcode

1234-5678-9012 RMCJ
9876-7654-4321 RSBJ
4321-8764-1234 RMCP

I use this format already to import data from the DNS redirect.

Prof. Eibe schrieb:

Does it have to be a .txt file or can it be an explizit output of an php file?
And shall there be only new inputs or also one you have already got?

Output of PHP is ok, if you use:
header("Content-Type: text/plain");
... and write the text only. Give me all, so no FC is lost if the import fails.

Prof. Eibe · 28. April 2014, 22:23

Ok, the Output of wifi.profeibe.at/show.php should now be plaintext.
Do you want a tabulator ("\t") or just a space between the code and the game id?

In which programming language is this code written?

Quellcode

u64 pid_to_fc(u32 pid) {
if (pid == 0)
// behaviour observed in MKWii, more likely an error condition
return 0;
else {
u8 buffer[8], md5[16];
// buffer is pid in little endian, followed by RMCJ in little endian
buffer[0] = pid >> 0;
buffer[1] = pid >> 8;
buffer[2] = pid >> 16;
buffer[3] = pid >> 24;
buffer[4] = 'J';
buffer[5] = 'C';
buffer[6] = 'M';
buffer[7] = 'R';
// md5digest computes the digest of the second parameter and stores it in the first.
md5digest(md5, buffer, 8);
return ((u64)(md5[0] >> 1) << 32) | pid;
}
}

Alles anzeigen

And can someone tell me how i get the pid?

Maschell · 28. April 2014, 22:38

FC -> PID

$pid= dechex($fc);
$pid= substr($pid,-8);
$pid= hexdec($pid);

Wiimm · 28. April 2014, 23:35

Prof. Eibe schrieb:

And can someone tell me how i get the pid?

Remove the minus signs from the FC, read the number as decimal with 12 digits and mask it with 0xffffffff.

Quellcode

$pid = (int)str_replace('-','',$fc) & 0xffffffff;

⇒ wiki.tockdom.com/wiki/Friend_code

A hint for php:
Try the pack() function to get the data for md5 processing:

Quellcode

$data = pack('V',$pid)."RMCP";

Prof. Eibe · 29. April 2014, 00:36

Thanks, I found already this post (Friend codes) which seams to do the same.
Yeah, that is also the way I´m trying to do it. But there seams to be a small Bug, that is hiding from me.

Wiimm · 29. April 2014, 00:44

Prof. Eibe schrieb:

Thanks, I found already this post (Friend codes) which seams to do the same.
Yeah, that is also the way I´m trying to do it. But there seams to be a small Bug, that is hiding from me.

1.) That code works only on 64 bit machines.
2.) Don't know, why people don't use the direct way without text-and-back conversions:

Quellcode

$pidhash = md5($fbuffer,true);
echo ($pidhash[0] >> 1) << 32) | $pid;

Prof. Eibe · 29. April 2014, 00:48

Wiimm schrieb:

1.) That code works only on 64 bit machines.

Hm I don´t know if thats the problem.
I found a different bug and now it works for MKWii Codes (it works for mine and it works for yours/Wiimms).
But it works only for the MKWii Codes. E.g. my SSBB Code gets a different result...

Wiimm · 29. April 2014, 00:52

Have you replaced RMCJ by RSBJ?

Prof. Eibe · 29. April 2014, 00:56

Of course respectivle with RSBP. It´s the second input field. And the last P is cut of and replaced with a J.

Maybe my Friendcode is false but I don´t think so. I will search for some other codes.

Prof. Eibe · 29. April 2014, 01:01

Super Smash Bros Brawl seems not to be compatible.
I tested @fragglepower and @eN-t s Codes too with RSBP as Gamecode and they didn´t work too.

On the other side @Quali s Animal Crossing Code is working.

Maybe this algorythm is only working with games developed directly from Nintendo.

Leseratte · 29. April 2014, 03:09

~~No, this should work with all games. But some of them don't use the Japanese ID. Hav you also tried RSBP, RSBE, RSBJ, RSBK?~~

Prof. Eibe · 29. April 2014, 09:57

The other game ids aren´t working too...

You can try it yourselfe. Just replace the gameid in the link with a different one:
wifi.profeibe.at/pidtofc.php?fc=2406-7270-0627&gameid=RSBP

Edit: Hm SSBB is not working with any kind of game ID like RSB* ...
wifi.profeibe.at/check.php?fc=2406-7270-0627&gameid=RSB

Wiimm · 29. April 2014, 12:13

My idea was:
First try the ID4 given by the user. If this fails, replace the last char by 'J'. If this fails too, the game code of the FC is wrong.

However, the game ID4 it is not really needed and only a way to filter wrong input and to help a user if he enter a wrong FC.

Quellcode

Quellcode

Quellcode

Quellcode

Quellcode

Quellcode

Quellcode

Teilen