<!-- /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: "irl.m001", tier: 1, color: "TMblue", system: "irlm", label: "IRL M1" };
routeInfo[1] = { firstWaypoint: 28, root: "irl.m002", tier: 1, color: "TMblue", system: "irlm", label: "IRL M2" };
routeInfo[2] = { firstWaypoint: 34, root: "irl.m003", tier: 1, color: "TMblue", system: "irlm", label: "IRL M3" };
routeInfo[3] = { firstWaypoint: 48, root: "irl.m004", tier: 1, color: "TMblue", system: "irlm", label: "IRL M4" };
routeInfo[4] = { firstWaypoint: 64, root: "irl.m006", tier: 1, color: "TMblue", system: "irlm", label: "IRL M6" };
routeInfo[5] = { firstWaypoint: 77, root: "irl.m006bal", tier: 1, color: "TMblue", system: "irlm", label: "IRL M6Bal" };
routeInfo[6] = { firstWaypoint: 91, root: "irl.m007", tier: 1, color: "TMblue", system: "irlm", label: "IRL M7" };
routeInfo[7] = { firstWaypoint: 135, root: "irl.m008", tier: 1, color: "TMblue", system: "irlm", label: "IRL M8" };
routeInfo[8] = { firstWaypoint: 169, root: "irl.m009", tier: 1, color: "TMblue", system: "irlm", label: "IRL M9" };
routeInfo[9] = { firstWaypoint: 202, root: "irl.m011", tier: 1, color: "TMblue", system: "irlm", label: "IRL M11" };
routeInfo[10] = { firstWaypoint: 206, root: "irl.m011gor", tier: 1, color: "TMblue", system: "irlm", label: "IRL M11Gor" };
routeInfo[11] = { firstWaypoint: 232, root: "irl.m017", tier: 1, color: "TMblue", system: "irlm", label: "IRL M17" };
routeInfo[12] = { firstWaypoint: 238, root: "irl.m018", tier: 1, color: "TMblue", system: "irlm", label: "IRL M18" };
routeInfo[13] = { firstWaypoint: 255, root: "irl.m020", tier: 1, color: "TMblue", system: "irlm", label: "IRL M20" };
routeInfo[14] = { firstWaypoint: 260, root: "irl.m050", tier: 1, color: "TMblue", system: "irlm", label: "IRL M50" };
waypoints = [
new Waypoint("1",53.410517,-6.226587),
new Waypoint("2",53.427333,-6.21736),
new Waypoint("3",53.442935,-6.206095),
new Waypoint("4",53.477958,-6.205301),
new Waypoint("+X01",53.510484,-6.204142),
new Waypoint("5",53.56356,-6.213756),
new Waypoint("+X03",53.586621,-6.211867),
new Waypoint("6",53.598668,-6.220708),
new Waypoint("+X04",53.617256,-6.244011),
new Waypoint("7",53.638761,-6.254954),
new Waypoint("+X05",53.668545,-6.343746),
new Waypoint("8",53.692908,-6.371684),
new Waypoint("9",53.702055,-6.383422),
new Waypoint("+X06",53.710323,-6.39473),
new Waypoint("10",53.728277,-6.396618),
new Waypoint("+X07",53.756323,-6.414642),
new Waypoint("11",53.775107,-6.405866),
new Waypoint("12",53.820802,-6.403388),
new Waypoint("13",53.838336,-6.415887),
new Waypoint("14",53.858969,-6.428107),
new Waypoint("+X08",53.8835,-6.429749),
new Waypoint("15",53.901633,-6.420844),
new Waypoint("+X09",53.927188,-6.413011),
new Waypoint("16",53.970678,-6.423826),
new Waypoint("+X10",54.004415,-6.445369),
new Waypoint("17",54.018486,-6.442924),
new Waypoint("+X11",54.033334,-6.42653),
new Waypoint("18",54.03634,-6.385642),
new Waypoint("2",53.432958,-6.345978),
new Waypoint("+X10",53.469759,-6.363659),
new Waypoint("3",53.488556,-6.387606),
new Waypoint("+X11",53.493867,-6.413097),
new Waypoint("+X12",53.511301,-6.420994),
new Waypoint("N2",53.526546,-6.416166),
new Waypoint("4",53.408918,-6.427774),
new Waypoint("4a",53.413081,-6.444319),
new Waypoint("5",53.436653,-6.468222),
new Waypoint("+X556578",53.453765,-6.482577),
new Waypoint("6",53.508176,-6.560569),
new Waypoint("+X1",53.558294,-6.556557),
new Waypoint("+X2",53.596473,-6.590386),
new Waypoint("7",53.599085,-6.612112),
new Waypoint("8",53.617725,-6.678791),
new Waypoint("+X21",53.618668,-6.701059),
new Waypoint("9",53.639505,-6.74034),
new Waypoint("+X3",53.667979,-6.763872),
new Waypoint("10",53.7086,-6.85664),
new Waypoint("11",53.717184,-6.895035),
new Waypoint("5",53.358415,-6.474649),
new Waypoint("6",53.359824,-6.532596),
new Waypoint("7",53.36709,-6.591261),
new Waypoint("+X05",53.383533,-6.660976),
new Waypoint("8",53.402074,-6.689879),
new Waypoint("+X06",53.412102,-6.756323),
new Waypoint("+X07",53.404338,-6.811266),
new Waypoint("9",53.409091,-6.846306),
new Waypoint("+X09",53.412742,-6.897955),
new Waypoint("+X10",53.425415,-6.923521),
new Waypoint("+X11",53.425492,-6.978722),
new Waypoint("+X12",53.44142,-7.02404),
new Waypoint("10",53.449011,-7.093391),
new Waypoint("11",53.450066,-7.10265),
new Waypoint("12",53.454097,-7.117896),
new Waypoint("13",53.491365,-7.201924),
new Waypoint("1",53.450066,-7.10265),
new Waypoint("2",53.449108,-7.123282),
new Waypoint("+X01",53.446507,-7.194929),
new Waypoint("3",53.405087,-7.284129),
new Waypoint("4",53.387891,-7.362132),
new Waypoint("+X02",53.361789,-7.414237),
new Waypoint("5",53.358402,-7.495251),
new Waypoint("+X03",53.393457,-7.625767),
new Waypoint("6",53.386835,-7.68308),
new Waypoint("7",53.393201,-7.782354),
new Waypoint("AthSer",53.399496,-7.830269),
new Waypoint("+X04",53.402842,-7.870797),
new Waypoint("8",53.415255,-7.88886),
new Waypoint("13",53.420269,-7.981353),
new Waypoint("+X05",53.400065,-8.045704),
new Waypoint("+X06",53.349283,-8.071341),
new Waypoint("14",53.313513,-8.178221),
new Waypoint("15",53.315525,-8.244531),
new Waypoint("+X07",53.300761,-8.341402),
new Waypoint("+X08",53.281919,-8.415699),
new Waypoint("+X09",53.283562,-8.497754),
new Waypoint("16",53.265187,-8.609076),
new Waypoint("+X10",53.276608,-8.721085),
new Waypoint("17",53.287269,-8.760782),
new Waypoint("18",53.297293,-8.807248),
new Waypoint("+X12",53.299954,-8.872404),
new Waypoint("19",53.29526,-8.923903),
new Waypoint("9",53.235017,-6.635957),
new Waypoint("+X04",53.2419,-6.656041),
new Waypoint("9a",53.234618,-6.683593),
new Waypoint("10",53.20841,-6.712861),
new Waypoint("11",53.170997,-6.75347),
new Waypoint("+X06",53.160282,-6.788907),
new Waypoint("12",53.162147,-6.823948),
new Waypoint("13",53.152027,-6.919155),
new Waypoint("+X07",53.154671,-6.950655),
new Waypoint("14",53.14594,-7.014685),
new Waypoint("+X08",53.137928,-7.033031),
new Waypoint("+X09",53.115975,-7.049704),
new Waypoint("+X10",53.111918,-7.107876),
new Waypoint("15",53.088766,-7.172806),
new Waypoint("16",53.050069,-7.239432),
new Waypoint("+X11",53.016871,-7.269049),
new Waypoint("17",53.013325,-7.303237),
new Waypoint("18",53.019933,-7.34311),
new Waypoint("+X12",52.990373,-7.429123),
new Waypoint("+X13",52.943789,-7.448881),
new Waypoint("19",52.91974,-7.48446),
new Waypoint("+X15",52.911529,-7.515851),
new Waypoint("+X16",52.92686,-7.593956),
new Waypoint("21",52.923626,-7.629507),
new Waypoint("+X17",52.914789,-7.70622),
new Waypoint("+X18",52.926381,-7.755359),
new Waypoint("22",52.921715,-7.794116),
new Waypoint("+X19",52.904755,-7.893506),
new Waypoint("+X20",52.88852,-7.91518),
new Waypoint("23",52.886326,-7.944681),
new Waypoint("+X21",52.880837,-8.003883),
new Waypoint("24",52.859783,-8.11962),
new Waypoint("25",52.849334,-8.160525),
new Waypoint("26",52.845199,-8.248308),
new Waypoint("+X22",52.837727,-8.284099),
new Waypoint("+X23",52.798137,-8.324396),
new Waypoint("+X24",52.784285,-8.367634),
new Waypoint("27",52.75675,-8.409149),
new Waypoint("+X25",52.729002,-8.460954),
new Waypoint("28",52.673552,-8.515563),
new Waypoint("+X26",52.663891,-8.518438),
new Waypoint("29",52.647126,-8.563671),
new Waypoint("+X27",52.638409,-8.593884),
new Waypoint("30",52.641189,-8.621929),
new Waypoint("1",52.91974,-7.48446),
new Waypoint("+X01",52.886328,-7.493191),
new Waypoint("3",52.86661,-7.484757),
new Waypoint("+X02",52.840155,-7.500899),
new Waypoint("+X03",52.813086,-7.493491),
new Waypoint("+X04",52.753984,-7.572906),
new Waypoint("4",52.730172,-7.584536),
new Waypoint("5",52.665088,-7.706684),
new Waypoint("+X05",52.6559,-7.739052),
new Waypoint("6",52.623157,-7.774297),
new Waypoint("7",52.543007,-7.864837),
new Waypoint("+X06",52.524512,-7.858444),
new Waypoint("8",52.508686,-7.871221),
new Waypoint("9",52.498746,-7.887605),
new Waypoint("+X07",52.478337,-7.906723),
new Waypoint("10",52.399722,-7.915972),
new Waypoint("11",52.354865,-8.001309),
new Waypoint("+X08",52.332888,-8.034933),
new Waypoint("+X09",52.31084,-8.146728),
new Waypoint("12",52.284542,-8.217408),
new Waypoint("13",52.238287,-8.279786),
new Waypoint("+X10",52.228798,-8.287167),
new Waypoint("14",52.162297,-8.266021),
new Waypoint("+X699495",52.132474,-8.259573),
new Waypoint("15",52.114728,-8.272887),
new Waypoint("+X11",52.074969,-8.301802),
new Waypoint("16",52.054338,-8.305943),
new Waypoint("17A",52.014176,-8.337325),
new Waypoint("17",52.007248,-8.341863),
new Waypoint("18",51.955599,-8.389177),
new Waypoint("+X12",51.944053,-8.392782),
new Waypoint("+X13",51.931228,-8.37434),
new Waypoint("+WoodLn",51.907916,-8.384403),
new Waypoint("19",51.90442,-8.387739),
new Waypoint("1",53.170997,-6.75347),
new Waypoint("+X01",53.153565,-6.751442),
new Waypoint("+X02",53.136525,-6.766291),
new Waypoint("2",53.121223,-6.755541),
new Waypoint("KilSer",53.089939,-6.753502),
new Waypoint("+X04",53.073326,-6.756886),
new Waypoint("3",52.998527,-6.842658),
new Waypoint("+X05",52.984933,-6.852437),
new Waypoint("+X06",52.944707,-6.853237),
new Waypoint("+X07",52.926446,-6.866283),
new Waypoint("4",52.892057,-6.857336),
new Waypoint("+X08",52.865593,-6.836886),
new Waypoint("+X09",52.807703,-6.855426),
new Waypoint("5",52.801425,-6.881207),
new Waypoint("+X10",52.79281,-6.891539),
new Waypoint("+X11",52.785225,-6.93085),
new Waypoint("6",52.770007,-6.953219),
new Waypoint("+X12",52.758581,-6.985073),
new Waypoint("7",52.680623,-7.039275),
new Waypoint("+X13",52.641992,-7.112215),
new Waypoint("8",52.633805,-7.146349),
new Waypoint("+X14",52.605445,-7.166745),
new Waypoint("+X15",52.594634,-7.198727),
new Waypoint("9",52.572868,-7.232298),
new Waypoint("+X16",52.552768,-7.247715),
new Waypoint("10",52.485942,-7.240677),
new Waypoint("+X17",52.436051,-7.233725),
new Waypoint("+X18",52.41153,-7.214069),
new Waypoint("+X19",52.393149,-7.172785),
new Waypoint("11",52.373634,-7.166948),
new Waypoint("+X20",52.345276,-7.16579),
new Waypoint("+X21",52.311181,-7.140877),
new Waypoint("12",52.284411,-7.153902),
new Waypoint("DubRd",53.241399,-6.129212),
new Waypoint("4",53.231651,-6.132345),
new Waypoint("5",53.212998,-6.124706),
new Waypoint("6",53.196284,-6.133606),
new Waypoint("14",53.042645,-6.087982),
new Waypoint("15",53.027158,-6.093786),
new Waypoint("+X03",53.014861,-6.100073),
new Waypoint("16",53.001291,-6.091232),
new Waypoint("17",52.977557,-6.094365),
new Waypoint("18",52.953654,-6.09738),
new Waypoint("+X722585",52.934828,-6.123419),
new Waypoint("+X514324",52.904166,-6.102648),
new Waypoint("19",52.882754,-6.100802),
new Waypoint("+X792708",52.855074,-6.105287),
new Waypoint("20",52.821399,-6.144962),
new Waypoint("+X06",52.799778,-6.182642),
new Waypoint("+X07",52.781131,-6.175861),
new Waypoint("21",52.773213,-6.182846),
new Waypoint("GorSer",52.747606,-6.205773),
new Waypoint("+X09",52.736967,-6.232295),
new Waypoint("22",52.711495,-6.256059),
new Waypoint("+X11",52.667528,-6.263248),
new Waypoint("23",52.663266,-6.273473),
new Waypoint("24",52.632776,-6.362672),
new Waypoint("+X348914",52.581696,-6.417217),
new Waypoint("+X647488",52.538283,-6.505537),
new Waypoint("25",52.521437,-6.512876),
new Waypoint("+X935777",52.511278,-6.508155),
new Waypoint("+X275811",52.502697,-6.522338),
new Waypoint("26",52.443782,-6.541618),
new Waypoint("18",53.297293,-8.807248),
new Waypoint("+X931185",53.344044,-8.80168),
new Waypoint("+X538442",53.363204,-8.787775),
new Waypoint("19",53.403098,-8.817995),
new Waypoint("+X620643",53.467563,-8.860989),
new Waypoint("20",53.507221,-8.878761),
new Waypoint("9",52.726065,-8.874936),
new Waypoint("10",52.752292,-8.903416),
new Waypoint("+X01",52.761003,-8.916982),
new Waypoint("11",52.789073,-8.921027),
new Waypoint("12",52.827409,-8.938322),
new Waypoint("13",52.859382,-8.937142),
new Waypoint("14",52.886172,-8.943944),
new Waypoint("15",52.938573,-8.905519),
new Waypoint("+X02",52.970521,-8.889227),
new Waypoint("16",53.073432,-8.826745),
new Waypoint("+X660641",53.12741,-8.824425),
new Waypoint("+X990487",53.157323,-8.855238),
new Waypoint("17",53.176978,-8.83687),
new Waypoint("+X230229",53.204079,-8.827257),
new Waypoint("+X234546",53.244673,-8.834295),
new Waypoint("+X976391",53.277429,-8.801765),
new Waypoint("18",53.297293,-8.807248),
new Waypoint("1",52.641189,-8.621929),
new Waypoint("2",52.630068,-8.633934),
new Waypoint("3",52.612527,-8.659072),
new Waypoint("4",52.598975,-8.702331),
new Waypoint("5",52.58579,-8.720999),
new Waypoint("1",53.354541,-6.223412),
new Waypoint("+X01",53.37456,-6.243646),
new Waypoint("2",53.394551,-6.24047),
new Waypoint("+X514269",53.39589,-6.239702),
new Waypoint("2a",53.397315,-6.238636),
new Waypoint("3",53.410517,-6.226587),
new Waypoint("4",53.409097,-6.265941),
new Waypoint("5",53.404364,-6.311431),
new Waypoint("6",53.38256,-6.363015),
new Waypoint("7",53.356648,-6.384301),
new Waypoint("+X02",53.33933,-6.387348),
new Waypoint("9",53.318313,-6.368122),
new Waypoint("10",53.30732,-6.356718),
new Waypoint("11",53.290848,-6.331),
new Waypoint("12",53.277952,-6.322595),
new Waypoint("+X03",53.266933,-6.282935),
new Waypoint("13",53.270988,-6.243067),
new Waypoint("+X236097",53.27179,-6.230921),
new Waypoint("13A",53.271816,-6.219625),
new Waypoint("14",53.27086,-6.21367),
new Waypoint("15",53.253628,-6.177696),
new Waypoint("16",53.241232,-6.152515),
new Waypoint("17",53.231651,-6.132345)
];
traveler = 'michih';
segments = [
351313,
351314,
351315,
351316,
351317,
351318,
351319,
351320,
351321,
351322,
351323,
351324,
351325,
351326,
351327,
351328,
351329,
351330,
351331,
351332,
351333,
351334,
351335,
351336,
351337,
351338,
351339,
351340,
351341,
351342,
351343,
351344,
351345,
351346,
351347,
351348,
351349,
351350,
351351,
351352,
351353,
351354,
351355,
351356,
351357,
351358,
351359,
351360,
351361,
351362,
351363,
351364,
351365,
351366,
351367,
351368,
351369,
351370,
351371,
351372,
351373,
351374,
351375,
351376,
351377,
351378,
351379,
351380,
351381,
351382,
351383,
351384,
351385,
351386,
351387,
351388,
351389,
351390,
351391,
351392,
351393,
351394,
351395,
351396,
351397,
351398,
351399,
351400,
351401,
351402,
351403,
351404,
351405,
351406,
351407,
351408,
351409,
351410,
351411,
351412,
351413,
351414,
351415,
351416,
351417,
351418,
351419,
351420,
351421,
351422,
351423,
351424,
351425,
351426,
351427,
351428,
351429,
351430,
351431,
351432,
351433,
351434,
351435,
351436,
351437,
351438,
351439,
351440,
351441,
351442,
351443,
351444,
351445,
351446,
351447,
351448,
351449,
351450,
351451,
351452,
351453,
351454,
351455,
351456,
351457,
351458,
351459,
351460,
351461,
351462,
351463,
351464,
351465,
351466,
351467,
351468,
351469,
351470,
351471,
351472,
351473,
351474,
351475,
351476,
351477,
351478,
351479,
351480,
351481,
351482,
351483,
351484,
351485,
351486,
351487,
351488,
351489,
351490,
351491,
351492,
351493,
351494,
351495,
351496,
351497,
351498,
351499,
351500,
351501,
351502,
351503,
351504,
351505,
351506,
351507,
351508,
351509,
351510,
351511,
351512,
351513,
351514,
351515,
351516,
351517,
351518,
351519,
351520,
351521,
351522,
351523,
351524,
351525,
351526,
351527,
351528,
351529,
351530,
351531,
351532,
351533,
351534,
351535,
351536,
351537,
351538,
351539,
351540,
351541,
351542,
351543,
351544,
351545,
351546,
351547,
351548,
351549,
351550,
351551,
351552,
351553,
351554,
351555,
351556,
351557,
351558,
351559,
351560,
351561,
351562,
351563,
351564,
351565,
351566,
351567,
351568,
351569,
351570,
351571,
351572,
351573,
351574,
351575,
351576,
351577,
351578,
351579,
351580
];
clinched = [
351313,
351314,
351315,
351316,
351317,
351318,
351319,
351320,
351321,
351322,
351323,
351324,
351325,
351326,
351327,
351328,
351329,
351330,
351331,
351332,
351333,
351334,
351335,
351336,
351337,
351338,
351339,
351340,
351341,
351342,
351343,
351344,
351345,
351346,
351347,
351348,
351349,
351350,
351351,
351352,
351353,
351354,
351355,
351356,
351357,
351358,
351359,
351360,
351361,
351362,
351363,
351364,
351365,
351366,
351367,
351368,
351369,
351370,
351371,
351372,
351373,
351374,
351375,
351376,
351377,
351378,
351379,
351380,
351381,
351382,
351383,
351384,
351385,
351386,
351387,
351388,
351389,
351390,
351391,
351392,
351393,
351394,
351395,
351396,
351397,
351398,
351399,
351400,
351401,
351402,
351403,
351404,
351405,
351406,
351407,
351408,
351409,
351410,
351411,
351412,
351413,
351414,
351415,
351416,
351417,
351418,
351419,
351420,
351421,
351422,
351423,
351424,
351425,
351426,
351427,
351428,
351429,
351430,
351431,
351432,
351433,
351434,
351435,
351436,
351437,
351438,
351439,
351440,
351441,
351442,
351443,
351444,
351445,
351446,
351447,
351448,
351449,
351450,
351451,
351452,
351453,
351454,
351455,
351456,
351457,
351458,
351459,
351460,
351461,
351462,
351463,
351464,
351465,
351466,
351467,
351468,
351469,
351470,
351471,
351472,
351473,
351474,
351475,
351476,
351477,
351478,
351479,
351480,
351481,
351482,
351483,
351484,
351485,
351486,
351487,
351488,
351489,
351490,
351491,
351492,
351493,
351494,
351495,
351496,
351497,
351498,
351499,
351500,
351501,
351502,
351503,
351504,
351505,
351506,
351507,
351508,
351509,
351510,
351511,
351512,
351513,
351514,
351515,
351516,
351517,
351518,
351519,
351520,
351521,
351522,
351523,
351524,
351525,
351526,
351527,
351534,
351535,
351536,
351537,
351538,
351539,
351540,
351541,
351542,
351543,
351544,
351545,
351546,
351547,
351548,
351549,
351550,
351551,
351552,
351553,
351554,
351555,
351556,
351557,
351558,
351559,
351560,
351561,
351562,
351563,
351564,
351565,
351566,
351567,
351568,
351569,
351570,
351571,
351572,
351573,
351574,
351575,
351576,
351577,
351578,
351579,
351580
];
mapClinched = true;
mapStatus = mapStates.MAPVIEW;
genEdges = true;
}