PHP grr_sql_command函数代码示例

OGeek|极客世界-中国程序员成长平台 › 门户 › 编程› PHP›PHP编程经验

原作者: [db:作者] 来自: [db:来源] 收藏邀请

本文整理汇总了PHP中grr_sql_command函数的典型用法代码示例。如果您正苦于以下问题：PHP grr_sql_command函数的具体用法？PHP grr_sql_command怎么用？PHP grr_sql_command使用的例子？那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。

在下文中一共展示了grr_sql_command函数的17个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的PHP代码示例。

示例1: delete_user

function delete_user($login)
{
    $sql = "SELECT source FROM " . TABLE_PREFIX . "_utilisateurs\n\t    WHERE login LIKE '{$login}'";
    $res = grr_sql_query($sql);
    $row = grr_sql_row($res, 0);
    $source = $row[0];
    if ($source == 'ext') {
        // Si l'utilisateur avait été créé automatiquement, on le
        // supprime
        // Cf. admin_user.php l99 et l203
        $sql = "DELETE FROM " . TABLE_PREFIX . "_utilisateurs WHERE login='{$login}'";
        if (grr_sql_command($sql) < 0) {
            fatal_error(1, "<p>" . grr_sql_error());
        } else {
            grr_sql_command("DELETE FROM " . TABLE_PREFIX . "_j_mailuser_room  WHERE login='{$login}'");
            grr_sql_command("DELETE FROM " . TABLE_PREFIX . "_j_user_area      WHERE login='{$login}'");
            grr_sql_command("DELETE FROM " . TABLE_PREFIX . "_j_user_room      WHERE login='{$login}'");
            grr_sql_command("DELETE FROM " . TABLE_PREFIX . "_j_useradmin_area WHERE login='{$login}'");
            grr_sql_command("DELETE FROM " . TABLE_PREFIX . "_j_useradmin_site WHERE login='{$login}'");
        }
        // Fin de la session
        grr_closeSession($_GET['auto']);
    }
    // sinon c'est source="local": on le garde et il y a toujours accès
    // classique login/mot de passe).
}

开发者ID:nicolas-san，项目名称:GRRV4，代码行数:26，代码来源:delete_user.php

示例2: grr_sql_query

       grr_sql_query("DELETE from ".TABLE_PREFIX."_setting where NAME = 'maj196_qui_peut_reserver_pour'");
       grr_sql_query("INSERT INTO ".TABLE_PREFIX."_setting VALUES ('maj196_qui_peut_reserver_pour', '1');");
       $result .= "<b>Mise à jour du champs qui_peut_reserver_pour : </b><span style=\"color:green;\">Ok !</span><br /><br />";
    }


    // Mise à jour du numéro de version
    $req = grr_sql_query1("SELECT VALUE FROM ".TABLE_PREFIX."_setting WHERE NAME='version'");
    if ($req == -1) {
        $result_inter .= traite_requete("INSERT INTO ".TABLE_PREFIX."_setting VALUES ('version', '".$version_grr."');");
    } else {
        $result_inter .= traite_requete("UPDATE ".TABLE_PREFIX."_setting SET VALUE='".$version_grr."' WHERE NAME='version';");
    }

    // Mise à jour du numéro de RC
    $req = grr_sql_command("DELETE FROM ".TABLE_PREFIX."_setting WHERE NAME='versionRC'");
    $result_inter .= traite_requete("INSERT INTO ".TABLE_PREFIX."_setting VALUES ('versionRC', '".$version_grr_RC."');");


    //Re-Chargement des valeurs de la table settingS
    if (!loadSettings()) {
        die("Erreur chargement settings");
    }
    affiche_pop_up(get_vocab("maj_good"),"force");
}
// Numéro de version effective
$version_old = getSettingValue("version");
if ($version_old == "") $version_old = "1.3";
// Numéro de RC
$version_old_RC = getSettingValue("versionRC");

开发者ID:rhertzog，项目名称:lcs，代码行数:30，代码来源:admin_maj.php

示例3: NettoyerTablesJointure

/** NettoyerTablesJointure()
 *
 * Supprime les lignes inutiles dans les tables de liaison
 *
 */
function NettoyerTablesJointure()
{
    $nb = 0;
    // Table grr_j_mailuser_room
    $req = "SELECT j.login FROM " . TABLE_PREFIX . "_j_mailuser_room j\n\tLEFT JOIN " . TABLE_PREFIX . "_utilisateurs u on u.login=j.login\n\tWHERE (u.login  IS NULL)";
    $res = grr_sql_query($req);
    if ($res) {
        for ($i = 0; $row = grr_sql_row($res, $i); $i++) {
            $nb++;
            grr_sql_command("delete from " . TABLE_PREFIX . "_j_mailuser_room where login='" . $row[0] . "'");
        }
    }
    // Table grr_j_user_area
    $req = "SELECT j.login FROM " . TABLE_PREFIX . "_j_user_area j\n\tLEFT JOIN " . TABLE_PREFIX . "_utilisateurs u on u.login=j.login\n\tWHERE (u.login  IS NULL)";
    $res = grr_sql_query($req);
    if ($res) {
        for ($i = 0; $row = grr_sql_row($res, $i); $i++) {
            $nb++;
            grr_sql_command("delete from " . TABLE_PREFIX . "_j_user_area where login='" . $row[0] . "'");
        }
    }
    // Table grr_j_user_room
    $req = "SELECT j.login FROM " . TABLE_PREFIX . "_j_user_room j\n\tLEFT JOIN " . TABLE_PREFIX . "_utilisateurs u on u.login=j.login\n\tWHERE (u.login  IS NULL)";
    $res = grr_sql_query($req);
    if ($res) {
        for ($i = 0; $row = grr_sql_row($res, $i); $i++) {
            $nb++;
            grr_sql_command("DELETE FROM " . TABLE_PREFIX . "_j_user_room WHERE login='" . $row[0] . "'");
        }
    }
    // Table grr_j_useradmin_area
    $req = "SELECT j.login FROM " . TABLE_PREFIX . "_j_useradmin_area j\n\tLEFT JOIN " . TABLE_PREFIX . "_utilisateurs u on u.login=j.login\n\tWHERE (u.login  IS NULL)";
    $res = grr_sql_query($req);
    if ($res) {
        for ($i = 0; $row = grr_sql_row($res, $i); $i++) {
            $nb++;
            grr_sql_command("DELETE FROM " . TABLE_PREFIX . "_j_useradmin_area WHERE login='" . $row[0] . "'");
        }
    }
    // Table grr_j_useradmin_site
    $req = "SELECT j.login FROM " . TABLE_PREFIX . "_j_useradmin_site j\n\tLEFT JOIN " . TABLE_PREFIX . "_utilisateurs u on u.login=j.login\n\tWHERE (u.login  IS NULL)";
    $res = grr_sql_query($req);
    if ($res) {
        for ($i = 0; $row = grr_sql_row($res, $i); $i++) {
            $nb++;
            grr_sql_command("DELETE FROM " . TABLE_PREFIX . "_j_useradmin_site WHERE login='" . $row[0] . "'");
        }
    }
    // Suppression effective
    echo "<hr />\n";
    echo "<p class='avertissement'>" . get_vocab("tables_liaison") . get_vocab("deux_points") . $nb . get_vocab("entres_supprimees") . "</p>\n";
}

开发者ID:JeromeDevome，项目名称:GRR，代码行数:57，代码来源:functions.inc.php

示例4: grr_sql_query1

        $test_statut = grr_sql_query1("SELECT statut FROM " . TABLE_PREFIX . "_utilisateurs WHERE login='" . $_GET['user_del'] . "'");
        if ($test_statut == "gestionnaire_utilisateur" || $test_statut == "administrateur") {
            $can_delete = "no";
        }
    }
    if ($temp != getUserName() && $can_delete == "yes") {
        $temp = str_replace('\\', '\\\\', $temp);
        $sql = "DELETE FROM " . TABLE_PREFIX . "_utilisateurs WHERE login='{$temp}'";
        if (grr_sql_command($sql) < 0) {
            fatal_error(1, "<p>" . grr_sql_error());
        } else {
            grr_sql_command("DELETE FROM " . TABLE_PREFIX . "_j_mailuser_room WHERE login='{$temp}'");
            grr_sql_command("DELETE FROM " . TABLE_PREFIX . "_j_user_area WHERE login='{$temp}'");
            grr_sql_command("DELETE FROM " . TABLE_PREFIX . "_j_user_room WHERE login='{$temp}'");
            grr_sql_command("DELETE FROM " . TABLE_PREFIX . "_j_useradmin_area WHERE login='{$temp}'");
            grr_sql_command("DELETE FROM " . TABLE_PREFIX . "_j_useradmin_site WHERE login='{$temp}'");
            $msg = get_vocab("del_user_succeed");
        }
    }
}
if (isset($mess) && $mess != "") {
    echo "<p>" . $mess . "</p>";
}
echo "<h2>" . get_vocab('admin_user.php') . "</h2>";
if (empty($display)) {
    $display = 'actifs';
}
if (empty($order_by)) {
    $order_by = 'nom,prenom';
}
?>

开发者ID:Sirlefou1，项目名称:GRR2，代码行数:31，代码来源:admin_user.php

示例5: NettoyerTablesJointure

/** NettoyerTablesJointure()
 * Supprime les lignes inutiles dans les tables de liaison.
 */
function NettoyerTablesJointure()
{
    $nb = 0;
    // Table grr_j_mailuser_room
    $req = 'SELECT j.login FROM ' . TABLE_PREFIX . '_j_mailuser_room j
	LEFT JOIN ' . TABLE_PREFIX . '_utilisateurs u on u.login=j.login
	WHERE (u.login  IS NULL)';
    $res = grr_sql_query($req);
    if ($res) {
        for ($i = 0; $row = grr_sql_row($res, $i); ++$i) {
            ++$nb;
            grr_sql_command('delete from ' . TABLE_PREFIX . "_j_mailuser_room where login='" . $row[0] . "'");
        }
    }
    // Table grr_j_user_area
    $req = 'SELECT j.login FROM ' . TABLE_PREFIX . '_j_user_area j
	LEFT JOIN ' . TABLE_PREFIX . '_utilisateurs u on u.login=j.login
	WHERE (u.login  IS NULL)';
    $res = grr_sql_query($req);
    if ($res) {
        for ($i = 0; $row = grr_sql_row($res, $i); ++$i) {
            ++$nb;
            grr_sql_command('delete from ' . TABLE_PREFIX . "_j_user_area where login='" . $row[0] . "'");
        }
    }
    // Table grr_j_user_room
    $req = 'SELECT j.login FROM ' . TABLE_PREFIX . '_j_user_room j
	LEFT JOIN ' . TABLE_PREFIX . '_utilisateurs u on u.login=j.login
	WHERE (u.login  IS NULL)';
    $res = grr_sql_query($req);
    if ($res) {
        for ($i = 0; $row = grr_sql_row($res, $i); ++$i) {
            ++$nb;
            grr_sql_command('DELETE FROM ' . TABLE_PREFIX . "_j_user_room WHERE login='" . $row[0] . "'");
        }
    }
    // Table grr_j_useradmin_area
    $req = 'SELECT j.login FROM ' . TABLE_PREFIX . '_j_useradmin_area j
	LEFT JOIN ' . TABLE_PREFIX . '_utilisateurs u on u.login=j.login
	WHERE (u.login  IS NULL)';
    $res = grr_sql_query($req);
    if ($res) {
        for ($i = 0; $row = grr_sql_row($res, $i); ++$i) {
            ++$nb;
            grr_sql_command('DELETE FROM ' . TABLE_PREFIX . "_j_useradmin_area WHERE login='" . $row[0] . "'");
        }
    }
    // Table grr_j_useradmin_site
    $req = 'SELECT j.login FROM ' . TABLE_PREFIX . '_j_useradmin_site j
	LEFT JOIN ' . TABLE_PREFIX . '_utilisateurs u on u.login=j.login
	WHERE (u.login  IS NULL)';
    $res = grr_sql_query($req);
    if ($res) {
        for ($i = 0; $row = grr_sql_row($res, $i); ++$i) {
            ++$nb;
            grr_sql_command('DELETE FROM ' . TABLE_PREFIX . "_j_useradmin_site WHERE login='" . $row[0] . "'");
        }
    }
    // Suppression effective
    echo "<hr />\n";
    echo "<p class='avertissement'>" . get_vocab('tables_liaison') . get_vocab('deux_points') . $nb . get_vocab('entres_supprimees') . "</p>\n";
}

开发者ID:nicolas-san，项目名称:GRR，代码行数:65，代码来源:functions.inc.php

示例6: fatal_error

            $clef = 0;
            $upd = "UPDATE " . TABLE_PREFIX . "_entry SET clef='{$clef}' WHERE id = '" . $id . "'";
            if (grr_sql_command($upd) < 0) {
                fatal_error(0, grr_sql_error());
            }
        }
        if (isset($_GET['courrier'])) {
            $courrier = 1;
            $upd = "UPDATE " . TABLE_PREFIX . "_entry SET courrier='{$courrier}' WHERE id = '" . $id . "'";
            if (grr_sql_command($upd) < 0) {
                fatal_error(0, grr_sql_error());
            }
        } else {
            $courrier = 0;
            $upd = "UPDATE " . TABLE_PREFIX . "_entry SET courrier='{$courrier}' WHERE id = '" . $id . "'";
            if (grr_sql_command($upd) < 0) {
                fatal_error(0, grr_sql_error());
            }
        }
        if (isset($_GET["envoyer_mail"]) && Settings::get("automatic_mail") == 'yes') {
            $_SESSION['session_message_error'] = send_mail($id, 7, $dformat);
            if ($_SESSION['session_message_error'] == "") {
                $_SESSION['displ_msg'] = "yes";
                $_SESSION["msg_a_afficher"] = get_vocab("un email envoye") . " " . $_GET["mail_exist"];
            }
        }
        header("Location: " . $_GET['back'] . "");
        die;
    }
}
if (!isset($day) || !isset($month) || !isset($year)) {

开发者ID:Birssan，项目名称:GRR，代码行数:31，代码来源:view_entry.php

示例7: mktime

             $n = mktime(0,0,0,$month,$day,$year);
             if (isset($_POST[$n])) {
                 // Le jour a été selectionné dans le calendrier
                 $starttime = mktime($morningstarts, 0, 0, $month, $day  , $year);
                 $endtime   = mktime($eveningends, 0, $resolution, $month, $day, $year);
                 // Pour toutes les dates bon précédement enregistrées, on efface toutes les résa en conflit
                 if (!in_array($n,$day_old)) {
                   $sql = "select id from ".TABLE_PREFIX."_room";
                   $res = grr_sql_query($sql);
                   if ($res) for ($i = 0; ($row = grr_sql_row($res, $i)); $i++)
                       $result += grrDelEntryInConflict($row[0], $starttime, $endtime, 0, 0, 1);
                 }

                 // On enregistre la valeur dans ".TABLE_PREFIX."_calendar
                 $sql = "INSERT INTO ".TABLE_PREFIX."_calendar set DAY='".$n."'";
                 if (grr_sql_command($sql) < 0) fatal_error(0, "<p>" . grr_sql_error());
             }
             $day++;
         }
         $month++;
         if ($month == 13) {
            $year++;
             $month = 1;
         }
    }
}


    echo "\n<p>".get_vocab("les_journees_cochees_sont_ignorees")."</p>";
    echo "\n<table cellpadding=\"3\">\n";
    $basetime = mktime(12,0,0,6,11+$weekstarts,2000);

开发者ID:rhertzog，项目名称:lcs，代码行数:31，代码来源:admin_calend_ignore.php

示例8: delete_site

 function delete_site($id)
 {
  if (!(isset($_GET['confirm']))) {
      echo '<h2>'.get_vocab('supprimer site').'</h2>';
      echo '<h2 style="text-align:center;">' .  get_vocab('sure') . '</h2>';
      echo '<h2 style="text-align:center;"><a href="admin_site.php?action=delete&amp;id='.$id.'&amp;confirm=yes">' . get_vocab('YES') . '!</a> &nbsp;&nbsp;&nbsp; <a href="admin_site.php?action=delete&amp;id='.$id.'&amp;confirm=no">' . get_vocab('NO') . '!</a></h2>';
  } else {
    if ($_GET['confirm']=='yes') {
     grr_sql_command("delete from ".TABLE_PREFIX."_site where id='".$_GET['id']."'");
     grr_sql_command("delete from ".TABLE_PREFIX."_j_site_area where id_site='".$_GET['id']."'");
     grr_sql_command("delete from ".TABLE_PREFIX."_j_useradmin_site where id_site='".$_GET['id']."'");
     grr_sql_command("update ".TABLE_PREFIX."_utilisateurs set default_site = '-1' where default_site='".$_GET['id']."'");
     $test = grr_sql_query1("select VALUE from ".TABLE_PREFIX."_setting where NAME='default_site'");
     if ($test==$_GET['id'])
          grr_sql_command("delete from ".TABLE_PREFIX."_setting where NAME='default_site'");


     // On affiche le tableau des sites
     read_sites();

    } else {
     // On affiche le tableau des sites
     read_sites();

    }
 }

 }

开发者ID:rhertzog，项目名称:lcs，代码行数:28，代码来源:admin_site.php

示例9: grrDelOverloadFromEntries

         grrDelOverloadFromEntries($id_overload);
         $sql = "DELETE FROM " . TABLE_PREFIX . "_overload WHERE id={$id_overload};";
         grr_sql_command($sql);
     }
     //OK, nothing there, lets blast it away
     grr_sql_command("DELETE FROM " . TABLE_PREFIX . "_area WHERE id={$id_area}");
     grr_sql_command("update " . TABLE_PREFIX . "_utilisateurs set default_area = '-1', default_room = '-1' WHERE default_area='" . $id_area . "'");
     grr_sql_command("DELETE FROM " . TABLE_PREFIX . "_area_periodes WHERE id_area={$id_area}");
     grr_sql_command("DELETE FROM " . TABLE_PREFIX . "_j_useradmin_area WHERE id_area={$id_area}");
     grr_sql_command("DELETE FROM " . TABLE_PREFIX . "_j_type_area WHERE id_area={$id_area}");
     grr_sql_command("DELETE FROM " . TABLE_PREFIX . "_j_user_area WHERE id_area={$id_area}");
     grr_sql_command("DELETE FROM " . TABLE_PREFIX . "_j_site_area WHERE id_area={$id_area}");
     $test = grr_sql_query1("select VALUE from " . TABLE_PREFIX . "_setting WHERE NAME='default_area'");
     if ($test == $id_area) {
         grr_sql_command("DELETE FROM " . TABLE_PREFIX . "_setting WHERE NAME='default_area'");
         grr_sql_command("DELETE FROM " . TABLE_PREFIX . "_setting WHERE NAME='default_room'");
         // Settings
         require_once "./include/settings.class.php";
         //Chargement des valeurs de la table settingS
         if (!Settings::load()) {
             die("Erreur chargement settings");
         }
     }
     //Redirect back to the admin page
     header("Location: admin_room.php?id_site={$id_site}");
     die;
 } else {
     //There are rooms left in the area
     //print the page header
     print_header("", "", "", $type = "with_session");
     //print_banner("", "", "", "", $type = "with_session", $page = "admin");

开发者ID:Sirlefou1，项目名称:GRR2，代码行数:31，代码来源:admin_room_del.php

示例10:

      }

  // On fait l'action si l'id/area a été validé.

  if ( $arearight == True )
    {
      $sql = "update ".TABLE_PREFIX."_overload set
      fieldname='".protect_data_sql($fieldname)."',
      fieldtype='".protect_data_sql($fieldtype)."',
      obligatoire='".$obligatoire."',
      confidentiel='".$confidentiel."',
      affichage='".$affichage."',
      overload_mail='".$overload_mail."',
      fieldlist='".protect_data_sql($fieldlist)."'
      where id=$id_overload;";
      if (grr_sql_command($sql) < 0) fatal_error(0, "$sql \n\n" . grr_sql_error());
    }
}

// X- On affiche la première ligne du tableau avec les libelles.
$html = get_vocab("explication_champs_additionnels")."\n";
$html .= "<form method=\"post\" action=\"admin_overload.php\" >\n<table border=\"0\">";
$html .= "<tr><td>".get_vocab("match_area").get_vocab("deux_points")."</td>\n";
$html .= "<td>".get_vocab("fieldname").get_vocab("deux_points")."</td>\n";
$html .= "<td>".get_vocab("fieldtype").get_vocab("deux_points")."</td>\n";
$html .= "<td><span class='small'>".get_vocab("champ_obligatoire")."</span></td>\n";
$html .= "<td><span class='small'>".get_vocab("affiche_dans_les vues")."</span></td>\n";
$html .= "<td><span class='small'>".get_vocab("affiche_dans_les mails")."</span></td>\n";
$html .= "<td><span class='small'>".get_vocab("champ_confidentiel")."</span></td>\n";
$html .= "<td>&nbsp;</td></tr>\n";

开发者ID:rhertzog，项目名称:lcs，代码行数:30，代码来源:admin_overload.php

示例11: verif_display_email

$verif_display_email = verif_display_email(getUserName(), $room_id);
if ($verif_display_email)
   $option_affiche_nom_prenom_email = "withmail";
else
   $option_affiche_nom_prenom_email = "nomail";

// Si l'utilisateur est administrateur, possibilité de modifier le statut de la réservation (en cours / libérée)
if (($fin_session == 'n') and (getUserName()!='') and (authGetUserLevel(getUserName(),$room_id) >= 3) and (isset($_GET['ok'])))
{
  if (!$was_del)
    {
      if ($reg_statut_id != "") {
        $upd1 = "update ".TABLE_PREFIX."_entry set statut_entry='-' where room_id = '".$room_id."'";
        if (grr_sql_command($upd1) < 0) return 0;
        $upd2 = "update ".TABLE_PREFIX."_entry set statut_entry='$reg_statut_id' where id = '".$id."'";
        if (grr_sql_command($upd2) < 0) return 0;
      }
      if ((isset($_GET["envoyer_mail"])) and (getSettingValue("automatic_mail") == 'yes')) {
          $_SESSION['session_message_error'] = send_mail($id,7,$dformat);
          if ($_SESSION['session_message_error'] == "") {
              $_SESSION['displ_msg'] = "yes";
              $_SESSION["msg_a_afficher"] = get_vocab("un email envoye")." ".$_GET["mail_exist"];
          }
      }
      header("Location: ".$_GET['back']."");
      die();
    }
}

#If we dont know the right date then make it up
if(!isset($day) or !isset($month) or !isset($year))

开发者ID:rhertzog，项目名称:lcs，代码行数:31，代码来源:view_entry.php

示例12: mrbsCreateRepeatEntry

/** mrbsCreateRepeatEntry()
 *
 * Creates a repeat entry in the data base
 *
 * $starttime   - Start time of entry
 * $endtime     - End time of entry
 * $rep_type    - The repeat type
 * $rep_enddate - When the repeating ends
 * $rep_opt     - Any options associated with the entry
 * $room_id     - Room ID
 * $beneficiaire       - beneficiaire
 * $beneficiaire_ext   - beneficiaire extérieur
 * $creator     - celui aui a créé ou modifié la réservation.
 * $name        - Name
 * $type        - Type (Internal/External)
 * $description - Description
  *$rep_jour_c - Le jour cycle d'une réservation, si aucun 0
 *
 * Returns:
 *   0        - An error occured while inserting the entry
 *   non-zero - The entry's ID
 */
function mrbsCreateRepeatEntry($starttime, $endtime, $rep_type, $rep_enddate, $rep_opt,
                               $room_id, $creator, $beneficiaire, $beneficiaire_ext, $name, $type, $description, $rep_num_weeks,$overload_data, $rep_jour_c)
{
  $overload_data_string = "";
  $area_id = mrbsGetAreaIdFromRoomId($room_id);

  $overload_fields_list = mrbsOverloadGetFieldslist($area_id);

  foreach ($overload_fields_list as $field=>$fieldtype)
    {
      $id_field = $overload_fields_list[$field]["id"];
      if (array_key_exists($id_field,$overload_data))
      {
//      $begin_string = "<".$id_field.">"; //tructruc
//      $end_string = "</".$id_field.">";  //tructruc
      $begin_string = "@".$id_field."@";
      $end_string = "@/".$id_field."@";
//    $overload_data_string .= $begin_string.base64_encode($overload_data[$id_field]).$end_string; // tructruc
    $overload_data_string .= $begin_string.urlencode($overload_data[$id_field]).$end_string; // tructruc

      }
    }
  $sql = "INSERT INTO ".TABLE_PREFIX."_repeat (
  start_time, end_time, rep_type, end_date, rep_opt, room_id, create_by, beneficiaire, beneficiaire_ext, type, name, description, rep_num_weeks, overload_desc, jours)
  VALUES ($starttime, $endtime,  $rep_type, $rep_enddate, '$rep_opt', $room_id,   '".protect_data_sql($creator)."','".protect_data_sql($beneficiaire)."','".protect_data_sql($beneficiaire_ext)."', '".protect_data_sql($type)."', '".protect_data_sql($name)."', '".protect_data_sql($description)."', '$rep_num_weeks','".protect_data_sql($overload_data_string)."',".$rep_jour_c.")";


  if (grr_sql_command($sql) < 0)
    {
      return 0;

    }
  return grr_sql_insert_id("".TABLE_PREFIX."_repeat", "id");
}

开发者ID:rhertzog，项目名称:lcs，代码行数:56，代码来源:mrbs_sql.inc.php

示例13: grr_sql_query1

//
// Suppression d'un type de réservation
//
if ((isset($_GET['action_del'])) and ($_GET['js_confirmed'] ==1) and ($_GET['action_del']='yes')) {
    // faire le test si il existe une réservation en cours avec ce type de réservation
    $type_id = grr_sql_query1("select type_letter from ".TABLE_PREFIX."_type_area where id = '".$_GET['type_del']."'");
    $test1 = grr_sql_query1("select count(id) from ".TABLE_PREFIX."_entry where type= '".$type_id."'");
    $test2 = grr_sql_query1("select count(id) from ".TABLE_PREFIX."_repeat where type= '".$type_id."'");
    if (($test1 != 0) or ($test2 != 0)) {
        $msg =  "Suppression impossible : des réservations ont été enregistrées avec ce type.";
    } else {
        $sql = "DELETE FROM ".TABLE_PREFIX."_type_area WHERE id='".$_GET['type_del']."'";
        if (grr_sql_command($sql) < 0) {fatal_error(1, "<p>" . grr_sql_error());}
        $sql = "DELETE FROM ".TABLE_PREFIX."_j_type_area WHERE id_type='".$_GET['type_del']."'";
        if (grr_sql_command($sql) < 0) {fatal_error(1, "<p>" . grr_sql_error());}

    }
}
affiche_pop_up($msg,"admin");

echo "<h2>".get_vocab('admin_type.php')."</h2>";
echo get_vocab('admin_type_explications');
echo "<br />\n";
echo "<br />\n";
echo "| <a href=\"admin_type_modify.php?id=0\">".get_vocab("display_add_type")."</a> |\n";
echo "<br />\n";
echo "<br />\n";
$sql = "SELECT id, type_name, order_display, couleur, type_letter, disponible FROM ".TABLE_PREFIX."_type_area
ORDER BY order_display,type_letter";
$res = grr_sql_query($sql);

开发者ID:rhertzog，项目名称:lcs，代码行数:30，代码来源:admin_type.php

示例14: grr_sql_query1

		$res = grr_sql_query1($sql);
		if ($res == -1) {
			$sql = "insert into ".TABLE_PREFIX."_j_useradmin_area (login, id_area) values ('$reg_admin_login',$id_area)";
			if (grr_sql_command($sql) < 0) {fatal_error(1, "<p>" . grr_sql_error());}  else {$msg=get_vocab("add_user_succeed");}
		} else {
           $msg = get_vocab("warning_exist");
		}
	}

}

if ($action) {
    if ($action == "del_admin") {
        unset($login_admin); $login_admin = $_GET["login_admin"];
        $sql = "DELETE FROM ".TABLE_PREFIX."_j_useradmin_area WHERE (login='$login_admin' and id_area = '$id_area')";
        if (grr_sql_command($sql) < 0) {fatal_error(1, "<p>" . grr_sql_error());} else {$msg=get_vocab("del_user_succeed");}
    }
}

echo "<h2>".get_vocab('admin_right_admin.php').grr_help("aide_grr_administateur_restreint")."</h2>\n";
echo "<p><i>".get_vocab("admin_right_admin_explain")."</i></p>\n";

// Affichage d'un pop-up
affiche_pop_up($msg,"admin");

# Table with areas.
echo "<table><tr>\n";
$this_area_name = "";
# 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\"><div><select name=\"area\" onchange=\"area_go()\">\n";

开发者ID:rhertzog，项目名称:lcs，代码行数:31，代码来源:admin_right_admin.php

示例15: grr_opensession


//.........这里部分代码省略.........
            $sql .= " password = '' and ";
        }
        $sql .= " etat != 'inactif'";
        $res_user = grr_sql_query($sql);
        $num_row = grr_sql_count($res_user);
        if ($num_row == 1) {
            // L'utilisateur est présent dans la base locale
            if ($sso == "lcs") {
                // Mise à jour des données
                $nom_user = $tab_login["nom"];
                $email_user = $tab_login["email"];
                $prenom_user = $tab_login["fullname"];
                // On met à jour
                $sql = "UPDATE " . TABLE_PREFIX . "_utilisateurs SET\n\t\t\t\tnom='" . protect_data_sql($nom_user) . "',\n\t\t\t\tprenom='" . protect_data_sql($prenom_user) . "',\n\t\t\t\temail='" . protect_data_sql($email_user) . "'\n\t\t\t\twhere login='" . protect_data_sql($_login) . "'";
            } else {
                if ($_user_ext_authentifie == "cas") {
                    if (Settings::get("ldap_statut") != '' && @function_exists("ldap_connect") && @file_exists("include/config_ldap.inc.php")) {
                        $auth_ldap = 'yes';
                    }
                    $nom_user = $tab_login["user_nom"];
                    $email_user = $tab_login["user_email"];
                    $prenom_user = $tab_login["user_prenom"];
                    if ($nom_user != '') {
                        //  On détecte si Nom, Prénom ou Email ont changé,
                        // Si c'est le cas, on met à jour les champs
                        $req = grr_sql_query("SELECT nom, prenom, email from " . TABLE_PREFIX . "_utilisateurs where login ='" . protect_data_sql($_login) . "'");
                        $res = mysqli_fetch_array($req);
                        $nom_en_base = $res[0];
                        $prenom_en_base = $res[1];
                        $email_en_base = $res[2];
                        if (strcmp($nom_en_base, $nom_user) != 0 || strcmp($prenom_en_base, $prenom_user) != 0 || strcmp($email_en_base, $email_user) != 0) {
                            // Si l'un des champs est différent, on met à jour les champs
                            $sql = "UPDATE " . TABLE_PREFIX . "_utilisateurs SET\n\t\t\t\t\t\tnom='" . protect_data_sql($nom_user) . "',\n\t\t\t\t\t\tprenom='" . protect_data_sql($prenom_user) . "',\n\t\t\t\t\t\temail='" . protect_data_sql($email_user) . "'\n\t\t\t\t\t\twhere login='" . protect_data_sql($_login) . "'";
                            if (grr_sql_command($sql) < 0) {
                                fatal_error(0, get_vocab("msg_login_created_error") . grr_sql_error());
                            }
                            //Comme les données de la base on été changés, on doit remettre à jour la variable $row,
                            //Pour que les données mises en sessions soient les bonnes
                            //on récupère les données de l'utilisateur
                            $sql = "SELECT upper(login) login, password, prenom, nom, statut, now() start, default_area, default_room, default_style, default_list_type, default_language, source, etat, default_site\n\t\t\t\t\t\tFROM " . TABLE_PREFIX . "_utilisateurs\n\t\t\t\t\t\tWHERE login = '" . protect_data_sql($_login) . "' and\n\t\t\t\t\t\tsource = 'ext' and\n\t\t\t\t\t\tetat != 'inactif'";
                            $res_user = grr_sql_query($sql);
                            $num_row = grr_sql_count($res_user);
                            if ($num_row != 1) {
                                return "2";
                            }
                        }
                    }
                }
            }
            if (grr_sql_command($sql) < 0) {
                fatal_error(0, get_vocab("msg_login_created_error") . grr_sql_error());
            }
            // on récupère les données de l'utilisateur dans $row
            $row = grr_sql_row($res_user, 0);
        } else {
            // L'utilisateur n'est pas présent dans la base locale ou est inactif
            //  ou possède un mot de passe (utilisateur local GRR)
            // On teste si un utilisateur porte déjà le même login
            $test = grr_sql_query1("SELECT login FROM " . TABLE_PREFIX . "_utilisateurs WHERE login = '" . protect_data_sql($_login) . "'");
            if ($test != '-1') {
                return "3";
            } else {
                //Aucun utilisateur dans la base locale ne porte le même login. On peut continuer la procédure d'importation
                //1er cas : LCS.
                if ($sso == "lcs") {
                    if ($_statut == 'aucun') {

开发者ID:JeromeDevome，项目名称:GRR，代码行数:67，代码来源:session.inc.php

示例16: VerifyModeDemo

VerifyModeDemo();
unset($user_login);
$user_login = isset($_POST["user_login"]) ? $_POST["user_login"] : ($user_login = isset($_GET["user_login"]) ? $_GET["user_login"] : NULL);
$valid = isset($_POST["valid"]) ? $_POST["valid"] : NULL;
$msg = '';
if ($valid == "yes") {
    unset($reg_password1);
    $reg_password1 = unslashes($_POST["reg_password1"]);
    unset($reg_password2);
    $reg_password2 = unslashes($_POST["reg_password2"]);
    $reg_password_c = md5($reg_password1);
    if ($reg_password1 != $reg_password2 || strlen($reg_password1) < $pass_leng) {
        $msg = get_vocab("passwd_error");
    } else {
        $sql = "UPDATE " . TABLE_PREFIX . "_utilisateurs SET password='" . protect_data_sql($reg_password_c) . "' WHERE login='{$user_login}'";
        if (grr_sql_command($sql) < 0) {
            fatal_error(0, get_vocab('update_pwd_failed') . grr_sql_error());
        } else {
            $msg = get_vocab('update_pwd_succeed');
        }
    }
}
$user_nom = '';
$user_prenom = '';
$user_source = '';
// On appelle les informations de l'utilisateur
if (isset($user_login) && $user_login != '') {
    $sql = "SELECT nom,prenom, source FROM " . TABLE_PREFIX . "_utilisateurs WHERE login='{$user_login}'";
    $res = grr_sql_query($sql);
    if ($res) {
        for ($i = 0; $row = grr_sql_row($res, $i); $i++) {

开发者ID:nicolas-san，项目名称:GRRV4，代码行数:31，代码来源:admin_change_pwd.php

示例17: grrDelOverloadFromEntries

            grrDelOverloadFromEntries($id_overload);
            $sql = "delete from ".TABLE_PREFIX."_overload where id=$id_overload;";
            grr_sql_command($sql);
        }
        # OK, nothing there, lets blast it away
        grr_sql_command("delete from ".TABLE_PREFIX."_area where id=$id_area");
        grr_sql_command("update ".TABLE_PREFIX."_utilisateurs set default_area = '-1', default_room = '-1' where default_area='".$id_area."'");
        grr_sql_command("DELETE FROM ".TABLE_PREFIX."_area_periodes WHERE id_area=$id_area");
        grr_sql_command("DELETE FROM ".TABLE_PREFIX."_j_useradmin_area WHERE id_area=$id_area");
        grr_sql_command("DELETE FROM ".TABLE_PREFIX."_j_type_area WHERE id_area=$id_area");
        grr_sql_command("DELETE FROM ".TABLE_PREFIX."_j_user_area WHERE id_area=$id_area");
        grr_sql_command("DELETE FROM ".TABLE_PREFIX."_j_site_area WHERE id_area=$id_area");
        $test = grr_sql_query1("select VALUE from ".TABLE_PREFIX."_setting where NAME='default_area'");
        if ($test==$id_area) {
            grr_sql_command("delete from ".TABLE_PREFIX."_setting where NAME='default_area'");
            grr_sql_command("delete from ".TABLE_PREFIX."_setting where NAME='default_room'");
            // Settings
            require_once("./include/settings.inc.php");
            //Chargement des valeurs de la table settingS
            if (!loadSettings())
                die("Erreur chargement settings");

        }
        # Redirect back to the admin page
        header("Location: admin_room.php?id_site=$id_site");
    }
    else
    {
        # There are rooms left in the area
        # print the page header
        print_header("","","","",$type="with_session", $page="admin");

开发者ID:rhertzog，项目名称:lcs，代码行数:31，代码来源:admin_room_del.php

注：本文中的grr_sql_command函数示例整理自Github/MSDocs等源码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。

鲜花

握手

雷人

路过

鸡蛋

该文章已有0人参与评论

请发表评论

全部评论

专题导读

More+

10-27 六六分期app的软件客服如何联系？(六六分期

11-06 可心卡盟:win10系统火狐flash插件崩溃怎么

11-06 亲亲特价:怎么删除回收站图标

11-06 济南大学虚拟社区:鲁大师节能降温的具体办

11-06 xlueops.exe:无线网络安装向导

11-06 女斗合众国:win7系统cf与主机连接不稳定怎

11-06 0xc000022-[cf烟雾头]cf怎么调烟雾头

11-06 qizideyouhuo:应用程序无法正常启动0xc0000

11-06 ipz-185:win7系统vcf文件怎么打开

11-06 傻哥蹦迪:win10系统s4怎么打开usb调试

11-06 八神浩树gtaste:回收站清空了怎么恢复

11-06 妖尾之黑色守护:win10系统电脑没有1440x900

11-06 校园至尊魔王小说:win7系统浏览网页时字体

11-06 女斗合众国:win10系统访问共享文件夹提示请

11-06 tokyo hot n0654:恢复win7系统默认字体一招

11-06 雨酷仙境:设置win7系统转移临时文件夹腾出

11-06 阿穆纳伊之杖:win7系统开始菜单在右边还原

11-06 tunespotting:win10系统火狐flash插件总是

11-06 甘尔葛分析师：计谋网站seo关键词暴涨有什

11-06 蔡贵霖: 计谋网站seo关键词暴涨有什么秘密

11-06 博益网首页:ao3网页版进入不了解决方法

11-06 漏斗子专栏: 网站数据分析小白易懂精华篇

11-06 见证双虹怎么做:win7系统开启telnet命令的

11-06 颾狐蝶蜋:系统资源不足无法完成请求的服务

11-06 国光中学校歌:提交网站到alexa查询详细步骤

11-06 西安有情天:静态网页和动态网页的区别

11-06 红木雅尚斋:外部链接构造对网站的好处

11-06 前官礼遇：防止域名劫持–增强域安全性的10

11-06 密传二转答案: 中文分词算法有哪些

11-06 金泉家园邮编:百度快照劫持的表现及应对方

PHP grr_sql_count函数代码示例发布时间：2022-05-15

PHP grr_resumeSession函数代码示例发布时间：2022-05-15

使用Delphi自带的TDockTabSet组件实现停靠

1 librespeed/speedtest: Self-hosted Speedt

librespeed/speedtest: Self-hosted Speedtest for HTML5 and more. Easy setup, exam

阅读：1209|2022-08-30

2 CVE-2022-24083

Password authentication bypass vulnerability for local accounts can be used to b

阅读：795|2022-07-29

3 avehtari/BDA_m_demos: Bayesian Data Anal

avehtari/BDA_m_demos: Bayesian Data Analysis demos for Matlab/Octave

阅读：1116|2022-08-17

4 四维彩超怎么看性别？四维看男孩女孩诀窍

女人怀孕后，为了有一个健康聪明的宝宝，经历各种体检、筛查。其实这些体检和筛查中的

阅读：929|2022-11-06

5 攘外必先安内是什么意思谁说的

我们对蒋介石有一个印象，那就是“九一八事变”之后、“七七事变”之前，他坚持对日本

阅读：539|2022-07-30

6 medfreeman/markdown-it-toc-and-anchor: m

medfreeman/markdown-it-toc-and-anchor: markdown-it plugin to add a toc and ancho

阅读：1326|2022-08-18

7 sydney0zq/covid-19-detection: The implem

sydney0zq/covid-19-detection: The implementation of A Weakly-supervised Framewor

阅读：477|2022-08-16

8 世界上哪个国家离中国最远？

离中国最远的国家是阿根廷。从太平洋直线计算，即往东线走，北京到阿根廷的布宜诺斯艾

阅读：623|2022-11-06

9 CVE-2021-36667

Command injection vulnerability in Druva inSync 6.9.0 for MacOS, allows attacker

阅读：1423|2022-07-29

10 shem8/MaterialLogin: Login view with mat

shem8/MaterialLogin: Login view with material design

阅读：720|2022-08-17

客服电话

电子邮件

PHP grr_sql_command函数代码示例

示例1: delete_user

示例2: grr_sql_query

示例3: NettoyerTablesJointure

示例4: grr_sql_query1

示例5: NettoyerTablesJointure

示例6: fatal_error

示例7: mktime

示例8: delete_site

示例9: grrDelOverloadFromEntries

示例10:

示例11: verif_display_email

示例12: mrbsCreateRepeatEntry

示例13: grr_sql_query1

示例14: grr_sql_query1

示例15: grr_opensession

示例16: VerifyModeDemo

示例17: grrDelOverloadFromEntries

请发表评论

全部评论

上一篇：

下一篇：

krishnaik06/Machine-Learning-in-90-days

geekammo/MicroView-Arduino-Library: Micr

美元符号为什么是“$”

Mekolaos/Aternos-On-Discord: A Discord B

FNNDSC/matlab: Matlab Projects and Snipp

使用Delphi自带的TDockTabSet组件实现停靠

librespeed/speedtest: Self-hosted Speedt

延的笔顺,聊聊延的笔画,讨论延的部首

avehtari/BDA_m_demos: Bayesian Data Anal

四维彩超怎么看性别？四维看男孩女孩诀窍

medfreeman/markdown-it-toc-and-anchor: m

关于我们

产品与服务

解决方案

139-2527-9053