$html = str_get_html($route_page, true);
$routes = $html->find(".PageHeaderBlack");
$routes = $routes[0];
$routes = $routes->parent()->parent();
$routes = $routes->find("li");
foreach ($routes as $route) {
$link = $route->first_child();
if (!$link->title) {
continue;
}
$route_vals = "('" . mysql_real_escape_string(trim($link->title)) . "','" . mysql_real_escape_string(trim($link->text())) . "','Bus')";
$res = $database->getResult("SELECT *\n\t\t\tFROM routing_route\n\t\t\tWHERE marta_id = '" . mysql_real_escape_string(trim($link->title)) . "'\n\t\t\tAND name = '" . mysql_real_escape_string(trim($link->text())) . "'\n\t\t\tAND type = 'Bus';");
if ($res != null) {
continue;
}
$route_id = $database->getResultInserted("INSERT INTO routing_route\n\t\t\t(marta_id, name, type)\n\t\t\tVALUES {$route_vals};");
loadBusTimes(trim($link->title), $route_id, $database);
}
/************
Load Train Routes
************/
$trainRoutes = array("Red" => "NS-w.aspx", "Blue" => "EW-w.aspx", "Gold" => "NE-w.aspx", "Green" => "PC-w.aspx");
foreach ($trainRoutes as $key => $value) {
$link = $value;
$marta_id = mysql_real_escape_string(strtoupper($key));
$name = mysql_real_escape_string($key . " Line");
$res = $database->getResult("SELECT *\n\t\t\tFROM routing_route\n\t\t\tWHERE marta_id = '{$marta_id}'\n\t\t\tAND name = '{$name}'\n\t\t\tAND type = 'Train';");
if ($res != null) {
continue;
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
$res = curl_exec($ch);
if (!$res) {
trigger_error(curl_error($ch));
}
curl_close($ch);
return $res;
}
echo "";
// Format Array of {"id": #, "short_name": bus_route or line, "name": name}
$bus_routes = json_decode(file_get_contents("http://spice.ridecell.com/get_routes/buses/"), true);
$train_routes = json_decode(file_get_contents("http://spice.ridecell.com/get_routes/trains/"), true);
foreach ($bus_routes as $value) {
if (!$database->getResult("SELECT id FROM Route WHERE id='" . mysql_real_escape_string($value['id']) . "';")) {
$route_vals = "(" . mysql_real_escape_string($value['id']) . ",'" . mysql_real_escape_string($value['short_name']) . "','" . mysql_real_escape_string($value['name']) . "','Bus')";
$database->getResultInserted("INSERT INTO Route\n\t\t\t\t(id, marta_id, route_name, type)\n\t\t\t\tVALUES {$route_vals};");
}
}
foreach ($train_routes as $value) {
if (!$database->getResult("SELECT id FROM Route WHERE id='" . mysql_real_escape_string($value['id']) . "';")) {
$route_vals = "(" . mysql_real_escape_string($value['id']) . ",'" . mysql_real_escape_string($value['short_name']) . "','" . mysql_real_escape_string($value['name']) . "','Train')";
$database->getResultInserted("INSERT INTO Route\n\t\t\t\t(id, marta_id, route_name, type)\n\t\t\t\tVALUES {$route_vals};");
}
}
$routes = $database->getResults("SELECT id FROM Route;");
$head_val = '';
foreach ($routes as $route) {
$headsigns = json_decode(do_post_request("http://spice.ridecell.com/desktop/route_headsigns/", array("route_id" => $route['id'])), true);
$headsigns = $headsigns[1];
foreach ($headsigns as $head) {
if (!$database->getResult("SELECT * \n\t\t\t\tFROM Route_Variation \n\t\t\t\tWHERE route_id='" . mysql_real_escape_string($head['route_id']) . "' \n\t\t\t\tAND direction='" . mysql_real_escape_string($head['direction']) . "' \n\t\t\t\tAND variation_name='" . mysql_real_escape_string($head['headsign']) . "' \n\t\t\t\tAND route_shape_id='" . mysql_real_escape_string($head['shape_id']) . "';")) {
