View file ä󿪫¬/modules/games/inc/details.php

<?
only_reg();
$ID = (isset($_GET['id_apps']) ? (int) $_GET['id_apps'] : 0);

$apps = $pdo->query(("SELECT * FROM `apps` WHERE `id` = '$ID' LIMIT 1"))->fetch(PDO::FETCH_ASSOC);

if (!$apps['id'] || $ID == 0) {
	header('Location: ?func=list');
	exit;
}

if (isset($_GET['enter']) && isset($user) && isset($_SESSION['sid']) && isset($_GET['sid']) && $_SESSION['sid'] == $_GET['sid'] && $pdo->query(("SELECT COUNT(*) FROM `user_apps` WHERE `id_user` = '$user[id]' AND `id_apps` = '$ID'"),0)->fetchColumn() == 0) {
	$pdo->query("INSERT INTO `user_apps` (`id_user`, `id_apps`, `time`) values('$user[id]', '$ID', '$time')");
	$pdo->query("UPDATE `apps` SET `count` = `count` + '1' WHERE `id` = '$ID' LIMIT 1");
	
	
$dlist = $pdo->query("SELECT * FROM `dlist` WHERE `id_user` = '".$user['id']."' LIMIT 1")->fetch(PDO::FETCH_ASSOC);

if (isset($user) && $pdo->query(("SELECT COUNT(*) FROM `dlist` WHERE `id_user` = '$user[id]' AND `games` = '3'"), 0)->fetchColumn()==0)
{
$pdo->query("UPDATE `dlist` SET `games` = '" . ($dlist['games'] + 1) . "' WHERE `id_user` = '".intval($user['id'])."' LIMIT 1");
} 

if (isset($user) && $pdo->query(("SELECT COUNT(*) FROM `dlist` WHERE `id_user` = '$user[id]' AND `games` = '3' AND `games_ok` = '0'"), 0)->fetchColumn())
{
$pdo->query("UPDATE `user` SET `activity` = '" . ($user['activity'] + $dlist['games_v']) . "' WHERE `id` = '".intval($user['id'])."' LIMIT 1");
$pdo->query("UPDATE `dlist` SET `games_ok` = '1' WHERE `id_user` = '".intval($user['id'])."' LIMIT 1");
$pdo->query("INSERT INTO `jurnal_balls` (`time`, `msg`, `id_user`, `balls`, `id_post`, `type`, `type_post`) values('$time', 'Выполнение достижения', '".intval($user['id'])."', '".intval($dlist['games_v'])."', '".intval($id_file)."', 'plus', 'games')");
}	
	
	header('Location: ' . text($apps['url']));
	exit;
} elseif (isset($user) && $pdo->query(("SELECT COUNT(*) FROM `user_apps` WHERE `id_user` = '$user[id]' AND `id_apps` = '$ID'"),0)->fetchColumn() == 1){
	$pdo->query("UPDATE `user_apps` SET `time` = '$time' WHERE `id_user` = '$user[id]' AND `id_apps` = '$ID' LIMIT 1");
	header('Location: ' . text($apps['url']));
	exit;
}


$_SESSION['sid'] = mt_rand(000, 999);
$set['title'] = text($apps['name']);
include_once H . 'sys/inc/thead.php';
aut(); 
err();

#Навигация
echo "<div class='card-header'>";
echo "<a href='/' data-toggle='tooltip' data-placement='right' title='" . lang('На главную') . "'><i class='fa fa-home fa-lg'></i></a> <i class='fa fa-angle-right fa-fw'></i> ";
echo "<a href='/modules/games/?func=list'>" . lang('Онлайн игры') . "</a> <i class='fa fa-angle-right fa-fw'></i> игра";
echo "</div>";





?>
<div class="list-group-item">


<b><?= ($apps['icon_big'] ? '<img src="' . text($apps['icon_small']) . '" /> ' : '')?> <?= text($apps['name'])?></b>
<span class='badge'><?= $pdo->query(("SELECT COUNT(id_apps) FROM `user_apps` WHERE `id_apps` = '$apps[id]'"), 0)->fetchColumn()?> <?= __('чел')?></span>
</div>

<div class="list-group-item">
<?= ($apps['icon_big'] ? '<img src="' . text($apps['icon_big']) . '" style="max-width: 100px;" /><br />' : '')?>
<br><font color='gray'><?= output_text($apps['opis'])?></font><br><br>

<? if (isset($user)) { ?>

<a class="knopka" href="index.php?func=details&id_apps=<?= $apps['id']?>&amp;sid=<?= $_SESSION['sid']?>&amp;enter"><font color=white>Войти в игру</font></a>

<? } ?>

</div>