<?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);