<!-- /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: "mexchih.chih007d", tier: 3, color: "TMteal", system: "mexed", label: "MEX-CHIH CHIH7D" };
routeInfo[1] = { firstWaypoint: 9, root: "mexchih.chih048d", tier: 3, color: "TMteal", system: "mexed", label: "MEX-CHIH CHIH48D" };
routeInfo[2] = { firstWaypoint: 13, root: "mexchih.chih056d", tier: 3, color: "TMteal", system: "mexed", label: "MEX-CHIH CHIH56D" };
routeInfo[3] = { firstWaypoint: 20, root: "mexemex.emex005d", tier: 3, color: "TMteal", system: "mexed", label: "MEX-EMEX EMEX5D" };
routeInfo[4] = { firstWaypoint: 31, root: "mexemex.emexa007", tier: 3, color: "TMteal", system: "mexed", label: "MEX-EMEX EMEXA7" };
routeInfo[5] = { firstWaypoint: 37, root: "mexmor.pue438d", tier: 3, color: "TMteal", system: "mexed", label: "MEX-MOR PUE438D" };
routeInfo[6] = { firstWaypoint: 42, root: "mexnl.nl040d", tier: 3, color: "TMteal", system: "mexed", label: "MEX-NL NL40D" };
routeInfo[7] = { firstWaypoint: 48, root: "mexpue.pue190d", tier: 3, color: "TMteal", system: "mexed", label: "MEX-PUE PUE190D" };
routeInfo[8] = { firstWaypoint: 53, root: "mexpue.pue438d", tier: 3, color: "TMteal", system: "mexed", label: "MEX-PUE PUE438D" };
routeInfo[9] = { firstWaypoint: 66, root: "mexsin.sinae001", tier: 3, color: "TMteal", system: "mexed", label: "MEX-SIN SINAE1" };
routeInfo[10] = { firstWaypoint: 84, root: "mexslp.slp075d", tier: 3, color: "TMteal", system: "mexed", label: "MEX-SLP SLP75D" };
routeInfo[11] = { firstWaypoint: 95, root: "mexslp.slp080d", tier: 3, color: "TMteal", system: "mexed", label: "MEX-SLP SLP80D" };
waypoints = [
new Waypoint("MEX45",29.476292,-106.402245),
new Waypoint("+X0",29.559273,-106.471596),
new Waypoint("+X1",29.746643,-106.684799),
new Waypoint("+X1A",29.75022,-106.712737),
new Waypoint("+X700584",29.793096,-106.758699),
new Waypoint("+X2",29.809444,-106.793847),
new Waypoint("+X3",29.820298,-106.868863),
new Waypoint("+X4",29.900112,-106.938815),
new Waypoint("MEX10/19",29.940432,-106.9489),
new Waypoint("MEX45",31.450595,-106.466489),
new Waypoint("+X560611",31.461029,-106.507194),
new Waypoint("+X103339",31.590088,-106.683168),
new Waypoint("MEX2",31.608583,-106.684628),
new Waypoint("MEX10_W",30.180228,-107.625933),
new Waypoint("Gal_W",30.141193,-107.564049),
new Waypoint("Gal_E",30.108157,-107.493238),
new Waypoint("+X2",30.101772,-107.412128),
new Waypoint("+X3",30.040715,-107.336941),
new Waypoint("+X4",29.998206,-107.220726),
new Waypoint("MEX10_E",29.966535,-107.062626),
new Waypoint("MEX136D",19.46811,-99.007652),
new Waypoint("PerMex",19.487833,-99.01602),
new Waypoint("+X0",19.564643,-99.013939),
new Waypoint("MEX85",19.581545,-99.025826),
new Waypoint("MEX85D",19.604873,-99.036942),
new Waypoint("MEX142",19.613888,-99.040718),
new Waypoint("+X1",19.747317,-99.107022),
new Waypoint("EMEX9",19.751942,-99.129703),
new Waypoint("+X2",19.819157,-99.202595),
new Waypoint("+X3",19.823962,-99.232764),
new Waypoint("MEX57D",19.819056,-99.242892),
new Waypoint("MEX15Val",19.396901,-100.066953),
new Waypoint("+X1",19.371721,-100.029488),
new Waypoint("Tur",19.354635,-99.98301),
new Waypoint("+X2",19.37666,-99.904261),
new Waypoint("MEX15",19.381114,-99.808066),
new Waypoint("MEX15D/55D",19.386819,-99.706662),
new Waypoint("MEX160",18.702371,-98.768377),
new Waypoint("Jan",18.71926,-98.767369),
new Waypoint("Ami",18.729421,-98.76312),
new Waypoint("Pop",18.747404,-98.749366),
new Waypoint("MOR/PUE",18.750025,-98.747048),
new Waypoint("AvAdoMat",25.693842,-100.212554),
new Waypoint("AvDiaEmp",25.695447,-100.180378),
new Waypoint("ValGua",25.692933,-100.164456),
new Waypoint("M41",25.689588,-100.145702),
new Waypoint("M910",25.65967,-100.07869),
new Waypoint("MEX40D",25.654632,-100.069528),
new Waypoint("MEX190",18.921206,-98.408854),
new Waypoint("PUE438D",18.937911,-98.391023),
new Waypoint("+X1",18.975536,-98.36493),
new Waypoint("+X2",18.979594,-98.322144),
new Waypoint("PerEco",19.010474,-98.262234),
new Waypoint("MOR/PUE",18.750025,-98.747048),
new Waypoint("Act",18.756121,-98.741512),
new Waypoint("+X1",18.782167,-98.731813),
new Waypoint("+X11",18.822264,-98.687718),
new Waypoint("+X12",18.815318,-98.674049),
new Waypoint("+X13",18.822,-98.61165),
new Waypoint("+X14",18.848624,-98.531656),
new Waypoint("+X15",18.876483,-98.504362),
new Waypoint("+X16",18.929143,-98.479085),
new Waypoint("Met",18.930888,-98.469515),
new Waypoint("+X17",18.94816,-98.438358),
new Waypoint("SanAug",18.940519,-98.39437),
new Waypoint("PUE190D",18.937911,-98.391023),
new Waypoint("SIN5",24.745974,-107.452598),
new Waypoint("+X0",24.754002,-107.508259),
new Waypoint("SIN280",24.749871,-107.5704),
new Waypoint("+X1",24.758952,-107.584991),
new Waypoint("+X2",24.820627,-107.588167),
new Waypoint("+X2A",24.849992,-107.612801),
new Waypoint("SIN259",24.877054,-107.654943),
new Waypoint("+X3",24.919562,-107.72923),
new Waypoint("+X4",24.968416,-107.770257),
new Waypoint("+X5",24.992087,-107.773304),
new Waypoint("SIN225",25.072286,-107.878404),
new Waypoint("+X6",25.153676,-107.966466),
new Waypoint("+X7",25.240193,-108.005433),
new Waypoint("+X7A",25.250906,-108.041439),
new Waypoint("+X8",25.321296,-108.118558),
new Waypoint("+X9",25.38358,-108.118687),
new Waypoint("SIN223",25.393001,-108.127956),
new Waypoint("MEX15",25.488104,-108.234301),
new Waypoint("MEX70",21.92113,-99.959965),
new Waypoint("+X1",21.932636,-99.956403),
new Waypoint("+X2",22.003359,-100.020926),
new Waypoint("+X3",22.192213,-100.169563),
new Waypoint("+X4",22.226064,-100.221233),
new Waypoint("+X5",22.324433,-100.289125),
new Waypoint("+X6",22.42539,-100.316634),
new Waypoint("CemMoc",22.474096,-100.387444),
new Waypoint("+X7",22.516561,-100.445809),
new Waypoint("+X8",22.535827,-100.459113),
new Waypoint("MEX80",22.590675,-100.592408),
new Waypoint("MEX70/80",21.899013,-101.39883),
new Waypoint("+X1",21.89292,-101.393595),
new Waypoint("+X2",21.9061,-101.194553),
new Waypoint("+X3",21.885474,-101.159363),
new Waypoint("+X4",21.81254,-101.112456),
new Waypoint("+X5",21.816803,-101.070828),
new Waypoint("+X6",21.802699,-101.020446),
new Waypoint("+X7",21.932934,-100.931654),
new Waypoint("MEX57",22.018777,-100.842905)
];
traveler = 'yasubee_horibe';
segments = [
391199,
391200,
391201,
391202,
391203,
391204,
391205,
391206,
391207,
391208,
391209,
391210,
391211,
391212,
391213,
391214,
391215,
391216,
391217,
391218,
391219,
391220,
391221,
391222,
391223,
391224,
391225,
391226,
391227,
391228,
391229,
391230,
391240,
391241,
391242,
391243,
391231,
391232,
391233,
391234,
391235,
391236,
391237,
391238,
391239,
391244,
391245,
391246,
391247,
391248,
391249,
391250,
391251,
391252,
391253,
391254,
391255,
391256,
391257,
391258,
391259,
391260,
391261,
391262,
391263,
391264,
391265,
391266,
391267,
391268,
391269,
391270,
391271,
391272,
391273,
391274,
391275,
391276,
391277,
391278,
391279,
391280,
391281,
391282,
391283,
391284,
391285,
391286,
391287,
391288,
391289,
391290
];
clinched = [
];
mapClinched = true;
mapStatus = mapStates.MAPVIEW;
genEdges = true;
}