-
-
Notifications
You must be signed in to change notification settings - Fork 25
/
Copy pathfeed.php
26 lines (24 loc) · 1.85 KB
/
feed.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
<?php error_reporting(E_ALL);
//Vital file include
require_once("load.php");
require_once( INC.'/rss.class.php' );
//Initialize RSS:
$rss = new FeedRSS(_html(get_option('site-logo-text')), site_url().'feed/', _html(seo_desc()), current_lang(), _html(get_option('site-copyright')), '', '', '', '', '');
if(get_option('site-logo')) {
$rss->AddImage(_html(get_option('site-logo-text')), thumb_fix(get_option('site-logo')), site_url().'feed/', '145', '45', get_option('site-logo-text'));
}
$options = DB_PREFIX."videos.*, ".DB_PREFIX."channels.cat_name as channel_name ,".DB_PREFIX."users.name as owner";
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 {
$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 ORDER BY ".DB_PREFIX."videos.id DESC ".this_limit();
}
$videos = $db->get_results($vq);
foreach ($videos as $video) {
if(!empty($video->title)) {
$rss->AddArticle(_html($video->title), video_url($video->id , $video->title), gmdate(DATE_RSS, strtotime($video->date)), $video->owner, $video->channel_name, channel_url($video->category,$video->channel_name), _cut(_html($video->description),20), _html($video->description));
}
}
//Publish RSS:
$rss->Output();
?>