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