1
Mods & Plugins (Requests & Discussions) / Re: Joomla and 4images Single Login/ NEW and it should work
« on: December 13, 2006, 07:50:49 PM »
I'd appretiate it, thanks tdkpaul
You're looking for some 4images templates and styles? Then visit this thread to show websites with 4images templates to download.
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.
in fresh 1.7.2 this mod works finereally? Oo
$new_cutoff = time() - 60 * 60 * 24 * $config['new_cutoff'];
$num_new_images = $config['image_cells'];
$sql = "SELECT IF(i.image_date >= $new_cutoff,RAND()+1,1) as random_no, i.image_id, i.cat_id, i.user_id, i.image_name, i.image_description, i.image_keywords, i.image_date, i.image_active, i.image_media_file, i.image_thumb_file, i.image_download_url, i.image_allow_comments, i.image_comments, i.image_downloads, i.image_votes, i.image_rating, i.image_hits".$additional_sql.", c.cat_name".get_user_table_field(", u.", "user_name")."
FROM (".IMAGES_TABLE." i, ".CATEGORIES_TABLE." c)
LEFT JOIN ".USERS_TABLE." u ON (".get_user_table_field("u.", "user_id")." = i.user_id)
WHERE i.image_active = 1 AND c.cat_id = i.cat_id AND i.cat_id NOT IN (".get_auth_cat_sql("auth_viewcat", "NOTIN").")
ORDER BY random_no DESC, RAND(), i.image_date DESC
LIMIT $num_new_images";