Example #1
0
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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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}&nbsp;&raquo;' 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>&nbsp;</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") . "&nbsp;%</td>\n\t\t<td>&nbsp;</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") . "&nbsp;MB</td>\n\t\t<td>&nbsp;</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);
}
Example #2
0
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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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}&nbsp;&raquo;' 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);
}