Licence information

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
Rorthron
Dynamite Dan
Posts: 1644
Joined: Sun Nov 12, 2017 10:35 pm

Licence information

Post by Rorthron »

The database contains a lot of information labelled "licence information". However, most of the time the information seems not to describe a licence at all. Typically the relationship is that of an unauthorised clone.

For example, Beaky and the Egg Snatchers is listed as a licensed version of Joust, which it obviously is not. Kong is listed as a licensed version of Donkey Kong, which it isn't. Etc.

There are some cases where the information does describe a licence, such as Donkey Kong itself. But such titles are mixed in with the unauthorised clones.

There are multiple ways to correct this. The licence information could be deleted for unauthorised clones, but this would involve a lot of work and lose a lot of valuable information. The information could be divided between unauthorised and licensed copies, but again this involves trawling through the database and correcting it.

The best solution, I think, is to rename the information to indicate that the game is a derivative and leave it unspecified whether it is authorised. (If needed an authorised/unauthorised flag could be added later.)

What do other people think?
User avatar
druellan
Dynamite Dan
Posts: 1466
Joined: Tue Apr 03, 2018 7:19 pm

Re: Licence information

Post by druellan »

On WOS there are two different columns, one "Tie-in licence", related to official conversions, and "Inspired by" more related to clones or non-official conversions, but looking at the tables on the ZXDB, I'm not sure if the database has something similar to "Inspired by".
User avatar
StooB
Dynamite Dan
Posts: 1073
Joined: Mon Oct 22, 2018 11:03 am
Contact:

Re: Licence information

Post by StooB »

druellan wrote: Sun Jan 27, 2019 2:27 am I'm not sure if the database has something similar to "Inspired by".
It does: entries.was_inspired.
User avatar
Rorthron
Dynamite Dan
Posts: 1644
Joined: Sun Nov 12, 2017 10:35 pm

Re: Licence information

Post by Rorthron »

StooB wrote: Sun Jan 27, 2019 9:59 am
druellan wrote: Sun Jan 27, 2019 2:27 am I'm not sure if the database has something similar to "Inspired by".
It does: entries.was_inspired.
Then SC is not displaying it correctly.
User avatar
PeterJ
Site Admin
Posts: 6855
Joined: Thu Nov 09, 2017 7:19 pm
Location: Surrey, UK

Re: Licence information

Post by PeterJ »

Hi,

Is that what you would like? If so I will tidy it up some more. As [mention]StooB[/mention] says there is a 'In Inspired' flag:

Image

'1' indicates yes, but I can change the text to something more meaningful.
User avatar
Einar Saukas
Bugaboo
Posts: 3070
Joined: Wed Nov 15, 2017 2:48 pm

Re: Licence information

Post by Einar Saukas »

I think modifying the section name will look better. Kinda like:

Code: Select all

if ($was_inspired == '0')
    echo 'TIE-IN LICENCE';
else
    echo 'INSPIRED BY';
instead of LICENCE INFORMATION.
User avatar
PeterJ
Site Admin
Posts: 6855
Joined: Thu Nov 09, 2017 7:19 pm
Location: Surrey, UK

Re: Licence information

Post by PeterJ »

Einar Saukas wrote: Sun Jan 27, 2019 1:17 pm I think modifying the section name will look better. Kinda like:

Code: Select all

if ($was_inspired == '0')
    echo 'TIE-IN LICENCE';
else
    echo 'INSPIRED BY';
instead of LICENCE INFORMATION.
Done [mention]Einar Saukas[/mention]

Image

I'm just hoping that no title includes more than one licence row, otherwise it will break.
User avatar
PeterJ
Site Admin
Posts: 6855
Joined: Thu Nov 09, 2017 7:19 pm
Location: Surrey, UK

Re: Licence information

Post by PeterJ »

[mention]Rorthron[/mention]

Now the Ocean version of Kong shows correctly as a Tie-In license:

https://spectrumcomputing.co.uk/index.p ... 96&id=1437
User avatar
Einar Saukas
Bugaboo
Posts: 3070
Joined: Wed Nov 15, 2017 2:48 pm

Re: Licence information

Post by Einar Saukas »

PeterJ wrote: Sun Jan 27, 2019 2:35 pmI'm just hoping that no title includes more than one licence row, otherwise it will break.
Nope.

Thanks!
User avatar
Rorthron
Dynamite Dan
Posts: 1644
Joined: Sun Nov 12, 2017 10:35 pm

Re: Licence information

Post by Rorthron »

Great. I think the new presentation is much better. Thanks.
User avatar
StooB
Dynamite Dan
Posts: 1073
Joined: Mon Oct 22, 2018 11:03 am
Contact:

Re: Licence information

Post by StooB »

Einar Saukas wrote: Sun Jan 27, 2019 3:44 pm
PeterJ wrote: Sun Jan 27, 2019 2:35 pmI'm just hoping that no title includes more than one licence row, otherwise it will break.
Nope.

Thanks!
There's always one.

https://spectrumcomputing.co.uk/index.p ... 96&id=2546
User avatar
StooB
Dynamite Dan
Posts: 1073
Joined: Mon Oct 22, 2018 11:03 am
Contact:

Re: Licence information

Post by StooB »

User avatar
StooB
Dynamite Dan
Posts: 1073
Joined: Mon Oct 22, 2018 11:03 am
Contact:

Re: Licence information

Post by StooB »

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

Re: Licence information

Post by PeterJ »

StooB wrote: Sun Jan 27, 2019 6:23 pm

There's always one.

https://spectrumcomputing.co.uk/index.p ... 96&id=2546
Ohh well, it's only a handful I think we can live with it. Thanks though.

Are you a coder [mention]StooB[/mention]
User avatar
PeterJ
Site Admin
Posts: 6855
Joined: Thu Nov 09, 2017 7:19 pm
Location: Surrey, UK

Re: Licence information

Post by PeterJ »

StooB wrote: Sun Jan 27, 2019 6:24 pm This one's a bit of a cheat too:

https://spectrumcomputing.co.uk/index.p ... 96&id=1220
Not sure what the issue is with this one?

It works though, and that is how it's stored on the other site.
**Edited**
User avatar
Rorthron
Dynamite Dan
Posts: 1644
Joined: Sun Nov 12, 2017 10:35 pm

Re: Licence information

Post by Rorthron »

PeterJ wrote: Sun Jan 27, 2019 6:31 pm
StooB wrote: Sun Jan 27, 2019 6:24 pm This one's a bit of a cheat too:

https://spectrumcomputing.co.uk/index.p ... 96&id=1220
Not sure what the issue is with this one?
It bundles three licences together ("Daley Thompson/Adidas/Lucozade"), I suppose.
User avatar
Rorthron
Dynamite Dan
Posts: 1644
Joined: Sun Nov 12, 2017 10:35 pm

Re: Licence information

Post by Rorthron »

To complicate things further, should Daley Thompson's Decathlon have a "tie-in" with Daley Thompson and an "inspired by" Track and Field?
User avatar
PeterJ
Site Admin
Posts: 6855
Joined: Thu Nov 09, 2017 7:19 pm
Location: Surrey, UK

Re: Licence information

Post by PeterJ »

I think if 99.9% of titles have an improvement with the work done today, the remainder will probably have to wait for another day.

We are always after experienced PHP developers to help-out.
User avatar
PeterJ
Site Admin
Posts: 6855
Joined: Thu Nov 09, 2017 7:19 pm
Location: Surrey, UK

Re: Licence information

Post by PeterJ »

Rorthron wrote: Sun Jan 27, 2019 6:37 pm To complicate things further, should Daley Thompson's Decathlon have a "tie-in" with Daley Thompson and an "inspired by" Track and Field?
That's one for ZXDB [mention]Einar Saukas[/mention]
User avatar
PeterJ
Site Admin
Posts: 6855
Joined: Thu Nov 09, 2017 7:19 pm
Location: Surrey, UK

Re: Licence information

Post by PeterJ »

Iv'e moved things back to the body now to allow for multiple rows. I preferred the previous layout, but this caters for those 2 oddities that [mention]StooB[/mention] encountered.

Image

That's me done for today. I have a weeks worth of work shirts to iron.
User avatar
PeterJ
Site Admin
Posts: 6855
Joined: Thu Nov 09, 2017 7:19 pm
Location: Surrey, UK

Re: Licence information

Post by PeterJ »

StooB wrote: Sun Jan 27, 2019 6:23 pm
Einar Saukas wrote: Sun Jan 27, 2019 3:44 pm Nope.

Thanks!
There's always one.

https://spectrumcomputing.co.uk/index.p ... 96&id=2546
This title now displays as expected [mention]StooB[/mention] [mention]Rorthron[/mention]
User avatar
Einar Saukas
Bugaboo
Posts: 3070
Joined: Wed Nov 15, 2017 2:48 pm

Re: Licence information

Post by Einar Saukas »

Just to be clear, ZXDB follows Martijn's WoS model that each game can have only 1 license "product" (either as official tie-in or unofficial inspiration). Although the license "product" may have multiple owners (like this and this).

I could change this model if needed, but I don't think that's necessary. In this case, I think it should be marked as official tie-in for Daley Thompson only. Both Adidas and Lucozade are paid advertises, not really tie-ins.

Any thoughts?


EDIT: Actually it seems Adidas is a paid advertise, and Lucozade is a co-owner of the "Daley Thompson" brand (together with Daley Thompson himself). Thus my suggestion is adding a comment about Adidas advertise, and leave a single license with 2 owners.
Last edited by Einar Saukas on Mon Jan 28, 2019 4:15 pm, edited 1 time in total.
User avatar
Rorthron
Dynamite Dan
Posts: 1644
Joined: Sun Nov 12, 2017 10:35 pm

Re: Licence information

Post by Rorthron »

PeterJ wrote: Mon Jan 28, 2019 11:21 am
StooB wrote: Sun Jan 27, 2019 6:23 pm There's always one.

https://spectrumcomputing.co.uk/index.p ... 96&id=2546
This title now displays as expected @StooB @Rorthron
Thanks for your work on this.
User avatar
Rorthron
Dynamite Dan
Posts: 1644
Joined: Sun Nov 12, 2017 10:35 pm

Re: Licence information

Post by Rorthron »

Einar Saukas wrote: Mon Jan 28, 2019 3:00 pmIn this case, I think it should be marked as official tie-in for Daley Thompson only. Both Adidas and Lucozade are paid advertises, not really tie-ins.
+1
User avatar
StooB
Dynamite Dan
Posts: 1073
Joined: Mon Oct 22, 2018 11:03 am
Contact:

Re: Licence information

Post by StooB »

PeterJ wrote: Sun Jan 27, 2019 6:30 pm Are you a coder @StooB
A long long time ago.

Einar Saukas wrote: Mon Jan 28, 2019 3:00 pm Just to be clear, ZXDB follows Martijn's WoS model that each game can have only 1 license "product" (either as official tie-in or unofficial inspiration). Although the license "product" may have multiple owners (like this and this).

I could change this model if needed, but I don't think that's necessary. In this case, I think it should be marked as official tie-in for Daley Thompson only. Both Adidas and Lucozade are paid advertises, not really tie-ins.

Any thoughts?


EDIT: Actually it seems Adidas is a paid advertise, and Lucozade is a co-owner of the "Daley Thompson" brand (together with Daley Thompson himself). Thus my suggestion is adding a comment about Adidas advertise, and leave a single license with 2 owners.
There are two other Adidas games, https://spectrumcomputing.co.uk/index.php?cat=96&id=85 and https://spectrumcomputing.co.uk/index.php?cat=96&id=87 .
Does an advertiser only become a licensor when their name is in the title?

Clicking on Adidas at WoS brings up all three titles: http://www.worldofspectrum.org/infoseek ... loadpics=3
Post Reply