Bravo List
Register
Go Back   > Bravo List > Source Code > Archived Trackers > TBDev
Reply
  #1  
Old 2nd November 2009, 16:59
irfan's Avatar
irfan irfan is offline
Senior Member
 
Join Date: Jun 2009
United Kingdom
Posts: 67
Default Sort torrent by column mod
can some1 help me add this mod please in my browse.php thanks:
Board Message - thats the mod.

i attached the file browse.php thanks.
Attached Files
File Type: php browse.php (7.8 KB, 25 views)
Reply With Quote
  #2  
Old 2nd November 2009, 17:22
daffy's Avatar
daffy daffy is offline
Senior Member
 
Join Date: Mar 2009
United Kingdom
Posts: 550
Default
you wil need to post the code from tbdev as not everyone is a member from tbdev. i know im not.
__________________
"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
  #3  
Old 2nd November 2009, 17:30
irfan's Avatar
irfan irfan is offline
Senior Member
 
Join Date: Jun 2009
United Kingdom
Posts: 67
Default
Edit: This is the new version with 2 fixed XSS vunerabilities.

1. in browse.php find


PHP Code:
if (empty($cleansearchstr))
    unset(
$cleansearchstr);

// sorting by MarkoStamcar

if ($_GET['sort'] && $_GET['type']) {

$column '';
$ascdesc '';

    switch(
$_GET['sort']) {
        case 
'1'$column "name"; break;
        case 
'2'$column "numfiles"; break;
        case 
'3'$column "comments"; break;
        case 
'4'$column "added"; break;
        case 
'5'$column "size"; break;
        case 
'6'$column "times_completed"; break;
        case 
'7'$column "seeders"; break;
        case 
'8'$column "leechers"; break;
        case 
'9'$column "owner"; break;
  default: 
$column "id"; break;
    }

    switch(
$_GET['type']) {
  case 
'asc'$ascdesc "ASC"$linkascdesc "asc"; break;
  case 
'desc'$ascdesc "DESC"$linkascdesc "desc"; break;
  default: 
$ascdesc "DESC"$linkascdesc "desc"; break;
    }


$orderby "ORDER BY torrents." $column " " $ascdesc;
$pagerlink "sort=" intval($_GET['sort']) . "&type=" $linkascdesc "&";

} else {

$orderby "ORDER BY torrents.id DESC";
$pagerlink "";


2. (still in browse.php) find:

PHP Code:
$torrentsperpage $CURUSER["torrentsperpage"];
if (!
$torrentsperpage)
    
$torrentsperpage 15;

if (
$count)

and add after it:

PHP Code:
<td class="colhead" align="center">Type</td>
<td class="colhead" align=left>Name</td>
<!--<td class="heading" align=left>DL</td>-->
<?
    
if ($wait)
    {
        print(
"<td class=\"colhead\" align=\"center\">Wait</td>\n");
    }

    if (
$variant == "mytorrents")
  {
      print(
"<td class=\"colhead\" align=\"center\">Edit</td>\n");
    print(
"<td class=\"colhead\" align=\"center\">Visible</td>\n");
    }

?>
<td class="colhead" align=right>Files</td>
<td class="colhead" align=right>Comm.</td>
<!--<td class="colhead" align="center">Rating</td>-->
<td class="colhead" align="center">Added</td>
<td class="colhead" align="center">TTL</td>
<td class="colhead" align="center">Size</td>
<!--
<td class="colhead" align=right>Views</td>
<td class="colhead" align=right>Hits</td>
-->
<td class="colhead" align="center">Snatched</td>
<td class="colhead" align=right>Seeders</td>
<td class="colhead" align=right>Leechers</td>
<?

    
if ($variant == "index")
        print(
"<td class=\"colhead\" align=center>Upped&nbsp;by</td>\n");

    print(
"</tr>\n");
and replace it by:

PHP Code:
<?

// sorting by MarkoStamcar

$count_get 0;

foreach (
$_GET as $get_name => $get_value) {

    
$get_name mysql_escape_string(strip_tags(str_replace(array("\"","'"),array("",""),$get_name)));

    
$get_value mysql_escape_string(strip_tags(str_replace(array("\"","'"),array("",""),$get_value)));
    
    if (
$get_name != "sort" && $get_name != "type") {
        if (
$count_get 0) {
            
$oldlink $oldlink "&" $get_name "=" $get_value;
        } else {
            
$oldlink $oldlink $get_name "=" $get_value;
        }
        
$count_get++;
    }

}

if (
$count_get 0) {
    
$oldlink $oldlink "&";
}


if (
$_GET['sort'] == "1") {
    if (
$_GET['type'] == "desc") {
        
$link1 "asc";
    } else {
        
$link1 "desc";
    }
}

if (
$_GET['sort'] == "2") {
    if (
$_GET['type'] == "desc") {
        
$link2 "asc";
    } else {
        
$link2 "desc";
    }
}

if (
$_GET['sort'] == "3") {
    if (
$_GET['type'] == "desc") {
        
$link3 "asc";
    } else {
        
$link3 "desc";
    }
}

if (
$_GET['sort'] == "4") {
    if (
$_GET['type'] == "desc") {
        
$link4 "asc";
    } else {
        
$link4 "desc";
    }
}

if (
$_GET['sort'] == "5") {
    if (
$_GET['type'] == "desc") {
        
$link5 "asc";
    } else {
        
$link5 "desc";
    }
}

if (
$_GET['sort'] == "6") {
    if (
$_GET['type'] == "desc") {
        
$link6 "asc";
    } else {
        
$link6 "desc";
    }
}

if (
$_GET['sort'] == "7") {
    if (
$_GET['type'] == "desc") {
        
$link7 "asc";
    } else {
        
$link7 "desc";
    }
}

if (
$_GET['sort'] == "8") {
    if (
$_GET['type'] == "desc") {
        
$link8 "asc";
    } else {
        
$link8 "desc";
    }
}

if (
$_GET['sort'] == "9") {
    if (
$_GET['type'] == "desc") {
        
$link9 "asc";
    } else {
        
$link9 "desc";
    }
}

if (
$link1 == "") { $link1 "asc"; } // for torrent name
if ($link2 == "") { $link2 "desc"; }
if (
$link3 == "") { $link3 "desc"; }
if (
$link4 == "") { $link4 "desc"; }
if (
$link5 == "") { $link5 "desc"; }
if (
$link6 == "") { $link6 "desc"; }
if (
$link7 == "") { $link7 "desc"; }
if (
$link8 == "") { $link8 "desc"; }
if (
$link9 == "") { $link9 "desc"; }

?>
<td class="colhead" align="center">Type</td>
<td class="colhead" align=left><a href="browse.php?<? print $oldlink?>sort=1&type=<? print $link1?>">Name</a></td>
<!--<td class="heading" align=left>DL</td>-->
<?
    
if ($wait)
    {
        print(
"<td class=\"colhead\" align=\"center\">Wait</td>\n");
    }

    if (
$variant == "mytorrents")
  {
      print(
"<td class=\"colhead\" align=\"center\">Edit</td>\n");
    print(
"<td class=\"colhead\" align=\"center\">Visible</td>\n");
    }

?>
<td class="colhead" align="right"><a href="browse.php?<? print $oldlink?>sort=2&type=<? print $link2?>">Files</a></td>
<td class="colhead" align="right"><a href="browse.php?<? print $oldlink?>sort=3&type=<? print $link3?>">Comm.</a></td>
<!--<td class="colhead" align="center">Rating</td>-->
<td class="colhead" align="center"><a href="browse.php?<? print $oldlink?>sort=4&type=<? print $link4?>">Added</a></td>
<td class="colhead" align="center">TTL</td>
<td class="colhead" align="center"><a href="browse.php?<? print $oldlink?>sort=5&type=<? print $link5?>">Size</a></td>
<!--
<td class="colhead" align=right>Views</td>
<td class="colhead" align=right>Hits</td>
-->
<td class="colhead" align="center"><a href="browse.php?<? print $oldlink?>sort=6&type=<? print $link6?>">Snatched</a></td>
<td class="colhead" align="right"><a href="browse.php?<? print $oldlink?>sort=7&type=<? print $link7?>">Seeders</a></td>
<td class="colhead" align="right"><a href="browse.php?<? print $oldlink?>sort=8&type=<? print $link8?>">Leechers</a></td>
<?

    
if ($variant == "index")
        print(
"<td class=\"colhead\" align=center><a href=\"browse.php?{$oldlink}sort=9&type={$link9}\">Upped&nbsp;by</a></td>\n");

    print(
"</tr>\n");
please do this for me with the attached browse.php in post 1. thanks

Please help

Last edited by irfan; 2nd November 2009 at 22:32.
Reply With Quote
Reply

Tags
column , mod , sort , torrent

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
Remove Local/External column lovebeer Torrent Trader 3 3rd February 2010 04:23
Sort by seeder's ? Zuby TBDev 0 15th January 2010 22:20
Remove a column in TorrentTable lovebeer Template Shares 2 26th November 2009 20:01
Sort by Seeders, leechers and stuff ? Ripparinn Torrent Strike 1 24th July 2009 21:51
Show anonymus on the upped by column Devil150 TBDev 1 2nd June 2008 23:54



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