Page 1 of 2

Steam to WSGF game compare

Posted: 05 May 2013, 19:19
by LuckyNoS7evin
So i moved my initial post here instead of the WSGF Medals for Steam [Chrome/Firefox Extension] thread for the reason being I'm going to be posting more over the next couple of days so here is the oiginal post which is now deleted from the other thread.


Good evening gents,

Delphium pointed me in this direction as I've been working on a system for matching my steam library against WSGF. This app (will be an app later it's currently a bit of hacked together code) will then be able to display "you have these games in your library here is the WSGF ratings" and "you have these games but they don't match WSGF you may be able to contribute"

I started a thread here http://www.wsgf.org/forums/viewtopic.php?f=59&t=25668 which has started well however this is the current issues I'm working on and probably need help or info from CJM and Brett (Delphium told me you two)

Issue 1: When I access http://www.wsgf.org/mgl/xml it seems to only have 82 nodes, it was mentioned that it only displays games with Steam IDs so completely understand

Issue 2: some of those 82 nodes still don't show Steam ID, it seems to be blank

Then this is the next phase, questions

Question 1: Is there any chance on an xml format version like the existing one that isn't restricted by steam id?

Question 2: if not could I get sent a version as to code the system I'm planning on doing however handing it over at the end for WSGF to "install" and look at

Finally something I've done for you (possibly if you haven't yet)

I took the MGL and literally copy/pasted all titles into a CSV, yes all 1279, from there I did a title match on the Steam Master Games List. This was a simple title match but was able to match 503 games with their steam ID, the resulting file is here however probably not in a useful format.

I'm happy to code the rest of my project based on these 500 matches as it will give me a good start point to match my library against WSGF.

I just hope you can help with the Questions and Issues above and answer this final question:-

Do you want me to write the matching system as described at the start or should I stop now :)

Re: Steam to WSGF game compare

Posted: 05 May 2013, 19:54
by LuckyNoS7evin
So tonight during a bit of dev time I thought I would convert my original Title: SteamID text filr and ALL WSGF csv into a joined up xml file.

This XML file contains all copy pasted titles from the MGL and their steam ids based on title match only, if you want this file its here http://s7evin.azurewebsites.net/AllWSGFMatched.xml

So after that I took the matched by steam ID, matched by title and no matches from my own steam ID and created a little mock application......

So here it is....

http://s7evin.azurewebsites.net/

so you need your steam ID..... if you don't type one then it uses mine (for now) so you can test it if you just click get games

skipclarke = 76561197987549704

delphiuum = 76561197995599711

CJM = 76561197960503379

Please this is a work in progress, I know a lot of steam IDs are missing, but this is what I have so far, if I was able to get the rating in my copypasted xml I would have shown that for matched games.

Those that are matched by title didn't match the first time round for some reason but show you haw it would work if you didn't have steam ID but it matched on Title (you could put a note saying we matched this game on title, the steam ID is {xxxxx} contribute to WSGF :))

Re: Steam to WSGF game compare

Posted: 05 May 2013, 23:18
by LuckyNoS7evin
Added the Grades from WSGF, again this was taken from Saturday 4th May and is a copy so will not update at the moment, if the WSGF admins want to include this in the site it would be awesome, this was mainly just for me to see where WSGF had gaps.

Unfortunately with the current MGL xml being those with Steam IDs and currently at 82 nodes I had to do a bit of hack and slash to get where I am now.

If you want to know it's in C# using Linq-2-Xml at the moment, I thought I would get the concept done before trying to do this in php and you guys would probably want to hook straight to DB rather than using xml then messing with that in php (steam provides xml or json for the matching)

Re: Steam to WSGF game compare

Posted: 06 May 2013, 07:23
by Wijkert
Very useful site. Great work! :onethumb:

Re: Steam to WSGF game compare

Posted: 06 May 2013, 11:20
by Delphium
All I get... when the website is online, is "Oh noes! Error happened!" upon entering in a game. :(

Re: Steam to WSGF game compare

Posted: 06 May 2013, 11:56
by LuckyNoS7evin
Delphium wrote:All I get... when the website is online, is "Oh noes! Error happened!" upon entering in a game. :(


oh that's odd

you don't get this?

orThis.PNG
orThis.PNG (15.78 KiB) Viewed 11456 times


or

this.PNG
this.PNG (458.19 KiB) Viewed 11461 times


Wonder what's up with that? will have a look after getting in this afternoon

Re: Steam to WSGF game compare

Posted: 06 May 2013, 14:07
by Haldi
Same Problem als Delphium, when i enter skyrim and press get Game i get a Oh noes.

Re: Steam to WSGF game compare

Posted: 06 May 2013, 14:31
by LuckyNoS7evin
Haldi wrote:Same Problem als Delphium, when i enter skyrim and press get Game i get a Oh noes.



Ah okay, the idea is not to put individual games in, the idea is to put your steam ID in.

For example my steam ID is 76561198040969636

To get your steam ID use http://steamidconverter.com/

To use the converter type in your profile URL for example mine is http://steamcommunity.com/id/LuckyNoS7evin/ and then take the value of steamID64, type this into the text box on my site and there you go your steam library..

I'm not sure if your steam profile has to be public for it to pick up all your games, I haven't tested this.

Re: Steam to WSGF game compare

Posted: 06 May 2013, 15:28
by Delphium
LuckyNoS7evin wrote:the idea is to put your steam ID in.

Ahh, that worked.
Cool :)

Re: Steam to WSGF game compare

Posted: 06 May 2013, 15:33
by LuckyNoS7evin
Delphium wrote:
LuckyNoS7evin wrote:the idea is to put your steam ID in.

Ahh, that worked.
Cool :)


Ah but now you have it working you have to tell me what you think :)

Re: Steam to WSGF game compare

Posted: 06 May 2013, 18:04
by Nox Deleo
Works sweet for me, save for a large number of non-matches which of course you can't help. That said maybe another option would be for users to go around all the DR's updating Steam ID's for non-matches...I mean, you couldn't have made it much easier having listed them all out like that.

Re: Steam to WSGF game compare

Posted: 06 May 2013, 18:20
by LuckyNoS7evin
Nox Deleo wrote:Works sweet for me, save for a large number of non-matches which of course you can't help. That said maybe another option would be for users to go around all the DR's updating Steam ID's for non-matches...I mean, you couldn't have made it much easier having listed them all out like that.


Ye I'm going to try and get in contact with Brett and CJM as Delphium mentioned they were the guys to talk to about Steam IDs and matching, the process of getting this working has been very manual up til now which I hope to correct.

The idea is to get people to update DRs with Steam IDs as we go however I would like to get a good base to start with as it's a little lacking up to now. This is not a bitch at the guys as I know they do this in their spare time it's more of an I'm happy to help in any way I can to bring this and other projects forward.

Re: Steam to WSGF game compare

Posted: 06 May 2013, 21:17
by Delphium
Indeed Brett and CJM worked on something to do a mass import, im hoping they can chime in and explain some.

Users can of cause help us update these manually...
To update the steamID for a game simply find the game in the MGL or follow the Enhanced steam plugin to the games "Detailed Report" page.

For example for Need for Speed...

Find the game.. http://www.wsgf.org/mgl?title_op=contai ... +for+speed
Visit DR page.. http://www.wsgf.org/dr/need-speed-carbon
Click 'Edit'.. http://www.wsgf.org/node/10/edit

Look for "Affiliate (Store) Links" and click to expand, there it will list all Steam ID's associated with the game for which you may add new/remove/update exisiting values.

Save the DR for this to then take effect, note that it may take a little while for the update to propagate through to the xml list of http://www.wsgf.org/mgl/xml/ due to caching.

:cheers:

Re: Steam to WSGF game compare

Posted: 06 May 2013, 21:39
by CrackerJackMack
Cache is now invalidated when DR's are saved. So that update should be instant and the /mgl/xml doesn't seem to have all the games, I'm troubleshooting to see if it's a view thing or maybe we didnt' import the data right.

Re: Steam to WSGF game compare

Posted: 07 May 2013, 16:55
by LuckyNoS7evin
CrackerJackMack wrote:Cache is now invalidated when DR's are saved. So that update should be instant and the /mgl/xml doesn't seem to have all the games, I'm troubleshooting to see if it's a view thing or maybe we didnt' import the data right.



Just something you may want to know... I started adding steamIDs and of course started with A :) I got to "Age of Conan: Hyborian Adventures" I went to edit and it already had 2 steamIDs, checked the original MGL xml and it was there correctly with both entries, I added my 3rd and all three are there.

So next I had/wanted to find out why games like Warframe was in the list with no steamID. This is a good one for you, the steamID for Warframe was 0 so changed it to 230410, the reason it's 0 is because this is the default for a new game added to the MGL.

I guess the next thing is to figure out if you imported the steamIDs correctly and that's why there are/were 82 nodes with steamids. :)

hope this helps

S7evin

Re: Steam to WSGF game compare

Posted: 07 May 2013, 19:03
by CrackerJackMack
Ah ha! Thanks for confirming that. So now we need to look at why those steam ID's aren't linked up like they should be, but are when you save them.

Re: Steam to WSGF game compare

Posted: 07 May 2013, 20:46
by Wijkert
Ps you are going ham on those widescreen reports :twothumb:

Re: Steam to WSGF game compare

Posted: 07 May 2013, 20:57
by LuckyNoS7evin
Wijkert wrote:Ps you are going ham on those widescreen reports :twothumb:


:D Did As and Bs I think I'll stop for now, did post a sorry in off topic :) As mentioned some of them didn't have threads so when I updated the threads were created :) I have only added 2 games to the MGL, I'm not going to take credit for all the DRs, it's just the fact I was updating the Steam IDs :geek:

Re: Steam to WSGF game compare

Posted: 08 May 2013, 03:43
by Timobkg
This looks great so far, thanks!

Re: Steam to WSGF game compare

Posted: 24 May 2013, 01:10
by Uhuru NUru
LuckyNoS7evin wrote:
I'm not sure if your steam profile has to be public for it to pick up all your games, I haven't tested this.


I can confirm

Profile Status: must be public

then will work even if

Inventory: is Private

will not work at all if

Profile Status: is not public