<?php require_once dirname(dirname(__FILE__)) . '/config.php'; CheckTourSession(true); require_once './LibScheduler.php'; if (!empty($_REQUEST['Fld'])) { $Field = key($_REQUEST['Fld']); foreach ($_REQUEST['Fld'] as $Date => $Times) { foreach ($Times as $Time => $Orders) { foreach ($Orders as $Order => $Arg) { if ($Arg != 'del') { out(); } safe_w_sql("delete from Scheduler where SchTournament={$_SESSION['TourId']} and SchDay='{$Date}' and SchStart='{$Time}' and SchOrder='{$Order}'"); } } $ret = DistanceInfoData(true); out($ret); } } if (!empty($_REQUEST['WarmDelete'])) { list($TeamEvent, $Phase, $Day, $MatchTime, $Time) = explode('|', $_REQUEST['WarmDelete']); safe_w_sql("delete from FinWarmup\n\t\twhere FwTournament={$_SESSION['TourId']}\n\t\t\tand FwTeamEvent='" . ($TeamEvent == 'T' ? 1 : 0) . "'\n\t\t\tand FwDay='{$Day}'\n\t\t\tand FwMatchTime='{$MatchTime}'\n\t\t\tand FwTime='{$Time}:00'"); $ret = DistanceInfoData(true); out($ret); } out();
function ChangeFinComment($Request, $Team = '0') { foreach ($Request as $Phase => $Dates) { foreach ($Dates as $OldDate => $Times) { foreach ($Times as $OldTime => $WarmTimes) { foreach ($WarmTimes as $WarmTime => $Value) { if (strlen($WarmTime) != 5) { return; } safe_w_sql("update FinWarmup\n\t\t\t\t\t\t\tset FwOptions=" . StrSafe_DB($Value) . "\n\t\t\t\t\t\t\twhere\n\t\t\t\t\t\t\t\tFwTournament={$_SESSION['TourId']}\n\t\t\t\t\t\t\t\tAND FwTeamEvent={$Team}\n\t\t\t\t\t\t\t\tAND FwDay='{$OldDate}'\n\t\t\t\t\t\t\t\tAND FwMatchTime='{$OldTime}'\n\t\t\t\t\t\t\t\tAND FwTime='{$WarmTime}:00'\n\t\t\t\t\t\t"); $SQL = "select\n\t\t\t\t\t\t\tFwDay DiDay,\n\t\t\t\t\t\t\tFwTime DiWarmStart,\n\t\t\t\t\t\t\tFwDuration DiWarmDuration,\n\t\t\t\t\t\t\tFwOptions DiOptions,\n\t\t\t\t\t\t\t'Fld[" . ($Team ? 'T' : 'I') . "][WarmTime][{$Phase}][{$OldDate}][{$OldTime}][{$WarmTime}]' as oldTimName,\n\t\t\t\t\t\t\t'Fld[" . ($Team ? 'T' : 'I') . "][WarmDuration][{$Phase}][{$OldDate}][{$OldTime}][{$WarmTime}]' as oldDurName,\n\t\t\t\t\t\t\t'Fld[" . ($Team ? 'T' : 'I') . "][Options][{$Phase}][{$OldDate}][{$OldTime}][{$WarmTime}]' as oldOptName,\n\t\t\t\t\t\t\t'Fld[" . ($Team ? 'T' : 'I') . "][WarmTime][{$Phase}][{$OldDate}][{$OldTime}][{$WarmTime}]' as newTimName,\n\t\t\t\t\t\t\t'Fld[" . ($Team ? 'T' : 'I') . "][WarmDuration][{$Phase}][{$OldDate}][{$OldTime}][{$WarmTime}]' as newDurName,\n\t\t\t\t\t\t\t'Fld[" . ($Team ? 'T' : 'I') . "][Options][{$Phase}][{$OldDate}][{$OldTime}][{$WarmTime}]' as newOptName\n\t\t\t\t\t\t\t" . (isset($Duration) ? ", FwDuration DiDuration" : '') . "\n\t\t\t\t\t\tfrom FinWarmup\n\t\t\t\t\t\twhere FwTournament={$_SESSION['TourId']}\n\t\t\t\t\t\t\tAND FwTeamEvent={$Team}\n\t\t\t\t\t\t\tAND FwDay='{$OldDate}'\n\t\t\t\t\t\t\tAND FwMatchTime='{$OldTime}'\n\t\t\t\t\t\t\tAND FwTime='{$WarmTime}:00'"; $q = safe_r_sql($SQL); return DistanceInfoData(safe_fetch($q)); } } } } return array('error' => 1); }