<!-- /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 = 'boilerup25';
segments = [
1208113,
1208114,
1208115,
1208116,
1208117,
1208118,
1208119,
1208120,
1208121,
1208122,
1208123,
1208124,
1208125,
1208126,
1208127,
1208128,
1208129,
1208130,
1208131,
1208132,
1208133,
1208134,
1208135,
1208136,
1208137,
1208138,
1208139,
1208140,
1208141,
1208142,
1208143,
1208144,
1208145,
1208146,
1208147,
1208148,
1208149,
1208150,
1208151,
1208152,
1208153,
1208154,
1208155,
1208156,
1208157,
1208158,
1208159,
1208160,
1208161,
1208162,
1208163,
1208164,
1208165,
1208166,
1208167,
1208168,
1208169,
1208170,
1208171,
1208172,
1208173,
1208174,
1208175,
1208176,
1208177,
1208178,
1208179,
1208180,
1208181,
1208182,
1208183,
1208184,
1208185,
1208186,
1208187,
1208188,
1208189,
1208190,
1208191,
1208192,
1208193,
1208194,
1208195,
1208196,
1208197,
1208198,
1208199,
1208200,
1208201,
1208202,
1208203,
1208204,
1208205,
1208206,
1208207,
1208208,
1208209
];
clinched = [
1208115,
1208116,
1208117,
1208118,
1208119,
1208120,
1208121,
1208126,
1208127,
1208128,
1208129,
1208130,
1208131,
1208132,
1208133,
1208134,
1208135,
1208136,
1208137,
1208138,
1208147,
1208148,
1208149,
1208150,
1208151,
1208152,
1208153,
1208154,
1208162,
1208163,
1208166,
1208174,
1208175,
1208176,
1208177,
1208178,
1208179,
1208180,
1208181,
1208182,
1208183,
1208184,
1208185,
1208195,
1208196,
1208197,
1208198,
1208199,
1208200,
1208201,
1208202,
1208203,
1208204,
1208205,
1208206,
1208207
];
mapClinched = true;
mapStatus = mapStates.MAPVIEW;
genEdges = true;
}