Ik kijken, ik kwam geen enkele fout tegen... daarna logde ik in onder een andere gebruiker, test account zonder admin rechten...
en toen...
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 '<> 0 OR 0 <> 1 ) AND ( b.buddy_visible = 1 OR ( u.user_allow_vi
SELECT DISTINCT
u.*,
(CASE WHEN i.buddy_ignore = 0 THEN 1 ELSE 0 END) AS user_my_friend_virt,
i.buddy_visible AS user_my_visible_virt,
(CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) AS user_my_ignore_virt,
(CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) AS user_friend_virt,
b.buddy_visible AS user_visible_virt,
(CASE WHEN b.buddy_ignore = 1 THEN 1 ELSE 0 END) AS user_ignore_virt,
(CASE WHEN (u.user_id = 16 OR ( ( i.buddy_ignore <> 1 OR i.buddy_ignore IS NULL ) AND ( <> 0 OR 0 <> 1 ) AND ( b.buddy_visible = 1 OR ( u.user_allow_viewonline = 1 OR ( = 1 AND 0 = 1) ) OR ( b.buddy_ignore = 0 AND ( u.user_allow_viewonline = 2 OR ( = 2 AND 0 = 1) ) ) ) )) THEN (CASE WHEN u.user_session_time >= (1113147116-300) THEN 1 ELSE 0 END) ELSE '' END) AS user_online_virt,
u.username AS username_virt,
(CASE WHEN (u.user_id = 16 OR ( ( i.buddy_ignore <> 1 OR i.buddy_ignore IS NULL ) AND ( <> 0 OR 0 <> 1 ) AND ( b.buddy_visible = 1 OR ( u.user_allow_viewonline = 1 OR ( = 1 AND 0 = 1) ) OR ( b.buddy_ignore = 0 AND ( u.user_allow_viewonline = 2 OR ( = 2 AND 0 = 1) ) ) ) )) THEN u.user_regdate ELSE '' END) AS user_regdate_virt,
(CASE WHEN (u.user_id = 16 OR ( ( i.buddy_ignore <> 1 OR i.buddy_ignore IS NULL ) AND ( <> 0 OR 0 <> 1 ) AND ( b.buddy_visible = 1 OR ( u.user_allow_viewonline = 1 OR ( = 1 AND 0 = 1) ) OR ( b.buddy_ignore = 0 AND ( u.user_allow_viewonline = 2 OR ( = 2 AND 0 = 1) ) ) ) )) THEN u.user_lastvisit ELSE '' END) AS user_lastvisit_virt,
(CASE WHEN (u.user_id = 16 OR ( ( i.buddy_ignore <> 1 OR i.buddy_ignore IS NULL ) AND ( <> 0 OR 0 <> 1 ) AND ( b.buddy_visible = 1 OR ( u.user_allow_viewonline = 1 OR ( = 1 AND 0 = 1) ) OR ( b.buddy_ignore = 0 AND ( u.user_allow_viewonline = 2 OR ( = 2 AND 0 = 1) ) ) ) )) THEN u.user_posts ELSE '' END) AS user_posts_virt,
(CASE WHEN (u.user_id = 16 OR ( ( i.buddy_ignore <> 1 OR i.buddy_ignore IS NULL ) AND ( <> 0 OR 0 <> 1 ) AND u.user_allow_website = 1 AND ( b.buddy_visible = 1 OR ( u.user_viewwebsite = 1 OR ( = 1 AND 0 = 1) ) OR ( b.buddy_ignore = 0 AND ( u.user_viewwebsite = 2 OR ( = 2 AND 0 = 1) ) ) ) )) THEN r.rank_title ELSE '' END) AS user_rank_title_virt,
1 AS user_generic_display,
(CASE WHEN (u.user_id = 16 OR ( ( i.buddy_ignore <> 1 OR i.buddy_ignore IS NULL ) AND ( <> 0 OR 0 <> 1 ) AND ( b.buddy_visible = 1 OR ( u.user_allow_viewonline = 1 OR ( = 1 AND 0 = 1) ) OR ( b.buddy_ignore = 0 AND ( u.user_allow_viewonline = 2 OR ( = 2 AND 0 = 1) ) ) ) )) THEN 1 ELSE '' END) AS user_viewonline_display,
(CASE WHEN (u.user_id = 16 OR ( ( i.buddy_ignore <> 1 OR i.buddy_ignore IS NULL ) AND ( <> 0 OR 0 <> 1 ) AND u.user_allow_website = 1 AND ( b.buddy_visible = 1 OR ( u.user_viewwebsite = 1 OR ( = 1 AND 0 = 1) ) OR ( b.buddy_ignore = 0 AND ( u.user_viewwebsite = 2 OR ( = 2 AND 0 = 1) ) ) ) )) THEN 1 ELSE '' END) AS user_webdisplay_display
FROM ((((
phpbb_users AS u)
LEFT JOIN phpbb_buddy AS i ON i.user_id=16 AND i.buddy_id=u.user_id)
LEFT JOIN phpbb_buddy AS b ON b.user_id=u.user_id AND b.buddy_id=16)
LEFT JOIN phpbb_ranks AS r ON (u.user_rank > 0 AND r.rank_special <> 0 AND r.rank_id = u.user_rank) OR (u.user_rank = 0 AND r.rank_special = 0 AND u.user_posts >= r.rank_min AND u.user_posts < r.rank_max))
WHERE u.user_id <> -1 AND i.buddy_ignore = 0
ORDER BY username_virt ASC
Line : 906
File : profilcp_buddy.php
wat een fouten, nou ik ben er niet uitgekomen... heb al meerde dingen geprobeerd... toen werd het nog erger
maar het is nu weer zo fout als nieuw...