<!-- /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: "rou.a000", tier: 1, color: "TMblue", system: "roua", label: "ROU A0" };
routeInfo[1] = { firstWaypoint: 3, root: "rou.a000jil", tier: 1, color: "TMblue", system: "roua", label: "ROU A0Jil" };
routeInfo[2] = { firstWaypoint: 7, root: "rou.a001", tier: 1, color: "TMblue", system: "roua", label: "ROU A1" };
routeInfo[3] = { firstWaypoint: 34, root: "rou.a001ara", tier: 1, color: "TMblue", system: "roua", label: "ROU A1Ara" };
routeInfo[4] = { firstWaypoint: 62, root: "rou.a001sib", tier: 1, color: "TMblue", system: "roua", label: "ROU A1Sib" };
routeInfo[5] = { firstWaypoint: 103, root: "rou.a002", tier: 1, color: "TMblue", system: "roua", label: "ROU A2" };
routeInfo[6] = { firstWaypoint: 137, root: "rou.a003", tier: 1, color: "TMblue", system: "roua", label: "ROU A3" };
routeInfo[7] = { firstWaypoint: 164, root: "rou.a003bra", tier: 1, color: "TMblue", system: "roua", label: "ROU A3Bra" };
routeInfo[8] = { firstWaypoint: 166, root: "rou.a003buc", tier: 1, color: "TMblue", system: "roua", label: "ROU A3Buc" };
routeInfo[9] = { firstWaypoint: 184, root: "rou.a003ora", tier: 1, color: "TMblue", system: "roua", label: "ROU A3Ora" };
routeInfo[10] = { firstWaypoint: 187, root: "rou.a003sup", tier: 1, color: "TMblue", system: "roua", label: "ROU A3Sup" };
routeInfo[11] = { firstWaypoint: 190, root: "rou.a004", tier: 1, color: "TMblue", system: "roua", label: "ROU A4" };
routeInfo[12] = { firstWaypoint: 199, root: "rou.a006", tier: 1, color: "TMblue", system: "roua", label: "ROU A6" };
routeInfo[13] = { firstWaypoint: 205, root: "rou.a007", tier: 1, color: "TMblue", system: "roua", label: "ROU A7" };
routeInfo[14] = { firstWaypoint: 212, root: "rou.a010", tier: 1, color: "TMblue", system: "roua", label: "ROU A10" };
routeInfo[15] = { firstWaypoint: 230, root: "rou.a011", tier: 1, color: "TMblue", system: "roua", label: "ROU A11" };
waypoints = [
new Waypoint("A3",44.573201,26.180516),
new Waypoint("+X1",44.598237,26.133792),
new Waypoint("DN1",44.595915,26.074183),
new Waypoint("DN6",44.355006,25.970585),
new Waypoint("+X1",44.314975,26.038928),
new Waypoint("DN5",44.313489,26.06259),
new Waypoint("DN4",44.34631,26.224151),
new Waypoint("BulPre",44.435733,25.974126),
new Waypoint("DNCB",44.436319,25.966782),
new Waypoint("DJ601_E",44.438882,25.936789),
new Waypoint("DJ602",44.461962,25.878822),
new Waypoint("BolDeal",44.467012,25.826197),
new Waypoint("+X02",44.469194,25.773239),
new Waypoint("DJ601_W",44.462287,25.735044),
new Waypoint("Spa_A",44.479759,25.675478),
new Waypoint("+X03",44.490597,25.612993),
new Waypoint("VanMici",44.504189,25.57786),
new Waypoint("DJ711A",44.534049,25.529677),
new Waypoint("+X04",44.581145,25.469227),
new Waypoint("+X05",44.609962,25.451546),
new Waypoint("DC75",44.6311,25.414467),
new Waypoint("+X06",44.646338,25.384855),
new Waypoint("DN61",44.65684,25.338292),
new Waypoint("DJ702F",44.667707,25.308122),
new Waypoint("+X07",44.697,25.245638),
new Waypoint("Spa_B",44.700447,25.224137),
new Waypoint("DJ702A",44.705808,25.163068),
new Waypoint("+X08",44.752158,25.091057),
new Waypoint("DJ703B",44.755145,25.083632),
new Waypoint("DC105",44.763616,25.042777),
new Waypoint("DJ503",44.786739,24.992437),
new Waypoint("DN65B",44.81534,24.951131),
new Waypoint("DN73",44.869029,24.8809),
new Waypoint("DN7",44.897121,24.838243),
new Waypoint("DN68A_Mar",45.857918,22.244396),
new Waypoint("+X611587",45.827065,22.194614),
new Waypoint("+X224960",45.807623,22.108526),
new Waypoint("DN68A_Dum",45.812681,22.072048),
new Waypoint("+X228",45.81576,21.966133),
new Waypoint("A6",45.797332,21.853523),
new Waypoint("+X455708",45.774348,21.756535),
new Waypoint("DJ572",45.80069,21.661155),
new Waypoint("+X993323",45.812529,21.491661),
new Waypoint("DN6",45.804632,21.409779),
new Waypoint("+X231",45.805829,21.397076),
new Waypoint("DJ691",45.860533,21.314794),
new Waypoint("+X232",45.876744,21.287041),
new Waypoint("+X233",45.900163,21.275711),
new Waypoint("DJ693",45.966902,21.286354),
new Waypoint("+X234",46.052505,21.304808),
new Waypoint("+X235",46.097757,21.334162),
new Waypoint("DN69",46.125545,21.315365),
new Waypoint("DJ682",46.141576,21.306358),
new Waypoint("DJ682F",46.172639,21.281247),
new Waypoint("+X236",46.181673,21.275282),
new Waypoint("A11",46.185476,21.241894),
new Waypoint("+X237",46.188506,21.210995),
new Waypoint("+X238",46.174244,21.131001),
new Waypoint("DN7_Pec",46.180366,21.115443),
new Waypoint("+X554170",46.208468,21.045341),
new Waypoint("DN7G",46.210057,20.788858),
new Waypoint("ROU/HUN",46.213517,20.759354),
new Waypoint("DN7_Boi",45.639587,24.260598),
new Waypoint("+X7",45.714198,24.230712),
new Waypoint("+X6",45.734994,24.20095),
new Waypoint("DN1/7_Sib",45.749169,24.201403),
new Waypoint("+X200",45.762493,24.20713),
new Waypoint("DJ106",45.789163,24.199104),
new Waypoint("StrHenCoa",45.800683,24.188118),
new Waypoint("DN14",45.823357,24.151554),
new Waypoint("+X201",45.826407,24.090014),
new Waypoint("DN7H",45.819468,24.074435),
new Waypoint("+X202",45.803256,24.053621),
new Waypoint("+X203",45.779137,23.95998),
new Waypoint("DJ143D",45.809329,23.902387),
new Waypoint("+X204",45.828321,23.863935),
new Waypoint("+X205",45.86509,23.8799),
new Waypoint("DJ143B",45.875698,23.869643),
new Waypoint("+X206",45.894489,23.815012),
new Waypoint("+X20A",45.901179,23.759737),
new Waypoint("DJ106I",45.918943,23.72118),
new Waypoint("+X207",45.921961,23.632879),
new Waypoint("DN1/7_Seb",45.945958,23.592539),
new Waypoint("+X208",45.96893,23.59314),
new Waypoint("DN1",45.975093,23.55734),
new Waypoint("A10",45.98023,23.544924),
new Waypoint("DN7_Seb",45.977155,23.521589),
new Waypoint("+X210",45.957475,23.440533),
new Waypoint("DN7_Ora",45.890051,23.258183),
new Waypoint("+X211",45.87274,23.16699),
new Waypoint("+X212",45.836813,23.108368),
new Waypoint("DN66",45.849728,23.045197),
new Waypoint("+X213",45.869274,23.018761),
new Waypoint("+X214",45.909301,22.912502),
new Waypoint("DN76",45.912672,22.876807),
new Waypoint("+X1",45.928972,22.858155),
new Waypoint("+X2",45.911675,22.798219),
new Waypoint("+X3",45.947241,22.714362),
new Waypoint("DN7_Ili",45.943757,22.62454),
new Waypoint("+X4",45.936169,22.550726),
new Waypoint("DN68A_Gri",45.916982,22.51862),
new Waypoint("+X5",45.882017,22.463629),
new Waypoint("DN68A_Oha",45.886129,22.403269),
new Waypoint("SosLib",44.405465,26.210654),
new Waypoint("CenBuc",44.407129,26.233764),
new Waypoint("DC55",44.408976,26.277186),
new Waypoint("DJ100",44.429564,26.352757),
new Waypoint("+X2",44.452033,26.444049),
new Waypoint("DJ402",44.448809,26.515975),
new Waypoint("+X3",44.444382,26.554642),
new Waypoint("+X4",44.4491,26.62159),
new Waypoint("+X5",44.439142,26.65884),
new Waypoint("+X6",44.446955,26.718063),
new Waypoint("+X7",44.440337,26.815224),
new Waypoint("DN3",44.425827,26.862044),
new Waypoint("+X8",44.422808,26.971779),
new Waypoint("+X9",44.427835,27.031689),
new Waypoint("+X10",44.423299,27.269096),
new Waypoint("DN21",44.40673,27.376986),
new Waypoint("+X11",44.397915,27.457066),
new Waypoint("+X12",44.401288,27.623749),
new Waypoint("+X13",44.418027,27.713013),
new Waypoint("+X14",44.415973,27.769575),
new Waypoint("DN3B",44.394956,27.831802),
new Waypoint("+X15",44.383195,27.848196),
new Waypoint("+X16",44.344967,28.003035),
new Waypoint("DN22C",44.3314,28.027217),
new Waypoint("+X17",44.297439,28.035564),
new Waypoint("+X18",44.250241,28.077278),
new Waypoint("+X19",44.241387,28.107147),
new Waypoint("+X20",44.244584,28.125858),
new Waypoint("+X21",44.215802,28.207397),
new Waypoint("+X22",44.207435,28.267822),
new Waypoint("DJ381",44.17466,28.322872),
new Waypoint("*DN3_Mur",44.145346,28.362912),
new Waypoint("+X23",44.132449,28.401375),
new Waypoint("A4",44.146124,28.55587),
new Waypoint("DN15J",46.478751,24.496969),
new Waypoint("DJ151D",46.477184,24.464643),
new Waypoint("DN15_Ung",46.463788,24.43884),
new Waypoint("+X00",46.436642,24.317025),
new Waypoint("DN14A",46.43047,24.267946),
new Waypoint("+X1",46.431202,24.246504),
new Waypoint("+X2",46.451541,24.178945),
new Waypoint("DN15_Lud",46.458844,24.04904),
new Waypoint("+X5",46.471591,24.022593),
new Waypoint("+X4",46.461667,23.982854),
new Waypoint("+X3",46.51263,23.942031),
new Waypoint("DN15",46.523556,23.899212),
new Waypoint("+X198",46.522493,23.811493),
new Waypoint("A10",46.526627,23.79334),
new Waypoint("A3_U2",46.553844,23.766003),
new Waypoint("+X199",46.58317,23.736305),
new Waypoint("+X200",46.603194,23.699484),
new Waypoint("+X201",46.597385,23.644123),
new Waypoint("+X202",46.637533,23.529453),
new Waypoint("+X202A",46.687014,23.466454),
new Waypoint("A3_U1",46.69708,23.43915),
new Waypoint("+X203",46.727992,23.417788),
new Waypoint("DN1_Gil",46.756578,23.410406),
new Waypoint("+X282054",46.770395,23.383284),
new Waypoint("+X975180",46.779917,23.413668),
new Waypoint("+X311323",46.801396,23.427787),
new Waypoint("DN1F/1J",46.813204,23.42548),
new Waypoint("DN73",45.577147,25.444561),
new Waypoint("DN73G",45.632984,25.457296),
new Waypoint("SosPet",44.478714,26.125467),
new Waypoint("StrGhe",44.478645,26.137869),
new Waypoint("StrPop",44.492637,26.14922),
new Waypoint("CenBuc",44.524049,26.176193),
new Waypoint("+X01",44.542465,26.184626),
new Waypoint("A0",44.573201,26.180516),
new Waypoint("+X02",44.602202,26.177073),
new Waypoint("DJ101",44.634299,26.186526),
new Waypoint("DC184",44.67378,26.202307),
new Waypoint("DJ101B",44.717513,26.242984),
new Waypoint("+X03",44.743463,26.256124),
new Waypoint("DJ100B",44.776441,26.247509),
new Waypoint("+X05",44.823552,26.21501),
new Waypoint("+X06",44.857937,26.198359),
new Waypoint("+X07",44.860979,26.154327),
new Waypoint("+X08",44.888046,26.123772),
new Waypoint("+X09",44.879471,26.041803),
new Waypoint("DN1",44.884952,26.032292),
new Waypoint("DN19",47.185852,21.917327),
new Waypoint("DEX16",47.19062,21.891662),
new Waypoint("ROU/HUN",47.196781,21.859228),
new Waypoint("DN1H",47.183048,22.694235),
new Waypoint("U1",47.210512,22.666096),
new Waypoint("Sup",47.225303,22.555986),
new Waypoint("DN2A",44.262535,28.554668),
new Waypoint("DN3C",44.262459,28.552845),
new Waypoint("+X01",44.258233,28.545012),
new Waypoint("DC89",44.216136,28.552238),
new Waypoint("DN3",44.166864,28.549556),
new Waypoint("A2",44.146124,28.55587),
new Waypoint("+X02",44.115414,28.587971),
new Waypoint("DN39",44.1083,28.609042),
new Waypoint("ConPort",44.108327,28.635006),
new Waypoint("DN6",45.720664,21.896911),
new Waypoint("+X03",45.734583,21.897812),
new Waypoint("+X02",45.747282,21.872063),
new Waypoint("+X01",45.767762,21.868286),
new Waypoint("DJ609B",45.780334,21.853867),
new Waypoint("A1",45.797332,21.853523),
new Waypoint("DN2/2T",46.497865,26.923764),
new Waypoint("+X1",46.496304,26.950984),
new Waypoint("+X2",46.537521,26.969998),
new Waypoint("DN2F",46.587904,26.962225),
new Waypoint("+X3",46.617603,26.955739),
new Waypoint("+X4",46.638102,26.928501),
new Waypoint("DN2_N",46.636075,26.913478),
new Waypoint("1",45.98023,23.544924),
new Waypoint("+X1a",46.009944,23.546083),
new Waypoint("+X2a",46.026201,23.580447),
new Waypoint("2",46.044583,23.588038),
new Waypoint("3",46.111199,23.613471),
new Waypoint("4",46.185565,23.681202),
new Waypoint("+X2",46.205498,23.700686),
new Waypoint("+X1",46.255175,23.702241),
new Waypoint("+X4",46.266228,23.728065),
new Waypoint("+X3",46.295461,23.757505),
new Waypoint("5",46.329298,23.72901),
new Waypoint("+X805762",46.357058,23.726091),
new Waypoint("6",46.387793,23.77244),
new Waypoint("+X749796",46.401453,23.795679),
new Waypoint("A10_U",46.421322,23.798618),
new Waypoint("+X538560",46.444807,23.797417),
new Waypoint("+X552594",46.473073,23.775664),
new Waypoint("7",46.526627,23.79334),
new Waypoint("A1",46.185476,21.241894),
new Waypoint("DN7",46.202914,21.231176)
];
traveler = '';
segments = [
432625,
432626,
432627,
432628,
432629,
432630,
432631,
432632,
432633,
432634,
432635,
432636,
432637,
432638,
432639,
432640,
432641,
432642,
432643,
432644,
432645,
432646,
432647,
432648,
432649,
432650,
432651,
432652,
432653,
432654,
432655,
432696,
432697,
432698,
432699,
432700,
432701,
432702,
432703,
432704,
432705,
432706,
432707,
432708,
432709,
432710,
432711,
432712,
432713,
432714,
432715,
432716,
432717,
432718,
432719,
432720,
432721,
432722,
432656,
432657,
432658,
432659,
432660,
432661,
432662,
432663,
432664,
432665,
432666,
432667,
432668,
432669,
432670,
432671,
432672,
432673,
432674,
432675,
432676,
432677,
432678,
432679,
432680,
432681,
432682,
432683,
432684,
432685,
432686,
432687,
432688,
432689,
432690,
432691,
432692,
432693,
432694,
432695,
432723,
432724,
432725,
432726,
432727,
432728,
432729,
432730,
432731,
432732,
432733,
432734,
432735,
432736,
432737,
432738,
432739,
432740,
432741,
432742,
432743,
432744,
432745,
432746,
432747,
432748,
432749,
432750,
432751,
432752,
432753,
432754,
432755,
432776,
432777,
432778,
432779,
432780,
432781,
432782,
432783,
432784,
432785,
432786,
432787,
432788,
432789,
432790,
432791,
432792,
432793,
432794,
432795,
432796,
432797,
432798,
432799,
432800,
432801,
432756,
432757,
432758,
432759,
432760,
432761,
432762,
432763,
432764,
432765,
432766,
432767,
432768,
432769,
432770,
432771,
432772,
432773,
432774,
432775,
432802,
432803,
432804,
432805,
432806,
432807,
432808,
432809,
432810,
432811,
432812,
432813,
432814,
432815,
432816,
432817,
432818,
432819,
432820,
432821,
432822,
432823,
432824,
432825,
432826,
432827,
432828,
432829,
432830,
432831,
432832,
432833,
432834,
432835,
432836,
432837,
432838,
432839,
432840
];
clinched = [
];
mapClinched = true;
mapStatus = mapStates.MAPVIEW;
genEdges = true;
}