[Xenon]

use this code:

PHP Code:

if (intval($post['userid']) > 0) {
$usertherd = $DB_site->query_first("SELECT COUNT(threadid) AS total FROM thread WHERE postuserid=$post[userid] ");
$usertherdcoun = $usertherd[total];
$userpostdcoun = $post[posts] - $usertherdcoun ;
$userscann = $DB_site->query_first("SELECT COUNT(threadid) AS total FROM thread WHERE postuserid=$post[userid] AND forumid IN (12,20,37)"); 
$userscanncoun = $userscann[total]+$userscann1[total]+$userscann2[total] ;
} 


but you shouldn't use this as it produces a queries per post, which will increase the showthread load a lot..