| | |
| | | $app->remoting_lib->loadFormDef($formdef_file); |
| | | |
| | | //* load the user profile of the client |
| | | $app->remoting_lib->loadUserProfile($reseller_id); |
| | | $app->remoting_lib->loadUserProfile($reseller_id); |
| | | |
| | | //* load the client template |
| | | if(isset($params['template_master']) and $params['template_master'] > 0) |
| | | { |
| | | $template=$app->db->queryOneRecord("SELECT * FROM client_template WHERE template_id=".intval($params['template_master'])); |
| | | $params=array_merge($params,$template); |
| | | } |
| | | |
| | | //* Get the SQL query |
| | | $sql = $app->remoting_lib->getSQL($params,'INSERT',0); |
| | |
| | | $new_group[] = intval( $group_id); |
| | | } |
| | | $group_list = implode(',', $new_group); |
| | | $sql ="SELECT domain, domain_id, document_root FROM web_domain WHERE ( (sys_userid = $sys_userid AND sys_perm_user LIKE '%r%') OR (sys_groupid IN ($group_list) AND sys_perm_group LIKE '%r%') OR sys_perm_other LIKE '%r%') AND type = 'vhost'"; |
| | | $sql ="SELECT domain, domain_id, document_root, active FROM web_domain WHERE ( (sys_userid = $sys_userid AND sys_perm_user LIKE '%r%') OR (sys_groupid IN ($group_list) AND sys_perm_group LIKE '%r%') OR sys_perm_other LIKE '%r%') AND type = 'vhost'"; |
| | | $result = $app->db->queryAllRecords($sql); |
| | | if(isset($result)) { |
| | | return $result; |