<?php


require_once "../../maincore.php";
require_once "../../subheader.php";
require_once "../../side_left.php";




$query = dbquery("SELECT name FROM teams WHERE treneris = '".$userdata['user_name']."' AND played >= 0");

                while ($qwerty = dbarray($query)) {
                        $komanda = $qwerty['name'];
                }


if($komanda){



if(isset($status) && $status != '') {
if($status == 'pateikta') { /*kazkas jeigu pridejo*/ }
elseif($status == 'atmesta') { /*Kazkas jei nepridejo*/}
}

if (isset($_POST['submit'])) {
$ip = $_SERVER['REMOTE_ADDR'];

$_POST['komanda1'] = str_replace("\'", "", $_POST['komanda1']);
$_POST['komanda2'] = str_replace("\'", "", $_POST['komanda2']);

$result = dbquery("INSERT INTO pirkimai (busena, komanda1, suma,  komanda2, zaidejas22, kada)
VALUES ('Nepatvirtintas', '".$_POST['ho_team']."', '".$_POST['suma']."',  '".$_POST['aw_team']."', '".$_POST['zaidejas22']."',  '".time()."')");
if($result) {



	opentable('Atlikti keitima');
	echo "<center><b>Keitimas atliktas.</b></center>";
	closetable();
 }

else { echo "Klaida."; }
}
else {
opentable('Atlikti keitima');
$dal = mysql_query("SELECT * from teams WHERE treneris='".$userdata['user_name']."'");
while ($q = mysql_fetch_array($dal))
{

$namee = $q['name'];
$te_id = $q['id'];
$suma1 = $q['suma1'];
$played = $q['played'];
}



$teamsho = "";
$t1 = mysql_query("SELECT id, name FROM teams WHERE name='{$_POST['komanda1']}'");
while ($q = mysql_fetch_array($t1))
{
	$teamsho .= "<option value=\"{$q['id']}\">{$q['name']}</option>";
}


$teamsaw = "";
$t2 = mysql_query("SELECT id, name FROM teams WHERE name='{$_POST['komanda2']}'");
while ($q = mysql_fetch_array($t2))
{
	$teamsaw .= "<option value=\"{$q['id']}\">{$q['name']}</option>";
}

$ho_te_gavimas = mysql_query("SELECT id from teams WHERE name='{$_POST['komanda1']}'");

while ($q = mysql_fetch_array($ho_te_gavimas))
{
$home_idas = $q['id'];
}

$aw_te_gavimas = mysql_query("SELECT id from teams WHERE name='{$_POST['komanda2']}'");

while ($q = mysql_fetch_array($aw_te_gavimas))
{
$away_idas = $q['id'];
}



$playersho = "<option value=\"0\" selected=\"selected\">Pasirinkite ?aidėją</option>";
$rez1 = mysql_query("SELECT id, team_id, name FROM zaidejai WHERE team_id='$home_idas' order by id");
while ($q = mysql_fetch_array($rez1))
{
	$playersho .= "<option value=\"{$q['id']}\">{$q['name']}</option>";
}

$playersaw = "<option value=\"0\" selected=\"selected\">Pasirinkite ?aidėją</option>";
$rez2 = mysql_query("SELECT id, team_id, name FROM zaidejai WHERE team_id='$away_idas' order by id");
while ($q = mysql_fetch_array($rez2))
{
	$playersaw .= "<option value=\"{$q['id']}\">{$q['name']}</option>";
}


echo "

<center><b>Atlikti keitima</b></center><br><br>

<center>
Komanda 1 - Komanda 2<br><br>
<form method='POST' action='".FUSION_SELF."'>

<select class='textbox' name='ho_team'>
{$teamsho}
</select>
&nbsp;
&nbsp;
<select class='textbox' name='aw_team'>
{$teamsaw}
</select>
<br>


<table border='0' width='100%'>
<tr><td><br><b><center>Suma:</center></b></td><td><br><b><center>Zaidejai:</center></b></td></tr>

<td><select name='suma' class='textbox' style='width:265px;'>
<option value='500000'>500000</option>
<option value='1000000'>1000000</option>

<td><center>
<select class='textbox' name='zaidejas22'>$playersaw</select>
</center></td></tr>



</table>

 <br><br>
<input type='submit' name='submit' value='Atlikti keitima'>

</form></center>";

}


} else {
opentable("STOP");
echo "<table><tr><td class='tbl1'><b>Tu nedalyvauji turnyre, arba nesi su&#382;aid&#281;s pakankamai var&#382;yb&#371;, kad galetum atlikti keitim&#261;.</b></td></tr></table>";
}
closetable();



require_once BASEDIR."side_right.php";
require_once BASEDIR."footer.php";
?>