<!-- /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: "mkd.a001", tier: 4, color: "TMlightsalmon", system: "mkda", label: "MKD A1" };
routeInfo[1] = { firstWaypoint: 48, root: "mkd.a001pri", tier: 4, color: "TMlightsalmon", system: "mkda", label: "MKD A1Pri" };
routeInfo[2] = { firstWaypoint: 63, root: "mkd.a002", tier: 4, color: "TMlightsalmon", system: "mkda", label: "MKD A2" };
routeInfo[3] = { firstWaypoint: 154, root: "mkd.a003", tier: 4, color: "TMlightsalmon", system: "mkda", label: "MKD A3" };
routeInfo[4] = { firstWaypoint: 191, root: "mkd.a003bit", tier: 4, color: "TMlightsalmon", system: "mkda", label: "MKD A3Bit" };
routeInfo[5] = { firstWaypoint: 201, root: "mkd.a003sht", tier: 4, color: "TMlightsalmon", system: "mkda", label: "MKD A3Sht" };
routeInfo[6] = { firstWaypoint: 239, root: "mkd.a004", tier: 4, color: "TMlightsalmon", system: "mkda", label: "MKD A4" };
waypoints = [
new Waypoint("SRB/MKD",42.236874,21.703341),
new Waypoint("1",42.223941,21.702504),
new Waypoint("2",42.186875,21.706216),
new Waypoint("3",42.173323,21.709456),
new Waypoint("4",42.156023,21.711345),
new Waypoint("5",42.133841,21.702016),
new Waypoint("6",42.07479,21.696614),
new Waypoint("7",42.047412,21.68345),
new Waypoint("8",42.025431,21.675344),
new Waypoint("9",41.997052,21.663607),
new Waypoint("10",41.984728,21.65401),
new Waypoint("11",41.959079,21.632144),
new Waypoint("12",41.955433,21.630798),
new Waypoint("13",41.938357,21.626624),
new Waypoint("+X683",41.914829,21.642251),
new Waypoint("14",41.893365,21.682119),
new Waypoint("+X805",41.875185,21.701431),
new Waypoint("+X556",41.842967,21.712418),
new Waypoint("+X558",41.814954,21.711388),
new Waypoint("15",41.774,21.75705),
new Waypoint("16",41.748582,21.768894),
new Waypoint("17",41.728673,21.794069),
new Waypoint("+X115",41.715007,21.816943),
new Waypoint("18",41.685436,21.832173),
new Waypoint("19",41.680292,21.829834),
new Waypoint("+X808",41.666965,21.828504),
new Waypoint("+X912",41.640624,21.849918),
new Waypoint("+X435",41.619613,21.905923),
new Waypoint("+X705",41.593493,21.912832),
new Waypoint("20",41.562602,21.955195),
new Waypoint("21",41.549917,21.97463),
new Waypoint("+X519",41.558303,22.009778),
new Waypoint("22",41.49771,22.100464),
new Waypoint("+X267",41.476428,22.109642),
new Waypoint("+X862",41.445236,22.179337),
new Waypoint("+X470",41.428586,22.18432),
new Waypoint("+X786",41.417146,22.197704),
new Waypoint("23",41.41684,22.2304),
new Waypoint("+X384",41.403499,22.283106),
new Waypoint("+X791",41.37478,22.314863),
new Waypoint("+X799",41.369824,22.339679),
new Waypoint("24",41.297638,22.430804),
new Waypoint("25",41.262606,22.471274),
new Waypoint("+X217",41.245409,22.484078),
new Waypoint("R1102_Prd",41.203682,22.496073),
new Waypoint("R1102/R1109",41.151984,22.516635),
new Waypoint("Bog",41.139082,22.541993),
new Waypoint("MKD/GRC",41.130771,22.551391),
new Waypoint("R1102",41.567137,21.955715),
new Waypoint("A1",41.562602,21.955195),
new Waypoint("R1107",41.525206,21.946751),
new Waypoint("Man",41.491892,21.928389),
new Waypoint("Trs",41.47523,21.904507),
new Waypoint("+X29",41.466013,21.910858),
new Waypoint("R1103",41.443305,21.896696),
new Waypoint("+X77",41.435411,21.874471),
new Waypoint("Far",41.441773,21.822318),
new Waypoint("+X59",41.422718,21.794595),
new Waypoint("+X58",41.38925,21.771598),
new Waypoint("R29172",41.362791,21.695777),
new Waypoint("+X44",41.370239,21.678091),
new Waypoint("+X37",41.368822,21.614571),
new Waypoint("A3",41.3568,21.581064),
new Waypoint("BGR/MKD",42.21946,22.459617),
new Waypoint("R1210",42.218213,22.448276),
new Waypoint("Uzem",42.222638,22.42331),
new Waypoint("R2250",42.230686,22.364243),
new Waypoint("UliMarTito_E",42.212674,22.346148),
new Waypoint("R2245",42.208331,22.338193),
new Waypoint("ShaMost",42.201993,22.333714),
new Waypoint("UliSveOso",42.191963,22.309102),
new Waypoint("+X24",42.172564,22.229435),
new Waypoint("Psa",42.171821,22.202157),
new Waypoint("R29281",42.167623,22.118273),
new Waypoint("R2248",42.167598,22.117656),
new Waypoint("R1205",42.156317,22.053155),
new Waypoint("Rug",42.147643,21.976851),
new Waypoint("+X25",42.158874,21.930664),
new Waypoint("+X18",42.144283,21.91515),
new Waypoint("R29277",42.159936,21.874332),
new Waypoint("R1207/R2237",42.17023,21.817871),
new Waypoint("+X35",42.175872,21.787734),
new Waypoint("ToR2237",42.163507,21.753954),
new Waypoint("1",42.156719,21.726558),
new Waypoint("2",42.156023,21.711345),
new Waypoint("5(A1)",42.133841,21.702016),
new Waypoint("6(A1)",42.07479,21.696614),
new Waypoint("7(A1)",42.047412,21.68345),
new Waypoint("8(A1)",42.025431,21.675344),
new Waypoint("9(A1)",41.997052,21.663607),
new Waypoint("8",41.984728,21.65401),
new Waypoint("9",41.981985,21.619249),
new Waypoint("10",41.999751,21.576118),
new Waypoint("11",41.996554,21.554811),
new Waypoint("12",41.994584,21.533203),
new Waypoint("13",42.018342,21.533911),
new Waypoint("+X773",42.033548,21.524019),
new Waypoint("14",42.031891,21.511595),
new Waypoint("Smi",42.032456,21.485642),
new Waypoint("15",42.040943,21.45484),
new Waypoint("16",42.052734,21.421795),
new Waypoint("17",42.052917,21.381943),
new Waypoint("18",42.053272,21.364385),
new Waypoint("+X958",42.055411,21.343431),
new Waypoint("19",42.038054,21.33575),
new Waypoint("20",42.007995,21.321963),
new Waypoint("21",41.991068,21.311964),
new Waypoint("+X659",41.98007,21.226766),
new Waypoint("+X511",41.982535,21.186619),
new Waypoint("22",41.964939,21.142518),
new Waypoint("+X429",41.964085,21.11834),
new Waypoint("+X764",41.989864,21.089244),
new Waypoint("23",41.987427,21.06548),
new Waypoint("24",42.00245,20.991338),
new Waypoint("R2233_Tet",41.985677,20.966034),
new Waypoint("25",41.982774,20.959693),
new Waypoint("26",41.944338,20.949286),
new Waypoint("27",41.916581,20.942414),
new Waypoint("28",41.871542,20.930758),
new Waypoint("29",41.852397,20.925822),
new Waypoint("IliSka",41.813937,20.91548),
new Waypoint("30",41.805594,20.902192),
new Waypoint("Jna",41.7948,20.886126),
new Waypoint("R29279",41.792685,20.881469),
new Waypoint("+X707",41.742047,20.834356),
new Waypoint("R1202",41.727095,20.841193),
new Waypoint("+X250",41.719836,20.829343),
new Waypoint("+X410",41.71739,20.838532),
new Waypoint("+X630",41.660938,20.857179),
new Waypoint("+X486",41.65913,20.875021),
new Waypoint("+X123",41.644183,20.887456),
new Waypoint("+X379",41.633632,20.915265),
new Waypoint("Stro",41.599884,20.951475),
new Waypoint("+X999",41.553767,20.963416),
new Waypoint("R2231",41.528712,20.957108),
new Waypoint("GoceDel",41.51986,20.952344),
new Waypoint("R1303",41.501065,20.952526),
new Waypoint("R1305",41.479506,20.918714),
new Waypoint("R2246",41.482328,20.824445),
new Waypoint("+X438",41.465213,20.812526),
new Waypoint("+X573",41.449972,20.828061),
new Waypoint("+X605",41.427428,20.824714),
new Waypoint("Vrb",41.413461,20.81582),
new Waypoint("+X243",41.389278,20.824708),
new Waypoint("+X108",41.317182,20.792699),
new Waypoint("R29273",41.285498,20.791272),
new Waypoint("31",41.23537,20.767529),
new Waypoint("Gor",41.191424,20.750272),
new Waypoint("32",41.161759,20.750427),
new Waypoint("ToR1208",41.177289,20.706892),
new Waypoint("R1201",41.184008,20.675508),
new Waypoint("UliMarTito_W",41.173914,20.656915),
new Waypoint("R2240",41.164699,20.637903),
new Waypoint("MKD/ALB",41.09022,20.607734),
new Waypoint("A1",41.3568,21.581064),
new Waypoint("10",41.330021,21.557397),
new Waypoint("9",41.311473,21.519926),
new Waypoint("8",41.287175,21.497412),
new Waypoint("+X22",41.247396,21.44929),
new Waypoint("7",41.223964,21.437695),
new Waypoint("+X82",41.172575,21.388203),
new Waypoint("+X47",41.145194,21.367282),
new Waypoint("6",41.07441,21.342927),
new Waypoint("+X10",41.03861,21.319115),
new Waypoint("R1101_Bit",41.045832,21.290174),
new Waypoint("+X179",41.055546,21.277406),
new Waypoint("+X996",41.070782,21.242731),
new Waypoint("5",41.069385,21.218703),
new Waypoint("4",41.062952,21.146163),
new Waypoint("+X887",41.069419,21.134949),
new Waypoint("+X803",41.072711,21.055995),
new Waypoint("R1308",41.065686,21.052621),
new Waypoint("+X443",41.070942,21.033003),
new Waypoint("UliKor",41.086079,21.019549),
new Waypoint("R1307",41.085299,21.00852),
new Waypoint("UliBorKil",41.092734,21.011438),
new Waypoint("R29371",41.111766,21.011701),
new Waypoint("+X874",41.133611,21.00719),
new Waypoint("DolKru",41.149359,20.989278),
new Waypoint("+X584",41.15898,20.983629),
new Waypoint("+X869",41.160563,20.951743),
new Waypoint("+X985",41.191315,20.944705),
new Waypoint("Kur",41.204683,20.903892),
new Waypoint("+X719",41.195771,20.875096),
new Waypoint("+X856",41.176025,20.862426),
new Waypoint("Kos",41.174426,20.836762),
new Waypoint("Uli7Noe",41.125377,20.814908),
new Waypoint("3",41.128856,20.784861),
new Waypoint("+X447",41.141199,20.761714),
new Waypoint("ToR1208",41.159479,20.751294),
new Waypoint("2",41.161759,20.750427),
new Waypoint("A3",41.07441,21.342927),
new Waypoint("R1101_E",41.068325,21.343791),
new Waypoint("R1101/R1311",41.038056,21.346725),
new Waypoint("+X62",41.032017,21.349579),
new Waypoint("NikTes_N",41.023777,21.34186),
new Waypoint("E65_N",41.019655,21.341296),
new Waypoint("R2333",41.015227,21.344671),
new Waypoint("Kar",40.995257,21.380092),
new Waypoint("R2338",40.926184,21.417149),
new Waypoint("MKD/GRC",40.91768,21.417332),
new Waypoint("R1312",41.773104,21.847419),
new Waypoint("R1204_N",41.802555,22.011293),
new Waypoint("R1204_S",41.806177,22.021548),
new Waypoint("11",41.812209,22.034551),
new Waypoint("A4_S",41.780941,22.126551),
new Waypoint("Shi",41.787085,22.143175),
new Waypoint("+X72",41.786711,22.158037),
new Waypoint("+X23",41.809668,22.172223),
new Waypoint("+X68",41.838351,22.22384),
new Waypoint("R1205",41.861423,22.23562),
new Waypoint("+X97",41.892007,22.286491),
new Waypoint("R2342_Spa",41.897591,22.31106),
new Waypoint("+X49",41.903674,22.3344),
new Waypoint("*R2342",41.898683,22.365825),
new Waypoint("Koc",41.902029,22.390566),
new Waypoint("14",41.90266,22.411938),
new Waypoint("Ori",41.910088,22.454547),
new Waypoint("R1304",41.910769,22.47372),
new Waypoint("Ist",41.93006,22.501953),
new Waypoint("+X37",41.951815,22.539348),
new Waypoint("+X24",41.963216,22.570317),
new Waypoint("+X80",41.993615,22.585959),
new Waypoint("+X58",42.02078,22.584948),
new Waypoint("R1210",42.024192,22.588663),
new Waypoint("MakKam_E",42.01835,22.592483),
new Waypoint("+X94",42.011642,22.591871),
new Waypoint("Luk",42.015361,22.604719),
new Waypoint("+X40",41.997275,22.620404),
new Waypoint("+X54",41.98718,22.668384),
new Waypoint("R2345",41.991538,22.677771),
new Waypoint("+X57",41.994776,22.69063),
new Waypoint("+X15",41.975755,22.724297),
new Waypoint("Och",41.980003,22.737992),
new Waypoint("R2341",41.971943,22.773011),
new Waypoint("R2343",41.971392,22.773419),
new Waypoint("R1302",41.959973,22.785468),
new Waypoint("+X98",41.985888,22.84402),
new Waypoint("MKD/BGR",41.986482,22.874994),
new Waypoint("RKS/MKD",42.141721,21.302598),
new Waypoint("+X714",42.080269,21.342847),
new Waypoint("R2239",42.068225,21.36711),
new Waypoint("17(A2)",42.052917,21.381943),
new Waypoint("16(A2)",42.052734,21.421795),
new Waypoint("15(A2)",42.040943,21.45484),
new Waypoint("Smi",42.032456,21.485642),
new Waypoint("14(A2)",42.031891,21.511595),
new Waypoint("+X773",42.033548,21.524019),
new Waypoint("13(A2)",42.018342,21.533911),
new Waypoint("12(A2)",41.994584,21.533203),
new Waypoint("+X520",41.980262,21.542258),
new Waypoint("Kad",41.95888,21.584063),
new Waypoint("Pet",41.941245,21.621088),
new Waypoint("13(A1)",41.938357,21.626624),
new Waypoint("12(A1)",41.955433,21.630798),
new Waypoint("11(A1)",41.959079,21.632144),
new Waypoint("10(A1)",41.984728,21.65401),
new Waypoint("+X459",41.986658,21.664653),
new Waypoint("SreKon",41.962083,21.714649),
new Waypoint("+X762",41.945343,21.79275),
new Waypoint("R2135",41.916645,21.878618),
new Waypoint("+X111",41.90288,21.91214),
new Waypoint("R1204_SveN",41.877246,21.938195),
new Waypoint("R1204_SveS",41.855674,21.962657),
new Waypoint("+X358",41.834014,21.989608),
new Waypoint("11",41.812209,22.034551),
new Waypoint("A3_E",41.780941,22.126551),
new Waypoint("12",41.765286,22.158034),
new Waypoint("13",41.763013,22.160529),
new Waypoint("R1204/R2433",41.711388,22.153255),
new Waypoint("Dol",41.687445,22.173645),
new Waypoint("+X915",41.645472,22.222684),
new Waypoint("R1103",41.621678,22.279099),
new Waypoint("+X64",41.624239,22.304944),
new Waypoint("Buc",41.637232,22.349335),
new Waypoint("+X193",41.638282,22.406015),
new Waypoint("R2433_Rad",41.62639,22.442493),
new Waypoint("R1310",41.621987,22.456162),
new Waypoint("+X633",41.607407,22.462567),
new Waypoint("R1403_Sul",41.592305,22.490172),
new Waypoint("+X29",41.586283,22.50847),
new Waypoint("R1403_Kal",41.581524,22.518421),
new Waypoint("+X467",41.577319,22.528657),
new Waypoint("R1403/R29471",41.541658,22.582789),
new Waypoint("Vla",41.519845,22.611752),
new Waypoint("R1403_Dob",41.49378,22.632072),
new Waypoint("R2432_Gra",41.481339,22.634526),
new Waypoint("+X389",41.457479,22.636653),
new Waypoint("R1403_Str",41.44764,22.642339),
new Waypoint("R1401/R2432",41.438824,22.649603),
new Waypoint("R1302",41.443366,22.691451),
new Waypoint("R1404",41.439994,22.707651),
new Waypoint("Sek",41.437257,22.796116),
new Waypoint("NovoSelo",41.412656,22.881888),
new Waypoint("+X937",41.402759,22.882719),
new Waypoint("R1402",41.395548,22.942071),
new Waypoint("MKD/BGR",41.396642,22.965889)
];
traveler = 'michih';
segments = [
391521,
391522,
391523,
391524,
391525,
391526,
391527,
391528,
391529,
391530,
391531,
391532,
391533,
391534,
391535,
391536,
391537,
391538,
391539,
391540,
391541,
391542,
391543,
391544,
391545,
391546,
391547,
391548,
391549,
391550,
391551,
391552,
391553,
391554,
391555,
391556,
391557,
391558,
391559,
391560,
391561,
391562,
391563,
391564,
391565,
391566,
391567,
391568,
391569,
391570,
391571,
391572,
391573,
391574,
391575,
391576,
391577,
391578,
391579,
391580,
391581,
391582,
391583,
391584,
391585,
391586,
391587,
391588,
391589,
391590,
391591,
391592,
391593,
391594,
391595,
391596,
391597,
391598,
391599,
391600,
391601,
391602,
391603,
391604,
391605,
391606,
391607,
391608,
391609,
391610,
391611,
391612,
391613,
391614,
391615,
391616,
391617,
391618,
391619,
391620,
391621,
391622,
391623,
391624,
391625,
391626,
391627,
391628,
391629,
391630,
391631,
391632,
391633,
391634,
391635,
391636,
391637,
391638,
391639,
391640,
391641,
391642,
391643,
391644,
391645,
391646,
391647,
391648,
391649,
391650,
391651,
391652,
391653,
391654,
391655,
391656,
391657,
391658,
391659,
391660,
391661,
391662,
391663,
391664,
391665,
391666,
391667,
391668,
391669,
391670,
391671,
391672,
391673,
391674,
391675,
391676,
391677,
391678,
391679,
391680,
391681,
391682,
391683,
391684,
391685,
391686,
391687,
391688,
391689,
391690,
391691,
391692,
391693,
391694,
391695,
391696,
391697,
391698,
391699,
391700,
391701,
391702,
391703,
391704,
391705,
391706,
391707,
391745,
391746,
391747,
391748,
391749,
391750,
391751,
391752,
391753,
391708,
391709,
391710,
391711,
391712,
391713,
391714,
391715,
391716,
391717,
391718,
391719,
391720,
391721,
391722,
391723,
391724,
391725,
391726,
391727,
391728,
391729,
391730,
391731,
391732,
391733,
391734,
391735,
391736,
391737,
391738,
391739,
391740,
391741,
391742,
391743,
391744,
391754,
391755,
391756,
391757,
391758,
391759,
391760,
391761,
391762,
391763,
391764,
391765,
391766,
391767,
391768,
391769,
391770,
391771,
391772,
391773,
391774,
391775,
391776,
391777,
391778,
391779,
391780,
391781,
391782,
391783,
391784,
391785,
391786,
391787,
391788,
391789,
391790,
391791,
391792,
391793,
391794,
391795,
391796,
391797,
391798,
391799,
391800,
391801,
391802,
391803,
391804,
391805,
391806,
391807,
391808,
391809,
391810
];
clinched = [
391521,
391522,
391523,
391524,
391525,
391526,
391527,
391528,
391529,
391530,
391531,
391532,
391533,
391534,
391535,
391536,
391537,
391538,
391539,
391540,
391541,
391542,
391543,
391544,
391545,
391546,
391547,
391548,
391549,
391550,
391551,
391552,
391553,
391554,
391555,
391556,
391557,
391558,
391559,
391560,
391561,
391562,
391563,
391564,
391565,
391566,
391567,
391569,
391570,
391571,
391572,
391573,
391574,
391575,
391576,
391577,
391578,
391579,
391580,
391581,
391603,
391604,
391605,
391606,
391607,
391608,
391609,
391610,
391611,
391612,
391613,
391614,
391615,
391616,
391617,
391618,
391619,
391620,
391621,
391622,
391623,
391624,
391625,
391626,
391627,
391628,
391629,
391630,
391631,
391632,
391633,
391634,
391635,
391636,
391637,
391638,
391667,
391668,
391669,
391670,
391671,
391672,
391673,
391674,
391675,
391676,
391677,
391678,
391679,
391680,
391681,
391682,
391683,
391684,
391685,
391686,
391687,
391688,
391689,
391690,
391691,
391692,
391693,
391694,
391695,
391696,
391697,
391698,
391699,
391700,
391701,
391702,
391703,
391704,
391705,
391706,
391707,
391745,
391746,
391749,
391750,
391751,
391752,
391753,
391708,
391709,
391710,
391711,
391721,
391722,
391723,
391724,
391725,
391726,
391727,
391728,
391729,
391730,
391731,
391732,
391733,
391734,
391735,
391736,
391737,
391738,
391739,
391740,
391741,
391742,
391743,
391744,
391754,
391755,
391756,
391757,
391758,
391759,
391760,
391761,
391762,
391763,
391764,
391765,
391766,
391767,
391768,
391769,
391770,
391771,
391772,
391773,
391774,
391775,
391776,
391777,
391778,
391779,
391780,
391781,
391782
];
mapClinched = true;
mapStatus = mapStates.MAPVIEW;
genEdges = true;
}