Magazines in ZXDB

This is the place for general discussion and updates about the ZXDB Database. This forum is not specific to Spectrum Computing.

Moderator: druellan

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

Re: Magazines in ZXDB

Post by PeterJ »

I'm happy to make a start with Sinclair User [mention]Einar Saukas[/mention] if option one turns out to be the preferred solution.
User avatar
Stefan
Manic Miner
Posts: 809
Joined: Mon Nov 13, 2017 9:51 pm
Location: Belgium
Contact:

Re: Magazines in ZXDB

Post by Stefan »

Einar Saukas wrote: Sun Mar 29, 2020 9:29 pm
  • Or each site could detect automatically if a link to the next page is valid, before displaying it (as mentioned here).
So, being pragamatic, this will solve all problems, if instead of looking ahead one page a second page ahead is also attempted before giving up and considering the magazine complete.
User avatar
Einar Saukas
Bugaboo
Posts: 3100
Joined: Wed Nov 15, 2017 2:48 pm

Re: Magazines in ZXDB

Post by Einar Saukas »

PeterJ wrote: Sun Mar 29, 2020 9:47 pm I'm happy to make a start with Sinclair User @Einar Saukas if option one turns out to be the preferred solution.
Thanks a lot for the offer! However I prefer to avoid doing it now, concentrating our efforts on much more important tasks instead.

For instance, processing the remaining CSSCGC entries, and taking screenshots of other games that are still missing them.
User avatar
Einar Saukas
Bugaboo
Posts: 3100
Joined: Wed Nov 15, 2017 2:48 pm

Re: Magazines in ZXDB

Post by Einar Saukas »

Stefan wrote: Sun Mar 29, 2020 9:50 pm
Einar Saukas wrote: Sun Mar 29, 2020 9:29 pm
  • Or each site could detect automatically if a link to the next page is valid, before displaying it (as mentioned here).
So, being pragamatic, this will solve all problems, if instead of looking ahead one page a second page ahead is also attempted before giving up and considering the magazine complete.
Right! :)
User avatar
PeterJ
Site Admin
Posts: 6873
Joined: Thu Nov 09, 2017 7:19 pm
Location: Surrey, UK

Re: Magazines in ZXDB

Post by PeterJ »

Einar Saukas wrote: Mon Mar 30, 2020 12:04 am
PeterJ wrote: Sun Mar 29, 2020 9:47 pm I'm happy to make a start with Sinclair User @Einar Saukas if option one turns out to be the preferred solution.
Thanks a lot for the offer! However I prefer to avoid doing it now, concentrating our efforts on much more important tasks instead.

For instance, processing the remaining CSSCGC entries, and taking screenshots of other games that are still missing them.
Thanks Einar,

For obvious reasons I have more free time currently! I will continue with the Crap Games entries.
User avatar
StooB
Dynamite Dan
Posts: 1076
Joined: Mon Oct 22, 2018 11:03 am
Contact:

Re: Magazines in ZXDB

Post by StooB »

PeterJ wrote: Sun Mar 29, 2020 9:47 pm I'm happy to make a start with Sinclair User @Einar Saukas if option one turns out to be the preferred solution.
For a magazine like Sinclair User, which always had an advert on the back cover, then the last page can be found by looking up the highest numbered magazine reference for that issue. There's no need to do it manually.
User avatar
PeterJ
Site Admin
Posts: 6873
Joined: Thu Nov 09, 2017 7:19 pm
Location: Surrey, UK

Re: Magazines in ZXDB

Post by PeterJ »

Thanks [mention]StooB[/mention],

Good point.

I could write an SQL script for that. Similar for Crash, and I'm sure the majority of mainstream titles.

I was also thinking of the old WoS magazine viewer which I believe had the data in. I would need to check that though.
Post Reply