Adult Script Pro Community Forums

Create, help and share your ideas with the community!

You are not logged in.

#1 2011-05-10 22:50:02

marshalbros
Member
Registered: 2011-05-05
Posts: 42

Use Sphinx to add videos to categories

Is it possible?  It does a much better job of identifying than I can do.

Last edited by marshalbros (2011-05-10 22:50:19)

Offline

#2 2011-05-11 07:05:17

symtab
Administrator
Registered: 2010-08-23
Posts: 7,501
Website

Re: Use Sphinx to add videos to categories

I thaught a few times about this problem, so what i'm thinking is to add a new mysql column to the video_categories table, which will contain words separated by commas. These words will act like tags for the categories and will be used to identify a video (by title, by description and by video tags) and assign it to the specified category. This way i can make sure the category detection for mass embed, mass rss and mass csv import is more accurate.

With sphinx i dont see exactly how i could identify the category for a video, except for checking if that video contains the category name (or in the future one of the category tags), however this is done from php, not sphinx (sphinx only stores the data for faster searching).


Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds

Offline

Board footer

Powered by FluxBB