PHP grr_sql_query1函数代码示例

/**
 * Load settings from the database
 *
 * Query all the settings
 * Fetch the result in the $grrSettings associative array
 *
 * Returns true if all went good, false otherwise
 *
 *
 * @return bool The settings are loaded
 */
function loadSettings()
{
    global $grrSettings;
    // Pour tenir compte du changement de nom de la table setting à partir de la version 1.8
    $test = grr_sql_query1("select NAME  from ".TABLE_PREFIX."_setting where NAME='version'");
    if ($test != -1)
       $sql = "select `NAME`, `VALUE` from ".TABLE_PREFIX."_setting";
    else
        $sql = "select `NAME`, `VALUE` from setting";
    $res = grr_sql_query($sql);
    if (! $res) return (false);
    if (grr_sql_count($res) == 0) {
        return (false);
    } else {
        for ($i = 0; ($row = grr_sql_row($res, $i)); $i++) {
            $grrSettings[$row[0]] = $row[1];
        }
        return (true);
    }
}

 static function load()
 {
     $test = grr_sql_query1("SELECT NAME FROM " . TABLE_PREFIX . "_setting WHERE NAME='version'");
     if ($test != -1) {
         $sql = "SELECT `NAME`, `VALUE` FROM " . TABLE_PREFIX . "_setting";
     } else {
         $sql = "SELECT `NAME`, `VALUE` FROM setting";
     }
     $res = grr_sql_query($sql);
     if (!$res) {
         return false;
     }
     if (grr_sql_count($res) == 0) {
         return false;
     } else {
         for ($i = 0; $row = grr_sql_row($res, $i); $i++) {
             self::$grrSettings[$row[0]] = $row[1];
         }
         return true;
     }
 }

if ($error_booking_in_past == 'yes') {
    $str_date = utf8_strftime('%d %B %Y, %H:%M', $date_now);
    print_header();
    echo '<h2>' . get_vocab('booking_in_past') . '</h2>';
    if ($rep_type != 0 && !empty($reps)) {
        echo '<p>' . get_vocab('booking_in_past_explain_with_periodicity') . $str_date . '</p>';
    } else {
        echo '<p>' . get_vocab('booking_in_past_explain') . $str_date . '</p>';
    }
    echo '<a href="' . $back . '&amp;Err=yes">' . get_vocab('returnprev') . '</a>';
    include 'include/trailer.inc.php';
    die;
}
if ($error_duree_max_resa_area == 'yes') {
    $area_id = grr_sql_query1('SELECT area_id FROM ' . TABLE_PREFIX . "_room WHERE id='" . protect_data_sql($room_id) . "'");
    $duree_max_resa_area = grr_sql_query1('SELECT duree_max_resa_area FROM ' . TABLE_PREFIX . "_area WHERE id='" . $area_id . "'");
    print_header();
    $temps_format = $duree_max_resa_area * 60;
    toTimeString($temps_format, $dur_units, true);
    echo '<h2>' . get_vocab('error_duree_max_resa_area') . $temps_format . ' ' . $dur_units . '</h2>';
    echo '<a href="' . $back . '&amp;Err=yes">' . get_vocab('returnprev') . '</a>';
    include 'include/trailer.inc.php';
    die;
}
if ($error_delais_max_resa_room == 'yes') {
    print_header();
    echo '<h2>' . get_vocab('error_delais_max_resa_room') . '</h2>';
    echo '<a href="' . $back . '&amp;Err=yes">' . get_vocab('returnprev') . '</a>';
    include 'include/trailer.inc.php';
    die;
}

/**
 * Resume a session
 *
 * Check that all the expected data is present
 * Check login / password against database
 * Update the timeout in the ".TABLE_PREFIX."_log table
 *
 * Returns true if session resumes, false otherwise
 *
 *
 * @return boolean
 */
function grr_resumeSession()
{
    // Resuming session
    session_name(SESSION_NAME);
    @session_start();
    if (Settings::get('sso_statut') == 'lcs' and !isset($_SESSION['est_authentifie_sso']) and $_SESSION['source_login'] == "ext") {
        return false;
    }
    // La session est-elle expirée
    if (isset($_SESSION['login'])) {
        $test_session = grr_sql_query1("SELECT count(LOGIN) from " . TABLE_PREFIX . "_log where END > now() and LOGIN = '" . protect_data_sql($_SESSION['login']) . "'");
        if ($test_session == 0) {
            $_SESSION = array();
        }
    }
    if (!isset($_SESSION) or !isset($_SESSION['login'])) {
        return false;
    }
    if (Settings::get("disable_login") == 'yes' and $_SESSION['statut'] != "administrateur") {
        return false;
    }
    // To be removed
    // Validating session data
    $sql = "SELECT password = '" . $_SESSION['password'] . "' PASSWORD, login = '" . protect_data_sql($_SESSION['login']) . "' LOGIN, statut = '" . $_SESSION['statut'] . "' STATUT\n\tfrom " . TABLE_PREFIX . "_utilisateurs where login = '" . protect_data_sql($_SESSION['login']) . "'";
    $res = grr_sql_query($sql);
    $row = grr_sql_row($res, 0);
    // Checking for a timeout
    $sql2 = "SELECT now() > END TIMEOUT from " . TABLE_PREFIX . "_log where SESSION_ID = '" . session_id() . "' and START = '" . $_SESSION['start'] . "'";
    if ($row[0] != "1" || $row[1] != "1" || $row[2] != "1") {
        return false;
    } else {
        if (grr_sql_query1($sql2)) {
            // Le temps d'inactivité est supérieur à la limite fixée.
            // cas d'une authentification LCS
            if (Settings::get('sso_statut') == 'lcs') {
                // l'utilisateur est authentifié par LCS, on renouvelle la session
                if ($is_authentified_lcs == 'yes') {
                    $sql = "UPDATE " . TABLE_PREFIX . "_log set END = now() + interval " . $_SESSION['maxLength'] . " minute where SESSION_ID = '" . session_id() . "' and START = '" . $_SESSION['start'] . "'";
                    $res = grr_sql_query($sql);
                    if (!$res) {
                        fatal_error(0, 'erreur mysql' . grr_sql_error());
                    }
                    return true;
                } else {
                    return false;
                }
            } else {
                return false;
            }
        } else {
            $sql = "UPDATE " . TABLE_PREFIX . "_log set END = now() + interval " . $_SESSION['maxLength'] . " minute where SESSION_ID = '" . session_id() . "' and START = '" . $_SESSION['start'] . "'";
            $res = grr_sql_query($sql);
            if (!$res) {
                fatal_error(0, 'erreur mysql' . grr_sql_error());
            }
            return true;
        }
    }
}

?>
</h2>
<?php 
if (Settings::get("module_multisite") == "Oui") {
    if (authGetUserLevel(getUserName(), -1, 'area') >= 6) {
        $sql = "SELECT id,sitecode,sitename FROM " . TABLE_PREFIX . "_site ORDER BY sitename ASC";
    } else {
        // Administrateur de sites ou de domaines
        $sql = "SELECT DISTINCT id,sitecode,sitename FROM " . TABLE_PREFIX . "_site s ";
        // l'utilisateur est-il administrateur d'un site ?
        $test1 = grr_sql_query1("SELECT count(login) FROM " . TABLE_PREFIX . "_j_useradmin_site WHERE login='" . getUserName() . "'");
        if ($test1 > 0) {
            $sql .= ", " . TABLE_PREFIX . "_j_useradmin_site u";
        }
        // l'utilisateur est-il administrateur d'un domaine ?
        $test2 = grr_sql_query1("SELECT count(login) FROM " . TABLE_PREFIX . "_j_useradmin_area WHERE login='" . getUserName() . "'");
        if ($test2 > 0) {
            $sql .= ", " . TABLE_PREFIX . "_j_useradmin_area a, " . TABLE_PREFIX . "_j_site_area j";
        }
        $sql .= " WHERE (";
        if ($test1 > 0) {
            $sql .= "(s.id=u.id_site AND u.login='" . getUserName() . "') ";
        }
        if ($test1 > 0 && $test2 > 0) {
            $sql .= " or ";
        }
        if ($test2 > 0) {
            $sql .= "(j.id_site=s.id AND j.id_area=a.id_area AND a.login='" . getUserName() . "')";
        }
        $sql .= ") ORDER BY s.sitename ASC";
    }

         }
     }
     echo '</span>' . PHP_EOL;
 } else {
     echo PHP_EOL . '<table class="table-header"><tr>';
     tdcell($d[$cday]["color"][$i]);
     if ($d[$cday]["res"][$i] != '-') {
         echo '<img src="img_grr/buzy.png" alt="', get_vocab("ressource actuellement empruntee"), '" title="', get_vocab("ressource actuellement empruntee"), '" width="20" height="20" class="image" />', PHP_EOL;
     }
     if (isset($d[$cday]["option_reser"][$i]) && $d[$cday]["option_reser"][$i] != -1) {
         echo '<img src="img_grr/small_flag.png" alt="', get_vocab("reservation_a_confirmer_au_plus_tard_le"), '" title="', get_vocab("reservation_a_confirmer_au_plus_tard_le"), ' ', time_date_string_jma($d[$cday]["option_reser"][$i], $dformat), '" width="20" height="20" class="image" />', PHP_EOL;
     }
     if (isset($d[$cday]["moderation"][$i]) && $d[$cday]["moderation"][$i] == 1) {
         echo '<img src="img_grr/flag_moderation.png" alt="', get_vocab("en_attente_moderation"), '" title="', get_vocab("en_attente_moderation"), '" class="image" />', PHP_EOL;
     }
     $Son_GenreRepeat = grr_sql_query1("SELECT " . TABLE_PREFIX . "_type_area.type_name FROM " . TABLE_PREFIX . "_type_area," . TABLE_PREFIX . "_entry  WHERE  " . TABLE_PREFIX . "_entry.type=" . TABLE_PREFIX . "_type_area.type_letter  AND " . TABLE_PREFIX . "_entry.id = '" . $d[$cday]["id"][$i] . "';");
     if ($Son_GenreRepeat == -1) {
         echo '<span class="small_planning">', PHP_EOL, '<b>', $d[$cday]["data"][$i], '</b><br>';
     } else {
         echo '<span class="small_planning">' . $d[$cday]["data"][$i] . '<br>' . $Son_GenreRepeat . '<br>' . PHP_EOL;
     }
     echo $d[$cday]["who1"][$i] . '<br>' . PHP_EOL;
     if ($d[$cday]["description"][$i] != "") {
         echo '<i>' . $d[$cday]["description"][$i] . '</i>' . PHP_EOL;
     }
     echo '</span>' . PHP_EOL;
 }
 echo '</td>' . PHP_EOL;
 echo '</tr>' . PHP_EOL;
 echo '</table>' . PHP_EOL;
 echo '</a>' . PHP_EOL;

function cal($month, $year)
{
    global $weekstarts;
    if (!isset($weekstarts)) $weekstarts = 0;
    $s = "";
    $daysInMonth = getDaysInMonth($month, $year);
    $date = mktime(12, 0, 0, $month, 1, $year);
    $first = (strftime("%w",$date) + 7 - $weekstarts) % 7;
    $monthName = utf8_strftime("%B",$date);
    $s .= "<table class=\"calendar2\" border=\"1\" cellspacing=\"3\">\n";
    $s .= "<tr>\n";
    $s .= "<td class=\"calendarHeader2\" colspan=\"8\">$monthName&nbsp;$year</td>\n";
    $s .= "</tr>\n";
    $d = 1 - $first;
    $is_ligne1 = 'y';
    while ($d <= $daysInMonth)
    {
        $s .= "<tr>\n";
        for ($i = 0; $i < 7; $i++)
        {
            $basetime = mktime(12,0,0,6,11+$weekstarts,2000);
            $show = $basetime + ($i * 24 * 60 * 60);
            $nameday = utf8_strftime('%A',$show);
            $temp = mktime(0,0,0,$month,$d,$year);
            if ($i==0) $s .= "<td class=\"calendar2\" style=\"vertical-align:bottom;\"><b>S".numero_semaine($temp)."</b></td>\n";
            $s .= "<td class=\"calendar2\" align=\"center\" valign=\"top\">";
            if ($is_ligne1 == 'y') $s .=  '<b>'.ucfirst(substr($nameday,0,1)).'</b><br />';
            if ($d > 0 && $d <= $daysInMonth)
            {
                $s .= $d;
                $day = grr_sql_query1("SELECT day FROM ".TABLE_PREFIX."_calendar WHERE day='$temp'");
                $s .= "<br /><input type=\"checkbox\" name=\"$temp\" value=\"$nameday\" ";
                if (!($day < 0)) $s .= "checked=\"checked\" ";
                $s .= " />";
            } else {
                $s .= "&nbsp;";
            }
            $s .= "</td>\n";
            $d++;
        }
        $s .= "</tr>\n";
        $is_ligne1 = 'n';
    }
    $s .= "</table>\n";
    return $s;
}

if (isset($result) and ($result != '')) {
    echo "<div class=\"page_sans_col_gauche\">";
    echo "<h2>".encode_message_utf8("Résultat de la mise à jour")."</h2>";
    echo encode_message_utf8($result);
    echo $result_inter;
    echo "</div>";
}

// Test de cohérence des types de réservation
if ($version_grr > "1.9.1") {
    $res = grr_sql_query("select distinct type from ".TABLE_PREFIX."_entry order by type");
    if ($res) {
        $liste = "";
        for ($i = 0; ($row = grr_sql_row($res, $i)); $i++)
        {
            $test = grr_sql_query1("select type_letter from ".TABLE_PREFIX."_type_area where type_letter='".$row[0]."'");
            if ($test == -1) $liste .= $row[0]." ";
        }
        if ($liste != "") {
            echo encode_message_utf8("<table border=\"1\" cellpadding=\"5\"><tr><td><p><span style=\"color:red;\"><b>ATTENTION : votre table des types de réservation n'est pas à jour :</b></span></p>");
            echo encode_message_utf8("<p>Depuis la version 1.9.2, les types de réservation ne sont plus définis dans le fichier config.inc.php
            mais directement en ligne. Un ou plusieurs types sont actuellement utilisés dans les réservations
            mais ne figurent pas dans la tables des types. Cela risque d'engendrer des messages d'erreur. <b>Il s'agit du ou des types suivants : ".$liste."</b>");
            echo encode_message_utf8("<br /><br />Vous devez donc définir dans <a href= './admin_type.php'>l'interface de gestion des types</a>, le ou les types manquants, en vous aidant éventuellement des informations figurant dans votre ancien fichier config.inc.php.</p></td></tr></table>");
        }
    }
}
// fin de l'affichage de la colonne de droite
if ($valid == 'no') echo "</td></tr></table>";
?>
</body>

foreach ($_POST as $index => $valeur) {
    $index = stripslashes(trim($valeur));
}
$mail_entete = "MIME-Version: 1.0\r\n";
$mail_entete .= "From: {$_POST['nom']} " . "<{$_POST['email']}>\r\n";
$mail_entete .= 'Reply-To: ' . $_POST['email'] . "\r\n";
$mail_entete .= 'Content-Type: text/plain; charset="iso-8859-1"';
$mail_entete .= "\r\nContent-Transfer-Encoding: 8bit\r\n";
$mail_entete .= 'X-Mailer:PHP/' . phpversion() . "\r\n";
$mail_corps = "<html><head></head><body> Message de :" . $_POST['prenom'] . " " . $_POST['nom'] . "<br/>";
$mail_corps .= "Email : " . $_POST['email'] . "<br/>";
$mail_corps .= "Téléphone : " . $_POST['telephone'] . "<br/><br/>";
$mail_corps .= "<b> Sujet de la réservation :" . $_POST['sujet'] . "</b><br/><br/>";
$id .= $_POST['area'];
$sql_areaName .= "SELECT area_name FROM " . TABLE_PREFIX . "_area where id = \"{$id}\" ";
$res_areaName .= grr_sql_query1($sql_areaName);
$mail_corps .= "Domaines : " . $res_areaName . "<br/> ";
$mail_corps .= "Salle : " . $_POST['room'] . "<br/><br/>";
$mail_corps .= "Date  :" . $_POST['start_day'] . "/" . $_POST['start_month'] . "/" . $_POST['start_year'] . " <br/>";
$mail_corps .= "Heure réservation  : " . $_POST['heure'] . "h  " . $_POST['minutes'] . "min<br/>";
$mail_corps .= "Durée de la réservation : " . $_POST['duree'] . " \n";
$mail_corps .= " h " . $_POST['dureemin'] . " \n</body></html>";
$mail_destinataire = Settings::get("mail_destinataire");
$mail_method = Settings::get("grr_mail_method");
if ($mail_method == 'mail') {
    if (mail($mail_destinataire, 'Demande de réservation', $mail_corps, $mail_entete)) {
        header('Location: week_all.php');
    } else {
        echo "le message n'a pas été envoyé et donc mail n'est pas installé";
    }
} else {

    destination = box.options[box.selectedIndex].value;
    if (destination) location.href = destination;
    }
    // -->
    </script>
    <noscript>
    <div><input type=\"submit\" value=\"Change\" /></div>
    </noscript>
    </form>";

echo $out_html;


$this_area_name = grr_sql_query1("select area_name from ".TABLE_PREFIX."_area where id=$id_area");
$this_room_name = grr_sql_query1("select room_name from ".TABLE_PREFIX."_room where id=$room");
$this_room_name_des = grr_sql_query1("select description from ".TABLE_PREFIX."_room where id=$room");
echo "</td>\n";

# Show all rooms in the current area
echo "<td><p><b>".get_vocab("rooms")."</b></p>";

# should we show a drop-down for the room list, or not?
$out_html = "<form id=\"room\" action=\"admin_email_manager.php\" method=\"post\">\n<div><select name=\"room\" onchange=\"room_go()\">\n";
$out_html .= "<option value=\"admin_email_manager.php?id_area=$id_area&amp;room=-1\">".get_vocab('select')."</option>\n";

    $sql = "select id, room_name, description from ".TABLE_PREFIX."_room where area_id=$id_area ";
    // on ne cherche pas parmi les ressources invisibles pour l'utilisateur
    foreach($tab_rooms_noaccess as $key){
      $sql .= " and id != $key ";
    };
    $sql .= "order by room_name";

 }
 // On teste si l'utilisateur administre une ressource
 $test_room = grr_sql_query1("SELECT count(r.room_name) FROM " . TABLE_PREFIX . "_room r\n\t\t\t\tleft join " . TABLE_PREFIX . "_j_user_room j on r.id=j.id_room\n\t\t\t\tWHERE j.login = '" . $user_login . "'");
 if ($test_room > 0 or $user_statut == 'administrateur') {
     $col[$i][3] .= "<span class=\"style_privilege\"> G</span>";
 } else {
     $col[$i][3] .= "";
 }
 // On teste si l'utilisateur gère les utilisateurs
 if ($user_statut == "gestionnaire_utilisateur") {
     $col[$i][3] .= "<span class=\"style_privilege\"> U</span>";
 } else {
     $col[$i][3] .= "";
 }
 // On teste si l'utilisateur reçoit des mails automatiques
 $test_mail = grr_sql_query1("SELECT count(r.room_name) FROM " . TABLE_PREFIX . "_room r\n\t\t\t\tleft join " . TABLE_PREFIX . "_j_mailuser_room j on r.id=j.id_room\n\t\t\t\tWHERE j.login = '" . $user_login . "'");
 if ($test_mail > 0) {
     $col[$i][3] .= "<span class=\"style_privilege\"> E</span>";
 } else {
     $col[$i][3] .= " ";
 }
 // Affichage du statut
 if ($user_statut == "administrateur") {
     $color[$i] = 'style_admin';
     $col[$i][4] = get_vocab("statut_administrator");
 }
 if ($user_statut == "visiteur") {
     $color[$i] = 'style_visiteur';
     $col[$i][4] = get_vocab("statut_visitor");
 }
 if ($user_statut == "utilisateur") {

     } else {
         for ($j = 0; $row_room = grr_sql_row($res_room, $j); $j++) {
             $is_gestionnaire .= $row_room[0] . "<br />";
         }
     }
 }
 $req_mail = "SELECT r.room_name from " . TABLE_PREFIX . "_room r\n\t\t\t\tleft join " . TABLE_PREFIX . "_j_mailuser_room j on r.id=j.id_room\n\t\t\t\tleft join " . TABLE_PREFIX . "_area a on r.area_id=a.id\n\t\t\t\twhere j.login = '" . $user_login . "' and a.id='" . $row_area[0] . "'";
 $res_mail = grr_sql_query($req_mail);
 $is_mail = '';
 if ($res_mail) {
     for ($j = 0; $row_mail = grr_sql_row($res_mail, $j); $j++) {
         $is_mail .= $row_mail[0] . "<br />";
     }
 }
 if ($row_area[2] == 'r') {
     $test_restreint = grr_sql_query1("SELECT count(id_area) from " . TABLE_PREFIX . "_j_user_area j where j.login = '" . $user_login . "' and j.id_area='" . $row_area[0] . "'");
     if ($test_restreint >= 1) {
         $is_restreint = 'y';
     } else {
         $is_restreint = 'n';
     }
 } else {
     $is_restreint = 'n';
 }
 if ($is_admin == 'y' || $is_restreint == 'y' || $is_gestionnaire != '' || $is_mail != '') {
     $a_privileges = 'y';
     echo "<h3>" . get_vocab("match_area") . get_vocab("deux_points") . $row_area[1];
     if ($row_area[2] == 'r') {
         echo " (" . $vocab["restricted"] . ")";
     }
     echo "</h3>";

}

if (isset($_SESSION['default_language'])) {
    // si l'utilisateur a défini sa propre langue
    $locale = $_SESSION['default_language'];
} else if ($defaultlanguage) {
    // sinon, on utilise la variable stockée dans la base
    $locale = $defaultlanguage;
} else {
    // sinon, on fixe la valeur à "fr"
    $locale = 'fr';
}

// $pass_leng est utilisé dans les fichiers langue, d'où la ligne ci-dessous
$pass_leng = "";
if (isset($fichier_mysql_inc_est_present)) $pass_leng = grr_sql_query1("select VALUE from ".TABLE_PREFIX."_setting where NAME = 'pass_leng'");

// Fichier de traduction
if (@file_exists("language/lang." . $locale)) {
    $lang_file = "language/lang." . $locale;
} else {
    $lang_file = "language/lang.fr";
}

// Dans le cas où le script verif_auto_grr.php est utilisé en tâche cron, il faut ici, donner le chemin complet.
if (defined("CHEMIN_COMPLET_GRR")){
  chdir(CHEMIN_COMPLET_GRR);
}
include $lang_file;

//Show all areas
echo "<td ><p><b>" . get_vocab("areas") . "</b></p>\n";
$out_html = '<form id="area" action="admin_right_admin.php" method="post">' . PHP_EOL . '<div>' . PHP_EOL . '<select class="form-control" name="area" onchange="area_go()">' . PHP_EOL;
$out_html .= '<option value="admin_right_admin.php?id_area=-1">' . get_vocab('select') . '</option>' . PHP_EOL;
$sql = "SELECT id, area_name FROM " . TABLE_PREFIX . "_area ORDER BY order_display";
$res = grr_sql_query($sql);
if ($res) {
    for ($i = 0; $row = grr_sql_row($res, $i); $i++) {
        $selected = $row[0] == $id_area ? 'selected="selected"' : "";
        $link = 'admin_right_admin.php?id_area=' . $row[0];
        $out_html .= '<option ' . $selected . ' value="' . $link . '">' . htmlspecialchars($row[1]) . '</option>' . PHP_EOL;
    }
}
$out_html .= "</select>\n<script type=\"text/javascript\" >\n\t<!--\n\tfunction area_go()\n\t{\n\t\tbox = document.getElementById(\"area\").area;\n\t\tdestination = box.options[box.selectedIndex].value;\n\t\tif (destination) location.href = destination;\n\t}\n// -->\n</script>\n</div>\n<noscript>\n\t<div><input type=\"submit\" value=\"Change\" /></div>\n</noscript>\n</form>";
echo $out_html;
$this_area_name = grr_sql_query1("SELECT area_name FROM " . TABLE_PREFIX . "_area WHERE id={$id_area}");
echo '</td>' . PHP_EOL;
echo '</tr>' . PHP_EOL . '</table>' . PHP_EOL;
if ($id_area <= 0) {
    echo '<h1>' . get_vocab("no_area") . '</h1>' . PHP_EOL;
    // fin de l'affichage de la colonne de droite
    echo '</td>' . PHP_EOL . '</tr>' . PHP_EOL . '</table>' . PHP_EOL . '</body>' . PHP_EOL . '</html>' . PHP_EOL;
    exit;
}
//Show area:
echo '<table class="table table-bordered">' . PHP_EOL . '<tr>' . PHP_EOL;
$is_admin = 'yes';
?>
<td>
	<?php 
$exist_admin = 'no';

		<?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");
?>
			</b>
		</td>