From 4f0df31cc153855d099e4c06228a6cf1bf51eeca Mon Sep 17 00:00:00 2001 From: Ludovic Pouzenc Date: Sat, 30 Jun 2018 11:29:21 +0200 Subject: Version beta_old1 (sans la doc) 2007-02-22+15:00 - 2007-03-11+16:41:00 --- beta_old1/app/index.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'beta_old1/app/index.php') diff --git a/beta_old1/app/index.php b/beta_old1/app/index.php index eefb768..572c656 100644 --- a/beta_old1/app/index.php +++ b/beta_old1/app/index.php @@ -92,7 +92,7 @@ generate_html_div_help(); // Réunions fixées et passées $query = 'SELECT DISTINCT R.idR, R.objetR, P.nomP, P.prenomP, UNIX_TIMESTAMP(C.dateHeure), R.estAnnulee' - . ' FROM Liste L,Reunion R,Appartenir A,Creneau C,Personne P' + . ' FROM AWOR_Liste L,AWOR_Reunion R,AWOR_Appartenir A,AWOR_Creneau C,AWOR_Personne P' . " WHERE ((A.idP = $idP AND A.idL = L.idL) OR R.idP_Orga = $idP)" . ' AND R.idL = L.idL AND P.idP = R.idP_Orga AND R.idC_Fixe = C.idC' . ' ORDER BY C.dateHeure DESC;'; @@ -100,7 +100,7 @@ generate_html_div_help(); // Réunion en préparation $query = 'SELECT DISTINCT R.idR, R.objetR, P.nomP, P.prenomP, NULL, R.estAnnulee' - . ' FROM Liste L,Reunion R,Appartenir A,Personne P' // Creneau C, + . ' FROM AWOR_Liste L,AWOR_Reunion R,AWOR_Appartenir A,AWOR_Personne P' // Creneau C, . " WHERE ((A.idP = $idP AND A.idL = L.idL) OR R.idP_Orga = $idP)" . ' AND R.idL = L.idL AND P.idP = R.idP_Orga AND ISNULL(R.idC_Fixe);'; //echo "DEBUG : $query\n"; -- cgit v1.2.3