<!-- /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: "rks.r006", tier: 1, color: "TMblue", system: "rksr", label: "RKS R6" };
routeInfo[1] = { firstWaypoint: 14, root: "rks.r007", tier: 1, color: "TMblue", system: "rksr", label: "RKS R7" };
routeInfo[2] = { firstWaypoint: 30, root: "rks.r007pri", tier: 1, color: "TMblue", system: "rksr", label: "RKS R7Pri" };
waypoints = [
new Waypoint("1",42.619524,21.115626),
new Waypoint("+X926301",42.56819,21.118469),
new Waypoint("2",42.546275,21.131934),
new Waypoint("+X976446",42.532085,21.140356),
new Waypoint("+X722021",42.529832,21.1625),
new Waypoint("+R6.1",42.51499,21.174903),
new Waypoint("+X913499",42.488872,21.189623),
new Waypoint("3",42.46241,21.17898),
new Waypoint("+X140058",42.430806,21.200867),
new Waypoint("4",42.36789,21.205051),
new Waypoint("5",42.276229,21.212025),
new Waypoint("+X896530",42.188004,21.266527),
new Waypoint("+X129888",42.179672,21.263437),
new Waypoint("6",42.149763,21.299422),
new Waypoint("ALB/RKS",42.155991,20.547309),
new Waypoint("1",42.157852,20.555023),
new Waypoint("2",42.196048,20.669339),
new Waypoint("+X365751",42.230074,20.690732),
new Waypoint("3",42.249996,20.716396),
new Waypoint("+X134488",42.280071,20.75326),
new Waypoint("+X278892",42.32695,20.770468),
new Waypoint("4",42.36384,20.810573),
new Waypoint("*N25_W",42.378583,20.845184),
new Waypoint("+X678557",42.397189,20.860892),
new Waypoint("5",42.40672,20.85719),
new Waypoint("+X745070",42.43866,20.822525),
new Waypoint("6",42.466526,20.805959),
new Waypoint("+X428557",42.484441,20.793257),
new Waypoint("+X813036",42.532117,20.801668),
new Waypoint("7",42.551357,20.813642),
new Waypoint("8",42.623685,21.085033),
new Waypoint("9",42.619524,21.115626),
new Waypoint("+X471784",42.642404,21.123662),
new Waypoint("11",42.679008,21.108068),
new Waypoint("+X490192",42.701007,21.111635),
new Waypoint("+X518021",42.727596,21.127739),
new Waypoint("N25",42.732249,21.142765)
];
traveler = 'michih';
segments = [
432931,
432932,
432933,
432934,
432935,
432936,
432937,
432938,
432939,
432940,
432941,
432942,
432943,
432944,
432945,
432946,
432947,
432948,
432949,
432950,
432951,
432952,
432953,
432954,
432955,
432956,
432957,
432958,
432959,
432960,
432961,
432962,
432963,
432964
];
clinched = [
432931,
432932,
432933,
432934,
432935,
432936,
432937,
432938,
432939,
432940,
432941,
432942,
432943,
432944,
432945,
432946,
432947,
432948,
432949,
432950,
432951,
432952,
432953,
432954,
432955,
432956,
432957,
432958,
432959,
432960,
432961,
432962,
432963,
432964
];
mapClinched = true;
mapStatus = mapStates.MAPVIEW;
genEdges = true;
}