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