<!-- /lib/tmphpfuncs.php: common PHP functionality for Travel Mapping -->
<!-- mysqli connecting to database TravelMapping on localhost -->
<!-- /lib/tmphpfuncs.php END -->

function waypointsFromSQL() {
    routeInfo[0] = { firstWaypoint: 0, root: "al.al152", tier: 3, color: "TMteal", system: "usansf", label: "AL AL152" };
routeInfo[1] = { firstWaypoint: 7, root: "al.al158", tier: 3, color: "TMteal", system: "usansf", label: "AL AL158" };
routeInfo[2] = { firstWaypoint: 14, root: "al.al255", tier: 3, color: "TMteal", system: "usansf", label: "AL AL255" };
routeInfo[3] = { firstWaypoint: 27, root: "al.al759", tier: 3, color: "TMteal", system: "usansf", label: "AL AL759" };
routeInfo[4] = { firstWaypoint: 30, root: "ms.ms067", tier: 3, color: "TMteal", system: "usansf", label: "MS MS67" };
waypoints = [
new Waypoint("I-65",32.389298,-86.32341),
new Waypoint("LouSt",32.395653,-86.316104),
new Waypoint("6thSt",32.403426,-86.309216),
new Waypoint("JacFerRd",32.411052,-86.302886),
new Waypoint("LowWetRd",32.42433,-86.283982),
new Waypoint("ColBlvd",32.4227,-86.268511),
new Waypoint("US231",32.421119,-86.229463),
new Waypoint("NewRd",30.806934,-88.225955),
new Waypoint("US45",30.802571,-88.150901),
new Waypoint("ColPkwy",30.802911,-88.125613),
new Waypoint("AL213_S",30.802137,-88.106988),
new Waypoint("I-65",30.802133,-88.104472),
new Waypoint("AL213_N",30.802207,-88.100905),
new Waypoint("US43",30.795032,-88.072248),
new Waypoint("RidRd",34.700841,-86.671373),
new Waypoint("I-565",34.706861,-86.671239),
new Waypoint("OldMadPike",34.713255,-86.6711),
new Waypoint("BraDr",34.728087,-86.670241),
new Waypoint("US72",34.742049,-86.670059),
new Waypoint("OakRd",34.757039,-86.672527),
new Waypoint("PluRd",34.7716,-86.672773),
new Waypoint("DanTibRd",34.778958,-86.672698),
new Waypoint("BlaBotRd",34.78621,-86.672258),
new Waypoint("AL53",34.791154,-86.667286),
new Waypoint("+x01",34.799127,-86.654406),
new Waypoint("PulPike",34.822127,-86.642733),
new Waypoint("BobWadeLn",34.823351,-86.626339),
new Waypoint("I-759",33.992748,-86.004442),
new Waypoint("+x01",33.995537,-85.995398),
new Waypoint("AL291",34.000171,-85.993547),
new Waypoint("I-10/110",30.45327,-88.896088),
new Waypoint("SanBlvd",30.457848,-88.898921),
new Waypoint("OldMS67_S",30.470055,-88.908148),
new Waypoint("MS15_N",30.485885,-88.912439),
new Waypoint("+x01",30.498523,-88.919553),
new Waypoint("BigJohnRd",30.510609,-88.936971),
new Waypoint("OldWooRd",30.524081,-88.984752),
new Waypoint("MS605",30.55335,-89.026331),
new Waypoint("TraPkwy",30.572266,-89.047483),
new Waypoint("WorRd",30.587922,-89.05745),
new Waypoint("+x02",30.613022,-89.104314),
new Waypoint("BetRd",30.637506,-89.115365),
new Waypoint("US49",30.653816,-89.133818)
];
traveler = '';
segments = [
505499,
505500,
505501,
505502,
505503,
505504,
505505,
505506,
505507,
505508,
505509,
505510,
505511,
505512,
505513,
505514,
505515,
505516,
505517,
505518,
505519,
505520,
505521,
505522,
505523,
505524,
505525,
505526,
505527,
505528,
505529,
505530,
505531,
505532,
505533,
505534,
505535,
505536
];
clinched = [
];
mapClinched = true;
mapStatus = mapStates.MAPVIEW;
genEdges = true;
}