<!-- /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: "tun.a001", tier: 1, color: "TMblue", system: "tuna", label: "TUN A1" };
routeInfo[1] = { firstWaypoint: 83, root: "tun.a003", tier: 1, color: "TMblue", system: "tuna", label: "TUN A3" };
routeInfo[2] = { firstWaypoint: 109, root: "tun.a004", tier: 1, color: "TMblue", system: "tuna", label: "TUN A4" };
waypoints = [
new Waypoint("RR22",36.728016,10.246124),
new Waypoint("1",36.717215,10.268912),
new Waypoint("2",36.695367,10.305133),
new Waypoint("3",36.646032,10.364614),
new Waypoint("4",36.585347,10.485249),
new Waypoint("5",36.567184,10.516405),
new Waypoint("+X311467",36.481726,10.570393),
new Waypoint("6",36.44067,10.564835),
new Waypoint("6a",36.420005,10.554686),
new Waypoint("7",36.405327,10.554729),
new Waypoint("7a",36.34256,10.489669),
new Waypoint("+X774271",36.323631,10.455465),
new Waypoint("8",36.304128,10.443707),
new Waypoint("+X145087",36.233404,10.413237),
new Waypoint("+X331045",36.200131,10.432248),
new Waypoint("9",36.106745,10.404739),
new Waypoint("10",36.086702,10.401564),
new Waypoint("11",35.995542,10.441003),
new Waypoint("+X491045",35.973352,10.459671),
new Waypoint("+X203653",35.951886,10.506277),
new Waypoint("12",35.935139,10.508251),
new Waypoint("+X962952",35.909595,10.491171),
new Waypoint("13",35.877159,10.505505),
new Waypoint("14",35.840012,10.533786),
new Waypoint("15",35.775939,10.557132),
new Waypoint("16",35.712023,10.558376),
new Waypoint("+X309952",35.662666,10.561295),
new Waypoint("17",35.641603,10.577774),
new Waypoint("+X472613",35.625419,10.592537),
new Waypoint("+X341628",35.532925,10.624852),
new Waypoint("18",35.462767,10.634766),
new Waypoint("+X568238",35.40843,10.675535),
new Waypoint("19",35.309522,10.652575),
new Waypoint("+X551926",35.20341,10.64558),
new Waypoint("+X369220",35.168546,10.653734),
new Waypoint("20",35.095895,10.712786),
new Waypoint("+X638676",35.050551,10.716519),
new Waypoint("+X605754",35.008628,10.740209),
new Waypoint("+X874337",34.913596,10.736818),
new Waypoint("22",34.891546,10.716498),
new Waypoint("+X282198",34.844663,10.673175),
new Waypoint("+X345753",34.819018,10.634508),
new Waypoint("23",34.727223,10.588417),
new Waypoint("+X597559",34.676206,10.544429),
new Waypoint("+X892624",34.649308,10.500998),
new Waypoint("+X951141",34.611136,10.468469),
new Waypoint("24",34.593756,10.434995),
new Waypoint("+X713781",34.518721,10.233936),
new Waypoint("+25",34.517201,10.205956),
new Waypoint("+X862343",34.514584,10.16613),
new Waypoint("+X598873",34.53046,10.092316),
new Waypoint("+X774802",34.522964,10.080342),
new Waypoint("+X916494",34.399757,10.063219),
new Waypoint("26",34.388443,10.049121),
new Waypoint("+X840754",34.33479,10.007172),
new Waypoint("+X578833",34.157273,9.970951),
new Waypoint("+X383558",34.105267,9.942284),
new Waypoint("27",34.032319,9.921513),
new Waypoint("+X656734",34.020368,9.919538),
new Waypoint("+X780814",33.934032,9.963055),
new Waypoint("28",33.881817,9.996099),
new Waypoint("29",33.800155,10.06073),
new Waypoint("+X752068",33.734155,10.147247),
new Waypoint("+X826244",33.633219,10.180206),
new Waypoint("+X878995",33.600993,10.206299),
new Waypoint("30",33.560762,10.310111),
new Waypoint("+X369389",33.529161,10.369377),
new Waypoint("+X110351",33.459014,10.454178),
new Waypoint("+X321509",33.407944,10.506191),
new Waypoint("+X131617",33.37462,10.559406),
new Waypoint("ToRN1",33.347827,10.574298),
new Waypoint("+X347097",33.310913,10.589275),
new Waypoint("+X716621",33.26076,10.686264),
new Waypoint("RR115",33.199563,10.83282),
new Waypoint("+X436474",33.148295,10.983152),
new Waypoint("+X180658",33.144199,11.037054),
new Waypoint("RN1_BG",33.129393,11.066236),
new Waypoint("+X894255",33.104161,11.097565),
new Waypoint("+X265849",33.065039,11.197815),
new Waypoint("+X631313",33.058925,11.242104),
new Waypoint("+X383499",33.081222,11.312399),
new Waypoint("+X952774",33.124793,11.370764),
new Waypoint("RN1_RA",33.147244,11.42312),
new Waypoint("RN5",36.773267,10.072317),
new Waypoint("1",36.740707,10.031161),
new Waypoint("2",36.682909,9.912801),
new Waypoint("+X460730",36.666422,9.879713),
new Waypoint("+X874162",36.645008,9.739723),
new Waypoint("+X100963",36.626067,9.713974),
new Waypoint("+X545289",36.631785,9.680414),
new Waypoint("3",36.623967,9.663806),
new Waypoint("+X671968",36.596029,9.619045),
new Waypoint("+X496909",36.585898,9.577246),
new Waypoint("4",36.602971,9.529803),
new Waypoint("+X618858",36.610705,9.495792),
new Waypoint("5",36.653478,9.458413),
new Waypoint("+X518688",36.669176,9.450989),
new Waypoint("+X199714",36.680741,9.42275),
new Waypoint("+X336716",36.706825,9.399834),
new Waypoint("+X570744",36.68377,9.371767),
new Waypoint("+X826839",36.703591,9.337542),
new Waypoint("+X771326",36.698017,9.292889),
new Waypoint("+X392670",36.716939,9.270229),
new Waypoint("6",36.685835,9.225769),
new Waypoint("+X513394",36.673032,9.146032),
new Waypoint("+X473704",36.651343,9.124231),
new Waypoint("7",36.628048,9.030912),
new Waypoint("Sou",36.636623,8.964157),
new Waypoint("RN11",36.637062,8.952763),
new Waypoint("RN8_Ceb",36.898224,10.118194),
new Waypoint("+X686377",36.938367,10.092916),
new Waypoint("+X942381",36.99844,10.020046),
new Waypoint("+X224744",37.030994,9.994726),
new Waypoint("RN8_Zan",37.072437,10.001593),
new Waypoint("+X905223",37.117039,10.034766),
new Waypoint("RR151",37.16124,10.025797),
new Waypoint("+X880808",37.192801,10.008545),
new Waypoint("RN8_Biz",37.256361,9.901686)
];
traveler = 'yasubee_horibe';
segments = [
475269,
475270,
475271,
475272,
475273,
475274,
475275,
475276,
475277,
475278,
475279,
475280,
475281,
475282,
475283,
475284,
475285,
475286,
475287,
475288,
475289,
475290,
475291,
475292,
475293,
475294,
475295,
475296,
475297,
475298,
475299,
475300,
475301,
475302,
475303,
475304,
475305,
475306,
475307,
475308,
475309,
475310,
475311,
475312,
475313,
475314,
475315,
475316,
475317,
475318,
475319,
475320,
475321,
475322,
475323,
475324,
475325,
475326,
475327,
475328,
475329,
475330,
475331,
475332,
475333,
475334,
475335,
475336,
475337,
475338,
475339,
475340,
475341,
475342,
475343,
475344,
475345,
475346,
475347,
475348,
475349,
475350,
475351,
475352,
475353,
475354,
475355,
475356,
475357,
475358,
475359,
475360,
475361,
475362,
475363,
475364,
475365,
475366,
475367,
475368,
475369,
475370,
475371,
475372,
475373,
475374,
475375,
475376,
475377,
475378,
475379,
475380,
475381,
475382,
475383
];
clinched = [
];
mapClinched = true;
mapStatus = mapStates.MAPVIEW;
genEdges = true;
}