Show Posts
1
Mods & Plugins (Releases & Support) / Re: [Mod] Random image / Zufallsbild
« on: November 28, 2002, 12:18:10 AM »
@ Jan - Thanks Jan - that removed the link. I am still stuck with the white backgraound. I've tried everything even CSS. Nothing works. Here is my code from inside PostWrap:
<html>
<body bgcolor="#e5e5e5">
<p align="center">
<iframe src="http://www.chphoto.net/chphoto/random.php" name="I1" width="100" marginwidth="0" height="100" marginheight="0" align="middle" scrolling="no" frameborder="0" vspace="0" style="color: grey" border="o" >
</iframe>
<a href="modules.php?op=modload&name=PostWrap&file=index&page=chphoto">CHPHOTO.NET</a>
</p>
</body>
</html>
But I think the color may need to be set in random.php
Here is my code:
<?php
// PATH to your 4images Gallery / PFAD zu Ihrer 4images Gallerie
define('ROOT_PATH', '../chphoto/');
define('SCRIPT_URL', 'http://www.chphoto.net/chphoto/');
include(ROOT_PATH.'config.php');
include(ROOT_PATH.'includes/db_mysql.php');
include(ROOT_PATH.'includes/constants.php');
$site_db = new Db($db_host, $db_user, $db_password, $db_name);
function is_remote($file_name) {
return (preg_match('#^https?\\:\\/\\/[a-z0-9\-]+\.([a-z0-9\-]+\.)?[a-z]+#i', $file_name)) ? 1 : 0;
}
$sql = "SELECT COUNT(*) as total_images
FROM ".IMAGES_TABLE." a, ".CATEGORIES_TABLE." b
WHERE a.image_active=1
AND a.cat_id = b.cat_id
AND b.auth_viewcat=".AUTH_ALL."
AND b.auth_viewimage=".AUTH_ALL."
";
$row = $site_db->query_firstrow($sql);
$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 ".IMAGES_TABLE." a, ".CATEGORIES_TABLE." b
WHERE a.image_active=1
AND a.cat_id = b.cat_id
AND b.auth_viewcat=".AUTH_ALL."
AND b.auth_viewimage=".AUTH_ALL."
LIMIT $number, 1";
$row = $site_db->query_firstrow($sql);
$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'];
echo "<Center><img src=\"".$thumb_src."\" border=\"0\" alt=\"$image_name\"></a></Center><br>\n";
?>
<html>
<body bgcolor="#e5e5e5">
<p align="center">
<iframe src="http://www.chphoto.net/chphoto/random.php" name="I1" width="100" marginwidth="0" height="100" marginheight="0" align="middle" scrolling="no" frameborder="0" vspace="0" style="color: grey" border="o" >
</iframe>
<a href="modules.php?op=modload&name=PostWrap&file=index&page=chphoto">CHPHOTO.NET</a>
</p>
</body>
</html>
But I think the color may need to be set in random.php
Here is my code:
<?php
// PATH to your 4images Gallery / PFAD zu Ihrer 4images Gallerie
define('ROOT_PATH', '../chphoto/');
define('SCRIPT_URL', 'http://www.chphoto.net/chphoto/');
include(ROOT_PATH.'config.php');
include(ROOT_PATH.'includes/db_mysql.php');
include(ROOT_PATH.'includes/constants.php');
$site_db = new Db($db_host, $db_user, $db_password, $db_name);
function is_remote($file_name) {
return (preg_match('#^https?\\:\\/\\/[a-z0-9\-]+\.([a-z0-9\-]+\.)?[a-z]+#i', $file_name)) ? 1 : 0;
}
$sql = "SELECT COUNT(*) as total_images
FROM ".IMAGES_TABLE." a, ".CATEGORIES_TABLE." b
WHERE a.image_active=1
AND a.cat_id = b.cat_id
AND b.auth_viewcat=".AUTH_ALL."
AND b.auth_viewimage=".AUTH_ALL."
";
$row = $site_db->query_firstrow($sql);
$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 ".IMAGES_TABLE." a, ".CATEGORIES_TABLE." b
WHERE a.image_active=1
AND a.cat_id = b.cat_id
AND b.auth_viewcat=".AUTH_ALL."
AND b.auth_viewimage=".AUTH_ALL."
LIMIT $number, 1";
$row = $site_db->query_firstrow($sql);
$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'];
echo "<Center><img src=\"".$thumb_src."\" border=\"0\" alt=\"$image_name\"></a></Center><br>\n";
?>
