<!-- /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: "mlt.t001", tier: 4, color: "TMlightsalmon", system: "mltt", label: "MLT T1" };
routeInfo[1] = { firstWaypoint: 49, root: "mlt.t001goz", tier: 4, color: "TMlightsalmon", system: "mltt", label: "MLT T1Goz" };
routeInfo[2] = { firstWaypoint: 61, root: "mlt.t002", tier: 4, color: "TMlightsalmon", system: "mltt", label: "MLT T2" };
routeInfo[3] = { firstWaypoint: 75, root: "mlt.t003", tier: 4, color: "TMlightsalmon", system: "mltt", label: "MLT T3" };
routeInfo[4] = { firstWaypoint: 79, root: "mlt.t004", tier: 4, color: "TMlightsalmon", system: "mltt", label: "MLT T4" };
routeInfo[5] = { firstWaypoint: 82, root: "mlt.t005", tier: 4, color: "TMlightsalmon", system: "mltt", label: "MLT T5" };
routeInfo[6] = { firstWaypoint: 89, root: "mlt.t006", tier: 4, color: "TMlightsalmon", system: "mltt", label: "MLT T6" };
routeInfo[7] = { firstWaypoint: 95, root: "mlt.t007", tier: 4, color: "TMlightsalmon", system: "mltt", label: "MLT T7" };
routeInfo[8] = { firstWaypoint: 103, root: "mlt.t008", tier: 4, color: "TMlightsalmon", system: "mltt", label: "MLT T8" };
routeInfo[9] = { firstWaypoint: 111, root: "mlt.t009", tier: 4, color: "TMlightsalmon", system: "mltt", label: "MLT T9" };
routeInfo[10] = { firstWaypoint: 117, root: "mlt.t010", tier: 4, color: "TMlightsalmon", system: "mltt", label: "MLT T10" };
routeInfo[11] = { firstWaypoint: 122, root: "mlt.t011", tier: 4, color: "TMlightsalmon", system: "mltt", label: "MLT T11" };
routeInfo[12] = { firstWaypoint: 129, root: "mlt.t012", tier: 4, color: "TMlightsalmon", system: "mltt", label: "MLT T12" };
routeInfo[13] = { firstWaypoint: 137, root: "mlt.t013", tier: 4, color: "TMlightsalmon", system: "mltt", label: "MLT T13" };
routeInfo[14] = { firstWaypoint: 140, root: "mlt.t014", tier: 4, color: "TMlightsalmon", system: "mltt", label: "MLT T14" };
routeInfo[15] = { firstWaypoint: 142, root: "mlt.t015", tier: 4, color: "TMlightsalmon", system: "mltt", label: "MLT T15" };
routeInfo[16] = { firstWaypoint: 151, root: "mlt.t016", tier: 4, color: "TMlightsalmon", system: "mltt", label: "MLT T16" };
routeInfo[17] = { firstWaypoint: 162, root: "mlt.t017", tier: 4, color: "TMlightsalmon", system: "mltt", label: "MLT T17" };
routeInfo[18] = { firstWaypoint: 167, root: "mlt.t018", tier: 4, color: "TMlightsalmon", system: "mltt", label: "MLT T18" };
routeInfo[19] = { firstWaypoint: 177, root: "mlt.t019", tier: 4, color: "TMlightsalmon", system: "mltt", label: "MLT T19" };
routeInfo[20] = { firstWaypoint: 179, root: "mlt.t020", tier: 4, color: "TMlightsalmon", system: "mltt", label: "MLT T20" };
routeInfo[21] = { firstWaypoint: 183, root: "mlt.t021", tier: 4, color: "TMlightsalmon", system: "mltt", label: "MLT T21" };
routeInfo[22] = { firstWaypoint: 188, root: "mlt.t022", tier: 4, color: "TMlightsalmon", system: "mltt", label: "MLT T22" };
routeInfo[23] = { firstWaypoint: 193, root: "mlt.t023", tier: 4, color: "TMlightsalmon", system: "mltt", label: "MLT T23" };
routeInfo[24] = { firstWaypoint: 200, root: "mlt.t024", tier: 4, color: "TMlightsalmon", system: "mltt", label: "MLT T24" };
routeInfo[25] = { firstWaypoint: 206, root: "mlt.t025", tier: 4, color: "TMlightsalmon", system: "mltt", label: "MLT T25" };
routeInfo[26] = { firstWaypoint: 208, root: "mlt.t026", tier: 4, color: "TMlightsalmon", system: "mltt", label: "MLT T26" };
routeInfo[27] = { firstWaypoint: 213, root: "mlt.t027", tier: 4, color: "TMlightsalmon", system: "mltt", label: "MLT T27" };
routeInfo[28] = { firstWaypoint: 215, root: "mlt.t028", tier: 4, color: "TMlightsalmon", system: "mltt", label: "MLT T28" };
routeInfo[29] = { firstWaypoint: 219, root: "mlt.t029", tier: 4, color: "TMlightsalmon", system: "mltt", label: "MLT T29" };
routeInfo[30] = { firstWaypoint: 223, root: "mlt.t030", tier: 4, color: "TMlightsalmon", system: "mltt", label: "MLT T30" };
routeInfo[31] = { firstWaypoint: 227, root: "mlt.t031", tier: 4, color: "TMlightsalmon", system: "mltt", label: "MLT T31" };
routeInfo[32] = { firstWaypoint: 230, root: "mlt.t032", tier: 4, color: "TMlightsalmon", system: "mltt", label: "MLT T32" };
routeInfo[33] = { firstWaypoint: 232, root: "mlt.t033", tier: 4, color: "TMlightsalmon", system: "mltt", label: "MLT T33" };
routeInfo[34] = { firstWaypoint: 235, root: "mlt.t034", tier: 4, color: "TMlightsalmon", system: "mltt", label: "MLT T34" };
waypoints = [
new Waypoint("MgaCirFry",35.989153,14.32909),
new Waypoint("+X130067",35.98707,14.328918),
new Waypoint("TriqMsid",35.986341,14.342061),
new Waypoint("T114",35.976478,14.346449),
new Waypoint("TriqMar_S",35.96592,14.354582),
new Waypoint("T115",35.962898,14.352522),
new Waypoint("+X790803",35.957218,14.351063),
new Waypoint("+X644138",35.957131,14.35147),
new Waypoint("+X388510",35.957739,14.351599),
new Waypoint("+X829398",35.957722,14.352007),
new Waypoint("+X479511",35.955186,14.354239),
new Waypoint("T117_N",35.955516,14.357994),
new Waypoint("T116_N",35.954239,14.372349),
new Waypoint("+X360904",35.954682,14.37988),
new Waypoint("+X318254",35.954309,14.380063),
new Waypoint("+X152637",35.953562,14.37825),
new Waypoint("+X297579",35.953197,14.378346),
new Waypoint("TriqMis",35.953223,14.382198),
new Waypoint("TriqRadRoti",35.952937,14.386929),
new Waypoint("TriqSanPawl",35.944781,14.384987),
new Waypoint("T116_S",35.943687,14.384322),
new Waypoint("T16",35.944069,14.411273),
new Waypoint("Triq10taFrar",35.945007,14.412904),
new Waypoint("T120",35.944381,14.423246),
new Waypoint("+X627236",35.95397,14.433675),
new Waypoint("T121",35.943131,14.449768),
new Waypoint("T118",35.933593,14.463308),
new Waypoint("TriqIbr",35.923463,14.475582),
new Waypoint("TriqEliZam",35.922212,14.486611),
new Waypoint("TriqBal",35.915921,14.486139),
new Waypoint("T18",35.911316,14.486718),
new Waypoint("T129",35.905824,14.488113),
new Waypoint("T5/T22",35.899619,14.484851),
new Waypoint("TriqGaeMan",35.89463,14.482234),
new Waypoint("T19",35.892527,14.482877),
new Waypoint("T7",35.884826,14.479315),
new Waypoint("T8_Qor",35.881697,14.485259),
new Waypoint("T6_W",35.880462,14.489679),
new Waypoint("T6_E",35.878967,14.494185),
new Waypoint("T8_Pao",35.872847,14.497147),
new Waypoint("T8_SLu",35.861926,14.496803),
new Waypoint("T8_Log",35.856048,14.48895),
new Waypoint("T9/T28",35.852814,14.494486),
new Waypoint("+X318607",35.834306,14.508648),
new Waypoint("T117_S",35.823172,14.502511),
new Waypoint("T141",35.82004,14.508648),
new Waypoint("T142",35.814646,14.524097),
new Waypoint("T143",35.817326,14.529848),
new Waypoint("T144",35.818788,14.530749),
new Waypoint("Dwe",36.0523,14.190152),
new Waypoint("T102",36.054355,14.218132),
new Waypoint("T11_N",36.050244,14.226222),
new Waypoint("T2_RabW",36.045525,14.23738),
new Waypoint("T11_S",36.045178,14.238067),
new Waypoint("T3/T10",36.044744,14.241135),
new Waypoint("T2_RabE",36.042923,14.248645),
new Waypoint("T2_Xag",36.042072,14.249804),
new Waypoint("T12",36.036121,14.260468),
new Waypoint("T110",36.032477,14.268665),
new Waypoint("T2_Mga",36.02564,14.295273),
new Waypoint("MgaCirFry",36.023696,14.29862),
new Waypoint("T1_RabW",36.045525,14.23738),
new Waypoint("T11_N",36.049862,14.237294),
new Waypoint("+X800936",36.048405,14.240813),
new Waypoint("T3_N",36.045421,14.241629),
new Waypoint("T3_S",36.045005,14.241328),
new Waypoint("TrigSel",36.0449,14.24901),
new Waypoint("T1_RabE",36.042923,14.248645),
new Waypoint("T1_Xag",36.042072,14.249804),
new Waypoint("T4",36.040251,14.257078),
new Waypoint("T12",36.038585,14.26476),
new Waypoint("T15_N",36.039695,14.288192),
new Waypoint("T15_E",36.038967,14.290252),
new Waypoint("T15_S",36.032373,14.297333),
new Waypoint("T1_Mga",36.02564,14.295273),
new Waypoint("T1/T10",36.044744,14.241135),
new Waypoint("T2_W",36.045005,14.241328),
new Waypoint("T2_E",36.045421,14.241629),
new Waypoint("T103",36.070609,14.259868),
new Waypoint("T2",36.040251,14.257078),
new Waypoint("T12",36.041743,14.265404),
new Waypoint("T114",36.05007,14.26476),
new Waypoint("T1/T22",35.899619,14.484851),
new Waypoint("UniMal",35.900392,14.479498),
new Waypoint("TriqTor",35.900575,14.47408),
new Waypoint("TriqSanGil",35.901479,14.470121),
new Waypoint("TriqNax",35.902243,14.452064),
new Waypoint("T18_E",35.90532,14.438331),
new Waypoint("T17",35.905485,14.431733),
new Waypoint("TriqGirCas",35.893552,14.508133),
new Waypoint("T22",35.889858,14.501052),
new Waypoint("T130",35.88719,14.497415),
new Waypoint("T1_W",35.880462,14.489679),
new Waypoint("+X652432",35.878549,14.491364),
new Waypoint("T1_E",35.878967,14.494185),
new Waypoint("T1",35.884826,14.479315),
new Waypoint("TriqMit",35.883765,14.473779),
new Waypoint("T130",35.892805,14.456592),
new Waypoint("T20",35.892979,14.450755),
new Waypoint("T25",35.889537,14.44243),
new Waypoint("T21",35.883591,14.415307),
new Waypoint("T16",35.890962,14.408913),
new Waypoint("T117",35.884078,14.390802),
new Waypoint("T1_Qor",35.881697,14.485259),
new Waypoint("T21",35.87535,14.476376),
new Waypoint("T132",35.868256,14.480453),
new Waypoint("T1_Log",35.856048,14.48895),
new Waypoint("T1_SLu",35.861926,14.496803),
new Waypoint("T9",35.865509,14.506416),
new Waypoint("T1_Pao",35.872847,14.497147),
new Waypoint("T24",35.87622,14.510493),
new Waypoint("T8",35.865509,14.506416),
new Waypoint("T135_N",35.861892,14.514355),
new Waypoint("T26",35.861405,14.5156),
new Waypoint("T29",35.848883,14.525471),
new Waypoint("T135_S",35.85104,14.507232),
new Waypoint("T1/T28",35.852814,14.494486),
new Waypoint("T1/T3",36.044744,14.241135),
new Waypoint("T14",36.042402,14.240427),
new Waypoint("T13",36.04084,14.240127),
new Waypoint("T12",36.040146,14.239697),
new Waypoint("T113",36.030026,14.218031),
new Waypoint("T1_W",36.050244,14.226222),
new Waypoint("T100",36.057998,14.228861),
new Waypoint("T103",36.061658,14.236522),
new Waypoint("T2_E",36.049862,14.237294),
new Waypoint("T1/T2",36.045525,14.23738),
new Waypoint("T1_E",36.045178,14.238067),
new Waypoint("T106",36.041916,14.232638),
new Waypoint("T10",36.040146,14.239697),
new Waypoint("T113",36.031453,14.236822),
new Waypoint("T13",36.029267,14.241607),
new Waypoint("T112",36.032824,14.248452),
new Waypoint("T14",36.034178,14.249182),
new Waypoint("T1",36.036121,14.260468),
new Waypoint("T2",36.038585,14.26476),
new Waypoint("T4",36.041743,14.265404),
new Waypoint("T10",36.04084,14.240127),
new Waypoint("T12",36.029267,14.241607),
new Waypoint("T113",36.02446,14.243002),
new Waypoint("T10",36.042402,14.240427),
new Waypoint("T12",36.034178,14.249182),
new Waypoint("BelBat",36.060739,14.283128),
new Waypoint("T114",36.057721,14.284265),
new Waypoint("TriqXur",36.053453,14.291346),
new Waypoint("T2_W",36.039695,14.288192),
new Waypoint("T2_S",36.038967,14.290252),
new Waypoint("TriqSanBlas",36.040146,14.296517),
new Waypoint("TriqQala",36.038793,14.309113),
new Waypoint("TriqBel",36.034646,14.309692),
new Waypoint("T2_E",36.032373,14.297333),
new Waypoint("T1",35.944069,14.411273),
new Waypoint("T118_W",35.937954,14.411488),
new Waypoint("T118_E",35.9354,14.414384),
new Waypoint("T122",35.917398,14.412625),
new Waypoint("T18",35.916686,14.417646),
new Waypoint("T17",35.904503,14.408698),
new Waypoint("T7",35.890962,14.408913),
new Waypoint("T21",35.883522,14.405179),
new Waypoint("T117_S",35.876011,14.39857),
new Waypoint("T117_N",35.875281,14.396188),
new Waypoint("TriqRill",35.862605,14.386489),
new Waypoint("T5",35.905485,14.431733),
new Waypoint("T18_W",35.90671,14.419641),
new Waypoint("T16",35.904503,14.408698),
new Waypoint("T118",35.918858,14.380589),
new Waypoint("T117/T123",35.919119,14.372435),
new Waypoint("T1",35.911316,14.486718),
new Waypoint("T129",35.909595,14.471633),
new Waypoint("TriqSanKat",35.916738,14.456527),
new Waypoint("T118",35.915886,14.450455),
new Waypoint("TriqCas",35.914774,14.444768),
new Waypoint("T5_E",35.90532,14.438331),
new Waypoint("T5/T17",35.905485,14.431733),
new Waypoint("T17_W",35.90671,14.419641),
new Waypoint("TriqKbi_E",35.909395,14.425757),
new Waypoint("T16",35.916686,14.417646),
new Waypoint("T1",35.892527,14.482877),
new Waypoint("T20",35.895308,14.465582),
new Waypoint("T130",35.889989,14.472899),
new Waypoint("T19",35.895308,14.465582),
new Waypoint("TriqBir_W",35.895013,14.449232),
new Waypoint("T7",35.892979,14.450755),
new Waypoint("T8",35.87535,14.476376),
new Waypoint("T27",35.873333,14.452171),
new Waypoint("T25",35.878897,14.438524),
new Waypoint("T7",35.883591,14.415307),
new Waypoint("T16",35.883522,14.405179),
new Waypoint("T1/T5",35.899619,14.484851),
new Waypoint("T127",35.895656,14.489465),
new Waypoint("+X960312",35.896316,14.497318),
new Waypoint("TriqJoeGas",35.890893,14.497243),
new Waypoint("T6",35.889858,14.501052),
new Waypoint("T34",35.88041,14.52929),
new Waypoint("T135_S",35.880688,14.52869),
new Waypoint("StNicRd",35.882209,14.525342),
new Waypoint("T24",35.885139,14.52354),
new Waypoint("T135_N",35.885538,14.527016),
new Waypoint("T134",35.884287,14.542809),
new Waypoint("TriqSanLeo",35.878063,14.55328),
new Waypoint("T8",35.87622,14.510493),
new Waypoint("TriqGwaGhu",35.879853,14.51781),
new Waypoint("FuqSanPawl_N",35.881566,14.519119),
new Waypoint("TriqInk",35.880714,14.519752),
new Waypoint("TriqSanLaw",35.884991,14.521641),
new Waypoint("T23",35.885139,14.52354),
new Waypoint("T7",35.889537,14.44243),
new Waypoint("T21",35.878897,14.438524),
new Waypoint("T9",35.861405,14.5156),
new Waypoint("T134_W",35.869578,14.527059),
new Waypoint("T34_W",35.872081,14.527187),
new Waypoint("T34_E",35.872394,14.53208),
new Waypoint("T134_E",35.862848,14.561112),
new Waypoint("T21",35.873333,14.452171),
new Waypoint("T132",35.860848,14.444532),
new Waypoint("T1/T9",35.852814,14.494486),
new Waypoint("T33",35.845996,14.487062),
new Waypoint("T31",35.8485,14.481869),
new Waypoint("T139",35.838899,14.463716),
new Waypoint("T9",35.848883,14.525471),
new Waypoint("T30",35.846517,14.526844),
new Waypoint("T138",35.836185,14.528604),
new Waypoint("T144",35.831453,14.530535),
new Waypoint("T29",35.846517,14.526844),
new Waypoint("TriqZej",35.8433,14.540834),
new Waypoint("T138",35.842986,14.549267),
new Waypoint("DelPowSta",35.834689,14.552615),
new Waypoint("T28",35.8485,14.481869),
new Waypoint("T32",35.840534,14.477041),
new Waypoint("T117",35.834532,14.474723),
new Waypoint("T31",35.840534,14.477041),
new Waypoint("T33",35.835298,14.486332),
new Waypoint("T28",35.845996,14.487062),
new Waypoint("TriqGaw",35.838351,14.491106),
new Waypoint("T32",35.835298,14.486332),
new Waypoint("End",35.884078,14.507446),
new Waypoint("T8",35.87622,14.510493),
new Waypoint("T26_W",35.872081,14.527187),
new Waypoint("T26_E",35.872394,14.53208),
new Waypoint("T134",35.874759,14.532723),
new Waypoint("T23",35.88041,14.52929)
];
traveler = 'michih';
segments = [
392177,
392178,
392179,
392180,
392181,
392182,
392183,
392184,
392185,
392186,
392187,
392188,
392189,
392190,
392191,
392192,
392193,
392194,
392195,
392196,
392197,
392198,
392199,
392200,
392201,
392202,
392203,
392204,
392205,
392206,
392207,
392208,
392209,
392210,
392211,
392212,
392213,
392214,
392215,
392216,
392217,
392218,
392219,
392220,
392221,
392222,
392223,
392224,
392166,
392167,
392168,
392169,
392170,
392171,
392172,
392173,
392174,
392175,
392176,
392225,
392226,
392227,
392228,
392229,
392230,
392231,
392232,
392233,
392234,
392235,
392236,
392237,
392238,
392239,
392240,
392241,
392242,
392243,
392244,
392245,
392246,
392247,
392248,
392249,
392250,
392251,
392252,
392253,
392254,
392255,
392256,
392257,
392258,
392259,
392260,
392261,
392262,
392263,
392264,
392265,
392266,
392267,
392268,
392269,
392270,
392271,
392272,
392273,
392274,
392275,
392276,
392277,
392278,
392279,
392280,
392281,
392282,
392283,
392284,
392285,
392286,
392287,
392288,
392289,
392290,
392291,
392292,
392293,
392294,
392295,
392296,
392297,
392298,
392299,
392300,
392301,
392302,
392303,
392304,
392305,
392306,
392307,
392308,
392309,
392310,
392311,
392312,
392313,
392314,
392315,
392316,
392317,
392318,
392319,
392320,
392321,
392322,
392323,
392324,
392325,
392326,
392327,
392328,
392329,
392330,
392331,
392332,
392333,
392334,
392335,
392336,
392337,
392338,
392339,
392340,
392341,
392342,
392343,
392344,
392345,
392346,
392347,
392348,
392349,
392350,
392351,
392352,
392353,
392354,
392355,
392356,
392357,
392358,
392359,
392360,
392361,
392362,
392363,
392364,
392365,
392366,
392367,
392368,
392369,
392370,
392371
];
clinched = [
392177,
392178,
392179,
392180,
392181,
392182,
392183,
392184,
392185,
392186,
392187,
392188,
392189,
392190,
392191,
392192,
392193,
392194,
392195,
392196,
392197,
392198,
392199,
392200,
392201,
392202,
392203,
392204,
392205,
392206,
392207,
392208,
392209,
392210,
392211,
392212,
392213,
392214,
392215,
392216,
392217,
392218,
392219,
392220,
392221,
392222,
392223,
392224,
392166,
392167,
392168,
392169,
392170,
392171,
392172,
392173,
392174,
392175,
392176,
392225,
392226,
392227,
392228,
392229,
392230,
392231,
392232,
392233,
392234,
392235,
392236,
392237,
392238,
392239,
392240,
392241,
392242,
392243,
392244,
392245,
392246,
392247,
392248,
392249,
392250,
392251,
392252,
392253,
392254,
392255,
392256,
392257,
392258,
392259,
392260,
392261,
392262,
392263,
392264,
392265,
392266,
392267,
392268,
392269,
392270,
392271,
392272,
392273,
392274,
392275,
392276,
392277,
392278,
392279,
392280,
392281,
392282,
392283,
392284,
392285,
392286,
392287,
392288,
392289,
392290,
392291,
392292,
392293,
392294,
392295,
392296,
392297,
392298,
392299,
392300,
392301,
392302,
392303,
392304,
392305,
392306,
392307,
392308,
392309,
392310,
392311,
392312,
392313,
392314,
392315,
392316,
392317,
392318,
392319,
392320,
392321,
392322,
392323,
392324,
392325,
392326,
392327,
392328,
392329,
392330,
392331,
392332,
392333,
392334,
392335,
392336,
392337,
392338,
392339,
392340,
392341,
392342,
392343,
392344,
392345,
392346,
392347,
392348,
392349,
392350,
392351,
392352,
392353,
392354,
392355,
392356,
392357,
392358,
392359,
392360,
392361,
392362,
392363,
392364,
392365,
392366,
392367,
392368,
392369,
392370,
392371
];
mapClinched = true;
mapStatus = mapStates.MAPVIEW;
genEdges = true;
}