<!-- /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: "svk.r001", tier: 2, color: "TMteal", system: "svkr", label: "SVK R1" };
routeInfo[1] = { firstWaypoint: 64, root: "svk.r001a", tier: 2, color: "TMteal", system: "svkr", label: "SVK R1A" };
routeInfo[2] = { firstWaypoint: 69, root: "svk.r002", tier: 2, color: "TMteal", system: "svkr", label: "SVK R2" };
routeInfo[3] = { firstWaypoint: 75, root: "svk.r002ban", tier: 2, color: "TMteal", system: "svkr", label: "SVK R2Ban" };
routeInfo[4] = { firstWaypoint: 79, root: "svk.r002det", tier: 2, color: "TMteal", system: "svkr", label: "SVK R2Det" };
routeInfo[5] = { firstWaypoint: 84, root: "svk.r002myt", tier: 2, color: "TMteal", system: "svkr", label: "SVK R2Myt" };
routeInfo[6] = { firstWaypoint: 89, root: "svk.r002ozd", tier: 2, color: "TMteal", system: "svkr", label: "SVK R2Ozd" };
routeInfo[7] = { firstWaypoint: 92, root: "svk.r002zvo", tier: 2, color: "TMteal", system: "svkr", label: "SVK R2Zvo" };
routeInfo[8] = { firstWaypoint: 103, root: "svk.r003", tier: 2, color: "TMteal", system: "svkr", label: "SVK R3" };
routeInfo[9] = { firstWaypoint: 105, root: "svk.r003hor", tier: 2, color: "TMteal", system: "svkr", label: "SVK R3Hor" };
routeInfo[10] = { firstWaypoint: 107, root: "svk.r003trs", tier: 2, color: "TMteal", system: "svkr", label: "SVK R3Trs" };
routeInfo[11] = { firstWaypoint: 111, root: "svk.r003vru", tier: 2, color: "TMteal", system: "svkr", label: "SVK R3Vru" };
routeInfo[12] = { firstWaypoint: 113, root: "svk.r004", tier: 2, color: "TMteal", system: "svkr", label: "SVK R4" };
routeInfo[13] = { firstWaypoint: 116, root: "svk.r004kec", tier: 2, color: "TMteal", system: "svkr", label: "SVK R4Kec" };
routeInfo[14] = { firstWaypoint: 121, root: "svk.r004kos", tier: 2, color: "TMteal", system: "svkr", label: "SVK R4Kos" };
routeInfo[15] = { firstWaypoint: 123, root: "svk.r004pre", tier: 2, color: "TMteal", system: "svkr", label: "SVK R4Pre" };
routeInfo[16] = { firstWaypoint: 125, root: "svk.r006", tier: 2, color: "TMteal", system: "svkr", label: "SVK R6" };
routeInfo[17] = { firstWaypoint: 128, root: "svk.r007", tier: 2, color: "TMteal", system: "svkr", label: "SVK R7" };
waypoints = [
new Waypoint("1",48.358388,17.605076),
new Waypoint("2",48.348948,17.620268),
new Waypoint("3",48.337381,17.630224),
new Waypoint("6",48.31459,17.645524),
new Waypoint("8",48.300892,17.659267),
new Waypoint("12",48.28546,17.703856),
new Waypoint("14",48.270976,17.719402),
new Waypoint("16",48.25867,17.744937),
new Waypoint("+X1",48.256398,17.774334),
new Waypoint("21",48.266777,17.799525),
new Waypoint("23",48.26532,17.819803),
new Waypoint("27",48.2906,17.877148),
new Waypoint("29",48.297773,17.897855),
new Waypoint("+X2",48.326412,17.951917),
new Waypoint("39",48.31494,18.011141),
new Waypoint("+X258216",48.299183,18.023071),
new Waypoint("45",48.285649,18.065858),
new Waypoint("+X902616",48.296556,18.117871),
new Waypoint("51",48.308803,18.141003),
new Waypoint("+X219421",48.316994,18.187609),
new Waypoint("+X115921",48.339222,18.235545),
new Waypoint("62",48.333544,18.269663),
new Waypoint("+X158064",48.330948,18.308501),
new Waypoint("70",48.35103,18.375835),
new Waypoint("+X738109",48.341047,18.410382),
new Waypoint("+X273882",48.353882,18.450208),
new Waypoint("80",48.356163,18.49381),
new Waypoint("+X513584",48.371674,18.509645),
new Waypoint("+I65_W",48.371167,18.536183),
new Waypoint("87",48.362316,18.577151),
new Waypoint("+X100",48.376264,18.608093),
new Waypoint("+X102",48.403067,18.622727),
new Waypoint("95",48.409641,18.648005),
new Waypoint("+X103",48.442099,18.696842),
new Waypoint("+X104",48.463958,18.691864),
new Waypoint("105",48.474038,18.713171),
new Waypoint("+X105",48.476236,18.727698),
new Waypoint("109",48.503576,18.731582),
new Waypoint("110",48.51143,18.732462),
new Waypoint("+X106",48.53363,18.740745),
new Waypoint("119",48.54974,18.816276),
new Waypoint("+X108",48.572518,18.824988),
new Waypoint("R2_N",48.57709,18.836446),
new Waypoint("128",48.588382,18.896227),
new Waypoint("+X200",48.580724,18.980684),
new Waypoint("137",48.564077,19.009802),
new Waypoint("137A",48.563321,19.016476),
new Waypoint("140",48.56554,19.04171),
new Waypoint("141",48.568521,19.063554),
new Waypoint("142",48.568926,19.073167),
new Waypoint("144",48.585288,19.09087),
new Waypoint("146",48.598508,19.108572),
new Waypoint("148",48.606078,19.121017),
new Waypoint("148A",48.608174,19.121232),
new Waypoint("151",48.629122,19.118958),
new Waypoint("157",48.700549,19.134321),
new Waypoint("160",48.716535,19.13784),
new Waypoint("162",48.730117,19.13784),
new Waypoint("163",48.739621,19.1343),
new Waypoint("164",48.749681,19.139557),
new Waypoint("165",48.74671,19.15535),
new Waypoint("166",48.743116,19.163804),
new Waypoint("168",48.740017,19.186249),
new Waypoint("169",48.742069,19.197214),
new Waypoint("0",48.31494,18.011141),
new Waypoint("2",48.319021,18.040195),
new Waypoint("3",48.321389,18.048949),
new Waypoint("4",48.326383,18.063498),
new Waypoint("5",48.328951,18.080449),
new Waypoint("I16_Fig",48.396029,20.234413),
new Waypoint("+X450493",48.400446,20.249991),
new Waypoint("219",48.397375,20.264947),
new Waypoint("223",48.40088,20.319257),
new Waypoint("+X301",48.406771,20.334663),
new Waypoint("230",48.449464,20.346401),
new Waypoint("26",48.744842,18.220053),
new Waypoint("+X363945",48.70399,18.239021),
new Waypoint("+X243741",48.696059,18.264256),
new Waypoint("I9_E",48.697901,18.290434),
new Waypoint("110",48.574534,19.240837),
new Waypoint("+X895923",48.568827,19.302163),
new Waypoint("117",48.54599,19.328728),
new Waypoint("123",48.537863,19.400396),
new Waypoint("127",48.533203,19.453611),
new Waypoint("I16_Myt",48.47487,19.529099),
new Waypoint("+X868098",48.473469,19.535215),
new Waypoint("138",48.464467,19.546759),
new Waypoint("+X330406",48.459938,19.563046),
new Waypoint("I16_Tom",48.383768,19.632032),
new Waypoint("I16_W",48.375427,19.873517),
new Waypoint("+X101",48.374054,19.910789),
new Waypoint("I16_E",48.387013,19.932986),
new Waypoint("I9",48.620314,18.801212),
new Waypoint("98",48.57709,18.836446),
new Waypoint("128(R1)",48.588382,18.896227),
new Waypoint("+X200",48.580724,18.980684),
new Waypoint("137(R1)",48.564077,19.009802),
new Waypoint("137A(R1)",48.563321,19.016476),
new Waypoint("140(R1)",48.56554,19.04171),
new Waypoint("141(R1)",48.568521,19.063554),
new Waypoint("142(R1)",48.568926,19.073167),
new Waypoint("+X220",48.557949,19.088874),
new Waypoint("I16/I66",48.563005,19.104409),
new Waypoint("I59_N",49.263499,19.41031),
new Waypoint("I59_S",49.250573,19.339435),
new Waypoint("I65_N",48.832153,18.874984),
new Waypoint("I65_S",48.792645,18.87876),
new Waypoint("I59_N",49.378559,19.631109),
new Waypoint("6",49.362547,19.633813),
new Waypoint("+X1",49.344194,19.577594),
new Waypoint("I59_S",49.343761,19.568238),
new Waypoint("I18",49.094722,18.949656),
new Waypoint("D1",49.108574,18.957424),
new Waypoint("16",49.289978,21.586933),
new Waypoint("+X100",49.316925,21.581654),
new Waypoint("21",49.326101,21.591053),
new Waypoint("124",48.644252,21.268759),
new Waypoint("+X569409",48.618499,21.241121),
new Waypoint("+X625666",48.58274,21.247902),
new Waypoint("135",48.548547,21.231937),
new Waypoint("SVK/HUN",48.531953,21.252322),
new Waypoint("29",48.732148,21.330729),
new Waypoint("30",48.743201,21.337938),
new Waypoint("63",48.996269,21.202605),
new Waypoint("67",49.035603,21.213226),
new Waypoint("D1",49.063304,18.340934),
new Waypoint("I61",49.069325,18.339186),
new Waypoint("I49",49.082004,18.328929),
new Waypoint("0",48.141843,17.15204),
new Waypoint("1",48.135542,17.155066),
new Waypoint("6",48.090249,17.185847),
new Waypoint("+X986626",48.083498,17.226305),
new Waypoint("14",48.062206,17.281795),
new Waypoint("19",48.042025,17.339602),
new Waypoint("32",48.000691,17.488346)
];
traveler = 'michih';
segments = [
453389,
453390,
453391,
453392,
453393,
453394,
453395,
453396,
453397,
453398,
453399,
453400,
453401,
453402,
453403,
453404,
453405,
453406,
453407,
453408,
453409,
453410,
453411,
453412,
453413,
453414,
453415,
453416,
453417,
453418,
453419,
453420,
453421,
453422,
453423,
453424,
453425,
453426,
453427,
453428,
453429,
453430,
453431,
453432,
453433,
453434,
453435,
453436,
453437,
453438,
453439,
453440,
453441,
453442,
453443,
453444,
453445,
453446,
453447,
453448,
453449,
453450,
453451,
453452,
453453,
453454,
453455,
453479,
453480,
453481,
453482,
453483,
453456,
453457,
453458,
453469,
453470,
453471,
453472,
453473,
453474,
453475,
453476,
453477,
453478,
453459,
453460,
453461,
453462,
453463,
453464,
453465,
453466,
453467,
453468,
453487,
453489,
453484,
453485,
453486,
453488,
453490,
453491,
453494,
453495,
453496,
453497,
453492,
453493,
453498,
453499,
453500,
453501,
453502,
453503,
453504,
453505
];
clinched = [
453389,
453390,
453391,
453392,
453393,
453394,
453395,
453396,
453397,
453398,
453399,
453400,
453401,
453402,
453403,
453404,
453405,
453406,
453407,
453408,
453409,
453410,
453411,
453412,
453413,
453414,
453415,
453416,
453417,
453418,
453419,
453420,
453421,
453422,
453423,
453424,
453425,
453426,
453427,
453428,
453429,
453430,
453431,
453436,
453437,
453438,
453439,
453440,
453441,
453442,
453443,
453444,
453445,
453446,
453447,
453460,
453465,
453466,
453467,
453468,
453489,
453488,
453490,
453491,
453494,
453495,
453496,
453497,
453492,
453493,
453498,
453499,
453502,
453503,
453504,
453505
];
mapClinched = true;
mapStatus = mapStates.MAPVIEW;
genEdges = true;
}