function DeleteGroup()
{
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 count(*) FROM squiduser WHERE s_group_id='{$id}' ");
$row = $DB->samsdb_fetch_array();
$count = $row[0];
$DB->free_samsdb_query();
if ($count > 0) {
NotEmptyGroupWarning($id);
} else {
$num_rows = $DB->samsdb_query_value("SELECT s_name FROM sgroup WHERE s_group_id='{$id}' ");
$row = $DB->samsdb_fetch_array();
$gname = $row['s_name'];
$DB->free_samsdb_query();
$QUERY = "DELETE FROM sgroup WHERE s_group_id='{$id}' ";
$num_rows = $DB->samsdb_query($QUERY);
// $QUERY="delete from auth_param where (s_param='adldgroup' OR s_param='ntlmgroup' OR s_param='ldapgroup') AND s_value='$gname'";
// $num_rows=$DB->samsdb_query($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 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 AddShablon()
{
global $SAMSConf;
global $USERConf;
$DB = new SAMSDB();
$lang = "./lang/lang.{$SAMSConf->LANG}";
require $lang;
if ($USERConf->ToWebInterfaceAccess("C") != 1) {
exit;
}
$period = "M";
$clrdate = "1980-01-01";
if (isset($_GET["groupnick"])) {
$snick = $_GET["groupnick"];
}
if (isset($_GET["defaulttraf"])) {
$defaulttraf = $_GET["defaulttraf"];
}
if (isset($_GET["auth"])) {
$auth = $_GET["auth"];
}
if (isset($_GET["period"])) {
$period = $_GET["period"];
}
if (isset($_GET["newperiod"])) {
$newperiod = $_GET["newperiod"];
}
if (isset($_GET["clryear"])) {
$clryear = $_GET["clryear"];
}
if (isset($_GET["clrmonth"])) {
$clrmonth = $_GET["clrmonth"];
}
if (isset($_GET["clrday"])) {
$clrday = $_GET["clrday"];
}
if (isset($_GET["trange"])) {
$trange = $_GET["trange"];
}
if ($period == "A") {
$period = $newperiod;
$clrdate = "{$clryear}-{$clrmonth}-{$clrday}";
}
$QUERY = "INSERT INTO shablon ( s_name, s_quote, s_auth, s_period, s_clrdate, s_alldenied, s_shablon_id2 ) VALUES ( '{$snick}', '{$defaulttraf}', '{$auth}', '{$period}', '{$clrdate}', '0', '-1' ) ";
$DB->samsdb_query($QUERY);
$DB->samsdb_query_value("SELECT s_shablon_id FROM shablon WHERE s_name='{$snick}' ");
$row = $DB->samsdb_fetch_array();
$sid = $row['s_shablon_id'];
$DB->free_samsdb_query();
$DB->samsdb_query("INSERT INTO sconfig_time ( s_shablon_id, s_trange_id ) VALUES ( '{$sid}', '{$trange}' ) ");
// UpdateLog("$SAMSConf->adminname","$shablonnew_AddShablon_1 $snick","01");
print "<SCRIPT>\n";
print " parent.lframe.location.href=\"lframe.php\"; \n";
print " parent.basefrm.location.href =\"tray.php?show=exe&function=shablontray&filename=shablontray.php&id={$sid}\";\n";
print "</SCRIPT> \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 SysPlugConfigForm()
{
global $SAMSConf;
$DB = new SAMSDB();
$num_rows = $DB->samsdb_query_value("SELECT * FROM sysinfo");
PageTop("sysplug_64.png", "System Plugins");
print "<FORM NAME=\"sysplugconfigform\" ACTION=\"main.php\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"show\" value=\"exe\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"function\" value=\"sysplugconfig\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"filename\" value=\"sysplugconfigtray.php\">\n";
print "<TABLE CLASS=samstable>\n";
print "<TH>Name</TH>\n";
print "<TH>Version</TH>\n";
print "<TH>Author</TH>\n";
print "<TH>Enabled</TH>\n";
while ($row = $DB->samsdb_fetch_array()) {
/*
print("<TR>\n");
if(isset($_GET["$row[s_row_id]"])) $val=$_GET["$row[s_row_id]"];
print("<TD>s_row_id=$row[s_row_id]</TD>\n");
print("<TD>val=$val</TD>\n");
if($val=="on") $val=1; else $val=0;
print("<TD>val=$val</TD>\n");
print("<TD>s_status=$row[s_status]</TD>\n");
print("</TR>\n");
*/
print "<TR>\n";
print " <TD>{$row['s_name']}</TD>\n";
print " <TD>{$row['s_version']}</TD>\n";
print " <TD>{$row['s_author']}</TD>\n";
$CHECKED = "";
if ($row['s_status'] == 1) {
$CHECKED = "CHECKED";
}
print "<TD><INPUT TYPE=\"CHECKBOX\" NAME=\"{$row['s_row_id']}\" {$CHECKED}></TD>\n";
print "</TR>\n";
}
$DB->free_samsdb_query();
print "</TABLE>\n";
print "<BR><INPUT TYPE=\"SUBMIT\" value=\"Configure\">\n";
print "</FORM>\n";
}
function SAMSPROXY($proxy_id)
{
global $SAMSConf;
$DB = new SAMSDB();
$num_rows = $DB->samsdb_query_value("SELECT * FROM proxy WHERE s_proxy_id='{$proxy_id}' ");
$row = $DB->samsdb_fetch_array();
$this->s_proxy_id = $row['s_proxy_id'];
$this->s_description = $row['s_description'];
$this->s_endvalue = $row['s_endvalue'];
$this->s_redirect_to = $row['s_redirect_to'];
$this->s_denied_to = $row['s_denied_to'];
$this->s_redirector = $row['s_redirector'];
$this->s_delaypool = $row['s_delaypool'];
$this->s_auth = $row['s_auth'];
$this->s_wbinfopath = $row['s_wbinfopath'];
$this->s_separator = $row['s_separator'];
$this->s_usedomain = $row['s_usedomain'];
$this->s_bigd = $row['s_bigd'];
$this->s_bigu = $row['s_bigu'];
$this->s_sleep = $row['s_sleep'];
$this->s_parser = $row['s_parser'];
$this->s_parser_time = $row['s_parser_time'];
$this->s_count_clean = $row['s_count_clean'];
$this->s_nameencode = $row['s_nameencode'];
$this->s_realsize = $row['s_realsize'];
$this->s_checkdns = $row['s_checkdns'];
$this->s_debuglevel = $row['s_debuglevel'];
$this->s_defaultdomain = $row['s_defaultdomain'];
$this->s_squidbase = $row['s_squidbase'];
$this->s_udscript = $row['s_udscript'];
$this->s_adminaddr = $row['s_adminaddr'];
$this->s_kbsize = $row['s_kbsize'];
$this->s_mbsize = $row['s_mbsize'];
$this->s_ldapserver = $row['s_ldapserver'];
$this->s_ldapbasedn = $row['s_ldapbasedn'];
$this->s_ldapuser = $row['s_ldapuser'];
$this->s_ldappasswd = $row['s_ldappasswd'];
$this->s_ldapusergroup = $row['s_ldapusergroup'];
$this->s_autouser = $row['s_autouser'];
$this->s_autotpl = $row['s_autotpl'];
$this->s_autogrp = $row['s_autogrp'];
$DB->free_samsdb_query();
}
function 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 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 ImportFromNTLM()
{
global $SAMSConf;
global $USERConf;
$DB = new SAMSDB();
$lang = "./lang/lang.{$SAMSConf->LANG}";
require $lang;
if ($USERConf->ToWebInterfaceAccess("UC") != 1) {
exit(0);
}
if (isset($_GET["addtemplates"])) {
$addtemplates = $_GET["addtemplates"];
}
if (isset($_GET["addgroups"])) {
$addgroups = $_GET["addgroups"];
}
if (isset($_GET["addgroupname"])) {
$addgroupname = $_GET["addgroupname"];
}
if (isset($_GET["defaulttraf"])) {
$defaulttraf = $_GET["defaulttraf"];
}
if (isset($_GET["period"])) {
$period = $_GET["period"];
}
if (isset($_GET["newperiod"])) {
$newperiod = $_GET["newperiod"];
}
if (isset($_GET["clryear"])) {
$clryear = $_GET["clryear"];
}
if (isset($_GET["clrmonth"])) {
$clrmonth = $_GET["clrmonth"];
}
if (isset($_GET["clrday"])) {
$clrday = $_GET["clrday"];
}
if (isset($_GET["trange"])) {
$trange = $_GET["trange"];
}
if (isset($_GET["enabled"])) {
$enabled = $_GET["enabled"];
}
$addgroups = "on";
$addtemplates = "on";
if ($enabled == "on") {
$enabled = 1;
} else {
$enabled = 0;
}
if ($period == "A") {
$period = $newperiod;
$clrdate = "{$clryear}-{$clrmonth}-{$clrday}";
}
$ntlmserver = GetAuthParameter("ntlm", "ntlmserver");
$ntlmdomain = GetAuthParameter("ntlm", "ntlmdomain");
$ntlmadmin = GetAuthParameter("ntlm", "ntlmadmin");
$ntlmadminpasswd = GetAuthParameter("ntlm", "ntlmadminpasswd");
$ntlmusergroup = GetAuthParameter("ntlm", "ntlmusergroup");
$e = escapeshellcmd("{$ntlmadmin} {$ntlmadminpasswd}");
$value = ExecuteShellScript("importntlmusers", $e);
$a = explode("|", $value);
$acount = count($a);
$aflag = 0;
$i = 0;
while (strlen($addgroupname[$i]) > 0) {
echo "{$i}: {$addgroupname[$i]}<BR>";
if ($addtemplates == "on") {
$result = $DB->samsdb_query_value("SELECT s_name FROM shablon where s_name = '{$addgroupname[$i]}'");
if ($result == 0) {
if ($clrdate == "") {
$clrdate = "1980-01-01";
}
$DB->samsdb_query("INSERT INTO shablon ( s_name, s_quote, s_auth, s_period, s_clrdate, s_alldenied, \ts_shablon_id2 ) VALUES ( '{$addgroupname[$i]}', '{$defaulttraf}', 'ntlm', '{$period}', '{$clrdate}', '0', '-1' ) ");
$DB->samsdb_query_value("SELECT s_shablon_id FROM shablon WHERE s_name='{$addgroupname[$i]}' ");
$row = $DB->samsdb_fetch_array();
$sid = $row['s_shablon_id'];
$DB->free_samsdb_query();
$DB->samsdb_query("INSERT INTO sconfig_time ( s_shablon_id, s_trange_id ) VALUES ( '{$sid}', '{$trange}' ) ");
echo "create template {$addgroupname[$i]} <BR>";
}
}
if ($addgroups == "on") {
$result = $DB->samsdb_query_value("SELECT s_name FROM sgroup where s_name = '{$addgroupname[$i]}'");
if ($result == 0) {
$result = $DB->samsdb_query("INSERT INTO sgroup (s_name) VALUES('{$addgroupname[$i]}') ");
echo "create group {$addgroupname[$i]} <BR>";
$result = $DB->samsdb_query("INSERT INTO auth_param (s_auth, s_param, s_value) VALUES('ntlm', 'ntlmgroup', '{$addgroupname[$i]}') ");
}
$result = $DB->samsdb_query_value("SELECT s_name, s_group_id FROM sgroup where s_name = '{$addgroupname[$i]}'");
$row = $DB->samsdb_fetch_array();
$groupid = $row['s_group_id'];
$result = $DB->samsdb_query_value("SELECT s_name, s_shablon_id FROM shablon where s_name = '{$addgroupname[$i]}'");
$row = $DB->samsdb_fetch_array();
$shablonid = $row['s_shablon_id'];
for ($k = 1; $k < $acount; $k++) {
$gflag = 0;
$g = explode(";", $a[$k]);
$gcount = count($g);
for ($j = 1; $j < $gcount; $j++) {
$qqq = str_replace("\\", "%", $g[$j]);
$www = urldecode($qqq, "UTF-8");
if ($g[$j] == $addgroupname[$i]) {
echo "user {$g['0']} added <BR>";
$gflag = 1;
$QUERY = "SELECT s_nick FROM squiduser WHERE s_nick='{$g['0']}' ";
$result = $DB->samsdb_query_value($QUERY);
if ($result == 0) {
if ($enabled == "") {
$enabled = 0;
}
$QUERY = "INSERT INTO squiduser ( s_nick, s_domain, s_name, s_family, s_shablon_id, s_quote, s_size, s_enabled, s_group_id, s_soname, s_ip, s_passwd, s_hit, s_autherrorc, s_autherrort ) VALUES ( '{$g['0']}', '{$userdomain}', '{$name['0']}', '" . $name[$cname - 1] . "', '{$shablonid}', '{$defaulttraf}', '0', '{$enabled}', '{$groupid}', '{$usersoname}', '{$userip}', '{$pass}', '0', '0', '0') ";
$DB->samsdb_query($QUERY);
}
}
}
}
}
print " <BR><BR>";
$i++;
}
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";
}
function SiteUsersList()
{
global $SAMSConf;
global $DATE;
global $USERConf;
require "reportsclass.php";
$DB = new SAMSDB();
$lang = "./lang/lang.{$SAMSConf->LANG}";
require $lang;
if (isset($_GET["site"])) {
$site = $_GET["site"];
}
if (isset($_GET["id"])) {
$id = $_GET["id"];
}
$sdate = $DATE->sdate();
$edate = $DATE->edate();
$bdate = $DATE->BeginDate();
$eddate = $DATE->EndDate();
if ($USERConf->ToWebInterfaceAccess("GSC") != 1 && ($USERConf->s_user_id != $SquidUSERConf->s_user_id && $USERConf->ToWebInterfaceAccess("W") != 1)) {
exit(0);
}
$dateselect = new DATESELECT($DATE->sdate(), $DATE->edate());
PageTop("usergroup_48.jpg", "{$userbuttom_4_site_SiteUserList_1} <BR>{$site} {$USERConf->s_nick}");
printf("<BR><B>{$traffic_2} {$bdate} {$traffic_3} {$eddate}</B> ");
print "<script language=JAVASCRIPT>\n";
print "function EditURL(URL)\n";
print "{\n";
print "document.forms[\"REDIRECT\"].elements[\"addurl\"].value=URL;\n";
print "}\n";
print "function CloseWindow()\n";
print "{\n";
print "this.document.forms[\"REDIRECT\"].submit();\n";
print "window.close;\n";
print "}\n";
print "</script>\n";
print "<FORM NAME=\"REDIRECT\" ACTION=\"main.php\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"show\" value=\"exe\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"function\" value=\"addurltolist\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"filename\" value=\"usersbuttom_3_site.php\">\n";
print "<TABLE>\n";
print "<TR>\n";
print "<TD>\n";
print "<B>{$userbuttom_4_site_SiteUserList_2}:\n";
print "<TD>\n";
print "<INPUT TYPE=\"TEXT\" NAME=\"addurl\" SIZE=30> \n";
print "<TR>\n";
print "<TD>\n";
print "<B>{$userbuttom_4_site_SiteUserList_3}:\n";
print "<TD>\n";
print "<SELECT NAME=\"type\" >\n";
$num_rows = $DB->samsdb_query_value("SELECT s_redirect_id,s_name FROM redirect");
while ($row2 = $DB->samsdb_fetch_array()) {
print "<OPTION VALUE={$row2['s_redirect_id']}> {$row2['s_name']}";
}
print "</SELECT>\n";
$DB->free_samsdb_query();
print "</TABLE>\n";
print "<BR><INPUT TYPE=\"SUBMIT\" value=\"{$userbuttom_4_site_SiteUserList_4}\" onsubmit=CloseWindow()>\n";
print "</FORM>\n";
print "<P><TABLE CLASS=samstable>";
print "<TR>";
print "<TH>{$grptraffic_2}</b></TD>";
print "<TH>{$userbuttom_2_traffic_UserTrafficPeriod_3}";
print "<TH>{$userbuttom_2_traffic_UserTrafficPeriod_4}";
print "<TH>{$userbuttom_2_traffic_UserTrafficPeriod_5}";
print "<TH>URL";
$QUERY = "SELECT s_date,s_user,s_size,s_url FROM squidcache WHERE s_date>='{$sdate}' AND s_date<='{$edate}' AND s_url like '%{$site}%' ORDER BY s_size desc limit 250";
$num_rows = $DB->samsdb_query_value($QUERY);
$counter = 0;
while ($row = $DB->samsdb_fetch_array()) {
print "<TR>";
LTableCell("{$row['s_date']}", 10);
LTableCell("{$row['s_user']}", 20);
$aaa = FormattedString("{$row['s_size']}");
RTableCell($aaa, 20);
if ($SAMSConf->realtraffic == "real") {
PrintFormattedSize($row['s_size'] - $row['s_hit']);
} else {
PrintFormattedSize($row['s_size']);
}
print "<TD ALIGN=\"LEFT\" bgcolor=blanchedalmond onclick=EditURL(\"{$row['s_url']}\")> {$row['3']} \n";
}
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> ";
}
}
function NewUserForm()
{
global $SAMSConf;
global $USERConf;
$DB = new SAMSDB();
$lang = "./lang/lang.{$SAMSConf->LANG}";
require $lang;
if ($USERConf->ToWebInterfaceAccess("UC") == 1) {
if ($SAMSConf->AUTH == "ntlm" || $SAMSConf->AUTH == "adld") {
print "<SCRIPT LANGUAGE=JAVASCRIPT>";
print "function SetChange()";
print "{";
print "if(document.forms[\"NEWUSER\"].elements[\"ud\"].checked==true)\n";
print " {\n";
print " document.forms[\"NEWUSER\"].elements[\"usernick\"].disabled=true\n";
print " document.forms[\"NEWUSER\"].elements[\"newusernick\"].disabled=false\n";
print " document.forms[\"NEWUSER\"].elements[\"userdomain\"].disabled=false\n";
print " }\n";
print "if(document.forms[\"NEWUSER\"].elements[\"ud\"].checked==false)\n";
print " {\n";
print " document.forms[\"NEWUSER\"].elements[\"usernick\"].disabled=false\n";
print " document.forms[\"NEWUSER\"].elements[\"newusernick\"].disabled=true\n";
print " document.forms[\"NEWUSER\"].elements[\"userdomain\"].disabled=true\n";
print " }\n";
print "}\n";
print "</SCRIPT>";
}
PageTop("user.jpg", "{$userstray_NewUserForm_1}");
print "<FORM NAME=\"NEWUSER\" ACTION=\"main.php\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"show\" value=\"exe\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"function\" value=\"adduser\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"filename\" id=filename value=\"usersbuttom_1_useradd.php\">\n";
print "<TABLE BORDER=0>\n";
if ($SAMSConf->AUTH == "ntlm" || $SAMSConf->AUTH == "adld") {
print "<TR>\n";
print "<TD>\n";
print "<B>{$userstray_NewUserForm_2}:\n";
print "<TD>\n";
GetDomainUsersList();
}
print "<TR>\n";
print "<TD>\n";
if ($SAMSConf->AUTH == "ntlm" || $SAMSConf->AUTH == "adld") {
print "<INPUT TYPE=\"CHECKBOX\" NAME=\"ud\" onclick=SetChange()>";
}
print "<B>{$userstray_NewUserForm_3}: \n";
print "<TD>\n";
print "<INPUT TYPE=\"TEXT\" NAME=\"newusernick\" SIZE=30 ";
if ($SAMSConf->AUTH == "ntlm" || $SAMSConf->AUTH == "adld") {
print "DISABLED";
}
print "> \n";
print "<TR><TD>\n";
print "<B>{$userstray_NewUserForm_4}: \n";
print "<TD>\n";
print "<INPUT TYPE=\"TEXT\" NAME=\"userdomain\" SIZE=30 VALUE=\"{$SAMSConf->DEFAULTDOMAIN}\" ";
if ($SAMSConf->AUTH == "ntlm" || $SAMSConf->AUTH == "adld") {
print "DISABLED";
}
print "> \n";
print "<TR><TD><B>{$userbuttom_1_prop_UpdateUserForm_3}:\n";
print "<TD><INPUT TYPE=\"PASSWORD\" NAME=\"passwd\" SIZE=20 >\n";
print "<TR><TD><B>{$userstray_NewUserForm_7}: \n";
print "<TD><INPUT TYPE=\"TEXT\" NAME=\"userip\" SIZE=15> \n";
print "<TR>\n";
print "<TD>\n";
print "<B>{$userstray_NewUserForm_8}: \n";
print "<TD>\n";
print "<INPUT TYPE=\"TEXT\" NAME=\"username\" SIZE=30> \n";
print "<TR>\n";
print "<TD>\n";
print "<B>{$userstray_NewUserForm_9}: \n";
print "<TD>\n";
print "<INPUT TYPE=\"TEXT\" NAME=\"usersoname\" SIZE=30> \n";
print "<TR>\n";
print "<TD>\n";
print "<B>{$userstray_NewUserForm_10}: \n";
print "<TD>\n";
print "<INPUT TYPE=\"TEXT\" NAME=\"userfamily\" SIZE=30> \n";
print "<TR>\n";
print "<TD>\n";
print "<B>{$userstray_NewUserForm_11}: \n";
print "<TD>\n";
print "<SELECT NAME=\"usergroup\" ID=\"groupname\" SIZE=1 TABINDEX=30 >\n";
$num_rows = $DB->samsdb_query_value("SELECT s_group_id, s_name FROM sgroup ORDER BY s_name");
while ($row = $DB->samsdb_fetch_array()) {
print "<OPTION VALUE={$row['s_group_id']}> {$row['s_name']}";
}
print "</SELECT>\n";
print "<TR>\n";
print "<TD>\n";
print "<B>{$userstray_NewUserForm_12} \n";
print "<TD>\n";
print " \n";
$DB->free_samsdb_query();
$num_rows = $DB->samsdb_query_value("SELECT * FROM shablon");
$row = $DB->samsdb_fetch_array();
print "<TR>\n";
print "<TD>\n";
print "<B>{$userstray_NewUserForm_13} \n";
print "<TD>\n";
print "<INPUT TYPE=\"TEXT\" NAME=\"userquote\" SIZE=10 VALUE=\"{$row['s_quote']}\"> \n";
print "<TR>\n";
print "<TD>\n";
print "<B>{$userstray_NewUserForm_14}: \n";
print "<TD>\n";
print "<INPUT TYPE=\"CHECKBOX\" NAME=\"enabled\" CHECKED> \n";
print "<SCRIPT language=JAVASCRIPT>\n";
print "function SetQuote()\n";
print "{\n";
$result = $DB->samsdb_query("SELECT * FROM shablon");
while ($row = $DB->samsdb_fetch_array($result)) {
print "if(document.forms[\"NEWUSER\"].elements[\"usershablon\"].value==\"{$row['s_shablon_id']}\" )\n";
print " document.forms[\"NEWUSER\"].elements[\"userquote\"].value=\"{$row['s_quote']}\" \n";
}
print "}\n";
print "</SCRIPT> \n";
$DB->free_samsdb_query();
print "<TR>\n";
print "<TD>\n";
print "<B>{$userstray_NewUserForm_15}: \n";
print "<TD>\n";
print "<SELECT NAME=\"usershablon\" ID=\"usershablon\" SIZE=1 TABINDEX=30 onChange=\"SetQuote()\">\n";
$num_rows = $DB->samsdb_query_value("SELECT * FROM shablon ORDER BY s_name");
while ($row = $DB->samsdb_fetch_array()) {
print "<OPTION VALUE={$row['s_shablon_id']} > {$row['s_name']}\n";
}
print "</SELECT>\n";
print "</TABLE>\n";
print "<BR><INPUT TYPE=\"SUBMIT\" value=\"{$userstray_NewUserForm_16}\">\n";
print "</FORM>\n";
$DB->free_samsdb_query();
}
}
function ImportFromLDAP()
{
include 'ldap.php';
global $SAMSConf;
global $USERConf;
$DB = new SAMSDB();
$lang = "./lang/lang.{$SAMSConf->LANG}";
require $lang;
if ($USERConf->ToWebInterfaceAccess("UC") != 1) {
exit(0);
}
PageTop("importfromldap-48.jpg", " {$authadldbuttom_3_importfromldap_ImportFromLDAPForm_1} ");
if (isset($_GET["addtemplates"])) {
$addtemplates = $_GET["addtemplates"];
}
if (isset($_GET["addgroups"])) {
$addgroups = $_GET["addgroups"];
}
if (isset($_GET["addgroupname"])) {
$addgroupname = $_GET["addgroupname"];
}
if (isset($_GET["defaulttraf"])) {
$defaulttraf = $_GET["defaulttraf"];
}
if (isset($_GET["period"])) {
$period = $_GET["period"];
}
if (isset($_GET["newperiod"])) {
$newperiod = $_GET["newperiod"];
}
if (isset($_GET["clryear"])) {
$clryear = $_GET["clryear"];
}
if (isset($_GET["clrmonth"])) {
$clrmonth = $_GET["clrmonth"];
}
if (isset($_GET["clrday"])) {
$clrday = $_GET["clrday"];
}
if (isset($_GET["trange"])) {
$trange = $_GET["trange"];
}
if (isset($_GET["enabled"])) {
$enabled = $_GET["enabled"];
}
$addgroups = "on";
$addtemplates = "on";
if ($enabled == "on") {
$enabled = 1;
} else {
$enabled = 0;
}
if ($period == "A") {
$period = $newperiod;
$clrdate = "{$clryear}-{$clrmonth}-{$clrday}";
}
$adldserver = GetAuthParameter("ldap", "ldapserver");
$basedn = GetAuthParameter("ldap", "basedn");
$adadmin = GetAuthParameter("ldap", "adadmin");
$adadminpasswd = GetAuthParameter("ldap", "adadminpasswd");
$usersrdn = GetAuthParameter("ldap", "usersrdn");
$usersfilter = GetAuthParameter("ldap", "usersfilter");
$usernameattr = GetAuthParameter("ldap", "usernameattr");
$groupsrdn = GetAuthParameter("ldap", "groupsrdn");
$groupsfilter = GetAuthParameter("ldap", "groupsfilter");
$samsldap = new sams_ldap($adldserver, $basedn, $usersrdn, $usersfilter, $usernameattr, $groupsrdn, $groupsfilter, $adadmin, $adadminpasswd);
$i = 0;
while (strlen($addgroupname[$i]) > 0) {
if ($addtemplates == "on") {
echo "<B>ADD TEMPLATE:</B> {$addgroupname[$i]}";
$result = $DB->samsdb_query_value("SELECT s_name FROM shablon where s_name = '{$addgroupname[$i]}'");
if ($result == 0) {
if ($clrdate == "") {
$clrdate = "1980-01-01";
}
$DB->samsdb_query("INSERT INTO shablon ( s_name, s_quote, s_auth, s_period, s_clrdate, s_alldenied, \ts_shablon_id2 ) VALUES ( '{$addgroupname[$i]}', '{$defaulttraf}', 'ldap', '{$period}', '{$clrdate}', '0', '-1' ) ");
$DB->samsdb_query_value("SELECT s_shablon_id FROM shablon WHERE s_name='{$addgroupname[$i]}' ");
$row = $DB->samsdb_fetch_array();
$sid = $row['s_shablon_id'];
$DB->free_samsdb_query();
$DB->samsdb_query("INSERT INTO sconfig_time ( s_shablon_id, s_trange_id ) VALUES ( '{$sid}', '{$trange}' ) ");
echo " Ok";
}
echo "<BR>";
}
if ($addgroups == "on") {
echo "<B>ADD GROUP:</B> {$addgroupname[$i]}";
$result = $DB->samsdb_query_value("SELECT s_name FROM sgroup where s_name = '{$addgroupname[$i]}'");
if ($result == 0) {
$result = $DB->samsdb_query("INSERT INTO sgroup (s_name) VALUES('{$addgroupname[$i]}') ");
$result = $DB->samsdb_query("INSERT INTO auth_param (s_auth, s_param, s_value) VALUES('ldap', 'ldapgroup', '{$addgroupname[$i]}') ");
echo " Ok ";
}
echo "<BR>";
$result = $DB->samsdb_query_value("SELECT s_name, s_group_id FROM sgroup where s_name = '{$addgroupname[$i]}'");
$row = $DB->samsdb_fetch_array();
$groupid = $row['s_group_id'];
$result = $DB->samsdb_query_value("SELECT s_name, s_shablon_id FROM shablon where s_name = '{$addgroupname[$i]}'");
$row = $DB->samsdb_fetch_array();
$shablonid = $row['s_shablon_id'];
echo "<B>ADD USERS:</B><BR>";
$b = $samsldap->GetUsersWithSecondaryGroupID($addgroupname[$i]);
for ($j = 0; $j < $b['userscount']; $j++) {
$user = $b['uid'][$j];
$username = $b['name'][$j];
if ($enabled == "") {
$enabled = 0;
}
$QUERY = "INSERT INTO squiduser ( s_nick, s_domain, s_name, s_family, s_shablon_id, s_quote, s_size, s_enabled, s_group_id, s_soname, s_ip, s_passwd, s_hit, s_autherrorc, s_autherrort ) VALUES ( '{$user}', '{$userdomain}', '{$name['0']}', '" . $name[$cname - 1] . "', '{$shablonid}', '{$defaulttraf}', '0', '{$enabled}', '{$groupid}', '{$usersoname}', '{$userip}', '{$pass}', '0', '0', '0') ";
$DB->samsdb_query($QUERY);
echo " {$user}<BR>";
}
}
print " <BR>";
$i++;
}
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";
}
function ImportFromADForm()
{
global $SAMSConf;
global $USERConf;
$lang = "./lang/lang.{$SAMSConf->LANG}";
require $lang;
if ($USERConf->ToWebInterfaceAccess("UC") != 1) {
exit(0);
}
PageTop("importfromad-48.jpg", " {$authadldbuttom_3_importfromad_ImportFromADForm_1} ");
require_once "src/adldap.php";
// print("<FORM NAME=\"AddDomainUsers\" ACTION=\"main.php\">\n");
$DB = new SAMSDB();
$adldserver = GetAuthParameter("adld", "adldserver");
$basedn = GetAuthParameter("adld", "basedn");
$adadmin = GetAuthParameter("adld", "adadmin");
$adadminpasswd = GetAuthParameter("adld", "adadminpasswd");
$usergroup = GetAuthParameter("adld", "usergroup");
$LDAPBASEDN2 = strtok($basedn, ".");
$LDAPBASEDN = "DC={$LDAPBASEDN2}";
while (strlen($LDAPBASEDN2) > 0) {
$LDAPBASEDN2 = strtok(".");
if (strlen($LDAPBASEDN2) > 0) {
$LDAPBASEDN = "{$LDAPBASEDN},DC={$LDAPBASEDN2}";
}
}
$pdc = array("{$adldserver}");
$options = array(account_suffix => "@{$basedn}", base_dn => "{$LDAPBASEDN}", domain_controllers => $pdc, ad_username => "{$adadmin}", ad_password => "{$adadminpasswd}", "", "", "");
$ldap = new adLDAP($options);
$groupinfo = $ldap->all_groups($include_desc = false, $search = "*", $sorted = true);
$gcount = count($groupinfo);
print "<FORM NAME=\"AddFromAD\" ACTION=\"main.php\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"show\" id=Show value=\"exe\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"function\" id=function value=\"importfromad\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"filename\" id=filename value=\"authadldbuttom_3_importfromad.php\">\n";
/* */
echo "<TABLE WIDTH=90%>";
print "<TR><TD WIDTH=30%><B>{$authadldbuttom_3_importfromad_ImportFromADForm_2}:\n";
print "<TD WIDTH=70%><SELECT NAME=\"addgroupname[]\" SIZE=15 TABINDEX=30 MULTIPLE>\n";
asort($groupinfo);
foreach ($groupinfo as $group) {
$groupname = UTF8ToSAMSLang($group);
if (SearchAuthParameter("adld", "adldgroup", "{$groupname}") == 0) {
print "<OPTION VALUE=\"{$groupname}\"> {$groupname} \n";
}
}
print "</SELECT>\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 onchange=EnterNewGroupName(AddFromAD)>\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']} ";
}
print "<OPTION VALUE=\"-2\"> {$usersbuttom_1_domain_AddUsersFromDomainForm_10}";
print "<OPTION VALUE=\"-1\"> {$usersbuttom_1_domain_AddUsersFromDomainForm_8} ";
print "</SELECT>\n";
print "<TR><TD ALIGN=RIGHT>\n";
print "{$usersbuttom_1_domain_AddUsersFromDomainForm_9}: \n";
print "<TD>\n";
print "<INPUT TYPE=\"TEXT\" NAME=\"newgroupname\" id=Newgroupname\" DISABLED>\n";
$DB->free_samsdb_query();
print "<TR><TD><B>{$usersbuttom_1_domain_AddUsersFromDomainForm_6}";
print "<TD><INPUT TYPE=\"CHECKBOX\" NAME=\"enabled\" CHECKED>";
print "<TR>\n";
print "<TD>\n";
print "{$shablonnew_NewShablonForm_3}:\n";
print "<TD>\n";
print "<INPUT TYPE=\"TEXT\" NAME=\"defaulttraf\" SIZE=6 VALUE=\"100\"> <B> 0 - unlimited traffic\n";
print "<TR>\n";
print "<TD>\n";
print "{$shablonnew_NewShablonForm_10}\n";
print "<TD>\n";
print "<SELECT NAME=\"period\" onchange=EnterPeriod(AddDomainUsers) {$CCLEAN}> \n";
print "<OPTION value=\"M\" SELECTED>{$shablonnew_NewShablonForm_11}\n";
print "<OPTION value=\"W\">{$shablonnew_NewShablonForm_12}\n";
print "<OPTION value=\"A\">{$shablonnew_NewShablonForm_13}\n";
print "</SELECT>\n";
print "<SCRIPT LANGUAGE=JAVASCRIPT> \n";
print "function EnterPeriod(formname) \n";
print "{ \n";
print " var period=formname.period.value; \n";
print " var clryear=formname.clryear.value; \n";
print " var clrmonth=formname.clrmonth.value; \n";
print " var clrday=formname.clrday.value; \n";
//print(" value=window.confirm(\"1? \" );\n");
print " if(period==\"A\") \n";
print " {\n";
print " formname.newperiod.disabled=false; \n";
print " formname.clryear.disabled=false; \n";
print " formname.clrmonth.disabled=false; \n";
print " formname.clrday.disabled=false; \n";
print " }\n";
print " else \n";
print " {\n";
print " formname.newperiod.disabled=true; \n";
print " formname.clryear.disabled=true; \n";
print " formname.clrmonth.disabled=true; \n";
print " formname.clrday.disabled=true; \n";
print " }\n";
print "}\n";
print "function EnterNewGroupName(formname) \n";
print "{ \n";
print " var groupname=formname.groupname.value; \n";
print " if(groupname==\"-1\") \n";
print " {\n";
print " formname.newgroupname.disabled=false; \n";
print " }\n";
print " else \n";
print " {\n";
print " formname.newgroupname.disabled=true; \n";
print " }\n";
print "}\n";
print "</SCRIPT> \n";
$month = array(0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12);
$days = array(0, 31, 28, 31, 30, 31, 30, 31, 31, 30, 31, 30, 31);
$YCLRVALUE = strftime("%Y");
$MCLRVALUE = strftime("%m");
$DCLRVALUE = strftime("%d");
if ($DCLRVALUE + 1 > $days[$MCLRVALUE]) {
$DCLRVALUE = 1;
$MCLRVALUE += 1;
if ($MCLRVALUE > 12) {
$MCLRVALUE = 1;
$YCLRVALUE += 1;
}
} else {
$DCLRVALUE += 1;
}
print "<TR><TD>\n";
print "<TD> {$shablonnew_NewShablonForm_14}: \n";
print "<INPUT TYPE=\"TEXT\" NAME=\"newperiod\" SIZE=5 DISABLED>{$shablonnew_NewShablonForm_15}\n";
print "<TR><TD><TD> {$shablonnew_NewShablonForm_16}: \n";
print "<BR><INPUT TYPE=\"TEXT\" NAME=\"clryear\" SIZE=4 DISABLED VALUE=\"{$YCLRVALUE}\">:\n";
print "<INPUT TYPE=\"TEXT\" NAME=\"clrmonth\" SIZE=2 DISABLED VALUE=\"{$MCLRVALUE}\">:\n";
print "<INPUT TYPE=\"TEXT\" NAME=\"clrday\" SIZE=2 DISABLED VALUE=\"{$DCLRVALUE}\">\n";
print "<TR><TD>{$AddTRangeForm_trangetray_1}:<TD><SELECT NAME=\"trange\" ID=\"trange\" >\n";
$num_rows = $DB->samsdb_query_value("SELECT * FROM timerange ");
while ($row = $DB->samsdb_fetch_array()) {
print "<OPTION VALUE={$row['s_trange_id']}> {$row['s_name']} ({$row['s_timestart']} - {$row['s_timeend']} )";
}
print "</SELECT>\n";
/*
print("<TR><TD WIDTH=30%><B>Create SAMS groups with AD groups name:\n");
print("<TD><INPUT TYPE=\"CHECKBOX\" NAME=\"addgroups\" CHECKED>");
*/
echo "</TABLE>";
print "<INPUT TYPE=\"SUBMIT\" value=\"Import\">\n";
print "</FORM>\n";
}
function RecalcUsersTraffic()
{
global $SAMSConf;
global $USERConf;
$DB = new SAMSDB();
$DB2 = new SAMSDB();
$lang = "./lang/lang.{$SAMSConf->LANG}";
require $lang;
if ($USERConf->ToWebInterfaceAccess("C") != 1) {
exit;
}
$thisdate = strftime("%Y-%m-%d");
$smdate = strftime("%Y") . "-" . strftime("%m") . "-01";
$stime = "0:00:00";
$etime = time();
$shabloncount = $DB->samsdb_query_value("SELECT s_shablon_id, s_name, s_period, s_clrdate FROM shablon");
$scount = 0;
$stime = array();
$shablonid = array();
while ($row = $DB->samsdb_fetch_array()) {
$shablonid[$scount] = $row['s_shablon_id'];
$edate[$scount] = $thisdate;
$a = explode("-", $row['s_clrdate']);
if ($row['s_period'] == "W") {
$stime[$scount] = $etime - (strftime("%u") - 1) * 24 * 60 * 60;
$sdate[$scount] = date("Y-m-d", $stime);
} else {
if ($row['s_period'] != "M" && $row['s_period'] != "W") {
$stime[$scount] = mktime(0, 1, 0, $a[1], $a[2], $a[0]) - $row['s_period'] * 24 * 60 * 60;
$sdate[$scount] = date("Y-m-d", $stime[$scount]);
$edate[$scount] = $row['s_clrdate'];
} else {
$stime[$scount] = mktime(0, 1, 0, strftime("%m", $etime), "1", strftime("%Y", $etime));
$sdate[$scount] = strftime("%Y", $etime) . "-" . strftime("%m", $etime) . "-01";
}
}
$s_shablon_id[$scount] = $row['s_shablon_id'];
$s_shablon_name[$scount] = $row['s_name'];
$scount++;
}
$DB->free_samsdb_query();
sort($stime);
$QUERY = "TRUNCATE TABLE cachesum";
$num_rows = $DB->samsdb_query($QUERY);
$QUERY = "INSERT INTO cachesum SELECT s_proxy_id,s_date,s_user,s_domain,sum(s_size),sum(s_hit) FROM squidcache GROUP BY s_date,s_user,s_domain,s_proxy_id";
$num_rows = $DB->samsdb_query($QUERY);
$QUERY = "SELECT s_user_id, s_name, s_nick, s_shablon_id FROM squiduser";
$num_rows = $DB->samsdb_query_value($QUERY);
while ($row = $DB->samsdb_fetch_array()) {
$key = array_search($row['s_shablon_id'], $shablonid);
$QUERY = "SELECT sum(s_size) as size, sum(s_hit) as hit FROM cachesum WHERE s_user='******'s_nick']}' and s_date >='{$sdate[$key]}' and s_date <='{$edate[$key]}' ";
$DB2->samsdb_query($QUERY);
$row2 = $DB2->samsdb_fetch_array();
$sumsize = $row2['size'] + 0;
$sumhit = $row2['hit'] + 0;
$DB2->free_samsdb_query();
$QUERY = "UPDATE squiduser SET s_size='{$sumsize}', s_hit='{$sumhit}' WHERE s_user_id={$row['s_user_id']}";
$DB2->samsdb_query($QUERY);
}
$DB->free_samsdb_query();
PageTop("usergroup_48.jpg", "{$usersbuttom_5_recalc_RecalcUsersTraffic_1} {$sdate[$key]} - {$edate[$key]} {$usersbuttom_5_recalc_RecalcUsersTraffic_2}");
print "<SCRIPT>\n";
print " parent.basefrm.location.href=\"main.php?show=exe&filename=userstray.php&function=AllUsersForm&type=all\";\n";
print " parent.lframe.location.href=\"lframe.php\";\n";
print "</SCRIPT> \n";
}
function UpdateUserForm()
{
global $SAMSConf;
global $USERConf;
global $SquidUSERConf;
$DB = new SAMSDB();
$DB2 = new SAMSDB();
$lang = "./lang/lang.{$SAMSConf->LANG}";
require $lang;
if (isset($_GET["id"])) {
$userid = $_GET["id"];
}
if ($USERConf->ToWebInterfaceAccess("AUC") != 1) {
exit;
}
$SquidUSERConf = new SAMSUSER();
$SquidUSERConf->sams_user($userid);
PageTop("user.jpg", "{$userbuttom_1_prop_UpdateUserForm_1} <FONT COLOR=\"BLUE\">{$SquidUSERConf->s_nick}</FONT>");
print "<FORM NAME=\"UPDATEUSER\" ACTION=\"main.php\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"show\" value=\"exe\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"function\" value=\"updateuser\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"filename\" value=\"userbuttom_1_prop.php\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"id\" value=\"{$userid}\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"auth\" value=\"{$SquidUSERConf->s_auth}\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"defstatus\" value=\"{$SquidUSERConf->s_enabled}\">\n";
print "<TABLE>\n";
print "<TR>\n";
print "<TD>\n";
print "<B>Nickname:\n";
print "<TD>\n";
print "<INPUT TYPE=\"TEXT\" VALUE=\"{$SquidUSERConf->s_nick}\" NAME=\"usernick\" SIZE=15> \n";
print "<TR>\n";
print "<TD>\n";
print "<B>{$userbuttom_1_prop_UpdateUserForm_2}:\n";
print "<TD>\n";
print "<INPUT TYPE=\"TEXT\" VALUE=\"{$SquidUSERConf->s_domain}\" NAME=\"domain\" SIZE=15> \n";
print "<TR>\n";
print "<TD>\n";
print "<B>{$userbuttom_1_prop_UpdateUserForm_4}: \n";
print "<TD>\n";
print "<INPUT TYPE=\"TEXT\" VALUE=\"{$SquidUSERConf->s_ip}\" NAME=\"userip\" SIZE=15>/ \n";
print "<TR>\n";
print "<TD>\n";
print "<B>{$userbuttom_1_prop_UpdateUserForm_5}: \n";
print "<TD>\n";
print "<INPUT TYPE=\"TEXT\" VALUE=\"{$SquidUSERConf->s_name}\" NAME=\"username\" SIZE=30> \n";
print "<TR>\n";
print "<TD>\n";
print "<B>{$userbuttom_1_prop_UpdateUserForm_6}: \n";
print "<TD>\n";
print "<INPUT TYPE=\"TEXT\" VALUE=\"{$SquidUSERConf->s_soname}\" NAME=\"usersoname\" SIZE=30> \n";
print "<TR>\n";
print "<TD>\n";
print "<B>{$userbuttom_1_prop_UpdateUserForm_7}: \n";
print "<TD>\n";
print "<INPUT TYPE=\"TEXT\" VALUE=\"{$SquidUSERConf->s_family}\" NAME=\"userfamily\" SIZE=30> \n";
print "<TR>\n";
print "<TD>\n";
print "<B>{$userbuttom_1_prop_UpdateUserForm_8}: \n";
print "<TD>\n";
print "<SELECT NAME=\"usergroup\" ID=\"groupname\" SIZE=1 TABINDEX=30 >\n";
$num_rows = $DB2->samsdb_query_value("SELECT s_group_id, s_name FROM sgroup");
while ($row2 = $DB2->samsdb_fetch_array()) {
if ($row2['s_group_id'] == $SquidUSERConf->s_group_id) {
print "<OPTION VALUE={$row2['s_group_id']} SELECTED> {$row2['s_name']}";
} else {
print "<OPTION VALUE={$row2['s_group_id']}> {$row2['s_name']}";
}
}
print "</SELECT>\n";
$DB2->free_samsdb_query();
print "<SCRIPT LANGUAGE=JAVASCRIPT>\n";
print "function EnableIndividualQuote(formname)\n";
print "{\n";
print " if(formname.individuallimit.checked==true)\n";
print " {\n";
print " formname.userquote.disabled=false\n";
print " }\n";
print " if(formname.individuallimit.checked==false)\n";
print " {\n";
print " formname.userquote.disabled=true\n";
print " }\n";
print "}\n";
print "</SCRIPT>\n";
print "<TR>\n";
print "<TD>\n";
print "<B>{$userbuttom_1_prop_UpdateUserForm_25} \n";
print "<TD>\n";
if ($SquidUSERConf->s_quote != -1) {
print "<INPUT TYPE=\"CHECKBOX\" NAME=\"individuallimit\" CHECKED onclick=EnableIndividualQuote(UPDATEUSER)> \n";
$QDISABLED = "";
} else {
print "<INPUT TYPE=\"CHECKBOX\" NAME=\"individuallimit\" onclick=EnableIndividualQuote(UPDATEUSER) > \n";
$QDISABLED = "DISABLED";
}
print "<TR>\n";
print "<TD>\n";
print "<B>{$userbuttom_1_prop_UpdateUserForm_9} {$userbuttom_1_prop_UpdateUserForm_10} </B>\n";
print "<TD>\n";
if ($SquidUSERConf->s_quote == -1) {
$uquote = $SquidUSERConf->s_defquote;
} else {
$uquote = $SquidUSERConf->s_quote;
}
print "<INPUT TYPE=\"TEXT\" NAME=\"userquote\" SIZE=10 VALUE=\"{$uquote}\" {$QDISABLED}> <B>0 - unlimited traffic \n";
print "<TD>\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"saveenabled\" value=\"{$SquidUSERConf->s_enabled}\">\n";
print "<TR>\n";
print "<TD>\n";
print "<B>{$userbuttom_1_prop_UpdateUserForm_11}: \n";
print "<TD>\n";
print "<SELECT NAME=\"enabled\" ID=\"enabled\" SIZE=1 TABINDEX=10 >\n";
if ($SquidUSERConf->s_enabled == 1) {
print "<OPTION VALUE=\"1\" SELECTED> {$userbuttom_1_prop_UpdateUserForm_15}";
} else {
print "<OPTION VALUE=\"1\"> {$userbuttom_1_prop_UpdateUserForm_15}";
}
if ($SquidUSERConf->s_enabled == 2) {
print "<OPTION VALUE=\"2\" SELECTED> {$userbuttom_1_prop_UpdateUserForm_25}";
} else {
print "<OPTION VALUE=\"2\"> {$userbuttom_1_prop_UpdateUserForm_25}";
}
if ($SquidUSERConf->s_enabled == 0) {
print "<OPTION VALUE=\"0\" SELECTED> {$userbuttom_1_prop_UpdateUserForm_16}";
} else {
print "<OPTION VALUE=\"0\"> {$userbuttom_1_prop_UpdateUserForm_16}";
}
if ($SquidUSERConf->s_enabled == -1) {
print "<OPTION VALUE=\"-1\" SELECTED> {$userbuttom_1_prop_UpdateUserForm_17}";
} else {
print "<OPTION VALUE=\"-1\"> {$userbuttom_1_prop_UpdateUserForm_17}";
}
print "</SELECT>\n";
print "<TR>\n";
print "<TD>\n";
print "<B>{$userbuttom_1_prop_UpdateUserForm_12}: \n";
print "<TD>\n";
print "<SELECT NAME=\"usershablon\" ID=\"usershablon\" SIZE=1 TABINDEX=30 >\n";
$num_rows = $DB2->samsdb_query_value("SELECT s_shablon_id,s_name,s_quote FROM shablon");
while ($row2 = $DB2->samsdb_fetch_array()) {
if ($row2['s_shablon_id'] == $SquidUSERConf->s_shablon_id) {
print "<OPTION VALUE=\"{$row2['s_shablon_id']}\" SELECTED> {$row2['s_name']}";
} else {
print "<OPTION VALUE=\"{$row2['s_shablon_id']}\"> {$row2['s_name']}";
}
}
print "</SELECT>\n";
print "<TR><TD><B>{$userbuttom_1_prop_UpdateUserForm_18} (W)\n";
print "<TD>\n";
$WCHECKED = "";
if ($SquidUSERConf->W_access == 1) {
$WCHECKED = "CHECKED";
}
print "<INPUT TYPE=\"CHECKBOX\" NAME=\"W_access\" {$WCHECKED}> \n";
print "<TR><TD><B>{$userbuttom_1_prop_UpdateUserForm_19} (G)\n";
print "<TD>\n";
$GCHECKED = "";
if ($SquidUSERConf->G_access == 1) {
$GCHECKED = "CHECKED";
}
print "<INPUT TYPE=\"CHECKBOX\" NAME=\"G_access\" {$GCHECKED}> \n";
print "<TR><TD><B>{$userbuttom_1_prop_UpdateUserForm_20} (S)\n";
print "<TD>\n";
$SCHECKED = "";
if ($SquidUSERConf->S_access == 1) {
$SCHECKED = "CHECKED";
}
print "<INPUT TYPE=\"CHECKBOX\" NAME=\"S_access\" {$SCHECKED}> \n";
print "<TR><TD><B>{$userbuttom_1_prop_UpdateUserForm_21} (A)\n";
print "<TD>\n";
$ACHECKED = "";
if ($SquidUSERConf->A_access == 1) {
$ACHECKED = "CHECKED";
}
print "<INPUT TYPE=\"CHECKBOX\" NAME=\"A_access\" {$ACHECKED}> \n";
print "<TR><TD><B>{$userbuttom_1_prop_UpdateUserForm_22} (U)\n";
print "<TD>\n";
$UCHECKED = "";
if ($SquidUSERConf->U_access == 1) {
$UCHECKED = "CHECKED";
}
print "<INPUT TYPE=\"CHECKBOX\" NAME=\"U_access\" {$UCHECKED}> \n";
print "<TR><TD><B>{$userbuttom_1_prop_UpdateUserForm_23} (L)\n";
print "<TD>\n";
$LCHECKED = "";
if ($SquidUSERConf->L_access == 1) {
$LCHECKED = "CHECKED";
}
print "<INPUT TYPE=\"CHECKBOX\" NAME=\"L_access\" {$LCHECKED}> \n";
print "<TR><TD><B>{$userbuttom_1_prop_UpdateUserForm_24} (C)\n";
print "<TD>\n";
$CCHECKED = "";
if ($SquidUSERConf->C_access == 1) {
$CCHECKED = "CHECKED";
}
print "<INPUT TYPE=\"CHECKBOX\" NAME=\"C_access\" {$CCHECKED}> \n";
print "</TABLE>\n";
print "<BR><INPUT TYPE=\"SUBMIT\" value=\"{$userbuttom_1_prop_UpdateUserForm_13}\">\n";
print "</FORM>\n";
}
function ProxyReConfigForm()
{
global $SAMSConf;
global $PROXYConf;
global $USERConf;
$DB = new SAMSDB();
$files = array();
if (isset($_GET["id"])) {
$proxy_id = $_GET["id"];
}
$lang = "./lang/lang.{$SAMSConf->LANG}";
require $lang;
if ($USERConf->ToWebInterfaceAccess("C") != 1) {
exit;
}
$DISABLED_PARSER = "";
PageTop("config_48.jpg", "Proxy server<BR><FONT COLOR=\"BLUE\">{$PROXYConf->s_description}</FONT>");
print "<IMG SRC=\"{$SAMSConf->ICONSET}/help.jpg\">";
print "<A HREF=\"http://sams.perm.ru/sams2/doc/" . $SAMSConf->LANG . "/squid.html\">{$documentation}</A>";
print "<P>\n";
print "<P>\n";
print "<SCRIPT LANGUAGE=JAVASCRIPT>\n";
print "function EnableCheckBox(formname)\n";
print "{\n";
print " formname.ntlmdomain.disabled=false; \n";
print " formname.bigdomain.disabled=false; \n";
print " formname.bigusername.disabled=false; \n";
print " formname.nameencode.disabled=false; \n";
print "}\n";
print "function DisableCheckBox(formname)\n";
print "{\n";
print " formname.ntlmdomain.disabled=true; \n";
print " formname.bigdomain.disabled=true; \n";
print " formname.bigusername.disabled=true; \n";
print " formname.nameencode.disabled=true; \n";
print "}\n";
print "function ChangeAuthScheme(formname)\n";
print "{\n";
print " var auth=formname.authtype.value; \n";
print " var domainenabled=formname.usedomain.checked; \n";
print " if(auth==\"ip\")\n";
print " {\n";
print " formname.usedomain.disabled=true; \n";
print " formname.bigdomain.disabled=true; \n";
print " formname.bigusername.disabled=true; \n";
print " formname.separator.disabled=true; \n";
print " }\n";
print " else if(auth==\"ncsa\")\n";
print " {\n";
print " formname.usedomain.disabled=true; \n";
print " formname.bigdomain.disabled=true; \n";
print " formname.bigusername.disabled=true; \n";
print " formname.separator.disabled=true; \n";
print " }\n";
print " else if(auth==\"ldap\")\n";
print " {\n";
print " formname.usedomain.disabled=true; \n";
print " formname.bigdomain.disabled=true; \n";
print " formname.bigusername.disabled=true; \n";
print " formname.separator.disabled=true; \n";
print " }\n";
print " else if(auth==\"adld\")\n";
print " {\n";
print " formname.usedomain.disabled=false; \n";
print " formname.separator.disabled=true; \n";
print " if(domainenabled==true)\n";
print " formname.bigdomain.disabled=false; \n";
print " else\n";
print " formname.bigdomain.disabled=true; \n";
// print(" formname.bigusername.disabled=false; \n");
print " }\n";
print " else if(auth==\"ntlm\")\n";
print " {\n";
print " formname.usedomain.disabled=false; \n";
print " if(domainenabled==true)\n";
print " {\n";
print " formname.bigdomain.disabled=false; \n";
print " formname.bigusername.disabled=false; \n";
print " formname.separator.disabled=false; \n";
print " }\n";
print " else\n";
print " {\n";
print " formname.bigdomain.disabled=true; \n";
print " formname.bigusername.disabled=true; \n";
print " formname.separator.disabled=true; \n";
print " }\n";
// print(" formname.bigusername.disabled=false; \n");
print " }\n";
print "}\n";
print "function EnableDomainName(formname) \n";
print "{\n";
print " var needdomain=formname.usedomain.checked; \n";
print " if(needdomain==true) \n";
print " {\n";
print " formname.bigdomain.disabled=false; \n";
print " formname.bigusername.disabled=false; \n";
print " formname.separator.disabled=false; \n";
print " }\n";
print " else \n";
print " {\n";
print " formname.bigdomain.disabled=true; \n";
print " formname.bigusername.disabled=true; \n";
print " formname.separator.disabled=true; \n";
print " }\n";
print "}\n";
print "function EnableParser(formname)";
print "{";
print " var parser_on=formname.parser_on.checked; \n";
print " if(parser_on==true) \n";
print " {\n";
print " formname.parser_time.disabled=false; ";
print " }\n";
print " else \n";
print " {\n";
print " formname.parser_time.disabled=true; ";
print " }\n";
print "}\n";
print "function EnableUserAdd(formname) \n";
print "{\n";
print " var addenabled=formname.autouser.checked; \n";
print " if(addenabled==true) \n";
print " {\n";
print " \tformname.shablon.disabled=false; \n";
print " \tformname.group.disabled=false; \n";
print " }\n";
print " if(addenabled==false) \n";
print " {\n";
print " \tformname.shablon.disabled=true; \n";
print " \tformname.group.disabled=true; \n";
print " }\n";
print "}\n";
print "</SCRIPT>\n";
print "<FORM NAME=\"samsreconfigform\" ACTION=\"main.php\">\n";
print "<BR><INPUT TYPE=\"SUBMIT\" value=\"{$adminbuttom_1_prop_SamsReConfigForm_12}\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"show\" value=\"exe\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"function\" value=\"proxyreconfig\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"filename\" value=\"proxybuttom_1_prop.php\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"defauth\" value=\"{$PROXYConf->s_auth}\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"id\" value=\"{$proxy_id}\">\n";
print "<P><B>{$adminbuttom_1_prop_SamsReConfigForm_45}:</B>\n";
print "<TABLE CLASS=samstable>\n";
print "<TR><TD><B>{$CacheForm_squidbuttom_4_addcache_3}: </B>\n";
print "<TD><INPUT TYPE=\"TEXT\" NAME=\"description\" value=\"{$PROXYConf->s_description}\">\n";
print "<TR><TD><B>{$adminbuttom_1_prop_SamsReConfigForm_46}: </B>\n";
print "<TD><SELECT NAME=\"traffic\">\n";
if ($PROXYConf->s_realsize == "real") {
print "<OPTION VALUE=\"real\" SELECTED> {$adminbuttom_1_prop_SamsReConfigForm_47}";
print "<OPTION VALUE=\"full\"> {$adminbuttom_1_prop_SamsReConfigForm_48}";
} else {
print "<OPTION VALUE=\"real\"> {$adminbuttom_1_prop_SamsReConfigForm_47}";
print "<OPTION VALUE=\"full\" SELECTED> {$adminbuttom_1_prop_SamsReConfigForm_48}";
}
print "</SELECT>\n";
print "<TR>\n";
print "<TD><B>{$adminbuttom_1_prop_SamsReConfigForm_49}</B>\n";
if ($PROXYConf->s_checkdns == 1) {
print "<TD><INPUT TYPE=\"CHECKBOX\" NAME=\"checkdns\" CHECKED>\n";
} else {
print "<TD><INPUT TYPE=\"CHECKBOX\" NAME=\"checkdns\" > \n";
}
print "<TR>\n";
print "<TD><B>{$adminbuttom_1_prop_SamsReConfigForm_51}</B>\n";
print "<TD><SELECT NAME=\"loglevel\">\n";
for ($i = 0; $i < 10; $i++) {
if ($PROXYConf->s_debuglevel == $i) {
print "<OPTION VALUE=\"{$i}\" SELECTED> {$i}";
} else {
print "<OPTION VALUE=\"{$i}\"> {$i}";
}
}
print "<TR>\n";
print "<TD><B>{$adminbuttom_1_prop_SamsReConfigForm_52}</B>\n";
print "<TD><INPUT TYPE=\"TEXT\" NAME=\"defaultdomain\" value=\"{$PROXYConf->s_defaultdomain}\">\n";
print "<TR>\n";
/*
$scount=0;
if ($handle2 = opendir("./src/script"))
{
while (false !== ($file = readdir($handle2)))
{
if($file!="."&&$file!=".."&&$file!=".svn")
{
if(strlen($file)>0)
{
$script[$scount]=$file;
$scount++;
}
}
}
}
print("<TD><B>$configbuttom_1_prop_SamsReConfigForm_56</B>\n");
print("<TD><SELECT NAME=\"udscript\" ID=\"udscript\" >\n");
$SELECTED="";
if($PROXYConf->s_udscript=="none")
$SELECTED="SELECTED";
print("<OPTION VALUE=\"none\" $SELECTED> NONE\n");
for($i=0;$i<$scount;$i++)
{
$SELECTED="";
if($PROXYConf->s_udscript==$script[$i])
$SELECTED="SELECTED";
print("<OPTION VALUE=\"$script[$i]\" $SELECTED> $script[$i]\n");
}
print("</SELECT>\n");
*/
print "<TR>\n";
print "<TD><B>{$configbuttom_1_prop_SamsReConfigForm_57}</B>\n";
print "<TD><INPUT TYPE=\"TEXT\" NAME=\"adminaddr\" value=\"{$PROXYConf->s_adminaddr}\">\n";
print "</TABLE>\n";
print "<BR>\n";
print "<P><B>{$adminbuttom_1_prop_SamsReConfigForm_17}</B>\n";
print "<TABLE class=samstable>\n";
print "<TR>\n";
print "<TD ROWSPAN=3>\n";
print "<BR><SELECT NAME=\"authtype\" ID=\"authtype\" onchange=ChangeAuthScheme(samsreconfigform)>\n";
$QUERY = "SELECT s_auth FROM auth_param WHERE s_param='enabled' AND s_value='1'";
$num_rows = $DB->samsdb_query_value($QUERY);
$row_num = 0;
$selected_auth = "";
while ($row = $DB->samsdb_fetch_array()) {
$SELECTED = "";
if ($row_num == 0) {
$selected_auth = $row['s_auth'];
$SELECTED = "SELECTED";
$row_num = 1;
}
if ($row['s_auth'] == $PROXYConf->s_auth) {
$selected_auth = $row['s_auth'];
$SELECTED = "SELECTED";
}
print "<OPTION VALUE={$row['s_auth']} {$SELECTED}> {$row['s_auth']}";
}
print "</SELECT>\n";
$DB->free_samsdb_query();
$DOMAINDISABLE = "DISABLED";
$USERDISABLE = "DISABLED";
if ($selected_auth == "adld" || $selected_auth == "ntlm") {
$DOMAINDISABLE = "ENABLED";
}
if ($selected_auth != "ip") {
$USERDISABLE = "ENABLED";
}
print "</TD>\n";
print "</TR>\n";
print "<TR>\n";
print "<TD>\n";
if ($PROXYConf->s_usedomain == 1) {
print "<INPUT TYPE=\"CHECKBOX\" NAME=\"usedomain\" {$DOMAINDISABLE} CHECKED onchange=EnableDomainName(samsreconfigform)>{$adminbuttom_1_prop_SamsReConfigForm_18}\n";
$DOMAINDISABLE = "";
$USERDISABLE = "";
} else {
print "<INPUT TYPE=\"CHECKBOX\" NAME=\"usedomain\" {$DOMAINDISABLE} onchange=EnableDomainName(samsreconfigform)>{$adminbuttom_1_prop_SamsReConfigForm_19}\n";
$DOMAINDISABLE = "DISABLED";
$USERDISABLE = "DISABLED";
}
print "<BR>{$adminbuttom_1_prop_SamsReConfigForm_20} \n";
print "<SELECT NAME=\"bigdomain\" {$DOMAINDISABLE} onchange=EnableDomainName(samsreconfigform)>\n";
if ($PROXYConf->s_bigd == 0) {
print "<OPTION VALUE=0 SELECTED >{$adminbuttom_1_prop_SamsReConfigForm_20a}</OPTION>\n";
} else {
print "<OPTION VALUE=0>{$adminbuttom_1_prop_SamsReConfigForm_20a}</OPTION>\n";
}
if ($PROXYConf->s_bigd == 1) {
print "<OPTION VALUE=1 SELECTED >{$adminbuttom_1_prop_SamsReConfigForm_20b}</OPTION>\n";
} else {
print "<OPTION VALUE=1 >{$adminbuttom_1_prop_SamsReConfigForm_20b}</OPTION>\n";
}
if ($PROXYConf->s_bigd == 2) {
print "<OPTION VALUE=2 SELECTED >{$adminbuttom_1_prop_SamsReConfigForm_20c}</OPTION>\n";
} else {
print "<OPTION VALUE=2>{$adminbuttom_1_prop_SamsReConfigForm_20c}</OPTION>\n";
}
print "</SELECT >\n";
print "<BR>{$adminbuttom_1_prop_SamsReConfigForm_22} \n";
print "<SELECT NAME=\"bigusername\" {$USERDISABLE} onchange=EnableDomainName(samsreconfigform)>\n";
if ($PROXYConf->s_bigu == 0) {
print "<OPTION VALUE=0 SELECTED>{$adminbuttom_1_prop_SamsReConfigForm_20a}</OPTION>\n";
} else {
print "<OPTION VALUE=0>{$adminbuttom_1_prop_SamsReConfigForm_20a}</OPTION>\n";
}
if ($PROXYConf->s_bigu == 1) {
print "<OPTION VALUE=1 SELECTED >{$adminbuttom_1_prop_SamsReConfigForm_20b}</OPTION>\n";
} else {
print "<OPTION VALUE=1 >{$adminbuttom_1_prop_SamsReConfigForm_20b}</OPTION>\n";
}
if ($PROXYConf->s_bigu == 2) {
print "<OPTION VALUE=2 SELECTED>{$adminbuttom_1_prop_SamsReConfigForm_20c}</OPTION>\n";
} else {
print "<OPTION VALUE=2>{$adminbuttom_1_prop_SamsReConfigForm_20c}</OPTION>\n";
}
print "</SELECT>\n";
print "<P>{$adminbuttom_1_prop_SamsReConfigForm_50}: \n";
print "<SELECT NAME=\"separator\" {$USERDISABLE}>\n";
if (strstr($PROXYConf->s_separator, "+") != FALSE) {
print "<OPTION VALUE=0 SELECTED>+</OPTION>\n";
} else {
print "<OPTION VALUE=0>+</OPTION>\n";
}
if (strstr($PROXYConf->s_separator, "\\") != FALSE) {
print "<OPTION VALUE=1 SELECTED >\\</OPTION>\n";
} else {
print "<OPTION VALUE=1 >\\</OPTION>\n";
}
if (strstr($PROXYConf->s_separator, "@") != FALSE) {
print "<OPTION VALUE=2 SELECTED>@</OPTION>\n";
} else {
print "<OPTION VALUE=2>@</OPTION>\n";
}
print "</SELECT>\n";
print "</TD>\n";
print "</TR>\n";
print "</TABLE>\n";
print "<BR>\n";
print "<P><CENTER><B>{$adminbuttom_1_prop_SamsReConfigForm_30}</B></CENTER>\n";
print "<TABLE class=samstable>\n";
$SLEEP = 1;
if ($PROXYConf->s_sleep > 0) {
$SLEEP = $PROXYConf->s_sleep;
}
print "<TR><TD><B>{$adminbuttom_1_prop_SamsReConfigForm_31}</B>\n";
print "<TD><INPUT TYPE=\"TEXT\" NAME=\"sleep\" SIZE=5 VALUE={$SLEEP}> {$adminbuttom_1_prop_SamsReConfigForm_32}\n";
print "<TR>\n";
print "<TD><B>{$adminbuttom_1_prop_SamsReConfigForm_38}</B>\n";
if ($PROXYConf->s_parser > 0) {
print "<TD><INPUT TYPE=\"CHECKBOX\" NAME=\"parser_on\" onchange=EnableParser(samsreconfigform) CHECKED>\n";
} else {
$DISABLED_PARSER = "DISABLED";
print "<TD><INPUT TYPE=\"CHECKBOX\" NAME=\"parser_on\" onchange=EnableParser(samsreconfigform)> \n";
}
if ($PROXYConf->s_parser_time > 0) {
$time = $PROXYConf->s_parser_time;
} else {
$time = 1;
}
print "<TR><TD ALIGN=\"RIGHT\"><B>{$adminbuttom_1_prop_SamsReConfigForm_35}</B>\n";
print "<TD><INPUT TYPE=\"TEXT\" NAME=\"parser_time\" SIZE=5 VALUE=\"{$time}\" {$DISABLED_PARSER}> {$adminbuttom_1_prop_SamsReConfigForm_36}\n";
print "<TR><TD><B>{$adminbuttom_1_prop_SamsReConfigForm_37} </B>\n";
if ($PROXYConf->s_count_clean == 1) {
print "<TD><INPUT TYPE=\"CHECKBOX\" NAME=\"count_clean\" CHECKED >\n";
} else {
print "<TD><INPUT TYPE=\"CHECKBOX\" NAME=\"count_clean\" > \n";
}
print "</TABLE >\n";
print "<P><TABLE class=samstable>\n";
print "<TR>\n";
print "<TD><B>{$adminbuttom_1_prop_SamsReConfigForm_3}</B>\n";
print "<TD><INPUT TYPE=\"TEXT\" NAME=\"wbinfopath\" SIZE=50 VALUE=\"{$PROXYConf->s_wbinfopath}\">\n";
print "<TR>\n";
print "<TD><B>{$adminbuttom_1_prop_SamsReConfigForm_4}</B>\n";
print "<TD><INPUT TYPE=\"TEXT\" NAME=\"redirect_to\" SIZE=50 VALUE=\"{$PROXYConf->s_redirect_to}\">\n";
print "<TR>\n";
print "<TD><B>{$adminbuttom_1_prop_SamsReConfigForm_5}</B>\n";
print "<TD><INPUT TYPE=\"TEXT\" NAME=\"denied_to\" SIZE=50 VALUE=\"{$PROXYConf->s_denied_to}\"> \n";
print "<TR>\n";
print "<TD><B>{$adminbuttom_1_prop_SamsReConfigForm_6}</B>\n";
print "<TD><SELECT NAME=\"redirector\">\n";
if ($PROXYConf->s_redirector == "none") {
print "<OPTION VALUE=\"none\" SELECTED> {$adminbuttom_1_prop_SamsReConfigForm_43}";
} else {
print "<OPTION VALUE=\"none\" > {$adminbuttom_1_prop_SamsReConfigForm_43}";
}
if ($PROXYConf->s_redirector == "sams") {
print "<OPTION VALUE=\"sams\" SELECTED> {$adminbuttom_1_prop_SamsReConfigForm_7}";
} else {
print "<OPTION VALUE=\"sams\" > {$adminbuttom_1_prop_SamsReConfigForm_7}";
}
if ($PROXYConf->s_redirector == "rejik") {
print "<OPTION VALUE=\"rejik\" SELECTED> Rejik";
} else {
print "<OPTION VALUE=\"rejik\"> Rejik";
}
if ($PROXYConf->s_redirector == "squidguard") {
print "<OPTION VALUE=\"squidguard\" SELECTED> SquidGuard";
} else {
print "<OPTION VALUE=\"squidguard\"> SquidGuard";
}
if ($PROXYConf->s_redirector == "squid") {
print "<OPTION VALUE=\"squid\" SELECTED> {$adminbuttom_1_prop_SamsReConfigForm_8}";
} else {
print "<OPTION VALUE=\"squid\"> {$adminbuttom_1_prop_SamsReConfigForm_8}";
}
print "</SELECT>\n";
print "<TR>\n";
print "<TD><B>{$adminbuttom_1_prop_SamsReConfigForm_9}</B>\n";
if ($PROXYConf->s_delaypool == 1) {
print "<TD><INPUT TYPE=\"CHECKBOX\" NAME=\"delaypool\" CHECKED> \n";
} else {
print "<TD><INPUT TYPE=\"CHECKBOX\" NAME=\"delaypool\" > \n";
}
print "<TR>\n";
print "<TD><B>{$configbuttom_1_prop_SamsReConfigForm_53}</B>\n";
print "<TD><SELECT NAME=\"squidbase\">\n";
$SELECTED = "";
if ($PROXYConf->s_squidbase == 0) {
$SELECTED = "SELECTED";
}
print "<OPTION VALUE=\"0\" {$SELECTED}> {$configbuttom_1_prop_SamsReConfigForm_54}";
for ($i = 1; $i <= 12; $i++) {
$SELECTED = "";
if ($PROXYConf->s_squidbase == $i) {
$SELECTED = "SELECTED";
}
print "<OPTION VALUE=\"{$i}\" {$SELECTED}> {$i}";
}
print "</SELECT>\n";
print "{$configbuttom_1_prop_SamsReConfigForm_55}\n";
$USERADD = "";
if ($PROXYConf->s_autouser == 0) {
$USERADD = "DISABLED";
}
print "<TR>\n";
print "<TD><B>{$configbuttom_1_prop_SamsReConfigForm_58}</B>\n";
if ($PROXYConf->s_autouser == 1) {
print "<TD><INPUT TYPE=\"CHECKBOX\" NAME=\"autouser\" onchange=EnableUserAdd(samsreconfigform) CHECKED> \n";
} else {
print "<TD><INPUT TYPE=\"CHECKBOX\" NAME=\"autouser\" onchange=EnableUserAdd(samsreconfigform) > \n";
}
print "<TR>\n";
print "<TD><B>{$configbuttom_1_prop_SamsReConfigForm_59}</B>\n";
print "<TD><SELECT NAME=\"shablon\" ID=\"shablon\" SIZE=1 TABINDEX=30 {$USERADD} >\n";
print "<OPTION VALUE=\"-1\" SELECTED> NONE";
$num_rows = $DB->samsdb_query_value("SELECT s_shablon_id,s_name FROM shablon");
while ($row = $DB->samsdb_fetch_array()) {
if ($row['s_shablon_id'] == $PROXYConf->s_autotpl) {
print "<OPTION VALUE={$row['s_shablon_id']} SELECTED> {$row['s_name']}";
} else {
print "<OPTION VALUE={$row['s_shablon_id']}> {$row['s_name']}";
}
}
print "</SELECT>\n";
$DB->free_samsdb_query();
print "<TR>\n";
print "<TD><B>{$configbuttom_1_prop_SamsReConfigForm_60} {$USERADD}</B>\n";
print "<TD><SELECT NAME=\"group\" ID=\"group\" SIZE=1 TABINDEX=30 {$USERADD} >\n";
print "<OPTION VALUE=\"-1\" SELECTED> NONE";
$num_rows = $DB->samsdb_query_value("SELECT s_group_id, s_name FROM sgroup");
while ($row = $DB->samsdb_fetch_array()) {
if ($row['s_group_id'] == $PROXYConf->s_autogrp) {
print "<OPTION VALUE={$row['s_group_id']} SELECTED> {$row['s_name']} ";
} else {
print "<OPTION VALUE={$row['s_group_id']}> {$row['s_name']} ";
}
}
print "</SELECT>\n";
$DB->free_samsdb_query();
/**/
print "</TABLE>\n";
print "<BR><INPUT TYPE=\"SUBMIT\" value=\"{$adminbuttom_1_prop_SamsReConfigForm_12}\">\n";
print "</FORM>\n";
}
function AddUsersFromNTLMForm()
{
global $SAMSConf;
global $USERConf;
$lang = "./lang/lang.{$SAMSConf->LANG}";
require $lang;
if (isset($_GET["ldapgroup"])) {
$ldapgroup = $_GET["ldapgroup"];
}
if (isset($_GET["getgroup"])) {
$getgroup = $_GET["getgroup"];
}
if ($USERConf->ToWebInterfaceAccess("UC") != 1) {
exit(0);
}
$DB = new SAMSDB();
PageTop("user.jpg", " {$usersbuttom_1_domain_AddUsersFromDomainForm_1} NTLM ");
$ntlmserver = GetAuthParameter("ntlm", "ntlmserver");
$ntlmdomain = GetAuthParameter("ntlm", "ntlmdomain");
$ntlmadmin = GetAuthParameter("ntlm", "ntlmadmin");
$ntlmpasswd = GetAuthParameter("ntlm", "ntlmadminpasswd");
print "<FORM NAME=\"AddDomainUsers\" ACTION=\"main.php\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"domain\" id=Show value=\"{$ntlmdomain}\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"show\" id=Show value=\"exe\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"function\" id=function value=\"addusersfromntlm\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"filename\" id=filename value=\"authntlmbuttom_2_usersadd.php\">\n";
print "<TABLE>\n";
print "<TR><TD><B>{$usersbuttom_1_domain_AddUsersFromDomainForm_2}</B><TD>\n";
print "<SELECT NAME=\"username[]\" MULTIPLE>\n";
$users = ExecuteShellScript("getntlmusers", "{$LANG}");
$a = explode("|", $users);
asort($a);
$acount = count($a);
foreach ($a as $user) {
$num_rows = $DB->samsdb_query_value("SELECT * FROM squiduser WHERE s_nick='{$user}'");
if ($num_rows == 0 && strlen($user) > 0) {
print "<OPTION VALUE=\"{$user}\"> <B>{$user}</B>";
}
$DB->free_samsdb_query();
}
print "</SELECT>\n";
print "<P>";
print "<TR><TD><P>\n";
print "<TR><TD>\n";
print "<B>{$usersbuttom_1_domain_AddUsersFromDomainForm_7} \n";
print "<TD>\n";
print "<INPUT TYPE=\"TEXT\" NAME=\"domainname\" id=Show VALUE=\"{$ntlmdomain}\">\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']} ";
}
$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']}";
}
$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 JSProxyInfo()
{
global $SAMSConf;
global $PROXYConf;
$lang = "./lang/lang.{$SAMSConf->LANG}";
require $lang;
if ($PROXYConf->s_realsize == "real") {
$traffic = "{$adminbuttom_1_prop_SamsReConfigForm_47}";
} else {
$traffic = "{$adminbuttom_1_prop_SamsReConfigForm_48}";
}
if ($PROXYConf->s_auth == "ip") {
$auth = "IP";
}
if ($PROXYConf->s_auth == "ncsa") {
$auth = "NCSA";
}
if ($PROXYConf->s_auth == "ntlm") {
$auth = "NTLM";
}
if ($PROXYConf->s_auth == "adld") {
$auth = "Active Directory";
}
if ($PROXYConf->s_auth == "ldap") {
$auth = "LDAP";
}
if ($PROXYConf->s_parser == 0) {
$parser = "No";
}
if ($PROXYConf->s_parser == 2) {
$parser = "{$adminbuttom_1_prop_SamsReConfigForm_33}";
}
if ($PROXYConf->s_parser == 1) {
$parser = "{$adminbuttom_1_prop_SamsReConfigForm_34}";
}
if ($PROXYConf->s_redirector == "sams") {
$redirector = "{$adminbuttom_1_prop_SamsReConfigForm_7}";
} else {
if ($PROXYConf->s_redirector == "rejik") {
$redirector = "Rejik";
} else {
if ($PROXYConf->s_redirector == "squidguard") {
$redirector = "SquidGuard";
} else {
if ($PROXYConf->s_redirector == "squid") {
$redirector = "{$adminbuttom_1_prop_SamsReConfigForm_8}";
} else {
$redirector = "{$adminbuttom_1_prop_SamsReConfigForm_43}";
}
}
}
}
$extrainfo = "";
$DB = new SAMSDB();
$num_rows = $DB->samsdb_query("SELECT * FROM sysinfo WHERE s_status='1' AND s_proxy_id='{$PROXYConf->s_proxy_id}'");
if ($num_rows > 0) {
$extrainfo = $extrainfo . "<HR>";
$extrainfo = $extrainfo . "<TABLE CLASS=samstable>";
}
while ($row = $DB->samsdb_fetch_array()) {
$extrainfo = $extrainfo . "<TR><TD><FONT COLOR=blue>{$row['s_name']} updated at {$row['s_date']}</FONT></TD></TR>";
$extrainfo = $extrainfo . "<TR><TD>{$row['s_info']}</TD></TR>";
}
if ($num_rows > 0) {
$extrainfo = $extrainfo . "</TABLE>";
}
$DB->free_samsdb_query();
$htmlcode = "<HTML><HEAD>\n <link rel=\"STYLESHEET\" type=\"text/css\" href=\"{$SAMSConf->ICONSET}/tree.css\">\n </HEAD>\n <BODY><CENTER>\n <TABLE WIDTH=\"95%\" border=0><TR><TD WIDTH=\"10%\" valign=\"middle\">\n <img src=\"{$SAMSConf->ICONSET}/user.jpg\" align=\"RIGHT\" valign=\"middle\" >\n <TD valign=\"middle\"><h2 align=\"CENTER\">Proxy server <BR><FONT COLOR=\"BLUE\">{$PROXYConf->s_description}</FONT></h2>\n </TABLE>\n\n <TABLE>\n <TR><TD><B>{$adminbuttom_1_prop_SamsReConfigForm_53}<TD>{$PROXYConf->s_proxy_id} \n <TR><TD><B>{$adminbuttom_1_prop_SamsReConfigForm_2}<TD>{$auth} \n <TR><TD><B>{$adminbuttom_1_prop_SamsReConfigForm_38}<TD>{$parser}\n <TR><TD><B>{$adminbuttom_1_prop_SamsReConfigForm_6}<TD>{$redirector}\n <TR><TD><B>{$adminbuttom_1_prop_SamsReConfigForm_46}<TD>{$traffic}\n <TR><TD><B>{$adminbuttom_1_prop_SamsReConfigForm_54}<TD>{$PROXYConf->s_endvalue} \n </TABLE>";
$htmlcode = $htmlcode . $extrainfo;
$htmlcode = $htmlcode . "\n <IMG SRC=\"{$SAMSConf->ICONSET}/help.jpg\">\n <A HREF=\"http://sams.perm.ru/sams2/doc/" . $SAMSConf->LANG . "/squid.html\">{$documentation}</A>\n <P>\n </CENTER></BODY></HTML>";
$htmlcode = str_replace("\"", "\\\"", $htmlcode);
$htmlcode = str_replace("\n", "", $htmlcode);
print " parent.basefrm.document.write(\"{$htmlcode}\");\n";
print " parent.basefrm.document.close();\n";
}
function UsersChartGB()
{
require 'lib/piegraph.class.php';
global $SAMSConf;
global $DATE;
$DB = new SAMSDB();
$sdate = $DATE->sdate();
$edate = $DATE->edate();
$bdate = $DATE->BeginDate();
$eddate = $DATE->EndDate();
$size = "";
if (isset($_GET["size"])) {
$size = $_GET["size"];
}
if (isset($_GET["sort"])) {
$sort = $_GET["sort"];
}
if (isset($_GET["desc"])) {
$desc = $_GET["desc"];
}
$QUERY = "SELECT sum(s_size) as user_size FROM cachesum WHERE s_date>='{$sdate}' AND s_date<='{$edate}'";
$num_rows = $DB->samsdb_query_value($QUERY);
$row = $DB->samsdb_fetch_array();
$full_utraffic_size = $row['user_size'];
$DB->free_samsdb_query();
$colors = array("#FF0000", "#0000FF", "#FFFF00", "#009000", "#C3690F", "#CC009C", "#99CC33", "#3C3CFF", "#C9960C", "#FF6F00", "#C6C63C", "#CC033C", "#00FFFF", "#636F66", "#6FFF00", "#96693F", "#009C9C", "#FFCC00", "#9F9F6F", "#CC60CC");
$usercolors = array();
if ($sort == "users") {
$QUERY = "SELECT c.s_user,sum(c.s_size) as user_size,sum(c.s_hit) as hit_size, s.s_user_id as s_id FROM cachesum c, squiduser s WHERE c.s_user=s.s_nick AND c.s_date>='{$sdate}' AND c.s_date<='{$edate}' GROUP BY c.s_user, s.s_user_id ORDER BY user_size DESC;";
} else {
$QUERY = "SELECT sum.sum_name as s_user,sum(sum.sum_size) as user_size, sum(sum.sum_hit) as hit_size, sum.sum_group_id as s_id FROM ( SELECT sum(c.s_size) as sum_size, sum(c.s_hit) as sum_hit, c.s_user as sum_user, s.s_group_id as sum_group_id, g.s_name as sum_name FROM cachesum c, squiduser s, sgroup g WHERE c.s_user=s.s_nick AND s.s_group_id=g.s_group_id AND s_date>='{$sdate}' AND s_date<='{$edate}' GROUP BY c.s_user, s.s_group_id, g.s_name ORDER BY g.s_name ) as sum GROUP BY s_user, sum.sum_group_id;";
}
$num_rows = $DB->samsdb_query_value($QUERY);
$count = 0;
$sum_size = 0;
$sum_hit = 0;
$sum_pc = 0;
$another_utraffic_size = 0;
while ($row = $DB->samsdb_fetch_array()) {
if ($row['user_size'] >= $full_utraffic_size / 100) {
if ($count < count($colors)) {
$usercolors[$count] = $colors[$count];
} else {
$r = mt_rand(10, 240);
$g = mt_rand(10, 240);
$b = mt_rand(10, 240);
$usercolors[$count] = "#" . sprintf("%X%X%X", mt_rand(20, 200), mt_rand(20, 200), mt_rand(20, 200));
}
$user[$count] = $row['s_user'];
$size[$count] = $row['user_size'];
$count++;
} else {
$another_utraffic_size += $row['user_size'];
}
}
if ($another_utraffic_size > 0) {
$user[$count] = "another users";
$size[$count] = $another_utraffic_size;
$count++;
}
$pie = new PieGraph(300, 200, $size);
$pie->setColors($usercolors);
// legends for the data
$pie->setLegends($user);
// Display creation time of the graph
$pie->DisplayCreationTime();
// Height of the pie 3d effect
$pie->set3dHeight(15);
// Display the graph
$pie->display();
}
function UpdateShablonForm()
{
global $SAMSConf;
global $SHABLONConf;
global $USERConf;
$s_name = array();
$s_type = array();
$s_id = array();
$s_selected = array();
$credir = 0;
$DB = new SAMSDB();
$DB2 = new SAMSDB();
$lang = "./lang/lang.{$SAMSConf->LANG}";
require $lang;
if (isset($_GET["id"])) {
$id = $_GET["id"];
}
if ($USERConf->ToWebInterfaceAccess("C") != 1) {
exit;
}
$DENIEDDISABLED = "";
$ALLOWDISABLED = "";
$NTLMSELECTED = "";
$IPSELECTED = "";
PageTop("shablon.jpg", "{$shablon_1}<BR>{$shablonbuttom_1_prop_UpdateShablonForm_1} <FONT COLOR=\"BLUE\">{$SHABLONConf->s_name}</FONT>");
print "<IMG SRC=\"{$SAMSConf->ICONSET}/help.jpg\">";
print "<A HREF=\"http://sams.perm.ru/sams2/doc/" . $SAMSConf->LANG . "/templates.html\">{$documentation}</A>";
print "<P>\n";
print "<FORM NAME=\"UPDATESHABLON\" ACTION=\"main.php\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"show\" value=\"exe\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"function\" value=\"updateshablon\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"filename\" value=\"shablonbuttom_1_prop.php\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"id\" value=\"{$SHABLONConf->s_shablon_id}\">\n";
print "<TABLE WIDTH=\"80%\">\n";
print "<TR bgcolor=blanchedalmond><TD ALIGN=RIGHT WIDTH=\"40%\"><B> </B>\n";
print "<TD><B>{$shablonbuttom_1_prop_UpdateShablonForm_2}</B>\n";
$credir = 0;
$cselect = 0;
$num_rows = $DB->samsdb_query_value("SELECT s_redirect_id, s_name, s_type FROM redirect ORDER BY s_type ");
while ($row = $DB->samsdb_fetch_array()) {
$s_name[$credir] = $row['s_name'];
$s_type[$credir] = $row['s_type'];
$s_id[$credir] = $row['s_redirect_id'];
$credir++;
}
$DB->free_samsdb_query();
$num_rows = $DB->samsdb_query_value("SELECT redirect.s_redirect_id FROM redirect LEFT JOIN sconfig ON redirect.s_redirect_id=sconfig.s_redirect_id WHERE sconfig.s_shablon_id='{$id}' ");
while ($row = $DB->samsdb_fetch_array()) {
$s_selected[$cselect] = $row['s_redirect_id'];
$cselect++;
}
$DB->free_samsdb_query();
// ��������������� �������
$section_exist = 0;
for ($i = 0; $i < $credir; $i++) {
if ($s_type[$i] == "redir") {
if ($section_exist == 0) {
print "<TR bgcolor=blanchedalmond>\n <TD WIDTH=\"40%\"></TD>\n";
print " <TD ALIGN=LEFT WIDTH=\"60%\"><B>{$shablonbuttom_1_prop_UpdateShablonForm_8}</B></TD>\n";
print "</TR>\n";
$section_exist = 1;
}
print "<TR>\n <TD ALIGN=RIGHT WIDTH=\"40%\">";
print "<IMG SRC=\"{$SAMSConf->ICONSET}/redir.jpg\"> ";
$checked = "";
if (in_array($s_id[$i], $s_selected)) {
$checked = "CHECKED";
}
print "<INPUT TYPE=\"CHECKBOX\" NAME=\"d{$s_id[$i]}\" {$checked}></TD>\n";
print " <TD WIDTH=\"60%\">{$s_name[$i]}</TD>\n";
print "</TR>\n";
}
}
// ����������� �������
$section_exist = 0;
for ($i = 0; $i < $credir; $i++) {
if ($s_type[$i] == "replace") {
if ($section_exist == 0) {
print "<TR bgcolor=blanchedalmond>\n <TD WIDTH=\"40%\"></TD>\n";
print " <TD ALIGN=LEFT WIDTH=\"60%\"><B>Substitute url</B></TD>\n";
print "</TR>\n";
$section_exist = 1;
}
print "<TR>\n <TD ALIGN=RIGHT WIDTH=\"40%\">";
print "<IMG SRC=\"{$SAMSConf->ICONSET}/redir.jpg\"> ";
$checked = "";
if (in_array($s_id[$i], $s_selected)) {
$checked = "CHECKED";
}
print "<INPUT TYPE=\"CHECKBOX\" NAME=\"{$s_id[$i]}\" {$checked}></TD>\n";
print " <TD WIDTH=\"60%\">{$s_name[$i]}</TD>\n";
print "</TR>\n";
}
}
$DENIEDCHECKED = "";
$DENIEDDISABLED = "";
if ($SHABLONConf->s_alldenied == 1) {
$DENIEDCHECKED = "CHECKED";
$DENIEDDISABLED = "DISABLED";
}
print "<TR bgcolor=blanchedalmond>\n <TD WIDTH=\"40%\" ALIGN=RIGHT>";
print "<INPUT TYPE=\"CHECKBOX\" NAME=\"alldenied\" onclick=EnableDeniedLists(UPDATESHABLON) {$DENIEDCHECKED}></TD>\n";
print " <TD ALIGN=LEFT WIDTH=\"60%\"><B>{$shablonbuttom_1_prop_UpdateShablonForm_22}</B></TD>\n";
// ������ �������
$section_exist = 0;
for ($i = 0; $i < $credir; $i++) {
if ($s_type[$i] == "denied") {
if ($section_exist == 0) {
print "<TR bgcolor=blanchedalmond>\n <TD WIDTH=\"40%\"></TD>\n";
print " <TD ALIGN=LEFT WIDTH=\"60%\"><B>{$shablonbuttom_1_prop_UpdateShablonForm_9}</B></TD>\n";
print "</TR>\n";
$section_exist = 1;
}
print "<TR>\n <TD ALIGN=RIGHT WIDTH=\"40%\">";
print "<IMG SRC=\"{$SAMSConf->ICONSET}/redir.jpg\"> ";
$checked = "";
if (in_array($s_id[$i], $s_selected)) {
$checked = "CHECKED";
}
print "<INPUT TYPE=\"CHECKBOX\" NAME=\"d{$s_id[$i]}\" {$checked} {$DENIEDDISABLED}></TD>\n";
print " <TD WIDTH=\"60%\">{$s_name[$i]}</TD>\n";
print "</TR>\n";
}
}
// ������ ������� �� ���������� ����������
$section_exist = 0;
for ($i = 0; $i < $credir; $i++) {
if ($s_type[$i] == "regex") {
if ($section_exist == 0) {
print "<TR bgcolor=blanchedalmond>\n <TD WIDTH=\"40%\"></TD>\n";
print " <TD ALIGN=LEFT WIDTH=\"60%\"><B>{$shablonbuttom_1_prop_UpdateShablonForm_10}</B></TD>\n";
print "</TR>\n";
$section_exist = 1;
}
print "<TR>\n <TD ALIGN=RIGHT WIDTH=\"40%\">";
print "<IMG SRC=\"{$SAMSConf->ICONSET}/redir.jpg\"> ";
$checked = "";
if (in_array($s_id[$i], $s_selected)) {
$checked = "CHECKED";
}
print "<INPUT TYPE=\"CHECKBOX\" NAME=\"d{$s_id[$i]}\" {$checked}></TD>\n";
print " <TD WIDTH=\"60%\">{$s_name[$i]}</TD>\n";
print "</TR>\n";
}
}
// ������ ��������
$section_exist = 0;
for ($i = 0; $i < $credir; $i++) {
if ($s_type[$i] == "allow") {
if ($section_exist == 0) {
print "<TR bgcolor=blanchedalmond>\n <TD WIDTH=\"40%\"></TD>\n";
print " <TD ALIGN=LEFT WIDTH=\"60%\"><B>{$shablonbuttom_1_prop_UpdateShablonForm_11}</B></TD>\n";
print "</TR>\n";
$section_exist = 1;
}
print "<TR>\n <TD ALIGN=RIGHT WIDTH=\"40%\">";
print "<IMG SRC=\"{$SAMSConf->ICONSET}/redir.jpg\"> ";
$checked = "";
if (in_array($s_id[$i], $s_selected)) {
$checked = "CHECKED";
}
print "<INPUT TYPE=\"CHECKBOX\" NAME=\"d{$s_id[$i]}\" {$checked}></TD>\n";
print " <TD WIDTH=\"60%\">{$s_name[$i]}</TD>\n";
print "</TR>\n";
}
}
// afqks
$section_exist = 0;
for ($i = 0; $i < $credir; $i++) {
if ($s_type[$i] == "files") {
if ($section_exist == 0) {
print "<TR bgcolor=blanchedalmond>\n <TD WIDTH=\"40%\"></TD>\n";
print " <TD ALIGN=LEFT WIDTH=\"60%\"><B>{$shablonbuttom_1_prop_UpdateShablonForm_23}</B></TD>\n";
print "</TR>\n";
$section_exist = 1;
}
print "<TR>\n <TD ALIGN=RIGHT WIDTH=\"40%\">";
print "<IMG SRC=\"{$SAMSConf->ICONSET}/redir.jpg\"> ";
$checked = "";
if (in_array($s_id[$i], $s_selected)) {
$checked = "CHECKED";
}
print "<INPUT TYPE=\"CHECKBOX\" NAME=\"d{$s_id[$i]}\" {$checked}></TD>\n";
print " <TD WIDTH=\"60%\">{$s_name[$i]}</TD>\n";
print "</TR>\n";
}
}
print "</TABLE>\n";
$sguardgroups = array("ads", "aggressive", "audio-video", "drugs", "gambling", "hacking", "mail", "p**n", "proxy", "violence", "warez");
print "<SCRIPT LANGUAGE=JAVASCRIPT> \n";
print "function EnableDeniedLists(formname) \n";
print "{ \n";
print " if(formname.alldenied.checked==true) \n";
print " { \n";
for ($i = 0; $i < $credir; $i++) {
if ($s_type[$i] == "denied") {
print " formname.d{$s_id[$i]}.disabled=true; \n";
}
}
print " } \n";
print " if(formname.alldenied.checked==false) \n";
print " { \n";
for ($i = 0; $i < $credir; $i++) {
if ($s_type[$i] == "denied") {
print " formname.d{$s_id[$i]}.disabled=false; \n";
}
}
print " } \n";
print "} \n";
print "</SCRIPT> \n";
print "<TABLE>\n";
print "<TR>\n";
print "<TD>\n";
print "<B>{$shablonbuttom_1_prop_UpdateShablonForm_4}:\n";
print "<TD>\n";
print "<INPUT TYPE=\"TEXT\" NAME=\"defaulttraf\" SIZE=6 VALUE=\"{$SHABLONConf->s_quote}\"> <B> 0 - unlimited traffic \n";
print "<TR>\n";
print "<TD><B>{$shablonbuttom_1_prop_UpdateShablonForm_28}</B>\n";
print "<TD><SELECT NAME=\"shablon2\" ID=\"shablon2\" SIZE=1>\n";
print "<OPTION VALUE=\"-1\" SELECTED> NONE";
$num_rows = $DB->samsdb_query_value("SELECT s_shablon_id,s_name FROM shablon WHERE s_shablon_id!={$id}");
while ($row = $DB->samsdb_fetch_array()) {
if ($row['s_shablon_id'] == $SHABLONConf->s_shablon_id2) {
print "<OPTION VALUE={$row['s_shablon_id']} SELECTED> {$row['s_name']}";
} else {
print "<OPTION VALUE={$row['s_shablon_id']}> {$row['s_name']}";
}
}
print "</SELECT>\n";
$DB->free_samsdb_query();
print "<TR>\n";
print "<TD>\n";
print "<B>{$shablonbuttom_1_prop_UpdateShablonForm_19} \n";
print "<TD>\n";
print "<SELECT NAME=\"auth\"> \n";
$DB->samsdb_query_value("SELECT s_auth,s_value FROM auth_param WHERE s_param='enabled' AND s_value='1' ");
while ($row = $DB->samsdb_fetch_array()) {
$SELECTED = "";
if ($row['s_auth'] == $SHABLONConf->s_auth) {
$SELECTED = "SELECTED";
}
print "<OPTION value=" . $row['s_auth'] . " {$SELECTED}>" . $row['s_auth'] . " \n";
}
print "</SELECT>\n";
print "<SCRIPT LANGUAGE=JAVASCRIPT> \n";
print "function EnterPeriod(formname) \n";
print "{ \n";
print " var period=formname.period.value; \n";
print " var clryear=formname.clryear.value; \n";
print " var clrmonth=formname.clrmonth.value; \n";
print " var clrday=formname.clrday.value; \n";
print " if(period==\"A\") \n";
print " {\n";
print " formname.newperiod.disabled=false; \n";
print " formname.clryear.disabled=false; \n";
print " formname.clrmonth.disabled=false; \n";
print " formname.clrday.disabled=false; \n";
print " }\n";
print " else \n";
print " {\n";
print " formname.newperiod.disabled=true; \n";
print " formname.clryear.disabled=true; \n";
print " formname.clrmonth.disabled=true; \n";
print " formname.clrday.disabled=true; \n";
print " }\n";
print "}\n";
print "</SCRIPT> \n";
$CCLEAN = "";
if ($SAMSConf->CCLEAN != "Y") {
$CCLEAN = "DISABLED";
}
$CCLEAN = "";
print "<TR>\n";
print "<TD>\n";
print "<B>{$shablonbuttom_1_prop_UpdateShablonForm_20} \n";
print "<TD>\n";
print "<SELECT NAME=\"period\" onchange=EnterPeriod(UPDATESHABLON) {$CCLEAN}> \n";
$MSELECTED = "";
$WSELECTED = "";
$DSELECTED = "";
$ASELECTED = "";
$ADISABLED = "DISABLED";
$AVALUE = "1";
if ($SHABLONConf->s_period == "M") {
$MSELECTED = "SELECTED";
}
print "<OPTION value=\"M\" {$MSELECTED}>{$shablonbuttom_1_prop_UpdateShablonForm_24} \n";
if ($SHABLONConf->s_period == "W") {
$WSELECTED = "SELECTED";
}
print "<OPTION value=\"W\" {$WSELECTED}>{$shablonbuttom_1_prop_UpdateShablonForm_25} \n";
if ($SHABLONConf->s_period == "D") {
$DSELECTED = "SELECTED";
}
print "<OPTION value=\"D\" {$DSELECTED}>{$shablonbuttom_1_prop_UpdateShablonForm_27} \n";
if ($SHABLONConf->s_period != "M" && $SHABLONConf->s_period != "W" && $SHABLONConf->s_period != "D") {
$ASELECTED = "SELECTED";
$ADISABLED = "";
$AVALUE = $SHABLONConf->s_period;
$YCLRVALUE = substr($SHABLONConf->s_clrdate, 0, 4);
$MCLRVALUE = substr($SHABLONConf->s_clrdate, 5, 2);
$DCLRVALUE = substr($SHABLONConf->s_clrdate, 8, 2);
} else {
$month = array(0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12);
$days = array(0, 31, 28, 31, 30, 31, 30, 31, 31, 30, 31, 30, 31);
$YCLRVALUE = strftime("%Y");
$MCLRVALUE = strftime("%m");
$DCLRVALUE = strftime("%d");
if ($DCLRVALUE + 1 > $days[$MCLRVALUE]) {
$DCLRVALUE = 1;
$MCLRVALUE += 1;
if ($MCLRVALUE > 12) {
$MCLRVALUE = 1;
$YCLRVALUE += 1;
}
} else {
$DCLRVALUE += 1;
}
}
print "<OPTION value=\"A\" {$ASELECTED}>{$shablonbuttom_1_prop_UpdateShablonForm_15}\n";
print "</SELECT>\n";
print "<TR><TD>\n";
print "<TD> {$shablonbuttom_1_prop_UpdateShablonForm_16}: \n";
print "<INPUT TYPE=\"TEXT\" NAME=\"newperiod\" SIZE=5 {$ADISABLED} VALUE=\"{$AVALUE}\"> {$shablonbuttom_1_prop_UpdateShablonForm_17}\n";
print "<TR><TD><TD>{$shablonbuttom_1_prop_UpdateShablonForm_18}: \n";
print "<BR><INPUT TYPE=\"TEXT\" NAME=\"clryear\" SIZE=4 {$ADISABLED} VALUE=\"{$YCLRVALUE}\">:\n";
print "<INPUT TYPE=\"TEXT\" NAME=\"clrmonth\" SIZE=2 {$ADISABLED} VALUE=\"{$MCLRVALUE}\">:\n";
print "<INPUT TYPE=\"TEXT\" NAME=\"clrday\" SIZE=2 {$ADISABLED} VALUE=\"{$DCLRVALUE}\">\n";
print "<TR><TD><B>Delay pool </B>\n";
$QUERY = "SELECT delaypool.s_pool_id as delaypoolid, delaypool.s_name as delaypoolname, shablon.s_shablon_id as shablonid FROM delaypool LEFT JOIN d_link_s ON delaypool.s_pool_id=d_link_s.s_pool_id LEFT JOIN shablon ON d_link_s.s_shablon_id=shablon.s_shablon_id";
$num_rows = $DB->samsdb_query_value($QUERY);
print "<TD>\n";
print "<SELECT NAME=\"delaypool\">\n";
if ($num_rows > 0) {
while ($row = $DB->samsdb_fetch_array()) {
$DELAYPOOLSELECTED = "";
if ($id == $row['shablonid']) {
$DELAYPOOLSELECTED = "SELECTED";
}
print "<OPTION VALUE=\"{$row['delaypoolid']}\" {$DELAYPOOLSELECTED}> {$row['delaypoolname']}\n";
}
}
$DB->free_samsdb_query();
print "</TABLE>\n";
print "<BR><INPUT TYPE=\"SUBMIT\" value=\"{$shablonbuttom_1_prop_UpdateShablonForm_7}\">\n";
print "</FORM>\n";
print "<P><B>{$AddTRangeForm_trangetray_1}: </B>\n";
print "<TABLE>\n";
print "<FORM NAME=\"REMOVETRANGE2shablon\" ACTION=\"main.php\">\n";
$num_rows = $DB2->samsdb_query_value("SELECT sconfig_time.*, timerange.s_name, timerange.s_timestart, s_timeend FROM sconfig_time LEFT JOIN timerange ON sconfig_time.s_trange_id=timerange.s_trange_id WHERE sconfig_time.s_shablon_id='{$id}' ");
if ($num_rows > 0) {
while ($row2 = $DB2->samsdb_fetch_array()) {
print "<TR><TD ALIGN=\"RIGHT\" > <B>{$row2['s_name']}</B> ({$row2['s_timestart']} - {$row2['s_timeend']} ) ";
print "<INPUT TYPE=\"BUTTON\" value=\"{$redir_filetypesform2}\" Onclick=RemoveTRange({$row2['s_trange_id']})>\n";
}
}
print "</TABLE>\n";
if ($num_rows > 1) {
print "<SCRIPT language=JAVASCRIPT>\n";
print "function RemoveTRange(id)\n";
print "{\n";
print " var href=\"main.php?show=exe&function=removetrange2shablon&filename=shablonbuttom_1_prop.php&shablon_id={$SHABLONConf->s_shablon_id}&id=\"+id; ";
print " value=window.confirm(\"{$shablonbuttom_1_prop_UpdateShablonForm_30}\");\n";
print " if(value==true) \n";
print " {\n";
print " parent.basefrm.location.href=href;\n";
print " }\n";
print "}\n";
print "</SCRIPT> \n";
} else {
print "<SCRIPT language=JAVASCRIPT>\n";
print "function RemoveTRange(id)\n";
print "{\n";
print " value=window.alert(\"{$shablonbuttom_1_prop_UpdateShablonForm_31}\");\n";
print " if(value==true) \n";
print " {\n";
print " parent.basefrm.location.href=href;\n";
print " }\n";
print "}\n";
print "</SCRIPT> \n";
}
$DB2->free_samsdb_query();
print "<P><B>{$shablonbuttom_1_prop_UpdateShablonForm_29}: </B>\n";
print "<TABLE>\n";
print "<FORM NAME=\"ADDTRANGE2shablon\" ACTION=\"main.php\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"show\" value=\"exe\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"function\" value=\"addtrange2shablon\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"filename\" value=\"shablonbuttom_1_prop.php\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"id\" value=\"{$id}\">\n";
print "<TD><SELECT NAME=\"trange\" ID=\"trange\" >\n";
$num_rows = $DB->samsdb_query_value("SELECT timerange.*,sconfig_time.s_shablon_id FROM timerange LEFT JOIN sconfig_time ON timerange.s_trange_id=sconfig_time.s_trange_id");
$prev_trange_id = -1;
while ($row = $DB->samsdb_fetch_array()) {
if ($row['s_shablon_id'] != $id && $row['s_trange_id'] != $prev_trange_id) {
print "<OPTION VALUE={$row['s_trange_id']}> {$row['s_name']} ({$row['s_timestart']} - {$row['s_timeend']} )";
}
$prev_trange_id = $row['s_trange_id'];
}
print "</SELECT>\n";
$DB->free_samsdb_query();
print "<INPUT TYPE=\"SUBMIT\" value=\"Add\">\n";
print "</TABLE>\n";
print "</FORM>\n";
}
function AddUsersFromLDAPForm()
{
global $SAMSConf;
global $USERConf;
$lang = "./lang/lang.{$SAMSConf->LANG}";
require $lang;
if (isset($_GET["ldapgroup"])) {
$ldapgroup = $_GET["ldapgroup"];
}
if (isset($_GET["getgroup"])) {
$getgroup = $_GET["getgroup"];
}
if (isset($_GET["addgroupname"])) {
$addgroupname = $_GET["addgroupname"];
}
if ($USERConf->ToWebInterfaceAccess("UC") != 1) {
exit;
}
PageTop("user.jpg", " {$usersbuttom_1_domain_AddUsersFromDomainForm_1} LDAP");
$DB = new SAMSDB();
$adldserver = GetAuthParameter("ldap", "ldapserver");
$basedn = GetAuthParameter("ldap", "basedn");
$adadmin = GetAuthParameter("ldap", "adadmin");
$adadminpasswd = GetAuthParameter("ldap", "adadminpasswd");
$usersrdn = GetAuthParameter("ldap", "usersrdn");
$usersfilter = GetAuthParameter("ldap", "usersfilter");
$usernameattr = GetAuthParameter("ldap", "usernameattr");
$groupsrdn = GetAuthParameter("ldap", "groupsrdn");
$groupsfilter = GetAuthParameter("ldap", "groupsfilter");
include 'ldap.php';
$samsldap = new sams_ldap($adldserver, $basedn, $usersrdn, $usersfilter, $usernameattr, $groupsrdn, $groupsfilter, $adadmin, $adadminpasswd);
if ($samsldap != NULL) {
print "<FORM NAME=\"SelectUsersGroup\" ACTION=\"main.php\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"show\" id=Show value=\"exe\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"function\" value=\"addusersfromldapform\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"filename\" id=filename value=\"authldapbuttom_2_usersadd.php\">\n";
if ($addgroupname == "_allgroups_" || $addgroupname == "") {
$a = $samsldap->GetUsersData();
} else {
$a = $samsldap->GetUsersWithPrimaryGroupID($addgroupname);
$b = $samsldap->GetUsersWithSecondaryGroupID($addgroupname);
for ($i = 0; $i < $a['userscount']; $i++) {
$user = $a['uid'][$i];
$username = $a['name'][$i];
print "<B>{$user}</B> ({$username}) <BR>\n";
}
}
$groupinfo = $samsldap->GetGroupsData();
$SELECTED = "";
if ($addgroupname == "_allgroups_" || $addgroupname == "") {
$SELECTED = "SELECTED";
}
print "<TR><TD>{$usersbuttom_1_adldap_AddUsersFromAdLDAPForm_1}\n";
print "<TD><SELECT NAME=\"addgroupname\">\n";
print "<OPTION VALUE=\"_allgroups_\"> {$usersbuttom_1_adldap_AddUsersFromAdLDAPForm_5} \n";
for ($i = 0; $i < $groupinfo['groupscount']; $i++) {
$groupname = $groupinfo['cn'][$i];
$gid = $groupinfo['gidNumber'][$i];
$SELECTED = "";
if ($groupname == $addgroupname) {
$SELECTED = "SELECTED";
}
print "<OPTION VALUE=\"{$groupname}\" {$SELECTED}> {$groupname} \n";
}
print "</SELECT>\n";
print "</TABLE>\n";
print "<INPUT TYPE=\"SUBMIT\" value=\"{$usersbuttom_1_adldap_AddUsersFromAdLDAPForm_2}\" >\n";
print "<P>\n";
print "</FORM>\n";
print "<FORM NAME=\"AddDomainUsers\" 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=\"addusersfromldap\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"filename\" id=filename value=\"authldapbuttom_2_usersadd.php\">\n";
if (strlen($ldapgroup) > 0 && $ldapgroup != "_allgroups_" && $ldapgroup != "_gettxtinput_") {
printf("<B>{$usersbuttom_1_adldap_AddUsersFromAdLDAPForm_4}: {$ldapgroup}</B><BR>");
} else {
if (strlen($ldapgroup) > 0 && $ldapgroup == "_gettxtinput_") {
printf("<B>{$usersbuttom_1_adldap_AddUsersFromAdLDAPForm_4}: {$getgroup}</B><BR>");
} else {
print "<BR><B>{$usersbuttom_1_domain_AddUsersFromDomainForm_2}</B><BR>";
}
}
print "<SELECT NAME=\"username[]\" MULTIPLE>\n";
for ($i = 0; $i < $a['userscount']; $i++) {
$user = $a['uid'][$i];
$username = $a['name'][$i];
$num_rows = $DB->samsdb_query_value("SELECT * FROM squiduser WHERE s_nick='{$user}'");
if ($num_rows == 0) {
print "<OPTION VALUE=\"{$user}\"> <B>{$user}</B> ({$username}) \n";
}
$DB->free_samsdb_query();
}
for ($i = 0; $i < $b['userscount']; $i++) {
$user = $b['uid'][$i];
$username = $b['name'][$i];
$num_rows = $DB->samsdb_query_value("SELECT * FROM squiduser WHERE s_nick='{$user}'");
if ($num_rows == 0) {
print "<OPTION VALUE=\"{$user}\"> <B>{$user}</B> ({$username}) \n";
}
$DB->free_samsdb_query();
}
print "</SELECT>\n";
print "<P>";
print "<TABLE>\n";
print "<TR><TD><P>\n";
print "<TR><TD>\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";
/*
print("<FORM NAME=\"AddDomainUsers\" ACTION=\"main.php\">\n");
print("<SCRIPT language=JAVASCRIPT>\n");
print("function SelectADGroup(formname)\n");
print("{\n");
print(" var group=formname.addgroupname.value; \n");
print(" var getgroup=formname.getgroup.value; \n");
print(" var str=\"main.php?show=exe&ldapgroup=\"+group+\"&getgroup=\"+getgroup+\"&function=addusersfromldapform&filename=authldapbuttom_2_usersadd.php\"; \n");
print(" parent.basefrm.location.href=str;\n");
print("}\n");
print("function EnableTxtInput(formname)\n");
print("{\n");
print(" value=document.forms[\"AddDomainUsers\"].elements[\"addgroupname\"].value;\n");
print(" if(value==\"_gettxtinput_\") \n");
print(" {\n");
print(" document.forms[\"AddDomainUsers\"].elements[\"getgroup\"].disabled=false\n");
print(" }\n");
print(" else \n");
print(" {\n");
print(" document.forms[\"AddDomainUsers\"].elements[\"getgroup\"].disabled=true\n");
print(" }\n");
print("}\n");
print("</SCRIPT> \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=\"addusersfromldapap\">\n");
print("<INPUT TYPE=\"HIDDEN\" NAME=\"filename\" id=filename value=\"authldapbuttom_2_usersadd.php\">\n");
print("<TABLE>\n");
print("<TR><TD><P>\n");
print("<TR><TD>\n");
print("<B>$usersbuttom_1_domain_AddUsersFromDomainForm_7\n");
print("<TD>\n");
print("<INPUT TYPE=\"TEXT\" NAME=\"domainname\" id=Show VALUE=\"$basedn\">\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] ");
}
$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]");
}
$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 AddUsersFromADLDForm()
{
global $SAMSConf;
global $USERConf;
$lang = "./lang/lang.{$SAMSConf->LANG}";
require $lang;
if (isset($_GET["ldapgroup"])) {
$ldapgroup = $_GET["ldapgroup"];
}
if (isset($_GET["getgroup"])) {
$getgroup = $_GET["getgroup"];
}
if ($USERConf->ToWebInterfaceAccess("UC") != 1) {
exit(0);
}
PageTop("user.jpg", " {$usersbuttom_1_domain_AddUsersFromDomainForm_1} Active Directory ");
require_once "src/adldap.php";
print "<FORM NAME=\"AddDomainUsers\" ACTION=\"main.php\">\n";
$DB = new SAMSDB();
$adldserver = GetAuthParameter("adld", "adldserver");
$basedn = GetAuthParameter("adld", "basedn");
$adadmin = GetAuthParameter("adld", "adadmin");
$adadminpasswd = GetAuthParameter("adld", "adadminpasswd");
$usergroup = GetAuthParameter("adld", "usergroup");
$LDAPBASEDN2 = strtok($basedn, ".");
$LDAPBASEDN = "DC={$LDAPBASEDN2}";
while (strlen($LDAPBASEDN2) > 0) {
$LDAPBASEDN2 = strtok(".");
if (strlen($LDAPBASEDN2) > 0) {
$LDAPBASEDN = "{$LDAPBASEDN},DC={$LDAPBASEDN2}";
}
}
$pdc = array("{$adldserver}");
$options = array(account_suffix => "@{$basedn}", base_dn => "{$LDAPBASEDN}", domain_controllers => $pdc, ad_username => "{$adadmin}", ad_password => "{$adadminpasswd}", "", "", "");
$ldap = new adLDAP($options);
$usersgroupname = "Users";
$a = $ldap->all_users($include_desc = false, $search = "*", $sorted = true);
$acount = count($a);
if (strlen($ldapgroup) > 0 && $ldapgroup != "_allgroups_" && $ldapgroup != "_gettxtinput_") {
$usersgroupname = $ldapgroup;
} else {
if (strlen($ldapgroup) > 0 && $ldapgroup == "_gettxtinput_") {
$usersgroupname = $getgroup;
}
}
$groupinfo = $ldap->all_groups($include_desc = false, $search = "*", $sorted = true);
$gcount = count($groupinfo);
print "<FORM NAME=\"AddDomainUsers\" ACTION=\"main.php\">\n";
/* */
print "<SCRIPT language=JAVASCRIPT>\n";
print "function SelectADGroup(formname)\n";
print "{\n";
print " var group=formname.addgroupname.value; \n";
print " var getgroup=formname.getgroup.value; \n";
print " var str=\"main.php?show=exe&ldapgroup=\"+group+\"&getgroup=\"+getgroup+\"&function=addusersfromadldform&filename=authadldbuttom_2_usersadd.php\"; \n";
print " parent.basefrm.location.href=str;\n";
print "}\n";
print "function EnableTxtInput(formname)\n";
print "{\n";
print " value=document.forms[\"AddDomainUsers\"].elements[\"addgroupname\"].value;\n";
print " if(value==\"_gettxtinput_\") \n";
print " {\n";
print " document.forms[\"AddDomainUsers\"].elements[\"getgroup\"].disabled=false\n";
print " }\n";
print " else \n";
print " {\n";
print " document.forms[\"AddDomainUsers\"].elements[\"getgroup\"].disabled=true\n";
print " }\n";
print "}\n";
print "</SCRIPT> \n";
print "<TABLE WIDTH=90%>\n";
print "<TR><TD WIDTH=40%>{$usersbuttom_1_adldap_AddUsersFromAdLDAPForm_1}</TD>\n";
print "<TD WIDTH=60%><SELECT NAME=\"addgroupname\" onChange=EnableTxtInput(AddDomainUsers)>\n";
print "<OPTION VALUE=\"_allgroups_\" SELECT onselect=EnableTxtInput(AddDomainUsers)> {$usersbuttom_1_adldap_AddUsersFromAdLDAPForm_5}";
print "<OPTION VALUE=\"_gettxtinput_\" onselect=EnableTxtInput(AddDomainUsers)> {$usersbuttom_1_adldap_AddUsersFromAdLDAPForm_6}";
foreach ($groupinfo as $group) {
$groupname = UTF8ToSAMSLang($group);
print "<OPTION VALUE=\"{$groupname}\" onselect=EnableTxtInput(AddDomainUsers)> {$groupname}";
}
/*
for($i=0;$i<$gcount;$i++)
{
$groupname = UTF8ToSAMSLang($groupinfo[$i]);
print("<OPTION VALUE=\"$groupname\" onselect=EnableTxtInput(AddDomainUsers)> $groupname");
}
*/
print "</SELECT>\n";
print "<TR><TD WIDTH=40%>{$usersbuttom_1_adldap_AddUsersFromAdLDAPForm_7}\n";
print "<TD WIDTH=60%><INPUT TYPE=\"TEST\" NAME=\"getgroup\" SIZE=\"20\" DISABLED>\n";
print "</TABLE>\n";
print "<INPUT TYPE=\"BUTTON\" value=\"{$usersbuttom_1_adldap_AddUsersFromAdLDAPForm_2}\" onclick=SelectADGroup(AddDomainUsers)>\n";
print "<P>\n";
/* */
if (strlen($ldapgroup) > 0 && $ldapgroup != "_allgroups_" && $ldapgroup != "_gettxtinput_") {
printf("<B>{$usersbuttom_1_adldap_AddUsersFromAdLDAPForm_4}: <FONT COLOR=BLUE>{$ldapgroup}</FONT></B><BR>");
} else {
if (strlen($ldapgroup) > 0 && $ldapgroup == "_gettxtinput_") {
printf("<B>{$usersbuttom_1_adldap_AddUsersFromAdLDAPForm_4}: <FONT COLOR=BLUE>{$getgroup}</FONT></B><BR>");
} else {
print "<BR><B>{$usersbuttom_1_domain_AddUsersFromDomainForm_2}</B><BR>";
}
}
print "<SELECT NAME=\"username[]\" MULTIPLE>\n";
asort($a);
foreach ($a as $user) {
$samaccountname = UTF8ToSAMSLang($user["samaccountname"]);
$num_rows = $DB->samsdb_query_value("SELECT * FROM squiduser WHERE s_nick='{$samaccountname}'");
if ($num_rows == 0) {
$displayname = UTF8ToSAMSLang($user["displayname"]);
$memberof = UTF8ToSAMSLang($user["memberof"]);
$adldgroups = explode("|", $memberof);
$cadldgroups = count($adldgroups);
$memberofgroup = "Users";
for ($j = 0; $j < $cadldgroups; $j++) {
$adldgroupname = explode("=", $adldgroups[$j]);
if (strlen($adldgroupname[1]) > 3) {
$memberofgroup = $memberofgroup . "|" . substr($adldgroupname[1], 0, strlen($adldgroupname[1]) - 3);
}
}
if (strstr($memberofgroup, $usersgroupname)) {
print "<OPTION VALUE=\"{$samaccountname}\"> {$samaccountname} ({$displayname})\n";
}
}
$DB->free_samsdb_query();
}
print "</SELECT>\n";
print "<P>";
print "<P>";
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=\"addusersfromadldap\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"filename\" id=filename value=\"authadldbuttom_2_usersadd.php\">\n";
print "<SCRIPT LANGUAGE=JAVASCRIPT> \n";
print "function EnterNewGroupName(formname) \n";
print "{ \n";
print " var groupname=formname.groupname.value; \n";
print " if(groupname==\"-1\") \n";
print " {\n";
print " formname.newgroupname.disabled=false; \n";
print " }\n";
print " else \n";
print " {\n";
print " formname.newgroupname.disabled=true; \n";
print " }\n";
print "}\n";
print "</SCRIPT> \n";
print "<TABLE>\n";
print "<TR><TD><P>\n";
print "<TR><TD>\n";
print "<B>{$usersbuttom_1_domain_AddUsersFromDomainForm_7}\n";
print "<TD>\n";
print "<INPUT TYPE=\"TEXT\" NAME=\"domainname\" id=Show VALUE=\"{$basedn}\">\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 onchange=EnterNewGroupName(AddDomainUsers)>\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']} ";
}
print "<OPTION VALUE=\"-1\"> {$usersbuttom_1_domain_AddUsersFromDomainForm_8} ";
print "</SELECT>\n";
print "<TR><TD ALIGN=RIGHT>\n";
print "{$usersbuttom_1_domain_AddUsersFromDomainForm_9}: \n";
print "<TD>\n";
print "<INPUT TYPE=\"TEXT\" NAME=\"newgroupname\" id=Newgroupname\" DISABLED>\n";
$DB->free_samsdb_query();
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']}";
}
$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 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 ShablonUsers()
{
global $SAMSConf;
global $SHABLONConf;
global $USERConf;
$DB = new SAMSDB();
$lang = "./lang/lang.{$SAMSConf->LANG}";
require $lang;
if (isset($_GET["id"])) {
$id = $_GET["id"];
}
if (isset($_GET["sid"])) {
$sid = $_GET["sid"];
}
if ($USERConf->ToWebInterfaceAccess("C") != 1) {
exit;
}
PageTop("shablon.jpg", "{$shablon_1}<BR>{$shablontray_ShablonUsers_1} <FONT COLOR=\"BLUE\">{$SHABLONConf->s_name}</FONT>");
print "<IMG SRC=\"{$SAMSConf->ICONSET}/help.jpg\">";
print "<A HREF=\"http://sams.perm.ru/sams2/doc/" . $SAMSConf->LANG . "/templates.html\">{$documentation}</A>";
print "<P>\n";
print "<TABLE>\n";
print "<TR><TD><B>{$shablonbuttom_1_prop_UpdateShablonForm_19}</B><TD><FONT COLOR=\"BLUE\">{$SHABLONConf->s_auth}</FONT>\n";
print "<TR><TD><B>{$shablonbuttom_1_prop_UpdateShablonForm_4}</B><TD><FONT COLOR=\"BLUE\">{$SHABLONConf->s_quote}</FONT>\n";
if ($SHABLONConf->s_quote == 0) {
print " <FONT COLOR=\"BLUE\">(unlimited traffic)</FONT>";
}
print "<TR><TD><B>{$shablonbuttom_1_prop_UpdateShablonForm_20}</B><TD>";
if ($SHABLONConf->s_period == "M") {
print "<FONT COLOR=\"BLUE\">{$shablonbuttom_1_prop_UpdateShablonForm_24}</FONT>\n";
} else {
if ($SHABLONConf->s_period == "W") {
print "<FONT COLOR=\"BLUE\">{$shablonbuttom_1_prop_UpdateShablonForm_25}</FONT>\n";
} else {
if ($SHABLONConf->s_period == "D") {
print "<FONT COLOR=\"BLUE\">{$shablonbuttom_1_prop_UpdateShablonForm_27}</FONT>\n";
} else {
print "<FONT COLOR=\"BLUE\">{$SHABLONConf->s_period} {$shablonbuttom_1_prop_UpdateShablonForm_17}</FONT>\n";
print "<TR><TD>{$shablonbuttom_1_prop_UpdateShablonForm_18}:<TD><FONT COLOR=\"BLUE\">{$SHABLONConf->s_clrdate}</FONT>";
}
}
}
$second_template = "NONE";
print "<TR><TD><B>{$AddTRangeForm_trangetray_1}: </B>\n";
$num_rows = $DB->samsdb_query_value("SELECT sconfig_time.*, timerange.s_name, timerange.s_timestart, s_timeend FROM sconfig_time LEFT JOIN timerange ON sconfig_time.s_trange_id=timerange.s_trange_id WHERE sconfig_time.s_shablon_id='{$id}' ");
if ($num_rows > 0) {
while ($row = $DB->samsdb_fetch_array()) {
print "<TR><TD><TD ALIGN=\"RIGHT\" > <FONT COLOR=\"BLUE\"><B>{$row['s_name']}</B> ({$row['s_timestart']} - {$row['s_timeend']} ) ";
}
}
$DB->free_samsdb_query();
if ($SHABLONConf->s_shablon_id2 != -1) {
$num_rows = $DB->samsdb_query_value("SELECT * FROM shablon WHERE s_shablon_id='{$SHABLONConf->s_shablon_id2}'");
if ($row = $DB->samsdb_fetch_array()) {
$second_template = $row["s_name"];
}
}
print "<TR><TD><B>{$shablonbuttom_1_prop_UpdateShablonForm_28} </B><TD><FONT COLOR=\"BLUE\">{$second_template}\n";
print "<TR><TD><B>Delay pool </B>\n";
$QUERY = "SELECT d_link_s.s_pool_id as delaypoolid, d_link_s.s_shablon_id as shablonid,shablon.s_name, delaypool.s_name as delaypoolname FROM d_link_s LEFT JOIN shablon ON d_link_s.s_shablon_id=shablon.s_shablon_id LEFT JOIN delaypool ON d_link_s.s_pool_id=delaypool.s_pool_id WHERE shablon.s_shablon_id='{$id}'";
$num_rows = $DB->samsdb_query_value($QUERY);
if ($num_rows > 0) {
$row = $DB->samsdb_fetch_array();
print "<TD><FONT COLOR=\"BLUE\">{$row['delaypoolname']}\n";
}
$DB->free_samsdb_query();
print "<TR>\n";
print "</TABLE>\n";
$num_rows = $DB->samsdb_query_value("SELECT * FROM squiduser WHERE squiduser.s_shablon_id='{$id}' ORDER BY s_nick");
print "<H2>{$shablontray_ShablonUsers_4}: </H2>\n";
print "<TABLE>\n";
while ($row = $DB->samsdb_fetch_array()) {
print "<TR>\n";
print "<TD>";
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 = "puser.gif";
} 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";
}
print "<IMG SRC=\"{$SAMSConf->ICONSET}/{$gif}\" TITLE=\"\"> ";
print "<TD> <B>{$row['s_nick']} </B>";
print "<TD> {$row['s_family']} ";
print "<TD> {$row['s_name']} ";
print "<TD> {$row['s_soname']} ";
}
$DB->free_samsdb_query();
print "</TABLE>\n";
if ($USERConf->ToWebInterfaceAccess("C") == 1) {
print "<SCRIPT language=JAVASCRIPT>\n";
print "function SelectUsers(id)\n";
print "{\n";
print " var shablon = \"main.php?show=exe&filename=shablontray.php&function=shablonusers&id={$SHABLONConf->s_shablon_id}&sid=\" + id ; \n";
print " parent.basefrm.location.href=shablon;\n";
print "}\n";
print "</SCRIPT>\n";
print "<P><BR><B>{$shablontray_ShablonUsers_2} {$SHABLONConf->s_name}:</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=\"shablontray.php\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"function\" value=\"moveuserstoshablon\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"id\" value=\"{$SHABLONConf->s_shablon_id}\">\n";
print "<SELECT NAME=\"shablonid\" onchange=SelectUsers(moveform.shablonid.value)>\n";
$num_rows = $DB->samsdb_query_value("SELECT * FROM shablon WHERE s_shablon_id!='{$SHABLONConf->s_shablon_id}' ORDER BY s_name");
if ($sid == "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_shablon_id'] == $sid) {
$SECTED = "SELECTED";
}
print "<OPTION VALUE=\"{$row['s_shablon_id']}\" {$SECTED}> {$row['s_name']} \n";
}
print "</SELECT>\n";
$DB->free_samsdb_query();
//echo "<BR>SELECT * FROM squiduser WHERE s_shablon_id='$sid'&&s_shablon_id!='$id' ORDER BY s_nick<BR>";
print "<SELECT NAME=\"username[]\" SIZE=10 MULTIPLE >\n";
if ($sid == "ALL") {
$num_rows = $DB->samsdb_query_value("SELECT squiduser.s_user_id,squiduser.s_nick,squiduser.s_quote,shablon.s_quote as def_quote FROM squiduser LEFT JOIN shablon ON squiduser.s_shablon_id=shablon.s_shablon_id WHERE shablon.s_shablon_id!='{$id}' ORDER BY s_nick");
} else {
$num_rows = $DB->samsdb_query_value("SELECT squiduser.s_user_id,squiduser.s_nick,squiduser.s_quote,shablon.s_quote as def_quote FROM squiduser LEFT JOIN shablon ON squiduser.s_shablon_id=shablon.s_shablon_id WHERE shablon.s_shablon_id='{$sid}' ORDER BY s_nick");
}
while ($row = $DB->samsdb_fetch_array()) {
print "<OPTION ID=\"{$row['s_user_id']}\" VALUE={$row['s_user_id']}+{$row['s_quote']}+{$row['def_quote']}+{$SHABLONConf->s_quote}> {$row['s_nick']}\n";
}
print "</SELECT>\n";
print "<P> <INPUT TYPE=\"SUBMIT\" VALUE=\"{$shablontray_ShablonUsers_3} '{$SHABLONConf->s_name}'\" \n> ";
print "</FORM>\n";
}
}
function RedirListForm()
{
global $SAMSConf;
global $USERConf;
$DB = new SAMSDB();
$lang = "./lang/lang.{$SAMSConf->LANG}";
require $lang;
if (isset($_GET["id"])) {
$id = $_GET["id"];
}
$count = 0;
if ($USERConf->ToWebInterfaceAccess("LC") != 1) {
exit;
}
$num_rows = $DB->samsdb_query_value("SELECT * FROM redirect WHERE s_redirect_id='{$id}' ");
$row = $DB->samsdb_fetch_array();
$show1 = $row['s_type'];
$nick1 = $row['s_name'];
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'] == "files") {
$type = " {$filedeniedlisttray_filedeniedlisttray_1}";
}
if ($row['s_type'] == "local") {
$type = " {$redirlisttray_RedirListTray_2}";
}
if ($row['s_type'] == "regex") {
$type = " {$regexlisttray_regexlisttray_1}";
}
PageTop("redirect_48.jpg", "{$type} <FONT COLOR=\"BLUE\">{$row['s_name']}</FONT>");
print "<IMG SRC=\"{$SAMSConf->ICONSET}/help.jpg\">";
print "<A HREF=\"http://sams.perm.ru/sams2/doc/" . $SAMSConf->LANG . "/accesslists.html#fileext\">{$documentation}</A>";
print "<P>\n";
print "<FORM NAME=\"destination\" ACTION=\"main.php\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"show\" id=Show value=\"exe\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"function\" id=function value=\"savedestination\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"filename\" id=filename value=\"redirlisttray.php\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"row_id\" VALUE=\"{$id}\"> \n";
if ($row['s_type'] == "replace") {
print "<INPUT TYPE=\"HIDDEN\" NAME=\"type\" VALUE=\"replace\"> \n";
print "Substitute destination <INPUT TYPE=\"TEXT\" NAME=\"dest\" SIZE=50 VALUE=\"{$row['s_dest']}\"> </INPUT>";
print "<INPUT TYPE=\"SUBMIT\" value=\"Save\">\n";
print "<BR>";
}
print "</FORM>";
$DB->free_samsdb_query();
print "<BR>\n";
print "<FORM NAME=\"table\" ACTION=\"main.php\">\n";
print "<SELECT NAME=\"delete\" ID=\"deleteurl\" SIZE=10 TABINDEX=20 ";
print "STYLE=\"font-size:10pt\">\n";
$num_rows = $DB->samsdb_query_value("SELECT s_url FROM url WHERE s_redirect_id='{$id}' ORDER BY s_url");
while ($row = $DB->samsdb_fetch_array()) {
$count++;
$string = $row['s_url'];
$string2 = EkranChars($string);
print "<OPTION VALUE={$string} onclick=EditURL(\"{$string2}\")> {$string}\n";
}
print "</SELECT>\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"show\" id=Show value=\"exe\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"function\" id=function value=\"deleteurlfromlist\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"filename\" id=filename value=\"redirlisttray.php\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"type\" VALUE=\"{$id}\"> \n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"deletedurl\" VALUE=\"\"> \n";
print "</BR>\n";
print "\n";
print "<INPUT TYPE=\"BUTTON\" value=\"{$redirlisttray_RedirListForm_1}\" OnClick=DeleteURL(table)>\n";
print "</FORM>\n";
print "<script language=JAVASCRIPT>\n";
print "function AppendURLString(s)\n";
print "{\n";
print " var res=\"\";\n";
print " for (var i=0; i <= s.length; i++)\n";
print " {\n";
print " var letter =s.substr(i,1);\n";
print " if ( letter == \"\\\\\" ) \n";
print " { res = res + letter }\n";
print " res = res + letter \n";
print " } \n";
print " return res\n";
print "}\n";
print "function AddURL(formname)\n";
print "{\n";
print " var s=formname.addurl.value;\n";
print " var res=AppendURLString(s);\n";
print " document.forms[\"ADDURL\"].elements[\"addurl\"].value=res;\n";
print " document.forms[\"ADDURL\"].submit();\n";
print "}\n";
print "function DeleteURL(formname)\n";
print "{\n";
print " var s=formname.deleteurl.value;\n";
print " var res=AppendURLString(s);\n";
print " document.forms[\"table\"].elements[\"deletedurl\"].value=res;\n";
print " document.forms[\"table\"].submit();\n";
print "}\n";
print "function ChangeURL(formname)\n";
print "{\n";
print " var s=formname.editurlstr.value;\n";
print " var res=AppendURLString(s);\n";
print " document.forms[\"EDITURL\"].elements[\"editurl\"].value=res;\n";
print " document.forms[\"EDITURL\"].submit();\n";
print "}\n";
print "function EditURL(URL)\n";
print "{\n";
print " document.forms[\"EDITURL\"].elements[\"editurlstr\"].value=URL;\n";
print " var res=AppendURLString(URL);\n";
print " document.forms[\"EDITURL\"].elements[\"oldvalue\"].value=res;\n";
print "}\n";
print "function SaveDestination(formname)\n";
print "{\n";
//print(" var s=formname.deleteurl.value;\n");
//print(" var res=AppendURLString(s);\n");
//print(" document.forms[\"table\"].elements[\"deletedurl\"].value=res;\n");
//print(" document.forms[\"table\"].submit();\n");
print "}\n";
print "</script>\n";
print "<P>\n";
print "<FORM NAME=\"EDITURL\" ACTION=\"main.php\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"show\" id=Show value=\"exe\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"function\" id=function value=\"editurlfromlist\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"filename\" id=filename value=\"redirlisttray.php\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"type\" VALUE=\"{$id}\"> \n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"oldvalue\" VALUE=\"\"> \n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"editurl\" VALUE=\"\"> \n";
print "<INPUT TYPE=\"TEXT\" NAME=\"editurlstr\" SIZE=30> \n";
print "<INPUT TYPE=\"BUTTON\" value=\"Change\" OnClick=ChangeURL(EDITURL)>\n";
print "</FORM>\n";
print "<P><BR>\n";
print "<FORM NAME=\"ADDURL\" ACTION=\"main.php\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"show\" id=Show value=\"exe\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"function\" id=function value=\"addurlfromlist\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"filename\" id=filename value=\"redirlisttray.php\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"id\" VALUE=\"{$id}\"> \n";
print "<INPUT TYPE=\"TEXT\" NAME=\"addurl\" SIZE=30> \n";
print "<INPUT TYPE=\"BUTTON\" value=\"{$redirlisttray_RedirListForm_2}\" OnClick=AddURL(ADDURL)>\n";
print "</FORM>\n";
print "<P>\n";
print "<FORM NAME=\"CLEARLIST\" ACTION=\"main.php\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"show\" id=Show value=\"exe\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"function\" id=function value=\"deleteallurlfromlist\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"filename\" id=filename value=\"redirlisttray.php\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"type\" VALUE=\"{$id}\"> \n";
print "<INPUT TYPE=\"SUBMIT\" value=\"{$redirlisttray_RedirListForm_3}\">\n";
print "</FORM>\n";
}
function sams_admin_authentication($username, $passwd)
{
global $SAMSConf;
global $DATE;
$DB = new SAMSDB();
$time = time();
$num_rows = $DB->samsdb_query_value("SELECT * FROM passwd WHERE s_user='******' ");
if ($num_rows == 0) {
$SAMSConf->AddLog("webinterface", "user {$username} authentication error", $DATE->today, $DATE->thistime);
echo "<H2><FONT COLOR=\"RED\">Authorisation ERROR</FONT></H2>";
exit;
}
$row = $DB->samsdb_fetch_array();
$autherrorc = $row['s_autherrorc'];
$autherrort = $row['s_autherrort'];
$admname = $row['s_user'];
$admpasswd = $row['s_pass'];
$DB->free_samsdb_query();
if ($autherrorc == 0 || $time > $autherrort + 60) {
if ($time > $autherrort + 60) {
$newpasswd = crypt("{$passwd}", "00");
if ($admpasswd == $newpasswd) {
$SAMSConf->adminname = $username;
if ($autherror > 0) {
$DB->samsdb_query("UPDATE passwd SET s_autherrorc='0',s_autherrort='0' WHERE s_user='******' ");
}
if ($username == "Admin" || $username == "admin") {
setcookie("samsadmin", "1");
}
if ($username == "Auditor" || $username == "auditor") {
setcookie("samsadmin", "2");
}
setcookie("user", "{$username}");
setcookie("passwd", "{$newpasswd}");
} else {
$SAMSConf->AddLog("webinterface", "user {$username} authentication error", $DATE->today, $DATE->thistime);
echo "<H2><FONT COLOR=\"RED\">Authorisation ERROR</FONT></H2>";
if ($autherrorc >= 2) {
$DB->samsdb_query("UPDATE passwd SET s_autherrorc='0',s_autherrort='{$time}' WHERE s_user='******' ");
print "<h2>next logon after 60 second</h2> \n";
} else {
$DB->samsdb_query("UPDATE passwd SET s_autherrorc=s_autherrorc+1,s_autherrort='0' WHERE s_user='******' ");
}
exit;
}
} else {
$SAMSConf->AddLog("webinterface", "user {$username} authentication error", $DATE->today, $DATE->thistime);
print "<h1><FONT COLOR=\"RED\">Authentication ERROR</FONT></h1> \n";
$time2 = 60 - ($time - $autherrort);
print "<h2>next logon after {$time2} second</h2> \n";
exit(0);
$user = "";
$function = "autherror";
}
}
}
