2 or II searches
- Juan F. Ramirez
- Bugaboo
- Posts: 5137
- Joined: Tue Nov 14, 2017 6:55 am
- Location: Málaga, Spain
2 or II searches
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?
However, no problems if I search for Saboteur 2 or II. The game entry is displayed in both cases.
It can be fix it?
- Einar Saukas
- Bugaboo
- Posts: 3133
- Joined: Wed Nov 15, 2017 2:48 pm
Re: 2 or II searches
Good point! I will handle it in ZXDB.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?
- PeteProdge
- Bugaboo
- Posts: 3588
- Joined: Mon Nov 13, 2017 9:03 am
Re: 2 or II searches
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.
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!
New video: Nine ZX Spectrum magazine controversies - How Crash, Your Sinclair and Sinclair User managed to offend the world!
Re: 2 or II searches
I release a new game called ';DROP TABLE zxdb.entries;SELECT * FROM zxdb.entries WHERE title='.
Would you like to host it? :DDDDDDD
Would you like to host it? :DDDDDDD
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
Re: 2 or II searches
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
Games with explanation marks already work OK, such as 'Empire!'
I will take a look at this. Thanks for pointing it out.
Peter
Re: 2 or II searches
If you try Benny Hill's Madcap Chase now it will work.
For those interested I used the following:
$title = str_replace("\'","%",$title);
Peter
For those interested I used the following:
$title = str_replace("\'","%",$title);
Peter
- MatGubbins
- Dynamite Dan
- Posts: 1239
- Joined: Mon Nov 13, 2017 11:45 am
- Location: Kent, UK
Re: 2 or II searches
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.
Re: 2 or II searches
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
Peter
- MatGubbins
- Dynamite Dan
- Posts: 1239
- Joined: Mon Nov 13, 2017 11:45 am
- Location: Kent, UK
Re: 2 or II searches
[mention]MatGubbins[/mention]
This is a testing page for the letter 'E'
https://spectrumcomputing.co.uk/index.php?cat=52
Peter
This is a testing page for the letter 'E'
https://spectrumcomputing.co.uk/index.php?cat=52
Peter
- MatGubbins
- Dynamite Dan
- Posts: 1239
- Joined: Mon Nov 13, 2017 11:45 am
- Location: Kent, UK
Re: 2 or II searches
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.
Re: 2 or II searches
Thanks, changed title to Genre. Looking at adding publisher
Cheers
Cheers
- Einar Saukas
- Bugaboo
- Posts: 3133
- Joined: Wed Nov 15, 2017 2:48 pm
Re: 2 or II searches
Searching for "Cauldron 2" works now!
- Einar Saukas
- Bugaboo
- Posts: 3133
- Joined: Wed Nov 15, 2017 2:48 pm
Re: 2 or II searches
Nice to hear that people will be able to find Renegade 3 much more easily now.
My Speccy site: thirdharmoniser.com
Re: 2 or II searches
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.
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.
- Juan F. Ramirez
- Bugaboo
- Posts: 5137
- Joined: Tue Nov 14, 2017 6:55 am
- Location: Málaga, Spain
Re: 2 or II searches
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
https://spectrumcomputing.co.uk/index. ... 6&id=5641
Re: 2 or II searches
Hi [mention]Juan F. Ramirez[/mention]
Searching for Fist + now works. Thanks for bringing this to our attention.
Peter
Searching for Fist + now works. Thanks for bringing this to our attention.
Peter
- Juan F. Ramirez
- Bugaboo
- Posts: 5137
- Joined: Tue Nov 14, 2017 6:55 am
- Location: Málaga, Spain
Re: 2 or II searches
Search for 'Arkanoid 2' doesn't work.
- Einar Saukas
- Bugaboo
- Posts: 3133
- Joined: Wed Nov 15, 2017 2:48 pm
Re: 2 or II searches
Ops! I will fix it in the next ZXDB update.
Thanks for reporting it!
Thanks for reporting it!
Re: 2 or II searches
Searching for "Break/Space" yields no results, but searching for "Break Space" returns "Break/Space".
Re: 2 or II searches
Also "&" and "and". A search for "Horace and the Robots" returns no results; "Horace & the Robots" works.
Re: 2 or II searches
Hi, as the title in ZXDB uses an ampersand it won't pick up the and in a search. Maybe the title needs changing?
Re: 2 or II searches
It's possible the forward slash is stripped as part of the PHP security checks we do on strings. We can check.