All pastes #502636 Raw Edit

Mine

public text v1 · immutable
·published 2007-05-22 15:57 UTC
rendered paste body
function 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;
	}
}