show only picture from spezifics categories as random pictures

[TIMT]

Hi

I want to show only pictures from specifics categories as random pictures. Let's say, I have a category 10 and a category 15, and now I want to show only the pictures which belongs to this two categories as random pictures.

Is that difficult to implement? I'm a "non-coder" and I would be very happy, if somebody can help me.

Thanks
TIMT

[Xyu BAM]

you can try find in includes/functions.php:

Code: [Select]

$cat_id_sql = get_auth_cat_sql("auth_viewcat", "NOTIN");add after:

Code: [Select]

  $cat_in = array(1,2,3); //list of category ids
Then find two times:

Code: [Select]

            WHERE i.image_active = 1 AND i.cat_id NOT IN ($cat_id_sql) AND c.cat_id = i.cat_idreplace both of them with:

Code: [Select]

            WHERE i.image_active = 1 AND i.cat_id NOT IN ($cat_id_sql) AND c.cat_id = i.cat_id AND i.cat_id IN (".implode(", ", $cat_in).")

[TIMT]

the problem is, that the picutures next to the categories (pictures instead of folders) are not shown anymore.

[V@no]

yeah, that method would affect these too...

[TIMT]

is there another method possible?

[TIMT]

that means, I need two different types of random pictures.
One as it works today and one, who shows only pictures from at least one specific category (it would be perfect, if i can define, from which categories) and without information abotu picturename and username.

how can I do that?

[Xyu BAM]

oh...right...then leave the first instance of

Code: [Select]

            WHERE i.image_active = 1 AND i.cat_id NOT IN ($cat_id_sql) AND c.cat_id = i.cat_idintact, change only second instance of that line.

[TIMT]

no, it doesn't work. I get still shown pictures from all categories.

[GeXX]

Nice work, if this could work...

I think a good solution would be to deactive categories for random pictures.

Code: [Select]

WHERE i.image_active = 1 AND i.cat_id NOT IN ($cat_id_sql) AND c.cat_id = i.cat_id AND i.cat_id NOT IN (".implode(", ", $cat_in).")
and to configure at the backand->categories->show this category as random

but i have the same prob here. the code works, but for all other categories (there where it should be another picture and not from the random generated category) the randompicture is still not shown.

a solution there?

[V@no]

I think a good solution would be to deactive categories for random pictures.

whatever is works for you. for some people is easier remove few categories from the list for others is easier to use only few specific categories...

anyway, as Хyu BAM said in her(?) last reply, the only line should be changed is in this block:

            WHERE i.image_active = 1 AND i.cat_id NOT IN ($cat_id_sql) AND c.cat_id = i.cat_id  AND i.cat_id IN (".implode(", ", $cat_in).")
            LIMIT $number, 1";
    $random_image_cache[0] = $site_db->query_firstrow($sql);

[TIMT]

I add

Code: [Select]

$cat_in = array(1,2,3); //list of category ids
and replaced

Code: [Select]

WHERE i.image_active = 1 AND i.cat_id NOT IN ($cat_id_sql) AND c.cat_id = i.cat_id
with

Code: [Select]

WHERE i.image_active = 1 AND i.cat_id NOT IN ($cat_id_sql) AND c.cat_id = i.cat_id  AND i.cat_id IN (".implode(", ", $cat_in).")
in the mentioned block.

But  I get still shown pictures from all categories.

[Xyu BAM]

Then you do something wrong. I've checked it on a fresh v1.7.1 and it worked just as planned.

In fact your last reply

But I get still shown pictures from all categories.

Does not match with your first reply:

the problem is, that the picutures next to the categories (pictures instead of folders) are not shown anymore.

Your first reply indicates that the changes worked and also affected category specific random images and your last reply indicates that no visible changes acured and your random image is workign  as default...
So, which your reply is true?

[GeXX]

whatever is works for you. for some people is easier remove few categories from the list for others is easier to use only few specific categories...

right 

anyway, as Хyu BAM said in her(?) last reply, the only line should be changed is in this block:

it's not working, same situation. e.g.: i have 10 categories and with this example it works for the categories 1-3, but the most time (7/10) there is no random-image (empty).

Code: [Select]

    $number = ($total_images > 1) ? mt_rand(0, $total_images - 1) : 0;

    $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, 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 NOT IN ($cat_id_sql) AND c.cat_id = i.cat_id AND i.cat_id IN (".implode(", ", $cat_in).")
            LIMIT $number, 1";
    $random_image_cache[0] = $site_db->query_firstrow($sql);

maybe i'm wrong, but what's up with the variable "$number"?
this $number is generated of the total-images. but the value of total-images is lower in combination of filtered categories.

so if i do following and it works good, maybe there is a better solution:

find:

Code: [Select]

mt_srand((double)microtime() * 1000000);

insert before:

Code: [Select]

      $sql = "SELECT COUNT(*) as total_images
              FROM ".IMAGES_TABLE."
              WHERE image_active = 1 AND cat_id NOT IN ($cat_id_sql) AND cat_id IN (".implode(", ", $cat_in).")";
      $row = $site_db->query_firstrow($sql);
      $total_images = $row['total_images'];

this will calculate the real total_images for the filtered random-images.
it was just a test so i hope this will help to solve this problem with a better solution instead this one  

G.

[TIMT]

somebody here who can help GeXX and me?

Thanks!

[GeXX]

i've solved my problem  :

more here: http://www.4homepages.de/forum/index.php?topic=4259.15