<?php
/**
*
* @ This file is created by http://DeZender.Net
* @ deZender (PHP7 Decoder for ionCube Encoder)
*
* @ Version			:	4.1.0.1
* @ Author			:	DeZender
* @ Release on		:	29.08.2020
* @ Official site	:	http://DeZender.Net
*
*/

class DB
{
	protected $db;

	private function init()
	{
		$db = new PDO('mysql:host=' . $GLOBALS['host'] . ';dbname=' . $GLOBALS['select_db'] . ';charset=utf8mb4', $GLOBALS['login_db'], $GLOBALS['pass_db'], [PDO::MYSQL_ATTR_INIT_COMMAND => 'SET sql_mode = \'NO_ENGINE_SUBSTITUTION\'', PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION]);
		return $db;
	}

	protected function data($query)
	{
		$query = $this->db->query($query);
		$result = [];

		while ($row = mysqli_fetch_assoc($query)) {
			$result[] = $row;
		}

		return $result;
	}

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

class Model extends DB
{
	protected $db;

	public function login($login, $hash)
	{
		$query = 'SELECT id FROM users WHERE login=:login AND hash=:hash';
		$stmt = $this->db->prepare($query);
		$stmt->execute([__FUNCTION__ => $login, 'hash' => $hash]);
		$data = $stmt->fetchAll(PDO::FETCH_ASSOC);
		return $data;
	}

	public function category_digiseller($type, $in_stock)
	{
		$query = 'SELECT * FROM category_digiseller WHERE type = :type ';

		if (!empty($in_stock)) {
			$query .= 'AND in_stock = 1 ';
		}

		$query .= 'ORDER BY sort';
		$stmt = $this->db->prepare($query);
		$stmt->execute(['type' => $type]);
		$data = $stmt->fetchAll(PDO::FETCH_ASSOC);
		return $data;
	}

	public function category_digiseller_sort()
	{
		$query = 'SELECT * FROM category_digiseller ORDER BY sort';
		$stmt = $this->db->query($query);
		$data = $stmt->fetchAll(PDO::FETCH_ASSOC);
		return $data;
	}

	public function category_digiseller_id($id)
	{
		$query = 'SELECT * FROM category_digiseller WHERE id = :id';
		$stmt = $this->db->prepare($query);
		$stmt->execute(['id' => $id]);
		$data = $stmt->fetchAll(PDO::FETCH_ASSOC);
		return $data;
	}

	public function show_edit_category($id)
	{
		$query = 'SELECT * FROM category_digiseller WHERE id = :id';
		$stmt = $this->db->prepare($query);
		$stmt->execute(['id' => $id]);
..................................................................
.....................................
................