$refAmount = $amount * ($settings["referral_percentage"] / 100); $response = pay($ref, $refAmount, "Referral earnings from XXX, payed through Xapo!"); if (!$response->success) { $success = 0; } else { $success = 1; } $q = $sql->prepare("INSERT into data_referals (user, referrer, amount, date, result, message) values (?,?,?,now(),?,?)"); $q->execute(array($ref, $username, $refAmount, $success, $response->message)); } } else { $view['main']['result_html'] = '<div class="row text-center"><div class="col-sm-6 col-md-offset-3 bg-danger"><p>' . $response->message . '</p></div></div>'; $message = $response->message; goto error; } } else { $waitingTime = $row['claimed_at'] + $settings['timer'] * 60 - $time; if ($waitingTime > 0) { $waitingTime = format_timer($waitingTime); } $view['main']['result_html'] = '<div class="row text-center"><div class="col-sm-6 col-md-offset-3 bg-danger"><p>You can get a reward again in ' . htmlspecialchars($waitingTime) . '.</p></div></div>'; $message = "Time!!"; goto error; } error: require 'style/template/index.php'; exit; } else { require 'style/template/index.php'; exit; }
function shortcode_handler() { global $wpdb; $settings = array(); $time = time(); $myHashKey = "8c278cfb4784588efd29effc613e5983"; $settings = get_option('wedevs_basics'); $GLOBALS["settings"] = $settings; $GLOBALS['hashKey'] = $myHashKey; $rewards = get_rewards(); if (isset($_POST['xapoform']) && $_POST['xapoform'] == "posted") { $view['main']['result_html'] = ''; $view['main']['waiting_time'] = 0; $success = "false"; $ip = get_ip(); //Checks that the username is not empty if (!isset($_POST['username']) || $_POST['username'] == "") { $view['main']['result_html'] = '<div class="row text-center"><div class="col-sm-6 col-md-offset-3 bg-danger"><p>Missing email address!</p></div></div>'; $message = "Missing email address"; goto b; } $username = $_POST['username']; //Checks if the user has written something in the captcha box $captchaChallange = $_POST['adcopy_challenge']; $captchaResponse = $_POST['adcopy_response']; if (empty($captchaChallange) || empty($captchaResponse)) { $view['main']['result_html'] = '<div class="row text-center"><div class="col-sm-6 col-md-offset-3 bg-danger"><p>Missing captcha, try again!</p></div></div>'; $message = "Missing captcha"; goto b; } $response = @file('http://verify.solvemedia.com/papi/verify?privatekey=' . $settings['solvemedia_verification_key'] . '&challenge=' . rawurlencode($captchaChallange) . '&response=' . rawurlencode($captchaResponse) . '&remoteip=' . $ip); if (!isset($response[0]) || trim($response[0]) === 'false') { $view['main']['result_html'] = '<div class="row text-center"><div class="col-sm-6 col-md-offset-3 bg-danger"><p>Wrong captcha!</p></div></div>'; $message = "Wrong captcha"; goto b; } /* $q = $sql->prepare("select * from wp_xf_users where LOWER(username) = LOWER(?) or ip = ? order by claimed_at desc"); $q->execute(array($username,$ip)); $row = $q->fetch();*/ // wordpress version starts $row = $wpdb->query($wpdb->prepare("\n\t\tselect * from wp_xf_users where LOWER(username) = LOWER(%s) or ip = %s order by claimed_at desc\n\t", array($username, $ip))); // wordpress version ends //timer check if ($row === null || $row['claimed_at'] <= $time - $settings['timer'] * 60) { $amount = intval($rewards['random_reward']); $response = pay($username, $amount, "Earnings from XXX, payed through Xapo!"); echo "<pre>"; echo $username; echo $amount; print_r($response); echo "</pre>"; try { $message = $response->message; if (!$response->success) { $success = 0; } else { $success = 1; } /* $q = $sql->prepare("INSERT into wp_xf_data (user, amount, date, result, message) values (?, ?, CURRENT_TIMESTAMP, ?, ?)"); $q->execute(array($username,$amount,$success,$message)); */ // Wordpress Version Starts $wpdb->query($wpdb->prepare("\nINSERT into wp_xf_data (user, amount, date, result, message) values (%s, %d, CURRENT_TIMESTAMP, %s, %s)\t", array($username, $amount, $success, $message))); // Wordpress Version Ends } catch (Exception $e) { goto b; } if ($response->success) { $view['main']['result_html'] = '<div class="row text-center"><div class="col-sm-6 col-md-offset-3 bg-success"><p>Congratulations you have won ' . $amount . ' Satoshis !!!</p></div></div>'; $url = get_main_url() . "?r=" . $username; $view['main']['ref_link'] = '<div class="row text-center"><div class="col-sm-6 col-md-offset-3 bg-success"><p>Share your referal link and earn a ' . $settings["referral_percentage"] . '% lifetime bonus. Your referal link is ' . $url . '</p></div></div>'; /* $q = $sql->prepare("INSERT into wp_xf_users (username, ip, claimed_at) values (?,?,?) on duplicate key update ip = values(ip), claimed_at = values(claimed_at)"); $q->execute(array($username, $ip, $time));*/ // Wordpress Version Starts $wpdb->query($wpdb->prepare("\nINSERT into wp_xf_users (username, ip, claimed_at) values (%s,%s,%s) on duplicate key update ip = values(ip), claimed_at = values(claimed_at)", array($username, $ip, $time))); // Wordpress Version Ends /* $q = $sql->prepare("Select * from wp_xf_referals where username=?"); $q->execute(array($username)); $row = $q->fetch();*/ // Wordpress Version Starts $row = $wpdb->get_results("\nSelect * from wp_xf_referals where username='******'"); // Wordpress Version Ends $ref = null; if (!$row) { //new user $ref = $_GET["r"]; /* $q = $sql->prepare("INSERT into wp_xf_referals(username,reffered_by) Values(?,?)"); $q->execute(array($username,$ref)); */ // Wordpress Version Starts $wpdb->query($wpdb->prepare("\nINSERT into wp_xf_referals(username,reffered_by) Values(%s,%s)\n", array($username, $ref))); // Wordpress Version Ends } else { $ref = $row[0]->reffered_by; } if (!is_null($ref)) { $refAmount = $amount * ($settings["referral_percentage"] / 100); $response = pay($ref, $refAmount, "Referral earnings from XXX, payed through Xapo!"); if (!$response->success) { $success = 0; } else { $success = 1; } /* $q = $sql->prepare("INSERT into wp_xf_data_referals (user, referrer, amount, date, result, message) values (?,?,?,now(),?,?)"); $q->execute(array($ref, $username, $refAmount, $success, $response->message)); */ // Wordpress Version Starts $wpdb->query($wpdb->prepare("\nINSERT into wp_xf_data_referals (user, referrer, amount, date, result, message) values (%s,%s,%d,now(),%s,%s)", array($ref, $username, $refAmount, $success, $response->message))); // Wordpress Version Ends } } else { $view['main']['result_html'] = '<div class="row text-center"><div class="col-sm-6 col-md-offset-3 bg-danger"><p>' . $response->message . '</p></div></div>'; $message = $response->message; goto b; } } else { $waitingTime = $row['claimed_at'] + $settings['timer'] * 60 - $time; if ($waitingTime > 0) { $waitingTime = format_timer($waitingTime); } $view['main']['result_html'] = '<div class="row text-center"><div class="col-sm-6 col-md-offset-3 bg-danger"><p>You can get a reward again in ' . htmlspecialchars($waitingTime) . '.</p></div></div>'; $message = "Time!!"; goto b; } } //Form on front end Starts b: ?> <div><strong><p class="alert alert-info">Your possible rewards <?php echo $rewards["reward_list_html"]; ?> </p></strong></div> <div> <strong><p>Earning bitcoins is simple:</p></strong> </div> <?php echo $view['main']['result_html']; ?> <?php echo $view['main']['ref_link']; ?> <form method="Post"> <input type="hidden" name="xapoform" value="posted" /> <div > <div><label>Insert your email or BTC address:</label> <input name="username" id="username" class="form-control text-center" type="text" placeholder="Enter your email or BTC address"></div> </div><br> <div> <div class="form-group"><label>Solve the captcha:</label> <center class="captcha"><script type="text/javascript" src="http://api.solvemedia.com/papi/challenge.script?k=<?php echo $settings['solvemedia_challenge_key']; ?> "></script></center></div> </div> <div> <div> <button class="btn btn-success" type="submit">Claim Prize</button> </div> </div> </form> <?php //Form on front end Ends }