ezsystems / ezpublish-kernel

     *

     * @return string[][]

     */

    public function loadAllSectionData()

    {

        $query = $this->dbHandler->createSelectQuery();

        $query->select(

            $this->dbHandler->quoteColumn('id'),

            $this->dbHandler->quoteColumn('identifier'),

            $this->dbHandler->quoteColumn('name')

        )->from(

            $this->dbHandler->quoteTable('ezsection')

        );

        $statement = $query->prepare();

        $statement->execute();

        return $statement->fetchAll(\PDO::FETCH_ASSOC);

    }

    /**

     * Loads data for section with $identifier.

     *

     * @param int $id

     */

    public function deleteSection($id)

    {

        $query = $this->dbHandler->createDeleteQuery();

        $query->deleteFrom(

            $this->dbHandler->quoteTable('ezsection')

        )->where(

            $query->expr->eq(

                $this->dbHandler->quoteColumn('id'),

                $query->bindValue($id, null, \PDO::PARAM_INT)

            )

        );

        $query->prepare()->execute();

    }

    /**

     * Inserts the assignment of $contentId to $sectionId.

     *

     * @param int $id

     */

    public function deleteLanguage($id)

    {

        $query = $this->dbHandler->createDeleteQuery();

        $query->deleteFrom(

            $this->dbHandler->quoteTable('ezcontent_language')

        )->where(

            $query->expr->eq(

                $this->dbHandler->quoteColumn('id'),

                $query->bindValue($id, null, \PDO::PARAM_INT)

            )

        );

        $query->prepare()->execute();

    }

    /**

     * Check whether a language may be deleted.

     *

     * @param int $stateId

     */

    public function deleteObjectStateLinks($stateId)

    {

        $query = $this->dbHandler->createDeleteQuery();

        $query->deleteFrom(

            $this->dbHandler->quoteTable('ezcobj_state_link')

        )->where(

            $query->expr->eq(

                $this->dbHandler->quoteColumn('contentobject_state_id'),

                $query->bindValue($stateId, null, \PDO::PARAM_INT)

            )

        );

        $query->prepare()->execute();

    }

    /**

     * Inserts a new object state group into database.

     *

     * @param mixed $stateId

     */

    protected function deleteObjectStateTranslations($stateId)

    {

        $query = $this->dbHandler->createDeleteQuery();

        $query->deleteFrom(

            $this->dbHandler->quoteTable('ezcobj_state_language')

        )->where(

            $query->expr->eq(

                $this->dbHandler->quoteColumn('contentobject_state_id'),

                $query->bindValue($stateId, null, \PDO::PARAM_INT)

            )

        );

        $query->prepare()->execute();

    }

    /**

     * Inserts object state group translations into database.

     *

     * @param mixed $groupId

     */

    protected function deleteObjectStateGroupTranslations($groupId)

    {

        $query = $this->dbHandler->createDeleteQuery();

        $query->deleteFrom(

            $this->dbHandler->quoteTable('ezcobj_state_group_language')

        )->where(

            $query->expr->eq(

                $this->dbHandler->quoteColumn('contentobject_state_group_id'),

                $query->bindValue($groupId, null, \PDO::PARAM_INT)

            )

        );

        $query->prepare()->execute();

    }

}

     *

     * @param mixed $id

     */

    public function deleteUrlWildcard($id)

    {

        /** @var $query \eZ\Publish\Core\Persistence\Database\DeleteQuery */

        $query = $this->dbHandler->createDeleteQuery();

        $query->deleteFrom(

            $this->dbHandler->quoteTable('ezurlwildcard')

        )->where(

            $query->expr->eq(

                $this->dbHandler->quoteColumn('id'),

                $query->bindValue($id, null, \PDO::PARAM_INT)

            )

        );

        $query->prepare()->execute();

    }

    /**

     * Loads an array with data about UrlWildcard with $id.

     * @param string $pathString

     * @param bool $isHidden

     */

    private function setNodeHiddenStatus(string $pathString, bool $isHidden): void

    {

        $query = $this->handler->createUpdateQuery();

        $query

            ->update($this->handler->quoteTable('ezcontentobject_tree'))

            ->set(

                $this->handler->quoteColumn('is_hidden'),

                $query->bindValue((int) $isHidden)

            )

            ->where(

                $query->expr->eq(

                    $this->handler->quoteColumn('path_string'),

                    $query->bindValue($pathString)

                )

            );

        $query->prepare()->execute();

    }

    /**

     * Sets a location to be unhidden, and self + children to visible unless a parent is hiding the tree.

     * @param mixed $contentId

     * @param mixed $versionNo

     */

    public function updateLocationsContentVersionNo($contentId, $versionNo)

    {

        $query = $this->handler->createUpdateQuery();

        $query->update(

            $this->handler->quoteTable('ezcontentobject_tree')

        )->set(

            $this->handler->quoteColumn('contentobject_version'),

            $query->bindValue($versionNo, null, \PDO::PARAM_INT)

        )->where(

            $query->expr->eq(

                $this->handler->quoteColumn('contentobject_id'),

                $contentId

            )

        );

        $query->prepare()->execute();

    }

    /**

     * Searches for the main nodeId of $contentId in $versionId.

     *

     * @param string $hash

     */

    public function expireUserToken($hash)

    {

        $query = $this->handler->createUpdateQuery();

        $query

            ->update($this->handler->quoteTable('ezuser_accountkey'))

            ->set(

                $this->handler->quoteColumn('time'),

                $query->bindValue(0)

            )->where(

                $query->expr->eq(

                    $this->handler->quoteColumn('hash_key'),

                    $query->bindValue($hash, null, \PDO::PARAM_STR)

                )

            );

        $query->prepare()->execute();

    }

    /**

     * Assigns role to user with given limitation.