Games with source code

Broken link? Feature request? Anything related to the Spectrum Computing website here.
Post Reply
Ralf
Manic Miner
Posts: 839
Joined: Mon Nov 13, 2017 11:59 am
Location: Poland

Games with source code

Post by Ralf » Sat Jan 13, 2018 4:46 pm

Is it currently possible to search at Spectrum Computing for the games where we have source code available? I believe it isn't. Would it be hard to add it to the search engine?

Actually on old WOS if you go into Advanced Search there is a lot of flags which you can use during your search and "source code" is one of them. I suspect all this info is available in ZXDB, just not supported yet.

And I'm asking because I'd like to upload source code for all my games here so it doesn't get lost for future generations ;) I checked and it is already present for some games but without the search engine I would have to check each game separately for it.
1 x

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

Re: Games with source code

Post by PeterJ » Sat Jan 13, 2018 6:23 pm

Good evening @Ralf ,

I had a quick look at ZXDB and if you run this on the database:

Code: Select all

SELECT entries.id, entries.title, downloads.file_link FROM `downloads` 
inner join entries on entries.id = downloads.entry_id
where filetype_id = '32'
You get the following list (exported as CSV)

https://spectrumcomputing.co.uk/exports ... ceCode.csv

I did a test with:

Mariano the Dragon in Capers in Cityland

https://spectrumcomputing.co.uk/index.p ... 6&id=20177

Please remember that if any of the games were commercial you may not find the downloads on this site.

I will look at getting it intergrated into the site, but it will have to join the queue I'm afraid.
0 x

Ralf
Manic Miner
Posts: 839
Joined: Mon Nov 13, 2017 11:59 am
Location: Poland

Re: Games with source code

Post by Ralf » Mon Jan 15, 2018 4:38 pm

All right. So good luck with site development and I'll be watching the news !
0 x

Post Reply