Anonymous

<?
session_start();
include "../_db.php";
if (isset($_POST['pass'])) {
	$user = $_POST['user'];
	$pass = $_POST['pass'];
	
	$q = "SELECT * from admin WHERE user='".$user."'";
	$r=mysql_query($q);		
	$admin=mysql_fetch_array($r);
	if ($admin['pass'] == $pass) {
		$_SESSION['hda_adm'] = "iaaaa";
	} else {
	echo "password incorecte !";
	}
}

if (!isset($_SESSION['hda_adm'])){
?>
<h1>Login requis</h1>
<form method="post" action="?view=txt">				
<label>&nbsp;user</label>
<input name="user" id="user" type="text" size="30" /><br/>
<label>&nbsp;pass</label>
<input name="pass" id="pass" type="password" size="30" /><br/>
<input class="button" value="Soumettre la requ&ecirc;te" type="submit" />		

</form>
<?
exit();
}


?><center>
<h1>Administration ligue hda</h1>
</center>
<table width="100%">

<tr valign="top">

<td>
<div id="main">

	

	<p>
		<a href="?view=txt">Manager les textes</a>
	</p>
	
	<p>
		<a href="?view=game">Manager les parties</a>
	</p>
	
	<p>
		<a href="?view=joueurs">Manager les joueurs</a>
	</p>

	<p>
		<a href="?view=subs">Manager les substituts</a>
	</p>
	
	<p>
		<a href="?view=points">Manager le pointage</a>
	</p>
	
	<p>
		<a href="logout.php">log out</a>
	</p>
	</td>
	
	<td>
<?
if(isset($_GET['view'])) {
	$view = $_GET['view'];
	
	if ($view == "game") {
echo '
	<p>
		<a href="?add=game">Ajouter une game</a>
	</p>
<p>
	<table width="100%">
		<tr width="100%">
		<td width="30%">
		<b>Date</b>
		</td>
		<td width="10%">
		<b>Heure</b>
		</td>
		<td width="10%">
		<b>&Eacute;quipe</b>
		</td>
		<td width="10%">
		&nbsp;
		</td>
</tr>
';
		
		
		$query = "SELECT * from game ORDER by date DESC";
		$result=mysql_query($query);
		
		while ($game=mysql_fetch_array($result)) {
		
		$q = "SELECT * from equipe WHERE id=".$game['eq1']."";
		$r=mysql_query($q);		
		$equipe1=mysql_fetch_array($r);
		
		$q1 = "SELECT * from equipe WHERE id=".$game['eq2']."";
		$r1=mysql_query($q1);		
		$equipe2=mysql_fetch_array($r1);
		
		$tmz = $equipe1['nom']." - ".$equipe2['nom'];
		
		echo '
		<tr width="100%">
		<td width="30%">'.$game['date'].'</td>
		<td width="10%">'.$game['heure'].'</td>
		<td width="10%">'.$tmz.'</td>
		<td><a href="?del=game&id='.$game['id'].'">del</a></td>
		</tr>
		';
		
		}
	echo '
	</table></p>

	';
	}
	
	if ($view == "joueurs") {
echo '
	<p>
		<a href="?add=joueur">Ajouter une vedette</a>
	</p>
<p>
	<table width="100%">
		<tr width="100%">
		<td width="30%">
		<b>Nom</b>
		</td>
		<td width="10%">
		<b>Numero</b>
		</td>
		<td width="10%">
		<b>&Eacute;quipe</b>
		</td>
		<td width="10%">
		&nbsp;
		</td>
</tr>
';
		
		
		$query = "SELECT * from joueur ORDER by nom ASC";
		$result=mysql_query($query);
		
		while ($game=mysql_fetch_array($result)) {
		
		$q = "SELECT * from equipe WHERE id=".$game['equipe']."";
		$r=mysql_query($q);		
		$equipe1=mysql_fetch_array($r);
		
		
		$tmz = $equipe1['nom'];
		
		echo '
		<tr width="100%">
		<td width="30%">'.$game['prenom'].' '.$game['nom'].'</td>
		<td width="10%">'.$game['numero'].'</td>
		<td width="10%">'.$tmz.'</td>
		<td><a href="?edit=joueur&id='.$game['id'].'">edit</a> | <a href="?del=joueur&id='.$game['id'].'">del</a></td>
		</tr>
		';
		
		}
	echo '
	</table></p>

	';
	}
	
	if ($view == "txt") {

		$q_ = "SELECT * from settings where id=1 LIMIT 1";
		$r_=mysql_query($q_);
		$settings=mysql_fetch_array($r_);
		$titre = $settings['title'];
		$txt = $settings['value'];
	?>
				<h1>texte d'accueil</h1>
				<form method="post" name="send" id="send" action="?confirm=txt">				
				<p>
				
				<label>&nbsp;Titre</label>
				<input name="titre" id="titre" value="<? echo $titre; ?>" type="text" size="30" /> <br/>
				<label>&nbsp;Ton joli texte</label><br/>
				<textarea name="txt" rows="10" cols="50"><? echo $txt; ?></textarea>
				<br />	
				<input class="button" value="Soumettre la requ&ecirc;te" type="submit" />		
				</p>		
				</form>	
<?
		$q_ = "SELECT * from settings where id=2 LIMIT 1";
		$r_=mysql_query($q_);
		$settings=mysql_fetch_array($r_);
		$txt2 = $settings['value'];
?>				
				<br/><br/>
				<h1>texte en bas a gauche</h1>
				<form method="post" name="send" id="send" action="?confirm=txt2">				
				<p>
				
				<label>&nbsp;Ton joli texte</label><br/>
				<textarea name="txt" rows="10" cols="50"><? echo $txt2; ?></textarea>
				<br />	
				<input class="button" value="Soumettre la requ&ecirc;te" type="submit" />		
				</p>		
				</form>	
	<?
	
	}
	

	if ($view == "subs") {
echo '
	<p>
		<a href="?add=subs">Ajouter un substituts</a>
	</p>
<p>
	<table width="100%">
		<tr width="100%">
		<td width="30%">
		<b>Nom</b>
		</td>
		<td width="15%">
		<b>Numero de tel</b>
		</td>
		<td width="15%">
		&nbsp;
		</td>
		<td width="10%">
		&nbsp;
		</td>
</tr>
';
		
		
		$query = "SELECT * from subs ORDER by nom ASC";
		$result=mysql_query($query);
		
		while ($game=mysql_fetch_array($result)) {
		
		if ($game['goaler']==1) {
		$nom = $game['nom']." <b>(Gardien)</b>";
		} else {
		$nom = $game['nom'];
		}
		
		echo '
		<tr width="100%">
		<td width="30%">'.$nom.'</td>
		<td width="10%">'.$game['num1'].'</td>
		<td width="10%">'.$game['num2'].'</td>
		<td><a href="?edit=subs&id='.$game['id'].'">edit</a> | <a href="?del=subs&id='.$game['id'].'">del</a></td>
		</tr>
		';
		
		}
	echo '
	</table></p>

	';
	}
	
	
	if ($view == "points") {
echo '<p>
	<table width="100%">
		<tr width="100%">
		<td width="30%">
		<b>Date</b>
		</td>
		<td width="10%">
		<b>Heure</b>
		</td>
		<td width="10%">
		<b>&Eacute;quipe</b>
		</td>
		<td width="10%">
		&nbsp;
		</td>
</tr>
';
		
		
		$query = "SELECT * from game ORDER by date DESC";
		$result=mysql_query($query);
		
		while ($game=mysql_fetch_array($result)) {
		
		$q = "SELECT * from equipe WHERE id=".$game['eq1']."";
		$r=mysql_query($q);		
		$equipe1=mysql_fetch_array($r);
		
		$q1 = "SELECT * from equipe WHERE id=".$game['eq2']."";
		$r1=mysql_query($q1);		
		$equipe2=mysql_fetch_array($r1);
		$k = $game['id'];
		//echo $k;
		$sql_chk = "SELECT COUNT(*) FROM resultat WHERE id_game=$k";
		$req_chk = mysql_query($sql_chk) or die('Erreur SQL !<br>'.$sql_chk.'<br>'.mysql_error());
		$nb_chk = mysql_fetch_array($req_chk);
		$ok = 0;
		//echo "($nb_chk[0])";
		
		if ($nb_chk[0] > 0) {
			$ok = 1;
		}
		//echo "->".$nb_chk[0]." (  $ok ) ";
		$tmz = $equipe1['nom']." - ".$equipe2['nom'];
		
		
		echo '
		<tr width="100%">
		<td width="30%">'.$game['date'].'</td>
		<td width="10%">'.$game['heure'].'</td>
		<td width="10%">'.$tmz.'</td>
		';
		
		if ($ok != 1) {
		echo '
		<td><a href="?score='.$game['id'].'">entrez score</a></td>
		</tr>
		';
		} else {
		$k = $game['id'];
		
		$q3 = "SELECT * from resultat WHERE id_game='".$k."'";
		$r3=mysql_query($q3);		
		$resultz=mysql_fetch_array($r3);
		
		$pnt1 = $resultz['eq1_result'];
		$pnt2 = $resultz['eq2_result'];
		
		$q2 = "SELECT * from equipe WHERE id='".$resultz['winner']."'";
		$r2=mysql_query($q2);		
		$winz=mysql_fetch_array($r2);	
		
		$team = $winz['nom'];
		
		//echo $resultz['eq1_result'];
		
		echo '
		<td> | '.$pnt1.'-'.$pnt2.' pour '.$team.'</td>
		</tr>
		';
		}
		}
	echo '
	</table></p>

	';
	}
}

if(isset($_GET['add'])) {
	$add = $_GET['add'];
	
	if ($add == "game") {
	?>
<script language="JavaScript" src="pupdate.js">
</script>

<script language="JavaScript">
if (document.all) {
 document.writeln("<div id=\"PopUpCalendar\" style=\"position:absolute; left:0px; top:0px; z-index:7; width:200px; height:77px; overflow: visible; visibility: hidden; background-color: #FFFFFF; border: 1px none #000000\" onMouseOver=\"if(ppcTI){clearTimeout(ppcTI);ppcTI=false;}\" onMouseOut=\"ppcTI=setTimeout(\'hideCalendar()\',500)\">");
 document.writeln("<div id=\"monthSelector\" style=\"position:absolute; left:0px; top:0px; z-index:9; width:181px; height:27px; overflow: visible; visibility:inherit\">");}
else if (document.layers) {
 document.writeln("<layer id=\"PopUpCalendar\" pagex=\"0\" pagey=\"0\" width=\"200\" height=\"200\" z-index=\"100\" visibility=\"hide\" bgcolor=\"#FFFFFF\" onMouseOver=\"if(ppcTI){clearTimeout(ppcTI);ppcTI=false;}\" onMouseOut=\"ppcTI=setTimeout('hideCalendar()',500)\">");
 document.writeln("<layer id=\"monthSelector\" left=\"0\" top=\"0\" width=\"181\" height=\"27\" z-index=\"9\" visibility=\"inherit\">");}
else {
 document.writeln("<p><font color=\"#FF0000\"><b>SA PREND LE (*&*(& DE INTERNET EXPLORER ! ENTRE TA TITE DATE A MAIN.</b></font></p>");}
</script>
<noscript><p><font color="#FF0000"><b>JavaScript is not activated !</b></font></p></noscript>
<table border="1" cellspacing="1" cellpadding="2" width="200" bordercolorlight="#000000" bordercolordark="#000000" vspace="0" hspace="0"><form name="ppcMonthList"><tr><td align="center" bgcolor="#CCCCCC"><a href="javascript:moveMonth('Back')" onMouseOver="window.status=' ';return true;"><font face="Arial, Helvetica, sans-serif" size="2" color="#000000"><b>< </b></font></a><font face="MS Sans Serif, sans-serif" size="1"> 
<select name="sItem" onMouseOut="if(ppcIE){window.event.cancelBubble = true;}" onChange="switchMonth(this.options[this.selectedIndex].value)" style="font-family: 'MS Sans Serif', sans-serif; font-size: 9pt"><option value="0" selected>2000 • January</option><option value="1">2000 • February</option><option value="2">2000 • March</option><option value="3">2000 • April</option><option value="4">2000 • May</option><option value="5">2000 • June</option><option value="6">2000 • July</option><option value="7">2000 • August</option><option value="8">2000 • September</option><option value="9">2000 • October</option><option value="10">2000 • November</option><option value="11">2000 • December</option><option value="0">2001 • January</option></select></font><a href="javascript:moveMonth('Forward')" onMouseOver="window.status=' ';return true;"><font face="Arial, Helvetica, sans-serif" size="2" color="#000000"><b> ></b></font></a></td></tr></form></table>
<table border="1" cellspacing="1" cellpadding="2" bordercolorlight="#000000" bordercolordark="#000000" width="200" vspace="0" hspace="0"><tr align="center" bgcolor="#CCCCCC"><td width="20" bgcolor="#FFFFCC"><b><font face="MS Sans Serif, sans-serif" size="1">Su</font></b></td><td width="20"><b><font face="MS Sans Serif, sans-serif" size="1">Mo</font></b></td><td width="20"><b><font face="MS Sans Serif, sans-serif" size="1">Tu</font></b></td><td width="20"><b><font face="MS Sans Serif, sans-serif" size="1">We</font></b></td><td width="20"><b><font face="MS Sans Serif, sans-serif" size="1">Th</font></b></td><td width="20"><b><font face="MS Sans Serif, sans-serif" size="1">Fr</font></b></td><td width="20" bgcolor="#FFFFCC"><b><font face="MS Sans Serif, sans-serif" size="1">Sa</font></b></td></tr></table>
<script language="JavaScript">
if (document.all) {
 document.writeln("</div>");
 document.writeln("<div id=\"monthDays\" style=\"position:absolute; left:0px; top:52px; z-index:8; width:200px; height:17px; overflow: visible; visibility:inherit; background-color: #FFFFFF; border: 1px none #000000\"> </div></div>");}
else if (document.layers) {
 document.writeln("</layer>");
 document.writeln("<layer id=\"monthDays\" left=\"0\" top=\"52\" width=\"200\" height=\"17\" z-index=\"8\" bgcolor=\"#FFFFFF\" visibility=\"inherit\"> </layer></layer>");}
else {/*NOP*/}
</script>
	<p>
				<form method="post" name="send" id="send" action="?confirm=game">				
				<p>
				
				<label>&nbsp;Date</label>
				<input name="date" id="date" value="2007-MM-DD" type="text" size="30" /> <a href="#" onClick="getCalendarFor(document.send.date);return false">[Choisir une belle tite date]</a> <br/>
				<label>&nbsp;Heure</label>
				<SELECT name="heure" id="heure" ><OPTION value="20:00H">20:00H</OPTION><OPTION value="21:30H">21:30H</OPTION></SELECT><br/>
				<label>&nbsp;&Eacute;quipe 1: </label><SELECT name="equipe1" id="equipe1" ><OPTION value="1">1 - Rhesus PFP</OPTION><OPTION value="2">2 - Les blancs</OPTION><OPTION value="3">3 - L'évasion</OPTION><OPTION value="4">4 - Norampac</OPTION> </SELECT><br/>
				<label>&nbsp;&Eacute;quipe 2: </label><SELECT name="equipe2" id="equipe2" ><OPTION value="1">1 - Rhesus PFP</OPTION><OPTION value="2">2 - Les blancs</OPTION><OPTION value="3">3 - L'évasion</OPTION><OPTION value="4">4 - Norampac</OPTION> </SELECT><br/>
				

				<br />	
				<input class="button" value="Soumettre la requ&ecirc;te" type="submit" />		
				</p>		
				</form>		
	</p>
	<?
	}
	
	if ($add == "joueur") {
	?>
	<p>
				<form method="post" name="send" id="send" action="?confirm=joueur">				
				<p>
				
				<label>&nbsp;Prenom</label>
				<input name="prenom" id="prenom" type="text" size="30" /> <br/>
				<label>&nbsp;Nom</label>
				<input name="nom" id="nom" type="text" size="30" /> <br/>
				<label>&nbsp;Numero</label>
				<input name="num" id="num" type="text" size="30" /> <br/>
				
				<label>&nbsp;&Eacute;quipe: </label><SELECT name="equipe" id="equipe" ><OPTION value="1">1 - Rhesus PFP</OPTION><OPTION value="2">2 - Les blancs</OPTION><OPTION value="3">3 - L'évasion</OPTION><OPTION value="4">4 - Norampac</OPTION> </SELECT><br/>
				
				

				<br />	
				<input class="button" value="Soumettre la requ&ecirc;te" type="submit" />		
				</p>		
				</form>		
	</p>
	<?
	}
	
	if ($add == "subs") {
	?>
	<p>
				<form method="post" name="send" id="send" action="?confirm=subs">				
				<p>
				
				<label>&nbsp;Prenom</label>
				<input name="prenom" id="prenom" type="text" size="30" /> <br/>
				<label>&nbsp;Nom</label>
				<input name="nom" id="nom" type="text" size="30" /> <br/>
				<label>&nbsp;Numero de tel (maison)</label>
				<input name="num1" id="num1" value="XXX-XXX-XXXX" type="text" size="30" /> <br/>
				<label>&nbsp;Numero de tel (job/cell)</label>
				<input name="num2" id="num2" value="XXX-XXX-XXXX" type="text" size="30" /> <br/>
				<label>&nbsp;Est un goaler</label>
				<input type="checkbox" name="goaler" value="1" <? echo $goaler; ?> ><br>
				

				<br />	
				<input class="button" value="Soumettre la requ&ecirc;te" type="submit" />		
				</p>		
				</form>		
	</p>
	<?
	}
}

if(isset($_GET['confirm'])) {
	$confirm = $_GET['confirm'];
	
	if ($confirm == "game") {
	$date = $_POST['date'];
	$heure = $_POST['heure'];
	$equipe1 = $_POST['equipe1'];
	$equipe2 = $_POST['equipe2'];
	
	$req = "INSERT INTO game (id,date,heure,eq1,eq2) VALUES('','$date','$heure','$equipe1','$equipe2')";
	mysql_query($req);
	
	echo "<h3>REQUETE EFFECTUER AVEC SUCCES !</h3>";
	}
	
	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 "<h3>REQUETE EFFECTUER AVEC SUCCES !</h3>";
	}
	
	if ($confirm == "txt2") {

	$txt = $_POST['txt'];
	$txt  = addslashes($txt);
	
	$req = "UPDATE settings SET value='".$txt."' WHERE id=2";
	mysql_query($req);	
	
	echo "<h3>REQUETE EFFECTUER AVEC SUCCES !</h3>";
	}
	
	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 "<h3>REQUETE EFFECTUER AVEC SUCCES !</h3>";
	}

	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 "<h3>REQUETE EFFECTUER AVEC SUCCES !</h3>";
	}
	
	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 "<h3>REQUETE EFFECTUER AVEC SUCCES !</h3>";
	}
	
	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 "<h3>REQUETE EFFECTUER AVEC SUCCES !</h3>";
	}
	
	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 "<h3>REQUETE EFFECTUER AVEC SUCCES !</h3>";
	echo "Equipe 1: +".$point_id_1." points<br/>";
	echo "Equipe 2: +".$point_id_2." points<br/>";
		
	}
}

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 "<h3>REQUETE EFFECTUER AVEC SUCCES !</h3>";
	}
	
	if ($del == "joueur") {
	$id_joueur = $_GET['id'];
	$req = "DELETE from joueur WHERE id='$id_joueur'";
	mysql_query($req);
	echo "<h3>REQUETE EFFECTUER AVEC SUCCES !</h3>";
	}
	if ($del == "subs") {
	$id_joueur = $_GET['id'];
	$req = "DELETE from subs WHERE id='$id_joueur'";
	mysql_query($req);
	echo "<h3>REQUETE EFFECTUER AVEC SUCCES !</h3>";
	}
}

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);
	?>
	<p>
				<form method="post" name="send" id="send" action="?confirm=joueur2&id=<? echo $user_id; ?>">				
				<p>
				
				<label>&nbsp;Prenom</label>
				<input name="prenom" value="<? echo $joueur['prenom']; ?>" id="prenom" type="text" size="30" /> <br/>
				<label>&nbsp;Nom</label>
				<input name="nom" value="<? echo $joueur['nom']; ?>" id="nom" type="text" size="30" /> <br/>
				<label>&nbsp;Numero</label>
				<input name="num" value="<? echo $joueur['numero']; ?>" id="num" type="text" size="30" /> <br/>

				<br/>
				<h2>STATS PERSO</h2>
				
				<label>&nbsp;PJ</label>
				<input name="pj" value="<? echo $joueur['pj']; ?>" id="pj" type="text" size="10" /> <br/>
				<label>&nbsp;B</label>
				<input name="b" value="<? echo $joueur['b']; ?>" id="b" type="text" size="10" /> <br/>
				<label>&nbsp;A</label>
				<input name="a" value="<? echo $joueur['a']; ?>" id="a" type="text" size="10" /> <br/>
				<label>&nbsp;PTS</label>
				<input name="pts" value="<? echo $joueur['pts']; ?>" id="pts" type="text" size="10" /> <br/>
				<label>&nbsp;PUN</label>
				<input name="pun" value="<? echo $joueur['pun']; ?>" id="pun" type="text" size="10" /> <br/>
				

				<br />	
				<input class="button" value="Soumettre la requ&ecirc;te" type="submit" />		
				</p>		
				</form>		
	</p>
	<?
	}
	
	if ($edit == "subs") {
	
$q = "SELECT * from subs WHERE id=".$user_id."";
$r=mysql_query($q);		
$joueur=mysql_fetch_array($r);

		if ($joueur['goaler']==1) {
		$goaler = "checked";
		} else {
		$goaler = "";
		}
	?>
	<p>
				<form method="post" name="send" id="send" action="?confirm=subs2&id=<? echo $user_id; ?>">				
				<p>
				
				<label>&nbsp;Nom</label>
				<input name="nom" value="<? echo $joueur['nom'] ?>" id="prenom" type="text" size="30" /> <br/>
				<label>&nbsp;Numero de tel (maison)</label>
				<input name="num1" id="num1" value="<? echo $joueur['num1'] ?>" type="text" size="30" /> <br/>
				<label>&nbsp;Numero de tel (job/cell)</label>
				<input name="num2" id="num2" value="<? echo $joueur['num2'] ?>" type="text" size="30" /> <br/>
				<label>&nbsp;Est un goaler</label>
				<input type="checkbox" name="option2" value="Goaler"<? echo $goaler; ?> ><br>

				<br />	
				<input class="button" value="Soumettre la requ&ecirc;te" type="submit" />		
				</p>		
				</form>		
	</p>
	<?
	}
}

if(isset($_GET['score'])) {
$the_game = $_GET['score'];

$query = "SELECT * from game WHERE id=".$the_game."";
$result=mysql_query($query);
$game=mysql_fetch_array($result);

$q = "SELECT * from equipe WHERE id=".$game['eq1']."";
$r=mysql_query($q);		
$equipe1=mysql_fetch_array($r);

$q1 = "SELECT * from equipe WHERE id=".$game['eq2']."";
$r1=mysql_query($q1);		
$equipe2=mysql_fetch_array($r1);

// EQUIPE 1
$point_1 = $equipe1['nom'];
$id_1 = $equipe1['id'];

// EQUIPE 2
$point_2 = $equipe2['nom'];
$id_2 = $equipe2['id'];

	?>
	<p>
				<form method="post" action="?confirm=pointage">				
				<p>
				<h2>Première prériode</h2>
				<label>&nbsp;Gagnant</label>
				<SELECT name="winner_p1" id="winner_p1" >
				<?   if ($id_1 == 1 OR $id_2 == 1) { ?>
					<OPTION value="1">1 - Rhesus PFP (+1 point)</OPTION>
				<? } if ($id_1 == 2 OR $id_2 == 2) { ?>
					<OPTION value="2">2 - Les blancs (+1 point)</OPTION>
				<? } if ($id_1 == 3 OR $id_2 == 3) { ?>
					<OPTION value="3">3 - L'évasion (+1 point)</OPTION>
				<? } if ($id_1 == 4 OR $id_2 == 4) { ?>
					<OPTION value="4">4 - Norampac (+1 point)</OPTION> 
				<? } ?>
					<OPTION value="0">0 - Période null (+.5 point/chaque)</OPTION> 
				</SELECT><br/>	
				<h2>Deuxième prériode</h2>
				<label>&nbsp;Gagnant</label>
				<SELECT name="winner_p2" id="winner_p2" >
				<?   if ($id_1 == 1 OR $id_2 == 1) { ?>
					<OPTION value="1">1 - Rhesus PFP (+1 point)</OPTION>
				<? } if ($id_1 == 2 OR $id_2 == 2) { ?>
					<OPTION value="2">2 - Les blancs (+1 point)</OPTION>
				<? } if ($id_1 == 3 OR $id_2 == 3) { ?>
					<OPTION value="3">3 - L'évasion (+1 point)</OPTION>
				<? } if ($id_1 == 4 OR $id_2 == 4) { ?>
					<OPTION value="4">4 - Norampac (+1 point)</OPTION> 
				<? } ?>
					<OPTION value="0">0 - Période null (+.5 point/chaque)</OPTION> 
				</SELECT><br/>	
				<h2>Troisième prériode</h2>
				<label>&nbsp;Gagnant</label>
				<SELECT name="winner_p3" id="winner_p3" >
				<?   if ($id_1 == 1 OR $id_2 == 1) { ?>
					<OPTION value="1">1 - Rhesus PFP (+1 point)</OPTION>
				<? } if ($id_1 == 2 OR $id_2 == 2) { ?>
					<OPTION value="2">2 - Les blancs (+1 point)</OPTION>
				<? } if ($id_1 == 3 OR $id_2 == 3) { ?>
					<OPTION value="3">3 - L'évasion (+1 point)</OPTION>
				<? } if ($id_1 == 4 OR $id_2 == 4) { ?>
					<OPTION value="4">4 - Norampac (+1 point)</OPTION> 
				<? } ?>
					<OPTION value="0">0 - Période null (+.5 point/chaque)</OPTION> 
				</SELECT><br/>		
				<h2>Marque final</h2>				
				<label>&nbsp;Gagnant</label>
				<SELECT name="winner" id="winner" >
				<?   if ($id_1 == 1 OR $id_2 == 1) { ?>
					<OPTION value="1">1 - Rhesus PFP (+1 point)</OPTION>
				<? } if ($id_1 == 2 OR $id_2 == 2) { ?>
					<OPTION value="2">2 - Les blancs (+1 point)</OPTION>
				<? } if ($id_1 == 3 OR $id_2 == 3) { ?>
					<OPTION value="3">3 - L'évasion (+1 point)</OPTION>
				<? } if ($id_1 == 4 OR $id_2 == 4) { ?>
					<OPTION value="4">4 - Norampac (+1 point)</OPTION> 
				<? } ?>
					<OPTION value="0">0 - Partie null (+.5 point/chaque)</OPTION> 
				</SELECT><br/>
				<label>&nbsp;Marque final pour <? echo $point_1; ?></label>
				<input name="point_1" id="point_1" value="0" type="text" size="4"  /><br/>
				<label>&nbsp;Marque final pour <? echo $point_2; ?></label>
				<input name="point_2" id="point_2" value="0" type="text" size="4"  /><br/>
				<input name="team_id_1" id="team_id_1" value="<? echo $id_1; ?>" type="hidden" size="30"  />
				<input name="team_id_2" id="team_id_2" value="<? echo $id_2; ?>" type="hidden" size="30"  />
				<input name="game_id" id="game_id" value="<? echo $the_game; ?>" type="hidden" size="30"  />
				
				<br />	
				<b>VÉRIFIEZ AVANT D'ENREGISTREZ CAR TOUT EST CALCULÉ AUTOMATIQUEMENT.<br/>
				IMPOSSIBLE DE REVENIR EN ARRIÈRE. CAPITCH ?</b>
				<br/><br/>
				<input class="button" value="Enregistrer les pointages" type="submit" />		
				</p>		
				</form>		
	</p>
	<?
}
?>

</td>
</tr>
</table>
</div>