Ptirhiik - RPGnet-fr wrote: define( should be defined(
That worked, thanks.
Ptirhiik - RPGnet-fr wrote: define( should be defined(
Ptirhiik - RPGnet-fr wrote: define( should be defined(
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 '' at line 25
SELECT DISTINCT
u.*,
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_session_time >= (1067438369-300) THEN 1 ELSE 0 END) AS user_online_virt,
u.username AS username_virt,
u.user_regdate AS user_regdate_virt,
u.user_lastvisit AS user_lastvisit_virt,
u.user_posts AS user_posts_virt,
r.rank_title AS user_rank_title_virt,
1 AS user_generic_display,
1 AS user_viewonline_display,
1 AS user_webdisplay_display
FROM ((((
users AS u)
LEFT JOIN buddy AS i ON i.user_id=2 AND i.buddy_id=u.user_id)
LEFT JOIN buddy AS b ON b.user_id=u.user_id AND b.buddy_id=2)
LEFT JOIN ranks AS r
#, Online, Username, Joined, Last visit time, Total posts, Poster Rank
Does it show when you are using the subSilver template ?