Topic: v5.6.0 ][ Open-Source Pooling Web Software ( MiningFarm ) - page 9. (Read 57276 times)

ALTER TABLE `stats_poolMHashHistory` ADD `totalMhash` INT( 50 ) NOT NULL 

//Get average Mhash for the entire pool
$poolAverageHashQ = mysql_query("SELECT `mhashes` FROM `stats_userMHashHistory` WHERE `mhashes` > 0 AND `timestamp` = '".$globalTime."'");
$numPoolHashRows = mysql_num_rows($poolAverageHashQ);
$averagePoolHash = 0;
while($poolHash = mysql_fetch_array($poolAverageHashQ)){
	$averagePoolHash += $poolHash["mhashes"];
}
if($averagePoolHash > 0 && $numPoolHashRows > 0){
	$averagePoolHash = $averagePoolHash/$numPoolHashRows;
}
//Add pool average to table
mysql_query("INSERT INTO `stats_poolMHashHistory` (`timestamp`, `averageMhash`)
						VALUES('$globalTime', '$averagePoolHash')");

//Get average and total Mhash for the entire pool
$poolAverageHashQ = mysql_query("SELECT `mhashes` FROM `stats_userMHashHistory` WHERE `mhashes` > 0 AND `timestamp` = '".$globalTime."'");
$numPoolHashRows = mysql_num_rows($poolAverageHashQ);
$averagePoolHash = 0;
$totalPoolHash = 0;
while($poolHash = mysql_fetch_array($poolAverageHashQ)){
	$averagePoolHash += $poolHash["mhashes"];
	$totalPoolHash += $poolHash["mhashes"];
}
if($averagePoolHash > 0 && $numPoolHashRows > 0){
	$averagePoolHash = $averagePoolHash/$numPoolHashRows;
}
//Add pool average and total to table
mysql_query("INSERT INTO `stats_poolMHashHistory` (`timestamp`, `averageMhash`, `totalMhash`)
						VALUES('$globalTime', '$averagePoolHash', '$totalPoolHash')");

else if($numRows == 0){
									$i=0;
									//Go through the pool history and display that
										$poolHistory = mysql_query("SELECT `averageMhash`, `timestamp` FROM `stats_poolMHashHistory` WHERE `timestamp` >= '".$fiveMinutesAgo."' ORDER BY `timestamp` DESC");
										while($poolHash = mysql_fetch_array($poolHistory)){
											if($i > 0){
												$poolHashArray .=",";
												$timeHashArray .=",";
											}
											$i++;
											$poolHashArray .= $poolHash["averageMhash"];
											$timeHashArray .= "'".date("G:i:s", $time["timestamp"])."'";
										}

else if($numRows == 0){
									$i=0;
									//Go through the pool history and display that
										$poolHistory = mysql_query("SELECT `averageMhash`, `timestamp` FROM `stats_poolMHashHistory` WHERE `timestamp` >= '".$fiveMinutesAgo."' ORDER BY `timestamp` DESC");
										while($poolHash = mysql_fetch_array($poolHistory)){
											if($i > 0){
												$poolHashArray .=",";
												$timeHashArray .=",";
											}
											$i++;
											$poolHashArray .= $poolHash["averageMhash"];
											$timeHashArray .= "'".date("G:i:s", $poolHash["timestamp"])."'";
										}

//Bitcoind RPC information
$rpcType	= "http";
$rpcUsername	= "bitcoins";
$rpcPassword 	= "lolsalad";
$rpcHost	= "127.0.0.1";

$getRoundSharesQ = msyql_query("SELECT `id FROM `shares_history` WHERE `blockNumber` = '".$block["blockNumber"]."' AND `username` = '$username.%' AND `our_result` != 'N'");