gregorybesson / PlaygroundGame

     *

     * @return Array of PlaygroundGame\Entity\Game

     */

    public function getPrizeCategoryGames($categoryid)

    {

        $em = $this->serviceLocator->get('doctrine.entitymanager.orm_default');

        $query = $em->createQuery('SELECT g FROM PlaygroundGame\Entity\Game g

            WHERE (g.prizeCategory = :categoryid AND g.broadcastPlatform = 1)

            ORDER BY g.publicationDate DESC');

        $query->setParameter('categoryid', $categoryid);

        $games = $query->getResult();

        return $games;

    }

    public function getGameIdentifierFromFacebook($fbPageId)

    {

        return $quiz;

    }

    public function getNumberCorrectAnswersQuiz($user, $count = 'count')

    {

        $em = $this->serviceLocator->get('doctrine.entitymanager.orm_default');

        $query = $em->createQuery(

            "SELECT COUNT(e.id) FROM PlaygroundGame\Entity\Entry e, PlaygroundGame\Entity\Game g

                WHERE e.user = :user

                AND g.classType = 'quiz'

                AND e.points > 0"

        );

        $query->setParameter('user', $user);

        $number = $query->getSingleScalarResult();

        return $number;

    }

    public function createQuizReply($data, $game, $user)

    {