PHP Code:
$templatesused = "home_newthisweek";
chdir("/your/path/to/forum");
require("./global.php");
$newforum="1";
$newposts="3";
$newsql=$DB_site->query("SELECT * FROM thread WHERE forumid='$newforum' ORDER BY dateline DESC LIMIT 0,$newposts");
while ($new=$DB_site->fetch_array($newsql)) {
$newthreadid=$new[threadid];
$newtitle=$new[title];
$newtime=vbdate($timeformat,$getnew[dateline]);
$newdate=vbdate($dateformat,$getnew[dateline]);
$getnewsql=$DB_site->query("SELECT * FROM post WHERE threadid='$newthreadid' ORDER BY postid ASC LIMIT 0,1");
while ($getnew=$DB_site->fetch_array($getnewsql)) {
$newpagetext=$getnew[pagetext];
$newpagetext=bbcodeparse($newpagetext);
eval("\$newthisweek = \"".gettemplate('home_newthisweek')."\";");
}
}
You need to tell it what number to start at i believe so its in the format 0,Number to View