<!-- /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.cs101", tier: 5, color: "TMyellow", system: "andcs", label: "AND CS101" };
routeInfo[1] = { firstWaypoint: 4, root: "and.cs102", tier: 5, color: "TMyellow", system: "andcs", label: "AND CS102" };
routeInfo[2] = { firstWaypoint: 6, root: "and.cs120", tier: 5, color: "TMyellow", system: "andcs", label: "AND CS120" };
routeInfo[3] = { firstWaypoint: 15, root: "and.cs130", tier: 5, color: "TMyellow", system: "andcs", label: "AND CS130" };
routeInfo[4] = { firstWaypoint: 27, root: "and.cs131", tier: 5, color: "TMyellow", system: "andcs", label: "AND CS131" };
routeInfo[5] = { firstWaypoint: 43, root: "and.cs140", tier: 5, color: "TMyellow", system: "andcs", label: "AND CS140" };
routeInfo[6] = { firstWaypoint: 47, root: "and.cs141", tier: 5, color: "TMyellow", system: "andcs", label: "AND CS141" };
routeInfo[7] = { firstWaypoint: 49, root: "and.cs142", tier: 5, color: "TMyellow", system: "andcs", label: "AND CS142" };
routeInfo[8] = { firstWaypoint: 58, root: "and.cs143", tier: 5, color: "TMyellow", system: "andcs", label: "AND CS143" };
routeInfo[9] = { firstWaypoint: 60, root: "and.cs144", tier: 5, color: "TMyellow", system: "andcs", label: "AND CS144" };
routeInfo[10] = { firstWaypoint: 62, root: "and.cs200", tier: 5, color: "TMyellow", system: "andcs", label: "AND CS200" };
routeInfo[11] = { firstWaypoint: 70, root: "and.cs210", tier: 5, color: "TMyellow", system: "andcs", label: "AND CS210" };
routeInfo[12] = { firstWaypoint: 73, root: "and.cs220", tier: 5, color: "TMyellow", system: "andcs", label: "AND CS220" };
routeInfo[13] = { firstWaypoint: 77, root: "and.cs221", tier: 5, color: "TMyellow", system: "andcs", label: "AND CS221" };
routeInfo[14] = { firstWaypoint: 79, root: "and.cs230", tier: 5, color: "TMyellow", system: "andcs", label: "AND CS230" };
routeInfo[15] = { firstWaypoint: 81, root: "and.cs240", tier: 5, color: "TMyellow", system: "andcs", label: "AND CS240" };
routeInfo[16] = { firstWaypoint: 90, root: "and.cs250", tier: 5, color: "TMyellow", system: "andcs", label: "AND CS250" };
routeInfo[17] = { firstWaypoint: 93, root: "and.cs251", tier: 5, color: "TMyellow", system: "andcs", label: "AND CS251" };
routeInfo[18] = { firstWaypoint: 95, root: "and.cs255", tier: 5, color: "TMyellow", system: "andcs", label: "AND CS255" };
routeInfo[19] = { firstWaypoint: 97, root: "and.cs260", tier: 5, color: "TMyellow", system: "andcs", label: "AND CS260" };
routeInfo[20] = { firstWaypoint: 101, root: "and.cs261", tier: 5, color: "TMyellow", system: "andcs", label: "AND CS261" };
routeInfo[21] = { firstWaypoint: 103, root: "and.cs262", tier: 5, color: "TMyellow", system: "andcs", label: "AND CS262" };
routeInfo[22] = { firstWaypoint: 106, root: "and.cs265", tier: 5, color: "TMyellow", system: "andcs", label: "AND CS265" };
routeInfo[23] = { firstWaypoint: 109, root: "and.cs266", tier: 5, color: "TMyellow", system: "andcs", label: "AND CS266" };
routeInfo[24] = { firstWaypoint: 111, root: "and.cs270", tier: 5, color: "TMyellow", system: "andcs", label: "AND CS270" };
routeInfo[25] = { firstWaypoint: 114, root: "and.cs280", tier: 5, color: "TMyellow", system: "andcs", label: "AND CS280" };
routeInfo[26] = { firstWaypoint: 116, root: "and.cs300", tier: 5, color: "TMyellow", system: "andcs", label: "AND CS300" };
routeInfo[27] = { firstWaypoint: 119, root: "and.cs310", tier: 5, color: "TMyellow", system: "andcs", label: "AND CS310" };
routeInfo[28] = { firstWaypoint: 131, root: "and.cs320", tier: 5, color: "TMyellow", system: "andcs", label: "AND CS320" };
routeInfo[29] = { firstWaypoint: 135, root: "and.cs321", tier: 5, color: "TMyellow", system: "andcs", label: "AND CS321" };
routeInfo[30] = { firstWaypoint: 138, root: "and.cs330", tier: 5, color: "TMyellow", system: "andcs", label: "AND CS330" };
routeInfo[31] = { firstWaypoint: 142, root: "and.cs335", tier: 5, color: "TMyellow", system: "andcs", label: "AND CS335" };
routeInfo[32] = { firstWaypoint: 145, root: "and.cs340", tier: 5, color: "TMyellow", system: "andcs", label: "AND CS340" };
routeInfo[33] = { firstWaypoint: 154, root: "and.cs345", tier: 5, color: "TMyellow", system: "andcs", label: "AND CS345" };
routeInfo[34] = { firstWaypoint: 158, root: "and.cs350", tier: 5, color: "TMyellow", system: "andcs", label: "AND CS350" };
routeInfo[35] = { firstWaypoint: 160, root: "and.cs360", tier: 5, color: "TMyellow", system: "andcs", label: "AND CS360" };
routeInfo[36] = { firstWaypoint: 163, root: "and.cs370", tier: 5, color: "TMyellow", system: "andcs", label: "AND CS370" };
routeInfo[37] = { firstWaypoint: 169, root: "and.cs400", tier: 5, color: "TMyellow", system: "andcs", label: "AND CS400" };
routeInfo[38] = { firstWaypoint: 172, root: "and.cs420", tier: 5, color: "TMyellow", system: "andcs", label: "AND CS420" };
routeInfo[39] = { firstWaypoint: 178, root: "and.cs430", tier: 5, color: "TMyellow", system: "andcs", label: "AND CS430" };
routeInfo[40] = { firstWaypoint: 181, root: "and.cs500", tier: 5, color: "TMyellow", system: "andcs", label: "AND CS500" };
routeInfo[41] = { firstWaypoint: 184, root: "and.cs510", tier: 5, color: "TMyellow", system: "andcs", label: "AND CS510" };
routeInfo[42] = { firstWaypoint: 188, root: "and.cs520", tier: 5, color: "TMyellow", system: "andcs", label: "AND CS520" };
routeInfo[43] = { firstWaypoint: 191, root: "and.cs530", tier: 5, color: "TMyellow", system: "andcs", label: "AND CS530" };
routeInfo[44] = { firstWaypoint: 195, root: "and.cs600", tier: 5, color: "TMyellow", system: "andcs", label: "AND CS600" };
routeInfo[45] = { firstWaypoint: 198, root: "and.cs610", tier: 5, color: "TMyellow", system: "andcs", label: "AND CS610" };
waypoints = [
new Waypoint("CG1",42.503664,1.519353),
new Waypoint("+X312751",42.49706,1.513088),
new Waypoint("CS102",42.498543,1.523731),
new Waypoint("CS200",42.504082,1.552275),
new Waypoint("CS101",42.498543,1.523731),
new Waypoint("CenTraRes",42.495523,1.522749),
new Waypoint("CG1",42.466965,1.491963),
new Waypoint("CS130",42.466603,1.492376),
new Waypoint("+X527990",42.47034,1.494677),
new Waypoint("+X764126",42.46683,1.495932),
new Waypoint("Nag",42.470095,1.498089),
new Waypoint("+X997833",42.470633,1.503432),
new Waypoint("+X826967",42.474253,1.500674),
new Waypoint("+X356395",42.471974,1.510459),
new Waypoint("Cer",42.47496,1.505449),
new Waypoint("CS120",42.466603,1.492376),
new Waypoint("CS131_W",42.4603,1.491576),
new Waypoint("TerTar",42.448896,1.490836),
new Waypoint("CarLin",42.438451,1.491029),
new Waypoint("+X687662",42.447718,1.508818),
new Waypoint("NatCota1600",42.441111,1.500632),
new Waypoint("+X398858",42.448565,1.517487),
new Waypoint("+X249735",42.442968,1.513667),
new Waypoint("CS131_E",42.444737,1.530093),
new Waypoint("+X358927",42.442042,1.522529),
new Waypoint("+X404461",42.442485,1.532271),
new Waypoint("NatCota2000",42.435941,1.519107),
new Waypoint("CS130_W",42.4603,1.491576),
new Waypoint("Aix",42.462529,1.501372),
new Waypoint("+X341215",42.459173,1.495793),
new Waypoint("+X936316",42.462481,1.509547),
new Waypoint("+X702387",42.458626,1.503153),
new Waypoint("+X233501",42.461025,1.513989),
new Waypoint("+X205221",42.458041,1.509075),
new Waypoint("+X797109",42.460225,1.515813),
new Waypoint("+X742595",42.457882,1.512036),
new Waypoint("+X367099",42.460748,1.519568),
new Waypoint("+X600977",42.45831,1.516242),
new Waypoint("+X341386",42.461349,1.521585),
new Waypoint("+X779893",42.458262,1.51916),
new Waypoint("+X173764",42.455326,1.534803),
new Waypoint("+X173765",42.443562,1.535076),
new Waypoint("CS130_E",42.444737,1.530093),
new Waypoint("CG1",42.461098,1.489989),
new Waypoint("CS141",42.453398,1.473273),
new Waypoint("CS142",42.452345,1.463435),
new Waypoint("Fon",42.454152,1.463606),
new Waypoint("CS140",42.453398,1.473273),
new Waypoint("Mui",42.443708,1.471224),
new Waypoint("CS140",42.452345,1.463435),
new Waypoint("+X744406",42.449864,1.471589),
new Waypoint("CS143",42.447267,1.465302),
new Waypoint("+X174932",42.451526,1.449809),
new Waypoint("+X356412",42.455896,1.451504),
new Waypoint("+X909819",42.454419,1.444445),
new Waypoint("+X102788",42.458066,1.451612),
new Waypoint("CS144",42.458878,1.44739),
new Waypoint("CS600",42.459321,1.449943),
new Waypoint("CS142",42.447267,1.465302),
new Waypoint("End",42.441032,1.459916),
new Waypoint("CS142",42.458878,1.44739),
new Waypoint("AND/ESP",42.458642,1.445915),
new Waypoint("CG2",42.510006,1.548257),
new Waypoint("CS101",42.504082,1.552275),
new Waypoint("Sol",42.508264,1.551856),
new Waypoint("+X982753",42.51364,1.559989),
new Waypoint("Eng",42.51222,1.55957),
new Waypoint("+X141764",42.509505,1.559404),
new Waypoint("CarEng",42.51776,1.570739),
new Waypoint("CampSer",42.517422,1.568202),
new Waypoint("AviJoanMar",42.532919,1.577826),
new Waypoint("CarRib",42.533576,1.57362),
new Waypoint("CS310",42.527709,1.548042),
new Waypoint("CG2",42.535256,1.588157),
new Waypoint("CS221",42.531291,1.60042),
new Waypoint("+X852986",42.5389,1.63413),
new Waypoint("CorEnc",42.539535,1.630665),
new Waypoint("CS220",42.531291,1.60042),
new Waypoint("LlacEng",42.522277,1.57215),
new Waypoint("CG2",42.550887,1.590915),
new Waypoint("Mer",42.553991,1.590443),
new Waypoint("CG2",42.565898,1.596553),
new Waypoint("+X851499",42.564903,1.59158),
new Waypoint("+X831391",42.568486,1.600294),
new Waypoint("+X889782",42.570987,1.59409),
new Waypoint("+X421580",42.572551,1.602387),
new Waypoint("+X969521",42.57282,1.591408),
new Waypoint("+X981529",42.568814,1.591215),
new Waypoint("+X983428",42.573649,1.586516),
new Waypoint("CS340",42.556028,1.572397),
new Waypoint("CG2",42.566748,1.60012),
new Waypoint("CS251",42.561983,1.593479),
new Waypoint("CamiRal",42.559059,1.593329),
new Waypoint("CS250",42.561983,1.593479),
new Waypoint("End",42.55573,1.616047),
new Waypoint("CG2",42.578133,1.634152),
new Waypoint("AldCan",42.578868,1.628101),
new Waypoint("CG2",42.579918,1.64561),
new Waypoint("CS261",42.581386,1.63803),
new Waypoint("CS262",42.592573,1.637456),
new Waypoint("ComaRan",42.612068,1.637878),
new Waypoint("CS260",42.581386,1.63803),
new Waypoint("ElsPla",42.581554,1.632156),
new Waypoint("CS260",42.592573,1.637456),
new Waypoint("+X366367",42.583236,1.640364),
new Waypoint("Ent",42.583805,1.652606),
new Waypoint("CG2",42.579444,1.649537),
new Waypoint("PlaTar_E",42.580185,1.649231),
new Waypoint("Tar",42.58058,1.648405),
new Waypoint("CG2",42.577778,1.65385),
new Waypoint("PlaTar",42.579273,1.653035),
new Waypoint("CG2",42.583825,1.663538),
new Waypoint("PontBal",42.601973,1.687177),
new Waypoint("End",42.601815,1.687885),
new Waypoint("CG2",42.547366,1.700392),
new Waypoint("GrauRoig",42.535335,1.701851),
new Waypoint("AviFitRos",42.5152,1.531305),
new Waypoint("+X967809",42.517485,1.53079),
new Waypoint("CarCanDiu",42.515579,1.538397),
new Waypoint("CG3",42.532738,1.519804),
new Waypoint("+X656488",42.53454,1.520716),
new Waypoint("+X217024",42.530927,1.52283),
new Waypoint("CamiPad",42.535038,1.526166),
new Waypoint("CS335",42.536388,1.528301),
new Waypoint("Ori",42.536817,1.530898),
new Waypoint("+X701569",42.534473,1.528001),
new Waypoint("+X895984",42.531884,1.531949),
new Waypoint("+X610437",42.538394,1.542077),
new Waypoint("+X167618",42.532409,1.541455),
new Waypoint("+X897515",42.538038,1.549137),
new Waypoint("CS210",42.527709,1.548042),
new Waypoint("CG3",42.533789,1.519364),
new Waypoint("+X772172",42.531188,1.517111),
new Waypoint("CS321",42.534398,1.515663),
new Waypoint("End",42.523428,1.475515),
new Waypoint("CS320",42.534398,1.515663),
new Waypoint("CarPla",42.537277,1.516097),
new Waypoint("CS330",42.541552,1.515512),
new Waypoint("CG3",42.545688,1.514676),
new Waypoint("CS321",42.541552,1.515512),
new Waypoint("CarPla",42.54341,1.510373),
new Waypoint("UrbGir",42.546674,1.509054),
new Waypoint("CG3",42.551417,1.526467),
new Waypoint("CarBoi",42.544827,1.523956),
new Waypoint("CS310",42.536388,1.528301),
new Waypoint("CG3",42.555601,1.532904),
new Waypoint("CS345",42.555473,1.533167),
new Waypoint("+X876727",42.55067,1.528473),
new Waypoint("CamiRed",42.556803,1.54845),
new Waypoint("+X320065",42.54931,1.541026),
new Waypoint("+X317536",42.55606,1.555789),
new Waypoint("+X226551",42.555862,1.56199),
new Waypoint("+X320204",42.552175,1.552012),
new Waypoint("CS240",42.556028,1.572397),
new Waypoint("CS340",42.555473,1.533167),
new Waypoint("CarAFR",42.556674,1.534878),
new Waypoint("CarReg",42.557413,1.537609),
new Waypoint("End",42.558111,1.540543),
new Waypoint("CG3",42.5632,1.527539),
new Waypoint("CarCapPeca",42.564592,1.527312),
new Waypoint("CG3",42.582269,1.51908),
new Waypoint("+X200490",42.582028,1.517261),
new Waypoint("Ara",42.585014,1.518334),
new Waypoint("CG3",42.622631,1.534824),
new Waypoint("VallSor",42.625809,1.551956),
new Waypoint("+X650194",42.623061,1.551658),
new Waypoint("+X319965",42.621431,1.554936),
new Waypoint("+X288183",42.622945,1.553262),
new Waypoint("PorSor",42.621337,1.558393),
new Waypoint("CG4",42.548115,1.513345),
new Waypoint("+X164924",42.547881,1.515424),
new Waypoint("CarComaCol",42.548556,1.514255),
new Waypoint("CG4",42.537192,1.482693),
new Waypoint("+X892858",42.54288,1.493722),
new Waypoint("CS420_E",42.538169,1.494495),
new Waypoint("PlaCau",42.537062,1.492167),
new Waypoint("+X279231",42.53926,1.492692),
new Waypoint("CS420_W",42.538169,1.494495),
new Waypoint("CG4",42.550002,1.511596),
new Waypoint("+X235161",42.552077,1.520931),
new Waypoint("ColCol",42.552816,1.514665),
new Waypoint("CG5",42.565831,1.490858),
new Waypoint("+X898962",42.564863,1.492971),
new Waypoint("PuiPiu",42.566471,1.490793),
new Waypoint("CG5",42.570955,1.486309),
new Waypoint("+X395059",42.568,1.491625),
new Waypoint("+X440300",42.570544,1.491759),
new Waypoint("MasRib",42.568842,1.492209),
new Waypoint("CG5",42.578169,1.478836),
new Waypoint("+X875192",42.56559,1.473498),
new Waypoint("MirRocaSab",42.572512,1.471288),
new Waypoint("CG5",42.578169,1.478836),
new Waypoint("CarPratSob",42.578984,1.476701),
new Waypoint("+X429814",42.580229,1.476674),
new Waypoint("PratSob",42.579281,1.480853),
new Waypoint("CG6",42.483618,1.458478),
new Waypoint("Can",42.474567,1.451799),
new Waypoint("CS142",42.459321,1.449943),
new Waypoint("CG6",42.484079,1.457963),
new Waypoint("+X863306",42.482997,1.460119),
new Waypoint("+X735643",42.486174,1.461761),
new Waypoint("+X496962",42.483147,1.465216),
new Waypoint("+X411982",42.487068,1.464679),
new Waypoint("+X366021",42.484841,1.46764),
new Waypoint("Aix",42.486455,1.467147)
];
traveler = 'duke87';
segments = [
1150,
1151,
1152,
1153,
1154,
1155,
1156,
1157,
1158,
1159,
1160,
1161,
1162,
1163,
1164,
1165,
1166,
1167,
1168,
1169,
1170,
1171,
1172,
1173,
1174,
1175,
1176,
1177,
1178,
1179,
1180,
1181,
1182,
1183,
1184,
1185,
1186,
1187,
1188,
1189,
1190,
1191,
1192,
1193,
1194,
1195,
1196,
1197,
1198,
1199,
1200,
1201,
1202,
1203,
1204,
1205,
1206,
1207,
1208,
1209,
1210,
1211,
1212,
1213,
1214,
1215,
1216,
1217,
1218,
1219,
1220,
1221,
1222,
1223,
1224,
1225,
1226,
1227,
1228,
1229,
1230,
1231,
1232,
1233,
1234,
1235,
1236,
1237,
1238,
1239,
1240,
1241,
1242,
1243,
1244,
1245,
1246,
1247,
1248,
1249,
1250,
1251,
1252,
1253,
1254,
1255,
1256,
1257,
1258,
1259,
1260,
1261,
1262,
1263,
1264,
1265,
1266,
1267,
1268,
1269,
1270,
1271,
1272,
1273,
1274,
1275,
1276,
1277,
1278,
1279,
1280,
1281,
1282,
1283,
1284,
1285,
1286,
1287,
1288,
1289,
1290,
1291,
1292,
1293,
1294,
1295,
1296,
1297,
1298,
1299,
1300,
1301,
1302,
1303,
1304,
1305,
1306,
1307,
1308
];
clinched = [
1239
];
mapClinched = true;
mapStatus = mapStates.MAPVIEW;
genEdges = true;
}