<!-- /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: "espmc.rm001", tier: 5, color: "TMyellow", system: "espmc", label: "ESP-MC RM1" };
routeInfo[1] = { firstWaypoint: 13, root: "espmc.rm002", tier: 5, color: "TMyellow", system: "espmc", label: "ESP-MC RM2" };
routeInfo[2] = { firstWaypoint: 26, root: "espmc.rm003", tier: 5, color: "TMyellow", system: "espmc", label: "ESP-MC RM3" };
routeInfo[3] = { firstWaypoint: 38, root: "espmc.rm011", tier: 5, color: "TMyellow", system: "espmc", label: "ESP-MC RM11" };
routeInfo[4] = { firstWaypoint: 55, root: "espmc.rm012", tier: 5, color: "TMyellow", system: "espmc", label: "ESP-MC RM12" };
routeInfo[5] = { firstWaypoint: 68, root: "espmc.rm015", tier: 5, color: "TMyellow", system: "espmc", label: "ESP-MC RM15" };
routeInfo[6] = { firstWaypoint: 94, root: "espmc.rm016", tier: 5, color: "TMyellow", system: "espmc", label: "ESP-MC RM16" };
routeInfo[7] = { firstWaypoint: 97, root: "espmc.rm017", tier: 5, color: "TMyellow", system: "espmc", label: "ESP-MC RM17" };
routeInfo[8] = { firstWaypoint: 99, root: "espmc.rm019", tier: 5, color: "TMyellow", system: "espmc", label: "ESP-MC RM19" };
routeInfo[9] = { firstWaypoint: 110, root: "espmc.rm023", tier: 5, color: "TMyellow", system: "espmc", label: "ESP-MC RM23" };
routeInfo[10] = { firstWaypoint: 115, root: "espmc.rm301", tier: 5, color: "TMyellow", system: "espmc", label: "ESP-MC RM301" };
routeInfo[11] = { firstWaypoint: 122, root: "espmc.rm303", tier: 5, color: "TMyellow", system: "espmc", label: "ESP-MC RM303" };
routeInfo[12] = { firstWaypoint: 127, root: "espmc.rm332", tier: 5, color: "TMyellow", system: "espmc", label: "ESP-MC RM332" };
routeInfo[13] = { firstWaypoint: 153, root: "espmc.rm333", tier: 5, color: "TMyellow", system: "espmc", label: "ESP-MC RM333" };
routeInfo[14] = { firstWaypoint: 156, root: "espmc.rm412", tier: 5, color: "TMyellow", system: "espmc", label: "ESP-MC RM412" };
routeInfo[15] = { firstWaypoint: 161, root: "espmc.rm414", tier: 5, color: "TMyellow", system: "espmc", label: "ESP-MC RM414" };
routeInfo[16] = { firstWaypoint: 165, root: "espmc.rm422", tier: 5, color: "TMyellow", system: "espmc", label: "ESP-MC RM422" };
routeInfo[17] = { firstWaypoint: 171, root: "espmc.rm424", tier: 5, color: "TMyellow", system: "espmc", label: "ESP-MC RM424" };
routeInfo[18] = { firstWaypoint: 179, root: "espmc.rm425", tier: 5, color: "TMyellow", system: "espmc", label: "ESP-MC RM425" };
routeInfo[19] = { firstWaypoint: 182, root: "espmc.rm426", tier: 5, color: "TMyellow", system: "espmc", label: "ESP-MC RM426" };
routeInfo[20] = { firstWaypoint: 186, root: "espmc.rm602", tier: 5, color: "TMyellow", system: "espmc", label: "ESP-MC RM602" };
routeInfo[21] = { firstWaypoint: 199, root: "espmc.rm711", tier: 5, color: "TMyellow", system: "espmc", label: "ESP-MC RM711" };
routeInfo[22] = { firstWaypoint: 213, root: "espmc.rm714", tier: 5, color: "TMyellow", system: "espmc", label: "ESP-MC RM714" };
routeInfo[23] = { firstWaypoint: 230, root: "espmc.rm730", tier: 5, color: "TMyellow", system: "espmc", label: "ESP-MC RM730" };
waypoints = [
new Waypoint("AP7",37.815531,-0.843008),
new Waypoint("3",37.838903,-0.867019),
new Waypoint("5",37.849375,-0.877362),
new Waypoint("7",37.863233,-0.894313),
new Waypoint("11",37.878952,-0.933881),
new Waypoint("13",37.892636,-0.949674),
new Waypoint("+X2",37.919081,-0.962763),
new Waypoint("19",37.936887,-0.954738),
new Waypoint("22",37.963096,-0.965745),
new Waypoint("24",37.977966,-0.974435),
new Waypoint("26",37.996839,-0.985444),
new Waypoint("29",38.002622,-1.012995),
new Waypoint("MU30",38.011439,-1.014369),
new Waypoint("0",37.827752,-1.404963),
new Waypoint("1",37.815412,-1.39389),
new Waypoint("4",37.799035,-1.374621),
new Waypoint("8",37.778279,-1.341791),
new Waypoint("11",37.764133,-1.312823),
new Waypoint("14",37.748865,-1.277246),
new Waypoint("18",37.747813,-1.235361),
new Waypoint("21",37.734238,-1.204848),
new Waypoint("26",37.741773,-1.154852),
new Waypoint("30",37.72538,-1.116228),
new Waypoint("32",37.734069,-1.087432),
new Waypoint("36",37.7471,-1.065888),
new Waypoint("A30",37.750613,-1.059633),
new Waypoint("A7",37.751826,-1.473734),
new Waypoint("0",37.748212,-1.465688),
new Waypoint("5",37.727552,-1.414447),
new Waypoint("+X862085",37.721934,-1.370265),
new Waypoint("10",37.712853,-1.357841),
new Waypoint("13",37.696046,-1.345868),
new Waypoint("15",37.681035,-1.340353),
new Waypoint("17",37.657341,-1.331792),
new Waypoint("20",37.635849,-1.339989),
new Waypoint("23",37.613348,-1.337928),
new Waypoint("25",37.597708,-1.339023),
new Waypoint("RM332",37.588799,-1.342177),
new Waypoint("A7",37.662896,-1.713738),
new Waypoint("N340a",37.658989,-1.708438),
new Waypoint("RMD11",37.657651,-1.705869),
new Waypoint("RonSur",37.654912,-1.701486),
new Waypoint("RMD10",37.63833,-1.696336),
new Waypoint("ToRM621",37.626299,-1.676016),
new Waypoint("Pur",37.59968,-1.660545),
new Waypoint("RM620",37.592506,-1.657047),
new Waypoint("+X696536",37.568596,-1.65164),
new Waypoint("14",37.559803,-1.637049),
new Waypoint("17",37.53539,-1.626245),
new Waypoint("19",37.52472,-1.631491),
new Waypoint("RM322",37.498576,-1.625977),
new Waypoint("RMD19",37.471129,-1.635633),
new Waypoint("RMD13",37.460501,-1.631035),
new Waypoint("AP7",37.434335,-1.624668),
new Waypoint("RM333",37.41305,-1.599669),
new Waypoint("AP7",37.660008,-0.900621),
new Waypoint("1",37.650971,-0.883605),
new Waypoint("2",37.638823,-0.873413),
new Waypoint("3",37.641609,-0.852127),
new Waypoint("5",37.643223,-0.837751),
new Waypoint("6",37.633436,-0.806572),
new Waypoint("8",37.623681,-0.784063),
new Waypoint("9",37.622611,-0.767498),
new Waypoint("10",37.623197,-0.753143),
new Waypoint("11",37.624718,-0.739185),
new Waypoint("12",37.625542,-0.731664),
new Waypoint("13",37.628465,-0.714937),
new Waypoint("CarMan",37.636087,-0.708565),
new Waypoint("A7/MU30",37.980401,-1.245403),
new Waypoint("3",37.993017,-1.271453),
new Waypoint("4",37.993897,-1.29319),
new Waypoint("8",38.007288,-1.33898),
new Waypoint("10",38.013595,-1.358013),
new Waypoint("13",38.014778,-1.383569),
new Waypoint("14",38.021827,-1.395607),
new Waypoint("16",38.026053,-1.406379),
new Waypoint("17",38.034977,-1.424317),
new Waypoint("20",38.045962,-1.455045),
new Waypoint("+X1",38.059378,-1.461782),
new Waypoint("+X2",38.071136,-1.510534),
new Waypoint("30",38.056911,-1.543665),
new Waypoint("33",38.064514,-1.571817),
new Waypoint("35",38.065156,-1.591451),
new Waypoint("+X3",38.063466,-1.630225),
new Waypoint("40",38.05387,-1.653271),
new Waypoint("41",38.054444,-1.660073),
new Waypoint("43",38.051234,-1.68035),
new Waypoint("46",38.062284,-1.713095),
new Waypoint("48",38.070781,-1.738243),
new Waypoint("50",38.073248,-1.760881),
new Waypoint("53",38.081744,-1.78678),
new Waypoint("55",38.090796,-1.806543),
new Waypoint("57",38.100016,-1.828709),
new Waypoint("61",38.08904,-1.865852),
new Waypoint("1",37.843003,-1.103997),
new Waypoint("2",37.82643,-1.111507),
new Waypoint("3",37.811479,-1.126099),
new Waypoint("A30",37.820396,-1.093268),
new Waypoint("RM16",37.82643,-1.111507),
new Waypoint("A30",37.8653,-1.121421),
new Waypoint("1",37.867858,-1.103525),
new Waypoint("4",37.853373,-1.067948),
new Waypoint("9",37.834463,-1.023316),
new Waypoint("15",37.816497,-0.964823),
new Waypoint("16",37.81431,-0.947142),
new Waypoint("18",37.814954,-0.929525),
new Waypoint("21",37.810835,-0.890579),
new Waypoint("24",37.807597,-0.862899),
new Waypoint("AP7",37.80597,-0.850684),
new Waypoint("N332",37.80541,-0.838003),
new Waypoint("0",37.799035,-1.374621),
new Waypoint("4",37.771682,-1.374707),
new Waypoint("7",37.744589,-1.372776),
new Waypoint("9",37.721679,-1.363528),
new Waypoint("10",37.712853,-1.357841),
new Waypoint("RM303",37.998809,-1.025194),
new Waypoint("RMF16",38.000762,-1.020827),
new Waypoint("RM310",37.993258,-0.996108),
new Waypoint("+X460251",37.992409,-0.983105),
new Waypoint("RM1(24)",37.977966,-0.974435),
new Waypoint("RMF18",37.972468,-0.969436),
new Waypoint("RM1(22)",37.963096,-0.965745),
new Waypoint("RM301",37.998809,-1.025194),
new Waypoint("RM330",38.021388,-1.033874),
new Waypoint("RMF2",38.032269,-1.042124),
new Waypoint("RMF10",38.039777,-1.048036),
new Waypoint("N340",38.05931,-1.054044),
new Waypoint("RM11",37.498576,-1.625977),
new Waypoint("RMD9",37.525375,-1.575688),
new Waypoint("RMD20",37.541651,-1.477189),
new Waypoint("RMD21",37.545258,-1.44599),
new Waypoint("AP7(857)",37.548014,-1.434402),
new Waypoint("RMD5",37.567066,-1.407108),
new Waypoint("+X836925",37.585398,-1.368442),
new Waypoint("RM3",37.588799,-1.342177),
new Waypoint("RMD6",37.587558,-1.316664),
new Waypoint("RMD4",37.590431,-1.316085),
new Waypoint("AveCon",37.591536,-1.304541),
new Waypoint("AveDocMeca",37.573486,-1.26847),
new Waypoint("CalCamCru",37.577244,-1.25905),
new Waypoint("AveCaboNao",37.576624,-1.246862),
new Waypoint("RME22",37.579719,-1.238687),
new Waypoint("+X681171",37.600836,-1.208839),
new Waypoint("+X871125",37.615897,-1.208668),
new Waypoint("+X723431",37.625485,-1.188771),
new Waypoint("RME34",37.637192,-1.187146),
new Waypoint("RME17",37.645568,-1.165667),
new Waypoint("RME26",37.639468,-1.095264),
new Waypoint("RME16",37.640777,-1.086917),
new Waypoint("RME20",37.629494,-1.046751),
new Waypoint("CT31",37.626214,-1.027994),
new Waypoint("CalVarPon",37.621079,-1.016117),
new Waypoint("RM36",37.620163,-1.013907),
new Waypoint("RM11",37.41305,-1.599669),
new Waypoint("RMD18",37.395255,-1.605892),
new Waypoint("MC/AN",37.37737,-1.632768),
new Waypoint("RM414",38.195376,-1.044152),
new Waypoint("RMA7",38.204734,-1.049237),
new Waypoint("RMA21",38.215959,-1.056796),
new Waypoint("RMA29",38.217898,-1.05899),
new Waypoint("RM422",38.239554,-1.080115),
new Waypoint("N340",38.059327,-1.051764),
new Waypoint("ToA7",38.092113,-1.056597),
new Waypoint("A7",38.094486,-1.055213),
new Waypoint("RM412",38.195376,-1.044152),
new Waypoint("RM412",38.239554,-1.080115),
new Waypoint("+X689641",38.259379,-1.069236),
new Waypoint("RM410",38.267483,-1.0757),
new Waypoint("RMA30",38.309875,-1.063056),
new Waypoint("RMA10",38.325561,-1.065395),
new Waypoint("MC/VC",38.344618,-1.054559),
new Waypoint("MC/VC",38.452984,-1.063271),
new Waypoint("RMA19",38.458218,-1.06539),
new Waypoint("RMA15",38.467429,-1.069456),
new Waypoint("+X664998",38.480638,-1.071467),
new Waypoint("RMA27",38.526782,-1.044602),
new Waypoint("A33",38.573501,-1.073034),
new Waypoint("RMA26",38.593621,-1.089862),
new Waypoint("N344",38.60201,-1.096846),
new Waypoint("N344",38.616104,-1.085968),
new Waypoint("A33",38.619603,-1.041083),
new Waypoint("MC/VC",38.621665,-1.014047),
new Waypoint("AveJPII",38.619117,-1.117988),
new Waypoint("RMA14",38.718147,-1.166954),
new Waypoint("+X455809",38.733414,-1.175966),
new Waypoint("MC/CM",38.750168,-1.166224),
new Waypoint("A30",37.687455,-1.018467),
new Waypoint("N301a",37.687917,-1.027967),
new Waypoint("RME33",37.696386,-1.06709),
new Waypoint("RM605",37.701513,-1.078591),
new Waypoint("RME31",37.714856,-1.093183),
new Waypoint("RME14",37.7228,-1.116185),
new Waypoint("CarCar",37.723377,-1.153221),
new Waypoint("RM601",37.731727,-1.164422),
new Waypoint("CarAlhMur",37.726296,-1.189957),
new Waypoint("RME32",37.728205,-1.203421),
new Waypoint("RME6",37.736003,-1.245146),
new Waypoint("RME11",37.745039,-1.269146),
new Waypoint("RM2",37.748865,-1.277246),
new Waypoint("RM730",38.051808,-1.896858),
new Waypoint("RMC23",38.027321,-1.912324),
new Waypoint("RMC17",38.005129,-1.92367),
new Waypoint("RMC18",37.991521,-1.927189),
new Waypoint("+X271845",37.96582,-1.929173),
new Waypoint("+X284953",37.931277,-1.888286),
new Waypoint("+X631776",37.888335,-1.864414),
new Waypoint("RM504",37.877928,-1.844024),
new Waypoint("RMC12",37.855101,-1.811328),
new Waypoint("RMC11",37.828268,-1.786319),
new Waypoint("RMC14",37.794322,-1.777087),
new Waypoint("+X603051",37.75443,-1.733608),
new Waypoint("RMC9",37.717814,-1.705788),
new Waypoint("A7",37.695061,-1.704855),
new Waypoint("N344",38.464939,-1.331916),
new Waypoint("+X279785",38.438615,-1.348068),
new Waypoint("+X285529",38.367435,-1.447234),
new Waypoint("+X222153",38.326979,-1.463671),
new Waypoint("N301",38.316336,-1.480676),
new Waypoint("A30",38.315212,-1.486137),
new Waypoint("RMB19",38.263288,-1.618681),
new Waypoint("+X679279",38.261772,-1.666875),
new Waypoint("CalTenFlo",38.239983,-1.698117),
new Waypoint("RM510",38.240034,-1.719446),
new Waypoint("+X389106",38.226247,-1.735668),
new Waypoint("AveJRJ",38.205072,-1.735303),
new Waypoint("RMB35",38.196303,-1.741333),
new Waypoint("RMB39",38.18287,-1.747416),
new Waypoint("RMB21",38.12886,-1.803574),
new Waypoint("RMB36",38.107412,-1.820297),
new Waypoint("RM15",38.100016,-1.828709),
new Waypoint("RM15",38.081879,-1.871495),
new Waypoint("RM711",38.051808,-1.896858),
new Waypoint("Bar_E",38.050569,-1.928921),
new Waypoint("AntCamCar",38.053954,-1.956725),
new Waypoint("RM702",38.047436,-1.975769),
new Waypoint("Bar_W",38.038907,-1.987925),
new Waypoint("+X180785",38.003298,-2.085986),
new Waypoint("RMB24",37.998644,-2.209287),
new Waypoint("RMB23",37.99322,-2.258243),
new Waypoint("MC/AN",37.98791,-2.2964)
];
traveler = '';
segments = [
245840,
245841,
245842,
245843,
245844,
245845,
245846,
245847,
245848,
245849,
245850,
245851,
245852,
245853,
245854,
245855,
245856,
245857,
245858,
245859,
245860,
245861,
245862,
245863,
245864,
245865,
245866,
245867,
245868,
245869,
245870,
245871,
245872,
245873,
245874,
245875,
245876,
245877,
245878,
245879,
245880,
245881,
245882,
245883,
245884,
245885,
245886,
245887,
245888,
245889,
245890,
245891,
245892,
245893,
245894,
245895,
245896,
245897,
245898,
245899,
245900,
245901,
245902,
245903,
245904,
245905,
245906,
245907,
245908,
245909,
245910,
245911,
245912,
245913,
245914,
245915,
245916,
245917,
245918,
245919,
245920,
245921,
245922,
245923,
245924,
245925,
245926,
245927,
245928,
245929,
245930,
245931,
245932,
245933,
245934,
245935,
245936,
245937,
245938,
245939,
245940,
245941,
245942,
245943,
245944,
245945,
245946,
245947,
245948,
245949,
245950,
245951,
245952,
245953,
245954,
245955,
245956,
245957,
245958,
245959,
245960,
245961,
245962,
245963,
245964,
245965,
245966,
245967,
245968,
245969,
245970,
245971,
245972,
245973,
245974,
245975,
245976,
245977,
245978,
245979,
245980,
245981,
245982,
245983,
245984,
245985,
245986,
245987,
245988,
245989,
245990,
245991,
245992,
245993,
245994,
245995,
245996,
245997,
245998,
245999,
246000,
246001,
246002,
246003,
246004,
246005,
246006,
246007,
246008,
246009,
246010,
246011,
246012,
246013,
246014,
246015,
246016,
246017,
246018,
246019,
246020,
246021,
246022,
246023,
246024,
246025,
246026,
246027,
246028,
246029,
246030,
246031,
246032,
246033,
246034,
246035,
246036,
246037,
246038,
246039,
246040,
246041,
246042,
246043,
246044,
246045,
246046,
246047,
246048,
246049,
246050,
246051,
246052,
246053,
246054,
246055
];
clinched = [
];
mapClinched = true;
mapStatus = mapStates.MAPVIEW;
genEdges = true;
}