<!-- /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: "espri.lr111", tier: 5, color: "TMyellow", system: "espri", label: "ESP-RI LR111" };
routeInfo[1] = { firstWaypoint: 17, root: "espri.lr113", tier: 5, color: "TMyellow", system: "espri", label: "ESP-RI LR113" };
routeInfo[2] = { firstWaypoint: 40, root: "espri.lr115", tier: 5, color: "TMyellow", system: "espri", label: "ESP-RI LR115" };
routeInfo[3] = { firstWaypoint: 63, root: "espri.lr123", tier: 5, color: "TMyellow", system: "espri", label: "ESP-RI LR123" };
routeInfo[4] = { firstWaypoint: 88, root: "espri.lr124", tier: 5, color: "TMyellow", system: "espri", label: "ESP-RI LR124" };
routeInfo[5] = { firstWaypoint: 93, root: "espri.lr124bri", tier: 5, color: "TMyellow", system: "espri", label: "ESP-RI LR124Bri" };
routeInfo[6] = { firstWaypoint: 95, root: "espri.lr124log", tier: 5, color: "TMyellow", system: "espri", label: "ESP-RI LR124Log" };
routeInfo[7] = { firstWaypoint: 98, root: "espri.lr131", tier: 5, color: "TMyellow", system: "espri", label: "ESP-RI LR131" };
routeInfo[8] = { firstWaypoint: 102, root: "espri.lr132", tier: 5, color: "TMyellow", system: "espri", label: "ESP-RI LR132" };
routeInfo[9] = { firstWaypoint: 106, root: "espri.lr134", tier: 5, color: "TMyellow", system: "espri", label: "ESP-RI LR134" };
routeInfo[10] = { firstWaypoint: 116, root: "espri.lr136", tier: 5, color: "TMyellow", system: "espri", label: "ESP-RI LR136" };
routeInfo[11] = { firstWaypoint: 120, root: "espri.lr137", tier: 5, color: "TMyellow", system: "espri", label: "ESP-RI LR137" };
waypoints = [
new Waypoint("CL/RI",42.318035,-3.10456),
new Waypoint("LR415",42.326808,-3.013961),
new Waypoint("LR414",42.387934,-2.971888),
new Waypoint("N120a_W",42.439413,-2.953413),
new Waypoint("N120a_E",42.439203,-2.951272),
new Waypoint("LR203_S",42.44642,-2.950645),
new Waypoint("A12",42.455508,-2.947898),
new Waypoint("LR308",42.489948,-2.938929),
new Waypoint("LR502",42.509312,-2.919016),
new Waypoint("LR503",42.53588,-2.916355),
new Waypoint("N232a",42.546046,-2.904215),
new Waypoint("N232",42.554716,-2.897976),
new Waypoint("AP68",42.562441,-2.876406),
new Waypoint("LR203_N",42.572709,-2.854128),
new Waypoint("LR202",42.574258,-2.855018),
new Waypoint("LR212",42.582063,-2.846274),
new Waypoint("N124",42.585298,-2.845378),
new Waypoint("CL/RI",42.139128,-3.087287),
new Waypoint("+X987856",42.151967,-3.038514),
new Waypoint("+X298670",42.132078,-3.010662),
new Waypoint("LR334",42.135325,-2.978776),
new Waypoint("+X138235",42.154178,-2.957811),
new Waypoint("+X501422",42.157486,-2.914209),
new Waypoint("LR333",42.173423,-2.886014),
new Waypoint("LR332",42.204735,-2.827488),
new Waypoint("LR435",42.220255,-2.822928),
new Waypoint("CalNue",42.262439,-2.764875),
new Waypoint("+X759661",42.285405,-2.764049),
new Waypoint("LR431",42.315797,-2.759736),
new Waypoint("LR207",42.342274,-2.757375),
new Waypoint("LR205",42.37798,-2.744823),
new Waypoint("LR136",42.39104,-2.732849),
new Waypoint("LR429",42.406708,-2.731047),
new Waypoint("N120",42.422328,-2.722592),
new Waypoint("A12",42.428462,-2.718687),
new Waypoint("LR514_S",42.434955,-2.71328),
new Waypoint("LR322",42.438946,-2.704868),
new Waypoint("LR514_N",42.450251,-2.705855),
new Waypoint("+X610834",42.47857,-2.671309),
new Waypoint("N232",42.48162,-2.649674),
new Waypoint("CL/RI",42.135826,-2.291508),
new Waypoint("+X779789",42.150121,-2.279255),
new Waypoint("LR286",42.147655,-2.270565),
new Waypoint("+X170914",42.159522,-2.260898),
new Waypoint("+X275400",42.181763,-2.269868),
new Waypoint("LR484",42.196001,-2.26666),
new Waypoint("+X591711",42.217585,-2.228347),
new Waypoint("LR382",42.215781,-2.219979),
new Waypoint("LR380",42.209734,-2.191279),
new Waypoint("+X766101",42.214184,-2.132163),
new Waypoint("LR583",42.22472,-2.100406),
new Waypoint("LR123",42.232172,-2.077146),
new Waypoint("LR281",42.233252,-2.055988),
new Waypoint("LR282",42.21302,-2.005858),
new Waypoint("+X876430",42.208367,-1.956339),
new Waypoint("LR384",42.22642,-1.893489),
new Waypoint("N232_RinW",42.230154,-1.858325),
new Waypoint("N232_RinE",42.227727,-1.847827),
new Waypoint("LR586",42.227898,-1.846561),
new Waypoint("N232_Esp",42.223179,-1.838891),
new Waypoint("PolInd",42.227596,-1.835682),
new Waypoint("LR495",42.245707,-1.839588),
new Waypoint("RI/NC",42.250138,-1.83742),
new Waypoint("N113",41.981287,-1.861673),
new Waypoint("+X107558",41.995701,-1.890163),
new Waypoint("LR492",41.994967,-1.909819),
new Waypoint("LR284",42.007413,-1.948764),
new Waypoint("LR593",42.032082,-1.932392),
new Waypoint("LR285",42.049994,-1.925654),
new Waypoint("LR283_S",42.054391,-1.945009),
new Waypoint("+X113893",42.065702,-1.972561),
new Waypoint("LR387",42.092112,-1.983123),
new Waypoint("LR385",42.107934,-1.998653),
new Waypoint("LR283_N",42.127901,-2.07265),
new Waypoint("LR488",42.138173,-2.078819),
new Waypoint("+X245213",42.154305,-2.109075),
new Waypoint("+X630032",42.198989,-2.082682),
new Waypoint("LR583",42.211641,-2.097917),
new Waypoint("+X554216",42.225753,-2.0753),
new Waypoint("LR115",42.232172,-2.077146),
new Waypoint("LR585",42.239225,-2.089849),
new Waypoint("LR134",42.247454,-2.089001),
new Waypoint("LR483",42.270196,-2.096629),
new Waypoint("LR481",42.299659,-2.098174),
new Waypoint("N232",42.318054,-2.093073),
new Waypoint("LR280",42.345668,-2.090449),
new Waypoint("+X478936",42.356324,-2.090428),
new Waypoint("RI/NC",42.366884,-2.078862),
new Waypoint("PV/RI",42.566483,-2.687187),
new Waypoint("LR319",42.570754,-2.711268),
new Waypoint("LR424",42.566199,-2.741604),
new Waypoint("LR210",42.571366,-2.758191),
new Waypoint("RI/PV",42.580088,-2.779498),
new Waypoint("PV/RI",42.601967,-2.8231),
new Waypoint("N124",42.605332,-2.838947),
new Waypoint("N111a",42.475872,-2.444522),
new Waypoint("CuaPueLog",42.479599,-2.457418),
new Waypoint("RI/PV",42.487527,-2.476537),
new Waypoint("N111a",42.475872,-2.444522),
new Waypoint("PuePie",42.471195,-2.444222),
new Waypoint("A13",42.472136,-2.416359),
new Waypoint("RI/NC",42.474186,-2.402315),
new Waypoint("N232",42.449356,-2.317767),
new Waypoint("+X942313",42.450315,-2.308395),
new Waypoint("+X462835",42.454162,-2.306635),
new Waypoint("AerAgo",42.455033,-2.31348),
new Waypoint("LR123",42.247454,-2.089001),
new Waypoint("LR281",42.264336,-2.055956),
new Waypoint("LR282",42.285723,-2.012054),
new Waypoint("AP68",42.301976,-1.982431),
new Waypoint("N232_E",42.302702,-1.979202),
new Waypoint("N232_W",42.310303,-1.980705),
new Waypoint("CalBeb",42.311339,-1.977947),
new Waypoint("LR482",42.314925,-1.971617),
new Waypoint("CarSanAdr_S",42.318848,-1.952664),
new Waypoint("RI/NC",42.328712,-1.937456),
new Waypoint("LR113",42.39104,-2.732849),
new Waypoint("LR429",42.400612,-2.71461),
new Waypoint("N120",42.41261,-2.704831),
new Waypoint("A12",42.41655,-2.696028),
new Waypoint("N111",42.340311,-2.502313),
new Waypoint("LR541_S",42.377251,-2.523551),
new Waypoint("LR445",42.380643,-2.530332),
new Waypoint("LR444/541",42.397791,-2.539945),
new Waypoint("N120",42.431131,-2.566085),
new Waypoint("A12",42.436982,-2.570028),
new Waypoint("AP68",42.446641,-2.567282),
new Waypoint("N232",42.46404,-2.563526)
];
traveler = 'master_son';
segments = [
246994,
246995,
246996,
246997,
246998,
246999,
247000,
247001,
247002,
247003,
247004,
247005,
247006,
247007,
247008,
247009,
247010,
247011,
247012,
247013,
247014,
247015,
247016,
247017,
247018,
247019,
247020,
247021,
247022,
247023,
247024,
247025,
247026,
247027,
247028,
247029,
247030,
247031,
247032,
247033,
247034,
247035,
247036,
247037,
247038,
247039,
247040,
247041,
247042,
247043,
247044,
247045,
247046,
247047,
247048,
247049,
247050,
247051,
247052,
247053,
247054,
247055,
247056,
247057,
247058,
247059,
247060,
247061,
247062,
247063,
247064,
247065,
247066,
247067,
247068,
247069,
247070,
247071,
247072,
247073,
247074,
247075,
247076,
247077,
247080,
247081,
247082,
247083,
247084,
247078,
247079,
247085,
247086,
247087,
247088,
247089,
247090,
247091,
247092,
247093,
247094,
247095,
247096,
247097,
247098,
247099,
247100,
247101,
247102,
247103,
247104,
247105,
247106,
247107,
247108,
247109
];
clinched = [
];
mapClinched = true;
mapStatus = mapStates.MAPVIEW;
genEdges = true;
}