function popup_list()
{
include_once dirname(__FILE__) . '/ressources/class.apache.inc';
$tpl = new templates();
$MyPage = CurrentPageName();
$q = new mysql();
$vhosts = new vhosts();
$search = '%';
$table = "freeweb";
$page = 1;
$FORCE_FILTER = "";
if ($q->COUNT_ROWS($table, 'artica_backup') == 0) {
writelogs("{$table}, no row", __FILE__, __FUNCTION__, __FILE__, __LINE__);
$data['page'] = $page;
$data['total'] = $total;
$data['rows'] = array();
echo json_encode($data);
return;
}
if (isset($_POST["sortname"])) {
if ($_POST["sortname"] != null) {
$ORDER = "ORDER BY {$_POST["sortname"]} {$_POST["sortorder"]}";
}
}
if (isset($_POST['page'])) {
$page = $_POST['page'];
}
if ($_POST["query"] != null) {
$_POST["query"] = "*" . $_POST["query"] . "*";
$_POST["query"] = str_replace("**", "*", $_POST["query"]);
$_POST["query"] = str_replace("**", "*", $_POST["query"]);
$_POST["query"] = str_replace("*", "%", $_POST["query"]);
$search = $_POST["query"];
$searchstring = "AND (`{$_POST["qtype"]}` LIKE '{$search}')";
$sql = "SELECT COUNT(*) as TCOUNT FROM `{$table}` WHERE 1 {$FORCE_FILTER} {$searchstring}";
$ligne = mysql_fetch_array($q->QUERY_SQL($sql));
$total = $ligne["TCOUNT"];
} else {
$sql = "SELECT COUNT(*) as TCOUNT FROM `{$table}` WHERE 1 {$FORCE_FILTER}";
$ligne = mysql_fetch_array($q->QUERY_SQL($sql, 'artica_backup'));
$total = $ligne["TCOUNT"];
}
if (isset($_POST['rp'])) {
$rp = $_POST['rp'];
}
$pageStart = ($page - 1) * $rp;
$limitSql = "LIMIT {$pageStart}, {$rp}";
$sql = "SELECT * FROM `{$table}` WHERE 1 {$searchstring} {$FORCE_FILTER} {$ORDER} {$limitSql}";
writelogs($sql, __FUNCTION__, __FILE__, __LINE__);
$results = $q->QUERY_SQL($sql, 'artica_backup');
$data = array();
$data['page'] = $page;
$data['total'] = $total;
$data['rows'] = array();
if (!$q->ok) {
$data['rows'][] = array('id' => $ligne[time() + 1], 'cell' => array($q->mysql_error, "", "", ""));
$data['rows'][] = array('id' => $ligne[time()], 'cell' => array($sql, "", "", ""));
echo json_encode($data);
return;
}
//if(mysql_num_rows($results)==0){$data['rows'][] = array('id' => $ligne[time()],'cell' => array($sql,"", "",""));}
$sock = new sockets();
while ($ligne = mysql_fetch_assoc($results)) {
$id = $ligne["ID"];
$groupware = null;
if ($ligne["groupware"] != null) {
$groupware = div_groupware("({{$vhosts->TEXT_ARRAY[$ligne["groupware"]]["TITLE"]}})");
}
$choose = imgsimple("arrow-right-24.png", null, "BackWWWWChoose('{$ligne["servername"]}')");
$data['rows'][] = array('id' => $id, 'cell' => array("<psan style='font-size:16px;'>{$ligne["servername"]}{$groupware}</span>", $choose));
}
echo json_encode($data);
}
function servers_list()
{
include_once dirname(__FILE__) . '/ressources/class.apache.inc';
unset($_SESSION["MYSQL_PARAMETERS"]);
$vhosts = new vhosts();
$search = $_GET["search"];
$MyPage = CurrentPageName();
$page = 1;
$users = new usersMenus();
$DNS_INSTALLED = false;
$tpl = new templates();
$GLOBALS["CLASS_TPL"] = $tpl;
$sock = new sockets();
$where = null;
$query_groupware = null;
$ZarafaWebAccessInFrontEnd = $sock->GET_INFO("ZarafaWebAccessInFrontEnd");
if (!is_numeric($ZarafaWebAccessInFrontEnd)) {
$ZarafaWebAccessInFrontEnd = 1;
}
if (!$users->ZARAFA_INSTALLED) {
$ZarafaWebAccessInFrontEnd = 0;
}
$FreeWebDisableSSL = intval(trim($sock->GET_INFO("FreeWebDisableSSL")));
$addg = imgtootltip("plus-24.png", "{add} {joomlaservername}", "Loadjs('freeweb.edit.php?hostname=&force-groupware={$_GET["force-groupware"]}')");
if ($_POST["query"] != null) {
$search = $_POST["query"];
}
$q = new mysql();
$q->QUERY_SQL("DELETE FROM freeweb WHERE servername=''", 'artica_backup');
if ($_GET["force-groupware"] != null) {
if ($_GET["force-groupware"] == "ZARAFA-WEBS") {
if ($_GET["ForceInstanceZarafaID"] > 0) {
$ForceInstanceZarafaIDQ = " AND ForceInstanceZarafaID={$_GET["ForceInstanceZarafaID"]}";
}
$query_groupware = " AND ((groupware='ZARAFA'{$ForceInstanceZarafaIDQ}) OR (groupware='ZARAFA_MOBILE'{$ForceInstanceZarafaIDQ}) OR (groupware='Z-PUSH'{$ForceInstanceZarafaIDQ}) OR (groupware='WEBAPP'{$ForceInstanceZarafaIDQ}))";
}
if ($query_groupware == null) {
$query_groupware = " AND groupware='{$_GET["force-groupware"]}'";
}
}
if (!$users->AsSystemAdministrator) {
$whereOU = " AND ou='{$_SESSION["ou"]}'";
$ou = " » {$_SESSION["ou"]}";
}
if (strlen($search) > 1) {
$search = "*{$search}*";
$search = str_replace("*", "%", $search);
$search = str_replace("%%", "%", $search);
$whereOU = "AND (servername LIKE '{$search}' {$whereOU}{$query_groupware}) OR (domainname LIKE '{$search}' {$whereOU}{$query_groupware})";
} else {
$query_groupware_single = $query_groupware;
}
if ($users->dnsmasq_installed) {
$DNS_INSTALLED = true;
}
if ($users->POWER_DNS_INSTALLED) {
$DNS_INSTALLED = true;
}
$data = array();
$data['rows'] = array();
if (strlen($search) < 2) {
if ($_GET["force-groupware"] != "ZARAFA-WEBS") {
$sock = new sockets();
$EnableWebDavPerUser = $sock->GET_INFO("EnableWebDavPerUser");
if (!is_numeric($EnableWebDavPerUser)) {
$EnableWebDavPerUser = 0;
}
$WebDavPerUserSets = unserialize(base64_decode($sock->GET_INFO("WebDavPerUserSets")));
if ($EnableWebDavPerUser == 1) {
$icon = "webdav-32.png";
$groupware = div_groupware("WebDav");
$href = "<a href=\"javascript:blur();\" \n\t\t\t\tOnClick=\"javascript:Loadjs('freeweb.webdavusr.php')\" \n\t\t\t\tstyle='font-size:13px;text-decoration:underline;font-weight:bold'>";
$edit = imgtootltip($icon, "{apply} *.{$WebDavPerUserSets["WebDavSuffix"]}", "Loadjs('freeweb.webdavusr.php')");
if ($WebDavPerUserSets["EnableSSL"] == 1) {
$ssl = "20-check.png";
} else {
$ssl = "none-20.png";
}
$data['rows'][] = array('id' => '-200', 'cell' => array($icon, "{$href}*.{$WebDavPerUserSets["WebDavSuffix"]}</a>", " ", " ", " ", " ", " ", " ", " ", " ", " ", " "));
}
}
}
if (isset($_POST["sortname"])) {
if ($_POST["sortname"] != null) {
$ORDER = "ORDER BY {$_POST["sortname"]} {$_POST["sortorder"]}";
}
}
if (isset($_POST['page'])) {
$page = $_POST['page'];
}
if (isset($_POST['rp'])) {
$rp = $_POST['rp'];
}
if (!is_numeric($rp)) {
$rp = 50;
}
$pageStart = ($page - 1) * $rp;
$limitSql = "LIMIT {$pageStart}, {$rp}";
$q = new mysql();
$sqlCount = "SELECT COUNT(*) AS TCOUNT FROM freeweb WHERE 1 {$whereOU}{$query_groupware_single}";
$ligne = mysql_fetch_array($q->QUERY_SQL($sqlCount, "artica_backup"));
if (!$q->ok) {
writelogs("{$q->mysql_error}", __FUNCTION__, __FILE__, __LINE__);
json_error_show($q->mysql_error, 1);
}
$countDeRows = $ligne["TCOUNT"];
writelogs($sqlCount . " {$countDeRows} rows", __FUNCTION__, __FILE__, __LINE__);
if ($countDeRows == 0) {
json_error_show("");
}
$total = $countDeRows;
$data['page'] = $page;
$data['total'] = $total;
$members_text = $tpl->_ENGINE_parse_body("{members}");
if (!isset($_SESSION["CheckTableWebsites"])) {
$q->BuildTables();
$_SESSION["CheckTableWebsites"] = true;
}
$sql = "SELECT * FROM freeweb WHERE 1 {$whereOU}{$query_groupware_single} {$ORDER} {$limitSql}";
$results = $q->QUERY_SQL($sql, 'artica_backup');
writelogs($sql . " " . mysql_num_rows($results) . " rows", __FUNCTION__, __FILE__, __LINE__);
if (!$q->ok) {
writelogs("{$q->mysql_error}", __FUNCTION__, __FILE__, __LINE__);
}
$vgservices = unserialize(base64_decode($sock->GET_INFO("vgservices")));
$duplicate = $tpl->javascript_parse_text("{duplicate}");
$pdns = new pdns();
while ($ligne = mysql_fetch_array($results, MYSQL_ASSOC)) {
if ($ligne["useSSL"] == 1) {
$ssl = "20-check.png";
} else {
$ssl = "20-check-grey.png";
}
if ($FreeWebDisableSSL == 1) {
$ssl = "20-check-grey.png";
}
$DirectorySize = FormatBytes($ligne["DirectorySize"] / 1024);
$WebCopyID = $ligne["WebCopyID"];
$groupware_duplicate = null;
$statistics = " ";
$exec_statistics = " ";
$Members = null;
$groupware = null;
$forward_text = null;
$checkDNS = "<img src='img/20-check-grey.png'>";
$checkMember = "<img src='img/20-check-grey.png'>";
$JSDNS = 0;
if ($DNS_INSTALLED) {
$ip = $pdns->GetIpDN($ligne["servername"]);
if ($ip != null) {
$checkDNS = "<img src='img/20-check.png'>";
$JSDNS = 1;
}
}
$ServerAlias = null;
$Params = @unserialize(base64_decode($ligne["Params"]));
$f = array();
if (isset($Params["ServerAlias"])) {
while (list($host, $num) = each($Params["ServerAlias"])) {
$f[] = $host;
}
$ServerAlias = div_groupware("<a href=\"javascript:blur();\" \n\t\t\tOnClick=\"javascript:Loadjs('freeweb.edit.ServerAlias.php?servername={$ligne["servername"]}')\" \n\t\t\tstyle='text-decoration:underline'><i>" . @implode(", ", $f) . "</i>");
}
if ($ligne["uid"] != null) {
$checkMember = "<img src='img/20-check.png'>";
}
$added_port = null;
$icon = build_icon($ligne, $ligne["servername"]);
if ($vgservices["freewebs"] != null) {
if ($ligne["lvm_size"] > 0) {
$ligne["lvm_size"] = $ligne["lvm_size"] * 1024;
$sizevg = " <i style='font-size:11px'>(" . FormatBytes($ligne["lvm_size"]) . ")</i>";
}
}
$ServerPort = $ligne["ServerPort"];
if ($ServerPort > 0) {
$added_port = ":{$ServerPort}";
}
if ($ligne["groupware"] != null) {
$groupware = div_groupware("({{$vhosts->TEXT_ARRAY[$ligne["groupware"]]["TITLE"]}})", $ligne["enabled"]);
}
if ($ligne["Forwarder"] == 1) {
$forward_text = div_groupware("{www_forward} <b>{$ligne["ForwardTo"]}</b>", $ligne["enabled"]);
}
$js_edit = "Loadjs('freeweb.edit.php?hostname={$ligne["servername"]}&t={$_GET["t"]}')";
$servername_text = $ligne["servername"];
if ($servername_text == "_default_") {
$servername_text = "{all}";
if ($ZarafaWebAccessInFrontEnd == 1) {
$servername_text = "{APP_ZARAFA}";
}
if ($FreeWebDisableSSL == 0) {
$ssl = "20-check.png";
}
$groupware = div_groupware("({default_website})", $ligne["enabled"]);
} else {
$checkResolv = "<img src='img/20-check.png'>";
if (trim($ligne["resolved_ipaddr"]) == null) {
$error_text = "{could_not_find_iphost}";
$checkResolv = "<img src='img/20-check-grey.png'>";
}
}
$colorhref = null;
if ($ligne["enabled"] == 0) {
$colorhref = "color:#8C8C8C";
}
$href = "<a href=\"javascript:blur();\" \n\t\tOnClick=\"javascript:Loadjs('freeweb.edit.php?hostname={$ligne["servername"]}&t={$_GET["t"]}')\"\n\t\tstyle='font-size:16px;text-decoration:underline;font-weight:bold;{$colorhref}'>";
$color = "black";
$md5S = md5($ligne["servername"]);
$delete = icon_href("delete-32.png", "FreeWebDelete('{$ligne["servername"]}',{$JSDNS},'{$md5S}')");
$sql = "SELECT ID FROM drupal_queue_orders WHERE `ORDER`='DELETE_FREEWEB' AND `servername`='{$ligne["servername"]}'";
$ligneDrup = @mysql_fetch_array($q->QUERY_SQL($sql, 'artica_backup'));
if ($ligne["ID"] > 0) {
$edit = imgtootltip("folder-tasks-32.png", "{delete}");
$color = "#8a8a8a";
$delete = imgtootltip("delete-32-grey.png", "{delete} {scheduled}");
}
$sql = "SELECT ID FROM drupal_queue_orders WHERE `ORDER`='INSTALL_GROUPWARE' AND `servername`='{$ligne["servername"]}'";
if ($ligne["ID"] > 0) {
$edit = icon_href("folder-tasks-32.png", "Loadjs('freeweb.edit.php?hostname={$ligne["servername"]}')");
$color = "#8a8a8a";
$delete = icon_href("delete-32-grey.png");
$groupware = div_groupware("({installing} {{$vhosts->TEXT_ARRAY[$ligne["groupware"]]["TITLE"]}})", $ligne["enabled"]);
}
$Params = @unserialize(base64_decode($ligne["Params"]));
$IsAuthen = false;
if ($Params["LDAP"]["enabled"] == 1) {
$IsAuthen = true;
}
if ($Params["NTLM"]["enabled"] == 1) {
$IsAuthen = true;
}
$color_orange = "#B64B13";
if ($ligne["enabled"] == 0) {
$color_orange = "#8C8C8C";
}
if ($IsAuthen) {
$Members = "<span style='font-size:11px;font-weight:bold;color:{$color_orange};'> «<a href=\"javascript:blur();\" \n\t\t\tOnClick=\"javascript:Loadjs('freeweb.edit.ldap.users.php?servername={$ligne["servername"]}');\"\n\t\t\tstyle='font-size:11px;font-weight:bold;color:{$color_orange};text-decoration:underline;font-style:italic'>{$members_text}</a>\n\t\t\t »</span>";
}
$memory = "-";
$requests_second = "-";
$traffic_second = "-";
$uptime = null;
$table_name_stats = "apache_stats_" . date('Ym');
$sql = "SELECT * FROM {$table_name_stats} WHERE servername='{$ligne["servername"]}' ORDER by zDate DESC LIMIT 0,1";
$ligneStats = mysql_fetch_array($q->QUERY_SQL($sql, "artica_events"));
if ($ligneStats["total_memory"] > 0) {
$memory = FormatBytes($ligneStats["total_memory"] / 1024);
$requests_second = "{$ligneStats["requests_second"]}/s";
$traffic_second = FormatBytes($ligneStats["traffic_second"] / 1024) . "/s";
$uptime = div_groupware("{uptime}:{$ligneStats["UPTIME"]}", $ligne["enabled"]);
}
$groupware = $tpl->_ENGINE_parse_body($groupware);
$forward_text = $tpl->_ENGINE_parse_body($forward_text);
$servername_text = $tpl->_ENGINE_parse_body($servername_text);
$ServerAlias = $tpl->_ENGINE_parse_body($ServerAlias);
$uptime = $tpl->_ENGINE_parse_body($uptime);
$memory = $tpl->_ENGINE_parse_body($memory);
$requests_second = $tpl->_ENGINE_parse_body("{$requests_second}");
$traffic_second = $tpl->_ENGINE_parse_body($traffic_second);
$checkResolv = $tpl->_ENGINE_parse_body($checkResolv);
$checkDNS = $tpl->_ENGINE_parse_body($checkDNS);
$checkMember = $tpl->_ENGINE_parse_body($checkMember);
$delete = $tpl->_ENGINE_parse_body($delete);
if ($WebCopyID > 0) {
$ligne2 = mysql_fetch_array($q->QUERY_SQL("SELECT sitename FROM httrack_sites WHERE ID={$WebCopyID}", "artica_backup"));
$groupware = div_groupware("WebCopy: {$ligne2["sitename"]}", $ligne["enabled"]);
}
if ($ligne["groupware"] == "UPDATEUTILITY") {
$iconPlus = "<a href=\"javascript:blur();\" OnClick=\"javascript:Loadjs('UpdateUtility.php?js=yes');\"><img src='img/settings-15.png' align='left'></a>";
}
$servername_enc = urlencode($ligne["servername"]);
$color_span = "#5F5656";
if ($ligne["enabled"] == 0) {
$color_span = "#8C8C8C";
}
$compile = imgsimple("apply-config-32.png", null, "Loadjs('freeweb.rebuild.progress.php?servername={$servername_enc}')");
$enable = Field_checkbox("enable_{$md5S}", 1, $ligne["enabled"], "Loadjs('freeweb.servers.php?enable-site-js=yes&t={$_GET["t"]}&servername={$servername_enc}&enabled={$ligne["enabled"]}');");
if ($ligne["groupware_duplicate"] != null) {
$groupware_duplicate = "<br><span style='color:#d32d2d'>{$duplicate} :{$ligne["groupware_duplicate"]}</span>";
}
if ($ligne["enabled"] == 0) {
$requests_second = "-";
$traffic_second = "-";
$memory = "-";
$color = "#8C8C8C";
$color_span = $color;
$icon = "status_disabled.gif";
$compile = " ";
}
$spanStyle1 = "<span style='font-size:11px;font-weight:bold;color:#5F5656;'>";
$data['rows'][] = array('id' => $md5S, 'cell' => array("<img src='img/{$icon}'>", "<strong style='font-size:13px;style='color:{$color}'>{$href}{$servername_text}</a>{$groupware_duplicate}{$iconPlus}{$groupware}{$forward_text}\n\t\t\t\t\t{$added_port}{$Members}{$sizevg}</strong></span>{$ServerAlias}{$uptime}", $compile, $enable, "{$spanStyle1}{$DirectorySize}</span>", "{$spanStyle1}{$memory}</span>", "{$spanStyle1}{$requests_second} | {$traffic_second}</span>", "<img src='img/{$ssl}'>", "{$checkResolv}", "{$checkDNS}", "{$checkMember}", $delete));
}
echo json_encode($data);
}
function websites_search()
{
include_once dirname(__FILE__) . '/ressources/class.apache.inc';
$vhosts = new vhosts();
$GLOBALS["IMG_ARRAY_64"] = $vhosts->IMG_ARRAY_64;
$searchstring = string_to_flexquery("websites-search");
$DNS_INSTALLED = false;
$q = new mysql();
$sql = "SELECT * FROM freeweb WHERE 1 {$searchstring} LIMIT 0,250";
$results = $q->QUERY_SQL($sql, 'artica_backup');
$tpl = new templates();
$GLOBALS["CLASS_TPL"] = $tpl;
$boot = new boostrap_form();
if ($users->dnsmasq_installed) {
$DNS_INSTALLED = true;
}
if ($users->POWER_DNS_INSTALLED) {
$DNS_INSTALLED = true;
}
$pdns = new pdns();
while ($ligne = mysql_fetch_array($results, MYSQL_ASSOC)) {
if ($ligne["useSSL"] == 1) {
$ssl = "check-32.png";
} else {
$ssl = "check-32-grey.png";
}
$DirectorySize = FormatBytes($ligne["DirectorySize"] / 1024);
$WebCopyID = $ligne["WebCopyID"];
$statistics = " ";
$exec_statistics = " ";
$Members = null;
$groupware = null;
$forward_text = null;
$error_text = null;
$checkDNS = "<img src='img/check-48.png'>";
$checkMember = "<img src='img/check-48-grey.png'>";
$JSDNS = 0;
if ($DNS_INSTALLED) {
$ip = $pdns->GetIpDN($ligne["servername"]);
if ($ip != null) {
$checkDNS = "<img src='img/check-48.png'>";
$JSDNS = 1;
}
}
$ServerAlias = null;
$Params = @unserialize(base64_decode($ligne["Params"]));
$f = array();
if (isset($Params["ServerAlias"])) {
while (list($host, $num) = each($Params["ServerAlias"])) {
$f[] = $host;
}
$ServerAlias = div_groupware("<a href=\"javascript:blur();\"\n\t\t\t\t\tOnClick=\"javascript:Loadjs('freeweb.edit.ServerAlias.php?servername={$ligne["servername"]}')\"\n\t\t\t\t\tstyle='text-decoration:underline'><i>" . @implode(", ", $f) . "</i>");
}
if ($ligne["uid"] != null) {
$checkMember = "<img src='img/20-check.png'>";
}
$added_port = null;
$icon = build_icon($ligne, $ligne["servername"]);
$ServerPort = $ligne["ServerPort"];
if ($ServerPort > 0) {
$added_port = ":{$ServerPort}";
}
if ($ligne["groupware"] != null) {
$groupware = div_groupware("({{$vhosts->TEXT_ARRAY[$ligne["groupware"]]["TITLE"]}})", $ligne["enabled"]);
}
if ($ligne["Forwarder"] == 1) {
$forward_text = div_groupware("{www_forward} <b>{$ligne["ForwardTo"]}</b>", $ligne["enabled"]);
}
$js_edit = "Loadjs('freeweb.edit.php?hostname={$ligne["servername"]}&t={$_GET["t"]}')";
$servername_text = $ligne["servername"];
if ($servername_text == "_default_") {
$servername_text = "{all}";
$groupware = div_groupware("({default_website})", $ligne["enabled"]);
} else {
if (!preg_match("#^[0-9]+\\.[0-9]+\\.[0-9]+\\.[0-9]+#", $ligne["servername"])) {
$checkResolv = "<img src='img/20-check.png'>";
if (trim($ligne["resolved_ipaddr"]) == null) {
$error_text = $tpl->_ENGINE_parse_body("\n\t\t\t\t\t<p class=text-error style='font-size:12px;margin-top:10px'>\n\t\t\t\t\t\t{could_not_find_iphost}\n\t\t\t\t\t</p>");
$checkResolv = "<img src='img/20-check-grey.png'>";
}
}
}
$colorhref = null;
if ($ligne["enabled"] == 0) {
$colorhref = "color:#8C8C8C";
}
$href = "<a href=\"javascript:blur();\"\n\t\tOnClick=\"javascript:Loadjs('freeweb.edit.php?hostname={$ligne["servername"]}&t={$_GET["t"]}')\"\n\t\tstyle='font-size:13px;text-decoration:underline;font-weight:bold;{$colorhref}'>";
$color = "black";
$md5S = md5($ligne["servername"]);
$delete = icon_href("delete-48.png", "FreeWebDelete('{$ligne["servername"]}',{$JSDNS},'{$md5S}')");
$sql = "SELECT ID FROM drupal_queue_orders WHERE `ORDER`='DELETE_FREEWEB' AND `servername`='{$ligne["servername"]}'";
$ligneDrup = @mysql_fetch_array($q->QUERY_SQL($sql, 'artica_backup'));
if ($ligne["ID"] > 0) {
$edit = imgtootltip("folder-tasks-32.png", "{delete}");
$color = "#8a8a8a";
$delete = imgtootltip("delete-48-grey.png", "{delete} {scheduled}");
}
$sql = "SELECT ID FROM drupal_queue_orders WHERE `ORDER`='INSTALL_GROUPWARE' AND `servername`='{$ligne["servername"]}'";
if ($ligne["ID"] > 0) {
$edit = icon_href("folder-tasks-32.png", "Loadjs('freeweb.edit.php?hostname={$ligne["servername"]}')");
$color = "#8a8a8a";
$delete = icon_href("delete-48-grey.png");
$groupware = div_groupware("({installing} {{$vhosts->TEXT_ARRAY[$ligne["groupware"]]["TITLE"]}})", $ligne["enabled"]);
}
$Params = @unserialize(base64_decode($ligne["Params"]));
$IsAuthen = false;
if ($Params["LDAP"]["enabled"] == 1) {
$IsAuthen = true;
}
if ($Params["NTLM"]["enabled"] == 1) {
$IsAuthen = true;
}
$color_orange = "#B64B13";
if ($ligne["enabled"] == 0) {
$color_orange = "#8C8C8C";
}
if ($IsAuthen) {
$Members = "<span style='font-size:14px;font-weight:bold;color:{$color_orange};'> «<a href=\"javascript:blur();\"\n\t\tOnClick=\"javascript:Loadjs('freeweb.edit.ldap.users.php?servername={$ligne["servername"]}');\"\n\t\tstyle='font-size:14px;font-weight:bold;color:{$color_orange};text-decoration:underline;font-style:italic'>{$members_text}</a>\n\t\t »</span>";
}
$memory = "-";
$requests_second = "-";
$traffic_second = "-";
$uptime = null;
$table_name_stats = "apache_stats_" . date('Ym');
$sql = "SELECT * FROM {$table_name_stats} WHERE servername='{$ligne["servername"]}' ORDER by zDate DESC LIMIT 0,1";
$ligneStats = mysql_fetch_array($q->QUERY_SQL($sql, "artica_events"));
if ($ligneStats["total_memory"] > 0) {
$memory = FormatBytes($ligneStats["total_memory"] / 1024);
$requests_second = "{$ligneStats["requests_second"]}/s";
$traffic_second = FormatBytes($ligneStats["traffic_second"] / 1024) . "/s";
$uptime = div_groupware("{uptime}:{$ligneStats["UPTIME"]}", $ligne["enabled"]);
}
$groupware = $tpl->_ENGINE_parse_body($groupware);
$forward_text = $tpl->_ENGINE_parse_body($forward_text);
$servername_text = $tpl->_ENGINE_parse_body($servername_text);
$ServerAlias = $tpl->_ENGINE_parse_body($ServerAlias);
$uptime = $tpl->_ENGINE_parse_body($uptime);
$memory = $tpl->_ENGINE_parse_body($memory);
$requests_second = $tpl->_ENGINE_parse_body("{$requests_second}");
$traffic_second = $tpl->_ENGINE_parse_body($traffic_second);
$checkResolv = $tpl->_ENGINE_parse_body($checkResolv);
$checkDNS = $tpl->_ENGINE_parse_body($checkDNS);
$checkMember = $tpl->_ENGINE_parse_body($checkMember);
$delete = $tpl->_ENGINE_parse_body($delete);
if ($WebCopyID > 0) {
$ligne2 = mysql_fetch_array($q->QUERY_SQL("SELECT sitename FROM httrack_sites WHERE ID={$WebCopyID}", "artica_backup"));
$groupware = div_groupware("WebCopy: {$ligne2["sitename"]}", $ligne["enabled"]);
}
if ($ligne["groupware"] == "UPDATEUTILITY") {
$iconPlus = "<a href=\"javascript:blur();\" OnClick=\"javascript:Loadjs('UpdateUtility.php?js=yes');\"><img src='img/settings-15.png' align='left'></a>";
}
$color_span = "#5F5656";
if ($ligne["enabled"] == 0) {
$color_span = "#8C8C8C";
}
$compile = imgsimple("refresh-32.png", null, "FreeWebsRebuildvHostsTable('{$ligne["servername"]}')");
$enable = Field_checkbox("enable_{$md5S}", 1, $ligne["enabled"], "FreeWebsEnableSite('{$ligne["servername"]}')");
if ($ligne["enabled"] == 0) {
$requests_second = "-";
$traffic_second = "-";
$memory = "-";
$color = "#8C8C8C";
$color_span = $color;
$icon = "status_disabled.gif";
$compile = " ";
}
$jsedit = $boot->trswitch($js_edit);
$tr[] = "\n\t\t\t\t<tr style='color:{$color}' id='row{$md5S}'>\n\t\t\t\t\t<td width=1% nowrap {$jsedit}><img src='img/{$icon}'></td>\n\t\t\t\t\t<td width=80% {$jsedit}><span style='font-size:18px;font-weight:bold'>{$servername_text}</span>{$iconPlus}{$groupware}{$forward_text}{$added_port}{$Members}{$sizevg}{$ServerAlias}{$uptime}{$error_text}</td>\n\t\t\t\t\t<td width=1% nowrap>{$compile}</td>\n\t\t\t\t\t<td width=1% nowrap>{$enable}</td>\n\t\t\t\t\t<td width=1% nowrap>{$DirectorySize}</td>\n\t\t\t\t\t<td width=1% nowrap>{$memory}</td>\n\t\t\t\t\t<td width=1% nowrap>{$requests_second} | {$traffic_second}</td>\t\t\t\t\n\t\t\t\t\t<td width=1% nowrap><img src='img/{$ssl}'></td>\n\t\t\t\t\t<td width=1% nowrap>{$delete}</td>\n\t\t\t\t</tr>\n\t\t\t\t";
}
$t = time();
$freeweb_compile_background = $tpl->javascript_parse_text("{freeweb_compile_background}");
$reset_admin_password = $tpl->javascript_parse_text("{reset_admin_password}");
$delete_freeweb_text = $tpl->javascript_parse_text("{delete_freeweb_text}");
$delete_freeweb_dnstext = $tpl->javascript_parse_text("{delete_freeweb_dnstext}");
echo $tpl->_ENGINE_parse_body("\n\t\n\t\t<table class='table table-bordered table-hover'>\n\t\n\t\t\t<thead>\n\t\t\t\t<tr>\n\t\t\t\t\t<th colspan=2>{website}</th>\n\t\t\t\t\t<th> </th>\n\t\t\t\t\t<th>{enable}</th>\n\t\t\t\t\t<th>{size}</th>\n\t\t\t\t\t<th>{memory}</th>\n\t\t\t\t\t<th>Rq/s</th>\n\t\t\t\t\t<th>SSL</th>\n\t\t\t\t\t<th> </th>\n\t\t\t\t</tr>\n\t\t\t</thead>\n\t\t\t <tbody>") . @implode("", $tr) . "</tbody></table>\n<script>\nvar FreeWebIDMEM{$t}='';\n\n\tfunction HelpSection(){\n\t\tLoadHelp('freewebs_explain','',false);\n\t}\n\n\tfunction AddNewFreeWebServer(){\n\t\t Loadjs('freeweb.edit.php?hostname=&force-groupware={$_GET["force-groupware"]}&t={$t}')\n\t}\n\t\n\tfunction AddNewFreeWebServerZarafa(){\n\t\tYahooWin('650','freeweb.servers.php?freeweb-zarafa-choose=yes&t={$t}','{$choose_your_zarafa_webserver_type}');\n\t}\n\t\n\t\n\tfunction ApacheAllstatus(){\n\t\tLoadjs('freeweb.status.php');\n\t}\n\t\n\t\n\tfunction FreeWebWebDavPerUsers(){\n\t\tLoadjs('freeweb.webdavusr.php?t={$t}')\n\t}\n\t\n\tfunction RestoreSite(){\n\t\tLoadjs('freeweb.restoresite.php?t={$t}')\n\t}\n\t\n\tfunction FreeWebsRefreshWebServersList(){\n\t\tExecuteByClassName('SearchFunction');\n\t}\n\t\n\t\n\tvar x_EmptyEvents= function (obj) {\n\t\tvar results=obj.responseText;\n\t\tif(results.length>3){alert(results);return;}\n\t\tExecuteByClassName('SearchFunction');\n\n\t\t\n\t}\t\n\t\n\tvar x_FreeWebsRebuildvHostsTable= function (obj) {\n\t\tvar results=obj.responseText;\n\t\tif(results.length>3){alert(results);return;}\n\t\talert('{$freeweb_compile_background}');\n\t\tExecuteByClassName('SearchFunction');\n\t\t}\n\n\t\n\tvar x_klmsresetwebpassword{$t}= function (obj) {\n\t\tvar results=obj.responseText;\n\t\tif(results.length>3){alert(results);return;}\n\t\tExecuteByClassName('SearchFunction');\n\t}\t\n\t\n\tvar x_FreeWebDelete=function (obj) {\n\t\t\tvar results=obj.responseText;\n\t\t\tif(results.length>10){alert(results);return;}\t\n\t\t\t\$('#row'+FreeWebIDMEM{$t}).remove();\n\t\t\tif(document.getElementById('container-www-tabs')){\tRefreshTab('container-www-tabs');}\n\t\t}\t\n\t\t\n\t\tfunction FreeWebDelete(server,dns,md){\n\t\t\tFreeWebIDMEM{$t}=md;\n\t\t\tif(confirm('{$delete_freeweb_text}')){\n\t\t\t\tvar XHR = new XHRConnection();\n\t\t\t\tif(dns==1){if(confirm('{$delete_freeweb_dnstext}')){XHR.appendData('delete-dns',1);}else{XHR.appendData('delete-dns',0);}}\n\t\t\t\tXHR.appendData('delete-servername',server);\n \t\t\tXHR.sendAndLoad('freeweb.php', 'GET',x_FreeWebDelete);\n\t\t\t}\n\t\t}\n\n\tvar x_FreeWebRefresh=function (obj) {\n\t\t\tvar results=obj.responseText;\n\t\t\tif(results.length>10){alert(results);return;}\t\n\t\t\tExecuteByClassName('SearchFunction');\n\t\t}\t\t\n\t\t\n\t\tfunction FreeWebAddDefaultVirtualHost(){\n\t\t\tvar XHR = new XHRConnection();\n\t\t\tXHR.appendData('AddDefaultOne','yes');\n \t\tXHR.sendAndLoad('freeweb.php', 'POST',x_FreeWebRefresh);\t\t\n\t\t}\n\t\t\n\t\tfunction FreeWeCheckVirtualHost(){\n\t\t\tvar XHR = new XHRConnection();\n\t\t\tXHR.appendData('CheckAVailable','yes');\n \t\tXHR.sendAndLoad('freeweb.php', 'POST',x_FreeWebDelete);\t\t\t\n\t\t}\n\t\t\n\t\tvar x_RebuildFreeweb{$t}=function (obj) {\n\t\t\tvar results=obj.responseText;\n\t\t\tif(results.length>0){alert(results);}\t\t\t\n\t\t\tExecuteByClassName('SearchFunction');\n\t\t}\t\t\t\n\t\t\n\t\tfunction RebuildFreeweb(){\n\t\t\tvar XHR = new XHRConnection();\n\t\t\tXHR.appendData('rebuild-items','yes');\n \t\tXHR.sendAndLoad('freeweb.php', 'GET',x_RebuildFreeweb{$t});\n\t\t\n\t\t}\n\n\t\tfunction klmsresetwebpassword(){\n\t\t if(confirm('{$reset_admin_password} ?')){\n\t\t\t\tvar XHR = new XHRConnection();\n\t\t\t\tXHR.appendData('klms-reset-password','yes');\n \t\t\tXHR.sendAndLoad('klms.php', 'POST',x_klmsresetwebpassword{$t});\n \t\t}\t\t\n\t\t}\n\t\t\n\tfunction FreeWebsRebuildvHostsTable(servername){\n\t\tvar XHR = new XHRConnection();\n\t\tXHR.appendData('FreeWebsRebuildvHosts',servername);\n\t\tXHR.sendAndLoad('freeweb.edit.php', 'POST',x_FreeWebsRebuildvHostsTable);\n\t}\n\n</script>\t\t\t \t\t\t\t\t \t\t\t\t \t\t\n";
}
