1
Discussion & Troubleshooting / Re: How to use search by keywords only in the URL
« on: June 28, 2010, 02:15:46 PM »
V@no, just 3 words: You are Genius!
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
http://mysite/search.php?search_fields=image_keywords&search_keywords=whatever
can you send/receive any kind of emails from your 4images?
Hi to all.
Why admins do not receive comments for their images?
I'm using 1.7.4
Thanks.
UPDATE : Fix it . Thanks
<?php
define('ROOT_PATH', './');
include(ROOT_PATH.'config.php');
$site_db = new Db($db_host, $db_user, $db_password, $db_name);
$num_images = 4;
$config['image_cells'] = 2;
$i = 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."
ORDER BY a.image_id DESC
LIMIT $num_images";
$result = $site_db->query($sql);
while ($row = $site_db->fetch_array($result)){
$image_id = $row['image_id'];
$cat_id = $row['cat_id'];
$image_name = $row['image_name'];
$image_comments = $row['image_comments'];
if($i == $config['image_cells']) {
echo "<td> </td></tr><TR><td> </td>";
}
$thumb_src = (is_remote($row['image_thumb_file'])) ? $row['image_thumb_file'] : ROOT_PATH.THUMB_DIR."/".$cat_id."/".$row['image_thumb_file'];
echo "<td><a href=\"".ROOT_PATH."details.php?image_id=$image_id\"><img width=\"98\" height=\"98\" src=\"".$thumb_src."\" class=\"imageBoxSmall\" alt=\"$image_name | $image_comments comments\"></a></td>";
echo $cat_cache[$subcat_id];
$i++;
}
?>