$results = calculateResult($res, $nb_radio);
}
/*else*/
if ($arr_radio != null) {
$rid = implode(', ', $arr_radio);
$sql = "SELECT cmp.id AS id, cmp.name AS name, org.name AS team, radio.ctrl, radio.timestamp, radio.rt AS time, 1 AS status " . "FROM mopradio AS radio, mopcompetitor AS cmp " . "LEFT JOIN moporganization AS org ON cmp.org = org.id AND cmp.cid = org.cid " . "WHERE radio.ctrl IN(" . $rid . ") " . "AND radio.id=cmp.id " . "AND cmp.cls='{$cls}' " . "AND cmp.cid = '{$cmpId}' AND radio.cid = '{$cmpId}' " . "ORDER BY radio.id ASC, radio.rt ASC ";
$res = mysql_query($sql);
$results = addRadioResult($res, $results);
}
formatResultScreen($results, $limit);
}
} else {
// Single leg (patrol etc)
if ($radio != '') {
if ($radio == 'finish') {
$sql = "SELECT t.id AS id, cmp.name AS name, cmp.timestamp, t.name AS team, t.rt AS time, t.stat AS status " . "FROM mopteammember tm, mopcompetitor cmp, mopteam t " . "WHERE t.cls = '{$cls}' AND t.id = tm.id AND tm.rid = cmp.id AND tm.leg=1 " . "AND t.cid = '{$cmpId}' AND tm.cid = '{$cmpId}' AND cmp.cid = '{$cmpId}' " . "AND ((t.stat>0) OR ((t.stat=0) AND ((SELECT COUNT(*) FROM mopradio AS mr WHERE mr.cid='{$cmpId}' AND tm.rid=mr.id) > 0)))" . "ORDER BY t.stat ASC, t.rt ASC, t.id";
$rname = "Finish";
$res = mysql_query($sql);
$results = calculateResult($res, $nb_radio);
}
/*else*/
if ($arr_radio != null) {
$rid = implode(', ', $arr_radio);
$sql = "SELECT team.id AS id, cmp.name AS name, team.name AS team, radio.rt AS time, radio.timestamp, 1 AS status " . "FROM mopradio AS radio, mopteammember AS m, mopteam AS team, mopcompetitor AS cmp " . "WHERE radio.ctrl IN(" . $rid . ") " . "AND radio.id=cmp.id " . "AND m.rid = radio.id " . "AND m.id = team.id " . "AND m.leg=1 " . "AND cmp.cls='{$cls}' " . "AND radio.cid = '{$cmpId}' AND m.cid = '{$cmpId}' AND team.cid = '{$cmpId}' AND cmp.cid = '{$cmpId}' " . "ORDER BY radio.id ASC, radio.rt ASC ";
$res = mysql_query($sql);
$results = addRadioResult($res, $results);
}
formatResultScreen($results, $limit);
}
}
}
} else {
// Single leg (patrol etc)
$radio = selectRadio($cls);
if ($radio != '') {
if ($radio == 'finish') {
$sql = "SELECT t.id AS id, cmp.name AS name, t.name AS team, t.rt AS time, t.stat AS status " . "FROM mopteammember tm, mopcompetitor cmp, mopteam t " . "WHERE t.cls = '{$cls}' AND t.id = tm.id AND tm.rid = cmp.id AND tm.leg=1 " . "AND t.cid = '{$cmpId}' AND tm.cid = '{$cmpId}' AND cmp.cid = '{$cmpId}' AND t.stat>0 ORDER BY t.stat, t.rt ASC, t.id";
$rname = $lang["finish"];
} else {
$rid = (int) $radio;
$sql = "SELECT name FROM mopcontrol WHERE cid='{$cmpId}' AND id='{$rid}'";
$res = mysql_query($sql);
$rinfo = mysql_fetch_array($res);
$rname = $rinfo['name'];
$sql = "SELECT team.id AS id, cmp.name AS name, team.name AS team, radio.rt AS time, 1 AS status " . "FROM mopradio AS radio, mopteammember AS m, mopteam AS team, mopcompetitor AS cmp " . "WHERE radio.ctrl='{$rid}' " . "AND radio.id=cmp.id " . "AND m.rid = radio.id " . "AND m.id = team.id " . "AND cmp.stat<=1 " . "AND m.leg=1 " . "AND cmp.cls='{$cls}' " . "AND radio.cid = '{$cmpId}' AND m.cid = '{$cmpId}' AND team.cid = '{$cmpId}' AND cmp.cid = '{$cmpId}' " . "ORDER BY radio.rt ASC ";
}
$res = mysql_query($sql);
$results = calculateResult($res);
print "<h3>{$rname}</h3>\n";
formatResult($results);
}
}
}
}
print '</div>';
?>
<div style="clear:both;padding-top:3em;color: grey;">
Results provided by <a href="http://www.melin.nu/meos" target="_blank">MeOS Online Results</a>.
</div>
</body></html>
