ûmständlich das mit der 3
suche das original in der index.php:
$num_new_images = $config['image_cells'];
$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 c.cat_id = i.cat_id AND i.cat_id NOT IN (".get_auth_cat_sql("auth_viewcat", "NOTIN").")
ORDER BY i.image_date DESC
LIMIT $num_new_images";
und ersetze es mit:
$sql = "SELECT setting_value as cat_rand_pic FROM ".SETTINGS_TABLE." WHERE setting_name = 'cat_rand_pic'";
$result = $site_db->query($sql); $row = mysql_fetch_object($result);
$cat_in= $row->cat_rand_pic;
$num_new_images = $config['image_cells'];
//$cat_in = array($cat_rand_pic);
$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,i.image_DateTimeOriginal".$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 c.cat_id = i.cat_id AND i.cat_id NOT IN (".get_auth_cat_sql("auth_viewcat", "NOTIN").")AND i.cat_id NOT IN (".$cat_in.")
ORDER BY i.image_date DESC
LIMIT $num_new_images";
abgesehn von umständlich, wenn du das nur kopierst werden unter new_images3 die gleichen bilder angezeig wie unter new_images2.
du musst die sql abfrage auf:
AND i.cat_id NOT IN (".$cat_in.")
stellen.
EDIT: noch etwas, wenn du jetzt mehrere {new_images1 -2 -3 } kannst du die folgenden SQL abfragen löschen:
$sql = "SELECT setting_value as cat_rand_pic FROM ".SETTINGS_TABLE." WHERE setting_name = 'cat_rand_pic'";
$result = $site_db->query($sql); $row = mysql_fetch_object($result);
$cat_in = $row->cat_rand_pic;
//$cat_in = array($cat_rand_pic);
diesen eintrag brauchst du nur einmal am anfang bei der ersten {new_images}.
mfg Andi