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)";
}
