ilForumDatabaseUpdateSteps11 Class Reference

Inheritance diagram for ilForumDatabaseUpdateSteps11:

Collaboration diagram for ilForumDatabaseUpdateSteps11:

Public Member Functions
	prepare (ilDBInterface $db)
	step_1 ()
Public Member Functions inherited from ilDatabaseUpdateSteps
	prepare (\ilDBInterface $db)
	Prepare the execution of the steps. More...

Protected Attributes
ilDBInterface	$db

Detailed Description

Definition at line 21 of file class.ilForumDatabaseUpdateSteps11.php.

Member Function Documentation

prepare()

ilForumDatabaseUpdateSteps11::prepare

(

ilDBInterface

$db

)

Definition at line 25 of file class.ilForumDatabaseUpdateSteps11.php.

References $db.

                                              : void
    {
        $this->db = $db;
    }

step_1()

ilForumDatabaseUpdateSteps11::step_1

(

)

Definition at line 30 of file class.ilForumDatabaseUpdateSteps11.php.

References $res, ILIAS\Repository\int(), ilDBConstants\T_INTEGER, and ilDBConstants\T_TEXT.

                            : void
    {
        $res = $this->db->queryF(
            "SELECT * FROM settings WHERE module = %s AND keyword = %s",
            [ilDBConstants::T_TEXT, ilDBConstants::T_TEXT],
            ['forum', 'frm_mod_tpl_perm_revocation']
        );

        $row = $this->db->fetchAssoc($res);
        if ($row) {
            $this->db->manipulateF(
                "DELETE FROM settings WHERE module = %s AND keyword = %s",
                [ilDBConstants::T_TEXT, ilDBConstants::T_TEXT],
                ['forum', 'frm_mod_tpl_perm_revocation']
            );

            return;
        }

        $res = $this->db->queryF(
            "SELECT obj_id FROM object_data WHERE type = %s AND title = %s",
            [ilDBConstants::T_TEXT, ilDBConstants::T_TEXT],
            ['rolt', 'il_frm_moderator']
        );

        $row = $this->db->fetchAssoc($res);
        if (!isset($row['obj_id'])) {
            return;
        }

        $rol_id = (int) $row['obj_id'];

        $res = $this->db->query(
            "SELECT ops_id FROM rbac_operations WHERE " . $this->db->in(
                'operation',
                ['edit_permission', 'delete', 'copy'],
                false,
                ilDBConstants::T_TEXT
            )
        );

        $rows = $this->db->fetchAll($res);
        if (!$rows) {
            return;
        }

        $operations_to_remove = [];
        foreach ($rows as $row) {
            $operations_to_remove[] = (int) $row['ops_id'];
        }

        foreach ($operations_to_remove as $op_id) {
            $this->db->manipulateF(
                "DELETE FROM rbac_templates WHERE rol_id = %s AND type = %s AND ops_id = %s AND parent = %s",
                [ilDBConstants::T_INTEGER, ilDBConstants::T_TEXT, ilDBConstants::T_INTEGER, ilDBConstants::T_INTEGER],
                [$rol_id, 'frm', $op_id, 8]
            );
        }
    }

Here is the call graph for this function:

Field Documentation

$db

ilDBInterface ilForumDatabaseUpdateSteps11::$db

protected

Definition at line 23 of file class.ilForumDatabaseUpdateSteps11.php.

Referenced by prepare().

---

The documentation for this class was generated from the following file:

• components/ILIAS/Forum/classes/Setup/class.ilForumDatabaseUpdateSteps11.php