<?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);
if(isset($_GET['snuid'])) {
    $currency = $_GET['currency'];
    $network = "tapjoy";
    $snuid = $_GET['snuid'];
    $addCallback->addCallback($network, $currency, $snuid);
    echo "200 OK";
    echo "<endora>";
}
else
{
    echo "ERROR";
}


?>