コード例 #1
0
ファイル: AjaxDelete.php プロジェクト: brian-nelson/ianseo
<?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();
コード例 #2
0
ファイル: LibScheduler.php プロジェクト: brian-nelson/ianseo
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);
}