/**
* Will copy all pictures to their correct folder.
* This is done LAST, after we know that the database is ok, in case something
* goes wrong with the database.
*/
function copyPicturesToCorrectFolder($sortedPictureSet, $originalDir, $db, $oldPictures, $oldExperiment)
{
foreach ($sortedPictureSet as $pictureSet) {
mkdir("../../uploads/" . $_SESSION['user']['id'] . "/" . $pictureSet['newPictureset'], 0777, true);
foreach ($pictureSet['picture'] as $pictureId) {
$newTargetPath = getUrlForPicture($pictureId['newId'], $db);
$oldTargetPath;
foreach ($oldPictures as $picture) {
if ($pictureId['oldId'] == $picture['id']) {
$picture['person'] = $oldExperiment['person'];
$oldTargetPath = "../../uploads/zipfiles/" . $_SESSION['user']['id'] . "/randomName/uploads/" . $oldExperiment['person'] . "/" . $pictureSet['oldPictureset'] . "/" . $picture['name'];
}
}
copy($oldTargetPath, $newTargetPath);
}
}
$path = "../../uploads/zipfiles/" . $_SESSION['user']['id'] . "/";
SureRemoveDir($path, true);
}
}
function getExperimentById($id, $db)
{
$sql = "SELECT *, experimenttype.name AS experimentTypeName, experiment.title AS experimentName, experiment.longDescription AS experimentDescription " . " FROM experiment " . " JOIN experimenttype ON experiment.experimentType = experimenttype.id " . " WHERE person = ? AND experiment.id = ?";
$sth = $db->prepare($sql);
$sth->bindParam(1, $_SESSION['user']['id']);
$sth->bindParam(2, $id);
$sth->execute();
$result = $sth->fetch();
return $result;
}
if (isset($_GET['option'])) {
$option = $_GET['option'];
if ($option == "getPictureUrl") {
$pictureId = $_GET['pictureId'];
echo json_encode(getUrlForPicture($pictureId, $db));
}
}
/**
* Returns results for category experiments
* @param int $experimentId Id of experiment
* @param object $db Object of current database
* @param int $type experimenttype id
* @return array Array of rows with result data
*/
function getExperimentRawData($experimentId, $db, $type, $complete)
{
$result = 0;
if ($type == 3) {
//Magic be here, DO NOT TOUCH OR GOD BE WITH YOU
$sql = "SELECT result.*, picture.*, experimentorder.eOrder as experimentOrder, person.firstName, person.lastName, categoryname.name AS categoryName" . " FROM `result` " . " JOIN pictureorder ON result.pictureOrderId = pictureorder.id" . " JOIN picture ON pictureorder.picture = picture.id" . " JOIN picturequeue ON pictureorder.pictureQueue = picturequeue.id" . " JOIN experimentorder ON picturequeue.id = experimentorder.pictureQueue" . " JOIN person ON result.personId = person.id" . " JOIN categoryname ON result.category = categoryname.id" . ($complete == 1 ? " JOIN experimentresult ON result.experimentId = experimentresult.experiment " : '') . " WHERE result.experimentId = ? " . ($complete == 1 ? "AND experimentresult.complete != 1 AND experimentresult.person = person.id " : "");
