PHPFusion\Forums\Threads\ForumThreads::get_thread PHP Метод

get_thread() публичный статический Метод

Get thread structure on specific thread id.
public static get_thread ( integer $thread_id ) : array
$thread_id integer
Результат array
    public static function get_thread($thread_id = 0)
    {
        $userdata = fusion_get_userdata();
        $userid = !empty($userdata['user_id']) ? (int) $userdata['user_id'] : 0;
        $data = array();
        $result = dbquery("\n\t\t\t\tSELECT t.*, f.*,\n\t\t\t\tf2.forum_name 'forum_cat_name', f2.forum_access 'parent_access',\n\t\t\t\tu.user_id, u.user_name, u.user_status, u.user_avatar, u.user_joined,\n\t\t\t\tIF (n.thread_id > 0, 1 , 0) as user_tracked,\n\t\t\t\tcount(v.vote_user) 'thread_rated',\n\t\t\t\tcount(p.forum_vote_user_id) 'poll_voted'\n\t\t\t\tFROM " . DB_FORUM_THREADS . " t\n\t\t\t\tINNER JOIN " . DB_USERS . " u on t.thread_author = u.user_id\n\t\t\t\tINNER JOIN " . DB_FORUMS . " f ON t.forum_id=f.forum_id\n\t\t\t\tLEFT JOIN " . DB_FORUMS . " f2 ON f.forum_cat=f2.forum_id\n\t\t\t\tLEFT JOIN " . DB_FORUM_VOTES . " v on v.thread_id = t.thread_id AND v.vote_user='" . intval($userid) . "' AND v.forum_id=f.forum_id AND f.forum_type='4'\n\t\t\t\tLEFT JOIN " . DB_FORUM_POLL_VOTERS . " p on p.thread_id = t.thread_id AND p.forum_vote_user_id='" . intval($userid) . "' AND t.thread_poll='1'\n\t\t\t\tLEFT JOIN " . DB_FORUM_THREAD_NOTIFY . " n on n.thread_id = t.thread_id and n.notify_user = '" . intval($userid) . "'\n\t\t\t\t" . (multilang_table("FO") ? "WHERE f.forum_language='" . LANGUAGE . "' AND" : "WHERE") . "\n\t\t\t\t" . groupaccess('f.forum_access') . " AND t.thread_id='" . intval($thread_id) . "' AND t.thread_hidden='0'\n\t\t\t\t");
        if (dbrows($result) > 0) {
            $data = dbarray($result);
            define_forum_mods($data);
        }
        return (array) $data;
    }

Usage Example

Пример #1
0
function get_thread($thread_id)
{
    return \PHPFusion\Forums\Threads\ForumThreads::get_thread($thread_id);
}