phpBB.de

memory_limit 40M 40M

Bezüglich Mitgliederliste ist eigentlich zu V 1.3 nichts mehr hinzugekommen

Could not read user informations

DEBUG MODE

SQL Error : 2008 MySQL client run out of memory

SELECT DISTINCT u.*, (CASE WHEN u.user_from_flag = 'blank.gif' THEN '' ELSE TRIM(LEADING ' ' FROM SUBSTRING(LPAD(u.user_from_flag, 25, ' '), 1, 21)) END) as user_flag, (CASE WHEN (u.user_id = 9) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ((CASE WHEN b.buddy_visible = 1 THEN 1 ELSE 0 END) = 1) OR ( (u.user_allow_viewonline = 1) OR ( (u.user_allow_viewonline = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END) as user_online_display, (CASE WHEN (u.user_id = 9) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_email = 1) AND ( (u.user_viewemail = 1) OR ( (u.user_viewemail = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END) as user_email_display, (CASE WHEN (u.user_id = 9) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_pm = 1) AND ( (u.user_viewpm = 1) OR ( (u.user_viewpm = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END) as user_pm_display, (CASE WHEN (u.user_id = 9) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_website = 1) AND ( (u.user_viewwebsite = 1) OR ( (u.user_viewwebsite = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END) as user_www_display, (CASE WHEN (u.user_id = 9) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_messanger = 1) AND ( (u.user_viewmessanger = 1) OR ( (u.user_viewmessanger = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END) as user_messanger_display, (CASE WHEN (u.user_id = 9) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_real = 1) AND ( (u.user_viewreal = 1) OR ( (u.user_viewreal = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END) as user_real_display, (CASE WHEN i.buddy_ignore = 0 THEN 1 ELSE 0 END) as user_my_friend, (CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) as user_my_ignore, (CASE WHEN i.buddy_visible = 1 THEN 1 ELSE 0 END) as user_my_visible, (CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) as user_friend, (CASE WHEN b.buddy_ignore = 1 THEN 1 ELSE 0 END) as user_ignore, (CASE WHEN b.buddy_visible = 1 THEN 1 ELSE 0 END) as user_visible , (CASE WHEN i.buddy_ignore = 0 THEN 1 ELSE 0 END) as user_my_friend, (CASE WHEN (u.user_session_time >= 1082468680) AND ((CASE WHEN (u.user_id = 9) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ((CASE WHEN b.buddy_visible = 1 THEN 1 ELSE 0 END) = 1) OR ( (u.user_allow_viewonline = 1) OR ( (u.user_allow_viewonline = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END) = 1) THEN 1 ELSE 0 END) as user_online, (CASE WHEN (CASE WHEN (u.user_id = 9) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_pm = 1) AND ( (u.user_viewpm = 1) OR ( (u.user_viewpm = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END) = 1 THEN (CASE WHEN (u.user_id = 9) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_pm = 1) AND ( (u.user_viewpm = 1) OR ( (u.user_viewpm = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END) ELSE 0 END) as user_pm, (CASE WHEN (CASE WHEN (u.user_id = 9) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_email = 1) AND ( (u.user_viewemail = 1) OR ( (u.user_viewemail = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_email ELSE '' END) as user_email_virt, (CASE WHEN (CASE WHEN (u.user_id = 9) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_messanger = 1) AND ( (u.user_viewmessanger = 1) OR ( (u.user_viewmessanger = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_icq ELSE '' END) as user_icq_virt, (CASE WHEN (CASE WHEN (u.user_id = 9) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_messanger = 1) AND ( (u.user_viewmessanger = 1) OR ( (u.user_viewmessanger = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_aim ELSE '' END) as user_aim_virt, (CASE WHEN (CASE WHEN (u.user_id = 9) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_messanger = 1) AND ( (u.user_viewmessanger = 1) OR ( (u.user_viewmessanger = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_yim ELSE '' END) as user_yim_virt, (CASE WHEN (CASE WHEN (u.user_id = 9) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_messanger = 1) AND ( (u.user_viewmessanger = 1) OR ( (u.user_viewmessanger = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_msnm ELSE '' END) as user_msnm_virt, (CASE WHEN (CASE WHEN (u.user_id = 9) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ((CASE WHEN b.buddy_visible = 1 THEN 1 ELSE 0 END) = 1) OR ( (u.user_allow_viewonline = 1) OR ( (u.user_allow_viewonline = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_regdate ELSE 0 END) as user_regdate_virt, (CASE WHEN (CASE WHEN (u.user_id = 9) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ((CASE WHEN b.buddy_visible = 1 THEN 1 ELSE 0 END) = 1) OR ( (u.user_allow_viewonline = 1) OR ( (u.user_allow_viewonline = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_lastvisit ELSE 0 END) as user_lastvisit_virt, (CASE WHEN (CASE WHEN (u.user_id = 9) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ((CASE WHEN b.buddy_visible = 1 THEN 1 ELSE 0 END) = 1) OR ( (u.user_allow_viewonline = 1) OR ( (u.user_allow_viewonline = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_posts ELSE 0 END) as user_posts_virt, (CASE WHEN ((CASE WHEN (u.user_id = 9) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_website = 1) AND ( (u.user_viewwebsite = 1) OR ( (u.user_viewwebsite = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END) = 1) THEN ( COALESCE(sr.rank_title, SUBSTRING(MAX(CONCAT(LPAD(nr.rank_min,8,'0'), nr.rank_title)), 9)) ) ELSE '' END) as user_rank_title, (CASE WHEN (CASE WHEN (u.user_id = 9) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_website = 1) AND ( (u.user_viewwebsite = 1) OR ( (u.user_viewwebsite = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_timezone ELSE 0 END) as user_timezone_virt, (CASE WHEN (CASE WHEN (u.user_id = 9) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_website = 1) AND ( (u.user_viewwebsite = 1) OR ( (u.user_viewwebsite = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_lang ELSE '' END) as user_lang_virt, (CASE WHEN (CASE WHEN (u.user_id = 9) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_website = 1) AND ( (u.user_viewwebsite = 1) OR ( (u.user_viewwebsite = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_website ELSE '' END) as user_website_virt, (CASE WHEN (CASE WHEN (u.user_id = 9) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_real = 1) AND ( (u.user_viewreal = 1) OR ( (u.user_viewreal = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_realname ELSE '' END) as user_realname_virt, (CASE WHEN (CASE WHEN (u.user_id = 9) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_real = 1) AND ( (u.user_viewreal = 1) OR ( (u.user_viewreal = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_gender ELSE 0 END) as user_gender_virt, (CASE WHEN (CASE WHEN (u.user_id = 9) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_real = 1) AND ( (u.user_viewreal = 1) OR ( (u.user_viewreal = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_birthday ELSE '' END) as user_birthday_virt, (CASE WHEN (CASE WHEN (u.user_id = 9) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_real = 1) AND ( (u.user_viewreal = 1) OR ( (u.user_viewreal = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_from ELSE '' END) as user_from_virt, (CASE WHEN (CASE WHEN (u.user_id = 9) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_real = 1) AND ( (u.user_viewreal = 1) OR ( (u.user_viewreal = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_occ ELSE '' END) as user_occ_virt, (CASE WHEN (CASE WHEN (u.user_id = 9) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_real = 1) AND ( (u.user_viewreal = 1) OR ( (u.user_viewreal = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_interests ELSE '' END) as user_interests_virt, (CASE WHEN (CASE WHEN (u.user_id = 9) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_real = 1) AND ( (u.user_viewreal = 1) OR ( (u.user_viewreal = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_home_phone ELSE '' END) as user_home_phone_virt, (CASE WHEN (CASE WHEN (u.user_id = 9) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_real = 1) AND ( (u.user_viewreal = 1) OR ( (u.user_viewreal = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_home_fax ELSE '' END) as user_home_fax_virt, (CASE WHEN (CASE WHEN (u.user_id = 9) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_real = 1) AND ( (u.user_viewreal = 1) OR ( (u.user_viewreal = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_work_phone ELSE '' END) as user_work_phone_virt, (CASE WHEN (CASE WHEN (u.user_id = 9) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_real = 1) AND ( (u.user_viewreal = 1) OR ( (u.user_viewreal = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_work_fax ELSE '' END) as user_work_fax_virt, (CASE WHEN (CASE WHEN (u.user_id = 9) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_real = 1) AND ( (u.user_viewreal = 1) OR ( (u.user_viewreal = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_cellular ELSE '' END) as user_cellular_virt, (CASE WHEN (CASE WHEN (u.user_id = 9) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_real = 1) AND ( (u.user_viewreal = 1) OR ( (u.user_viewreal = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_pager ELSE '' END) as user_pager_virt FROM (((((phpbb_users as u LEFT JOIN phpbb_flags as f ON f.flag_image = u.user_from_flag) LEFT JOIN phpbb_buddy as b ON b.user_id=u.user_id AND b.buddy_id=9) LEFT JOIN phpbb_buddy as i ON i.user_id=9 AND i.buddy_id=u.user_id) LEFT JOIN phpbb_ranks as sr ON u.user_rank > 0 AND sr.rank_special = 1 AND u.user_rank = sr.rank_id) LEFT JOIN phpbb_ranks as nr ON u.user_rank = 0 AND nr.rank_special = 0 AND nr.rank_min <= u.user_posts) WHERE u.user_id <> -1 GROUP BY u.user_id ORDER BY u.username ASC, u.username ASC

Line : 734
File : ... /phpBB2/profilcp/profilcp_buddy.php