/web/acc/manager/lib/sql/change_passwd.php |
---|
20,7 → 20,7 |
if (is_file("../lib/crypt/$config[general_encryption_method].php")){ |
include("../lib/crypt/$config[general_encryption_method].php"); |
$passwd = da_encrypt($passwd); |
$passwd = da_sql_escape_string($passwd); |
$passwd = da_sql_escape_string($link,$passwd); |
$res = da_sql_query($link,$config, |
"SELECT value FROM $config[sql_check_table] WHERE username = '$login' |
AND attribute = '$config[sql_password_attribute]';"); |
/web/acc/manager/lib/sql/defaults.php |
---|
1,6 → 1,7 |
<?php |
require('../lib/sql/attrmap.php'); |
if ((isset($login) && $login != '') && (isset($user_type) && $user_type !== 'group')){ |
if (is_file("../lib/sql/drivers/$config[sql_type]/functions.php")) |
include_once("../lib/sql/drivers/$config[sql_type]/functions.php"); |
else{ |
66,7 → 67,10 |
$tmp["$attr"]['operator'][]="$oper"; |
} |
$tmp["$attr"][] = "$val"; |
$tmp["$attr"]['count']++; |
if(isset($tmp["$attr"]['count'])) |
{ |
$tmp["$attr"]['count']++; |
} |
} |
} |
else |
124,11 → 128,23 |
unset($member_groups); |
$link = da_sql_pconnect($config); |
if ($link){ |
$res = da_sql_query($link,$config, |
"SELECT DISTINCT groupname FROM $config[sql_usergroup_table];"); |
if(isset($login) && $login != '') |
{ |
#affiche le groupe appartenant à l'utilisateur |
$res = da_sql_query($link,$config, |
"SELECT DISTINCT groupname FROM $config[sql_usergroup_table] WHERE username = '$login';"); |
} |
else |
{ |
#affiche la liste de groupe disponible (dans le cas de la creation d'un utilisateur) |
$res = da_sql_query($link,$config, |
"SELECT DISTINCT groupname FROM $config[sql_usergroup_table] ;"); |
} |
if ($res){ |
while(($row = da_sql_fetch_array($res,$config))) |
while(($row = da_sql_fetch_array($res,$config))){ |
$member_groups[] = $row['groupname']; |
} |
} |
else |
echo "<b>Database query failed: " . da_sql_error($link,$config) . "</b><br>\n"; |
/web/acc/manager/lib/sql/drivers/mysql/functions.php |
---|
120,7 → 120,7 |
function da_sql_num_fields($fields,$config) |
{ |
return mysqli_num_fields($fields); |
return mysqli_num_fields($fields); |
} |
function da_sql_field_name($fields,$num,$config) |
/web/acc/manager/lib/sql/group_change.php |
---|
11,7 → 11,7 |
$del_groups = array_diff($member_groups,$edited_groups); |
if (isset($del_groups)){ |
foreach ($del_groups as $del){ |
$del = da_sql_escape_string($del); |
$del = da_sql_escape_string($link,$del); |
$res = da_sql_query($link,$config, |
"DELETE FROM $config[sql_usergroup_table] WHERE username = '$login' AND groupname = '$del';"); |
if (!$res) |
23,7 → 23,7 |
$new_groups = array_diff($edited_groups,$member_groups); |
if (isset($new_groups)){ |
foreach($new_groups as $new){ |
$new = da_sql_escape_string($new); |
$new = da_sql_escape_string($link,$new); |
$res = da_sql_query($link,$config, |
"INSERT INTO $config[sql_usergroup_table] (groupname,username) |
VALUES ('$new','$login');"); |
/web/acc/manager/lib/sql/nas_list.php |
---|
5,7 → 5,7 |
unset($da_name_cache); |
if (isset($_SESSION['da_name_cache'])) |
$da_name_cache = $_SESSION['da_name_cache']; |
if ($config[sql_nas_table] != ''){ |
if ($config['sql_nas_table'] != ''){ |
if (is_file("../lib/sql/drivers/$config[sql_type]/functions.php")) |
include_once("../lib/sql/drivers/$config[sql_type]/functions.php"); |
17,7 → 17,7 |
if ($link){ |
$auth_user = $_SERVER["PHP_AUTH_USER"]; |
$extra = ''; |
if (isset($mappings[$auth_user][nasdb])){ |
if (isset($mappings[$auth_user]['nasdb'])){ |
$NAS_ARR = array(); |
$NAS_ARR = preg_split('/,/',$mappings[$auth_user][nasdb]); |
$extra = 'WHERE nasname IN ('; |
/web/acc/manager/lib/sql/user_info.php |
---|
99,7 → 99,9 |
foreach(array_keys($tmp) as $val){ |
if ($val == '') |
continue; |
if(isset($rev_attrmap["$val"])) $key = $rev_attrmap["$val"]; |
if(isset($rev_attrmap["$val"])) { |
$key = $rev_attrmap["$val"]; |
} |
if ($key == ''){ |
$key = $val; |
$attrmap["$key"] = $val; |
119,4 → 121,5 |
} |
else |
echo "<b>Could not connect to SQL database</b><br>\n"; |
?> |