<!-- /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 = [
1198936,
1198937,
1198938,
1198939,
1198940,
1198941,
1198942,
1198943,
1198944,
1198945,
1198946,
1198947,
1198948,
1198949,
1198950,
1198951,
1198952,
1198953,
1198954,
1198955,
1198956,
1198957,
1198958,
1198959,
1198960,
1198961,
1198962,
1198963,
1198964,
1198965,
1198966,
1198967,
1198968,
1198969,
1198970,
1198971,
1198972,
1198973,
1198974,
1198975,
1198976,
1198977,
1198978,
1198979,
1198980,
1198981,
1198982,
1198983,
1198984,
1198985,
1198986,
1198987,
1198988,
1198989,
1198990,
1198991,
1198992,
1198993,
1198994,
1198995,
1198996,
1198997,
1198998,
1198999,
1199000,
1199001,
1199002,
1199003,
1199004,
1199005,
1199006,
1199007,
1199008,
1199009,
1199010,
1199011,
1199012,
1199013,
1199014,
1199015,
1199016,
1199017,
1199018,
1199019,
1199020,
1199021,
1199022,
1199023,
1199024,
1199025,
1199026,
1199027,
1199028,
1199029,
1199030,
1199031,
1199032
];
clinched = [
];
mapClinched = true;
mapStatus = mapStates.MAPVIEW;
genEdges = true;
}