|
Ajouter une game
texte d'accueiltexte en bas a gaucheAjouter un substituts
REQUETE EFFECTUER AVEC SUCCES !"; } if ($confirm == "txt") { $txt = $_POST['txt']; $titre = $_POST['titre']; $txt = addslashes($txt); $titre = addslashes($titre); $req = "UPDATE settings SET value='".$txt."' WHERE id=1"; mysql_query($req); $req1 = "UPDATE settings SET title='".$titre."' WHERE id=1"; mysql_query($req1); echo " REQUETE EFFECTUER AVEC SUCCES !"; } if ($confirm == "txt2") { $txt = $_POST['txt']; $txt = addslashes($txt); $req = "UPDATE settings SET value='".$txt."' WHERE id=2"; mysql_query($req); echo "REQUETE EFFECTUER AVEC SUCCES !"; } if ($confirm == "joueur") { $prenom = $_POST['prenom']; $nom = $_POST['nom']; $num = $_POST['num']; $equipe = $_POST['equipe']; $req = "INSERT INTO joueur (id,prenom,nom,equipe,numero,susbs) VALUES('','$prenom','$nom','$equipe','$num','0')"; mysql_query($req); echo "REQUETE EFFECTUER AVEC SUCCES !"; } if ($confirm == "subs") { $prenom = $_POST['prenom']; $nom = $_POST['nom']; $goaler = $_POST['goaler']; $t_name = $prenom.' '.$nom; if ($goaler == "1") { $goaler = 1; } else { $goaler = 0; } $num1 = $_POST['num1']; $num2 = $_POST['num2']; $req = "INSERT INTO subs (id,nom,num1,num2,goaler) VALUES('','$t_name','$num1','$num2','$goaler')"; mysql_query($req); echo "REQUETE EFFECTUER AVEC SUCCES !"; } if ($confirm == "subs2") { $user_id = $_GET['id']; $nom = $_POST['nom']; $num1 = $_POST['num1']; $num2 = $_POST['num2']; $goaler = $_POST['option2']; if ($goaler == "Goaler") { $goaler = 1; } else { $goaler = 0; } $req = "UPDATE subs SET num1='".$num1."' WHERE id='".$user_id."'"; mysql_query($req); $req1 = "UPDATE subs SET nom='".$nom."' WHERE id='".$user_id."'"; mysql_query($req1); $req2 = "UPDATE subs SET num2='".$num2."' WHERE id='".$user_id."'"; mysql_query($req2); $req3 = "UPDATE subs SET goaler='".$goaler."' WHERE id='".$user_id."'"; mysql_query($req3); echo "REQUETE EFFECTUER AVEC SUCCES !"; } if ($confirm == "joueur2") { $user_id = $_GET['id']; $prenom = $_POST['prenom']; $nom = $_POST['nom']; $num = $_POST['num']; $pj = $_POST['pj']; $but = $_POST['b']; $ass = $_POST['a']; $pts = $_POST['pts']; $pun = $_POST['pun']; $req = "UPDATE joueur SET prenom='".$prenom."' WHERE id='".$user_id."'"; mysql_query($req); $req1 = "UPDATE joueur SET nom='".$nom."' WHERE id='".$user_id."'"; mysql_query($req1); $req2 = "UPDATE joueur SET numero='".$num."' WHERE id='".$user_id."'"; mysql_query($req2); $req3 = "UPDATE joueur SET pj='".$pj."' WHERE id='".$user_id."'"; mysql_query($req3); $req4 = "UPDATE joueur SET b='".$but."' WHERE id='".$user_id."'"; mysql_query($req4); $req5 = "UPDATE joueur SET a='".$ass."' WHERE id='".$user_id."'"; mysql_query($req5); $req6 = "UPDATE joueur SET pts='".$pts."' WHERE id='".$user_id."'"; mysql_query($req6); $req7 = "UPDATE joueur SET pun='".$pun."' WHERE id='".$user_id."'"; mysql_query($req7); echo "REQUETE EFFECTUER AVEC SUCCES !"; } if ($confirm == "pointage") { $game_id = $_POST['game_id']; $id_winner = $_POST['winner']; $id_winner_p1 = $_POST['winner_p1']; $id_winner_p2 = $_POST['winner_p2']; $id_winner_p3 = $_POST['winner_p3']; $point_id_1 = 0.0; $point_id_2 = 0.0; $eq1_id = $_POST['team_id_1']; $eq2_id = $_POST['team_id_2']; if ($id_winner_p1 != 0) { if ($id_winner_p1 == $eq1_id) { $point_id_1 = 1.0; $point_id_1_p1 = 1.0; } if ($id_winner_p1 == $eq2_id) { $point_id_2 = 1.0; $point_id_2_p1 = 1.0; } } else { $point_id_1 = 0.5; $point_id_2 = 0.5; $point_id_1_p1 = 0.5; $point_id_2_p1 = 0.5; } if ($id_winner_p2 != 0) { if ($id_winner_p2 == $eq1_id) { $point_id_1 = $point_id_1+1.0; $point_id_1_p2 = 1.0; } if ($id_winner_p2 == $eq2_id) { $point_id_2 = $point_id_2+1.0; $point_id_2_p2 = 1.0; } } else { $point_id_1 = $point_id_1+0.5; $point_id_2 = $point_id_2+0.5; $point_id_1_p2 = 0.5; $point_id_2_p2 = 0.5; } if ($id_winner_p3 != 0) { if ($id_winner_p3 == $eq1_id) { $point_id_1 = $point_id_1+1.0; $point_id_1_p3 = 1.0; } if ($id_winner_p3 == $eq2_id) { $point_id_2 = $point_id_2+1.0; $point_id_2_p3 = 1.0; } } else { $point_id_1 = $point_id_1+0.5; $point_id_2 = $point_id_2+0.5; $point_id_1_p3 = 0.5; $point_id_2_p3 = 0.5; } if ($id_winner != 0) { if ($id_winner == $eq1_id) { $point_id_1 = $point_id_1+1.0; $point_id_1_m = 1.0; } if ($id_winner == $eq2_id) { $point_id_2 = $point_id_2+1.0; $point_id_2_m = 1.0; } } else { $point_id_1 = $point_id_1+0.5; $point_id_2 = $point_id_2+0.5; $point_id_1_m = 0.5; $point_id_2_m = 0.5; } if ($eq1_id == $id_winner) { $id_looser = $eq2_id; } else { $id_looser = $eq1_id; } $eq1_point = $_POST['point_1']; $eq2_point = $_POST['point_2']; $req = "INSERT INTO resultat (id,id_game,winner,looser,eq1_result,eq2_result) VALUES('','$game_id','$id_winner','$id_looser','$eq1_point','$eq2_point')"; mysql_query($req); $req_u1 = "UPDATE classement SET p1=p1+".$point_id_1_p1." WHERE id_equipe='".$eq1_id."'"; mysql_query($req_u1); $req_u2 = "UPDATE classement SET p2=p2+".$point_id_1_p2." WHERE id_equipe='".$eq1_id."'"; mysql_query($req_u2); $req_u3 = "UPDATE classement SET p3=p3+".$point_id_1_p3." WHERE id_equipe='".$eq1_id."'"; mysql_query($req_u3); $req_u7 = "UPDATE classement SET m=m+".$point_id_1_m." WHERE id_equipe='".$eq1_id."'"; mysql_query($req_u7); $req_u_1 = "UPDATE classement SET pts=pts+".$point_id_1." WHERE id_equipe='".$eq1_id."'"; mysql_query($req_u_1); $req_u4 = "UPDATE classement SET p1=p1+".$point_id_2_p1." WHERE id_equipe='".$eq2_id."'"; mysql_query($req_u4); $req_u5 = "UPDATE classement SET p2=p2+".$point_id_2_p2." WHERE id_equipe='".$eq2_id."'"; mysql_query($req_u5); $req_u6 = "UPDATE classement SET p3=p3+".$point_id_2_p3." WHERE id_equipe='".$eq2_id."'"; mysql_query($req_u6); $req_u8 = "UPDATE classement SET m=m+".$point_id_2_m." WHERE id_equipe='".$eq2_id."'"; mysql_query($req_u8); $req_u_2 = "UPDATE classement SET pts=pts+".$point_id_2." WHERE id_equipe='".$eq2_id."'"; mysql_query($req_u_2); if ($id_winner != 0) { // CUMULATIF !!!!!!!!! // ajoute une victoire a lequipe winner $req2 = "UPDATE cumulatif SET win=win+1 WHERE id_equipe='".$id_winner."'"; mysql_query($req2); $req4 = "UPDATE cumulatif SET total=total+1 WHERE id_equipe='".$id_winner."'"; mysql_query($req4); // ajoute une defaite pour le loooooser ! (PAS RHESUS CERTAIN !) =p $req3 = "UPDATE cumulatif SET lost=lost+1 WHERE id_equipe='".$id_looser."'"; mysql_query($req3); $req5 = "UPDATE cumulatif SET total=total+1 WHERE id_equipe='".$id_looser."'"; mysql_query($req5); } else { $req2 = "UPDATE cumulatif SET null=null+1 WHERE id_equipe='".$eq1_id."'"; mysql_query($req2); $req4 = "UPDATE cumulatif SET total=total+1 WHERE id_equipe='".$eq1_id."'"; mysql_query($req4); // ajoute une defaite pour le loooooser ! (PAS RHESUS CERTAIN !) =p $req3 = "UPDATE cumulatif SET null=null+1 WHERE id_equipe='".$eq2_id."'"; mysql_query($req3); $req5 = "UPDATE cumulatif SET total=total+1 WHERE id_equipe='".$eq2_id."'"; mysql_query($req5); } echo "REQUETE EFFECTUER AVEC SUCCES !"; echo "Equipe 1: +".$point_id_1." points"; echo "Equipe 2: +".$point_id_2." points "; } } if(isset($_GET['del'])) { $del = $_GET['del']; if ($del == "game") { $id_game = $_GET['id']; $req = "DELETE from game WHERE id='$id_game'"; mysql_query($req); $req2 = "DELETE from resultat WHERE id_game='$id_game'"; mysql_query($req2); echo " REQUETE EFFECTUER AVEC SUCCES !"; } if ($del == "joueur") { $id_joueur = $_GET['id']; $req = "DELETE from joueur WHERE id='$id_joueur'"; mysql_query($req); echo "REQUETE EFFECTUER AVEC SUCCES !"; } if ($del == "subs") { $id_joueur = $_GET['id']; $req = "DELETE from subs WHERE id='$id_joueur'"; mysql_query($req); echo "REQUETE EFFECTUER AVEC SUCCES !"; } } if (isset($_GET['edit'])) { $edit = $_GET['edit']; $user_id = $_GET['id']; if ($edit == "joueur") { $q = "SELECT * from joueur WHERE id=".$user_id.""; $r=mysql_query($q); $joueur=mysql_fetch_array($r); ?>
|