<body>
<div class="container">
<?php
if (isset($_POST['delete'])) {
//sumbit came from index.php when delete button selected.
if (isset($_POST['table'])) {
//do we have table information
switch ($_POST['table']) {
//what table are we deleting
case "sport":
deleteSport();
break;
case "team":
deleteTeam();
break;
case "game":
deleteGame();
break;
default:
fail();
break;
}
}
}
?>
</div>
</body>
</html>
<?php
mysqli_close($link);
require $config['BASE_DIR'] . '/classes/filter.class.php';
require $config['BASE_DIR'] . '/include/compat/json.php';
require $config['BASE_DIR'] . '/include/adodb/adodb.inc.php';
require $config['BASE_DIR'] . '/include/dbconn.php';
require $config['BASE_DIR'] . '/include/function_user.php';
$response = array('status' => 0, 'msg' => '', 'debug' => '');
if (isset($_POST['game_id'])) {
if (isset($_SESSION['uid'])) {
$filter = new VFilter();
$gid = $filter->get('game_id', 'INTEGER');
$uid = intval($_SESSION['uid']);
$sql = "SELECT UID FROM game WHERE GID = " . $gid . " LIMIT 1";
$rs = $conn->execute($sql);
if ($conn->Affected_Rows() === 1) {
$game = $rs->getrows();
if ($uid == $game[0][0]) {
deleteGame($gid);
$response['status'] = 1;
$response['msg'] = show_msg_mb($lang['ajax.delete_game_success']);
} else {
$response['msg'] = show_err_mb($lang['ajax.delete_game_failed']);
}
} else {
$response['msg'] = show_err_mb($lang['ajax.delete_game_failed']);
}
} else {
$response['msg'] = show_err_mb($lang['ajax.delete_game_login']);
}
}
echo json_encode($response);
die;
} // create if end*/
// võtan aadressirealt ja saadan createResult funktsiooni
if (isset($_GET["add_single_result"])) {
$game_id = $_GET["game_id"];
$basket_nr = $_GET["basket_nr"];
$par = $_GET["par"];
$my_result = $_GET["my_result"];
createResult($game_id, $basket_nr, $par, $my_result);
// siin suuna kuhu tahad
header("Location: data.php?add_result=" . $game_id . "&baskets=" . $_GET["baskets_count"]);
}
//kas kasutaja tahab kustutada
//kas aadressireal on ?delete=???
if (isset($_GET["delete"])) {
//saadan kaasa id, mida kustutada
deleteGame($_GET["delete"]);
}
function cleanInput($data)
{
$data = trim($data);
$data = stripslashes($data);
$data = htmlspecialchars($data);
return $data;
}
$game_list = getGameData();
?>
<p>
Tere, <?php
echo $_SESSION["user_email"];
?>
case 0:
$echoAnswer = "Визуализатор успешно удален!";
break;
case -1:
$echoAnswer = "Не удалось удалить визуализатор с сервера (однако данные из БД были удалены)!";
break;
case 1:
$echoAnswer = "Произошла ошибка во время удаления визуализатора : проблемы с БД!";
break;
case 2:
$echoAnswer = "Произошла ошибка во время работы с БД!";
break;
}
} else {
if (isset($_POST['deleteGame'])) {
$answer = deleteGame($gameId);
switch ($answer) {
case 0:
$echoAnswer = "Игра успешно удалена!";
break;
case 1:
$echoAnswer = "Произошла ошибка во время удаления игры : проблемы с БД!";
break;
case 2:
$echoAnswer = "Произошла ошибка во время работы с БД!";
break;
}
}
}
}
}
$title = $request->title;
$hint = $request->hint;
$wordFinal = $request->wordFinal;
$wordTemp = $request->wordTemp;
$wordLength = $request->wordLength;
$correct = $request->correct;
$clickedString = $request->clickedString;
$bad = $request->bad;
saveGame($username, $title, $hint, $wordFinal, $wordTemp, $wordLength, $correct, $bad, $clickedString);
} else {
if ($method == "retrieve") {
getGames($username);
} else {
if ($method == "delete") {
$title = $request->title;
deleteGame($username, $title);
}
}
}
/*Table: ID, Username, Title, wordFinal, wordTemp, wordLength, correct, bad*/
function saveGame($username, $title, $hint, $wordFinal, $wordTemp, $wordLength, $correct, $bad, $clickedString)
{
$data = array();
$connection = pdo_connect();
if (doesTitleExist($username, $title)) {
$query = <<<SQL
UPDATE SAVEGAMES
SET hint = ? AND wordFinal = ? AND wordTemp = ? AND wordLength = ? AND correct = ? AND bad = ? AND clickedString = ?
WHERE Username = ? AND Title = ?
SQL;
$statement = $connection->prepare($query);
<?php
session_start();
include "dbconnection.php";
if (isset($_REQUEST['id'])) {
deleteGame($_REQUEST['id']);
header("location:maverick-games.php?delete");
} else {
header("location:maverick-games.php");
}
/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
function uninstallGames($games, $delete_files = false)
{
global $smcFunc, $modSettings, $sourcedir, $boarddir;
require_once $sourcedir . '/Subs-Package.php';
$request = $smcFunc['db_query']('', '
SELECT id_game, internal_name, game_name, game_file, thumbnail, thumbnail_small, game_directory
FROM {db_prefix}arcade_games
WHERE id_game IN({array_int:games})', array('games' => $games));
$status = array();
while ($row = $smcFunc['db_fetch_assoc']($request)) {
if ($delete_files) {
$altdir = strtolower($row['internal_name']);
$altdir2 = 'game_' . $row['internal_name'];
$altdir3 = 'game_' . strtolower($row['internal_name']);
$phpfile = substr($row['game_file'], 0, -4) . '.php';
if ($row['game_directory'] == $row['internal_name']) {
deltree($modSettings['gamesDirectory'] . '/' . $row['game_directory'], true);
} elseif ($row['game_directory'] == $altdir) {
deltree($modSettings['gamesDirectory'] . '/' . $altdir, true);
} elseif ($row['game_directory'] == $altdir2) {
deltree($modSettings['gamesDirectory'] . '/' . $altdir2, true);
} elseif ($row['game_directory'] == $altdir3) {
deltree($modSettings['gamesDirectory'] . '/' . $altdir3, true);
} else {
$files = array_unique(array($row['game_file'], $phpfile, $row['thumbnail'], $row['thumbnail_small']));
foreach ($files as $f) {
if (!empty($f) && @file_exists($modSettings['gamesDirectory'] . '/' . $row['game_directory'] . '/' . $f)) {
@unlink($modSettings['gamesDirectory'] . '/' . $row['game_directory'] . '/' . $f);
}
}
}
if (@file_exists($boarddir . '/arcade/gamedata/' . $row['internal_name'] . '/')) {
deltree($boarddir . '/arcade/gamedata/' . $row['internal_name'] . '/', true);
}
deleteArcadeArchives($modSettings['gamesDirectory'] . '/gamedata/' . $row['internal_name']);
}
deleteGame($row['id_game'], $delete_files);
$status[] = array('id' => $row['id_game'], 'name' => $row['game_name']);
}
return $status;
}
if (count($_POST['game_sel']) > 0) {
$del_ids = $_POST['game_sel'];
foreach ($del_ids as $game_id) {
deleteGame($game_id);
}
}
header("Location: admin_config.php?eb_games");
exit;
}
if (isset($_POST['delete_all_games'])) {
$q = "SELECT " . TBL_GAMES . ".*" . " FROM " . TBL_GAMES;
$result = $sql->db_Query($q);
$num_rows = mysql_numrows($result);
for ($i = 0; $i < $num_rows; $i++) {
$game_id = mysql_result($result, $i, TBL_GAMES . ".GameID");
deleteGame($game_id);
}
header("Location: admin_config.php?eb_games");
exit;
}
if (isset($_POST['update_selected_games'])) {
if (count($_POST['game_sel']) > 0) {
$del_ids = $_POST['game_sel'];
foreach ($del_ids as $game_id) {
updateGame($game_id);
}
}
header("Location: admin_config.php?eb_games");
exit;
}
if (isset($_POST['update_all_games'])) {
<?php
session_start();
require_once "../../../include/config.php";
require_once $basedir . "/admin/include/functions.php";
$private_key = $config['private_key'];
$hash = isset($_POST['hash']) ? $_POST['hash'] : 0;
$public_key = isset($_POST['public']) ? $_POST['public'] : 0;
$time = isset($_POST['t']) ? $_POST['t'] : 0;
$myhash = md5($public_key . $private_key . $time);
if ($hash != $myhash) {
echo json_encode(array('error' => '1', 'status' => $lang[215]));
exit;
}
$game_id = isset($_POST['game_id']) ? $_POST['game_id'] : '';
if (!$game_id) {
echo json_encode(array('error' => '1', 'status' => $lang[213]));
exit;
}
$bool = deleteGame($game_id);
if ($bool) {
// erase the cache
$filename = $basedir . '/temp/all_games.txt';
if (file_exists($filename)) {
unlink($filename);
}
echo json_encode(array('error' => '0', 'status' => 'success'));
exit;
}
}
if ($index === 0) {
$errors[] = 'Please select games to be ' . $act_name . '!';
} else {
$messages[] = 'Successfully ' . $act_name . ' ' . $index . ' (selected) games!';
}
}
$remove = NULL;
$page = isset($_GET['page']) ? intval($_GET['page']) : 1;
if (isset($_GET['a']) && $_GET['a'] != '') {
$action = trim($_GET['a']);
$GID = isset($_GET['GID']) && is_numeric($_GET['GID']) && gameExists($_GET['GID']) ? trim($_GET['GID']) : NULL;
if ($GID) {
switch ($action) {
case 'delete':
deleteGame($GID);
$messages[] = 'Game deleted successfuly!';
$remove = '&a=delete&GID=' . $GID;
break;
case 'suspend':
case 'activate':
$act = $action == 'suspend' ? 0 : 1;
$act_name = $action == 'suspend' ? 'suspended' : 'activated';
$sql = "UPDATE game SET status = '" . $act . "' WHERE GID = '" . mysql_real_escape_string($GID) . "' LIMIT 1";
$conn->execute($sql);
if ($act_name == 'activated') {
send_game_approve_email($GID);
}
$remove = '&a=' . $action . '&GID=' . $GID;
$messages[] = 'Game ' . $act_name . ' successfully!';
}
