Subversion Repositories ALCASAR

Rev

Rev 1831 | Blame | Compare with Previous | Last modification | View Log

<?php
if (is_file("../lib/sql/drivers/$config[sql_type]/functions.php"))
        include_once("../lib/sql/drivers/$config[sql_type]/functions.php");
else{
        echo "<b>Could not include SQL library</b><br>\n";
        exit();
}
$link = da_sql_pconnect($config);
if ($link){
        if (isset($member_groups) && isset($edited_groups)){
                $del_groups = array_diff($member_groups,$edited_groups);
                if (isset($del_groups)){
                        foreach ($del_groups as $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)
                                        echo "<b>Could not delete user $login from group $del: " . da_sql_error($link,$config) . "</b><br>\n";
                                else
                                        echo "<b>User $login deleted from group $del</b><br>\n";
                        }
                }
                $new_groups = array_diff($edited_groups,$member_groups);
                if (isset($new_groups)){
                        foreach($new_groups as $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');");
                                if (!$res)
                                        echo "<b>Error while adding user $login to group $login: " . da_sql_error($link,$config) . "</b><br>\n";
                                else
                                        echo "<b>User $login added to group $new</b><br>\n";
                        }
                }
        }
        //si l'utilisateur n'appartient a aucun groupe. 
        if (!isset($member_groups) && isset($edited_groups)){
                $new = $edited_groups[0];
                $new = da_sql_escape_string($link,$new);
                $res = da_sql_query($link,$config,
                "INSERT INTO $config[sql_usergroup_table] (groupname,username)
                VALUES ('$new','$login');");
                if (!$res)
                        echo "<b>Error while adding user $login to group $login: " . da_sql_error($link,$config) . "</b><br>\n";
                else
                        echo "<b>User $login added to group $new</b><br>\n";
        }
}
else
        echo "<b>Could not connect to SQL database</b><br>\n";
?>