Exclude categories from random

[skiemor]

Hi @ all,
how can I exclude a category from random?

Best, Chris.

[thunderstrike]

Exclude random cat is same of exclude cat in ACP - > Categories - > Add / Edit Categories.

[skiemor]

Hi, Thunderstike,
ACP is configured. Only members can see "songs". But the mp3.gif in random disturbs me.

Chris.

[thunderstrike]

Ok so ... no MP3 file in random ?

[skiemor]

excact, mp3.gif will shown for members in random and a don't like this, because it's no bird"pic".

[thunderstrike]

Hum ... ok so quick way is this -

in includes/functions.php file,

find:

Code: [Select]

while ($row = $site_db->fetch_array($result)) {
      $random_image_cache[$row['cat_id']] = $row;
}

replace:

Code: [Select]

while ($row = $site_db->fetch_array($result)) {
   if (!eregi("\.mp3$", get_basefile(stripslashes(trim($row['image_thumb_file'])))) || !eregi("\.mp3$", get_basefile(stripslashes(trim($row['image_media_file']))))) {
      $random_image_cache[$row['cat_id']] = $row;
  }
}


[skiemor]

Oki, I changed it. I wonder, why you have for all problems a solution?!

It's now a "quick" solution. How looks solution with code, for example: "don't show cat 1, 2, 3" in php
May be I want to exclude a pic-cat too.

I found in MOD random.php a good looking description, but it's for external only?

Chris

[thunderstrike]

May be I want to exclude a pic-cat too.

In includes/functions.php file,

find:

Code: [Select]

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

change ($cat_id_sql) for: (1, 2, 3, 4) .

Note: If keep last change for MP3 with new change, MP3 is still no show - exclude cat or no exclude (axcept if reverse MP3 step and use new step for exclude).
Note2: If exclude cat from ACP after edit new change, is no response. Only if use $cat_id_sql for ACP.

[skiemor]

Oki, returned mp3 step and use new code.
And know: If I upload mp3-files, they will be shown in "Newest images". I change the date to get them out, but this is a bad solution.
How to code similiar to exclude mp3 from "Newest images" like code for random?

Chris.

[thunderstrike]

In index.php file,

find:

Code: [Select]

while ($image_row = $site_db->fetch_array($result)) {
    if ($count == 0) {

replace:

Code: [Select]

while ($image_row = $site_db->fetch_array($result)) {
  if (!preg_match("/\.mp3/", get_basefile(stripslashes(trim($image_row['image_thumb_file'])))) || !preg_match("/\.mp3/", get_basefile(stripslashes(trim($image_row['image_media_file']))))) {
    if ($count == 0) {

find:

Code: [Select]

$count = 0;
    }
  } // end while

replace:

Code: [Select]

$count = 0;
    }
  }
  } // end while


[skiemor]

Thanks but last code crashs my site.
I believe, that this code works, but not in my sites.

Chris.

[skiemor]

May be I want to exclude a pic-cat too.

In includes/functions.php file,

find:

Code: [Select]

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


change ($cat_id_sql) for: (1, 2, 3, 4) .

Note: If keep last change for MP3 with new change, MP3 is still no show - exclude cat or no exclude (axcept if reverse MP3 step and use new step for exclude).
Note2: If exclude cat from ACP after edit new change, is no response. Only if use $cat_id_sql for ACP.

That works, but if "choosen" a pic from excluded cat, this pic will not shown (right) and below the headline "Random picture" is nothing. The query must be "search without excluded cats", not only don't show pics of these cats.

[thunderstrike]

Thanks but last code crashs my site.

Is say for crash from server ?

[skiemor]

No, sorry, layout crashs.

[thunderstrike]

1, 2, 3, 4 value exist in CATEGORIES_TABLE and IMAGES_TABLE (cat_id field) + image of inactive category is inactive too ? If inactive category with active image, is no work sure.