| freakyshiat |
03-29-2004 02:37 PM |
Latest threadid, postid and memberid on index page
Quote:
Originally Posted by hellsatan
PHP Code:
// +++++++ 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, :
Code:
lastthread_id
<a href="showthread.php?s=$session[sessionhash]&threadid=$threads[threadid]">$threads[threadid]</a>
Code:
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? :) |
More Information