function section_websites_search() { $boot = new boostrap_form(); $tpl = new templates(); $q = new mysql_squid_builder(); $page = CurrentPageName(); $table = "visited_sites_tot"; $searchstring = string_to_flexquery("sites-search"); $ORDER = $boot->TableOrder(array("size" => "ASC")); if ($q->COUNT_ROWS($table) == 0) { senderrors("no data"); } $sql = "SELECT * FROM {$table} WHERE 1 {$searchstring} ORDER BY {$ORDER} LIMIT 0,250"; $results = $q->QUERY_SQL($sql); if (!$q->ok) { senderrors($q->mysql_error . "<br>{$sql}"); } while ($ligne = mysql_fetch_assoc($results)) { $md = md5(serialize($ligne)); $ligne["size"] = FormatBytes($ligne["size"] / 1024); $sitenameenc = urlencode($ligne["familysite"]); $js = "Loadjs('miniadm.webstats.familysite.all.php?familysite={$sitenameenc}')"; $link = $boot->trswitch($js); $tr[] = "\n\t\t<tr id='{$md}'>\n\t\t\t<td style='font-size:16px' width=10% nowrap {$link}>{$ligne["familysite"]}</td>\n\t\t\t<td style='font-size:16px' width=1% nowrap {$link}>{$ligne["hits"]}</td>\n\t\t\t<td style='font-size:16px' width=1% nowrap {$link}>{$ligne["size"]}</td>\n\t\t</tr>\n\t\t"; } echo $boot->TableCompile(array("familysite" => "{familysite}", "hits" => "{hits}", "size" => "{size}"), $tr); }
function bridge_search() { $boot = new boostrap_form(); $page = CurrentPageName(); $tpl = new templates(); $sock = new sockets(); $q = new mysql(); $table = "iptables_bridge"; $database = "artica_backup"; $t = time(); $ORDER = $boot->TableOrder(array("ID" => "DESC")); $sock = new sockets(); $net = new networking(); $ip = new IP(); $interfaces = unserialize(base64_decode($sock->getFrameWork("cmd.php?ifconfig-interfaces=yes"))); $searchstring = string_to_flexquery("search-bridge"); $sql = "SELECT * FROM {$table} WHERE 1 {$searchstring} ORDER BY {$ORDER} LIMIT 0,250"; $results = $q->QUERY_SQL($sql, $database); if (!$q->ok) { senderrors($q->mysql_error . "<br>{$sql}"); } $net = new networking(); while ($ligne = mysql_fetch_assoc($results)) { $md = md5(serialize($ligne)); $ip = new IP(); $img = "folder-network-48.png"; $cdir = $ligne["cdir"]; $eth = "br{$ligne["ID"]}"; $eth_text = "br{$ligne["ID"]}"; $array = $net->GetNicInfos($ligne["nic_inbound"]); $nic_inbound_ip = $array["IPADDR"]; $array = $net->GetNicInfos($ligne["nic_linked"]); $nic_linked_ip = $array["IPADDR"]; $delete = imgsimple("delete-48.png", "{delete}", "Delete{$t}('{$ligne["ID"]}','{$md}')"); $tr[] = "\n\t\t<tr id='{$md}'>\n\t\t\t<td style='font-size:18px' width=1% nowrap><img src='img/{$img}'></td>\n\t\t\t<td style='font-size:18px' width=1% nowrap>{$ligne["nic_inbound"]} - {$nic_inbound_ip}</td>\n\t\t\t<td style='font-size:18px' width=10% nowrap>{$ligne["nic_linked"]} - {$nic_linked_ip}</td>\n\t\t\t<td style='font-size:18px' width=1% nowrap>{$delete}</td>\n\t\t</tr>\n\t\t"; } $delete_text = $tpl->javascript_parse_text("{delete_nic_bridge}"); echo $boot->TableCompile(array("ID" => "ID", "nic_inbound" => "{from}", "nic_linked" => "{to}", "delete" => null), $tr) . "\n\t\t\t\t\t\n<script>\nvar mem{$t}='';\nvar xDelete{$t}=function(obj){\n\tvar tempvalue=obj.responseText;\n\tif(tempvalue.length>3){alert(tempvalue);return;}\n\t\$('#'+mem{$t}).remove();\n}\nfunction Delete{$t}(ID,mem){\n\tmem{$t}=mem;\n\tif(confirm('{$delete_text} ID: '+ID+'?')){\n\t\tmem{$t}=mem;\n\t\tvar XHR = new XHRConnection();\n\t\tXHR.appendData('bridge-delete',ID);\n\t\tXHR.sendAndLoad('{$page}', 'POST',xDelete{$t});\n\t\t}\n\t}\n</script>\t\t\t\t\t\n"; }
function section_websites_search() { $boot = new boostrap_form(); $tpl = new templates(); $q = new mysql_squid_builder(); $page = CurrentPageName(); $current_month = date("Ym", $_GET["xtime"]); $table = "{$current_month}_catfam"; $searchstring = string_to_flexquery("sites-search"); $ORDER = $boot->TableOrder(array("size" => "DESC")); if (!$q->TABLE_EXISTS($table)) { senderrors("no such table"); } if ($q->COUNT_ROWS($table) == 0) { senderrors("no data"); } //zDate | client | uid | hostname | MAC | familysite | catfam | hits | size $table = "( SELECT familysite,catfam,SUM(size) as size,SUM(hits) as hits FROM `{$table}` GROUP BY familysite HAVING catfam='{$_GET["catfam"]}') as t"; $sql = "SELECT * FROM {$table} WHERE 1 {$searchstring} ORDER BY {$ORDER} LIMIT 0,250"; $results = $q->QUERY_SQL($sql); if (!$q->ok) { senderrors($q->mysql_error . "<br>{$sql}"); } while ($ligne = mysql_fetch_assoc($results)) { $md = md5(serialize($ligne)); $ligne["size"] = FormatBytes($ligne["size"] / 1024); $sitenameenc = urlencode($ligne["familysite"]); $js = "Loadjs('miniadm.webstats.familysite.all.php?familysite={$sitenameenc}')"; $link = $boot->trswitch($js); $tr[] = "\n\t\t<tr id='{$md}'>\n\t\t\t<td style='font-size:16px' width=10% nowrap {$link}>{$ligne["familysite"]}</td>\n\t\t\t<td style='font-size:16px' width=1% nowrap {$link}>{$ligne["hits"]}</td>\n\t\t\t<td style='font-size:16px' width=1% nowrap {$link}>{$ligne["size"]}</td>\n\t\t</tr>\n\t\t"; } echo $boot->TableCompile(array("familysite" => "{familysite}", "hits" => "{hits}", "size" => "{size}"), $tr); }
function search() { $page = CurrentPageName(); $boot = new boostrap_form(); $tpl = new templates(); $searchstring = string_to_flexquery("search"); $ORDER = $boot->TableOrder(array("subject" => "ASC")); $limitSql = "LIMIT 0,250"; $sql = "SELECT * FROM reverse_pages_content WHERE 1 {$searchstring} ORDER BY {$ORDER} {$limitSql}"; $q = new mysql_squid_builder(); $results = $q->QUERY_SQL($sql); if (!$q->ok) { echo $q->mysql_error_html(); } while ($ligne = mysql_fetch_assoc($results)) { $ID = $ligne["ID"]; $jsselect = null; $select = null; $js = $boot->trswitch("Loadjs('miniadmin.crm.pages.php?ID={$ID}')"); if ($_GET["field-id"] != null) { $select = "Loadjs('{$page}?select-js=yes&ID={$ID}&field-id={$_GET["field-id"]}')"; $jsselect = $boot->trswitch($select); $select_img = imgsimple("arrow-right-24.png", null, $select); } $delete_img = imgsimple("delete-24.png", null, "Loadjs('{$page}?delete-js=yes&ID={$ID}')"); $tr[] = "\n\t<tr id='{$ligne["ID"]}'>\n\t<td width='99%' nowrap {$js}><i class='icon-tags'></i> {$ligne["subject"]}</a></td>\n\t<td width='45px' nowrap style='vertical-align:middle;text-align:center'>{$select_img}</td>\n\t<td width='45px' nowrap style='vertical-align:middle;text-align:center'>{$delete_img}</td>\n\t</tr>"; } $html = $boot->TableCompile(array("subject" => "{subject}", "ID" => "select", "delete" => "{delete}"), $tr); echo $tpl->_ENGINE_parse_body($html); }
function topmembers_table_search() { $tpl = new templates(); $MyPage = CurrentPageName(); $boot = new boostrap_form(); $q = new mysql_squid_builder(); $sock = new sockets(); $fontsize = "14px"; $page = 1; $t = time(); $ORDER = $boot->TableOrder(array("size" => "DESC")); $searchstring = string_to_flexquery("topmembers-search"); $year = $_GET["year"]; $month = $_GET["month"]; $familysite = mysql_escape_string2($_GET["familysite"]); $table = "quotamonth_{$year}{$month}"; $table = "(SELECT `uid`,familysite,SUM(size) as `size` FROM {$table} GROUP BY `uid`,familysite \n\tHAVING familysite='{$familysite}' ORDER BY `size` DESC LIMIT 0,50) as t"; $size_text = $tpl->_ENGINE_parse_body("{size}"); $members_text = $tpl->_ENGINE_parse_body("{members}"); $websites_text = $tpl->_ENGINE_parse_body("{websites}"); $sql = "SELECT * FROM {$table} WHERE 1 {$searchstring} ORDER BY {$ORDER} LIMIT 0,20"; $results = $q->QUERY_SQL($sql); if (!$q->ok) { echo $q->mysql_error_html(); } $suffix = suffix(); while ($ligne = mysql_fetch_array($results, MYSQL_ASSOC)) { $color = "black"; $size = FormatBytes($ligne["size"] / 1024); $websiteenc = urlencode($ligne["familysite"]); $js = $boot->trswitch("Loadjs('miniadm.webstats.popup.ByMonthByUserByFamilysite.php?uid={$ligne["uid"]}{$suffix}')"); $tr[] = "\n\t\t<tr>\n\t\t<td style='font-size:18px;color:{$color}' nowrap width=99% nowrap {$js}>{$ligne["uid"]}</td>\n\t\t<td style='font-size:18px;color:{$color}' nowrap width=1% nowrap {$js}>{$size}</td>\n\t\t</tr>"; } echo $boot->TableCompile(array("uid" => "{$members_text}", "size" => "{$size_text}"), $tr); }
function etchosts_search() { $boot = new boostrap_form(); $page = CurrentPageName(); $tpl = new templates(); $sock = new sockets(); $q = new mysql(); $table = "net_hosts"; $database = "artica_backup"; $t = time(); if ($q->COUNT_ROWS($table, $database) == 0) { $sock->getFrameWork("system.php?etchosts-default=yes"); } $ORDER = $boot->TableOrder(array("hostname" => "ASC")); $sock = new sockets(); $net = new networking(); $ip = new IP(); $interfaces = unserialize(base64_decode($sock->getFrameWork("cmd.php?ifconfig-interfaces=yes"))); $searchstring = string_to_flexquery("search-etchosts"); $sql = "SELECT * FROM {$table} WHERE 1 {$searchstring} ORDER BY {$ORDER} LIMIT 0,250"; $results = $q->QUERY_SQL($sql, $database); if (!$q->ok) { senderrors($q->mysql_error . "<br>{$sql}"); } $net = new networking(); while ($ligne = mysql_fetch_assoc($results)) { $md = md5(serialize($ligne)); $delete = imgsimple("delete-48.png", "{delete}", "Delete{$t}('{$ligne["zmd5"]}','{$md}','{$ligne["hostname"]}@{$ligne["ipaddr"]}')"); $tr[] = "\n\t\t<tr id='{$md}'>\n\t\t\t<td style='font-size:20px' width=90% nowrap >{$ligne["hostname"]}</td>\n\t\t\t<td style='font-size:20px' width=5% nowrap >{$ligne["ipaddr"]}</td>\n\t\t\t<td style='font-size:20px' width=5% nowrap >{$ligne["alias"]}</td>\n\t\t\t<td style='font-size:20px' width=1% nowrap>{$delete}</td>\n\t\t</tr>\n\t\t"; } $delete_text = $tpl->javascript_parse_text("{delete_nic_etchosts}"); echo $boot->TableCompile(array("hostname" => "{hostname}", "ipaddr" => "{ipaddr}", "alias" => "{alias}", "delete" => null), $tr) . "\n\t\t\t\t\t\n<script>\nvar mem{$t}='';\nvar xDelete{$t}=function(obj){\n\tvar tempvalue=obj.responseText;\n\tif(tempvalue.length>3){alert(tempvalue);return;}\n\t\$('#'+mem{$t}).remove();\n}\nfunction Delete{$t}(md5,mem,ipaddr){\n\tmem{$t}=mem;\n\tif(confirm('{$delete_text}: '+ipaddr+'?')){\n\t\tmem{$t}=mem;\n\t\tvar XHR = new XHRConnection();\n\t\tXHR.appendData('etchosts-delete',md5);\n\t\tXHR.sendAndLoad('{$page}', 'POST',xDelete{$t});\n\t\t}\n\t}\n</script>\t\t\t\t\t\n"; }
function events_rotate_table() { $q = new mysql_storelogs(); $boot = new boostrap_form(); $table = "evnts"; $rows = $q->COUNT_ROWS($table); if ($rows == 0) { senderror("{$table} is empty"); } $ORDER = $boot->TableOrder(array("zDate" => "DESC")); $searchstring = string_to_flexquery("search-rotate-events"); $sql = "SELECT * FROM {$table} WHERE 1 {$searchstring} ORDER BY {$ORDER} LIMIT 0,250"; $results = $q->QUERY_SQL($sql, $database); if (!$q->ok) { senderrors($q->mysql_error . "<br>{$sql}"); } $tpl = new templates(); while ($ligne = mysql_fetch_assoc($results)) { $md = md5(serialize($ligne)); $ligne["content"] = $tpl->_ENGINE_parse_body($ligne["content"]); $ligne["content"] = str_replace("\n", "<br>", $ligne["content"]); $tr[] = "\n\t\t<tr id='{$md}'>\n\t\t<td style='font-size:12px' width=1% nowrap>{$ligne["zDate"]}</td>\n\t\t<td style='font-size:12px' width=1% nowrap>{$ligne["hostname"]}</td>\n\t\t<td style='font-size:12px' width=30% nowrap>{$ligne["subject"]}</td>\n\t\t<td style='font-size:12px' width=70% nowrap>{$ligne["content"]}</td>\n\t\t</tr>\n\t\t"; } echo $boot->TableCompile(array("zDate" => " {zDate} {$rows} {rows}", "hostname" => "{hostname}", "subject" => "{subject}", "content" => null), $tr); }
function members_search() { $tpl = new templates(); $MyPage = CurrentPageName(); $boot = new boostrap_form(); $q = new mysql_squid_builder(); $sock = new sockets(); $fontsize = "14px"; $page = 1; $t = time(); $ORDER = $boot->TableOrder(array("uid" => "ASC")); $searchstring = string_to_flexquery("search-members"); $table = "hotspot_members"; $minutes = $tpl->_ENGINE_parse_body("{minutes}"); $unlimited = $tpl->_ENGINE_parse_body("{unlimited}"); $ttl = $tpl->_ENGINE_parse_body("{ttl}"); $members = $tpl->_ENGINE_parse_body("{members}"); $MAC = $tpl->_ENGINE_parse_body("{MAC}"); $ttl = $tpl->_ENGINE_parse_body("{ttl}"); $finaltime = $tpl->_ENGINE_parse_body("{re_authenticate_each}"); $endtime = $tpl->_ENGINE_parse_body("{endtime}"); $title = $tpl->_ENGINE_parse_body("{sessions} " . date("{l} d {F}")); $q = new mysql_squid_builder(); $hostname = $tpl->_ENGINE_parse_body("{hostname}"); $enabled = $tpl->_ENGINE_parse_body("{enabled}"); $new_account = $tpl->_ENGINE_parse_body("{new_account}"); $sql = "SELECT * FROM {$table} WHERE 1 {$searchstring} ORDER BY {$ORDER} LIMIT 0,250"; $results = $q->QUERY_SQL($sql); if (!$q->ok) { echo $q->mysql_error_html(); } while ($ligne = mysql_fetch_array($results, MYSQL_ASSOC)) { $md5 = md5(serialize($ligne)); $uid = $ligne["uid"]; $ttl = intval($ligne["ttl"]); $logintime = intval($ligne["logintime"]); $Start = $tpl->_ENGINE_parse_body(date("{l} d H:i", $logintime)); $delete = imgsimple("delete-48.png", null, "DeleteMember{$t}('{$ligne["uid"]}','{$md5}')"); $End = $tpl->_ENGINE_parse_body(date("{l} d H:i", $ligne["finaltime"])); $hostname = $ligne["hostname"]; $MAC = $ligne["MAC"]; $ipaddr = $ligne["ipaddr"]; $ttl = $ligne["ttl"]; if ($ttl == 0) { $ttl = $unlimited; } else { $ttl = $tpl->_ENGINE_parse_body(date("{l} d H:i", $ttl)); } $enabled = Field_checkbox("enable_{$uid}", 1, $ligne["enabled"], "MemberEnable{$t}('{$uid}')"); $color = "black"; if ($ligne["enabled"] == 0) { $color = "#A4A1A1"; } $uid_url = urlencode($ligne["uid"]); $uid_url = urlencode($ligne["uid"]); $js = $boot->trswitch("YahooWin4('600','miniadmin.hotspot.php?uid={$uid_url}&t={$t}','{$ligne["uid"]}');"); $jsttl = $boot->trswitch("YahooWin4('500','miniadmin.hotspot.php?ttl={$uid_url}&t={$t}','{$ttl}:{$ligne["uid"]}');"); $tr[] = "\n\t\t<tr>\n\t\t<td style='font-size:18px;color:{$color}' nowrap width=1% {$js}>{$ligne["uid"]}</td>\n\t\t<td style='font-size:18px;color:{$color}' nowrap {$jsttl}>{$ttl}</td>\n\t\t<td style='font-size:18px;color:{$color}' nowrap width=1% {$js}>{$ligne["sessiontime"]} {$minutes}</td>\n\t\t<td style='font-size:18px;color:{$color}' nowrap width=1%>{$enabled}</td>\n\t\t<td style='font-size:18px;color:{$color}' nowrap width=1% {$js}>{$delete}</td>\n\n\t\t</tr>"; } echo $boot->TableCompile(array("uid" => "{$members}", "ttl" => "{ttl}", "sessiontime" => "{$finaltime}", "enabled" => "{$enabled}", "delete" => " "), $tr) . "\t\n<script>\t\t\t\t\nvar x_DeleteSession{$t}= function (obj) {\n\tvar results=obj.responseText;\n\tif(results.length>3){alert(results);return;}\n\t\$('#row'+mem{$t}).remove();\n}\n\nfunction DeleteSession{$t}(md){\n\tmem{$t}=md;\n\tvar XHR = new XHRConnection();\n\tXHR.appendData('DeleteSession',md);\t\n\tXHR.sendAndLoad('miniadmin.hotspot.php', 'POST',x_DeleteSession{$t});\t\n\n}\n\nfunction NewAccount{$t}(){\n\tYahooWin4('600','miniadmin.hotspot.php?uid=&t={$t}','{$new_account}');\n}\n\nvar x_MemberEnable{$t}= function (obj) {\n\tvar results=obj.responseText;\n\tif(results.length>3){alert(results);return;}\n\t\$('#flexRT{$t}').flexReload();\n}\n\nfunction MemberEnable{$t}(uid){\n\tvar enabled=0;\n\tif(document.getElementById('enable_'+uid).checked){enabled=1;}\n\tvar XHR = new XHRConnection();\n\tXHR.appendData('EnableMember',uid);\n\tXHR.appendData('value',enabled);\t\t\n\tXHR.sendAndLoad('miniadmin.hotspot.php', 'POST',x_MemberEnable{$t});\t\n\t\n}\n\nvar x_DeleteMember{$t}= function (obj) {\n\tvar results=obj.responseText;\n\tif(results.length>3){alert(results);return;}\n\t\$('#row'+mem{$t}).remove();\n}\n\nfunction DeleteMember{$t}(uid,md){\n\tmem{$t}=md;\n\tvar XHR = new XHRConnection();\n\tXHR.appendData('DeleteMember',uid);\n\tXHR.sendAndLoad('miniadmin.hotspot.php', 'POST',x_DeleteMember{$t});\t\t\n}\n\n</script>"; }
function search_websites() { $q = new mysql_squid_builder(); $tpl = new templates(); $searchstring = string_to_flexquery("search-websites"); $Params = url_decode_special_tool($_GET["Params"]); $table = "notcategorized"; $boot = new boostrap_form(); $ORDER = $boot->TableOrder(array("hits" => "DESC")); $sql = "SELECT * FROM {$table} WHERE 1 {$searchstring} ORDER BY {$ORDER} LIMIT 0,30"; writelogs($sql, __FUNCTION__, __FILE__, __LINE__); $results = $q->QUERY_SQL($sql); if (!$q->ok) { echo "<p class=text-error>{$q->mysql_error}<hr><code>{$sql}</code></p>"; } while ($ligne = mysql_fetch_assoc($results)) { $id = md5($ligne["sitename"]); $ligne["size"] = FormatBytes($ligne["size"] / 1024); $ligne["hits"] = FormatNumber($ligne["hits"]); $dates = unserialize($ligne["seen"]); $trg = array(); if (is_array($dates)) { while (list($none, $xtime) = each($dates)) { $trg[] = time_to_date($xtime); } } $params = BuildDiv($ligne["sitename"]); $link = $boot->trswitch($params[2]); $content = $params[0]; $js[] = $params[1]; $tr[] = "\n\t<tr id='{$id}'>\n\t<td {$link}><i class='icon-globe'></i> {$ligne["sitename"]}{$content}<br><i style='font-size:10px'>" . @implode(", ", $trg) . "</td>\n\t<td {$link} nowrap><i class='icon-globe'></i> {$ligne["familysite"]}</td>\n\t<td {$link} nowrap><i class='icon-globe'></i> {$ligne["country"]}</td>\n\t<td {$link} nowrap><i class='icon-globe'></i> {$ligne["size"]}</td>\n\t<td {$link} nowrap><i class='icon-star'></i> {$ligne["hits"]}</td>\n\t</tr>"; } echo $boot->TableCompile(array("sitename" => "{website}", "familysite" => "{familysite}", "country" => "{country}", "size" => "{size}", "hits" => "{hits}"), $tr) . "\n\t\t\t<script>" . @implode("\n", $js) . "</script>\t\n\t\t\t\t\t\n\t\t\t"; }
function rules_search() { $boot = new boostrap_form(); $page = CurrentPageName(); $tpl = new templates(); $sock = new sockets(); $q = new mysql_squid_builder(); $table = "authenticator_rules"; $t = time(); $ORDER = $boot->TableOrder(array("ID" => "DESC")); if (!$q->TABLE_EXISTS($table)) { $f = new squid_reverse(); } $searchstring = string_to_flexquery("rules-search"); $sql = "SELECT * FROM {$table} WHERE 1 {$searchstring} ORDER BY {$ORDER} LIMIT 0,250"; $results = $q->QUERY_SQL($sql); if (!$q->ok) { senderrors($q->mysql_error . "<br>{$sql}"); } $AdminPrivs = AdminPrivs(); while ($ligne = mysql_fetch_assoc($results)) { $edit = $boot->trswitch("Loadjs('{$page}?rules-js={$ligne["ID"]}');"); $md = md5(serialize($ligne)); if ($AdminPrivs) { $delete = imgsimple("delete-48.png", "{delete}", "Delete{$t}('{$ligne["ID"]}','{$md}')"); } $explaintext = EXPLAIN_RULE($ligne["ID"]); $tr[] = "\n\t\t<tr id='{$md}'>\n\t\t<td style='font-size:18px' width=1% nowrap {$edit}>{$ligne["rulename"]}</td>\n\t\t<td style='font-size:18px' width=90% nowrap>{$ligne["explain"]}<div style='font-size:12px'>{$explaintext}</div></td>\n\t\t<td style='font-size:18px' width=1% nowrap>{$delete}</td>\n\t\t</tr>\n\t\t"; } $delete_text = $tpl->javascript_parse_text("{delete}"); echo $boot->TableCompile(array("rulename" => " {rulename}", "explain:no" => "{explain}", "delete" => null), $tr) . "\n\t\t\n<script>\nvar mem{$t}='';\nvar xDelete{$t}=function(obj){\n\tvar tempvalue=obj.responseText;\n\tif(tempvalue.length>3){alert(tempvalue);return;}\n\t\$('#'+mem{$t}).remove();\n}\nfunction Delete{$t}(ID,mem){\n\tmem{$t}=mem;\n\tif(confirm('{$delete_text} ID: '+ID+'?')){\n\t\tmem{$t}=mem;\n\t\tvar XHR = new XHRConnection();\n\t\tXHR.appendData('rules-delete',ID);\n\t\tXHR.sendAndLoad('{$page}', 'POST',xDelete{$t});\n\t}\n}\n</script>\n"; }
function container_search() { $t = time(); ini_set('display_errors', 1); ini_set('error_prepend_string', "<p class=text-error>"); ini_set('error_append_string', "</p>\n"); $q = new mysql(); $users = new usersMenus(); $boot = new boostrap_form(); $page = CurrentPageName(); $tpl = new templates(); $ORDER = $boot->TableOrder(array("container_name" => "ASC")); $searchstring = string_to_flexquery("container-search"); $table = "users_containers"; $gpidenc = urlencode($_GET["gpid"]); $sql = "SELECT * FROM `{$table}` WHERE 1 {$searchstring} ORDER BY {$ORDER} LIMIT 0,250"; $results = $q->QUERY_SQL($sql, "artica_backup"); if (!$q->ok) { echo "<p class=text-error>{$q->mysql_error}<hr>{$sql}</p>\n"; } $available = $tpl->_ENGINE_parse_body("{available}"); $used_text = $tpl->_ENGINE_parse_body("{used}"); $error = $tpl->_ENGINE_parse_body("{error}"); $ligne = mysql_fetch_array($q->QUERY_SQL("SELECT maxsize FROM storage_containers WHERE `groupid`='" . mysql_escape_string2($_GET["gpid"]) . "'", "artica_backup")); $maxsize = $ligne["maxsize"]; if ($maxsize > 0) { $uidenc = mysql_escape_string2($_SESSION["uid"]); $ligne = mysql_fetch_array($q->QUERY_SQL("SELECT SUM(container_size) as tSize FROM users_containers WHERE `uid`='{$uidenc}'", "artica_backup")); $tSize = $ligne["tSize"]; $prc = $tSize / $maxsize * 100; $status = "\n\t\t<div style='width:100%;text-align:right;margin-top:25px'>{global_size}: " . pourcentage($prc) . "\n\t\t</div>"; } $iscsi_chap_secret_explain = $tpl->_ENGINE_parse_body("{iscsi_chap_secret_explain}"); $delete_container_ask = $tpl->javascript_parse_text("{delete_container_ask}"); $tr = array(); while ($ligne = mysql_fetch_array($results, MYSQL_ASSOC)) { $ID = $ligne["container_id"]; $addtext = null; $md5 = md5(serialize($ligne)); $container_name = $ligne["container_name"]; $container_size = $ligne["container_size"]; $container_size_UNIT = "MB"; $per = null; $iscsi_error = null; $CMD_WEBDAV_ICON = null; $CMD_ISCSI_JS = null; $CMD_ISCSI_ICON = null; if ($container_size >= 1000) { $container_size = $container_size / 1000; $container_size_UNIT = "GB"; } $delete = imgsimple("delete-32.png", null, "Delete{$t}('{$ID}','{$md5}')"); $color = "black"; $availble = null; $lock = "<img src='img/lock.gif' style='float:right'>"; $status_img = "ok32-grey.png"; if ($ligne["created"] == 0) { $color = "#C1C1C1"; $addtext = $tpl->_ENGINE_parse_body(" {building} {please_wait}..."); } if ($ligne["onerror"] == 1) { $color = "#A10000"; $addtext = " {$error}:" . $ligne["onerrortext"]; } $statusA = unserialize(base64_decode($ligne["status"])); if (is_array($statusA)) { if ($statusA["MOUNTED"] != null) { $status_img = "ok32.png"; } $availble = " {$available}:" . FormatBytes($statusA["STATUS"]["AIVA"]) . " {$used_text} {$statusA["STATUS"]["POURC"]}%"; $per = pourcentage($statusA["STATUS"]["POURC"]); } else { $addtext = " No status..."; } $webdav_creds = unserialize(base64_decode($ligne["webdav_creds"])); if ($webdav_creds["username"] == null) { $lock = null; } if ($ligne["iscsid"] == 1) { $length = strlen($webdav_creds["password"]); if ($length < 12) { $iscsi_error = "<div style='color:#C50808'>{$iscsi_chap_secret_explain}</div>"; } if ($length > 16) { $iscsi_error = "<div style='color:#C50808'>{$iscsi_chap_secret_explain}</div>"; } $CMD_ISCSI_JS = $boot->trswitch("Loadjs('{$page}?iscsi-cmd-js=yes&ID={$ID}')"); $CMD_ISCSI_ICON = "<img src='img/32-infos.png'>"; ////http://nas-appliance.org/index.php?cID=220 } $trjs = $boot->trswitch("Loadjs('{$page}?wizard-js=yes&ID={$ID}&gpid={$gpidenc}')"); if ($ligne["webdav"] == 1) { $CMD_WEBDAV_ICON = "<img src='img/cmd-32.png'>"; $CMD_WEBDAV_JS = $boot->trswitch("Loadjs('{$page}?webdav-cmd-js=yes&ID={$ID}')"); } $tr[] = "\n\t\t<tr id='{$md5}'>\n\t\t<td style='font-size:18px;color:{$color}' nowrap {$trjs}>{$lock}[disk{$ID}] {$container_name} ({$container_size}{$container_size_UNIT}) {$addtext}{$availble}{$iscsi_error}</td>\n\t\t<td style='font-size:18px;color:{$color};text-align:center' nowrap width=1% {$CMD_ISCSI_JS}>{$CMD_ISCSI_ICON}</td>\n\t\t<td style='font-size:18px;color:{$color};text-align:center' nowrap width=1% {$CMD_WEBDAV_JS}>{$CMD_WEBDAV_ICON}</td>\n\t\t<td style='font-size:18px;color:{$color}' nowrap width=1% {$trjs}><img src='img/{$status_img}'></td>\n\t\t<td style='font-size:18px;color:{$color}' nowrap width=1% {$trjs}>{$per}</td>\n\t\t<td style='font-size:18px;color:{$color}' nowrap width=1% >{$delete}</td>\n\t\t</tr>"; } echo $status . $boot->TableCompile(array("container_name" => "{name}", "5:no" => "iSCSI", "3:no" => "WebDav", "1:no" => "{status}", "delete" => "{delete}", "2:no" => ""), $tr) . "\n\t\t\t\t\n<script>\nvar id{$t}='';\nvar xDelete{$t}= function (obj) {\n\tvar res=obj.responseText;\n\tif (res.length>3){alert(res);}\n\t\$('#'+id{$t}).remove();\n}\n\t\nfunction Delete{$t}(ID,md){\n\tif(!confirm('{$delete_container_ask}')){return;}\n\tid{$t}=md;\n\tvar XHR = new XHRConnection();\n\tXHR.appendData('delete-container',ID);\n\tXHR.sendAndLoad('{$page}', 'POST',xDelete{$t});\n}\n</script>"; }
function tasks_search() { $boot = new boostrap_form(); $tpl = new templates(); $q = new mysql(); $t = time(); if (isset($_GET["t"])) { $t = $_GET["t"]; } $page = CurrentPageName(); $table = "system_schedules"; $searchstring = string_to_flexquery("search-tasks"); $ORDER = $boot->TableOrder(array("ID" => "DESC")); if ($q->COUNT_ROWS($table, "artica_backup") == 0) { senderrors("{no_task}"); } if ($_GET["task-section"] > 0) { $table = "( SELECT * FROM {$table} WHERE `TaskType`={$_GET["task-section"]} ) as T"; } $sql = "SELECT * FROM {$table} WHERE 1 {$searchstring} ORDER BY {$ORDER} LIMIT 0,250"; $results = $q->QUERY_SQL($sql, "artica_backup"); if (!$q->ok) { senderrors($q->mysql_error . "<br>{$sql}"); } $schedules = new system_tasks(); while ($ligne = mysql_fetch_assoc($results)) { $color = "black"; $events = " "; $md = md5(serialize($ligne)); $TaskType = $ligne["TaskType"]; $jstaskexplain = $tpl->javascript_parse_text($schedules->tasks_array[$ligne["TaskType"]]); $ligne["TaskType"] = $tpl->_ENGINE_parse_body($schedules->tasks_array[$ligne["TaskType"]]); $TimeDescription = $ligne["TimeDescription"]; $delete = imgtootltip("delete-32.png", "{delete} {$ligne['ID']}", "Delete{$t}('{$ligne['ID']}','{$md}')"); $run = $tpl->_ENGINE_parse_body(imgtootltip("24-run.png", "{run} {$ligne['ID']}", "SystemTaskRun('{$ligne['ID']}','{$jstaskexplain}')")); if ($ligne["enabled"] == 0) { $color = "#A0A0A0"; } $tablename = "Taskev{$ligne['ID']}"; if (!$q->TABLE_EXISTS($tablename, "artica_events")) { $events = null; } else { $evs = $q->COUNT_ROWS($tablename, "artica_events"); if ($evs > 0) { $events = imgsimple("events-32.png"); } } $explainTXT = $tpl->_ENGINE_parse_body($schedules->tasks_explain_array[$TaskType]); $TimeText = $tpl->_ENGINE_parse_body($schedules->PatternToHuman($ligne["TimeText"])); $TimeText = str_replace("<br>", "", $TimeText); if (preg_match("#(.+?)\\s+(.+?)\\s+(.+?)\\s+(.+?)\\s+(.+?)#", $TimeDescription, $re)) { $TimeDescription = $TimeText; $TimeText = null; } $js = "Loadjs('{$page}?schedule-js=yes&ID={$ligne['ID']}')"; $link = $boot->trswitch($js); $ligne["TimeDescription"] = utf8_encode($ligne["TimeDescription"]); $ligne["TaskType"] = utf8_encode($ligne["TaskType"]); $tr[] = "\n\t\t<tr id='{$md}'>\n\t\t<td style='font-size:16px' width=1% nowrap {$link}>{$ligne['ID']}</td>\n\t\t<td style='font-size:16px' width=25% nowrap {$link}>{$ligne["TaskType"]}</td>\n\t\t<td style='font-size:16px' width=70% {$link}>{$TimeDescription}<br>{$explainTXT}</td>\n\t\t<td style='font-size:16px' width=1% nowrap >{$run}</td>\n\t\t<td style='font-size:16px' width=1% nowrap {$link}>{$events}</td>\n\t\t<td style='font-size:12px' width=1%>{$delete}</td>\n\t\t</tr>\n\t\t"; } $run_this_task_now = $tpl->javascript_parse_text("{run_this_task_now}"); $delete_text = $tpl->javascript_parse_text("{delete_this_task}"); echo $boot->TableCompile(array("ID" => "ID", "TaskType" => "{type}", "TimeText" => "{explain}", "run:no" => "{run}", "event:no" => "{events}", "delete:no" => null), $tr) . "\n<script>\nvar mem{$t}='';\nvar xDelete{$t}=function(obj){\n\tvar tempvalue=obj.responseText;\n\tif(tempvalue.length>3){alert(tempvalue);return;}\n\t\$('#'+mem{$t}).remove();\n}\nfunction Delete{$t}(ID,mem){\n\tmem{$t}=mem;\n\tif(confirm('{$delete_text} ID: '+ID+'?')){\n\t\tmem{$t}=mem;\n\t\tvar XHR = new XHRConnection();\n\t\tXHR.appendData('task-delete',ID);\n\t\tXHR.sendAndLoad('{$page}', 'POST',xDelete{$t});\n\t}\n}\nvar xSystemTaskEnable{$t}=function (obj) {\n\tvar results=obj.responseText;\n\tif(results.length>0){alert(results);}\n\tExecuteByClassName('SearchFunction');\t\t\n}\n\nfunction SystemTaskRun{$t}(ID){\n\tif(confirm('{$run_this_task_now} :`'+ID+'`')){\n\t\tvar XHR = new XHRConnection();\n\t\tXHR.appendData('task-run',ID);\n\t\tXHR.sendAndLoad('{$page}', 'POST',xSystemTaskEnable{$t});\t\t\n\t}\n}\n\t\t\t\n</script>\n\t\t\t\n"; }
function events_search() { $boot = new boostrap_form(); $tpl = new templates(); $q = new mysql(); $page = CurrentPageName(); $table = "mirror_logs"; $searchstring = string_to_flexquery("search-events"); $ORDER = $boot->TableOrder(array("zDate" => "DESC")); if ($q->COUNT_ROWS($table, "artica_events") == 0) { senderrors("no data"); } $sql = "SELECT * FROM {$table} WHERE 1 {$searchstring} ORDER BY {$ORDER} LIMIT 0,250"; $results = $q->QUERY_SQL($sql, "artica_events"); if (!$q->ok) { senderrors($q->mysql_error . "<br>{$sql}"); } while ($ligne = mysql_fetch_assoc($results)) { $md = md5(serialize($ligne)); if ($ligne["totalsize"] > 0) { $ligne["totalsize"] = FormatBytes($ligne["totalsize"] / 1024); } $distance = $tpl->_ENGINE_parse_body(distanceOfTimeInWords($ligne["starton"], $ligne["endon"])); $link = null; $tr[] = "\n\t\t<tr id='{$md}'>\n\t\t<td style='font-size:16px' width=1% nowrap {$link}>{$ligne["zDate"]}</td>\n\t\t<td style='font-size:16px' width=1% nowrap {$link}>{$ligne["pid"]}</td>\n\t\t<td style='font-size:16px' width=1% nowrap {$link}>{$distance}</td>\n\t\t<td style='font-size:16px' width=1% nowrap {$link}>{$ligne["filesnumber"]}</td>\n\t\t<td style='font-size:16px' width=1% nowrap {$link}>{$ligne["totalsize"]}</td>\n\t\t<td style='font-size:12px' width=99% {$link}>{$ligne["error"]}</td>\n\t\t</tr>\n\t\t"; } echo $boot->TableCompile(array("zDate" => "{date}", "pid" => "pid", "endon" => "{duration}", "filesnumber" => "{files}", "size" => "{size}", "error" => "{error}"), $tr); }
function events_search() { $page = CurrentPageName(); $boot = new boostrap_form(); $tpl = new templates(); $searchstring = string_to_flexquery("events-search"); $ORDER = $boot->TableOrder(array("zDate" => "DESC")); $limitSql = "LIMIT 0,250"; $sql = "SELECT * FROM nginx_exploits_fwev WHERE servername='{$_GET["servername"]}' {$searchstring} ORDER BY {$ORDER} {$limitSql}"; $q = new mysql_squid_builder(); $results = $q->QUERY_SQL($sql); if (!$q->ok) { echo $q->mysql_error_html(); } while ($ligne = mysql_fetch_assoc($results)) { $tr[] = "\n\t\t\t\t\t<tr id='{$ligne["ID"]}'>\n\t\t\t\t\t<td width='25%' nowrap><i class='icon-time'></i> {$ligne["zDate"]}</a></td>\n\t\t\t\t\t<td width='25%' nowrap>{$ligne["ipaddr"]}</a></td>\n\t\t\t\t\t<td width='25%' nowrap>{$ligne["hostname"]}</td>\n\t\t\t\t\t<td width='25%' nowrap>{$ligne["country"]}</td>\n\t\t\t\t\t</tr>"; } $html = $boot->TableCompile(array("zDate" => "{date}", "ipaddr" => "{ipaddr}", "hostname" => "{hostname}", "country" => "{country}"), $tr); echo $tpl->_ENGINE_parse_body($html); }
function computers_search() { $tpl = new templates(); $MyPage = CurrentPageName(); $boot = new boostrap_form(); $q = new mysql(); $sock = new sockets(); $fontsize = "14px"; $page = 1; if (!$q->DATABASE_EXISTS("ocsweb")) { $sock->getFrameWork("services.php?mysql-ocs=yes"); } if (!$q->TABLE_EXISTS("hardware", "ocsweb")) { $sock->getFrameWork("services.php?mysql-ocs=yes"); } if (!$q->TABLE_EXISTS("networks", "ocsweb", true)) { $sock->getFrameWork("services.php?mysql-ocs=yes"); } $EnableScanComputersNet = $sock->GET_INFO("EnableScanComputersNet"); if (!is_numeric($EnableScanComputersNet)) { $EnableScanComputersNet = 0; } if (!$q->FIELD_EXISTS("networks", "isActive", "ocsweb")) { $q->QUERY_SQL("ALTER TABLE `networks` ADD `isActive` SMALLINT( 1 ) NOT NULL DEFAULT '0',ADD INDEX ( `isActive` ) ", "ocsweb"); } $ORDER = $boot->TableOrder(array("NAME" => "ASC")); $searchstring = string_to_flexquery("computer-search"); $table = "(SELECT networks.MACADDR,networks.IPADDRESS,\n\t\t\thardware.OSNAME,\n\t\t\thardware.LASTDATE,\n\t\t\thardware.NAME,\n\t\t\thardware.IPADDR,\n\t\t\thardware.IPSRC\n\t\t\tFROM networks,hardware WHERE networks.HARDWARE_ID=hardware.ID) as t"; $sql = "SELECT * FROM {$table} WHERE 1 {$searchstring} ORDER BY {$ORDER} LIMIT 0,250"; $results = $q->QUERY_SQL($sql, "ocsweb"); if (!$q->ok) { echo $q->mysql_error . "<br>{$sql}\n"; } $computer = new computers(); while ($ligne = mysql_fetch_array($results, MYSQL_ASSOC)) { if ($ligne["MACADDR"] == "unknown") { continue; } $uid = null; $OSNAME = null; if ($ligne["OSNAME"] == "Unknown") { $ligne["OSNAME"] = null; } $color = "#7D7D7D"; $md = md5($ligne["MACADDR"]); $uri = strtolower($ligne["NAME"]); $uid = $computer->ComputerIDFromMAC($ligne["MACADDR"]); $view = " "; $jsfiche = MEMBER_JS($uid, 1, 1); $js = null; if ($uid != null) { $js = $boot->trswitch($jsfiche); } if ($ligne["OSNAME"] != null) { $OSNAME = "<div style='font-size:9px'><i>{$ligne["OSNAME"]}</i></div>"; } $isActive = "img/unknown24.png"; if ($EnableScanComputersNet == 1) { if ($ligne["isActive"] == 1) { $isActive = "img/ok24.png"; } else { $isActive = "img/danger24.png"; } } if (!IsPhysicalAddress($ligne["MACADDR"])) { if ($_GET["CorrectMac"] == 1) { continue; } } $AlreadyMAC[$ligne["MACADDR"]] = true; $zdate = null; if (isset($ligne["zDate"])) { $zdate = "<div style='font-size:11px;color:#7D7D7D'>{$ligne["zDate"]}</div>"; } $tr[] = "\n\t\t<tr>\n\t\t\t<td style='font-size:18px' nowrap width=1% {$js}>{$ligne["LASTDATE"]}</td>\n\t\t\t<td style='font-size:18px' nowrap {$js}>{$ligne["NAME"]}</td>\n\t\t\t<td style='font-size:18px' nowrap width=1% {$js}>{$ligne["IPADDRESS"]}</td>\n\t\t\t<td style='font-size:18px' nowrap width=1% {$js}>{$ligne["MACADDR"]}</td>\n\t\t\t<td style='font-size:18px' nowrap width=1% {$js}><img src='{$isActive}'></td>\t\t\t\n\t\t\t\t\n\t\t</tr>"; } echo $boot->TableCompile(array("LASTDATE" => "{date}", "NAME" => "{hostname}", "IPADDRESS" => "{ipaddr}", "MACADDR" => "{MAC}"), $tr); }
function search_members() { $q = new mysql_squid_builder(); $tpl = new templates(); $searchstring = string_to_flexquery("search-members"); $Params = url_decode_special_tool($_GET["Params"]); if (!$_SESSION["CORP"]) { $tpl = new templates(); $onlycorpavailable = $tpl->_ENGINE_parse_body("{onlycorpavailable}"); $content = "<p class=text-error>{$onlycorpavailable}</p>"; echo $content; return; } $boot = new boostrap_form(); $ORDER = $boot->TableOrder(array("uid" => "ASC")); $table = "(SELECT SUM(size) as size,SUM(hits) as hits,uid FROM members_uid \n\t\t\tGROUP BY uid HAVING uid NOT LIKE '%\$' AND LENGTH(uid) >0 ) as t"; $sql = "SELECT * FROM {$table} WHERE 1 {$searchstring} ORDER BY {$ORDER} LIMIT 0,150"; writelogs($sql, __FUNCTION__, __FILE__, __LINE__); $results = $q->QUERY_SQL($sql); if (!$q->ok) { echo "<p class=text-error>{$q->mysql_error}<hr><code>{$sql}</code></p>"; } while ($ligne = mysql_fetch_assoc($results)) { $ligne["size"] = FormatBytes($ligne["size"] / 1024); $ligne["hits"] = FormatNumber($ligne["hits"]); $link = $boot->trswitch("document.location.href='miniadm.webstats.ByMember.php?by=uid&member-value=" . urlencode($ligne["uid"]) . "';"); $tr[] = "\n\t<tr id='{$id}'>\n\t<td {$link}><i class='icon-user'></i> {$ligne["uid"]}</a></td>\n\t<td {$link}><i class='icon-globe'></i> {$ligne["size"]}</td>\n\t<td {$link}><i class='icon-star'></i> {$ligne["hits"]}</td>\n\t</tr>"; } echo $boot->TableCompile(array("uid" => "{member}", "size" => "{size}", "hits" => "{hits}"), $tr); }
function category_search() { $t = time(); ini_set('display_errors', 1); ini_set('error_prepend_string', "<p class=text-error>"); ini_set('error_append_string', "</p>\n"); $q = new mysql_squid_builder(); $users = new usersMenus(); $boot = new boostrap_form(); $page = CurrentPageName(); $tpl = new templates(); $ORDER = $boot->TableOrder(array("pattern" => "ASC")); $searchstring = string_to_flexquery("category-search"); $table = $q->cat_totablename($_GET["category"]); $sql = "SELECT * FROM `{$table}` WHERE 1 {$searchstring} ORDER BY {$ORDER} LIMIT 0,250"; $results = $q->QUERY_SQL($sql); if (!$q->ok) { echo "<p class=text-error>{$q->mysql_error}<hr>{$sql}</p>\n"; } $tr = array(); while ($ligne = mysql_fetch_array($results, MYSQL_ASSOC)) { $date = $boot->time_to_date(strtotime($ligne['zDate']), true); $md5 = md5(serialize($ligne)); $pattern = $ligne["pattern"]; $delete = imgsimple("delete-32.png", null, "Delete{$t}('{$pattern}','{$md5}')"); $tr[] = "\n\t\t<tr id='{$md5}'>\n\t\t<td style='font-size:18px' nowrap width=1% nowrap>{$date}</td>\n\t\t<td style='font-size:18px' nowrap >{$pattern}</td>\n\t\t<td style='font-size:18px' nowrap width=1% >{$delete}</td>\n\t\t</tr>"; } echo $boot->TableCompile(array("zDate" => "{date}", "pattern" => "{sitename}", "delete" => "{delete}"), $tr) . "\n\t\t\t\t\t\n<script>\nvar id{$t}='';\n\tvar xDelete{$t}= function (obj) {\n\t\tvar res=obj.responseText;\n\t\tif (res.length>3){alert(res);return;}\n\t\t\$('#'+id{$t}).remove();\n\t\t\n\t}\n\nfunction Delete{$t}(www,md){\n\tid{$t}=md;\n\tvar XHR = new XHRConnection();\n\tXHR.appendData('www-delete',www);\n\tXHR.appendData('category','{$_GET["category"]}');\n\tXHR.sendAndLoad('{$page}', 'POST',xDelete{$t});\t\t\n}\n</script>"; }
function section_categories_search() { $t = $_GET["t"]; $tpl = new templates(); $MyPage = CurrentPageName(); $q = new mysql_squid_builder(); $users = new usersMenus(); $sock = new sockets(); $boot = new boostrap_form(); $database = "squidlogs"; $familysite = $_GET["familysite"]; $search = '%'; $table = date("Ymd", $_GET["xtime"]) . "_hour"; $rp = 250; $page = 1; $boot = new boostrap_form(); $FAMS = $boot->SQUID_CATEGORIES_FAM; $searchstring = string_to_flexquery("categories-search"); $ORDER = $boot->TableOrder(array("size" => "DESC")); if (!$q->TABLE_EXISTS($table)) { senderrors("no such table"); } if ($q->COUNT_ROWS($table) == 0) { senderrors("no data"); } //zDate | client | uid | hostname | MAC | familysite | catfam | hits | size $table = "( SELECT sitename,familysite,category,catfam,SUM(size) as size,SUM(hits) as hits FROM `{$table}` GROUP BY\n\tsitename HAVING familysite='{$familysite}' AND catfam={$_GET["fam"]}) as t"; $sql = "SELECT * FROM {$table} WHERE 1 {$searchstring} ORDER BY {$ORDER} LIMIT 0,250"; $results = $q->QUERY_SQL($sql); if (!$q->ok) { senderrors($q->mysql_error . "<br>{$sql}"); } while ($ligne = mysql_fetch_assoc($results)) { $md = md5(serialize($ligne)); $fam = $tpl->_ENGINE_parse_body("{$FAMS[$ligne["catfam"]]["TITLE"]}"); $link = null; $tr[] = "\n\t\t<tr id='{$md}'>\n\t\t<td style='font-size:14px' width=50% nowrap {$link}>{$ligne["sitename"]}</td>\n\t\t<td style='font-size:14px' width=1% nowrap {$link}>{$ligne["hits"]}</td>\n\t\t<td style='font-size:14px' width=1% nowrap {$link}>{$ligne["size"]}</td>\n\t\t<td style='font-size:14px' width=1% nowrap {$link}>{$ligne["category"]}</td>\n\t\t<td style='font-size:14px' width=50% {$link}>{$fam}</td>\n\t\t</tr>\n\t\t"; } echo $boot->TableCompile(array("zDate" => "{this_month}", "hits" => "{hits}", "size" => "{size}", "category" => "{category}", "catfam" => "{behavior}"), $tr); }
function www_beahvior_search() { $page = CurrentPageName(); $tpl = new templates(); $boot = new boostrap_form(); $familysite = $_GET["familysite"]; $FAMS = $boot->SQUID_CATEGORIES_FAM; $current_month = date("Ym"); $table = "{$current_month}_catfam"; $q = new mysql_squid_builder(); $searchstring = string_to_flexquery("www-behavior-search"); $ORDER = $boot->TableOrder(array("zDate" => "DESC")); if (!$q->TABLE_EXISTS($table)) { senderrors("no such table"); } if ($q->COUNT_ROWS($table) == 0) { senderrors("no data"); } //zDate | client | uid | hostname | MAC | familysite | catfam | hits | size $table = "( SELECT familysite,zDate,catfam,SUM(size) as size,SUM(hits) as hits FROM `{$table}` GROUP BY \n\tzDate,familysite HAVING familysite='{$familysite}') as t"; $sql = "SELECT * FROM {$table} WHERE 1 {$searchstring} ORDER BY {$ORDER} LIMIT 0,250"; $results = $q->QUERY_SQL($sql); if (!$q->ok) { senderrors($q->mysql_error . "<br>{$sql}"); } while ($ligne = mysql_fetch_assoc($results)) { $md = md5(serialize($ligne)); $ligne["size"] = FormatBytes($ligne["size"] / 1024); $sitenameenc = urlencode($ligne["familysite"]); $xtime = strtotime("{$ligne["zDate"]} 00:00:00"); $js = "Loadjs('miniadm.webstats.fam.ByDay.php?familysite={$sitenameenc}&xtime={$xtime}&fam={$ligne["catfam"]}')"; $link = $boot->trswitch($js); $tr[] = "\n\t\t<tr id='{$md}'>\n\t\t<td style='font-size:16px' width=1% nowrap {$link}>{$ligne["zDate"]}</td>\n\t\t<td style='font-size:16px' width=1% nowrap {$link}>{$ligne["hits"]}</td>\n\t\t<td style='font-size:16px' width=1% nowrap {$link}>{$ligne["size"]}</td>\n\t\t<td style='font-size:16px' width=99% {$link}>" . $tpl->_ENGINE_parse_body($FAMS[$ligne["catfam"]]["TITLE"]) . "</td>\n\t\t</tr>\n\t\t"; } echo $boot->TableCompile(array("zDate" => "{this_month}", "hits" => "{hits}", "size" => "{size}", "catfam" => "{behavior}"), $tr); }
function virtip_search() { $boot = new boostrap_form(); $page = CurrentPageName(); $tpl = new templates(); $sock = new sockets(); $q = new mysql(); $table = "nics_virtuals"; $database = "artica_backup"; $t = time(); $ORDER = $boot->TableOrder(array("ID" => "DESC")); $sock = new sockets(); $net = new networking(); $ip = new IP(); $interfaces = unserialize(base64_decode($sock->getFrameWork("cmd.php?ifconfig-interfaces=yes"))); $searchstring = string_to_flexquery("search-virtip"); $sql = "SELECT * FROM {$table} WHERE 1 {$searchstring} ORDER BY {$ORDER} LIMIT 0,250"; $results = $q->QUERY_SQL($sql, $database); if (!$q->ok) { senderrors($q->mysql_error . "<br>{$sql}"); } $net = new networking(); while ($ligne = mysql_fetch_assoc($results)) { $md = md5(serialize($ligne)); $ip = new IP(); $cdir = $ligne["cdir"]; $eth = "{$ligne["nic"]}:{$ligne["ID"]}"; $eth_text = "{$ligne["nic"]}:{$ligne["ID"]}"; if ($ligne["cdir"] == null) { $ligne["cdir"] = $net->array_TCP[$ligne["nic"]]; $eth = $ligne["nic"]; } if ($ligne["cdir"] == null) { $ligne["cdir"] = $net->array_TCP[$ligne["nic"]]; $eth = $ligne["nic"]; } $img = "folder-network-48.png"; if ($interfaces["{$ligne["nic"]}.{$ligne["ID"]}"] != null) { $img = "folder-network-48-grey.png"; } if (trim($ligne["org"]) == null) { $ligne["org"] = $tpl->_ENGINE_parse_body("<strong style='color:red'>{no_organization}</strong>"); } $edit = $boot->trswitch("Loadjs('{$page}?virtid-js={$ligne["ID"]}')"); $delete = imgsimple("delete-48.png", "{delete}", "Delete{$t}('{$ligne["ID"]}','{$md}')"); $a = $ip->parseCIDR($cdir); if ($a[0] == 0) { $img = "warning-panneau-24.png"; $cdir = "<span style='color:red'>{$cdir}</span>"; } $tr[] = "\n\t\t<tr id='{$md}'>\n\t\t\t<td style='font-size:18px' width=48px nowrap {$edit}><img src='img/{$img}'></td>\n\t\t\t<td style='font-size:18px' width=1% nowrap {$edit}>{$eth_text}</td>\n\t\t\t<td style='font-size:18px' width=90% nowrap {$edit}>{$ligne["org"]}</td>\n\t\t\t<td style='font-size:18px' width=10% nowrap {$edit}>{$ligne["nic"]}</td>\n\t\t\t<td style='font-size:18px' width=5% nowrap {$edit}>{$ligne["ipaddr"]}</td>\n\t\t\t<td style='font-size:18px' width=5% nowrap {$edit}>{$ligne["netmask"]}</td>\n\t\t\t<td style='font-size:18px' width=1% nowrap>{$delete}</td>\n\t\t</tr>\n\t\t"; } $delete_text = $tpl->javascript_parse_text("{delete}"); echo $boot->TableCompile(array("ID" => "ID:colspan=2", "org" => " {organization}", "nic" => "{nic}", "ipaddr" => "{ipaddr}", "netmask" => "{netmask}", "delete" => null), $tr) . "\n\t\t\t\t\t\n<script>\nvar mem{$t}='';\nvar xDelete{$t}=function(obj){\n\tvar tempvalue=obj.responseText;\n\tif(tempvalue.length>3){alert(tempvalue);return;}\n\t\$('#'+mem{$t}).remove();\n}\nfunction Delete{$t}(ID,mem){\n\tmem{$t}=mem;\n\tif(confirm('{$delete_text} ID: '+ID+'?')){\n\t\tmem{$t}=mem;\n\t\tvar XHR = new XHRConnection();\n\t\tXHR.appendData('virtip-delete',ID);\n\t\tXHR.sendAndLoad('{$page}', 'POST',xDelete{$t});\n\t\t}\n\t}\n</script>\t\t\t\t\t\n"; }
function sources_search() { $boot = new boostrap_form(); $page = CurrentPageName(); $tpl = new templates(); $sock = new sockets(); $q = new mysql_squid_builder(); $table = "authenticator_authlnk"; $ORDER = $boot->TableOrder(array("zorder" => "ASC")); $searchstring = string_to_flexquery("sources-search"); if (!$q->TABLE_EXISTS("authenticator_authlnk")) { $f = new squid_reverse(); } $table = "(\n\tSELECT\n\tauthenticator_authlnk.ID,\n\tauthenticator_authlnk.zorder,\n\tauthenticator_auth.groupname,\n\tauthenticator_auth.group_type,\n\tauthenticator_authlnk.groupid\n\tFROM authenticator_authlnk,authenticator_auth\n\tWHERE authenticator_authlnk.ruleid='{$_GET["mainrule"]}'\n\t\t\tAND authenticator_authlnk.groupid=authenticator_auth.ID\n\t\t\t) as t"; $sql = "SELECT * FROM {$table} WHERE 1 {$searchstring} ORDER BY {$ORDER} LIMIT 0,250"; $results = $q->QUERY_SQL($sql); if (!$q->ok) { senderrors($q->mysql_error . "<br>{$sql}"); } $AdminPrivs = AdminPrivs(); $t = time(); while ($ligne = mysql_fetch_assoc($results)) { $edit = $boot->trswitch("Loadjs('{$page}?sources-group-js=yes&groupid={$ligne["groupid"]}');"); $md = md5(serialize($ligne)); if ($AdminPrivs) { $delete = imgsimple("delete-48.png", "{delete}", "Delete{$t}('{$ligne["ID"]}','{$md}')"); } $tr[] = "\n\t\t\t<tr id='{$md}'>\n\t\t\t<td style='font-size:18px' width=99% nowrap {$edit}>{$ligne["groupname"]} - " . $tpl->_ENGINE_parse_body($GLOBALS["TYPES"][$ligne["group_type"]]) . "</td>\n\t\t\t<td style='font-size:18px' width=1% nowrap>{$delete}</td>\n\t\t\t\n\t\t\t</tr>\n\t\t\t"; } $delete_text = $tpl->javascript_parse_text("{unlink}"); echo $boot->TableCompile(array("rulename" => " {groupname}", "delete" => null), $tr) . "\n\n<script>\nvar mem{$t}='';\n\tvar xDelete{$t}=function(obj){\n\t\tvar tempvalue=obj.responseText;\n\t\tif(tempvalue.length>3){alert(tempvalue);return;}\n\t\t\$('#'+mem{$t}).remove();\n\t}\nfunction Delete{$t}(ID,mem){\n\tmem{$t}=mem;\n\tif(confirm('{$delete_text} ID: '+ID+'?')){\n\t\tmem{$t}=mem;\n\t\tvar XHR = new XHRConnection();\n\t\tXHR.appendData('source-unlink',ID);\n\t\tXHR.sendAndLoad('{$page}', 'POST',xDelete{$t});\n\t}\n}\n</script>\n\t"; }
function search_records() { //SELECT MacAddress, uid FROM hostsusers $search = '%'; $q = new mysql_squid_builder(); $page = CurrentPageName(); $tpl = new templates(); $q2 = new mysql(); $limitSql = "LIMIT 0,150"; $t = time(); $q = new mysql_squid_builder(); if (!$q->FIELD_EXISTS("webfilters_ipaddr", "ip")) { $q->QUERY_SQL("ALTER TABLE `webfilters_ipaddr` ADD `ip` int(10) unsigned NOT NULL default '0',ADD INDEX ( `ip` )"); } $boot = new boostrap_form(); $searchstring = string_to_flexquery("search-records"); $ORDER = $boot->TableOrder(array("ip" => "ASC")); $sql = "SELECT * FROM webfilters_ipaddr WHERE 1 {$searchstring} ORDER BY {$ORDER} {$limitSql}"; $results = $q->QUERY_SQL($sql); $sock = new sockets(); if (!$q->ok) { echo "<p class=text-error>{$q->mysql_error}<hr><code>{$sql}</code></p>"; } while ($ligne = mysql_fetch_assoc($results)) { $id = md5(serialize($ligne)); $explainthis = null; $articasrv = null; $aliases_text = null; $explainMac = null; $OS = null; $macencoded = urlencode($ligne["ipaddr"]); $delete = imgsimple("delete-24.png", null, "Loadjs('{$page}?delete-ipaddr-js={$macencoded}&id={$id}')"); $jshost = "NewPDNSEntry{$t}({$id});"; $linkipaddr = $boot->trswitch("Loadjs('{$page}?NewipaddrLink-js=yes&ipaddr={$macencoded}')"); $tr[] = "\n\t\t<tr id='{$id}'>\n\t\t<td {$linkipaddr} width=1% nowrap><i class='icon-user'></i> {$ligne["ipaddr"]}</a></td>\n\t\t<td nowrap {$linkipaddr}><i class='icon-user'></i> {$ligne["hostname"]}</a></td>\n\t\t<td nowrap {$linkipaddr} width=1% nowrap><i class='icon-user'></i> {$ligne["uid"]}</td>\n\t\t<td style='text-align:center' width=1% nowrap>{$delete}</td>\n\t\t</tr>"; } $html = $boot->TableCompile(array("ip" => "{ipaddr}", "hostname" => "{hostname}", "uid" => "{uid}", "delete:no" => "{delete}"), $tr); echo $tpl->_ENGINE_parse_body($html); }
function table_sites_search() { $t = $_GET["t"]; $tpl = new templates(); $MyPage = CurrentPageName(); $q = new mysql_squid_builder(); $users = new usersMenus(); $sock = new sockets(); $boot = new boostrap_form(); $database = "squidlogs"; $search = '%'; $table = date("Ymd", $_GET["xtime"]) . "_hour"; $rp = 250; $page = 1; $FORCE_FILTER = null; $ORDER = "ORDER BY size DESC"; if (!$q->TABLE_EXISTS($table, $database)) { senderror("{$table} doesn't exists..."); } if ($q->COUNT_ROWS($table, $database) == 0) { senderror("No data"); } if (isset($_POST["sortname"])) { if ($_POST["sortname"] != null) { $ORDER = "ORDER BY {$_POST["sortname"]} {$_POST["sortorder"]}"; } } if (isset($_POST['page'])) { $page = $_POST['page']; } $search = string_to_flexquery("sitename-search"); if (isset($_POST['rp'])) { $rp = $_POST['rp']; } $familysite = mysql_escape_string2($_GET["familysite"]); $uid = mysql_escape_string2($_GET["uid"]); $sql = "SELECT SUM(size) as size, sum(hits) as hits,sitename,familysite,uid FROM {$table}\n\tGROUP BY sitename,familysite,uid HAVING `familysite`='{$familysite}' AND uid='{$uid}' {$search} {$ORDER} LIMIT 0,500"; $results = $q->QUERY_SQL($sql, $database); $ORDER = $boot->TableOrder(array("size" => "DESC")); if (!$q->ok) { senderror($q->mysql_error . "<br>{$sql}"); } while ($ligne = mysql_fetch_assoc($results)) { $color = "black"; $ligne["hits"] = numberFormat($ligne["hits"], 0, "", " "); $ligne["size"] = FormatBytes($ligne["size"] / 1024); $id = md5(serialize($ligne)); $jsSitename = $boot->trswitch("Loadjs('miniadm.webstats.websites.ByDayBySiteName.php?sitename={$ligne["sitename"]}&xtime={$_GET["xtime"]}')"); $tr[] = "\n\t\t\t\t<tr id='{$id}'>\n\t\t\t\t\t<td ><i class='icon-globe'></i> {$ligne["sitename"]}</a></td>\n\t\t\t\t\t<td ><i class='icon-info-sign'></i> {$ligne["size"]}</td>\n\t\t\t\t\t<td ><i class='icon-info-sign'></i> {$ligne["hits"]}</td>\n\t\t\t\t</tr>"; } echo $boot->TableCompile(array("sitename" => "{website}", "size" => "{size}", "hits" => "{hits}"), $tr); }
function charters_search() { $boot = new boostrap_form(); $tpl = new templates(); $page = CurrentPageName(); $searchstring = string_to_flexquery("itcharters-search"); $q = new mysql_squid_builder(); $ORDER = $boot->TableOrder(array("title" => "ASC")); $table = "itcharters"; $t = time(); $sql = "SELECT ID,title,TextIntro,TextButton FROM {$table} WHERE 1 {$searchstring} ORDER BY {$ORDER} LIMIT 0,150"; writelogs($sql, __FUNCTION__, __FILE__, __LINE__); $results = $q->QUERY_SQL($sql); if (!$q->ok) { echo "<p class=text-error>{$q->mysql_error}<hr><code>{$sql}</code></p>"; } while ($ligne = mysql_fetch_assoc($results)) { $md = md5(serialize($ligne)); $link = $boot->trswitch("Loadjs('{$page}?charter-js=yes&ID={$ligne["ID"]}')"); $delete = imgtootltip("delete-24.png", null, "Delete{$t}({$ligne["ID"]},'{$md}')"); $tr[] = "\n\t<tr id='{$md}'>\n\t<td {$link}><i class='icon-globe'></i> {$ligne["title"]}</td>\n\t<td width=1% nowrap>{$delete}</td>\n\t</tr>"; } $delete_text = $tpl->javascript_parse_text("{delete_this_itchart}"); echo $boot->TableCompile(array("title" => "{it_charters}", "delete" => null), $tr) . "\n<script>\nvar mem{$t}='';\nvar xDelete{$t}=function(obj){\n\tvar tempvalue=obj.responseText;\n\tif(tempvalue.length>3){alert(tempvalue);return;}\n\t\$('#'+mem{$t}).remove();\n}\nfunction Delete{$t}(ID,mem){\n\tmem{$t}=mem;\n\tif(confirm('{$delete_text} '+ID+'?')){\n\t\tmem{$t}=mem;\n\t\tvar XHR = new XHRConnection();\n\t\tXHR.appendData('itcharters-delete',ID);\n\t\tXHR.sendAndLoad('{$page}', 'POST',xDelete{$t});\n\t\t}\n\t}\n</script>\t\t\t\t\t\n"; }
function section_flow_search() { $tpl = new templates(); $MyPage = CurrentPageName(); $boot = new boostrap_form(); $q = new mysql_squid_builder(); $sock = new sockets(); $fontsize = "14px"; $page = 1; $t = time(); $ORDER = $boot->TableOrder(array("day" => "DESC")); $searchstring = string_to_flexquery("topwebsites-search"); $year = $_GET["year"]; $month = $_GET["month"]; $uid = mysql_escape_string2($_GET["uid"]); $familysite = mysql_escape_string2($_GET["familysite"]); $familysiteEnc = urlencode($_GET["familysite"]); $uidenc = urlencode($_GET["uid"]); $table = "quotamonth_{$year}{$month}"; $table = "(SELECT `uid`,`day`,familysite,SUM(size) as `size` FROM {$table} GROUP BY `uid`,familysite,`day`\n\tHAVING uid='{$uid}' \n\tAND familysite='{$familysite}'\n\tORDER BY `day` LIMIT 0,30) as t"; $size_text = $tpl->_ENGINE_parse_body("{size}"); $websites_text = $tpl->_ENGINE_parse_body("{day}"); $sql = "SELECT * FROM {$table} WHERE 1 {$searchstring} ORDER BY {$ORDER} LIMIT 0,20"; $results = $q->QUERY_SQL($sql); if (!$q->ok) { echo $q->mysql_error_html(); } $suffix = suffix(); while ($ligne = mysql_fetch_array($results, MYSQL_ASSOC)) { $color = "black"; $day = $ligne["day"]; if (strlen($day) == 1) { $day = "0{$day}"; } $size = FormatBytes($ligne["size"] / 1024); $time = strtotime("{$year}-{$month}-{$day} 00:00:00"); $dayname = $tpl->_ENGINE_parse_body(date("{l} {$day}", $time)); $js = $boot->trswitch("Loadjs('miniadm.webstats.websites.ByDayByFamilySiteByMember.php?familysite={$familysiteEnc}&xtime={$time}&uid={$uidenc}')"); $tr[] = "\n\t\t<tr>\n\t\t<td style='font-size:18px;color:{$color}' nowrap width=99% nowrap {$js}>{$dayname}</td>\n\t\t<td style='font-size:18px;color:{$color}' nowrap width=1% nowrap {$js}>{$size}</td>\n\t\t</tr>"; } echo $boot->TableCompile(array("day" => "{days}", "size" => "{$size_text}"), $tr); }
function items_search() { $page = CurrentPageName(); $boot = new boostrap_form(); $tpl = new templates(); $searchstring = string_to_flexquery("items-search"); $ORDER = $boot->TableOrder(array("token" => "ASC")); $limitSql = "LIMIT 0,150"; $sql = "SELECT * FROM nginx_exploits_items WHERE groupid={$_GET["groupid"]} {$searchstring} ORDER BY {$ORDER} {$limitSql}"; $q = new mysql_squid_builder(); $results = $q->QUERY_SQL($sql); $sock = new sockets(); $not = $tpl->_ENGINE_parse_body("{is_not}"); if (!$q->ok) { echo $q->mysql_error_html(); } while ($ligne = mysql_fetch_assoc($results)) { $reverse = null; if ($ligne["reverse"] == 1) { $reverse = "<strong>{$not}</strong> "; } $linkipaddr = $boot->trswitch("Loadjs('{$page}?js-item=yes&ID={$ligne["ID"]}&groupid={$ligne["groupid"]}&servername={$_GET["servername"]}')"); $ligne["token"] = $tpl->_ENGINE_parse_body("{{$ligne["token"]}}"); $delete = imgsimple("delete-24.png", null, "Loadjs('{$page}?delete-item-js={$ligne["ID"]}&ID={$ligne["ID"]}')"); $tr[] = "\n\t<tr id='{$ligne["ID"]}'>\n\t<td {$linkipaddr} width='30%' nowrap><i class='icon-list-alt'></i> {$ligne["token"]}</a></td>\n\t<td {$linkipaddr} width='70%' nowrap><i class='icon-list-alt'></i> {$reverse}{$ligne["pattern"]}</a></td>\n\t<td style='text-align:center' width='24px' nowrap>{$delete}</td>\n\t</tr>"; } $html = $boot->TableCompile(array("token" => "{token}", "pattern" => "{pattern}", "delete" => "{delete}"), $tr); echo $tpl->_ENGINE_parse_body($html); }
function section_dump_table_search() { $t = $_GET["t"]; $tpl = new templates(); $MyPage = CurrentPageName(); $q = new mysql_squid_builder(); $users = new usersMenus(); $sock = new sockets(); $boot = new boostrap_form(); $table = date("Ymd", $_GET["xtime"]) . "_hour"; $searchstring = string_to_flexquery("dump-table-search"); $ORDER = $boot->TableOrder(array("size" => "DESC")); $sql = "SELECT * FROM {$table} WHERE 1 {$searchstring} ORDER BY {$ORDER} LIMIT 0,250"; $results = $q->QUERY_SQL($sql); $TABLE_GET_COLUMNS = $q->TABLE_GET_COLUMNS($table); if (!$q->ok) { senderrors($q->mysql_error . "<br>{$sql}"); } while ($ligne = mysql_fetch_assoc($results)) { $md = md5(serialize($ligne)); $ligne["size"] = FormatBytes($ligne["size"] / 1024); $sitenameenc = urlencode($ligne["familysite"]); $js = "Loadjs('miniadm.webstats.familysite.all.php?familysite={$sitenameenc}')"; $link = $boot->trswitch($js); $tr[] = "<tr id='{$md}'>"; reset($TABLE_GET_COLUMNS); while (list($index, $field) = each($TABLE_GET_COLUMNS)) { $tr[] = "<td style='font-size:11px' width=1% nowrap>{$ligne[$field]}</td>"; } $tr[] = "</tr>"; } reset($TABLE_GET_COLUMNS); while (list($index, $field) = each($TABLE_GET_COLUMNS)) { $array[$field] = $field; } echo $boot->TableCompile($array, $tr); }