Bravo List

Bravo List (http://www.bvlist.com/index.php)
-   BT.Manager (phpMyBitTorrent) (http://www.bvlist.com/forumdisplay.php?f=23)
-   -   Modded Torrent Table (http://www.bvlist.com/showthread.php?t=4466)

pwnage 10th February 2010 06:58

Recent Block
 
PHP Code:

OpenTable("Recently Uploaded");
        
$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(); 


wMan 10th February 2010 07:05

open include/bittorent.php

look for
PHP Code:

if ($variant == "index"

        echo 
"<thead><tr><th align=\"center\" width=\"7%\"><p><a href=\"$phpself?sort=4&type=$link4\" title=\"Sort by "._bttype." ".$link4."\">"._bttype."</a></p></th>"
        echo 
"<th align=\"center\" width=\"51%\"><p><a href=\"$phpself".$oldlink."sort=1&type=$link1\" title=\"Sort by "._btname." ".$link1."\">"._btname."</a></p></th>"
        echo 
"<th align=\"center\" width=\"1%\"><p>"._btcomments."</p></th>"
        echo 
"<th align=\"center\" width=\"7%\"><p><a href=\"$phpself".$oldlink."sort=7&type=$link7\" title=\"Sort by "._btseeders." ".$link7."\">"._btseeders."</a></p></th>"
        echo 
"<th align=\"center\" width=\"7%\"><p><a href=\"$phpself".$oldlink."sort=8&type=$link8\" title=\"Sort by "._btleechers." ".$link8."\">"._btleechers."</a></p></th>"
        echo 
"<th align=\"center\" width=\"1%\"><p>"._btnet."</p></th>"
}else{ 
        echo 
"<thead><tr><th align=\"center\" width=\"7%\"><p>"._bttype."</p></th>"
        echo 
"<th align=\"center\" width=\"51%\"><p>"._btname."</p></th>"
        echo 
"<th align=\"center\" width=\"1%\"><p>"._btcomments."</p></th>"
        echo 
"<th align=\"center\" width=\"7%\"><p>"._btseeders."</p></th>"
        echo 
"<th align=\"center\" width=\"7%\"><p>"._btleechers."</p></th>"
        echo 
"<th align=\"center\" width=\"1%\"><p>"._btnet."</p></th>"


and change % values like 7% to 5% will change width of columns

wait for more


All times are GMT +2. The time now is 17:10.

Powered by vBulletin® Version 3.8.11 Beta 3
Copyright ©2000 - 2024, vBulletin Solutions Inc.