<!-- /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: "prt.ip002", tier: 2, color: "TMteal", system: "prtip", label: "PRT IP2" };
routeInfo[1] = { firstWaypoint: 33, root: "prt.ip002est", tier: 2, color: "TMteal", system: "prtip", label: "PRT IP2Est" };
routeInfo[2] = { firstWaypoint: 52, root: "prt.ip002gaf", tier: 2, color: "TMteal", system: "prtip", label: "PRT IP2Gaf" };
routeInfo[3] = { firstWaypoint: 63, root: "prt.ip002mac", tier: 2, color: "TMteal", system: "prtip", label: "PRT IP2Mac" };
routeInfo[4] = { firstWaypoint: 77, root: "prt.ip002tra", tier: 2, color: "TMteal", system: "prtip", label: "PRT IP2Tra" };
routeInfo[5] = { firstWaypoint: 90, root: "prt.ip003", tier: 2, color: "TMteal", system: "prtip", label: "PRT IP3" };
routeInfo[6] = { firstWaypoint: 121, root: "prt.ip004", tier: 2, color: "TMteal", system: "prtip", label: "PRT IP4" };
routeInfo[7] = { firstWaypoint: 140, root: "prt.ip004bra", tier: 2, color: "TMteal", system: "prtip", label: "PRT IP4Bra" };
routeInfo[8] = { firstWaypoint: 146, root: "prt.ip005", tier: 2, color: "TMteal", system: "prtip", label: "PRT IP5" };
routeInfo[9] = { firstWaypoint: 160, root: "prt.ip006", tier: 2, color: "TMteal", system: "prtip", label: "PRT IP6" };
routeInfo[10] = { firstWaypoint: 166, root: "prt.ip007", tier: 2, color: "TMteal", system: "prtip", label: "PRT IP7" };
routeInfo[11] = { firstWaypoint: 181, root: "prt.ip008", tier: 2, color: "TMteal", system: "prtip", label: "PRT IP8" };
routeInfo[12] = { firstWaypoint: 204, root: "prt.ip008sin", tier: 2, color: "TMteal", system: "prtip", label: "PRT IP8Sin" };
routeInfo[13] = { firstWaypoint: 207, root: "prt.ip009", tier: 2, color: "TMteal", system: "prtip", label: "PRT IP9" };
waypoints = [
new Waypoint("33",38.492582,-7.749127),
new Waypoint("34",38.454177,-7.744734),
new Waypoint("+X41",38.42462,-7.716914),
new Waypoint("35",38.396271,-7.718689),
new Waypoint("+X13",38.353186,-7.683164),
new Waypoint("36",38.314976,-7.706249),
new Waypoint("37",38.306442,-7.710377),
new Waypoint("38",38.252953,-7.784146),
new Waypoint("+X95",38.236771,-7.797691),
new Waypoint("39",38.219491,-7.796184),
new Waypoint("+X258",38.206792,-7.792354),
new Waypoint("40",38.199965,-7.800776),
new Waypoint("41",38.155313,-7.829604),
new Waypoint("N258-1",38.119416,-7.847741),
new Waypoint("RuaPoeBri",38.109058,-7.854409),
new Waypoint("IP8",38.025681,-7.875137),
new Waypoint("RuaLis",38.023082,-7.875921),
new Waypoint("N18_S",38.009351,-7.876725),
new Waypoint("AveFiaGou",38.002859,-7.866447),
new Waypoint("42",37.971978,-7.874408),
new Waypoint("+X83",37.949342,-7.879558),
new Waypoint("43",37.930151,-7.871404),
new Waypoint("44",37.910473,-7.871857),
new Waypoint("45",37.893076,-7.895865),
new Waypoint("46",37.863924,-7.952369),
new Waypoint("47",37.835562,-7.964608),
new Waypoint("+X50",37.803206,-7.98161),
new Waypoint("RuaErm",37.773166,-8.019623),
new Waypoint("49",37.708541,-8.084865),
new Waypoint("50",37.694824,-8.098705),
new Waypoint("51",37.678148,-8.13529),
new Waypoint("52",37.670767,-8.15391),
new Waypoint("A2",37.665527,-8.157813),
new Waypoint("IC13",39.298199,-7.452413),
new Waypoint("N246_N",39.297933,-7.438409),
new Waypoint("N246_S",39.279042,-7.434225),
new Waypoint("AveFraFino",39.268893,-7.440405),
new Waypoint("M520",39.200134,-7.458172),
new Waypoint("N18-1",39.198663,-7.457925),
new Waypoint("M1099",39.106454,-7.438774),
new Waypoint("+X72",39.065802,-7.435716),
new Waypoint("N369",39.054955,-7.443795),
new Waypoint("R243",39.046865,-7.448103),
new Waypoint("N243",39.03922,-7.451177),
new Waypoint("+X93",39.000543,-7.468343),
new Waypoint("M372_E",38.96055,-7.509493),
new Waypoint("M372_W",38.948713,-7.513522),
new Waypoint("M504",38.850539,-7.584625),
new Waypoint("N245",38.845461,-7.602705),
new Waypoint("N4_E",38.843752,-7.606659),
new Waypoint("N4_W",38.844989,-7.609148),
new Waypoint("A6",38.819713,-7.605937),
new Waypoint("A23",39.558322,-7.801084),
new Waypoint("N359-1",39.556666,-7.796519),
new Waypoint("+X66",39.543588,-7.802825),
new Waypoint("N359",39.530323,-7.78825),
new Waypoint("+X97",39.514206,-7.768579),
new Waypoint("M528",39.498039,-7.768211),
new Waypoint("N118/N364",39.469106,-7.753773),
new Waypoint("Tol",39.423597,-7.70824),
new Waypoint("RuaAlp",39.412269,-7.673569),
new Waypoint("N245",39.410544,-7.622916),
new Waypoint("N18",39.401962,-7.602789),
new Waypoint("A4",41.566899,-6.993235),
new Waypoint("1",41.553616,-6.987906),
new Waypoint("2",41.522614,-6.987364),
new Waypoint("+X17",41.488193,-6.978309),
new Waypoint("3",41.474264,-6.99128),
new Waypoint("4",41.458721,-7.011072),
new Waypoint("5",41.404477,-7.075327),
new Waypoint("6",41.390544,-7.076609),
new Waypoint("+X36",41.379932,-7.071333),
new Waypoint("+X23",41.362187,-7.091417),
new Waypoint("+X11",41.346144,-7.078285),
new Waypoint("7",41.324641,-7.079412),
new Waypoint("8",41.298616,-7.073559),
new Waypoint("9",41.265122,-7.086573),
new Waypoint("N102_Vil",41.12734,-7.124505),
new Waypoint("12",41.054993,-7.168563),
new Waypoint("13",40.977857,-7.196018),
new Waypoint("+X29",40.936664,-7.192783),
new Waypoint("N102_Mar",40.901167,-7.219289),
new Waypoint("N102_Cog",40.823494,-7.267496),
new Waypoint("+X20",40.807469,-7.293999),
new Waypoint("16",40.75316,-7.331105),
new Waypoint("+X44",40.740136,-7.338352),
new Waypoint("17",40.707928,-7.312831),
new Waypoint("+X27",40.686953,-7.310999),
new Waypoint("18",40.671659,-7.322356),
new Waypoint("A25",40.643168,-7.319276),
new Waypoint("9(A14)",40.270151,-8.469644),
new Waypoint("8",40.272357,-8.443835),
new Waypoint("9",40.300177,-8.418537),
new Waypoint("+X41",40.308953,-8.382139),
new Waypoint("9A",40.303045,-8.348137),
new Waypoint("10",40.302804,-8.318885),
new Waypoint("11",40.27688,-8.285413),
new Waypoint("12",40.293803,-8.254783),
new Waypoint("+X15",40.304371,-8.228846),
new Waypoint("13",40.309321,-8.235023),
new Waypoint("13A",40.317105,-8.228687),
new Waypoint("13B",40.323179,-8.230396),
new Waypoint("14",40.340215,-8.218975),
new Waypoint("15",40.353795,-8.198633),
new Waypoint("16",40.348617,-8.18552),
new Waypoint("+X72",40.347213,-8.177755),
new Waypoint("17",40.354113,-8.152875),
new Waypoint("18",40.361359,-8.134818),
new Waypoint("19",40.38315,-8.117845),
new Waypoint("Vim",40.390293,-8.128295),
new Waypoint("20",40.400292,-8.126248),
new Waypoint("21",40.437108,-8.110002),
new Waypoint("22",40.499263,-8.082346),
new Waypoint("+X63",40.517832,-8.093853),
new Waypoint("23",40.525858,-8.088255),
new Waypoint("24",40.535833,-8.05933),
new Waypoint("+X62",40.565916,-8.048998),
new Waypoint("25",40.585457,-8.016562),
new Waypoint("26",40.603517,-7.976466),
new Waypoint("N2_N",40.612486,-7.965131),
new Waypoint("A24/A25",40.62559,-7.9617),
new Waypoint("A4(19)",41.259025,-8.032143),
new Waypoint("19",41.280677,-7.992538),
new Waypoint("20",41.259525,-7.969873),
new Waypoint("+X89",41.255214,-7.957972),
new Waypoint("21",41.276272,-7.932781),
new Waypoint("+X34",41.280955,-7.923189),
new Waypoint("22",41.281221,-7.842076),
new Waypoint("+X47",41.284974,-7.83009),
new Waypoint("23",41.284809,-7.806741),
new Waypoint("+X70",41.273166,-7.790605),
new Waypoint("24A",41.275918,-7.777921),
new Waypoint("24",41.283956,-7.759861),
new Waypoint("25",41.300161,-7.753555),
new Waypoint("25A",41.304151,-7.751369),
new Waypoint("+X24",41.311795,-7.746461),
new Waypoint("26",41.313808,-7.733568),
new Waypoint("27",41.32355,-7.699909),
new Waypoint("28",41.328489,-7.673116),
new Waypoint("A4(24)",41.317722,-7.660775),
new Waypoint("A4(42)",41.762453,-6.793499),
new Waypoint("M15",41.769851,-6.792882),
new Waypoint("N103",41.812595,-6.802356),
new Waypoint("N103-7",41.820665,-6.75414),
new Waypoint("N218",41.814678,-6.739919),
new Waypoint("A4(44)",41.791621,-6.721294),
new Waypoint("A25(14)",40.699211,-8.130358),
new Waypoint("+X47",40.700416,-8.117695),
new Waypoint("JoaMar",40.686777,-8.110938),
new Waypoint("+X33",40.68856,-8.086469),
new Waypoint("13",40.646502,-8.074321),
new Waypoint("A25",40.645395,-8.062109),
new Waypoint("14",40.668801,-7.990327),
new Waypoint("14A",40.672448,-7.971952),
new Waypoint("+X73",40.677282,-7.947823),
new Waypoint("15",40.693911,-7.930965),
new Waypoint("16",40.692563,-7.912672),
new Waypoint("17",40.680819,-7.882766),
new Waypoint("+X70",40.672558,-7.860506),
new Waypoint("A25(19)",40.65395,-7.863443),
new Waypoint("N114_Pen",39.350282,-9.359901),
new Waypoint("N114_Ato",39.345439,-9.341431),
new Waypoint("N247",39.330899,-9.33085),
new Waypoint("+X19",39.324505,-9.279499),
new Waypoint("N114_Ser",39.33126,-9.257336),
new Waypoint("A8",39.338301,-9.17408),
new Waypoint("A2",38.66591,-9.171824),
new Waypoint("AcePon25Abr",38.710697,-9.177747),
new Waypoint("A5",38.723239,-9.175864),
new Waypoint("AveCalGul",38.72779,-9.172318),
new Waypoint("RadBen",38.737975,-9.171347),
new Waypoint("RuaCam",38.741553,-9.168568),
new Waypoint("AveForArm",38.744312,-9.165028),
new Waypoint("AveLus",38.750017,-9.168091),
new Waypoint("2Cir",38.75753,-9.172189),
new Waypoint("AveNacUni",38.763617,-9.172954),
new Waypoint("AvePadCruz",38.772534,-9.16362),
new Waypoint("EstSanBar",38.781469,-9.155541),
new Waypoint("AveSanCas",38.789742,-9.147317),
new Waypoint("EstFet",38.797305,-9.140794),
new Waypoint("IC17",38.80227,-9.137197),
new Waypoint("IC1",38.112707,-8.418202),
new Waypoint("N259_W",38.116649,-8.413797),
new Waypoint("A2",38.118071,-8.414117),
new Waypoint("+X52",38.122406,-8.379578),
new Waypoint("N259_Can",38.103554,-8.280087),
new Waypoint("RuaTra",38.092802,-8.203933),
new Waypoint("R2",38.066642,-8.118725),
new Waypoint("AveGHD",38.062054,-8.103455),
new Waypoint("N387",38.0686,-8.070775),
new Waypoint("RuaCab",38.054191,-7.986095),
new Waypoint("M528-2",38.039627,-7.919799),
new Waypoint("IP2",38.025681,-7.875137),
new Waypoint("RuaAfoIII",38.020304,-7.847639),
new Waypoint("RuaFMD",38.025749,-7.735019),
new Waypoint("N388",38.018609,-7.724555),
new Waypoint("N265",37.951985,-7.599422),
new Waypoint("N255",37.948525,-7.590249),
new Waypoint("R265",37.930234,-7.584477),
new Waypoint("RuaLib",37.91909,-7.48081),
new Waypoint("N392",37.924995,-7.420168),
new Waypoint("M519",37.921089,-7.405094),
new Waypoint("R385",37.949479,-7.302934),
new Waypoint("PRT/ESP",37.960001,-7.251792),
new Waypoint("A26",37.968561,-8.831549),
new Waypoint("+X36",37.950695,-8.822751),
new Waypoint("N120-1",37.939662,-8.830784),
new Waypoint("A3",41.506866,-8.471634),
new Waypoint("A11",41.507467,-8.446365)
];
traveler = 'michih';
segments = [
431942,
431943,
431944,
431945,
431946,
431947,
431948,
431949,
431950,
431951,
431952,
431953,
431954,
431955,
431956,
431957,
431958,
431959,
431960,
431961,
431962,
431963,
431964,
431965,
431966,
431967,
431968,
431969,
431970,
431971,
431972,
431973,
431924,
431925,
431926,
431927,
431928,
431929,
431930,
431931,
431932,
431933,
431934,
431935,
431936,
431937,
431938,
431939,
431940,
431941,
431914,
431915,
431916,
431917,
431918,
431919,
431920,
431921,
431922,
431923,
431889,
431890,
431891,
431892,
431893,
431894,
431895,
431896,
431897,
431898,
431899,
431900,
431901,
431902,
431903,
431904,
431905,
431906,
431907,
431908,
431909,
431910,
431911,
431912,
431913,
431974,
431975,
431976,
431977,
431978,
431979,
431980,
431981,
431982,
431983,
431984,
431985,
431986,
431987,
431988,
431989,
431990,
431991,
431992,
431993,
431994,
431995,
431996,
431997,
431998,
431999,
432000,
432001,
432002,
432003,
432004,
432005,
432006,
432007,
432008,
432009,
432010,
432011,
432012,
432013,
432014,
432015,
432016,
432017,
432018,
432019,
432020,
432021,
432022,
432023,
432024,
432025,
432026,
432027,
432028,
432029,
432030,
432031,
432032,
432033,
432034,
432035,
432036,
432037,
432038,
432039,
432040,
432041,
432042,
432043,
432044,
432045,
432046,
432047,
432048,
432049,
432050,
432051,
432052,
432053,
432054,
432055,
432056,
432057,
432058,
432061,
432062,
432063,
432064,
432065,
432066,
432067,
432068,
432069,
432070,
432071,
432072,
432073,
432074,
432075,
432076,
432077,
432078,
432079,
432080,
432081,
432082,
432059,
432060,
432083
];
clinched = [
431942,
431943,
431944,
431945,
431946,
431947,
431948,
431949,
431950,
431951,
431952,
431953,
431954,
431955,
431956,
431957,
431958,
431959,
431960,
431961,
431962,
431963,
431964,
431965,
431966,
431967,
431968,
431969,
431970,
431971,
431972,
431924,
431925,
431926,
431927,
431928,
431929,
431930,
431931,
431932,
431933,
431934,
431935,
431936,
431937,
431938,
431939,
431940,
431941,
431914,
431915,
431916,
431917,
431918,
431919,
431920,
431921,
431922,
431923,
432045,
432046,
432061,
432065,
432066,
432067,
432068,
432069,
432070,
432071,
432072,
432073,
432074,
432075,
432076,
432077,
432078,
432079,
432080,
432081,
432082,
432059,
432060
];
mapClinched = true;
mapStatus = mapStates.MAPVIEW;
genEdges = true;
}