<!-- /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: "dc.beadr", tier: 4, color: "TMbrown", system: "usanp", label: "DC BeaDr" };
routeInfo[1] = { firstWaypoint: 7, root: "dc.clabarpkwy", tier: 4, color: "TMbrown", system: "usanp", label: "DC ClaBarPkwy" };
routeInfo[2] = { firstWaypoint: 9, root: "dc.dc295", tier: 4, color: "TMbrown", system: "usadc", label: "DC DC295" };
routeInfo[3] = { firstWaypoint: 16, root: "dc.gwmempkwy", tier: 4, color: "TMbrown", system: "usanp", label: "DC GWMemPkwy" };
routeInfo[4] = { firstWaypoint: 21, root: "dc.rockcrkpkwy", tier: 4, color: "TMbrown", system: "usanp", label: "DC RockCrkPkwy" };
routeInfo[5] = { firstWaypoint: 34, root: "dc.suipkwy", tier: 4, color: "TMbrown", system: "usanp", label: "DC SuiPkwy" };
routeInfo[6] = { firstWaypoint: 40, root: "dc.us001altwas", tier: 3, color: "TMmagenta", system: "usausb", label: "DC US1AltWas" };
routeInfo[7] = { firstWaypoint: 47, root: "dc.us001", tier: 2, color: "TMred", system: "usaus", label: "DC US1" };
routeInfo[8] = { firstWaypoint: 58, root: "dc.us029", tier: 2, color: "TMred", system: "usaus", label: "DC US29" };
routeInfo[9] = { firstWaypoint: 74, root: "dc.us050", tier: 2, color: "TMred", system: "usaus", label: "DC US50" };
routeInfo[10] = { firstWaypoint: 89, root: "dc.i066", tier: 1, color: "TMblue", system: "usai", label: "DC I-66" };
routeInfo[11] = { firstWaypoint: 94, root: "dc.i095", tier: 1, color: "TMblue", system: "usai", label: "DC I-95" };
routeInfo[12] = { firstWaypoint: 96, root: "dc.i295", tier: 1, color: "TMblue", system: "usai", label: "DC I-295" };
routeInfo[13] = { firstWaypoint: 101, root: "dc.i395", tier: 1, color: "TMblue", system: "usai", label: "DC I-395" };
routeInfo[14] = { firstWaypoint: 112, root: "dc.i495", tier: 1, color: "TMblue", system: "usai", label: "DC I-495" };
routeInfo[15] = { firstWaypoint: 114, root: "dc.i695", tier: 1, color: "TMblue", system: "usai", label: "DC I-695" };
waypoints = [
new Waypoint("RockCrkPkwy",38.920742,-77.051406),
new Waypoint("HarSt",38.928025,-77.043836),
new Waypoint("PorSt",38.933984,-77.048471),
new Waypoint("PinBraPkwy",38.935027,-77.04772),
new Waypoint("TilSt",38.939484,-77.05126),
new Waypoint("BlaAve",38.943356,-77.049565),
new Waypoint("BroBraRd",38.94419,-77.04963),
new Waypoint("MD/DC",38.936897,-77.116706),
new Waypoint("ChaBriRd",38.930354,-77.111793),
new Waypoint("1A",38.869618,-76.987634),
new Waypoint("1B",38.875198,-76.974592),
new Waypoint("ECapSt",38.889764,-76.958477),
new Waypoint("BenRd",38.895575,-76.95204),
new Waypoint("NHBurAve",38.902397,-76.943741),
new Waypoint("NashSt",38.907536,-76.938238),
new Waypoint("DC/MD",38.912265,-76.934123),
new Waypoint("VA/DC",38.875265,-77.04699),
new Waypoint("WasBlvd",38.882982,-77.057934),
new Waypoint("ArlMemBr",38.885738,-77.059865),
new Waypoint("US50",38.889279,-77.063835),
new Waypoint("DC/VA",38.88978,-77.064328),
new Waypoint("LinMemCir",38.889667,-77.051282),
new Waypoint("OhioDr",38.892223,-77.054914),
new Waypoint("FSt",38.897675,-77.0564),
new Waypoint("VirAve",38.900919,-77.057183),
new Waypoint("US29",38.902543,-77.056915),
new Waypoint("PenAve",38.904643,-77.05626),
new Waypoint("PSt",38.909636,-77.050424),
new Waypoint("WatDr_S",38.913059,-77.054393),
new Waypoint("+X954875",38.916815,-77.058449),
new Waypoint("WatDr_N",38.918702,-77.055337),
new Waypoint("BeaDr",38.920742,-77.051406),
new Waypoint("CatAve",38.921815,-77.05125),
new Waypoint("CalSt",38.923476,-77.052612),
new Waypoint("SouCapSt",38.865475,-77.002165),
new Waypoint("I-295",38.863011,-76.99936),
new Waypoint("MLKAve",38.860596,-76.994312),
new Waypoint("StaRd",38.853261,-76.983283),
new Waypoint("AlaAve",38.851189,-76.972747),
new Waypoint("DC/MD",38.849067,-76.965601),
new Waypoint("US1_S",38.903583,-77.0199),
new Waypoint("I-395",38.90491,-77.016081),
new Waypoint("NorCapSt",38.907348,-77.009056),
new Waypoint("MouOliRd",38.913601,-76.991125),
new Waypoint("US50_E",38.917335,-76.972468),
new Waypoint("SouDakAve",38.925177,-76.965145),
new Waypoint("DC/MD",38.930737,-76.957747),
new Waypoint("VA/DC",38.873929,-77.043343),
new Waypoint("I-395(1)",38.879249,-77.036197),
new Waypoint("MaiAve",38.883508,-77.03216),
new Waypoint("US50_W",38.8921,-77.032858),
new Waypoint("ConAve_E",38.892072,-77.019911),
new Waypoint("US50_E",38.903583,-77.0199),
new Waypoint("RhoIslAve_W",38.913023,-77.0199),
new Waypoint("NorCapSt",38.916792,-77.009045),
new Waypoint("MonAve",38.924568,-76.985605),
new Waypoint("SouDakAve",38.931278,-76.971569),
new Waypoint("DC/MD",38.935182,-76.963407),
new Waypoint("VA/DC",38.901153,-77.070508),
new Waypoint("MSt",38.904159,-77.069027),
new Waypoint("I-66",38.902543,-77.056915),
new Waypoint("NewHamAve_S",38.902539,-77.050123),
new Waypoint("17thSt",38.902539,-77.039426),
new Waypoint("15thSt",38.902531,-77.033643),
new Waypoint("11thSt_S",38.902522,-77.027045),
new Waypoint("11thSt_N",38.910537,-77.027056),
new Waypoint("RhoIslAve_E",38.912687,-77.020874),
new Waypoint("FloAve",38.916264,-77.021901),
new Waypoint("ColRd",38.927691,-77.023033),
new Waypoint("NewHamAve_N",38.936346,-77.024291),
new Waypoint("ArkAve",38.951533,-77.027389),
new Waypoint("MisAve",38.961129,-77.028024),
new Waypoint("PinBraRd",38.967526,-77.027486),
new Waypoint("DC/MD",38.98455,-77.026625),
new Waypoint("VA/DC",38.891751,-77.064532),
new Waypoint("I-66_W",38.891751,-77.062998),
new Waypoint("I-66_E",38.893471,-77.053385),
new Waypoint("23rdSt",38.892087,-77.050166),
new Waypoint("17thSt",38.892098,-77.039483),
new Waypoint("US1_S",38.8921,-77.032858),
new Waypoint("ConAve_E",38.892072,-77.019911),
new Waypoint("US1_N",38.903583,-77.0199),
new Waypoint("I-395",38.90491,-77.016081),
new Waypoint("NorCapSt",38.907348,-77.009056),
new Waypoint("MouOliRd",38.913601,-76.991125),
new Waypoint("US1Alt_N",38.917335,-76.972468),
new Waypoint("36thPl",38.916928,-76.957968),
new Waypoint("SouDakAve",38.918265,-76.954985),
new Waypoint("DC/MD",38.918103,-76.941395),
new Waypoint("VA/DC",38.89175,-77.064531),
new Waypoint("US50_W",38.891751,-77.062998),
new Waypoint("US50_E",38.893471,-77.053385),
new Waypoint("EStExpy",38.895909,-77.053256),
new Waypoint("US29",38.902543,-77.056915),
new Waypoint("VA/DC",38.792671,-77.038968),
new Waypoint("DC/MD",38.792685,-77.037579),
new Waypoint("MD/DC",38.804592,-77.022362),
new Waypoint("1",38.825901,-77.016692),
new Waypoint("2",38.845073,-77.007374),
new Waypoint("3",38.863011,-76.99936),
new Waypoint("5",38.869618,-76.987634),
new Waypoint("VA/DC",38.873929,-77.043343),
new Waypoint("1",38.879249,-77.036197),
new Waypoint("2",38.880068,-77.031402),
new Waypoint("3",38.882239,-77.02785),
new Waypoint("4",38.882402,-77.024009),
new Waypoint("5",38.882482,-77.021901),
new Waypoint("7",38.882386,-77.01247),
new Waypoint("8",38.885003,-77.012502),
new Waypoint("9",38.894799,-77.014144),
new Waypoint("10",38.899466,-77.014166),
new Waypoint("US50",38.90491,-77.016081),
new Waypoint("VA/DC",38.792671,-77.038968),
new Waypoint("DC/MD",38.792685,-77.037579),
new Waypoint("I-395",38.882386,-77.01247),
new Waypoint("1A",38.881617,-77.009102),
new Waypoint("1B",38.879604,-76.998742),
new Waypoint("1C",38.877892,-76.991539),
new Waypoint("2",38.876497,-76.990873),
new Waypoint("2A",38.869618,-76.987634)
];
traveler = 'froggie';
segments = [
587922,
587923,
587924,
587925,
587926,
587927,
587106,
606931,
606932,
606933,
606934,
606935,
606936,
587381,
587382,
587383,
587384,
587928,
587929,
587930,
587931,
587932,
587933,
587934,
587935,
587936,
587937,
587938,
587939,
588025,
588026,
588027,
588028,
588029,
579575,
579576,
579577,
579578,
579579,
579580,
507544,
507545,
507546,
507547,
507548,
507549,
507550,
507551,
507552,
507553,
524608,
524609,
524610,
524611,
524612,
524613,
524614,
524615,
524616,
524617,
524618,
524619,
524620,
524621,
524622,
534029,
534030,
534031,
534032,
534033,
534034,
534035,
534036,
534037,
534038,
534039,
534040,
534041,
534042,
489336,
489337,
489338,
489339,
498450,
500838,
500839,
500840,
500841,
501285,
501286,
501287,
501288,
501289,
501290,
501291,
501292,
501293,
501294,
502055,
503025,
503026,
503027,
503028,
503029
];
clinched = [
587922,
587923,
587924,
587925,
587926,
587927,
587106,
606931,
606932,
606933,
606934,
606935,
606936,
587381,
587382,
587383,
587384,
587928,
587929,
587930,
587931,
587932,
587933,
587934,
587935,
587936,
587937,
587938,
587939,
588025,
588026,
588027,
588028,
588029,
579575,
579576,
579577,
579578,
579579,
579580,
507544,
507545,
507546,
507547,
507548,
507549,
507550,
507551,
507552,
507553,
524608,
524609,
524610,
524611,
524612,
524613,
524614,
524615,
524616,
524617,
524618,
524619,
524620,
524621,
524622,
534029,
534030,
534031,
534032,
534033,
534034,
534035,
534036,
534037,
534038,
534039,
534040,
534041,
534042,
489336,
489337,
489338,
489339,
498450,
500838,
500839,
500840,
500841,
501285,
501286,
501287,
501288,
501289,
501290,
501291,
501292,
501293,
501294,
502055,
503025,
503026,
503027,
503028,
503029
];
mapClinched = true;
mapStatus = mapStates.MAPVIEW;
genEdges = true;
}