/**
* 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) {
