Exclude Category from New Images

[sigma.]

Hi,

Is there a way to exclude images being added to the latest images from a certain category, or one that has certain user group permissions attached to it?

I basicly dont want images from a certain category to show up in the 'New Images' area of my site.

Is this possible?

[mawenzi]

...if you want to exclude certain categories (e.g. 1,2,3), than use in your new_images_query ...

Code: [Select]

AND i.cat_id NOT IN (1,2,3)


[sigma.]

Hi mawenzi,

are saying this is only possible in phpMyadmin?

What Im just trying to do is exclude a certain category from the {new_images} section on my site. So basicly no new thumbnails/images get displayed in {new_images} from for example cat_id=24

[mawenzi]

... in index.php find in //--- Show New Images ---- the following ...

Code: [Select]

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").")

... and add after ...

Code: [Select]

AND i.cat_id NOT IN (24)


[sigma.]

dam man, i wish i had your skills. Thank you very much AGAIN. Ive excluded multiple categories by seperating them using a comma. (192,67,84) and so on.
Works great

[jrey]

Im using this solution for my gallery and works fine, but the problem that I have is that the statistics in category "New Images" are showing the total number of images ( the real number, counting the images that Im not showing in "New Images" ) and its showing the paging of this result, then if for example I have 50 images but Im showing only 12, there is not really a second page with more images, but paging says that yes, and if you press in the link to the second page you will not see anything, only a page with not images. How can I adapt the "real" statistics and paging to my modified/restricted results ?. I want that statistics says " There are 12 new images" and not  "There are 50 new images" in three pages  - Got to page 2,3 "  ( continuing with the example ).

Thanks in advance.

Javi

[mawenzi]

@jrey
in search.php find

Code: [Select]

if (!empty($search_id['search_new_images']) && $search_id['search_new_images'] == 1) {
    $new_cutoff = time() - 60 * 60 * 24 * $config['new_cutoff'];
    $sql_where_query .= "AND i.image_date >= $new_cutoff ";
}

and change it to

Code: [Select]

if (!empty($search_id['search_new_images']) && $search_id['search_new_images'] == 1) {
    $new_cutoff = time() - 60 * 60 * 24 * $config['new_cutoff'];
    $sql_where_query .= "AND i.image_date >= $new_cutoff AND i.cat_id NOT IN (1,2,3)";
}

where (1,2,3) are the categories you want to exclude ...

[Loda]

another solution:
you create a table called e.g. "digi_cat_id" in the 4images_settings table
then you insert in admin/settings.php after:

Code: [Select]

show_setting_row("random_cat_id", $random_cat_id);
this:

Code: [Select]

show_setting_row("digi_cat_id", $digi_cat_id);and in the lang/your lang/admin.php:

Code: [Select]

$setting['digi_cat_id'] = "Exclude Category from all Images";
and then in every page e.g. index.php, search.php, top.php etc..
you can insert this in the sql:

Code: [Select]

AND i.cat_id NOT IN (".$config['digi_cat_id'].")
in the acp you see in the settings a new field. insert in this field the cat id exclude from images
you can insert there many cat ids for example:
1, 2, 3

[jrey]

    Yes, its perfect !!. Thank you very much to both, I did it and now I can configure in my acp the categories that I want to hide and showing the correct statistics. Great help. Thanks again.

Bye

jrey

[webmaster73]

... in index.php find in //--- Show New Images ---- the following ...

Code: [Select]

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").")

... and add after ...

Code: [Select]

AND i.cat_id NOT IN (24)


this is sweet. but this must be a parameter to be set in the admin panel, not a hack to the core script.

[mawenzi]

@ wbmaster73
... then use this ... http://www.4homepages.de/forum/index.php?topic=16348.msg92769#msg92769

[webmaster73]

@ wbmaster73
... then use this ... http://www.4homepages.de/forum/index.php?topic=16348.msg92769#msg92769

thank you mawenzi, I really appreciate your effort.

I have tried the first method, and it works fine for me, so I am ok with that.

what honestly disturbs me a bit is to find that almost every single feature I would wish to see in 4images is already available in the form of a Mod.

hmmmm. I believe I am an average user of 4images. If almost every single one of my requests has already been made And answered in the form of a mod, why does not the coding team of 4images pull itself together and integrate those essential mods into the core of the script?

Guys, if frankly it is a funds question, then do as everyone did and does: sell your script at a reasonable price (may I suggest $30/domain) and provide better service......

Freeware has limits and I believe 4images has reached 'em.  now the script is well known, we could take it a step further...

[NetRebel]

... in index.php find in //--- Show New Images ---- the following ...

Oh... if only everything in life was this easy! Thanks for this perfect, yet simple solution. It's exactly what I was looking for to exclude some "adult" content categories from being displayed on the frontpage.

[niad]

I didn't manage to exclude categories with the above solutions, so I did this:

In the Search.php
Find this:
AND c.cat_id = i.cat_id $cat_id_sql

and replace it with this:
AND c.cat_id = i.cat_id AND i.cat_id NOT IN (1,2,3)

where the 1,2,3 are the categories you want to exclude from the "new images" results.

This is a very easy solution and works great!