$apx->lang->drop('list');
$apx->lang->drop('search');
//Verwendete Variablen auslesen
$parse = $apx->tmpl->used_vars('index');
//Kategorie auslesen
$catinfo = array();
if ($_REQUEST['catid']) {
$catinfo = $db->first("SELECT id, title, text, icon, open FROM " . PRE . "_videos_cat WHERE id='" . $_REQUEST['catid'] . "' LIMIT 1");
}
//Tree-Manager
require_once BASEDIR . 'lib/class.recursivetree.php';
$tree = new RecursiveTree(PRE . '_videos_cat', 'id');
//KATEGORIEN
if ($_REQUEST['catid']) {
$wholetree = array($_REQUEST['catid']);
$data = $tree->getLevel(array('title', 'text', 'icon', 'open'), $_REQUEST['catid']);
} else {
$wholetree = array();
$data = $tree->getLevel(array('title', 'text', 'icon', 'open'));
}
if (count($data)) {
//Kategorien auflisten
$catdata = array();
foreach ($data as $res) {
++$i;
//Link
$link = mklink('videos.php?catid=' . $res['id'], 'videos,' . $res['id'] . ',1' . urlformat($res['title']) . '.html');
//Video-Zahl
$contentIds = $res['children'];
$contentIds[] = $res['id'];
$wholetree = array_merge($wholetree, $contentIds);
}
if (!$_REQUEST['letter']) {
$_REQUEST['letter'] = 0;
}
//Seitenzahlen
if ($set['gallery']['subgals']) {
list($count) = $db->first("SELECT count(id) FROM " . PRE . "_gallery WHERE ( '" . time() . "' BETWEEN starttime AND endtime AND parents='|' " . section_filter() . " )");
} else {
list($count) = $db->first("SELECT count(id) FROM " . PRE . "_gallery WHERE ( ( '" . time() . "' BETWEEN starttime AND endtime ) " . $where . " " . section_filter() . " )");
}
pages(mklink('gallery.php' . iif($_REQUEST['letter'], '?letter=' . $_REQUEST['letter']), 'gallery,' . $_REQUEST['letter'] . ',{P}.html'), $count, $set['gallery']['listepp']);
//Galerie sortieren nach
if ($set['gallery']['subgals']) {
require_once BASEDIR . 'lib/class.recursivetree.php';
$tree = new RecursiveTree(PRE . '_gallery', 'id');
$data = $tree->getLevel(array('*'), 0, "'" . time() . "' BETWEEN starttime AND endtime " . section_filter(true, 'secid'));
} else {
if ($_REQUEST['letter']) {
$orderby = 'title ASC';
} elseif ($set['gallery']['ordergal'] == 2) {
$orderby = 'title ASC';
} elseif ($set['gallery']['ordergal'] == 3) {
$orderby = 'lft ASC';
} else {
$orderby = 'starttime DESC';
}
$data = $db->fetch("SELECT *,1 AS level FROM " . PRE . "_gallery WHERE ( '" . time() . "' BETWEEN starttime AND endtime " . $where . " " . section_filter() . " ) ORDER BY " . $orderby . " " . iif($set['gallery']['listepp'], getlimit($set['gallery']['listepp'])));
}
//Galerien auslesen, die veröffentlicht sind
if ($set['gallery']['subgals']) {
$openData = $db->fetch("SELECT id FROM " . PRE . "_gallery WHERE '" . time() . "' BETWEEN starttime AND endtime");
