poolhashrategraph.php

<?php
#    wizstats - bitcoin pool web statistics - 1StatsQytc7UEZ9sHJ9BGX2csmkj8XZr2
#    Copyright (C) 2012  Jason Hughes <wizkid057@gmail.com>
#
#    This program is free software: you can redistribute it and/or modify
#    it under the terms of the GNU Affero General Public License as published by
#    the Free Software Foundation, either version 3 of the License, or
#    (at your option) any later version.
#
#    This program is distributed in the hope that it will be useful,
#    but WITHOUT ANY WARRANTY; without even the implied warranty of
#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
#    GNU Affero General Public License for more details.
#
#    You should have received a copy of the GNU Affero General Public License
#    along with this program.  If not, see <http://www.gnu.org/licenses/>.

error_reporting(E_ALL ^ E_NOTICE);

require_once 'includes.php';
$link = pg_pconnect("dbname=$psqldb user=$psqluser password='$psqlpass' host=$psqlhost");


$sql = "select sum(hashrate) as hr,time from $psqlschema.stats_shareagg where server=$serverid and time > NOW()-'10 days'::interval-'12 hours'::interval group by time order by time asc;";
header("Content-type: text/csv");
$query_hash = hash("sha256", $sql);
$cacheddata = get_stats_cache($link, 4, $query_hash);
if ($cacheddata != "") {
	print $cacheddata;
	exit;
}


$result = pg_exec($link, $sql);
$numrows = pg_numrows($result);


$tdata = "date,hashrate,hashrate3hr,hashrate12hr\n";
print $tdata;


	$an = 0;
	$an2 = 0;

	for($i=0;$i<64;$i++) { $ta[$i] = 0; $ta2[$i] = 0; }
	for($i=0;$i<128;$i++) { $lagavg3[$i] = 0; $lagavg12[$i] = 0; }

	$lav = 0;

	for($ri = 0; $ri < $numrows+32; $ri++) {
		if ($ri < $numrows) {
			$row = pg_fetch_array($result, $ri);
			$ta[$an] = $row["hr"]; $an++; if ($an == 16) { $an = 0; } $av = 0; for($i=0;$i<16;$i++) { $av += $ta[$i]; } if ($ri > 16) {       $av = $av / 16; } else { $av = ""; }
			$ta2[$an2] = $row["hr"]; $an2++; if ($an2 == 64) { $an2 = 0; } $av2 = 0; for($i=0;$i<64;$i++) { $av2 += $ta2[$i]; } if ($ri > 64) {       $av2 = $av2 / 64; } else { $av2 = ""; }

			$lagavg3[$lav] = round($av/1000000000,2);
			$lagavg12[$lav] = round($av2/1000000000,2);
		} else {
			unset($row);
			$lagavg3[$lav] = "";
			$lagavg12[$lav] = "";
		}

		if ($ri > 64) {

			$lagavg675[$lav] = $row["time"].",".$row["hr"]/1000000000;

			if ($ri > 64+32) {
				$lavx = $lav - 32; if ($lavx < 0) { $lavx+=128; }
				$lavy = $lav - 24; if ($lavy < 0) { $lavy+=128; }
				$lavz = $lav - 0; if ($lavz < 0) { $lavz+=128; }
				$tline = $lagavg675[$lavx].",".$lagavg3[$lavy].",".$lagavg12[$lavz]."\n";
				$tdata .= $tline;
				print $tline;
			}
		}

		$lav++; if ($lav == 128) { $lav = 0; }

	}

	set_stats_cache($link, 4, $query_hash, $tdata, 675);

exit();


?>