<!-- /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 = '';
segments = [
1202155,
1202156,
1202157,
1202158,
1202159,
1202160,
1202161,
1202162,
1202163,
1202164,
1202165,
1202166,
1202167,
1202168,
1202169,
1202170,
1202171,
1202172,
1202173,
1202174,
1202175,
1202176,
1202177,
1202178,
1202179,
1202180,
1202181,
1202182,
1202183,
1202184,
1202185,
1202186,
1202187,
1202188,
1202189,
1202190,
1202191,
1202192,
1202193,
1202194,
1202195,
1202196,
1202197,
1202198,
1202199,
1202200,
1202201,
1202202,
1202203,
1202204,
1202205,
1202206,
1202207,
1202208,
1202209,
1202210,
1202211,
1202212,
1202213,
1202214,
1202215,
1202216,
1202217,
1202218,
1202219,
1202220,
1202221,
1202222,
1202223,
1202224,
1202225,
1202226,
1202227,
1202228,
1202229,
1202230,
1202231,
1202232,
1202233,
1202234,
1202235,
1202236,
1202237,
1202238,
1202239,
1202240,
1202241,
1202242,
1202243,
1202244,
1202245,
1202246,
1202247,
1202248,
1202249,
1202250,
1202251
];
clinched = [
];
mapClinched = true;
mapStatus = mapStates.MAPVIEW;
genEdges = true;
}