Changeset 1756 for trunk/jabberit_messenger/inc/class.db_im.inc.php
- Timestamp:
- 12/04/09 16:41:31 (15 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/jabberit_messenger/inc/class.db_im.inc.php
r1438 r1756 115 115 public final function get_accounts_acl() 116 116 { 117 $query = "select acl_account from phpgw_acl where acl_location in (select cast(acl_account as varchar) from phpgw_acl where acl_appname = 'jabberit_messenger') "; 118 $query .= "union select acl_account from phpgw_acl where acl_appname = 'jabberit_messenger'"; 119 117 $query = "SELECT acl_account FROM phpgw_acl WHERE acl_location IN (SELECT CAST(acl_account AS varchar) FROM phpgw_acl WHERE acl_appname = 'jabberit_messenger') "; 118 $query .= "UNION SELECT acl_account FROM phpgw_acl WHERE acl_appname = 'jabberit_messenger'"; 120 119 121 120 if( $this->db->query($query) ) … … 156 155 $return = $result[0]['config_value']; 157 156 } 157 } 158 159 return $return; 160 } 161 162 public final function getGroupsSearch() 163 { 164 $return = ""; 165 166 if( $this->db ) 167 { 168 $query = "SELECT * FROM phpgw_config WHERE config_app = 'phpgwapi' AND config_name = 'groups_search_jabberit';"; 169 170 if($this->db->query($query)) 171 { 172 while($this->db->next_record()) 173 $result[] = $this->db->row(); 174 } 175 176 if( count($result) > 0 ) 177 $return = $result[0]['config_value']; 158 178 } 159 179 … … 314 334 } 315 335 return false; 336 } 337 338 public final function setAddGroupsSearch($pData) 339 { 340 if( $pData) 341 { 342 if( $this->db ) 343 { 344 $query = "SELECT * FROM phpgw_config WHERE config_app = 'phpgwapi' AND config_name = 'groups_search_jabberit';"; 345 346 if( $this->db->query($query) ) 347 { 348 while( $this->db->next_record()) 349 $result[] = $this->db->row(); 350 } 351 352 if( count($result) == 0 ) 353 { 354 $query = "INSERT INTO phpgw_config(config_app,config_name,config_value) VALUES('phpgwapi','groups_search_jabberit','".serialize($pData)."');"; 355 $this->db->query($query); 356 return true; 357 } 358 else 359 { 360 $resultQuery = unserialize($result[0]['config_value']); 361 $keys = array_keys($pData); 362 363 $resultQuery[$keys[0]] = $pData[$keys[0]]; 364 365 $query = "UPDATE phpgw_config SET config_value = '".serialize($resultQuery)."' WHERE config_app = 'phpgwapi' AND config_name = 'groups_search_jabberit';"; 366 $this->db->query($query); 367 return true; 368 } 369 } 370 } 316 371 } 317 372
Note: See TracChangeset
for help on using the changeset viewer.