<!-- /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: "irl.corioacw", tier: 5, color: "TMgray", system: "irlorb", label: "IRL CorIOACW" };
routeInfo[1] = { firstWaypoint: 18, root: "irl.coriocw", tier: 5, color: "TMgray", system: "irlorb", label: "IRL CorIOCW" };
routeInfo[2] = { firstWaypoint: 43, root: "irl.dubioacw", tier: 5, color: "TMgray", system: "irlorb", label: "IRL DubIOACW" };
routeInfo[3] = { firstWaypoint: 78, root: "irl.dubiocw", tier: 5, color: "TMgray", system: "irlorb", label: "IRL DubIOCW" };
routeInfo[4] = { firstWaypoint: 118, root: "irl.duboo", tier: 5, color: "TMgray", system: "irlorb", label: "IRL DubOO" };
routeInfo[5] = { firstWaypoint: 155, root: "irl.kilrr", tier: 5, color: "TMgray", system: "irlorb", label: "IRL KilRR" };
routeInfo[6] = { firstWaypoint: 165, root: "irl.slicitylp", tier: 5, color: "TMgray", system: "irlorb", label: "IRL SliCityLp" };
waypoints = [
new Waypoint("J7",51.894851,-8.469225),
new Waypoint("J8",51.895222,-8.468732),
new Waypoint("J5",51.895314,-8.465213),
new Waypoint("J4",51.895785,-8.46341),
new Waypoint("J3",51.897314,-8.46282),
new Waypoint("J2",51.898088,-8.463292),
new Waypoint("J1",51.899545,-8.463668),
new Waypoint("J26",51.89977,-8.465835),
new Waypoint("J25",51.899896,-8.467069),
new Waypoint("J24",51.900273,-8.47047),
new Waypoint("J23",51.900442,-8.472551),
new Waypoint("J22",51.90075,-8.476371),
new Waypoint("J21",51.901068,-8.47953),
new Waypoint("J20",51.900657,-8.481102),
new Waypoint("J19",51.899962,-8.480641),
new Waypoint("R608_CorE",51.89784,-8.47931),
new Waypoint("R847",51.897509,-8.482379),
new Waypoint("J12",51.896433,-8.480651),
new Waypoint("J1",51.899545,-8.463668),
new Waypoint("J2",51.898088,-8.463292),
new Waypoint("J3",51.897314,-8.46282),
new Waypoint("J4",51.895785,-8.46341),
new Waypoint("J5",51.895314,-8.465213),
new Waypoint("J6",51.894083,-8.465406),
new Waypoint("J7",51.894851,-8.469225),
new Waypoint("J9",51.895593,-8.472573),
new Waypoint("J10",51.895473,-8.47607),
new Waypoint("CroGreQuay",51.895063,-8.478291),
new Waypoint("J11",51.894613,-8.481231),
new Waypoint("J12",51.896433,-8.480651),
new Waypoint("N22_E",51.897509,-8.482379),
new Waypoint("J16",51.895619,-8.489352),
new Waypoint("R847",51.897509,-8.482379),
new Waypoint("N22/R608",51.89784,-8.47931),
new Waypoint("J19",51.899962,-8.480641),
new Waypoint("J20",51.900657,-8.481102),
new Waypoint("J21",51.901068,-8.47953),
new Waypoint("J22",51.90075,-8.476371),
new Waypoint("J23",51.900442,-8.472551),
new Waypoint("J24",51.900273,-8.47047),
new Waypoint("J25",51.899896,-8.467069),
new Waypoint("J26",51.89977,-8.465835),
new Waypoint("N27",51.899545,-8.463668),
new Waypoint("J40",53.349419,-6.253377),
new Waypoint("J39",53.353017,-6.256006),
new Waypoint("J38",53.354195,-6.256864),
new Waypoint("J37",53.356808,-6.259074),
new Waypoint("J36",53.354501,-6.263494),
new Waypoint("R803_E",53.352589,-6.261467),
new Waypoint("J34",53.351895,-6.262883),
new Waypoint("J33",53.350415,-6.266338),
new Waypoint("J44",53.34989,-6.268162),
new Waypoint("J31",53.351064,-6.270061),
new Waypoint("J30",53.350148,-6.274534),
new Waypoint("J27",53.349831,-6.279577),
new Waypoint("R148/R804",53.346401,-6.280409),
new Waypoint("R108/R148",53.345537,-6.275752),
new Waypoint("J22",53.343308,-6.274931),
new Waypoint("J21",53.342898,-6.271788),
new Waypoint("J20",53.340579,-6.272228),
new Waypoint("J19",53.338894,-6.272635),
new Waypoint("J17",53.338132,-6.269288),
new Waypoint("J16",53.337613,-6.265801),
new Waypoint("J15",53.337568,-6.262615),
new Waypoint("J14",53.336175,-6.257282),
new Waypoint("J46",53.338596,-6.255341),
new Waypoint("J47",53.338141,-6.253592),
new Waypoint("J10",53.339756,-6.252015),
new Waypoint("J8",53.341163,-6.250743),
new Waypoint("J9",53.341769,-6.252578),
new Waypoint("J7",53.341946,-6.250411),
new Waypoint("J6",53.344103,-6.249284),
new Waypoint("ShawSt",53.344704,-6.252299),
new Waypoint("PeaSt_W",53.345215,-6.255019),
new Waypoint("J43",53.345862,-6.255137),
new Waypoint("J42",53.347479,-6.254997),
new Waypoint("J41",53.348279,-6.25496),
new Waypoint("R802",53.349419,-6.253377),
new Waypoint("J1",53.349173,-6.251929),
new Waypoint("J2",53.348267,-6.251553),
new Waypoint("J3",53.347469,-6.251773),
new Waypoint("J4",53.346769,-6.247836),
new Waypoint("J5",53.345436,-6.24841),
new Waypoint("J6",53.344103,-6.249284),
new Waypoint("J7",53.341946,-6.250411),
new Waypoint("J8",53.341163,-6.250743),
new Waypoint("J10",53.339756,-6.252015),
new Waypoint("J11",53.338225,-6.247702),
new Waypoint("J12",53.336825,-6.249118),
new Waypoint("J13",53.33243,-6.253162),
new Waypoint("PemStUpp",53.334406,-6.255244),
new Waypoint("J14",53.336175,-6.257282),
new Waypoint("J15",53.337568,-6.262615),
new Waypoint("J16",53.337613,-6.265801),
new Waypoint("J17",53.338132,-6.269288),
new Waypoint("J18",53.340576,-6.270061),
new Waypoint("J20",53.340579,-6.272228),
new Waypoint("J21",53.342898,-6.271788),
new Waypoint("J22",53.343308,-6.274931),
new Waypoint("R108/R148",53.345537,-6.275752),
new Waypoint("R804",53.346401,-6.280409),
new Waypoint("R148/R805",53.346613,-6.282597),
new Waypoint("J26",53.350036,-6.281712),
new Waypoint("J27",53.349831,-6.279577),
new Waypoint("J28",53.350548,-6.279577),
new Waypoint("J29",53.350721,-6.274213),
new Waypoint("J30",53.350148,-6.274534),
new Waypoint("J31",53.351064,-6.270061),
new Waypoint("J32",53.352053,-6.269138),
new Waypoint("J33",53.350415,-6.266338),
new Waypoint("J34",53.351895,-6.262883),
new Waypoint("J35",53.353572,-6.265528),
new Waypoint("J36",53.354501,-6.263494),
new Waypoint("J37",53.356808,-6.259074),
new Waypoint("J38",53.354195,-6.256864),
new Waypoint("J39",53.353017,-6.256006),
new Waypoint("J40",53.349419,-6.253377),
new Waypoint("R105",53.349173,-6.251929),
new Waypoint("J51",53.346253,-6.241275),
new Waypoint("J52",53.342744,-6.241157),
new Waypoint("J53",53.339765,-6.241822),
new Waypoint("ClaPla",53.338686,-6.239043),
new Waypoint("J54",53.337203,-6.234677),
new Waypoint("J55",53.336146,-6.23811),
new Waypoint("J56",53.334032,-6.245202),
new Waypoint("J57",53.331917,-6.252669),
new Waypoint("J58",53.330335,-6.260018),
new Waypoint("J59",53.329931,-6.264278),
new Waypoint("J60",53.329502,-6.275564),
new Waypoint("DonAve",53.330508,-6.284062),
new Waypoint("J61",53.332052,-6.29346),
new Waypoint("HerRd",53.333724,-6.298578),
new Waypoint("J62",53.336562,-6.306356),
new Waypoint("J63",53.339419,-6.307719),
new Waypoint("J64",53.340636,-6.307654),
new Waypoint("J65",53.342014,-6.307858),
new Waypoint("J66",53.343634,-6.308019),
new Waypoint("J67",53.348259,-6.30832),
new Waypoint("J68",53.348124,-6.295005),
new Waypoint("NorRd",53.352191,-6.298106),
new Waypoint("J69",53.355777,-6.292398),
new Waypoint("J70",53.357218,-6.288782),
new Waypoint("J71",53.360778,-6.275125),
new Waypoint("J72",53.36079,-6.272689),
new Waypoint("BerRd",53.360555,-6.269669),
new Waypoint("J73",53.359747,-6.261263),
new Waypoint("J74",53.359222,-6.258731),
new Waypoint("FitSt",53.358388,-6.254595),
new Waypoint("J75",53.357019,-6.249762),
new Waypoint("J76",53.354701,-6.246672),
new Waypoint("J77",53.35236,-6.24355),
new Waypoint("J78",53.350537,-6.241039),
new Waypoint("J79",53.349115,-6.240959),
new Waypoint("J80",53.347624,-6.241189),
new Waypoint("R813",53.346253,-6.241275),
new Waypoint("J1",52.642774,-7.262875),
new Waypoint("J2",52.637874,-7.257457),
new Waypoint("J3",52.63595,-7.250987),
new Waypoint("J4",52.637653,-7.236857),
new Waypoint("J5",52.641924,-7.231289),
new Waypoint("J6",52.649811,-7.228457),
new Waypoint("J7",52.658262,-7.225614),
new Waypoint("J8",52.663923,-7.227652),
new Waypoint("J9",52.670254,-7.23057),
new Waypoint("J10",52.67689,-7.253669),
new Waypoint("J1",54.272122,-8.479836),
new Waypoint("J2",54.272251,-8.476118),
new Waypoint("J3",54.272202,-8.4754),
new Waypoint("J4",54.272495,-8.474),
new Waypoint("J5",54.273554,-8.473914),
new Waypoint("J6",54.273541,-8.47327),
new Waypoint("J7",54.273588,-8.471478),
new Waypoint("J8",54.272614,-8.47151),
new Waypoint("J9",54.2713,-8.471607),
new Waypoint("J10",54.270602,-8.471607),
new Waypoint("J11",54.26963,-8.471714),
new Waypoint("J12",54.268416,-8.472755),
new Waypoint("J13",54.267239,-8.473034),
new Waypoint("J14",54.268448,-8.476843),
new Waypoint("J15",54.270196,-8.479385),
new Waypoint("J16",54.271355,-8.479697),
new Waypoint("R292",54.272122,-8.479836)
];
traveler = 'si404';
segments = [
358637,
358638,
358639,
358640,
358641,
358642,
358643,
358644,
358645,
358646,
358647,
358648,
358649,
358650,
358651,
358652,
358653,
358654,
358655,
358656,
358657,
358658,
358659,
358660,
358661,
358662,
358663,
358664,
358665,
358666,
358667,
358668,
358669,
358670,
358671,
358672,
358673,
358674,
358675,
358676,
358677,
358678,
358679,
358680,
358681,
358682,
358683,
358684,
358685,
358686,
358687,
358688,
358689,
358690,
358691,
358692,
358693,
358694,
358695,
358696,
358697,
358698,
358699,
358700,
358701,
358702,
358703,
358704,
358705,
358706,
358707,
358708,
358709,
358710,
358711,
358712,
358713,
358714,
358715,
358716,
358717,
358718,
358719,
358720,
358721,
358722,
358723,
358724,
358725,
358726,
358727,
358728,
358729,
358730,
358731,
358732,
358733,
358734,
358735,
358736,
358737,
358738,
358739,
358740,
358741,
358742,
358743,
358744,
358745,
358746,
358747,
358748,
358749,
358750,
358751,
358752,
358753,
358754,
358755,
358756,
358757,
358758,
358759,
358760,
358761,
358762,
358763,
358764,
358765,
358766,
358767,
358768,
358769,
358770,
358771,
358772,
358773,
358774,
358775,
358776,
358777,
358778,
358779,
358780,
358781,
358782,
358783,
358784,
358785,
358786,
358787,
358788,
358789,
358790,
358791,
358792,
358793,
358794,
358795,
358796,
358797,
358798,
358799,
358800,
358801,
358802,
358803,
358804,
358805,
358806,
358807,
358808,
358809,
358810,
358811
];
clinched = [
358678,
358679,
358683,
358684,
358685,
358686,
358690,
358691,
358692,
358693,
358694,
358695,
358696,
358697,
358698,
358699,
358700,
358701,
358702,
358703,
358704,
358705,
358706,
358707,
358708,
358709,
358710,
358711,
358712,
358713,
358714,
358715,
358716,
358717,
358718,
358719,
358720,
358721,
358722,
358723,
358724,
358725,
358726,
358727,
358730,
358731,
358732,
358733,
358741,
358743,
358744,
358748,
358749,
358750,
358751,
358752,
358753,
358754,
358755,
358756,
358757,
358758,
358779,
358780,
358781,
358782,
358783,
358784,
358785,
358786
];
mapClinched = true;
mapStatus = mapStates.MAPVIEW;
genEdges = true;
}