Location: PHPKode > projects > MembersGear > membersgear/includes/usersinroles_class.php
<?php
 
 require_once "peardb_class.php";
    
 class usersinroles_class extends peardb_class
 {   
    function View($pQuery, $pValues=false, $types=true, $pStart=0, $pEnd=0)
    {
       
        return $this->BaseView($pQuery,$pValues,$types,$pStart,$pEnd);
        
    }
    
    function Update($pQuery, $pValues=false, $types=true)
    { 
        if($pQuery=='')
        {
        
            $pQuery="update ".TABLE_PREFIX."users_in_roles set roleid=?,modifiedon=?, modifiedby=?, modifiedipaddress=? where userid=?";
        }    
        return $this->BaseUpdate($pQuery, $pValues, null);
    
    }

    
    function Insert($pQuery, $pValues=false, $types=true)
    { 
        if($pQuery=='')
        {
           $pQuery="insert into ".TABLE_PREFIX."users_in_roles (userid, roleid, createdon, createdby, createdipaddress) VALUES(?,?,?,?,?)"; 
            
        }    
        return $this->BaseInsert($pQuery, $pValues, $types);
    
    }
    function delete($pQuery, $pValues=false, $types=true)
    {
        
        if($pQuery=='') 
        {
           $pQuery="delete from ".TABLE_PREFIX."users_in_roles  where userid=?";  
        
        }   
        return $this->BaseDelete($pQuery, $pValues, null);
        
    }   
  
      
 }   
   
   
 
    

?>
Return current item: MembersGear