Version beta_old1 (sans la doc) 2007-02-22+15:00 - 2007-03-11+16:41:00

1 files changed, 13 insertions, 13 deletions

diff --git a/beta_old1/app/include/je.inc.php b/beta_old1/app/include/je.inc.php
index 3c87753..dcbb75e 100644
--- a/beta_old1/app/include/je.inc.php
+++ b/beta_old1/app/include/je.inc.php
@@ -25,13 +25,13 @@ require_once ('include/connect.inc.php');
 	
 	function list_delete($idL)
 	{
-		$result = mysql_query("DELETE FROM Appartenir WHERE idL=$idL;");
-		$result = mysql_query("DELETE FROM Liste WHERE idL=$idL;");
+		$result = mysql_query("DELETE FROM AWOR_Appartenir WHERE idL=$idL;");
+		$result = mysql_query("DELETE FROM AWOR_Liste WHERE idL=$idL;");
 	}
 	
 	function list_new($listname,$idP,$isPrivate)
 	{
-		$result = mysql_query("INSERT INTO Liste (libelleL,estPrivee,idP_Createur) VALUES ('$listname','$isPrivate',$idP)") or die (mysql_error());
+		$result = mysql_query("INSERT INTO AWOR_Liste (libelleL,estPrivee,idP_Createur) VALUES ('$listname','$isPrivate',$idP)") or die (mysql_error());
 		if (mysql_affected_rows() > 0)
 		{
 			return (mysql_insert_id());
@@ -41,7 +41,7 @@ require_once ('include/connect.inc.php');
 	
 	function list_modif($idL,$tabParticipant)
 	{
-		$result = mysql_query("SELECT P.idP,P.courrielP FROM Appartenir A, Personne P WHERE P.idP = A.idP AND A.idL=$idL") or die (mysql_error());
+		$result = mysql_query("SELECT P.idP,P.courrielP FROM AWOR_Appartenir A, AWOR_Personne P WHERE P.idP = A.idP AND A.idL=$idL") or die (mysql_error());
 		if (mysql_num_rows($result)>=0)
 		{
 			//Fabrication des trois tableaux
@@ -111,7 +111,7 @@ require_once ('include/connect.inc.php');
 	{
 		foreach ($tabPers as $pers)
 		{
-			$result=mysql_query("INSERT INTO Appartenir (idP,idL) VALUES ($pers,$idL);");
+			$result=mysql_query("INSERT INTO AWOR_Appartenir (idP,idL) VALUES ($pers,$idL);");
 		}
 
 	}
@@ -121,7 +121,7 @@ require_once ('include/connect.inc.php');
 		
 		foreach ($tabPers as $pers)
 		{
-			$result = mysql_query("DELETE FROM Appartenir WHERE idP=$pers AND idL=$idL;");
+			$result = mysql_query("DELETE FROM AWOR_Appartenir WHERE idP=$pers AND idL=$idL;");
 		}
 		
 	}
@@ -131,7 +131,7 @@ require_once ('include/connect.inc.php');
 	// ou Insert une personne et retourne son identifiant
 	function new_pers ($persMail)
 	{
-		$result = mysql_query("SELECT idP,courrielP FROM Personne WHERE courrielP = '$persMail'");
+		$result = mysql_query("SELECT idP,courrielP FROM AWOR_Personne WHERE courrielP = '$persMail'");
 		if (mysql_num_rows($result)>0)
 		{
 			$row = mysql_fetch_array($result);
@@ -139,7 +139,7 @@ require_once ('include/connect.inc.php');
 		}
 		else
 		{
-			$result = mysql_query("INSERT INTO Personne (courrielP,loginP,nomP) VALUES ('$persMail','$persMail','$persMail')");
+			$result = mysql_query("INSERT INTO AWOR_Personne (courrielP,loginP,nomP) VALUES ('$persMail','$persMail','$persMail')");
 			return (mysql_insert_id());
 		}
 			
@@ -151,7 +151,7 @@ require_once ('include/connect.inc.php');
 	//Fonction qui affiche toutes les liste public ainsi que les liste privée possédées par idP
 	function generate_html_array_list ($idP)
 	{
-		$result = mysql_query("SELECT idL,libelleL,estPrivee,idP_Createur FROM Liste WHERE idP_Createur=$idP OR estPrivee='non' ORDER BY estPrivee,libelleL");
+		$result = mysql_query("SELECT idL,libelleL,estPrivee,idP_Createur FROM AWOR_Liste WHERE idP_Createur=$idP OR estPrivee='non' ORDER BY estPrivee,libelleL");
 		echo "<table>\n<tr>\n<th>Supprimer</th>\n<th>Type</th>\n<th>Libell&eacute;</th>\n</tr>\n";	
 		if (mysql_num_rows($result)>0)
 		{
@@ -181,11 +181,11 @@ require_once ('include/connect.inc.php');
 			require_once ('include/connect.inc.php');
 			if (isset($_GET['idR']))
 			{
-				$query="UPDATE Repondre SET commentaireReponse ='".$_GET['txtCommentaire']."' WHERE idR=".$_GET['idR']." AND idP=".$_SESSION['session_idP'];
+				$query="UPDATE AWOR_Repondre SET commentaireReponse ='".$_GET['txtCommentaire']."' WHERE idR=".$_GET['idR']." AND idP=".$_SESSION['session_idP'];
 				$result = @mysql_query($query);
 				if ( ! $result || ( mysql_affected_rows() !== 1 ) )
 				{
-					$query="INSERT INTO Repondre(idR,idP,commentaireReponse) VALUES (".$_GET['idR'].", ".$_SESSION['session_idP'].", '".$_GET['txtCommentaire']."')";
+					$query="INSERT INTO AWOR_Repondre(idR,idP,commentaireReponse) VALUES (".$_GET['idR'].", ".$_SESSION['session_idP'].", '".$_GET['txtCommentaire']."')";
 	
 					$result = mysql_query($query);
 					if ( ! $result || ( mysql_affected_rows() !== 1 ))
@@ -199,7 +199,7 @@ require_once ('include/connect.inc.php');
 		}
 		else
 		{
-			$query="DELETE FROM Repondre WHERE idR=".$_GET['idR']." AND idP=".$_SESSION['session_idP'];
+			$query="DELETE FROM AWOR_Repondre WHERE idR=".$_GET['idR']." AND idP=".$_SESSION['session_idP'];
 			$result = mysql_query($query);
 		}
 	}
@@ -215,7 +215,7 @@ require_once ('include/connect.inc.php');
 	echo "<th>Commentaires <a href=\"#\" onclick=\"loadid('popcommentaire.php?idR=".$idR."&amp;idP=".$idP."','popcommentaire',true);popon('popcommentaire');\">(Editer votre commentaire)</a></th>";
 	echo '</tr>';
 	echo '</thead>';
-	$requete = "SELECT P.nomP,P.prenomP,P.courrielP,R.commentaireReponse FROM Repondre R,Personne P WHERE P.idP = R.idP AND R.idR = '".$idR."'";
+	$requete = "SELECT P.nomP,P.prenomP,P.courrielP,R.commentaireReponse FROM AWOR_Repondre R,AWOR_Personne P WHERE P.idP = R.idP AND R.idR = '".$idR."'";
 	//echo "DEBUG : requete : $requete\n";
 	$resultat = mysql_query($requete);
 	if($resultat != false)