| | |
|---|
| | | } else { |
|---|
| | | if($primary_id != 0) { |
|---|
| | | // update client permissions only if client_id > 0 |
|---|
| | | if($this->formDef['auth'] == 'yes' && $this->client_id > 0) { |
|---|
| | | $sql_update .= '`sys_userid` = "'.$this->sys_userid.'", '; |
|---|
| | | $sql_update .= '`sys_groupid` = "'.$this->sys_default_group.'", '; |
|---|
| | | if($this->formDef['auth'] == 'yes' && $this->client_id > 0 && $this->sys_userid > 0 && $this->sys_default_group > 0) { |
|---|
| | | $sql_update .= '`sys_userid` = '.$this->sys_userid.', '; |
|---|
| | | $sql_update .= '`sys_groupid` = '.$this->sys_default_group.', '; |
|---|
| | | } |
|---|
| | | $sql_update = substr($sql_update,0,-2); |
|---|
| | | $sql = "UPDATE ".$escape.$this->formDef['db_table'].$escape." SET ".$sql_update." WHERE ".$this->formDef['db_table_idx']." = ".$primary_id; |
|---|
| | |
|---|
| | | if(@is_numeric($primary_id)) { |
|---|
| | | $sql = "SELECT * FROM ".$escape.$this->formDef['db_table'].$escape." WHERE ".$this->formDef['db_table_idx']." = ".$primary_id; |
|---|
| | | return $app->db->queryOneRecord($sql); |
|---|
| | | } elseif (@is_array($primary_id)) { |
|---|
| | | } elseif (@is_array($primary_id) || @is_object($primary_id)) { |
|---|
| | | if(@is_object($primary_id)) $primary_id = get_object_vars($primary_id); // do not use cast (array)xxx because it returns private and protected properties! |
|---|
| | | $sql_offset = 0; |
|---|
| | | $sql_limit = 0; |
|---|
| | | $sql_where = ''; |
|---|
