View Single Post
  #2  
Old 28th January 2012, 23:41
daffy's Avatar
daffy daffy is offline
Senior Member
 
Join Date: Mar 2009
United Kingdom
Posts: 550
Default
add below where you want to show in index.php

Code:
OpenTable("last 10 uploads");         $sql = "SELECT ".$db_prefix."_torrents.*, IF(".$db_prefix."_torrents.numratings < '".$minvotes."', NULL, ROUND(".$db_prefix."_torrents.ratingsum / ".$db_prefix."_torrents.numratings, 1)) AS rating, ".$db_prefix."_categories.name AS cat_name, ".$db_prefix."_categories.image AS cat_pic, U.username, IF(U.name IS NULL, U.username, U.name) as user_name, U.level as user_level FROM ".$db_prefix."_torrents LEFT JOIN ".$db_prefix."_categories ON category = ".$db_prefix."_categories.id LEFT JOIN ".$db_prefix."_users U ON ".$db_prefix."_torrents.owner = U.id WHERE banned = 'no' AND ".$db_prefix."_torrents.password IS NULL ORDER BY ".$db_prefix."_torrents.added DESC LIMIT 10;";         $res = $db->sql_query($sql) or btsqlerror($sql);         if ($db->sql_numrows($res) > 0) {                 torrenttable($res,"usertorrent");         } else {                 OpenTable2();                 echo "<h3>"._btnotorrents."</h3>";                 CloseTable2();         } CloseTable();
change
Code:
DESC LIMIT 10
to how many you want to show

helps to search code main forum to ;)
http://www.phpmybittorrent.com/forum.../399/#msg_2722
__________________
"FFS PPL READ GOD DAMMIT, WHAT AM I GOOGLE?"
"I Kill You!" simples


http://i.imgur.com/DtcRfH5.gif

I also Setup And Modify Trackers PM For Details
Reply With Quote
The Following User Says Thank You to daffy For This Useful Post:
romano1 (29th January 2012)