<?php

require dirname(__FILE__) . '/includes/bootstrap.php';
$classPublisherAd = new BuckysPublisherAds();
$bannerHTML = $classPublisherAd->renderAd($_GET['ad']);
?>
    <!DOCTYPE html>
    <html lang="en">
    <head>
        <style type="text/css">
            *{
                margin: 0;
                padding: 0;
                color: #333333;
                font-family: Arial, Helvetica, sans-serif;
                font-size: 12px;
            }

            /*** publisher.css Starts Here ***/
            .buckysroom-ad-banner table{
                border: solid 1px #006699;
            }

            .buckysroom-ad-banner td{
                padding: 0;
            }

            .buckysroom-ad{
                padding: 0 8px;
                white-space: -moz-pre-wrap !important;
                white-space: -pre-wrap;
function render_forum_ad($userID)
{
    global $db;
    $publisherAdClass = new BuckysPublisherAds();
    //Getting Ad Token
    $query = $db->prepare("SELECT token FROM " . TABLE_PUBLISHER_ADS . " WHERE publisherID=%d AND adType=%d", $userID, TNB_AD_TYPE_FORUM);
    $token = $db->getVar($query);
    echo $publisherAdClass->renderAd($token);
}
 /**
  * @param $email
  * @param $token
  * @return bool
  */
 public static function verifyAccount($email, $token)
 {
     global $db;
     $query = $db->prepare("SELECT userID FROM " . TABLE_USERS . " WHERE token=%s AND email=%s AND STATUS=0", $token, $email);
     $userID = $db->getVar($query);
     if (!$userID) {
         buckys_add_message(MSG_INVALID_TOKEN, MSG_TYPE_ERROR);
         return false;
     }
     //Verify links
     $query = $db->prepare("UPDATE " . TABLE_USERS . " SET status=1, token='' WHERE userID=%d", $userID);
     $db->query($query);
     buckys_add_message(MSG_ACCOUNT_VERIFIED, MSG_TYPE_SUCCESS);
     //Make this user to friend with bucky
     $query = $db->prepare("SELECT userID FROM " . TABLE_USERS . " WHERE email=%s", TNB_ADMIN_EMAIL);
     $buckysID = $db->getVar($query);
     //$buckysID = $db->getVar("Select userID FROM " . TABLE_USERS . " WHERE email='*****@*****.**'");
     $db->insertFromArray(TABLE_FRIENDS, ['userID' => $buckysID, 'userFriendID' => $userID, 'status' => '1']);
     $db->insertFromArray(TABLE_FRIENDS, ['userID' => $userID, 'userFriendID' => $buckysID, 'status' => '1']);
     //Create Bitcoin account
     BuckysBitcoin::createWallet($userID, $email);
     //Create Default Ads for the users
     $classPublisherAds = new BuckysPublisherAds();
     $classPublisherAds->createDefaultPublisherAds($userID);
     return true;
 }
<?php

require dirname(dirname(__FILE__)) . '/includes/bootstrap.php';
//Getting Current User ID
if (!buckys_check_user_acl(USER_ACL_REGISTERED)) {
    buckys_redirect('/index.php', MSG_PERMISSION_DENIED, MSG_TYPE_ERROR);
}
$userID = buckys_is_logged_in();
$classPublisherAd = new BuckysPublisherAds();
buckys_enqueue_stylesheet('publisher.css');
$adID = buckys_escape_query_integer($_GET['id']);
$adDetail = $classPublisherAd->getAdById($adID);
if (!$adDetail || $adDetail['publisherID'] != $userID && buckys_check_user_acl(USER_ACL_MODERATOR)) {
    buckys_redirect('/ads/publisher.php', MSG_INVALID_REQUEST, MSG_TYPE_ERROR);
}
$classAds = new BuckysAds();
$sizeDetail = $classAds->getAdSizeById($adDetail['size']);
$TNB_GLOBALS['headerType'] = "ads";
$TNB_GLOBALS['content'] = "ads/publisher_ad_view";
$TNB_GLOBALS['title'] = "View Ad Details - thenewboston Ads";
require DIR_FS_TEMPLATE . $TNB_GLOBALS['template'] . "/" . $TNB_GLOBALS['layout'] . ".php";
<?php

require dirname(dirname(__FILE__)) . '/includes/bootstrap.php';
//Getting Current User ID
if (!buckys_check_user_acl(USER_ACL_REGISTERED)) {
    buckys_redirect('/index.php', MSG_PERMISSION_DENIED, MSG_TYPE_ERROR);
}
$userID = buckys_is_logged_in();
$classPublisherAd = new BuckysPublisherAds();
if (isset($_POST['action']) && $_POST['action'] == 'create-publisher-ad') {
    if (!buckys_check_form_token()) {
        buckys_redirect('/ads/create_publisher_ad.php', MSG_INVALID_REQUEST, MSG_TYPE_ERROR);
    } else {
        $_POST['adType'] = TNB_AD_TYPE_CUSTOM;
        if ($classPublisherAd->savePublisherAd($userID, $_POST)) {
            buckys_redirect('/ads/publisher.php', $classPublisherAd->last_message);
        } else {
            buckys_redirect('/ads/create_publisher_ad.php', $classPublisherAd->last_message, MSG_TYPE_ERROR);
        }
    }
}
$classAds = new BuckysAds();
$adSizes = $classAds->getAdSizes();
buckys_enqueue_javascript('colorpicker.js');
buckys_enqueue_javascript('create_publisher_ads.js');
buckys_enqueue_stylesheet('colorpicker.css');
buckys_enqueue_stylesheet('publisher.css');
$TNB_GLOBALS['headerType'] = "ads";
$TNB_GLOBALS['content'] = "ads/create_publisher_ad";
$TNB_GLOBALS['title'] = "Create Publisher Ad - thenewboston Ads";
require DIR_FS_TEMPLATE . $TNB_GLOBALS['template'] . "/" . $TNB_GLOBALS['layout'] . ".php";
<?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']);