Esempi in PHP per Requests::get_tags

Esempio n. 1

File: upload.php Progetto: Kufirc/Gazelle

		SELECT
			ID AS RequestID,
			CategoryID,
			Title AS Title,
			Year,
			RecordLabel,
			CatalogueNumber,
			ReleaseType,
			Image
		FROM requests
		WHERE ID = ' . $_GET['requestid']);
    list($Properties) = $DB->to_array(false, MYSQLI_BOTH);
    $UploadForm = $Categories[$Properties['CategoryID'] - 1];
    $Properties['CategoryName'] = $Categories[$Properties['CategoryID'] - 1];
    $Properties['Artists'] = Requests::get_artists($_GET['requestid']);
    $Properties['TagList'] = implode(', ', Requests::get_tags($_GET['requestid'])[$_GET['requestid']]);
}
if (!empty($ArtistForm)) {
    $Properties['Artists'] = $ArtistForm;
}
require SERVER_ROOT . '/classes/torrent_form.class.php';
$TorrentForm = new TORRENT_FORM($Properties, $Err);
$GenreTags = $Cache->get_value('genre_tags');
if (!$GenreTags) {
    $DB->query("\n\t\tSELECT Name\n\t\tFROM tags\n\t\tWHERE TagType = 'genre'\n\t\tORDER BY Name");
    $GenreTags = $DB->collect('Name');
    $Cache->cache_value('genre_tags', $GenreTags, 3600 * 6);
}
$DB->query('
	SELECT
		Name,

Esempio n. 2

File: artist.php Progetto: Kufirc/Gazelle

			<td style="width: 48%;">
				<a href="#">&uarr;</a>&nbsp;
				<strong>Request Name</strong>
			</td>
			<td class="nobr">
				<strong>Vote</strong>
			</td>
			<td class="nobr">
				<strong>Bounty</strong>
			</td>
			<td>
				<strong>Added</strong>
			</td>
		</tr>
<?php 
    $Tags = Requests::get_tags(array_keys($Requests));
    $Row = 'b';
    foreach ($Requests as $RequestID => $Request) {
        $CategoryName = $Categories[$Request['CategoryID'] - 1];
        $Title = display_str($Request['Title']);
        if ($CategoryName == 'Music') {
            $ArtistForm = Requests::get_artists($RequestID);
            $ArtistLink = Artists::display_artists($ArtistForm, true, true);
            $FullName = $ArtistLink . "<a href=\"requests.php?action=view&amp;id={$RequestID}\"><span dir=\"ltr\">{$Title}</span> [{$Request['Year']}]</a>";
        } elseif ($CategoryName == 'Audiobooks' || $CategoryName == 'Comedy') {
            $FullName = "<a href=\"requests.php?action=view&amp;id={$RequestID}\"><span dir=\"ltr\">{$Title}</span> [{$Request['Year']}]</a>";
        } else {
            $FullName = "<a href=\"requests.php?action=view&amp;id={$RequestID}\" dir=\"ltr\">{$Title}</a>";
        }
        if (!empty($Tags[$RequestID])) {
            $ReqTagList = array();