Bitcoin Forum

sudo apt-get install php5-cli

universalChecklogin.php (1 hits)
	Line 27: 		$cookieValid		= $validateCookie->checkCookie($_COOKIE[$cookieName], $ip);

$cookieInfo = explode("-", $input);
			
			//Get "secret" from MySql database
				$getSecretQ	= mysql_query("SELECT `secret`, `pass`, `sessionTimeoutStamp` FROM `webUsers` WHERE `id` = ".$cookieInfo[0]." LIMIT 0,1");
				$getSecret	= mysql_fetch_object($getSecretQ);

/////////Update share counts
$sql ="select sum(id) as id, a.associatedUserId from ".
	  "(select count(s.id) as id, p.associatedUserId from shares s, pool_worker p WHERE p.username=s.username group by p.associatedUserId ".
	  "union ".
	  "select count(s.id) as id, p.associatedUserId from shares_history s, pool_worker p WHERE p.username=s.username group by p.associatedUserId) a group by associatedUserId";
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)) {
	mysql_query("UPDATE webUsers SET share_count=".$row["id"]." WHERE id=".$row["associatedUserId"]);
}

$sql ="select sum(id) as id, a.associatedUserId from ".
	  "(select count(s.id) as id, p.associatedUserId from shares s, pool_worker p WHERE p.username=s.username AND s.our_result='N' group by p.associatedUserId  ".
	  "union ".
	  "select count(s.id) as id, p.associatedUserId from shares_history s, pool_worker p WHERE p.username=s.username AND s.our_result='N' group by p.associatedUserId) a group by associatedUserId ";
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)) {
	mysql_query("UPDATE webUsers SET stale_share_count=".$row["id"]." WHERE id=".$row["associatedUserId"]);
}

$sql ="select sum(id) as id, a.associatedUserId from ".
	  "(select count(s.id) as id, p.associatedUserId from shares s, pool_worker p WHERE p.username=s.username AND s.our_result='Y' group by p.associatedUserId  ".
	  "union ".
	  "select count(s.id) as id, p.associatedUserId from shares_history s, pool_worker p WHERE p.username=s.username AND s.our_result='Y' AND s.counted=0 group by p.associatedUserId) a group by associatedUserId ";
$result = mysql_query($sql);
$totalsharesthisround = 0;
while ($row = mysql_fetch_array($result)) {
	mysql_query("UPDATE webUsers SET shares_this_round=".$row["id"]." WHERE id=".$row["associatedUserId"]);
	$totalsharesthisround += $row["id"];
}
mysql_query("UPDATE settings SET value='".$totalsharesthisround."' WHERE setting='currentroundshares'");

//Test registration information
$act = $_POST["act"];
if($act == "attemptRegister"){
	//Valid date all fields
	$username	= $_POST["user"];
	$pass		= $_POST["pass"];
	$rPass		= $_POST["pass2"];
	$email		= $_POST["email"];
	$email2		= $_POST["email2"];
	$authPin	= (int) $_POST["authPin"];

	$validRegister = 1;
//.....
		//Validate passwords
		if($pass != $rPass){
			if(strlen($pass) < 5){
				$validRegister = 0;
				$returnError .= " | Password is too short";
			}else{
				$validRegister = 0;
				$returnError .= " | Passwords do not match";
			}
		}
	//.....
	if($validRegister){
		//Add user to webUsers
		$emailAuthPin = genRandomString(10);
		$secret = genRandomString(10);
		connectToDb();
		mysql_query("INSERT INTO `xenland_pushpool`.`webUsers` (`admin`, `username`, `pass`, `email`, `emailAuthPin`, `secret`, `loggedIp`, `sessionTimeoutStamp`, `accountLocked`, `accountFailedAttempts`, `pin`) 
								VALUES ('0', '".$username."', [b]'".$pass."[/b]', '".$email."', '".$emailAuthPin."', '".$secret."', '0', '0', '0', '0', '".[b]hash("sha256", $authPin)[/b]."')");
		$goodMessage = "Successfully signed up! You must authorize your account by now logging into your email address of ".$email." and clicking the authorize link";
	}

//Encrypt settings
$salt = "836483jd7Dg6h5s92k"; 

<?php 

$req 		= "/var/www/req/";
$functions	= $req."requiredFunctions.php";	
include($functions);
	
/////////Update workers
connectToDb();

//Active in past 10 minutes
try {
	$sql ="SELECT sum(a.id) IS NOT NULL AS active, p.username FROM pool_worker p LEFT JOIN ".
		  "(SELECT count(id) AS id, username FROM shares_history WHERE time > DATE_SUB(now(), INTERVAL 10 MINUTE) group by username ". 
		  "UNION ".
		  "SELECT count(id) AS id, username FROM shares_history WHERE time > DATE_SUB(now(), INTERVAL 10 MINUTE) group by username) a ON p.username=a.username group by username";
	$result = mysql_query($sql);
	while ($resultObj = mysql_fetch_object($result)) {
		mysql_query("UPDATE pool_worker p SET active=".$resultObj->active." WHERE username='".$resultObj->username."'");
	}
} catch (Exception $e) {}

<?php 

$req 		= "/var/www/req/";
$functions	= $req."requiredFunctions.php";	
include($functions);
	
/////////Update workers
connectToDb();

//Active in past 10 minutes
try {
	$sql ="SELECT sum(a.id) IS NOT NULL AS active, p.username FROM pool_worker p LEFT JOIN ".
		  "(SELECT count(id) AS id, username FROM shares WHERE time > DATE_SUB(now(), INTERVAL 10 MINUTE) group by username ". 
		  "UNION ".
		  "SELECT count(id) AS id, username FROM shares_history WHERE time > DATE_SUB(now(), INTERVAL 10 MINUTE) group by username) a ON p.username=a.username group by username";
	$result = mysql_query($sql);
	while ($resultObj = mysql_fetch_object($result)) {
		mysql_query("UPDATE pool_worker p SET active=".$resultObj->active." WHERE username='".$resultObj->username."'");
	}
} catch (Exception $e) {}

*/10 * * * * /home/miningsite/req/cronjob/blockUpdater.php
*/12 * * * * /home/miningsite/req/cronjob/blockFound.php

$:php blockUpdater.php 
PHP Deprecated:  Comments starting with '#' are deprecated in /etc/php5/cli/conf.d/mcrypt.ini on line 1 in Unknown on line 0
PHP Parse error:  syntax error, unexpected '{' in /home/miningsite/req/cronjob/blockUpdater.php on line 45

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

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

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"])."'";
										}

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')");

[20-Jun-2011 20:20:35] PHP Warning:  mktime() expects parameter 1 to be long, string given in /var/www/req/cronjob/statsUpdater.php on line 30
[20-Jun-2011 20:20:35] PHP Notice:  Undefined offset: 1 in /var/www/req/cronjob/statsUpdater.php on line 27
[20-Jun-2011 20:20:35] PHP Notice:  Undefined offset: 1 in /var/www/req/cronjob/statsUpdater.php on line 30
[20-Jun-2011 20:20:35] PHP Notice:  Undefined offset: 2 in /var/www/req/cronjob/statsUpdater.php on line 30
[20-Jun-2011 20:20:35] PHP Notice:  Undefined offset: 1 in /var/www/req/cronjob/statsUpdater.php on line 30
[20-Jun-2011 20:20:35] PHP Notice:  Undefined offset: 2 in /var/www/req/cronjob/statsUpdater.php on line 30

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

$fiveMinutesAgo = time();
$fiveMinutesAgo -= 60*5;

SELECT `id` FROM `stats_userMhashes` WHERE `timestamp` >= $fiveMinutesAgo AND `mhashes` > 0

$fiveMinutesAgo = time()-60*5;

ul#list-nav li {
	      display:inline
	}

		//Get estimated earnings
			$estReward = 0;
			if($totalPoolShares > 0 && $totalShares > 0){
				$estReward = $totalPoolShares/$totalShares;
			}

		//Get estimated earnings
			$estReward = 0;
			if($totalPoolShares > 0 && $totalShares > 0){
				$estReward = $totalShares/$totalPoolShares;
			}

	if(isSet($getCredentials->sendAddress)){
													echo $getCredientials->sendAddress;
												}else{

							//Does this accountbalance meet the `cashoutMinimum`
								$accountBalance = $getCredientials->accountBalance;
								$cashOutAddress = $getCredientials->sendAddress;
								$userId		= $getCredientials->userId;
								$cashOutMin	= getCashoutMin();
								echo $cashOutAddress;
								

{
        "account" : "",
        "category" : "orphan",
        "amount" : 50.25293224,
        "confirmations" : 0,
        "txid" : "790c5494c0a26a520c3cffc0dae536173bedfd4ef512b65db9bbf5613d68f0bb",
        "time" : 1309191321
    }
]

mail($to, $subject, $message, $headers);

mail($to, $subject, $message);

[error] [client xx] PHP Fatal error:  Uncaught BitcoinClientException: [0]: sendtoaddress requires a destination address\n\n  thrown in  on line 0, referer: http://xx.com/accountDetails.php

Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /var/www/req/functions.php on line 262

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /var/www/stats.php on line 83

Warning: fopen(http://mtgox.com/code/data/ticker.php) [function.fopen]: failed to open stream: HTTP request failed! in /var/www/req/cronjob/blockUpdater.php on line 81

Warning: fread() expects parameter 1 to be resource, boolean given in /var/www/req/cronjob/blockUpdater.php on line 82

Warning: fclose() expects parameter 1 to be resource, boolean given in /var/www/req/cronjob/blockUpdater.php on line 83