HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Feature Requests (http://www.howtoforge.com/forums/forumdisplay.php?f=31)
-   -   Remoting API (http://www.howtoforge.com/forums/showthread.php?t=61685)

tio289 1st May 2013 23:32

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.


All times are GMT +2. The time now is 16:00.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.