Latest threadid, postid and memberid on index page

[freakyshiat]

// +++++++ Last Post Thread ID [ Start ] +++++++
$getid=$DB_site->query("SELECT threadid FROM thread ORDER BY lastpost DESC LIMIT 1");
while ($threads = mysql_fetch_array($getid)) {
eval("\$lastthread = \"".gettemplate("lastthread_id")."\";");
}
$getpid=$DB_site->query("SELECT postid FROM post ORDER BY postid DESC LIMIT 1");
while ($postings = mysql_fetch_array($getpid)) {
eval("\$lastpost = \"".gettemplate("lastpost_id")."\";");
}
// +++++++ Last Post Thread ID [ End ] +++++++


Now make 2 templates, :
lastthread_id
<a href="showthread.php?s=$session[sessionhash]&threadid=$threads[threadid]">$threads[threadid]</a>

lastpost_id
<a href="showthread.php?s=$session[sessionhash]&postid=$postings[postid]">$postings[postid]</a>

Now just put $lastthread and $lastpost in the forumhome template...

Satan

The hack above worked for vb2.x, I am trying to get it to work on my vb 3.x board. Id like to add latest member id to that list. Can anyone help? :)

[NTLDR]

$newuserid can be used on index.php for the latest users userid.

[freakyshiat]

Thank You :)