<?php /** * VBulletin Torrent Tracker 3 PHP v1.1 SVN * Coded by Toolmanwill **/ // ######################## SET PHP ENVIRONMENT ########################### error_reporting(E_ALL & ~E_NOTICE); if (!is_object($vbulletin->db)) { exit; } // ######################################################################## // ######################### START MAIN SCRIPT ############################ // ######################################################################## // number of seeders and leechers $res1 = $vbulletin->db->query_read("SELECT SUM(seeders) AS c, sum(leechers) AS d FROM ". TABLE_PREFIX ."attachment "); $row1= $vbulletin->db->fetch_array($res1) ; // speed totals $res2 = $vbulletin->db->query_read("SELECT SUM(ulspeed) AS c, sum(dlspeed) AS d FROM ". TABLE_PREFIX ."peers "); $row2= $vbulletin->db->fetch_array($res2) ; $vbulletin->db->query_write("INSERT INTO ". TABLE_PREFIX ."trackerhistory (`date` , `seeders`, `leechers`, `ulspeed`, `dlspeed`) VALUES (NOW(),".$row1["c"]." , ".$row1["d"].",".$row2["c"]." , ".$row2["d"].") "); log_cron_action('Daily Bittorrent Tracker History stored', $nextitem); ?> |