0 ORDER BY name"); if ($nick!='' && $skype!='' && $komanda!=''){ $dalyvis = mysql_query("SELECT * FROM `".$db_prefix."registracija` WHERE `komanda` = '$komanda'"); $sql = mysql_fetch_array($dalyvis); if ($komanda!==$sql['komanda']){ mysql_query("INSERT INTO ".$db_prefix."registracija (skype,nick,komanda) VALUES ('$skype','$nick','$komanda')") or die(mysql_error()); mysql_query("Update teams set treneris = '$nick' WHERE name = '$komanda'") or die(mysql_error()); mysql_query("Update teams set treneriss = '$skype' WHERE name = '$komanda'") or die(mysql_error()); echo "".$locale['009']." ".$locale['010']."
"; } else {echo "".$locale['011']."";} } else {echo "".$locale['012']."";} echo "

".$locale['005']."	".$userdata['user_name']."
".$locale['006']."
".$locale['007']."	"; while ($komandosPav = dbarray($komandosPasirinkimas)) { echo " ".$komandosPav[name].""; } echo "

"; echo "Dalyviai"; echo "\n"; $uzklausa=mysql_query("SELECT nick, skype, komanda from ".$db_prefix."registracija order by nick"); if (dbrows($uzklausa)) { echo "\n"; $i = 1; while ($data = dbarray($uzklausa)) { $i = $i+1; $tbl = $i%2 == 0 ? "class='tbl2'" : "class='tbl1'"; echo "\n"; } } echo "

Vartotojo vardas (vadybininkas)	Skype	Komanda
".$data['nick']."	".$data['skype']."

\n"; closetable(); require_once BASEDIR."side_right.php"; require_once BASEDIR."footer.php"; ?>