$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");