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 LoadBackUp() { global $SAMSConf; global $USERConf; $DB = new SAMSDB(); $lang = "./lang/lang.{$SAMSConf->LANG}"; require $lang; if ($USERConf->ToWebInterfaceAccess("C") != 1) { exit; } PageTop("reark_48.jpg", "{$backupbuttom_2_loadbase_LoadBackUp_1}"); if (($finp = gzopen($_FILES['userfile']['tmp_name'], "r")) != NULL) { while (gzeof($finp) == 0) { $string = gzgets($finp, 10000); $QUERY = strtok($string, ";"); if (strstr($QUERY, "#") == FALSE) { echo "{$QUERY}<BR>"; $num_rows = $DB->samsdb_query($QUERY . ";"); } $count++; } } print "<SCRIPT>\n"; 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 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 UpdateTRange() { global $SAMSConf; global $USERConf; $DB = new SAMSDB(); $lang = "./lang/lang.{$SAMSConf->LANG}"; require $lang; if (isset($_GET["id"])) { $id = $_GET["id"]; } if (isset($_GET["name"])) { $name = $_GET["name"]; } $timestart = ""; if (isset($_GET["shour"])) { $timestart = $_GET["shour"]; } if (isset($_GET["smin"])) { $timestart = $timestart . ":" . $_GET["smin"] . ":00"; } $timeend = ""; if (isset($_GET["ehour"])) { $timeend = $_GET["ehour"]; } if (isset($_GET["emin"])) { $timeend = $timeend . ":" . $_GET["emin"] . ":00"; } $days = ""; if (isset($_GET["day1"])) { $days = "M"; } if (isset($_GET["day2"])) { $days = $days . "T"; } if (isset($_GET["day3"])) { $days = $days . "W"; } if (isset($_GET["day4"])) { $days = $days . "H"; } if (isset($_GET["day5"])) { $days = $days . "F"; } if (isset($_GET["day6"])) { $days = $days . "A"; } if (isset($_GET["day7"])) { $days = $days . "S"; } if ($USERConf->ToWebInterfaceAccess("C") != 1) { exit; } $DB->samsdb_query("UPDATE timerange SET s_name='{$name}', s_days='{$days}', s_timestart='{$timestart}' , s_timeend='{$timeend}' WHERE s_trange_id='{$id}' "); // UpdateLog("$SAMSConf->adminname","$shablonnew_AddShablon_1 $snick","01"); print "<SCRIPT>\n"; print " parent.lframe.location.href=\"lframe.php\"; \n"; print " parent.tray.location.href=\"tray.php?show=exe&filename=trangetray.php&function=trangetray&id={$id}\"; \n"; print "</SCRIPT> \n"; }
function ClearUsersTrafficCounter() { global $SAMSConf; global $USERConf; $DB = new SAMSDB(); $lang = "./lang/lang.{$SAMSConf->LANG}"; require $lang; if ($USERConf->ToWebInterfaceAccess("C") == 1) { $num_rows = $DB->samsdb_query("UPDATE squiduser SET s_size='0', s_hit='0' "); print "<SCRIPT>\n"; print " parent.basefrm.location.href=\"main.php?show=exe&filename=userstray.php&function=AllUsersForm&type=all\";\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 shutdown_proxy() { global $SAMSConf; global $USERConf; $lang = "./lang/lang.{$SAMSConf->LANG}"; require $lang; if (isset($_GET["id"])) { $id = $_GET["id"]; } if ($USERConf->ToWebInterfaceAccess("C") == 1) { $DB = new SAMSDB(); PageTop("reconfig_48.jpg", "Send command '{$SAMSConf->SHUTDOWN}' to proxy server"); $QUERY = "INSERT INTO reconfig (s_proxy_id, s_service, s_action) VALUES('{$id}', 'squid', 'shutdown'); "; $result = $DB->samsdb_query($QUERY); } }
function ClearCounter() { global $SAMSConf; global $USERConf; $DB = new SAMSDB(); $lang = "./lang/lang.{$SAMSConf->LANG}"; require $lang; if ($USERConf->ToWebInterfaceAccess("C") != 1) { exit; } if (isset($_GET["id"])) { $id = $_GET["id"]; } $QUERY = "UPDATE proxy SET s_endvalue='0' WHERE s_proxy_id='{$id}'"; $DB->samsdb_query($QUERY); }
function AddPool() { global $SAMSConf; global $USERConf; $DB = new SAMSDB(); $lang = "./lang/lang.{$SAMSConf->LANG}"; require $lang; $agg1 = "-1"; $agg2 = "-1"; $net1 = "-1"; $net2 = "-1"; $ind1 = "-1"; $ind2 = "-1"; if (isset($_GET["name"])) { $name = $_GET["name"]; } if (isset($_GET["class"])) { $class = $_GET["class"]; } if (isset($_GET["agg1"])) { $agg1 = $_GET["agg1"]; } if (isset($_GET["agg2"])) { $agg2 = $_GET["agg2"]; } if (isset($_GET["net1"])) { $net1 = $_GET["net1"]; } if (isset($_GET["net2"])) { $net2 = $_GET["net2"]; } if (isset($_GET["ind1"])) { $ind1 = $_GET["ind1"]; } if (isset($_GET["ind2"])) { $ind2 = $_GET["ind2"]; } if ($USERConf->ToWebInterfaceAccess("C") != 1) { exit; } $DB->samsdb_query("INSERT INTO delaypool ( s_name, s_class, s_agg1, s_agg2, s_net1, s_net2, s_ind1, s_ind2 ) VALUES ( '{$name}', '{$class}', '{$agg1}', '{$agg2}', '{$net1}', '{$net2}', '{$ind1}', '{$ind2}' ) "); print "<SCRIPT>\n"; print " parent.lframe.location.href=\"lframe.php\"; \n"; print " parent.basefrm.location.href = \"main.php?show=exe&filename=pooltray.php&function=addpoolform\"; \n"; print "</SCRIPT> \n"; }
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_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_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 lffolder_5_z1_shablon() { global $SAMSConf; global $USERConf; $DB = new SAMSDB(); $lang = "./lang/lang.{$SAMSConf->LANG}"; require $lang; if ($USERConf->ToWebInterfaceAccess("C") == 1) { $item = array("classname" => "shablon", "icon" => "paddressbook.gif", "target" => "basefrm", "url" => "main.php?show=exe&function=newshablonform&filename=shablonnew.php", "text" => "{$lframe_sams_UserShablonFolder_1}"); treeFolder($item); $DB->samsdb_query("SELECT * FROM shablon ORDER BY s_name"); while ($row = $DB->samsdb_fetch_array()) { $item = array("classname" => "shablon", "target" => "tray", "url" => "tray.php?show=exe&function=shablontray&filename=shablontray.php&id={$row['s_shablon_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_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 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 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 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 DeleteProxy() { global $SAMSConf; global $USERConf; $DB = new SAMSDB(); $lang = "./lang/lang.{$SAMSConf->LANG}"; require $lang; if ($USERConf->ToWebInterfaceAccess("C") != 1) { exit; } if (isset($_GET["id"])) { $id = $_GET["id"]; } $QUERY = "DELETE FROM proxy WHERE s_proxy_id='{$id}'"; $DB->samsdb_query($QUERY); print "<SCRIPT>\n"; print " parent.lframe.location.href=\"lframe.php\";\n"; print " parent.basefrm.location.href = \"main.php?show=exe&function=cacheform&filename=squidtray.php&function=squidtray\"; \n"; print "</SCRIPT> \n"; }
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 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 DeleteTRange() { 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") { $DB->samsdb_query("DELETE FROM timerange WHERE s_trange_id='{$id}' "); } print "<SCRIPT>\n"; print " parent.lframe.location.href=\"lframe.php\";\n"; print " parent.basefrm.location.href=\"main.php?show=exe&filename=trangetray.php&function=addtrangeform\";\n"; print "</SCRIPT> \n"; }
function LoadRedirList() { global $SAMSConf; global $USERConf; $DB = new SAMSDB(); $lang = "./lang/lang.{$SAMSConf->LANG}"; require $lang; if (isset($_GET["listfilename"])) { $listfilename = $_GET["listfilename"]; } if (isset($_GET["type"])) { $type = $_GET["type"]; } if (isset($_GET["id"])) { $id = $_GET["id"]; } if ($USERConf->ToWebInterfaceAccess("CL") != 1) { exit; } $listfilename = $_FILES["userfile"]["name"]; PageTop("import_48.jpg", "{$redir_loadfurllist1} <BR>{$listfilename}"); $aaa = copy($_FILES["userfile"]["tmp_name"], "data/urllist.txt"); $finp = fopen("data/urllist.txt", "r"); if ($finp == FALSE) { echo "can't open sams config file data/urllist.txt<BR>"; exit(0); } while (feof($finp) == 0) { $string = fgets($finp, 10000); $string = trim($string); //print("INSERT INTO urls SET urls.url=\"$string\",type=\"$id\" <BR> "); if (strlen($string) > 1) { $DB->samsdb_query("INSERT INTO url (s_url, s_redirect_id) VALUES ('{$string}' , '{$id}') "); } } fclose($finp); print "<SCRIPT>\n"; print " parent.basefrm.location.href=\"main.php?show=exe&filename=redirlisttray.php&function=redirlistform&id={$id}\";\n"; print "</SCRIPT> \n"; }
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 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 ChUserPasswd() { global $SAMSConf; global $USERConf; global $SquidUSERConf; if (isset($_GET["id"])) { $id = $_GET["id"]; } $SquidUSERConf = new SAMSUSER(); $SquidUSERConf->sams_user($id); if ($USERConf->ToWebInterfaceAccess("AUC") == 1 || $USERConf->s_user_id == $SquidUSERConf->s_user_id && $USERConf->ToWebInterfaceAccess("W") == 1) { $DB = new SAMSDB(); $lang = "./lang/lang.{$SAMSConf->LANG}"; require $lang; if (isset($_GET["passw1"])) { $newpasswd = $_GET["passw1"]; } PageTop("userpasswd_48.jpg", " {$userbuttom_6_chpasswd_ChUserPasswd_1} <BR><FONT COLOR=\"BLUE\">{$SquidUSERConf->s_nick}</FONT>"); $passwd = crypt($newpasswd, substr($newpasswd, 0, 2)); $num_rows = $DB->samsdb_query("UPDATE squiduser SET s_passwd='{$passwd}' WHERE s_user_id='{$SquidUSERConf->s_user_id}'"); } }
function AuthEnabled() { global $SAMSConf; global $USERConf; if ($USERConf->ToWebInterfaceAccess("C") != 1) { exit(0); } if (isset($_GET["adld"])) { $adld = $_GET["adld"]; } if (isset($_GET["ntlm"])) { $ntlm = $_GET["ntlm"]; } if (isset($_GET["ldap"])) { $ldap = $_GET["ldap"]; } if (isset($_GET["ncsa"])) { $ncsa = $_GET["ncsa"]; } if (isset($_GET["ip"])) { $ip = $_GET["ip"]; } if ($ip == "on") { $ip = 1; } else { $ip = 0; } if ($adld == "on") { $adld = 1; } else { $adld = 0; } if ($ntlm == "on") { $ntlm = 1; } else { $ntlm = 0; } if ($ldap == "on") { $ldap = 1; } else { $ldap = 0; } if ($ncsa == "on") { $ncsa = 1; } else { $ncsa = 0; } $DB = new SAMSDB(); $num_rows = $DB->samsdb_query("UPDATE auth_param SET s_value='{$ip}' WHERE s_auth='ip' AND s_param='enabled' "); $num_rows = $DB->samsdb_query("UPDATE auth_param SET s_value='{$adld}' WHERE s_auth='adld' AND s_param='enabled' "); $num_rows = $DB->samsdb_query("UPDATE auth_param SET s_value='{$ntlm}' WHERE s_auth='ntlm' AND s_param='enabled' "); $num_rows = $DB->samsdb_query("UPDATE auth_param SET s_value='{$ldap}' WHERE s_auth='ldap' AND s_param='enabled' "); $num_rows = $DB->samsdb_query("UPDATE auth_param SET s_value='{$ncsa}' WHERE s_auth='ncsa' AND s_param='enabled' "); print "<SCRIPT>\n"; print " parent.basefrm.location.href=\"tray.php?show=exe&function=authtray&filename=authtray.php\";\n"; print " parent.lframe.location.href=\"lframe.php\";\n"; print "</SCRIPT> \n"; }