nilsteampassnet / TeamPass

                }

            } elseif ($_POST['allowed'] == 0) {

                //case where folder was not allowed but allowed now

                foreach ($tree as $node) {

                    //Store in DB

                    DB::insert(

                        prefix_table("roles_values"),

                        array(

                            'folder_id' => $node->id,

                            'role_id' => $_POST['role']

                        )

                    );

                }

            }

            break;

                    WHERE folder_id = %i",

                    $nodeInfo->id

                );

                foreach ($rows as $record) {

                    //add access to this subfolder

                    DB::insert(

                        prefix_table("roles_values"),

                        array(

                            'role_id' => $record['role_id'],

                            'folder_id' => $newFolderId,

                            'type' => $record['type']

                        )

                    );

                }

                // if parent folder has Custom Fields Categories then add to this child one too

                $rows = DB::query("SELECT id_category FROM ".prefix_table("categories_folders")." WHERE id_folder = %i", $nodeInfo->id);

                    //If it is a subfolder, then give access to it for all roles that allows the parent folder

                    $rows = DB::query("SELECT role_id, type FROM ".prefix_table("roles_values")." WHERE folder_id = %i", $parentId);

                    foreach ($rows as $record) {

                        //add access to this subfolder

                        DB::insert(

                            prefix_table("roles_values"),

                            array(

                                'role_id' => $record['role_id'],

                                'folder_id' => $newId,

                                'type' => $record['type']

                            )

                        );

                    }

                    // if parent folder has Custom Fields Categories then add to this child one too

                    $rows = DB::query("SELECT id_category FROM ".prefix_table("categories_folders")." WHERE id_folder = %i", $parentId);

                        );

                        //For each role to which the user depends on, add the folder just created.

                        foreach ($_SESSION['arr_roles'] as $role) {

                            DB::insert(

                                prefix_table("roles_values"),

                                array(

                                    'role_id' => $role['id'],

                                    'folder_id' => $id,

                                    'type' => "W"

                                )

                            );

                        }

                        //Add this new folder to the list of visible folders for the user.

                        array_push($_SESSION['groupes_visibles'], $id);