topcontributors.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/>.



require_once 'includes.php';

if (!isset($link)) { $link = pg_pconnect("dbname=$psqldb user=$psqluser password='$psqlpass' host=$psqlhost"); }


if (!isset($subcall)) {
	$titleprepend = "Contributors - ";
	print_stats_top();
	$minilimit = "";
	$cachehash = "topcontributors.php v2 full call";
} else {
	$cachehash = "topcontributors.php v2 subcall $minilimit";
}

$cachehash = hash("sha256", $cachehash);
$cacheddata = get_stats_cache($link, 20, $cachehash);

if ($cacheddata != "") {
	print $cacheddata;
} else {

	if (!isset($link2)) { $link2 = pg_pconnect("dbname=$psqldb user=$psqluser password='$psqlpass' host=$psqlhost"); }

	# get total pool hashrate
	$sql = "select to_timestamp((date_part('epoch', (time))::integer / 675::integer)::integer * 675::integer)-'3 hours'::interval as stime from $psqlschema.stats_shareagg where server=$serverid group by server,time order by time desc limit 1";
	$result = pg_exec($link, $sql); $row = pg_fetch_array($result, 0);
	$stime = $row["stime"];

	$sql = "select (sum(accepted_shares)*pow(2,32))/10800 as avghash from $psqlschema.stats_shareagg where server=$serverid and time > '$stime'::timestamp without time zone";
	$result = pg_exec($link, $sql); $row = pg_fetch_array($result, 0);
	$poolhashrate3hr = $row["avghash"];


	$sql = "select (sum(accepted_shares)*pow(2,32))/10800 as avghash, sum(accepted_shares) as sharecount, keyhash, min(users.id) as user_id from $psqlschema.stats_shareagg left join users on user_id=users.id where server=$serverid and time > '$stime'::timestamp without time zone and accepted_shares > 0 group by keyhash order by avghash desc $minilimit;";
	$result = pg_exec($link, $sql);
	$numrows = pg_numrows($result);


	$pdata = "<TABLE BORDER=1 class=\"contributors\">";

	$pdata .= "<TR class=\"contribhead\"><TD>Rank</TD><TD>Address</TD><TD>3-hr Avg Hashrate</TD><TD>3-hr Shares</TD><TD>Percentage of Pool</TD></TR>";

	$oe = 0;

	$rank = 1;

	for($ri = 0; $ri < $numrows; $ri++) {
		$row = pg_fetch_array($result, $ri);
		$phash = prettyHashrate($row["avghash"]);

		$tpercent = (($row["avghash"] / $poolhashrate3hr) * 100);
		$tpercent = round($tpercent,4);

		$user_id = $row["user_id"];


		if (isset($row['keyhash'])) {
	                $address =  \Bitcoin::hash160ToAddress(bits2hex($row['keyhash']));
			$nickname = get_nickname($link2,get_user_id_from_address($link2,$address));

			if (($nickname != "") && ($nickname != $address)) {
				$address = "<A HREF=\"userstats.php/$address\">$nickname<BR><FONT SIZE=\"-3\">($address)</FONT></A>";
			} else {
				$address = "<A HREF=\"userstats.php/$address\">$address</A>";
			}
		} else {
			$address = "(Unknown users)";
		}

		if ($oe == 1) { $oclass = "class=\"odd\""; $oe = 0; } else { $oclass = "class=\"notodd\""; $oe = 1; }

		$meshares = $row["sharecount"];

		$pdata .= "<TR HEIGHT=\"38\" $oclass><TD class=\"rank\">#$rank</TD><TD>$address</TD><TD class=\"hash\">$phash</TD><TD class=\"shares\">$meshares</TD><TD class=\"percent\">$tpercent%</TD></TR>";
		$rank++;
	}
	$pdata .= "</TABLE>";
	set_stats_cache($link, 20, $cachehash, $pdata, 675);
	print $pdata;
}


if (!isset($subcall)) {
	print_stats_bottom();
}

?>