[ericgtr]

Well, whether or not you want to add a new template for it is up to you. Let's say it's something you want to spit out on your forumhome, you could add the query to index.php and then call it up in your forumhome (corresponding) template.

Here is an example of how that could be done:

in index.php you could find:

PHP Code:

// ### ALL DONE! SPIT OUT THE HTML AND LET'S GET OUTA HERE... ### 


Add your query above it:

PHP Code:

$myvalue = $DB_site->query_first(" 
                SELECT somefield1, somefield2 
                FROM " . TABLE_PREFIX . "sometable 
                WHERE (somethreadid = " . intval($threadid) . ") 
                AND (someuserid = " . intval($userid) . ") 
        "); 


The call it up in your forumhome template with your variable
$myvalue
where ever you want it to display.

Hope this helps some