<!-- /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: "ny.baypkwy", tier: 2, color: "TMteal", system: "usanyp", label: "NY BayPkwy" };
routeInfo[1] = { firstWaypoint: 3, root: "ny.bearmtnpkwy", tier: 2, color: "TMteal", system: "usanyp", label: "NY BearMtnPkwy" };
routeInfo[2] = { firstWaypoint: 10, root: "ny.bearmtnpkwyyor", tier: 2, color: "TMteal", system: "usanyp", label: "NY BearMtnPkwyYor" };
routeInfo[3] = { firstWaypoint: 12, root: "ny.betstapkwy", tier: 2, color: "TMteal", system: "usanyp", label: "NY BetStaPkwy" };
routeInfo[4] = { firstWaypoint: 17, root: "ny.crobaypkwy", tier: 2, color: "TMteal", system: "usanyp", label: "NY CroBayPkwy" };
routeInfo[5] = { firstWaypoint: 19, root: "ny.jacrobpkwy", tier: 2, color: "TMteal", system: "usanyp", label: "NY JacRobPkwy" };
routeInfo[6] = { firstWaypoint: 27, root: "ny.korwarpkwy", tier: 2, color: "TMteal", system: "usanyp", label: "NY KorWarPkwy" };
routeInfo[7] = { firstWaypoint: 33, root: "ny.lakeontpkwysprcar", tier: 2, color: "TMteal", system: "usanyp", label: "NY LakeOntPkwySprCar" };
routeInfo[8] = { firstWaypoint: 36, root: "ny.lakeweldr", tier: 2, color: "TMteal", system: "usanyp", label: "NY LakeWelDr" };
routeInfo[9] = { firstWaypoint: 41, root: "ny.looppkwy", tier: 2, color: "TMteal", system: "usanyp", label: "NY LoopPkwy" };
routeInfo[10] = { firstWaypoint: 44, root: "ny.mospkwy", tier: 2, color: "TMteal", system: "usanyp", label: "NY MosPkwy" };
routeInfo[11] = { firstWaypoint: 49, root: "ny.niascepkwy", tier: 2, color: "TMteal", system: "usanyp", label: "NY NiaScePkwy" };
routeInfo[12] = { firstWaypoint: 61, root: "ny.niascepkwynia", tier: 2, color: "TMteal", system: "usanyp", label: "NY NiaScePkwyNia" };
routeInfo[13] = { firstWaypoint: 64, root: "ny.niascepkwysprpor", tier: 2, color: "TMteal", system: "usanyp", label: "NY NiaScePkwySprPor" };
routeInfo[14] = { firstWaypoint: 67, root: "ny.ocepkwy", tier: 2, color: "TMteal", system: "usanyp", label: "NY OcePkwy" };
routeInfo[15] = { firstWaypoint: 76, root: "ny.ocepkwybro", tier: 2, color: "TMteal", system: "usanyp", label: "NY OcePkwyBro" };
routeInfo[16] = { firstWaypoint: 85, root: "ny.pelpkwy", tier: 2, color: "TMteal", system: "usanyp", label: "NY PelPkwy" };
routeInfo[17] = { firstWaypoint: 90, root: "ny.promtnhwy", tier: 2, color: "TMteal", system: "usanyp", label: "NY ProMtnHwy" };
routeInfo[18] = { firstWaypoint: 100, root: "ny.sevlakdr", tier: 2, color: "TMteal", system: "usanyp", label: "NY SevLakDr" };
routeInfo[19] = { firstWaypoint: 112, root: "ny.shofropkwy", tier: 2, color: "TMteal", system: "usanyp", label: "NY ShoFroPkwy" };
routeInfo[20] = { firstWaypoint: 115, root: "ny.soupkwy", tier: 2, color: "TMteal", system: "usanyp", label: "NY SouPkwy" };
waypoints = [
new Waypoint("OcePkwy",40.593621,-73.537931),
new Waypoint("+x1",40.597792,-73.531837),
new Waypoint("WanStaPkwy",40.600171,-73.50862),
new Waypoint("US6/9",41.295865,-73.933311),
new Waypoint("HigAve",41.302257,-73.920591),
new Waypoint("DivSt",41.301455,-73.915946),
new Waypoint("CarAve",41.298545,-73.906043),
new Waypoint("+X548092",41.303244,-73.890599),
new Waypoint("US6",41.29925,-73.885803),
new Waypoint("US202",41.293173,-73.870547),
new Waypoint("US202",41.290786,-73.835056),
new Waypoint("TacStaPkwy",41.298896,-73.822911),
new Waypoint("B1",40.705839,-73.45268),
new Waypoint("B2",40.716587,-73.458431),
new Waypoint("B3",40.72734,-73.468521),
new Waypoint("B4",40.735543,-73.469986),
new Waypoint("PlaRd",40.738051,-73.468924),
new Waypoint("ShoFroPkwy",40.583795,-73.815663),
new Waypoint("CroBayBri",40.587963,-73.818281),
new Waypoint("JamAve",40.678128,-73.89746),
new Waypoint("1",40.680418,-73.896709),
new Waypoint("2",40.689742,-73.890315),
new Waypoint("3",40.692174,-73.882472),
new Waypoint("4",40.699764,-73.868642),
new Waypoint("5",40.702525,-73.861068),
new Waypoint("6",40.708971,-73.841488),
new Waypoint("7",40.716428,-73.82628),
new Waypoint("NY440(1)",40.525609,-74.232774),
new Waypoint("NY440(2)",40.526392,-74.223504),
new Waypoint("MagAve",40.529866,-74.211037),
new Waypoint("HugAve",40.535007,-74.193351),
new Waypoint("ArdAve",40.546711,-74.180846),
new Waypoint("DruRd",40.559518,-74.173631),
new Waypoint("NY18",43.360653,-78.234715),
new Waypoint("LakeOntPkwy",43.363664,-78.234743),
new Waypoint("CampRd",43.367516,-78.237365),
new Waypoint("SevLakDr",41.213239,-74.122932),
new Waypoint("StJohRd",41.222629,-74.097285),
new Waypoint("WelBea",41.238625,-74.070296),
new Waypoint("TioBroRd",41.250701,-74.048774),
new Waypoint("PalIntPkwy",41.250096,-74.041264),
new Waypoint("LidoBlvd",40.592049,-73.587075),
new Waypoint("+x1",40.600812,-73.584782),
new Waypoint("MeaStaPkwy",40.610695,-73.548918),
new Waypoint("SouBlvd",40.867757,-73.879505),
new Waypoint("GraCon",40.879082,-73.884269),
new Waypoint("GunHillRd",40.884355,-73.887064),
new Waypoint("I-87",40.889882,-73.887391),
new Waypoint("HenHudPkwy",40.901447,-73.887906),
new Waypoint("FinDr",43.115994,-79.058738),
new Waypoint("*OldNiaPkwy",43.116911,-79.060696),
new Waypoint("WhiSP",43.119624,-79.062188),
new Waypoint("NY104",43.132916,-79.046996),
new Waypoint("UppMouRd",43.150519,-79.03985),
new Waypoint("+X499132",43.160971,-79.042425),
new Waypoint("NY18F/104",43.172815,-79.028842),
new Waypoint("PleRd",43.208359,-79.029041),
new Waypoint("NY93",43.253668,-79.030881),
new Waypoint("NiaScePkwySpr",43.262577,-79.033231),
new Waypoint("FourMileSP",43.271913,-78.996259),
new Waypoint("NY18",43.271288,-78.98994),
new Waypoint("LaSExpy",43.080414,-78.986673),
new Waypoint("I-190",43.074278,-78.990793),
new Waypoint("JohnDalyBlvd",43.080804,-79.050987),
new Waypoint("NiaScePkwy",43.262577,-79.033231),
new Waypoint("NY18F",43.264851,-79.046073),
new Waypoint("FortNiaSP",43.264468,-79.052188),
new Waypoint("MeaStaPkwy",40.593621,-73.537931),
new Waypoint("WanStaPkwy",40.596489,-73.508148),
new Waypoint("TobBea",40.609326,-73.43156),
new Waypoint("WGilBea",40.612877,-73.416143),
new Waypoint("GilBea",40.618733,-73.393832),
new Waypoint("CedBea",40.634583,-73.341433),
new Waypoint("OakBea",40.640653,-73.286029),
new Waypoint("RobMosCswy",40.639488,-73.263617),
new Waypoint("CapSP",40.640301,-73.2559),
new Waypoint("SeaBreAve",40.575259,-73.96892),
new Waypoint("BeltPkwy",40.583991,-73.966784),
new Waypoint("AveW",40.593332,-73.964623),
new Waypoint("AveU",40.597833,-73.965476),
new Waypoint("KinHwy",40.605656,-73.966951),
new Waypoint("AveP",40.609404,-73.96767),
new Waypoint("AveJ",40.624185,-73.97047),
new Waypoint("18thAve",40.633112,-73.972162),
new Waypoint("NY27",40.647792,-73.974938),
new Waypoint("US1",40.856969,-73.869077),
new Waypoint("WilRd",40.857342,-73.856277),
new Waypoint("EasRd",40.857497,-73.843644),
new Waypoint("HutRivPkwy",40.85602,-73.832846),
new Waypoint("I-95",40.856572,-73.826387),
new Waypoint("US9",43.411747,-73.711299),
new Waypoint("+X879093",43.406723,-73.728009),
new Waypoint("+X516149",43.416497,-73.737112),
new Waypoint("+X158525",43.433328,-73.730707),
new Waypoint("+X295472",43.435945,-73.746446),
new Waypoint("+X800273",43.423627,-73.747659),
new Waypoint("LakeGeoOve",43.42346,-73.746119),
new Waypoint("+X506749",43.425411,-73.743786),
new Waypoint("+X710636",43.425957,-73.744585),
new Waypoint("End",43.424519,-73.745931),
new Waypoint("JohRd",41.166796,-74.17939),
new Waypoint("PineMeaRd",41.20183,-74.124654),
new Waypoint("LakeWelDr",41.213239,-74.122932),
new Waypoint("KanRd",41.234143,-74.111302),
new Waypoint("TioBroRd",41.275557,-74.087956),
new Waypoint("+X647984",41.293886,-74.069014),
new Waypoint("PalIntPkwy(18)",41.305118,-74.034762),
new Waypoint("PalIntPkwy(19)",41.309373,-74.024591),
new Waypoint("PerMemDr",41.303091,-74.006602),
new Waypoint("*LemRd",41.300675,-73.991786),
new Waypoint("SouEntRd",41.309224,-73.990978),
new Waypoint("US9W/202",41.314648,-73.9885),
new Waypoint("Bea108thSt",40.580153,-73.828844),
new Waypoint("CroBayPkwy",40.583795,-73.815663),
new Waypoint("Bea73rdSt",40.586769,-73.800632),
new Waypoint("WestRivPkwy",42.96778,-78.95889),
new Waypoint("FixRd",42.984295,-78.959352),
new Waypoint("I-190",43.004961,-78.948226)
];
traveler = 'mariethefoxy';
segments = [
1202682,
1202683,
1202684,
1202685,
1202686,
1202687,
1202688,
1202689,
1202690,
1202691,
1202692,
1202693,
1202694,
1202695,
1202696,
1202697,
1202698,
1202699,
1202700,
1202701,
1202702,
1202703,
1202704,
1202705,
1202706,
1202707,
1202708,
1202709,
1202710,
1202711,
1202712,
1202713,
1202714,
1202715,
1202716,
1202717,
1202718,
1202719,
1202720,
1202721,
1202722,
1202723,
1202724,
1202725,
1202726,
1202727,
1202728,
1202729,
1202730,
1202731,
1202732,
1202733,
1202734,
1202735,
1202736,
1202737,
1202738,
1202739,
1202740,
1202741,
1202742,
1202743,
1202744,
1202745,
1202746,
1202747,
1202748,
1202749,
1202750,
1202751,
1202752,
1202753,
1202754,
1202755,
1202756,
1202757,
1202758,
1202759,
1202760,
1202761,
1202762,
1202763,
1202764,
1202765,
1202766,
1202767,
1202768,
1202769,
1202770,
1202771,
1202772,
1202773,
1202774,
1202775,
1202776,
1202777,
1202778
];
clinched = [
1202682,
1202683,
1202684,
1202685,
1202686,
1202687,
1202688,
1202689,
1202690,
1202691,
1202692,
1202693,
1202694,
1202695,
1202699,
1202700,
1202701,
1202702,
1202703,
1202704,
1202705,
1202706,
1202707,
1202714,
1202715,
1202716,
1202717,
1202718,
1202719,
1202735,
1202736,
1202737,
1202738,
1202739,
1202740,
1202741,
1202751,
1202752,
1202753,
1202754,
1202767,
1202768,
1202769,
1202770
];
mapClinched = true;
mapStatus = mapStates.MAPVIEW;
genEdges = true;
}