Hab nen kleinen Fehler noch bei dir gefunden
Und zwar steh bei dir in deiner
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
kein user_birthday drin. Bei mir heißt es nun
Code: Alles auswählen
$sql = "SELECT username, user_id, user_viewemail, user_posts, user_regdate, user_birthday, user_from, user_website, user_email, user_icq, user_aim, user_yim, user_msnm, user_avatar, user_avatar_type, user_allowavatar
Dann kommt aber folgende Fehlermeldung
Could not query users
DEBUG MODE
SQL Error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') UNION (SELECT username, user_id, user_viewemail, user_posts, user_regdate, use' at line 5
SELECT username, user_id, user_viewemail, user_posts, user_regdate, user_birthday, user_from, user_website, user_email, user_icq, user_aim, user_yim, user_msnm, user_avatar, user_avatar_type, user_allowavatar FROM phpbb_users WHERE user_id <> -1 AND user_birthday <> 999999 ORDER BY user_birthday ASC LIMIT 0, 50) UNION (SELECT username, user_id, user_viewemail, user_posts, user_regdate, user_birthday, user_from, user_website, user_email, user_icq, user_aim, user_yim, user_msnm, user_avatar, user_avatar_type, user_allowavatar FROM phpbb_users WHERE user_id <> -1 AND user_birthday = 999999 ORDER BY user_birthday ASC LIMIT 0, 50) LIMIT 0, 50
Line : 169
File : memberlist.php
Insgesamt sieht das so aus:
Code: Alles auswählen
case 'birthday':
$order_by = "user_birthday $sort_order LIMIT $start, " . $board_config['topics_per_page'];
break;
default:
$order_by = "user_regdate $sort_order LIMIT $start, " . $board_config['topics_per_page'];
break;
}
if ($mode == 'birthday')
{
$sql = "SELECT username, user_id, user_viewemail, user_posts, user_regdate, user_birthday, 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_birthday <> 999999
ORDER BY $order_by) UNION (SELECT username, user_id, user_viewemail, user_posts, user_regdate, user_birthday, 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_birthday = 999999
ORDER BY $order_by) LIMIT $start, " . $board_config['topics_per_page'];
}
else
{
$sql = "SELECT username, user_id, user_viewemail, user_posts, user_regdate, user_birthday, 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 . "
ORDER BY $order_by";
}