File manager

File manager - Edit - /home/newsbmcs.com/public_html/static/img/logo/Category.php.tar

Back
home/newsbmcs.com/public_html/play1/classes/Category.php��0000644��00000026633�15027264752�0017371 0��ustar�00��<?php /** * Class to handle game categories / class Category { public $id = null; public $name = null; public $slug = null; public $priority = 0; public $description = ""; public $meta_description = ""; public $fields = ""; public $extra_fields = null; public function __construct($data = array()) { if (isset($data['id'])) $this->id = (int)$data['id']; if (isset($data['name'])) $this->name = $data['name']; if (isset($data['description'])) $this->description = $data['description']; if (isset($data['meta_description'])) $this->meta_description = $data['meta_description']; if (isset($data['fields'])) $this->fields = $data['fields']; if (isset($data['priority'])) $this->priority = (int)$data['priority']; if ( isset( $data['slug'] ) ) { $this->slug = strtolower(str_replace(' ', '-', str_replace('.', '', $data["slug"]))); } else { if ( isset( $data['name'] ) ) $this->slug = strtolower(str_replace(' ', '-', $data["name"])); } if(isset($data['extra_fields'])){ if(is_array($data['extra_fields'])){ $data['extra_fields'] = json_encode($data['extra_fields']); } $this->extra_fields = $data['extra_fields']; } if($this->priority > 10000){ // Fix possible bug $this->priority = 10000; } if($this->priority < -100){ // Fix possible bug $this->priority = -100; } } public function storeFormValues($params) { $this->__construct($params); } public static function getById($id) { $conn = open_connection(); $sql = "SELECT FROM categories WHERE id = :id"; $st = $conn->prepare($sql); $st->bindValue(":id", $id, PDO::PARAM_INT); $st->execute(); $row = $st->fetch(); if ($row) return new Category($row); } public static function getBySlug($slug) { $conn = open_connection(); $sql = "SELECT * FROM categories WHERE slug = :slug LIMIT 1"; $st = $conn->prepare($sql); $st->bindValue(":slug", $slug, PDO::PARAM_STR); $st->execute(); $row = $st->fetch(); if ($row) return new Category($row); } public static function getByName($name) { $conn = open_connection(); $sql = "SELECT * FROM categories WHERE name = :name LIMIT 1"; $st = $conn->prepare($sql); $st->bindValue(":name", $name, PDO::PARAM_STR); $st->execute(); $row = $st->fetch(); if ($row) return new Category($row); } public static function getIdByName($name) { $conn = open_connection(); $sql = "SELECT * FROM categories WHERE name = :name LIMIT 1"; $st = $conn->prepare($sql); $st->bindValue(":name", $name, PDO::PARAM_STR); $st->execute(); $row = $st->fetch(); if($row){ return $row['id']; } else { return null; } } public static function getIdBySlug($slug) { $conn = open_connection(); $sql = "SELECT * FROM categories WHERE slug = :slug limit 1"; $st = $conn->prepare($sql); $st->bindValue(":slug", $slug, PDO::PARAM_STR); $st->execute(); $row = $st->fetch(); if( $row ) { return $row['id']; } else { return null; } } public static function getList($numRows = 1000) { $conn = open_connection(); $sql = "SELECT * FROM categories ORDER BY priority DESC, name ASC LIMIT :numRows"; $st = $conn->prepare($sql); $st->bindValue(":numRows", $numRows, PDO::PARAM_INT); $st->execute(); $list = array(); while ($row = $st->fetch()) { $category = new Category($row); $list[] = $category; } $totalRows = $conn->query('SELECT count() FROM categories')->fetchColumn(); return (array( "results" => $list, "totalRows" => $totalRows )); } public static function getCategoryCount($id) { $conn = open_connection(); $sql = "SELECT count() FROM cat_links WHERE categoryid = :id"; $st = $conn->prepare($sql); $st->bindValue(":id", $id, PDO::PARAM_INT); $st->execute(); $totalRows = $st->fetchColumn(); return $totalRows; } public static function getListByCategory($id, int $amount, int $page = 0) { $additional_condition = ''; if(defined('IS_VISITOR_PAGE')){ if(get_setting_value('hide_pc_on_mobile') && is_mobile_device()){ $additional_condition = 'AND games.is_mobile = 1'; } } $id = (int)$id; // Get only published games. $sql = "SELECT games.id FROM games JOIN cat_links ON games.id = cat_links.gameid WHERE cat_links.categoryid = $id AND games.published = 1 $additional_condition ORDER BY cat_links.id DESC LIMIT $amount OFFSET $page"; $cached_result = null; if(is_cached_query_allowed()){ $data_value = get_cached_query($sql); if(!is_null($data_value)){ $cached_result = json_decode($data_value, true); } } $conn = open_connection(); $rows; if(!$cached_result){ $st = $conn->prepare($sql); $st->execute(); $rows = $st->fetchAll(); if(is_cached_query_allowed()){ set_cached_query($sql, json_encode($rows)); } } else { $rows = $cached_result; } $list = array(); foreach ($rows as $item) { $game = new Game; $res = $game->getById($item['id']); array_push($list, $res); } // Count only published games. $sql = "SELECT COUNT() FROM games JOIN cat_links ON games.id = cat_links.gameid WHERE cat_links.categoryid = $id AND games.published = 1 $additional_condition"; $cached_result2 = null; if(is_cached_query_allowed()){ $data_value = get_cached_query($sql); if(!is_null($data_value)){ $cached_result2 = json_decode($data_value, true); } } $totalRows = null; if(is_null($cached_result2)){ $st = $conn->prepare($sql); $st->execute(); $totalRows = $st->fetchColumn(); if(is_cached_query_allowed()){ set_cached_query($sql, json_encode($totalRows)); } } else { $totalRows = $cached_result2; } return (array( "results" => $list, "totalRows" => $totalRows, "totalPages" => ceil($totalRows / $amount) )); } public static function getListByCategories($ids, int $amount, int $page = 0, $random = true){ // Deprecated since v1.8.7 (Previously used for similar games), replaced with Game::fetchSimilarGames() for better performance $conn = open_connection(); $random_order = ''; if ($random) { $random_order = ' ORDER BY rand()'; } $sql = "SELECT cl1. FROM `cat_links` as cl1 ,( SELECT DISTINCT `gameid`,`categoryid` FROM `cat_links`"; if ($ids) { $sql .= " WHERE `categoryid` IN (" . implode(',', $ids) . ")"; } $sql .= $random_order . " LIMIT $amount OFFSET $page ) as cl2 WHERE cl2.gameid = cl1.gameid"; $st = $conn->prepare($sql); $st->execute(); $rows = $st->fetchAll(); $list = array(); $gameIds = []; foreach ($rows as $row) { if (count($gameIds) > $amount) { break; } if (!in_array($row['gameid'], $gameIds)) { $gameIds[] = $row['gameid']; } } $is_only_mobile = false; if(defined('IS_VISITOR_PAGE')){ if(get_setting_value('hide_pc_on_mobile') && is_mobile_device()){ $is_only_mobile = true; } } foreach ($gameIds as $gameId) { if (count($list) < $amount) { $game = new Game; $res = $game->getById($gameId); if ($res && $res->published) { if($is_only_mobile && $res->is_mobile){ array_push($list, $res); } if(!$is_only_mobile){ array_push($list, $res); } } } else { break; } } return array( "results" => $list, "totalRows" => count($list), "totalPages" => 1 ); } public function addToCategory($gameID, $catID) { $conn = open_connection(); $sql = "INSERT INTO cat_links ( gameid, categoryid ) VALUES ( :gameID, :catID )"; $st = $conn->prepare($sql); $st->bindValue(":gameID", $gameID, PDO::PARAM_INT); $st->bindValue(":catID", $catID, PDO::PARAM_INT); $st->execute(); $this->id = $conn->lastInsertId(); } public function isCategoryExist($name) { $conn = open_connection(); $sql = 'SELECT * FROM categories WHERE name = :name limit 1'; $st = $conn->prepare($sql); $st->bindValue(":name", $name, PDO::PARAM_STR); $st->execute(); $row = $st->fetch(); if ($row) { $this->id = $row['id']; } if ($row) { return true; } else { return false; } } public function getExtraField($key) { if($this->extra_fields != null){ $fields = json_decode($this->extra_fields, true); if(isset($fields[$key])){ return $fields[$key]; } } return null; } public function get_fields() { if($this->fields != ''){ return json_decode($this->fields, true); } else { return null; } } public function get_field($key) { if($this->fields != ''){ $fields = json_decode($this->fields, true); if(isset($fields[$key])){ return $fields[$key]; } else { return null; } } else { return null; } } public function insert() { if (!is_null($this->id)) trigger_error("Category::insert(): Attempt to insert a Category object that already has its ID property set (to $this->id).", E_USER_ERROR); // Clean-up slug string $this->slug = preg_replace('/-+/', '-', preg_replace('/^-+\|-+$/', '', $this->slug)); $conn = open_connection(); $sql = "INSERT INTO categories ( name, slug, description, meta_description, extra_fields, priority ) VALUES ( :name, :slug, :description, :meta_description, :extra_fields, :priority )"; $st = $conn->prepare($sql); $st->bindValue(":name", $this->name, PDO::PARAM_STR); $st->bindValue(":slug", esc_slug($this->slug), PDO::PARAM_STR); $st->bindValue(":description", $this->description, PDO::PARAM_STR); $st->bindValue(":meta_description", $this->meta_description, PDO::PARAM_STR); $st->bindValue(":extra_fields", $this->extra_fields, PDO::PARAM_STR); $st->bindValue(":priority", $this->priority, PDO::PARAM_INT); $st->execute(); $this->id = $conn->lastInsertId(); } public function update() { if (is_null($this->id)) trigger_error("Category::update(): Attempt to update a Category object that does not have its ID property set.", E_USER_ERROR); //$prev_name = Category::getById($this->id)->name; // // Clean-up slug string $this->slug = preg_replace('/-+/', '-', preg_replace('/^-+\|-+$/', '', $this->slug)); $conn = open_connection(); $sql = "UPDATE categories SET name=:name, slug=:slug, priority=:priority, description=:description, meta_description=:meta_description, fields=:fields, extra_fields=:extra_fields WHERE id = :id"; $st = $conn->prepare($sql); $st->bindValue(":name", $this->name, PDO::PARAM_STR); $st->bindValue(":slug", $this->slug, PDO::PARAM_STR); $st->bindValue(":description", $this->description, PDO::PARAM_STR); $st->bindValue(":meta_description", $this->meta_description, PDO::PARAM_STR); $st->bindValue(":fields", $this->fields, PDO::PARAM_STR); $st->bindValue(":extra_fields", $this->extra_fields, PDO::PARAM_STR); $st->bindValue(":id", $this->id, PDO::PARAM_INT); $st->bindValue(":priority", $this->priority, PDO::PARAM_INT); $st->execute(); } public function delete() { if (is_null($this->id)) trigger_error("Category::delete(): Attempt to delete a Category object that does not have its ID property set.", E_USER_ERROR); $conn = open_connection(); $st = $conn->prepare("DELETE FROM categories WHERE id = :id LIMIT 1"); $st->bindValue(":id", $this->id, PDO::PARAM_INT); $st->execute(); } } ?> ��

| ver. 1.4 | Github | . | PHP 8.2.28 | Generation time: 0.02 | proxy | phpinfo | Settings