Subversion Repositories ALCASAR

Compare Revisions

Ignore whitespace Rev 1830 → Rev 1831

/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";
 
?>