Quote:
Originally Posted by hazem_aliraqi
version 5.0.51
|
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.