function SaveRedirList() { global $SAMSConf; global $USERConf; $DB = new SAMSDB(); $lang = "./lang/lang.{$SAMSConf->LANG}"; require $lang; if ($USERConf->ToWebInterfaceAccess("LC") != 1) { exit; } if (isset($_GET["id"])) { $id = $_GET["id"]; } $num_rows = $DB->samsdb_query_value("SELECT * FROM redirect WHERE s_redirect_id='{$id}' "); $row = $DB->samsdb_fetch_array(); PageTop("export_48.jpg", "{$redir_exporturllist1} <FONT COLOR=\"BLUE\">{$row['s_name']}</FONT>"); $DB->free_samsdb_query(); $filename = strftime("urllist-%d%b%Y-%H-%M-%S.txt"); $fout = fopen("data/{$filename}", "w"); if ($fout == FALSE) { echo "can't open sams config file data/{$filename}<BR>"; exit(0); } $num_rows = $DB->samsdb_query_value("SELECT * FROM url WHERE s_redirect_id='{$id}' "); while ($row = $DB->samsdb_fetch_array()) { fwrite($fout, "{$row['s_url']}\n"); } fclose($fout); print "<A HREF=\"data/{$filename}\">\n"; print "<BR>{$redir_exporturllist2} \n"; print "</A>\n"; }
function UpdateGroupForm() { global $SAMSConf; global $USERConf; $DB = new SAMSDB(); $lang = "./lang/lang.{$SAMSConf->LANG}"; require $lang; if (isset($_GET["id"])) { $id = $_GET["id"]; } if ($USERConf->ToWebInterfaceAccess("C") != 1) { exit; } $num_rows = $DB->samsdb_query_value("SELECT * FROM sgroup WHERE s_group_id='{$id}' "); $row = $DB->samsdb_fetch_array(); PageTop("shablon.jpg", "{$groupbuttom_0_prop_UpdateGroupForm_1} <FONT COLOR=\"BLUE\">{$row['s_name']}</FONT>"); print "<FORM NAME=\"UPDATEGROUP\" ACTION=\"main.php\">\n"; print "<INPUT TYPE=\"HIDDEN\" NAME=\"show\" value=\"exe\">\n"; print "<INPUT TYPE=\"HIDDEN\" NAME=\"function\" value=\"updategroup\">\n"; print "<INPUT TYPE=\"HIDDEN\" NAME=\"filename\" value=\"groupbuttom_0_prop.php\">\n"; print "<INPUT TYPE=\"HIDDEN\" NAME=\"id\" value=\"{$id}\">\n"; print "<TABLE BORDER=0>\n"; print "<TR>\n"; print "<TD><B>{$groupbuttom_0_prop_UpdateGroupForm_2}: </B>\n"; print "<TD><INPUT TYPE=\"TEXT\" NAME=\"nick\" SIZE=30 VALUE=\"{$row['s_name']}\"> \n"; print "</TABLE>\n"; /* calendar */ print "<BR><INPUT TYPE=\"SUBMIT\" value=\"{$shablonbuttom_1_prop_UpdateShablonForm_7}\">\n"; print "</FORM>\n"; }
function redirbuttom_3_deletelist() { global $SAMSConf; global $USERConf; $DB = new SAMSDB(); $lang = "./lang/lang.{$SAMSConf->LANG}"; require $lang; if (isset($_GET["id"])) { $id = $_GET["id"]; } $num_rows = $DB->samsdb_query_value("SELECT * FROM redirect WHERE s_redirect_id='{$id}' "); $row = $DB->samsdb_fetch_array(); if ($USERConf->ToWebInterfaceAccess("LC") == 1) { print "<SCRIPT language=JAVASCRIPT>\n"; print "function DeleteList(id)\n"; print "{\n"; print " value=window.confirm(\"{$redirbuttom_3_deletelist_redirbuttom_3_deletelist_1} {$row['s_name']} \" );\n"; print " if(value==true) \n"; print " {\n"; print " parent.basefrm.location.href=\"main.php?show=exe&function=deletelist&filename=redirlisttray.php&id={$id}\";\n"; print " }\n"; print "}\n"; print "</SCRIPT> \n"; print "<TD CLASS=\"samstraytd\">\n"; print "<IMAGE id=Trash name=\"Trash\" src=\"{$SAMSConf->ICONSET}/trash_32.jpg\" \n "; print "TITLE=\"{$redirbuttom_3_deletelist_redirbuttom_3_deletelist_1}\" border=0 "; print "onclick=DeleteList(\"{$id}\") \n"; print "onmouseover=\"this.src='{$SAMSConf->ICONSET}/trash_48.jpg'\" \n"; print "onmouseout= \"this.src='{$SAMSConf->ICONSET}/trash_32.jpg'\" >\n"; } }
function ClearUserTrafficCounter() { global $SAMSConf; global $USERConf; $DB = new SAMSDB(); $lang = "./lang/lang.{$SAMSConf->LANG}"; require $lang; if ($USERConf->ToWebInterfaceAccess("UC") != 1) { exit(0); } if (isset($_GET["id"])) { $id = $_GET["id"]; } if (isset($_GET["enabled"])) { $enabled = $_GET["enabled"]; } if ($enabled == "on") { $uenabled = ",s_enabled='1'"; } else { $uenabled = ""; } $QUERY = "UPDATE squiduser SET s_size='0',s_hit='0'" . $uenabled . " WHERE s_user_id='{$id}'"; $num_rows = $DB->samsdb_query_value($QUERY); print "<SCRIPT>\n"; print " parent.tray.location.href=\"tray.php?show=exe&filename=usertray.php&function=usertray&auth=ip&id={$id}\";\n"; if ($enabled == "on") { print " parent.lframe.location.href=\"lframe.php\";\n"; } print "</SCRIPT> \n"; }
function ReconfigSquid() { global $SAMSConf; global $USERConf; global $DATE; $lang = "./lang/lang.{$SAMSConf->LANG}"; require $lang; $DB = new SAMSDB(); if (isset($_GET["id"])) { $cache = $_GET["id"]; } $reconfigureOK = 0; if ($USERConf->ToWebInterfaceAccess("C") == 1) { $SAMSConf->AddLog("webinterface", "Sent a command to reconfigure proxy server id={$cache}", $DATE->today, $DATE->thistime); PageTop("reconfig_48.jpg", "{$squidbuttom_0_reconfig_ReconfigSquid_1}"); $QUERY = "INSERT INTO reconfig (s_proxy_id, s_service, s_action) VALUES('{$cache}', 'squid', 'reconfig'); "; $result = $DB->samsdb_query($QUERY); for ($j = 0; $j < 10; $j++) { $num_rows = $DB->samsdb_query_value("SELECT * FROM reconfig WHERE s_service='squid' AND s_proxy_id='{$cache}' AND s_action='reconfig' "); if ($num_rows == 0) { $reconfigureOK = 1; break; } else { sleep(1); } } if ($reconfigureOK == 1) { $str = "<FONT color=\"BLUE\" SIZE=+1> {$squidbuttom_0_reconfig_ReconfigSquid_3} </FONT><BR>\n"; } else { $str = "<FONT color=\"RED\" SIZE=+1> {$squidbuttom_0_reconfig_ReconfigSquid_4} </FONT><BR>\n"; } print "{$str}"; } }
function MoveUserTrafficDataForm() { global $SAMSConf; global $USERConf; require "reportsclass.php"; $dateselect = new DATESELECT("", ""); $lang = "./lang/lang.{$SAMSConf->LANG}"; require $lang; $DB = new SAMSDB(); if ($USERConf->ToWebInterfaceAccess("C") != 1) { exit; } PageTop("switchuser_48.jpg", "{$MoveUserTrafficDataForm_1}"); print "<IMG SRC=\"{$SAMSConf->ICONSET}/help.jpg\">"; print "<A HREF=\"http://sams.perm.ru/sams2/doc/" . $SAMSConf->LANG . "/samsbackup.html\">{$documentation}</A>"; print "<P>\n"; print "<FORM NAME=\"BACKUP\" ACTION=\"main.php\">\n"; print "<INPUT TYPE=\"HIDDEN\" NAME=\"show\" value=\"exe\">\n"; print "<INPUT TYPE=\"HIDDEN\" NAME=\"function\" value=\"moveusertrafficdata\">\n"; print "<INPUT TYPE=\"HIDDEN\" NAME=\"filename\" value=\"configbuttom_6_moveusertrafficdata.php\">\n"; $dateselect->SetPeriod(); print "<TABLE WIDTH=70%>\n"; print "<TR><TD WIDTH=20%>{$MoveUserTrafficDataForm_2}\n"; print "<TD WIDTH=35%><SELECT NAME=\"userfrom\">\n"; $QUERY = "SELECT s_user FROM squidcache GROUP BY s_user ORDER BY s_user"; $num_rows = $DB->samsdb_query_value($QUERY); while ($row = $DB->samsdb_fetch_array()) { print "<OPTION VALUE=\"" . $row['s_user'] . "\"> " . $row['s_user'] . "\n"; } print "</SELECT>\n"; print "<TD WIDTH=10%> {$MoveUserTrafficDataForm_3}\n"; print "<TD WIDTH=35%><SELECT NAME=\"userto\">\n"; $QUERY = "SELECT * FROM squiduser ORDER BY s_nick"; $num_rows = $DB->samsdb_query_value($QUERY); while ($row = $DB->samsdb_fetch_array()) { print "<OPTION VALUE=\"" . $row['s_nick'] . "\"> " . $row['s_nick'] . "\n"; } print "</SELECT>\n"; print "</TABLE>\n"; print "<BR><INPUT TYPE=\"SUBMIT\" value=\"{$MoveUserTrafficDataForm_4}\">\n"; print "</FORM>\n"; }
function DeleteShablon() { global $SAMSConf; global $USERConf; $DB = new SAMSDB(); $lang = "./lang/lang.{$SAMSConf->LANG}"; require $lang; if (isset($_GET["id"])) { $id = $_GET["id"]; } if ($USERConf->ToWebInterfaceAccess("C") != 1) { exit; } if ($sname != "default") { $num_rows = $DB->samsdb_query_value("SELECT * FROM squiduser WHERE s_shablon_id='{$id}' "); $DB->free_samsdb_query(); if ($num_rows == 0) { $QUERY = "select s_name from shablon where s_shablon_id='{$id}'"; $DB->samsdb_query_value($QUERY); $row = $DB->samsdb_fetch_array(); $s_name = $row['s_name']; $DB->free_samsdb_query(); $QUERY = "delete from auth_param where (s_param='adldgroup' OR s_param='ntlmgroup' OR s_param='ldapgroup') AND s_value='{$s_name}'"; $DB->samsdb_query($QUERY); $QUERY = "DELETE FROM shablon WHERE s_shablon_id='{$id}'"; $DB->samsdb_query($QUERY); } else { PageTop("denied.gif", "<FONT SIZE=+3 COLOR=\"RED\"> {$shablonbuttom_9_delete_DeleteShablon_3} </FONT>"); echo "<FONT SIZE=+1>{$shablonbuttom_9_delete_DeleteShablon_1} {$num_rows} {$shablonbuttom_9_delete_DeleteShablon_2}</FONT>"; exit(0); } } print "OK<BR>"; print "<SCRIPT>\n"; print " parent.lframe.location.href=\"lframe.php\";\n"; print " parent.basefrm.location.href=\"main.php?show=exe&function=newshablonform&filename=shablonnew.php\";\n"; print "</SCRIPT> \n"; }
function SAMSSHABLON($shablonid) { global $SAMSConf; $DB = new SAMSDB(); $num_rows = $DB->samsdb_query_value("SELECT * FROM shablon WHERE s_shablon_id='{$shablonid}' "); $row = $DB->samsdb_fetch_array(); $this->s_shablon_id = $row['s_shablon_id']; $this->s_shablon_id2 = $row['s_shablon_id2']; $this->s_name = $row['s_name']; $this->s_auth = $row['s_auth']; $this->s_quote = $row['s_quote']; $this->s_period = $row['s_period']; $this->s_clrdate = $row['s_clrdate']; $this->s_alldenied = $row['s_alldenied']; $DB->free_samsdb_query(); }
function SAMSPOOL($poolid) { global $SAMSConf; $DB = new SAMSDB(); $num_rows = $DB->samsdb_query_value("SELECT * FROM delaypool WHERE s_pool_id='{$poolid}' "); $row = $DB->samsdb_fetch_array(); $this->s_pool_id = $row['s_pool_id']; $this->s_name = $row['s_name']; $this->s_class = $row['s_class']; $this->s_agg1 = $row['s_agg1']; $this->s_agg2 = $row['s_agg2']; $this->s_net1 = $row['s_net1']; $this->s_net2 = $row['s_net2']; $this->s_ind1 = $row['s_ind1']; $this->s_ind2 = $row['s_ind2']; $DB->free_samsdb_query(); }
function ChangeAdminPasswd() { global $SAMSConf; global $USERConf; $DB = new SAMSDB(); $lang = "./lang/lang.{$SAMSConf->LANG}"; require $lang; if (isset($_GET["username"])) { $username = $_GET["username"]; } if (isset($_GET["adminname"])) { $adminname = $_GET["adminname"]; } if (isset($_GET["passw1"])) { $newpasswd = $_GET["passw1"]; } if (isset($_GET["oldpasswd"])) { $oldpasswd = $_GET["oldpasswd"]; } if ($USERConf->ToWebInterfaceAccess("C") != 1) { exit; } $passwd = crypt($newpasswd, "00"); $oldpasswd2 = crypt($oldpasswd, "00"); $QUERY = "SELECT s_pass FROM passwd WHERE s_user='******' AND s_pass='******' "; $num_rows = $DB->samsdb_query_value($QUERY); if ($num_rows != 1) { PageTop("warning.jpg", "{$username} password wrong"); } else { $QUERY = "UPDATE passwd SET s_pass='******' WHERE s_user='******' AND s_pass='******' "; $num_rows = $DB->samsdb_query($QUERY); PageTop("user_48.jpg", "{$adminbuttom_4_chpasswd_ChangeAdminPasswd_1} {$username} {$adminbuttom_4_chpasswd_ChangeAdminPasswd_2}"); setcookie("user", ""); setcookie("passwd", ""); setcookie("domainuser", ""); setcookie("gauditor", ""); setcookie("userid", ""); setcookie("webaccess", ""); setcookie("samsadmin", "0"); print "<SCRIPT>\n"; print " parent.basefrm.location.href=\"main.php?show=exe&function=setcookie&username={$username}&userid={$newpasswd}\";\n"; print " parent.lframe.location.href=\"lframe.php\";\n"; print "</SCRIPT> \n"; } }
function lffolder_4_z2_url() { global $SAMSConf; global $USERConf; $DB = new SAMSDB(); $lang = "./lang/lang.{$SAMSConf->LANG}"; require $lang; if ($USERConf->ToWebInterfaceAccess("CL") == 1) { $item = array("classname" => "url", "icon" => "stop.gif", "target" => "basefrm", "url" => "main.php?show=exe&filename=redirlisttray.php&function=addurllistform&type=regex", "text" => "{$lframe_sams_FolderContextDenied_1}"); treeFolder($item); $num_rows = $DB->samsdb_query_value("SELECT * FROM redirect WHERE s_type='regex' "); while ($row = $DB->samsdb_fetch_array()) { $item = array("classname" => "url", "target" => "tray", "url" => "tray.php?show=exe&filename=redirlisttray.php&function=redirlisttray&id={$row['s_redirect_id']}", "text" => "{$row['s_name']}"); treeFolderItem($item); } treeFolderClose(); } }
function lffolder_5_z20_delaypool() { global $SAMSConf; global $USERConf; $DB = new SAMSDB(); $lang = "./lang/lang.{$SAMSConf->LANG}"; require $lang; if ($USERConf->ToWebInterfaceAccess("C") == 1) { $item = array("classname" => "delaypool", "icon" => "delaypool.png", "target" => "basefrm", "url" => "main.php?show=exe&filename=pooltray.php&function=addpoolform", "text" => "{$lframe_sams_DelayPools}"); treeFolder($item); $num_rows = $DB->samsdb_query_value("SELECT * FROM delaypool"); while ($row = $DB->samsdb_fetch_array()) { $item = array("classname" => "delaypool", "target" => "tray", "url" => "tray.php?show=exe&filename=pooltray.php&function=pooltray&id={$row['s_pool_id']}", "text" => "{$row['s_name']}"); treeFolderItem($item); } treeFolderClose(); } }
function lffolder_2_squid() { global $SAMSConf; global $USERConf; $DB = new SAMSDB(); $lang = "./lang/lang.{$SAMSConf->LANG}"; require $lang; if ($USERConf->ToWebInterfaceAccess("C") == 1) { $item = array("classname" => "squid", "icon" => "pobject.gif", "target" => "tray", "url" => "tray.php?show=exe&filename=squidtray.php&function=squidtray", "text" => "SQUID"); treeFolder($item); $DB->samsdb_query_value("SELECT * FROM proxy"); while ($row = $DB->samsdb_fetch_array()) { $item = array("classname" => "squid", "target" => "tray", "url" => "tray.php?show=exe&function=proxytray&filename=proxytray.php&id={$row['s_proxy_id']}", "text" => "{$row['s_description']}"); treeFolderItem($item); } treeFolderClose(); } }
function lffolder_5_z0_trange() { global $SAMSConf; global $USERConf; $DB = new SAMSDB(); $lang = "./lang/lang.{$SAMSConf->LANG}"; require $lang; if ($USERConf->ToWebInterfaceAccess("C") == 1) { $item = array("classname" => "timerange", "icon" => "clock.gif", "target" => "basefrm", "url" => "main.php?show=exe&filename=trangetray.php&function=addtrangeform", "text" => "{$lffolder_5_z0_trange_lfforder_5_z0_trange_1}"); treeFolder($item); $num_rows = $DB->samsdb_query_value("SELECT * FROM timerange"); while ($row = $DB->samsdb_fetch_array()) { $item = array("classname" => "timerange", "target" => "tray", "url" => "tray.php?show=exe&filename=trangetray.php&function=trangetray&id={$row['s_trange_id']}", "text" => "{$row['s_name']}"); treeFolderItem($item); } treeFolderClose(); } }
function SAMSPROXY($proxy_id) { global $SAMSConf; $DB = new SAMSDB(); $num_rows = $DB->samsdb_query_value("SELECT * FROM proxy WHERE s_proxy_id='{$proxy_id}' "); $row = $DB->samsdb_fetch_array(); $this->s_proxy_id = $row['s_proxy_id']; $this->s_description = $row['s_description']; $this->s_endvalue = $row['s_endvalue']; $this->s_redirect_to = $row['s_redirect_to']; $this->s_denied_to = $row['s_denied_to']; $this->s_redirector = $row['s_redirector']; $this->s_delaypool = $row['s_delaypool']; $this->s_auth = $row['s_auth']; $this->s_wbinfopath = $row['s_wbinfopath']; $this->s_separator = $row['s_separator']; $this->s_usedomain = $row['s_usedomain']; $this->s_bigd = $row['s_bigd']; $this->s_bigu = $row['s_bigu']; $this->s_sleep = $row['s_sleep']; $this->s_parser = $row['s_parser']; $this->s_parser_time = $row['s_parser_time']; $this->s_count_clean = $row['s_count_clean']; $this->s_nameencode = $row['s_nameencode']; $this->s_realsize = $row['s_realsize']; $this->s_checkdns = $row['s_checkdns']; $this->s_debuglevel = $row['s_debuglevel']; $this->s_defaultdomain = $row['s_defaultdomain']; $this->s_squidbase = $row['s_squidbase']; $this->s_udscript = $row['s_udscript']; $this->s_adminaddr = $row['s_adminaddr']; $this->s_kbsize = $row['s_kbsize']; $this->s_mbsize = $row['s_mbsize']; $this->s_ldapserver = $row['s_ldapserver']; $this->s_ldapbasedn = $row['s_ldapbasedn']; $this->s_ldapuser = $row['s_ldapuser']; $this->s_ldappasswd = $row['s_ldappasswd']; $this->s_ldapusergroup = $row['s_ldapusergroup']; $this->s_autouser = $row['s_autouser']; $this->s_autotpl = $row['s_autotpl']; $this->s_autogrp = $row['s_autogrp']; $DB->free_samsdb_query(); }
function SysPlugConfigForm() { global $SAMSConf; $DB = new SAMSDB(); $num_rows = $DB->samsdb_query_value("SELECT * FROM sysinfo"); PageTop("sysplug_64.png", "System Plugins"); print "<FORM NAME=\"sysplugconfigform\" ACTION=\"main.php\">\n"; print "<INPUT TYPE=\"HIDDEN\" NAME=\"show\" value=\"exe\">\n"; print "<INPUT TYPE=\"HIDDEN\" NAME=\"function\" value=\"sysplugconfig\">\n"; print "<INPUT TYPE=\"HIDDEN\" NAME=\"filename\" value=\"sysplugconfigtray.php\">\n"; print "<TABLE CLASS=samstable>\n"; print "<TH>Name</TH>\n"; print "<TH>Version</TH>\n"; print "<TH>Author</TH>\n"; print "<TH>Enabled</TH>\n"; while ($row = $DB->samsdb_fetch_array()) { /* print("<TR>\n"); if(isset($_GET["$row[s_row_id]"])) $val=$_GET["$row[s_row_id]"]; print("<TD>s_row_id=$row[s_row_id]</TD>\n"); print("<TD>val=$val</TD>\n"); if($val=="on") $val=1; else $val=0; print("<TD>val=$val</TD>\n"); print("<TD>s_status=$row[s_status]</TD>\n"); print("</TR>\n"); */ print "<TR>\n"; print " <TD>{$row['s_name']}</TD>\n"; print " <TD>{$row['s_version']}</TD>\n"; print " <TD>{$row['s_author']}</TD>\n"; $CHECKED = ""; if ($row['s_status'] == 1) { $CHECKED = "CHECKED"; } print "<TD><INPUT TYPE=\"CHECKBOX\" NAME=\"{$row['s_row_id']}\" {$CHECKED}></TD>\n"; print "</TR>\n"; } $DB->free_samsdb_query(); print "</TABLE>\n"; print "<BR><INPUT TYPE=\"SUBMIT\" value=\"Configure\">\n"; print "</FORM>\n"; }
function LoadUndefinedUserVariables($request) { global $SAMSConf; $DB = new SAMSDB(); $num_rows = $DB->samsdb_query_value($request); if ($num_rows > 0) { $row = $DB->samsdb_fetch_array(); $this->UserName = $row['s_nick']; $this->UserGroup = $row['s_group_id']; $this->gauditor = $row['s_gauditor']; $this->autherrorc = $row['s_autherrorc']; $this->autherrort = $row['s_autherrort']; $this->userid = $row['s_user_id']; $this->salt = substr($row['s_passwd'], 0, 2); return 1; } else { $this->UserName = ""; } return 0; }
function DeleteUser() { global $SAMSConf; global $USERConf; $DB = new SAMSDB(); $lang = "./lang/lang.{$SAMSConf->LANG}"; require $lang; if ($USERConf->ToWebInterfaceAccess("UC") != 1) { exit(0); } if (isset($_GET["id"])) { $userid = $_GET["id"]; } $query = "DELETE FROM squiduser WHERE s_user_id='{$userid}'"; $num_rows = $DB->samsdb_query_value($query); print "<SCRIPT>\n"; print " parent.tray.location.href=\"tray.php?show=exe&filename=userstray.php&function=userstray\";\n"; print " parent.lframe.location.href=\"lframe.php\";\n"; print "</SCRIPT> \n"; }
function RemoveCache() { global $SAMSConf; $DB = new SAMSDB("{$SAMSConf->DB_ENGINE}", $SAMSConf->ODBC, $SAMSConf->DB_SERVER, $SAMSConf->DB_USER, $SAMSConf->DB_PASSWORD, $SAMSConf->SAMSDB, $SAMSConf->PDO); $DB2 = new SAMSDB("{$SAMSConf->DB_ENGINE}", $SAMSConf->ODBC, $SAMSConf->DB_SERVER, $SAMSConf->DB_USER, $SAMSConf->DB_PASSWORD, $SAMSConf->SAMSDB, $SAMSConf->PDO); if (isset($_GET["cache"])) { $cache = $_GET["cache"]; } $num_rows = $DB->samsdb_query_value("SELECT * FROM proxy "); while ($row = $DB->samsdb_fetch_array()) { $id = $row['s_proxy_id']; if ($cache[$id] == "on") { $DB2->samsdb_query("DELETE FROM {$SAMSConf->SAMSDB}.proxy WHERE s_proxy_id=\"{$id}\" "); } } print "<SCRIPT>\n"; print " parent.basefrm.location.href=\"main.php?show=exe&function=cacheform&filename=squidbuttom_4_addcache.php\"; \n"; print " parent.lframe.location.href=\"lframe.php\";\n"; print "</SCRIPT> \n"; }
function SAMSTRANGE($trangeid) { global $SAMSConf; $DB = new SAMSDB(); $num_rows = $DB->samsdb_query_value("SELECT *, extract(hour from s_timestart) as s_hour, extract(hour from s_timeend) as e_hour, extract(minute from s_timestart) as s_min, extract(minute from s_timeend) as e_min FROM timerange WHERE s_trange_id='{$trangeid}' "); $row = $DB->samsdb_fetch_array(); $this->s_trange_id = $row['s_trange_id']; $this->s_name = $row['s_name']; $this->s_timestart = $row['s_timestart']; $this->s_timeend = $row['s_timeend']; $this->s_shour = $row['s_hour']; $this->s_ehour = $row['e_hour']; $this->s_smin = $row['s_min']; $this->s_emin = $row['e_min']; if (strstr($row['s_days'], "M")) { $this->s_days[1] = "CHECKED"; } if (strstr($row['s_days'], "T")) { $this->s_days[2] = "CHECKED"; } if (strstr($row['s_days'], "W")) { $this->s_days[3] = "CHECKED"; } if (strstr($row['s_days'], "H")) { $this->s_days[4] = "CHECKED"; } if (strstr($row['s_days'], "F")) { $this->s_days[5] = "CHECKED"; } if (strstr($row['s_days'], "A")) { $this->s_days[6] = "CHECKED"; } if (strstr($row['s_days'], "S")) { $this->s_days[7] = "CHECKED"; } $DB->free_samsdb_query(); }
function AddGroup() { global $SAMSConf; global $USERConf; if ($USERConf->ToWebInterfaceAccess("C") != 1) { exit; } $DB = new SAMSDB(); $lang = "./lang/lang.{$SAMSConf->LANG}"; require $lang; if (isset($_GET["groupnick"])) { $groupnick = $_GET["groupnick"]; } $result = $DB->samsdb_query_value("SELECT s_name FROM sgroup where s_name = '{$groupnick}'"); if ($result == 0) { $result = $DB->samsdb_query("INSERT INTO sgroup (s_name) VALUES('{$groupnick}') "); print "<SCRIPT>\n"; print " parent.lframe.location.href=\"lframe.php\"; \n"; print " parent.tray.location.href=\"tray.php?show=usergrouptray&groupname={$groupname}&groupnick={$groupnick}\";\n"; print "</SCRIPT> \n"; } else { PageTop("usergroup_48.jpg", "{$newgroupbuttom_5_addgroup_newgrpbuttom_5_groupexist}"); } }
function UserForm() { global $SAMSConf; $DB = new SAMSDB(); $DB2 = new SAMSDB(); $lang = "./lang/lang.{$SAMSConf->LANG}"; require $lang; if (isset($_GET["userid"])) { $userid = $_GET["userid"]; } $num_rows = $DB->samsdb_query_value("SELECT * FROM squiduser WHERE s_user_id='{$userid}' "); $row = $DB->samsdb_fetch_array(); $num_rows2 = $DB2->samsdb_query_value("SELECT * FROM sgroup WHERE s_group_id='{$row['s_group_id']}' "); $row2 = $DB2->samsdb_fetch_array(); PageTop("user.jpg", "{$usertray_UserForm_1} <FONT COLOR=\"BLUE\">{$row['nick']}</FONT>"); print "<TABLE>\n"; print "<TR>\n"; print "<TD>\n"; print "<B>Nickname:\n"; print "<TD>\n"; print "{$row['s_nick']}\n"; if ($SAMSConf->NTLMDOMAIN == "Y") { print "<TR>\n"; print "<TD>\n"; print "<B>{$usertray_UserForm_2}\n"; print "<TD>\n"; print "{$row['S_domain']}\n"; } if ($USERConf->ToWebInterfaceAccess("C") == 1) { print "<TR>\n"; print "<TD>\n"; print "<B>{$usertray_UserForm_3}:\n"; print "<TD>\n"; print "{$row['s_ip']}\n"; } print "<TR>\n"; print "<TD>\n"; print "<B>{$usertray_UserForm_4}: \n"; print "<TD>\n"; print "{$row['s_name']}\n"; print "<TR>\n"; print "<TD>\n"; print "<B>{$usertray_UserForm_5}: \n"; print "<TD>\n"; print "{$row['s_soname']}\n"; print "<TR>\n"; print "<TD>\n"; print "<B>{$usertray_UserForm_6}: \n"; print "<TD>\n"; print "{$row['s_family']} \n"; print "<TR>\n"; print "<TD>\n"; print "<B>{$usertray_UserForm_7}: \n"; print "<TD>\n"; print "{$row2['s_name']}\n"; $DB2->free_samsdb_query(); if ($USERConf->ToWebInterfaceAccess("C") == 1 || strcasecmp($SAMSConf->domainusername, $row[nick]) == 0 || $SAMSConf->groupauditor == $row[group]) { print "<TR>\n"; print "<TD>\n"; print "<B>{$usertray_UserForm_8}: \n"; print "<TD>\n"; if ($row['s_quote'] > 0) { print " {$row['s_quote']} Mb"; } else { print " unlimited "; } // print("$row[quotes] Mb\n"); print "<TR>\n"; print "<TD>\n"; print "<B>{$usertray_UserForm_9}: \n"; print "<TD>\n"; $syea = strftime("%Y"); $smon = strftime("%m"); $eday = strftime("%d"); $sdate = "{$syea}-{$smon}-1"; $edate = "{$syea}-{$smon}-{$eday}"; $stime = "0:00:00"; $etime = "0:00:00"; // if($SAMSConf->realtraffic=="real") // PrintTrafficSize($row['s_size']-$row['s_hit']); // else // PrintTrafficSize($row['s_size']); } if ($USERConf->ToWebInterfaceAccess("C") == 1) { print "<TR>\n"; print "<TD>\n"; print "<B>{$usertray_UserForm_10}:\n"; print "<TD>\n"; if ($row['s_enabled'] == 2) { print "{$usertray_UserForm_14}\n"; } else { if ($row['s_enabled'] == 1) { print "{$usertray_UserForm_13}\n"; } else { if ($row['s_enabled'] == 0) { print "{$usertray_UserForm_15}\n"; } else { if ($row['s_enabled'] == -1) { print "{$usertray_UserForm_11}\n"; } else { print "Unknown status\n"; } } } } $num_rows2 = $DB2->samsdb_query_value("SELECT * FROM shablon WHERE s_shablon_id='{$row['s_shablon_id']}' "); $row2 = $DB2->samsdb_fetch_array(); print "<TR>\n"; print "<TD>\n"; print "<B>{$usertray_UserForm_12}: \n"; print "<TD>\n"; print "<A HREF=\"tray.php?show=exe&function=shablontray&id={$row2['s_shablon_id']}\" TARGET=\"tray\">{$row2['s_name']}</A>\n"; print "</TABLE>\n"; } }
function UserTimeTraffic() { global $SAMSConf; global $DATE; global $USERConf; global $SquidUSERConf; if (isset($_GET["id"])) { $id = $_GET["id"]; } $SquidUSERConf = new SAMSUSER(); $SquidUSERConf->sams_user($id); if ($USERConf->ToWebInterfaceAccess("GSC") != 1 && ($USERConf->s_user_id != $SquidUSERConf->s_user_id && $USERConf->ToWebInterfaceAccess("W") != 1)) { exit(0); } $DB = new SAMSDB(); $sdate = $DATE->sdate(); $edate = $DATE->edate(); $bdate = $DATE->BeginDate(); $eddate = $DATE->EndDate(); $sday = $DATE->sday; $smon = $DATE->smon; $syea = $DATE->syea; $shou = $DATE->shou; $eday = $DATE->eday; $emon = $DATE->emon; $eyea = $DATE->eyea; require "reportsclass.php"; $dateselect = new DATESELECT($DATE->sdate(), $DATE->edate()); $lang = "./lang/lang.{$SAMSConf->LANG}"; require $lang; if ($USERConf->ToWebInterfaceAccess("WAUC") != 1) { exit(0); } PageTop("ttraffic_48.jpg", "{$traffic_1} <FONT COLOR=\"BLUE\"> {$SquidUSERConf->s_nick}</FONT><BR>{$URLTimeForm_userbuttom_4_time_1}<BR>{$bdate}"); print "<TABLE WIDTH=\"90%\"><TR><TD>"; print "<FORM NAME=\"UserIDForm\" ACTION=\"main.php\">\n"; print "<INPUT TYPE=\"HIDDEN\" NAME=\"id\" id=id value=\"{$SquidUSERConf->s_user_id}\">\n"; print "<INPUT TYPE=\"HIDDEN\" NAME=\"show\" id=Show value=\"exe\">\n"; print "<INPUT TYPE=\"HIDDEN\" NAME=\"function\" id=function value=\"usertimetraffic\">\n"; print "<INPUT TYPE=\"HIDDEN\" NAME=\"filename\" id=filename value=\"userbuttom_3_time.php\">\n"; $dateselect->SetDate(); print "<TD><IMG SRC=\"{$SAMSConf->ICONSET}/printer.gif\" TITLE=\"Print\" ALT=\"Print\" onClick=\"JavaScript:window.print();\"></TABLE>\n"; print "</FORM>\n"; $URL = array("time" => array(), "url" => array(), "method" => array()); $count = 0; $QUERY = "SELECT * FROM (SELECT substring(s_time from 1 for 5) as time , substring( s_url from position('//' in s_url)+2 for position('/' in substring(s_url from position('/' in s_url)+2 )) ) as url_domain, s_method FROM squidcache WHERE s_user='******' AND s_date='{$sdate}' AND s_method!='CONNECT' ORDER BY s_time) AS _cache GROUP BY _cache.time,_cache.url_domain ORDER BY _cache.time"; $num_rows = $DB->samsdb_query_value($QUERY); while ($row = $DB->samsdb_fetch_array()) { $URL["time"][$count] = $row['time']; $URL["url"][$count] = str_replace("/", "", $row['url_domain']); $URL["method"][$count] = $row['s_method']; $count++; } $QUERY = "SELECT * FROM (SELECT substring(s_time from 1 for 5) as time, s_url as url_domain, s_method FROM squidcache WHERE s_user='******' AND s_date='{$sdate}' AND s_method='CONNECT' ORDER BY s_time) AS _cache GROUP BY _cache.time,_cache.url_domain ORDER BY _cache.time"; $num_rows = $DB->samsdb_query_value($QUERY); while ($row = $DB->samsdb_fetch_array()) { $URL["time"][$count] = $row['time']; $URL["url"][$count] = str_replace("/", "", $row['url_domain']); $URL["method"][$count] = $row['s_method']; $count++; } print "<CENTER>\n"; print "<script type=\"text/javascript\" src=\"lib/jquery-1.2.6.js\"></script>\n"; print "<script type=\"text/javascript\" src=\"lib/jquery.dataTables.js\"></script>\n"; print "<script type=\"text/javascript\">\n"; print "\$(document).ready(function(){\n"; print " \$(\"#urltime\").dataTable({\n"; print "\t\"bInfo\": 0,\n"; print "\t\"iDisplayLength\": {$count},\n"; print "\t\"iDisplayStart\": 0,\n"; print "\t\"iDisplayEnd\": {$count},\n"; print "\t\"oLanguage\": {\n"; print "\t\t\"sSearch\": \"search\", \n"; print "\t\t\"sLengthMenu\": \"Show _MENU_ entries\"\n"; print "\t\t},\n"; print "\t\"aoColumns\": [ \n"; print "\t\t{ \"sType\": \"numeric\", \"sWidth\": \"15%\" },\n"; print "\t\t{ \"sType\": \"html\", \"sWidth\": \"75%\"},\n"; print "\t\t{ \"sType\": \"html\", \"sWidth\": \"10%\"},\n"; print " ]\n"; print " });\n"; print "});\n"; print "</script>\n"; print "</CENTER>\n"; asort($URL["time"]); reset($URL["time"]); $cache = 0; print "<TABLE CLASS=samstable id=\"urltime\" WIDTH=80%>"; print "<THEAD>\n"; print "<TH>Time"; print "<TH>URL"; print "<TH>Method"; print "</THEAD>\n"; print "<TBODY>\n"; $size = 0; asort($URL["time"]); reset($URL["time"]); while (list($key, $val) = each($URL["time"])) { print "<TR>"; LTableCell($URL['time'][$key], 15); if ($USERConf->ToWebInterfaceAccess("C") == 1) { RTableCell($URL['url'][$key], 75); } RTableCell($URL['method'][$key], 15); print "</TR>\n"; } print "</TBODY>\n"; print "</TABLE>"; }
function UserTrafficPeriod() { global $SAMSConf; global $DATE; global $USERConf; global $SquidUSERConf; if (isset($_GET["id"])) { $id = $_GET["id"]; } $SquidUSERConf = new SAMSUSER(); $SquidUSERConf->sams_user($id); if ($USERConf->ToWebInterfaceAccess("GSC") != 1 && ($USERConf->s_user_id != $SquidUSERConf->s_user_id && $USERConf->ToWebInterfaceAccess("W") != 1)) { exit(0); } $DB = new SAMSDB(); $sdate = $DATE->sdate(); $edate = $DATE->edate(); $bdate = $DATE->BeginDate(); $eddate = $DATE->EndDate(); require "reportsclass.php"; $dateselect = new DATESELECT($DATE->sdate(), $DATE->edate()); $lang = "./lang/lang.{$SAMSConf->LANG}"; require $lang; if ($USERConf->ToWebInterfaceAccess("WAUC") != 1) { exit(0); } PageTop("usertraffic_48.jpg", "{$traffic_1} <FONT COLOR=\"BLUE\"> {$SquidUSERConf->s_nick}</FONT><BR>{$userbuttom_2_traffic_UserTrafficPeriod_2}"); print "<TABLE WIDTH=\"90%\"><TR><TD>"; print "<FORM NAME=\"UserIDForm\" ACTION=\"main.php\">\n"; print "<INPUT TYPE=\"HIDDEN\" NAME=\"id\" id=id value=\"{$SquidUSERConf->s_user_id}\">\n"; print "<INPUT TYPE=\"HIDDEN\" NAME=\"show\" id=Show value=\"exe\">\n"; print "<INPUT TYPE=\"HIDDEN\" NAME=\"function\" id=function value=\"usertrafficperiod\">\n"; print "<INPUT TYPE=\"HIDDEN\" NAME=\"filename\" id=filename value=\"userbuttom_2_traffic.php\">\n"; $dateselect->SetPeriod(); print "<TD><IMG SRC=\"{$SAMSConf->ICONSET}/printer.gif\" TITLE=\"Print\" ALT=\"Print\" onClick=\"JavaScript:window.print();\"></TABLE>\n"; print "</FORM>\n"; printf("<BR><B>{$traffic_2} {$bdate} {$traffic_3} {$eddate}</B> "); printf("<P><IMG SRC=\"main.php?show=exe&function=usertrafficperiodgb&filename=userbuttom_2_traffic.php&id={$SquidUSERConf->s_user_id}&gb=1&sdate={$sdate}&edate={$edate}\"><P>"); $count = 1; $cache = 0; print "<TABLE CLASS=samstable>"; print "<THEAD>\n"; print "<TH>No"; print "<TH>{$traffic_data}"; if ($USERConf->ToWebInterfaceAccess("C") == 1) { print "<TH>{$userbuttom_2_traffic_UserTrafficPeriod_3}"; print "<TH>{$userbuttom_2_traffic_UserTrafficPeriod_4}"; } print "<TH>{$userbuttom_2_traffic_UserTrafficPeriod_5}"; print "</THEAD>\n"; print "<TBODY>\n"; $size = 0; $QUERY = "SELECT sum(s_size),s_date,s_user,s_domain,sum(s_hit) FROM cachesum WHERE lower(s_user)=lower('" . $SquidUSERConf->s_nick . "') AND s_date>='{$sdate}' AND s_date<='{$edate}' GROUP BY s_date,s_user,s_domain ORDER BY s_date"; $num_rows = $DB->samsdb_query_value($QUERY); while ($row = $DB->samsdb_fetch_array()) { print "<TR>"; LTableCell($count, 10); $aaa = ReturnDate($row['s_date']); LTableCell($aaa, 15); if ($USERConf->ToWebInterfaceAccess("C") == 1) { $aaa = FormattedString("{$row['0']}"); RTableCell($aaa, 25); $aaa = FormattedString("{$row['4']}"); RTableCell($aaa, 25); } // if($SAMSConf->realtraffic=="real") PrintFormattedSize($row[0] - $row[4]); // else // PrintFormattedSize($row[0]); print "</TR>"; $count = $count + 1; $size = $size + $row[0]; $cache = $cache + $row[4]; } print "<TR>"; print "</TBODY>\n"; print "<TD>"; RBTableCell("{$vsego}", 25); if ($USERConf->ToWebInterfaceAccess("C") == 1) { // $aaa=FormattedString("$size"); // RBTableCell("$aaa",25); PrintFormattedSize($size); // $aaa=FormattedString("$cache"); // RBTableCell("$aaa",25); PrintFormattedSize($cache); } // if($SAMSConf->realtraffic=="real") PrintFormattedSize($size - $cache); // else // PrintFormattedSize($size); // echo "$SAMSConf->realtraffic"; print "</TABLE>"; }
function SaveBackUp() { global $SAMSConf; global $USERConf; $DB = new SAMSDB(); $lang = "./lang/lang.{$SAMSConf->LANG}"; require $lang; if ($USERConf->ToWebInterfaceAccess("C") != 1) { exit; } if (isset($_GET["traffic"])) { $traffic = $_GET["traffic"]; } $samsdb = array('auth_param', 'passwd', 'proxy', 'redirect', 'sconfig', 'sconfig_time', 'sgroup', 'shablon', 'squiduser', 'sysinfo', 'timerange', 'url', 'websettings'); $traffictable = array('squidcache', 'cachesum'); $filename = strftime("sams2-%d%b%Y-%H-%M-%S.sql.gz"); PageTop("backup_48.jpg", "{$backupbuttom_1_savebase_SaveBackUpForm_1}"); if (($fout = gzopen("data/{$filename}", "w9")) != NULL) { gzwrite($fout, "# " . $SAMSConf->SAMSDB . " DUMP FOR " . $SAMSConf->DB_ENGINE . " DATABASE\n"); for ($tcount = 0; $tcount < count($samsdb); $tcount++) { echo "export table: " . $samsdb[$tcount] . "<BR>"; gzwrite($fout, "TRUNCATE TABLE " . $samsdb[$tcount] . ";\n"); $QUERY = "SELECT * FROM " . $samsdb[$tcount]; $num_rows = $DB->samsdb_query_value($QUERY); while ($row = $DB->samsdb_fetch_array()) { $export = "INSERT INTO " . $samsdb[$tcount] . " VALUES("; $a = 0; $a = ceil(count($row) / 2); for ($i = 0; $i < $a; $i++) { $export = $export . "'" . $row[$i] . "'"; if ($i < $a - 1) { $export = $export . ","; } } $export = $export . ");"; gzwrite($fout, $export . "\n"); } } if ($traffic == "on") { for ($tcount = 0; $tcount < count($traffictable); $tcount++) { echo "export table: " . $traffictable[$tcount] . "<BR>"; gzwrite($fout, "DELETE FROM " . $traffictable[$tcount] . ";\n"); $QUERY = "SELECT * FROM " . $traffictable[$tcount]; $num_rows = $DB->samsdb_query_value($QUERY); while ($row = $DB->samsdb_fetch_array()) { $export = "INSERT INTO " . $traffictable[$tcount] . " VALUES("; $a = 0; $a = ceil(count($row) / 2); for ($i = 0; $i < $a; $i++) { $export = $export . "'" . $row[$i] . "'"; if ($i < $a - 1) { $export = $export . ","; } } $export = $export . ");"; gzwrite($fout, $export . "\n"); } } } gzclose($fout); } else { fwrite($fout, "# " . $SAMSConf->SAMSDB . " DUMP FOR " . $SAMSConf->DB_ENGINE . " DATABASE\n"); fwrite($fout, "USE " . $SAMSConf->SAMSDB . ";\n"); for ($tcount = 0; $tcount < count($samsdb); $tcount++) { fwrite($fout, "DROP TABLE IF EXISTS `" . $samsdb[$tcount] . "`;\n"); fwrite($fout, "CREATE TABLE `" . $samsdb[$tcount] . "`;\n"); $QUERY = "SELECT * FROM " . $samsdb[$tcount]; $num_rows = $DB->samsdb_query_value($QUERY); while ($row = $DB->samsdb_fetch_array()) { $export = "INSERT INTO " . $samsdb[$tcount] . " VALUES("; $a = count($row); for ($i = 0; $i < $a; $i++) { $export = $export . "'" . $row[$i] . "'"; if ($i < $a - 1) { $export = $export . ","; } } $export = $export . ");"; fwrite($fout, $export . "\n"); } } if ($traffic == "on") { for ($tcount = 0; $tcount < count($traffictable); $tcount++) { fwrite($fout, "DROP TABLE IF EXISTS `" . $traffictable[$tcount] . "`;\n"); fwrite($fout, "CREATE TABLE `" . $traffictable[$tcount] . "`;\n"); $QUERY = "SELECT * FROM " . $traffictable[$tcount]; $num_rows = $DB->samsdb_query_value($QUERY); while ($row = $DB->samsdb_fetch_array()) { $export = "INSERT INTO " . $traffictable[$tcount] . " VALUES("; $a = count($row); for ($i = 0; $i < $a; $i++) { $export = $export . "'" . $row[$i] . "'"; if ($i < $a - 1) { $export = $export . ","; } } $export = $export . ");"; fwrite($fout, $export . "\n"); } } } fclose($fout); } print "<P><A HREF=\"data/{$filename}\">\n"; print "<BR><FONT COLOR=\"BLUE\">{$backupbuttom_1_savebase_SaveBackUp_1} <B>{$filename}</B></FONT>\n"; print "</A>\n"; }
function UsersTrafficPeriod() { global $SAMSConf; global $USERConf; global $DATE; if ($USERConf->ToWebInterfaceAccess("CS") != 1) { exit(0); } $DB = new SAMSDB(); $sdate = $DATE->sdate(); $edate = $DATE->edate(); $bdate = $DATE->BeginDate(); $eddate = $DATE->EndDate(); $size = ""; if (isset($_GET["size"])) { $size = $_GET["size"]; } require "reportsclass.php"; $dateselect = new DATESELECT($DATE->sdate(), $DATE->edate()); $lang = "./lang/lang.{$SAMSConf->LANG}"; require $lang; PageTop("usergroup_48.jpg", "{$usersbuttom_2_traffic_UsersTrafficPeriod_1}<BR>{$usersbuttom_2_traffic_UsersTrafficPeriod_2}"); print "<BR>\n"; print "<TABLE WIDTH=\"90%\"><TR><TD>"; print "<FORM NAME=\"UserIDForm\" ACTION=\"main.php\">\n"; print "<INPUT TYPE=\"HIDDEN\" NAME=\"show\" id=Show value=\"exe\">\n"; print "<INPUT TYPE=\"HIDDEN\" NAME=\"function\" id=function value=\"userstrafficperiod\">\n"; print "<INPUT TYPE=\"HIDDEN\" NAME=\"filename\" id=filename value=\"usersbuttom_2_traffic.php\">\n"; $dateselect->SetPeriod(); print "<TD><IMG SRC=\"{$SAMSConf->ICONSET}/printer.gif\" TITLE=\"Print\" ALT=\"Print\" onClick=\"JavaScript:window.print();\">"; print "<A HREF=\"main.php?show=exe&function=userstrafficperiodpdf&filename=usersbuttom_2_traffic.php\"> pdf</a> </TABLE>\n"; print "</FORM>\n"; printf("<BR><B>{$traffic_2} {$bdate} {$traffic_3} {$eddate}</B> "); printf("<P><IMG SRC=\"main.php?show=exe&function=userstrafficperiodgb&filename=usersbuttom_2_traffic.php&gb=1&sdate={$sdate}&edate={$edate}\"><P>"); $count = 1; $size2 = 0; $hitsize = 0; $traf = 0; print "<script type=\"text/javascript\" src=\"lib/jquery-1.2.6.js\"></script>"; print "<script type=\"text/javascript\" src=\"lib/jquery.dataTables.js\"></script>\n"; print "<script type=\"text/javascript\">\n"; print "\$(document).ready(function(){\n"; print " \$(\"#userstraffic\").dataTable({\n"; print "\t\"bInfo\": 0,\n"; print "\t\"iDisplayLength\": 100,\n"; print "\t\"iDisplayStart\": 0,\n"; print "\t\"iDisplayEnd\": 100,\n"; print "\t\"oLanguage\": {\n"; print "\t\t\"sSearch\": \"search\", \n"; print "\t\t\"sLengthMenu\": \"Show _MENU_ entries\"\n"; print "\t\t},\n"; print "\t\"aoColumns\": [ \n"; print "\t\t{ \"sType\": \"numeric\", \"sWidth\": \"8%\" },\n"; print "\t\t{ \"sType\": \"html\", \"sWidth\": \"16%\"},\n"; print "\t\t{ \"sType\": \"formatted-num\", \"sWidth\": \"15%\" },\n"; print "\t\t{ \"sType\": \"formatted-num\", \"sWidth\": \"15%\" },\n"; print "\t\t{ \"sType\": \"formatted-num\", \"sWidth\": \"30%\" }\n"; print " ]\n"; print " });\n"; print "});\n"; print "</script>\n"; print "<TABLE CLASS=samstable id=\"userstraffic\">\n"; $item = array("head" => "squid", "access" => "pobject.gif", "target" => "tray", "url" => "tray.php?show=exe&filename=squidtray.php&function=squidtray", "text" => "SQUID"); print "<THEAD>\n"; print "<TH>No\n"; print "<TH>{$usersbuttom_2_traffic_UsersTrafficPeriod_4}\n"; if ($size == "On") { print "<TH>{$usersbuttom_2_traffic_UsersTrafficPeriod_8}\n"; } else { if (($SAMSConf->AUTH = "ntlm" || ($SAMSConf->AUTH = "adld")) && $SAMSConf->NTLMDOMAIN == "Y") { print "<TH>Domain\n"; } } if ($USERConf->ToWebInterfaceAccess("C") == 1) { print "<TH>{$usersbuttom_2_traffic_UsersTrafficPeriod_6}\n"; print "<TH>{$usersbuttom_2_traffic_UsersTrafficPeriod_5}\n"; } print "<TH>{$usersbuttom_2_traffic_UsersTrafficPeriod_7}\n"; print "</THEAD>\n"; print "<TBODY>\n"; $QUERY = "SELECT sum(cachesum.s_size),sum(cachesum.s_hit),cachesum.s_user,cachesum.s_domain, squiduser.s_nick, squiduser.s_family, squiduser.s_name, squiduser.s_user_id FROM cachesum LEFT JOIN squiduser ON cachesum.s_user=squiduser.s_nick WHERE cachesum.s_date>='{$sdate}'AND cachesum.s_date<='{$edate}' GROUP BY cachesum.s_user,cachesum.s_domain,squiduser.s_nick,squiduser.s_family, squiduser.s_name, squiduser.s_user_id order by sum(cachesum.s_size) desc"; $num_rows = $DB->samsdb_query_value($QUERY); while ($row = $DB->samsdb_fetch_array()) { print "<TR>\n"; //LTableCell($count,8); print "<TD>{$count}"; if ($SAMSConf->SHOWNAME == "fam") { $name = "{$row['s_family']}"; } else { if ($SAMSConf->SHOWNAME == "famn") { $name = "{$row['s_family']} {$row['s_name']}"; } else { if ($SAMSConf->SHOWNAME == "nickd") { $name = "{$row['s_nick']} / {$row['s_domain']}"; } else { $name = $row['s_nick']; } } } $str = "<A HREF=\"tray.php?show=exe&filename=usertray.php&function=usertray&id={$row['s_user_id']}\" TARGET=\"tray\">{$name} </A>\n"; LTableCell($str, 16); if ($size == "On") { LTableCell($row['s_family'], 16); } else { if (($SAMSConf->AUTH = "ntlm" || ($SAMSConf->AUTH = "adld")) && $SAMSConf->NTLMDOMAIN == "Y") { TableCell($row['s_domain'], 16); } } if ($USERConf->ToWebInterfaceAccess("C") == 1) { $aaa = FormattedString("{$row['0']}"); LTableCell("{$aaa}", 15); $aaa = FormattedString("{$row['1']}"); LTableCell("{$aaa}", 15); } if ($SAMSConf->realtraffic == "real") { PrintFormattedSize($row[0] - $row[1]); } else { PrintFormattedSize($row[0]); } print "</TR>\n"; $count = $count + 1; $size2 = $size2 + $row[0]; $hitsize = $hitsize + $row[1]; } print "</TBODY>\n"; print "<TFOOT><TR>\n"; print "<TD>"; RBTableCell("{$vsego}", 16); if (($SAMSConf->AUTH = "ntlm" || ($SAMSConf->AUTH = "adld")) && $SAMSConf->NTLMDOMAIN == "Y" || $size == "On") { print "<TD>"; } if ($USERConf->ToWebInterfaceAccess("C") == 1) { $aaa = FormattedString("{$size2}"); RBTableCell($aaa, 15); $aaa = FormattedString("{$hitsize}"); RBTableCell($aaa, 15); } if ($SAMSConf->realtraffic == "real") { PrintFormattedSize($size2 - $hitsize); } else { PrintFormattedSize($size2); } print "</TFOOT></TABLE>\n"; }
function UsersImportFromNCSAFileForm() { global $SAMSConf; global $USERConf; $lang = "./lang/lang.{$SAMSConf->LANG}"; require $lang; if ($USERConf->ToWebInterfaceAccess("UC") != 1) { exit; } $DB = new SAMSDB(); PageTop("loadncsa_48.jpg", "{$authbuttom_1_ncsaimport_LoadFileForm_1}"); $listfilename = $_FILES["userfile"]["name"]; //echo "filename: ".$_FILES["userfile"]["name"]."<BR>"; //echo "filename: ".$_FILES["userfile"]["tmp_name"]."<BR>"; $aaa = copy($_FILES["userfile"]["tmp_name"], "data/ncsauserslist.txt"); print "<FORM NAME=\"AddUsersFromFile\" ACTION=\"main.php\">\n"; print "<INPUT TYPE=\"HIDDEN\" NAME=\"domain\" id=Show value=\"{$domain}\">\n"; print "<INPUT TYPE=\"HIDDEN\" NAME=\"show\" id=Show value=\"exe\">\n"; print "<INPUT TYPE=\"HIDDEN\" NAME=\"function\" id=function value=\"usersimportfromncsafile\">\n"; print "<INPUT TYPE=\"HIDDEN\" NAME=\"filename\" id=filename value=\"authncsabuttom_2_ncsaimport.php\">\n"; print "<TABLE>\n"; print "<TR><TD><TD>\n"; // print(" <INPUT TYPE=\"HIDDEN\" NAME=\"MAX_FILES_SIZE\" value=\"1048576\">\n"); // print("<BR><INPUT TYPE=\"FILE\" NAME=\"userfile\" value=\"$redir_importurllistform1\">\n"); print "<TR><TD>\n"; print "<B>{$usersbuttom_1_domain_AddUsersFromDomainForm_3} \n"; print "<TD>\n"; print "<SELECT NAME=\"groupname\" ID=\"groupname\" SIZE=1 TABINDEX=30 >\n"; $num_rows = $DB->samsdb_query_value("SELECT * FROM sgroup"); while ($row2 = $DB->samsdb_fetch_array()) { print "<OPTION VALUE=\"{$row2['s_group_id']}\"> {$row2['s_name']} \n"; } $DB->free_samsdb_query(); print "</SELECT>\n"; print "<TR>\n"; print "<TD>\n"; print "<B>{$usersbuttom_1_domain_AddUsersFromDomainForm_4} \n"; print "<TD>\n"; print "<SELECT NAME=\"usershablon\" ID=\"usershablon\" SIZE=1 TABINDEX=30 > \n"; $num_rows = $DB->samsdb_query_value("SELECT s_shablon_id, s_name FROM shablon"); while ($row = $DB->samsdb_fetch_array()) { print "<OPTION VALUE={$row['s_shablon_id']}> {$row['s_name']}\n"; } $DB->free_samsdb_query(); print "</SELECT>"; print "<TR><TD><B>{$usersbuttom_1_domain_AddUsersFromDomainForm_6}"; print "<TD><INPUT TYPE=\"CHECKBOX\" NAME=\"enabled\" CHECKED>"; print "</TABLE>\n"; print "<INPUT TYPE=\"SUBMIT\" value=\"{$usersbuttom_1_domain_AddUsersFromDomainForm_5}\">\n"; print "</FORM>\n"; exit(0); }
function GroupTrafficForm() { global $SAMSConf; global $USERConf; if ($USERConf->ToWebInterfaceAccess("CS") != 1) { exit(0); } require "reportsclass.php"; $dateselect = new DATESELECT("", ""); $lang = "./lang/lang.{$SAMSConf->LANG}"; require $lang; $DB = new SAMSDB(); if (isset($_GET["id"])) { $id = $_GET["id"]; } $a = array(array($usersbuttom_2_traffic_UsersTrafficForm_4, 'all_sum', 'desc', 'CHECKED'), array($usersbuttom_2_traffic_UsersTrafficForm_5, 's_nick', '', '')); $num_rows = $DB->samsdb_query_value("SELECT * FROM sgroup WHERE s_group_id='{$id}' "); $row = $DB->samsdb_fetch_array(); PageTop("traffic_48.jpg", "{$grptraffic_1} <FONT COLOR=\"BLUE\"> " . $row['s_name'] . " </FONT><BR> {$groupbuttom_1_traffic_GroupTrafficForm_1}"); print "<FORM NAME=\"UserIDForm\" ACTION=\"main.php\">\n"; print "<INPUT TYPE=\"HIDDEN\" NAME=\"show\" id=Show value=\"exe\">\n"; print "<INPUT TYPE=\"HIDDEN\" NAME=\"function\" id=function value=\"grouptrafficperiod\">\n"; print "<INPUT TYPE=\"HIDDEN\" NAME=\"filename\" value=\"groupbuttom_2_traffic.php\">\n"; print "<INPUT TYPE=\"HIDDEN\" NAME=\"id\" value=\"{$id}\">\n"; $dateselect->SetPeriod2("{$usersbuttom_2_traffic_UsersTrafficForm_3}", $a); print "</FORM>\n"; }
function RedirListTray() { global $SAMSConf; global $USERConf; $DB = new SAMSDB(); $lang = "./lang/lang.{$SAMSConf->LANG}"; require $lang; if (isset($_GET["id"])) { $id = $_GET["id"]; } print "<SCRIPT>\n"; print " parent.basefrm.location.href=\"main.php?show=exe&filename=redirlisttray.php&function=redirlistform&id={$id}\";\n"; print "</SCRIPT> \n"; $num_rows = $DB->samsdb_query_value("SELECT * FROM redirect WHERE s_redirect_id='{$id}' "); $row = $DB->samsdb_fetch_array(); if ($USERConf->ToWebInterfaceAccess("LC") == 1) { print "<TABLE border=0 WIDTH=\"100%\">\n"; print "<TR HEIGHT=60>\n"; print "<TD WIDTH=25%>"; if ($row['s_type'] == "redir") { $type = "{$redirlisttray_RedirListTray_1}"; } if ($row['s_type'] == "replace") { $type = "{$redirlisttray_ReplaceListTray_1}"; } if ($row['s_type'] == "denied") { $type = "{$deniedlisttray_DeniedListTray_1}"; } if ($row['s_type'] == "allow") { $type = "{$allowlisttray_allowlisttray_1}"; } if ($row['s_type'] == "local") { $type = " {$redirlisttray_RedirListTray_2}"; } if ($row['s_type'] == "files") { $type = " {$filedeniedlisttray_filedeniedlisttray_1}"; } print "<B>{$type} <FONT SIZE=\"+1\" COLOR=\"blue\">{$row['s_name']}</FONT></B>\n"; ExecuteFunctions("./src", "redirbuttom", "1"); } print "<TD>\n"; print "</TABLE>\n"; }
function AuthLDAPValues() { global $SAMSConf; global $USERConf; if ($USERConf->ToWebInterfaceAccess("C") != 1) { exit(0); } $lang = "./lang/lang.{$SAMSConf->LANG}"; require $lang; $DB = new SAMSDB(); $DB2 = new SAMSDB(); PageTop("config_48.jpg", $lframe_sams_Auth_Title_LDAP_Config); print "<IMG SRC=\"{$SAMSConf->ICONSET}/help.jpg\">"; print "<A HREF=\"http://sams.perm.ru/sams2/doc/" . $SAMSConf->LANG . "/syncwithldap.html\">{$documentation}</A>"; print "<P>\n"; print "<TABLE CLASS=samstable WIDTH=\"90%\" BORDER=0>\n"; print "<TR bgcolor=blanchedalmond>\n"; print "<TD><B>Server</B>\n"; $value = GetAuthParameter("ldap", "ldapserver"); print "<TD>{$value} \n"; print "<TR bgcolor=blanchedalmond>\n"; print "<TD><B>Base DN</B>\n"; $value = GetAuthParameter("ldap", "basedn"); print "<TD>{$value} \n"; print "<TR bgcolor=blanchedalmond>\n"; print "<TD><B>Bind DN</B>\n"; $value = GetAuthParameter("ldap", "adadmin"); print "<TD>{$value}\n"; print "<TR bgcolor=blanchedalmond>\n"; print "<TD><B>Bind password</B>\n"; $value = GetAuthParameter("ldap", "adadminpasswd"); print "<TD>{$value}\n"; print "<TR bgcolor=blanchedalmond>\n"; print "<TD><B>Users RDN</B>\n"; $value = GetAuthParameter("ldap", "usersrdn"); print "<TD>{$value}\n"; print "<TR bgcolor=blanchedalmond>\n"; print "<TD><B>Users filter</B>\n"; $value = GetAuthParameter("ldap", "usersfilter"); print "<TD>{$value}\n"; print "<TR bgcolor=blanchedalmond>\n"; print "<TD><B>User name attribute</B>\n"; $value = GetAuthParameter("ldap", "usernameattr"); print "<TD>{$value}\n"; print "<TR bgcolor=blanchedalmond>\n"; print "<TD><B>Groups RDN</B>\n"; $value = GetAuthParameter("ldap", "groupsrdn"); print "<TD>{$value}\n"; print "<TR bgcolor=blanchedalmond>\n"; print "<TD><B>Groups filter</B>\n"; $value = GetAuthParameter("ldap", "groupsfilter"); print "<TD>{$value}\n"; print "</TABLE>\n"; print "<FORM NAME=\"ldapreconfigform\" ACTION=\"main.php\">\n"; print "<INPUT TYPE=\"HIDDEN\" NAME=\"show\" value=\"exe\">\n"; print "<INPUT TYPE=\"HIDDEN\" NAME=\"function\" value=\"ldaptest\">\n"; print "<INPUT TYPE=\"HIDDEN\" NAME=\"filename\" value=\"authldaptray.php\">\n"; print "<BR><INPUT TYPE=\"SUBMIT\" value=\"{$lframe_sams_Auth_LDAP_connections_test}\">\n"; print "</FORM>\n"; $num_rows = $DB->samsdb_query_value("select s_value from auth_param where s_auth='ldap' AND s_param='ldapgroup'"); if ($num_rows > 0) { print "<FORM NAME=\"rmsyncgroupform\" ACTION=\"main.php\">\n"; print "<INPUT TYPE=\"HIDDEN\" NAME=\"show\" value=\"exe\">\n"; print "<INPUT TYPE=\"HIDDEN\" NAME=\"function\" value=\"removesyncgroup\">\n"; print "<INPUT TYPE=\"HIDDEN\" NAME=\"filename\" value=\"authldaptray.php\">\n"; print "<SELECT NAME=\"rmsyncgroupname[]\" SIZE=3 TABINDEX=30 MULTIPLE>\n"; while ($row = $DB->samsdb_fetch_array()) { print "<OPTION VALUE=\"" . $row['s_value'] . "\"> " . $row['s_value'] . ""; } print "</SELECT>\n"; print "<BR><INPUT TYPE=\"SUBMIT\" value=\"{$AuthLDAPValues_authldaptray_1} \">\n"; print "</FORM>\n"; } $num_rows = $DB->samsdb_query_value("SELECT sgroup.s_name FROM sgroup "); if ($num_rows > 0) { print "<FORM NAME=\"addsyncgroupform\" ACTION=\"main.php\">\n"; print "<INPUT TYPE=\"HIDDEN\" NAME=\"show\" value=\"exe\">\n"; print "<INPUT TYPE=\"HIDDEN\" NAME=\"function\" value=\"addsyncgroup\">\n"; print "<INPUT TYPE=\"HIDDEN\" NAME=\"filename\" value=\"authldaptray.php\">\n"; print "<SELECT NAME=\"addsyncgroupname[]\" SIZE=3 TABINDEX=30 MULTIPLE>\n"; while ($row = $DB->samsdb_fetch_array()) { $QUERY = "SELECT * FROM auth_param WHERE s_param='ldapgroup' AND s_value='" . $row['s_name'] . "'"; $num_rows = $DB2->samsdb_query_value($QUERY); if ($num_rows == 0) { print "<OPTION VALUE=\"" . $row['s_name'] . "\"> " . $row['s_name'] . ""; } } print "</SELECT>\n"; print "<BR><INPUT TYPE=\"SUBMIT\" value=\"{$AuthLDAPValues_authldaptray_2}\">\n"; print "</FORM>\n"; } }