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