23 $this->mapping_id = $a_mapping_id;
31 $query =
"SELECT * FROM ldap_rg_mapping "
32 .
"WHERE mapping_id = " . $this->db->quote($this->
getMappingId(),
'integer');
33 $set = $this->db->query(
$query);
34 $rec = $this->db->fetchAssoc($set);
38 $this->
setURL($rec[
"url"]);
39 $this->
setDN($rec[
"dn"]);
52 $query =
"DELETE FROM ldap_rg_mapping ".
53 "WHERE mapping_id = ".$this->db->quote($this->
getMappingId(),
'integer');
62 $query =
"UPDATE ldap_rg_mapping ".
63 "SET server_id = ".$this->db->quote($this->
getServerId(),
'integer').
", ".
64 "url = ".$this->db->quote($this->
getURL(),
'text').
", ".
65 "dn =".$this->db->quote($this->
getDN(),
'text').
", ".
67 "member_isdn = ".$this->db->quote($this->
getMemberISDN(),
'integer').
", ".
68 "role = ".$this->db->quote($this->
getRole(),
'integer').
", ".
69 "mapping_info = ".$this->db->quote($this->
getMappingInfo(),
'text').
", ".
71 "WHERE mapping_id = ".$this->db->quote($this->
getMappingId(),
'integer');
80 $this->
setMappingId($this->db->nextId(
'ldap_rg_mapping'));
81 $query =
"INSERT INTO ldap_rg_mapping (mapping_id,server_id,url,dn,member_attribute,member_isdn,role,mapping_info,mapping_info_type) ".
84 $this->db->quote($this->
getServerId(),
'integer').
", ".
85 $this->db->quote($this->
getURL(),
'text').
", ".
86 $this->db->quote($this->
getDN(),
'text').
", ".
89 $this->db->quote($this->
getRole(),
'integer').
", ".
93 $res = $this->db->manipulate($query);
102 return $this->mapping_id;
111 $this->mapping_id = $a_value;
120 return $this->server_id;
129 $this->server_id = $a_value;
147 $this->url = $a_value;
165 $this->dn = $a_value;
174 return $this->member_attribute;
183 $this->member_attribute = $a_value;
192 return $this->member_isdn;
201 $this->member_isdn = $a_value;
219 $this->role = $a_value;
229 global $ilObjDataCache;
230 return $ilObjDataCache->lookupTitle($this->role);
250 return $this->mapping_info;
259 $this->mapping_info = $a_value;
268 return $this->mapping_info_type;
277 $this->mapping_info_type = $a_value;