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";
}
