Файловый менеджер - Редактировать - C:/wwwroot/www.game-competition.com/app/includes/app_start.php
�азад
<?php session_start(); try { $socket = new mysqli(DB_HOST, DB_USERNAME, DB_PASSWORD, DB_NAME); $con = new mysqli(DB_HOST, DB_USERNAME, DB_PASSWORD, DB_NAME); if ($socket) { # empty code; } else { # error if connection is not established } } catch (Exeception $error) { if ($error) { echo 'Connection is not establish'; } } function LoadFile($name) { $path = "layout/" . $name . "/content.phtml"; if (file_exists($path)) { include($path); } else { echo 'file not exists.'; } } function ZonConfig() { global $socket; $sql = $socket->query('SELECT * FROM ' . T_ZON_CONFIG); $data = []; while ($row = $sql->fetch_assoc()) { $data = $row; } return $data; } $zon = []; $zon['url'] = $_GET['url'] ?? ''; $zon['page'] = explode("/", $_GET['url'] ?? ''); $zon['config'] = ZonConfig(); $zon['user'] = getLoggedinUser(); if (isset($_SESSION['Loggedin'])) { define("IsLoggedin", true); } else { define("IsLoggedin", false); } if (isset($_SESSION['is_admin_Loggedin'])) { define("IsAdmin", true); } else { define("IsAdmin", false); } function getLoggedinUser() { global $socket; if (isset($_SESSION['Loggedin']) && isset($_SESSION['Loggedin_user'])) { $user_i = $_SESSION['Loggedin_user']; $sql = "SELECT * FROM " . T_ZON_USERS . " WHERE username='$user_i' OR email='$user_i' "; $runned = mysqli_query($socket, $sql); $data = []; while ($row = $runned->fetch_assoc()) { $data = $row; } return $data; } } function DynamicSection() { global $socket; $sql = $socket->query('SELECT * FROM ' . T_ZON_SEC); $data = []; while ($row = $sql->fetch_assoc()) { $data[] = $row; } return $data; } function GameByCategoryName($id, $limit) { global $socket; $name = getCategoryNameById($id); if ($limit !== '') { $sql = $socket->query("SELECT * FROM " . T_ZON_GAMES . " WHERE game_category='$name' AND game_published != 'No' ORDER BY game_sort DESC, game_quality DESC LIMIT $limit "); $data = []; while ($row = $sql->fetch_assoc()) { $data[] = $row; } return $data; } } function GameByCategoryWise($name, $limit) { global $socket; if ($limit !== '') { $sql = $socket->query("SELECT * FROM " . T_ZON_GAMES . " WHERE game_category='$name' AND game_published != 'No' ORDER BY game_sort DESC LIMIT $limit "); $data = []; while ($row = $sql->fetch_assoc()) { $data[] = $row; } return $data; } } function getGame($limit) { global $socket; if ($limit !== '') { $sql = $socket->query("SELECT * FROM " . T_ZON_GAMES . " WHERE game_published != 'No' ORDER BY game_sort DESC LIMIT $limit "); $data = []; while ($row = $sql->fetch_assoc()) { $data[] = $row; } return $data; } } function getCategoryNameById($id) { global $socket; $sql = $socket->query("SELECT * FROM " . T_ZON_CATEGORY . " WHERE id=$id "); $data = $row = $sql->fetch_assoc(); return $data['name']; } function getFeaturedGames() { global $socket; $sql = $socket->query("SELECT * FROM " . T_ZON_F_GAMES); $data = []; while ($row = $sql->fetch_assoc()) { $data[] = $row; } return $data; } function getGamesById($game_id) { global $socket; $sql = $socket->query("SELECT * FROM " . T_ZON_GAMES . " WHERE id=$game_id "); $data = []; while ($row = $sql->fetch_assoc()) { $data = $row; } return $data; } function getHeaderCategory($limit = 3) { global $socket; if ($limit !== 0) { $sql = $socket->query("SELECT * FROM " . T_ZON_CATEGORY . " WHERE cat_sort > 5 ORDER BY cat_sort DESC, id DESC LIMIT $limit "); } else { $sql = $socket->query("SELECT * FROM " . T_ZON_CATEGORY . " WHERE cat_sort > 5 ORDER BY cat_sort DESC, id DESC"); } $data = []; while ($row = $sql->fetch_assoc()) { $data[] = $row; } return $data; } function getCategory($limit = 0) { global $socket; if ($limit !== 0) { $sql = $socket->query("SELECT * FROM " . T_ZON_CATEGORY . " LIMIT $limit "); } else { $sql = $socket->query("SELECT * FROM " . T_ZON_CATEGORY); } $data = []; while ($row = $sql->fetch_assoc()) { $data[] = $row; } return $data; } function num_rows($table, $con) { global $socket; $sql = $socket->query("SELECT * FROM $table WHERE $con ORDER BY id DESC "); $count = 0; while ($row = $sql->fetch_assoc()) { $count++; } return $count; } function getGamesByPopular($limit) { global $socket; $sql = $socket->query("SELECT MAX( game_played ) FROM " . T_ZON_GAMES . " WHERE game_published != 'No' $limit "); $s = $socket->query("SELECT * FROM " . T_ZON_GAMES . " WHERE game_published != 'No' ORDER BY game_played DESC $limit "); $data = []; $count = 0; while ($row = $sql->fetch_assoc()) { $data[] = $row; $count++; } $data2 = []; if ($count <= 4) { while ($r = $s->fetch_assoc()) { $data2[] = $r; } } return $data2; } function getBlogs() { global $socket; $sql = $socket->query("SELECT * FROM " . T_ZON_BLOGS . " ORDER BY id DESC "); $data = []; while ($row = $sql->fetch_assoc()) { $data[] = $row; } return $data; } function tabActivation($page, $class) { global $zon; if (isset($zon['page'][0]) && $zon['page'][0] == $page) { echo $class; } } function AutoPlay() { // global $socket; // $sql = $socket->query("SELECT * FROM " . T_ZON_GAMES . " ORDER BY id DESC "); // $game_len = count(mysqli_fetch_all($sql)); // $game_id = rand(1, $game_len); // print(" xxxxx长度：" . $game_len); // if (num_rows(T_ZON_GAMES, "id=$game_id") > 0) { // $game_id = rand(1, $game_len); // } // print(" xxxxx game_id：" . $game_id); // $game_sql = $socket->query("SELECT * FROM " . T_ZON_GAMES . " WHERE id=$game_id ORDER BY id DESC "); // $data = []; // while ($row = $game_sql->fetch_assoc()) { // $data = $row; // } // print(" xxxxx data" . json_encode($data)); // 随机获取一条 global $socket; $sql = $socket->query("SELECT * FROM " . T_ZON_GAMES . " WHERE game_published !='No' ORDER BY RAND() LIMIT 1 "); $data = []; while ($row = $sql->fetch_assoc()) { $data = $row; } // print(" xxxxx data" . json_encode($data)); return $data; } function getAd($offset, $d) { global $socket; $sql = $socket->query("SELECT * FROM " . T_ZON_ADS . " ORDER BY id ASC LIMIT $offset "); $data = []; while ($row = $sql->fetch_assoc()) { $data = $row; } return $data[$d]; } function makeSlug($v) { $e = strtolower($v); $e = str_replace(" ", "-", $e); $e = urlencode($e); return $e; } function blogById($id) { global $socket; $sql = $socket->query("SELECT * FROM " . T_ZON_BLOGS . " WHERE id=$id ORDER BY id DESC "); $data = []; while ($row = $sql->fetch_assoc()) { $data = $row; } return $data; } function getTitle() { global $zon; if ($zon['page'][0] == 'autoplay') { echo "AutoPlay - Play Random Games"; } else if ($zon['page'][0] == 'games') { echo $zon['config']['games_title']; } else if ($zon['page'][0] == 'new-games') { echo $zon['config']['games_title']; } else if ($zon['page'][0] == 'popular-games' || ($zon['page'][0] == 'archive' && $zon['page'][1] == 'popular')) { echo $zon['config']['games_title']; } else if ($zon['page'][0] == 'category' || ($zon['page'][0] == 'game' && count($zon['page']) == 2)) { $category_title = $zon['config']['category_title']; $title = str_replace("[name]", $_GET['n'] ?? '', $category_title); echo $title; } else if ($zon['page'][0] == 'blogs') { echo "Blogs"; } else if ($zon['page'][0] == 'game-details' && (count($zon['page']) == 3 || count($zon['page']) == 4)) { $play_title = $zon['config']['play_title']; if ($zon['page'][0] == 'single') { $game = getGamesById($zon['page'][1]); } else { $game = getGamesById($zon['page'][2]); } $title = str_replace("[name]", $game['game_name'], $play_title); echo $title; } else if ($zon['page'][0] == 'game' && (count($zon['page']) == 3 || count($zon['page']) == 4)) { $play_title = $zon['config']['play_title']; if ($zon['page'][0] == 'single') { $game = getGamesById($zon['page'][1]); } else { $game = getGamesById($zon['page'][2]); } $title = str_replace("[name]", $game['game_name'], $play_title); echo $title; } else if ($zon['page'][0] == 'blog') { $blog = blogById($zon['page'][2]); echo $blog['blog_title']; } else if ($zon['page'][0] == 'login') { echo "Login"; } else if ($zon['page'][0] == 'register') { echo "Register"; } else if ($zon['page'][0] == 'page') { $page = getPageById($zon['page'][1]); echo $page['title']; } else if ($zon['page'][0] == '') { echo $zon['config']['site_title']; } else if (isset($zon['page'][0]) && num_rows(T_ZON_USERS, "username='" . $zon['page'][0] . "'")) { $username = $zon['user']['username']; $pro_title = $zon['config']['profile_title']; $title = str_replace("[name]", $username, $pro_title); echo $title; } else { echo "404 Page Not Found"; } } function getPages() { global $socket; $sql = $socket->query("SELECT * FROM " . T_ZON_PAGES . " ORDER BY id DESC "); $data = []; while ($row = $sql->fetch_assoc()) { $data[] = $row; } return $data; } function getPageById($id) { global $socket; $sql = $socket->query("SELECT * FROM " . T_ZON_PAGES . " WHERE id=$id ORDER BY id DESC "); $data = []; while ($row = $sql->fetch_assoc()) { $data = $row; } return $data; } function getGamesByQuery($query, $limit) { global $socket; $sql = $socket->query("SELECT * FROM " . T_ZON_GAMES . " WHERE game_published != 'No' AND game_name LIKE '%$query%' LIMIT $limit "); $data = []; while ($row = $sql->fetch_assoc()) { $data[] = $row; } return $data; } function getCommentsByGameId($id) { global $socket; $sql = $socket->query("SELECT * FROM " . T_ZON_COMMENTS . " WHERE game_id=$id ORDER BY id DESC "); $data = []; while ($row = $sql->fetch_assoc()) { $data[] = $row; } return $data; } function getUserDataById($id) { global $socket; $sql = $socket->query("SELECT * FROM " . T_ZON_USERS . " WHERE id=$id"); $data = []; while ($row = $sql->fetch_assoc()) { $data = $row; } return $data; } function redirect($path, $full = 0) { global $site_url; $p = $path; if ($full == 1) { $p = $site_url . $path; } else { $p = $path; return $p; } echo "<script>window.location.href = '$p'</script>"; } function getUserGame($user_id) { global $socket; $sql = $socket->query("SELECT *, zon_games.id FROM zon_games LEFT JOIN zon_likes ON zon_games.id=zon_likes.game_id WHERE zon_likes.user_id=$user_id"); $data = []; while ($row = $sql->fetch_assoc()) { $data[] = $row; } return $data; } function getUserComments($user_id) { global $socket; $sql = $socket->query("SELECT *, zon_comments.id FROM zon_comments LEFT JOIN zon_users ON zon_users.id=zon_comments.user_id WHERE zon_comments.user_id=$user_id"); $data = []; while ($row = $sql->fetch_assoc()) { $data[] = $row; } return $data; } function add_views($game_id) { global $socket; mysqli_query($socket, "UPDATE " . T_ZON_GAMES. " SET game_played=game_played+1 WHERE id=$game_id"); }
| ver. 1.4 |
Github
|
.
| PHP 7.3.33 | Генераци� �траницы: 0 |
proxy
|
phpinfo
|
�а�тройка