ich geh jetzt davon asu das du die änderungen schon drin hast:
finde in functions.php
case 'newestuser':
$sql = "SELECT user_id, username
FROM " . USERS_TABLE . "
WHERE user_id <> " . ANONYMOUS . " AND user_active = 1
ORDER BY user_id DESC
LIMIT 1";
break;
ersetze es mit
case 'newestuser':
($userdata['user_level'] == ADMIN)? $where = '' : $where = ' AND user_active = 1 ';
$sql = "SELECT user_id, username
FROM " . USERS_TABLE . "
WHERE user_id <> " . ANONYMOUS . $where . "
ORDER BY user_id DESC
LIMIT 1";
break;
in memberlist.php
finde
$sql = "SELECT username, user_id, user_viewemail, user_posts, user_regdate, user_from, user_website, user_email, user_icq, user_aim, user_yim, user_msnm, user_avatar, user_avatar_type, user_allowavatar
FROM " . USERS_TABLE . "
WHERE user_id <> " . ANONYMOUS . " AND user_active = 1
ORDER BY $order_by";
ersetze es mit
($userdata['user_level'] == ADMIN)? $where = '' : $where = ' AND user_active = 1 ';
$sql = "SELECT username, user_id, user_viewemail, user_posts, user_regdate, user_from, user_website, user_email, user_icq, user_aim, user_yim, user_msnm, user_avatar, user_avatar_type, user_allowavatar
FROM " . USERS_TABLE . "
WHERE user_id <> " . ANONYMOUS . $where . "
ORDER BY $order_by";
finde
$sql = "SELECT count(*) AS total
FROM " . USERS_TABLE . "
WHERE user_id <> " . ANONYMOUS ."
AND user_active = 1";
ersetze es mit
($userdata['user_level'] == ADMIN)? $where = '' : $where = ' AND user_active = 1 ';
$sql = "SELECT count(*) AS total
FROM " . USERS_TABLE . "
WHERE user_id <> " . ANONYMOUS . $where;
Jan