Page 9 of 22

Re: New Database Model ZXDB

Posted: Sat Oct 05, 2019 8:33 pm
by 8BitAG
Einar Saukas wrote: Fri Oct 04, 2019 3:42 pm If either of you is willing to add any of the remaining titles, please let me know. Thank you!!!
Well, there are quite a lot of missing SAM titles that fall under my specialism of text adventures, most of which are listed on World of Sam, so I'll look into adding them to the database.

There's also our Sam Adventure Club magazine disks, as well as all the various compilations that we collaborated on with several homebrew publishers... These are things like compilations of Zenobi's Spectrum titles that have various tweaks (such as offering additional choices of fonts & user-defined colour schemes) and Sam-specific features such as disk saves... I'm not quite sure how these will slot into the database...

Re: New Database Model ZXDB

Posted: Mon Oct 14, 2019 12:27 am
by Einar Saukas
A new ZXDB update is available!

This version mostly contains bugfixes provided by [mention]druellan[/mention].

Re: New Database Model ZXDB

Posted: Mon Oct 21, 2019 12:27 pm
by PeterJ
Thanks [mention]Einar Saukas[/mention]

If everything goes to plan, I will update the site this evening.

Re: New Database Model ZXDB

Posted: Thu Oct 31, 2019 1:36 pm
by Einar Saukas
A new ZXDB update is available!

It includes new titles (thanks [mention]R-Tape[/mention]!), new hires inlays (thanks [mention]pavero[/mention]!), and new fixes (thanks [mention]druellan[/mention]!).

Re: New Database Model ZXDB

Posted: Thu Oct 31, 2019 1:49 pm
by R-Tape
Einar Saukas wrote: Thu Oct 31, 2019 1:36 pm A new ZXDB update is available!
Fast work Einar. Hope it wasn't too painful :-)

And clickety-click, that marks the 66th ZXDB update at SC (plus an as-yet uncounted number from BSCE*)

*before Spectrum Computing Era

Re: New Database Model ZXDB

Posted: Wed Nov 20, 2019 6:56 pm
by Einar Saukas
A new ZXDB update is available!

Once again it contains new titles (thanks [mention]R-Tape[/mention]!), new hires inlays (thanks [mention]pavero[/mention]!), and new fixes (thanks [mention]druellan[/mention]!).

Re: New Database Model ZXDB

Posted: Wed Nov 20, 2019 8:04 pm
by R-Tape
Stairway to heaven, update #67!*

Image

*plus however many were done BSCE if anyone wants to count.

EDIT - just realised that bingo calls stop at 90. Might have to think again on this.

Re: New Database Model ZXDB

Posted: Sun Dec 01, 2019 8:28 pm
by Einar Saukas
Another ZXDB update is available!

As usual, it contains new titles (thanks [mention]R-Tape[/mention]!), new hires inlays and/or instructions (thanks [mention]pavero[/mention]!), and new fixes (thanks [mention]druellan[/mention]!).

Re: New Database Model ZXDB

Posted: Mon Dec 23, 2019 5:50 am
by Einar Saukas
Another ZXDB update is now available!

Merry Xmas!!!

Re: New Database Model ZXDB

Posted: Wed Jan 22, 2020 12:41 am
by Einar Saukas
A new ZXDB update is available!

This time, it contains new titles (thanks [mention]R-Tape[/mention] and [mention]pavero[/mention]!), new hires inlays and instructions (thanks again [mention]pavero[/mention]!) and new fixes (thanks [mention]druellan[/mention]!)

Re: New Database Model ZXDB

Posted: Sun Feb 09, 2020 9:30 pm
by R-Tape
Just a quick note for new content fans: I won't be able to do my part of an update until near the end of Feb. I'm keeping track of everything that needs doing though, including [mention]Alessandro[/mention]'s and [mention]Ersh[/mention]'s updates. Cheers.

Re: New Database Model ZXDB

Posted: Fri Feb 21, 2020 10:47 pm
by Einar Saukas
In the meantime... A new ZXDB update is available!

Re: New Database Model ZXDB

Posted: Fri Feb 28, 2020 6:49 pm
by Einar Saukas
Another ZXDB update is now available!

It contains new titles (thanks both [mention]R-Tape[/mention] and [mention]pavero[/mention]!), new hires inlays and instructions (thanks again [mention]pavero[/mention]!) and more fixes (thanks [mention]druellan[/mention]!) as usual. Also the first few issues of Load'n'Run are now cataloged (thanks [mention]Alessandro[/mention]!)

Re: New Database Model ZXDB

Posted: Fri Feb 28, 2020 9:24 pm
by R-Tape
Einar Saukas wrote: Mon Dec 23, 2019 5:50 am Another ZXDB update is now available!

Merry Xmas!!!
I missed my chance in December to say update #69, Head over heels!

But we're on #72 now*, so the point is moot :?

*plus previous, as yet uncounted updates from BSCE.

Re: New Database Model ZXDB

Posted: Fri Feb 28, 2020 9:28 pm
by R-Tape
Ah! Got it:

Image

Mr Do!... Update number 72!

Re: New Database Model ZXDB

Posted: Wed Mar 04, 2020 5:37 am
by Einar Saukas
Yet another ZXDB update is already available!

It contains lots of Czech program files, new hires inlays and instructions (thanks [mention]pavero[/mention]!), new fixes (thanks [mention]druellan[/mention]!), and a few more catalogued issues of Load'n'Run (thanks [mention]Alessandro[/mention]!)

Also there's now a new classification group called High-Quality CSSCGC Software. If you are running a ZXDB-based site that filters search results based on the "is_crap" flag, please update your filter to consider this group instead. The "is_crap" flag still exists, but it will be removed in the next ZXDB update. Please see this post for more details.

Re: New Database Model ZXDB

Posted: Wed Mar 25, 2020 6:32 am
by Einar Saukas
A large ZXDB update is now available! As usual, many thanks to [mention]R-Tape[/mention], [mention]pavero[/mention], [mention]druellan[/mention], and [mention]Alessandro[/mention].

As announced in my last post, flag "is_crap" was removed from ZXDB. Now if anyone wants to find out if a certain title is CSSCGC, they must simply check if this title belongs to any CSSCGC group. In practice, this change will only affect site owners. If anyone needs assistance with this change, please let me know!

Re: New Database Model ZXDB

Posted: Wed Apr 29, 2020 5:28 am
by Einar Saukas
Another fairly large ZXDB update has been released!

Lots of thanks to [mention]R-Tape[/mention], [mention]pavero[/mention], [mention]druellan[/mention] and [mention]kolbeck[/mention]!!!

Re: New Database Model ZXDB

Posted: Wed Apr 29, 2020 7:42 am
by PeterJ
Thank you [mention]Einar Saukas[/mention] [mention]R-Tape[/mention], [mention]pavero[/mention], [mention]druellan[/mention] and [mention]kolbeck[/mention] .

The update has been applied.

Re: New Database Model ZXDB

Posted: Fri May 15, 2020 7:43 pm
by Einar Saukas
A new ZXDB update is available!

As usual, many thanks to [mention]R-Tape[/mention], [mention]pavero[/mention], [mention]druellan[/mention] and [mention]kolbeck[/mention]!

Re: New Database Model ZXDB

Posted: Fri May 15, 2020 8:08 pm
by PeterJ
Einar Saukas wrote: Fri May 15, 2020 7:43 pm A new ZXDB update is available!

As usual, many thanks to @R-Tape, @pavero, @druellan and @kolbeck!
Thanks everyone. Update applied.

Re: New Database Model ZXDB

Posted: Fri May 15, 2020 8:13 pm
by Einar Saukas
PeterJ wrote: Fri May 15, 2020 8:08 pm Thanks everyone. Update applied.
That was fast! Thank you!


PS: [mention]R-Tape[/mention] stay safe!

Re: New Database Model ZXDB

Posted: Fri May 15, 2020 8:29 pm
by PeterJ
Einar Saukas wrote: Fri May 15, 2020 8:13 pm That was fast! Thank you!
Its down to having a 10 second trip home from work (study to kitchen), rather than 2 hours each way!

Re: New Database Model ZXDB

Posted: Wed May 27, 2020 6:57 pm
by Einar Saukas
Another ZXDB update is now available!

This time we didn't have much time to add recently released titles, but there are new screens (some of them for the SAM Coupé and Next) and tons of additional information (mainly author credits).

Special thanks to [mention]PeterJ[/mention], [mention]druellan[/mention], [mention]pavero[/mention], and [mention]kolbeck[/mention]!

Re: New Database Model ZXDB

Posted: Wed May 27, 2020 7:19 pm
by Einar Saukas
A technical note for anyone running websites and apps based on ZXDB:

Column "magrefs.feature_id" is now obsolete and it will be removed in the next ZXDB update. There's already a separate table called "magreffeats" to store this information.

I doubt anyone is using this column, but I always provide notice in advance for all upcoming ZXDB changes, so everyone has enough time to update their systems accordingly!