chamilo / chamilo-lms

        $userId = (int) $userId;

        $schema = Database::getManager()->getConnection()->getSchemaManager();

        if ($schema->tablesExist('ticket_assigned_log')) {

            $sql = "UPDATE ticket_assigned_log SET user_id = NULL WHERE user_id = $userId";

            Database::query($sql);

            $sql = "UPDATE ticket_assigned_log SET sys_insert_user_id = NULL WHERE sys_insert_user_id = $userId";

            Database::query($sql);

        }

        if ($schema->tablesExist('ticket_ticket')) {

            $sql = "UPDATE ticket_ticket SET assigned_last_user = NULL WHERE assigned_last_user = $userId";

            Database::query($sql);

        }

        if ($schema->tablesExist('ticket_category')) {

            $sql = "UPDATE ticket_category SET sys_insert_user_id = NULL WHERE sys_insert_user_id = $userId";

            Database::query($sql);

            $sql = "UPDATE ticket_category SET sys_lastedit_user_id = NULL WHERE sys_lastedit_user_id = $userId";

            Database::query($sql);

        }

        if ($schema->tablesExist('ticket_category_rel_user')) {

            $sql = "DELETE FROM ticket_category_rel_user WHERE user_id = $userId";

            Database::query($sql);

        }

        if ($schema->tablesExist('ticket_message')) {

            $sql = "UPDATE ticket_message SET sys_insert_user_id = NULL WHERE sys_insert_user_id = $userId";

            Database::query($sql);

            $sql = "UPDATE ticket_message SET sys_lastedit_user_id = NULL WHERE sys_lastedit_user_id = $userId";

            Database::query($sql);

        }

        if ($schema->tablesExist('ticket_message_attachments')) {

            $sql = "UPDATE ticket_message_attachments SET sys_insert_user_id = NULL WHERE sys_insert_user_id = $userId";

            Database::query($sql);

        }

        if ($schema->tablesExist('ticket_message_attachments')) {

            $sql = "UPDATE ticket_message_attachments SET sys_insert_user_id = NULL WHERE sys_insert_user_id = $userId";

            Database::query($sql);

            $sql = "UPDATE ticket_message_attachments SET sys_lastedit_user_id = NULL WHERE sys_lastedit_user_id = $userId";

            Database::query($sql);

        }

        if ($schema->tablesExist('ticket_priority')) {

            $sql = "UPDATE ticket_priority SET sys_insert_user_id = NULL WHERE sys_insert_user_id = $userId";

            Database::query($sql);

        }

        if ($schema->tablesExist('ticket_priority')) {

            $sql = "UPDATE ticket_priority SET sys_insert_user_id = NULL WHERE sys_insert_user_id = $userId";

            Database::query($sql);

            $sql = "UPDATE ticket_priority SET sys_lastedit_user_id = NULL WHERE sys_lastedit_user_id = $userId";

            Database::query($sql);

        }

        if ($schema->tablesExist('ticket_project')) {

            $sql = "UPDATE ticket_project SET sys_insert_user_id = NULL WHERE sys_insert_user_id = $userId";

            Database::query($sql);

        }

        if ($schema->tablesExist('ticket_project')) {

            $sql = "UPDATE ticket_project SET sys_insert_user_id = NULL WHERE sys_insert_user_id = $userId";

            Database::query($sql);

            $sql = "UPDATE ticket_project SET sys_lastedit_user_id = NULL WHERE sys_lastedit_user_id = $userId";

            Database::query($sql);

        }

    }

}