Версия 53

28 авг 2014, 23:29

заменить
//-----------------------------------------------------------------------------
$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)" : '').'

в инструкции , а в 53 версии

Код: Выделить всё

$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)' : '').'

01 сен 2014, 10:30

заменить на

Код: Выделить всё

$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' : '').($config['ppkbb_forumid_remove'] ? ', t.forum_id, t.topic_title, t.topic_id' : '').'
	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)" : '').($config['ppkbb_forumid_remove'] ? ' LEFT JOIN '.TOPICS_TABLE.' t ON(s.session_topic_id=t.topic_id)' : '').'