<!-- /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: "bgr.a001", tier: 1, color: "TMblue", system: "bgra", label: "BGR A1" };
routeInfo[1] = { firstWaypoint: 59, root: "bgr.a002", tier: 1, color: "TMblue", system: "bgra", label: "BGR A2" };
routeInfo[2] = { firstWaypoint: 83, root: "bgr.a002var", tier: 1, color: "TMblue", system: "bgra", label: "BGR A2Var" };
routeInfo[3] = { firstWaypoint: 110, root: "bgr.a003", tier: 1, color: "TMblue", system: "bgra", label: "BGR A3" };
routeInfo[4] = { firstWaypoint: 140, root: "bgr.a003kul", tier: 1, color: "TMblue", system: "bgra", label: "BGR A3Kul" };
routeInfo[5] = { firstWaypoint: 153, root: "bgr.a004", tier: 1, color: "TMblue", system: "bgra", label: "BGR A4" };
routeInfo[6] = { firstWaypoint: 176, root: "bgr.a005", tier: 1, color: "TMblue", system: "bgra", label: "BGR A5" };
routeInfo[7] = { firstWaypoint: 180, root: "bgr.a006", tier: 1, color: "TMblue", system: "bgra", label: "BGR A6" };
routeInfo[8] = { firstWaypoint: 185, root: "bgr.a006sof", tier: 1, color: "TMblue", system: "bgra", label: "BGR A6Sof" };
waypoints = [
new Waypoint("II18",42.633154,23.448043),
new Waypoint("UliSae",42.625465,23.506622),
new Waypoint("I8_Loz",42.623776,23.517995),
new Waypoint("+Ben",42.599709,23.566704),
new Waypoint("NoviHan",42.593817,23.593612),
new Waypoint("+Ben2",42.591653,23.622279),
new Waypoint("+X01",42.580515,23.652363),
new Waypoint("+X02",42.563512,23.663692),
new Waypoint("Vak",42.554329,23.693604),
new Waypoint("+X03",42.525159,23.746605),
new Waypoint("I8_Iht",42.487273,23.787718),
new Waypoint("+X04",42.464341,23.829346),
new Waypoint("+X05",42.4449,23.848314),
new Waypoint("I8_Mir",42.403099,23.867798),
new Waypoint("+X06",42.375095,23.879471),
new Waypoint("III3704",42.344423,23.937471),
new Waypoint("+X07",42.325618,23.969936),
new Waypoint("+X08",42.341449,24.002981),
new Waypoint("III8402",42.334898,24.083276),
new Waypoint("III803",42.303198,24.208031),
new Waypoint("II37",42.261399,24.316435),
new Waypoint("+X09",42.215678,24.414711),
new Waypoint("III8005",42.204441,24.565086),
new Waypoint("III805_W",42.19945,24.652205),
new Waypoint("III805_E",42.202383,24.668963),
new Waypoint("II64",42.214311,24.730225),
new Waypoint("II56",42.21207,24.812579),
new Waypoint("Tru",42.216902,24.860215),
new Waypoint("III565",42.217617,25.019903),
new Waypoint("III666",42.192249,25.196114),
new Waypoint("A4",42.193854,25.233107),
new Waypoint("III664",42.20789,25.303059),
new Waypoint("II66",42.250345,25.41275),
new Waypoint("+X10",42.292517,25.46957),
new Waypoint("+X11",42.31667,25.544672),
new Waypoint("I5",42.339387,25.661745),
new Waypoint("+X12",42.348903,25.728607),
new Waypoint("+X13",42.370847,25.804653),
new Waypoint("+X14",42.38898,25.879669),
new Waypoint("+X15",42.436254,25.984726),
new Waypoint("III554",42.441954,26.017513),
new Waypoint("+X16",42.469185,26.084633),
new Waypoint("+X17",42.487163,26.192436),
new Waypoint("+X18",42.489694,26.254578),
new Waypoint("+X19",42.51412,26.369762),
new Waypoint("II53",42.537904,26.418686),
new Waypoint("+X20",42.545113,26.447954),
new Waypoint("Kab",42.540528,26.484132),
new Waypoint("+X22",42.555546,26.51473),
new Waypoint("I7",42.555799,26.578674),
new Waypoint("+X23",42.558012,26.643562),
new Waypoint("+X24",42.545998,26.780376),
new Waypoint("+X25",42.572362,26.880198),
new Waypoint("III795",42.590563,26.983452),
new Waypoint("+X26",42.58576,27.135029),
new Waypoint("+X27",42.595902,27.162752),
new Waypoint("+X28",42.586266,27.205067),
new Waypoint("Bal",42.604289,27.303085),
new Waypoint("I6",42.592174,27.394667),
new Waypoint("II18",42.707669,23.449631),
new Waypoint("I1/I6",42.709309,23.466196),
new Waypoint("+X01",42.723403,23.509669),
new Waypoint("I1_Yan",42.723734,23.547091),
new Waypoint("I1_Ele",42.738172,23.621163),
new Waypoint("+X02",42.7368,23.655624),
new Waypoint("+X03",42.750101,23.666439),
new Waypoint("I1_Zhe",42.748887,23.68691),
new Waypoint("+X04",42.77622,23.721113),
new Waypoint("I1_Vit",42.778071,23.772526),
new Waypoint("+X06",42.773731,23.784714),
new Waypoint("+X08",42.800817,23.81115),
new Waypoint("+X09",42.812214,23.799477),
new Waypoint("+X10",42.853945,23.789778),
new Waypoint("+X11",42.87653,23.801193),
new Waypoint("II17",42.89186,23.825827),
new Waypoint("I3_Tru",42.911319,23.889556),
new Waypoint("I3_Osi",42.936114,23.967576),
new Waypoint("+X13",42.950235,24.016027),
new Waypoint("Dzh",42.971434,24.034395),
new Waypoint("I3_Yab",43.011143,24.09482),
new Waypoint("I3_E",43.037811,24.120655),
new Waypoint("+X680109",43.049416,24.143915),
new Waypoint("I4",43.056566,24.22245),
new Waypoint("III5102",43.322087,26.695147),
new Waypoint("+X599176",43.325271,26.727762),
new Waypoint("+X200435",43.339662,26.757545),
new Waypoint("+X632126",43.333638,26.784754),
new Waypoint("I4",43.341597,26.874189),
new Waypoint("I2_Bel",43.340068,26.883674),
new Waypoint("*I7",43.333482,26.922083),
new Waypoint("+X100",43.324179,26.968346),
new Waypoint("I2_Shu",43.306662,27.008611),
new Waypoint("+X101",43.30382,27.04113),
new Waypoint("I2_Kas",43.323898,27.161636),
new Waypoint("+X102",43.310565,27.209015),
new Waypoint("+X103",43.292825,27.237167),
new Waypoint("Nev",43.280658,27.309608),
new Waypoint("MlaGva",43.271808,27.376707),
new Waypoint("III208",43.255174,27.426424),
new Waypoint("Gab",43.253971,27.505002),
new Waypoint("+X104",43.246953,27.533798),
new Waypoint("+X105",43.228789,27.554741),
new Waypoint("III2009",43.230665,27.609243),
new Waypoint("+X106",43.241232,27.63319),
new Waypoint("+X107",43.227538,27.643318),
new Waypoint("Pov",43.227241,27.652459),
new Waypoint("Sla",43.237043,27.711468),
new Waypoint("II29_W",43.239857,27.834291),
new Waypoint("II29_E",43.227874,27.860513),
new Waypoint("I2_Var",43.223926,27.867465),
new Waypoint("II18",42.712966,23.230333),
new Waypoint("MaloBuc",42.692467,23.181925),
new Waypoint("+X01",42.688177,23.15712),
new Waypoint("+X02",42.665018,23.147593),
new Waypoint("+X03",42.655929,23.130856),
new Waypoint("+X05",42.629033,23.126049),
new Waypoint("+X06",42.616781,23.139696),
new Waypoint("I6",42.599851,23.12356),
new Waypoint("+X07",42.565314,23.11532),
new Waypoint("Stu",42.533556,23.132744),
new Waypoint("Bos",42.499947,23.139267),
new Waypoint("StaSelo_N",42.482605,23.117466),
new Waypoint("StaSelo_S",42.472318,23.111372),
new Waypoint("III627",42.452531,23.111801),
new Waypoint("+X08",42.39646,23.120556),
new Waypoint("+X09",42.348142,23.095837),
new Waypoint("I1_Dup",42.331519,23.099098),
new Waypoint("+X594856",42.29712,23.092232),
new Waypoint("II62",42.26594,23.068972),
new Waypoint("+X762272",42.24847,23.085194),
new Waypoint("III104",42.154305,23.033695),
new Waypoint("+X487015",42.073253,23.033009),
new Waypoint("I1_Koc",42.054774,23.047943),
new Waypoint("+X688776",42.040385,23.039532),
new Waypoint("III106",42.00715,23.048201),
new Waypoint("+X717163",41.983213,23.060131),
new Waypoint("I1_BlaS",41.962043,23.098626),
new Waypoint("+X639638",41.951607,23.105621),
new Waypoint("+X648060",41.917407,23.117251),
new Waypoint("I1_Zhe",41.90718,23.118324),
new Waypoint("I1_Kre",41.698311,23.176904),
new Waypoint("+X674247",41.656,23.177419),
new Waypoint("III1008",41.628419,23.203082),
new Waypoint("+X922112",41.607308,23.223896),
new Waypoint("BulEvr",41.54159,23.256941),
new Waypoint("I1_Dam",41.506842,23.275051),
new Waypoint("III108",41.499064,23.280973),
new Waypoint("+X855687",41.480547,23.306723),
new Waypoint("NovoKon",41.455175,23.321099),
new Waypoint("Mar",41.435327,23.329682),
new Waypoint("III198",41.422585,23.330927),
new Waypoint("Kul",41.38473,23.361912),
new Waypoint("BGR/GRC",41.379095,23.363103),
new Waypoint("A1",42.193854,25.233107),
new Waypoint("*II66",42.181405,25.246625),
new Waypoint("+X710311",42.155641,25.277481),
new Waypoint("ZlaLiv",42.108969,25.414209),
new Waypoint("+X430949",42.093255,25.443993),
new Waypoint("+X919653",42.056176,25.484333),
new Waypoint("I5",42.022168,25.581493),
new Waypoint("+X725630",41.978316,25.706978),
new Waypoint("+X358304",41.962107,25.810447),
new Waypoint("III554",41.957735,25.886364),
new Waypoint("II76",41.929358,25.925675),
new Waypoint("+X02",41.916649,25.944901),
new Waypoint("+X01",41.872501,26.080856),
new Waypoint("III809",41.857128,26.090813),
new Waypoint("*Mom",41.832279,26.14068),
new Waypoint("II80",41.799471,26.173468),
new Waypoint("II55",41.783009,26.205955),
new Waypoint("*I8_SviE",41.757547,26.232991),
new Waypoint("*I8_GenW",41.746037,26.252217),
new Waypoint("*I8_GenE",41.726967,26.289167),
new Waypoint("I8_KapW",41.725382,26.308908),
new Waypoint("*I8_KapE",41.718991,26.346202),
new Waypoint("BGR/TUR",41.717326,26.353025),
new Waypoint("I9_N",43.186044,27.876863),
new Waypoint("+X101",43.180928,27.847338),
new Waypoint("+X100",43.167189,27.846737),
new Waypoint("I9_S",43.139544,27.819271),
new Waypoint("III811",42.848377,23.077898),
new Waypoint("III8112",42.859073,23.039923),
new Waypoint("+X05",42.881625,23.012474),
new Waypoint("AldBla",42.882136,22.997636),
new Waypoint("I8",42.909017,22.944646),
new Waypoint("VasLev",42.772684,23.274536),
new Waypoint("II18",42.769006,23.286638),
new Waypoint("BulRoz",42.758298,23.321475),
new Waypoint("+UliIli",42.753567,23.342214),
new Waypoint("CheSho",42.728337,23.379936),
new Waypoint("IztTan",42.720577,23.394672),
new Waypoint("+X319058",42.719178,23.422251),
new Waypoint("I1/I6",42.708299,23.440061)
];
traveler = 'michih';
segments = [
51853,
51854,
51855,
51856,
51857,
51858,
51859,
51860,
51861,
51862,
51863,
51864,
51865,
51866,
51867,
51868,
51869,
51870,
51871,
51872,
51873,
51874,
51875,
51876,
51877,
51878,
51879,
51880,
51881,
51882,
51883,
51884,
51885,
51886,
51887,
51888,
51889,
51890,
51891,
51892,
51893,
51894,
51895,
51896,
51897,
51898,
51899,
51900,
51901,
51902,
51903,
51904,
51905,
51906,
51907,
51908,
51909,
51910,
51911,
51912,
51913,
51914,
51915,
51916,
51917,
51918,
51919,
51920,
51921,
51922,
51923,
51924,
51925,
51926,
51927,
51928,
51929,
51930,
51931,
51932,
51933,
51934,
51935,
51936,
51937,
51938,
51939,
51940,
51941,
51942,
51943,
51944,
51945,
51946,
51947,
51948,
51949,
51950,
51951,
51952,
51953,
51954,
51955,
51956,
51957,
51958,
51959,
51960,
51961,
51962,
51963,
51964,
51965,
51966,
51967,
51968,
51969,
51970,
51971,
51972,
51973,
51974,
51975,
51976,
51977,
51978,
51979,
51980,
51981,
51982,
51983,
51984,
51985,
51986,
51987,
51988,
51989,
51990,
51991,
51992,
51993,
51994,
51995,
51996,
51997,
51998,
51999,
52000,
52001,
52002,
52003,
52004,
52005,
52006,
52007,
52008,
52009,
52010,
52011,
52012,
52013,
52014,
52015,
52016,
52017,
52018,
52019,
52020,
52021,
52022,
52023,
52024,
52025,
52033,
52034,
52035,
52036,
52026,
52027,
52028,
52029,
52030,
52031,
52032
];
clinched = [
51911,
51912,
51913,
51914,
51915,
51916,
51917,
51918,
51919,
51920,
51921,
51922,
51923,
51924,
51925,
51926,
51927,
51928,
51929,
51930,
51931,
51932,
51933,
51960,
51961,
51962,
51963,
51964,
51965,
51966,
51967,
51968,
51969,
51970,
51971,
51972,
51973,
51974,
51975,
51976,
51977,
51978,
51979,
51980,
51981,
51982,
51983,
51984,
51985,
51989,
51990,
51991,
51992,
51993,
51994,
51995,
51996,
51997,
51998,
51999,
52000,
52033,
52034,
52035,
52036,
52026,
52027,
52028,
52029,
52030,
52031,
52032
];
mapClinched = true;
mapStatus = mapStates.MAPVIEW;
genEdges = true;
}