competition.php | searchcode

/competition.php

http://airscore.googlecode.com/
PHP | 326 lines | 271 code | 39 blank | 16 comment | 23 complexity | 482a74dd066eae12225dcd6e8e84cc19 MD5 | raw file
Possible License(s): GPL-2.0

<html>
<head>
<link HREF="xcstyle.css" REL="stylesheet" TYPE="text/css">
</head>
<body>
<div id="container">
<div id="vhead"><h1>airScore admin</h1></div>
<?php
require 'authorisation.php';
require 'format.php';
$comPk = intval($_REQUEST['comPk']);
adminbar($comPk);

$usePk = auth('system');
$link = db_connect();
$query = "select comName from tblCompetition where comPk=$comPk";
$result = mysql_query($query) or die('Task add failed: ' . mysql_error());
$comName = mysql_result($result,0);

echo "<p><h2><a href=\"comp_result.php?comPk=$comPk\">Competition - $comName</a></h2></p>";

// Add a task
if (array_key_exists('add', $_REQUEST))
{
    $Name = addslashes($_REQUEST['taskname']);
    $Date = addslashes($_REQUEST['date']);
    $TaskStart = addslashes($_REQUEST['taskstart']);
    $TaskFinish = addslashes($_REQUEST['taskfinish']);
    $StartOpen = addslashes($_REQUEST['starttime']);
    $StartClose = addslashes($_REQUEST['startclose']);
    $TaskType = addslashes($_REQUEST['tasktype']);
    $Interval = intval($_REQUEST['interval']);
    $regPk = addslashes($_REQUEST['region']);
    $depart = addslashes($_REQUEST['departure']);
    $arrival = addslashes($_REQUEST['arrival']);

    check_admin('admin',$usePk,$comPk);

    $query = "insert into tblTask (comPk, tasName, tasDate, tasTaskStart, tasFinishTime, tasStartTime, tasStartCloseTime, tasSSInterval, tasTaskType, regPk, tasDeparture, tasArrival) values ($comPk, '$Name', '$Date', '$Date $TaskStart', '$Date $TaskFinish', '$Date $StartOpen', '$Date $StartClose', $Interval, '$TaskType', $regPk, '$depart', '$arrival')";
    $result = mysql_query($query) or die('Task add failed: ' . mysql_error());

    // Get the task we just inserted
    $tasPk = mysql_insert_id();

    // Now check for pre-submitted tracks ..
    // FIX: check for task / track date match!
    // $query = "select traPk from tblComTaskTrack where comPk=$comPk and tasPk is null";
    $query = "select CTT.traPk from tblComTaskTrack CTT, tblTask T, tblTrack TR, tblCompetition C where CTT.comPk=$comPk and C.comPk=CTT.comPk and T.tasPk=$tasPk and CTT.traPk=TR.traPk and CTT.tasPk is null and TR.traStart > date_sub(T.tasDate, interval C.comTimeOffset hour) and TR.traStart < date_add(T.tasDate, interval (24-C.comTimeOffset) hour)";
    $result = mysql_query($query,$link);
    $tracks = array();
    while($row = mysql_fetch_array($result))
    {
        $tracks[] = $row['traPk'];
    }

    if (sizeof($tracks) > 0)
    {
        // Give them a task number 
        $sql = "update tblComTaskTrack set tasPk=$tasPk where comPk=$comPk and traPk in (" . implode(",",$tracks) . ")";
        $result = mysql_query($sql,$link);

        // Now verify the pre-submitted tracks against the task
        foreach ($tracks as $tpk)
        {
            echo "Verifying pre-submitted track: $tpk<br>";
            $out = '';
            $retv = 0;
            exec(BINDIR . "track_verify.pl $tpk", $out, $retv);
        }
    }
}

// Delete a task
if (array_key_exists('delete', $_REQUEST))
{
    $id = intval($_REQUEST['delete']);
    check_admin('admin',$usePk,$comPk);

    if ($id > 0)
    {
        $query = "delete from tblTask where tasPk=$id";
        $result = mysql_query($query) or die('Task delete failed: ' . mysql_error());
    
        $query = "delete from tblComTaskTrack where tasPk=$id";
        $result = mysql_query($query) or die('Task CTT delete failed: ' . mysql_error());
    
        $query = "delete from tblTaskWaypoint where tasPk=$id";
        $result = mysql_query($query) or die('Task TW delete failed: ' . mysql_error());
    
        $query = "delete from tblTaskResult where tasPk=$id";
        $result = mysql_query($query) or die('Task TR delete failed: ' . mysql_error());

        echo "Task Removed\n";
    }
    else
    {
        echo "Unable to remove task: $id\n";
    }
}

// Update the competition
if (array_key_exists('update', $_REQUEST))
{
    check_admin('admin',$usePk,$comPk);

    $comname = addslashes($_REQUEST['comname']);
    $datefrom = addslashes($_REQUEST['datefrom']);
    $dateto = addslashes($_REQUEST['dateto']);
    $location = addslashes($_REQUEST['location']);
    $director = addslashes($_REQUEST['director']);
    $sanction = addslashes($_REQUEST['sanction']);
    $comptype = addslashes($_REQUEST['comptype']);
    $comcode = addslashes($_REQUEST['code']);
    $timeoffset = floatval($_REQUEST['timeoffset']);
    $overallscore = addslashes($_REQUEST['overallscore']);
    $overallparam = floatval($_REQUEST['overallparam']); 
    $teamscoring = addslashes($_REQUEST['teamscoring']);
    $teamsize = intval($_REQUEST['teamsize']);
    $teamover = addslashes($_REQUEST['teamover']);
    $compclass = addslashes($_REQUEST['compclass']);

    $query = "update tblCompetition set comName='$comname', comLocation='$location', comDateFrom='$datefrom', comDateTo='$dateto', comMeetDirName='$director', comTimeOffset=$timeoffset, comType='$comptype', comCode='$comcode', comOverallScore='$overallscore', comOverallParam=$overallparam, comTeamScoring='$teamscoring', comTeamSize=$teamsize, comTeamOver='$teamover', comClass='$compclass' where comPk=$comPk";

    # FIX: re-optimise tracks if change from Free to OLC and vice versa

    $result = mysql_query($query) or die('Competition update failed: ' . mysql_error());
}

// Add/update the formula
if (array_key_exists('upformula', $_REQUEST))
{
    $forPk = intval($_REQUEST['forPk']) + 0;
    $formula = addslashes($_REQUEST['formula']);
    $version = addslashes($_REQUEST['version']);
    $nomdist = floatval($_REQUEST['nomdist']);
    $mindist = floatval($_REQUEST['mindist']);
    $nomtime = floatval($_REQUEST['nomtime']);
    $nomgoal = floatval($_REQUEST['nomgoal']);
    $sspenalty = floatval($_REQUEST['sspenalty']);
    $lineardist = floatval($_REQUEST['lineardist']);
    $diffdist = floatval($_REQUEST['diffdist']);
    $difframp = addslashes($_REQUEST['difframp']);
    $diffcalc = addslashes($_REQUEST['diffcalc']);

    if ($forPk < 1)
    {
        $query = "insert into tblFormula (forClass, forVersion, forNomDistance, forMinDistance, forNomTime, forNomGoal, comPk, forLinearDist, forDiffDist, forDiffRamp, forDiffCalc, forGoalSSPenalty) values ('$formula', '$version', $nomdist, $mindist, $nomtime, $nomgoal, $comPk, $lineardist, $diffdist, '$difframp', '$diffcalc', $sspenalty)";
        $result = mysql_query($query) or die('Formula addition failed: ' . mysql_error());
        $forPk = mysql_insert_id();

        #$query = "select max(forPk) from tblFormula";
        #$result = mysql_query($query) or die('Cant get max forPk: ' . mysql_error());
        #$forPk = mysql_result($result,0,0);

        $query = "update tblCompetition set forPk=$forPk where comPk=$comPk";
        $result = mysql_query($query) or die('Competition formula addition failed: ' . mysql_error());
    }
    else
    {
        $query = "update tblFormula set forClass='$formula', forVersion='$version', forNomDistance=$nomdist, forMinDistance=$mindist, forNomTime=$nomtime, forNomGoal=$nomgoal, forLinearDist=$lineardist, forDiffDist=$diffdist, forDiffRamp='$difframp', forDiffCalc='$diffcalc', forGoalSSPenalty=$sspenalty where comPk=$comPk";
        $result = mysql_query($query) or die('Formula update failed: ' . mysql_error());
    }
}

$forPk = 0;
$sql = "SELECT T.* FROM tblCompetition T where T.comPk=$comPk";
$result = mysql_query($sql,$link);
$row = mysql_fetch_array($result);
if ($row)
{
    echo "<form action=\"competition.php?comPk=$comPk\" name=\"comedit\" method=\"post\">";
    $cname = $row['comName'];
    $cdfrom = substr($row['comDateFrom'],0,10);
    $cdto = substr($row['comDateTo'],0,10);
    $cdirector = $row['comMeetDirName'];
    $clocation = $row['comLocation'];
    $csanction = $row['comSanction'];
    $ctimeoffset = $row['comTimeOffset'];
    $overallscore = $row['comOverallScore'];
    $overallparam = $row['comOverallParam'];
    $teamscoring = $row['comTeamScoring'];
    $teamover = $row['comTeamOver'];
    $teamsize = $row['comTeamSize'];
    $ccode = $row['comCode'];
    $ctype = $row['comType'];
    $forPk = $row['forPk'];
    $restricted = $row['comRestricted'];
    $cclass = $row['comClass'];
    $clocked = $row['comLocked'];

    $out = ftable(
        array(
            array('Name:', fin('comname', $cname, 14), 'Type:', fselect('comptype', $ctype, array('OLC', 'RACE', 'Free', 'Route', 'Team-RACE' )), 'Class:', fselect('compclass', $cclass, array('PG','HG','mixed'))),
            array('Date From:', fin('datefrom', $cdfrom, 10), 'Date To:', fin('dateto', $cdto, 10)),
            array('Director:', fin('director', $cdirector, 14), 'Location:', fin('location', $clocation, 10)),
            array('Abbrev:', fin('code', $ccode, 10), 'Time Offset:', fin('timeoffset', $ctimeoffset, 10)),
            array('Scoring:', fselect('overallscore', $overallscore, array('all', 'ftv', 'round', 'round-perc' )), 'Score param:', fin('overallparam', $overallparam, 10)),
            array('Team Scoring:', fselect('teamscoring', $teamscoring, array('aggregate', 'team-gap', 'handicap')), 'Team Over:', fselect('teamover', $teamover, array('best', 'selected')), 'Team Size:', fin('teamsize', $teamsize, 4))
        ), '', '', ''
    );

    echo $out;
    echo fis('update', 'Update Competition', '');
    echo "</form>\n";
}
// Formula
$version = 0;
if ($ctype == 'RACE' || $ctype == 'Team-RACE')
{
    $sql = "SELECT F.* FROM tblFormula F where F.comPk=$comPk";
    $result = mysql_query($sql,$link);
    $row = mysql_fetch_array($result);
    if ($row)
    {
        $class = $row['forClass'];
        $version = $row['forVersion'];
        $nomdist = $row['forNomDistance'];
        $mindist = $row['forMinDistance'];
        $nomtime = $row['forNomTime'];
        $nomgoal = $row['forNomGoal'];
        $sspenalty = $row['forGoalSSpenalty'];
        $lineardist = $row['forLinearDist'];
        $diffdist = $row['forDiffDist'];
        $difframp = $row['forDiffRamp'];
        $diffcalc = $row['forDiffCalc'];
    }
    echo "<hr><h3>RACE Formula</h3>";
    echo "<form action=\"competition.php?comPk=$comPk\" name=\"formulaadmin\" method=\"post\">";
    $out = ftable(
        array(
          array('Formula:', fselect('formula', $class, array('gap', 'ozgap', 'pwd', 'sahpa', 'nzl', 'ggap', 'nogap' )), 'Year:', fin('version', $version, 4)),
          array('Nom Dist (km):', fin('nomdist',$nomdist,4), 'Min Dist (km):', fin('mindist', $mindist, 4), 'Nom Goal (%):', fin('nomgoal',$nomgoal,4)),
          array('Nom Time (min):', fin('nomtime', $nomtime, 4), 'Goal/SS Penalty (0-1):', fin('sspenalty', $sspenalty, 4)),
          array('Linear Dist (0-1):', fin('lineardist', $lineardist, 4),'Diff Dist (km):', fin('diffdist', $diffdist, 4), 'Diff Ramp:', fselect('difframp', $difframp, array('fixed', 'flexible')), 'Diff Calc:', fselect('diffcalc', $diffcalc, array('all', 'lo')))
        ), '', '', ''
      );
    echo $out;
    echo "<input type=\"hidden\" name=\"forPk\" value=\"$forPk\">";
    echo "<input type=\"submit\" name=\"upformula\" value=\"Update Formula\">";
    echo "</form>";
}


if ($ctype == 'RACE' || $ctype == 'Team-RACE' || $ctype == 'Route')
{
// Tasks
echo "<hr><h3>Tasks</h3><form action=\"competition.php?comPk=$comPk\" name=\"taskadmin\" method=\"post\">";
echo "<ol>";
$count = 1;
$sql = "SELECT T.*, count(*) as Tadded FROM tblTask T left outer join tblComTaskTrack CTT on CTT.tasPk=T.tasPk where T.comPk=$comPk group by T.tasPk order by T.tasDate";
$result = mysql_query($sql,$link);

while($row = mysql_fetch_array($result))
{
    $tasPk = $row['tasPk'];
    $tasDate = $row['tasDate'];
    $tasName = $row['tasName'];
    $tasDistance = $row['tasDistance'];
    $tasTaskStart = $row['tasTaskStart'];
    $tasStartTime = $row['tasStartTime'];
    $tasFinishTime = $row['tasFinishTime'];
    $tasResultsType = $row['tasResultsType'];
    $tasTaskType = $row['tasTaskType'];
    $tasDistance = $row['tasDistance'];
    $tasSSDistance = $row['tasSSDistance'];
    $tasSSOpen = $row['tasSSOpen'];
    $tasSSClose = $row['tasSSClose'];
    $tasESClose = $row['tasESClose'];
    $tasDistFlown = $row['tasTotalDistanceFlown'];

    echo "<li>";
    if ($row['Tadded'] < 2)
    {
        echo "<button type=\"submit\" name=\"delete\" value=\"$tasPk\">del</button>";
    }
    echo "<a href=\"task.php?comPk=$comPk&tasPk=$tasPk\">$tasName: " . round($tasDistance/1000,1) . " kms on " . $tasDate . " (" . substr($tasTaskStart,11) . " - " . substr($tasFinishTime,11) . ")</a></li>\n";

    $count++;
}
echo "</ol>";

$sql = "SELECT * FROM tblRegion R";
$result = mysql_query($sql,$link);
$regions = array();
while ($row = mysql_fetch_array($result))
{
    $regPk = $row['regPk'];
    $regDesc = $row['regDescription'];
    $regions[$regDesc] = $regPk;
}

$sql = "SELECT T.* FROM tblCompetition C, tblTask T where T.comPk=C.comPk and C.comPk=$comPk order by T.tasPk limit 1";
$result = mysql_query($sql,$link);
$defregion = '';
if (mysql_num_rows($result) > 0)
{
    $row = mysql_fetch_array($result);
    $defregion = $row['regPk'];
}


echo "<hr>";
$depdef = 'on';
if ($version > 2000)
{
   $depdef = 'leadout'; 
}
$out = ftable(
    array(
        array('Task Name:', fin('taskname', '', 10), 'Date:', fin('date', '', 10)),
        array('Region:', fselect('region', $defregion, $regions), 'Task Type:', fselect('tasktype', 'race', array('olc', 'race', 'speedrun', 'speedrun-interval', 'free', 'free-bearing', 'airgain', 'aat'))),
        array('Task Start:', fin('taskstart', '', 10), 'Task Finish:', fin('taskfinish', '', 10)), 
        array('Start Open:', fin('starttime', '', 10), 'Start Close:', fin('startclose', '', 10), 'Gate Interval:', fin('interval', '', 4)), 
        array('Depart Bonus:', fselect('departure', $depdef, array('on', 'off', 'leadout')), 'Arrival Bonus:', fselect('arrival', 'on', array('on', 'off')))
    ), '', '', '');

echo $out;
echo "<input type=\"submit\" name=\"add\" value=\"Add Task\">";

echo "</form>";
}
?>
</div>
</body>
</html>