<?php

    class accs {

        private $password;
        private $db;

        public function __construct() {
            $database = new database();
            $this->db = $database->db;
        }

        public function accsbase() {
            $stmt = $this->db->query("SELECT * FROM sk_cat ORDER BY `id`")->fetchAll(PDO::FETCH_ASSOC);
            return $stmt;
        }

        public function accbase($trade) {
            $stmt = $this->db->prepare("SELECT * FROM sk_cat WHERE cat = :cat ORDER BY `id`");
            $stmt->bindParam(':cat', $trade);
            $stmt->execute();
            $res = $stmt->fetchAll(PDO::FETCH_ASSOC);
            return $res;
        }

        public function accurl($url) {
            $stmt = $this->db->prepare("SELECT * FROM sk_cat WHERE url = :url ORDER BY `id`");
            $stmt->bindParam(':url', $url);
            $stmt->execute();
            $res = $stmt->fetchAll(PDO::FETCH_ASSOC);
            return $res;
        }

        public function takeacc($mail) {
            $stmt = $this->db->prepare("SELECT cat FROM sk_users WHERE email = :email");
            $stmt->bindParam(':email', $mail, PDO::PARAM_STR);
            $stmt->execute();
            $cat = $stmt->fetchColumn();
            $stmt = $this->db->prepare("SELECT * FROM sk_accs WHERE cat = :cat LIMIT 1");
            $stmt->bindParam(':cat', $cat, PDO::PARAM_STR);
            $stmt->execute();
            $res = $stmt->fetchAll(PDO::FETCH_ASSOC);
            $stmt = $this->db->prepare("DELETE FROM sk_accs WHERE cat = :cat LIMIT 1");
            $stmt->bindParam(':cat', $cat, PDO::PARAM_STR);
            $stmt->execute();

            $subject = 'Оплата аккаунта S-KEYS';
            $headers = 'From: support@skeys.ru' . "\r\n" .
                'Reply-To: support@skeys.ru' . "\r\n" .
                'X-Mailer: PHP/' . phpversion();

            mail($mail, $subject, "Вы произвели покупку аккаунта в магазине S-KEYS.RU.\nДанные от аккаунта:\n\nТип аккаунта: {$res[0]['cat']}\nЛогин: {$res[0]['login']}\nПароль: {$res[0]['pass']}", $headers);
        }

        public function takeacc2($mail) {
            $stmt = $this->db->prepare("SELECT pricesell FROM sk_users WHERE email = :email");
            $stmt->bindParam(':email', $mail, PDO::PARAM_STR);
            $stmt->execute();
            $cat = $stmt->fetchColumn();
            return $cat;
        }

        public function whyacc($cat) {
            $stmt = $this->db->prepare("SELECT * FROM sk_accs WHERE cat = :cat");
            $stmt->bindParam(':cat', $cat, PDO::PARAM_STR);
            $stmt->execute();
            $cat = $stmt->fetchAll(PDO::FETCH_ASSOC);
            if(empty($cat)) {
                return 'NO';
            } else{
                return 'YES';
            }
        }

        public function accfor($trade) {
            $newsmass = $this->accbase($trade);
            $newar = array();
            $copy_block = file_get_contents('style/acc.tpl');
            foreach ($newsmass as $acc) {
                $str = $copy_block;
                $str = str_replace('{img}',$acc['img'],$str);
                $str = str_replace('{name}',$acc['name'],$str);
                $str = str_replace('{price}',$acc['price'],$str);
                $str = str_replace('{url}',$acc['url'],$str);
                $newar[] = $str;
            }
            return $newar;
        }

        public function accsfor() {
            $newsmass = $this->accsbase();
            $newar = array();
            $copy_block = file_get_contents('style/acc.tpl');
            foreach ($newsmass as $acc) {
                $str = $copy_block;
                $str = str_replace('{img}',$acc['img'],$str);
                $str = str_replace('{name}',$acc['name'],$str);
                $str = str_replace('{price}',$acc['price'],$str);
                $str = str_replace('{url}',$acc['url'],$str);
                $newar[] = $str;
            }
            return $newar;
        }

        public function fullacc($url) {
            $newsmass = $this->accurl($url);
            $newar = array();
            $copy_block = file_get_contents('style/fullacc.tpl');
            foreach ($newsmass as $acc) {
                $str = $copy_block;
                $str = str_replace('{img}',$acc['img'],$str);
                $str = str_replace('{price}',$acc['price'],$str);
                $str = str_replace('{desc}',$acc['descr'],$str);
                $newar[] = $str;
            }

            if(empty($newar)) {
                return 'NO';
            } else{
                return $newar;
            }

        }


                //oplata
        public function oplata($email, $cat, $pricesell) {
            $stmt = $this->db->prepare("SELECT email FROM sk_users WHERE email = :email");
            $stmt->bindParam(':email', $email, PDO::PARAM_STR);
            $stmt->execute();
            $res = $stmt->fetchAll(PDO::FETCH_ASSOC);
            if(empty($res)) {
                $stmt = $this->db->prepare("INSERT INTO sk_users (email, cat, pricesell) VALUES (:email, :cat, :pricesell)");
                $stmt->bindParam(':email', $email, PDO::PARAM_STR);
                $stmt->bindParam(':cat', $cat, PDO::PARAM_STR);
                $stmt->bindParam(':pricesell', $pricesell, PDO::PARAM_STR);
                $stmt->execute();
            } else{
                $stmt = $this->db->prepare("UPDATE sk_users SET cat = :cat, pricesell = :pricesell WHERE email = :email");
                $stmt->bindParam(':email', $email, PDO::PARAM_STR);
                $stmt->bindParam(':cat', $cat, PDO::PARAM_STR);
                $stmt->bindParam(':pricesell', $pricesell, PDO::PARAM_STR);
                $stmt->execute();
            }
        }


    }
?>