function synthesis() { $page = CurrentPageName(); $tpl = new templates(); $q = new mysql_squid_builder(); $table = $_GET["table"]; $user = $_GET["user"]; $field = $_GET["field"]; $t = $_GET["divkey"]; $year = substr($table, 0, 4); $month = substr($table, 4, 2); $day = substr($table, 6, 2); $time = strtotime("{$year}-{$month}-{$day} 00:00:00"); $dayTitle = date('{l}, {F} Y', $time); $TITLE_PAGE = "«{$user}» ({{$field}}) <br>{$dayTitle}"; if ($field == "MAC") { $userText = $q->UID_FROM_MAC($user); if ($userText != null) { $TITLE_PAGE = "{$userText} ({$user}) <br>{$dayTitle}"; } } $html = "\n\t\n\t<table style='width:99%' class=form>\n\t<tbody>\n\t<tr>\n\t\t<td width=1%><img src='img/postmaster-48.png'></td>\n\t\t<td><div style='width:100%;font-size:16px;font-weight:bold'>{$TITLE_PAGE}</div></td>\n\t</tr>\n\t</tbody>\n\t</table>\n\t<table style='width:100%'>\n\t<tbody>\n\t\t<tr>\n\t\t\t<td width=50% valign='top'><div id='paragraphe1'></div></td>\n\t\t\t<td width=50% valign='top'><div id='paragraphe2'></div></td>\n\t\t</tr>\n\t</tbody>\n\t</table>\n\t<script>\n\t\tfunction LoadUserSearchSection(){\n\t\t\tif(!document.getElementById('week-search-users-list')){alert('week-search-users-list no such id');}\n\t\t\tLoadAjaxTiny('week-search-users-list','{$page}?users-form=yes&table={$table}&user={$user}&field={$field}');\n\t\t}\n\t\t\n\t\tLoadUserSearchSection();\n\t</script>\n\t\t\t\n\t\n\t"; echo $tpl->_ENGINE_parse_body($html); }
function uris_list() { $q = new mysql_squid_builder(); $MyPage = CurrentPageName(); $tpl = new templates(); if ($_GET["field"] == "ipaddr") { $_GET["field"] = "CLIENT"; } $_GET["xtime"] = strtotime("{$_GET["day"]} 00:00:00"); $page = 1; if (isset($_POST['rp'])) { $rp = $_POST['rp']; } if (isset($_POST["sortname"])) { if ($_POST["sortname"] != null) { $ORDER = "ORDER BY {$_POST["sortname"]} {$_POST["sortorder"]}"; } } if (isset($_POST['page'])) { $page = $_POST['page']; } $pageStart = ($page - 1) * $rp; $limitSql = "LIMIT {$pageStart}, {$rp}"; $tablesource = "dansguardian_events_" . date("Ymd", $_GET["xtime"]); $table = "(SELECT DATE_FORMAT(zDate,'%Hh') as zDate,QuerySize as size,hits,uri FROM {$tablesource} WHERE {$_GET["field"]}='{$_GET["value"]}' AND sitename LIKE '%{$_GET["familysite"]}') as t"; $searchstring = string_to_flexquery(); if ($searchstring != null) { $sql = "SELECT COUNT(*) as TCOUNT FROM {$table} WHERE 1 {$searchstring}"; $ligne = mysql_fetch_array($q->QUERY_SQL($sql)); $total = $ligne["TCOUNT"]; } else { $sql = "SELECT COUNT(*) as TCOUNT FROM {$table} WHERE 1"; $ligne = mysql_fetch_array($q->QUERY_SQL($sql)); $total = $ligne["TCOUNT"] + 1; } $sql = "SELECT * FROM {$table} WHERE 1 {$searchstring} {$ORDER} {$limitSql}"; $line = $tpl->_ENGINE_parse_body("{line}"); writelogs($sql, __FUNCTION__, __FILE__, __LINE__); $results = $q->QUERY_SQL($sql, "artica_events"); $data = array(); $data['page'] = $page; $data['total'] = $total; $data['rows'] = array(); if (mysql_num_rows($results) == 0) { json_error_show("No data {$sql}"); } $style = "style='font-size:12px'"; while ($ligne = @mysql_fetch_array($results, MYSQL_ASSOC)) { $style = "style='font-size:12px'"; if ($ligne["size"] > 10000000) { $style = "style='font-size:12px;font-weight:bold'"; } if (trim($ligne["category"]) == null) { $ligne["category"] = "<span style='color:#D70707'>{categorize_this_website}</span>"; } $id = md5(@implode("", $ligne)); if (trim($ligne["uid"]) == "-") { $ligne["uid"] = null; } if (trim($ligne["uid"]) == null) { $ligne["uid"] = $q->UID_FROM_MAC($ligne["MAC"]); } $ttz = $ligne["size"]; $ligne["size"] = FormatBytes($ligne["size"] / 1024); $data['rows'][] = array('id' => $id, 'cell' => array("<span {$style}>{$ligne["zDate"]}</span>", "<span {$style}>{$ligne["uri"]}</span>", "<span {$style}>{$ligne["size"]}</span>", "<span {$style}>{$ligne["hits"]}</span>")); } echo json_encode($data); }
function rows_members() { $tpl = new templates(); $MyPage = CurrentPageName(); $q = new mysql_squid_builder(); $day = $_GET["day"]; $time = strtotime("{$day} 00:00:00"); $table = date("Ymd", $time) . "_hour"; $textcss = "<span style='font-size:12px'>"; $search = '%'; $page = 1; $total = 0; if ($q->COUNT_ROWS($table, "artica_events") == 0) { $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 = "HAVING (`{$_POST["qtype"]}` LIKE '{$search}')"; $sql = "SELECT SUM(size) as tsize, SUM(hits) as thits,client,uid,MAC,hostname FROM `{$table}` GROUP BY client,uid,MAC,hostname {$searchstring}"; $results = $q->QUERY_SQL($sql, "artica_events"); $total = mysql_numrows($results); } else { $sql = "SELECT SUM(size) as tsize, SUM(hits) as thits,client,uid,MAC,hostname FROM GROUP BY client,uid,MAC,hostname `{$table}`"; $results = $q->QUERY_SQL($sql, "artica_events"); $total = mysql_numrows($results); } if (isset($_POST['rp'])) { $rp = $_POST['rp']; } $pageStart = ($page - 1) * $rp; $limitSql = "LIMIT {$pageStart}, {$rp}"; $sql = "SELECT SUM(size) as tsize, SUM(hits) as thits,client,uid,MAC,hostname FROM `{$table}` GROUP BY client,uid,MAC,hostname {$searchstring} {$ORDER} {$limitSql}"; writelogs($sql, __FUNCTION__, __FILE__, __LINE__); $results = $q->QUERY_SQL($sql, "artica_events"); $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; } while ($ligne = mysql_fetch_assoc($results)) { $jsweb = "\n\t\t<a href=\"javascript:blur()\"\n\t\tOnClick=\"javascript:Loadjs('squid.traffic.statistics.days.php?today-zoom=yes&type=req&familysite={$ligne["familysite"]}&day={$_GET["day"]}')\"\n\t\tstyle='font-size:12px;text-decoration:underline'>"; $jsjscat = "Loadjs('squid.categorize.php?www={$ligne["sitename"]}&day={$_GET["day"]}&week=&month=');"; $jscat = "<a href=\"javascript:blur()\"\n\t\tOnClick=\"javascript:{$jsjscat}\"\n\t\tstyle='font-size:12px;text-decoration:underline'>\n\t\t"; $ligne["tsize"] = FormatBytes($ligne["tsize"] / 1024); $uid = ahref_member("uid", $ligne["uid"], $table); if ($ligne["uid"] == null) { $ligne["uid"] = $q->UID_FROM_MAC($ligne["MAC"]); $uid = $ligne["uid"]; } $data['rows'][] = array('id' => $ligne['MAC'], 'cell' => array($textcss . $uid . "</a></span>", $textcss . ahref_member("hostname", $ligne["hostname"], $table) . "</a></span>", $textcss . ahref_member("client", $ligne["client"], $table) . "</span>", $textcss . ahref_member("MAC", $ligne["MAC"], $table) . "</span>", $textcss . $ligne["thits"] . "</span>", $textcss . $ligne["tsize"] . "</span>")); } echo json_encode($data); }
function youtube_array_to_sql($array) { $q = new mysql_squid_builder(); while (list($key, $val) = each($array)) { $val = str_replace("'", "`", $val); $val = mysql_escape_string2($val); $array[$key] = addslashes($val); } $VIDEOID = $array["VIDEOID"]; $clientip = $array["clientip"]; $username = $array["username"]; $time = $array["time"]; $mac = $array["mac"]; $hostname = $array["hostname"]; if ($username == "-") { $username = null; } if (strlen($username) < 3) { $username = null; } if (!__IsPhysicalAddress($mac)) { $mac = null; } if ($mac == null) { $mac = GetMacFromIP($clientip); } if ($GLOBALS["VERBOSE"]) { echo "{$mac}:: {$VIDEOID} -> \n"; } if (!youtube_infos($VIDEOID)) { youtube_events("youtube_infos:: {$VIDEOID} -> FAILED", __LINE__); } $timeint = strtotime($time); $timeKey = date('YmdH', $timeint); $account = 0; if ($mac != null) { if ($username == null) { $username = $q->UID_FROM_MAC($mac); } } if ($clientip != null) { if ($username == null) { $username = $q->UID_FROM_IP($clientip); } } youtube_events("{$timeKey} => ('{$time}','{$clientip}','{$hostname}','{$username}','{$mac}','{$account}','{$VIDEOID}')", __LINE__); return array($timeKey, "('{$time}','{$clientip}','{$hostname}','{$username}','{$mac}','{$account}','{$VIDEOID}')"); }
function items() { $page = 1; $q = new mysql(); $table = "nmap_scannet"; if (isset($_POST["sortname"])) { if ($_POST["sortname"] != null) { $ORDER = "ORDER BY {$_POST["sortname"]} {$_POST["sortorder"]}"; } } if (isset($_POST['page'])) { $page = $_POST['page']; } if (!$q->TABLE_EXISTS("nmap_scannet", "artica_backup")) { $sql = "CREATE TABLE IF NOT EXISTS `nmap_scannet` (\n\t\t`MAC` varchar(90) NOT NULL,\n\t\t`ipaddr` varchar(90) NOT NULL,\n\t\t`vendor` varchar(90) NOT NULL DEFAULT '',\n\t\t`zDate` datetime NOT NULL,\n\t\tPRIMARY KEY (`MAC`),\n\t\tKEY `ipaddr` (`ipaddr`),\n\t\tKEY `vendor` (`vendor`)\n\t\t) ENGINE=MYISAM;"; $q->QUERY_SQL($sql, "artica_backup"); } $searchstring = string_to_flexquery(); if ($searchstring != null) { $sql = "SELECT COUNT(*) as TCOUNT FROM {$table} WHERE 1 {$searchstring}"; $ligne = mysql_fetch_array($q->QUERY_SQL($sql, "artica_backup")); $total = $ligne["TCOUNT"]; } else { $sql = "SELECT COUNT(*) as TCOUNT FROM {$table}"; $ligne = mysql_fetch_array($q->QUERY_SQL($sql, "artica_backup")); $total = $ligne["TCOUNT"]; } if (isset($_POST['rp'])) { $rp = $_POST['rp']; } if (!is_numeric($rp)) { $rp = 50; } $pageStart = ($page - 1) * $rp; $limitSql = "LIMIT {$pageStart}, {$rp}"; $sql = "SELECT * FROM {$table} WHERE 1 {$searchstring} {$ORDER} {$limitSql}"; if (isset($_GET["verbose"])) { echo "<hr><code>{$sql}</code></hr>"; } $results = $q->QUERY_SQL($sql, "artica_backup"); if (!$q->ok) { json_error_show($q->mysql_error, 1); } if (mysql_num_rows($results) == 0) { json_error_show("{$table} no data", 1); } $fontsize = "26px"; $data = array(); $data['page'] = 1; $data['total'] = mysql_num_rows($results); $data['rows'] = array(); //if(mysql_num_rows($results)==0){$data['rows'][] = array('id' => $ligne[time()],'cell' => array($sql,"", "",""));} $computer = new computers(); $tpl = new templates(); $dhcpfixed = $tpl->_ENGINE_parse_body("{dhcpfixed}"); $q2 = new mysql_squid_builder(); while ($ligne = mysql_fetch_assoc($results)) { $ipaddr = $ligne["ipaddr"]; $infoZ = array(); $mac = strtolower($ligne["MAC"]); $vendor = $ligne["vendor"]; $uid = null; $uid = $computer->ComputerIDFromMAC($mac); $view = " "; $jslink = null; $jsfiche = null; $infos = null; $macenc = urlencode($ligne["MAC"]); if ($uid != null) { $jslink = "<a href=\"javascript:blur();\"\n\t\t\t\tOnClick=\"javascript:" . MEMBER_JS($uid, 1, 1) . "\"\n\t\t\t\tstyle='font-size:{$fontsize};text-decoration:underline'>"; $computer = new computers($uid); if ($computer->dhcpfixed == 1) { $infoZ[] = "<a href=\"javascript:blur();\"\n\t\t\t\t\t\t\tOnClick=\"javascript:Loadjs('dhcpd.fixed.hosts.php?modify-dhcpd-settings-js=yes&mac={$macenc}');\"\n\t\t\t\t\t\t\tstyle='text-decoration:underline'>{$dhcpfixed}</a> - "; } if (trim($computer->DisplayName) != null) { $infoZ[] = $computer->DisplayName; } if (trim($computer->ComputerMachineType) != null) { $infoZ[] = $computer->ComputerMachineType; } if (trim($computer->ComputerOS) != null) { $infoZ[] = $computer->ComputerOS; } $infos = @implode(" - ", $infoZ); } else { $ocs = new ocs($mac); if (trim($ocs->HARDWARE_ID > 0)) { if ($ocs->dhcpfixed == 1) { $infos = "<a href=\"javascript:blur();\"\n\t\t\t\t\t\tOnClick=\"javascript:Loadjs('dhcpd.fixed.hosts.php?modify-dhcpd-settings-js=yes&mac={$macenc}');\n\t\t\t\t\t\tstyle='text-decoration:underline'>{$dhcpfixed}</a> - "; } $infos = $infos . $ocs->ComputerName . " - " . $computer->ComputerOS; } } $macenc = urlencode($mac); $proxy_alias = $q2->UID_FROM_MAC($mac); if ($proxy_alias != null) { $proxy_alias = "\n\t\t\t\t<a href=\"javascript:blur();\"\n\t\t\t\tstyle=\"text-decoration:underline\"\n\t\t\t\tOnClick=\"javascript:Loadjs('squid.nodes.php?node-infos-js=yes&MAC={$macenc}');\"\n\t\t\t\t>{$proxy_alias}</a>"; } if ($proxy_alias == null) { $proxy_alias = $q2->UID_FROM_IP($ipaddr); } if ($proxy_alias == null) { $proxy_alias = "<center>\n\t\t\t\t\t<a href=\"javascript:blur();\" \n\t\t\t\t\tOnClick=\"javascript:Loadjs('squid.nodes.php?link-user-js=yes&MAC={$macenc}&ipaddr={$ipaddr}',true)\"\n\t\t\t\t\t><img src='img/32-plus.png'></a></center>"; } $data['rows'][] = array('id' => md5(serialize($ligne)), 'cell' => array("<span style='font-size:26px'>{$ipaddr}</span>", "<span style='font-size:26px'>{$jslink}{$mac}</a></span>", "<span style='font-size:26px'>{$vendor}</span>", "<span style='font-size:18px'>{$infos}</span>", "<span style='font-size:26px'>{$proxy_alias}</span>")); } echo json_encode($data); }
function ParseDB_FILE($path, $uuid = null, $asmeta = false) { $unix = new unix(); if (!is_file($path)) { return; } echo "Open {$path}\n"; $db_con = dba_open($path, "r", "db4"); if (!$db_con) { if ($asmeta) { meta_admin_mysql(1, "DB open failed {$path}", null, __FILE__, __LINE__); } echo "DB open failed\n"; die; } $mainkey = dba_firstkey($db_con); while ($mainkey != false) { $val = 0; $data = unserialize(dba_fetch($mainkey, $db_con)); $mainkey = dba_nextkey($db_con); if (!is_array($data)) { continue; } $q = new mysql_squid_builder(); $qCommon = new mysql_squid_builder(); if ($uuid != null) { $q = new mysql_stats($uuid); } if ($asmeta) { $q = new mysql_meta(); } if (!isset($data["HOURLY"])) { continue; } if (!isset($data["WWW"])) { continue; } $category = null; $ipaddr = mysql_escape_string2($data["IPADDR"]); if (isset($data["MAC"])) { $mac = mysql_escape_string2($data["MAC"]); } $uid = mysql_escape_string2($data["UID"]); $familysite = mysql_escape_string2($data["WWW"]); if (isset($data["category"])) { $category = mysql_escape_string2($data["category"]); } if ($uid == null) { $uid = $qCommon->UID_FROM_MAC($data["MAC"]); } if ($uid == null) { $uid = $qCommon->UID_FROM_IP($data["IPADDR"]); } $uid = mysql_escape_string2($uid); $length = strlen($ipaddr) + strlen($mac) + strlen($uid) + strlen($familysite); if ($length == 0) { continue; } while (list($day, $array) = each($data["HOURLY"])) { while (list($hour, $size) = each($array)) { $md5 = md5("'{$ipaddr}','{$mac}','{$uid}','{$familysite}','{$day}','{$hour}','{$size}','{$category}'"); $wwwUH[] = "('{$md5}','{$ipaddr}','{$mac}','{$uid}','{$familysite}','{$day}','{$hour}','{$size}','{$category}')"; if ($GLOBALS["VERBOSE"]) { echo "('{$md5}','{$ipaddr}','{$mac}','{$uid}','{$familysite}','{$day}','{$hour}','{$size}','{$category}')\n"; } } } } dba_close($db_con); $TABLE_WEEK_RTTH = "WEEK_RTTH"; $ENGINE = "MEMORY"; if ($asmeta) { $TABLE_WEEK_RTTH = "{$uuid}_WEEK_RTTH"; $ENGINE = "MYISAM"; } if ($asmeta) { xmeta_events("DROP TABLE `{$TABLE_WEEK_RTTH}`", __FUNCTION__, __FILE__, __LINE__); } $q->QUERY_SQL("DROP TABLE `{$TABLE_WEEK_RTTH}`"); if ($asmeta) { xmeta_events("CREATE TABLE `{$TABLE_WEEK_RTTH}`", __FUNCTION__, __FILE__, __LINE__); } $q->QUERY_SQL("CREATE TABLE IF NOT EXISTS `{$TABLE_WEEK_RTTH}` (\n\t\t\t`zmd5` varchar(90) NOT NULL,\n\t\t\t`familysite` varchar(128) NOT NULL,\n\t\t\t`ipaddr` varchar(50) NOT NULL DEFAULT '',\n\t\t\t`day` smallint(2) NOT NULL,\n\t\t\t`hour` smallint(2) NOT NULL,\n\t\t\t`uid` varchar(128) NOT NULL,\n\t\t\t`MAC` varchar(20) NOT NULL,\n\t\t\t`size` BIGINT UNSIGNED NOT NULL,\n\t\t\t`category` varchar(90) NOT NULL,\n\t\t\tPRIMARY KEY `zmd5` (`zmd5`),\n\t\t\tKEY `familysite` (`familysite`),\n\t\t\tKEY `ipaddr` (`ipaddr`),\n\t\t\tKEY `uid` (`uid`),\n\t\t\tKEY `category` (`category`),\n\t\t\tKEY `hour` (`hour`),\n\t\t\tKEY `day` (`day`),\n\t\t\tKEY `MAC` (`MAC`)\n\t) ENGINE={$ENGINE};"); if (!$q->ok) { if ($asmeta) { meta_admin_mysql(1, "MySQL error", $q->mysql_error, __FILE__, __LINE__); } echo $q->mysql_error; return; } $q->QUERY_SQL("INSERT IGNORE INTO `{$TABLE_WEEK_RTTH}` ( `zmd5`,`ipaddr`,`MAC`,`uid`,familysite,`day`,`hour`,`size`,`category`) VALUES " . @implode(",", $wwwUH)); if (!$q->ok) { if ($asmeta) { meta_admin_mysql(1, "MySQL error", $q->mysql_error, __FILE__, __LINE__); } echo $q->mysql_error; return; } if ($asmeta) { xmeta_events("Success parsing {$path} adding " . count($wwwUH) . " elements", __FUNCTION__, __FILE__, __LINE__); return; } $sock = new sockets(); $EnableArticaMetaClient = intval($sock->GET_INFO("EnableArticaMetaClient")); $EnableSquidRemoteMySQL = intval($sock->GET_INFO("EnableSquidRemoteMySQL")); if ($EnableSquidRemoteMySQL == 1) { return; } if ($EnableArticaMetaClient == 0) { return; } $DIR_TEMP = $unix->TEMP_DIR(); if (!$unix->compress($path, "{$DIR_TEMP}/SQUID_QUOTASIZE.gz")) { meta_admin_mysql(1, "Unable to compress {$path}", null, __FILE__, __LINE__); @unlink("{$DIR_TEMP}/SQUID_QUOTASIZE.gz"); return; } $artica_meta = new artica_meta(); if (!$artica_meta->SendFile("{$DIR_TEMP}/SQUID_QUOTASIZE.gz", "SQUID_QUOTASIZE")) { meta_admin_mysql(1, "Unable to updload {$DIR_TEMP}/SQUID_QUOTASIZE.gz", null, __FILE__, __LINE__); } @unlink("{$DIR_TEMP}/SQUID_QUOTASIZE.gz"); }
function SearchComputers() { $tpl = new templates(); $MyPage = CurrentPageName(); $sock = new sockets(); $EnableIntelCeleron = intval($sock->GET_INFO("EnableIntelCeleron")); $q = new mysql(); $sock = new sockets(); $fontsize = "14px"; $cs = 0; $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"); } 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"); } if (isset($_POST['rp'])) { $rp = $_POST['rp']; } $pageStart = ($page - 1) * $rp; $limitSql = "LIMIT {$pageStart}, {$rp}"; $table = "(SELECT networks.HARDWARE_ID,networks.MACADDR,networks.STATUS,networks.IPADDRESS,networks.isActive,\n\t\t\thardware.* FROM networks,hardware WHERE networks.HARDWARE_ID=hardware.ID) as t"; $searchstring = string_to_flexquery(); if ($searchstring != null) { $sql = "SELECT COUNT(*) as TCOUNT FROM {$table} WHERE 1 {$searchstring}"; $ligne = mysql_fetch_array($q->QUERY_SQL($sql, "ocsweb")); if (!$q->ok) { json_error_show($q->mysql_error . "<br>{$sql}"); } $total = $ligne["TCOUNT"]; } else { $sql = "SELECT COUNT(*) as TCOUNT FROM {$table} WHERE 1"; $ligne = mysql_fetch_array($q->QUERY_SQL($sql, "ocsweb")); if (!$q->ok) { json_error_show($q->mysql_error . "<br>{$sql}"); } $total = $ligne["TCOUNT"]; } if (isset($_POST['rp'])) { $rp = $_POST['rp']; } if (isset($_POST["sortname"])) { if ($_POST["sortname"] != null) { $ORDER = "ORDER BY {$_POST["sortname"]} {$_POST["sortorder"]}"; } } if (isset($_POST['page'])) { $page = $_POST['page']; } $data = array(); $data['page'] = $page; $data['total'] = $total; $data['rows'] = array(); $sql = "SELECT * FROM {$table} WHERE 1 {$searchstring} {$ORDER} {$limitSql}"; writelogs($sql, __FUNCTION__, __FILE__, __LINE__); $results = $q->QUERY_SQL($sql, "ocsweb"); if (!$q->ok) { json_error_show($q->mysql_error . "<hr>{$sql}"); } if (mysql_num_rows($results) == 0) { json_error_show("no data"); } $users = new usersMenus(); $DHC_MAIN = false; if ($users->dhcp_installed) { $EnableDHCPServer = intval($sock->GET_INFO('EnableDHCPServer')); if ($EnableDHCPServer == 1) { $DHC_MAIN = true; } } $SQUID_MAIN = false; if ($users->SQUID_INSTALLED) { $SQUID_MAIN = true; } $fontsize = "22px"; $computer = new computers(); $q2 = new mysql_squid_builder(); while ($ligne = mysql_fetch_array($results, MYSQL_ASSOC)) { if ($ligne["MACADDR"] == "unknown") { continue; } $ligne["MACADDR"] = strtolower($ligne["MACADDR"]); $HARDWARE_ID = $ligne["HARDWARE_ID"]; $uid = null; $OSNAME = null; if ($ligne["OSNAME"] == "Unknown") { $ligne["OSNAME"] = null; } $color = "#7D7D7D"; $md = md5($ligne["MACADDR"]); $uri = strtolower($ligne["NAME"]); if ($EnableIntelCeleron == 0) { $uid = $computer->ComputerIDFromMAC($ligne["MACADDR"]); } $view = " "; $jslink = null; $jsfiche = null; $ISDB = "ok32-grey.png"; $DHCP = "ok32-none.png"; $SQUID = "ok32-none.png"; if ($DHC_MAIN) { $DHCP = "ok32-grey.png"; if ($computer->dhcpfixedFromMac($ligne["MACADDR"])) { $DHCP = "ok32.png"; } } if ($SQUID_MAIN) { $ligne2 = mysql_fetch_array($q2->QUERY_SQL("SELECT enabled FROM computers_time WHERE `MAC`='{$ligne["MACADDR"]}'", "artica_backup")); if (intval($ligne2["enabled"]) != 0) { $SQUID = "warning24.png"; } } if ($uid != null) { $ISDB = "ok32.png"; $jsfiche = MEMBER_JS($uid, 1, 1); $view = "<a href=\"javascript:blur();\" \n\t\t\tOnClick=\"javascript:{$jsfiche}\" \n\t\t\tstyle='font-size:{$fontsize};text-decoration:underline'>" . str_replace("\$", "", strtolower($uid)) . "</a>"; $jslink = "<a href=\"javascript:blur();\" \n\t\t\tOnClick=\"javascript:{$jsfiche}\" \n\t\t\tstyle='font-size:{$fontsize};text-decoration:underline'>"; } else { $uid = $ligne["NAME"]; if (preg_match("#^[0-9]+\\.[0-9]+\\.[0-9]+#", $uid)) { $q = new mysql_squid_builder(); $NAME2 = $q->UID_FROM_MAC($ligne["MACADDR"]); if ($NAME2 != null) { $uid = $NAME2; } } if ($uid == null) { $uid = "Unknown"; } $jsfiche = "Loadjs('domains.computer.autoadd.php?mac=" . urlencode($ligne["MACADDR"]) . "&ipaddr=" . urlencode($ligne["IPADDRESS"]) . "&computername=" . urlencode($uid) . "&t={$_GET["t"]}')"; if ($EnableIntelCeleron == 1) { $jsfiche = "Loadjs('domains.computer.mysql.php?HARDWARE_ID={$HARDWARE_ID}&t={$_GET["t"]}')"; } $jslink = "<a href=\"javascript:blur();\"\n\t\t\tOnClick=\"javascript:{$jsfiche}\"\n\t\t\tstyle='font-size:{$fontsize};text-decoration:underline'>"; $view = "<a href=\"javascript:blur();\"\n\t\t\tOnClick=\"javascript:{$jsfiche}\"\n\t\t\tstyle='font-size:{$fontsize};text-decoration:underline'>{$uid}</a>"; } $js[] = "LoadAjaxTiny('cmp-{$md}','{$page}?compt-status={$ligne["IPADDRESS"]}');"; $icon = "<img src='img/{$ISDB}'>"; if ($ligne["OSNAME"] != null) { $OSNAME = "<div style='font-size:9px'><i>{$ligne["OSNAME"]}</i></div>"; } if ($_GET["callback"] != null) { $color = "black"; if ($_GET["fullvalues"] == 1) { $viewjs = "{$_GET["callback"]}('{$uid}','{$ligne["IPADDRESS"]}','{$ligne["MACADDR"]}')"; } else { $viewjs = "{$_GET["callback"]}('{$uid}')"; } $view = "<a href=\"javascript:blur();\" \n\t\t\t\t\t\tOnClick=\"javascript:{$viewjs}\" \n\t\t\t\t\t\tstyle='font-size:{$fontsize};text-decoration:underline'>" . str_replace("\$", "", strtolower($uid)) . "</a>"; $icon = imgtootltip("arrow-blue-left-32.png", null, $viewjs); } 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>"; } $macenc = urlencode($ligne["MACADDR"]); $ipenc = urlencode($ligne["IPADDRESS"]); $jsDelete = "Loadjs('{$MyPage}?delete-computer-js=yes&MAC={$macenc}&t={$_GET["t"]}');"; $alias = $q2->UID_FROM_MAC($ligne["MACADDR"]); if ($alias != null) { $alias_uri = "Loadjs('squid.nodes.php?node-infos-js=yes&MAC={$macenc}');"; } if ($alias == null) { $alias = $q2->UID_FROM_IP($ligne["IPADDRESS"]); if ($alias != null) { $alias_uri = "Loadjs('squid.nodes.php?node-infos-js=yes&ipaddr={$ipenc}');"; } } if ($alias == null) { $alias = "<center><img src='img/32-plus.png'></center>"; $alias_uri = "Loadjs('squid.nodes.php?link-user-js=yes&MAC={$macenc}&ipaddr={$ipenc}',true)"; } if ($EnableIntelCeleron == 1) { $jsfiche = "Loadjs('domains.computer.mysql.php?HARDWARE_ID={$HARDWARE_ID}&t={$_GET["t"]}')"; } $cs++; $data['rows'][] = array('id' => md5(serialize($ligne)), 'cell' => array($view . $zdate, "<span style='font-size:{$fontsize}'>{$jslink}{$ligne["IPADDRESS"]}</a></span>", "<span style='font-size:{$fontsize}'>{$jslink}{$ligne["MACADDR"]}</a></span>", "<span style='font-size:{$fontsize}'><a href=\"javascript:blur();\" \n\t\t\tOnClick=\"javascript:{$alias_uri}\" style='text-decoration:underline'>{$alias}</a></span>", "<center><a href=\"javascript:blur();\" OnClick=\"javascript:{$jsfiche}\">{$icon}</a></center>", "<center><a href=\"javascript:blur();\" OnClick=\"javascript:{$jsfiche}\"><img src='img/{$DHCP}'></center></a>", "<center><a href=\"javascript:blur();\" OnClick=\"javascript:{$jsfiche}\"><img src='img/{$SQUID}'></center></a>", "<center><a href=\"javascript:blur();\" OnClick=\"javascript:{$jsDelete}\"><img src='img/delete-32.png'></center></a>")); } if ($cs > $_POST["rp"]) { $data['total'] = $cs; echo json_encode($data); return; } if ($cs == 0) { json_error_show("no item"); } $data['total'] = $cs; echo json_encode($data); }
function search() { $Mypage = CurrentPageName(); $tpl = new templates(); $q = new mysql_squid_builder(); $t = time(); $fontsize = 13; $type = $_GET["type"]; $field_query = "size"; $field_query2 = "SUM(size)"; $table_field = "{size}"; $category = $tpl->_ENGINE_parse_body("{category}"); $table = "WEEK_RTTH"; $member = $tpl->_ENGINE_parse_body("{member}"); $sitename = $tpl->_ENGINE_parse_body("{website}"); $search = '%'; $page = 1; $ORDER = "ORDER BY ID DESC"; $ip = new IP(); $Select = "MAC"; $FORCE_FILTER = " AND `MAC`='{$_GET["MAC"]}'"; if ($ip->isIPAddress($_GET["ipaddr"])) { $Select = "ipaddr"; $FORCE_FILTER = "ipaddr='{$_GET["ipaddr"]}'"; } if ($ip->IsvalidMAC($_GET["MAC"])) { $Select = "MAC"; $FORCE_FILTER = "MAC='{$_GET["MAC"]}'"; } $table = "(SELECT `day`,SUM(size) as size,{$Select} FROM WEEK_RTTH GROUP BY `day`,{$Select} HAVING {$FORCE_FILTER}) as t"; 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']; } $search = string_to_flexquery(); if ($search != null) { $sql = "SELECT COUNT(*) as TCOUNT FROM {$table}"; $ligne = mysql_fetch_array($q->QUERY_SQL($sql)); $total = $ligne["TCOUNT"]; } else { $sql = "SELECT COUNT(*) as TCOUNT FROM {$table}"; $ligne = mysql_fetch_array($q->QUERY_SQL($sql)); $total = $ligne["TCOUNT"]; } if (isset($_POST['rp'])) { $rp = $_POST['rp']; } $pageStart = ($page - 1) * $rp; $limitSql = "LIMIT {$pageStart}, {$rp}"; $sql = "SELECT* FROM {$table} WHERE 1 {$search} {$ORDER} {$limitSql}"; $results = $q->QUERY_SQL($sql); $data = array(); $data['page'] = 0; $data['total'] = $total; $data['rows'] = array(); if (!$q->ok) { json_error_show($q->mysql_error); } if (mysql_num_rows($results) == 0) { json_error_show("no data"); } $data['total'] = mysql_num_rows($results); $style = "style='font-size:22px'"; while ($ligne = @mysql_fetch_array($results, MYSQL_ASSOC)) { $ligne["size"] = FormatBytes($ligne["size"] / 1024); $categorize = "Loadjs('squid.categorize.php?www={$ligne["sitename"]}')"; if (trim($ligne["category"]) == null) { $ligne["category"] = "<span style='color:#D70707'>{categorize_this_website}</span>"; } $id = md5(@implode("", $ligne)); if (trim($ligne["uid"]) == "-") { $ligne["uid"] = null; } if (trim($ligne["uid"]) == null) { $ligne["uid"] = $q->UID_FROM_MAC($ligne["MAC"]); } if (trim($ligne["uid"]) == null) { $ligne["uid"] = $q->UID_FROM_IP($ligne["CLIENT"]); } $categorize = "<a href=\"javascript:blur()\" \n\t\tOnClick=\"javascript:{$categorize}\" \n\t\tstyle='font-size:{$fontsize}px;text-decoration:underline'>"; $familysite = $q->GetFamilySites($ligne["sitename"]); $TrafficHour = "<a href=\"javascript:blur()\" \n\t\tOnClick=\"javascript:Loadjs('squid.traffic.statistics.hours.php?familysite={$ligne["sitename"]}&day={$_GET["day"]}')\" \n\t\tstyle='font-size:{$fontsize}px;text-decoration:underline'>"; $dd = date("Y-m"); $D = $q->time_to_date(strtotime("{$dd}-{$ligne["day"]} 00:00:00")); $data['rows'][] = array('id' => $id, 'cell' => array("<span {$style}>{$D}</span>", "<span {$style}>{$ligne["size"]}</a></span>")); } echo json_encode($data); }
function today_zoom_popup_history_list(){ $Mypage=CurrentPageName(); $tpl=new templates(); $q=new mysql_squid_builder(); $t=time(); $fontsize=13; $type=$_GET["type"]; $field_query="size"; $field_query2="SUM(size)"; $table_field="{size}"; $category=$tpl->_ENGINE_parse_body("{category}"); if($_GET["day"]==date('Y-m-d')){$_GET["day"]=$q->HIER();} $hour_table=date('Ymd',strtotime($_GET["day"]))."_hour"; $member=$tpl->_ENGINE_parse_body("{member}"); $sitename=$tpl->_ENGINE_parse_body("{website}"); if (isset($_POST['rp'])) {$rp = $_POST['rp'];} if(isset($_POST["sortname"])){if($_POST["sortname"]<>null){$ORDER="ORDER BY {$_POST["sortname"]} {$_POST["sortorder"]}";}} if (isset($_POST['page'])) {$page = $_POST['page'];} $pageStart = ($page-1)*$rp; $limitSql = "LIMIT $pageStart, $rp"; if($type=="req"){ $field_query="hits"; $field_query2="SUM(hits)"; $table_field="{hits}"; } $table="(SELECT $field_query2 as thits, uid,client,MAC,sitename,category,familysite FROM $hour_table GROUP BY uid,client,sitename,MAC,category,familysite HAVING familysite='{$_GET["familysite"]}' ) as t"; $searchstring=string_to_flexquery(); if($searchstring<>null){ $sql="SELECT COUNT(*) as TCOUNT FROM $table WHERE 1 $searchstring"; $ligne=mysql_fetch_array($q->QUERY_SQL($sql)); $total = $ligne["TCOUNT"]; }else{ $sql="SELECT COUNT(*) as TCOUNT FROM $table WHERE 1"; $ligne=mysql_fetch_array($q->QUERY_SQL($sql)); $total = $ligne["TCOUNT"]+1; } $sql="SELECT * FROM $table WHERE 1 $searchstring $ORDER $limitSql"; $results=$q->QUERY_SQL($sql); $data = array(); $data['page'] = 0; $data['total'] = $total; $data['rows'] = array(); if(!$q->ok){json_error_show($q->mysql_error);}; if(mysql_num_rows($results)==0){json_error_show("No data");} $data['total'] = mysql_num_rows($results); $style="style='font-size:{$fontsize}px'"; while($ligne=@mysql_fetch_array($results,MYSQL_ASSOC)){ if($type<>"req"){$ligne["thits"]=FormatBytes($ligne["thits"]/1024);} $categorize="Loadjs('squid.categorize.php?www={$ligne["sitename"]}')"; if(trim($ligne["category"])==null){$ligne["category"]="<span style='color:#D70707'>{categorize_this_website}</span>";} $id=md5(@implode("", $ligne)); if(trim($ligne["uid"])=="-"){$ligne["uid"]=null;} if(trim($ligne["uid"])==null){$ligne["uid"]=$q->UID_FROM_MAC($ligne["MAC"]);} $categorize="<a href=\"javascript:blur()\" OnClick=\"javascript:$categorize\" style='font-size:{$fontsize}px;text-decoration:underline'>"; $familysite=$q->GetFamilySites($ligne["sitename"]); $TrafficHour="<a href=\"javascript:blur()\" OnClick=\"javascript:Loadjs('squid.traffic.statistics.hours.php?familysite={$ligne["sitename"]}&day={$_GET["day"]}')\" style='font-size:{$fontsize}px;text-decoration:underline'>"; $data['rows'][] = array( 'id' => $id, 'cell' => array( "<span $style>{$ligne["uid"]}</span>", "<span $style>{$ligne["MAC"]}</span>", "<span $style>{$ligne["client"]}</span>", "<span $style>$TrafficHour{$ligne["sitename"]}</a></span>", "<span $style>{$ligne["thits"]}</span>", "<span $style>$categorize{$ligne["category"]}</a></span>" ) ); } echo json_encode($data); }
function items() { $t = $_GET["t"]; $tpl = new templates(); $MyPage = CurrentPageName(); $q = new mysql_squid_builder(); $uid = $_GET["uid"]; $users = new usersMenus(); $sock = new sockets(); if (!$users->AsMailBoxAdministrator) { $uid = $_SESSION["uid"]; } $search = '%'; $table = "UserAuthDaysGrouped"; $database = "artica_backup"; $page = 1; $FORCE_FILTER = null; if (isset($_GET["ByUid"])) { $FORCE_FILTER = " AND LENGTH(uid)>1"; } if (isset($_GET["ByMAC"])) { $FORCE_FILTER = " AND LENGTH(MAC)>1"; } if (!$q->TABLE_EXISTS($table, $database)) { json_error_show("{$table} doesn't exists..."); } if ($q->COUNT_ROWS($table, $database) == 0) { json_error_show("No rules"); } if (isset($_POST["sortname"])) { if ($_POST["sortname"] != null) { $ORDER = "ORDER BY {$_POST["sortname"]} {$_POST["sortorder"]}"; } } if (isset($_POST['page'])) { $page = $_POST['page']; } $searchstring = string_to_flexquery(); if ($searchstring != null) { $sql = "SELECT COUNT(*) as TCOUNT FROM {$table} WHERE 1 {$FORCE_FILTER} {$searchstring}"; $ligne = mysql_fetch_array($q->QUERY_SQL($sql, $database)); $total = $ligne["TCOUNT"]; } else { $sql = "SELECT COUNT(*) as TCOUNT FROM {$table} WHERE 1 {$FORCE_FILTER}"; $ligne = mysql_fetch_array($q->QUERY_SQL($sql, $database)); $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, $database); $data = array(); $data['page'] = $page; $data['total'] = $total; $data['rows'] = array(); if (!$q->ok) { json_error_show($q->mysql_error); } while ($ligne = mysql_fetch_assoc($results)) { $zmd5 = md5(serialize($ligne)); $delete = imgsimple("delete-24.png", "", "Delete{$t}('{$zmd5}')"); $enabled = Field_checkbox("enable_{$zmd5}", 1, $ligne["enabled"], "Enable{$t}('{$zmd5}')"); $color = "black"; $urljs = "<a href=\"javascript:blur();\" \n\tOnClick=\"javascript:GItem{$t}('{$zmd5}','{$ligne["imapserv"]}/{$ligne["account"]}')\"\n\tstyle='font-size:14px;text-decoration:underline;color:{$color}'>"; $ligne["hits"] = numberFormat($ligne["hits"], 0, "", " "); $ligne["QuerySize"] = FormatBytes($ligne["QuerySize"] / 1024); if ($ligne["MAC"] != null) { if (strlen($ligne["uid"]) < 2) { $ligne["uid"] = $q->UID_FROM_MAC($ligne["MAC"]); } } if ($ligne["ipaddr"] != null) { if ($ligne["uid"] == null) { $ligne["uid"] = $q->UID_FROM_IP($ligne["ipaddr"]); } } $data['rows'][] = array('id' => "{$zmd5}", 'cell' => array("<span style='font-size:14px;color:{$color}'>{$urljs}{$ligne["ipaddr"]}</a></span>", "<span style='font-size:14px;color:{$color}'>{$urljs}{$ligne["MAC"]}</a></span>", "<span style='font-size:14px;color:{$color}'>{$urljs}{$ligne["hostname"]}</a></span>", "<span style='font-size:14px;color:{$color}'>{$urljs}{$ligne["uid"]}</span>", "<span style='font-size:14px;color:{$color}'>{$urljs}{$ligne["QuerySize"]}</span>", "<span style='font-size:14px;color:{$color}'>{$ligne["hits"]}</span>")); } echo json_encode($data); }
function today_zoom_popup_history_list(){ $Mypage=CurrentPageName(); $tpl=new templates(); $q=new mysql_squid_builder(); $t=time(); $fontsize=13; $type=$_GET["type"]; $field_query="size"; $field_query2="SUM(size)"; $table_field="{size}"; $category=$tpl->_ENGINE_parse_body("{category}"); $hour_table=date('Ymd',strtotime($_GET["day"]))."_hour"; $member=$tpl->_ENGINE_parse_body("{member}"); $sitename=$tpl->_ENGINE_parse_body("{website}"); if($type=="req"){ $field_query="hits"; $field_query2="SUM(hits)"; $table_field="{hits}"; } $sql="SELECT $field_query2 as thits, uid,client,MAC,sitename,category,familysite FROM $hour_table GROUP BY uid,client,sitename,MAC,category,familysite HAVING familysite='{$_GET["familysite"]}' ORDER BY thits DESC LIMIT 0,100"; $results=$q->QUERY_SQL($sql); $data = array(); $data['page'] = 0; $data['total'] = $total; $data['rows'] = array(); if(!$q->ok){$data['rows'][] = array('id' => $ligne[time()],'cell' => array($sql,"$q->mysql_error", "",""));echo json_encode($data);return;} if(mysql_num_rows($results)==0){array('id' => $ligne[time()],'cell' => array(null,"", "",""));echo json_encode($data);return;} $data['total'] = mysql_num_rows($results); $style="style='font-size:{$fontsize}px'"; while($ligne=@mysql_fetch_array($results,MYSQL_ASSOC)){ if($type<>"req"){$ligne["thits"]=FormatBytes($ligne["thits"]/1024);} $categorize="Loadjs('squid.categorize.php?www={$ligne["sitename"]}')"; if(trim($ligne["category"])==null){$ligne["category"]="<span style='color:#D70707'>{categorize_this_website}</span>";} $id=md5(@implode("", $ligne)); if(trim($ligne["uid"])=="-"){$ligne["uid"]=null;} if(trim($ligne["uid"])==null){$ligne["uid"]=$q->UID_FROM_MAC($ligne["MAC"]);} $categorize="<a href=\"javascript:blur()\" OnClick=\"javascript:$categorize\" style='font-size:{$fontsize}px;text-decoration:underline'>"; $familysite=$q->GetFamilySites($ligne["sitename"]); $TrafficHour="<a href=\"javascript:blur()\" OnClick=\"javascript:Loadjs('squid.traffic.statistics.hours.php?familysite={$ligne["sitename"]}&day={$_GET["day"]}')\" style='font-size:{$fontsize}px;text-decoration:underline'>"; $data['rows'][] = array( 'id' => $id, 'cell' => array( "<span $style>{$ligne["uid"]}</span>", "<span $style>{$ligne["MAC"]}</span>", "<span $style>{$ligne["client"]}</span>", "<span $style>$TrafficHour{$ligne["sitename"]}</a></span>", "<span $style>{$ligne["thits"]}</span>", "<span $style>$categorize{$ligne["category"]}</a></span>" ) ); } echo json_encode($data); }