Topic: [GP] GoldPieces - An expandable digital currency for online multiplayer gaming - page 47. (Read 131317 times)

$wallet=new jsonRPCClient($driver_login);


$transactions = $wallet->listtransactions('',256);
/* go through each of these 256 transactions we got from the wallet */
foreach($transactions as $tx){
	if ($tx['category']=='receive')
	{
		$amount = $tx['amount'];
		$txid = $tx['txid'];
		$confirmations = $tx['confirmations'];
		$address=$tx['address'];
		
		$ssql=mysql_query("SELECT * FROM `bank_deposits` WHERE txid='$txid'");
		if (mysql_num_rows($ssql)<1){
			/* this does not exist in the banks archive, we must create it */
			mysql_query("INSERT INTO `bank_deposits` (`amount`,`txid`,`confirmations`,`address`) VALUES ('$amount','$txid','$confirmations','$address')");
			
		} else {
			$deposit = mysql_fetch_array($ssql);
			/* check if it has more than 3 confirmations */
			if ($confirmations>2)
			{
				/* its in the database already and has enough confirmations,  has it been credited? */
				if ($deposit['credited']=='0')
				{
					/* it hasn't been credited yet! lets do it. */
					mysql_query("UPDATE  `bank_deposits` SET  `credited` =  '1' WHERE  `txid` ='$txid';");
					/* add to users balance */
					mysql_query("UPDATE `players` SET balance = balance+$amount WHERE `deposit_address`='$address';");
				} else {
					//it has been credited, so we're done here.
				}
			} else {
			
			/* not three confirmations yet, so update confirmations */
			
			mysql_query("UPDATE `bank_deposits` SET confirmations='$confirmations' WHERE `txid`='$txid'");
			
		}
	}
}
}
?>