Help required for the new BBC games archive

feedback, questions and discussion relating to the Complete BBC Games Archive (beta site now open!)
User avatar
leenew
Posts: 3408
Joined: Wed Jul 04, 2012 3:27 pm
Location: Doncaster, Yorkshire

Re: Help required for the new BBC games archive

Postby leenew » Sat Jul 08, 2017 10:50 am

Hi John,
Apart from the ones that are already on bbcmicro.co.uk, that Lurkio linked to above, I sent Mick Brown (that chap that makes all the discs that end up on bbcmicro.uk) the following:

I am not sure what else is missing?
Anyone? :D

Lee.

**EDIT** Crossed posts with Lurkio!!

User avatar
bakoulis
Posts: 249
Joined: Wed Feb 08, 2012 9:45 pm
Location: Athens, Greece

Re: Help required for the new BBC games archive

Postby bakoulis » Sun Aug 13, 2017 9:03 am

How is possible to download (wget?) the whole site http://bbcmicro.co.uk/ for offline gaming for my vacations at a mountain without WiFi?
[-o<
2xElectron, 3xBBC B, BBC Master.
2xAcorn A310, A420/1, 2xA3000, 2xA3010, A3020, A4000, A5000.
2xRISC PC, Acorn Pocket Book, Acorn Pocket Book II.

John_Acorn
Posts: 19
Joined: Fri Jul 07, 2017 8:57 am

Re: Help required for the new BBC games archive

Postby John_Acorn » Sun Sep 03, 2017 11:02 am

Megaapocalypse?

User avatar
leenew
Posts: 3408
Joined: Wed Jul 04, 2012 3:27 pm
Location: Doncaster, Yorkshire

Re: Help required for the new BBC games archive

Postby leenew » Sun Sep 03, 2017 11:16 am


John_Acorn
Posts: 19
Joined: Fri Jul 07, 2017 8:57 am

Re: Help required for the new BBC games archive

Postby John_Acorn » Wed Sep 06, 2017 9:46 am

I couldn't find in the index :oops:

User avatar
leenew
Posts: 3408
Joined: Wed Jul 04, 2012 3:27 pm
Location: Doncaster, Yorkshire

Re: Help required for the new BBC games archive

Postby leenew » Wed Sep 06, 2017 10:42 am

Probably because it is 2 words "Mega Apocalypse" and the search doesn't find "Megaapocalypse" as 1 word... :-k
Lee.

User avatar
lurkio
Posts: 1292
Joined: Tue Apr 09, 2013 11:30 pm
Location: Doomawangara
Contact:

Re: Help required for the new BBC games archive

Postby lurkio » Wed Sep 06, 2017 10:59 am

Just a reminder for anyone (called Lee) who's interested that there's another thread to check for reports of tweaks that need to be made to (the JSBeeb aspect of) bbcmicro.co.uk:

:idea:

User avatar
pau1ie
Posts: 328
Joined: Thu May 10, 2012 9:48 pm
Location: Bedford

Re: Help required for the new BBC games archive

Postby pau1ie » Wed Sep 06, 2017 8:07 pm

bakoulis wrote:How is possible to download (wget?) the whole site http://bbcmicro.co.uk/ for offline gaming


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).

This is all stuff I will never get round to. The website source is on github. If you (Or anyone else) have the inclination to do something along these lines, I would be happy to incorporate the changes (So long as they don't risk taking the mickey with bandwidth etc). I didn't add the disc images to github as it looks difficult to remove them should it become necessary.

Regarding sizes it looks like there are around 2670 disc images. Most of these are 200K SSDs. This means about 521M. However, many of the SSDs are largely empty, so they compress nicely to about 35M. If a download option was to be offered it would seem zipping the files is the way to go, maybe a cron job to generate it once a day/week. As I say, I am not going to get round to this any time soon.
I'm working on http://bbcmicro.co.uk

User avatar
Arcadian
Posts: 2809
Joined: Fri Nov 24, 2000 12:16 pm
Contact:

Re: Help required for the new BBC games archive

Postby Arcadian » Tue Dec 12, 2017 2:05 am

Just a note for Lee really ...

I can confirm that Guardian of Doomsday and Bridge to the East (which are currently listed as 'Awaiting Categorisation') were commercial releases, as I owned the original cassettes.
For a "Complete BBC Games Archive" visit www.bbcmicro.co.uk

Image
ABug NORTH (Manchester) (19-21 January 2018)
ABug SOUTH (Hampshire) (1-3 June 2018)

User avatar
leenew
Posts: 3408
Joined: Wed Jul 04, 2012 3:27 pm
Location: Doncaster, Yorkshire

Re: Help required for the new BBC games archive

Postby leenew » Tue Dec 12, 2017 8:16 am

Updated :D
These games are still "Awaiting Categorisation" http://www.bbcmicro.co.uk/index.php?rt_W=on&search=

Lee.

User avatar
Arcadian
Posts: 2809
Joined: Fri Nov 24, 2000 12:16 pm
Contact:

Re: Help required for the new BBC games archive

Postby Arcadian » Thu Dec 14, 2017 7:43 pm

Just noticed that a little bug has crept in - if you click either a publisher or a year, you get an SQL error:

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
)
For a "Complete BBC Games Archive" visit www.bbcmicro.co.uk

Image
ABug NORTH (Manchester) (19-21 January 2018)
ABug SOUTH (Hampshire) (1-3 June 2018)

User avatar
pau1ie
Posts: 328
Joined: Thu May 10, 2012 9:48 pm
Location: Bedford

Re: Help required for the new BBC games archive

Postby pau1ie » Fri Dec 15, 2017 10:16 am

Arcadian wrote:Just noticed that a little bug has crept in

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.
I'm working on http://bbcmicro.co.uk

User avatar
pau1ie
Posts: 328
Joined: Thu May 10, 2012 9:48 pm
Location: Bedford

Re: Help required for the new BBC games archive

Postby pau1ie » Sat Dec 16, 2017 7:31 pm

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.
I'm working on http://bbcmicro.co.uk

User avatar
leenew
Posts: 3408
Joined: Wed Jul 04, 2012 3:27 pm
Location: Doncaster, Yorkshire

Re: Help required for the new BBC games archive

Postby leenew » Sun Dec 17, 2017 2:07 am

Excellent work Paul.
Quick question...
When you click on a game to get to the details page, how hard would it be to make more of the fields clickable? e.g. the author or the genre?
Thanks :D
Lee.

User avatar
tricky
Posts: 1922
Joined: Tue Jun 21, 2011 8:25 am
Contact:

Re: Help required for the new BBC games archive

Postby tricky » Sun Dec 17, 2017 9:52 am

I was wondering about having a "discuss" link from the game's page to a thread on stardot. To avoid adding thousands of threads, maybe it could create the thread if it doesn't already exist. It could use some of the thread details to create a forum friendly hierarchy.

User avatar
pau1ie
Posts: 328
Joined: Thu May 10, 2012 9:48 pm
Location: Bedford

Re: Help required for the new BBC games archive

Postby pau1ie » Sun Dec 17, 2017 8:41 pm

leenew wrote:how hard would it be to make more of the fields clickable? e.g. the author or the genre?


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.

tricky wrote:wondering about having a "discuss" link from the game's page to a thread on stardot.

I asked if this can be done with PHPBB. I might investigate if I get a chance.
I'm working on http://bbcmicro.co.uk

User avatar
pau1ie
Posts: 328
Joined: Thu May 10, 2012 9:48 pm
Location: Bedford

Re: Help required for the new BBC games archive

Postby pau1ie » Sun Dec 17, 2017 11:44 pm

leenew wrote:how hard would it be to make more of the fields clickable?


lurkio wrote:Can the items on the Details page for each game be made clickable?


Ok, that's done. Let me know if I have broken anything...
I'm working on http://bbcmicro.co.uk

User avatar
leenew
Posts: 3408
Joined: Wed Jul 04, 2012 3:27 pm
Location: Doncaster, Yorkshire

Re: Help required for the new BBC games archive

Postby leenew » Sun Dec 17, 2017 11:54 pm

:shock:
I will have a good play in the morning!

Lee.


Return to “bbcmicro.co.uk”

Who is online

Users browsing this forum: No registered users and 1 guest