Hall of Fame

[korobert]

How can i generate category selected RSS Feed?

Thanks Robert

[Marius P.]

Hi, same code as for feed type, but query the category, example (feed.php):

Code Select Expand

if(_get("m") && (intval(_get("m")) > 0)) {
$vq = "select ".$options.", ".DB_PREFIX."users.name as owner FROM ".DB_PREFIX."videos LEFT JOIN ".DB_PREFIX."channels ON ".DB_PREFIX."videos.category =".DB_PREFIX."channels.cat_id  LEFT JOIN ".DB_PREFIX."users ON ".DB_PREFIX."videos.user_id = ".DB_PREFIX."users.id WHERE ".DB_PREFIX."videos.views >= 0 and ".DB_PREFIX."videos.pub > 0 and ".DB_PREFIX."videos.media ='".intval(_get("m"))."' ORDER BY ".DB_PREFIX."videos.id DESC ".this_limit();
} else {

turned to

Code Select Expand

if(_get("m") && (intval(_get("m")) > 0)) {
$vq = "select ".$options.", ".DB_PREFIX."users.name as owner FROM ".DB_PREFIX."videos LEFT JOIN ".DB_PREFIX."channels ON ".DB_PREFIX."videos.category =".DB_PREFIX."channels.cat_id  LEFT JOIN ".DB_PREFIX."users ON ".DB_PREFIX."videos.user_id = ".DB_PREFIX."users.id WHERE ".DB_PREFIX."videos.views >= 0 and ".DB_PREFIX."videos.pub > 0 and ".DB_PREFIX."videos.media ='".intval(_get("m"))."' ORDER BY ".DB_PREFIX."videos.id DESC ".this_limit();
} elseif(_get("c") && (intval(_get("c")) > 0)) {
$vq = "select ".$options.", ".DB_PREFIX."users.name as owner FROM ".DB_PREFIX."videos LEFT JOIN ".DB_PREFIX."channels ON ".DB_PREFIX."videos.category =".DB_PREFIX."channels.cat_id  LEFT JOIN ".DB_PREFIX."users ON ".DB_PREFIX."videos.user_id = ".DB_PREFIX."users.id WHERE ".DB_PREFIX."videos.views >= 0 and ".DB_PREFIX."videos.pub > 0 and ".DB_PREFIX."videos.category ='".intval(_get("c"))."' ORDER BY ".DB_PREFIX."videos.id DESC ".this_limit();
}else {

This way if you go to :

Code Select Expand

www.yoursite.com/feed?c=1

It will show the rss with the videos in the category with the id 1.

[korobert]

Thanks

how can i random feed generate from category?

[Marius P.]

Code Select Expand

ORDER BY ".DB_PREFIX."videos.id DESC

changed to

Code Select Expand

ORDER BY rand()

[korobert]

how can i select only top 10?

[Marius P.]

Top 10 based on what?

[korobert]

I want on feed list only 10 feeds, or only 1.

[Marius P.]

Once again, based on what? The top 10 should be made with video select by which algorithm (views, likes, etc)?