function listwebs_search(){ include_once(dirname(__FILE__).'/ressources/class.apache.inc'); $vhosts=new vhosts(); $search=$_GET["search"]; $page=CurrentPageName(); $users=new usersMenus(); $where=null; 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) OR (domainname LIKE '$search' $whereOU)"; } $tpl=new templates(); $sock=new sockets(); $delete_freeweb_text=$tpl->javascript_parse_text("{delete_freeweb_text}"); $sql="SELECT * FROM freeweb WHERE 1 $whereOU ORDER BY servername"; $q=new mysql(); if(!isset($_SESSION["CheckTableWebsites"])){$q->BuildTables();$_SESSION["CheckTableWebsites"]=true;} $results=$q->QUERY_SQL($sql,'artica_backup'); if(!$q->ok){echo "<H2>$q->mysql_error</H2><code>$sql</code>";} $vgservices=unserialize(base64_decode($sock->GET_INFO("vgservices"))); $html=" <table cellspacing='0' cellpadding='0' border='0' class='tableView' style='width:100%'> <thead class='thead'> <tr> <th colspan=2>{joomlaservername}:$ou</th> <th>{ssl}</th> <th> </th> <th> </th> <th>{member}</th> <th> </th> </tr> </thead> <tbody class='tbody'>"; while($ligne=mysql_fetch_array($results,MYSQL_ASSOC)){ if($classtr=="oddRow"){$classtr=null;}else{$classtr="oddRow";} if($ligne["useSSL"]==1){$ssl="check2.gif";}else{$ssl="check1.gif";} $statistics=" "; $exec_statistics=" "; $groupware=null; $forward_text=null; $added_port=null; $icon="free-web-32.png"; $aw=new awstats($ligne["servername"]); if($aw->getCountDePages()>0){ $statistics= imgtootltip("status_statistics-22.png","{statistics}","Loadjs('awstats.view.php?servername={$ligne["servername"]}')"); } if($aw->GET("AwstatsEnabled")){ $exec_statistics=imgtootltip("22-recycle.png","{build_awstats_statistics}","Loadjs('awstats.php?servername={$ligne["servername"]}&execute=yes')"); } 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["UseReverseProxy"]){$icon="Firewall-Move-Right-32.png";} if($ligne["groupware"]<>null){ $groupware="<span style='text-align:right;font-size:11px;font-weight:bold;font-style:italic;color:#B64B13;float:right'> ({{$vhosts->TEXT_ARRAY[$ligne["groupware"]]["TITLE"]}})</span>"; } if($ligne["Forwarder"]==1){$forward_text="<span style='text-align:right;font-size:11px;font-weight:bold;font-style:italic;color:#B64B13;float:right'>{www_forward} <b>{$ligne["ForwardTo"]}</b></span>";} $edit=imgtootltip($icon,"{$ligne["resolved_ipaddr"]}<br>{edit}","Loadjs('freeweb.edit.php?hostname={$ligne["servername"]}')"); $servername_text=$ligne["servername"]; if($servername_text=="_default_"){ $servername_text="{all}"; $groupware="<span style='text-align:right;font-size:11px;font-weight:bold;font-style:italic;color:#B64B13;float:right'> ({default_website})</span><br>"; }else{ if(trim($ligne["resolved_ipaddr"])==null){ $edit=imgtootltip("warning-panneau-32.png","{could_not_find_iphost}<br>{click_to_edit}","Loadjs('freeweb.edit.php?hostname={$ligne["servername"]}')"); } } $href="<a href=\"javascript:blur();\" OnClick=\"javascript:Loadjs('freeweb.edit.php?hostname={$ligne["servername"]}')\" style='font-size:13px;text-decoration:underline;font-weight:bold'>"; $html=$html." <tr class=$classtr> <td width=1%>$edit</td> <td nowrap>$groupware$forward_text<span style='float:left'><strong style='font-size:13px'>$href$servername_text</a>$added_port$sizevg</strong></span></td> <td width=1%><img src='img/$ssl'></td> <td width=1%>$statistics</td> <td width=1%>$exec_statistics</td> <td nowrap><strong style='font-size:13px'>{$ligne["uid"]}$ipDetect</strong></td> <td width=1%>". imgtootltip("delete-24.png","{delete}","FreeWebDelete('{$ligne["servername"]}')")."</td> </tr> "; } $html=$html." </tbody> </table> <div style='text-align:right;margin-top:8px'>". button("{recheck_net_items}","FreeWeCheckVirtualHost()")." | ". button("{add_default_www}","FreeWebAddDefaultVirtualHost()")."</div> <script> var x_FreeWebDelete=function (obj) { var results=obj.responseText; if(results.length>10){alert(results);} if(document.getElementById('main_config_freeweb')){ RefreshTab('main_config_freeweb');} if(document.getElementById('container-www-tabs')){ RefreshTab('container-www-tabs');} } function FreeWebDelete(server){ if(confirm('$delete_freeweb_text')){ var XHR = new XHRConnection(); XHR.appendData('delete-servername',server); AnimateDiv('freewebs_list'); XHR.sendAndLoad('$page', 'GET',x_FreeWebDelete); } } function FreeWebAddDefaultVirtualHost(){ var XHR = new XHRConnection(); XHR.appendData('AddDefaultOne','yes'); AnimateDiv('freewebs_list'); XHR.sendAndLoad('$page', 'POST',x_FreeWebDelete); } function FreeWeCheckVirtualHost(){ var XHR = new XHRConnection(); XHR.appendData('CheckAVailable','yes'); AnimateDiv('freewebs_list'); XHR.sendAndLoad('$page', 'POST',x_FreeWebDelete); } </script> "; echo $tpl->_ENGINE_parse_body($html); }
function listwebs_search() { include_once dirname(__FILE__) . '/ressources/class.apache.inc'; $vhosts = new vhosts(); $search = $_GET["search"]; $page = CurrentPageName(); $users = new usersMenus(); $DNS_INSTALLED = false; $where = null; $query_groupware = null; $addg = imgtootltip("plus-24.png", "{add} {joomlaservername}", "Loadjs('freeweb.edit.php?hostname=&force-groupware={$_GET["force-groupware"]}')"); 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}))"; $addg = " "; } 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; } if (strlen($search) < 2) { $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 = "<span style='text-align:right;font-size:11px;font-weight:bold;font-style:italic;color:#B64B13;float:right'> WebDav</span>"; $href = "<a href=\"javascript:blur();\" OnClick=\"javascript:Loadjs('freeweb.webdavusr.php')\" style='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"; } $WebdavTR = "\n\t\t\t<tr class={$classtr}>\n\t\t\t<td width=1%>{$edit}</td>\n\t\t\t<td nowrap style='color:{$color}'><span style='float:left'>\n\t\t\t<strong style='font-size:13px;style='color:{$color}'>{$href}*.{$WebDavPerUserSets["WebDavSuffix"]}</a></strong></span>\n\t\t\t</td>\n\t\t\t\n\t\t\t<td width=1% style='font-size:11px;font-weight:bold;color:#5F5656;'> </td>\n\t\t\t<td width=1% style='font-size:11px;font-weight:bold;color:#5F5656;'> </td>\n\t\t\t<td width=1%><img src='img/{$ssl}'></td>\n\t\t\t<td width=1% align='center'> </td>\n\t\t\t<td width=1% align='center'> </td>\n\t\t\t<td width=1% align='center'> </td>\n\t\t\t<td width=1% align='center'> </td>\n\t\t\t<td width=1% align='center'> </td>\n\t\t\t<td width=1%> </td>\n\t\t\t</tr>\n\t\t\t"; } } $tpl = new templates(); $sock = new sockets(); $delete_freeweb_text = $tpl->javascript_parse_text("{delete_freeweb_text}"); $delete_freeweb_dnstext = $tpl->javascript_parse_text("{delete_freeweb_dnstext}"); $sql = "SELECT * FROM freeweb WHERE 1 {$whereOU}{$query_groupware_single} ORDER BY servername"; $q = new mysql(); if (!isset($_SESSION["CheckTableWebsites"])) { $q->BuildTables(); $_SESSION["CheckTableWebsites"] = true; } $results = $q->QUERY_SQL($sql, 'artica_backup'); if (!$q->ok) { echo "<H2>{$q->mysql_error}</H2><code>{$sql}</code>"; } $vgservices = unserialize(base64_decode($sock->GET_INFO("vgservices"))); $html = "\n<table cellspacing='0' cellpadding='0' border='0' class='tableView' style='width:100%'>\n<thead class='thead'>\n\t<tr>\n\t<th width=1%>{$addg}</th>\n\t<th>{joomlaservername}:{$ou}</th>\n\t<th>{memory}</th>\n\t<th>{requests}</th>\n\t<th>SSL</th>\n\t<th>RESOLV</th>\n\t<th>DNS</th>\n\t<th>{member}</th>\n\t<th> </th>\n\t<th> </th>\n\t\n\t<th> </th>\n\t</tr>\n</thead>\n<tbody class='tbody'>{$WebdavTR}"; $pdns = new pdns(); while ($ligne = mysql_fetch_array($results, MYSQL_ASSOC)) { if ($classtr == "oddRow") { $classtr = null; } else { $classtr = "oddRow"; } if ($ligne["useSSL"] == 1) { $ssl = "20-check.png"; } else { $ssl = "none-20.png"; } $statistics = " "; $exec_statistics = " "; $groupware = null; $forward_text = null; $checkDNS = " "; $checkMember = " "; $JSDNS = 0; if ($DNS_INSTALLED) { $ip = $pdns->GetIpDN($ligne["servername"]); if ($ip != null) { $checkDNS = imgtootltip("20-check.png", "<span style=font-size:16px>{$ligne["servername"]}<hr>{dns}: {$ip}</span>"); $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 = "<hr style='border: 1px'><div style='font-size:11px'><a href=\"javascript:blur();\" OnClick=\"javascript:Loadjs('freeweb.edit.ServerAlias.php?servername={$ligne["servername"]}')\" style='text-decoration:underline'><i>" . @implode(", ", $f) . "</i></div>"; } if ($ligne["uid"] != null) { $checkMember = imgtootltip("20-check.png", "<span style=font-size:16px>{$ligne["servername"]}<hr>{member}: {$ligne["uid"]}</span>"); } $added_port = null; $icon = "free-web-32.png"; $aw = new awstats($ligne["servername"]); if ($aw->getCountDePages() > 0) { $statistics = imgtootltip("status_statistics-22.png", "{statistics}", "Loadjs('awstats.view.php?servername={$ligne["servername"]}')"); } if ($aw->GET("AwstatsEnabled")) { $exec_statistics = imgtootltip("22-recycle.png", "{build_awstats_statistics}", "Loadjs('awstats.php?servername={$ligne["servername"]}&execute=yes')"); } 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["UseReverseProxy"]) { $icon = "Firewall-Move-Right-32.png"; } if ($ligne["groupware"] != null) { $groupware = "<span style='text-align:right;font-size:11px;font-weight:bold;font-style:italic;color:#B64B13;float:right'> ({{$vhosts->TEXT_ARRAY[$ligne["groupware"]]["TITLE"]}})</span>"; } if ($ligne["Forwarder"] == 1) { $forward_text = "<span style='text-align:right;font-size:11px;font-weight:bold;font-style:italic;color:#B64B13;float:right'>{www_forward} <b>{$ligne["ForwardTo"]}</b></span>"; } $edit = imgtootltip($icon, "{$ligne["resolved_ipaddr"]}<br>{apply}", "Loadjs('freeweb.edit.php?hostname={$ligne["servername"]}')"); $servername_text = $ligne["servername"]; if ($servername_text == "_default_") { $servername_text = "{all}"; $groupware = "<span style='text-align:right;font-size:11px;font-weight:bold;font-style:italic;color:#B64B13;float:right'> ({default_website})</span><br>"; } else { $checkResolv = imgtootltip("20-check.png", "<span style=font-size:16px>{$ligne["servername"]}<hr>{dns}: {$ligne["resolved_ipaddr"]}</span>"); if (trim($ligne["resolved_ipaddr"]) == null) { $edit = imgtootltip("warning-panneau-32.png", "{could_not_find_iphost}<br>{click_to_edit}", "Loadjs('freeweb.edit.php?hostname={$ligne["servername"]}')"); $checkResolv = " "; } } $href = "<a href=\"javascript:blur();\" OnClick=\"javascript:Loadjs('freeweb.edit.php?hostname={$ligne["servername"]}')\"\n\t\tstyle='font-size:13px;text-decoration:underline;font-weight:bold'>"; $color = "black"; $delete = imgtootltip("delete-24.png", "{delete}", "FreeWebDelete('{$ligne["servername"]}',{$JSDNS})"); $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 = imgtootltip("folder-tasks-32.png", "{installing}", "Loadjs('freeweb.edit.php?hostname={$ligne["servername"]}')"); $color = "#8a8a8a"; $delete = imgtootltip("delete-32-grey.png", "{installing}"); $groupware = "<span style='text-align:right;font-size:11px;font-weight:bold;font-style:italic;color:#B64B13;float:right'> ({installing} {{$vhosts->TEXT_ARRAY[$ligne["groupware"]]["TITLE"]}})</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 = "<hr style='border:0px'><div style='text-align:left;font-size:11px;font-style:italic;color:#5F5656;float:clear'>{uptime}:{$ligneStats["UPTIME"]}</div>"; } $html = $html . "\n\t\t\t<tr class={$classtr}>\n\t\t\t<td width=1%>{$edit}</td>\n\t\t\t<td nowrap style='color:{$color}'>{$groupware}{$forward_text}<span style='float:left'>\n\t\t\t<strong style='font-size:13px;style='color:{$color}'>{$href}{$servername_text}</a>{$added_port}{$sizevg}</strong></span>{$ServerAlias}\n\t\t\t{$uptime}\n\t\t\t</td>\n\t\t\t\n\t\t\t<td width=1% style='font-size:11px;font-weight:bold;color:#5F5656;'>{$memory}</td>\n\t\t\t<td width=1% style='font-size:11px;font-weight:bold;color:#5F5656;'>{$requests_second} | {$traffic_second}</td>\n\t\t\t<td width=1%><img src='img/{$ssl}'></td>\n\t\t\t<td width=1% align='center'>{$checkResolv}</td>\n\t\t\t<td width=1% align='center'>{$checkDNS}</td>\n\t\t\t<td width=1% align='center'>{$checkMember}</td>\n\t\t\t<td width=1% align='center'>{$statistics}</td>\n\t\t\t<td width=1% align='center'>{$exec_statistics}</td>\n\t\t\t<td width=1%>{$delete}</td>\n\t\t\t</tr>\n\t\t\t"; } $default_www = " | " . button("{add_default_www}", "FreeWebAddDefaultVirtualHost()"); if ($_GET["force-groupware"] != null) { $default_www = null; } $html = $html . "\n\t</tbody>\n\t</table>\n\t<div style='text-align:right;margin-top:8px'>" . button("{recheck_net_items}", "FreeWeCheckVirtualHost()") . "{$default_www}</div>\n\t<script>\n\tvar x_FreeWebDelete=function (obj) {\n\t\t\tvar results=obj.responseText;\n\t\t\tif(results.length>10){alert(results);}\t\n\t\t\tif(document.getElementById('main_config_freeweb')){\tRefreshTab('main_config_freeweb');}\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){\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\t\tAnimateDiv('freewebs_list');\n \t\t\tXHR.sendAndLoad('{$page}', 'GET',x_FreeWebDelete);\n\t\t\t}\n\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\t\tAnimateDiv('freewebs_list');\n \t\tXHR.sendAndLoad('{$page}', 'POST',x_FreeWebDelete);\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\t\tAnimateDiv('freewebs_list');\n \t\tXHR.sendAndLoad('{$page}', 'POST',x_FreeWebDelete);\t\t\t\n\t\t}\n\t\t\n\t</script>\t\n\t\n\t"; echo $tpl->_ENGINE_parse_body($html); }