Thread: Last X torrents
View Single Post
  #1  
Old 1st May 2009, 15:38
sammygo sammygo is offline
Senior Member
 
Join Date: May 2008
P2P
Posts: 141
Default Last X torrents
Here is Last X torrents with poster and marquee function.

Here is the code
Code:
//Start of Last X torrents with poster and marquee mod
$query="SELECT id, name, poster FROM torrents WHERE poster <> '' ORDER BY added DESC LIMIT XXX";
$result=mysql_query($query);$num = mysql_num_rows($result);
print("<br>");
print("<h2>Last XXX Torrents</h2>");
print("<table cellpadding=2 width=100% align=center><tr><td colspan=1 align=center><marquee scrollAmount=3 onMouseover=this.scrollAmount=0 onMouseout=this.scrollAmount=3 scrolldelay=0 direction=left>");
while ($row = mysql_fetch_assoc($result))  {
$id = $row['id'];
$name = $row['name'];
$poster = $row['poster'];
$name = str_replace('_', ' ' , $name);
$name = str_replace('.', ' ' , $name);
$name = substr($name, 0, 50);
print("<a href=$BASEURL/details.php?id=$id title=$name><img src=$poster width=100 height=142 title=$name border=0></a>");
}
print("</marquee></td></tr></table>");
//End of Last X torrents with poster and marquee mod
Change this :
Code:
DESC LIMIT XXX
And this :
Code:
print("<h2>Last XXX Torrents</h2>");
Thanks to Cue @ tbdev.net for this mod :X
Picture:
Click the image to open in full size.

Last edited by sammygo; 1st May 2009 at 16:03.
Reply With Quote
The Following 3 Users Say Thank You to sammygo For This Useful Post:
gaba89 (25th July 2012), JoKeR_3D (2nd January 2010), Tibys08 (29th May 2011)