PHP Code:
<?
require("/home/zoque/www/vbulletin/admin/config.php3");
$num_active = 1;
$db=mysql_connect(localhost,*,*);
mysql_select_db($dbname);
$twentyfourhours= 24*60*60;
$date1 = time() - $twentyfourhours * 1;
$myselect = "select * FROM thread where forumid='11' ORDER BY lastpost DESC LIMIT 10";
$result = mysql_query($myselect);
if ($row = mysql_fetch_array($result)) {
do {
printf("<LI TYPE=square><a href=\"http://www.zoque.com/vbulletin/showthread.php3?threadid=%d\">%s</a><br>%d views - %d replies</li><BR><BR>", $row[threadid], $row[title], $row[views], $row[replycount]);
} while ($row = mysql_fetch_array($result));
}
?>
i use the hack for the last 10 posts from wluke. the links looks like:
the name of the thread
views - replies
but i just want something like this:
the name of link [ >>> ]
views - replies
with my html knowledge i could not make the necessary change on the line:
<a href=\"http://www.zoque.com/vbulletin/showthread.php3?threadid=%d\">%s</a>
best regards