public static function startNewSeason($clusterIdentifier)
{
$season = QuizHallOfFame::getCurrentSeason($clusterIdentifier);
$db = MMDB::instance();
$players = $db->arrayQuery( sprintf("
SELECT uuid
FROM quiz_player_scoring
WHERE user_cluster = '%s'",
$db->escapeString( $clusterIdentifier )
));
$db->begin();
foreach($players as $player)
{
$uuid = $player['uuid'];
QuizReply::moveToArchive($uuid, $season);
}
QuizPlayerScoring::moveToArchive($clusterIdentifier, $season);
$db->commit();
}
/**
* @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;
}
