$user_theard_query = $db->query_read("SELECT COUNT(threadid) AS total FROM " . TABLE_PREFIX . "thread WHERE postuserid=$this_hack_userid");
$usertherd_pro_fetch = $db->fetch_array($user_theard_query);
Please always post hook_locations and template names for all code or we can't tell when you are adding things. And, as mentioned, there are several blogs over on vb.com that cover the new template syntax and the registering of variables. Please take a look over there.