2 or II searches

Broken link? Feature request? Anything related to the Spectrum Computing website here.
User avatar
MatGubbins
Dynamite Dan
Posts: 1238
Joined: Mon Nov 13, 2017 11:45 am
Location: Kent, UK

Re: 2 or II searches

Post by MatGubbins »

PeterJ wrote: Tue Jan 30, 2018 8:52 pm @MatGubbins

This is a testing page for the letter 'E'

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

Peter

Looks great, just that the heading states publisher, but it is listing what type of game style it is and not the company that released it. Yup, I know, a test page to make sure that we are paying attention at the back of the class. :)
User avatar
PeterJ
Site Admin
Posts: 6858
Joined: Thu Nov 09, 2017 7:19 pm
Location: Surrey, UK

Re: 2 or II searches

Post by PeterJ »

Thanks, changed title to Genre. Looking at adding publisher

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

Re: 2 or II searches

Post by Einar Saukas »

Searching for "Cauldron 2" works now!
Wall_Axe
Manic Miner
Posts: 492
Joined: Mon Nov 13, 2017 11:13 pm

Re: 2 or II searches

Post by Wall_Axe »

Seven.FFF wrote: Mon Jan 29, 2018 5:58 pm I release a new game called ';DROP TABLE zxdb.entries;SELECT * FROM zxdb.entries WHERE title='.

Would you like to host it? :DDDDDDD
lol
User avatar
Einar Saukas
Bugaboo
Posts: 3070
Joined: Wed Nov 15, 2017 2:48 pm

Re: 2 or II searches

Post by Einar Saukas »

Seven.FFF wrote: Mon Jan 29, 2018 5:58 pm I release a new game called ';DROP TABLE zxdb.entries;SELECT * FROM zxdb.entries WHERE title='.

Would you like to host it? :DDDDDDD
https://xkcd.com/327/
User avatar
Morkin
Bugaboo
Posts: 3251
Joined: Mon Nov 13, 2017 8:50 am
Location: Bristol, UK

Re: 2 or II searches

Post by Morkin »

Nice to hear that people will be able to find Renegade 3 much more easily now. ;)
My Speccy site: thirdharmoniser.com
User avatar
PeterJ
Site Admin
Posts: 6858
Joined: Thu Nov 09, 2017 7:19 pm
Location: Surrey, UK

Re: 2 or II searches

Post by PeterJ »

The alphabetical games list testing page now includes publisher.

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

We will get the full A-Z, working as soon as possible.

This is a much requested feature so I hope you will find it useful.
User avatar
Juan F. Ramirez
Bugaboo
Posts: 5102
Joined: Tue Nov 14, 2017 6:55 am
Location: Málaga, Spain

Re: 2 or II searches

Post by Juan F. Ramirez »

I can't access neither 'Fist +' nor 'Fist Plus'. It has to be through Exploding Fist and go to the series list.

https://spectrumcomputing.co.uk/index. ... 6&id=5641
User avatar
PeterJ
Site Admin
Posts: 6858
Joined: Thu Nov 09, 2017 7:19 pm
Location: Surrey, UK

Re: 2 or II searches

Post by PeterJ »

Hi [mention]Juan F. Ramirez[/mention]

Searching for Fist + now works. Thanks for bringing this to our attention.

Peter
User avatar
Juan F. Ramirez
Bugaboo
Posts: 5102
Joined: Tue Nov 14, 2017 6:55 am
Location: Málaga, Spain

Re: 2 or II searches

Post by Juan F. Ramirez »

Search for 'Arkanoid 2' doesn't work.
User avatar
Einar Saukas
Bugaboo
Posts: 3070
Joined: Wed Nov 15, 2017 2:48 pm

Re: 2 or II searches

Post by Einar Saukas »

Ops! I will fix it in the next ZXDB update.

Thanks for reporting it!
User avatar
Rorthron
Dynamite Dan
Posts: 1644
Joined: Sun Nov 12, 2017 10:35 pm

Re: 2 or II searches

Post by Rorthron »

Searching for "Break/Space" yields no results, but searching for "Break Space" returns "Break/Space".
User avatar
Rorthron
Dynamite Dan
Posts: 1644
Joined: Sun Nov 12, 2017 10:35 pm

Re: 2 or II searches

Post by Rorthron »

Also "&" and "and". A search for "Horace and the Robots" returns no results; "Horace & the Robots" works.
User avatar
PeterJ
Site Admin
Posts: 6858
Joined: Thu Nov 09, 2017 7:19 pm
Location: Surrey, UK

Re: 2 or II searches

Post by PeterJ »

Rorthron wrote: Sat Feb 17, 2018 8:04 am Also "&" and "and". A search for "Horace and the Robots" returns no results; "Horace & the Robots" works.
Hi, as the title in ZXDB uses an ampersand it won't pick up the and in a search. Maybe the title needs changing?
User avatar
PeterJ
Site Admin
Posts: 6858
Joined: Thu Nov 09, 2017 7:19 pm
Location: Surrey, UK

Re: 2 or II searches

Post by PeterJ »

Rorthron wrote: Sat Feb 17, 2018 6:53 am Searching for "Break/Space" yields no results, but searching for "Break Space" returns "Break/Space".
It's possible the forward slash is stripped as part of the PHP security checks we do on strings. We can check.
User avatar
Rorthron
Dynamite Dan
Posts: 1644
Joined: Sun Nov 12, 2017 10:35 pm

Re: 2 or II searches

Post by Rorthron »

PeterJ wrote: Sat Feb 17, 2018 8:31 am
Rorthron wrote: Sat Feb 17, 2018 8:04 am Also "&" and "and". A search for "Horace and the Robots" returns no results; "Horace & the Robots" works.
Hi, as the title in ZXDB uses an ampersand it won't pick up the and in a search. Maybe the title needs changing?
No, the title is correct in ZXDB, but it is quite unforgiving to insist on the exact orthography. I thought we were allowing "2" or "II", so shouldn't we also allow "&" or "and"?
User avatar
PeterJ
Site Admin
Posts: 6858
Joined: Thu Nov 09, 2017 7:19 pm
Location: Surrey, UK

Re: 2 or II searches

Post by PeterJ »

Good point. I will speak with [mention]Einar Saukas[/mention] and see if he has any suggestions.
User avatar
RMartins
Manic Miner
Posts: 776
Joined: Thu Nov 16, 2017 3:26 pm

Re: 2 or II searches

Post by RMartins »

I have worked for yellow pages, on it's search engine, and currently what I see reported here is entering this kind of complex search engine.

This requires a special index structure, besides a normal SQL database and it's search capabilities.
Note however, that this kind of support, takes a lot of work, and definition of alias, synonymous, link words, and other similar stuff, to be able to match all the expected outcomes.

Are we sure we want to go by this route ?

Do we have the resources, and man power to do it ?
User avatar
Einar Saukas
Bugaboo
Posts: 3070
Joined: Wed Nov 15, 2017 2:48 pm

Re: 2 or II searches

Post by Einar Saukas »

RMartins wrote: Sat Feb 17, 2018 1:50 pm I have worked for yellow pages, on it's search engine, and currently what I see reported here is entering this kind of complex search engine.

This requires a special index structure, besides a normal SQL database and it's search capabilities.
Note however, that this kind of support, takes a lot of work, and definition of alias, synonymous, link words, and other similar stuff, to be able to match all the expected outcomes.

Are we sure we want to go by this route ?

Do we have the resources, and man power to do it ?
You are right. We will never reach a perfect, flawless solution without investing more resources than it's reasonable to expect from a free site.

Even so, I think we can still get better results using a few smart tricks. Let's see...
User avatar
Einar Saukas
Bugaboo
Posts: 3070
Joined: Wed Nov 15, 2017 2:48 pm

Re: 2 or II searches

Post by Einar Saukas »

Rorthron wrote: Sat Feb 17, 2018 6:53 amSearching for "Break/Space" yields no results, but searching for "Break Space" returns "Break/Space".
This should be working now.
User avatar
Einar Saukas
Bugaboo
Posts: 3070
Joined: Wed Nov 15, 2017 2:48 pm

Re: 2 or II searches

Post by Einar Saukas »

Rorthron wrote: Sat Feb 17, 2018 8:04 amAlso "&" and "and". A search for "Horace and the Robots" returns no results; "Horace & the Robots" works.
This should be working now.
User avatar
Einar Saukas
Bugaboo
Posts: 3070
Joined: Wed Nov 15, 2017 2:48 pm

Re: 2 or II searches

Post by Einar Saukas »

Juan F. Ramirez wrote: Wed Feb 14, 2018 8:40 amSearch for 'Arkanoid 2' doesn't work.
This should work after the next ZXDB update.
User avatar
Juan F. Ramirez
Bugaboo
Posts: 5102
Joined: Tue Nov 14, 2017 6:55 am
Location: Málaga, Spain

Re: 2 or II searches

Post by Juan F. Ramirez »

Another issue:

If I'm looking for 'V', by Ocean, the system tells me the word must be minimum 3 characters long. So I must look for 'Ocean', and search for the game in the list.

Searching for 'V The Game' works.

Is it possible to stablish an exception to the three-characters rule for this case? The original, main game name in the DB is 'V', and 'V - The Game' is the 'aka'.
User avatar
PeterJ
Site Admin
Posts: 6858
Joined: Thu Nov 09, 2017 7:19 pm
Location: Surrey, UK

Re: 2 or II searches

Post by PeterJ »

[mention]Juan F. Ramirez[/mention] sorry, but the 3 character minimum stops risk of strain on the database so it needs to stay.
User avatar
Seven.FFF
Manic Miner
Posts: 736
Joined: Sat Nov 25, 2017 10:50 pm
Location: USA

Re: 2 or II searches

Post by Seven.FFF »

It could be possible with a new table or indexed view that surfaces a relatively small number of titles to be exact-matched on <3 search terms.
Robin Verhagen-Guest
SevenFFF / Threetwosevensixseven / colonel32
NXtel NXTP ESP Update ESP Reset CSpect Plugins
Post Reply