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 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 AllUsersForm()
{
global $SAMSConf;
global $USERConf;
$DB = new SAMSDB();
$DB2 = new SAMSDB();
$lang = "./lang/lang.{$SAMSConf->LANG}";
require $lang;
if ($USERConf->ToWebInterfaceAccess("AUCS") != 1) {
exit(0);
}
$groupname = "";
$type = "all";
if (isset($_GET["type"])) {
$type = $_GET["type"];
}
if (isset($_GET["username"])) {
$username = $_GET["username"];
}
PageTop("user.jpg", "{$grouptray_UserGroupForm_1}");
if ($USERConf->ToWebInterfaceAccess("UAC") == 1) {
print "<FORM NAME=\"searchform\" ACTION=\"main.php\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"show\" value=\"exe\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"filename\" value=\"userstray.php\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"function\" value=\"allusersform\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"type\" value=\"search\">\n";
print "{$userstray_AllUsersForm_13} \n";
print "<INPUT TYPE=\"TEXT\" NAME=\"username\" >\n";
print "<INPUT TYPE=\"SUBMIT\" VALUE=\"Search\" >\n";
print "</FORM>\n";
//show=exe&function=AllUsersForm&type=all
}
print "</TABLE>\n";
print "<SCRIPT language=JAVASCRIPT>\n";
print "function SendForm(formname)\n";
print "{\n";
print " var disable = new Array(); \n";
print " var defen = new Array(); \n";
print " var userdel = new Array(); \n";
print " var discount=0; \n";
print " var defcount=0; \n";
print " var delcount=0; \n";
print " var dis = \" \"; \n";
print " var def = \" \"; \n";
print " var del = \" \"; \n";
print " for(var i=0; i < groupform.counter.value; i +=1 ) \n";
print " {\n";
print " if(groupform.users[i].checked==false && groupform.dusers[i].value==\"1\")\n";
print " {\n";
print " disable[discount] = groupform.users[i].value; \n";
print " discount+=1; \n";
print " dis = dis + groupform.users[i].value + \" \"; \n";
print " }\n";
print " if(groupform.users[i].checked==true && ( groupform.dusers[i].value==\"-1\" || groupform.dusers[i].value==\"0\" ))\n";
print " {\n";
print " defen[defcount] = groupform.users[i].value; \n";
print " defcount+=1; \n";
print " def = def + groupform.users[i].value + \" \"; \n";
print " }\n";
print " if(groupform.userdel[i].checked==true)\n";
print " {\n";
print " userdel[delcount] = groupform.userdel[i].value; \n";
print " delcount+=1; \n";
print " del = del + groupform.userdel[i].value + \" \"; \n";
print " }\n";
print " }\n";
print " var strr= \"main.php?show=exe&filename=userstray.php&function=disableselectedusers&disable=\" + disable + \"&delete=\" + userdel + \"&defen=\" + defen + \"&delcount=\"+delcount+\"&discount=\"+discount + \"&defcount=\"+defcount \n";
// print(" var value=window.confirm( \"disable:\" + dis + \" delete: \" + del + \"default:\" + def );\n");
print " parent.basefrm.location.href=strr;\n";
print "}\n";
print "function EnableAll(formname)\n";
print "{\n";
print " for(var i=0; i < groupform.counter.value; i +=1 ) \n";
print " {\n";
print " if(groupform.users[i].checked==false )\n";
print " {\n";
print " groupform.users[i].checked=true; \n";
print " }\n";
print " }\n";
print "}\n";
print "function DisableAll(formname)\n";
print "{\n";
print " for(var i=0; i < groupform.counter.value; i +=1 ) \n";
print " {\n";
print " if(groupform.users[i].checked==true )\n";
print " {\n";
print " groupform.users[i].checked=false; \n";
print " }\n";
print " }\n";
print "}\n";
print "function DeleteAll(formname)\n";
print "{\n";
print " for(var i=0; i < groupform.counter.value; i +=1 ) \n";
print " {\n";
print " if(groupform.userdel[i].checked==false )\n";
print " {\n";
print " groupform.userdel[i].checked=true; \n";
print " }\n";
print " }\n";
print "}\n";
print "</SCRIPT> \n";
if ($USERConf->ToWebInterfaceAccess("UAC") == 1) {
print "<FORM NAME=\"groupform\" ACTION=\"main.php\" METHOD=\"post\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"show\" value=\"exe\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"filename\" value=\"userstray.php\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"function\" value=\"disableselectedusers\">\n";
print " <INPUT TYPE=\"BUTTON\" VALUE=\"{$userstray_AllUsersForm_8}\" onclick=SendForm(groupform) > \n";
}
print "<TABLE WIDTH=\"100%\" BORDER=0 CLASS=samstable>\n";
print "<THEAD>\n";
print "<TR>\n";
if ($USERConf->ToWebInterfaceAccess("UCGS") == 1) {
print "<TH WIDTH=\"10%\"> <B>{$userstray_AllUsersForm_1}</B> \n";
}
print "<TH WIDTH=\"15%\" bgcolor=beige> <B>{$userstray_AllUsersForm_2}</B>\n";
print "<TH WIDTH=\"10%\" bgcolor=beige> <B>{$userstray_AllUsersForm_3}</B>\n";
if ($USERConf->ToWebInterfaceAccess("UCS") == 1) {
print "<TH WIDTH=\"15%\" bgcolor=beige> <B>{$userstray_AllUsersForm_4}</B>\n";
print "<TH WIDTH=\"15%\" bgcolor=beige> <B>{$userstray_AllUsersForm_5}</B>\n";
print "<TH WIDTH=\"15%\" bgcolor=beige> <B>{$userstray_AllUsersForm_9}</B>\n";
}
print "<TH WIDTH=\"30%\" bgcolor=beige> <B>{$userstray_AllUsersForm_6}</B>\n";
if ($USERConf->ToWebInterfaceAccess("UAC") == 1) {
print "<TH WIDTH=\"15%\" bgcolor=beige> <B>{$userstray_AllUsersForm_7}</B>\n";
}
print "</THEAD>\n";
$count = 0;
if ($type == "search") {
$num_rows = $DB->samsdb_query_value("SELECT squiduser.*,sgroup.s_name AS gnick, shablon.s_period, shablon.s_clrdate, shablon.s_quote AS s_defquote, shablon.s_shablon_id2 as tpl2 FROM squiduser LEFT JOIN sgroup ON sgroup.s_group_id=squiduser.s_group_id LEFT JOIN shablon ON squiduser.s_shablon_id=shablon.s_shablon_id WHERE squiduser.s_nick like '%{$username}%' ORDER BY squiduser.s_shablon_id,squiduser.s_nick");
} else {
$num_rows = $DB->samsdb_query_value("SELECT squiduser.*,sgroup.s_name AS gnick, shablon.s_period, shablon.s_clrdate, shablon.s_quote AS s_defquote, shablon.s_shablon_id2 as tpl2 FROM squiduser LEFT JOIN sgroup ON sgroup.s_group_id=squiduser.s_group_id LEFT JOIN shablon ON squiduser.s_shablon_id=shablon.s_shablon_id ORDER BY squiduser.s_group_id,squiduser.s_nick");
}
print "<TBODY>\n";
while ($row = $DB->samsdb_fetch_array()) {
$clrdate = "";
$clrdays = 0;
print "<TR>\n";
if ($SAMSConf->realtraffic == "real") {
$traffic = $row['s_size'] - $row['s_hit'];
} else {
$traffic = $row['s_size'];
}
$defaultquote = $row['s_defquote'];
if ($row['s_enabled'] == 2) {
$gif = "user_moved.png";
if ($row['tpl2'] > 0) {
$num_rows2 = $DB2->samsdb_query_value("SELECT shablon.s_quote FROM shablon WHERE shablon.s_shablon_id={$row['tpl2']}");
if ($num_rows2 == 1) {
$row2 = $DB2->samsdb_fetch_array();
$defaultquote = $row2['s_quote'];
}
}
} else {
if ($row['s_enabled'] == 0) {
$gif = "user_inactive.png";
} else {
if ($row['s_enabled'] < 0) {
$gif = "user_off.png";
} else {
if ($row['s_enabled'] == 1) {
if ($row['s_quote'] * $SAMSConf->KBSIZE * $SAMSConf->KBSIZE >= $traffic || $row['s_quote'] <= 0) {
$gif = "user_active.png";
} else {
if ($row['s_quote'] > 0) {
$gif = "quote_alarm.gif";
}
}
}
}
}
}
if ($USERConf->ToWebInterfaceAccess("UACGS") == 1) {
print "<TD WIDTH=\"10%\">";
print "<IMG SRC=\"{$SAMSConf->ICONSET}/{$gif}\">";
}
if ($USERConf->ToWebInterfaceAccess("UAC") == 1) {
print " <INPUT TYPE=\"CHECKBOX\" NAME=\"users\" ID=\"{$count}\" VALUE=\"{$row['s_user_id']}\" ";
if ($row['s_enabled'] > 0) {
print " CHECKED ";
}
print "> \n ";
print " <INPUT TYPE=\"HIDDEN\" NAME=\"dusers\" ID=\"{$count}\" VALUE=\"{$row['s_enabled']}\" >";
}
print "<TD WIDTH=\"15%\"> <B><A HREF=\"tray.php?show=exe&filename=usertray.php&function=usertray&id={$row['s_user_id']}\" TARGET=\"tray\">{$row['s_nick']} </A></B>";
print "<TD WIDTH=\"15%\"> <B>{$row['gnick']} </B>";
if ($USERConf->ToWebInterfaceAccess("UCS") == 1) {
PrintFormattedSize($traffic);
$font_start = "";
$font_end = "";
if ($row['s_enabled'] == 2) {
$font_start = "<font color=#CFCF00>";
$font_end = "</font>";
}
if ($row['s_quote'] > 0) {
print "<TD WIDTH=\"15%\" ALIGN=CENTER><font color=red>{$row['s_quote']} Mb</font>";
} else {
if ($row['s_quote'] == 0) {
print "<TD WIDTH=\"15%\" ALIGN=CENTER><font color=red>unlimited</font>";
} else {
if ($defaultquote > 0) {
print "<TD WIDTH=\"15%\" ALIGN=CENTER>{$font_start} {$defaultquote} Mb {$font_end}";
} else {
print "<TD WIDTH=\"15%\" ALIGN=CENTER>{$font_start} unlimited {$font_end}";
}
}
}
if ($row['s_period'] != "M" && $row['s_period'] != "W" && $row['s_period'] != "D") {
$period = "{$row['period']} {$userstray_AllUsersForm_10}";
}
if ($row['s_period'] == "M") {
$period = "{$userstray_AllUsersForm_11}";
}
if ($row['s_period'] == "W") {
$period = "{$userstray_AllUsersForm_12}";
}
if ($row['s_period'] == "D") {
$period = "{$userstray_AllUsersForm_14}";
}
print "<TD WIDTH=\"15%\" ALIGN=CENTER> {$period} ";
}
print "<TD WIDTH=\"40%\"> {$row['s_family']} {$row['s_name']} {$row['s_soname']}";
if ($USERConf->ToWebInterfaceAccess("UC") == 1) {
print "<TD><INPUT TYPE=\"CHECKBOX\" NAME=\"userdel\" ID=\"{$count}\" VALUE=\"{$row['s_user_id']}\" > \n";
} else {
if ($USERConf->ToWebInterfaceAccess("A") == 1) {
print "<TD><INPUT TYPE=\"CHECKBOX\" NAME=\"userdel\" ID=\"{$count}\" VALUE=\"{$row['s_user_id']}\" DISABLED > \n";
}
}
$count = $count + 1;
}
print "</TBODY>\n";
if ($USERConf->ToWebInterfaceAccess("UAC") == 1) {
print "<TR><TD><INPUT TYPE=\"BUTTON\" VALUE=\"select all\" onclick=EnableAll(groupform) > \n";
print "<BR><INPUT TYPE=\"BUTTON\" VALUE=\"deselect all\" onclick=DisableAll(groupform) > \n";
print "<TD><TD><TD> \n";
}
if ($USERConf->ToWebInterfaceAccess("UC") == 1) {
print "<TD><TD><TD>\n";
}
if ($USERConf->ToWebInterfaceAccess("UC") == 1) {
print "<TD> <INPUT TYPE=\"BUTTON\" VALUE=\"select all\" onclick=DeleteAll(groupform) > \n";
} else {
if ($USERConf->ToWebInterfaceAccess("A") == 1) {
print "<TD> <INPUT TYPE=\"BUTTON\" VALUE=\"select all\" DISABLED > \n";
}
}
print "</TABLE>\n";
if ($USERConf->ToWebInterfaceAccess("UAC") == 1) {
print "<INPUT TYPE=\"HIDDEN\" NAME=\"counter\" value=\"{$count}\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"groupname\" value=\"{$groupname}\">\n";
}
if ($USERConf->ToWebInterfaceAccess("AUC") == 1) {
print " <INPUT TYPE=\"BUTTON\" VALUE=\"{$userstray_AllUsersForm_8}\" onclick=SendForm(groupform) > \n";
print "</FORM>\n";
}
}
function TestTable()
{
global $SAMSConf;
$DB = new SAMSDB();
$lang = "./lang/lang.{$SAMSConf->LANG}";
require $lang;
// TestWI();
$groupname = "";
$type = "all";
if (isset($_GET["type"])) {
$type = $_GET["type"];
}
if (isset($_GET["username"])) {
$username = $_GET["username"];
}
PageTop("user.jpg", "Test ");
print "</TABLE>\n";
print "<SCRIPT language=JAVASCRIPT>\n";
print "function SendForm(formname)\n";
print "{\n";
print " var disable = new Array(); \n";
print " var defen = new Array(); \n";
print " var userdel = new Array(); \n";
print " var discount=0; \n";
print " var defcount=0; \n";
print " var delcount=0; \n";
print " var dis = \" \"; \n";
print " var def = \" \"; \n";
print " var del = \" \"; \n";
print " for(var i=0; i < groupform.counter.value; i +=1 ) \n";
print " {\n";
print " if(groupform.users[i].checked==false && groupform.dusers[i].value==\"1\")\n";
print " {\n";
print " disable[discount] = groupform.users[i].value; \n";
print " discount+=1; \n";
print " dis = dis + groupform.users[i].value + \" \"; \n";
print " }\n";
print " if(groupform.users[i].checked==true && ( groupform.dusers[i].value==\"-1\" || groupform.dusers[i].value==\"0\" ))\n";
print " {\n";
print " defen[defcount] = groupform.users[i].value; \n";
print " defcount+=1; \n";
print " def = def + groupform.users[i].value + \" \"; \n";
print " }\n";
print " if(groupform.userdel[i].checked==true)\n";
print " {\n";
print " userdel[delcount] = groupform.userdel[i].value; \n";
print " delcount+=1; \n";
print " del = del + groupform.userdel[i].value + \" \"; \n";
print " }\n";
print " }\n";
print " var strr= \"main.php?show=exe&filename=userstray.php&function=disableselectedusers&disable=\" + disable + \"&delete=\" + userdel + \"&defen=\" + defen + \"&delcount=\"+delcount+\"&discount=\"+discount + \"&defcount=\"+defcount \n";
print " parent.basefrm.location.href=strr;\n";
print "}\n";
print " function fullArray( username)\n";
print "{\n";
print " this.username = username;\n";
print "}\n";
print "function SortTable(formname)\n";
print "{\n";
print " var table = new Array(); \n";
print " for(var i=0; i < groupform.counter.value; i +=1 ) \n";
print " {\n";
print " table[i] = new fullArray( groupform.username[i].value )\n";
print " }\n";
print " for(var i=0; i < groupform.counter.value; i +=1 ) \n";
print " {\n";
print " groupform.username[i].value=table[groupform.counter.value - i -1][1]\n";
print " }\n";
print "}\n";
print "</SCRIPT> \n";
if ($SAMSConf->access == 2) {
print "<FORM NAME=\"groupform\" ACTION=\"main.php\" METHOD=\"post\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"show\" value=\"exe\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"filename\" value=\"userstray.php\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"function\" value=\"disableselectedusers\">\n";
}
print "<TABLE WIDTH=\"100%\" BORDER=0 CLASS=samstable>\n";
print "<THEAD>\n";
print "<TR>\n";
if ($SAMSConf->access > 0) {
print "<TH WIDTH=\"10%\" onClick=SortTable(groupform)>\n";
print "<B>{$userstray_AllUsersForm_1}</B> \n";
}
print "<TH WIDTH=\"15%\" bgcolor=beige> <B>{$userstray_AllUsersForm_2}</B>\n";
print "<TH WIDTH=\"10%\" bgcolor=beige> <B>{$userstray_AllUsersForm_3}</B>\n";
if ($SAMSConf->access == 2) {
print "<TH WIDTH=\"15%\" bgcolor=beige> <B>{$userstray_AllUsersForm_4}</B>\n";
print "<TH WIDTH=\"15%\" bgcolor=beige> <B>{$userstray_AllUsersForm_5}</B>\n";
print "<TH WIDTH=\"15%\" bgcolor=beige> <B>{$userstray_AllUsersForm_9}</B>\n";
}
print "<TH WIDTH=\"30%\" bgcolor=beige> <B>{$userstray_AllUsersForm_6}</B>\n";
if ($SAMSConf->access == 2) {
print "<TH WIDTH=\"15%\" bgcolor=beige> <B>{$userstray_AllUsersForm_7}</B>\n";
}
$count = 0;
if ($type == "search") {
$num_rows = $DB->samsdb_query_value("SELECT squiduser.*,sgroup.s_name AS gnick, shablon.s_period, shablon.s_clrdate FROM squiduser LEFT JOIN sgroup ON sgroup.s_group_id=squiduser.s_group_id LEFT JOIN shablon ON squiduser.s_shablon_id=shablon.s_shablon_id WHERE squiduser.s_nick like '%{$username}%' ORDER BY squiduser.s_shablon_id,squiduser.s_nick");
} else {
$num_rows = $DB->samsdb_query_value("SELECT squiduser.*,sgroup.s_name AS gnick, shablon.s_period, shablon.s_clrdate FROM squiduser LEFT JOIN sgroup ON sgroup.s_group_id=squiduser.s_group_id LEFT JOIN shablon ON squiduser.s_shablon_id=shablon.s_shablon_id ORDER BY squiduser.s_group_id,squiduser.s_nick");
}
print "</THEAD><TBODY>\n";
while ($row = $DB->samsdb_fetch_array()) {
$clrdate = "";
$clrdays = 0;
print "<TR>\n";
if ($row['s_enabled'] == 2) {
$gif = "user_moved.png";
} else {
if ($row['s_enabled'] == 0) {
$gif = "user_inactive.png";
} else {
if ($row['s_enabled'] < 0) {
$gif = "user_off.png";
} else {
if ($row['s_enabled'] == 1) {
if ($SAMSConf->realtraffic == "real") {
$traffic = $row['s_size'] - $row['s_hit'];
} else {
$traffic = $row['s_size'];
}
if ($row['s_quote'] * $SAMSConf->KBSIZE * $SAMSConf->KBSIZE >= $traffic || $row['s_quote'] <= 0) {
$gif = "user_active.png";
} else {
if ($row['s_quote'] > 0) {
$gif = "quote_alarm.gif";
}
}
}
}
}
}
if ($SAMSConf->access > 0) {
print "<TD WIDTH=\"10%\" NAME=\"enabled\" ID=\"{$count}\">";
print "<IMG SRC=\"{$SAMSConf->ICONSET}/{$gif}\">";
}
if ($SAMSConf->access == 2) {
print " <INPUT TYPE=\"CHECKBOX\" NAME=\"users\" ID=\"{$count}\" VALUE=\"{$row['s_user_id']}\" ";
if ($row['s_enabled'] > 0) {
print " CHECKED ";
}
print "> \n ";
print " <INPUT TYPE=\"HIDDEN\" NAME=\"dusers\" ID=\"{$count}\" VALUE=\"{$row['s_enabled']}\" >";
}
print "<TD WIDTH=\"15%\" NAME=\"username\" ID=\"{$count}\"> <B><A HREF=\"tray.php?show=exe&filename=usertray.php&function=usertray&id={$row['s_user_id']}\" TARGET=\"tray\">{$row['s_nick']} </A></B>";
print "<TD WIDTH=\"15%\" NAME=\"group\" ID=\"{$count}\"> <B>{$row['gnick']} </B>";
if ($SAMSConf->access == 2) {
if ($SAMSConf->realtraffic == "real") {
PrintFormattedSize($row['s_size'] - $row['s_hit']);
} else {
PrintFormattedSize($row['s_size']);
}
if ($row['s_quote'] > 0) {
print "<TD WIDTH=\"15%\" NAME=\"quote\" ID=\"{$count}\" ALIGN=CENTER> {$row['s_quote']} Mb";
} else {
print "<TD WIDTH=\"15%\" NAME=\"quote\" ID=\"{$count}\" ALIGN=CENTER> unlimited ";
}
if ($row['s_period'] != "M" && $row['s_period'] != "W") {
$period = "{$row['period']} {$userstray_AllUsersForm_10}";
}
if ($row['s_period'] == "M") {
$period = "{$userstray_AllUsersForm_11}";
}
if ($row['s_period'] == "W") {
$period = "{$userstray_AllUsersForm_12}";
}
print "<TD WIDTH=\"15%\" NAME=\"period\" ID=\"{$count}\" ALIGN=CENTER> {$period} ";
}
print "<TD WIDTH=\"40%\" NAME=\"fio\" ID=\"{$count}\"> {$row['s_family']} {$row['s_name']} {$row['s_soname']}";
if ($SAMSConf->access == 2) {
print "<TD NAME=\"delete\" ID=\"{$count}\"><INPUT TYPE=\"CHECKBOX\" NAME=\"userdel\" ID=\"{$count}\" VALUE=\"{$row['s_user_id']}\" > \n";
}
$count = $count + 1;
}
print "<TR><TD><INPUT TYPE=\"BUTTON\" VALUE=\"select all\" onclick=EnableAll(groupform) > \n";
print "<BR><INPUT TYPE=\"BUTTON\" VALUE=\"deselect all\" onclick=DisableAll(groupform) > \n";
print "<TD><TD><TD><TD><TD><TD><TD> \n";
print "</TBODY>\n";
print "</TABLE>\n";
if ($SAMSConf->access == 2) {
print "<INPUT TYPE=\"HIDDEN\" NAME=\"counter\" value=\"{$count}\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"groupname\" value=\"{$groupname}\">\n";
print "</FORM>\n";
}
}
function UserSitesPeriod_new()
{
global $SAMSConf;
global $DATE;
global $USERConf;
global $SquidUSERConf;
if (isset($_GET["id"])) {
$id = $_GET["id"];
}
$SquidUSERConf = new SAMSUSER();
$SquidUSERConf->sams_user($id);
require "reportsclass.php";
$DB = new SAMSDB();
$lang = "./lang/lang.{$SAMSConf->LANG}";
require $lang;
if (isset($_GET["username"])) {
$username = $_GET["username"];
}
if (isset($_GET["userdomain"])) {
$userdomain = $_GET["userdomain"];
}
if (isset($_GET["userid"])) {
$userid = $_GET["userid"];
}
if (isset($_GET["usergroup"])) {
$usergroup = $_GET["usergroup"];
}
if ($USERConf->ToWebInterfaceAccess("GSC") != 1 && ($USERConf->s_user_id != $SquidUSERConf->s_user_id && $USERConf->ToWebInterfaceAccess("W") != 1)) {
exit(0);
}
$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;
$dateselect = new DATESELECT($DATE->sdate(), $DATE->edate());
PageTop("straffic_48.jpg", "{$traffic_1} <FONT COLOR=\"BLUE\">{$SquidUSERConf->s_nick}</FONT><BR>{$userbuttom_4_site_UserSitesPeriod_2}");
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=\"usersitesperiod\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"filename\" id=filename value=\"userbuttom_4_site.php\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"id\" id=id value=\"{$SquidUSERConf->s_user_id}\">\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> ");
print "<TABLE CLASS=samstable>";
print "<TH WIDTH=6%>No";
print "<TH WIDTH=20%>Domain";
print "<TH WIDTH=20%>URL";
if ($USERConf->ToWebInterfaceAccess("C") == 1) {
print "<TH WIDTH=15%>{$userbuttom_4_site_UserSitesPeriod_3}";
print "<TH WIDTH=15%>{$userbuttom_4_site_UserSitesPeriod_4}";
}
print "<TH WIDTH=15%>{$userbuttom_4_site_UserSitesPeriod_5}";
$URL = array("url_domain" => array(), "norm_url" => array(), "url_size" => array(), "hit_size" => array(), "sum_size" => array());
$query = "SELECT substring( s_url from position('//' in s_url)+2 for position('/' in substring(s_url from position('/' in s_url)+2 )) ) as url_domain,sum(s_size) as url_size,sum(s_hit) as hit_size FROM squidcache WHERE lower(s_user)=lower('" . $SquidUSERConf->s_nick . "') AND s_date>='{$sdate}'AND s_date<='{$edate}' AND s_method!='CONNECT' GROUP BY url_domain ORDER BY url_domain desc limit 25000";
$num_rows = $DB->samsdb_query_value($query);
$count = 0;
$cache = 0;
$counter = 0;
$url_domain = "";
while ($row = $DB->samsdb_fetch_array()) {
if (strlen($row['url_domain']) > 0) {
$url_domain = explode(".", str_replace("/", "", $row['url_domain']));
$ucount = count($url_domain);
$URL["url_domain"][$count] = $url_domain[$ucount - 2] . "." . $url_domain[$ucount - 1];
$URL["norm_url"][$count] = str_replace("/", "", $row['url_domain']);
$URL["url_size"][$count] = $row['url_size'];
$URL["hit_size"][$count] = $row['hit_size'];
// if($SAMSConf->realtraffic=="real")
$URL["sum_size"][$count] = $row['url_size'] - $row['hit_size'];
// else
// $URL["sum_size"][$count]=$row['url_size'];
$count++;
}
}
$query = "SELECT substring( s_url from 0 for position(':' in s_url) ) as url_domain,sum(s_size) as url_size,sum(s_hit) as hit_size FROM squidcache WHERE lower(s_user)=lower('" . $SquidUSERConf->s_nick . "') AND s_date>='{$sdate}'AND s_date<='{$edate}' AND s_method='CONNECT' GROUP BY url_domain ORDER BY url_domain desc limit 25000;";
$num_rows = $DB->samsdb_query_value($query);
while ($row = $DB->samsdb_fetch_array()) {
if (strlen($row['url_domain']) > 0) {
$url_domain = explode(".", str_replace("/", "", $row['url_domain']));
$ucount = count($url_domain);
$URL["url_domain"][$count] = $url_domain[$ucount - 2] . "." . $url_domain[$ucount - 1];
$URL["norm_url"][$count] = str_replace("/", "", $row['url_domain']);
$URL["url_size"][$count] = $row['url_size'];
$URL["hit_size"][$count] = $row['hit_size'];
// if($SAMSConf->realtraffic=="real")
$URL["sum_size"][$count] = $row['url_size'] - $row['hit_size'];
// else
// $URL["sum_size"][$count]=$row['url_size'];
$count++;
}
}
asort($URL["url_domain"]);
reset($URL["url_domain"]);
$count = 0;
$url_size_value = 0;
$hit_size_value = 0;
$sum_size_value = 0;
$url_domain_size_value = 0;
$hit_domain_size_value = 0;
$sum_domain_size_value = 0;
while (list($key, $val) = each($URL["url_domain"])) {
print "<TR>";
if ($url_domain != $val) {
if ($count != 0) {
echo "<TD colspan=3> ";
RBTableCell(FormattedString($url_domain_size_value), 15);
RBTableCell(FormattedString($hit_domain_size_value), 15);
RBTableCell(FormattedString($sum_domain_size_value), 15);
$url_domain_size_value = 0;
$hit_domain_size_value = 0;
$sum_domain_size_value = 0;
echo "<TR>";
}
$q = $count + 1;
echo "<TD>{$q}\n";
if (ctype_alpha($val[strlen($val) - 1]) == TRUE) {
print "<TD colspan=5><A HREF=\"http://{$val}\" TARGET=\"BLANK\"><B>{$val}</B></A>\n";
} else {
print "<TD colspan=5><A HREF=\"http://" . $URL["norm_url"][$key] . "\" TARGET=\"BLANK\"><B>" . $URL["norm_url"][$key] . "</B></A>\n";
}
$url_domain = $val;
$count++;
print "<TR>";
print "<TD colspan=2>\n";
RTableCell("<A HREF=\"main.php?show=exe&filename=userbuttom_4_site.php&function=showloadingfilesfromdomain&id={$id}&SDay={$sday}&SMon={$smon}&SYea={$syea}&EDay={$eday}&EMon={$emon}&EYea={$eyea}&url=" . $URL["norm_url"][$key] . "\" TARGET=\"BLANK\" >" . $URL["norm_url"][$key] . "</A>\n", 15);
RTableCell(FormattedString($URL["url_size"][$key]), 15);
RTableCell(FormattedString($URL["hit_size"][$key]), 15);
RTableCell(FormattedString($URL["sum_size"][$key]), 15);
$url_size_value += $URL["url_size"][$key];
$hit_size_value += $URL["hit_size"][$key];
$sum_size_value += $URL["sum_size"][$key];
$url_domain_size_value += $URL["url_size"][$key];
$hit_domain_size_value += $URL["hit_size"][$key];
$sum_domain_size_value += $URL["sum_size"][$key];
} else {
print "<TD colspan=2>\n";
RTableCell("<A HREF=\"main.php?show=exe&filename=userbuttom_4_site.php&function=showloadingfilesfromdomain&id={$id}&SDay={$sday}&SMon={$smon}&SYea={$syea}&EDay={$eday}&EMon={$emon}&EYea={$eyea}&url=" . $URL["norm_url"][$key] . "\" TARGET=\"BLANK\" >" . $URL["norm_url"][$key] . "</A>\n", 15);
RTableCell(FormattedString($URL["url_size"][$key]), 15);
RTableCell(FormattedString($URL["hit_size"][$key]), 15);
RTableCell(FormattedString($URL["sum_size"][$key]), 15);
$url_size_value += $URL["url_size"][$key];
$hit_size_value += $URL["hit_size"][$key];
$sum_size_value += $URL["sum_size"][$key];
$url_domain_size_value += $URL["url_size"][$key];
$hit_domain_size_value += $URL["hit_size"][$key];
$sum_domain_size_value += $URL["sum_size"][$key];
}
}
print "<TR>";
echo "<TD colspan=3> ";
RBTableCell(FormattedString($url_domain_size_value), 15);
RBTableCell(FormattedString($hit_domain_size_value), 15);
RBTableCell(FormattedString($sum_domain_size_value), 15);
print "<TR>";
print "<TD colspan=3>\n";
// RBTableCell(FormattedString($url_size_value),15);
PrintFormattedSize($url_size_value);
// RBTableCell(FormattedString($hit_size_value),15);
PrintFormattedSize($hit_size_value);
// RBTableCell(FormattedString($sum_size_value),15);
// if($SAMSConf->realtraffic=="real")
PrintFormattedSize($url_size_value - $hit_size_value);
// else
// PrintFormattedSize($url_size_value);
print "</TABLE>";
}
function UserGroupForm()
{
global $SAMSConf;
global $USERConf;
$DB = new SAMSDB();
$lang = "./lang/lang.{$SAMSConf->LANG}";
require $lang;
if (isset($_GET["id"])) {
$id = $_GET["id"];
}
if (isset($_GET["gid"])) {
$gid = $_GET["gid"];
}
$ga = 0;
$num_rows = $DB->samsdb_query_value("SELECT * FROM sgroup WHERE s_group_id='{$id}' ");
$row = $DB->samsdb_fetch_array();
$gname = $row['s_name'];
if ($SAMSConf->groupauditor == $row['s_name']) {
$ga = 1;
}
PageTop("user.jpg", "{$grouptray_UserGroupForm_1}.<BR>{$grouptray_UserGroupForm_2} <FONT COLOR=\"blue\">{$gname}</FONT>");
print "<SCRIPT language=JAVASCRIPT>\n";
print "function SendForm(formname)\n";
print "{\n";
print " var disable = new Array(); \n";
print " var defen = new Array(); \n";
print " var userdel = new Array(); \n";
print " var discount=0; \n";
print " var defcount=0; \n";
print " var delcount=0; \n";
print " var dis = \" \"; \n";
print " var def = \" \"; \n";
print " var del = \" \"; \n";
print " for(var i=0; i < groupform.counter.value; i +=1 ) \n";
print " {\n";
print " if(groupform.users[i].checked==false && groupform.dusers[i].value==\"1\")\n";
print " {\n";
print " disable[discount] = groupform.users[i].value; \n";
print " discount+=1; \n";
print " dis = dis + groupform.users[i].value + \" \"; \n";
print " }\n";
print " if(groupform.users[i].checked==true && ( groupform.dusers[i].value==\"-1\" || groupform.dusers[i].value==\"0\" ))\n";
print " {\n";
print " defen[defcount] = groupform.users[i].value; \n";
print " defcount+=1; \n";
print " def = def + groupform.users[i].value + \" \"; \n";
print " }\n";
print " if(groupform.userdel[i].checked==true)\n";
print " {\n";
print " userdel[delcount] = groupform.userdel[i].value; \n";
print " delcount+=1; \n";
print " del = del + groupform.userdel[i].value + \" \"; \n";
print " }\n";
print " }\n";
print " var strr= \"main.php?show=exe&filename=grouptray.php&function=disablegroupusers&disable=\" + disable + \"&delete=\" + userdel + \"&defen=\" + defen + \"&delcount=\"+delcount+\"&discount=\"+discount + \"&defcount=\"+defcount +\"&id={$id}\" \n";
// print(" var value=window.confirm( \"disable:\" + dis + \" delete: \" + del + \"default:\" + def );\n");
print " parent.basefrm.location.href=strr;\n";
print "}\n";
print "function EnableAll(formname)\n";
print "{\n";
print " for(var i=0; i < groupform.counter.value; i +=1 ) \n";
print " {\n";
print " if(groupform.users[i].checked==false )\n";
print " {\n";
print " groupform.users[i].checked=true; \n";
print " }\n";
print " }\n";
print "}\n";
print "function DisableAll(formname)\n";
print "{\n";
print " for(var i=0; i < groupform.counter.value; i +=1 ) \n";
print " {\n";
print " if(groupform.users[i].checked==true )\n";
print " {\n";
print " groupform.users[i].checked=false; \n";
print " }\n";
print " }\n";
print "}\n";
print "function DeleteAll(formname)\n";
print "{\n";
print " for(var i=0; i < groupform.counter.value; i +=1 ) \n";
print " {\n";
print " if(groupform.userdel[i].checked==false )\n";
print " {\n";
print " groupform.userdel[i].checked=true; \n";
print " }\n";
print " }\n";
print "}\n";
print "</SCRIPT> \n";
if ($USERConf->ToWebInterfaceAccess("C") == 1) {
print "<FORM NAME=\"groupform\" ACTION=\"main.php\" METHOD=\"post\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"show\" value=\"exe\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"filename\" value=\"grouptray.php\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"function\" value=\"disablegroupusers\">\n";
print " <INPUT TYPE=\"BUTTON\" VALUE=\"{$userstray_AllUsersForm_8}\" onclick=SendForm(groupform) > \n";
}
print "<TABLE WIDTH=\"100%\" BORDER=0 CLASS=samstable>\n";
if ($USERConf->ToWebInterfaceAccess("CGS") == 1) {
print "<TH WIDTH=\"10%\">";
print "<B>{$grouptray_NewGroupForm_3}</B></TH>\n";
}
print "<TH WIDTH=\"15%\" bgcolor=beige> <B>{$grouptray_NewGroupForm_4}</B></TH>\n";
if ($USERConf->ToWebInterfaceAccess("C") == 1) {
print "<TH WIDTH=\"10%\" bgcolor=beige> <B>{$grouptray_NewGroupForm_5}</B></TH>\n";
}
if ($USERConf->ToWebInterfaceAccess("C") == 1 || $ga == 1) {
print "<TH WIDTH=\"15%\" bgcolor=beige ALIGN=CENTER> <B>{$grouptray_NewGroupForm_6}</B></TH>\n";
print "<TH WIDTH=\"15%\" bgcolor=beige ALIGN=CENTER> <B>{$grouptray_NewGroupForm_7}</B></TH>\n";
}
print "<TH WIDTH=\"40%\" bgcolor=beige> <B>{$grouptray_NewGroupForm_8}</B></TH>\n";
if ($USERConf->ToWebInterfaceAccess("UAC") == 1) {
print "<TH WIDTH=\"15%\" bgcolor=beige> <B>{$userstray_AllUsersForm_7}</B>\n";
}
$DB->free_samsdb_query();
$count = 0;
$num_rows = $DB->samsdb_query_value("SELECT squiduser.*, shablon.s_quote AS s_defquote FROM squiduser, shablon WHERE squiduser.s_group_id='{$id}' AND squiduser.s_shablon_id=shablon.s_shablon_id ORDER BY squiduser.s_nick");
while ($row = $DB->samsdb_fetch_array()) {
print "<TR>\n";
if ($row['s_enabled'] > 0) {
if ($SAMSConf->realtraffic == "real") {
$traffic = $row['s_size'] - $row['s_hit'];
} else {
$traffic = $row['s_size'];
}
if ($row['s_quote'] * $SAMSConf->KBSIZE * $SAMSConf->KBSIZE >= $traffic || $row['s_quote'] <= 0) {
$gif = "user_active.png";
} else {
if ($row['s_quote'] > 0) {
$gif = "quote_alarm.gif";
}
}
}
if ($row['s_enabled'] == 0) {
$gif = "puserd.gif";
}
if ($row['s_enabled'] < 0) {
$gif = "duserd.gif";
}
if ($USERConf->ToWebInterfaceAccess("CGS") == 1) {
print " <TD WIDTH=\"10%\">";
print "<IMG SRC=\"{$SAMSConf->ICONSET}/{$gif}\">";
}
if ($USERConf->ToWebInterfaceAccess("C") == 1) {
print " <INPUT TYPE=\"CHECKBOX\" NAME=\"users\" ID=\"{$count}\" VALUE=\"{$row['s_user_id']}\" ";
if ($row['s_enabled'] > 0) {
print " CHECKED ";
}
print "></TD>\n";
print " <INPUT TYPE=\"HIDDEN\" NAME=\"dusers\" ID=\"{$count}\" VALUE=\"{$row['s_enabled']}\" >";
}
print " <TD WIDTH=\"15%\"> <B><A HREF=\"tray.php?show=exe&filename=usertray.php&function=usertray&id={$row['s_user_id']}\" TARGET=\"tray\">{$row['s_nick']} </A></B></TD>\n";
if ($USERConf->ToWebInterfaceAccess("C") == 1) {
print " <TD WIDTH=\"15%\"> <B>{$row['s_domain']}</B></TD>\n";
}
if ($USERConf->ToWebInterfaceAccess("C") == 1 || $ga == 1) {
if ($SAMSConf->realtraffic == "real") {
PrintFormattedSize($row['s_size'] - $row['s_hit']);
} else {
PrintFormattedSize($row['s_size']);
}
if ($row['s_quote'] > 0) {
print " <TD WIDTH=\"15%\" ALIGN=CENTER><font color=red>{$row['s_quote']} Mb</font></TD>\n";
} else {
if ($row['s_quote'] == 0) {
print " <TD WIDTH=\"15%\" ALIGN=CENTER><font color=red>unlimited</font></TD>\n";
} else {
if ($row['s_defquote'] > 0) {
print " <TD WIDTH=\"15%\" ALIGN=CENTER>{$row['s_defquote']} Mb</TD>\n";
} else {
print " <TD WIDTH=\"15%\" ALIGN=CENTER>unlimited</TD>\n";
}
}
}
}
print " <TD WIDTH=\"40%\"> {$row['s_family']} {$row['s_name']} {$row['s_soname']}</TD>\n";
if ($USERConf->ToWebInterfaceAccess("UC") == 1) {
print "<TD><INPUT TYPE=\"CHECKBOX\" NAME=\"userdel\" ID=\"{$count}\" VALUE=\"{$row['s_user_id']}\" > \n";
} else {
if ($USERConf->ToWebInterfaceAccess("A") == 1) {
print "<TD><INPUT TYPE=\"CHECKBOX\" NAME=\"userdel\" ID=\"{$count}\" VALUE=\"{$row['s_user_id']}\" DISABLED > \n";
}
}
$count = $count + 1;
}
if ($USERConf->ToWebInterfaceAccess("UAC") == 1) {
print "<TR><TD><INPUT TYPE=\"BUTTON\" VALUE=\"select all\" onclick=EnableAll(groupform) > \n";
print "<BR><INPUT TYPE=\"BUTTON\" VALUE=\"deselect all\" onclick=DisableAll(groupform) > \n";
print "<TD><TD><TD> \n";
}
if ($USERConf->ToWebInterfaceAccess("UC") == 1) {
print "<TD><TD>\n";
}
if ($USERConf->ToWebInterfaceAccess("UC") == 1) {
print "<TD> <INPUT TYPE=\"BUTTON\" VALUE=\"select all\" onclick=DeleteAll(groupform) > \n";
} else {
if ($USERConf->ToWebInterfaceAccess("A") == 1) {
print "<TD> <INPUT TYPE=\"BUTTON\" VALUE=\"select all\" DISABLED > \n";
}
}
print "</TABLE>\n";
$DB->free_samsdb_query();
if ($USERConf->ToWebInterfaceAccess("C") == 1) {
print "<INPUT TYPE=\"HIDDEN\" NAME=\"counter\" value=\"{$count}\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"id\" value=\"{$id}\">\n";
print " <INPUT TYPE=\"BUTTON\" VALUE=\"{$userstray_AllUsersForm_8}\" onclick=SendForm(groupform) > \n";
print "</FORM>\n";
}
if ($USERConf->ToWebInterfaceAccess("C") == 1) {
print "<SCRIPT language=JAVASCRIPT>\n";
print "function SelectUsers(id)\n";
print "{\n";
print " var group = \"main.php?show=exe&filename=grouptray.php&function=usergroupform&id={$id}&gid=\" + id ; \n";
print " parent.basefrm.location.href=group;\n";
print "}\n";
print "</SCRIPT>\n";
print "<P><B>{$grouptray_NewGroupForm_10} {$gname}:</B> ";
print "<FORM NAME=\"moveform\" ACTION=\"main.php\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"show\" value=\"exe\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"filename\" value=\"grouptray.php\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"function\" value=\"moveuserstogroup\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"id\" value=\"{$id}\">\n";
print "<SELECT NAME=\"groupid\" onchange=SelectUsers(moveform.groupid.value)>\n";
$num_rows = $DB->samsdb_query_value("SELECT * FROM sgroup WHERE s_group_id!='{$id}' ORDER BY s_name");
if ($gid == "ALL") {
print "<OPTION VALUE=\"ALL\" SELECTED> ALL\n";
} else {
print "<OPTION VALUE=\"ALL\"> ALL\n";
}
while ($row = $DB->samsdb_fetch_array()) {
$SECTED = "";
if ($row['s_group_id'] == $gid) {
$SECTED = "SELECTED";
}
if ($row['s_group_id'] != $id) {
print "<OPTION VALUE=\"{$row['s_group_id']}\" {$SECTED}> {$row['s_name']}\n";
}
}
print "</SELECT>\n";
$DB->free_samsdb_query();
print "<SELECT NAME=\"username[]\" SIZE=10 MULTIPLE>\n";
if ($gid == "ALL") {
$num_rows = $DB->samsdb_query_value("SELECT * FROM squiduser WHERE s_group_id!='{$id}' ORDER BY s_nick");
} else {
$num_rows = $DB->samsdb_query_value("SELECT * FROM squiduser WHERE s_group_id='{$gid}' ORDER BY s_nick ");
}
while ($row = $DB->samsdb_fetch_array()) {
print "<OPTION VALUE={$row['s_user_id']}> {$row['s_nick']}\n";
}
print "</SELECT>\n";
print " <P><INPUT TYPE=\"SUBMIT\" VALUE=\"{$grouptray_NewGroupForm_11} '{$gname}'\" \n> ";
print "</TABLE> ";
}
}
