本文整理汇总了PHP中grr_sql_query1函数的典型用法代码示例。如果您正苦于以下问题：PHP grr_sql_query1函数的具体用法？PHP grr_sql_query1怎么用？PHP grr_sql_query1使用的例子？那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了grr_sql_query1函数的20个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的PHP代码示例。
示例1: loadSettings
/**
* 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);
}
}
开发者ID:rhertzog，项目名称:lcs，代码行数:31，代码来源:settings.inc.php
示例2: load
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;
}
}
开发者ID:nicolas-san，项目名称:GRRV4，代码行数:21，代码来源:settings.class.php
示例3: utf8_strftime
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 . '&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 . '&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 . '&Err=yes">' . get_vocab('returnprev') . '</a>';
include 'include/trailer.inc.php';
die;
}
开发者ID:nicolas-san，项目名称:GRRV4，代码行数:31，代码来源:edit_entry_handler.php
示例4: grr_resumeSession
/**
* 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;
}
}
}
开发者ID:JeromeDevome，项目名称:GRR，代码行数:71，代码来源:session.inc.php
示例5: grr_sql_query1
?>
</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";
}
开发者ID:Sirlefou1，项目名称:GRR2，代码行数:31，代码来源:admin_room.php
示例6: tdcell
}
}
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;
开发者ID:JeromeDevome，项目名称:GRR，代码行数:31，代码来源:week_all.php
示例7: cal
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 $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 .= " ";
}
$s .= "</td>\n";
$d++;
}
$s .= "</tr>\n";
$is_ligne1 = 'n';
}
$s .= "</table>\n";
return $s;
}
开发者ID:rhertzog，项目名称:lcs，代码行数:46，代码来源:admin_calend_ignore.php
示例8: encode_message_utf8
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>
开发者ID:rhertzog，项目名称:lcs，代码行数:31，代码来源:admin_maj.php
示例9: foreach
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 {
开发者ID:nicolas-san，项目名称:GRRV4，代码行数:31，代码来源:traitementcontact.php
示例10: grr_sql_query1
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&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";
开发者ID:rhertzog，项目名称:lcs，代码行数:31，代码来源:admin_email_manager.php
示例11: grr_sql_query1
}
// 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") {
开发者ID:Sirlefou1，项目名称:GRR2，代码行数:31，代码来源:admin_user.php
示例12: grr_sql_query
} 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>";
开发者ID:Birssan，项目名称:GRR，代码行数:31，代码来源:admin_user_modify.php
示例13: if
}
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;
开发者ID:rhertzog，项目名称:lcs，代码行数:29，代码来源:language.inc.php
示例14: get_vocab
//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';
开发者ID:Sirlefou1，项目名称:GRR2，代码行数:31，代码来源:admin_right_admin.php
示例15: get_vocab
<?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>
开发者ID:Birssan，项目名称:GRR，代码行数:31，代码来源:view_entry.php
示例16: showAccessDenied
if (authGetUserLevel(getUserName(), -1) < 1) {
showAccessDenied($back);
exit;
}
if (!getWritable($info['beneficiaire'], getUserName(), $id)) {
showAccessDenied($back);
exit;
}
if (authUserAccesArea(getUserName(), $area) == 0) {
showAccessDenied($back);
exit;
}
if (Settings::get('automatic_mail') == 'yes') {
$_SESSION['session_message_error'] = send_mail($id, 3, $dformat);
}
$room_id = grr_sql_query1('SELECT ' . TABLE_PREFIX . '_entry.room_id FROM ' . TABLE_PREFIX . '_entry, ' . TABLE_PREFIX . '_room WHERE ' . TABLE_PREFIX . '_entry.room_id = ' . TABLE_PREFIX . '_room.id AND ' . TABLE_PREFIX . "_entry.id='" . $id . "'");
$date_now = time();
get_planning_area_values($area);
if (!verif_booking_date(getUserName(), $id, $room_id, -1, $date_now, $enable_periods) || verif_booking_date(getUserName(), $id, $room_id, -1, $date_now, $enable_periods) && $can_delete_or_create != 'y') {
showAccessDenied($back);
exit;
}
/* avant la suppression, dispatch de l'event */
$event = new EntryEventClass(false, false, $id, false);
$dispatcher->dispatch(DelEntryEvent::DELENTRY_START, $event);
$result = mrbsDelEntry(getUserName(), $id, $series, 1);
/* après la suppression, dispatch de l'event */
$eventEnd = new EntryEventClass(false, false, $id, false);
$dispatcher->dispatch(DelEntryEvent::DELENTRY_END, $eventEnd);
if ($result) {
$_SESSION['displ_msg'] = 'yes';
开发者ID:nicolas-san，项目名称:GRRV4，代码行数:31，代码来源:del_entry.php
示例17: get_vocab
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");
echo "<br /><input type=\"text\" name=\"objet_message\" id=\"objet_message\" size=\"40\" maxlength=\"256\" value=''/>\n";
echo "<textarea name=\"message\" cols=\"50\" rows=\"5\">".$corps_message."</textarea><br />";
echo get_vocab("E-mail pour la reponse").get_vocab("deux_points");
echo "<input type=\"text\" name=\"email_reponse\" id=\"email_reponse\" size=\"40\" maxlength=\"256\" ";
if ($email_reponse != '') {
echo "value='".$email_reponse."' ";
} else if (($fin_session == 'n') and (getUserName()!='')) {
$user_email = grr_sql_query1("select email from ".TABLE_PREFIX."_utilisateurs where login='".getUserName()."'");
if (($user_email != "") and ($user_email != -1))
echo "value='".$user_email."' ";
}
echo "/>\n";
echo "<br />\n";
echo "<p style=\"text-align:center;\">";
echo "<input type='button' value='".get_vocab("submit")."' onclick='verif_et_valide_envoi();' />\n";
echo "</p>\n";
echo "</div>\n";
echo "</form>\n";
echo "<script type='text/javascript'>
function verif_et_valide_envoi() {
if(document.getElementById('objet_message')) {
开发者ID:rhertzog，项目名称:lcs，代码行数:31，代码来源:contact.php
示例18: get_vocab
}
// Description complète
if (authGetUserLevel($getUserName(), -1) >= Settings::get("acces_fiche_reservation") && $row["comment_room"] != '') {
echo "<h3>" . get_vocab("match_descr") . "</h3>\n";
echo "<div>" . $row["comment_room"] . "</div>\n";
}
// Afficher capacité
if ($row["capacity"] != '0') {
echo "<h3>" . get_vocab("capacity_2") . "</h3>\n";
echo "<p>" . $row["capacity"] . "</p>\n";
}
if ($row["max_booking"] != "-1") {
echo "<p>" . get_vocab("msg_max_booking") . get_vocab("deux_points") . $row["max_booking"] . "</p>";
}
// Limitation par domaine
$max_booking_per_area = grr_sql_query1("SELECT max_booking FROM " . TABLE_PREFIX . "_area WHERE id = '" . protect_data_sql($id_area) . "'");
if ($max_booking_per_area >= 0) {
echo "<p>" . get_vocab("msg_max_booking_area") . get_vocab("deux_points") . $max_booking_per_area . "</p>";
}
if ($row["delais_max_resa_room"] != "-1") {
echo "<p>" . get_vocab("delais_max_resa_room_2") . " <b>" . $row["delais_max_resa_room"] . "</b></p>";
}
if ($row["delais_min_resa_room"] != "0") {
echo "<p>" . get_vocab("delais_min_resa_room_2") . " <b>" . $row["delais_min_resa_room"] . "</b></p>";
}
$nom_picture = '';
if ($row['picture_room'] != '') {
$nom_picture = "./images/" . $row['picture_room'];
}
echo "<div style=\"text-align:center; margin-top:30px\"><b>";
if (@file_exists($nom_picture) && $nom_picture) {
开发者ID:BdEINSALyon，项目名称:GRR，代码行数:31，代码来源:view_room.php
示例19: supprimerReservationsUtilisateursEXT
/** supprimerReservationsUtilisateursEXT()
*
* Supprime les réservations des membres qui proviennent d'une source "EXT"
*
*
* Returns:
* 0 - An error occured
* non-zero - The entries were deleted
*/
function supprimerReservationsUtilisateursEXT($avec_resa, $avec_privileges)
{
// Récupération de tous les utilisateurs de la source EXT
$requete_users_ext = "SELECT login FROM " . TABLE_PREFIX . "_utilisateurs WHERE source='ext' and statut<>'administrateur'";
$res = grr_sql_query($requete_users_ext);
$logins = array();
$logins_liaison = array();
if ($res) {
for ($i = 0; $row = grr_sql_row($res, $i); $i++) {
$logins[] = $row[0];
}
}
// Construction des requêtes de suppression à partir des différents utilisateurs à supprimer
if ($avec_resa == 'y') {
// Pour chaque utilisateur, on supprime les réservations qu'il a créées et celles dont il est bénéficiaire
// Table grr_entry
$req_suppr_table_entry = "DELETE FROM " . TABLE_PREFIX . "_entry WHERE create_by = ";
$first = 1;
foreach ($logins as $log) {
if ($first == 1) {
$req_suppr_table_entry .= "'{$log}' OR beneficiaire='{$log}'";
$first = 0;
} else {
$req_suppr_table_entry .= " OR create_by = '{$log}' OR beneficiaire = '{$log}' ";
}
}
// Pour chaque utilisateur, on supprime les réservations périodiques qu'il a créées et celles dont il est bénéficiaire
// Table grr_repeat
$req_suppr_table_repeat = "DELETE FROM " . TABLE_PREFIX . "_repeat WHERE create_by = ";
$first = 1;
foreach ($logins as $log) {
if ($first == 1) {
$req_suppr_table_repeat .= "'{$log}' OR beneficiaire='{$log}'";
$first = 0;
} else {
$req_suppr_table_repeat .= " OR create_by = '{$log}' OR beneficiaire = '{$log}' ";
}
}
// Pour chaque utilisateur, on supprime les réservations périodiques qu'il a créées et celles dont il est bénéficiaire
// Table grr_entry_moderate
$req_suppr_table_entry_moderate = "DELETE FROM " . TABLE_PREFIX . "_entry_moderate WHERE create_by = ";
$first = 1;
foreach ($logins as $log) {
if ($first == 1) {
$req_suppr_table_entry_moderate .= "'{$log}' OR beneficiaire='{$log}'";
$first = 0;
} else {
$req_suppr_table_entry_moderate .= " OR create_by = '{$log}' OR beneficiaire = '{$log}' ";
}
}
}
$req_j_mailuser_room = "";
$req_j_user_area = "";
$req_j_user_room = "";
$req_j_useradmin_area = "";
$req_j_useradmin_site = "";
foreach ($logins as $log) {
// Table grr_j_mailuser_room
$test = grr_sql_query1("SELECT count(login) FROM " . TABLE_PREFIX . "_j_mailuser_room WHERE login='" . $log . "'");
if ($test >= 1) {
if ($avec_privileges == "y") {
if ($req_j_mailuser_room == "") {
$req_j_mailuser_room = "DELETE FROM " . TABLE_PREFIX . "_j_mailuser_room WHERE login='" . $log . "'";
} else {
$req_j_mailuser_room .= " OR login = '" . $log . "'";
}
} else {
$logins_liaison[] = strtolower($log);
}
}
// Table grr_j_user_area
$test = grr_sql_query1("SELECT count(login) FROM " . TABLE_PREFIX . "_j_user_area WHERE login='" . $log . "'");
if ($test >= 1) {
if ($avec_privileges == "y") {
if ($req_j_user_area == "") {
$req_j_user_area = "DELETE FROM " . TABLE_PREFIX . "_j_user_area WHERE login='" . $log . "'";
} else {
$req_j_user_area .= " OR login = '" . $log . "'";
}
} else {
$logins_liaison[] = strtolower($log);
}
}
// Table grr_j_user_room
$test = grr_sql_query1("SELECT count(login) FROM " . TABLE_PREFIX . "_j_user_room WHERE login='" . $log . "'");
if ($test >= 1) {
if ($avec_privileges == "y") {
if ($req_j_user_room == "") {
$req_j_user_room = "DELETE FROM " . TABLE_PREFIX . "_j_user_room WHERE login='" . $log . "'";
} else {
$req_j_user_room .= " OR login = '" . $log . "'";
//.........这里部分代码省略.........
开发者ID:JeromeDevome，项目名称:GRR，代码行数:101，代码来源:functions.inc.php
|
客服电话
APP下载
官方微信
请发表评论