Hall of Fame

[akvdomains]

Hello Everyone
I have installed to latest version phpvive 3.6
and everything is great except for 1 little issue
when I type something in search bar, if it is more than 1 word for example
Third Eye Blind
it will bring results but if I type Third Blind
it will bring Sorry but there are no results.
even though there is video with this keywords
and say for example my video is Third Eye Blind - Semi-Charmed Life
if I type Third Eye Blind Semi Charmed Life it will not find any results
for some reason its not bringing any results if it contains special characters like -
and when I copy and paste exact title bring no result
its the same on www.videoscriptdemo.com/
please help
best regards Alex
bupp.com

[PHPVibe A.]

Hi, yes it does not split the 2 words.
It would be really heavy if it did all that, and most of our clients are on shared.

But on com/com_search.php you can alter this query

Code Select Expand

$vq = "select ".$options.", ".DB_PREFIX."users.name as owner FROM ".DB_PREFIX."videos LEFT JOIN ".DB_PREFIX."users ON ".DB_PREFIX."videos.user_id = ".DB_PREFIX."users.id 
	WHERE ".DB_PREFIX."videos.pub > 0 and ( ".DB_PREFIX."videos.title like '%".$key."%' or ".DB_PREFIX."videos.description like '%".$key."%' or ".DB_PREFIX."videos.tags like '%".$key."%' ) ".$interval."
	   ORDER BY CASE WHEN ".DB_PREFIX."videos.title like '" .$key. "%' THEN 0
	           WHEN ".DB_PREFIX."videos.title like '%" .$key. "%' THEN 1
	           WHEN ".DB_PREFIX."videos.tags like '" .$key. "%' THEN 2
               WHEN ".DB_PREFIX."videos.tags like '%" .$key. "%' THEN 3		   
               WHEN ".DB_PREFIX."videos.description like '%" .$key. "%' THEN 4
			   WHEN ".DB_PREFIX."videos.tags like '%" .$key. "%' THEN 5
               ELSE 6
          END, title ".this_limit();

[akvdomains]

Hello Alexander
thanks for quick reply can you be little more specific
what do I need to alter so when anyone types something it will bring results
on all words
thanks Alex

[PHPVibe A.]

I'll test and get back to you, it isn't something I can make out of the blue.

[akvdomains]

Hello Alexander
did you have a chance to test this issue?

[PHPVibe A.]

Not yet, but will do.
Sorry, tons of work here since we have fallen behind after the Easter break.

[akvdomains]

Hello Alexander  any news on search bar as its really not great for my site most people will type more than 1 keyword to search
regards Alex

[PHPVibe A.]

Sorry it's taking so long, but Mario put me in charge or redesigning phpvibe.com and I've been working on the new store.

I've added an ticket for 3.7 with this issues, so I guess in a couple of days when they are done with jplayer they will also commit this change to the search.

[alimehdipak]

Hi sir did you solve this problem ? ?
if yes then please tel me how to set ,

[PHPVibe A.]

We don't have any solution that will return accurate results and not put your server down yet.

[alimehdipak]

OK SIR , and work on it , and try to solve it .