152,61 → 152,64 |
{ |
$tligne = split(" ",$ligne); |
$login = str_replace("%0D","",str_replace("%0A","",urlencode ($tligne[0]))); |
$password = GenPassword(); |
$passwd = da_encrypt($password); |
$passwd = da_sql_escape_string($passwd); |
if ($login != '') |
{ |
$password = GenPassword(); |
$passwd = da_encrypt($password); |
$passwd = da_sql_escape_string($passwd); |
/* insertion (login + password) dans la table "radcheck" (si l'usager existe --> changement de mot de passe) */ |
$res = @da_sql_query($link,$config,"INSERT INTO $config[sql_check_table] (attribute,value,username $text) VALUES ('$config[sql_password_attribute]','$passwd','$login' $passwd_op);"); |
if (!$res || !@da_sql_affected_rows($link,$res,$config)) |
{ |
echo "<b>Unable to add user $login: " . da_sql_error($link,$config) . "</b><br>\n"; |
$da_abort=1; |
} |
else |
{ |
creatlog ($login,$password,$service,$RS_out); |
/*echo $login." : ".$password." , ";*/ |
} |
/* insertion de l'usager dans la table "userinfo" */ |
if ($config[sql_use_user_info_table] == 'true' && !$da_abort) |
{ |
$res = @da_sql_query($link,$config, "SELECT username FROM $config[sql_user_info_table] WHERE username = '$login';"); |
if ($res) |
{ |
if (!@da_sql_num_rows($res,$config)) |
$res = @da_sql_query($link,$config,"INSERT INTO $config[sql_check_table] (attribute,value,username $text) VALUES ('$config[sql_password_attribute]','$passwd','$login' $passwd_op);"); |
if (!$res || !@da_sql_affected_rows($link,$res,$config)) |
{ |
$res = @da_sql_query($link,$config,"INSERT INTO $config[sql_user_info_table] (username,department) VALUES ('$login','$service');"); |
if (!$res || !@da_sql_affected_rows($link,$res,$config)) |
echo "<b>Could not add user information in user info table: " . da_sql_error($link,$config) . "</b><br>\n"; |
echo "<b>Unable to add user $login: " . da_sql_error($link,$config) . "</b><br>\n"; |
$da_abort=1; |
} |
else |
echo "<b>User already exists in user info table.</b><br>\n"; |
} |
else |
echo "<b>Could not add user information in user info table: " . da_sql_error($link,$config) . "</b><br>\n"; |
if ($group != '') |
{ |
$group = da_sql_escape_string($group); |
$res = @da_sql_query($link,$config,"SELECT username FROM $config[sql_usergroup_table] WHERE username = '$login' AND groupname = '$group';"); |
if ($res) |
creatlog ($login,$password,$service,$RS_out); |
/*echo $login." : ".$password." , ";*/ |
} |
/* insertion de l'usager dans la table "userinfo" */ |
if ($config[sql_use_user_info_table] == 'true' && !$da_abort) |
{ |
$res = @da_sql_query($link,$config, "SELECT username FROM $config[sql_user_info_table] WHERE username = '$login';"); |
if ($res) |
{ |
if (!@da_sql_num_rows($res,$config)) |
{ |
if (!@da_sql_num_rows($res,$config)) |
$res = @da_sql_query($link,$config,"INSERT INTO $config[sql_user_info_table] (username,department) VALUES ('$login','$service');"); |
if (!$res || !@da_sql_affected_rows($link,$res,$config)) |
echo "<b>Could not add user information in user info table: " . da_sql_error($link,$config) . "</b><br>\n"; |
} |
else |
echo "<b>User already exists in user info table.</b><br>\n"; |
} |
else |
echo "<b>Could not add user information in user info table: " . da_sql_error($link,$config) . "</b><br>\n"; |
if ($group != '') |
{ |
$group = da_sql_escape_string($group); |
$res = @da_sql_query($link,$config,"SELECT username FROM $config[sql_usergroup_table] WHERE username = '$login' AND groupname = '$group';"); |
if ($res) |
{ |
$res = @da_sql_query($link,$config,"INSERT INTO $config[sql_usergroup_table] (username,groupname) VALUES ('$login','$group');"); |
if (!$res || !@da_sql_affected_rows($link,$res,$config)) |
echo "<b>Could not add user to group $group. SQL Error</b><br>\n"; |
} # end if |
if (!@da_sql_num_rows($res,$config)) |
{ |
$res = @da_sql_query($link,$config,"INSERT INTO $config[sql_usergroup_table] (username,groupname) VALUES ('$login','$group');"); |
if (!$res || !@da_sql_affected_rows($link,$res,$config)) |
echo "<b>Could not add user to group $group. SQL Error</b><br>\n"; |
} # end if |
else |
echo "<b>User already is a member of group $group</b><br>\n"; |
} # end if |
else |
echo "<b>User already is a member of group $group</b><br>\n"; |
} # end if |
else |
echo "<b>Could not add user to group $group: " . da_sql_error($link,$config) . "</b><br>\n"; |
} # end if ($group) |
} # end if ($config) |
} # end foreach |
echo "<b>Could not add user to group $group: " . da_sql_error($link,$config) . "</b><br>\n"; |
} # end if ($group) |
} # end if ($config) |
} # end if ($login !='') |
} # end foreach |
fclose($RS_out); |
} |
} # end if (is_file ... |
} # end if (is file) |
} # end if (link) |
} |
} |
else if ($choix == "bdd") |