<!-- /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: "prt.ve001", tier: 2, color: "TMteal", system: "prtve", label: "PRT VE1" };
routeInfo[1] = { firstWaypoint: 14, root: "prt.ve001svi", tier: 2, color: "TMteal", system: "prtve", label: "PRT VE1SVi" };
routeInfo[2] = { firstWaypoint: 18, root: "prt.ve002", tier: 2, color: "TMteal", system: "prtve", label: "PRT VE2" };
routeInfo[3] = { firstWaypoint: 24, root: "prt.ve003", tier: 2, color: "TMteal", system: "prtve", label: "PRT VE3" };
routeInfo[4] = { firstWaypoint: 41, root: "prt.ve004", tier: 2, color: "TMteal", system: "prtve", label: "PRT VE4" };
routeInfo[5] = { firstWaypoint: 49, root: "prt.ve005", tier: 2, color: "TMteal", system: "prtve", label: "PRT VE5" };
routeInfo[6] = { firstWaypoint: 53, root: "prt.ve006", tier: 2, color: "TMteal", system: "prtve", label: "PRT VE6" };
routeInfo[7] = { firstWaypoint: 55, root: "prt.ve007", tier: 2, color: "TMteal", system: "prtve", label: "PRT VE7" };
waypoints = [
new Waypoint("VR1",32.729657,-16.779749),
new Waypoint("ER236",32.734521,-16.805166),
new Waypoint("ER110_S",32.760988,-16.830046),
new Waypoint("RuaMarSpi",32.771651,-16.841505),
new Waypoint("ER110_N",32.776703,-16.845539),
new Waypoint("ER103",32.786075,-16.851418),
new Waypoint("ER213_E",32.790314,-16.853038),
new Waypoint("AveBJL",32.809451,-16.875697),
new Waypoint("ER213_W",32.811137,-16.884012),
new Waypoint("EstAchGra",32.821678,-16.888797),
new Waypoint("ER211_Jor",32.814906,-16.901028),
new Waypoint("EstFar",32.830315,-16.90797),
new Waypoint("+X78",32.828557,-16.942002),
new Waypoint("ER211_Arc",32.825374,-16.948417),
new Waypoint("EstVSBJ",32.820122,-16.975586),
new Waypoint("RueDME",32.821689,-16.990225),
new Waypoint("ER211",32.813869,-17.022983),
new Waypoint("VE2/4",32.802354,-17.043958),
new Waypoint("VE1/4",32.802354,-17.043958),
new Waypoint("ER211",32.808125,-17.051339),
new Waypoint("ER101_SeiE",32.819072,-17.102816),
new Waypoint("ER101_SeiW",32.824734,-17.114382),
new Waypoint("ER209",32.853093,-17.15631),
new Waypoint("ER101_Por",32.865963,-17.167189),
new Waypoint("VR1",32.684067,-17.051897),
new Waypoint("ER229",32.675127,-17.064106),
new Waypoint("ER227",32.677204,-17.078419),
new Waypoint("ER101_Vol",32.68171,-17.101936),
new Waypoint("ER101_Can",32.694071,-17.126184),
new Waypoint("ER101_Mad",32.701746,-17.135067),
new Waypoint("+X54",32.705736,-17.134037),
new Waypoint("ER101_Fon",32.711532,-17.152448),
new Waypoint("ER101_Lev",32.726083,-17.17324),
new Waypoint("CamDaIgr",32.730234,-17.187724),
new Waypoint("ER223",32.733141,-17.192981),
new Waypoint("+X19",32.74314,-17.195127),
new Waypoint("+X42",32.747913,-17.211735),
new Waypoint("CamLomRoc",32.753562,-17.210115),
new Waypoint("ER222_Pra",32.756747,-17.203367),
new Waypoint("ER222_Mal",32.765138,-17.208903),
new Waypoint("ER222_Rap",32.769306,-17.216338),
new Waypoint("VR1",32.684067,-17.051897),
new Waypoint("ER228_S",32.722689,-17.029409),
new Waypoint("SitPas",32.727834,-17.024356),
new Waypoint("+X96",32.742021,-17.017393),
new Waypoint("ER228_N",32.777028,-17.032971),
new Waypoint("ER104",32.784496,-17.033014),
new Waypoint("SitLar",32.791929,-17.034205),
new Waypoint("VE1/2",32.802354,-17.043958),
new Waypoint("ER204",32.648355,-16.858692),
new Waypoint("+X29",32.652149,-16.850731),
new Waypoint("EstFon",32.659303,-16.850903),
new Waypoint("ER110",32.677131,-16.847513),
new Waypoint("ER107_S",32.704599,-16.953921),
new Waypoint("ER107_N",32.724151,-16.96214),
new Waypoint("ER223_W",32.753381,-17.224803),
new Waypoint("ER223_E",32.737427,-17.208678)
];
traveler = 'jayhawkco';
segments = [
432497,
432498,
432499,
432500,
432501,
432502,
432503,
432504,
432505,
432506,
432507,
432508,
432509,
432510,
432511,
432512,
432513,
432514,
432515,
432516,
432517,
432518,
432519,
432520,
432521,
432522,
432523,
432524,
432525,
432526,
432527,
432528,
432529,
432530,
432531,
432532,
432533,
432534,
432535,
432536,
432537,
432538,
432539,
432540,
432541,
432542,
432543,
432544,
432545
];
clinched = [
432497,
432498,
432499,
432500,
432501,
432502,
432503,
432504,
432505,
432506,
432507,
432508,
432509,
432510,
432511,
432512,
432513,
432514,
432515,
432516,
432517,
432518,
432519,
432520,
432521,
432522,
432523,
432524,
432525,
432526,
432527,
432528,
432529,
432530,
432531,
432532,
432533,
432534,
432535,
432536,
432537,
432538,
432539,
432540,
432541,
432542,
432543,
432544,
432545
];
mapClinched = true;
mapStatus = mapStates.MAPVIEW;
genEdges = true;
}