phpBB.de

Code: Alles auswählen

$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 . "

Code: Alles auswählen

$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_level <> ". ADMIN ."

Code: Alles auswählen

$sql = "SELECT count(*) AS total
FROM " . USERS_TABLE . "
WHERE user_id <> " . ANONYMOUS;

Code: Alles auswählen

$sql = "SELECT count(*) AS total
FROM " . USERS_TABLE . "
WHERE user_id <> " . ANONYMOUS . " AND user_level <> ". ADMIN;

Code: Alles auswählen

WHERE user_id <> " . ANONYMOUS . " AND user_id <> ". 26;

Code: Alles auswählen

WHERE user_id <> " . ANONYMOUS . " AND user_id <> ". 26 ."

Code: Alles auswählen

WHERE user_id <> " . ANONYMOUS . " AND user_id <> ". 26;