Load'n'Run.... "Pirated" games?

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
wallyweek
Drutt
Posts: 47
Joined: Tue Mar 06, 2018 3:10 pm

Re: Load'n'Run.... "Pirated" games?

Post by wallyweek »

wallyweek wrote: Sat Jul 18, 2020 12:30 pm I guess a new relationship table with original game ID and fake alias, magazine and issue should suffice.
I've made a pull request on github with the new table and the entries for all 1984 issues of Load'n'Run as a start.

Any feedback welcome, please! :)
Master of Sarcastic Wit
User avatar
Einar Saukas
Bugaboo
Posts: 3070
Joined: Wed Nov 15, 2017 2:48 pm

Re: Load'n'Run.... "Pirated" games?

Post by Einar Saukas »

wallyweek wrote: Sat Jul 25, 2020 5:03 pmAny feedback welcome, please! :)
My apologies for not replying sooner! I didn't notice the latest posts until now.

First of all, thank you very much for your willingness to contribute, I really appreciate it!

ZXDB already had detailed information about the first 7 issues of Load'n'Run. For instance if you visit this Load'n'Run page, click on issue #4, then click on "Software/Tape: Load 'n' Run issue 04", you will see a full list of games included in Load 'n' Run #4's covertape. Since these games were distributed in the covertape that came with the magazine, instead of directly inside the magazine pages, it makes more sense to list them as covertape contents.

Notice that besides listing the pirated games in each tape, we also list original programs (like Stock Libri) and even programs that don't deserve a separate game page (like "Presentazione" and "Prossimamente"). We also list the tape side and order of each program in the tape.

This organization works quite well for unauthorized copies in magazines. If you search for "Oro Nero" at SpectrumComputing you will find the corresponding game page just fine.

This information was added using this spreadsheet. Alessandro Grussu and myself filled the first 7 issues, but we both have been too busy to do anything else. If you can help complete this spreadsheet, even if it's just a few more issues, we will be very grateful! Just send me a PM with your email address so I can give you editing permission in this spreadsheet. I also added a second "tab" in the spreadsheet so you can add a link to Giuseppe's page (and anything else you consider relevant) for each magazine issue, I'm sure he will like it. I already added all links to Giuseppe's page that will appear in the next ZXDB update, I'm sure he will like it.

You just need to be careful when filling the spreadsheet because there are different games with similar titles. For instance "Carambola" is Pool by Bug-Byte Software, not Pool by Omega Software. Also "Cowboys" is Cowboy Shootout by Micro Power, not Cowboy Shoot Out by 16/48 Tape Magazine. It's easy to get them wrong :)
User avatar
wallyweek
Drutt
Posts: 47
Joined: Tue Mar 06, 2018 3:10 pm

Re: Load'n'Run.... "Pirated" games?

Post by wallyweek »

Einar Saukas wrote: Sun Jul 26, 2020 4:15 pm This information was added using this spreadsheet. Alessandro Grussu and myself filled the first 7 issues, but we both have been too busy to do anything else. If you can help complete this spreadsheet, even if it's just a few more issues, we will be very grateful! Just send me a PM with your email address so I can give you editing permission in this spreadsheet.
I didn't notice that!

I'll be glad to complete the sheet, and if it's fine to you, can also add other magazines.
PM sent! :)

Oh, and don't forget to discard my pull request. :)
Master of Sarcastic Wit
User avatar
Einar Saukas
Bugaboo
Posts: 3070
Joined: Wed Nov 15, 2017 2:48 pm

Re: Load'n'Run.... "Pirated" games?

Post by Einar Saukas »

wallyweek wrote: Sun Jul 26, 2020 5:21 pm I'll be glad to complete the sheet, and if it's fine to you, can also add other magazines.
PM sent! :)
Awesome, thank you!!!

I gave you editing access to 2 spreadsheets:
  • Use this spreadsheet when you want to list programs distributed in magazine covertapes, like Load'n'Run. Please create a different spreadsheet tab for each magazine. You don't need to worry about the SQL columns, that's the easy part for me, I can add them later.
  • Use this spreadsheet when you want to list magazine page contents. It's not useful for Load'n'Run that doesn't have any actual content in magazine pages, everything's on covertapes. But you may need it for other magazines. In this case, everything does in the 1st tab. Except if there's a magazine issue that doesn't exist in ZXDB yet, you can use the 2nd tab to add it.
wallyweek wrote: Sun Jul 26, 2020 5:21 pm Oh, and don't forget to discard my pull request. :)
Done!
Post Reply