ZXDB and ZX-Art

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
Joefish
Rick Dangerous
Posts: 2042
Joined: Tue Nov 14, 2017 10:26 am

Re: ZXDB and ZX-Art

Post by Joefish »

moroz1999 wrote: Wed Apr 10, 2019 8:26 pm In ideal world - yes. But, unfortunately, there we have not many resources to deal with this question, so the current way is:
1. If something is denied for WoS/ZXDB, then it's not distributed on ZX-Art.
2. If something is undefined for WoS/ZXDB, then it's distributed on ZX-Art the same way as it's distributed on WoS.
3. If something is allowed for WoS/ZXDB, then it's distributed on ZX-Art until the first demand on removal.

That's not ideal, but unfortunately it's either this way or no way at all.
So when an item is specifically marked, for example:
"Redistribution of this game is only permitted on sites and services with the explicit consent of the author".
You're not even going to ask a signed up member of your own site if they mind? *ahem* :mrgreen:
User avatar
moroz1999
Manic Miner
Posts: 329
Joined: Fri Mar 30, 2018 9:22 pm

Re: ZXDB and ZX-Art

Post by moroz1999 »

Sorry, couldn't have traced everything :D
I've marked the game on ZX-Art as "denied" currently - there was no intention to make any harm or demotivate anybody, it was automatically imported and since it has an "allowed" status, it was not automatically hidden for downloading/playing online.

This made me thinking about a new type of permission in ZXDB database: someting like "Allowed explicitly on ZXDB", so I could automatically mark such releases as denied on ZX-Art with an external link to a permitted download.
User avatar
PeterJ
Site Admin
Posts: 6859
Joined: Thu Nov 09, 2017 7:19 pm
Location: Surrey, UK

Re: ZXDB and ZX-Art

Post by PeterJ »

[mention]moroz1999[/mention]

I will email you a list.

Peter
User avatar
Joefish
Rick Dangerous
Posts: 2042
Joined: Tue Nov 14, 2017 10:26 am

Re: ZXDB and ZX-Art

Post by Joefish »

I didn't mean that! I just meant you could have asked!
Argggh!

Yes, OK, you can host Buzzsaw+ (Foxton Locks Mix) and Buzzsaw+ (Dim Sun Edition) on ZXArt. I like the site!
But please post the same message about downloading and hosting permissions.

You probably have other members who are coders you could ask too...
User avatar
moroz1999
Manic Miner
Posts: 329
Joined: Fri Mar 30, 2018 9:22 pm

Re: ZXDB and ZX-Art

Post by moroz1999 »

Seems like releases.releases_seq has been changed after all? So my key strings based on entry_id + release_seq are now wrong and pointing to wrong releases?
This is why ID number is better than some combinations of properties. You can assign another entry_id, you can rearrange releases by changing release_seq, but releases would have stayed the same.
I will now have to figure out the way to reassign automatically all releases from ZXDB to releases on ZXArt. And that's not really easy task, because I cannot just delete everything and create it from scratch: the information has already been aggregated from other databases and sources.
I think I will stop rechecking the whole database and only add the new entries, that's too frustrating to newly invent the same wheel after almost every update of ZXDB.
User avatar
Einar Saukas
Bugaboo
Posts: 3070
Joined: Wed Nov 15, 2017 2:48 pm

Re: ZXDB and ZX-Art

Post by Einar Saukas »

moroz1999 wrote: Sat Nov 23, 2019 6:29 pmSeems like releases.releases_seq has been changed after all? So my key strings based on entry_id + release_seq are now wrong and pointing to wrong releases?
My apologies. Old WoS had quite a few cases of incorrectly ordered releases, such as a re-release #3 from 1984 and re-release #4 from 1983. They were all fixed a while ago at once.

I can give you a list of all these changes, so you can easily update your database accordingly.

moroz1999 wrote: Sat Nov 23, 2019 6:29 pmThis is why ID number is better than some combinations of properties. You can assign another entry_id, you can rearrange releases by changing release_seq, but releases would have stayed the same.
If I added a single ID to all releases now, I don't think it would help. Reordering releases won't happen again, all incorrectly ordered releases were already done. Except for this, every other change related to releases are either merging two releases, splitting a release in two, replacing a publisher, moving a publisher to another release, etc.
Post Reply