/** * Reject Ads * * @param mixed $id * @return bool */ public function rejectAds($id) { global $db; if (!is_array($id)) { $id = [$id]; } $bitcoinClass = new BuckysBitcoin(); foreach ($id as $ad_id) { $query = $db->prepare("UPDATE " . TABLE_ADS . " SET `status`=" . TNB_AD_STATUS_REJECTED . " WHERE id=%d", $ad_id); $db->query($query); //Return Bitcoin $query = $db->prepare("SELECT b.bitcoin_address, a.budget FROM " . TABLE_ADS . " AS a LEFT JOIN " . TABLE_USERS_BITCOIN . " AS b ON a.ownerID=b.userID WHERE a.id=%d", $ad_id); $info = $db->getRow($query); $bitcoinClass->sendBitcoinFromBuckysroom($info['bitcoin_address'], $info['budget'] - BLOCKCHAIN_FEE); } return true; }
<?php require dirname(dirname(__FILE__)) . '/includes/bootstrap.php'; //Getting Publisher Ads $query = "SELECT pa.*, b.bitcoin_address FROM " . TABLE_PUBLISHER_ADS . " AS pa LEFT JOIN " . TABLE_USERS_BITCOIN . " AS b ON b.userID=pa.publisherID WHERE pa.impressions > pa.paidImpressions"; $results = $db->getResultsArray($query); $bitcoinClass = new BuckysBitcoin(); $classPublisherAds = new BuckysPublisherAds(); //$price_per_impression = ADS_PRICE_FOR_THOUSAND_IMPRESSIONS * ADS_PUBLISHER_PERCENTAGE / 1000; foreach ($results as $row) { $userBalance = $classPublisherAds->getUserBalance($row['publisherID']); if ($userBalance >= ADS_MINIMUM_PAYOUT_BALANCE) { $amountToSend = $userBalance - BLOCKCHAIN_FEE; $paymentSend = $bitcoinClass->sendBitcoinFromBuckysroom($row['bitcoin_address'], $amountToSend); if ($paymentSend) { $db->update("UPDATE " . TABLE_PUBLISHER_ADS . " SET `paidImpressions`=`impressions` WHERE publisherID=" . $row['publisherID']); } } /* $unpaidImpressions = $row['impressions'] - $row['paidImpressions']; //0.00036 for every 1000 impressions $amount = $unpaidImpressions * $price_per_impression; if($amount < ADS_MINIMUM_PAYOUT_BALANCE) continue; $amount = $amount - BLOCKCHAIN_FEE; $bitcoinClass->sendBitcoinFromBuckysroom($row['bitcoin_address'], $amount); //Update PaidImpressions $db->update("UPDATE " . TABLE_PUBLISHER_ADS . " SET `paidImpressions`=`impressions`, `earnings` = `earnings` + " . $amount . " WHERE id=" . $row['id']);