<!-- /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: "hkg.rt001", tier: 2, color: "TMteal", system: "hkgrt", label: "HKG RT1" };
routeInfo[1] = { firstWaypoint: 29, root: "hkg.rt002", tier: 2, color: "TMteal", system: "hkgrt", label: "HKG RT2" };
routeInfo[2] = { firstWaypoint: 46, root: "hkg.rt003", tier: 2, color: "TMteal", system: "hkgrt", label: "HKG RT3" };
routeInfo[3] = { firstWaypoint: 62, root: "hkg.rt004", tier: 2, color: "TMteal", system: "hkgrt", label: "HKG RT4" };
routeInfo[4] = { firstWaypoint: 82, root: "hkg.rt005", tier: 2, color: "TMteal", system: "hkgrt", label: "HKG RT5" };
routeInfo[5] = { firstWaypoint: 109, root: "hkg.rt006", tier: 2, color: "TMteal", system: "hkgrt", label: "HKG RT6" };
routeInfo[6] = { firstWaypoint: 112, root: "hkg.rt007", tier: 2, color: "TMteal", system: "hkgrt", label: "HKG RT7" };
routeInfo[7] = { firstWaypoint: 145, root: "hkg.rt008", tier: 2, color: "TMteal", system: "hkgrt", label: "HKG RT8" };
routeInfo[8] = { firstWaypoint: 162, root: "hkg.rt009", tier: 2, color: "TMteal", system: "hkgrt", label: "HKG RT9" };
routeInfo[9] = { firstWaypoint: 204, root: "hkg.rt010", tier: 2, color: "TMteal", system: "hkgrt", label: "HKG RT10" };
waypoints = [
new Waypoint("1",22.24823,114.160695),
new Waypoint("1A",22.248568,114.161704),
new Waypoint("2",22.248856,114.167154),
new Waypoint("3",22.250444,114.171059),
new Waypoint("4",22.24964,114.174868),
new Waypoint("5",22.274592,114.179567),
new Waypoint("5A",22.278479,114.181268),
new Waypoint("6",22.281393,114.180404),
new Waypoint("6A",22.302155,114.180318),
new Waypoint("6C",22.306905,114.180801),
new Waypoint("7A",22.309128,114.178956),
new Waypoint("7C",22.312036,114.176896),
new Waypoint("8",22.317426,114.178483),
new Waypoint("8A",22.325753,114.178398),
new Waypoint("8C",22.326978,114.178467),
new Waypoint("9",22.330387,114.17872),
new Waypoint("9A",22.332551,114.178843),
new Waypoint("9C",22.334069,114.178923),
new Waypoint("9E",22.335156,114.178988),
new Waypoint("9G",22.339949,114.179235),
new Waypoint("10B",22.344142,114.181659),
new Waypoint("+X01",22.357597,114.172862),
new Waypoint("11",22.364285,114.181294),
new Waypoint("11A",22.372212,114.190049),
new Waypoint("11B",22.375952,114.198407),
new Waypoint("12",22.378135,114.199533),
new Waypoint("12A",22.386329,114.201486),
new Waypoint("12B",22.389494,114.199308),
new Waypoint("Rt9",22.392648,114.198697),
new Waypoint("1",22.289702,114.214565),
new Waypoint("+X01",22.288163,114.213181),
new Waypoint("+X02",22.289295,114.212107),
new Waypoint("1C",22.30355,114.235368),
new Waypoint("2",22.304364,114.235282),
new Waypoint("2A",22.309585,114.230411),
new Waypoint("2C",22.306408,114.224424),
new Waypoint("2D",22.317068,114.210337),
new Waypoint("+X03",22.321932,114.204683),
new Waypoint("3",22.332551,114.205123),
new Waypoint("3A",22.335002,114.20478),
new Waypoint("3B",22.338843,114.203396),
new Waypoint("5",22.381925,114.210305),
new Waypoint("4",22.383095,114.210445),
new Waypoint("6",22.394166,114.209748),
new Waypoint("7",22.404561,114.218287),
new Waypoint("7A",22.411584,114.212408),
new Waypoint("1",22.288938,114.141362),
new Waypoint("2",22.311351,114.161575),
new Waypoint("3",22.331221,114.14398),
new Waypoint("4",22.333305,114.138529),
new Waypoint("4A",22.336084,114.133594),
new Waypoint("4B",22.346662,114.124904),
new Waypoint("4C",22.352477,114.12044),
new Waypoint("4E",22.344836,114.096622),
new Waypoint("4D",22.345194,114.091344),
new Waypoint("5",22.354085,114.085143),
new Waypoint("5A",22.358728,114.082546),
new Waypoint("6",22.371031,114.074049),
new Waypoint("+X01",22.393948,114.061464),
new Waypoint("6A",22.421443,114.064157),
new Waypoint("6B",22.438143,114.057333),
new Waypoint("7",22.448952,114.047999),
new Waypoint("1",22.263393,114.237524),
new Waypoint("1A",22.265636,114.237846),
new Waypoint("2",22.270387,114.23871),
new Waypoint("ShiTaiRd",22.278335,114.236741),
new Waypoint("2A",22.282634,114.233351),
new Waypoint("2B",22.279129,114.228399),
new Waypoint("3A",22.279268,114.227536),
new Waypoint("3B",22.280569,114.225937),
new Waypoint("3C",22.286456,114.221554),
new Waypoint("4",22.289027,114.217311),
new Waypoint("5",22.289702,114.214565),
new Waypoint("6",22.29409,114.204769),
new Waypoint("6A",22.293435,114.198021),
new Waypoint("6B",22.289632,114.191015),
new Waypoint("6C",22.2845,114.185629),
new Waypoint("7",22.282192,114.170501),
new Waypoint("8",22.287056,114.155341),
new Waypoint("8A",22.288511,114.147735),
new Waypoint("9",22.288938,114.141362),
new Waypoint("HillRdFly",22.2873,114.135487),
new Waypoint("1",22.315808,114.217231),
new Waypoint("1A",22.318225,114.21259),
new Waypoint("1B",22.319178,114.207671),
new Waypoint("1D",22.320681,114.205874),
new Waypoint("2",22.323688,114.202312),
new Waypoint("2A",22.323361,114.191422),
new Waypoint("3",22.320314,114.190285),
new Waypoint("3A",22.315458,114.187705),
new Waypoint("4",22.309922,114.184771),
new Waypoint("5",22.308443,114.182764),
new Waypoint("6",22.306905,114.180801),
new Waypoint("6B",22.305853,114.178591),
new Waypoint("6C",22.307108,114.174278),
new Waypoint("6E",22.309575,114.167712),
new Waypoint("6D",22.312294,114.167073),
new Waypoint("7",22.321177,114.163892),
new Waypoint("7C",22.324919,114.161886),
new Waypoint("8B",22.335717,114.148947),
new Waypoint("8C",22.336272,114.144334),
new Waypoint("9",22.337126,114.139763),
new Waypoint("9A",22.338088,114.134216),
new Waypoint("9B",22.341225,114.13147),
new Waypoint("9C",22.346662,114.124904),
new Waypoint("9D",22.352011,114.12603),
new Waypoint("10",22.355613,114.123187),
new Waypoint("11",22.362876,114.117715),
new Waypoint("12",22.374087,114.104455),
new Waypoint("1A",22.295574,114.255688),
new Waypoint("1B",22.30355,114.235368),
new Waypoint("2",22.301262,114.231205),
new Waypoint("1",22.311858,114.265484),
new Waypoint("2",22.315957,114.260055),
new Waypoint("+X01",22.321376,114.251547),
new Waypoint("3A",22.315064,114.23997),
new Waypoint("3B",22.312245,114.235185),
new Waypoint("4",22.309585,114.230411),
new Waypoint("5",22.312195,114.22649),
new Waypoint("5A",22.31355,114.223368),
new Waypoint("5C",22.315366,114.218561),
new Waypoint("5D",22.315808,114.217231),
new Waypoint("6B",22.316959,114.215578),
new Waypoint("6C",22.318552,114.21486),
new Waypoint("6D",22.319302,114.214768),
new Waypoint("6E",22.323311,114.214377),
new Waypoint("6F",22.326011,114.214178),
new Waypoint("6G",22.326939,114.213701),
new Waypoint("7",22.328527,114.212558),
new Waypoint("8",22.333394,114.207666),
new Waypoint("9",22.338843,114.203396),
new Waypoint("10",22.341522,114.198461),
new Waypoint("10B",22.341621,114.192206),
new Waypoint("11",22.342346,114.189599),
new Waypoint("11A",22.34306,114.184545),
new Waypoint("12",22.344142,114.181659),
new Waypoint("13",22.342762,114.173001),
new Waypoint("13A",22.341284,114.16901),
new Waypoint("13B",22.341869,114.164976),
new Waypoint("13C",22.342802,114.157401),
new Waypoint("14A",22.340966,114.150245),
new Waypoint("14B",22.341155,114.143389),
new Waypoint("14C",22.340222,114.14207),
new Waypoint("14E",22.339914,114.136169),
new Waypoint("15",22.338088,114.134216),
new Waypoint("1",22.377897,114.179642),
new Waypoint("1A",22.375178,114.175823),
new Waypoint("1B",22.367975,114.172218),
new Waypoint("1C",22.341155,114.143389),
new Waypoint("2A",22.331221,114.14398),
new Waypoint("2D",22.326735,114.137719),
new Waypoint("2C",22.321277,114.130043),
new Waypoint("3",22.331916,114.110506),
new Waypoint("3A",22.345194,114.091344),
new Waypoint("4A",22.354085,114.085143),
new Waypoint("4C",22.347456,114.060874),
new Waypoint("5",22.332174,114.030104),
new Waypoint("6",22.302904,113.978155),
new Waypoint("5A",22.301386,113.975236),
new Waypoint("6A",22.289513,113.94747),
new Waypoint("6B",22.292233,113.939295),
new Waypoint("AirRd",22.294407,113.937525),
new Waypoint("0",22.380431,114.132881),
new Waypoint("1",22.377897,114.179642),
new Waypoint("2",22.384673,114.189599),
new Waypoint("2A",22.391255,114.196959),
new Waypoint("2B",22.392648,114.198697),
new Waypoint("2C",22.398759,114.202237),
new Waypoint("2D",22.403431,114.205585),
new Waypoint("3",22.40474,114.207237),
new Waypoint("3A",22.411584,114.212408),
new Waypoint("4",22.414004,114.212773),
new Waypoint("4A",22.435109,114.199791),
new Waypoint("5",22.444926,114.17696),
new Waypoint("5A",22.439194,114.164901),
new Waypoint("6",22.452085,114.152992),
new Waypoint("7",22.461445,114.147477),
new Waypoint("7A",22.482305,114.153507),
new Waypoint("7C",22.487658,114.14634),
new Waypoint("8",22.497551,114.131191),
new Waypoint("9",22.500207,114.123745),
new Waypoint("9A",22.504073,114.091344),
new Waypoint("10",22.501595,114.081903),
new Waypoint("10A",22.493784,114.069264),
new Waypoint("11",22.471082,114.055424),
new Waypoint("12",22.448952,114.047999),
new Waypoint("13",22.44439,114.039416),
new Waypoint("13A",22.435961,114.035468),
new Waypoint("14",22.437766,114.014954),
new Waypoint("15",22.433899,114.00341),
new Waypoint("16",22.4193,113.99192),
new Waypoint("17",22.414936,113.98199),
new Waypoint("18",22.405276,113.978047),
new Waypoint("19",22.394791,113.976642),
new Waypoint("20",22.39241,113.977334),
new Waypoint("20A",22.390228,113.97794),
new Waypoint("21",22.385952,113.979077),
new Waypoint("22",22.364384,114.014247),
new Waypoint("+X898675",22.35591,114.026177),
new Waypoint("23",22.369067,114.062312),
new Waypoint("24",22.371031,114.074049),
new Waypoint("24A",22.374087,114.104455),
new Waypoint("25",22.375456,114.120741),
new Waypoint("25A",22.380431,114.132881),
new Waypoint("CHN/HKG",22.477506,113.954272),
new Waypoint("1",22.447841,113.979528),
new Waypoint("3",22.4193,113.99192)
];
traveler = 'nagamasa';
segments = [
344560,
344561,
344562,
344563,
344564,
344565,
344566,
344567,
344568,
344569,
344570,
344571,
344572,
344573,
344574,
344575,
344576,
344577,
344578,
344579,
344580,
344581,
344582,
344583,
344584,
344585,
344586,
344587,
344588,
344589,
344590,
344591,
344592,
344593,
344594,
344595,
344596,
344597,
344598,
344599,
344600,
344601,
344602,
344603,
344604,
344605,
344606,
344607,
344608,
344609,
344610,
344611,
344612,
344613,
344614,
344615,
344616,
344617,
344618,
344619,
344620,
344621,
344622,
344623,
344624,
344625,
344626,
344627,
344628,
344629,
344630,
344631,
344632,
344633,
344634,
344635,
344636,
344637,
344638,
344639,
344640,
344641,
344642,
344643,
344644,
344645,
344646,
344647,
344648,
344649,
344650,
344651,
344652,
344653,
344654,
344655,
344656,
344657,
344658,
344659,
344660,
344661,
344662,
344663,
344664,
344665,
344666,
344667,
344668,
344669,
344670,
344671,
344672,
344673,
344674,
344675,
344676,
344677,
344678,
344679,
344680,
344681,
344682,
344683,
344684,
344685,
344686,
344687,
344688,
344689,
344690,
344691,
344692,
344693,
344694,
344695,
344696,
344697,
344698,
344699,
344700,
344701,
344702,
344703,
344704,
344705,
344706,
344707,
344708,
344709,
344710,
344711,
344712,
344713,
344714,
344715,
344716,
344717,
344718,
344719,
344720,
344721,
344722,
344723,
344724,
344725,
344726,
344727,
344728,
344729,
344730,
344731,
344732,
344733,
344734,
344735,
344736,
344737,
344738,
344739,
344740,
344741,
344742,
344743,
344744,
344745,
344746,
344747,
344748,
344749,
344750,
344751,
344752,
344753,
344754,
344755,
344756
];
clinched = [
344560,
344561,
344562,
344563,
344564,
344565,
344566,
344567,
344568,
344569,
344570,
344571,
344572,
344573,
344574,
344575,
344576,
344577,
344578,
344579,
344580,
344581,
344582,
344583,
344584,
344585,
344586,
344587,
344588,
344589,
344590,
344591,
344592,
344593,
344594,
344595,
344596,
344597,
344598,
344599,
344600,
344601,
344602,
344603,
344604,
344605,
344606,
344607,
344608,
344609,
344610,
344611,
344612,
344613,
344614,
344615,
344616,
344617,
344618,
344619,
344620,
344621,
344622,
344623,
344624,
344625,
344626,
344627,
344628,
344629,
344630,
344631,
344632,
344633,
344634,
344635,
344636,
344637,
344638,
344639,
344640,
344641,
344642,
344643,
344644,
344645,
344646,
344647,
344648,
344649,
344650,
344651,
344652,
344653,
344654,
344655,
344656,
344657,
344658,
344659,
344660,
344661,
344662,
344663,
344667,
344668,
344669,
344670,
344671,
344672,
344673,
344674,
344675,
344676,
344677,
344678,
344679,
344680,
344681,
344682,
344683,
344684,
344685,
344686,
344687,
344688,
344689,
344690,
344691,
344692,
344693,
344694,
344695,
344696,
344697,
344698,
344699,
344700,
344701,
344702,
344703,
344704,
344705,
344706,
344707,
344708,
344709,
344710,
344711,
344712,
344713,
344714,
344715,
344716,
344717,
344718,
344719,
344720,
344721,
344722,
344723,
344724,
344725,
344726,
344727,
344728,
344729,
344730,
344731,
344732,
344733,
344737,
344738,
344739,
344740,
344741,
344742,
344743,
344744,
344745,
344746,
344747,
344748,
344749,
344750,
344751,
344752,
344753,
344754,
344755,
344756
];
mapClinched = true;
mapStatus = mapStates.MAPVIEW;
genEdges = true;
}