poolluckgraph.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 *,date_part('epoch', time)::integer-date_part('epoch', roundstart)::integer as duration from $psqlschema.stats_blocks where server=$serverid and confirmations > 0 and height > 210000 order by time asc;";
$query_hash = hash("sha256", $sql.(isset($_GET["btc"])?"BTC":"PERCENTPPS"));
$cacheddata = get_stats_cache($link, 30, $query_hash);
if ($cacheddata != "") {
        print $cacheddata;
        exit;
}

header("Content-type: text/csv");

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

if (isset($_GET["btc"])) {
	$tdata = "date,est_paid,est_shelved,max_reward\n";
} else {
	$tdata = "date,est_paid,est_shelved\n";
}
print $tdata;

$unpaidbal = 0;
$shelvedshares = 0;
$myhashes = 1000000000;
$mytotalshares = 0;
$maxbal = 0;

$ignorepoints = 5;

	for($ri = 0; $ri < $numrows; $ri++) {
			$row = pg_fetch_array($result, $ri);

			$subsidy = 2500000000;
			if ($row["height"] < 210000) {
				$subsidy = 5000000000;
			}

			$diff = round($row["network_difficulty"],0);
			$shares = $row["acceptedshares"];
			$duration = $row["duration"];

			$poolspeed = $hashrate = ($shares * 4294967296) / $duration;

			$myshares = round(($myhashes / 4294967296) * $duration);
			$mytotalshares += $myshares;

			$maxearn = round((($myshares * $subsidy)/$diff));
			$maxbal += $maxearn;
			if ($diff >= $shares) {
				# lucky round
				$unpaidbal += $maxearn;
				if ($shelvedshares > 0) {
					# lucky round means I get some SS back also!
					# how lucky were we?!
					$extrafunds = $subsidy - (($shares * $subsidy)/$diff);
					$myss = round((($myhashes * $extrafunds) / $poolspeed));
					if ($shelvedshares <= $myss) { $shelvedshares = 0; $unpaidbal = $maxbal; } else { $shelvedshares -= $myss; $unpaidbal += $myss; }
				}
			} else {
				# unlucky round
				$luck = $diff/$shares;
				$earned = $luck * $maxearn;
				$shelvedshares += $maxearn - $earned;
				$unpaidbal += $earned;
			}


			$thisctime = strtotime($row["time"]);
			$date = date("Y-m-d H:i:s",$thisctime-1);
			if (isset($_GET["btc"])) {
				$tline = $date.",".sprintf("%.8f",round($unpaidbal/100000000,8)).",".sprintf("%.8f",round($shelvedshares/100000000,8)).",".sprintf("%.8f",round($maxbal/100000000,8))."\n";
				$tdata .= $tline;
				print $tline;
			} else {
				if ($ri > $ignorepoints) {
					$tline = $date.",".sprintf("%.8f",round(($unpaidbal/$maxbal)*100,8))."%,".sprintf("%.8f",round(($shelvedshares/$maxbal)*100,8))."%\n";
					$tdata .= $tline;
					print $tline;
				}
			}


	}
	set_stats_cache($link, 30, $query_hash, $tdata, 3600);

exit();


?>