Code: Select all
MySQLResultSet Object
(
[fetchmode:protected] => 2
[conn:protected] => MySQLConnection Object
(
[database:private] => test
[transactionOpcount:protected] => 0
[dblink:protected] => Resource id #65
[dsn:protected] => Array
(
[compat_assoc_lower] =>
[compat_rtrim_string] =>
[database] => test
[encoding] =>
[hostspec] => ***.***.***.***
[password] => ****
[persistent] =>
[phptype] => mysql
[port] =>
[protocol] =>
[socket] =>
[username] => root
)
[flags:protected] => 0
[lastQuery] => SELECT threads.THREAD_ID, threads.THREAD_ID AS THREAD_ID, decode_tb_escape(highlight_words(threads.TEXT, 'bar')) AS TEXT, IF (date_format(GREATEST(IFNULL(threads.LAST_REPLIED,threads.CREATED_AT),IFNULL(threads.CREATED_AT,threads.LAST_REPLIED)), '%d%m%y') = date_format(CURRENT_DATE(), '%d%m%y'),date_format(GREATEST(IFNULL(threads.LAST_REPLIED,threads.CREATED_AT),IFNULL(threads.CREATED_AT,threads.LAST_REPLIED)), '%H:%i'),IF ((DATE_SUB(CURRENT_DATE(), INTERVAL 6 MONTH) > GREATEST(IFNULL(threads.LAST_REPLIED,threads.CREATED_AT),IFNULL(threads.CREATED_AT,threads.LAST_REPLIED))),date_format(GREATEST(IFNULL(threads.LAST_REPLIED,threads.CREATED_AT),IFNULL(threads.CREATED_AT,threads.LAST_REPLIED)), '%b %y'),IF ((date_format(DATE_ADD(GREATEST(IFNULL(threads.LAST_REPLIED,threads.CREATED_AT),IFNULL(threads.CREATED_AT,threads.LAST_REPLIED)), INTERVAL 1 DAY), '%d%m%y') = date_format(CURRENT_DATE(), '%d%m%y')),'yesterday',date_format(GREATEST(IFNULL(threads.LAST_REPLIED,threads.CREATED_AT),IFNULL(threads.CREATED_AT,threads.LAST_REPLIED)), '%b %D')))) AS LAST_MODIFIED, users.USERNAME AS USERNAME, countries.FLAG_FILENAME AS FLAG_FILENAME, IF (ISNULL(online_users.LAST_TIMESTAMP),'offline.jpg','online.jpg') AS STATUS_FILE, (get_rank_by_delimiter('bar', threads.TEXT, ' ', 10, 5) + get_rank_by_delimiter('bar', users.USERNAME, ' ', 10, 5) + COALESCE((SELECT SUM(get_rank_by_delimiter('bar', t.TEXT, ' ', 5, 1) + get_rank_by_delimiter('bar', users.USERNAME, ' ', 5, 1)) FROM threads t WHERE t.FATHER_ID = threads.THREAD_ID), 0)) AS RANK FROM (threads, users, countries) LEFT JOIN online_users ON (threads.USER_ID=online_users.USER_ID) WHERE threads.ROOM_ID='4' AND threads.FATHER_ID IS NULL AND threads.USER_ID=users.USER_ID AND users.COUNTRY_ID=countries.COUNTRY_ID ORDER BY RANK DESC,GREATEST(IFNULL(threads.LAST_REPLIED,threads.CREATED_AT),IFNULL(threads.CREATED_AT,threads.LAST_REPLIED)) DESC LIMIT 30
)
[result:protected] => Resource id #126
[cursorPos:protected] => 0
[fields:protected] =>
[lowerAssocCase:protected] =>
[rtrimString:protected] =>
)