Missing screenshots

Broken link? Feature request? Anything related to the Spectrum Computing website here.
Post Reply
User avatar
pavero
Dynamite Dan
Posts: 1570
Joined: Sat Dec 09, 2017 11:49 pm
Location: The Czech Republic
Contact:

Missing screenshots

Post by pavero »

Just wonder ...

Is this list generated online from actual version of ZXDB?

https://spectrumcomputing.co.uk/index.php?cat=51

There are more new added games from 2017,2016,... without screenshots and I can't see them in the list at all.

Thanks.
User avatar
Einar Saukas
Bugaboo
Posts: 3070
Joined: Wed Nov 15, 2017 2:48 pm

Re: Missing screenshots

Post by Einar Saukas »

Yes, it's generated online. However there was an error in the SQL query that I gave to SpectrumComputing, it wasn't showing titles without publisher information... sorry!

It seems to be working properly now.
Ralf
Rick Dangerous
Posts: 2279
Joined: Mon Nov 13, 2017 11:59 am
Location: Poland

Re: Missing screenshots

Post by Ralf »

it wasn't showing titles without publisher information
INNER JOIN instead of LEFT JOIN? ;)
User avatar
Einar Saukas
Bugaboo
Posts: 3070
Joined: Wed Nov 15, 2017 2:48 pm

Re: Missing screenshots

Post by Einar Saukas »

Ralf wrote: Fri Jan 26, 2018 1:47 pm
it wasn't showing titles without publisher information
INNER JOIN instead of LEFT JOIN? ;)
Exactly! :)
User avatar
Guesser
Manic Miner
Posts: 639
Joined: Wed Nov 15, 2017 2:35 pm
Contact:

Re: Missing screenshots

Post by Guesser »

It also doesn't list csscgc entries, I assume because they were never listed in infoseek individually?
User avatar
kolbeck
Manic Miner
Posts: 309
Joined: Mon Nov 13, 2017 9:04 pm

Re: Missing screenshots

Post by kolbeck »

Einar Saukas wrote: Fri Jan 26, 2018 1:49 pm
Ralf wrote: Fri Jan 26, 2018 1:47 pm INNER JOIN instead of LEFT JOIN? ;)
Exactly! :)
Glad to know that I’m not the only one! :-)
https://api.zxinfo.dk/v3/ - ZXDB API for developers
zxinfo-file-browser - Cross platform app to manage your files
https://zxinfo.dk - another ZXDB frontend
User avatar
Seven.FFF
Manic Miner
Posts: 736
Joined: Sat Nov 25, 2017 10:50 pm
Location: USA

Re: Missing screenshots

Post by Seven.FFF »

I was gonna say INNER JOIN too, but I didn't want it to be interpreted as mockery!

I don't think I have ever seen you make a mistake before, Einar :)
Robin Verhagen-Guest
SevenFFF / Threetwosevensixseven / colonel32
NXtel NXTP ESP Update ESP Reset CSpect Plugins
User avatar
Einar Saukas
Bugaboo
Posts: 3070
Joined: Wed Nov 15, 2017 2:48 pm

Re: Missing screenshots

Post by Einar Saukas »

Seven.FFF wrote: Fri Jan 26, 2018 5:26 pmI don't think I have ever seen you make a mistake before, Einar :)
It happens all the time, you just need to pay more attention! :)
User avatar
pavero
Dynamite Dan
Posts: 1570
Joined: Sat Dec 09, 2017 11:49 pm
Location: The Czech Republic
Contact:

Re: Missing screenshots

Post by pavero »

Great!

BTW in which format to send screenshots for Sam Coupe? ;-)
User avatar
pavero
Dynamite Dan
Posts: 1570
Joined: Sat Dec 09, 2017 11:49 pm
Location: The Czech Republic
Contact:

Re: Missing screenshots

Post by pavero »

Maybe it would be better to filter software only (not books, hardware, etc.) in this query.

Entries with id < 1000000 ???
User avatar
Einar Saukas
Bugaboo
Posts: 3070
Joined: Wed Nov 15, 2017 2:48 pm

Re: Missing screenshots

Post by Einar Saukas »

Guesser wrote: Fri Jan 26, 2018 2:51 pmIt also doesn't list csscgc entries
pavero wrote: Sat Jan 27, 2018 3:37 pmMaybe it would be better to filter software only (not books, hardware, etc.) in this query.
Both errors are fixed now. Thanks!

I doubt Peter will ever ask me to write SQL for him again after I made so many silly mistakes in such a simple query! :)
User avatar
Einar Saukas
Bugaboo
Posts: 3070
Joined: Wed Nov 15, 2017 2:48 pm

Re: Missing screenshots

Post by Einar Saukas »

pavero wrote: Fri Jan 26, 2018 7:16 pmBTW in which format to send screenshots for Sam Coupe? ;-)
Please use SCR for Mode 1, MLT for Mode 2, SS4 (same as ZX-Art) for Mode 4.

I don't know if there's a standard format for Mode 3. If you need it, let me know and I will check it out.
User avatar
pavero
Dynamite Dan
Posts: 1570
Joined: Sat Dec 09, 2017 11:49 pm
Location: The Czech Republic
Contact:

Re: Missing screenshots

Post by pavero »

Einar Saukas wrote: Sat Jan 27, 2018 4:27 pm
pavero wrote: Fri Jan 26, 2018 7:16 pmBTW in which format to send screenshots for Sam Coupe? ;-)
Please use SCR for Mode 1, MLT for Mode 2, SS4 (same as ZX-Art) for Mode 4.

I don't know if there's a standard format for Mode 3. If you need it, let me know and I will check it out.
And which Sam Coupe emulator supports these formats? ;-)
User avatar
Einar Saukas
Bugaboo
Posts: 3070
Joined: Wed Nov 15, 2017 2:48 pm

Re: Missing screenshots

Post by Einar Saukas »

pavero wrote: Sat Jan 27, 2018 7:18 pmAnd which Sam Coupe emulator supports these formats? ;-)
I have never used a Sam Coupe emulator. What screenshot file formats are supported by them? I don't mind implementing a file converter if needed.
User avatar
Guesser
Manic Miner
Posts: 639
Joined: Wed Nov 15, 2017 2:35 pm
Contact:

Re: Missing screenshots

Post by Guesser »

I'm just looking forward to the screenshots of Chromatrons Attack from the 2013 CSSCGC :D
User avatar
R-Tape
Site Admin
Posts: 6353
Joined: Thu Nov 09, 2017 11:46 am

Re: Missing screenshots

Post by R-Tape »

Guesser wrote: Sat Jan 27, 2018 10:51 pm I'm just looking forward to the screenshots of Chromatrons Attack from the 2013 CSSCGC :D
Actually that is on the (small) list of notable CGC entries to get on the site soon! Probably the one example in the entire archive where your .png (or bmp?) is the most appropriate format...
User avatar
Einar Saukas
Bugaboo
Posts: 3070
Joined: Wed Nov 15, 2017 2:48 pm

Re: Missing screenshots

Post by Einar Saukas »

R-Tape wrote: Sat Jan 27, 2018 11:03 pm
Guesser wrote: Sat Jan 27, 2018 10:51 pm I'm just looking forward to the screenshots of Chromatrons Attack from the 2013 CSSCGC :D
Actually that is on the (small) list of notable CGC entries to get on the site soon! Probably the one example in the entire archive where your .png (or bmp?) is the most appropriate format...
Actually all CGC entries were already added to ZXDB! However it's hard to find them because Spectrum Computing excludes them from regular searches.

For instance "Chromatrons":

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

Should I rename it to "Chromatrons Attack"?
User avatar
R-Tape
Site Admin
Posts: 6353
Joined: Thu Nov 09, 2017 11:46 am

Re: Missing screenshots

Post by R-Tape »

Einar Saukas wrote: Sun Jan 28, 2018 1:43 am Actually all CGC entries were already added to ZXDB! However it's hard to find them because Spectrum Computing excludes them from regular searches.

For instance "Chromatrons":

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

Should I rename it to "Chromatrons Attack"?
Aye they're present when you browse by year on SC, and I happened to spot this one and plan to include the game and screenshots for it. A CGC tick box can be an option if we implement an ultra advanced search™.

Yes I think it should be "Chromatrons Attack" but let's let the moire master himself confirm [mention]Guesser[/mention]
User avatar
Guesser
Manic Miner
Posts: 639
Joined: Wed Nov 15, 2017 2:35 pm
Contact:

Re: Missing screenshots

Post by Guesser »

Yup, it's "Chromatrons Attack" in the game, and on the splash screen.

Trivia: it was originally going to be called "Attack of the Chromatrons" but that didn't really fit on the screen. :lol:
User avatar
Einar Saukas
Bugaboo
Posts: 3070
Joined: Wed Nov 15, 2017 2:48 pm

Re: Missing screenshots

Post by Einar Saukas »

Thanks for the confirmation! This fix will be in the next ZXDB update.
Post Reply