Thread: Remoting API
View Single Post
  #1  
Old 1st May 2013, 23:32
tio289 tio289 is offline
Member
 
Join Date: Mar 2009
Posts: 70
Thanks: 2
Thanked 14 Times in 9 Posts
Default Remoting API

Hello, there is client_get_sites_by_user function, but it selects only standard vhosts, not subdomain vhost. I edit SQL query to select subdomainvhost too.

Code:
3039 - $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'";
3039 + $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' OR type='vhostsubdomain')";
Would You integrate this change in next release? Or You add separate function to select subdomainvhost? Or add additional parameter which define type?

Thanks.
__________________
Independent Senior Webdeveloper
Reply With Quote
Sponsored Links