<?php

define('DEBUG', FALSE);
//a faire en fonction de la variable DEBUG, avec ou sans message d'erreurs de la BDD
define('BD_ADRESSE', 'localhost');
define('BD_USER', 'root');
define('BD_PASS', '');
define('BD_NOM', 'villededragons');

function connectionBDD(){
	$bdd =	@mysql_connect(BD_ADRESSE,BD_USER,BD_PASS) or exit('erreur de connection...');
			@mysql_select_db(BD_NOM)or exit('pb de Base de données...');
}

function check_id($login,$pass){
	connectionBDD();
	$login = addslashes($login);
	$pass = addslashes($pass);

	$resultat = mysql_query("SELECT id_login FROM login WHERE login = '".$login."' AND password = '".$pass."'")or exit('Erreur ' . mysql_errno() . ' : ' . mysql_error());
	if(mysql_num_rows($resultat) == 0){
		$usr_id=-1;
	}else{
		$tableauReponse = mysql_fetch_assoc($resultat);
		$usr_id = $tableauReponse['id_login'];
	}
	mysql_close();
	return $usr_id;
}

function creation_id($login,$pass){
	connectionBDD();
	$login = addslashes($login);
	$pass = addslashes($pass);
	$date = date("Y-m-d");

	mysql_query("INSERT	INTO login(login,password,Date_creation) VALUES('".$login."','".$pass."','".$date."')")or exit('Erreur ' . mysql_errno() . ' : ' . mysql_error());
	mysql_close();
}

function creationSorcier(){}


function existe_Log($login){
	connectionBDD();
	$login = addslashes($login);
	$resultat = mysql_query("SELECT id_login FROM login WHERE login = '".$login."'")or exit('Erreur ' . mysql_errno() . ' : ' . mysql_error());
	if(mysql_num_rows($resultat) == 0){
		$existe = false;
	}else{
		$existe = true;
	}
	mysql_close();
	return $existe;

}

function check_session(){
	if(!session_is_registered("user_id")){
		header("location: index.php");
	}
}

function check_ChaineDeCaracteres($chaine){
	set_magic_quotes_runtime(0);
	//1er caractere en majuscule
	$chaineMaj = ucfirst($chaine);
	//verificatitions des balises HTML
	$pos = strpos($chaineMaj,'<');
	if($pos !== FALSE){
		return(0);
	}else{
		//test sur la configuration du serveur pour l'utilisation de l'echappement avec les antiSlash
		if (get_magic_quotes_gpc() == 1){
			return $chaine;
		}else{
			$chaineBonneGuillemets = addslashes($chaine);
			return ($chaineBonneGuillemets);
		}
	}
}

function HTML_ChaineDeCaracteres($chaine){
	return (htmlspecialchars($chaine,ENT_QUOTES));
}
/****************************************************************************************************************/
/**************************************  FONCTIONS PROPRES AU JEU  **********************************************/
/****************************************************************************************************************/
function ChangementEnergie($nb,$retrait){
	if($retrait == 0){
		$_SESSION['FatigueActuelle'] += $nb;
		if($_SESSION['FatigueActuelle']>$_SESSION['FatigueMax']){
			$_SESSION['FatigueActuelle']=$_SESSION['FatigueMax'];
		}
	}else{
		$_SESSION['FatigueActuelle'] -= $nb;
		if($_SESSION['FatigueActuelle']<0){
			$_SESSION['FatigueActuelle']=0;
		header("location: fatigue.php");
		}
	}
}
function ChangementVie($nb,$retrait){
	if($retrait == 0){
		$_SESSION['VitActuelleAug'] += $nb;
		$_SESSION['VitActuelle'] += $nb;
		if($_SESSION['VitActuelleAug']>$_SESSION['VitAug']){
			$_SESSION['VitActuelleAug']=$_SESSION['VitAug'];
		}
		if($_SESSION['VitActuelle']>$_SESSION['Vit']){
			$_SESSION['VitActuelle']=$_SESSION['Vit'];
		}
	}else{
		$_SESSION['VitActuelleAug'] -= $nb;
		$_SESSION['VitActuelle'] -= $nb;
		if($_SESSION['VitActuelle']<0){
			$_SESSION['VitActuelle']=0;
		}
		if($_SESSION['VitActuelleAug']<0){
			$_SESSION['VitActuelleAug']=0;
		header("location: mort.php");
		}
	}
}
function ChangementEnergieCombat($nb,$retrait,$lequel){
    if($lequel==0){
	    //on enleve de l'energie a l'ennemi
	    if($retrait == 0){
		    $_SESSION['ennemiFatigue'] += $nb;
		    if($_SESSION['ennemiFatigue']>$_SESSION['ennemiFatigueMax']){
			    $_SESSION['ennemiFatigue']=$_SESSION['ennemiFatigueMax'];
		    }
	    }else{
		    $_SESSION['ennemiFatigue'] -= $nb;
		    if($_SESSION['ennemiFatigue']<0){
			    $_SESSION['ennemiFatigue']=0;
		    }
	    }
    }else{
	    //on enleve de l'energie au perso
	    if($retrait == 0){
		    $_SESSION['FatigueActuelle'] += $nb;
		    if($_SESSION['FatigueActuelle']>$_SESSION['FatigueMax']){
			    $_SESSION['FatigueActuelle']=$_SESSION['FatigueMax'];
		    }
	    }else{
		    $_SESSION['FatigueActuelle'] -= $nb;
		    if($_SESSION['FatigueActuelle']<0){
			    $_SESSION['FatigueActuelle']=0;
		    }
	    }
    }
}
function ChangementPoids($AlimentTresNutritif){
	if($AlimentTresNutritif == 0){
	$_SESSION['Poids']++;
	}elseif($AlimentTresNutritif == 1){
	$_SESSION['Poids']--;
	}
	if($_SESSION['Poids']>5){
		$_SESSION['Poids']=5;
	}else if($_SESSION['Poids']<1){
		$_SESSION['Poids']=1;
	}
}
function ChangementOr($combien,$retrait){
	if($retrait==0){
	$_SESSION['Or'] += $combien;
	}else{
	$_SESSION['Or'] -= $combien;
	}
}
function ChangementVariableHistoire($laquelle,$valeur){
	mysql_query("UPDATE histoire SET ".$laquelle."='".$valeur."' WHERE id = '".$_SESSION['id']."'")or exit('Erreur ' . mysqli_errno() . ' : ' . mysqli_error());
}

function ChangementHeureJournee(){
	//raz des encas qui font changer de journee
	$_SESSION['enCas'] = 1;
	//augmentation du compteur de l'heure de la journée
	$_SESSION['repas']++;
		//test pour savoir si on change de journée
		if($_SESSION['repas']>3){
			$_SESSION['repas']=0;
			$_SESSION['Age']++;
			$_SESSION['couple']=0;
		}
}

function SauvegardeHistoire(){
	$chaine = check_ChaineDeCaracteres($_SESSION['passeHeroique']);
	$req = 'UPDATE sorcier SET passeHeroiqueSorcier = "'.$chaine.'" WHERE id = "'.$_SESSION["id"].'"';
	mysql_query($req)or exit('Erreur ' . mysqli_errno() . ' : ' . mysqli_error());
}

function Sauvegarde($endroit){
	//remise a zero des compteurs encas et boissons
	$_SESSION['biereBu'] = 0;
	if($endroit==1){
		//ca ne marche que pour le moment ou l'on dort dans la taverne...
		ChangementHeureJournee();
	}
	CalculAugmentationCarac();
	//insertion des nouvelles caracteristiques
	$req = "UPDATE sorcier SET Niveau = '".$_SESSION['Niveau']."' ,"
			."Intelligence = '".$_SESSION['Int']."' ,"
			."Vitalite = '".$_SESSION['Vit']."' ,"
			."Forc = '".$_SESSION['For']."' ,"
			."Charisme = '".$_SESSION['Cha']."' ,"
			."Dexterite = '".$_SESSION['Dex']."' ,"
			."Sagesse = '".$_SESSION['Sag']."' ,"
			."VitActuelle = '".$_SESSION['VitActuelle']."' ,"
			."FatigueMax = '".$_SESSION['FatigueMax']."' ,"
			."FatigueActuelle = '".$_SESSION['FatigueActuelle']."' ,"
			."PiecesOr = '".$_SESSION['Or']."' ,"
			."Poids = '".$_SESSION['Poids']."' ,"
			."Age = '".$_SESSION['Age']."' ,"
			."Dieu = '".$_SESSION['Dieu']."' ,"
			."Heure= '".$_SESSION['repas']."' ,"
			."N_pomme = '".$_SESSION['N_pomme']."' ,"
			."N_viandeSeche = '".$_SESSION['N_viandeSeche']."' ,"
			."N_orange = '".$_SESSION['N_orange']."' ,"
			."N_pain = '".$_SESSION['N_pain']."' ,"
			."N_chocolat = '".$_SESSION['N_chocolat']."' ,"
			."N_lait = '".$_SESSION['N_lait']."' ,"
			."experience = '".$_SESSION['xp']."' ,"
			."experienceMax = '".$_SESSION['xpMax']."'"
			." WHERE id = '".$_SESSION['id']."'";
	CalculCaractAugmentee(TRUE);
	//insertion des nouvelles valeurs de l'histoire
	$req2 = "UPDATE histoire SET taverne= '".$_SESSION['taverne']."' ,"
			."taverneRumeur= '".$_SESSION['taverneRumeur']."',"
			."taverneRat= '".$_SESSION['taverneRat']."' ,"
			."arrivee= '".$_SESSION['arrivee']."' ,"
			."erudit= '".$_SESSION['erudit']."' ,"
			."pretre= '".$_SESSION['pretre']."' ,"
			."egliseRumeur= '".$_SESSION['egliseRumeur']."' ,"
			."egliseZombis= '".$_SESSION['egliseZombis']."' ,"
			."joueurs= '".$_SESSION['joueurs']."' ,"
			."nains= '".$_SESSION['nains']."' ,"
			."nainsHumeur= '".$_SESSION['nainsHumeur']."' ,"
			."nudite= '".$_SESSION['nudite']."' ,"
			."couple= '".$_SESSION['couple']."' ,"
			."bagueMaisonCouple= '".$_SESSION['bagueMaisonCouple']."' ,"
			."tavernier= '".$_SESSION['tavernier']."' ,"
			."forgeron= '".$_SESSION['forgeron']."' ,"
			."Sauvegarde= '".$endroit."'"
			." WHERE id = '".$_SESSION['id']."'";
	//insertion des nouveaux ou anciens objets
	$req3 = "UPDATE sac SET id_objets1 = '".$_SESSION['objets1']."' ,"
			."id_objets2 = '".$_SESSION['objets2']."' ,"
			."id_objets3 = '".$_SESSION['objets3']."' ,"
			."id_objets4 = '".$_SESSION['objets4']."'"
			."WHERE id_sorcier = '".$_SESSION['id']."'";
	//insertion des nouveaux ou anciens equipement
	$req4 = "UPDATE equipement SET id_tete = '".$_SESSION['tete']."' ,"
			."id_mainGauche = '".$_SESSION['mainGauche']."' ,"
			."id_mainDroite = '".$_SESSION['mainDroite']."' ,"
			."id_corps = '".$_SESSION['corps']."' ,"
			."id_mains = '".$_SESSION['mains']."' ,"
			."id_jambes = '".$_SESSION['jambes']."' ,"
			."id_pieds = '".$_SESSION['pieds']."' ,"
			."id_doigt1 = '".$_SESSION['doigt1']."' ,"
			."id_doigt2 = '".$_SESSION['doigt2']."' ,"
			."Sac = '".$_SESSION['sac']."'"
			."WHERE id_sorcier = '".$_SESSION['id']."'";

	mysql_query($req)or exit('Erreur ' . mysqli_errno() . ' : ' . mysqli_error());
	mysql_query($req2)or exit('Erreur ' . mysqli_errno() . ' : ' . mysqli_error());
	mysql_query($req3)or exit('Erreur ' . mysqli_errno() . ' : ' . mysqli_error());
	mysql_query($req4)or exit('Erreur ' . mysqli_errno() . ' : ' . mysqli_error());

}
function AfficheBarreDEtat($pageactuelle){
	echo "<table border='0' cellspacing='0' cellpadding='0' align='center'>"
		."<tr>"
		."<td align='center' width= '225'><B>POINTS DE VIE: </B>".$_SESSION['VitActuelleAug']."/".$_SESSION['VitAug']." ";
	AfficheImgBarre(0,$_SESSION['VitActuelleAug'],$_SESSION['VitAug']);
	echo "</td>"
		."<td align='center' width= '225'><B>FATIGUE: </B>".$_SESSION['FatigueActuelle']."/".$_SESSION['FatigueMax']." ";
	AfficheImgBarre(1,$_SESSION['FatigueActuelle'],$_SESSION['FatigueMax']);
	echo "</td>"
		."<td align='center' width='225'><B>OR: </B>".$_SESSION['Or']." pièces.<BR>";
		if($pageactuelle==0){
		echo "<A href=FicheDEtat.php>Fiche De ".$_SESSION['Prenom']."</a>";
		}
	echo "</td>"
		."</tr>"
		."</table>";
}
function AfficheImgBarre($QuelleBarre,$Actuel,$Max){
	switch($QuelleBarre){
		case 0:
		$image="images/barreHP.gif";
		break;
		case 1:
		$image="images/barreFatigue.gif";
		break;
		case 2:
		$image="images/barreXp.gif";
		break;
	}
	echo "<table border='0' cellspacing='0' cellpadding='0' align='center'>"
		."<tr>";
	$nbVie= round((100*$Actuel)/$Max)*2;
			echo "<td>"
				."<img src=".$image."  width='".$nbVie."px' height='9px'>"
				."</td>";
	$nbMort= (200-$nbVie);
			echo "<td>"
				."<img src=images/barre.gif width='".$nbMort."px' height='9px'>"
				."</td>";
	echo "</tr>"
		."</table>";
}
function typeAliment($nbAliment){
	switch($nbAliment){
	case 1:
		return("fruit");
	break;
	case 2:
		return("protéine");
	break;
	case 3:
		return("agrume");
	break;
	case 4:
		return("feculent");
	break;
	case 5:
		return("gourmandise");
	break;
	case 6:
		return("laitage");
	break;
	}

}
function CalculAugmentationCarac(){
				//mise a zero des augmentation de caracteristiques
	$_SESSION['Aug_Int'] = 0;
	$_SESSION['Aug_For'] = 0;
	$_SESSION['Aug_Vit'] = 0;
	$_SESSION['Aug_Cha'] = 0;
	$_SESSION['Aug_Dex'] = 0;
	$_SESSION['Aug_Sag'] = 0;
		//ajout des augmentation des caracteristiques
			//sur le corps
	$req = "SELECT aug_Int,aug_For,aug_Vit,aug_Cha,aug_Dex,aug_Sag FROM corps WHERE id_corps='".$_SESSION['corps']."'";
	$resultat = mysql_query($req)or exit('Erreur ' . mysqli_errno() . ' : ' . mysqli_error());

	$tableauReponse=mysqli_fetch_assoc($resultat);
	$_SESSION['Aug_Int'] += $tableauReponse['aug_Int'];
	$_SESSION['Aug_For'] += $tableauReponse['aug_For'];
	$_SESSION['Aug_Vit'] += $tableauReponse['aug_Vit'];
	$_SESSION['Aug_Cha'] += $tableauReponse['aug_Cha'];
	$_SESSION['Aug_Dex'] += $tableauReponse['aug_Dex'];
	$_SESSION['Aug_Sag'] += $tableauReponse['aug_Sag'];
			//sur les doigts de la main gauche
	$req = "SELECT aug_Int,aug_For,aug_Vit,aug_Cha,aug_Dex,aug_Sag FROM doigt WHERE id_doigt='".$_SESSION['doigt1']."'";
	$resultat = mysql_query($req)or exit('Erreur ' . mysqli_errno() . ' : ' . mysqli_error());

	$tableauReponse=mysqli_fetch_assoc($resultat);
	$_SESSION['Aug_Int'] += $tableauReponse['aug_Int'];
	$_SESSION['Aug_For'] += $tableauReponse['aug_For'];
	$_SESSION['Aug_Vit'] += $tableauReponse['aug_Vit'];
	$_SESSION['Aug_Cha'] += $tableauReponse['aug_Cha'];
	$_SESSION['Aug_Dex'] += $tableauReponse['aug_Dex'];
	$_SESSION['Aug_Sag'] += $tableauReponse['aug_Sag'];
			//sur les doigts de la main droite
	$req = "SELECT aug_Int,aug_For,aug_Vit,aug_Cha,aug_Dex,aug_Sag FROM doigt WHERE id_doigt='".$_SESSION['doigt2']."'";
	$resultat = mysql_query($req)or exit('Erreur ' . mysqli_errno() . ' : ' . mysqli_error());

	$tableauReponse=mysqli_fetch_assoc($resultat);
	$_SESSION['Aug_Int'] += $tableauReponse['aug_Int'];
	$_SESSION['Aug_For'] += $tableauReponse['aug_For'];
	$_SESSION['Aug_Vit'] += $tableauReponse['aug_Vit'];
	$_SESSION['Aug_Cha'] += $tableauReponse['aug_Cha'];
	$_SESSION['Aug_Dex'] += $tableauReponse['aug_Dex'];
	$_SESSION['Aug_Sag'] += $tableauReponse['aug_Sag'];
			//sur les jambes
	$req = "SELECT aug_Int,aug_For,aug_Vit,aug_Cha,aug_Dex,aug_Sag FROM jambes WHERE id_jambes='".$_SESSION['jambes']."'";
	$resultat = mysql_query($req)or exit('Erreur ' . mysqli_errno() . ' : ' . mysqli_error());

	$tableauReponse=mysqli_fetch_assoc($resultat);
	$_SESSION['Aug_Int'] += $tableauReponse['aug_Int'];
	$_SESSION['Aug_For'] += $tableauReponse['aug_For'];
	$_SESSION['Aug_Vit'] += $tableauReponse['aug_Vit'];
	$_SESSION['Aug_Cha'] += $tableauReponse['aug_Cha'];
	$_SESSION['Aug_Dex'] += $tableauReponse['aug_Dex'];
	$_SESSION['Aug_Sag'] += $tableauReponse['aug_Sag'];
			//sur la main Droite
	$req = "SELECT aug_Int,aug_For,aug_Vit,aug_Cha,aug_Dex,aug_Sag FROM maindroite WHERE id_maindroite='".$_SESSION['mainDroite']."'";
	$resultat = mysql_query($req)or exit('Erreur ' . mysqli_errno() . ' : ' . mysqli_error());

	$tableauReponse=mysqli_fetch_assoc($resultat);
	$_SESSION['Aug_Int'] += $tableauReponse['aug_Int'];
	$_SESSION['Aug_For'] += $tableauReponse['aug_For'];
	$_SESSION['Aug_Vit'] += $tableauReponse['aug_Vit'];
	$_SESSION['Aug_Cha'] += $tableauReponse['aug_Cha'];
	$_SESSION['Aug_Dex'] += $tableauReponse['aug_Dex'];
	$_SESSION['Aug_Sag'] += $tableauReponse['aug_Sag'];
			//sur la main gauche
	$req = "SELECT aug_Int,aug_For,aug_Vit,aug_Cha,aug_Dex,aug_Sag FROM maingauche WHERE id_maingauche='".$_SESSION['mainGauche']."'";
	$resultat = mysql_query($req)or exit('Erreur ' . mysqli_errno() . ' : ' . mysqli_error());

	$tableauReponse=mysqli_fetch_assoc($resultat);
	$_SESSION['Aug_Int'] += $tableauReponse['aug_Int'];
	$_SESSION['Aug_For'] += $tableauReponse['aug_For'];
	$_SESSION['Aug_Vit'] += $tableauReponse['aug_Vit'];
	$_SESSION['Aug_Cha'] += $tableauReponse['aug_Cha'];
	$_SESSION['Aug_Dex'] += $tableauReponse['aug_Dex'];
	$_SESSION['Aug_Sag'] += $tableauReponse['aug_Sag'];
		//sur les mains
	$req = "SELECT aug_Int,aug_For,aug_Vit,aug_Cha,aug_Dex,aug_Sag FROM mains WHERE id_mains='".$_SESSION['mains']."'";
	$resultat = mysql_query($req)or exit('Erreur ' . mysqli_errno() . ' : ' . mysqli_error());

	$tableauReponse=mysqli_fetch_assoc($resultat);
	$_SESSION['Aug_Int'] += $tableauReponse['aug_Int'];
	$_SESSION['Aug_For'] += $tableauReponse['aug_For'];
	$_SESSION['Aug_Vit'] += $tableauReponse['aug_Vit'];
	$_SESSION['Aug_Cha'] += $tableauReponse['aug_Cha'];
	$_SESSION['Aug_Dex'] += $tableauReponse['aug_Dex'];
	$_SESSION['Aug_Sag'] += $tableauReponse['aug_Sag'];
			//sur les pieds
	$req = "SELECT aug_Int,aug_For,aug_Vit,aug_Cha,aug_Dex,aug_Sag FROM pieds WHERE id_pieds='".$_SESSION['pieds']."'";
	$resultat = mysql_query($req)or exit('Erreur ' . mysqli_errno() . ' : ' . mysqli_error());

	$tableauReponse=mysqli_fetch_assoc($resultat);
	$_SESSION['Aug_Int'] += $tableauReponse['aug_Int'];
	$_SESSION['Aug_For'] += $tableauReponse['aug_For'];
	$_SESSION['Aug_Vit'] += $tableauReponse['aug_Vit'];
	$_SESSION['Aug_Cha'] += $tableauReponse['aug_Cha'];
	$_SESSION['Aug_Dex'] += $tableauReponse['aug_Dex'];
	$_SESSION['Aug_Sag'] += $tableauReponse['aug_Sag'];
			//sur la tete

	$req = "SELECT aug_Int,aug_For,aug_Vit,aug_Cha,aug_Dex,aug_Sag FROM tete WHERE id_tete='".$_SESSION['tete']."'";
	$resultat = mysql_query($req)or exit('Erreur ' . mysqli_errno() . ' : ' . mysqli_error());

	$tableauReponse=mysqli_fetch_assoc($resultat);
	$_SESSION['Aug_Int'] += $tableauReponse['aug_Int'];
	$_SESSION['Aug_For'] += $tableauReponse['aug_For'];
	$_SESSION['Aug_Vit'] += $tableauReponse['aug_Vit'];
	$_SESSION['Aug_Cha'] += $tableauReponse['aug_Cha'];
	$_SESSION['Aug_Dex'] += $tableauReponse['aug_Dex'];
	$_SESSION['Aug_Sag'] += $tableauReponse['aug_Sag'];

}
function CalculCaractAugmentee($var){
	$_SESSION['IntAug'] = $_SESSION['Aug_Int'] + $_SESSION['Int'];
	$_SESSION['VitAug'] = $_SESSION['Aug_Vit'] + $_SESSION['Vit'];
	$_SESSION['ForAug'] = $_SESSION['Aug_For'] + $_SESSION['For'];
	$_SESSION['SagAug'] = $_SESSION['Aug_Sag'] + $_SESSION['Sag'];
	$_SESSION['ChaAug'] = $_SESSION['Aug_Cha'] + $_SESSION['Cha'];
	$_SESSION['DexAug'] = $_SESSION['Aug_Dex'] + $_SESSION['Dex'];
	if($var == TRUE){
		$_SESSION['VitActuelleAug'] = $_SESSION['Aug_Vit'] + $_SESSION['VitActuelle'];
	}
}
function maxCent($variable){
	if ($variable> 100){
		return(100);
	}else if($variable<1){
		return(1);
	}else{
		return($variable);
	}
}
function recuperationNomObjetLaisser($id){
	$req = "SELECT nom FROM objets WHERE id_objets='".$id."'";
	$sql = mysql_query($req)or exit('Erreur ' . mysqli_errno() . ' : ' . mysqli_error());
	$data = mysql_fetch_row($sql);
	return $data[0];
}

function ChangementTexteSexe($homme,$femme){
	if($_SESSION['Sexe']==1){
		return $homme;
	}else{
		return $femme;
	}
}
?>