// Set here the URL to your 4images Gallery. WITH trailing slash! 
define('SCRIPT_URL', 'http://YOUR_URL_TO/4images/');


// Set here your THUMBNAIL directory. Normally no need to change. WITHOUT trailing slash!
define('THUMB_DIR', 'data/thumbnails');

function is_remote($file_name) {
  return (preg_match('#^https?\\:\\/\\/[a-z0-9\-]+\.([a-z0-9\-]+\.)?[a-z]+#i', $file_name)) ? 1 : 0;
}

// In following queries CHANGE 4images table PREFIX if it doesn't match (Standard "model_")!
$sql = "SELECT COUNT(*) as total_images
        FROM 4images_images a, 4images_categories b 
        WHERE a.image_active=1 
        AND a.cat_id = b.cat_id 
        AND b.auth_viewcat=0 
        AND b.auth_viewimage=0
        ";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
$total_images = $row['total_images'];

mt_srand((double)microtime() * 1000000);
$number = ($total_images > 1) ? mt_rand(0, $total_images - 1) : 0;

$sql = "SELECT a.image_id, a.cat_id, a.image_name, a.image_active, a.image_thumb_file, a.image_comments 
        FROM 4images_images a, 4images_categories b 
        WHERE a.image_active=1 
        AND a.cat_id = b.cat_id 
        AND b.auth_viewcat=0 
        AND b.auth_viewimage=0 ORDER BY RAND() 
        LIMIT $number, 1";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
if (!empty($row)) {
  $image_id = $row['image_id'];
  $cat_id = $row['cat_id'];
  $image_name = $row['image_name'];
  $image_comments = $row['image_comments'];
  $thumb_src = (is_remote($row['image_thumb_file'])) ? $row['image_thumb_file'] : SCRIPT_URL.THUMB_DIR."/".$cat_id."/".$row['image_thumb_file']; 
  $randompic = "<a href=\"".SCRIPT_URL."details.php?image_id=$image_id\"><img src=\"".$thumb_src."\" border=\"1\" alt=\"$image_name\"></a><br><font size=\"1\">Bild Name: $image_name<br>Bild Kommentare: $image_comments</font>\n";
} else {
  $randompic = "<font size=\"4\">NIX DA</font>";
}
print <<<EOT
<table border="0" width="100%" cellspacing="0" cellpadding="0"><tr><td align="center">$randompic</td></tr></table>
EOT;