Bravo List
Register
Go Back   > Bravo List > Source Code > Archived Trackers > TBDev
Reply
  #1  
Old 10th October 2020, 12:18
Brendal Brendal is offline
Member
 
Join Date: Mar 2015
Posts: 3
Default TBDev 08 snatched in browse mod request
Hello everyone,
I need to implement a mod, which will be tagging already downloaded by user in browse.php. It can be an icon or column background color. I've tried to use this querry:
Code:
mysql_query("select count(snatched.id) from snatched inner join users on  snatched.userid = users.id inner join torrents on snatched.torrentid =  torrents.id where snatched.finished='yes'AND snatched.torrentid =" .  $_GET[id]) or die(mysql_error());

but I have no idea what function should I use for $CURUSER and where I should place it.


Thank you for any help and suggestions.


Best regards,
Brendal.
Reply With Quote
  #2  
Old 10th October 2020, 17:34
Elena Elena is offline
Senior Member
 
Join Date: Sep 2010
P2P
Posts: 111
Default
Code:
print("<td align="left">".($row["not_sticky"] == "no" ? "Important: " : "")."");
///////////////////////   
$to = mysql_query("SELECT COUNT(*) FROM snatched WHERE userid='".$CURUSER['id']."' AND torrent='".$row['id']."'"); //request
$tok = mysql_fetch_array($to);
if(!$tok['0']){}else{?>         
&nbsp;<a href="download.php?id=<?=$row['id']?>"><img src="pic/trans.gif" title="You have already taken this torrent. Click to download the .torrent file again."/></a>&nbsp;<?}
////////////////////////////
print("<a href="details.php?");
if ($variant == "mytorrents")
Reply With Quote
  #3  
Old 12th October 2020, 14:03
Brendal Brendal is offline
Member
 
Join Date: Mar 2015
Posts: 3
Default
Thank you for reply.
I will try this. If I will have any problems I will post again.
Once moge time big thanks and best regards,
Brendal

EDIT:
Something is wrong it is displaying it out of table... Any tips?
Best regards,
Brendal.

Last edited by Brendal; 12th October 2020 at 19:02.
Reply With Quote
  #4  
Old 13th October 2020, 12:00
Thor Thor is offline
Administrator
 
Join Date: Jan 2017
United Kingdom
Posts: 33
Default
The example that was given to you will not work as it’s for a different source code.
Reply With Quote
  #5  
Old 14th October 2020, 10:44
Brendal Brendal is offline
Member
 
Join Date: Mar 2015
Posts: 3
Default
Yes, I know that. It also can be related with other mods, but I managed to make a different color for whole row on snatched position. It is enough for me. Thanks for help.


Best regards,
Brendal.
Reply With Quote
Reply

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



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