PHP ctrl_groups::DeleteGroupModulePermissions Examples

Example #1

File: controller.ext.php Project: bbspike/sentora-core

 static function doEditModule()
 {
     global $zdbh;
     global $controller;
     $currentuser = ctrl_users::GetUserDetail();
     $sql = "SELECT COUNT(*) FROM x_modules";
     if ($numrows = $zdbh->query($sql)) {
         if ($numrows->fetchColumn() != 0) {
             $sql = $zdbh->prepare("SELECT * FROM x_modules WHERE mo_type_en <> 'system' ORDER BY mo_name_vc ASC");
             $sql->execute();
             while ($rowmodule = $sql->fetch()) {
                 $groupssql = $zdbh->query("SELECT * FROM x_groups ORDER BY ug_name_vc ASC");
                 while ($groups = $groupssql->fetch()) {
                     if (isset($_POST['inEnable_' . $groups['ug_id_pk'] . '_' . $rowmodule['mo_id_pk'] . ''])) {
                         ctrl_groups::AddGroupModulePermissions($groups['ug_id_pk'], $rowmodule['mo_id_pk']);
                     } else {
                         ctrl_groups::DeleteGroupModulePermissions($groups['ug_id_pk'], $rowmodule['mo_id_pk']);
                     }
                 }
                 $sql2 = $zdbh->prepare("UPDATE x_modules SET mo_enabled_en = :enabled, mo_category_fk = :category WHERE mo_id_pk = :moduleid");
                 $disable = $controller->GetControllerRequest('FORM', 'inDisable_' . $rowmodule['mo_id_pk'] . '');
                 $category = $controller->GetControllerRequest('FORM', 'inCategory_' . $rowmodule['mo_id_pk'] . '');
                 $sql2->bindParam(':enabled', $disable);
                 $sql2->bindParam(':category', $category);
                 $sql2->bindParam(':moduleid', $rowmodule['mo_id_pk']);
                 $sql2->execute();
             }
             self::$ok = TRUE;
             return;
         }
     }
     self::$error = TRUE;
     return;
 }