/** * Creates part of a query for searches requiring the categoryID's. * * @param array $categories * * @return string */ public function categorySQL($categories) { $sql = ''; if (count($categories) > 0 && $categories[0] != -1) { $Category = new Category(['Settings' => $this->pdo]); $sql = ' AND ('; foreach ($categories as $category) { if ($category != -1) { if ($Category->isParent($category)) { $children = $Category->getChildren($category); $childList = '-99'; foreach ($children as $child) { $childList .= ', ' . $child['id']; } if ($childList != '-99') { $sql .= ' r.categoryid IN (' . $childList . ') OR '; } } else { $sql .= sprintf(' r.categoryid = %d OR ', $category); } } } $sql .= '1=2 )'; } return $sql; }
<?php use nzedb\Category; use nzedb\Movie; use nzedb\DnzbFailures; if (!$page->users->isLoggedIn()) { $page->show403(); } $movie = new Movie(['Settings' => $page->settings]); $cat = new Category(['Settings' => $page->settings]); $fail = new DnzbFailures(['Settings' => $page->settings]); $moviecats = $cat->getChildren(Category::CAT_PARENT_MOVIE); $mtmp = []; foreach ($moviecats as $mcat) { $mtmp[$mcat['id']] = $mcat; } $category = Category::CAT_PARENT_MOVIE; if (isset($_REQUEST['t']) && array_key_exists($_REQUEST['t'], $mtmp)) { $category = $_REQUEST['t'] + 0; } $user = $page->users->getById($page->users->currentUserId()); $cpapi = $user['cp_api']; $cpurl = $user['cp_url']; $page->smarty->assign('cpapi', $cpapi); $page->smarty->assign('cpurl', $cpurl); $catarray = []; $catarray[] = $category; $page->smarty->assign('catlist', $mtmp); $page->smarty->assign('category', $category); $browsecount = $movie->getMovieCount($catarray, -1, $page->userdata['categoryexclusions']); $offset = isset($_REQUEST['offset']) && ctype_digit($_REQUEST['offset']) ? $_REQUEST["offset"] : 0;
<?php use nzedb\Category; use nzedb\Genres; use nzedb\Music; if (!$page->users->isLoggedIn()) { $page->show403(); } $music = new Music(['Settings' => $page->settings]); $cat = new Category(['Settings' => $page->settings]); $gen = new Genres(['Settings' => $page->settings]); $musiccats = $cat->getChildren(Category::CAT_PARENT_MUSIC); $mtmp = array(); foreach ($musiccats as $mcat) { $mtmp[$mcat['id']] = $mcat; } $category = Category::CAT_PARENT_MUSIC; if (isset($_REQUEST['t']) && array_key_exists($_REQUEST['t'], $mtmp)) { $category = $_REQUEST['t'] + 0; } $catarray = array(); $catarray[] = $category; $page->smarty->assign('catlist', $mtmp); $page->smarty->assign('category', $category); $browsecount = $music->getMusicCount($catarray, -1, $page->userdata['categoryexclusions']); $offset = isset($_REQUEST['offset']) && ctype_digit($_REQUEST['offset']) ? $_REQUEST['offset'] : 0; $ordering = $music->getMusicOrdering(); $orderby = isset($_REQUEST['ob']) && in_array($_REQUEST['ob'], $ordering) ? $_REQUEST['ob'] : ''; $results = $musics = array(); $results = $music->getMusicRange($catarray, $offset, ITEMS_PER_COVER_PAGE, $orderby, $page->userdata['categoryexclusions']); $artist = isset($_REQUEST['artist']) && !empty($_REQUEST['artist']) ? stripslashes($_REQUEST['artist']) : '';
<?php use nzedb\Books; use nzedb\Category; use nzedb\DnzbFailures; if (!$page->users->isLoggedIn()) { $page->show403(); } $book = new Books(['Settings' => $page->settings]); $cat = new Category(['Settings' => $page->settings]); $fail = new DnzbFailures(['Settings' => $page->settings]); $boocats = $cat->getChildren(Category::CAT_PARENT_BOOKS); $btmp = array(); foreach ($boocats as $bcat) { $btmp[$bcat['id']] = $bcat; } $category = Category::CAT_PARENT_BOOKS; if (isset($_REQUEST["t"]) && array_key_exists($_REQUEST['t'], $btmp)) { $category = $_REQUEST["t"] + 0; } $catarray = array(); $catarray[] = $category; $page->smarty->assign('catlist', $btmp); $page->smarty->assign('category', $category); $browsecount = $book->getBookCount($catarray, -1, $page->userdata["categoryexclusions"]); $offset = isset($_REQUEST["offset"]) && ctype_digit($_REQUEST['offset']) ? $_REQUEST["offset"] : 0; $ordering = $book->getBookOrdering(); $orderby = isset($_REQUEST["ob"]) && in_array($_REQUEST['ob'], $ordering) ? $_REQUEST["ob"] : ''; $results = $books = array(); $results = $book->getBookRange($catarray, $offset, ITEMS_PER_COVER_PAGE, $orderby, $page->userdata["categoryexclusions"]); $maxwords = 50;
foreach ($ordering as $ordertype) { $page->smarty->assign('orderby' . $ordertype, WWW_TOP . "/myshows/browse?ob=" . $ordertype . "&offset=0"); } $page->smarty->assign('lastvisit', $page->userdata['lastlogin']); $page->smarty->assign('results', $results); $page->smarty->assign('shows', true); $page->content = $page->smarty->fetch('browse.tpl'); $page->render(); break; default: $page->title = "My Shows"; $page->meta_title = "My Shows"; $page->meta_keywords = "search,add,to,cart,nzb,description,details"; $page->meta_description = "Manage Your Shows"; $cat = new Category(['Settings' => $page->settings]); $tmpcats = $cat->getChildren(Category::CAT_PARENT_TV); $categories = array(); foreach ($tmpcats as $c) { $categories[$c['id']] = $c['title']; } $shows = $us->getShows($page->users->currentUserId()); $results = array(); foreach ($shows as $showk => $show) { $showcats = explode('|', $show['categoryid']); if (is_array($showcats) && sizeof($showcats) > 0) { $catarr = array(); foreach ($showcats as $scat) { if (!empty($scat)) { $catarr[] = $categories[$scat]; } }
<?php use nzedb\Category; use nzedb\Games; use nzedb\Genres; use nzedb\DnzbFailures; if (!$page->users->isLoggedIn()) { $page->show403(); } $games = new Games(['Settings' => $page->settings]); $cat = new Category(['Settings' => $page->settings]); $gen = new Genres(['Settings' => $page->settings]); $fail = new DnzbFailures(['Settings' => $page->settings]); $concats = $cat->getChildren(Category::CAT_PARENT_PC); $ctmp = array(); foreach ($concats as $ccat) { $ctmp[$ccat['id']] = $ccat; } $category = Category::CAT_PC_GAMES; if (isset($_REQUEST["t"]) && array_key_exists($_REQUEST['t'], $ctmp)) { $category = $_REQUEST["t"] + 0; } $catarray = array(); $catarray[] = $category; $page->smarty->assign('catlist', $ctmp); $page->smarty->assign('category', $category); $offset = isset($_REQUEST["offset"]) && ctype_digit($_REQUEST['offset']) ? $_REQUEST["offset"] : 0; $ordering = $games->getGamesOrdering(); $orderby = isset($_REQUEST["ob"]) && in_array($_REQUEST['ob'], $ordering) ? $_REQUEST["ob"] : ''; $results = $games2 = array(); $results = $games->getGamesRange($catarray, $offset, ITEMS_PER_COVER_PAGE, $orderby, -1, $page->userdata["categoryexclusions"]);
<?php use nzedb\Category; use nzedb\XXX; use nzedb\DnzbFailures; if (!$page->users->isLoggedIn()) { $page->show403(); } $movie = new XXX(['Settings' => $page->settings]); $cat = new Category(['Settings' => $page->settings]); $fail = new DnzbFailures(['Settings' => $page->settings]); $moviecats = $cat->getChildren(Category::CAT_PARENT_XXX); $mtmp = array(); foreach ($moviecats as $mcat) { $mtmp[$mcat['id']] = $mcat; } $category = Category::CAT_PARENT_XXX; if (isset($_REQUEST['t']) && array_key_exists($_REQUEST['t'], $mtmp)) { $category = $_REQUEST['t'] + 0; } $catarray = array(); $catarray[] = $category; $page->smarty->assign('catlist', $mtmp); $page->smarty->assign('category', $category); $browsecount = $movie->getXXXCount($catarray, -1, $page->userdata['categoryexclusions']); $offset = isset($_REQUEST['offset']) && ctype_digit($_REQUEST['offset']) ? $_REQUEST["offset"] : 0; $ordering = $movie->getXXXOrdering(); $orderby = isset($_REQUEST['ob']) && in_array($_REQUEST['ob'], $ordering) ? $_REQUEST['ob'] : ''; $results = $movies = array(); $results = $movie->getXXXRange($catarray, $offset, ITEMS_PER_COVER_PAGE, $orderby, -1, $page->userdata['categoryexclusions']); foreach ($results as $result) {