phpBB.de

Code: Alles auswählen

$sql = 'SELECT  b.buddy_name, b.buddy_id, b.user_id, b.added,
                                u.user_msnm, u.user_yim, u.user_aim, u.user_email, u.user_viewemail, u.user_icq, u.user_website,
                        IF(s.session_user_id <> "","true","false") AS is_online, count(*) AS total
                        FROM ' . BUDDYLIST_TABLE . ' b, ' . USERS_TABLE . ' u
                        LEFT OUTER JOIN '.SESSIONS_TABLE.' s ON b.buddy_id = s.session_user_id AND s.session_time >= '.( time() - 300 ) . '
                        WHERE b.buddy_id = u.user_id AND b.user_id = ' . $user_id . '
                        ORDER BY b.added
                        LIMIT $start, ' . board_config['topics_per_page'];