Missing screenshots
- pavero
- Dynamite Dan
- Posts: 1582
- Joined: Sat Dec 09, 2017 11:49 pm
- Location: The Czech Republic
- Contact:
Missing screenshots
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.
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.
- Einar Saukas
- Bugaboo
- Posts: 3094
- Joined: Wed Nov 15, 2017 2:48 pm
Re: Missing screenshots
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.
It seems to be working properly now.
Re: Missing screenshots
INNER JOIN instead of LEFT JOIN?it wasn't showing titles without publisher information
- Einar Saukas
- Bugaboo
- Posts: 3094
- Joined: Wed Nov 15, 2017 2:48 pm
Re: Missing screenshots
Exactly!
Re: Missing screenshots
It also doesn't list csscgc entries, I assume because they were never listed in infoseek individually?
Re: Missing screenshots
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
zxinfo-file-browser - Cross platform app to manage your files
https://zxinfo.dk - another ZXDB frontend
Re: Missing screenshots
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
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
SevenFFF / Threetwosevensixseven / colonel32
NXtel • NXTP • ESP Update • ESP Reset • CSpect Plugins
- Einar Saukas
- Bugaboo
- Posts: 3094
- Joined: Wed Nov 15, 2017 2:48 pm
Re: Missing screenshots
It happens all the time, you just need to pay more attention!
- pavero
- Dynamite Dan
- Posts: 1582
- Joined: Sat Dec 09, 2017 11:49 pm
- Location: The Czech Republic
- Contact:
Re: Missing screenshots
Great!
BTW in which format to send screenshots for Sam Coupe?
BTW in which format to send screenshots for Sam Coupe?
- pavero
- Dynamite Dan
- Posts: 1582
- Joined: Sat Dec 09, 2017 11:49 pm
- Location: The Czech Republic
- Contact:
Re: Missing screenshots
Maybe it would be better to filter software only (not books, hardware, etc.) in this query.
Entries with id < 1000000 ???
Entries with id < 1000000 ???
- Einar Saukas
- Bugaboo
- Posts: 3094
- Joined: Wed Nov 15, 2017 2:48 pm
Re: Missing screenshots
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!
- Einar Saukas
- Bugaboo
- Posts: 3094
- Joined: Wed Nov 15, 2017 2:48 pm
Re: Missing screenshots
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.
- pavero
- Dynamite Dan
- Posts: 1582
- Joined: Sat Dec 09, 2017 11:49 pm
- Location: The Czech Republic
- Contact:
Re: Missing screenshots
And which Sam Coupe emulator supports these formats?Einar Saukas wrote: ↑Sat Jan 27, 2018 4:27 pmPlease 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.
- Einar Saukas
- Bugaboo
- Posts: 3094
- Joined: Wed Nov 15, 2017 2:48 pm
Re: Missing screenshots
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.
Re: Missing screenshots
I'm just looking forward to the screenshots of Chromatrons Attack from the 2013 CSSCGC
Re: Missing screenshots
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...
- Einar Saukas
- Bugaboo
- Posts: 3094
- Joined: Wed Nov 15, 2017 2:48 pm
Re: Missing screenshots
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"?
Re: Missing screenshots
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™.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"?
Yes I think it should be "Chromatrons Attack" but let's let the moire master himself confirm [mention]Guesser[/mention]
Re: Missing screenshots
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.
Trivia: it was originally going to be called "Attack of the Chromatrons" but that didn't really fit on the screen.
- Einar Saukas
- Bugaboo
- Posts: 3094
- Joined: Wed Nov 15, 2017 2:48 pm
Re: Missing screenshots
Thanks for the confirmation! This fix will be in the next ZXDB update.