<?php
include ('logue.php'); 
include ('entete2.php');
include ('ressource.php');
include ('entete.php');
echo"
<STYLE TYPE=text/css>
.Style1 {color: #0000FF}
.Style2 {color: #FF0000}
input {
border:1px solid #7E7E7E;
background-color:#000000;
font-family:'trebuchet ms',sans-serif;
color:white;
}
textarea {
border:1px solid #7E7E7E;
background-color:#000000;
font-family:'trebuchet ms',sans-serif;
color:white;
}
select, option {
background-color:#000000;
color:white;
}
</STYLE>";
echo"<div align=\"center\"><form name=\"colo\" method=\"post\" action=\"colonie.php\" target=\"_parent\">
<table align=\"center\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">
   <tr>
     <td width=\"100\" rowspan=\"2\" valign=\"middle\">
       <div align=\"center\">
         <input name=\"page\" value=\"" . $PHP_SELF . "\" type=\"hidden\" id=\"page\">
         <select name=\"idcolo\" onchange=submit()>";
include ('colo2.php'); 

$sql2 = "SELECT ally,statut FROM matgraph_users WHERE id='$idlogin'";
$res2 = db_mysql_Query($sql2)or die('erreur sql<br>'.$sql2.'<br>'.mysql_error());
$row2 = mysql_fetch_array($res2);

$sql_options = "SELECT recrutement FROM matgraph_ally_statut WHERE id='$row2[statut]'";
$res_options = db_mysql_Query($sql_options)or die('erreur sql<br>'.$sql_options.'<br>'.mysql_error());
$row_options = mysql_fetch_array($res_options); 

if($row2[ally] == "no") {
	echo '<script language="javascript" type="text/javascript">
	<!--
	window.location.replace("ally_index.php");
	-->
	</script>';
	exit;
}


$req = "SELECT * FROM matgraph_ally_recrut WHERE idally = $row2[ally]";
$res = db_mysql_Query($req) or die('Erreur SQL! <br>'.$req.'<br>'.mysql_error());
$num = mysql_num_rows($res);

if ( $num == 0) {
	echo '<script language="javascript" type="text/javascript">
	<!--
	window.location.replace("ally_index.php");
	-->
	</script>';
	exit;
}

if($row2[statut] !== "0" AND $row_options[recrutement] == "1" OR $row2[statut] == "-1") {

	$idally = htmlentities ($_POST["idally"]);
	$idjoueur = htmlentities ($_POST["idjoueur"]);
	$msg2 = htmlentities ($_POST["msg"]);


	if($idally != $row2[ally]) {
		echo '<script language="javascript" type="text/javascript">
		<!--
		window.location.replace("ally_index.php");
		-->
		</script>';
		exit;
	}

	$req = "SELECT * FROM matgraph_ally_recrut WHERE idjoueur = '$idjoueur' AND idally='$row2[ally]'";
	$res = db_mysql_Query($req) or die('Erreur SQL! <br>'.$req.'<br>'.mysql_error());
	$num = mysql_num_rows($res);

	if ( $num == 0) {
		echo '<script language="javascript" type="text/javascript">
		<!--
		window.location.replace("ally_index.php");
		-->
		</script>';
		exit;
	}

	$sql = "SELECT nom,tag FROM matgraph_ally WHERE id='$idally'";
	$res = db_mysql_Query($sql)or die('erreur sql<br>'.$sql.'<br>'.mysql_error());
	$row = mysql_fetch_array($res); 

	$sujet = "Recrutement accepté.";
	$msg = "";
	$msg.= "L'alliance $row[nom] ($row[tag]) a accepter votre demmande de recrutement.";
	if (!empty($msg2) )
	  $msg.="<br>Message de bienvenue : <br>$msg2";
  
	$msg2 = addslashes($msg);  
	$requete = "INSERT INTO matgraph_msgally VALUES ('', now(), 'non', '$idjoueur', '$sujet', '$msg2')";
	$resultat = db_mysql_Query($requete)or die('erreur sql<br>'.$requete.'<br>'.mysql_error());

	$sql4 = "DELETE FROM matgraph_ally_recrut WHERE idally = $idally AND idjoueur = $idjoueur";
	$res4 = db_mysql_Query($sql4)or die('erreur sql<br>'.$sql4.'<br>'.mysql_error());

	$requete = "UPDATE matgraph_users SET ally=$idally WHERE id='$idjoueur'";
	$resultat = db_mysql_Query($requete)or die('erreur sql<br>'.$requete.'<br>'.mysql_error());

	$req = "SELECT * FROM matgraph_ally_recrut WHERE idally = $idally";
	$res = db_mysql_Query($req) or die('Erreur SQL! <br>'.$req.'<br>'.mysql_error());
	$num = mysql_num_rows($res);
	if ( $num == 0) {
		echo '<script language="javascript" type="text/javascript">
		<!--
		window.location.replace("ally_index.php");
		-->
		</script>';
		exit;
	}
	else {
		echo '<script language="javascript" type="text/javascript">
		<!--
		window.location.replace("ally_demmande_recrut.php");
		-->
		</script>';
	}
}
else {
	echo '<script language="javascript" type="text/javascript">
	<!--
	window.location.replace("ally_index.php");
	-->
	</script>';
	exit;
}
?>


