<!-- /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: "and.cg001", tier: 4, color: "TMlightsalmon", system: "andcg", label: "AND CG1" };
routeInfo[1] = { firstWaypoint: 9, root: "and.cg001a", tier: 4, color: "TMlightsalmon", system: "andcg", label: "AND CG1A" };
routeInfo[2] = { firstWaypoint: 12, root: "and.cg002", tier: 4, color: "TMlightsalmon", system: "andcg", label: "AND CG2" };
routeInfo[3] = { firstWaypoint: 39, root: "and.cg002a", tier: 4, color: "TMlightsalmon", system: "andcg", label: "AND CG2A" };
routeInfo[4] = { firstWaypoint: 43, root: "and.cg003", tier: 4, color: "TMlightsalmon", system: "andcg", label: "AND CG3" };
routeInfo[5] = { firstWaypoint: 63, root: "and.cg003a", tier: 4, color: "TMlightsalmon", system: "andcg", label: "AND CG3A" };
routeInfo[6] = { firstWaypoint: 65, root: "and.cg004", tier: 4, color: "TMlightsalmon", system: "andcg", label: "AND CG4" };
routeInfo[7] = { firstWaypoint: 74, root: "and.cg005", tier: 4, color: "TMlightsalmon", system: "andcg", label: "AND CG5" };
routeInfo[8] = { firstWaypoint: 78, root: "and.cg006", tier: 4, color: "TMlightsalmon", system: "andcg", label: "AND CG6" };
waypoints = [
new Waypoint("CG2/3",42.506512,1.534202),
new Waypoint("CS101",42.503664,1.519353),
new Waypoint("CG1A_N",42.493872,1.500835),
new Waypoint("CG1A_S",42.484734,1.491973),
new Waypoint("CG6",42.47656,1.490536),
new Waypoint("AviRoc",42.475029,1.49074),
new Waypoint("CS120",42.466965,1.491963),
new Waypoint("CS140",42.461098,1.489989),
new Waypoint("AND/ESP",42.435299,1.472795),
new Waypoint("CG1_N",42.493872,1.500835),
new Waypoint("AviSanCol",42.494971,1.498497),
new Waypoint("CG1_S",42.484734,1.491973),
new Waypoint("CG1/3",42.506512,1.534202),
new Waypoint("CS200",42.510006,1.548257),
new Waypoint("AviPontTos",42.51224,1.550494),
new Waypoint("CG3A",42.517963,1.555402),
new Waypoint("AviJoanMar",42.529354,1.571506),
new Waypoint("AveFraMit",42.533427,1.585084),
new Waypoint("CS220",42.535256,1.588157),
new Waypoint("CS230",42.550887,1.590915),
new Waypoint("+X877939",42.563227,1.590614),
new Waypoint("CS240",42.565898,1.596553),
new Waypoint("CS250",42.566748,1.60012),
new Waypoint("CS255",42.578133,1.634152),
new Waypoint("CS260",42.579918,1.64561),
new Waypoint("CS265",42.579444,1.649537),
new Waypoint("CS266",42.577778,1.65385),
new Waypoint("CS270",42.583825,1.663538),
new Waypoint("CG2A",42.55161,1.695457),
new Waypoint("CS280",42.547366,1.700392),
new Waypoint("+X01",42.542267,1.705112),
new Waypoint("+X02",42.549919,1.703739),
new Waypoint("+X03",42.537556,1.720047),
new Waypoint("+X04",42.543564,1.727686),
new Waypoint("+X05",42.537398,1.726871),
new Waypoint("CarSantJor",42.546358,1.730915),
new Waypoint("+X06",42.54886,1.732299),
new Waypoint("CarAbe",42.543706,1.733716),
new Waypoint("AND/FRA",42.543501,1.735582),
new Waypoint("CG2",42.55161,1.695457),
new Waypoint("+X850802",42.545192,1.701443),
new Waypoint("+X504668",42.544228,1.727514),
new Waypoint("AND/FRA",42.549097,1.737857),
new Waypoint("CG1/2",42.506512,1.534202),
new Waypoint("AviConEur",42.50996,1.533719),
new Waypoint("AviFitRos",42.519482,1.523892),
new Waypoint("CG3A",42.530378,1.520405),
new Waypoint("CS310",42.532738,1.519804),
new Waypoint("CS320",42.533789,1.519364),
new Waypoint("CS330",42.545688,1.514676),
new Waypoint("CG4",42.547263,1.513796),
new Waypoint("CS335",42.551417,1.526467),
new Waypoint("CS340",42.555601,1.532904),
new Waypoint("CS350",42.5632,1.527539),
new Waypoint("CS360",42.582269,1.51908),
new Waypoint("+X01",42.620792,1.542764),
new Waypoint("CS370",42.622631,1.534824),
new Waypoint("+X656164",42.631654,1.515427),
new Waypoint("+X697332",42.631749,1.500149),
new Waypoint("+X668783",42.627281,1.493282),
new Waypoint("+X707528",42.632254,1.495943),
new Waypoint("ComaArc",42.631636,1.481371),
new Waypoint("End",42.621727,1.478595),
new Waypoint("CG2",42.517963,1.555402),
new Waypoint("CG3",42.530378,1.520405),
new Waypoint("CG3",42.547263,1.513796),
new Waypoint("CS400",42.548115,1.513345),
new Waypoint("CS430",42.550002,1.511596),
new Waypoint("CG5",42.561457,1.496587),
new Waypoint("CamiCar",42.543754,1.472318),
new Waypoint("CS420",42.537192,1.482693),
new Waypoint("+X01",42.533603,1.466374),
new Waypoint("+X02",42.560003,1.44599),
new Waypoint("PortCab",42.546346,1.419731),
new Waypoint("CG4",42.561457,1.496587),
new Waypoint("CS500",42.565831,1.490858),
new Waypoint("CS510",42.570955,1.486309),
new Waypoint("CS520/530",42.578169,1.478836),
new Waypoint("CG1",42.47656,1.490536),
new Waypoint("CS600",42.483618,1.458478),
new Waypoint("CS610",42.484079,1.457963),
new Waypoint("AND/ESP",42.495422,1.443629)
];
traveler = '';
segments = [
1309,
1310,
1311,
1312,
1313,
1314,
1315,
1316,
1317,
1318,
1319,
1320,
1321,
1322,
1323,
1324,
1325,
1326,
1327,
1328,
1329,
1330,
1331,
1332,
1333,
1334,
1335,
1336,
1337,
1338,
1339,
1340,
1341,
1342,
1343,
1344,
1345,
1346,
1347,
1348,
1349,
1350,
1351,
1352,
1353,
1354,
1355,
1356,
1357,
1358,
1359,
1360,
1361,
1362,
1363,
1364,
1365,
1366,
1367,
1368,
1369,
1370,
1371,
1372,
1373,
1374,
1375,
1376,
1377,
1378,
1379,
1380,
1381
];
clinched = [
];
mapClinched = true;
mapStatus = mapStates.MAPVIEW;
genEdges = true;
}