Bravo List - Last X torrents

Bravo List (http://www.bvlist.com/index.php)

- Mods & Themes (http://www.bvlist.com/forumdisplay.php?f=109)

- - Last X torrents (http://www.bvlist.com/showthread.php?t=2537)

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("");

print("Last XXX Torrents
");

print("");

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("");

}

print("
");

//End of Last X torrents with poster and marquee mod

Change this :

Code:

DESC LIMIT XXX

And this :

Code:

print("Last XXX Torrents
");

Thanks to Cue @ tbdev.net for this mod :X :drink:
Picture:
http://img335.imageshack.us/img335/792/lastxxxez2.jpg

Another post copied from tbdev

In tbdev 08 dosen't work >>

http://i.imgur.com/nJA97Mk.jpg

Quote:

Originally Posted by Chez (Post 39030)

:sos:?

add this in index.php where do you want to appear

PHP 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 10";

$result=mysql_query($query);$num = mysql_num_rows($result);

print("<table cellpadding=2 width=93% align=center><tr><td colspan=1 align=center>

<marquee scrollAmount=2 onmouseover=this.scrollAmount=0 onmouseout=this.scrollAmount=2 scrolldelay=50 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);

if (!empty($poster)){

print("<a href=$BASEURL/details.php?id=$id title=$name><img src=$poster width=120 height=180 title=$name border=0></a>");

} else {

print("<a href=$BASEURL/details.php?id=$id title=$name><img src=pic/poster.jpg width=120 height=180 title=$name border=0></a>");

} } print("</marquee></td></tr></table>");

//== End of Last X torrents with poster and marquee mod ==//

and run this SQL query in phpmyadmin

PHP Code:


		
			
ALTER TABLE torrents ADD `poster` blob ;