• Welcome to WooUSEFUL by PHPVIBE . Please log in.
K

[ Video Sharing CMS v4 ] Category RSS feed

Started by korobert,

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Go Down Pages1

korobertTopic starter

How can i generate category selected RSS Feed?

Thanks Robert
  •  

Marius

#1

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



Code Select 
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 
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 
www.yoursite.com/feed?c=1



It will show the rss with the videos in the category with the id 1.
If this helped, consider buying me a coffee.
20 years coding, tweaking, building in PHP. Still creating!
  •  

korobertTopic starter

#2
Thanks

how can i random feed generate from category?
  •  

Marius

#3
Code Select 
ORDER BY ".DB_PREFIX."videos.id DESC


changed to


Code Select 
ORDER BY rand()
If this helped, consider buying me a coffee.
20 years coding, tweaking, building in PHP. Still creating!
  •  

korobertTopic starter

#4
how can i select only top 10?
  •  

Marius

#5
Top 10 based on what?
If this helped, consider buying me a coffee.
20 years coding, tweaking, building in PHP. Still creating!
  •  

korobertTopic starter

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

Marius

#7
Once again, based on what? The top 10 should be made with video select by which algorithm (views, likes, etc)?
If this helped, consider buying me a coffee.
20 years coding, tweaking, building in PHP. Still creating!
  •  
Go Up Pages1

Similar topics (7)