$query = dbquery("SELECT name FROM teams WHERE treneris = '".$userdata['user_name']."' AND played >= 0");



                while ($qwerty = dbarray($query)) {



 



                        $komanda = $qwerty['name'];

 $suma1 = $qwerty['suma1'];



 



                }



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'];



 

$dal = dbarray(dbquery("SELECT * from teams WHERE treneris='".$userdata['user_name']."'"));

 

$suma1 = $dal['suma1'];

 



$_POST['komanda1'] = str_replace("\'", "", $_POST['komanda1']);



 



$_POST['komanda2'] = str_replace("\'", "", $_POST['komanda2']);



 







 if($suma1 > $_POST['suma']) { 



   $result = dbquery("INSERT INTO pirkimai (busena, komanda1, suma,  komanda2, zaidejas22, kada) VALUES ('Nepatvirtintas', '".$_POST['ho_team']."', '".$_POST['suma']."',  '".$_POST['aw_team']."', '".$_POST['zaidejas22']."',  '".time()."')"); 



 } else {



   echo "Jums nepakanka pinigų.";



 }



 



if($result) {



 



   opentable('Atlikti keitima');



 



   echo "<center><b>Keitimas atliktas.</b></center>";



 



   closetable();



 



 }



 



 



 



else { echo "Klaida."; }



 



}



 



else {



 



opentable('Atlikti keitima');



 



$dal = dbquery("SELECT * from teams WHERE treneris='".$userdata['user_name']."'");



 



while ($q = dbarray($dal))



 



{



 



 



 



$namee = $q['name'];



 



$te_id = $q['id'];



 



$suma1 = $q['suma1'];



 



$played = $q['played'];



 



}



 



 



$teamsho = "";



 



$t1 = dbquery("SELECT id, name FROM teams WHERE name='{$_POST['komanda1']}'");



 



while ($q = dbarray($t1))



 



{



 



   $teamsho .= "<option value=\"{$q['id']}\">{$q['name']}</option>";



 



}



 



 



$teamsaw = "";



 



$t2 = dbquery("SELECT id, name FROM teams WHERE name='{$_POST['komanda2']}'");



 



while ($q = dbarray($t2))



 



{



 



   $teamsaw .= "<option value=\"{$q['id']}\">{$q['name']}</option>";



 



}



 



$ho_te_gavimas = dbquery("SELECT id from teams WHERE name='{$_POST['komanda1']}'");



 



 



while ($q = dbarray($ho_te_gavimas))



 



{



 



$home_idas = $q['id'];



 



}



 



 



$aw_te_gavimas = dbquery("SELECT id from teams WHERE name='{$_POST['komanda2']}'");



 



 



while ($q = dbarray($aw_te_gavimas))



{



 



$away_idas = $q['id'];



 



}



 



 



$playersho = "<option value=\"0\" selected=\"selected\">Pasirinkite ?aidėją</option>";



 



$rez1 = dbquery("SELECT id, team_id, name FROM zaidejai WHERE team_id='$home_idas' order by id");



 



while ($q = dbarray($rez1)) {



 



   $playersho .= "<option value=\"{$q['id']}\">{$q['name']}</option>";



}



 



$playersaw = "<option value=\"0\" selected=\"selected\">Pasirinkite ?aidėją</option>";



 



$rez2 = dbquery("SELECT id, team_id, name FROM zaidejai WHERE team_id='$away_idas' order by id");



 



 while ($q = dbarray($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>



   </select>



  <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?aidęs pakankamai var?ybų, kad galetum atlikti keitimą.</b></td></tr></table>";



}



 



closetable();



 



 



require_once BASEDIR."side_right.php";



require_once BASEDIR."footer.php";



 



?>