admin_sql.inc

FIREFLY 是一个多用户专业帮助桌面系统

<?
##########################################
#
#  ADMIN SQL LIBRARY
#
##########################################

function SQL_CHECK_LOGIN($dbproc, $login)
{
  if (isset($login) && ($login!=""))
    {
      $query="select id from login where login='$login'";
      $SQL_RESULT=SQL_QUERY($query, $dbproc);
      
      if (SQL_NUM_ROWS($SQL_RESULT)>0)
    {
      SQL_FREE_RESULT($SQL_RESULT);
      return  1;
    }
      else
    return -1; 
    }
}
function SQL_LOGIN_UPDATE($dbproc, $login, $pass="", $login_id, $lang_id="1")
{
  /* init transaction */
  SQL_BEGIN($dbproc);
  if($pass)
    $setmore =  ", pass='$pass'";

  $query="UPDATE login SET login='$login', lang='$lang_id' $setmore WHERE id=$login_id";

  $SQL_RESULT=SQL_QUERY($query, $dbproc);
  if ($SQL_RESULT)
    /*fin de transaction */
    {
      SQL_COMMIT($dbproc);
      SQL_FREE_RESULT($SQL_RESULT);
      RETURN 0;
    }
  else
    { SQL_ROLLBACK($dbproc); return -1; }

}

function SQL_LOGIN_INSERT($dbproc, $login, $pass, $ent_id, $lang_id="1")
{
  /* init transaction */
  SQL_BEGIN($dbproc);
  $login_id = SQL_NEXT_ID($dbproc,"login_seq");
  $query="INSERT INTO login (id,ent_id,login,pass,ins_date,upd_date,ts,lang) VALUES ('$login_id','$ent_id','$login','$pass',NOW(),NOW(),NOW(),'$lang_id')";

  $SQL_RESULT=SQL_QUERY($query, $dbproc);
  if ($SQL_RESULT)
    /*fin de transaction */
    {
      SQL_COMMIT($dbproc);
      SQL_FREE_RESULT($SQL_RESULT);
      RETURN $login_id;
    }
  else
    { SQL_ROLLBACK($dbproc); return -1; }

}

function SQL_LOGIN_DELETE($dbproc, $login_id)
{
  /* init transaction */
  SQL_BEGIN($dbproc);
  $query="delete from login where id=$login_id ";
  $SQL_RESULT=SQL_QUERY($query, $dbproc);
  $query="delete from log_grp where login_id=$login_id ";
  $SQL_RESULT=SQL_QUERY($query, $dbproc);

  if ($SQL_RESULT)
    /*fin de transaction */
    {
      SQL_COMMIT($dbproc);
      SQL_FREE_RESULT($SQL_RESULT);
      RETURN $login_id;
    }
  else
    { SQL_ROLLBACK($dbproc); return -1; }

}
function SQL_DELETE_LOG_GRP($dbproc,$login_id, $group_id, $user_id)
{
  $query="delete from log_grp where login_id=$login_id and group_id=$group_id";
  $SQL_RESULT=SQL_QUERY($query, $dbproc);
  if ($SQL_RESULT)
    return 0;
  else
    { SQL_ROLLBACK($dbproc); return -1; }
}

function SQL_INSERT_LOG_GRP($dbproc,$login_id, $group_id, $user_id=0)
{
  $status=0;

  /* init transaction */
  SQL_BEGIN($dbproc);
  /*on verifie que le profil n'exista pas d閖