<?php
require_once dirname(dirname(dirname(__FILE__))) . '/config.php';
require_once 'Partecipants-exp/functions/rows.inc.php';
/****** Controller ******/
if (!CheckTourSession()) {
print get_text('CrackError');
exit;
}
$error = 0;
$divisions = getDivisions();
$classes = getClasses();
if ($divisions === false || $classes === false) {
$error = 1;
$divisions = array('--' => '--');
$classes = array('--' => array('val' => '--', 'valid' => '--'));
}
/****** End Controlloer ******/
/****** Output ******/
$xmlDoc = new DOMDocument('1.0', 'UTF-8');
$xmlRoot = $xmlDoc->createElement('response');
$xmlDoc->appendChild($xmlRoot);
// Sezione header
$xmlHeader = $xmlDoc->createElement('header');
$xmlRoot->appendChild($xmlHeader);
$node = $xmlDoc->createElement('error', $error);
$xmlHeader->appendChild($node);
// Sezione combos
$xmlCombos = $xmlDoc->createElement('combos');
$xmlRoot->appendChild($xmlCombos);
// divisions
// array('division' => 'NPT', 'number' => 1.7),
// )
//);
//
//--------------------------------------------------------------------------------------------------
// make sure we have access to the database
//=========================================
// connect to our database
$link = getLink();
// create the empty structure
//===========================
// data array
$data = array('legend' => array(), 'totals' => array(), 'data' => array());
$averages = array();
// add the names of the divisions and the empty result array stub
$divisions = getDivisions($link);
foreach ($divisions as $division) {
$data['data'][] = array('division' => $division, 'numbers' => array(), 'average' => 0);
$averages[$division] = 0;
}
// fill the values from the database semster by semester
//======================================================
// find all matching tables and fill per table
$nSemester = 0;
$tables = findTables($link, 'Assignments');
foreach ($tables as $key => $table) {
$semester = substr($table, -5, 5);
if (substr($semester, 0, 1) != 'I') {
$nSemester += 1;
$data['legend'][] = $semester;
$semesterData = getAssignments($link, $table, $divisions);
