diff options
Diffstat (limited to 'beta_old1/app/include/je.inc.php')
| -rw-r--r-- | beta_old1/app/include/je.inc.php | 26 |
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é</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."&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) |