Related videos shows alsovideos that is playing

Eri · 2011-05-20 12:57:05

Related videos shows also videos that is playing.
The video that a user is just watching is not good having it at related videos.

symtab · 2011-05-20 15:20:44

Erm...fixing.

Eri · 2011-07-25 19:14:03

I have this problem only when i enable sphinix

symtab · 2011-07-25 21:03:20

Yes. Because the mysql code for the related video excludes the current video. I think i need to offer 3 methods (all depending on what the user decides to do, full text, tag only and sphinx).

symtab · 2011-07-26 14:31:50

I've found a solution for this. We need one more attribute in sphinx.conf and then from the api: $sphinx->SetFilter('attribute', array($video_id), true); and the current video will be exacluded. It does not work with video_id as attribute because first column cannot be used, so v.video_id AS vid will be used. Will add this fix to 1.0RC3.

Eri · 2011-07-27 06:52:45

Nice

Adult Script Pro Community Forums

#1 2011-05-20 12:57:05

Related videos shows alsovideos that is playing

#2 2011-05-20 15:20:44

Re: Related videos shows alsovideos that is playing

#3 2011-07-25 19:14:03

Re: Related videos shows alsovideos that is playing

#4 2011-07-25 21:03:20

Re: Related videos shows alsovideos that is playing

#5 2011-07-26 14:31:50

Re: Related videos shows alsovideos that is playing

#6 2011-07-27 06:52:45

Re: Related videos shows alsovideos that is playing

Board footer