/**
* @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();
