[hazem_aliraqi]

Originally Posted by MarkFL

Okay, now if you wish for this data to show up in the postbit userinfo area (if you are also showing the icon next to the username), try adding this code:

PHP Code:

        $t = 'Thread';
        if ($myfeatured['thread_count'] > 1)
        {
            $t .= 's';
        }
        $template_hook['postbit_userinfo_right_after_posts'] .= '<dt title="Featured Thread Author">FT Author</dt> <dd>' . $myfeatured['thread_count'] . ' ' . $t . '</dd>'; 


within the if statement (at the end within it) in the plugins titled:

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

thank you mark

i use this php file with field42

PHP Code:

SELECT COUNT(*) AS thread_count
FROM thread AS thread
INNER JOIN featuredthreads AS featuredthreads
ON thread.threadid = featuredthreads.threadid
WHERE thread.postuserid = userfield.userid 


is that right ?