[EquinoxWorld]

Originally Posted by 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.

Well that worked! No need for a file, even better! Thanks for the help kh99, as always very helpful. I didn;t even know you could run queries from there like that... Opens up more possibilities :up:

--------------- Added [DATE]1312430497[/DATE] at [TIME]1312430497[/TIME] ---------------

Can I do this in the same plguin?

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']; 
$row2 = $db->query_first("SELECT id FROM cotw_aotw_time_end ORDER BY id DESC LIMIT 1"); 
$cotw_aotw_contests_number = $row2['id'];
vB_Template::preRegister('COTW_SOTW',array('cotw_sotw_contests_number' => $cotw_sotw_contests_number));
vB_Template::preRegister('COTW_SOTW',array('cotw_aotw_contests_number' => $cotw_aotw_contests_number));