Просмотр файла tennis/komanda/wtagame/admin/index.php

Свежие Креативы и море позитива !!!
Размер файла: 21.18Kb
<?php
/** Author: ArseN
/*	icq: 799956
/*	email: [email protected]
/*	site: http://softmob.ru
*/
header("Content-type: text/html; charset=UTF-8");
include "../config.php";

if (empty($_GET['login']) or empty($_GET['p']))
{
        $result = mysql_query("SELECT count(*) FROM `superadmin` WHERE 1");
		$row=mysql_fetch_row($result);
		$button = "Р’РѕР№С‚Рё";
		$input_type = "password";
		
		echo "<html><head>\n";
        echo "<title>Р’С…РѕРґ</title></head>";
        echo "<body>";
        echo "<small>";
        echo "<p mode='nowrap'>";
        echo "Р’С…РѕРґ РІ Р·РѕРЅСѓ СЃСѓРїРµСЂ Р°РґРјРёРЅР°!";
        echo "</p>";
        if ($row[0] == 0)
        {
        	echo "Р’ Р±Р°Р·Рµ РЅРµ РѕР±РЅР°СЂСѓР¶РµРЅРЅРѕ СЃСѓРїРµСЂР°РґРјРёРЅРѕРІ!<br/> \n";
        	echo "РЎРµР№С‡Р°СЃ Р’С‹ РјРѕР¶РµС‚Рµ СЃРѕР·РґР°С‚СЊ СѓС‡РµС‚РЅСѓСЋ Р·Р°РїРёСЃСЊ, Рё РёСЃРїРѕР»СЊР·РѕРІР°С‚СЊ РµРµ РІ РґР°Р»СЊРЅРµР№С€РµРј РґР»СЏ СѓРїСЂР°РІР»РµРЅРёСЏ СЂРµР№С‚РёРЅРіРѕРј!<br/> \n";
        	$button = "РЎРѕР·РґР°С‚СЊ";
        	$input_type = "text";
        }
        echo "<form action='index.php'>";
        echo "Р›РѕРіРёРЅ: <br/> <input type='text' name='login' id='login'/><br/>";
        echo "РџР°СЂРѕР»СЊ: <br/> <input type='$input_type' name='p' id='p' /><br/>";
        echo "<input type='submit' value='$button' />";
        echo "</form>";
        echo "</small>";
        echo "</body></html>";
        exit;
}
$login = $_GET['login'];
$pass = $_GET['p'];

$result = mysql_query("SELECT count(*) FROM `superadmin` WHERE 1");
$row=mysql_fetch_row($result);
if($row[0] == 0)
{
		$pass = md5($pass);
		$sql="INSERT INTO `superadmin` VALUES ('','$login','$pass')";
        @mysql_query($sql);
	    $uid = mysql_insert_id();
	    if ($uid == 0)
	    {
	    	 echo "<html><head>\n";
	         echo "<title>РЎРѕР·РґР°РЅРЅРѕ</title>";
	         echo "<meta http-equiv=\"refresh\" content=\"1;url=index.php\"/>";
	         echo "</head>";
	         echo "<body>";
	         echo "<small>";
	         echo "РќРµ СЃРѕР·РґР°РЅРЅРѕ!";
	         echo "</small>";
	         echo "</body></html>";
	         exit;
	    }
         echo "<html><head>\n";
         echo "<title>РЎРѕР·РґР°РЅРЅРѕ</title>";
         echo "<meta http-equiv=\"refresh\" content=\"1;url=index.php?login=$login&p=$pass\"/>";
         echo "</head>";
         echo "<body>";
         echo "<small>";
         echo "РЈС‡РµС‚РЅР°СЏ Р·Р°РїРёСЃСЊ СЃРѕР·РґР°РЅРЅР°!";
         echo "</small>";
         echo "</body></html>";
         exit;
}

$result = mysql_query("SELECT `pass` FROM `superadmin` WHERE `login`='$login';");
$row=mysql_fetch_row($result);
if(!empty($row))
{
	$truepass = $row[0];
	if ($truepass == $pass || $truepass == md5($pass))
	{
		// РІС…РѕРґ РѕСЃСѓС‰РµСЃС‚РІР»РµРЅ
		if (!empty($_GET['act'])) $action = $_GET['act'];
		else $action = '';
		
		echo "<html><head>\n";
		echo "<title>РџР°РЅРµР»СЊ СѓРїСЂР°РІР»РµРЅРёСЏ РёРіСЂРѕР№</title>";
		echo "</head>";
		echo "<body> \n";
		// РјРµРЅСЋ РґРµР№СЃС‚РІРёР№
		switch ($action)
		{
			case "club": // Р РµРґР°РєС‚РёСЂРѕРІР°РЅРёРµ РєР»СѓР±РѕРІ
				echo "<a href=\"index.php?login=$login&p=$pass&act=viewclub\">РЎРјРѕС‚СЂРµС‚СЊ РєР»СѓР±С‹</a> <br/> \n";
				echo "<a href=\"index.php?login=$login&p=$pass&act=addclub\">Р”РѕР±Р°РІРёС‚СЊ РєР»СѓР±</a> <br/> \n";
				break;
			case "viewclub": // РЎРјРѕС‚СЂРµС‚СЊ РєР»СѓР±С‹
				$result_club = mysql_query("SELECT * FROM `clubs` WHERE 1;");
				$count_clubs = mysql_num_rows($result_club);
				if ($count_clubs == 0) echo "РќРµС‚ РєР»СѓР±РѕРІ <br/> \n";
				for ($i=0;$i<$count_clubs;$i++)
				{
					if ($i == 0)
					{
						echo "<table cols=\"5\"> \n";
						echo "<tr> \n";
						echo "<td>РљР»СѓР±</td>";
						echo "<td>Р¦РµРЅР°</td>";
						echo "<td>Р‘Р°Р»Р»</td>";
						echo "<td>Р РµРґ.</td>";
						echo "<td>РЈРґ.</td>";
						echo "</tr> \n";
					}
					$club_data = mysql_fetch_array($result_club);
					echo "<tr> \n";
					echo "<td>".$club_data['club_name']."</td>";
					echo "<td>".$club_data['club_price']."</td>";
					echo "<td>".$club_data['club_points']."</td>";
					echo "<td><a href=\"index.php?login=$login&p=$pass&id_club=".$club_data['id_club']."&act=editclub\"><img src=\"img/edit.png\" alt=\"edit\" /></a></td>";
					echo "<td><a href=\"index.php?login=$login&p=$pass&id_club=".$club_data['id_club']."&act=delclub\"><img src=\"img/del.png\" alt=\"del\" /></a></td>";
					echo "</tr> \n";
					if ($i == $count_clubs-1) echo "</table> \n";
				}
				echo "<a href=\"index.php?login=$login&p=$pass&act=addclub\">Р”РѕР±Р°РІРёС‚СЊ РєР»СѓР±</a> <br/> \n";
				break;
			case "addclub": // Р”РѕР±Р°РІРёС‚СЊ РєР»СѓР±
				if (empty($_GET['cname']) || empty($_GET['cprice']))
				{
					echo "<form action=\"index.php\" method=\"get\"> \n";
					echo "РќР°Р·РІР°РЅРёРµ РєР»СѓР±Р°: <br/> \n";
					echo "<input type=\"text\" name=\"cname\" /> <br/> \n";
					echo "РЎС‚РѕРёРјРѕСЃС‚СЊ РєР»СѓР±Р°: <br/> \n";
					echo "<input type=\"text\" name=\"cprice\" /> <br/> \n";
					echo "РЎС‚Р°СЂС‚РѕРІС‹Рµ РѕС‡РєРё РєР»СѓР±Р°: <br/> \n";
					echo "<input type=\"text\" name=\"cpoints\" /> <br/> \n";
					echo "<input type=\"hidden\" name=\"login\" value=\"$login\" /> \n";
					echo "<input type=\"hidden\" name=\"p\" value=\"$pass\" /> \n";
					echo "<input type=\"hidden\" name=\"act\" value=\"addclub\" /> \n";
					echo "<input type=\"submit\" value=\"РЎРѕР·РґР°С‚СЊ\" /> <br/> \n";
					echo "</form>";
					echo "<a href=\"index.php?login=$login&p=$pass&act=viewclub\">РЎРјРѕС‚СЂРµС‚СЊ РєР»СѓР±С‹</a> <br/> \n";
				}else
					{
						$cname = $_GET['cname'];
						$cprice = $_GET['cprice'];
						$cpoints = 0;
						if (!empty($_GET['cpoints']))
							$cpoints = $_GET['cpoints'];
						// РґРѕР±Р°РІР»РµРЅРёРµ
				        @mysql_query("INSERT INTO `clubs` VALUES ('','$cname','$cprice','$cpoints')");
				        // РїСЂРѕРІРµСЂРєР° СЃС‚Р°С‚СѓСЃР° РІС‹РїРѕР»РЅРµРЅРёСЏ РѕРїРµСЂР°С†РёРё
					    if (mysql_insert_id() > 0)
					    	echo "Р”РѕР±Р°РІР»РµРЅРЅРѕ! <br/>\n";
					    else
					    	echo "РћС€РёР±РєР°! РќРµ РґРѕР±Р°РІР»РµРЅРЅРѕ! <br/>\n";
					    echo "<a href=\"index.php?login=$login&p=$pass&act=addclub\">Р”РѕР±Р°РІРёС‚СЊ РєР»СѓР±</a> <br/> \n";
					    echo "<a href=\"index.php?login=$login&p=$pass&act=viewclub\">РЎРјРѕС‚СЂРµС‚СЊ РєР»СѓР±С‹</a> <br/> \n";
					}
				break;
			case "delclub": // РЈРґР°Р»РёС‚СЊ РєР»СѓР±
				if (!empty($_GET['id_club']))
				{
					$id_club = (int)$_GET['id_club'];
					@mysql_query("DELETE FROM `clubs` WHERE `id_club`=$id_club LIMIT 1;");
					echo "РЈРґР°Р»РµРЅ! <br/> \n";
				}
				else
					echo "РћС€РёР±РєР°! РЈРїСѓС‰РµРЅ РїР°СЂР°РјРµС‚СЂ! <br/> \n";
				echo "<a href=\"index.php?login=$login&p=$pass&act=addclub\">Р”РѕР±Р°РІРёС‚СЊ РєР»СѓР±</a> <br/> \n";
				echo "<a href=\"index.php?login=$login&p=$pass&act=viewclub\">РЎРјРѕС‚СЂРµС‚СЊ РєР»СѓР±С‹</a> <br/> \n";
				break;
			case "editclub": // РЈРґР°Р»РёС‚СЊ РєР»СѓР±
				if (!empty($_GET['id_club']))
				{
					if (empty($_GET['cname']) || empty($_GET['cprice']) || empty($_GET['cpoints']))
					{
						$id_club = (int)$_GET['id_club'];
						$result_club = mysql_query("SELECT * FROM `clubs` WHERE `id_club`=$id_club LIMIT 1;");
						$club_data = mysql_fetch_array($result_club);
						
						echo "<form action=\"index.php\" method=\"get\"> \n";
						echo "РќР°Р·РІР°РЅРёРµ РєР»СѓР±Р°: <br/> \n";
						echo "<input type=\"text\" name=\"cname\" value=\"".$club_data['club_name']."\" /> <br/> \n";
						echo "РЎС‚РѕРёРјРѕСЃС‚СЊ РєР»СѓР±Р°: <br/> \n";
						echo "<input type=\"text\" name=\"cprice\" value=\"".$club_data['club_price']."\" /> <br/> \n";
						echo "РЎС‚Р°СЂС‚РѕРІС‹Рµ РѕС‡РєРё РєР»СѓР±Р°: <br/> \n";
						echo "<input type=\"text\" name=\"cpoints\" value=\"".$club_data['club_points']."\" /> <br/> \n";
						echo "<input type=\"hidden\" name=\"login\" value=\"$login\" /> \n";
						echo "<input type=\"hidden\" name=\"p\" value=\"$pass\" /> \n";
						echo "<input type=\"hidden\" name=\"id_club\" value=\"".$club_data['id_club']."\" /> \n";
						echo "<input type=\"hidden\" name=\"act\" value=\"editclub\" /> \n";
						echo "<input type=\"submit\" value=\"Р&#65533;Р·РјРµРЅРёС‚СЊ\" /> <br/> \n";
						echo "</form>";
					}else
						{
							// РёР·РјРµРЅРµРЅРёРµ РІ Р±Р°Р·Рµ
							$id_club = (int)$_GET['id_club'];
							$cname = $_GET['cname'];
							$cprice = $_GET['cprice'];
							$cpoints = $_GET['cpoints'];
							@mysql_query("UPDATE `clubs` SET `club_name` = '$cname', `club_price` = '$cprice', `club_points` = '$cpoints' WHERE `id_club`=$id_club LIMIT 1");
							echo "РћР±РЅРѕРІР»РµРЅРЅРѕ! <br/> \n";
						}
				}
				else
					echo "РћС€РёР±РєР°! РЈРїСѓС‰РµРЅ РїР°СЂР°РјРµС‚СЂ! <br/> \n";
				echo "<a href=\"index.php?login=$login&p=$pass&act=addclub\">Р”РѕР±Р°РІРёС‚СЊ РєР»СѓР±</a> <br/> \n";
				echo "<a href=\"index.php?login=$login&p=$pass&act=viewclub\">РЎРјРѕС‚СЂРµС‚СЊ РєР»СѓР±С‹</a> <br/> \n";
				break;
			case "addtour": // РЎРѕР·РґР°РЅРёРµ С‚СѓСЂРЅРёСЂР°
				if (empty($_GET['tname']) || empty($_GET['tperiod']))
				{
					echo "<form action=\"index.php\" method=\"get\"> \n";
					echo "РќР°Р·РІР°РЅРёРµ С‚СѓСЂРЅРёСЂР°: <br/> \n";
					echo "<input type=\"text\" name=\"tname\" /> <br/> \n";
					echo "Р”Р»РёС‚РµР»СЊРЅРѕСЃС‚СЊ С‚СѓСЂРЅРёСЂР° (РІ РґРЅСЏС…): <br/> \n";
					echo "<input type=\"text\" name=\"tperiod\" /> <br/> \n";
					echo "<input type=\"hidden\" name=\"login\" value=\"$login\" /> \n";
					echo "<input type=\"hidden\" name=\"p\" value=\"$pass\" /> \n";
					echo "<input type=\"hidden\" name=\"act\" value=\"addtour\" /> \n";
					echo "<input type=\"submit\" value=\"РЎРѕР·РґР°С‚СЊ\" /> <br/> \n";
					echo "</form>";
				}else
					{
						$tname = $_GET['tname'];
						$tperiod = $_GET['tperiod'];
						$date = time();
						// РґРѕР±Р°РІР»РµРЅРёРµ
				        @mysql_query("INSERT INTO `tournament` VALUES ('','$date','$tname','$tperiod')");
				        // РїСЂРѕРІРµСЂРєР° СЃС‚Р°С‚СѓСЃР° РІС‹РїРѕР»РЅРµРЅРёСЏ РѕРїРµСЂР°С†РёРё
					    if (mysql_insert_id() > 0)
					    	echo "Р”РѕР±Р°РІР»РµРЅРЅРѕ! <br/>\n";
					    else
					    	echo "РћС€РёР±РєР°! РќРµ РґРѕР±Р°РІР»РµРЅРЅРѕ! <br/>\n";
					}
				echo "<a href=\"index.php?login=$login&p=$pass&act=tour\">РўСѓСЂРЅРёСЂС‹</a> <br/> \n";
				break;
			case "tour": // РЎРјРѕС‚СЂРµС‚СЊ С‚СѓСЂРЅРёСЂС‹
				$result_tour = mysql_query("SELECT * FROM `tournament` WHERE 1;");
				$count_tour = mysql_num_rows($result_tour);
				if ($count_tour == 0) echo "РќРµС‚ С‚СѓСЂРЅРёСЂРѕРІ! <br/>\n";
				for ($i=0;$i<$count_tour;$i++)
				{
					if ($i == 0)
					{
						echo "<table cols=\"3\"> \n";
						echo "<tr> \n";
						echo "<td>РўСѓСЂРЅРёСЂ</td>";
						echo "<td>РќР°С‡Р°Р»Рѕ</td>";
						echo "<td>РљРѕРЅРµС†</td>";
						//echo "<td>Р РµРґ.</td>";
						//echo "<td>РЈРґ.</td>";
						echo "</tr> \n";
					}
					$tour_data = mysql_fetch_array($result_tour);
					echo "<tr> \n";
					echo "<td>".$tour_data['name']."</td>";
					echo "<td>".date("d.m.",$tour_data['date'])."</td>";
					echo "<td>".date("d.m.",mktime(0,0,0,date("m",$tour_data['date']),date("d",$tour_data['date'])+$tour_data['period'], date("Y",$tour_data['date'])))."</td>";
					//echo "<td><a href=\"index.php?login=$login&p=$pass&id_club=".$tour_data['id_tour']."&act=edittour\"><img src=\"img/edit.png\" alt=\"edit\" /></a></td>";
					//echo "<td><a href=\"index.php?login=$login&p=$pass&id_club=".$tour_data['id_tour']."&act=deltour\"><img src=\"img/del.png\" alt=\"del\" /></a></td>";
					echo "</tr> \n";
					if ($i == $count_tour-1) echo "</table> \n";
				}
				echo "<a href=\"index.php?login=$login&p=$pass&act=addtour\">Р”РѕР±Р°РІРёС‚СЊ С‚СѓСЂРЅРёСЂ</a> <br/> \n";
				break;
			case "closetour": // Р—Р°РєСЂС‹С‚РёРµ С‚СѓСЂРЅРёСЂР°
				if (empty($_GET['id_tour'])) exit;

				$points_array = array();
				$id_tour = $_GET['id_tour'];
				
				$result = mysql_query("SELECT * FROM `all_tour_result` WHERE `id_tour`=$id_tour;");
				$count_data = mysql_num_rows($result);
				
				if ($count_data == 0)
				{
					$result_user = mysql_query("SELECT `id_user` FROM `users` WHERE 1;");
					$count_user = mysql_num_rows($result_user);

					for ($j=0; $j<$count_user; $j++)
					{
						$row = mysql_fetch_array($result_user);
						$id_user = (int) $row['id_user'];
						
						//РїСЂРѕРІРµСЂРєР° РєРѕРјР°РЅРґС‹ РЅР°С…РѕРґ РІ С‚СѓСЂРЅРёСЂРµ
						$result = mysql_query("SELECT * FROM `team_in_tour` WHERE `id_user`='$id_user' AND `id_tour`=$id_tour LIMIT 1;");
						$row = mysql_fetch_array($result);
						
						if(!empty($row))
						{
							$id_team = $row['id_team'];
							$date_in_tour = $row['date'];
							$points = 0;
										
							$result = mysql_query("SELECT * FROM `users_team` WHERE `id_team`='$id_team' LIMIT 1;");
							$row = mysql_fetch_array($result);
							$id_clubs = explode(';', $row['id_club']);
							foreach ($id_clubs as $id_club)
							{
								// РґР°РЅРЅС‹Рµ РїРѕ РєР»СѓР±Р°Рј
								$result_club = mysql_query("SELECT * FROM `clubs` WHERE `id_club`=$id_club;");
								$club_data = mysql_fetch_array($result_club);
								// РґР°РЅРЅС‹Рµ РїРѕ РёРіСЂР°Рј
								$result_game = mysql_query("SELECT * FROM `results_game` WHERE `id_tour`=$id_tour AND `id_club`='$id_club' AND `date`>='$date_in_tour';");
								$game_num_data = mysql_num_rows($result_game);
								$text_points = " Р&#65533;РіСЂС‹:";
								for ($i = 0; $i < $game_num_data; $i++)
								{
									$game_data = mysql_fetch_array($result_game);
									$text_points .= " ".$game_data['points'];
									$points += $game_data['points'];
								}
								$points += (int)$club_data['club_points'];
								
							}
							$points_array[$id_user] = $points;
						}
					}
					arsort($points_array);
					
					foreach ($points_array as $id_user => $points)
					{
						$result_user = mysql_query("SELECT * FROM `users_team` WHERE `id_user`=$id_user;");
						$user_data = mysql_fetch_array($result_user);
						$id_clubs = $user_data['id_club'];
						
						// РґРѕР±Р°РІР»РµРЅРёРµ
						$date = time();
					    @mysql_query("INSERT INTO `all_tour_result` VALUES ('',$date,$id_tour,$id_user,'$id_clubs',$points)");
					    // СѓРґР°Р»РµРЅРёРµ Рё СѓСЃС‚Р°РЅРѕРІРєР° РЅР°С‡Р°Р»СЊРЅС‹С… РїР°СЂР°РјРµС‚СЂРѕРІ РёРіСЂРѕРєР°
					    @mysql_query("DELETE FROM `users_team` WHERE `id_user`=$id_user LIMIT 1");
					    @mysql_query("DELETE FROM `team_in_tour` WHERE `id_user`=$id_user LIMIT 1");
					    @mysql_query("UPDATE `users` SET `money`=100 WHERE `id_user`=$id_user LIMIT 1");
					}
				} else echo "Р”Р°РЅРЅС‹Р№ С‚СѓСЂРЅРёСЂ СѓР¶Рµ Р·Р°РєСЂС‹С‚!";
				break;
			case "game": // РџСЂРѕРІРµРґРµРЅРёРµ РёРіСЂС‹
				$time_now = time();
				$result_tour = mysql_query("SELECT * FROM `tournament` WHERE 1");
				$count_tour = mysql_num_rows($result_tour);
				if ($count_tour == 0) echo "РќРµС‚ СЃРѕР·РґР°РЅРЅС‹С… С‚СѓСЂРЅРёСЂРѕРІ! <br/>\n";
				for ($i=0;$i<$count_tour;$i++)
				{
					if ($i == 0)
					{
						echo "Р’С‹Р±РµСЂРµС‚Рµ С‚СѓСЂРЅРёСЂ, РґР»СЏ РїСЂРѕРІРµРґРµРЅРёСЏ РёРіСЂС‹ (РЅР°С‡РёСЃР»РµРЅРёСЏ РѕС‡РєРѕРІ РєРѕРјР°РЅРґР°Рј):";
						echo "<table cols=\"4\"> \n";
						echo "<tr> \n";
						echo "<td>РўСѓСЂРЅРёСЂ</td>";
						echo "<td>РќР°С‡Р°Р»Рѕ</td>";
						echo "<td>РљРѕРЅРµС†</td>";
						echo "<td>РЎС‚Р°С‚СѓСЃ</td>";
						echo "</tr> \n";
					}
					$tour_data = mysql_fetch_array($result_tour);
					$date = mktime(0,0,0,date("m",$tour_data['date']),date("d",$tour_data['date'])+$tour_data['period'], date("Y",$tour_data['date']));
					
					echo "<tr> \n";
					echo "<td>".$tour_data['name']."</td>";
					echo "<td>".date("d.m.",$tour_data['date'])."</td>";
					echo "<td>".date("d.m.",mktime(0,0,0,date("m",$tour_data['date']),date("d",$tour_data['date'])+$tour_data['period'], date("Y",$tour_data['date'])))."</td>";
					
					// Р°РІС‚РѕРјР°С‚РёС‡РµСЃРєРѕРµ РїРѕСЏРІР»РµРЅРёРµ СЃСЃС‹Р»С‹ Р—Р°РєСЂС‹С‚СЊ РїРѕ РѕРєРѕРЅС‡Р°РЅРёРё С‚СѓСЂРЅРёСЂР°
					if ($time_now >= $date)
						echo "<td><a href=\"index.php?login=$login&p=$pass&id_tour=".$tour_data['id_tour']."&act=closetour\">Р—Р°РєСЂС‹С‚СЊ</a></td>";
					else
						echo "<td><a href=\"index.php?login=$login&p=$pass&id_tour=".$tour_data['id_tour']."&act=playgame\">РћС‚РєСЂС‹С‚</a></td>";
					echo "</tr> \n";
					if ($i == $count_tour-1) echo "</table> \n";
				}
				echo "<a href=\"index.php?login=$login&p=$pass&act=addtour\">Р”РѕР±Р°РІРёС‚СЊ С‚СѓСЂРЅРёСЂ</a> <br/> \n";
				break;
			case "playgame": // РЅР°С‡РёСЃР»РµРЅРёРµ РѕС‡РєРѕРІ Р·Р° РјР°С‚С‡
				if (!empty($_GET['id_tour']))
				{
					$id_tour = $_GET['id_tour'];
					$result_club = mysql_query("SELECT * FROM `clubs` WHERE 1;");
					$count_clubs = mysql_num_rows($result_club);
					if ($count_clubs == 0) echo "РќРµС‚ РєР»СѓР±РѕРІ <br/> \n";
					for ($i=0;$i<$count_clubs;$i++)
					{
						if ($i == 0)
						{
							echo "<form action=\"index.php\" method=\"get\"> \n";
							echo "<table cols=\"3\"> \n";
							echo "<tr> \n";
							echo "<td>РљР»СѓР± (Р±Р°Р»Р»)</td>";
							echo "<td>Р¦РµРЅР°</td>";
							echo "<td>Р РµР·.РёРіСЂС‹</td>";
							echo "</tr> \n";
						}
						$club_data = mysql_fetch_array($result_club);
						
						// СЃСѓРјРјР°СЂРЅС‹Рµ РѕС‡РєРё РєР»СѓР·Р° Р·Р° РІСЃРµ РёРіСЂС‹ РІ РґР°РЅРЅРѕРј С‚СѓСЂРЅРёСЂРµ id_tour
						$id_club = $club_data['id_club'];
						$result_game_club = mysql_query("SELECT sum(`points`) FROM `results_game` WHERE `id_club`=$id_club AND `id_tour`=$id_tour LIMIT 1;");
						$club_points = mysql_fetch_array($result_game_club);
						$club_points = $club_points[0];
						$club_points += $club_data['club_points'];
						
						echo "<tr> \n";
						echo "<td>".$club_data['club_name']." (".$club_points.")</td>";
						echo "<td>".$club_data['club_price']."</td>";

						echo "<td>+<input type=\"text\" name=\"club_".$club_data['id_club']."\" value=\"0\" maxlength=\"2\" size=\"2\" /></td>";
						echo "</tr> \n";
						if ($i == $count_clubs-1)
						{
							echo "</table> \n";
							echo "<input type=\"hidden\" name=\"login\" value=\"$login\" /> \n";
							echo "<input type=\"hidden\" name=\"p\" value=\"$pass\" /> \n";
							echo "<input type=\"hidden\" name=\"act\" value=\"addgame\" /> \n";
							echo "<input type=\"hidden\" name=\"id_tour\" value=\"".$_GET['id_tour']."\" /> \n";
							echo "<input type=\"submit\" value=\"Р—Р°РїРёСЃР°С‚СЊ СЂРµР·СѓР»СЊС‚Р°С‚\" /> <br/> \n";
							echo "</form>";
							echo "<a href=\"index.php?login=$login&p=$pass&act=game\">РџСЂРѕРІРµРґРµРЅРёРµ РёРіСЂС‹</a> <br/> \n";
						}
					}
				}else echo "РЈРїСѓС‰РµРЅ РЅРµРѕР±С…РѕРґРёРјС‹Р№ РїР°СЂР°РјРµС‚СЂ! <br/> \n";
				break;
			case "addgame": // Р·Р°РїРёСЃСЊ СЂРµР·СѓР»СЊС‚Р° РёРіСЂС‹
				if (!empty($_GET['id_tour']))
				{
					$date = time();
					$id_tour = $_GET['id_tour'];
					$result_club = mysql_query("SELECT `id_club` FROM `clubs` WHERE 1;");
					$count_clubs = mysql_num_rows($result_club);
					for ($i=0;$i<$count_clubs;$i++)
					{
						$club_data = mysql_fetch_array($result_club);
						if (!empty($_GET['club_'.$club_data['id_club']]))
						{
							// РІС‹РїРѕР»РЅСЏРµС‚СЃСЏ РµСЃР»Рё РїРµСЂРµРјРµРЅРЅР°СЏ РІРёРґР° club_N РїРѕР»СѓС‡РµРЅРЅР°
							$game_points = $_GET['club_'.$club_data['id_club']];
							$id_club = $club_data['id_club'];
							
							mysql_query("INSERT INTO `results_game` VALUES ('$id_tour','$id_club','$date','$game_points');");
							/*
							$last_points = 0;
							// РїСЂРѕРІРµСЂРєР° РЅР°Р»РёС‡РёСЏ Р·Р°РїРёСЃРё РєР»СѓР±Р° РІ С‚СѓСЂРЅРёСЂРЅРѕР№ С‚Р°Р±Р»РёС†Рµ
							$result_game_club = mysql_query("SELECT `id_club` FROM `results_game` WHERE `id_club`=$id_club AND `id_tour`=$id_tour LIMIT 1;");
							$count_game_club = mysql_num_rows($result_game_club);
							
							if ($count_game_club == 0)
								mysql_query("INSERT INTO `results_game` VALUES ('$id_tour','$id_club','$date','$last_points');");
							else
								{
									$result_last_game = mysql_query("SELECT `points` FROM `results_game` WHERE `id_club`=$id_club AND `id_tour`=$id_tour LIMIT 1;");
									$last_points = mysql_fetch_array($result_last_game);
									$last_points = (int) $last_points['points'];
								}
							// СЃСѓРјРјР° РѕС‡РєРѕРІ Р·Р° РІСЃРµ РёРіСЂС‹
							$game_points += $last_points;
							// Р·Р°РїРёСЃСЊ СЂРµР·СѓР»СЊС‚Р°С‚Р°
							mysql_query("UPDATE `results_game` SET `points`='$game_points', `date`='$date' WHERE `id_club`=$id_club AND `id_tour`=$id_tour LIMIT 1;");
							*/
						}
					}
					echo "РћР±РЅРѕРІР»РµРЅРЅРѕ! <br/> \n";
					echo "<a href=\"index.php?login=$login&p=$pass&act=game\">РџСЂРѕРІРµРґРµРЅРёРµ РёРіСЂС‹</a> <br/> \n";
				}else echo "РЈРїСѓС‰РµРЅ РїР°СЂР°РјРµС‚СЂ! <br/> \n";
				break;
			default:	// Р“Р»Р°РІРЅРѕРµ РјРµРЅСЋ
				echo "<a href=\"index.php?login=$login&p=$pass&act=club\">Р РµРґР°РєС‚РёСЂРѕРІР°РЅРёРµ РєР»СѓР±РѕРІ</a> <br/> \n";
				echo "<a href=\"index.php?login=$login&p=$pass&act=addtour\">РЎРѕР·РґР°РЅРёРµ С‚СѓСЂРЅРёСЂР°</a> <br/> \n";
				echo "<a href=\"index.php?login=$login&p=$pass&act=tour\">РўСѓСЂРЅРёСЂС‹</a> <br/> \n";
				echo "<a href=\"index.php?login=$login&p=$pass&act=game\">РџСЂРѕРІРµРґРµРЅРёРµ РёРіСЂС‹</a> <br/> \n";
		}
		echo "<hr/> \n";
		echo "<a href=\"index.php?login=$login&p=$pass\">Р’ РіР»Р°РІРЅРѕРµ РјРµРЅСЋ</a> <br/> \n";
		echo "</body></html>";
		exit;
	}else
		{
			echo "<html><head>\n";
		    echo "<title>РћС€РёР±РєР°</title>";
		    echo "</head>";
		    echo "<body>";
		    echo "<small>";
		    echo "РџР°СЂРѕР»СЊ РЅРµРІРµСЂРЅС‹Р№!";
		    echo "</small>";
		    echo "</body></html>";
		    exit;
		}
}else
	{
		echo "<html><head>\n";
	    echo "<title>РћС€РёР±РєР°</title>";
	    echo "</head>";
	    echo "<body>";
	    echo "<small>";
	    echo "РџР°СЂРѕР»СЊ РЅРµРІРµСЂРЅС‹Р№!";
	    echo "</small>";
	    echo "</body></html>";
	    exit;
	}
?>