<!-- /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: "nzl.aucnmot", tier: 1, color: "TMblue", system: "nzlmot", label: "NZL AucNMot" };
routeInfo[1] = { firstWaypoint: 25, root: "nzl.aucnwmot", tier: 1, color: "TMblue", system: "nzlmot", label: "NZL AucNWMot" };
routeInfo[2] = { firstWaypoint: 41, root: "nzl.aucsmot", tier: 1, color: "TMblue", system: "nzlmot", label: "NZL AucSMot" };
routeInfo[3] = { firstWaypoint: 68, root: "nzl.aucswmot", tier: 1, color: "TMblue", system: "nzlmot", label: "NZL AucSWMot" };
routeInfo[4] = { firstWaypoint: 84, root: "nzl.chrlytmot", tier: 1, color: "TMblue", system: "nzlmot", label: "NZL ChrLytMot" };
routeInfo[5] = { firstWaypoint: 88, root: "nzl.chrnmot", tier: 1, color: "TMblue", system: "nzlmot", label: "NZL ChrNMot" };
routeInfo[6] = { firstWaypoint: 98, root: "nzl.chrsmot", tier: 1, color: "TMblue", system: "nzlmot", label: "NZL ChrSMot" };
routeInfo[7] = { firstWaypoint: 104, root: "nzl.dunsmot", tier: 1, color: "TMblue", system: "nzlmot", label: "NZL DunSMot" };
routeInfo[8] = { firstWaypoint: 110, root: "nzl.johpormot", tier: 1, color: "TMblue", system: "nzlmot", label: "NZL JohPorMot" };
routeInfo[9] = { firstWaypoint: 118, root: "nzl.tauelinkmot", tier: 1, color: "TMblue", system: "nzlmot", label: "NZL TauELinkMot" };
routeInfo[10] = { firstWaypoint: 121, root: "nzl.tragulmot", tier: 1, color: "TMblue", system: "nzlmot", label: "NZL TraGulMot" };
routeInfo[11] = { firstWaypoint: 130, root: "nzl.uppharmot", tier: 1, color: "TMblue", system: "nzlmot", label: "NZL UppHarMot" };
routeInfo[12] = { firstWaypoint: 140, root: "nzl.wbelbyp", tier: 1, color: "TMblue", system: "nzlmot", label: "NZL WBelByp" };
routeInfo[13] = { firstWaypoint: 143, root: "nzl.welurbmot", tier: 1, color: "TMblue", system: "nzlmot", label: "NZL WelUrbMot" };
waypoints = [
new Waypoint("SH1_N",-36.388599,174.642663),
new Waypoint("+X148666",-36.410058,174.630132),
new Waypoint("+X681825",-36.469941,174.634595),
new Waypoint("386",-36.516371,174.668938),
new Waypoint("388",-36.533502,174.67927),
new Waypoint("+X960192",-36.558739,174.680858),
new Waypoint("394",-36.587483,174.664421),
new Waypoint("396",-36.603608,174.662018),
new Waypoint("398",-36.625241,174.66279),
new Waypoint("+X524734",-36.654786,174.664507),
new Waypoint("+X144615",-36.686041,174.701328),
new Waypoint("410",-36.718488,174.712615),
new Waypoint("412",-36.734722,174.717422),
new Waypoint("413",-36.747348,174.723322),
new Waypoint("414",-36.750783,174.726048),
new Waypoint("417",-36.771858,174.742742),
new Waypoint("419",-36.788219,174.752784),
new Waypoint("420",-36.79932,174.761281),
new Waypoint("421",-36.812755,174.752955),
new Waypoint("422",-36.82021,174.749823),
new Waypoint("423",-36.837351,174.741476),
new Waypoint("424A",-36.844839,174.752119),
new Waypoint("424B",-36.851243,174.754265),
new Waypoint("427A",-36.855102,174.756694),
new Waypoint("427",-36.859965,174.756984),
new Waypoint("1",-36.854523,174.770819),
new Waypoint("2A",-36.855407,174.769585),
new Waypoint("2",-36.861193,174.763716),
new Waypoint("3",-36.859965,174.756984),
new Waypoint("5",-36.862034,174.754211),
new Waypoint("6",-36.868755,174.725876),
new Waypoint("8A",-36.872205,174.705126),
new Waypoint("8B",-36.872411,174.703903),
new Waypoint("11",-36.87006,174.674141),
new Waypoint("12",-36.86539,174.666266),
new Waypoint("14",-36.857459,174.652147),
new Waypoint("16",-36.847758,174.631441),
new Waypoint("18",-36.83189,174.619403),
new Waypoint("19",-36.818596,174.614296),
new Waypoint("+X01",-36.814782,174.612923),
new Waypoint("RR23",-36.79712,174.596958),
new Waypoint("UniSt",-36.853879,174.757816),
new Waypoint("427A",-36.855102,174.756694),
new Waypoint("427",-36.859965,174.756984),
new Waypoint("428",-36.861193,174.763716),
new Waypoint("429",-36.863124,174.764811),
new Waypoint("430",-36.865382,174.767257),
new Waypoint("431",-36.872351,174.77422),
new Waypoint("431A",-36.874634,174.779391),
new Waypoint("432",-36.881749,174.786419),
new Waypoint("433",-36.88888,174.797158),
new Waypoint("434",-36.894423,174.805516),
new Waypoint("435",-36.903749,174.811749),
new Waypoint("437",-36.916892,174.834194),
new Waypoint("438",-36.918882,174.839945),
new Waypoint("441",-36.939225,174.853635),
new Waypoint("443",-36.952155,174.858999),
new Waypoint("444",-36.963952,174.867711),
new Waypoint("447",-36.985757,174.884577),
new Waypoint("449B",-36.99203,174.887753),
new Waypoint("449",-36.995835,174.889169),
new Waypoint("451",-37.01465,174.906249),
new Waypoint("453",-37.036441,174.910154),
new Waypoint("458",-37.073566,174.928865),
new Waypoint("461",-37.107662,174.946074),
new Waypoint("466",-37.14359,174.969592),
new Waypoint("+X927710",-37.168832,174.98457),
new Waypoint("471",-37.192391,174.982638),
new Waypoint("1",-36.995835,174.889169),
new Waypoint("2",-36.996315,174.875071),
new Waypoint("3",-36.997874,174.852154),
new Waypoint("+X345068",-36.995985,174.847014),
new Waypoint("3A",-36.993418,174.843357),
new Waypoint("7",-36.973244,174.816985),
new Waypoint("9",-36.962015,174.799755),
new Waypoint("10",-36.953801,174.795399),
new Waypoint("12",-36.940323,174.790807),
new Waypoint("13",-36.928557,174.782224),
new Waypoint("15",-36.921626,174.767375),
new Waypoint("16",-36.917749,174.758277),
new Waypoint("18",-36.911333,174.739652),
new Waypoint("19",-36.903578,174.72343),
new Waypoint("+X523444",-36.892836,174.705706),
new Waypoint("24",-36.872411,174.703903),
new Waypoint("FryRd",-43.553805,172.691023),
new Waypoint("SH76",-43.571141,172.693448),
new Waypoint("BriPathRd",-43.584386,172.705872),
new Waypoint("SimQuay",-43.602801,172.71703),
new Waypoint("WilSt",-43.352582,172.662849),
new Waypoint("SH71",-43.374454,172.646627),
new Waypoint("OhaRd",-43.386306,172.64122),
new Waypoint("TramRd",-43.408021,172.64464),
new Waypoint("MainNorRd_N",-43.425809,172.648172),
new Waypoint("SH1_S",-43.428489,172.647121),
new Waypoint("*MainNorRd_S",-43.434598,172.646649),
new Waypoint("BelRd",-43.454204,172.644353),
new Waypoint("SH74_S",-43.486019,172.62974),
new Waypoint("CraSt",-43.493989,172.625835),
new Waypoint("BarSt",-43.548004,172.610064),
new Waypoint("SH73/75",-43.548082,172.578521),
new Waypoint("+X594610",-43.562512,172.558844),
new Waypoint("HalJctRd",-43.563694,172.531571),
new Waypoint("ShaRd",-43.564269,172.50329),
new Waypoint("SH1",-43.565731,172.449732),
new Waypoint("KaiValRd",-45.899924,170.454866),
new Waypoint("MainSRd_E",-45.901993,170.446669),
new Waypoint("MainSRd_W",-45.902179,170.423119),
new Waypoint("OldBriRd",-45.902134,170.393636),
new Waypoint("SadHillRd",-45.901283,170.377843),
new Waypoint("SH87",-45.890158,170.356112),
new Waypoint("NewRd",-41.231832,174.809475),
new Waypoint("JohRd",-41.227846,174.808187),
new Waypoint("MooRd",-41.220422,174.809668),
new Waypoint("GreDr",-41.204457,174.820912),
new Waypoint("TakRd",-41.185526,174.832327),
new Waypoint("SH1/59",-41.155482,174.839269),
new Waypoint("TitBayRd",-41.138363,174.844923),
new Waypoint("ParSt",-41.131292,174.844322),
new Waypoint("DomRd",-37.715128,176.28366),
new Waypoint("+X771496",-37.734204,176.347218),
new Waypoint("SH33",-37.800748,176.399274),
new Waypoint("SH59_S",-41.155482,174.839269),
new Waypoint("KenLinkRd",-41.151976,174.8437),
new Waypoint("+X687714",-41.155183,174.876165),
new Waypoint("WaiLinkRd",-41.132262,174.900241),
new Waypoint("SH58",-41.112744,174.918137),
new Waypoint("+X932674",-41.081373,174.94174),
new Waypoint("+X564910",-41.014053,174.958134),
new Waypoint("ToSH59",-40.982571,174.96985),
new Waypoint("SH59_N",-40.970907,174.983003),
new Waypoint("SH1",-36.747348,174.723322),
new Waypoint("1",-36.751496,174.72137),
new Waypoint("2",-36.75735,174.703517),
new Waypoint("4",-36.77148,174.685922),
new Waypoint("6",-36.781139,174.677596),
new Waypoint("8",-36.791038,174.654851),
new Waypoint("9",-36.800282,174.63747),
new Waypoint("10",-36.809456,174.61906),
new Waypoint("+X01",-36.814782,174.612922),
new Waypoint("11",-36.818596,174.614296),
new Waypoint("ChrNMot",-43.428489,172.647121),
new Waypoint("MainNorRd",-43.434084,172.638709),
new Waypoint("GroDr",-43.450433,172.610416),
new Waypoint("HuttRd",-41.245531,174.816899),
new Waypoint("SH1_N",-41.247507,174.814163),
new Waypoint("AotQuay",-41.26559,174.785153),
new Waypoint("MurSt",-41.271985,174.777857),
new Waypoint("HawSt",-41.274799,174.774531),
new Waypoint("EveTer",-41.285216,174.77275),
new Waypoint("WilSt",-41.294599,174.771624)
];
traveler = 'jayhawkco';
segments = [
410729,
410730,
410731,
410732,
410733,
410734,
410735,
410736,
410737,
410738,
410739,
410740,
410741,
410742,
410743,
410744,
410745,
410746,
410747,
410748,
410749,
410750,
410751,
410752,
410753,
410754,
410755,
410756,
410757,
410758,
410759,
410760,
410761,
410762,
410763,
410764,
410765,
410766,
410767,
410768,
410769,
410770,
410771,
410772,
410773,
410774,
410775,
410776,
410777,
410778,
410779,
410780,
410781,
410782,
410783,
410784,
410785,
410786,
410787,
410788,
410789,
410790,
410791,
410792,
410793,
410794,
410795,
410796,
410797,
410798,
410799,
410800,
410801,
410802,
410803,
410804,
410805,
410806,
410807,
410808,
410809,
410810,
410811,
410812,
410813,
410814,
410815,
410816,
410817,
410818,
410819,
410820,
410821,
410822,
410823,
410824,
410825,
410826,
410827,
410828,
410829,
410830,
410831,
410832,
410833,
410834,
410835,
410836,
410837,
410838,
410839,
410840,
410841,
410842,
410843,
410844,
410845,
410846,
410847,
410848,
410849,
410850,
410851,
410852,
410853,
410854,
410855,
410856,
410863,
410864,
410857,
410858,
410859,
410860,
410861,
410862
];
clinched = [
410800,
410801,
410802,
410803
];
mapClinched = true;
mapStatus = mapStates.MAPVIEW;
genEdges = true;
}