function setStatus($status)
{
require './lib/utils.lib.php';
if ($status >= $GLOBALS['cfgRoundStatus']['open']) {
$result = mysql_query("\r\n\t\t\t\tSELECT\r\n\t\t\t\t\tStatus\r\n\t\t\t\tFROM\r\n\t\t\t\t\trunde\r\n\t\t\t\tWHERE xRunde = " . $this->roundID);
if (mysql_errno() > 0) {
$GLOBALS['AA_ERROR'] = mysql_errno() . ": " . mysql_error();
} else {
$row = mysql_fetch_row($result);
// update only if status changed
if ($row[0] != $status) {
$this->update("\r\n\t\t\t\t\t\tUPDATE runde SET\r\n\t\t\t\t\t\t\tStatus = {$status}\r\n\t\t\t\t\t\tWHERE xRunde = " . $this->roundID);
// update log file if update OK
if (empty($GLOBALS['AA_ERROR'])) {
$txt = $GLOBALS['strStatus'] . ": " . $GLOBALS['cfgRoundStatusTranslation'][$status];
AA_utils_logRoundEvent($this->roundID, $txt);
}
}
// ET status changed
mysql_free_result($result);
}
// ET DB error
}
// ET valid status
}
if (!empty($_POST['qual_top'])) {
$qual_top = $_POST['qual_top'];
}
$qual_perf = 0;
if (!empty($_POST['qual_perf'])) {
$qual_perf = $_POST['qual_perf'];
}
$print = 'no';
if (!empty($_POST['print'])) {
$print = $_POST['print'];
}
AA_utils_changeRoundStatus($round, $cfgRoundStatus['heats_done']);
if (!empty($GLOBALS['AA_ERROR'])) {
AA_printErrorMsg($GLOBALS['AA_ERROR']);
}
AA_utils_logRoundEvent($round, $strHeatsPrinted);
//
// get nbr of heats
// ----------------
$res = mysql_query("SELECT COUNT(*)" . " FROM serie" . " WHERE xRunde = {$round}");
if (mysql_errno() > 0) {
// DB error
AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
} else {
$row = mysql_fetch_row($res);
$tot_heats = $row[0];
}
mysql_free_result($res);
//
// Update qualification parameters
// -------------------------------
function change()
{
include './convtables.inc.php';
require './lib/common.lib.php';
// Error: Empty fields
if (empty($this->round)) {
$GLOBALS['AA_ERROR'] = $GLOBALS['strErrEmptyFields'];
} else {
mysql_query("LOCK TABLES serie READ, kategorie_svm as ks READ, wettkampf as w READ, runde as r READ, disziplin_de as d READ, disziplin_fr as d READ, disziplin_it as d READ, runde WRITE, wettkampf WRITE, meeting WRITE");
$status = AA_utils_getRoundStatus($this->round);
if ($status == $GLOBALS['cfgRoundStatus']['results_done']) {
$GLOBALS['AA_ERROR'] = $GLOBALS['strErrResultsEntered'];
} else {
if (empty($this->type)) {
// round type is not optional!
$GLOBALS['AA_ERROR'] = $GLOBALS['strType'] . $GLOBALS['strErrNotValid'];
} else {
if (!empty($this->etime)) {
$et = AA_formatEnteredTime($this->etime);
$sqlEtime = ", Appellzeit = '{$et['0']}:{$et['1']}:00'";
}
if (!empty($this->mtime)) {
$mt = AA_formatEnteredTime($this->mtime);
$sqlMtime = ", Stellzeit = '{$mt['0']}:{$mt['1']}:00'";
}
// set conversion table
if (isset($cfgSVM[$this->svmCode])) {
$cfgSVM_arr = $cfgSVM[$this->svmCode];
if (isset($cfgSVM[$this->svmCode . "_NT"])) {
// _NT = nulltime
$cfgSVM_arr_NT = $cfgSVM[$this->svmCode . "_NT"];
}
}
if (isset($cfgSVM[$this->svmCode . "_NT"])) {
// _NT = nulltime
foreach ($cfgSVM_arr as $key => $val) {
if ($val == $_POST['dCode']) {
$keep_key = $key;
continue;
}
}
if ($cfgSVM_arr_NT[$keep_key] == '0000') {
// discipline with nulltime
$this->change_all();
} else {
mysql_query("\r\n UPDATE runde SET\r\n Datum = '" . $this->date . "'\r\n , Startzeit = '" . $this->hour . ":" . $this->min . ":00" . "'\r\n , xRundentyp = " . $this->type . "\r\n , Gruppe = '" . $this->group . "' \r\n {$sqlEtime}\r\n {$sqlMtime}\r\n WHERE xRunde = " . $this->round);
if (mysql_errno() > 0) {
$GLOBALS['AA_ERROR'] = mysql_errno() . ": " . mysql_error();
}
}
} else {
$sql = "SELECT \r\n xRundentyp,\r\n xWettkampf\r\n FROM\r\n runde as r\r\n WHERE\r\n r.xRunde = " . $this->round;
$result = mysql_query($sql);
if (mysql_errno() > 0) {
$GLOBALS['AA_ERROR'] = mysql_errno() . ": " . mysql_error();
} else {
$row = mysql_fetch_array($result);
if ($row[0] == 8 && $this->type != 8) {
// typ 8 = combined event
$typchange = '';
$sql_event = "SELECT \r\n w.Typ,\r\n w.Punktetabelle,\r\n w.Punkteformel,\r\n w.Info,\r\n w.Mehrkampfcode,\r\n w.Mehrkampfende, \r\n w.Mehrkampfreihenfolge \r\n FROM\r\n wettkampf as w\r\n WHERE\r\n w.xWettkampf = " . $row[1];
$res_event = mysql_query($sql_event);
if (mysql_errno() > 0) {
$GLOBALS['AA_ERROR'] = mysql_errno() . ": " . mysql_error();
} else {
$row_event = mysql_fetch_array($res_event);
$typchange = $row_event[0] . "," . $row_event[1] . "," . $row_event[2] . "," . $row_event[3] . "," . $row_event[4] . "," . $row_event[5] . "," . $row_event[6];
// update event as single event
mysql_query("\r\n UPDATE wettkampf SET\r\n Typ = 0\r\n , Punktetabelle = 0\r\n , Punkteformel = '0'\r\n , Info = '' \r\n , Mehrkampfcode = 0\r\n , Mehrkampfende = 0 \r\n , Mehrkampfreihenfolge = 0 \r\n , TypAenderung = '" . $typchange . "' \r\n WHERE xWettkampf = " . $row[1]);
if (mysql_errno() > 0) {
$GLOBALS['AA_ERROR'] = mysql_errno() . ": " . mysql_error();
}
}
} elseif ($this->type == 8 && $row[0] != 8) {
// typ 8 = combined event
$sql_event = "SELECT \r\n w.TypAenderung \r\n FROM\r\n wettkampf as w\r\n WHERE\r\n w.xWettkampf = " . $row[1];
$res_event = mysql_query($sql_event);
if (mysql_errno() > 0) {
$GLOBALS['AA_ERROR'] = mysql_errno() . ": " . mysql_error();
} else {
$row_event = mysql_fetch_array($res_event);
if ($row_event[0] != '') {
$typchange = explode(",", $row_event[0]);
// update event as combined event
mysql_query("\r\n UPDATE wettkampf SET\r\n Typ = " . $typchange[0] . "\r\n , Punktetabelle = " . $typchange[1] . " \r\n , Punkteformel = '" . $typchange[2] . "' \r\n , Info = '" . $typchange[3] . "' \r\n , Mehrkampfcode = " . $typchange[4] . " \r\n , Mehrkampfende = " . $typchange[5] . " \r\n , Mehrkampfreihenfolge = " . $typchange[6] . " \r\n , TypAenderung = '' \r\n WHERE xWettkampf = " . $row[1]);
if (mysql_errno() > 0) {
$GLOBALS['AA_ERROR'] = mysql_errno() . ": " . mysql_error();
}
}
}
}
mysql_query("\r\n\t\t\t\t\t\t UPDATE runde SET\r\n\t\t\t\t\t\t\t Datum = '" . $this->date . "'\r\n\t\t\t\t\t\t\t , Startzeit = '" . $this->hour . ":" . $this->min . ":00" . "'\r\n\t\t\t\t\t\t\t , xRundentyp = " . $this->type . "\r\n\t\t\t\t\t\t\t , Gruppe = '" . $this->group . "' \r\n\t\t\t\t\t\t\t {$sqlEtime}\r\n\t\t\t\t\t\t\t {$sqlMtime}\r\n\t\t\t\t\t\t WHERE xRunde = " . $this->round);
if (mysql_errno() > 0) {
$GLOBALS['AA_ERROR'] = mysql_errno() . ": " . mysql_error();
}
}
}
$sql = "UPDATE meeting SET\r\n StatusChanged = 'y' \r\n WHERE xMeeting = " . $_COOKIE['meeting_id'];
mysql_query($sql);
if (mysql_errno() > 0) {
$GLOBALS['AA_ERROR'] = mysql_errno() . ": " . mysql_error();
}
}
}
mysql_query("UNLOCK TABLES");
if ($status > 0 && $status != 4) {
$txt = $GLOBALS['strTimetableChanged'] . ": " . $this->date . ", " . $this->hr . ":" . $this->min;
AA_utils_logRoundEvent($this->round, $txt);
}
}
// ET round status
}
