Bravo List

Bravo List (http://www.bvlist.com/index.php)
-   TBDev (http://www.bvlist.com/forumdisplay.php?f=20)
-   -   how can i know on my tracker if sumone is cheating? (http://www.bvlist.com/showthread.php?t=9292)

nirbe 10th July 2013 14:24

how can i know on my tracker if sumone is cheating?
 
i want to open a tracker, and i'd like to know how can i tell if somebody is cheating on theire upload (RatioMaster and such...).

Thanks!

wMan 10th July 2013 14:30

easy install the cheating mod

nirbe 10th July 2013 14:44

Quote:

Originally Posted by TrinitY-RG (Post 41508)
easy install the cheating mod

Where can i find this "cheating mod"?








    $num = 0;
    while ($a = mysql_fetch_assoc($res))
    {
      ++$num;
      $highlight = $CURUSER["id"] == $a["userid"] ? " bgcolor=#BBAF9B" : "";
      if ($a["downloaded"])
      {
        $ratio = $a["uploaded"] / $a["downloaded"];
        $color = get_ratio_color($ratio);
        $ratio = number_format($ratio, 2);
        if ($color)
          $ratio = "$ratio";
      }
      else
        $ratio = "Inf.";
      print("");
    }
    end_table();
    end_frame();
  }

  stdhead("Ratio is 100 of above");

    $mainquery = "SELECT id as userid, username, added, uploaded, downloaded, uploaded / (UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(added)) AS upspeed, downloaded / (UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(added)) AS downspeed FROM users WHERE enabled = 'yes'";

          $limit = 250;
        $order = "added ASC";
        //$order = "uploaded / downloaded ASC, downloaded DESC";
          $extrawhere = " AND uploaded / downloaded > 100 and class <= 2";
          $r = mysql_query($mainquery . $extrawhere . " ORDER BY $order " . " LIMIT $limit") or sqlerr();
          usertable($r, "Ratio Above 100");

stdfoot();

?>
wMan 10th July 2013 14:51

Go to staff tools and the tool

Maybe Cheaters
Those users maybe are cheaters

Call it maybecheaters Add to dir root

Code:

ob_start("ob_gzhandler");
require "include/bittorrent.php";
dbconn(false);
loggedinorreturn();

if (get_user_class() < UC_MODERATOR)
stderr("Sorry", "Access denied.");

  function usertable($res, $frame_caption)
  {
      global $CURUSER;
    begin_frame($frame_caption, true);
    begin_table();
?>

A list of users with a ratio above 100. (VIP class and under)
Sorted by join date (oldest first).


User Uploaded Downloaded Ratio Joined
              $a["userid"] . ">" . $a["username"] . "" .
              "
" . mksize($a["uploaded"]) .
            "
" . mksize($a["downloaded"]) .
              "
" . $ratio .
              "
" . gmdate("Y-m-d",strtotime($a["added"])) . " (" .
              get_elapsed_time(sql_timestamp_to_unix_timestamp($a["added"])) . " ago)

nirbe 10th July 2013 14:59

Quote:







    $num = 0;
    while ($a = mysql_fetch_assoc($res))
    {
      ++$num;
      $highlight = $CURUSER["id"] == $a["userid"] ? " bgcolor=#BBAF9B" : "";
      if ($a["downloaded"])
      {
        $ratio = $a["uploaded"] / $a["downloaded"];
        $color = get_ratio_color($ratio);
        $ratio = number_format($ratio, 2);
        if ($color)
          $ratio = "$ratio";
      }
      else
        $ratio = "Inf.";
      print("");
    }
    end_table();
    end_frame();
  }

  stdhead("Ratio is 100 of above");

    $mainquery = "SELECT id as userid, username, added, uploaded, downloaded, uploaded / (UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(added)) AS upspeed, downloaded / (UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(added)) AS downspeed FROM users WHERE enabled = 'yes'";

          $limit = 250;
        $order = "added ASC";
        //$order = "uploaded / downloaded ASC, downloaded DESC";
          $extrawhere = " AND uploaded / downloaded > 100 and class <= 2";
          $r = mysql_query($mainquery . $extrawhere . " ORDER BY $order " . " LIMIT $limit") or sqlerr();
          usertable($r, "Ratio Above 100");

stdfoot();

?>


Originally Posted by TrinitY-RG (Post 41512)
Go to staff tools and the tool

Maybe Cheaters
Those users maybe are cheaters

Call it maybecheaters Add to dir root

Code:

ob_start("ob_gzhandler");
require "include/bittorrent.php";
dbconn(false);
loggedinorreturn();

if (get_user_class() < UC_MODERATOR)
stderr("Sorry", "Access denied.");

  function usertable($res, $frame_caption)
  {
      global $CURUSER;
    begin_frame($frame_caption, true);
    begin_table();
?>

A list of users with a ratio above 100. (VIP class and under)
Sorted by join date (oldest first).


User Uploaded Downloaded Ratio Joined
              $a["userid"] . ">" . $a["username"] . "" .
              "
" . mksize($a["uploaded"]) .
            "
" . mksize($a["downloaded"]) .
              "
" . $ratio .
              "
" . gmdate("Y-m-d",strtotime($a["added"])) . " (" .
              get_elapsed_time(sql_timestamp_to_unix_timestamp($a["added"])) . " ago)
Ok, it's ingenious.

But there is no way else to know if someone is cheating? just this way?

wMan 10th July 2013 15:00

yep but ill look if i have a better mod for it somewhere i made

nirbe 10th July 2013 15:04

Quote:

Originally Posted by TrinitY-RG (Post 41514)
yep but ill look if i have a better mod for it somewhere i made

I can build mods, i am a PHP programmer, but i have no idea.

wMan 10th July 2013 15:05

smsl:cool:

nirbe 10th July 2013 15:13

Quote:

Originally Posted by TrinitY-RG (Post 41518)
smsl:cool:

There is another way?

firefly007 10th July 2013 16:32

Quote:

Originally Posted by nirbe (Post 41519)
There is another way?

Yes, you block clients(black list peer ID's)

x360zone 10th July 2013 17:52

hi
 
there is no real way

i can go on any site use bitclient app that i posted on here and cheat on any tracker seba14 google

ratio master is a thing of the past

firefly007 10th July 2013 17:59

Yea! Maybe block VUSE completely and java Clients...

nirbe 10th July 2013 18:57

any way, i found a way.

tnx.

Giorgatzelos 11th July 2013 00:13

Quote:

Originally Posted by x360zone (Post 41526)
there is no real way

i can go on any site use bitclient app that i posted on here and cheat on any tracker seba14 google

ratio master is a thing of the past

Can you give a link of that app?
Thanx...

x360zone 11th July 2013 09:52

hi
 
1 Attachment(s)
so you can use it on trackers lol
pass


seba14
or
seba14.org

nirbe 11th July 2013 19:31

Nothing work.
And more something.
There is H&R mod for TBdev 2009 (or how i can calculate sharing time)?

Giorgatzelos 11th July 2013 21:13

seba14 works...

nirbe 12th July 2013 08:07

I can't open the rar..

more something, There is H&R mod for TBdev 2009 (or how i can calculate sharing time)?

x360zone 12th July 2013 10:13

hi
 
Quote:

Originally Posted by nirbe (Post 41565)
I can't open the rar..

more something, There is H&R mod for TBdev 2009 (or how i can calculate sharing time)?



works fine for me may get a change winrar version

nirbe 12th July 2013 11:57

Quote:

Originally Posted by x360zone (Post 41568)
works fine for me may get a change winrar version

Ok, i will try.

more something, There is H&R mod for TBdev 2009 (or how i can calculate sharing time)?

firefly007 12th July 2013 21:00

Quote:

Originally Posted by nirbe (Post 41571)
Ok, i will try.

more something, There is H&R mod for TBdev 2009 (or how i can calculate sharing time)?

Have a look @ u232 forums, there's a hit and run hack for 09'

http://forum.u-232.com/index.php/topic,1228.0.html

nirbe 13th July 2013 13:18

Quote:

Originally Posted by firefly007 (Post 41574)
Have a look @ u232 forums, there's a hit and run hack for 09'

http://forum.u-232.com/index.php/topic,1228.0.html

I dont have snatched table..

firefly007 13th July 2013 13:36

Mysql tables?

nirbe 13th July 2013 14:24

Quote:

Originally Posted by firefly007 (Post 41584)
Mysql tables?

Yes, i need to create one?

firefly007 13th July 2013 23:22

Quote:

Originally Posted by nirbe (Post 41585)
Yes, i need to create one?

You need to run the query... (alter Table)

Go to Phpmyadmin => The database in question => Then click on SQL button

Then Paste this in below:

ALTER TABLE `snatched` ADD `hit_and_run` INT(11) NOT NULL;
ALTER TABLE `snatched` ADD `mark_of_cain` enum('yes','no') NOT NULL DEFAULT 'no';
ALTER TABLE snatched ADD `finished` enum('yes','no') NOT NULL DEFAULT 'no';
ALTER TABLE `users` ADD `hnrwarn` enum('yes','no') NOT NULL DEFAULT 'no';
ALTER TABLE `users` ADD `hit_and_run_total` INT(9) DEFAULT '0';

Then hit the "GO"

nirbe 14th July 2013 07:20

Quote:

Originally Posted by firefly007 (Post 41586)
You need to run the query... (alter Table)

Go to Phpmyadmin => The database in question => Then click on SQL button

Then Paste this in below:

ALTER TABLE `snatched` ADD `hit_and_run` INT(11) NOT NULL;
ALTER TABLE `snatched` ADD `mark_of_cain` enum('yes','no') NOT NULL DEFAULT 'no';
ALTER TABLE snatched ADD `finished` enum('yes','no') NOT NULL DEFAULT 'no';
ALTER TABLE `users` ADD `hnrwarn` enum('yes','no') NOT NULL DEFAULT 'no';
ALTER TABLE `users` ADD `hit_and_run_total` INT(9) DEFAULT '0';

Then hit the "GO"

I know that, but how can i run AFTER TABLE if the table doesn't exist?

wMan 14th July 2013 10:09

Code:

ALTER TABLE `snatched` ADD `hit_and_run` INT(11) NOT NULL;
ALTER TABLE `snatched` ADD `mark_of_cain` enum('yes','no') NOT NULL DEFAULT 'no';
ALTER TABLE `snatched` ADD `finished` enum('yes','no') NOT NULL DEFAULT 'no';
ALTER TABLE `users` ADD `hnrwarn` enum('yes','no') NOT NULL DEFAULT 'no';
ALTER TABLE `users` ADD `hit_and_run_total` INT(9) DEFAULT '0';

ALLSO INPORT THE FULL SQL BEFORE ADDING THIS

firefly007 14th July 2013 11:44

Quote:

Originally Posted by nirbe (Post 41597)
I know that, but how can i run AFTER TABLE if the table doesn't exist?

Yea! I see what you saying... The snatch table needed does not come with the default Sql as far a I can recall might need to hunt around for it.

nirbe 15th July 2013 10:38

Quote:

Originally Posted by firefly007 (Post 41601)
Yea! I see what you saying... The snatch table needed does not come with the default Sql as far a I can recall might need to hunt around for it.

So where i can find this table?


All times are GMT +2. The time now is 13:27.

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