<?php
include ("inc/fonctions.inc.php");
if(db_cnx()==false)
{
   echo "problème de connexion";
}
//connexion à mysql réussi
else
{
@session_start();
$_SESSION["idDeSession"]=session_id();
$pwdKingd=md5($pwdKingd);
$passProv=md5($passProv);
$verifKgd="SELECT id_kingd, noKingd, pwdKingd FROM kingdoms WHERE noKingd=\"$noKingd\"";
$verifProv="SELECT id, provName, passProv, id_kingd, monarch FROM membres WHERE provName=\"$provName\"";
$resKgd = mysql_query($verifKgd);
$resProv = mysql_query($verifProv);

    while ($val = @mysql_fetch_array($resKgd))
    { 
   $noKgdBase=$val["noKingd"];
   $KgdPassBase=$val["pwdKingd"];
   $KgdId=$val["id_kingd"];
   $_SESSION["idKgd"]=$KgdId;
   }
   
   while ($val = @mysql_fetch_array($resProv))
    { 
   $ProvBase=$val["provName"];
   $ProvPassBase=$val["passProv"];
   $ProvIdKgd=$val["id_kingd"];
   $ProvId=$val["id"];
   $IsMonarch=$val["monarch"];
   $_SESSION["idPrv"]=$ProvId;
   $_SESSION["monarch"]=$IsMonarch;
   }
   
   echo "TEST DE VALEURS VARIABLES!!!<br><br>$pwdKingd<br>$passProv<br>$noKingd<br>$noKgdBase<br>$KgdPassBase<br>
        $KgdId<br>$provName<br>$ProvBase<br>$ProvPassBase<br>$ProvIdKgd<br><br><br><br>";
       
   $goodKgd=0;
   $goodKgdPass=0;
   $goodProvName=0;
   $goodProvPass=0;
   $ProvDansKgd=0;
   $err=0;
   
   if($noKgdBase==$noKingd)
      {
      $goodKgd=1;
      }
   if($KgdPassBase==$pwdKingd)
      {
      $goodKgdPass=1;
      }
   if($ProvBase==$provName)
      {
      $goodProvName=1;
      }
   if($ProvPassBase==$passProv)
      {
      $goodProvPass=1;
      }
   if($KgdId!=$ProvIdKgd)
      {
      $err=1;
      }
      
   if(($goodKgd==1)&&($goodKgdPass==1))
      {
      $_SESSION["kingd"]=$KgdBase;
      }
   else
      {
      $err=2;
      }
   if(($goodProvName==1)&&($goodProvPass==1))
      {
      $_SESSION["prov"]=$ProvBase;
      }
   else
      {
      $err=3;
      }
      
   if($err==1)
      {
      echo "But you are not a part of that kingdom!";
      }
   elseif($err==2)
      {
      echo "Not the good Kingdom infos!";
      }
   elseif($err==3)
      {
      ECHO "Not the good province infos!";
      }
   else
      {
      echo "The login / pass for the kingdom are ok<br>";
      echo "The login / pass for your province is ok<br><br>";
      $_SESSION["ProvKgd"]=1;
      echo "<a href='main.php'>Click here to continu into the system</a>";
      }
   $kgd=$_SESSION["kingd"];
   echo "$kgd";
   
}


?>

<?php
session_start();
include ("inc/fonctions.inc.php");
if(db_cnx()==false)
{
   echo "problème de connexion";
}
//connexion à mysql réussi
else
{
//ID DE SESSIONL $_SESSION["idDeSession"] ---Id de KGD dans la base: $_SESSION["idKgd"]---Id de province:$_SESSION["idPrv"]---
//Si il est monarch:$_SESSION["monarch"]---No de KGD: $_SESSION["kingd"]---nom de prov: $_SESSION["prov"]---
//si la prov est dnas le bon kingdom: $_SESSION["ProvKgd"]
$kgd=$_SESSION["kingd"];
//$sqlkGDInfos="SELECT * FROM kingdoms"
if($_SESSION["monarch"]==1)
   {
   echo "Welcome to the Utopia Out Of Kingdom Interactions Utility! (What a name!)<br>";
   echo "As the monarch of $kgd, we grant you administrators privileges.<br><br><hr>";
   echo "Modify you're kingdom informations'";
   }
else
   {
      echo "Welcome to the Utopia Out Of Kingdom Interactions Utility! (What a name!)";
   }

}


?>