locale = fusion_get_locale('', VID_LOCALE);
$this->video_settings = get_settings('videos');
if (isset($_GET['section']) && $_GET['section'] == 'back') {
redirect(FUSION_SELF.fusion_get_aidlink());
}
}
private function listing() {
$aidlink = fusion_get_aidlink();
$limit = 15;
$total_rows = dbcount("(video_id)", DB_VIDEOS);
$rowstart = isset($_GET['rowstart']) && ($_GET['rowstart'] <= $total_rows) ? $_GET['rowstart'] : 0;
$cat_opts['all'] = $this->locale['vid_005'];
$categories = dbquery("SELECT video_cat_id, video_cat_name FROM ".DB_VIDEO_CATS." ".(multilang_table('VL') ? "WHERE ".in_group('video_cat_language', LANGUAGE) : ""));
if (dbrows($categories) > 0) {
while ($cat_data = dbarray($categories)) {
$cat_opts[$cat_data['video_cat_id']] = $cat_data['video_cat_name'];
}
}
$cat_filter = '';
if (isset($_GET['filter_cid']) && isnum($_GET['filter_cid']) && isset($cat_opts[$_GET['filter_cid']])) {
if ($_GET['filter_cid'] > 0) {
$cat_filter = "video_cat='".intval($_GET['filter_cid'])."'";
}
}
$lang_filter = multilang_table('VL') ? "".in_group('video_cat_language', LANGUAGE) : '';
if ($cat_filter && $lang_filter) {
$filter = $cat_filter." AND ".$lang_filter;
} else {
$filter = $cat_filter.$lang_filter;
}
$result = dbquery("SELECT v.*, vc.video_cat_id, vc.video_cat_name
FROM ".DB_VIDEOS." v
INNER JOIN ".DB_VIDEO_CATS." vc on v.video_cat = vc.video_cat_id
".($filter ? "WHERE $filter " : '')."
ORDER BY v.video_datestamp DESC LIMIT $rowstart, $limit
");
$rows = dbrows($result);
echo '';
echo '
'.sprintf($this->locale['vid_006'], $rows, $total_rows).'';
if (!empty($cat_opts) > 0 && $total_rows > 0) {
echo '
';
}
if ($total_rows > $rows) {
echo makepagenav($rowstart, $limit, $total_rows, $limit, clean_request('', ['aid', 'section'], TRUE).'&');
}
echo '
';
while ($data = dbarray($result)) {
echo '
';
echo '
';
echo '
';
echo '
';
echo '
!['.$data['video_title'].']('.get_video_thumb($data).')
';
echo '
';
echo '
';
echo '
';
echo '
'.$data['video_title'].'';
echo '
';
echo '
';
echo '
';
echo '
';
echo '
';
}
echo '
'.$this->locale['vid_008'].'
';
}
}
public function displayAdmin() {
add_to_title($this->locale['vid_title']);
add_breadcrumb(['link' => INFUSIONS.'videos/admin.php'.fusion_get_aidlink(), 'title' => $this->locale['vid_title']]);
$edit = (isset($_GET['action']) && $_GET['action'] == 'edit') && isset($_GET['video_id']);
if (!empty($_GET['section'])) {
switch ($_GET['section']) {
case 'form':
add_breadcrumb(['link' => FUSION_REQUEST, 'title' => $edit ? $this->locale['edit'] : $this->locale['add']]);
break;
case 'categories':
add_breadcrumb(['link' => FUSION_REQUEST, 'title' => $this->locale['vid_001']]);
break;
case 'submissions':
add_breadcrumb(['link' => FUSION_REQUEST, 'title' => $this->locale['vid_002']]);
break;
case 'settings':
add_breadcrumb(['link' => FUSION_REQUEST, 'title' => $this->locale['vid_003']]);
break;
}
}
opentable($this->locale['vid_title']);
$allowed_section = ['list', 'form', 'categories', 'submissions', 'settings'];
$_GET['section'] = isset($_GET['section']) && in_array($_GET['section'], $allowed_section) ? $_GET['section'] : 'list';
if (isset($_GET['section']) && $_GET['section'] == 'form') {
$tab['title'][] = $this->locale['back'];
$tab['id'][] = 'back';
$tab['icon'][] = 'fa fa-fw fa-arrow-left';
}
$tab['title'][] = $this->locale['vid_title'];
$tab['id'][] = 'list';
$tab['icon'][] = 'fa fa-fw fa-play';
$tab['title'][] = $edit ? $this->locale['edit'] : $this->locale['add'];
$tab['id'][] = 'form';
$tab['icon'][] = 'fa fa-'.($edit ? 'pencil' : 'plus');
$tab['title'][] = $this->locale['vid_001'];
$tab['id'][] = 'categories';
$tab['icon'][] = 'fa fa-folder';
$tab['title'][] = $this->locale['vid_002'].' '.dbcount("(submit_id)", DB_SUBMISSIONS, "submit_type='v'").'';
$tab['id'][] = 'submissions';
$tab['icon'][] = 'fa fa-inbox';
$tab['title'][] = $this->locale['vid_003'];
$tab['id'][] = 'settings';
$tab['icon'][] = 'fa fa-cogs';
echo opentab($tab, $_GET['section'], 'videoadmin', TRUE, 'nav-tabs m-b-20');
switch ($_GET['section']) {
case 'form':
if (dbcount("(video_cat_id)", DB_VIDEO_CATS)) {
require_once 'admin/videos.php';
} else {
echo ''.$this->locale['vid_004'].'
';
}
break;
case 'categories':
require_once 'admin/video_cats.php';
break;
case 'submissions':
require_once 'admin/video_submissions.php';
break;
case 'settings':
require_once 'admin/video_settings.php';
break;
default:
$this->listing();
break;
}
echo closetab();
closetable();
}
}
$vid = new VideosAdmin();
$vid->displayAdmin();
require_once THEMES.'templates/footer.php';