RestlessRodent Posted November 9, 2012 How are the idgames numeric IDs determined? I presume the fullsort.gz is used, in reverse order with only the lines containing ZIP extensions, then numerical numbers are built based upon those? 0 Share this post Link to post
exl Posted November 9, 2012 I assume that whenever the database is updated with what's new in fullsort, it just continues counting ids from the highest one that is already in the database. 0 Share this post Link to post
Bloodshedder Posted November 9, 2012 http://dev.mysql.com/doc/refman/5.0/en/example-auto-increment.html 0 Share this post Link to post
RestlessRodent Posted November 9, 2012 Bloodshedder said:http://dev.mysql.com/doc/refman/5.0/en/example-auto-increment.html Would be it be possible to get an exported list of all the Ids and their associated upload templates? 0 Share this post Link to post
hex11 Posted November 10, 2012 YOu making a front-end WAD launcher or something? 0 Share this post Link to post
RestlessRodent Posted November 10, 2012 hex11 said:YOu making a front-end WAD launcher or something? Well, I am planning on adding an idgames:// protocol-ish -file support in ReMooD, along with a type of WAD lookup server (like DNS) to request WAD files. 0 Share this post Link to post
hex11 Posted November 10, 2012 That id field isn't canonical anyway, and in fact I've followed some links to doomworld.com/idgames for invalid id's before (links from old discussions or reviews from other PWADs that mention another id). You'll probably have to just build your own index directly from the /idgames mirrors (parsing the fullsort file to get a list of dirname+basename of each file should do the trick). That's directly from the canonical source, so it has to be valid. Too bad this api doesn't seem to have a "search" function, or even a straight one-to-one id lookup based on its full pathname. The closest thing seems to be the "getfiles" function, that you'd have to parse to find the id of the file you're interested in, and then make another call to get that file's info (I'm guessing you're after the ratings & comments, since everything else is available from /idgames HTTP/FTP mirrors). 0 Share this post Link to post
MTrop Posted November 14, 2012 A search function has been completed. Now, I'm just waiting for Bloodshedder to apply it. I sent him the files to update. 0 Share this post Link to post
MTrop Posted November 17, 2012 So, hey - search function's up. Go nuts. 0 Share this post Link to post
Bloodshedder Posted November 17, 2012 hex11 said:or even a straight one-to-one id lookup based on its full pathname. I actually added this to the regular site several months ago but never told anyone. e.g. http://www.doomworld.com/idgames/?file=/levels/doom2/megawads/strain10.zip 0 Share this post Link to post