Файл: html/huntb/clantur/index.php
Строк: 90
<?php
require_once '../../system/func.php';
if (isset($user['level']) && $user['level'] < 2) {
?>
<script>showContent("/main.php?msg=" + decodeURI("Не доступно до 2 уровня ."));</script>
<?php
}
$clan = $mc->query("SELECT * FROM `clan` WHERE `id`='" . $user['id_clan'] . "'")->fetch_array(MYSQLI_ASSOC);
$tur = $mc->query("SELECT * FROM `req_tur`")->fetch_all(MYSQLI_ASSOC);
if(isset($_GET['setReg']) && isset($_GET['id'])){
if(!$mc->query("SELECT * FROM `userListTur` WHERE `id_user` = '".$user['id']."' AND `id_tur` = '".$_GET['id']."'")->fetch_array(MYSQLI_ASSOC)){
if($mc->query("INSERT INTO `userListTur` (`id_user`,`id_tur`,`tur`) VALUES ('".$user['id']."','".intval($_GET['id'])."','1')")){
message("Успешно");
}
}else{
message("Нельзя зайти в турнир в котором вы есть");
}
}
if(isset($_GET['setOut']) && isset($_GET['id'])){
if(!$mc->query("SELECT * FROM `userListTur` WHERE `id_user` = '".$user['id']."' AND `id_tur` = '".$_GET['id']."'")->fetch_array(MYSQLI_ASSOC)){
message("error");
}else{
if($mc->query("DELETE FROM `userListTur` WHERE `id_user` = '".$user['id']."'")){
message("Успешно");
}
}
}
if(isset($_GET['go']) && isset($_GET['id'])){
$tur = $mc->query("SELECT * FROM `req_tur` WHERE `id` = '".intval($_GET['id'])."'")->fetch_array(MYSQLI_ASSOC);
$clName = $mc->query("SELECT `name` FROM `clan` WHERE `id` = '".$tur['id_clan']."'")->fetch_array(MYSQLI_ASSOC);
$listUser = $mc->query("SELECT * FROM `userListTur` WHERE `id_tur` = '".intval($_GET['id'])."'")->fetch_all(MYSQLI_ASSOC);
$turCount = $mc->query("SELECT * FROM `tur_list` WHERE `id` = '".$tur['id_tur']."'")->fetch_array(MYSQLI_ASSOC);
if(!$mc->query("SELECT * FROM `userListTur` WHERE `id_user` = '".$user['id']."' AND `id_tur` = '".$_GET['id']."'")->fetch_array(MYSQLI_ASSOC)){?>
<center>-Клановый турнир-</center>
<table class="table_block2">
<tr>
<td class="block01" style="width: 2%"></td>
<td class="block02" style="width: 96%"></td>
<td class="block03" style="width: 2%"></td>
</tr>
<tr>
<td class="block04"></td>
<td class="block05" style="padding-left: 6px;padding-right: 6px">
Организатор: <?= $clName['name'];?><br>
Регистрация участников с <b>21:45</b><br>
Старт турнира в <b>21:00</b><br>
Количество участников: <?= $turCount['count_user'];?><br>
Премия за победу: <br>
1 тур<br>
2 тур<br>
3 тур<br>
4 тур<br>
</td>
<td class="block06"></td>
</tr>
<tr>
<td class="block07"></td>
<td class="block08"></td>
<td class="block09"></td>
</tr>
</table>
<center> Регистрироваться могут все желающие. Во время старта турнира будет произведен отбор наиболее достойных <?= $turCount['count_user'];?> участников</center>
<br><cenrer>--Тест момент--</center>
<table class="table_block2">
<tr>
<td class="block01" style="width: 2%"></td>
<td class="block02" style="width: 96%"></td>
<td class="block03" style="width: 2%"></td>
</tr>
<tr>
<td class="block04"></td>
<td class="block05" style="padding-left: 6px;padding-right: 6px">
<?php for($i = 0; $i < count($listUser); $i++){
$users = $mc->query("SELECT * FROM `users` WHERE `id` = '".$listUser[$i]['id_user']."'")->fetch_array(MYSQLI_ASSOC); ?>
<center><?= $users['name'];?> <?=$users['level'];?></center><br>
<?php } ?>
<?php if(!$mc->query("SELECT * FROM `userListTur` WHERE `id_user` = '".$user['id']."' AND `id_tur` = '".$_GET['id']."'")->fetch_array(MYSQLI_ASSOC)){?>
<div class="button_alt_01" onclick="showContent('/huntb/clantur/index.php?setReg&id=<?=$_GET['id'];?>');">Зарегистрироваться</div>
<?php }else{ ?>
<div class="button_alt_01" onclick="showContent('/huntb/clantur/index.php?setOut&id=<?=$_GET['id'];?>');">Отказаться</div>
<?php } ?>
</td>
<td class="block06"></td>
</tr>
<tr>
<td class="block07"></td>
<td class="block08"></td>
<td class="block09"></td>
</tr>
</table>
<?php
}else{
?><script>showContent('/huntb/clantur/index.php')</script><?php
}
}
if(!isset($_GET['go']) && !isset($_GET['id'])){
?>
<div>
<center>
<div>
<b>-Турниры от кланов-</b>
</div>
</center>
<hr class="hr_02">
<center>
<div style="padding-bottom: 3px;">
Регистрация <b>20:45</b>, старт <b>21:00</b>
</div>
</center><?php
for($i = 0; $i < count($tur); $i++){
$clanName = $mc->query("SELECT `name` FROM `clan` WHERE `id` = '".$tur[$i]['id_clan']."'")->fetch_array(MYSQLI_ASSOC);
$countUser = $mc->query("SELECT * FROM `userListTur` WHERE `id_tur` = '".$tur[$i]['id_tur']."'")->num_rows;
$turCount = $mc->query("SELECT * FROM `tur_list` WHERE `id` = '".$tur[$i]['id_tur']."'")->fetch_array(MYSQLI_ASSOC); ?>
<div class="clanturblock" onclick="showContent('/huntb/clantur/index.php?go&id=<?= $tur[$i]['id'];?>')"><?= $clanName['name'];?> (<?=$countUser;?>/<?= $turCount['count_user'];?>)</div>
<?php } ?>
<center>
<div style="padding-bottom: 3px;">
Завершенные :
</div>
</center>
<div class="clanturblock">1</div>
<div class="clanturblock">2</div>
<div class="clanturblock">3</div>
<div class="clanturblock">4</div>
<div class="clanturblock">5</div>
</div>
<?php
}
$footval = "clantur_huntb";
require_once ('../../system/foot/foot.php');
?>