rendered paste bodyfunction getEventData($eventStructure) {
foreach($eventStructure as $eventKey=>$eventValue) {
if (!isset($eventSelectionClause[$eventValue['sport_key']])) {
$eventSelectionClause[$eventValue['sport_key']] = '(0';
}
$eventSelectionClause[$eventValue['sport_key']] .= " OR events.event_key = '" . $eventValue['event_key'] . "'\n";
}
foreach($eventSelectionClause as $eventKey=>$eventValue) {
$eventSelectionClause[$eventKey] .= ')';
}
// baseball
if (isset($eventSelectionClause[15007000])) {
$eventDataQuery = <<<STRINGBLOCK
SELECT
events.event_key,
events.start_date_time,
events.event_status,
baseball_event_states.inning_value,
baseball_event_states.inning_half,
baseball_event_states.outs,
baseball_event_states.runner_on_first_id,
baseball_event_states.runner_on_second_id,
baseball_event_states.runner_on_third_id,
baseball_event_states.runner_on_first,
baseball_event_states.runner_on_second,
baseball_event_states.runner_on_third,
baseball_event_states.pitcher_id
FROM
events, baseball_event_states
WHERE
$eventSelectionClause[15007000]
AND baseball_event_states.event_id = events.id
AND baseball_event_states.current_state = '1'
LIMIT 0, 30;
STRINGBLOCK;
// echo "<p>$eventDataQuery</p>";
$conn = dbOpen();
$eventDataResult = mysql_query($eventDataQuery, $conn);
while ($theRow = mysql_fetch_assoc($eventDataResult)) {
$eventData[$theRow['event_key']]['event_key'] = $theRow['event_key'];
$eventData[$theRow['event_key']]['start_date_time'] = $theRow['start_date_time'];
$eventData[$theRow['event_key']]['event_status'] = $theRow['event_status'];
$eventData[$theRow['event_key']]['inning_value'] = $theRow['inning_value'];
$eventData[$theRow['event_key']]['inning_half'] = $theRow['inning_half'];
$eventData[$theRow['event_key']]['outs'] = $theRow['outs'];
$eventData[$theRow['event_key']]['runner_on_first'] = $theRow['runner_on_first'];
$eventData[$theRow['event_key']]['runner_on_second'] = $theRow['runner_on_second'];
$eventData[$theRow['event_key']]['runner_on_third'] = $theRow['runner_on_third'];
$eventData[$theRow['event_key']]['runner_on_first_id'] = $theRow['runner_on_first_id'];
$eventData[$theRow['event_key']]['runner_on_second_id'] = $theRow['runner_on_second_id'];
$eventData[$theRow['event_key']]['runner_on_third_id'] = $theRow['runner_on_third_id'];
$eventData[$theRow['event_key']]['pitcher_id'] = $theRow['pitcher_id'];
/* Get the players names into the structure (?)
if ($eventData[$theRow['event_key']]['runner_on_first']) {
$eventData[$theRow['event_key']]['runner_on_first_name'] = $player_name[$eventData[$theRow['event_key']]['runner_on_first_id']];
}
else {
$eventData[$theRow['event_key']]['runner_on_first_name'] = "";
}
if ($eventData[$theRow['event_key']]['runner_on_second']) {
$eventData[$theRow['event_key']]['runner_on_second_name'] = $player_name[$eventData[$theRow['event_key']]['runner_on_second_id']];
}
else {
$eventData[$theRow['event_key']]['runner_on_second_name'] = "";
}
if ($eventData[$theRow['event_key']]['runner_on_third']) {
$eventData[$theRow['event_key']]['runner_on_third_name'] = $player_name[$eventData[$theRow['event_key']]['runner_on_third_id']];
}
else {
$eventData[$theRow['event_key']]['runner_on_third_name'] = "";
}
*/
}
dbClose($conn);
}
// basketball
if (isset($eventSelectionClause[15008000])) {
$eventDataQuery = <<<STRINGBLOCK
SELECT
events.event_key,
events.start_date_time,
events.event_status,
basketball_event_states.period_value,
basketball_event_states.period_time_remaining
FROM
events,
basketball_event_states
WHERE
$eventSelectionClause[15008000]
AND basketball_event_states.event_id = events.id
AND basketball_event_states.current_state = '1'
LIMIT 0, 30;
STRINGBLOCK;
$conn = dbOpen();
$eventDataResult = mysql_query($eventDataQuery, $conn);
while ($theRow = mysql_fetch_assoc($eventDataResult)) {
$eventData[$theRow['event_key']]['event_key'] = $theRow['event_key'];
$eventData[$theRow['event_key']]['start_date_time'] = $theRow['start_date_time'];
$eventData[$theRow['event_key']]['event_status'] = $theRow['event_status'];
$eventData[$theRow['event_key']]['period_value'] = $theRow['period_value'];
$eventData[$theRow['event_key']]['period_time_remaining'] = $theRow['period_time_remaining'];
}
dbClose($conn);
}
// ice-hockey
if (isset($eventSelectionClause[15031000])) {
$eventDataQuery = <<<STRINGBLOCK
SELECT
events.event_key,
events.start_date_time,
events.event_status,
ice_hockey_event_states.period_value,
ice_hockey_event_states.period_time_remaining
FROM
events,
ice_hockey_event_states
WHERE
$eventSelectionClause[15031000]
AND ice_hockey_event_states.event_id = events.id
AND ice_hockey_event_states.current_state = '1'
LIMIT 0, 30;
STRINGBLOCK;
$conn = dbOpen();
$eventDataResult = mysql_query($eventDataQuery, $conn);
while ($theRow = mysql_fetch_assoc($eventDataResult)) {
$eventData[$theRow['event_key']]['event_key'] = $theRow['event_key'];
$eventData[$theRow['event_key']]['start_date_time'] = $theRow['start_date_time'];
$eventData[$theRow['event_key']]['event_status'] = $theRow['event_status'];
$eventData[$theRow['event_key']]['period_value'] = $theRow['period_value'];
$eventData[$theRow['event_key']]['period_time_remaining'] = $theRow['period_time_remaining'];
}
dbClose($conn);
}
if (isset($eventData)) {
return $eventData;
}
else {
return NULL;
}
}