Page 1 of 1

How to query the database independently from the game search

Posted: Thu Jan 19, 2017 2:34 pm
by iamaran
Example: return BBC Micro games without an attached image.

Thanks.

Re: How to query the database independently from the game se

Posted: Thu Jan 19, 2017 8:37 pm
by Alex
I don't know if these options are needed for the general user, but I also would like to have options like:

-Which games for the c64 don't have a year, company, author,genre etc
It would make it a lot easier to update the database where needed.

May be more interesting for general users:
-Which games are currently played by others (or not)
-Which games have a rating of 6 and above
Note that even when you rate a game with a 1 the site tells you liked playing it when you look at another game which you also have rated :)

Re: How to query the database independently from the game se

Posted: Fri Jan 20, 2017 11:42 pm
by Alastair
Alex wrote:Which games for the c64 don't have a year, company, author,genre etc
It would make it a lot easier to update the database where needed.
Alex, I can't help with most of the queries but you can sort search results tables by year simply by clicking on 'Year' at the top of the year column with a second click reversing the order, as shown in this example for the C64/128.

Re: How to query the database independently from the game se

Posted: Sat Jan 21, 2017 8:58 pm
by Alex
Ok the year was a bad example :) as you point out correctly this can be done, but I think Aran's point as well as mine is it would be nice to have some more tools of finding information gaps in the database.

Re: How to query the database independently from the game se

Posted: Tue Jan 24, 2017 4:55 pm
by Gunness
The search routine can't handle such queries - but I'll be happy to do an extract from the database and upload it somewhere appropriate. Then you can filter and sort in Excel, Google Docs or what have you. Would that be an option?

Re: How to query the database independently from the game se

Posted: Thu Jan 26, 2017 5:47 pm
by Alex
It would be for me, but don't hurry because soon I'll be off in search of some inca ruins :) but after Easter it would be fine.

Re: How to query the database independently from the game se

Posted: Sun Jan 29, 2017 4:46 pm
by iamaran
Yes, that would be good as a one-off. Whichever format is easiest for you is fine for me.

Re: How to query the database independently from the game se

Posted: Mon Jan 30, 2017 10:18 am
by Gunness
Alex wrote:It would be for me, but don't hurry because soon I'll be off in search of some inca ruins :) but after Easter it would be fine.
Oh but you can't - there are 320 entries in the queue and as you know, you're not allowed to go off on irregular activities until such entries have been removed!

.... but have a nice trip anyway :D

Re: How to query the database independently from the game se

Posted: Tue Jan 31, 2017 7:49 pm
by Alex
Gunness wrote: you're not allowed to go off on irregular activities until such entries have been removed!
Luckily trekking through Bolivia isn't an irregular activity for me :lol:
Thank you, but I'm still around for a few more weeks, just very occupied in the ultimate preparations.