взгляните на код, дело в том что после окончания матча неверно отображаются игроки в командах. (+/-)
<?php
$matil = mysql_query("SELECT * from `m_tur` WHERE `time`<'" . (time() - 5700) . "' AND `rez1` = '—' AND `rez2` = '—';");
if (mysql_num_rows($matil) > 0)
{
while ($art = mysql_fetch_assoc($matil))
{
$sila1 = 0;
$sila2 = 0;
$k1 = mysql_query("select * from `m_team` where id='" . $art['id_team1'] . "';");
$krr1 = mysql_fetch_assoc($k1);
$k2 = mysql_query("select * from `m_team` where id='" . $art['id_team2'] . "';");
$krr2 = mysql_fetch_assoc($k2);
$req1 = mysql_query("SELECT * FROM `m_player` where `kom`='" . $art['id_team1'] . "' AND `sostav`='1' order by line asc LIMIT 11;");
$total1 = mysql_num_rows($req1);
$req2 = mysql_query("SELECT * FROM `m_player` where `kom`='" . $art['id_team2'] . "' AND `sostav`='1' order by line asc LIMIT 11;");
$total2 = mysql_num_rows($req2);
// Если не полный состав
$error = array();
if ($total1 != 11 && !$krr1['id_admin'])
echo functions::bildRoster($art['id_team1']);
if ($total2 != 11 && !$krr2['id_admin'])
echo functions::bildRoster($art['id_team2']);
if ($total2 < 9 && $total1 >= 9 && $art['goal1'] == 0 && $art['goal2'] == 0)
{
$input = "3:0";
$rezult = explode(":", $input);
$news = 'Команда ' . $krr2['name'] . ' вышла не в полном составе и получила техническое поражение 3:0.';
mysql_query("INSERT INTO `m_news` set `time`='" . time() . "', `tid`='" . $art['id'] . "' , `news`='" . $news . "' ;");
$error[] = 'error!';
} elseif ($total1 < 9 && $total2 >= 9 && $art['goal1'] == 0 && $art['goal2'] == 0)
{
$input = "0:3";
$rezult = explode(":", $input);
$news = 'Команда ' . $krr1['name'] . ' вышла не в полном составе и получила техническое поражение 0:3.';
mysql_query("INSERT INTO `m_news` set `time`='" . time() . "', `tid`='" . $art['id'] . "' , `news`='" . $news . "' ;");
$error[] = 'error!';
}
if (!$error)
{
/////////////////////////////////////////////////////////////////////////////////////////////////////////////
////////////////////////////// Расчёт //////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////////////////////////////////////////
if ($art['min'] == 0)
{
$req1 = mysql_query("SELECT * FROM `m_player` where `kom`='" . $art['id_team1'] . "' AND `sostav`='1';");
$total1 = mysql_num_rows($req1);
$id1 = '';
while ($arr1 = mysql_fetch_assoc($req1))
{
$id1[] = $arr1['id'];
$sila1 = $sila1 + $arr1['rm'];
$fiza1 = $arr1['fiz'] - $arr1['voz'];
$rmm1 = round($arr1['mas'] / 100 * $fiza1);
$rand = rand(1, 100);
if ($rand == 50 && $krr1['id_admin'] != 0)
{
$news = 'Игрок ' . $arr1['name'] . ' из команды ' . $art['name_team1'] . ' получает красную карточку и дисквалифицируется на 2 следующих игры.';
mysql_query("update `m_player` set `sostav`='4', `utime`='" . (time() + 174000) . "' where id='" . $arr1['id'] . "';");
mysql_query("INSERT INTO `m_news` set `time`='" . time() . "', `tid`='" . $art['id'] . "' , `news`='" . $news . "' ;");
}
if ($rand == 25 && $krr1['id_admin'] != 0)
{
$news = 'Игрок ' . $arr1['name'] . ' из команды ' . $art['name_team1'] . ' получает желтую карточку. ';
$arr1['yellow']++;
if ($arr1['yellow'] == 3)
{
$arr1['yellow'] = 0;
$news = $news . 'Это третья карточка. игрок дисквалифицируется на 3 следующих игры';
mysql_query("update `m_player` set `sostav`='4', `utime`='" . (time() + 260000) . "',`yellow`='" . $arr1['yellow'] . "' where id='" . $arr1['id'] .
"';");
} else
{
mysql_query("update `m_player` set `yellow`='" . $arr1['yellow'] . "' where id='" . $arr1['id'] . "';");
}
mysql_query("INSERT INTO `m_news` set `time`='" . time() . "', `tid`='" . $art['id'] . "' , `news`='" . $news . "' ;");
}
if ($rand == 75 && $krr1['id_admin'] != 0)
{
$news = 'Игрок ' . $arr1['name'] . ' из команды ' . $art['name_team1'] . ' очень сильно травмировался и будет находиться на лечении 2 следующих игры.';
mysql_query("update `m_player` set `sostav`='3', `btime`='" . (time() + 174000) . "' where id='" . $arr1['id'] . "';");
mysql_query("INSERT INTO `m_news` set `time`='" . time() . "', `tid`='" . $art['id'] . "' , `news`='" . $news . "' ;");
}
if ($krr1['id_admin'] != 0)
mysql_query("update `m_player` set `fiz`='" . $fiza1 . "', `rm`='" . $rmm1 . "' where id='" . $arr1['id'] . "';");
}
$silak1 = round($sila1);
$id2 = '';
$req2 = mysql_query("SELECT * FROM `m_player` where `kom`='" . $art['id_team2'] . "' AND `sostav`='1';");
$total2 = mysql_num_rows($req2);
while ($arr2 = mysql_fetch_assoc($req2))
{
$id2[] = $arr2['id'];
$sila2 = $sila2 + $arr2['rm'];
$fiza2 = $arr2['fiz'] - $arr2['voz'];
$rmm2 = round($arr2['mas'] / 100 * $fiza2);
$rand = rand(1, 100);
if ($rand == 50 && $krr2['id_admin'] != 0)
{
$news = 'Игрок ' . $arr2['name'] . ' из команды ' . $art['name_team2'] . ' получает красную карточку и дисквалифицируется на 2 следующих игры.';
mysql_query("update `m_player` set `sostav`='4', `utime`='" . (time() + 174000) . "' where id='" . $arr2['id'] . "';");
mysql_query("INSERT INTO `m_news` set `time`='" . time() . "', `tid`='" . $art['id'] . "' , `news`='" . $news . "' ;");
}
if ($rand == 25 && $krr2['id_admin'] != 0)
{
$news = 'Игрок ' . $arr2['name'] . ' из команды ' . $art['name_team2'] . ' получает желтую карточку. ';
$arr2['yellow']++;
if ($arr2['yellow'] == 3)
{
$arr2['yellow'] = 0;
$news = $news . 'Это третья карточка. игрок дисквалифицируется на 3 игровых дня';
mysql_query("update `m_player` set `sostav`='4', `utime`='" . (time() + 260000) . "',`yellow`='" . $arr2['yellow'] . "' where id='" . $arr2['id'] .
"';");
} else
{
mysql_query("update `m_player` set `yellow`='" . $arr2['yellow'] . "' where id='" . $arr2['id'] . "';");
}
mysql_query("INSERT INTO `m_news` set `time`='" . time() . "', `tid`='" . $art['id'] . "' , `news`='" . $news . "' ;");
}
if ($rand == 75 && $krr2['id_admin'] != 0)
{
$news = 'Игрок ' . $arr2['name'] . ' из команды ' . $art['name_team2'] .
' очень сильно травмировался и будет находиться на лечении в течение двух дней.';
mysql_query("update `m_player` set `sostav`='3', `btime`='" . (time() + 174000) . "' where id='" . $arr2['id'] . "';");
mysql_query("INSERT INTO `m_news` set `time`='" . time() . "', `tid`='" . $art['id'] . "' , `news`='" . $news . "' ;");
}
if ($krr2['id_admin'] != 0)
mysql_query("update `m_player` set `fiz`='" . $fiza2 . "', `rm`='" . $rmm2 . "' where id='" . $arr2['id'] . "';");
}
///////////////////////////////////////////////
///////////////////////////////////////////////
$silak2 = round($sila2);
$razn = abs($sila1 - $sila2);
$req = mysql_query("SELECT * FROM `m_player` where `kom`='" . $krr1['id'] . "' AND `line`='1' AND `sostav`='1' order by poz asc;");
$totalk10 = mysql_num_rows($req);
while ($arr = mysql_fetch_assoc($req))
{
$sostav1 = '<b>' . $arr['nomer'] . '</b> <a href="player.php?id=' . $arr['id'] . '">' . $arr['name'] . '</a><br/>';
}
//////////////////////////////////
$req = mysql_query("SELECT * FROM `m_player` where `kom`='" . $krr1['id'] . "' AND `line`='2' AND `sostav`='1' order by poz asc;");
$totalk11 = mysql_num_rows($req);
while ($arr = mysql_fetch_assoc($req))
{
$sostav1 = $sostav1 . '<b>' . $arr['nomer'] . '</b> <a href="player.php?id=' . $arr['id'] . '">' . $arr['name'] . '</a><br/>';
}
////////////////////////////////////
$req = mysql_query("SELECT * FROM `m_player` where `kom`='" . $krr1['id'] . "' AND `line`='3' AND `sostav`='1' order by poz asc;");
$totalk12 = mysql_num_rows($req);
while ($arr = mysql_fetch_assoc($req))
{
$sostav1 = $sostav1 . '<b>' . $arr['nomer'] . '</b> <a href="player.php?id=' . $arr['id'] . '">' . $arr['name'] . '</a><br/>';
}
///////////////////////////////////////
$req = mysql_query("SELECT * FROM `m_player` where `kom`='" . $krr1['id'] . "' AND `line`='4' AND `sostav`='1' order by poz asc;");
$totalk13 = mysql_num_rows($req);
while ($arr = mysql_fetch_assoc($req))
{
$sostav1 = $sostav1 . '<b>' . $arr['nomer'] . '</b> <a href="player.php?id=' . $arr['id'] . '">' . $arr['name'] . '</a><br/>';
}
$shema1 = '' . $totalk11 . '-' . $totalk12 . '-' . $totalk13 . '';
//////////////////////////////////
$req = mysql_query("SELECT * FROM `m_player` where `kom`='" . $krr2['id'] . "' AND `line`='1' AND `sostav`='1' order by poz asc;");
$totalk20 = mysql_num_rows($req);
while ($arr = mysql_fetch_assoc($req))
{
$sostav2 = '<b>' . $arr[nomer] . '</b> <a href="player.php?id=' . $arr['id'] . '">' . $arr['name'] . '</a><br/>';
}
//////////////////////////////////
$req = mysql_query("SELECT * FROM `m_player` where `kom`='" . $krr2['id'] . "' AND `line`='2' AND `sostav`='1' order by poz asc;");
$totalk21 = mysql_num_rows($req);
while ($arr = mysql_fetch_assoc($req))
{
$sostav2 = $sostav2 . '<b>' . $arr['nomer'] . '</b> <a href="player.php?id=' . $arr['id'] . '">' . $arr['name'] . '</a><br/>';
}
////////////////////////////////////
$req = mysql_query("SELECT * FROM `m_player` where `kom`='" . $krr2['id'] . "' AND `line`='3' AND `sostav`='1' order by poz asc;");
$totalk22 = mysql_num_rows($req);
while ($arr = mysql_fetch_assoc($req))
{
$sostav2 = $sostav2 . '<b>' . $arr['nomer'] . '</b> <a href="player.php?id=' . $arr['id'] . '">' . $arr['name'] . '</a><br/>';
}
///////////////////////////////////////
$req = mysql_query("SELECT * FROM `m_player` where `kom`='" . $krr2['id'] . "' AND `line`='4' AND `sostav`='1' order by poz asc;");
$totalk23 = mysql_num_rows($req);
while ($arr = mysql_fetch_assoc($req))
{
$sostav2 = $sostav2 . '<b>' . $arr['nomer'] . '</b> <a href="player.php?id=' . $arr['id'] . '">' . $arr['name'] . '</a><br/>';
}
$shema2 = '' . $totalk21 . '-' . $totalk22 . '-' . $totalk23 . '';
if ($sila1 >= $sila2)
{
if ($razn >= 100 && $krr1['tactics'] >= 90)
{
//echo 'Первая +10%<br/>';
$sila1 = $sila1 / 100 * 10 + $sila1;
}
if ($razn >= 100 && $krr1['tactics'] <= 20)
{
//echo 'Первая -10%<br/>';
$sila1 = $sila1 - ($sila1 / 100 * 10);
}
}
if ($sila2 <= $sila1)
{
if ($razn >= 100 && $krr2['tactics'] <= 20)
{
//echo 'Вторая +10%<br/>';
$sila2 = $sila2 / 100 * 10 + $sila2;
}
if ($razn >= 100 && $krr2['tactics'] >= 90)
{
//echo 'Вторая -10%<br/>';
$sila2 = $sila2 - ($sila2 / 100 * 10);
}
}
$razn = abs($sila1 - $sila2);
//echo 'Разница '.$razn.'<br/>';
//////////////////////////////////////////////////////////////////////////////////////
//echo '.........................................<br/>';
//echo 'пас1 '.$krr1[pass].'<br/>';
//echo 'пас2 '.$krr2[pass].'<br/>';
switch ($krr1['pass'])
{
case "0":
if ($krr2['pass'] == 2)
{
//echo 'Вторая +10%<br/>';
$sila2 = $sila2 / 100 * 10 + $sila2;
}
break;
case "1":
if ($krr2['pass'] == 0)
{
//echo 'Вторая +10%<br/>';
$sila2 = $sila2 / 100 * 10 + $sila2;
}
break;
case "2":
if ($krr2['pass'] == 1)
{
//echo 'Вторая +10%<br/>';
$sila2 = $sila2 / 100 * 10 + $sila2;
}
break;
}
switch ($krr2['pass'])
{
case "0":
if ($krr1['pass'] == 2)
{
//echo 'Первая +10%<br/>';
$sila1 = $sila1 / 100 * 10 + $sila1;
}
break;
case "1":
if ($krr1['pass'] == 0)
{
//echo 'Первая +10%<br/>';
$sila1 = $sila1 / 100 * 10 + $sila1;
}
break;
case "2":
if ($krr1['pass'] == 1)
{
//echo 'Первая +10%<br/>';
$sila1 = $sila1 / 100 * 10 + $sila1;
}
break;
}
$razn = abs($sila1 - $sila2);
//echo 'Разница '.$razn.'<br/>';
//////////////////////////////////////////////////////////////////////////////////////
//echo '.........................................<br/>';
//echo 'strat1 '.$krr1[strat].'<br/>';
//echo 'strat2 '.$krr2[strat].'<br/>';
switch ($krr1['strat'])
{
case "0":
if ($krr2['strat'] == 3 || $krr2['strat'] == 2)
{
//echo 'Вторая +10%<br/>';
$sila2 = $sila2 / 100 * 10 + $sila2;
}
break;
case "1":
if ($krr2['strat'] == 2 || $krr2['strat'] == 0)
{
//echo 'Вторая +10%<br/>';
$sila2 = $sila2 / 100 * 10 + $sila2;
}
break;
case "2":
if ($krr2['strat'] == 3 || $krr2['strat'] == 1)
{
//echo 'Вторая +10%<br/>';
$sila2 = $sila2 / 100 * 10 + $sila2;
}
break;
case "3":
if ($krr2['strat'] == 1 || $krr2['strat'] == 0)
{
//echo 'Вторая +10%<br/>';
$sila2 = $sila2 / 100 * 10 + $sila2;
}
break;
}
switch ($krr2['strat'])
{
case "0":
if ($krr1['strat'] == 3 || $krr1['strat'] == 2)
{
//echo 'Первая +10%<br/>';
$sila1 = $sila1 / 100 * 10 + $sila1;
}
break;
case "1":
if ($krr1['strat'] == 2 || $krr1['strat'] == 0)
{
//echo 'Первая +10%<br/>';
$sila1 = $sila1 / 100 * 10 + $sila1;
}
break;
case "2":
if ($krr1['strat'] == 3 || $krr1['strat'] == 1)
{
//echo 'Первая +10%<br/>';
$sila1 = $sila1 / 100 * 10 + $sila1;
}
break;
case "3":
if ($krr1['strat'] == 1 || $krr1['strat'] == 0)
{
//echo 'Первая +10%<br/>';
$sila1 = $sila1 / 100 * 10 + $sila1;
}
break;
}
$razn = abs($sila1 - $sila2);
//echo 'Разница '.$razn.'<br/>';
if ($razn >= 50)
{
if ($sila1 >= $sila2)
{
if ($razn < 75 && $razn >= 50)
{
$input = array(
"1:0",
"1:0",
"2:1",
"2:1",
"3:2",
"4:3");
}
if ($razn < 125 && $razn >= 75)
{
$input = array(
"2:0",
"2:0",
"3:1",
"3:1",
"4:2",
"5:3");
}
if ($razn < 200 && $razn >= 125)
{
$input = array(
"3:0",
"3:0",
"4:1",
"5:2");
}
if ($razn >= 200)
{
$input = array("4:0", "5:1");
}
} else
{
if ($razn < 75 && $razn >= 50)
{
$input = array(
"0:1",
"0:1",
"1:2",
"1:2",
"2:3",
"3:4");
}
if ($razn < 125 && $razn >= 75)
{
$input = array(
"0:2",
"0:2",
"1:3",
"1:3",
"2:4",
"3:5");
}
if ($razn < 200 && $razn >= 125)
{
$input = array(
"0:3",
"0:3",
"1:4",
"2:5");
}
if ($razn >= 200)
{
$input = array("0:4", "1:5");
}
}
} else
{
//echo 'Ничья<br/>';
$input = array(
"0:0",
"0:0",
"1:1",
"1:1",
"2:2",
"2:2",
"3:3");
}
$rand_keys = array_rand($input);
$rezult = explode(":", trim($input[$rand_keys]));
for ($i = 1; $i <= $rezult[0]; $i++)
{
$r_k = array_rand($id1);
mysql_query("INSERT INTO `m_goal` set `time`='" . rand(1, 90) . "', `tid`='" . $art['id'] . "' , `idgoal`='" . $id1[$r_k] . "' , `idteam`='" . $art['id_team1'] .
"';");
mysql_query("update `m_player` set `goal_chemp`=`goal_chemp`+1 where `id`='" . $id1[$r_k] . "'");
}
for ($i = 1; $i <= $rezult[1]; $i++)
{
$r_k = array_rand($id2);
mysql_query("INSERT INTO `m_goal` set `time`='" . rand(1, 90) . "', `tid`='" . $art['id'] . "' , `idgoal`='" . $id2[$r_k] . "' ,`idteam`='" . $art['id_team2'] .
"';");
mysql_query("update `m_player` set `goal_chemp`=`goal_chemp`+1 where `id`='" . $id2[$r_k] . "'");
}
$id1 = '';
$id2 = '';
$rezult1 = $rezult[0];
$rezult2 = $rezult[1];
} else
{
if ($art['min'] >= 70)
{
$req1 = mysql_query("SELECT * FROM `m_player` where `kom`='" . $art['id_team1'] . "' AND `sostav`='1';");
$total1 = mysql_num_rows($req1);
while ($arr1 = mysql_fetch_assoc($req1))
{
$sila1 = $sila1 + $arr1['rm'];
}
$req2 = mysql_query("SELECT * FROM `m_player` where `kom`='" . $art['id_team2'] . "' AND `sostav`='1';");
$total2 = mysql_num_rows($req2);
while ($arr2 = mysql_fetch_assoc($req2))
{
$sila2 = $sila2 + $arr2['rm'];
}
$req = mysql_query("SELECT * FROM `m_player` where `kom`='" . $krr1['id'] . "' AND `line`='1' AND `sostav`='1' order by poz asc;");
$totalk10 = mysql_num_rows($req);
while ($arr = mysql_fetch_assoc($req))
{
$sostav1 = '<b>' . $arr['nomer'] . '</b> <a href="player.php?id=' . $arr['id'] . '">' . $arr['name'] . '</a><br/>';
}
//////////////////////////////////
$req = mysql_query("SELECT * FROM `m_player` where `kom`='" . $krr1['id'] . "' AND `line`='2' AND `sostav`='1' order by poz asc;");
$totalk11 = mysql_num_rows($req);
while ($arr = mysql_fetch_assoc($req))
{
$sostav1 = $sostav1 . '<b>' . $arr['nomer'] . '</b> <a href="player.php?id=' . $arr['id'] . '">' . $arr['name'] . '</a><br/>';
}
////////////////////////////////////
$req = mysql_query("SELECT * FROM `m_player` where `kom`='" . $krr1['id'] . "' AND `line`='3' AND `sostav`='1' order by poz asc;");
$totalk12 = mysql_num_rows($req);
while ($arr = mysql_fetch_assoc($req))
{
$sostav1 = $sostav1 . '<b>' . $arr['nomer'] . '</b> <a href="player.php?id=' . $arr['id'] . '">' . $arr['name'] . '</a><br/>';
}
///////////////////////////////////////
$req = mysql_query("SELECT * FROM `m_player` where `kom`='" . $krr1['id'] . "' AND `line`='4' AND `sostav`='1' order by poz asc;");
$totalk13 = mysql_num_rows($req);
while ($arr = mysql_fetch_assoc($req))
{
$sostav1 = $sostav1 . '<b>' . $arr['nomer'] . '</b> <a href="player.php?id=' . $arr['id'] . '">' . $arr['name'] . '</a><br/>';
}
$shema1 = '' . $totalk11 . '-' . $totalk12 . '-' . $totalk13 . '';
//////////////////////////////////
$req = mysql_query("SELECT * FROM `m_player` where `kom`='" . $krr2['id'] . "' AND `line`='1' AND `sostav`='1' order by poz asc;");
$totalk20 = mysql_num_rows($req);
while ($arr = mysql_fetch_assoc($req))
{
$sostav2 = '<b>' . $arr['nomer'] . '</b> <a href="player.php?id=' . $arr['id'] . '">' . $arr['name'] . '</a><br/>';
}
//////////////////////////////////
$req = mysql_query("SELECT * FROM `m_player` where `kom`='" . $krr2['id'] . "' AND `line`='2' AND `sostav`='1' order by poz asc;");
$totalk21 = mysql_num_rows($req);
while ($arr = mysql_fetch_assoc($req))
{
$sostav2 = $sostav2 . '<b>' . $arr['nomer'] . '</b> <a href="player.php?id=' . $arr['id'] . '">' . $arr['name'] . '</a><br/>';
}
////////////////////////////////////
$req = mysql_query("SELECT * FROM `m_player` where `kom`='" . $krr2['id'] . "' AND `line`='3' AND `sostav`='1' order by poz asc;");
$totalk22 = mysql_num_rows($req);
while ($arr = mysql_fetch_assoc($req))
{
$sostav2 = $sostav2 . '<b>' . $arr['nomer'] . '</b> <a href="player.php?id=' . $arr['id'] . '">' . $arr['name'] . '</a><br/>';
}
///////////////////////////////////////
$req = mysql_query("SELECT * FROM `m_player` where `kom`='" . $krr2['id'] . "' AND `line`='4' AND `sostav`='1' order by poz asc;");
$totalk23 = mysql_num_rows($req);
while ($arr = mysql_fetch_assoc($req))
{
$sostav2 = $sostav2 . '<b>' . $arr['nomer'] . '</b> <a href="player.php?id=' . $arr['id'] . '">' . $arr['name'] . '</a><br/>';
}
$shema2 = '' . $totalk21 . '-' . $totalk22 . '-' . $totalk23 . '';
$bb = mysql_query("SELECT `id` FROM `m_gnews` WHERE `tid`='" . $art['id'] . "' ;");
while ($bb1 = mysql_fetch_assoc($bb))
{
mysql_query("DELETE FROM `m_gnews` WHERE `id`='" . $bb1['id'] . "' LIMIT 1;");
}
$rezult1 = $art['goal1'];
$rezult2 = $art['goal2'];
} else
{
$req1 = mysql_query("SELECT * FROM `m_player` where `kom`='" . $art['id_team1'] . "' AND `sostav`='1';");
$total1 = mysql_num_rows($req1);
$id1 = '';
while ($arr1 = mysql_fetch_assoc($req1))
{
$id1[] = $arr1['id'];
$sila1 = $sila1 + $arr1['rm'];
$fiza1 = $arr1['fiz'] - ($arr1['voz'] / 2);
$rmm1 = round($arr1['mas'] / 100 * $fiza1);
$rand = rand(1, 100);
if ($rand == 50 && $krr1['id_admin'] != 0)
{
$news = 'Игрок ' . $arr1['name'] . ' из команды ' . $art['name_team1'] . ' получает красную карточку и дисквалифицируется на 2 следующих игры.';
mysql_query("update `m_player` set `sostav`='4', `utime`='" . (time() + 174000) . "' where id='" . $arr1['id'] . "';");
mysql_query("INSERT INTO `m_news` set `time`='" . time() . "', `tid`='" . $art['id'] . "' , `news`='" . $news . "' ;");
}
if ($rand == 25 && $krr1['id_admin'] != 0)
{
$news = 'Игрок ' . $arr1['name'] . ' из команды ' . $art['name_team1'] . ' получает желтую карточку. ';
$arr1['yellow']++;
if ($arr1['yellow'] == 3)
{
$arr1['yellow'] = 0;
$news = $news . 'Это третья карточка. игрок дисквалифицируется на 3 следующих игры';
mysql_query("update `m_player` set `sostav`='4', `utime`='" . (time() + 260000) . "',`yellow`='" . $arr1['yellow'] . "' where id='" . $arr1['id'] .
"';");
} else
{
mysql_query("update `m_player` set `yellow`='" . $arr1['yellow'] . "' where id='" . $arr1['id'] . "';");
}
mysql_query("INSERT INTO `m_news` set `time`='" . time() . "', `tid`='" . $art['id'] . "' , `news`='" . $news . "' ;");
}
if ($rand == 75 && $krr1['id_admin'] != 0)
{
$news = 'Игрок ' . $arr1['name'] . ' из команды ' . $art['name_team1'] . ' очень сильно травмировался и будет находиться на лечении 2 следующих игры.';
mysql_query("update `m_player` set `sostav`='3', `btime`='" . (time() + 174000) . "' where id='" . $arr1['id'] . "';");
mysql_query("INSERT INTO `m_news` set `time`='" . time() . "', `tid`='" . $art['id'] . "' , `news`='" . $news . "' ;");
}
if ($krr1['id_admin'] != 0)
mysql_query("update `m_player` set `fiz`='" . $fiza1 . "', `rm`='" . $rmm1 . "' where id='" . $arr1['id'] . "';");
}
$id2 = '';
$silak1 = round($sila1);
$req2 = mysql_query("SELECT * FROM `m_player` where `kom`='" . $art['id_team2'] . "' AND `sostav`='1';");
$total2 = mysql_num_rows($req2);
while ($arr2 = mysql_fetch_assoc($req2))
{
$id2[] = $arr2['id'];
$sila2 = $sila2 + $arr2['rm'];
$fiza2 = $arr2['fiz'] - ($arr2['voz'] / 2);
$rmm2 = round($arr2['mas'] / 100 * $fiza2);
$rand = rand(1, 100);
if ($rand == 50 && $krr1['id_admin'] != 0)
{
$news = 'Игрок ' . $arr2['name'] . ' из команды ' . $art['name_team2'] . ' получает красную карточку и дисквалифицируется на 2 следующих игры.';
mysql_query("update `m_player` set `sostav`='4', `utime`='" . (time() + 174000) . "' where id='" . $arr2['id'] . "';");
mysql_query("INSERT INTO `m_news` set `time`='" . time() . "', `tid`='" . $art['id'] . "' , `news`='" . $news . "' ;");
}
if ($rand == 25 && $krr1['id_admin'] != 0)
{
$news = 'Игрок ' . $arr2['name'] . ' из команды ' . $art['name_team2'] . ' получает желтую карточку. ';
$arr2['yellow']++;
if ($arr2['yellow'] == 3)
{
$arr2['yellow'] = 0;
$news = $news . 'Это третья карточка. игрок дисквалифицируется на 3 игровых дня';
mysql_query("update `m_player` set `sostav`='4', `utime`='" . (time() + 260000) . "',`yellow`='" . $arr2['yellow'] . "' where id='" . $arr2['id'] .
"';");
} else
{
mysql_query("update `m_player` set `yellow`='" . $arr2['yellow'] . "' where id='" . $arr2['id'] . "';");
}
mysql_query("INSERT INTO `m_news` set `time`='" . time() . "', `tid`='" . $art['id'] . "' , `news`='" . $news . "' ;");
}
if ($rand == 75 && $krr1['id_admin'] != 0)
{
$news = 'Игрок ' . $arr2['name'] . ' из команды ' . $art['name_team2'] .
' очень сильно травмировался и будет находиться на лечении в течение двух дней.';
mysql_query("update `m_player` set `sostav`='3', `btime`='" . (time() + 174000) . "' where id='" . $arr2['id'] . "';");
mysql_query("INSERT INTO `m_news` set `time`='" . time() . "', `tid`='" . $art['id'] . "' , `news`='" . $news . "' ;");
}
if ($krr2['id_admin'] != 0)
mysql_query("update `m_player` set `fiz`='" . $fiza2 . "', `rm`='" . $rmm2 . "' where id='" . $arr2['id'] . "';");
}
///////////////////////////////////////////////
///////////////////////////////////////////////
$silak2 = round($sila2);
$razn = abs($sila1 - $sila2);
$req = mysql_query("SELECT * FROM `m_player` where `kom`='" . $krr1['id'] . "' AND `line`='1' AND `sostav`='1' order by poz asc;");
$totalk10 = mysql_num_rows($req);
while ($arr = mysql_fetch_assoc($req))
{
$sostav1 = '<b>' . $arr['nomer'] . '</b> <a href="player.php?id=' . $arr['id'] . '">' . $arr['name'] . '</a><br/>';
}
//////////////////////////////////
$req = mysql_query("SELECT * FROM `m_player` where `kom`='" . $krr1['id'] . "' AND `line`='2' AND `sostav`='1' order by poz asc;");
$totalk11 = mysql_num_rows($req);
while ($arr = mysql_fetch_assoc($req))
{
$sostav1 = $sostav1 . '<b>' . $arr['nomer'] . '</b> <a href="player.php?id=' . $arr['id'] . '">' . $arr['name'] . '</a><br/>';
}
////////////////////////////////////
$req = mysql_query("SELECT * FROM `m_player` where `kom`='" . $krr1['id'] . "' AND `line`='3' AND `sostav`='1' order by poz asc;");
$totalk12 = mysql_num_rows($req);
while ($arr = mysql_fetch_assoc($req))
{
$sostav1 = $sostav1 . '<b>' . $arr['nomer'] . '</b> <a href="player.php?id=' . $arr['id'] . '">' . $arr['name'] . '</a><br/>';
}
///////////////////////////////////////
$req = mysql_query("SELECT * FROM `m_player` where `kom`='" . $krr1['id'] . "' AND `line`='4' AND `sostav`='1' order by poz asc;");
$totalk13 = mysql_num_rows($req);
while ($arr = mysql_fetch_assoc($req))
{
$sostav1 = $sostav1 . '<b>' . $arr['nomer'] . '</b> <a href="player.php?id=' . $arr['id'] . '">' . $arr['name'] . '</a><br/>';
}
$shema1 = '' . $totalk11 . '-' . $totalk12 . '-' . $totalk13 . '';
//////////////////////////////////
$req = mysql_query("SELECT * FROM `m_player` where `kom`='" . $krr2['id'] . "' AND `line`='1' AND `sostav`='1' order by poz asc;");
$totalk20 = mysql_num_rows($req);
while ($arr = mysql_fetch_assoc($req))
{
$sostav2 = '<b>' . $arr[nomer] . '</b> <a href="player.php?id=' . $arr['id'] . '">' . $arr['name'] . '</a><br/>';
}
//////////////////////////////////
$req = mysql_query("SELECT * FROM `m_player` where `kom`='" . $krr2['id'] . "' AND `line`='2' AND `sostav`='1' order by poz asc;");
$totalk21 = mysql_num_rows($req);
while ($arr = mysql_fetch_assoc($req))
{
$sostav2 = $sostav2 . '<b>' . $arr['nomer'] . '</b> <a href="player.php?id=' . $arr['id'] . '">' . $arr['name'] . '</a><br/>';
}
////////////////////////////////////
$req = mysql_query("SELECT * FROM `m_player` where `kom`='" . $krr2['id'] . "' AND `line`='3' AND `sostav`='1' order by poz asc;");
$totalk22 = mysql_num_rows($req);
while ($arr = mysql_fetch_assoc($req))
{
$sostav2 = $sostav2 . '<b>' . $arr['nomer'] . '</b> <a href="player.php?id=' . $arr['id'] . '">' . $arr['name'] . '</a><br/>';
}
///////////////////////////////////////
$req = mysql_query("SELECT * FROM `m_player` where `kom`='" . $krr2['id'] . "' AND `line`='4' AND `sostav`='1' order by poz asc;");
$totalk23 = mysql_num_rows($req);
while ($arr = mysql_fetch_assoc($req))
{
$sostav2 = $sostav2 . '<b>' . $arr['nomer'] . '</b> <a href="player.php?id=' . $arr['id'] . '">' . $arr['name'] . '</a><br/>';
}
$shema2 = '' . $totalk21 . '-' . $totalk22 . '-' . $totalk23 . '';
if ($sila1 >= $sila2)
{
if ($razn >= 100 && $krr1['tactics'] >= 90)
{
//echo 'Первая +10%<br/>';
$sila1 = $sila1 / 100 * 10 + $sila1;
}
if ($razn >= 100 && $krr1['tactics'] <= 20)
{
//echo 'Первая -10%<br/>';
$sila1 = $sila1 - ($sila1 / 100 * 10);
}
}
if ($sila2 <= $sila1)
{
if ($razn >= 100 && $krr2['tactics'] <= 20)
{
//echo 'Вторая +10%<br/>';
$sila2 = $sila2 / 100 * 10 + $sila2;
}
if ($razn >= 100 && $krr2['tactics'] >= 90)
{
//echo 'Вторая -10%<br/>';
$sila2 = $sila2 - ($sila2 / 100 * 10);
}
}
$razn = abs($sila1 - $sila2);
//echo 'Разница '.$razn.'<br/>';
//////////////////////////////////////////////////////////////////////////////////////
//echo '.........................................<br/>';
//echo 'пас1 '.$krr1[pass].'<br/>';
//echo 'пас2 '.$krr2[pass].'<br/>';
switch ($krr1['pass'])
{
case "0":
if ($krr2['pass'] == 2)
{
//echo 'Вторая +10%<br/>';
$sila2 = $sila2 / 100 * 10 + $sila2;
}
break;
case "1":
if ($krr2['pass'] == 0)
{
//echo 'Вторая +10%<br/>';
$sila2 = $sila2 / 100 * 10 + $sila2;
}
break;
case "2":
if ($krr2['pass'] == 1)
{
//echo 'Вторая +10%<br/>';
$sila2 = $sila2 / 100 * 10 + $sila2;
}
break;
}
switch ($krr2['pass'])
{
case "0":
if ($krr1['pass'] == 2)
{
//echo 'Первая +10%<br/>';
$sila1 = $sila1 / 100 * 10 + $sila1;
}
break;
case "1":
if ($krr1['pass'] == 0)
{
//echo 'Первая +10%<br/>';
$sila1 = $sila1 / 100 * 10 + $sila1;
}
break;
case "2":
if ($krr1['pass'] == 1)
{
//echo 'Первая +10%<br/>';
$sila1 = $sila1 / 100 * 10 + $sila1;
}
break;
}
$razn = abs($sila1 - $sila2);
//echo 'Разница '.$razn.'<br/>';
//////////////////////////////////////////////////////////////////////////////////////
//echo '.........................................<br/>';
//echo 'strat1 '.$krr1[strat].'<br/>';
//echo 'strat2 '.$krr2[strat].'<br/>';
switch ($krr1['strat'])
{
case "0":
if ($krr2['strat'] == 3 || $krr2['strat'] == 2)
{
//echo 'Вторая +10%<br/>';
$sila2 = $sila2 / 100 * 10 + $sila2;
}
break;
case "1":
if ($krr2['strat'] == 2 || $krr2['strat'] == 0)
{
//echo 'Вторая +10%<br/>';
$sila2 = $sila2 / 100 * 10 + $sila2;
}
break;
case "2":
if ($krr2['strat'] == 3 || $krr2['strat'] == 1)
{
//echo 'Вторая +10%<br/>';
$sila2 = $sila2 / 100 * 10 + $sila2;
}
break;
case "3":
if ($krr2['strat'] == 1 || $krr2['strat'] == 0)
{
//echo 'Вторая +10%<br/>';
$sila2 = $sila2 / 100 * 10 + $sila2;
}
break;
}
switch ($krr2['strat'])
{
case "0":
if ($krr1['strat'] == 3 || $krr1['strat'] == 2)
{
//echo 'Первая +10%<br/>';
$sila1 = $sila1 / 100 * 10 + $sila1;
}
break;
case "1":
if ($krr1['strat'] == 2 || $krr1['strat'] == 0)
{
//echo 'Первая +10%<br/>';
$sila1 = $sila1 / 100 * 10 + $sila1;
}
break;
case "2":
if ($krr1['strat'] == 3 || $krr1['strat'] == 1)
{
//echo 'Первая +10%<br/>';
$sila1 = $sila1 / 100 * 10 + $sila1;
}
break;
case "3":
if ($krr1['strat'] == 1 || $krr1['strat'] == 0)
{
//echo 'Первая +10%<br/>';
$sila1 = $sila1 / 100 * 10 + $sila1;
}
break;
}
$razn = abs($sila1 - $sila2);
//echo 'Разница '.$razn.'<br/>';
$razn = abs($sila1 - $sila2);
//echo 'Разница '.$razn.'<br/>';
if ($razn >= 50)
{
if ($sila1 >= $sila2)
{
//echo 'Победа 1<br/>';
if ($razn < 75 && $razn >= 50)
{
$input = "1:0";
//echo $input[$rand_keys];
//echo '1:0<br/>';
}
if ($razn < 125 && $razn >= 75)
{
$input = "2:1";
//echo $input[$rand_keys];
//echo '2:0<br/>';
}
if ($razn < 200 && $razn >= 125)
{
$input = "2:0";
$rand_keys = array_rand($input);
//echo $input[$rand_keys];
//echo '3:0<br/>';
}
if ($razn >= 200)
{
$input = "3:1";
//echo $input[$rand_keys];
//echo '4:0<br/>';
}
} else
{
//echo 'Победа 2<br/>';
if ($razn < 75 && $razn >= 50)
{
$input = "0:1";
//echo $input[$rand_keys];
//echo '0:1<br/>';
}
if ($razn < 125 && $razn >= 75)
{
$input = "1:2";
//echo $input[$rand_keys];
////echo '0:2<br/>';
}
if ($razn < 200 && $razn >= 125)
{
$input = "0:2";
//echo $input[$rand_keys];
//echo '0:3<br/>';
}
if ($razn >= 200)
{
$input = "1:3";
//echo $input[$rand_keys];
////echo '0:4<br/>';
}
}
} else
{
//echo 'Ничья<br/>';
$input = "1:1";
//echo $input[$rand_keys];
}
$rezult = explode(":", trim($input));
mysql_query("delete from `m_goal` where `tid`='".$art['id']."';");
for ($i = 1; $i <= $rezult[0]; $i++)
{
$r_k = array_rand($id1);
mysql_query("INSERT INTO `m_goal` set `time`='" . (rand(1, 90)) . "', `tid`='" . $art['id'] . "' , `idgoal`='" . $id1[$r_k] . "' , `idteam`='" . $art['id_team1'] .
"';");
}
for ($i = 1; $i <= $rezult[1]; $i++)
{
$r_k = array_rand($id2);
mysql_query("INSERT INTO `m_goal` set `time`='" . (rand(1, 90)) . "', `tid`='" . $art['id'] . "' , `idgoal`='" . $id2[$r_k] . "' ,`idteam`='" . $art['id_team2'] .
"';");
}
$id1 = '';
$id2 = '';
$rezult1 = $rezult[0] + $art['goal1'];
$rezult2 = $rezult[1] + $art['goal2'];
$bb = mysql_query("SELECT `id` FROM `m_gnews` WHERE `tid`='" . $art['id'] . "' ;");
while ($bb1 = mysql_fetch_assoc($bb))
{
mysql_query("DELETE FROM `m_gnews` WHERE `id`='" . $bb1['id'] . "' LIMIT 1;");
}
}
}
} else
{
$rezult1 = $rezult[0];
$rezult2 = $rezult[1];
}
$plus = 0;
if ($krr1['stad'] > 0)
{
if ($krr1['bil'] < 10)
{
$rmax = $krr1['stad'];
} elseif ($gold < 20)
{
$rmax = round($krr1['stad'] / 10);
} elseif ($gold < 40)
{
$rmax = round($krr1['stad'] / 100);
} elseif ($gold < 50)
{
$rmax = round($krr1['stad'] / 1000);
} else
{
$rmax = 0;
}
if ($rmax != 0 && $krr1['stad'] != 0)
{
$mmax = rand(0, $rmax);
$plus = $mmax * $krr1['bil'];
$news = 'На игру пришли посмотреть ' . $mmax . ' человек. Прибыль команды ' . $krr1['name'] . ' от продажи билетов составила ' . $plus . ' тугр.';
mysql_query("INSERT INTO `m_news` set `time`='" . time() . "', `tid`='" . $art['id'] . "' , `news`='" . $news . "' ;");
}
}
$rezult[0] = $rezult1;
$rezult[1] = $rezult2;
if ($rezult[0] > $rezult[1])
{
//Команда 1
$ii1 = $krr1['ii'] + 1;
$vv1 = $krr1['vv'] + 1;
$mz1 = $krr1['mz'] + $rezult[0];
$mp1 = $krr1['mp'] + $rezult[1];
$oo1 = $krr1['oo'] + 3;
$raz1 = $krr1['raz'] + ($rezult[0] - $rezult[1]);
$moneyp = $krr1['money'] + 50000;
mysql_query("update `m_team` set `ii`='" . $ii1 . "', `vv`='" . $vv1 . "', `mz`='" . $mz1 . "' , `mp`='" . $mp1 . "', `raz`='" . $raz1 . "', `oo`='" .
$oo1 . "', `money`='" . $moneyp . "' where id='" . $krr1['id'] . "';");
//Команда 2
$ii2 = $krr2['ii'] + 1;
$vv2 = $krr2['pp'] + 1;
$mz2 = $krr2['mz'] + $rezult[1];
$mp2 = $krr2['mp'] + $rezult[0];
$oo2 = $krr2['oo'] + 0;
$raz2 = $krr2['raz'] + ($rezult[1] - $rezult[0]);
mysql_query("update `m_team` set `ii`='" . $ii2 . "', `pp`='" . $vv2 . "', `mz`='" . $mz2 . "' , `mp`='" . $mp2 . "',`raz`='" . $raz2 . "', `oo`='" .
$oo2 . "' where id='" . $krr2['id'] . "';");
} elseif ($rezult[0] < $rezult[1])
{ //Команда 1
$ii1 = $krr1['ii'] + 1;
$vv1 = $krr1['pp'] + 1;
$mz1 = $krr1['mz'] + $rezult[0];
$mp1 = $krr1['mp'] + $rezult[1];
$oo1 = $krr1['oo'] + 0;
$raz1 = $krr1['raz'] + ($rezult[0] - $rezult[1]);
mysql_query("update `m_team` set `ii`='" . $ii1 . "', `pp`='" . $vv1 . "', `mz`='" . $mz1 . "' , `mp`='" . $mp1 . "',`raz`='" . $raz1 . "', `oo`='" .
$oo1 . "' where id='" . $krr1['id'] . "';");
//Команда 2
$ii2 = $krr2['ii'] + 1;
$vv2 = $krr2['vv'] + 1;
$mz2 = $krr2['mz'] + $rezult[1];
$mp2 = $krr2['mp'] + $rezult[0];
$oo2 = $krr2['oo'] + 3;
$raz2 = $krr2['raz'] + ($rezult[1] - $rezult[0]);
$moneyp = $krr2['money'] + 50000;
mysql_query("update `m_team` set `ii`='" . $ii2 . "', `vv`='" . $vv2 . "', `mz`='" . $mz2 . "' , `mp`='" . $mp2 . "',`raz`='" . $raz2 . "', `oo`='" .
$oo2 . "', `money`='" . $moneyp . "' where id='" . $krr2['id'] . "';");
} else
{
//Команда 1
$ii1 = $krr1['ii'] + 1;
$nn1 = $krr1['nn'] + 1;
$mz1 = $krr1['mz'] + $rezult[0];
$mp1 = $krr1['mp'] + $rezult[1];
$oo1 = $krr1['oo'] + 1;
$raz1 = $krr1['raz'] + ($rezult[0] - $rezult[1]);
$moneyn1 = $krr1['money'] + 30000;
mysql_query("update `m_team` set `ii`='" . $ii1 . "', `nn`='" . $nn1 . "', `mz`='" . $mz1 . "' , `mp`='" . $mp1 . "',`raz`='" . $raz1 . "', `oo`='" .
$oo1 . "', `money`='" . $moneyn1 . "' where id='" . $krr1['id'] . "';");
//Команда 2
$ii2 = $krr2['ii'] + 1;
$nn2 = $krr2['nn'] + 1;
$mz2 = $krr2['mz'] + $rezult[1];
$mp2 = $krr2['mp'] + $rezult[0];
$oo2 = $krr2['oo'] + 1;
$raz2 = $krr2['raz'] + ($rezult[1] - $rezult[0]);
$moneyn2 = $krr2['money'] + 30000;
mysql_query("update `m_team` set `ii`='" . $ii2 . "', `nn`='" . $nn2 . "', `mz`='" . $mz2 . "' , `mp`='" . $mp2 . "',`raz`='" . $raz2 . "', `oo`='" .
$oo2 . "', `money`='" . $moneyn2 . "' where id='" . $krr2['id'] . "';");
}
mysql_query("update `m_tur` set
`sostav1`='" . $sostav1 . "', `shema1`='" . $shema1 . "', `pass1`='" . $krr1['pass'] . "', `strat1`='" . $krr1['strat'] . "', `press1`='" . $krr1['press'] .
"', `tactics1`='" . $krr1['tactics'] . "', `sila1`='" . $silak1 . "',
`sostav2`='" . $sostav2 . "', `shema2`='" . $shema2 . "', `pass2`='" . $krr2['pass'] . "', `strat2`='" . $krr2['strat'] . "', `press2`='" . $krr2['press'] .
"', `tactics2`='" . $krr2['tactics'] . "', `sila2`='" . $silak2 . "',
`rez1`='" . $rezult[0] . "', `rez2`='" . $rezult[1] . "' where id='" . $art['id'] . "';");
}
}
require_once ("cortable.php");
?>
