[cihangir]

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