Danke für deine mühe :-)
Habe den code mal eingefügt nun kommt "Fatal error: Call to undefined function: album_permissions() in /home/www/web143/html/test/portal.php on line 535"
Hier mal der code der das zufallsbild für den Block im portal generiert.
keine ahnung ob das hilft , da dieses bild auch nur aus einer offendlichen kategorie ausgelesen wird.//
// Get Newest Pic
//
$Display = 'Random'; // Replace 'Recent' with 'Random'
$CategoryID = 1; // Replace 0 with a category ID. Otherwise, keep it as it is
// Example: /album_cat.php?cat_id=3
// Category ID is 1
if ($Display == 'Random')
{
if ($CategoryID != 0)
{
$sql = "SELECT p.pic_id, p.pic_title, p.pic_username, p.pic_user_id, p.pic_time, p.pic_desc, p.pic_approval, u.username
FROM ". ALBUM_TABLE ." AS p
LEFT JOIN ". USERS_TABLE ." AS u ON p.pic_user_id = u.user_id
WHERE pic_approval = 1 AND pic_lock = 0 AND pic_cat_id = $CategoryID
ORDER BY RAND()
LIMIT 0,1";
}
else {
$sql = "SELECT p.pic_id, p.pic_title, p.pic_username, p.pic_user_id, p.pic_time, p.pic_desc, p.pic_lock, p.pic_approval, u.username
FROM ". ALBUM_TABLE ." AS p
LEFT JOIN ". USERS_TABLE ." AS u ON p.pic_user_id = u.user_id
WHERE pic_approval = 1 AND pic_lock = 0
ORDER BY RAND()
LIMIT 0,1";
}
}
else if ($Display == 'Recent')
{
if ($CategoryID != 0)
{
$sql = "SELECT p.pic_id, p.pic_title, p.pic_username, p.pic_user_id, p.pic_time, p.pic_desc, p.pic_approval, u.username
FROM ". ALBUM_TABLE ." AS p
LEFT JOIN ". USERS_TABLE ." AS u ON p.pic_user_id = u.user_id
WHERE pic_approval = 1 AND pic_lock = 0 AND pic_cat_id = $CategoryID
ORDER BY pic_time DESC
LIMIT 0,1";
}
else
{
$sql = "SELECT p.pic_id, p.pic_title, p.pic_username, p.pic_user_id, p.pic_time, p.pic_desc, p.pic_lock, p.pic_approval, u.username
FROM ". ALBUM_TABLE ." AS p
LEFT JOIN ". USERS_TABLE ." AS u ON p.pic_user_id = u.user_id
WHERE pic_approval = 1 AND pic_lock = 0
ORDER BY pic_time DESC
LIMIT 0,1";
}
}
if (!$result = $db->sql_query($sql))
{
message_die(GENERAL_ERROR, 'Could not query album information', '', __LINE__, __FILE__, $sql);
}
$picrow = $db->sql_fetchrow($result);
$pic_poster = '<a href="'. append_sid("profile.$phpEx?mode=viewprofile&". POST_USERS_URL .'='. $picrow['pic_user_id']) .'">'. $picrow['pic_username'] .'</a>';
//
// END: Get Newest Pic
//
mfg
hoti
gleich mal im dimension Board petzen *fg 
