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