Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $host = 'localhost'; //Hostitel
- $db = 'freekeys'; //Nazev DB
- $user = 'FSK'; //Přihlašovací jméno
- $pass = 'Kokotik!1337'; //Přihlašovací heslo
- $charset = 'utf8';
- $dsn = "mysql:host=$host;dbname=$db;charset=$charset";
- $opt = [
- \PDO::ATTR_ERRMODE => \PDO::ERRMODE_EXCEPTION,
- \PDO::ATTR_DEFAULT_FETCH_MODE => \PDO::FETCH_ASSOC,
- \PDO::ATTR_EMULATE_PREPARES => false,
- ];
- $pdo = new \PDO($dsn, $user, $pass, $opt);
- /**
- *
- */
- class Callback
- {
- function __construct(\PDO $pdo)
- {
- $this->conn = $pdo;
- }
- public function addCallback($network, $currency, $snuid)
- {
- if(!$this->checksnuid($snuid))
- {
- $addCallback = $this->conn->prepare("INSERT INTO users (email, points, lastEvent, lastrewardDate) VALUES (:snuid, :currency, :network, NOW())");
- $addCallback->execute(array(
- 'snuid' => $snuid,
- 'currency' => $currency,
- "network" => $network
- ));
- //DEBUG
- if($addCallback)
- {
- echo ":OK";
- }
- }
- else
- {
- $this->update($network, $currency, $snuid);
- }
- }
- public function checksnuid($snuid)
- {
- $checksnuid = $this->conn->prepare("SELECT email FROM users WHERE email=:snuid");
- $checksnuid->execute(array(
- 'snuid' => $snuid
- ));
- $count = $checksnuid->rowCount();
- if($count > 0)
- {
- return true;
- }
- else
- {
- return false;
- }
- }
- public function update($network, $currency, $snuid)
- {
- $update = $this->conn->prepare("UPDATE users SET points = points + $currency, lastEvent=:network, lastrewardDate=NOW() WHERE email=:snuid");
- $update->execute(array(
- "network" => $network,
- 'snuid' => $snuid
- ));
- }
- }
- $addCallback = new Callback($pdo);
- $test = true;
- if($test) {
- $currency = $_GET['currency'];
- $network = "tapjoy";
- $snuid = $_GET['snuid'];
- $addCallback->addCallback($network, $currency, $snuid);
- echo "200 OK";
- echo "<endora>";
- }
- else
- {
- echo "ERROR";
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement