<?php
/**
* @author Anne L'Hôte <*****@*****.**>
*
* Called by scripts/experiments.js
**/
require_once 'experiment.php';
$iExperimentId = $_POST['experiment_id'];
$sPrefix = 'export_scores_';
$oExperimentClass = new Experiment();
$aGames = $oExperimentClass->getGamesFromExperiment($iExperimentId);
$aScores = array();
// 1. Check if this experiment id exists into database, return an error
$sQuery = "SELECT COUNT(id) AS c FROM mango_experiment WHERE id = {$iExperimentId}";
$oResult = $oExperimentClass->oDbConnection->query($sQuery);
$aRows = $oResult->fetch_array();
if ($aRows[c] == 0) {
$aReturn['status'] = 'error';
$aReturn['message'] = 'This experiment id doesn\'t exist into database!';
echo json_encode($aReturn);
exit;
}
// 2. Export final scores into CSV file
$sFileContent = "token,earning" . PHP_EOL;
$sQuery = "SELECT token,earning FROM mango_earning WHERE experiment_id = {$iExperimentId}";
$oResult = $oExperimentClass->oDbConnection->query($sQuery);
while ($aRow = $oResult->fetch_array()) {
$sFileContent .= $aRow['token'] . ',' . $aRow['earning'] . PHP_EOL;
}
$fFile = fopen('../downloads/export_earning_' . $iExperimentId . '.csv', 'w+');
