From ecf891ab69b38ee1bcd0533d9a4f30d218c7e99c Mon Sep 17 00:00:00 2001 From: nveid <nveid@ispconfig3> Date: Mon, 21 Nov 2011 01:04:18 -0500 Subject: [PATCH] Added remoting API call: client_get_all @param -> session_id @return -> Array of all Client IDs on server --- interface/web/client/tools.inc.php | 78 ++++++++++++++++++++++++++++++++++++-- 1 files changed, 73 insertions(+), 5 deletions(-) diff --git a/interface/web/client/tools.inc.php b/interface/web/client/tools.inc.php index d98392f..abc85ae 100644 --- a/interface/web/client/tools.inc.php +++ b/interface/web/client/tools.inc.php @@ -28,13 +28,14 @@ */ function applyClientTemplates($clientId){ - global $app; + global $app,$page; /* * Get the master-template for the client */ - $sql = "SELECT template_master FROM client WHERE client_id = " . intval($clientId); + $sql = "SELECT template_master, template_additional FROM client WHERE client_id = " . intval($clientId); $record = $app->db->queryOneRecord($sql); $masterTemplateId = $record['template_master']; + $additionalTemplateStr = $record['template_additional']; /* * if the master-Template is custom there is NO changing @@ -42,20 +43,87 @@ if ($masterTemplateId > 0){ $sql = "SELECT * FROM client_template WHERE template_id = " . intval($masterTemplateId); $limits = $app->db->queryOneRecord($sql); + } else { + $limits = $page->dataRecord; } /* - * TODO: Process the additional tempaltes here (add them to the limits + * Process the additional tempaltes here (add them to the limits * if != -1) - * (like $limits['limit_database'] += $limitAdditional) */ + $addTpl = explode('/', $additionalTemplateStr); + foreach ($addTpl as $item){ + if (trim($item) != ''){ + $sql = "SELECT * FROM client_template WHERE template_id = " . intval($item); + $addLimits = $app->db->queryOneRecord($sql); + /* maybe the template is deleted in the meantime */ + if (is_array($addLimits)){ + foreach($addLimits as $k => $v){ + /* we can remove this condition, but it is easier to debug with it (don't add ids and other non-limit values) */ + if (strpos($k, 'limit') !== false){ + /* process the numerical limits */ + if (is_numeric($v)){ + /* switch for special cases */ + switch ($k){ + case 'limit_cron_frequency': + if ($v < $limits[$k]) $limits[$k] = $v; + /* silent adjustment of the minimum cron frequency to 1 minute */ + /* maybe this control test should be done via validator definition in tform.php file, but I don't know how */ + if ($limits[$k] < 1) $limits[$k] = 1; + break; + + default: + if ($limits[$k] > -1){ + if ($v == -1){ + $limits[$k] = -1; + } + else { + $limits[$k] += $v; + } + } + } + } + /* process the string limits (CHECKBOXARRAY, SELECT etc.) */ + elseif (is_string($v)){ + switch ($app->tform->formDef["tabs"]["limits"]["fields"][$k]['formtype']){ + case 'CHECKBOXARRAY': + if (!isset($limits[$k])){ + $limits[$k] = array(); + } + + $limits_values = $limits[$k]; + if (is_string($limits[$k])){ + $limits_values = explode($app->tform->formDef["tabs"]["limits"]["fields"][$k]["separator"],$limits[$k]); + } + $additional_values = explode($app->tform->formDef["tabs"]["limits"]["fields"][$k]["separator"],$v); + + /* unification of limits_values (master template) and additional_values (additional template) */ + $limits_unified = array(); + foreach($app->tform->formDef["tabs"]["limits"]["fields"][$k]["value"] as $key => $val){ + if (in_array($key,$limits_values) || in_array($key,$additional_values)) $limits_unified[] = $key; + } + $limits[$k] = implode($app->tform->formDef["tabs"]["limits"]["fields"][$k]["separator"],$limits_unified); + break; + + case 'SELECT': + $limit_values = array_keys($app->tform->formDef["tabs"]["limits"]["fields"][$k]["value"]); + /* choose the lower index of the two SELECT items */ + $limits[$k] = $limit_values[min(array_search($limits[$k], $limit_values), array_search($v, $limit_values))]; + break; + } + } + } + } + } + } + } /* * Write all back to the database */ $update = ''; foreach($limits as $k => $v){ - if (strpos($k, 'limit') !== false){ + if ((strpos($k, 'limit') !== false or $k == 'ssh_chroot' or $k == 'web_php_options') && !is_array($v)){ if ($update != '') $update .= ', '; $update .= '`' . $k . "`='" . $v . "'"; } -- Gitblit v1.9.1