} } elseif ($CategoryName === 'Audiobooks' || $CategoryName === 'Comedy') { $FullName = "{$Request['Title']} [{$Request['Year']}]"; $DisplayLink = "<span dir=\"ltr\">{$Request['Title']}</span> [{$Request['Year']}]"; } else { $FullName = $Request['Title']; $DisplayLink = "<span dir=\"ltr\">{$Request['Title']}</span>"; } //Votes time $RequestVotes = Requests::get_votes_array($RequestID); $VoteCount = count($RequestVotes['Voters']); $ProjectCanEdit = check_perms('project_team') && !$IsFilled && ($Request['CategoryID'] === '0' || $CategoryName === 'Music' && $Request['Year'] === '0'); $UserCanEdit = !$IsFilled && $LoggedUser['ID'] === $Request['UserID'] && $VoteCount < 2; $CanEdit = $UserCanEdit || $ProjectCanEdit || check_perms('site_moderate_requests'); // Comments (must be loaded before View::show_header so that subscriptions and quote notifications are handled properly) list($NumComments, $Page, $Thread, $LastRead) = Comments::load('requests', $RequestID); View::show_header("View request: {$FullName}", 'comments,requests,bbcode,subscriptions'); ?> <div class="thin"> <div class="header"> <h2><a href="requests.php">Requests</a> > <?php echo $CategoryName; ?> > <?php echo $DisplayLink; ?> </h2> <div class="linkbox"> <?php if ($CanEdit) { ?>
<?php if (empty($_GET['id']) || !is_number($_GET['id'])) { json_die("failure"); } list($NumComments, $Page, $Thread) = Comments::load('torrents', (int) $_GET['id'], false); //---------- Begin printing $JsonComments = array(); foreach ($Thread as $Key => $Post) { list($PostID, $AuthorID, $AddedTime, $Body, $EditedUserID, $EditedTime, $EditedUsername) = array_values($Post); list($AuthorID, $Username, $PermissionID, $Paranoia, $Artist, $Donor, $Warned, $Avatar, $Enabled, $UserTitle) = array_values(Users::user_info($AuthorID)); $JsonComments[] = array('postId' => (int) $PostID, 'addedTime' => $AddedTime, 'bbBody' => $Body, 'body' => Text::full_format($Body), 'editedUserId' => (int) $EditedUserID, 'editedTime' => $EditedTime, 'editedUsername' => $EditedUsername, 'userinfo' => array('authorId' => (int) $AuthorID, 'authorName' => $Username, 'artist' => $Artist == 1, 'donor' => $Donor == 1, 'warned' => $Warned != '0000-00-00 00:00:00', 'avatar' => $Avatar, 'enabled' => $Enabled == 2 ? false : true, 'userTitle' => $UserTitle)); } json_die("success", array('page' => (int) $Page, 'pages' => ceil($NumComments / TORRENT_COMMENTS_PER_PAGE), 'comments' => $JsonComments));
/**********|| Page to show individual threads || ********************************\ Things to expect in $_GET: ThreadID: ID of the forum curently being browsed page: The page the user's on. page = 1 is the same as no page ********************************************************************************/ //---------- Things to sort out before it can start printing/generating content // Check for lame SQL injection attempts if (!is_number($_GET['collageid'])) { error(0); } $CollageID = (int) $_GET['collageid']; list($NumComments, $Page, $Thread, $LastRead) = Comments::load('collages', $CollageID); $DB->query("\n\tSELECT Name\n\tFROM collages\n\tWHERE ID = '{$CollageID}'"); list($Name) = $DB->next_record(); // Start printing View::show_header("Comments for collage {$Name}", 'comments,bbcode,subscriptions'); ?> <div class="thin"> <div class="header"> <h2> <a href="collages.php">Collages</a> > <a href="collages.php?id=<?php echo $CollageID; ?> "><?php echo $Name; ?>
print_r($TorrentTags); print_r($Tags); print_r($TorrentTagUserIDs); die(); }*/ $CoverArt = $Cache->get_value("torrents_cover_art_{$GroupID}"); if (!$CoverArt) { $DB->query("\n\t\tSELECT ID, Image, Summary, UserID, Time\n\t\tFROM cover_art\n\t\tWHERE GroupID = '{$GroupID}'\n\t\tORDER BY Time ASC"); $CoverArt = array(); $CoverArt = $DB->to_array(); if ($DB->has_results()) { $Cache->cache_value("torrents_cover_art_{$GroupID}", $CoverArt, 0); } } // Comments (must be loaded before View::show_header so that subscriptions and quote notifications are handled properly) list($NumComments, $Page, $Thread, $LastRead) = Comments::load('torrents', $GroupID); // Start output View::show_header($Title, 'browse,comments,torrent,bbcode,recommend,cover_art,subscriptions'); ?> <div class="thin"> <div class="header"> <h2><?php echo $DisplayName; ?> </h2> <div class="linkbox"> <?php if (check_perms('site_edit_wiki')) { ?> <a href="torrents.php?action=editgroup&groupid=<?php echo $GroupID;
//Votes time $RequestVotes = Requests::get_votes_array($RequestID); $VoteCount = count($RequestVotes['Voters']); $ProjectCanEdit = check_perms('project_team') && !$IsFilled && ($CategoryID == 0 || $CategoryName == 'Music' && $Request['Year'] == 0); $UserCanEdit = !$IsFilled && $LoggedUser['ID'] == $Request['UserID'] && $VoteCount < 2; $CanEdit = $UserCanEdit || $ProjectCanEdit || check_perms('site_moderate_requests'); if ($CategoryName == "Music") { $JsonMusicInfo = array('composers' => isset($ArtistForm[4]) ? pullmediainfo($ArtistForm[4]) : array(), 'dj' => isset($ArtistForm[6]) ? pullmediainfo($ArtistForm[6]) : array(), 'artists' => isset($ArtistForm[1]) ? pullmediainfo($ArtistForm[1]) : array(), 'with' => isset($ArtistForm[2]) ? pullmediainfo($ArtistForm[2]) : array(), 'conductor' => isset($ArtistForm[5]) ? pullmediainfo($ArtistForm[5]) : array(), 'remixedBy' => isset($ArtistForm[3]) ? pullmediainfo($ArtistForm[3]) : array(), 'producer' => isset($ArtistForm[7]) ? pullmediainfo($ArtistForm[7]) : array()); } else { $JsonMusicInfo = new stdClass(); //json_encodes into an empty object: {} } $JsonTopContributors = array(); $VoteMax = $VoteCount < 5 ? $VoteCount : 5; for ($i = 0; $i < $VoteMax; $i++) { $User = array_shift($RequestVotes['Voters']); $JsonTopContributors[] = array('userId' => (int) $User['UserID'], 'userName' => $User['Username'], 'bounty' => (int) $User['Bounty']); } reset($RequestVotes['Voters']); list($NumComments, $Page, $Thread) = Comments::load('requests', $RequestID, false); $JsonRequestComments = array(); foreach ($Thread as $Key => $Post) { list($PostID, $AuthorID, $AddedTime, $Body, $EditedUserID, $EditedTime, $EditedUsername) = array_values($Post); list($AuthorID, $Username, $PermissionID, $Paranoia, $Artist, $Donor, $Warned, $Avatar, $Enabled, $UserTitle) = array_values(Users::user_info($AuthorID)); $JsonRequestComments[] = array('postId' => (int) $PostID, 'authorId' => (int) $AuthorID, 'name' => $Username, 'donor' => $Donor == 1, 'warned' => $Warned != '0000-00-00 00:00:00', 'enabled' => $Enabled == 2 ? false : true, 'class' => Users::make_class_string($PermissionID), 'addedTime' => $AddedTime, 'avatar' => $Avatar, 'comment' => Text::full_format($Body), 'editedUserId' => (int) $EditedUserID, 'editedUsername' => $EditedUsername, 'editedTime' => $EditedTime); } $JsonTags = array(); foreach ($Request['Tags'] as $Tag) { $JsonTags[] = $Tag; } json_print('success', array('requestId' => (int) $RequestID, 'requestorId' => (int) $Request['UserID'], 'requestorName' => $Requestor['Username'], 'isBookmarked' => Bookmarks::has_bookmarked('request', $RequestID), 'requestTax' => $RequestTax, 'timeAdded' => $Request['TimeAdded'], 'canEdit' => $CanEdit, 'canVote' => $CanVote, 'minimumVote' => $MinimumVote, 'voteCount' => $VoteCount, 'lastVote' => $Request['LastVote'], 'topContributors' => $JsonTopContributors, 'totalBounty' => (int) $RequestVotes['TotalBounty'], 'categoryId' => (int) $CategoryID, 'categoryName' => $CategoryName, 'title' => $Request['Title'], 'year' => (int) $Request['Year'], 'image' => $Request['Image'], 'bbDescription' => $Request['Description'], 'description' => Text::full_format($Request['Description']), 'musicInfo' => $JsonMusicInfo, 'catalogueNumber' => $Request['CatalogueNumber'], 'releaseType' => (int) $Request['ReleaseType'], 'releaseName' => $ReleaseName, 'bitrateList' => preg_split('/\\|/', $Request['BitrateList'], null, PREG_SPLIT_NO_EMPTY), 'formatList' => preg_split('/\\|/', $Request['FormatList'], null, PREG_SPLIT_NO_EMPTY), 'mediaList' => preg_split('/\\|/', $Request['MediaList'], null, PREG_SPLIT_NO_EMPTY), 'logCue' => html_entity_decode($Request['LogCue']), 'isFilled' => $IsFilled, 'fillerId' => (int) $Request['FillerID'], 'fillerName' => $Filler ? $Filler['Username'] : '', 'torrentId' => (int) $Request['TorrentID'], 'timeFilled' => $Request['TimeFilled'], 'tags' => $JsonTags, 'comments' => $JsonRequestComments, 'commentPage' => (int) $Page, 'commentPages' => (int) ceil($NumComments / TORRENT_COMMENTS_PER_PAGE), 'recordLabel' => $Request['RecordLabel'], 'oclc' => $Request['OCLC']));
?> </td> </tr> <?php } } if (!empty($TorrentList)) { ?> </table> </div> <?php } $TorrentDisplayList = ob_get_clean(); //----------------- End building list and getting stats // Comments (must be loaded before View::show_header so that subscriptions and quote notifications are handled properly) list($NumComments, $Page, $Thread, $LastRead) = Comments::load('artist', $ArtistID); View::show_header($Name, 'browse,requests,bbcode,comments,voting,recommend,subscriptions'); ?> <div class="thin"> <div class="header"> <h2><?php echo display_str($Name); if ($RevisionID) { ?> (Revision #<?php echo $RevisionID; ?> )<?php } if ($VanityHouseArtist) { ?>