function DisplayAllTags() { $TagQuery = mysql_query("Select `Name` from `Tags` group by `Name`"); while (list($TagName) = mysql_fetch_array($TagQuery)) { $CountQuery = mysql_query("Select `ID` from `Tags` where `Name`='{$TagName}'"); $ImageCount = mysql_num_rows($CountQuery); $TagPermalink = Permalink($TagName); $Tags .= "<div class='tag' style='display:inline-block'><a href='/view/{$TagPermalink}/'>{$TagName}</a> ({$ImageCount})</div> "; } return $Tags; }
function HandleImage($ID, $Source, $URL, $Caption) { $SourceQuery = mysql_query("Select `URL`, `Tags` from `Sites` where `ID`='{$Source}'"); list($SourceURL, $SourceTags) = mysql_fetch_array($SourceQuery); $Time = time(); $Permalink = Permalink($Caption); mysql_query("Insert into `Images` values ('', '{$Time}', '{$URL}', '{$SourceURL}', '{$Caption}', '{$Permalink}', '0')"); $ImageID = mysql_insert_id(); echo "{$ID} - {$Source} - {$URL} - {$Permalink} - {$Caption}<br />\n"; $Tags = explode(',', $SourceTags); foreach ($Tags as $Tag) { $Tag = trim($Tag); mysql_query("Insert into `Tags` values ('', '{$Tag}', '{$ImageID}')"); } mysql_query("Delete from `Queue` where `ID`='{$ID}'"); }
echo "<center><a href='/'><img src='{$Image}' /></a></center>"; $Extra = "<a href='{$Image}' target='_blank'>View Full Size</a>"; $Tags = DisplayTags($Redirect[1]); } elseif (empty($Redirect[1])) { $Tags = DisplayAllTags(); } else { $Tag = filter_var(str_replace('-', ' ', $Redirect[1]), FILTER_SANITIZE_SPECIAL_CHARS); $CountQuery = mysql_query("Select `ID` from `Tags` where `Name`='{$Tag}'"); $ImageCount = mysql_num_rows($CountQuery); $RandomOffset = rand(0, $ImageCount - 1); #echo "Count: $ImageCount<br />"; #echo "Seen: ".count($_SESSION[$Tag]['Seen'])."<br />"; while ($_SESSION[$Tag]['Seen'][$RandomOffset]) { if ($ImageCount - 1 <= count($_SESSION[$Tag]['Seen'])) { unset($_SESSION[$Tag]); } $RandomOffset = rand(0, $ImageCount - 1); } $_SESSION[$Tag]['Seen'][$RandomOffset] = true; $RandomQuery = mysql_query("Select `Image` from `Tags` where `Name`='{$Tag}' limit {$RandomOffset}, 1"); list($ImageID) = mysql_fetch_array($RandomQuery); $ImageQuery = mysql_query("Select `URL`, `Caption`, `Permalink` from `Images` where `ID`='{$ImageID}'"); list($URL, $Caption, $Permalink) = mysql_fetch_array($ImageQuery); $Title = "<a href='/view/{$ImageID}/{$Permalink}/'>{$Caption}</a>"; $Image = "{$URL}"; $TagPermalink = Permalink($Tag); echo "<center><a href='/view/{$TagPermalink}/'><img src='{$Image}' /></a></center>"; $Extra = "<a href='{$Image}' target='_blank'>View Full Size</a>"; $Tags = DisplayTags($ImageID); #echo "Displaying a random image from tag: $Tag ($ImageCount)"; }