[Question] Keeping some categories out of the New Images

[Vraxor]

Hi all,

I have a question about the "new images" at the main page of 4images.

As I currently have a digital art site and one of the categories is Ecards.
Now would i like to upload many Ecards there, but I would not like to see them apear in the new images list. Is this possible?

Also am I thinking about creating a downloads category where users can upload there own files to share, but I don't want that to appear at the new images too, so is it possible to exclude some categories from the new images and if so could someone point me in the right direction.

I don't know if it has already been done by someone, but if someone could give me some help getting started, I know where to search and then I hope to be able to figure the rest out myself.

Cheers,
Vraxor

[Jan]

Best way is to set the date in the past while adding the images. Or you expand the sql query in index.php:

Code: [Select]

AND i.cat_id NOT IN (<cat_id1>, <cat_id2>)
Jan

[Vraxor]

Ok Thanks Jan,

I will try this.

[migraul]

Best way is to set the date in the past while adding the images. Or you expand the sql query in index.php:

Code: [Select]

AND i.cat_id NOT IN (<cat_id1>, <cat_id2>)
Jan

Hallo Jan, an welche Stelle muss dieser Code im SQL?

Danke im voraus!

[Neo1]

Würde mich auch interessieren. Ich möchte nur neue Bilder aus einer Kategorie anzeigen lassen.....die anderen neuen Bilder sollen nicht auf dem Index erscheinen.

[migraul]

Würde mich auch interessieren. Ich möchte nur neue Bilder aus einer Kategorie anzeigen lassen.....die anderen neuen Bilder sollen nicht auf dem Index erscheinen.

$num_new_images = 8;
$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").get_user_table_field(", u.", "user_homepage")."
        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 IN
(".get_auth_cat_sql("auth_viewcat").")
    AND i.cat_id NOT IN (68,4,81)
Just look for something like this under the

//-----------------------------------------------------
//--- Show New Images ---------------------------------
//-----------------------------------------------------

Good Luck,
Vraxor

Dies habe ich vom Super freundlichen Vraxor bekommen, Hier nochmals dank an ihn!

[Neo1]

Vielen Dank

Ich hab das auch in meine new_pics.php für die Startseite der Homepage eingebaut. Funktioniert wunderbar. Ich mußte nur

Code: [Select]

i.cat
gegen

Code: [Select]

a.cat
austauschen.