2 or II searches

Broken link? Feature request? Anything related to the Spectrum Computing website here.
User avatar
Einar Saukas
Manic Miner
Posts: 516
Joined: Wed Nov 15, 2017 2:48 pm

Re: 2 or II searches

Post by Einar Saukas » Sat Feb 17, 2018 2:22 pm

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.
This should be working now.
1 x

User avatar
Einar Saukas
Manic Miner
Posts: 516
Joined: Wed Nov 15, 2017 2:48 pm

Re: 2 or II searches

Post by Einar Saukas » Sat Feb 17, 2018 2:24 pm

Juan F. Ramirez wrote:
Wed Feb 14, 2018 8:40 am
Search for 'Arkanoid 2' doesn't work.
This should work after the next ZXDB update.
2 x

User avatar
Juan F. Ramirez
Dynamite Dan
Posts: 1157
Joined: Tue Nov 14, 2017 6:55 am
Location: Málaga, Spain

Re: 2 or II searches

Post by Juan F. Ramirez » Fri Mar 16, 2018 11:55 am

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'.
0 x

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

Re: 2 or II searches

Post by PeterJ » Fri Mar 16, 2018 12:31 pm

@Juan F. Ramirez sorry, but the 3 character minimum stops risk of strain on the database so it needs to stay.
0 x
The Spectrum Computing Christmas 2018 charity prize draw is now live!

User avatar
Seven.FFF
Manic Miner
Posts: 283
Joined: Sat Nov 25, 2017 10:50 pm
Location: USA

Re: 2 or II searches

Post by Seven.FFF » Fri Mar 16, 2018 2:12 pm

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.
0 x
Robin Verhagen-Guest
SevenFFF / Threetwosevensixseven / colonel32
seven-fff.com/blog

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

Re: 2 or II searches

Post by PeterJ » Fri Mar 16, 2018 2:15 pm

@Seven.FFF I agree it's possible. We can add to the list.

That won't work for the above though as the title is 'V The Game'. Imagine how many results you would get if you were allowed to search just for 'V'. We are on a relatively small server and need to put these sorts of limitations in place.

I will publish a list of titles with under three characters over the weekend.
1 x
The Spectrum Computing Christmas 2018 charity prize draw is now live!

User avatar
Juan F. Ramirez
Dynamite Dan
Posts: 1157
Joined: Tue Nov 14, 2017 6:55 am
Location: Málaga, Spain

Re: 2 or II searches

Post by Juan F. Ramirez » Tue Mar 20, 2018 10:48 am

... and another one.

Whenever I search a game that it is also included in a compilation, the results shows first the compilation this game is in, then the original game.

For example, 'Sir Fred' show first a compilation in which it is included. Then the game itself.

Something similar to other searches, i.e. like Pyjamarama or The Muncher.

I think the results should show the original game first, then the compilation.

What do you think?
0 x

User avatar
Einar Saukas
Manic Miner
Posts: 516
Joined: Wed Nov 15, 2017 2:48 pm

Re: 2 or II searches

Post by Einar Saukas » Tue Mar 20, 2018 1:20 pm

Juan F. Ramirez wrote:
Tue Mar 20, 2018 10:48 am
Whenever I search a game that it is also included in a compilation, the results shows first the compilation this game is in, then the original game.
Nope! :)

Whenever you search for "XYZ", then all titles containing string "XYZ" are listed in alphabetic order. It doesn't matter if any of them is a compilation.

Juan F. Ramirez wrote:
Tue Mar 20, 2018 10:48 am
For example, 'Sir Fred' show first a compilation in which it is included. Then the game itself.
For example, there's a title called "La Abadia del Crimen + Sir Fred" and another called "Sir Fred". When you search for "Sir Fred", both titles are listed, in alphabetic order.

Juan F. Ramirez wrote:
Tue Mar 20, 2018 10:48 am
Something similar to other searches, i.e. like Pyjamarama or The Muncher.
Same thing.

Now try searching for "Automania". You will find "Automania", "Pyjamarama + Automania" and "Rugby Manager + Automania", all listed in alphabetic order.
0 x

User avatar
Juan F. Ramirez
Dynamite Dan
Posts: 1157
Joined: Tue Nov 14, 2017 6:55 am
Location: Málaga, Spain

Re: 2 or II searches

Post by Juan F. Ramirez » Tue Mar 20, 2018 4:09 pm

Ah, I know. The system considers game titles as equal as compilations, hence the results.

But what I'm trying to say is if the system is able to show requested games with these rules:
1. Games before compilations, then
2. A-Z

I'm doing some searches and it's a bit annoying come across compilations (2 or 3 in some cases) before the desired entry.
0 x

User avatar
Einar Saukas
Manic Miner
Posts: 516
Joined: Wed Nov 15, 2017 2:48 pm

Re: 2 or II searches

Post by Einar Saukas » Tue Mar 20, 2018 4:54 pm

Juan F. Ramirez wrote:
Tue Mar 20, 2018 4:09 pm
Ah, I know. The system considers game titles as equal as compilations, hence the results.
Kinda.

The system searches for titles. It doesn't make a difference if it's the title of an individual game, utility, compilation, electronic magazine, paper magazine covertape, book, computer, hardware add-on, scene demo, educational program, etc...

Juan F. Ramirez wrote:
Tue Mar 20, 2018 4:09 pm
But what I'm trying to say is if the system is able to show requested games with these rules:
1. Games before compilations, then
2. A-Z

I'm doing some searches and it's a bit annoying come across compilations (2 or 3 in some cases) before the desired entry.
What about the other categories I mentioned? What should be done about them?

If someone searches for "LOGO" for instance, it will return dozens of titles from different categories, spread across multiple pages. What's the exact order you propose?
0 x

Post Reply