| Name/Info Hash | Seeders | Leechers | Bytes Transfered | Stale Clients | Peer Cache | "; if (!is_null($filename)) echo $filename; else echo $hash; echo " | "; if (!$results2) { echo "Unable to process: ".mysql_error()." | "; continue; } $counts = array(); while ($row = mysql_fetch_row($results2)) $counts[$row[0]] = $row[1]; if (!isset($counts["leecher"])) $counts["leecher"] = 0; if (!isset($counts["seeder"])) $counts["seeder"] = 0; if ($counts["seeder"] != $seeders) { quickQuery("UPDATE ".$prefix."summary SET seeds=".$counts["seeder"]." WHERE info_hash=\"$hash\""); echo "$seeders -> ".$counts["seeder"]." | "; } else echo "$seeders | "; if ($counts["leecher"] != $leechers) { quickQuery("UPDATE ".$prefix."summary SET leechers=".$counts["leecher"]." WHERE info_hash=\"$hash\""); echo "$leechers -> ".$counts["leecher"]." | "; } else echo "$leechers | "; if ($counts["leecher"] == 0) { //If there are no leechers, set the speed to zero quickQuery("UPDATE ".$prefix."summary set speed=0 WHERE info_hash=\"$hash\""); } if ($bytes < 0) { quickQuery("UPDATE ".$prefix."summary SET dlbytes=0 WHERE info_hash=\"$hash\""); echo "$bytes -> Zero | "; } else echo "". round($bytes/1048576/1024,3) ." GB | "; myTrashCollector($hash, $report_interval, time(), $writeout); echo ""; $result = mysql_query("SELECT ".$prefix."x$hash.sequence FROM ".$prefix."x$hash LEFT JOIN ".$prefix."y$hash ON ".$prefix."x$hash.sequence = ".$prefix."y$hash.sequence WHERE ".$prefix."y$hash.sequence IS NULL") or die(errorMessage() . "" . mysql_error() . ""); if (mysql_num_rows($result) > 0) { echo "Added ", mysql_num_rows($result); $row = array(); while ($data = mysql_fetch_row($result)) $row[] = "sequence=\"${data[0]}\""; $where = implode(" OR ", $row); $query = mysql_query("SELECT * FROM ".$prefix."x$hash WHERE $where"); while ($row = mysql_fetch_assoc($query)) { $compact = mysql_real_escape_string(pack('Nn', ip2long($row["ip"]), $row["port"])); $peerid = mysql_real_escape_string('2:ip' . strlen($row["ip"]) . ':' . $row["ip"] . '7:peer id20:' . hex2bin($row["peer_id"]) . "4:porti{$row["port"]}e"); $no_peerid = mysql_real_escape_string('2:ip' . strlen($row["ip"]) . ':' . $row["ip"] . "4:porti{$row["port"]}e"); mysql_query("INSERT INTO ".$prefix."y$hash SET sequence='{$row["sequence"]}', compact='$compact', with_peerid='$peerid', without_peerid='$no_peerid'"); } } else echo "Added none"; $result = mysql_query("SELECT ".$prefix."y$hash.sequence FROM ".$prefix."y$hash LEFT JOIN ".$prefix."x$hash ON ".$prefix."y$hash.sequence = ".$prefix."x$hash.sequence WHERE ".$prefix."x$hash.sequence IS NULL"); if (mysql_num_rows($result) > 0) { echo ", Deleted ",mysql_num_rows($result); $row = array(); while ($data = mysql_fetch_row($result)) $row[] = "sequence=\"${data[0]}\""; $where = implode(" OR ", $row); $query = mysql_query("DELETE FROM ".$prefix."y$hash WHERE $where"); } else echo ", Deleted none"; echo " | "; echo "\n"; $i ++; if ($locking) quickQuery("UNLOCK TABLES"); //Repair tables, is this necessary? Sometimes the tables crash... //Can't repair table if locked? //quickQuery("REPAIR Table x$hash"); //quickQuery("REPAIR Table y$hash"); // Finally, it's time to do stuff to the summary table. if (!empty($summaryupdate)) { $stuff = ""; foreach ($summaryupdate as $column => $value) { $stuff .= ', '.$column. ($value[1] ? "=" : "=$column+") . $value[0]; } mysql_query("UPDATE ".$prefix."summary SET ".substr($stuff, 1)." WHERE info_hash=\"$hash\""); $summaryupdate = array(); } } function myTrashCollector($hash, $timeout, $now, $writeout) { // error_log("Trash collector working on $hash"); require("config.php"); $peers = loadLostPeers($hash, $timeout); for ($i=0; $i < $peers["size"]; $i++) killPeer($peers[$i]["peer_id"], $hash, $peers[$i]["bytes"], $peers[$i]); if ($i != 0) echo "Removed $i | "; else echo "Removed 0 | "; quickQuery("UPDATE ".$prefix."summary SET lastcycle='$now' WHERE info_hash='$hash'"); } ?>
|---|
Not working? Try running this.
Return to Statistics Page
Return to Admin Page