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/include/ludo/config.inc.php | 3 +- beta_old1/app/include/ludo/div_create_or_modif.php | 9 +--- beta_old1/app/include/ludo/fonctions.inc.php | 57 +++++++++++++++++----- beta_old1/app/include/ludo/html_elements.inc.php | 20 ++++---- beta_old1/app/include/ludo/mail_textarea.php | 2 +- beta_old1/app/include/ludo/majDispo.php | 18 +++---- 6 files changed, 69 insertions(+), 40 deletions(-) (limited to 'beta_old1/app/include/ludo') diff --git a/beta_old1/app/include/ludo/config.inc.php b/beta_old1/app/include/ludo/config.inc.php index 51d6d73..6d6504b 100644 --- a/beta_old1/app/include/ludo/config.inc.php +++ b/beta_old1/app/include/ludo/config.inc.php @@ -67,7 +67,8 @@ $CONFIG = array 'accepted_files' => array ( 'jpg', 'jpeg', 'gif', 'png', 'svg', 'pdf', 'ps', 'txt', 'rtf', 'csv', 'doc', 'docx', 'ppt', 'xls', 'sxw','sxp','sxd', 'odt', 'odg', 'odp', 'avi', 'mpg', 'mpeg', 'rm', 'flv', 'mp3', 'mp4', 'ogg','htm','html','zip', 'rar', 'tar', 'gz', 'bz2', 'ace' - ) + ), + 'relative_path' => 'beta/upload_files/' ) ); ?> diff --git a/beta_old1/app/include/ludo/div_create_or_modif.php b/beta_old1/app/include/ludo/div_create_or_modif.php index 5849180..c386060 100644 --- a/beta_old1/app/include/ludo/div_create_or_modif.php +++ b/beta_old1/app/include/ludo/div_create_or_modif.php @@ -58,20 +58,13 @@ if ( isset ( $_GET['idR']) ) Etat : Annulée - + Disponibilités masquées - Annuler"; - ?> diff --git a/beta_old1/app/include/ludo/fonctions.inc.php b/beta_old1/app/include/ludo/fonctions.inc.php index 7411000..74b7ca7 100644 --- a/beta_old1/app/include/ludo/fonctions.inc.php +++ b/beta_old1/app/include/ludo/fonctions.inc.php @@ -119,7 +119,7 @@ function generate_html_array_personnes_crenaux($idR) // Récupération des paramètres de la réunion... $montrerDispoR=$estAnnulee=$is_admin=$estFixee=false; $idP_orga=null; - $query="SELECT r.montrerDispoR, r.estAnnulee, r.idP_Orga, r.idC_Fixe, r.idL FROM Reunion r WHERE r.idR='$idR'"; + $query="SELECT r.montrerDispoR, r.estAnnulee, r.idP_Orga, r.idC_Fixe, r.idL FROM AWOR_Reunion r WHERE r.idR='$idR'"; $result = @mysql_query($query); if ( $result && ( mysql_num_rows($result) === 1 ) ) { @@ -160,7 +160,7 @@ function generate_html_array_personnes_crenaux($idR) echo ' ' . "\n"; // Remplissage des entêtes de colonnes (créneaux) - $query="SELECT idC, UNIX_TIMESTAMP(dateHeure), duree FROM Creneau WHERE idR='$idR' ORDER BY dateHeure ASC;"; + $query="SELECT idC, UNIX_TIMESTAMP(dateHeure), duree FROM AWOR_Creneau WHERE idR='$idR' ORDER BY dateHeure ASC;"; $creneaux=array(); $dispos=array(); if ( $result = @mysql_query($query) ) @@ -208,12 +208,12 @@ function generate_html_array_personnes_crenaux($idR) // Requette écrivant les disponibilités dans un tableau associatif en une seule fois if ( $montrerDispoR ) { - $query='SELECT ch.idC, ch.idP, ch.estDispo FROM Choisir ch, Creneau c, Personne p, Appartenir a, Reunion r WHERE ' + $query='SELECT ch.idC, ch.idP, ch.estDispo FROM AWOR_Choisir ch, AWOR_Creneau c, AWOR_Personne p, AWOR_Appartenir a, AWOR_Reunion r WHERE ' ."c.idR=$idR AND r.idR=$idR AND a.idL=r.idL AND p.idP=a.idP AND ch.idC = c.idC AND ch.idP = p.idP;"; } else { - $query='SELECT ch.idC, ch.idP, ch.estDispo FROM Choisir ch, Creneau c WHERE ' + $query='SELECT ch.idC, ch.idP, ch.estDispo FROM AWOR_Choisir ch, AWOR_Creneau c WHERE ' ."c.idR='$idR' AND ch.idC=c.idC AND ch.idP='$idP_Self';"; } //echo $query . "\n"; @@ -238,7 +238,7 @@ function generate_html_array_personnes_crenaux($idR) //print_r($dispos); - $query='SELECT p.idP, p.prenomP, p.nomP FROM Personne p, Appartenir a, Reunion r WHERE ' + $query='SELECT p.idP, p.prenomP, p.nomP FROM AWOR_Personne p, AWOR_Appartenir a, AWOR_Reunion r WHERE ' . "r.idR='$idR' AND a.idL=r.idL AND p.idP=a.idP ORDER BY p.nomP, p.prenomP;"; if ( $result = @mysql_query($query) ) @@ -338,7 +338,7 @@ function traiter_formulaire_fixer_creneau() $idR=addslashes($_GET['idR']); $idC=addslashes($_GET['idC']); - $query="UPDATE Reunion SET idC_Fixe=$idC WHERE idR=$idR;"; + $query="UPDATE AWOR_Reunion SET idC_Fixe=$idC WHERE idR=$idR;"; if ( ! mysql_query($query) || mysql_affected_rows() != 1 ) { $errmsg='Impossible de fixer la réunion : ' . mysql_generate_errmsg(); @@ -353,7 +353,7 @@ function traiter_formulaire_creer_reunion() $idP=$_SESSION['session_idP']; // Recherche d'une réunion vierge déjà existante - $query='SELECT idR FROM Reunion WHERE idP_Orga=' . "('$idP') AND objetR='Renseignez';"; + $query='SELECT idR FROM AWOR_Reunion WHERE idP_Orga=' . "('$idP') AND objetR='Renseignez';"; if ( ( $result = mysql_query($query) ) && (mysql_num_rows($result) > 0) ) { list($idR)=mysql_fetch_array($result); @@ -361,7 +361,7 @@ function traiter_formulaire_creer_reunion() else { // Création de la Réunion sauf si une réunion vierge existe déjà - $query='INSERT INTO Reunion(idP_Orga, objetR) VALUES' . "('$idP', 'Renseignez');"; + $query='INSERT INTO AWOR_Reunion(idP_Orga, objetR) VALUES' . "('$idP', 'Renseignez');"; if ( ! $result = @mysql_query($query) || (mysql_affected_rows() != 1) ) { // Cas d'erreur @@ -377,7 +377,7 @@ function traiter_formulaire_creer_reunion() return $errmsg; } - $query="UPDATE Reunion SET idL='$idL' WHERE idR='$idR'"; + $query="UPDATE AWOR_Reunion SET idL='$idL' WHERE idR='$idR'"; if ( ! $result = @mysql_query($query) || (mysql_affected_rows() != 1) ) { // Cas d'erreur @@ -405,8 +405,10 @@ function traiter_formulaire_modif_detail_reunion() $ordreJourR=addslashes($_POST['ordreJourR']); $remarquesR=addslashes($_POST['remarquesR']); $estAnnulee=( isset($_POST['isCancelled']) && ($_POST['isCancelled']==='on') )?'oui':'non'; + $montrerDispoR=( isset($_POST['isHidden']) && ($_POST['isHidden']==='on') )?'non':'oui'; - $query="UPDATE Reunion SET objetR='$objetR', lieuR='$lieuR', ordreJourR='$ordreJourR', remarquesR='$remarquesR', estAnnulee='$estAnnulee' WHERE idR='$idR'"; + $query="UPDATE AWOR_Reunion SET objetR='$objetR', lieuR='$lieuR', ordreJourR='$ordreJourR', " + ." remarquesR='$remarquesR', estAnnulee='$estAnnulee', montrerDispoR='$montrerDispoR' WHERE idR='$idR'"; if ( ! $result = @mysql_query($query) || (mysql_affected_rows() != 1) ) { // Cas d'erreur @@ -423,7 +425,7 @@ function traiter_formulaire_modif_detail_reunion() function generate_html_reunion_detail2($idR) { $query='SELECT r.objetR, r.ordreJourR, r.lieuR, r.remarquesR, r.montrerDispoR, r.estAnnulee, r.idP_Orga, r.idC_Fixe, p.nomP, p.prenomP' - . " FROM Reunion r, Personne p WHERE r.idR='$idR' AND p.idP=r.idP_Orga"; + . " FROM AWOR_Reunion r, AWOR_Personne p WHERE r.idR='$idR' AND p.idP=r.idP_Orga"; $result = @mysql_query($query); if ( ! $result || ( mysql_num_rows($result) !== 1 ) ) { @@ -512,4 +514,37 @@ function generate_html_reunion_detail2($idR) ' . "\n" . '' . "\n\n\n"; + echo '\n\n\n"; + echo "\n\n"; + echo "\n\n\n"; + echo ''; + for ( $i=0; $i < count($row); $i++ ) { echo ""; } + echo "\n\n\n"; + + $num=0; + do + { if ( isset($row[$key_name]) ) { $num=$row[$key_name]; } else { $num=''; } + echo "\n\n\n\n\n"; + } while ( $row = mysql_fetch_assoc($result) ); + echo "\n
$table
" . implode("",array_keys($row)) . "
" . implode("",$row) . "
\n\n"; + } +} + ?> diff --git a/beta_old1/app/include/ludo/html_elements.inc.php b/beta_old1/app/include/ludo/html_elements.inc.php index 41fd812..b845f28 100644 --- a/beta_old1/app/include/ludo/html_elements.inc.php +++ b/beta_old1/app/include/ludo/html_elements.inc.php @@ -15,10 +15,10 @@ echo ''."\n" Listes
  • Mon profil
  • iCal
    • +
  • A Propos
    • Administration' . "\n"; } ?> @@ -75,7 +76,7 @@ function generate_html_div_help($help_file='') //if ( @fopen($help_file, 'r')!==false ) { echo '
    ' . "\n

    ?

    \n" . "
    \n"; - echo '
    ' . "\n

    Aide

    \n"; + echo '
    ' . "\n"; readfile($help_file); echo "
    \n"; } @@ -100,14 +101,15 @@ function generate_html_div_css_chooser() if ( ! is_array($CONFIG['CSS']['CHOOSER_LIST']) ) { return false; } - if ( isset($_COOKIE['awor']['custom_css'] ) ) { $css_selected=$_COOKIE['awor']['custom_css']; }else{$css_selected='';}; + if ( isset($_COOKIE['aworcustom_css'] ) ) { $css_selected=$_COOKIE['aworcustom_css']; }else{$css_selected='';}; echo '
    ' . "\n"; + //print_r($_COOKIE); echo ' '. "\n"; echo '
    '. "\n"; @@ -133,7 +135,7 @@ function generate_html_div_footer()
  • - Application réalisée par Jérémie Dénoyer, Ludovic Pouzenc, Julien Séré et Andriana Semouchtchak + Application réalisée par Jérémie Dénoyer,
    Ludovic Pouzenc, Julien Séré et Andriana Semouchtchak
    • diff --git a/beta_old1/app/include/ludo/mail_textarea.php b/beta_old1/app/include/ludo/mail_textarea.php index cf4b6d7..87f4965 100644 --- a/beta_old1/app/include/ludo/mail_textarea.php +++ b/beta_old1/app/include/ludo/mail_textarea.php @@ -24,7 +24,7 @@ if ( isset($_GET['model']) ) { $model=$_GET['model']; } else { $model='empty'; } if (isset( $_GET['idR']) ) { $idR=addslashes($_GET['idR']); - $result = mysql_query("SELECT objetR, ordreJourR, lieuR, remarquesR FROM Reunion WHERE idR='$idR'"); + $result = mysql_query("SELECT objetR, ordreJourR, lieuR, remarquesR FROM AWOR_Reunion WHERE idR='$idR'"); if (mysql_num_rows($result)===1) { list($objetR, $ordreJourR, $lieuR, $remarquesR) = mysql_fetch_array($result); diff --git a/beta_old1/app/include/ludo/majDispo.php b/beta_old1/app/include/ludo/majDispo.php index ab7c200..3f79fec 100644 --- a/beta_old1/app/include/ludo/majDispo.php +++ b/beta_old1/app/include/ludo/majDispo.php @@ -1,4 +1,5 @@ \ No newline at end of file -- cgit v1.2.3