[hazem_aliraqi]

Originally Posted by MarkFL

Try changing the query to:

PHP Code:

    $myfeatured = $vbulletin->db->query_first("
        SELECT COUNT(*) AS thread_count, thread.postuserid
        FROM " . TABLE_PREFIX . "thread AS thread
        INNER JOIN " . TABLE_PREFIX . "featuredthreads AS featuredthreads
        ON thread.threadid = featuredthreads.threadid
        WHERE thread.postuserid = " . $post['userid'] . "
        GROUP BY thread.postuserid
    "); 


In the plugins titled:

• Show Featured Authors (Postbit)
• Show Featured Authors (Postbit - Quick Reply)
• Show Featured Authors (Profile)

If that works, then we will proceed from there.

awesome
works successfully

thank you