<?php
define('_IN_JOHNCMS', 1);
$textl='Турниры';
require_once("../incfiles/core.php");
include_once('system/safe.php');
require_once("../incfiles/head.php");
if (!$user_id) {
require('../incfiles/head.php');
echo functions::display_error($lng['access_guest_forbidden']);
require('../incfiles/end.php');
exit;
}
$user = functions::get_user($user);
if (!$user) {
require('../incfiles/head.php');
echo functions::display_error($lng['user_does_not_exist']);
require('../incfiles/end.php');
exit;
}
$act = isset($_GET['act']) ? $_GET['act'] : null;
switch($act) {
case "tour":
$act = isset($_GET['id']) && (int)$_GET['id'] !=null ? $_GET['id'] : null;
$a = mysql_fetch_array(mysql_query("SELECT * FROM `tourney` WHERE `id`= '".(int)$act."';"));
if ($a['id']==null) {
echo '<div class="menu">Нет такого турнира, ёбнись об стену!</div>';
echo "<div class='menu'><a href='index.php'>Фут.менеджер</a></div>";
require_once("../incfiles/end.php");
exit();
}
$query = mysql_fetch_array(mysql_query("SELECT * FROM `fman_clubs` WHERE `user_id`='".$user['id']."';"));
if(!$query['id']) echo"<div class='menu'><b><a href='zayv.php'>Получить команду</a></b></div>";
if ($a['last']==$a['count_users']) {
echo "<div class='menu' align='center'><b><a style='color: red' href='/man/tourney.php?act=tour&id=".(int)$act."&table'>Турнирная таблица</a></b></div>";
}
if (isset($_GET['table'])) {
$table_count = $a['count_users'] / 2;
$q_users = mysql_query("SELECT * FROM `tourney_users` ORDER BY `id` ASC LIMIT $table_count");
$q_users2 = mysql_query("SELECT * FROM `tourney_users` ORDER BY `id` DESC LIMIT $table_count");
$total = mysql_result(mysql_query("SELECT COUNT(*) FROM `tourney_users`;"),0);
$arr = array();
$n = $start;
echo '<h2 align="center">1/'.$table_count.'</h2>';
echo "<table width='100%'>";
while(($a = mysql_fetch_array($q_users)) && ($b = mysql_fetch_array($q_users2))){
$n++;
$q_clubs = mysql_fetch_array(mysql_query("SELECT * FROM `fman_clubs` WHERE `id` = '".$a['club_id']."' ORDER BY `id` ASC;"));
$q_clubs2 = mysql_fetch_array(mysql_query("SELECT * FROM `fman_clubs` WHERE `id` = '".$b['club_id']."' ORDER BY `id` DESC;"));
echo "<div style='height:40px'><tr><b>". $n ."</b> <td width='33%' align='right' style='Vertical-align: middle'> <a href='/man/club.php?id={$q_clubs['id']}'>{$q_clubs['name']}</a></td> <td width='33%' align='center' style='Vertical-align: middle'><img src='/man/emblems/{$q_clubs['id']}.png' height='30'/> <font style='color:red;font-size:20pt;font-weight:bold;padding: 0px 20px'>VS</font> <img src='/man/emblems/{$q_clubs2['id']}.png' height='30'/></td><td width='33%' align='left' style='Vertical-align: middle'><a href='/man/club.php?id={$q_clubs2['id']}'>{$q_clubs2['name']}</a></td></tr></div>";
}
echo "</table>";
echo "<div class='menu' style='padding-top:50px'><a href='index.php'>Фут.менеджер</a></div>";
require_once("../incfiles/end.php");
exit();
}
if (isset($_GET['declare']) && $_GET['declare'] == "themselves" && $query['id']!=null && $a['last']!=$a['count_users']) {
if (mysql_result(mysql_query("SELECT COUNT(*) FROM `tourney_users` WHERE `club_id`='".$query['id']."';"),0) == 0) {
mysql_query("UPDATE `tourney` SET last=last+1 WHERE `id`=".$a['id'].";");
mysql_query("INSERT INTO `tourney_users` (`tour_id`, `club_id`) VALUES ('$act', '".$query['id']."');");
###############################
$name_t = $a['name'];
if ($a['last']+1==$a['count_users']) {
$table_count = $a['count_users'] / 2;
$q_users = mysql_query("SELECT * FROM `tourney_users` ORDER BY `id` ASC LIMIT $table_count");
$q_users2 = mysql_query("SELECT * FROM `tourney_users` ORDER BY `id` DESC LIMIT $table_count");
$total = mysql_result(mysql_query("SELECT COUNT(*) FROM `tourney_users`;"),0);
while(($a = mysql_fetch_array($q_users)) && ($b = mysql_fetch_array($q_users2))) {
$q_clubs = mysql_fetch_array(mysql_query("SELECT * FROM `fman_clubs` WHERE `id` = '".$a['club_id']."' ORDER BY `id` ASC;"));
$q_clubs2 = mysql_fetch_array(mysql_query("SELECT * FROM `fman_clubs` WHERE `id` = '".$b['club_id']."' ORDER BY `id` DESC;"));
$long = "Турнир {$name_t}, 1/$table_count";
$kom1 = $q_clubs['name'];
$id1 = $q_clubs['id'];
$kom2 = $q_clubs2['name'];
$id2 = $q_clubs2['id'];
$now = time() + ((core::$system_set['timeshift'] + core::$user_set['timeshift']) * 3600) - 10800;
mysql_query("INSERT INTO `fman_matches` (`time`, `turn`, `tur`, `end`, `kom1`, `id1`, `kom2`, `id2`, `sc1`, `sc2`, `tour`, `long`) VALUES ('$now', 'to', '1', '0', '{$kom1}', '$id1', '{$kom2}', '$id2', '0', '0', '1', '$long')");
header("location: /");
}
}
###############################
header("location: /man/tourney.php");
} elseif ($a['last']!=$a['count_users']) {
mysql_query("UPDATE `tourney` SET last=last-1 WHERE `id`=".$a['id']."");
mysql_query("DELETE FROM `tourney_users` WHERE `club_id`='".$query['id']."';");
header("location: /man/tourney.php");
}
}
$t = time() + ((core::$system_set['timeshift'] + core::$user_set['timeshift']) * 3600);
$time = ($a['time_create'] + $a['time_start']) + ((core::$system_set['timeshift'] + core::$user_set['timeshift']) * 3600);
$reg = date("H:i:s", mktime(0, 0, $time));
$reg_last = date("H:i:s", mktime(0, 0, $time - $t));
$c_user = $a['count_users'] - $a['last'];
if ($time - $t > 0) {
$action = "Турнир ещё не начался";
echo "<div class='menu'><h2 align='center'>{$a['name']} <i style='color:grey;font-size: x-small'>$action</i></h2></div>";
echo "<div class='list2'>{$a['about']}</div>
<div class='list2'>
Кол-во участников: {$a['count_users']} <br />
Призовые: $ {$a['fund']} <br />
Регистрация в {$reg} (Осталось: {$reg_last})
</div>";
} elseif ($time - $t < 0 && $c_user != 0) {
echo "<div class='menu'><h2 align='center'>{$a['name']} </h2> </div>";
if (mysql_result(mysql_query("SELECT COUNT(*) FROM `tourney_users` WHERE `club_id`='".$query['id']."';"),0) == 0 && $a['last']!=$a['count_users'])
echo "<center><a class='btn' href='/man/tourney.php?act=tour&id=".(int)$_GET['id']."&declare=themselves'>Заявить об участии</a></center>";
echo "<div class='list2'>{$a['about']}</div>
<div class='list2'>
Кол-во участников: {$a['count_users']} (Осталось: {$c_user})<br />
Призовые: $ {$a['fund']} <br />
Регистрация в {$reg}
</div>";
} else {
$action = "Турнир уже состоялся";
echo "<div class='menu'><h2 align='center'>{$a['name']} <i style='color:grey;font-size: x-small'>$action</i></h2> </div>";
echo "<div class='list2'>{$a['about']}</div>
<div class='list2'>
Кол-во участников: {$a['count_users']} <br />
Призовые: $ {$a['fund']} <br />
Регистрация в {$reg}
</div>";
}
$q_users = mysql_query("SELECT * FROM `tourney_users` ORDER BY `id` ASC LIMIT $start, $kmess;");
$total = mysql_result(mysql_query("SELECT COUNT(*) FROM `tourney_users`;"),0);
$arr = array();
$n = $start;
while($a = mysql_fetch_array($q_users)){
$n++;
$q_clubs = mysql_fetch_array(mysql_query("SELECT * FROM `fman_clubs` WHERE `id` = '".$a['club_id']."' ORDER BY `id` ASC;"));
echo "<div class='list1'>". $n .". <img src='/man/emblems/{$q_clubs['id']}.png' width='30'/> <a href='/man/club.php?id={$q_clubs['id']}'>{$q_clubs['name']}</a></div>";
}
if ($total > $kmess) echo '<div class="topmenu">' . functions::display_pagination('tourney.php?act=tour&id='.$act.'&', $start, $total, $kmess) . '</div>';
break;
default:
echo "<div class='menu'><h2 align='center'>$textl</h2>";
$query = mysql_fetch_array(mysql_query("SELECT * FROM `fman_clubs` WHERE `user_id`='".$user['id']."';"));
$query2 = mysql_fetch_array(mysql_query("SELECT * FROM `tourney_users` WHERE `club_id`= '".$query['id']."';"));
if (mysql_result(mysql_query("SELECT COUNT(*) FROM `tourney_users` WHERE `club_id`='".$query['id']."';"),0) == 0)
echo "<h4 align='center'>Вы не участвуете в турнирах</h4>";
else {
$t_users = mysql_fetch_array(mysql_query("SELECT * FROM `tourney_users` WHERE `club_id`= '".$query['id']."';"));
$t = mysql_fetch_array(mysql_query("SELECT * FROM `tourney` WHERE `id`= '".$t_users['tour_id']."';"));
echo "<h4 align='center'>Вы участвуете в турнире <a href='/man/tourney.php?act=tour&id={$t['id']}'>{$t['name']}</a></h4>";
}
if (mysql_result(mysql_query("SELECT COUNT(*) FROM `tourney_users` WHERE `club_id`='".$query['id']."';"),0) == 1 && $a['last']!=$a['count_users'])
echo "<center><a class='btn' href='/man/tourney.php?act=tour&id=".$query2['tour_id']."&declare=themselves'>Отписаться от участия</a></center>";
echo '</div>';
$q = mysql_query("SELECT * FROM `tourney` ORDER BY `id` ASC LIMIT $start, $kmess;");
$total = mysql_result(mysql_query("SELECT COUNT(*) FROM `tourney`;"),0);
$n = $start;
while($a = mysql_fetch_array($q)){
$n++;
$t = time() + ((core::$system_set['timeshift'] + core::$user_set['timeshift']) * 3600);
$time = ($a['time_create'] + $a['time_start']) + ((core::$system_set['timeshift'] + core::$user_set['timeshift']) * 3600);
$reg = date("H:i:s", mktime(0, 0, $time));
$reg_last = date("H:i:s", mktime(0, 0, $time - $t));
$c_user = $a['count_users'] - $a['last'];
if ($time - $t > 0) {
$act = "Турнир ещё не начался";
echo "<div class='list1'>". $n . ". <b><a href='?act=tour&id={$a['id']}'>{$a['name']}</a></b> <i style='color:grey'>$act</i> </div><div class='user'>";
echo "
Кол-во участников: <br/>$t<br/>$time {$a['count_users']} <br />
Призовые: $ {$a['fund']} <br />
Регистрация в {$reg} (Осталось: {$reg_last})
</div>";
} elseif ($time - $t < 0 && $a['last'] != $a['count_users']) {
$act = "Открыт набор на турнир";
echo "<div class='list1'>". $n . ". <b><a href='?act=tour&id={$a['id']}'>{$a['name']}</a></b> <i style='color:grey'>$act</i> </div><div class='user'>";
echo "
Кол-во участников: {$a['count_users']} (Осталось: {$c_user})<br />
Призовые: $ {$a['fund']} <br />
Регистрация в {$reg}
</div>";
} else {
$act = "Турнир уже состоялся";
echo "<div class='list1'>". $n . ". <b><a href='?act=tour&id={$a['id']}'>{$a['name']}</a></b> <i style='color:grey'>$act</i> </div><div class='user'>";
echo "
Кол-во участников: {$a['count_users']} <br />
Призовые: $ {$a['fund']} <br />
Регистрация в {$reg}
</div>";
}
if ($total > $kmess) echo '<div class="topmenu">' . functions::display_pagination('tourney.php?', $start, $total, $kmess) . '</div>';
}
}
echo "<div class='menu'><a href='index.php'>Фут.менеджер</a></div>";
require_once("../incfiles/end.php");