/** * @param $relid * @param $uid */ public function postComment($relid, $uid) { $text = 'This release has failed to download properly. It might fail for other users too. This comment is automatically generated.'; $dbl = $this->pdo->queryOneRow(sprintf('SELECT text FROM release_comments WHERE releaseid = %d AND userid = %d', $relid, $uid)); if ($dbl['text'] != $text) { $this->rc->addComment($relid, $text, $uid, ''); } }
/** * @note Post comment for the release if that release has no comment for failure. * Only one user is allowed to post comment for that release, rest will just * update the failed count in dnzb_failures table * * @param $relid * @param $uid */ public function postComment($relid, $uid) { $dupe = 0; $text = 'This release has failed to download properly. It might fail for other users too. This comment is automatically generated.'; $check = $this->pdo->queryDirect(sprintf(' SELECT text FROM release_comments WHERE releaseid = %d', $relid)); if ($check instanceof \Traversable) { foreach ($check as $dbl) { if ($dbl['text'] == $text) { $dupe = 1; break; } } } if ($dupe === 0) { $this->rc->addComment($relid, $text, $uid, ''); } }
use nzedb\ReleaseExtra; use nzedb\ReleaseFiles; use nzedb\Releases; use nzedb\Videos; use nzedb\XXX; use nzedb\DnzbFailures; if (!$page->users->isLoggedIn()) { $page->show403(); } if (isset($_GET['id'])) { $releases = new Releases(['Settings' => $page->settings]); $data = $releases->getByGuid($_GET['id']); if (!$data) { $page->show404(); } $rc = new ReleaseComments($page->settings); $fail = new DnzbFailures(['Settings' => $page->settings]); if ($page->isPostBack()) { $rc->addComment($data['id'], $_POST['txtAddComment'], $page->users->currentUserId(), $_SERVER['REMOTE_ADDR']); } $criteria = $mov = $xxx = ''; if ($data['videos_id'] != 0) { $showInfo = (new Videos(['Settings' => $page->settings]))->getByVideoID($data['videos_id']); if (count($showInfo) > 0) { $criteria = ['title' => '', 'summary' => '', 'countries_id' => '', 'image' => '', 'id' => '']; $done = 1; $needed = count($criteria); foreach ($showInfo as $info) { foreach ($criteria as $key => $value) { if (empty($value) && !empty($info[$key])) { $criteria[$key] = $info[$key];
<?php use nzedb\ReleaseComments; use nzedb\SABnzbd; if (!$page->users->isLoggedIn()) { $page->show403(); } $rc = new ReleaseComments($page->settings); $sab = new SABnzbd($page); $userid = $page->users->currentUserId(); $privileged = $page->users->isAdmin($userid) || $page->users->isModerator($userid) ? true : false; $privateProfiles = $page->settings->getSetting('privateprofiles') == 1 ? true : false; $publicView = false; if (!$privateProfiles || $privileged) { $altID = isset($_GET['id']) && $_GET['id'] >= 0 ? (int) $_GET['id'] : false; $altUsername = isset($_GET['name']) && strlen($_GET['name']) > 0 ? $_GET['name'] : false; // If both 'id' and 'name' are specified, 'id' should take precedence. if ($altID === false && $altUsername !== false) { $user = $page->users->getByUsername($altUsername); if ($user) { $altID = $user['id']; } } else { if ($altID !== false) { $userid = $altID; $publicView = true; } } } $data = $page->users->getById($userid); if (!$data) {
<?php require_once './config.php'; use nzedb\ReleaseComments; $page = new AdminPage(); $releases = new ReleaseComments($page->settings); $page->title = "Comments List"; $commentcount = $releases->getCommentCount(); $offset = isset($_REQUEST["offset"]) ? $_REQUEST["offset"] : 0; $page->smarty->assign('pagertotalitems', $commentcount); $page->smarty->assign('pageroffset', $offset); $page->smarty->assign('pageritemsperpage', ITEMS_PER_PAGE); $page->smarty->assign('pagerquerybase', WWW_TOP . "/comments-list.php?offset="); $pager = $page->smarty->fetch("pager.tpl"); $page->smarty->assign('pager', $pager); $commentslist = $releases->getCommentsRange($offset, ITEMS_PER_PAGE); $page->smarty->assign('commentslist', $commentslist); $page->content = $page->smarty->fetch('comments-list.tpl'); $page->render();
<?php require_once './config.php'; use nzedb\ReleaseComments; $page = new AdminPage(); if (isset($_GET['id'])) { $rc = new ReleaseComments($page->settings); $rc->deleteComment($_GET['id']); } $referrer = $_SERVER['HTTP_REFERER']; header("Location: " . $referrer);
use nzedb\ReleaseExtra; use nzedb\ReleaseFiles; use nzedb\Releases; use nzedb\TraktTv; use nzedb\TvRage; use nzedb\XXX; if (!$page->users->isLoggedIn()) { $page->show403(); } if (isset($_GET['id'])) { $releases = new Releases(['Settings' => $page->settings]); $data = $releases->getByGuid($_GET['id']); if (!$data) { $page->show404(); } $rc = new ReleaseComments($page->settings); if ($page->isPostBack()) { $rc->addComment($data['id'], $_POST['txtAddComment'], $page->users->currentUserId(), $_SERVER['REMOTE_ADDR']); } $nfo = $releases->getReleaseNfo($data['id'], false); $re = new ReleaseExtra($page->settings); $reVideo = $re->getVideo($data['id']); $reAudio = $re->getAudio($data['id']); $reSubs = $re->getSubs($data['id']); $comments = $rc->getComments($data['id']); $similars = $releases->searchSimilar($data['id'], $data['searchname'], 6, $page->userdata['categoryexclusions']); $rage = $ani = $mov = $mus = $con = $game = $xxx = $boo = ''; if ($data['rageid'] != '') { $tvrage = new TvRage(['Settings' => $page->settings]); $rageinfo = $tvrage->getByRageID($data['rageid']); if (count($rageinfo) > 0) {
break; case 'sharing_reset_settings': $guid = $admin->settings->queryOneRow('SELECT site_guid FROM sharing'); $guid = $guid === false ? '' : $guid['site_guid']; (new Sharing(['Settings' => $admin->settings]))->initSettings($guid); print 'Re-initiated sharing settings!'; break; case 'sharing_purge_site': $guid = $admin->settings->queryOneRow(sprintf('SELECT site_guid FROM sharing_sites WHERE id = %d', $_GET['purge_site'])); if ($guid === false) { print 'Error purging site ' . $_GET['purge_site'] . '!'; } else { $ids = $admin->settings->query(sprintf('SELECT id FROM release_comments WHERE siteid = %s', $admin->settings->escapeString($guid['site_guid']))); $total = count($ids); if ($total > 0) { $rc = new ReleaseComments($admin->settings); foreach ($ids as $id) { $rc->deleteComment($id['id']); } } $admin->settings->queryExec(sprintf('UPDATE sharing_sites SET comments = 0 WHERE id = %d', $_GET['purge_site'])); print 'Deleted ' . $total . ' comments for site ' . $_GET['purge_site']; } break; case 'sharing_toggle_posting': $admin->settings->queryExec(sprintf('UPDATE sharing SET posting = %d', $_GET['posting_status'])); print ($_GET['posting_status'] == 1 ? 'Enabled' : 'Disabled') . ' posting!'; break; case 'sharing_toggle_fetching': $admin->settings->queryExec(sprintf('UPDATE sharing SET fetching = %d', $_GET['fetching_status'])); print ($_GET['fetching_status'] == 1 ? 'Enabled' : 'Disabled') . ' fetching!';
<?php use nzedb\ReleaseComments; use nzedb\SABnzbd; if (!$page->users->isLoggedIn()) { $page->show403(); } $rc = new ReleaseComments($page->settings); $sab = new SABnzbd($page); $userID = $page->users->currentUserId(); $privileged = $page->users->isAdmin($userID) || $page->users->isModerator($userID) ? true : false; $privateProfiles = $page->settings->getSetting('privateprofiles') == 1 ? true : false; $publicView = false; if (!$privateProfiles || $privileged) { $altID = isset($_GET['id']) && $_GET['id'] >= 0 ? (int) $_GET['id'] : false; $altUsername = isset($_GET['name']) && strlen($_GET['name']) > 0 ? $_GET['name'] : false; // If both 'id' and 'name' are specified, 'id' should take precedence. if ($altID === false && $altUsername !== false) { $user = $page->users->getByUsername($altUsername); if ($user) { $altID = $user['id']; } } else { if ($altID !== false) { $userID = $altID; $publicView = true; } } } $data = $page->users->getById($userID); if (!$data) {