The site is database driven, so not really possible as pages are generated. I suppose you are most interested in the disc images. I can see the value in allowing download of these and maybe generating a menu for the datacentre, and an MMB file (Though there are too many disc images, so some way of deciding which ones should go on it).bakoulis wrote:How is possible to download (wget?) the whole site http://bbcmicro.co.uk/ for offline gaming
Code: Select all
Error:
SQL: [342] select SQL_CALC_FOUND_ROWS g.*, sum(d.downloads) as dl, sum(d.gamepages) as gp from games g
left join game_downloads d on g.id = d.id WHERE id in (select gameid from games_publishers gp where gp.pubid = :pubid)
AND reltype in (select id from reltype where selected = 'Y')
group by g.id order by dl desc, gp desc LIMIT :limit OFFSET :offset
Params: 3
Key: Name: [6] :pubid
paramno=-1
name=[6] ":pubid"
is_param=1
param_type=2
Key: Name: [6] :limit
paramno=-1
name=[6] ":limit"
is_param=1
param_type=1
Key: Name: [7] :offset
paramno=-1
name=[7] ":offset"
is_param=1
param_type=1
Array
(
[0] => 23000
[1] => 1052
[2] => Column 'id' in IN/ALL/ANY subquery is ambiguous
)Sorry, that always breaks. It is an old way of doing things, which is different to the way the rest of the website works. I need to update it to use the same search as everything else. I will have a look over the weekend.Arcadian wrote:Just noticed that a little bug has crept in
OK I have fixed it so it uses the same code as everything else (You can see it does a search for you)q, so it works again now, and should be more robust in the future.Arcadian wrote:Just noticed that a little bug has crept in
I was thinking the same. It is doable. Actually Lurkio asked the same thing a couple of months ago when it was all getting a bit much for me, so I didn't do it then. I will look in to it.leenew wrote:how hard would it be to make more of the fields clickable? e.g. the author or the genre?
I asked if this can be done with PHPBB. I might investigate if I get a chance.tricky wrote:wondering about having a "discuss" link from the game's page to a thread on stardot.
leenew wrote:how hard would it be to make more of the fields clickable?
Ok, that's done. Let me know if I have broken anything...lurkio wrote:Can the items on the Details page for each game be made clickable?
Wholeheartedly agree with this. Thanks Paul for adding search by author. I've been aware my two games have been on there for a while, but never stated how much I appreciate the work done on creating this site. Thank you!MartinB wrote:Ha! I'm not much of a gamer myself but have kept an admiring watching brief on this project and of course, the grandkids love it!
Anyway, just on a random whim, this evening I typed my name into the search box and lo!, my one claim to fame (albeit a mere shadow of the bulk on offer) appeared! Yay! My life is complete and your work here is done gents - please take a big admiring pat on the back from me and mine....
It's good to know you're being appreciated buddy I even cannot think without many people on this forum I would be completely clueless, you Paul, KarateEd, DaveH, 1024MAK and of course leenew for introducing me in 2015 when I bought his disc drive on ebayMartinB wrote:Anyway, just on a random whim, this evening I typed my name into the search box and lo!, my one claim to fame (albeit a mere shadow of the bulk on offer) appeared! Yay! My life is complete and your work here is done gents - please take a big admiring pat on the back from me and mine....
Thanks for the appreciation. I am really proud of the search actually for this very reason.MartinB wrote:my one claim to fame ... appeared!
