Код: Выделить всё
заменить
//-----------------------------------------------------------------------------
$sql = 'SELECT u.user_id, u.username, u.username_clean, u.user_type, u.user_colour, s.session_id, s.session_time, s.session_page, s.session_ip, s.session_browser, s.session_viewonline, s.session_forum_id
FROM ' . USERS_TABLE . ' u, ' . SESSIONS_TABLE . ' s
//-----------------------------------------------------------------------------
на
//-----------------------------------------------------------------------------
$sql = 'SELECT u.user_id, u.username, u.username_clean, u.user_type, u.user_colour, s.session_id, s.session_time, s.session_page, s.session_ip, s.session_browser, s.session_viewonline, s.session_forum_id'.($ppkbb_enable_uadata[0] ? ', s.session_user_id, s.ua_md5_string, sua.ua_data, sua.ua_last_update' : '').'
FROM ' . USERS_TABLE . ' u, ' . SESSIONS_TABLE . ' s'.($ppkbb_enable_uadata[0] ? ' LEFT JOIN '.SESSIONS_USERS_UADATA." sua ON (s.ua_md5_string=sua.ua_md5_string)" : '').'
Код: Выделить всё
$sql = 'SELECT u.user_id, u.username, u.username_clean, u.user_type, u.user_colour, s.session_id, s.session_time, s.session_page, s.session_ip, s.session_browser, s.session_viewonline, s.session_forum_id, u.user_avatar, u.user_avatar_type, u.user_avatar_width, u.user_avatar_height'.($config['ppkbb_forumid_remove'] ? ', t.forum_id, t.topic_title, t.topic_id' : '').'
FROM ' . USERS_TABLE . ' u, ' . SESSIONS_TABLE . ' s'.($config['ppkbb_forumid_remove'] ? ' LEFT JOIN '.TOPICS_TABLE.' t ON(s.session_topic_id=t.topic_id)' : '').'