Spectrum Computing

R-Tape wrote: ↑Thu Sep 03, 2020 8:12 pmAh that's what those apparently superfluous columns were for. I thought you'd gone round the bend!

Einar Saukas wrote: ↑Fri Aug 21, 2020 1:46 am

Code: Select all

select e.id, e.title, e.comments, e.hardware_blurb, e.known_errors from entries e where e.id = ?

corresponds now to a query like this:

Code: Select all

select e.id, e.title, 
GROUP_CONCAT(c.text ORDER BY c.text SEPARATOR '\n\n') as comments,
h.text as hardware_blurb, 
r.text as known_errors
from entries e 
left join notes c on e.id = c.entry_id and c.notetype_id = 'C'
left join notes h on e.id = h.entry_id and h.notetype_id = 'H'
left join notes r on e.id = r.entry_id and r.notetype_id = 'R'
where e.id = ?

kolbeck wrote: ↑Wed Sep 09, 2020 8:59 am Shouldn't it be R, S, E instead of C, H, R? (Combined with notes.section for S for hardware blurp)

kolbeck wrote: ↑Thu Oct 01, 2020 7:58 am Hi Einar,

Looks like there is a problem running ZXDB_help_search.sql - it gives me the following error:

Code: Select all

ERROR 1062 (23000) at line 18: Duplicate entry 'ar cnidos-5147' for key 'PRIMARY'

As far as I can see, the problem is that entry 18241 has alias, which happens to be the the same title as entry 5147 ?

/Thomas

kolbeck wrote: ↑Thu Oct 01, 2020 7:58 am Looks like there is a problem running ZXDB_help_search.sql - it gives me the following error:

Code: Select all

ERROR 1062 (23000) at line 18: Duplicate entry 'ar cnidos-5147' for key 'PRIMARY'

update compilations set alias=null where alias='Aracnidos';

kolbeck wrote: ↑Thu Oct 01, 2020 7:58 am As far as I can see, the problem is that entry 18241 has alias, which happens to be the the same title as entry 5147 ?

Ralf wrote: ↑Thu Oct 01, 2020 10:10 am Thanks for the update, as usual!

Personally I'm really happy about indexing Load'n'Run. Now you can see all titles on each cassette and
in the case of cracks there is even a proper name of of the cracked game, along with the name of the crack.

Could we push it a bit more?

Now when I check for example Load'n'Run 26:
https://www.spectrumcomputing.co.uk/ent ... n_issue_26

I can see at the top of the list that it contains "Esploratore lunare" which is in fact Nodes of Yesod.

When I type "Esploratore lunare" into the search it returns indeed Nodes of Yesod.
But Nodes of Yesod entry itself don't have info that it was released on Load'n'Run under different title.

Type "Esploratore" into search - you'll get Nodes of Yesod and Sabre Wulf "Why???" someone could ask.
It may be really confusing for someone who doesn't know the story behind Italian cracks.

Would it be possible to add "Released unofficially as XXX on LOAD'N'Run NN' on entries of such games?
Or something like that?

Good point!
This is now fixed in both main and compact views