/** * @return array */ protected function submitQuizReply() { if (!$this->user()) { return null; } $season = QuizHallOfFame::getCurrentSeason(ClusterTool::clusterIdentifier()); $isLocalQuiz = $this->isLocalQuiz(); $quizId = $_POST['qid']; $quizObject = eZContentObject::fetch($quizId); $dataMap = $quizObject->dataMap(); $publicationDateTimestamp = $dataMap['online_date']->content()->timeStamp(); $publicationDate = DateTime::createFromFormat('U', $publicationDateTimestamp); $questionSeason = QuizHallOfFame::calculateSeason($publicationDate); if ($questionSeason > $season && !$this->isLocalQuiz()) { QuizPlayerScoring::startNewSeason(ClusterTool::clusterIdentifier()); } $fetchParams = array( 'quiz_id' => $quizId, 'uuid' => $this->user()->attribute( 'uuid' ), 'application_id' => $this->applicationObject->attribute( 'id' ) ); if (!$isLocalQuiz) { $fetchParams['cluster_identifier'] = null; } if( QuizReply::fetchOneBy( $fetchParams ) != null ) { return null; } $quizMetaFetchParams = array( 'quiz_id' => $quizId ); if (!$isLocalQuiz) { $quizMetaFetchParams['cluster_identifier'] = null; } $quizMeta = QuizMeta::fetchOneBy( $quizMetaFetchParams ); if (!$quizMeta) { return null; } $db = eZDB::instance(); $db->begin(); $lowestScores = null; $isCorrect = $_POST['r'] == $quizMeta->attribute( 'correct_answer' ) ? true : false; $reply = new QuizReply(); $reply->setAttribute( 'uuid', $this->user()->attribute( 'uuid' ) ); if ($isLocalQuiz) { $reply->setAttribute( 'cluster_identifier', ClusterTool::clusterIdentifier() ); } $reply->setAttribute( 'application_id', $this->applicationObject->attribute( 'id' ) ); $reply->setAttribute( 'quiz_id', $quizId ); $reply->setAttribute( 'is_correct', $isCorrect ); $playerScoringFetchParams = array( 'uuid' => $this->user()->attribute( 'uuid' ), ); if (!$isLocalQuiz) { $playerScoringFetchParams['cluster_identifier'] = null; } $playerScoring = QuizPlayerScoring::fetchOneBy( $playerScoringFetchParams ); if( is_null( $playerScoring ) ) { $lowestScores = QuizPlayerScoring::createNewPlayer( null, $this->applicationObject->attribute( 'id' ), $isLocalQuiz ); // TODO use returned playerScoring object from createNewPlayer instead of fetching one again $playerScoring = QuizPlayerScoring::fetchOneBy( $playerScoringFetchParams ); } if( $isCorrect ) { QuizPlayerScoring::scheduleRankingUpdate( $playerScoring->attribute( 'global_ranking' ), $this->applicationObject->attribute( 'id' ), $isLocalQuiz ); $playerScoring->setAttribute( 'score', ( (int)$playerScoring->attribute( 'score' ) + (int)$quizMeta->attribute( 'points' ) ) ); $playerScoring->setAttribute( 'nb_correct', ( (int)$playerScoring->attribute( 'nb_correct' ) + 1 ) ); $quizMeta->setAttribute( 'nb_correct', ( (int)$quizMeta->attribute( 'nb_correct' ) + 1 ) ); } else { $playerScoring->setAttribute( 'nb_wrong', ( (int)$playerScoring->attribute( 'nb_wrong' ) + 1 ) ); $quizMeta->setAttribute( 'nb_wrong', ( (int)$quizMeta->attribute( 'nb_wrong' ) + 1 ) ); } $quizMeta->store(); $reply->store(); $playerScoring->store(); $db->commit(); /* @type $quizArticleDM eZContentObjectAttribute[] */ $quizArticleDM = eZContentObject::fetch( $quizId )->DataMap(); $mediaContent = $quizArticleDM["media_content"]->content(); $quizDM = eZContentObjectTreeNode::fetch( $mediaContent['relation_list'][0]['node_id'] )->DataMap(); $outputHandler = new eZXHTMLXMLOutput( $quizDM['commented_answer']->DataText, false ); $commentedAnswer = $outputHandler->outputText(); $response = array( 'answer' => $quizMeta->attribute( 'correct_answer' ), 'comment' => $commentedAnswer, 'points' => (int)$quizMeta->attribute( 'points' ) ); if( !is_null( $lowestScores ) ) $response['ranking'] = $lowestScores; return $response; }
$countUS[$us] ); $score++; $db->query( $query ); } QuizPlayerScoring::scheduleRankingUpdate( $gr, $options['quizApplicationId'] ); $cli->output( "Done, added " . $options['nbPlayer'] . " test players in quiz player scoring table" ); } elseif( $options['empty'] && $options['clusterIdentifier'] && $options['quizApplicationId'] ) { ClusterTool::setCurrentCluster( $options['clusterIdentifier'] ); $db->query( sprintf( "DELETE FROM %s WHERE uuid LIKE 'qzbench%%'", QuizPlayerScoring::SQL_TABLENAME ) ); $lowestGlobalScore = QuizPlayerScoring::fetchBy( array( 'application_id' => $options['quizApplicationId'] ), array( 'global_ranking' => 'desc' ), array( 'length' => 1 ) ); if( $lowestGlobalScore ) $gr = $lowestGlobalScore[0]->attribute( 'score' ) == 0 ? $lowestGlobalScore[0]->attribute( 'global_ranking' ) : ( $lowestGlobalScore[0]->attribute( 'global_ranking' ) + 1 ); else $gr = 1; QuizPlayerScoring::scheduleRankingUpdate( $gr, $options['quizApplicationId'] ); $cli->output( "Quiz player scoring table has been emptied of its test players" ); } else { $cli->output( "Please specify either the --clusterIdentifier/--quizApplicationId/--nbPlayer parameters or the --clusterIdentifier/--quizApplicationId/--empty parameters" ); } $script->shutdown();