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 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.

     * @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.