PHP affiche_nom_prenom_email函数代码示例

        }
        if ($row['1'] < $am7) {
            $today[$row['0']][$am7]["data"] = affichage_lien_resa_planning($row['3'], $row['4']);
            if ($settings->get("display_info_bulle") == 1) {
                $today[$row['0']][$am7]["who"] = get_vocab("reservation au nom de") . affiche_nom_prenom_email($row['6'], $row['11'], "nomail");
            } else {
                if ($settings->get("display_info_bulle") == 2) {
                    $today[$row['0']][$am7]["who"] = $row['8'];
                } else {
                    $today[$row['0']][$am7]["who"] = "";
                }
            }
        } else {
            $today[$row['0']][$start_t]["data"] = affichage_lien_resa_planning($row['3'], $row['4']);
            if ($settings->get("display_info_bulle") == 1) {
                $today[$row['0']][$start_t]["who"] = get_vocab("reservation au nom de") . affiche_nom_prenom_email($row['6'], $row['11']);
            } else {
                if ($settings->get("display_info_bulle") == 2) {
                    $today[$row['0']][$start_t]["who"] = $row['8'];
                } else {
                    $today[$row['0']][$start_t]["who"] = "";
                }
            }
        }
    }
}
grr_sql_free($res);
$sql = "SELECT room_name, capacity, id, description, statut_room, show_fic_room, delais_option_reservation, moderate FROM " . TABLE_PREFIX . "_room WHERE area_id='" . protect_data_sql($area) . "' ORDER BY order_display, room_name";
$res = grr_sql_query($sql);
if (!$res) {
    fatal_error(0, grr_sql_error());

         $mail->AddAddress($item_email);
     }
     $mail->Subject = $sujet;
     $mail->Body = $message;
     $mail->AddReplyTo($email_reponse);
     if (!$mail->Send()) {
         $message_erreur .= $mail->ErrorInfo;
         echo $message_erreur;
     } else {
         echo "<p style=\"text-align: center\">Votre message a été envoyé !</p>";
     }
     break;
 default:
     echo "<table cellpadding='5'>";
     if ($fin_session == 'n' && getUserName() != '') {
         echo "<tr><td>" . get_vocab("Message poste par") . get_vocab("deux_points") . "</td><td><b>" . affiche_nom_prenom_email(getUserName(), "", $type = "nomail") . "</b></td></tr>\n";
     }
     echo "<tr><td>" . get_vocab("webmaster_name") . get_vocab("deux_points") . "</td><td><b>" . Settings::get("webmaster_name") . "</b></td></tr>\n";
     echo "<tr><td>" . get_vocab("company") . get_vocab("deux_points") . "</td><td><b>" . Settings::get("company") . "</b></td></tr>\n";
     echo "<tr><td colspan=\"2\">" . get_vocab("Redigez votre message ci-dessous") . get_vocab("deux_points") . "</td></tr>\n";
     echo "</table>\n";
     echo "<form action=\"contact.php\" method=\"post\" id=\"doc\">\n";
     echo "<div>\n";
     echo "<input type=\"hidden\" name=\"action\" value=\"envoi\" />\n";
     if ($cible != '') {
         echo "<input type=\"hidden\" name=\"cible\" value=\"" . $cible . "\" />\n";
     }
     if ($type_cible != '') {
         echo "<input type=\"hidden\" name=\"type_cible\" value=\"" . $type_cible . "\" />\n";
     }
     echo get_vocab("Objet du message") . get_vocab("deux_points");

} else {
    for ($i = 0; $row = grr_sql_row($res, $i); $i++) {
        $t = max((int) $row['0'], $date_start);
        $end_t = min((int) $row['1'], $date_end);
        $day_num = date("j", $t);
        $month_num = date("m", $t);
        $year_num = date("Y", $t);
        if ($enable_periods == 'y') {
            $midnight = mktime(12, 0, 0, $month_num, $day_num, $year_num);
        } else {
            $midnight = mktime(0, 0, 0, $month_num, $day_num, $year_num);
        }
        while ($t <= $end_t) {
            $d[$day_num]["id"][] = $row['2'];
            if (Settings::get("display_info_bulle") == 1) {
                $d[$day_num]["who"][] = get_vocab("reservee au nom de") . affiche_nom_prenom_email($row['4'], $row['12'], "nomail");
            } else {
                if (Settings::get("display_info_bulle") == 2) {
                    $d[$day_num]["who"][] = $row['8'];
                } else {
                    $d[$day_num]["who"][] = "";
                }
            }
            $d[$day_num]["who1"][] = affichage_lien_resa_planning($row['3'], $row['2']);
            $d[$day_num]["id_room"][] = $row['5'];
            $d[$day_num]["color"][] = $row['6'];
            $d[$day_num]["res"][] = $row['7'];
            $d[$day_num]["description"][] = affichage_resa_planning($row['8'], $row['2']);
            if ($row['10'] > 0) {
                $d[$day_num]["option_reser"][] = $row['9'];
            } else {

 } else {
     $midnight = mktime(0, 0, 0, $month_num, $day_num, $year_num);
 }
 while ($t <= $end_t) {
     /* j'ajoute pour la résa en cours, le temps de début et de fin */
     $d[$day_num]['tStart'][] = $row['0'];
     $d[$day_num]['tEnd'][] = $row['1'];
     $d[$day_num]['id'][] = $row['2'];
     if (Settings::get('display_info_bulle') == 1) {
         $d[$day_num]['who'][] = get_vocab('reservee au nom de') . affiche_nom_prenom_email($row['4'], $row['12'], 'nomail');
     } elseif (Settings::get('display_info_bulle') == 2) {
         $d[$day_num]['who'][] = $row['8'];
     } else {
         $d[$day_num]['who'][] = '';
     }
     $d[$day_num]['whoDeBase'][] = affiche_nom_prenom_email($row['4'], $row['12'], 'nomail');
     $d[$day_num]['who1'][] = affichage_lien_resa_planning($row['3'], $row['2']);
     $d[$day_num]['id_room'][] = $row['5'];
     $d[$day_num]['color'][] = $row['6'];
     $d[$day_num]['res'][] = $row['7'];
     $d[$day_num]['description'][] = affichage_resa_planning($row['8'], $row['2']);
     if ($row['10'] > 0) {
         $d[$day_num]['option_reser'][] = $row['9'];
     } else {
         $d[$day_num]['option_reser'][] = -1;
     }
     $d[$day_num]['moderation'][] = $row['11'];
     $midnight_tonight = $midnight + 86400;
     if (!isset($correct_heure_ete_hiver) || $correct_heure_ete_hiver == 1) {
         if (heure_ete_hiver('hiver', $year_num, 0) == mktime(0, 0, 0, $month_num, $day_num, $year_num)) {
             $midnight_tonight += 3600;

} else {
    for ($i = 0; $row = grr_sql_row($res, $i); ++$i) {
        $t = max((int) $row['0'], $date_start);
        $end_t = min((int) $row['1'], $date_end);
        $day_num = date('j', $t);
        $month_num = date('m', $t);
        $year_num = date('Y', $t);
        if ($enable_periods == 'y') {
            $midnight = mktime(12, 0, 0, $month_num, $day_num, $year_num);
        } else {
            $midnight = mktime(0, 0, 0, $month_num, $day_num, $year_num);
        }
        while ($t <= $end_t) {
            $d[$day_num]['id'][] = $row['2'];
            if (Settings::get('display_info_bulle') == 1) {
                $d[$day_num]['who'][] = get_vocab('reservee au nom de') . affiche_nom_prenom_email($row['4'], $row['12'], 'nomail');
            } elseif (Settings::get('display_info_bulle') == 2) {
                $d[$day_num]['who'][] = $row['8'];
            } else {
                $d[$day_num]['who'][] = '';
            }
            $d[$day_num]['who1'][] = affichage_lien_resa_planning($row['3'], $row['2']);
            $d[$day_num]['id_room'][] = $row['5'];
            $d[$day_num]['color'][] = $row['6'];
            $d[$day_num]['res'][] = $row['7'];
            $d[$day_num]['description'][] = affichage_resa_planning($row['8'], $row['2']);
            if ($row['10'] > 0) {
                $d[$day_num]['option_reser'][] = $row['9'];
            } else {
                $d[$day_num]['option_reser'][] = -1;
            }

 $t = max((int) $row[0], $month_start);
 $end_t = min((int) $row[1], $month_end);
 $day_num = date("j", $t);
 $month_num = date("m", $t);
 $year_num = date("Y", $t);
 if ($enable_periods == 'y') {
     $midnight = mktime(12, 0, 0, $month_num, $day_num, $year_num);
 } else {
     $midnight = mktime(0, 0, 0, $month_num, $day_num, $year_num);
 }
 while ($t < $end_t) {
     $d[$day_num][$month_num][$year_num]["id"][] = $row[2];
     // Info-bulle
     $temp = "";
     if (Settings::get("display_info_bulle") == 1) {
         $temp = get_vocab("reservee au nom de") . affiche_nom_prenom_email($row[4], $row[12], "nomail");
     } else {
         if (Settings::get("display_info_bulle") == 2) {
             $temp = $row[7];
         }
     }
     if ($temp != "") {
         $temp = " - " . $temp;
     }
     $d[$day_num][$month_num][$year_num]["who1"][] = affichage_lien_resa_planning($row[3], $row[2]);
     $d[$day_num][$month_num][$year_num]["room"][] = $row[5];
     $d[$day_num][$month_num][$year_num]["res"][] = $row[6];
     $d[$day_num][$month_num][$year_num]["color"][] = $row[10];
     if ($row[9] > 0) {
         $d[$day_num][$month_num][$year_num]["option_reser"][] = $row[8];
     } else {

                 $d[$weekday][$slot]["horaireDebut"] = mktime($morningstarts, 0, 0, date('m', $row[1]), date('d', $row[1]), date('Y', $row[1]));
                 $d[$weekday][$slot]["horaireFin"] = mktime($eveningends, 0, 0, date('m', $row[0]), date('d', $row[0]), date('Y', $row[0]));
                 $d[$weekday][$slot]["duree"] = ($eveningends - $morningstarts) * $heigthSlotHoure;
             }
         }
     } else {
         $d[$weekday][$slot]["horaireDebut"] = $row[0];
         $d[$weekday][$slot]["horaireFin"] = $row[1];
         $d[$weekday][$slot]["duree"] = ($row[1] - $row[0]) / $this_area_resolution;
     }
     if ($prev_weekday != $weekday) {
         $prev_weekday = $weekday;
         $d[$weekday][$slot]["data"] = affichage_lien_resa_planning($row[3], $row[4]);
         $d[$weekday][$slot]["id"] = $row[4];
         if (Settings::get("display_info_bulle") == 1) {
             $d[$weekday][$slot]["who"] = get_vocab("reservee au nom de") . affiche_nom_prenom_email($row[5], $row[10], "nomail");
         } else {
             if (Settings::get("display_info_bulle") == 2) {
                 $d[$weekday][$slot]["who"] = $row[7];
             } else {
                 $d[$weekday][$slot]["who"] = "";
             }
         }
         $d[$weekday][$slot]["statut"] = $row[6];
         $d[$weekday][$slot]["description"] = affichage_resa_planning($row[7], $row[4]);
         $d[$weekday][$slot]["option_reser"] = $row[8];
         $d[$weekday][$slot]["moderation"] = $row[9];
     }
 }
 $t += $resolution;
 $slot++;

//.........这里部分代码省略.........
    } else {
        $start_date = time_date_string($row[10], $dformat);
    }
    $rep_type = 0;
    if ($repeat_id != 0) {
        $res = grr_sql_query("SELECT rep_type, end_date, rep_opt, rep_num_weeks FROM " . TABLE_PREFIX . "_repeat WHERE id='" . protect_data_sql($repeat_id) . "'");
        if (!$res) {
            fatal_error(0, grr_sql_error());
        }
        $test = grr_sql_count($res);
        if ($test != 1) {
            fatal_error(0, "Deux reservation on le meme ID.");
        } else {
            $row2 = grr_sql_row($res, 0);
            $rep_type = $row2[0];
            $rep_end_date = strftime($dformat, $row2[1]);
            $rep_opt = $row2[2];
            $rep_num_weeks = $row2[3];
        }
        grr_sql_free($res);
    }
    if ($enable_periods == 'y') {
        toPeriodString($start_period, $duration, $dur_units);
    } else {
        toTimeString($duration, $dur_units);
    }
    $weeklist = array("unused", "every week", "week 1/2", "week 1/3", "week 1/4", "week 1/5");
    if ($rep_type == 2) {
        $affiche_period = $vocab[$weeklist[$rep_num_weeks]];
    } else {
        $affiche_period = $vocab['rep_type_' . $rep_type];
    }
    // Le bénéficiaire
    $beneficiaire_email = affiche_nom_prenom_email($beneficiaire, $beneficiaire_ext, "onlymail");
    if ($beneficiaire != "") {
        $beneficiaire_actif = grr_sql_query1("SELECT etat FROM " . TABLE_PREFIX . "_utilisateurs WHERE login='{$beneficiaire}'");
        if ($beneficiaire_actif == -1) {
            $beneficiaire_actif = 'actif';
        }
        // Cas des admins
    } else {
        if ($beneficiaire_ext != "" && $beneficiaire_email != "") {
            $beneficiaire_actif = "actif";
        } else {
            $beneficiaire_actif = "inactif";
        }
    }
    // Utilisateur ayant agit sur la réservation
    $user_login = getUserName();
    $user_email = grr_sql_query1("SELECT email FROM " . TABLE_PREFIX . "_utilisateurs WHERE login='{$user_login}'");
    //
    // Elaboration du message destiné aux utilisateurs désignés par l'admin dans la partie "Mails automatiques"
    //
    //Nom de l'établissement et mention "mail automatique"
    $message = removeMailUnicode(Settings::get("company")) . " - " . $vocab["title_mail"];
    // Url de GRR
    $message = $message . traite_grr_url("", "y") . "\n\n";
    $sujet = $vocab["subject_mail1"] . $room_name . " - " . $date_avis;
    if ($action == 1) {
        $sujet = $sujet . $vocab["subject_mail_creation"];
        $message .= $vocab["the_user"] . affiche_nom_prenom_email($user_login, "", "formail");
        $message = $message . $vocab["creation_booking"];
        $message = $message . $vocab["the_room"] . $room_name . " (" . $area_name . ") \n";
    } else {
        if ($action == 2) {
            $sujet = $sujet . $vocab["subject_mail_modify"];

//.........这里部分代码省略.........
    } else {
        $start_date = time_date_string($row[10], $dformat);
    }
    $rep_type = 0;
    if ($repeat_id != 0) {
        $res = grr_sql_query('SELECT rep_type, end_date, rep_opt, rep_num_weeks FROM ' . TABLE_PREFIX . "_repeat WHERE id='" . protect_data_sql($repeat_id) . "'");
        if (!$res) {
            fatal_error(0, grr_sql_error());
        }
        $test = grr_sql_count($res);
        if ($test != 1) {
            fatal_error(0, 'Deux reservation on le meme ID.');
        } else {
            $row2 = grr_sql_row($res, 0);
            $rep_type = $row2[0];
            $rep_end_date = strftime($dformat, $row2[1]);
            $rep_opt = $row2[2];
            $rep_num_weeks = $row2[3];
        }
        grr_sql_free($res);
    }
    if ($enable_periods == 'y') {
        toPeriodString($start_period, $duration, $dur_units);
    } else {
        toTimeString($duration, $dur_units);
    }
    $weeklist = array('unused', 'every week', 'week 1/2', 'week 1/3', 'week 1/4', 'week 1/5');
    if ($rep_type == 2) {
        $affiche_period = $vocab[$weeklist[$rep_num_weeks]];
    } else {
        $affiche_period = $vocab['rep_type_' . $rep_type];
    }
    // Le bénéficiaire
    $beneficiaire_email = affiche_nom_prenom_email($beneficiaire, $beneficiaire_ext, 'onlymail');
    if ($beneficiaire != '') {
        $beneficiaire_actif = grr_sql_query1('SELECT etat FROM ' . TABLE_PREFIX . "_utilisateurs WHERE login='{$beneficiaire}'");
        if ($beneficiaire_actif == -1) {
            $beneficiaire_actif = 'actif';
        }
        // Cas des admins
    } elseif ($beneficiaire_ext != '' && $beneficiaire_email != '') {
        $beneficiaire_actif = 'actif';
    } else {
        $beneficiaire_actif = 'inactif';
    }
    // Utilisateur ayant agit sur la réservation
    $user_login = getUserName();
    $user_email = grr_sql_query1('SELECT email FROM ' . TABLE_PREFIX . "_utilisateurs WHERE login='{$user_login}'");
    //
    // Elaboration du message destiné aux utilisateurs désignés par l'admin dans la partie "Mails automatiques"
    //
    //Nom de l'établissement et mention "mail automatique"
    $message = removeMailUnicode(Settings::get('company')) . ' - ' . $vocab['title_mail'];
    // Url de GRR
    $message = $message . traite_grr_url('', 'y') . "\n\n";
    $sujet = $vocab['subject_mail1'] . $room_name . ' - ' . $date_avis;
    if ($action == 1) {
        $sujet = $sujet . $vocab['subject_mail_creation'];
        $message .= $vocab['the_user'] . affiche_nom_prenom_email($user_login, '', 'formail');
        $message = $message . $vocab['creation_booking'];
        $message = $message . $vocab['the_room'] . $room_name . ' (' . $area_name . ") \n";
    } elseif ($action == 2) {
        $sujet = $sujet . $vocab['subject_mail_modify'];
        if ($moderate == 1) {
            $sujet .= ' (' . $vocab['en_attente_moderation'] . ')';
        }

			</td>
		</tr>
		<?php 
}
?>
	<tr>
		<td>
			<b>
				<?php 
echo get_vocab("created_by"), get_vocab("deux_points");
?>
			</b>
		</td>
		<td>
			<?php 
echo affiche_nom_prenom_email($create_by, "", $option_affiche_nom_prenom_email);
if ($active_ressource_empruntee == 'y') {
    $id_resa = grr_sql_query1("SELECT id from " . TABLE_PREFIX . "_entry where room_id = '" . $room_id . "' and statut_entry='y'");
    if ($id_resa == $id) {
        echo '<span class="avertissement">(', get_vocab("reservation_en_cours"), ') <img src="img_grr/buzy_big.png" align=middle alt="', get_vocab("ressource actuellement empruntee"), '" title="', get_vocab("ressource actuellement empruntee"), '" border="0" width="30" height="30" class="print_image" /></span>', PHP_EOL;
    }
}
?>
		</td>
	</tr>
	<tr>
		<td>
			<b>
				<?php 
echo get_vocab("lastupdate"), get_vocab("deux_points");
?>

 <tr>
	<td>
		<b>

                echo get_vocab('created_by'),get_vocab('deux_points')

		</b>
	</td>
	<td>
*/
$tplArray['beneficiaireNomPrenom'] = affiche_nom_prenom_email($create_by, '', 'nomail');
/* ajouté en attendant pour récuper le mail brut en plus */
$tplArray['beneficiaireMail'] = affiche_nom_prenom_email($create_by, '', 'onlymail');
$tplArray['telCreatedBy'] = grr_sql_query1('SELECT tel FROM ' . TABLE_PREFIX . "_utilisateurs WHERE login='{$create_by}'");
//echo affiche_nom_prenom_email($create_by, '', $option_affiche_nom_prenom_email);
$tplArray['createdBy'] = affiche_nom_prenom_email($create_by, '');
if ($active_ressource_empruntee == 'y') {
    $id_resa = grr_sql_query1('SELECT id from ' . TABLE_PREFIX . "_entry where room_id = '" . $room_id . "' and statut_entry='y'");
    if ($id_resa == $id) {
        $tplArray['empruntee'] = true;
        /*echo '<span class="avertissement">(',get_vocab('reservation_en_cours'),') <img src="img_grr/buzy_big.png" align=middle alt="',get_vocab('ressource actuellement empruntee'),'" title="',get_vocab('ressource actuellement empruntee'),'" border="0" width="30" height="30" class="print_image" /></span>',PHP_EOL;*/
    } else {
        $tplArray['empruntee'] = false;
    }
} else {
    $tplArray['empruntee'] = false;
}
$tplArray['updated'] = $updated;
/*		</td>
	</tr>
	<tr>

//.........这里部分代码省略.........
    if($enable_periods=='y')
        list( , $end_date) =  period_date_string($row[11], -1);
    else
        $end_date = time_date_string($row[11],$dformat);
    $rep_type = 0;

    if($repeat_id != 0)
    {
        $res = grr_sql_query("SELECT rep_type, end_date, rep_opt, rep_num_weeks FROM ".TABLE_PREFIX."_repeat WHERE id='".protect_data_sql($repeat_id)."'");
        if (! $res) fatal_error(0, grr_sql_error());

        if (grr_sql_count($res) == 1)
        {
            $row2 = grr_sql_row($res, 0);

            $rep_type     = $row2[0];
            $rep_end_date = strftime($dformat,$row2[1]);
            $rep_opt      = $row2[2];
            $rep_num_weeks = $row2[3];
        }
        grr_sql_free($res);
    }
    if ($enable_periods=='y')
        toPeriodString($start_period, $duration, $dur_units);
    else
        toTimeString($duration, $dur_units);
    $weeklist = array("unused","every week","week 1/2","week 1/3","week 1/4","week 1/5");
    if ($rep_type == 2)
        $affiche_period = $vocab[$weeklist[$rep_num_weeks]];
    else
        $affiche_period = $vocab['rep_type_'.$rep_type];

    // Le bénéficiaire
    $beneficiaire_email = affiche_nom_prenom_email($beneficiaire,$beneficiaire_ext,"onlymail");
    if ($beneficiaire != "") {
         $beneficiaire_actif = grr_sql_query1("select etat from ".TABLE_PREFIX."_utilisateurs where login='$beneficiaire'");
         if ($beneficiaire_actif == -1)
             $beneficiaire_actif = 'actif'; // cas des administrateurs
    } else if (($beneficiaire_ext != "")  and ($beneficiaire_email!="")) {
        $beneficiaire_actif = "actif";
    } else $beneficiaire_actif = "inactif";

    // Utilisateur ayant agit sur la réservation
    $user_login=getUserName();
    $user_email = grr_sql_query1("select email from ".TABLE_PREFIX."_utilisateurs where login='$user_login'");
    //
    // Elaboration du message destiné aux utilisateurs désignés par l'admin dans la partie "Mails automatiques"
    //
    //Nom de l'établissement et mention "mail automatique"
    $message = removeMailUnicode(getSettingValue("company"))." - ".$vocab["title_mail"];
    // Url de GRR
    $message = $message.traite_grr_url("","y")."\n\n";

    $sujet = $vocab["subject_mail1"].$room_name." - ".$date_avis;
    if ($action == 1) {
        // Nouvelle réservation
        $sujet = $sujet.$vocab["subject_mail_creation"];// - Nouvelle réservation
        // L'utilisateur nom prénom (email)
        $message .= $vocab["the_user"].affiche_nom_prenom_email($user_login,"","formail");
        $message = $message.$vocab["creation_booking"]; // a réservé
        // la ressource "nom de la ressource" ("nom du domaine")
        $message=$message.$vocab["the_room"].$room_name." (".$area_name.") \n";
    } else if ($action == 2) {
        // Modification d'une réservation
        $sujet = $sujet.$vocab["subject_mail_modify"];// - Modification d'une réservation
        if ($moderate == 1) $sujet .= " (".$vocab["en_attente_moderation"].")";// (en attente de modération)

    # Show the name of the booker in the first segment that the booking
    # happens in, or at the start of the day if it started before today.
    if ($row[1] < $am7) {
        $today[$row[0]][$am7]["data"] = affichage_lien_resa_planning($row[3],$row[4]);
        // Info-bulle
        if (getSettingValue("display_info_bulle") == 1)
            $today[$row[0]][$am7]["who"] = get_vocab("reservation au nom de").affiche_nom_prenom_email($row[6],$row[11],"nomail");
        else if (getSettingValue("display_info_bulle") == 2)
            $today[$row[0]][$am7]["who"] = $row[8];
        else
            $today[$row[0]][$am7]["who"] = "";
    } else {
        $today[$row[0]][$start_t]["data"] = affichage_lien_resa_planning($row[3],$row[4]);
        // Info-bulle
        if (getSettingValue("display_info_bulle") == 1)
            $today[$row[0]][$start_t]["who"] = get_vocab("reservation au nom de").affiche_nom_prenom_email($row[6],$row[11]);
        else if (getSettingValue("display_info_bulle") == 2)
            $today[$row[0]][$start_t]["who"] = $row[8];
        else
            $today[$row[0]][$start_t]["who"] = "";
    }
}
grr_sql_free($res);
# We need to know what all the rooms area called, so we can show them all
# pull the data from the db and store it. Convienently we can print the room
# headings and capacities at the same time

$sql = "select room_name, capacity, id, description, statut_room, show_fic_room, delais_option_reservation, moderate from ".TABLE_PREFIX."_room where area_id='".protect_data_sql($area)."' order by order_display, room_name";
$res = grr_sql_query($sql);

# It might be that there are no rooms defined for this area.