Site Updates

Broken link? Feature request? Anything related to the Spectrum Computing website here.
Post Reply
User avatar
PeterJ
Site Admin
Posts: 848
Joined: Thu Nov 09, 2017 7:19 pm
Location: Surrey, UK

Site Updates

Post by PeterJ » Wed Mar 28, 2018 8:03 pm

**Update 28 March 2018**

As @Einar Saukas mentioned earlier, the latest ZXDB update contained a splendiferous amount of new content. The highlights are as follows:

Updates and new entries
  • 144 +3 Text Adventures authored with ZXZVM (thanks @Lady Eklipse )
  • Electronic Magazines: 21 issues of X-Magazine, 4 of X-Ray, 3 of ZX Chart, 10 ZX-City, 9 ZX-Club (thanks @Lady Eklipse )
  • Musical utilities: 15 ZX Chip, SoftPLAY, TimexPLAY, Coldsnap audio
  • Scene demos: 228 ZX-Chip, 36 Wlodek’s demos, 41 ZX-Tunes (Fax, Music, Song, Triumph)
  • 539 ZX Chip Vologodonsk compilations (thanks @Lady Eklipse )
  • Derby+ BASIC interpreter
  • Some new entries from CSS CGC 2009 & 2007 (thanks @Guesser and @serbalgi)
  • The Retroscene best BASIC game competition 2017, 11 games
  • The ZX-Spectrum 2017 BASIC Game Jam, 23 games
  • 36 scans of the card backers from 16/48 Magazine (thanks @PaulJ ). We had to reduce the file size but the originals will be put onto archive.org
  • All screens from The Complete Machine Code Tutor (thanks @Nomad)
  • 2009 CSS CGC Screenshots (thanks @Guesser)
  • 2007 CSS CGC Screenshots and corrections (thanks @@serbalgi

Apologies:
  • Ralf’s latest new/old games, Guesser's CGC corrections
A database does not contain the actual content (just links to it), so a huge amount of effort goes on quietly behind the scenes to upload all the content to the server in the right locations Thanks to everyone who contributes to this task (you know who you are!), and this week a special thanks to those of you who have taken on the task of the CSS CGC Screenshots.

If you want your name in lights next week, then help @R-Tape by picking a year.

Just a reminder that this update and the previous ones (at least for the last few weeks) are available on our new updates page:

app.php/site-updates

I think I need a lie down....
7 x
The Spectrum Computing Christmas 2018 charity prize draw is now live!

Ralf
Manic Miner
Posts: 904
Joined: Mon Nov 13, 2017 11:59 am
Location: Poland

Re: Site Updates

Post by Ralf » Wed Mar 28, 2018 8:40 pm

Incredible stuff!

Good to see that you started to add Russian demos and magazines. It's a mammoth task that even Martijn at the time of glory of WOS was afraid of ;) But now it seems that the work is progressing really nice.

Okay it may be not important for some people but there are also people (including me ;) ) who will appreciate that.
1 x

pavero
Microbot
Posts: 112
Joined: Sat Dec 09, 2017 11:49 pm
Location: Czech Republic
Contact:

Re: Site Updates

Post by pavero » Wed Mar 28, 2018 9:06 pm

PeterJ wrote:
Wed Mar 28, 2018 8:03 pm

[*]Electronic Magazines: 21 issues of X-Magazine, 4 of X-Ray, 3 of ZX Chart, 10 ZX-City, 9 ZX-Club (thanks @Lady Eklipse )
BTW, how can I find these magazines via search engine on the site? ;)
0 x

User avatar
PeterJ
Site Admin
Posts: 848
Joined: Thu Nov 09, 2017 7:19 pm
Location: Surrey, UK

Re: Site Updates

Post by PeterJ » Wed Mar 28, 2018 9:10 pm

Good point @pavero I need to add on to advanced search categories an entry for 'Electronic Magazines'. You can use the simple search (the main search box) to search for a magazine such as 'X-Magazine' in the meantime. I will check with @R-Tape, but the actual files will hopefully be included on the next update.

Peter
0 x
The Spectrum Computing Christmas 2018 charity prize draw is now live!

User avatar
Einar Saukas
Manic Miner
Posts: 524
Joined: Wed Nov 15, 2017 2:48 pm

Re: Site Updates

Post by Einar Saukas » Wed Mar 28, 2018 10:50 pm

Murphy's Law: We just added new files for over a thousand titles, but people only asks questions about the few files we didn't receive yet! :)

We should get these files in a few days, as part of our joint effort with ZX Pokemaster. They will be included soon, in one of the next ZXDB updates.
0 x

Ralf
Manic Miner
Posts: 904
Joined: Mon Nov 13, 2017 11:59 am
Location: Poland

Re: Site Updates

Post by Ralf » Thu Mar 29, 2018 3:38 pm

Okay, I click on button UPDATE on the website top.

And get redirected to this:

https://spectrumcomputing.co.uk/index.php?cat=301

Which doesn't show any of thousand new added titles.

Am I doing something wrong?

EDIT: I noticed it shows presumably titles by their release date. But if you add to the database something from let's say 1989 it will be buried deep and
you'll never see it, right?

Should it be sorted by addding to database time and not release time?
Last edited by Ralf on Thu Mar 29, 2018 3:43 pm, edited 1 time in total.
0 x

User avatar
PeterJ
Site Admin
Posts: 848
Joined: Thu Nov 09, 2017 7:19 pm
Location: Surrey, UK

Re: Site Updates

Post by PeterJ » Thu Mar 29, 2018 3:42 pm

@Ralf I will need to check, but I think the updates page is just games.

Peter
0 x
The Spectrum Computing Christmas 2018 charity prize draw is now live!

Ralf
Manic Miner
Posts: 904
Joined: Mon Nov 13, 2017 11:59 am
Location: Poland

Re: Site Updates

Post by Ralf » Thu Mar 29, 2018 3:44 pm

Hi Peter, just if you didn't notice:

I noticed it shows presumably titles by their release date. But if you add to the database something from let's say 1989 it will be buried deep and
you'll never see it, right?

Should it be sorted by addding to database time and not release time?

By the way, there was a lot of text games added recently.
0 x

User avatar
Einar Saukas
Manic Miner
Posts: 524
Joined: Wed Nov 15, 2017 2:48 pm

Re: Site Updates

Post by Einar Saukas » Thu Mar 29, 2018 4:22 pm

Ralf wrote:
Thu Mar 29, 2018 3:44 pm
I noticed it shows presumably titles by their release date. But if you add to the database something from let's say 1989 it will be buried deep and
you'll never see it, right?
Correct.

Ralf wrote:
Thu Mar 29, 2018 3:44 pm
Should it be sorted by addding to database time and not release time?
I don't know. Since there's now a page in SC detailing updates, wouldn't it be redundant? I suppose most users would be more interested to check "what are the most recent Spectrum games released?" instead of "what are the games most recently added to ZXDB?"

Perhaps SC should simply rename button "UPDATES" to something else, like "LATEST".

Anyway if SC wants to change this behaviour, then technically it's just a matter of ordering games by ID, somewhat like this:

Code: Select all

select ... from entries e
...
where e.id < 1000000
...
order by e.id desc;
Ralf wrote:
Thu Mar 29, 2018 3:44 pm
By the way, there was a lot of text games added recently.
Correct! :)
0 x

Ralf
Manic Miner
Posts: 904
Joined: Mon Nov 13, 2017 11:59 am
Location: Poland

Re: Site Updates

Post by Ralf » Thu Mar 29, 2018 4:30 pm

I suppose most users would be more interested to check "what are the most recent Spectrum games released?" instead of "what are the games most recently added to ZXDB?"
When Martijn made updates to WOS he showed stuff recently added to the site.

If there is a "new" game added to the site, it doesn't matter that much if it is from 1988 or 2018. Most of people didn't see it before so it's new for them even if it's old ;) And it's interesting to see it.
0 x

Post Reply