Bravo List
Register
Go Back   > Bravo List > Source Code > Archived Trackers > TBDev > Mods & Themes
Reply
  #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)
  #2  
Old 5th May 2009, 04:48
Strikey's Avatar
Strikey Strikey is offline
Senior Member
 
Join Date: Jan 2009
United Kingdom
Posts: 57
Default TBDEV
Another post copied from tbdev
Reply With Quote
  #3  
Old 23rd January 2013, 10:29
bestlap bestlap is offline
Senior Member
 
Join Date: Nov 2012
P2P
Posts: 51
Default
In tbdev 08 dosen't work >>

Click the image to open in full size.
Reply With Quote
  #4  
Old 23rd January 2013, 12:51
Chez's Avatar
Chez Chez is offline
Senior Member
 
Join Date: Sep 2011
P2P
Posts: 278
Default
//
__________________
http://www.bvlist.com/images/avatars/signaturepics/sigpic16443_2.gif
Reply With Quote
  #5  
Old 23rd January 2013, 17:39
bestlap bestlap is offline
Senior Member
 
Join Date: Nov 2012
P2P
Posts: 51
Default
Quote:
Originally Posted by Chez View Post
//
?
Reply With Quote
  #6  
Old 23rd January 2013, 18:32
Chez's Avatar
Chez Chez is offline
Senior Member
 
Join Date: Sep 2011
P2P
Posts: 278
Default
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($name050);
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 `posterblob 
__________________
http://www.bvlist.com/images/avatars/signaturepics/sigpic16443_2.gif
Reply With Quote
The Following User Says Thank You to Chez For This Useful Post:
bestlap (23rd January 2013)
Reply

Tags
torrents

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Torrents.ro Fynnon Community Cafe 2 21st January 2015 12:45
TorrentStrike theme engine to TBdev Kotafi Mods & Themes 6 13th May 2012 04:42
Import TBdev & TT torrents to phpMyBitTorrent joeroberts Mods & Themes 1 12th November 2010 05:39
Problem with TBDEV Tracker - Torrents problem M4d4lyNn TBDev 0 15th January 2010 08:49



All times are GMT +2. The time now is 15:16. vBulletin skin by ForumMonkeys. Powered by vBulletin® Version 3.8.11 Beta 3
Copyright ©2000 - 2024, vBulletin Solutions Inc.