function mysql_instance_params() { $page = CurrentPageName(); $tpl = new templates(); $ip = new networking(); $q = new mysql(); $ServerToAdd = 0; if (!is_numeric($_GET["ID"])) { $_GET["ID"] = 0; $ServerToAdd = 1; } if ($_GET["ID"] == 0) { $title = "{new_server}"; $ServerToAdd = 1; } $button = "{add}"; if ($_GET["ID"] > 0) { $ligne = mysql_fetch_array($q->QUERY_SQL("SELECT * FROM mysqlmulti WHERE ID='{$_GET["ID"]}'", "artica_backup")); $title = $ligne["servername"]; $button = "{apply}"; $params = unserialize(base64_decode($ligne["params"])); } $MonitConfig = $params["MONIT"]; if (!is_numeric($MonitConfig["watchdogCPU"])) { $MonitConfig["watchdogCPU"] = 100; } if (!is_numeric($MonitConfig["watchdogMEM"])) { $MonitConfig["watchdogMEM"] = 1000; } $ips = $ip->ALL_IPS_GET_ARRAY(); $ips["0.0.0.0"] = "{all}"; $t = time(); $users = new usersMenus(); $MONIT_INSTALLED = 1; if (!$users->MONIT_INSTALLED) { $MONIT_INSTALLED = 0; } $GetLastInstanceNum = GetLastInstanceNum() + 1; if (!is_numeric($ligne["listen_port"])) { $ligne["listen_port"] = GetLastPort() + 1; } if ($ligne["Dir"] == null) { $ligne["Dir"] = "{$MYSQL_DATA_DIR}-{$GetLastInstanceNum}"; } $nets = Field_array_Hash($ips, "{$t}-addr", $ligne["listen_addr"], "style:font-size:14px;padding:3px"); $html = "\n\t<div id='{$t}' ><span style='font-size:16px'>{$title}</span>\n\t<table style='width:99%' class=form>\n\t<tbody>\n\t<tr>\n\t\t<td class=legend style='font-size:14px'>{enabled}:</td>\n\t\t<td>" . Field_checkbox("{$t}-enabled", 1, $ligne["enabled"], "InstanceChecKenabled{$t}()") . "</td>\n\t\t<td> </td>\n\t</tr>\t\n\t<tr>\n\t\t<td class=legend style='font-size:14px'>{hostname}:</td>\n\t\t<td>" . Field_text("{$t}-hostname", $ligne["servername"], "font-size:14px;padding:3px;width:220px") . "</td>\n\t\t<td> </td>\n\t</tr>\t\n\t<tr>\n\t\t<td class=legend style='font-size:14px'>{UseNetworkCard}:</td>\n\t\t<td>" . Field_checkbox("{$t}-usesocket", 1, $ligne["usesocket"], "InstanceCheckUsesocket{$t}()") . "</td>\n\t\t<td> </td>\n\t</tr>\t\t\n\t\n\t<tr>\n\t\t<td class=legend style='font-size:14px'>{listen_address}:</td>\n\t\t<td>{$nets}</td>\n\t\t<td> </td>\n\t</tr>\n\t<tr>\n\t<tr>\n\t\t<td class=legend style='font-size:14px'>{listen_port}:</td>\n\t\t<td>" . Field_text("{$t}-listen_port", $ligne["listen_port"], "font-size:14px;padding:3px;width:90px") . "</td>\n\t\t<td> </td>\n\t</tr>\n\t<tr>\n\t\t<td class=legend style='font-size:14px'>{directory}:</td>\n\t\t<td>" . Field_text("{$t}-Dir", $ligne["Dir"], "font-size:14px;padding:3px;width:220px") . "</td>\n\t\t<td><input type='button' value='{browse} »' OnClick=\"javascript:Loadjs('tree.php?select-dir=yes&target-form={$t}-Dir');\"></td>\n\t</tr>\n\n\t\n\t\n\t\n\t<tr>\n\t\t<td colspan=3 align='right'><hr>" . button($button, "SaveInstance{$t}()", 16) . "</td>\n\t</tr>\n\t</tbody>\n\t</table>\n\t<hr>\n<table style='width:99%' class=form>\n\t<tbody>\n\t<tr>\n\t\t<td class=legend style='font-size:14px'>{enable_watchdog}:</td>\n\t\t<td>" . Field_checkbox("{$t}-watchdog", 1, $ligne["watchdog"], "InstanceCheckWatchdog{$t}()") . "</td>\n\t\t<td> </td>\n\t</tr>\t\t\n\t<tr>\n\t\t<td class=legend style='font-size:14px'>{notify_when_cpu_exceed}:</td>\n\t\t<td style='font-size:14px'>" . Field_text("{$t}-watchdogCPU", $MonitConfig["watchdogCPU"], "font-size:14px;width:60px") . " %</td>\n\t\t<td> </td>\n\t</tr>\t\n\t<tr>\n\t\t<td class=legend style='font-size:14px'>{notify_when_memory_exceed}:</td>\n\t\t<td style='font-size:14px'>" . Field_text("{$t}-watchdogMEM", $MonitConfig["watchdogMEM"], "font-size:14px;width:60px") . " MB</td>\n\t\t<td> </td>\n\t</tr>\n<tr>\n\t\t<td colspan=3 align='right'><hr>" . button($button, "SaveInstance{$t}()", 16) . "</td>\n\t</tr>\t\n\t</tbody>\n</table>\t\t\n\n</div>\n\t\n\t\n\t\n\t\n\t<script>\n\t\n\tvar x_{$t}_SaveInstance= function (obj) {\n\t\tvar results=obj.responseText;\n\t\tvar ServerToAdd={$ServerToAdd};\n\t\tif(results.length>0){alert(results);}\n\t\tRefreshTab('main_config_instance_mysql_multi');\n\t\tif(document.getElementById('mysql-instances-table')){FlexReloadMysqlInstanceTable();}\n\t\tif(ServerToAdd==1){{$_GET["layer"]}Hide();}\n\t\tif(document.getElementById('freeweb-mysql-instances')){freeweb_mysql_instances();}\n\t\t}\t\n\t\n\tfunction SaveInstance{$t}(){\n\t\tvar XHR = new XHRConnection();\t\n\t\tif(document.getElementById('{$t}-enabled').checked){XHR.appendData('enabled',1);}else{XHR.appendData('enabled',0);}\n\t\tif(document.getElementById('{$t}-usesocket').checked){XHR.appendData('usesocket',1);}else{XHR.appendData('usesocket',0);}\n\t\tif(document.getElementById('{$t}-watchdog').checked){XHR.appendData('watchdog',1);}else{XHR.appendData('watchdog',0);}\n\t\t\n\t\t\n\t\tXHR.appendData('watchdogMEM',document.getElementById('{$t}-watchdogMEM').value);\n\t\tXHR.appendData('watchdogCPU',document.getElementById('{$t}-watchdogCPU').value);\n\t\t\n\t\tXHR.appendData('hostname',document.getElementById('{$t}-hostname').value);\n\t\tXHR.appendData('listen_addr',document.getElementById('{$t}-addr').value);\n\t\tXHR.appendData('listen_port',document.getElementById('{$t}-listen_port').value);\n\t\tXHR.appendData('Dir',document.getElementById('{$t}-Dir').value);\n\t\tXHR.appendData('ID','{$_GET["ID"]}');\n\t\tAnimateDiv('{$t}');\n\t\tXHR.sendAndLoad('{$page}', 'POST',x_{$t}_SaveInstance);\n\t}\n\t\n\t\n\tfunction InstanceChecKenabled{$t}(){\n\t\tdocument.getElementById('{$t}-usesocket').disabled=true;\n\t\tdocument.getElementById('{$t}-hostname').disabled=true;\n\t\tdocument.getElementById('{$t}-addr').disabled=true;\n\t\tdocument.getElementById('{$t}-listen_port').disabled=true;\n\t\tdocument.getElementById('{$t}-Dir').disabled=true;\n\t\n\t\tif(document.getElementById('{$t}-enabled').checked){\n\t\t\tdocument.getElementById('{$t}-hostname').disabled=false;\n\t\t\tdocument.getElementById('{$t}-Dir').disabled=false;\n\t\t\tdocument.getElementById('{$t}-usesocket').disabled=false;\n\t\t}\n\t\tInstanceCheckUsesocket{$t}();\n\t}\n\t\n\tfunction InstanceCheckUsesocket{$t}(){\n\t\tif(!document.getElementById('{$t}-enabled').checked){return;}\n\t\t\tdocument.getElementById('{$t}-addr').disabled=true;\n\t\t\tdocument.getElementById('{$t}-listen_port').disabled=true;\t\t\n\t\tif(document.getElementById('{$t}-usesocket').checked){\n\t\t\tdocument.getElementById('{$t}-addr').disabled=false;\n\t\t\tdocument.getElementById('{$t}-listen_port').disabled=false;\n\t\t}\n\t\n\t}\n\t\n\tfunction InstanceCheckWatchdog{$t}(){\n\t\tvar MONIT_INSTALLED={$MONIT_INSTALLED};\n\t\tdocument.getElementById('{$t}-watchdog').disabled=true;\n\t\tdocument.getElementById('{$t}-watchdogMEM').disabled=true;\n\t\tdocument.getElementById('{$t}-watchdogCPU').disabled=true;\n\t\tif(MONIT_INSTALLED==0){return;}\n\t\tdocument.getElementById('{$t}-watchdog').disabled=false;\n\t\tif(!document.getElementById('{$t}-watchdog').checked){return;}\n\t\tdocument.getElementById('{$t}-watchdogMEM').disabled=false;\n\t\tdocument.getElementById('{$t}-watchdogCPU').disabled=false;\t\t\n\t\n\t}\n\t\n\t\n\tInstanceChecKenabled{$t}();\n\tInstanceCheckWatchdog{$t}()\n\t</script>\n\t\n\t"; echo $tpl->_ENGINE_parse_body($html); }
function zarafa_instance_params() { $page = CurrentPageName(); $tpl = new templates(); $ip = new networking(); $q = new mysql(); $ldap = new clladp(); if (!is_numeric($_GET["ID"])) { $_GET["ID"] = 0; } if ($_GET["ID"] == 0) { $title = "{new_server}"; } $button = "{add}"; if ($_GET["ID"] > 0) { $ligne = mysql_fetch_array($q->QUERY_SQL("SELECT * FROM zarafamulti WHERE ID='{$_GET["ID"]}'", "artica_backup")); $title = $ligne["servername"]; $button = "{apply}"; } if (!is_numeric($ligne["mysql_instance_id"])) { $ligne["mysql_instance_id"] = 0; } $sql = "SELECT ID,servername FROM mysqlmulti WHERE enabled=1 ORDER BY servername"; $results = $q->QUERY_SQL($sql, 'artica_backup'); $mysqlinstances[0] = "{mysql_master}"; while ($ligne2 = mysql_fetch_assoc($results)) { $mysqlinstances[$ligne2["ID"]] = $ligne2["servername"]; } $sql = "SELECT value FROM postfix_multi WHERE `key` = 'myhostname' ORDER BY value"; $results = $q->QUERY_SQL($sql, 'artica_backup'); $PostfixInstances[null] = "{postfix_master}"; while ($ligne2 = mysql_fetch_assoc($results)) { $PostfixInstances[$ligne2["value"]] = $ligne2["value"]; } $ips = $ip->ALL_IPS_GET_ARRAY(); $ips["0.0.0.0"] = "{all}"; $t = time(); $ous = $ldap->hash_get_ou(true); $ous[null] = "{all}"; $GetLastInstanceNum = GetLastInstanceNum() + 1; if (!is_numeric($ligne["listen_port"])) { $ligne["listen_port"] = GetLastPort() + 1; } if (!is_numeric($ligne["lmtp_port"])) { $ligne["lmtp_port"] = GetLastlmtpport() + 1; } if ($ligne["Dir"] == null) { $ligne["Dir"] = "/var/lib/zarafa-{$GetLastInstanceNum}"; } $nets = Field_array_Hash($ips, "{$t}-addr", $ligne["listen_addr"], "style:font-size:14px;padding:3px"); $mysqlinstances = Field_array_Hash($mysqlinstances, "{$t}-mysql_instance_id", $ligne["mysql_instance_id"], "style:font-size:14px;padding:3px"); $PostfixInstances = Field_array_Hash($PostfixInstances, "{$t}-PostfixInstance", $ligne["PostfixInstance"], "style:font-size:14px;padding:3px"); $ous = Field_array_Hash($ous, "{$t}-ou", $ligne["ou"], "style:font-size:14px;padding:3px"); $html = "\n\t<div id='{$t}' ><span style='font-size:16px'>{$title}</span>\n\t<table style='width:99%' class=form>\n\t<tbody>\n\t<tr>\n\t\t<td class=legend style='font-size:14px'>{enabled}:</td>\n\t\t<td>" . Field_checkbox("{$t}-enabled", 1, $ligne["enabled"], "InstanceChecKenabled{$t}()") . "</td>\n\t\t<td> </td>\n\t</tr>\t\n\t<tr>\n\t\t<td class=legend style='font-size:14px'>{organization}:</td>\n\t\t<td>{$ous}</td>\n\t\t<td> </td>\n\t</tr>\t\n\t<tr>\n\t\t<td class=legend style='font-size:14px'>{hostname}:</td>\n\t\t<td>" . Field_text("{$t}-hostname", $ligne["servername"], "font-size:14px;padding:3px;width:220px") . "</td>\n\t\t<td> </td>\n\t</tr>\t\n\t<tr>\n\t\t<td class=legend style='font-size:14px'>{UseNetworkCard}:</td>\n\t\t<td>" . Field_checkbox("{$t}-usesocket", 1, $ligne["usesocket"], "InstanceCheckUsesocket{$t}()") . "</td>\n\t\t<td> </td>\n\t</tr>\t\t\n\t\n\t<tr>\n\t\t<td class=legend style='font-size:14px'>{listen_address}:</td>\n\t\t<td>{$nets}</td>\n\t\t<td> </td>\n\t</tr>\n\t<tr>\n\t<tr>\n\t\t<td class=legend style='font-size:14px'>{listen_port}:</td>\n\t\t<td>" . Field_text("{$t}-listen_port", $ligne["listen_port"], "font-size:14px;padding:3px;width:90px") . "</td>\n\t\t<td> </td>\n\t</tr>\n\t<tr>\n\t\t<td class=legend style='font-size:14px'>{lmtp_port}:</td>\n\t\t<td>" . Field_text("{$t}-lmtp_port", $ligne["lmtp_port"], "font-size:14px;padding:3px;width:90px") . "</td>\n\t\t<td> </td>\n\t</tr>\t\n\t<tr>\n\t\t<td class=legend style='font-size:14px'>{mysql_instance}:</td>\n\t\t<td>{$mysqlinstances}</td>\n\t\t<td> </td>\n\t</tr>\t\n\t<tr>\n\t\t<td class=legend style='font-size:14px'>{postfix_instance}:</td>\n\t\t<td>{$PostfixInstances}</td>\n\t\t<td> </td>\n\t</tr>\t\n\t\n\t\n\t<tr>\n\t\t<td class=legend style='font-size:14px'>{attachments_path}:</td>\n\t\t<td>" . Field_text("{$t}-Dir", $ligne["Dir"], "font-size:14px;padding:3px;width:220px") . "</td>\n\t\t<td><input type='button' value='{browse} »' OnClick=\"javascript:Loadjs('tree.php?select-dir=yes&target-form={$t}-Dir');\"></td>\n\t</tr>\t\n\t<tr>\n\t\t<td colspan=3 align='right'><hr>" . button($button, "SaveInstance{$t}()", 16) . "</td>\n\t</tr>\n\t</tbody>\n\t</table>\n\t</div>\n\t<script>\n\t\n\tvar x_{$t}_SaveInstance= function (obj) {\n\t\tvar results=obj.responseText;\n\t\tif(results.length>0){alert(results);}\n\t\tRefreshTab('main_config_instance_zarafa_multi');\n\t\tif(document.getElementById('zarafa-instances-table')){FlexReloadZarafaInstanceTable();}\n\t\t}\t\n\t\n\tfunction SaveInstance{$t}(){\n\t\tvar XHR = new XHRConnection();\t\n\t\tif(document.getElementById('{$t}-enabled').checked){XHR.appendData('enabled',1);}else{XHR.appendData('enabled',0);}\n\t\tif(document.getElementById('{$t}-usesocket').checked){XHR.appendData('usesocket',1);}else{XHR.appendData('usesocket',0);}\n\t\tXHR.appendData('mysql_instance_id',document.getElementById('{$t}-mysql_instance_id').value);\n\t\tXHR.appendData('hostname',document.getElementById('{$t}-hostname').value);\n\t\tXHR.appendData('ou',document.getElementById('{$t}-ou').value);\n\t\tXHR.appendData('listen_addr',document.getElementById('{$t}-addr').value);\n\t\tXHR.appendData('listen_port',document.getElementById('{$t}-listen_port').value);\n\t\tXHR.appendData('Dir',document.getElementById('{$t}-Dir').value);\n\t\tXHR.appendData('lmtp_port',document.getElementById('{$t}-lmtp_port').value);\n\t\tXHR.appendData('PostfixInstance',document.getElementById('{$t}-PostfixInstance').value);\n\t\tXHR.appendData('ID','{$_GET["ID"]}');\n\t\tAnimateDiv('{$t}');\n\t\tXHR.sendAndLoad('{$page}', 'POST',x_{$t}_SaveInstance);\n\t}\n\t\n\t\n\tfunction InstanceChecKenabled{$t}(){\n\t\tdocument.getElementById('{$t}-usesocket').disabled=true;\n\t\tdocument.getElementById('{$t}-hostname').disabled=true;\n\t\tdocument.getElementById('{$t}-addr').disabled=true;\n\t\tdocument.getElementById('{$t}-listen_port').disabled=true;\n\t\tdocument.getElementById('{$t}-Dir').disabled=true;\n\t\tdocument.getElementById('{$t}-ou').disabled=true;\n\t\tdocument.getElementById('{$t}-mysql_instance_id').disabled=true;\n\t\tdocument.getElementById('{$t}-lmtp_port').disabled=true;\n\t\tdocument.getElementById('{$t}-PostfixInstance').disabled=true;\n\t\t\n\t\t\n\t\n\t\tif(document.getElementById('{$t}-enabled').checked){\n\t\t\tdocument.getElementById('{$t}-hostname').disabled=false;\n\t\t\tdocument.getElementById('{$t}-Dir').disabled=false;\n\t\t\tdocument.getElementById('{$t}-usesocket').disabled=false;\n\t\t\tdocument.getElementById('{$t}-ou').disabled=false;\n\t\t\tdocument.getElementById('{$t}-mysql_instance_id').disabled=false;\t\n\t\t\tdocument.getElementById('{$t}-lmtp_port').disabled=false;\t\n\t\t\tdocument.getElementById('{$t}-PostfixInstance').disabled=false;\t\n\t\t}\n\t\tInstanceCheckUsesocket{$t}();\n\t}\n\t\n\tfunction InstanceCheckUsesocket{$t}(){\n\t\tdocument.getElementById('{$t}-listen_port').disabled=false;\n\t\tif(!document.getElementById('{$t}-enabled').checked){return;}\n\t\t\tdocument.getElementById('{$t}-addr').disabled=true;\t\n\t\tif(document.getElementById('{$t}-usesocket').checked){\n\t\t\tdocument.getElementById('{$t}-addr').disabled=false;\n\t\t\t\n\t\t}\n\t\n\t}\n\t\n\t\n\tInstanceChecKenabled{$t}();\n\t</script>\n\t\n\t"; echo $tpl->_ENGINE_parse_body($html); }