PHP Artists::get_artist方法代码示例

     }
     //foreach ($Top10 as $Torrent)
     // Send warnings to uploaders of torrents that will be deleted this week
     $DB->query("\n\t\t\tSELECT\n\t\t\t\tt.ID,\n\t\t\t\tt.GroupID,\n\t\t\t\ttg.Name,\n\t\t\t\tt.Format,\n\t\t\t\tt.Encoding,\n\t\t\t\tt.UserID\n\t\t\tFROM torrents AS t\n\t\t\t\tJOIN torrents_group AS tg ON tg.ID = t.GroupID\n\t\t\t\tJOIN users_info AS u ON u.UserID = t.UserID\n\t\t\tWHERE t.last_action < NOW() - INTERVAL 20 DAY\n\t\t\t\tAND t.last_action != 0\n\t\t\t\tAND u.UnseededAlerts = '1'\n\t\t\tORDER BY t.last_action ASC");
     $TorrentIDs = $DB->to_array();
     $TorrentAlerts = array();
     foreach ($TorrentIDs as $TorrentID) {
         list($ID, $GroupID, $Name, $Format, $Encoding, $UserID) = $TorrentID;
         if (array_key_exists($UserID, $InactivityExceptionsMade) && time() < $InactivityExceptionsMade[$UserID]) {
             // don't notify exceptions
             continue;
         }
         if (!array_key_exists($UserID, $TorrentAlerts)) {
             $TorrentAlerts[$UserID] = array('Count' => 0, 'Msg' => '');
         }
         $ArtistName = Artists::display_artists(Artists::get_artist($GroupID), false, false, false);
         if ($ArtistName) {
             $Name = "{$ArtistName} - {$Name}";
         }
         if ($Format && $Encoding) {
             $Name .= " [{$Format} / {$Encoding}]";
         }
         $TorrentAlerts[$UserID]['Msg'] .= "\n[url=" . site_url() . "torrents.php?torrentid={$ID}]" . $Name . "[/url]";
         $TorrentAlerts[$UserID]['Count']++;
     }
     foreach ($TorrentAlerts as $UserID => $MessageInfo) {
         Misc::send_pm($UserID, 0, 'Unseeded torrent notification', $MessageInfo['Count'] . " of your uploads will be deleted for inactivity soon. Unseeded torrents are deleted after 4 weeks. If you still have the files, you can seed your uploads by ensuring the torrents are in your client and that they aren't stopped. You can view the time that a torrent has been unseeded by clicking on the torrent description line and looking for the \"Last active\" time. For more information, please go [url=" . site_url() . "wiki.php?action=article&amp;id=663]here[/url].\n\nThe following torrent" . ($MessageInfo['Count'] > 1 ? 's' : '') . ' will be removed for inactivity:' . $MessageInfo['Msg'] . "\n\nIf you no longer wish to receive these notifications, please disable them in your profile settings.");
     }
 }
 $DB->query("\n\t\tUPDATE staff_pm_conversations\n\t\tSET Status = 'Resolved', ResolverID = '0'\n\t\tWHERE Date < NOW() - INTERVAL 1 MONTH\n\t\t\tAND Status = 'Open'\n\t\t\tAND AssignedToUser IS NULL");
 Donations::schedule();

 /**
  * Update the cache and sphinx delta index to keep everything up-to-date.
  *
  * @param int $GroupID
  */
 public static function update_hash($GroupID)
 {
     $QueryID = G::$DB->get_query_id();
     G::$DB->query("\n\t\t\tUPDATE torrents_group\n\t\t\tSET TagList = (\n\t\t\t\t\tSELECT REPLACE(GROUP_CONCAT(tags.Name SEPARATOR ' '), '.', '_')\n\t\t\t\t\tFROM torrents_tags AS t\n\t\t\t\t\t\tINNER JOIN tags ON tags.ID = t.TagID\n\t\t\t\t\tWHERE t.GroupID = '{$GroupID}'\n\t\t\t\t\tGROUP BY t.GroupID\n\t\t\t\t\t)\n\t\t\tWHERE ID = '{$GroupID}'");
     // Fetch album vote score
     G::$DB->query("\n\t\t\tSELECT Score\n\t\t\tFROM torrents_votes\n\t\t\tWHERE GroupID = {$GroupID}");
     if (G::$DB->has_results()) {
         list($VoteScore) = G::$DB->next_record();
     } else {
         $VoteScore = 0;
     }
     // Fetch album artists
     G::$DB->query("\n\t\t\tSELECT GROUP_CONCAT(aa.Name separator ' ')\n\t\t\tFROM torrents_artists AS ta\n\t\t\t\tJOIN artists_alias AS aa ON aa.AliasID = ta.AliasID\n\t\t\tWHERE ta.GroupID = {$GroupID}\n\t\t\t\tAND ta.Importance IN ('1', '4', '5', '6')\n\t\t\tGROUP BY ta.GroupID");
     if (G::$DB->has_results()) {
         list($ArtistName) = G::$DB->next_record(MYSQLI_NUM, false);
     } else {
         $ArtistName = '';
     }
     G::$DB->query("\n\t\t\tREPLACE INTO sphinx_delta\n\t\t\t\t(ID, GroupID, GroupName, TagList, Year, CategoryID, Time, ReleaseType, RecordLabel,\n\t\t\t\tCatalogueNumber, VanityHouse, Size, Snatched, Seeders, Leechers, LogScore, Scene, HasLog,\n\t\t\t\tHasCue, FreeTorrent, Media, Format, Encoding, Description, RemasterYear, RemasterTitle,\n\t\t\t\tRemasterRecordLabel, RemasterCatalogueNumber, FileList, VoteScore, ArtistName)\n\t\t\tSELECT\n\t\t\t\tt.ID, g.ID, Name, TagList, Year, CategoryID, UNIX_TIMESTAMP(t.Time), ReleaseType,\n\t\t\t\tRecordLabel, CatalogueNumber, VanityHouse, Size, Snatched, Seeders,\n\t\t\t\tLeechers, LogScore, CAST(Scene AS CHAR), CAST(HasLog AS CHAR), CAST(HasCue AS CHAR),\n\t\t\t\tCAST(FreeTorrent AS CHAR), Media, Format, Encoding, Description,\n\t\t\t\tRemasterYear, RemasterTitle, RemasterRecordLabel, RemasterCatalogueNumber,\n\t\t\t\tREPLACE(REPLACE(FileList, '_', ' '), '/', ' ') AS FileList, {$VoteScore}, '" . db_string($ArtistName) . "'\n\t\t\tFROM torrents AS t\n\t\t\t\tJOIN torrents_group AS g ON g.ID = t.GroupID\n\t\t\tWHERE g.ID = {$GroupID}");
     G::$Cache->delete_value("torrents_details_{$GroupID}");
     G::$Cache->delete_value("torrent_group_{$GroupID}");
     G::$Cache->delete_value("torrent_group_light_{$GroupID}");
     $ArtistInfo = Artists::get_artist($GroupID);
     foreach ($ArtistInfo as $Importances => $Importance) {
         foreach ($Importance as $Artist) {
             G::$Cache->delete_value('artist_groups_' . $Artist['id']);
             //Needed for at least freeleech change, if not others.
         }
     }
     G::$Cache->delete_value("groups_artists_{$GroupID}");
     G::$DB->set_query_id($QueryID);
 }

$ScriptUAs = array('BTWebClient*', 'Python-urllib*', 'python-requests*', 'uTorrent*');
if (Misc::in_array_partial($_SERVER['HTTP_USER_AGENT'], $ScriptUAs)) {
    $DB->query("\n\t\tSELECT 1\n\t\tFROM users_downloads\n\t\tWHERE UserID = {$UserID}\n\t\t\tAND TorrentID = {$TorrentID}\n\t\tLIMIT 4");
    if ($DB->record_count() === 4) {
        error('You have already downloaded this torrent file four times. If you need to download it again, please do so from your browser.', true);
        die;
    }
}
$Info = $Cache->get_value('torrent_download_' . $TorrentID);
if (!is_array($Info) || !array_key_exists('PlainArtists', $Info) || empty($Info[10])) {
    $DB->query("\n\t\tSELECT\n\t\t\tt.Media,\n\t\t\tt.Format,\n\t\t\tt.Encoding,\n\t\t\tIF(t.RemasterYear = 0, tg.Year, t.RemasterYear),\n\t\t\ttg.ID AS GroupID,\n\t\t\ttg.Name,\n\t\t\ttg.WikiImage,\n\t\t\ttg.CategoryID,\n\t\t\tt.Size,\n\t\t\tt.FreeTorrent,\n\t\t\tt.info_hash\n\t\tFROM torrents AS t\n\t\t\tINNER JOIN torrents_group AS tg ON tg.ID = t.GroupID\n\t\tWHERE t.ID = '" . db_string($TorrentID) . "'");
    if (!$DB->has_results()) {
        error(404);
    }
    $Info = array($DB->next_record(MYSQLI_NUM, array(4, 5, 6, 10)));
    $Artists = Artists::get_artist($Info[0][4], false);
    $Info['Artists'] = Artists::display_artists($Artists, false, true);
    $Info['PlainArtists'] = Artists::display_artists($Artists, false, true, false);
    $Cache->cache_value("torrent_download_{$TorrentID}", $Info, 0);
}
if (!is_array($Info[0])) {
    error(404);
}
list($Media, $Format, $Encoding, $Year, $GroupID, $Name, $Image, $CategoryID, $Size, $FreeTorrent, $InfoHash) = array_shift($Info);
// used for generating the filename
$Artists = $Info['Artists'];
// If he's trying use a token on this, we need to make sure he has one,
// deduct it, add this to the FLs table, and update his cache key.
if ($_REQUEST['usetoken'] && $FreeTorrent == '0') {
    if (isset($LoggedUser)) {
        $FLTokens = $LoggedUser['FLTokens'];

function generate_torrent_json($Caption, $Tag, $Details, $Limit)
{
    global $LoggedUser, $Categories;
    $results = array();
    foreach ($Details as $Detail) {
        list($TorrentID, $GroupID, $GroupName, $GroupCategoryID, $WikiImage, $TorrentTags, $Format, $Encoding, $Media, $Scene, $HasLog, $HasCue, $LogScore, $Year, $GroupYear, $RemasterTitle, $Snatched, $Seeders, $Leechers, $Data, $ReleaseType, $Size) = $Detail;
        $Artist = Artists::display_artists(Artists::get_artist($GroupID), false, true);
        $TruncArtist = substr($Artist, 0, strlen($Artist) - 3);
        $TagList = array();
        if ($TorrentTags != '') {
            $TorrentTags = explode(' ', $TorrentTags);
            foreach ($TorrentTags as $TagKey => $TagName) {
                $TagName = str_replace('_', '.', $TagName);
                $TagList[] = $TagName;
            }
        }
        // Append to the existing array.
        $results[] = array('torrentId' => (int) $TorrentID, 'groupId' => (int) $GroupID, 'artist' => $TruncArtist, 'groupName' => $GroupName, 'groupCategory' => (int) $GroupCategory, 'groupYear' => (int) $GroupYear, 'remasterTitle' => $RemasterTitle, 'format' => $Format, 'encoding' => $Encoding, 'hasLog' => $HasLog == 1, 'hasCue' => $HasCue == 1, 'media' => $Media, 'scene' => $Scene == 1, 'year' => (int) $Year, 'tags' => $TagList, 'snatched' => (int) $Snatched, 'seeders' => (int) $Seeders, 'leechers' => (int) $Leechers, 'data' => (int) $Data, 'size' => (int) $Size);
    }
    return array('caption' => $Caption, 'tag' => $Tag, 'limit' => (int) $Limit, 'results' => $results);
}

} else {
    $RevisionID = 0;
}
include SERVER_ROOT . '/sections/torrents/functions.php';
$TorrentCache = get_group_info($GroupID, true, $RevisionID);
$TorrentDetails = $TorrentCache[0];
$TorrentList = $TorrentCache[1];
// Group details
list($WikiBody, $WikiImage, $GroupID, $GroupName, $GroupYear, $GroupRecordLabel, $GroupCatalogueNumber, $ReleaseType, $GroupCategoryID, $GroupTime, $GroupVanityHouse, $TorrentTags, $TorrentTagIDs, $TorrentTagUserIDs, $TagPositiveVotes, $TagNegativeVotes, $GroupFlags) = array_values($TorrentDetails);
$DisplayName = "<span dir=\"ltr\">{$GroupName}</span>";
$AltName = $GroupName;
// Goes in the alt text of the image
$Title = $GroupName;
// goes in <title>
$WikiBody = Text::full_format($WikiBody);
$Artists = Artists::get_artist($GroupID);
if ($Artists) {
    $DisplayName = Artists::display_artists($Artists, true) . "{$DisplayName}";
    $AltName = display_str(Artists::display_artists($Artists, false)) . $AltName;
    $Title = $AltName;
}
if ($GroupYear > 0) {
    $DisplayName .= " [{$GroupYear}]";
    $AltName .= " [{$GroupYear}]";
    $Title .= " [{$GroupYear}]";
}
if ($GroupVanityHouse) {
    $DisplayName .= ' [Vanity House]';
    $AltName .= ' [Vanity House]';
}
if ($GroupCategoryID == 1) {

        }
    }
}
if ($TorrentID <= 0) {
    json_die("failure", "bad id parameter");
}
$TorrentCache = get_torrent_info($TorrentID, true, 0, true, true);
if (!$TorrentCache) {
    json_die("failure", "bad id parameter");
}
list($TorrentDetails, $TorrentList) = $TorrentCache;
if (!isset($TorrentList[$TorrentID])) {
    json_die("failure", "bad id parameter");
}
$GroupID = $TorrentDetails['ID'];
$ArtistForm = Artists::get_artist($GroupID);
if ($TorrentDetails['CategoryID'] == 0) {
    $CategoryName = "Unknown";
} else {
    $CategoryName = $Categories[$TorrentDetails['CategoryID'] - 1];
}
$JsonMusicInfo = array();
if ($CategoryName == "Music") {
    $JsonMusicInfo = array('composers' => $ArtistForm[4] == null ? array() : pullmediainfo($ArtistForm[4]), 'dj' => $ArtistForm[6] == null ? array() : pullmediainfo($ArtistForm[6]), 'artists' => $ArtistForm[1] == null ? array() : pullmediainfo($ArtistForm[1]), 'with' => $ArtistForm[2] == null ? array() : pullmediainfo($ArtistForm[2]), 'conductor' => $ArtistForm[5] == null ? array() : pullmediainfo($ArtistForm[5]), 'remixedBy' => $ArtistForm[3] == null ? array() : pullmediainfo($ArtistForm[3]), 'producer' => $ArtistForm[7] == null ? array() : pullmediainfo($ArtistForm[7]));
} else {
    $JsonMusicInfo = null;
}
$TagList = explode('|', $TorrentDetails['GROUP_CONCAT(DISTINCT tags.Name SEPARATOR \'|\')']);
$JsonTorrentDetails = array('wikiBody' => Text::full_format($TorrentDetails['WikiBody']), 'wikiImage' => $TorrentDetails['WikiImage'], 'id' => (int) $TorrentDetails['ID'], 'name' => $TorrentDetails['Name'], 'year' => (int) $TorrentDetails['Year'], 'recordLabel' => $TorrentDetails['RecordLabel'], 'catalogueNumber' => $TorrentDetails['CatalogueNumber'], 'releaseType' => (int) $TorrentDetails['ReleaseType'], 'categoryId' => (int) $TorrentDetails['CategoryID'], 'categoryName' => $CategoryName, 'time' => $TorrentDetails['Time'], 'vanityHouse' => $TorrentDetails['VanityHouse'] == 1, 'isBookmarked' => Bookmarks::has_bookmarked('torrent', $GroupID), 'musicInfo' => $JsonMusicInfo, 'tags' => $TagList);
$Torrent = $TorrentList[$TorrentID];
$Reports = Torrents::get_reports($TorrentID);

                foreach ($Media as $Key => $Val) {
                    if (in_array($Val, $MediaTemp)) {
                        $MediaArray[] = $Key;
                    }
                }
            }
        }
        $Tags = implode(', ', $Request['Tags']);
    }
}
if ($NewRequest && !empty($_GET['artistid']) && is_number($_GET['artistid'])) {
    $DB->query("\n\t\tSELECT Name\n\t\tFROM artists_group\n\t\tWHERE artistid = " . $_GET['artistid'] . "\n\t\tLIMIT 1");
    list($ArtistName) = $DB->next_record();
    $ArtistForm = array(1 => array(array('name' => trim($ArtistName))), 2 => array(), 3 => array());
} elseif ($NewRequest && !empty($_GET['groupid']) && is_number($_GET['groupid'])) {
    $ArtistForm = Artists::get_artist($_GET['groupid']);
    $DB->query("\n\t\tSELECT\n\t\t\ttg.Name,\n\t\t\ttg.Year,\n\t\t\ttg.ReleaseType,\n\t\t\ttg.WikiImage,\n\t\t\tGROUP_CONCAT(t.Name SEPARATOR ', '),\n\t\t\ttg.CategoryID\n\t\tFROM torrents_group AS tg\n\t\t\tJOIN torrents_tags AS tt ON tt.GroupID = tg.ID\n\t\t\tJOIN tags AS t ON t.ID = tt.TagID\n\t\tWHERE tg.ID = " . $_GET['groupid']);
    if (list($Title, $Year, $ReleaseType, $Image, $Tags, $CategoryID) = $DB->next_record()) {
        $GroupID = trim($_REQUEST['groupid']);
    }
}
View::show_header($NewRequest ? 'Create a request' : 'Edit a request', 'requests,form_validate');
?>
<div class="thin">
	<div class="header">
		<h2><?php 
echo $NewRequest ? 'Create a request' : 'Edit a request';
?>
</h2>
	</div>

			tg.Year,
			tg.RecordLabel,
			tg.CatalogueNumber,
			tg.WikiImage AS Image,
			tg.WikiBody AS GroupDescription,
			tg.ReleaseType,
			tg.VanityHouse
		FROM torrents_group AS tg
			LEFT JOIN torrents AS t ON t.GroupID = tg.ID
		WHERE tg.ID = ' . $_GET['groupid'] . '
		GROUP BY tg.ID');
    if ($DB->has_results()) {
        list($Properties) = $DB->to_array(false, MYSQLI_BOTH);
        $UploadForm = $Categories[$Properties['CategoryID'] - 1];
        $Properties['CategoryName'] = $Categories[$Properties['CategoryID'] - 1];
        $Properties['Artists'] = Artists::get_artist($_GET['groupid']);
        $DB->query("\n\t\t\tSELECT\n\t\t\t\tGROUP_CONCAT(tags.Name SEPARATOR ', ') AS TagList\n\t\t\tFROM torrents_tags AS tt\n\t\t\t\tJOIN tags ON tags.ID = tt.TagID\n\t\t\tWHERE tt.GroupID = '{$_GET['groupid']}'");
        list($Properties['TagList']) = $DB->next_record();
    } else {
        unset($_GET['groupid']);
    }
    if (!empty($_GET['requestid']) && is_number($_GET['requestid'])) {
        $Properties['RequestID'] = $_GET['requestid'];
    }
} elseif (empty($Properties) && !empty($_GET['requestid']) && is_number($_GET['requestid'])) {
    $DB->query('
		SELECT
			ID AS RequestID,
			CategoryID,
			Title AS Title,
			Year,

if ($FeaturedAlbum === false) {
    $DB->query('
		SELECT
			fa.GroupID,
			tg.Name,
			tg.WikiImage,
			fa.ThreadID,
			fa.Title
		FROM featured_albums AS fa
			JOIN torrents_group AS tg ON tg.ID = fa.GroupID
		WHERE Ended = 0');
    $FeaturedAlbum = $DB->next_record();
    $Cache->cache_value('featured_album', $FeaturedAlbum, 0);
}
if (is_number($FeaturedAlbum['GroupID'])) {
    $Artists = Artists::get_artist($FeaturedAlbum['GroupID']);
    ?>
		<div class="box">
			<div class="head colhead_dark"><strong>Featured Album</strong></div>
			<div class="center pad">
				<?php 
    echo Artists::display_artists($Artists, true, true);
    ?>
<a href="torrents.php?id=<?php 
    echo $FeaturedAlbum['GroupID'];
    ?>
"><?php 
    echo $FeaturedAlbum['Name'];
    ?>
</a>
			</div>