[kh99]

I think that all boils down to a plugin with this code:

PHP Code:

$row = $db->query_first("SELECT id FROM cotw_sotw_time_end ORDER BY id DESC LIMIT 1");
$cotw_sotw_contests_number = $row['id'];
vB_Template::preRegister('COTW_SOTW',array('cotw_sotw_contests_number' => $cotw_sotw_contests_number)); 


I suppose you could put that query in a file and include() it if the code is used in more than one place.