The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
|
|||||||
|
|
|
#1
03-15-2001, 11:05 AM
|
|||
|
|||
Please help.
Could you go to www.visordown.com/forums and click on office pal at the top. Apparantly it does not owrk which is really annoying. anyway here is the code Code:
<HTML>
<HEAD>
<TITLE></TITLE>
<STYLE type=text/css>
A:active {COLOR: #000000 ;}
A:visited {COLOR: #333333 ; text-decoration: none ;}
A:hover {COLOR: #666666; text-decoration: underline ;}
A:link {COLOR: #000000; text-decoration: none ;}
</STYLE>
</HEAD>
<body leftmargin=0 rightmargin=0 topmargin=0 marginwidth=0 marginheight=0 bgColor="#FFFFFF">
<br>
<center><font face="verdana" size="2"><a href="javascript:window.location.reload()">Click here to refresh</a> <a href="javascript:window.close();">Click here to close window</a></center>
<!-- ## START THREAD TABLE ## -->
<br>
<?php
require("http://www.visordown.com/forums/global.php");
$db_link = @mysql_pconnect("$dbservername", "$dbusername", "$dbpassword");
mysql_select_db("$dbname");
?>
<table cellpadding="4" cellspacing="1" width="100%">
<tr bgcolor="#DDDDDD">
<td><font color="#000000" face="verdana" size="2"><small><strong>Show the last 10 threads</strong></small></td>
<td align="center"><font color="#000000" face="verdana" size="2"><small><strong>REPLIES</strong></small></td>
<td align="center"><font color="#000000" face="verdana" size="2"><small><strong>VIEWS</strong></small></td>
</tr>
<?php
$lastten = lastten();
while( $row = mysql_fetch_row($lastten) )
{
print('<tr bgcolor="#F2F0F0">');
print('<td>');
print('<font size="2" face="verdana"><a href="http://www.visordown.com/forums/showthread.php?s=&threadid=');
print($row[0]);
print('" target="_blank">');
print($row[1]);
print('</a></td>');
print('<td align="center">');
print($row[2]);
print('</td>');
print('<td align="center">');
print($row[3]);
print('</td>');
print('</tr>');
}
mysql_free_result ($lastten);
?>
</table>
<?php
function lastten()
{
$query = 'SELECT threadid, title, replycount, views ' .
'FROM thread ' .
'WHERE (' . $cur_time . '-lastpost) < 604800 ' .
'ORDER BY threadid DESC LIMIT 10';
$result = mysql_query($query)
or die('most_viewed query failed');
return($result);
}
?>
</BODY>
</HTML>
Could you help me make it work, and ideally I woudl like to show the last 10 posts not threads. I know its a long shot, but I hope it can be done. cheers, ~veedee 
|
 |
«
Previous Thread
|
Next Thread
»
| Thread Tools | |
| Display Modes | |
Hybrid Mode
|
|
All times are GMT. The time now is 05:27 AM.