phpBB.de

Code: Alles auswählen

   $sql = "SELECT u.*, 
               (CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) AS user_ignore, 
               (CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) AS user_friend, 
               (CASE WHEN b.buddy_visible = 1 THEN 1 ELSE 0 END) AS user_visible 
            FROM ((" . USERS_TABLE . " AS u 
            LEFT JOIN " . BUDDYS_TABLE . " AS b   ON b.user_id=u.user_id AND b.buddy_id=$user_id) 
            LEFT JOIN " . BUDDYS_TABLE . " AS i ON i.user_id=$user_id AND i.buddy_id=u.user_id) 
            WHERE u.user_id <> " . ANONYMOUS . " AND u.user_birthday <> 0 AND u.user_birthday <> '' and RIGHT(u.user_birthday, 4) BETWEEN $today AND $date_lookforward 
            ORDER BY username"; 

Code: Alles auswählen

	$sql = "SELECT u.*,
					(CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) AS user_ignore,
					(CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) AS user_friend,
					(CASE WHEN b.buddy_visible = 1 THEN 1 ELSE 0 END) AS user_visible
				FROM ((" . USERS_TABLE . " AS u
				LEFT JOIN " . BUDDYS_TABLE . " AS b	ON b.user_id=u.user_id AND b.buddy_id=$user_id)
				LEFT JOIN " . BUDDYS_TABLE . " AS i ON i.user_id=$user_id AND i.buddy_id=u.user_id)
				WHERE u.user_id <> " . ANONYMOUS . " AND u.user_birthday <> 0 AND u.user_birthday <> '' and RIGHT(u.user_birthday, 4) >= $today AND RIGHT(u.user_birthday, 4) <= $date_lookforward
				ORDER BY username";