func_s.php

Oracle源码：Oracle 数据库管理与应用系统开发代码

<?
function check_login()
{ 
if(!isset($PHP_AUTH_USER))
{
header("Location:login.php");
}
}
//check_login();



/*
if(!session_is_registered("ses_0230a09a07cab1df8112d00b1f9a9719"))
{                $url="login.php";
		 show_msg("请先登录！",$url,1);        
         // Header("Location:login.php");
          exit;
 }
*/

function get_c_right($cla,$userid) //获得用户的栏目权限ID号,"id1,id2,id3"为ID号,"name1,name2,name3"为栏目名称.
   {
   $sqldo="select right_level from users where user_id='$userid'";
    $result_array=$cla->db_query($sqldo);
      if(trim($result_array[0][0])=="管理员"){
      $sqldo="select class_id,class_name from baseclass";
      $i=0;
      $result_array=$cla->db_query($sqldo);
      while($result_array[$i][0]){
      $result_right["id$i"]=$result_array[$i]["CLASS_ID"];
      $result_right["name$i"]=$result_array[$i]["CLASS_NAME"];
      $i++;
      }
   }
    else{
   $sqldo="select class_right from users where user_id='$userid'";
   $baseact=$cla->db_query($sqldo);
   $piece=explode(",",$baseact[0][0]);
   $cnt=0;
   while($piece["$cnt"]<>""){  
   $result_right["id$cnt"]=$piece["$cnt"];
   $temp=$piece["$cnt"];
   $sqldo="select class_name from baseclass where class_id='$temp'";
   $result_array=$cla->db_query($sqldo);
   $result_right["name$cnt"]=$result_array[0][0];
 //  echo "result_right:".$result_right;
   $cnt++;
   }    
   }
   return $result_right;
}
function get_c_right2($cla,$userid) //获得用户的栏目权限ID号,"id1,id2,id3"为ID号,"name1,name2,name3"为栏目名称.
   {
   $sqldo="select right_level from users where user_id='$userid'";
    $result_array=$cla->db_query($sqldo);
      if(trim($result_array[0][0])=="管理员"){
      $sqldo="select class_id,class_name from baseclass";
      $i=0;
      $result_array=$cla->db_query($sqldo);
      while($result_array[$i][0]){
      $id=$result_array[$i]["CLASS_ID"];
      $result_right[$id]=$id;
      $i++;
      }
   }
    else{
   $sqldo="select class_right from users where user_id='$userid'";
   $baseact=$cla->db_query($sqldo);
   $piece=explode(",",$baseact[0][0]);
   $cnt=0;
   while($piece["$cnt"]<>""){  
   $id=$piece["$cnt"];
   $result_right[$id]=$id;
   $cnt++;
   }    
   }
   return $result_right;
}
function get_o_right($cla,$userid) //获得用户的操作权限ID号,"id1,id2,id3"为ID号,"name1,name2,name3"为操作名称.
   {
   $sqldo="select right_level from users where user_id='$userid'";
    $result_array=$cla->db_query($sqldo);
     if(trim($result_array[0][0])=="管理员"){
      $sqldo="select act_id,act_name from baseact";
      $i=0;
      $result_array=$cla->db_query($sqldo);
      while($result_array[$i][0]){
      $result_right["id$i"]=$result_array[$i]["ACT_ID"];
      $result_right["name$i"]=$result_array[$i]["ACT_NAME"];
      $i++;
      }
   }
   else{
 
   $sqldo="select operate_right from users where user_id='$userid'";
   $baseact=$cla->db_query($sqldo);
   $piece=explode(",",$baseact[0][0]);
   $cnt=0;
   while($piece["$cnt"]<>""){  
   $result_right["id$cnt"]=$piece["$cnt"];
   $temp=$piece["$cnt"];
   $sqldo="select act_name from baseact where act_id='$temp'";
   $result_array=$cla->db_query($sqldo);
   $result_right["name$cnt"]=$result_array[0][0];
   //echo "result_right".$result_right["name$cnt"];
   $cnt++;
   } 
   }   
   return $result_right;
   }
   
   
   

function get_o_right2($cla,$userid) //获得用户的操作权限ID号,"id1,id2,id3"为ID号,"日志管理,新闻管理,新闻发布"等为操作名称.
   {

   
   $sqldo="select right_level from users where user_id='$userid'";
   //echo $sqldo;
   $result_array=$cla->db_query($sqldo);
   if(trim($result_array[0][0])=="管理员"){
      $sqldo="select act_id,act_name from baseact";
      $i=0;
      $result_array=$cla->db_query($sqldo);
      while($result_array[$i][0]){
	  //echo "Right:"+$result_array[$i]["ACT_NAME"];
      $result_right["id$i"]=$result_array[$i]["ACT_ID"];
      $temp=trim($result_array[$i]["ACT_NAME"]);
      $result_right["$temp"]=trim($result_array[$i]["ACT_NAME"]);
      $i++;
      }
   }
   else{

   $sqldo="select operate_right from users where user_id='$userid'";
  // echo $sqldo;
   $baseact=$cla->db_query($sqldo);
  // echo "r:".$baseact[0][0];
   $piece=explode(",",$baseact[0][0]);
   $cnt=0;
   while($piece["$cnt"]<>""){  
   
   $result_right["id$cnt"]=$piece["$cnt"];
   $temp=$piece["$cnt"];
   $sqldo="select act_name from baseact where act_id='$temp'";
   $result_array=$cla->db_query($sqldo); 
   $temp=trim($result_array[0][0]);   
   $result_right["$temp"]=trim($result_array[0][0]);
  // echo "r2".$temp;
   $cnt++;
   } 
   }   
   return $result_right;
   }
   
   
   ?>