2 or II searches

Broken link? Feature request? Anything related to the Spectrum Computing website here.
User avatar
Juan F. Ramirez
Bugaboo
Posts: 5102
Joined: Tue Nov 14, 2017 6:55 am
Location: Málaga, Spain

2 or II searches

Post by Juan F. Ramirez »

when I search for, say, 'Cauldron 2', no entries are displayed. I must have a search for 'Cauldron II' instead. The same to Beach Head 2 or Match Day 2.

However, no problems if I search for Saboteur 2 or II. The game entry is displayed in both cases.

It can be fix 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 »

Juan F. Ramirez wrote: Mon Jan 29, 2018 8:15 am when I search for, say, 'Cauldron 2', no entries are displayed. I must have a search for 'Cauldron II' instead. The same to Beach Head 2 or Match Day 2.

However, no problems if I search for Saboteur 2 or II. The game entry is displayed in both cases.

It can be fix it?
Good point! I will handle it in ZXDB.
User avatar
PeteProdge
Bugaboo
Posts: 3521
Joined: Mon Nov 13, 2017 9:03 am

Re: 2 or II searches

Post by PeteProdge »

There's also something that needs fixing with apostrophes.

The game Benny Hill's Madcap Chase is listed as exactly that title, but you will draw no results if you type exactly that into the search.

However, typing the grammatically incorrect Benny Hills Madcap Chase brings up the game, complete with apostrophe.

It doesn't just affect that one title, it appears to be in all apostrophe-using games. Same symptoms for CJ's Elephant Antics.
Reheated Pixels - a combination of retrogaming, comedy and factual musing, is here!
New video: Nine ZX Spectrum magazine controversies - How Crash, Your Sinclair and Sinclair User managed to offend the world!
User avatar
Seven.FFF
Manic Miner
Posts: 735
Joined: Sat Nov 25, 2017 10:50 pm
Location: USA

Re: 2 or II searches

Post by Seven.FFF »

I release a new game called ';DROP TABLE zxdb.entries;SELECT * FROM zxdb.entries WHERE title='.

Would you like to host it? :DDDDDDD
Robin Verhagen-Guest
SevenFFF / Threetwosevensixseven / colonel32
NXtel NXTP ESP Update ESP Reset CSpect Plugins
User avatar
PeterJ
Site Admin
Posts: 6855
Joined: Thu Nov 09, 2017 7:19 pm
Location: Surrey, UK

Re: 2 or II searches

Post by PeterJ »

We have to remove special characters from input strings before they reach the ZXDB tables (as these have them removed for improved searching and alternative names). The 'apostrophe' looks like it is one we missed.

Games with explanation marks already work OK, such as 'Empire!'

I will take a look at this. Thanks for pointing it out.

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

Re: 2 or II searches

Post by PeterJ »

If you try Benny Hill's Madcap Chase now it will work.

For those interested I used the following:

$title = str_replace("\'","%",$title);

Peter
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 »

Is it possible for Spectrum Computing to display a page of games starting with A... B... C... in a similar style that WOS already has. If it does exist then how do I make it work that way, with or without screen grabs.
User avatar
PeterJ
Site Admin
Posts: 6855
Joined: Thu Nov 09, 2017 7:19 pm
Location: Surrey, UK

Re: 2 or II searches

Post by PeterJ »

Hi [mention]MatGubbins[/mention] that is our current project we are working it. It will just be a long list by letter initially with hyperlinks for the game title.

Peter
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 6:37 pm Hi @MatGubbins that is our current project we are working it. It will just be a long list by letter initially with hyperlinks for the game title.

Peter
Ah that's great, thank you!!
User avatar
PeterJ
Site Admin
Posts: 6855
Joined: Thu Nov 09, 2017 7:19 pm
Location: Surrey, UK

Re: 2 or II searches

Post by PeterJ »

[mention]MatGubbins[/mention]

This is a testing page for the letter 'E'

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

Peter
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: 6855
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: 6855
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: 6855
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: 6855
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: 6855
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.
Post Reply