} } } mysql_query("UNLOCK TABLES"); } elseif ($_POST['arg'] == "teamsm_remove") { mysql_query("LOCK TABLES runde as r WRITE, wettkampf as w READ, runde WRITE, serie READ"); // if there are already rounds with groups, remove all but the one with the lowest group $res = mysql_query("SELECT r.xRunde, r.Gruppe FROM\r\n\t\t\t\trunde as r\r\n\t\t\t\t, wettkampf as w\r\n\t\t\tWHERE\r\n\t\t\t\tr.xWettkampf = w.xWettkampf\r\n\t\t\tAND\tw.xWettkampf = {$disc}\r\n\t\t\tORDER BY\r\n\t\t\t\tr.Gruppe ASC"); if (mysql_errno() > 0) { AA_printErrorMsg(mysql_errno() . ": " . mysql_error()); } else { if (mysql_num_rows($res) > 0) { $g = 0; $del = false; while ($row = mysql_Fetch_array($res)) { if (AA_utils_checkReference("serie", "xRunde", $row[0]) != 0) { $error = $GLOBALS['strRound'] . $GLOBALS['strErrStillUsed']; AA_printErrorMsg($error); $_POST['arg'] = ""; break; } if ($g != 0 && $g != $row[1]) { // first group over $del = true; } if ($del) { mysql_query("DELETE FROM runde WHERE xRunde = {$row['0']}"); } else { mysql_query("UPDATE runde as r SET Gruppe = '' WHERE xRunde = {$row['0']}"); } $g = $row[1];
function update_remark() { $GLOBALS['AA_ERROR'] = ''; $query = ''; $reply = new ResultReturn(); mysql_query("\r\n LOCK TABLES rundenset READ, runde READ, runde as r READ , serie as s READ , start as st READ, \r\n wettkampf as w READ , anmeldung as a READ , athlet as at READ, verein as v READ, \r\n rundentyp_de as rt READ, rundentyp_fr as rt READ, rundentyp_it as rt READ, serienstart as ss READ , serienstart WRITE\r\n "); if (!empty($this->startID)) { if (AA_utils_checkReference("serienstart", "xSerienstart", $this->startID) == 0) { $GLOBALS['AA_ERROR'] = $GLOBALS['strErrAthleteNotInHeat']; } else { $query = "SELECT \r\n w.mehrkampfcode , ss.Bemerkung\r\n FROM\r\n athletica.serienstart as ss\r\n LEFT JOIN athletica.start as st On (ss.xStart = st.xStart)\r\n LEFT JOIN athletica.wettkampf as w On (w.xWettkampf = st.xWettkampf) \r\n WHERE\r\n w.mehrkampfcode = 0\r\n AND ss.xSerienstart = " . $this->startID; $result = mysql_query($query); if (mysql_errno() > 0) { $GLOBALS['AA_ERROR'] = mysql_errno() . ": " . mysql_error(); } else { if (mysql_num_rows($result) > 0) { $sql = "UPDATE athletica.serienstart \r\n SET Bemerkung = '" . $this->remark . "' \r\n WHERE xSerienstart = " . $this->startID . ";"; mysql_query($sql); if (mysql_errno() > 0) { $GLOBALS['AA_ERROR'] = mysql_errno() . ": " . mysql_error(); } } else { // comnined event $query_mk = "SELECT \r\n ss.xSerienstart , ss.Bemerkung \r\n FROM \r\n athletica.runde AS r \r\n LEFT JOIN athletica.serie AS s ON (s.xRunde = r.xRunde) \r\n LEFT JOIN athletica.serienstart AS ss ON (ss.xSerie = s.xSerie)\r\n LEFT JOIN athletica.start AS st ON (st.xStart = ss.xStart) \r\n LEFT JOIN athletica.wettkampf as w ON (w.xWettkampf = st.xWettkampf)\r\n LEFT JOIN athletica.anmeldung AS a ON (a.xAnmeldung = st.xAnmeldung)\r\n LEFT JOIN athletica.athlet AS at ON (at.xAthlet = a.xAthlet)\r\n LEFT JOIN athletica.verein AS v ON (v.xVerein = at.xVerein )\r\n LEFT JOIN athletica.rundentyp_" . $_COOKIE['language'] . " AS rt ON rt.xRundentyp = r.xRundentyp \r\n WHERE \r\n w.mehrkampfcode > 0\r\n AND at.xAthlet = " . $this->xAthlete; $result = mysql_query($query_mk); if (mysql_errno() > 0) { $GLOBALS['AA_ERROR'] = mysql_errno() . ": " . mysql_error(); } else { while ($row = mysql_fetch_row($result)) { $sql = "UPDATE athletica.serienstart \r\n SET Bemerkung = '" . $this->remark . "' \r\n WHERE xSerienstart = " . $row[0] . ";"; mysql_query($sql); if (mysql_errno() > 0) { $GLOBALS['AA_ERROR'] = mysql_errno() . ": " . mysql_error(); } } } } } } } mysql_query("UNLOCK TABLES"); return $reply; }
/** * Check data reference * * @param string table name of table to be checked * @param string unique name of unique key column * @param int id uniqe key of item to be checked (xTablename) * @return int rows nbr of rows found */ function AA_checkReference($table, $unique, $id) { $rows = AA_utils_checkReference($table, $unique, $id); if (!empty($GLOBALS['AA_ERROR'])) { AA_printErrorMsg($GLOBALS['AA_ERROR']); } return $rows; }
function delete() { require './lib/utils.lib.php'; $GLOBALS['AA_ERROR'] = ''; // Error: Empty fields if (empty($_POST['round'])) { $GLOBALS['AA_ERROR'] = $GLOBALS['strErrEmptyFields']; } else { mysql_query("LOCK TABLES serie READ, runde WRITE, rundenset READ, rundenset WRITE"); // Still in use? if (AA_utils_checkReference("serie", "xRunde", $this->round) != 0) { $GLOBALS['AA_ERROR'] = $GLOBALS['strRound'] . $GLOBALS['strErrStillUsed']; } else { mysql_query("\r\n\t\t\t\t\tDELETE FROM\r\n\t\t\t\t\t\trunde\r\n\t\t\t\t\tWHERE xRunde = " . $this->round); } // Check if any error returned from DB if (mysql_errno() > 0) { $GLOBALS['AA_ERROR'] = mysql_errno() . ": " . mysql_error(); } // check if merged round $sql = "SELECT xRundenset, Hauptrunde FROM rundenset WHERE xRunde = " . $this->round . " AND xMeeting = " . $_COOKIE['meeting_id']; $result = mysql_query($sql); if (mysql_errno() > 0) { $GLOBALS['AA_ERROR'] = mysql_errno() . ": " . mysql_error(); } $num = mysql_num_rows($result); if ($num > 0) { $row = mysql_fetch_row($result); if ($row[1] == 1 || $num == 2) { // main round mysql_query("\r\n DELETE FROM\r\n rundenset\r\n WHERE xRundenset = " . $row[0] . " AND xMeeting = " . $_COOKIE['meeting_id']); if (mysql_errno() > 0) { $GLOBALS['AA_ERROR'] = mysql_errno() . ": " . mysql_error(); } } else { mysql_query("\r\n DELETE FROM\r\n rundenset\r\n WHERE xRunde= " . $this->round . " AND xMeeting = " . $_COOKIE['meeting_id']); if (mysql_errno() > 0) { $GLOBALS['AA_ERROR'] = mysql_errno() . ": " . mysql_error(); } } } mysql_query("UNLOCK TABLES"); } }
function delete() { require './lib/utils.lib.php'; $GLOBALS['AA_ERROR'] = ''; // Error: Empty fields if (empty($_POST['round'])) { $GLOBALS['AA_ERROR'] = $GLOBALS['strErrEmptyFields']; } else { mysql_query("LOCK TABLES serie READ, runde WRITE"); // Still in use? if (AA_utils_checkReference("serie", "xRunde", $this->round) != 0) { $GLOBALS['AA_ERROR'] = $GLOBALS['strRound'] . $GLOBALS['strErrStillUsed']; } else { mysql_query("\r\n\t\t\t\t\tDELETE FROM\r\n\t\t\t\t\t\trunde\r\n\t\t\t\t\tWHERE xRunde = " . $this->round); } // Check if any error returned from DB if (mysql_errno() > 0) { $GLOBALS['AA_ERROR'] = mysql_errno() . ": " . mysql_error(); } mysql_query("UNLOCK TABLES"); } }
/** * save remark * --------------- */ function AA_utils_saveRemark($startID, $remark, $xAthlete) { $GLOBALS['AA_ERROR'] = ''; $query = ''; mysql_query("\r\n LOCK TABLES rundenset READ, runde READ, runde as r READ , serie as s READ , start as st READ, \r\n wettkampf as w READ , anmeldung as a READ , athlet as at READ, verein as v READ, \r\n rundentyp as rt READ, serienstart as ss READ , serienstart WRITE\r\n "); if (!empty($startID)) { if (AA_utils_checkReference("serienstart", "xSerienstart", $startID) == 0) { $GLOBALS['AA_ERROR'] = $GLOBALS['strErrAthleteNotInHeat']; } else { $query = "SELECT \r\n w.mehrkampfcode , ss.Bemerkung\r\n FROM\r\n serienstart as ss\r\n LEFT JOIN start as st On (ss.xStart = st.xStart)\r\n LEFT JOIN wettkampf as w On (w.xWettkampf = st.xWettkampf) \r\n WHERE\r\n w.mehrkampfcode = 0\r\n AND ss.xSerienstart = " . $startID; $result = mysql_query($query); if (mysql_errno() > 0) { $GLOBALS['AA_ERROR'] = mysql_errno() . ": " . mysql_error(); } else { if (mysql_num_rows($result) > 0) { $sql = "UPDATE serienstart \r\n SET Bemerkung = '" . $remark . "' \r\n WHERE xSerienstart = " . $startID . ";"; mysql_query($sql); if (mysql_errno() > 0) { $GLOBALS['AA_ERROR'] = mysql_errno() . ": " . mysql_error(); } } else { // comnined event $query_mk = "SELECT \r\n ss.xSerienstart , ss.Bemerkung \r\n FROM \r\n runde AS r \r\n LEFT JOIN serie AS s ON (s.xRunde = r.xRunde) \r\n LEFT JOIN serienstart AS ss ON (ss.xSerie = s.xSerie)\r\n LEFT JOIN START AS st ON (st.xStart = ss.xStart) \r\n LEFT JOIN wettkampf as w ON (w.xWettkampf = st.xWettkampf)\r\n LEFT JOIN anmeldung AS a ON (a.xAnmeldung = st.xAnmeldung)\r\n LEFT JOIN athlet AS at ON (at.xAthlet = a.xAthlet)\r\n LEFT JOIN verein AS v ON (v.xVerein = at.xVerein )\r\n LEFT JOIN rundentyp AS rt ON rt.xRundentyp = r.xRundentyp \r\n WHERE w.mehrkampfcode > 0\r\n AND at.xAthlet = " . $xAthlete; $result = mysql_query($query_mk); if (mysql_errno() > 0) { $GLOBALS['AA_ERROR'] = mysql_errno() . ": " . mysql_error(); } else { while ($row = mysql_fetch_row($result)) { $sql = "UPDATE serienstart \r\n SET Bemerkung = '" . $remark . "' \r\n WHERE xSerienstart = " . $row[0] . ";"; mysql_query($sql); if (mysql_errno() > 0) { $GLOBALS['AA_ERROR'] = mysql_errno() . ": " . mysql_error(); } } } } } } } mysql_query("UNLOCK TABLES"); }