4images Forum & Community

4images Modifications / Modifikationen => Mods & Plugins (Requests & Discussions) => Topic started by: ilaslan on January 20, 2011, 01:40:58 AM

Title: which command :cat has no images?
Post by: ilaslan on January 20, 2011, 01:40:58 AM

hello
i have this code

$sql = "SELECT 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 i.cat_id = $cat_random AND c.cat_id = i.cat_id
        ORDER BY ".$selection[$cnt]." DESC, ".$selection_alt[$cnt];

this code is changed from mini top mod
but i have a small problem. some categories has no images. and in this cod $cat_random is random categories.

so there is a problem for me

so i need above in this code like
if ( $cat_random category has no images ) {  ..... }

ty all

Title: Re: which command :cat has no images?
Post by: V@no on January 20, 2011, 01:58:30 AM

Assuming you have your category ID stored in $cat_id variable, then you can use this simple check:
if (!$cat_cache[$cat_id]['num_images'])
{
// your code here, this category has no images
}