<!-- /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: "mb.rt017", tier: 5, color: "TMyellow", system: "canmbw", label: "MB Rte17" };
routeInfo[1] = { firstWaypoint: 4, root: "mb.rt020", tier: 5, color: "TMyellow", system: "canmbw", label: "MB Rte20" };
routeInfo[2] = { firstWaypoint: 14, root: "mb.rt023", tier: 5, color: "TMyellow", system: "canmbw", label: "MB Rte23" };
routeInfo[3] = { firstWaypoint: 16, root: "mb.rt025", tier: 5, color: "TMyellow", system: "canmbw", label: "MB Rte25" };
routeInfo[4] = { firstWaypoint: 19, root: "mb.rt030", tier: 5, color: "TMyellow", system: "canmbw", label: "MB Rte30" };
routeInfo[5] = { firstWaypoint: 23, root: "mb.rt037", tier: 5, color: "TMyellow", system: "canmbw", label: "MB Rte37" };
routeInfo[6] = { firstWaypoint: 32, root: "mb.rt042", tier: 5, color: "TMyellow", system: "canmbw", label: "MB Rte42" };
routeInfo[7] = { firstWaypoint: 53, root: "mb.rt047", tier: 5, color: "TMyellow", system: "canmbw", label: "MB Rte47" };
routeInfo[8] = { firstWaypoint: 58, root: "mb.rt052", tier: 5, color: "TMyellow", system: "canmbw", label: "MB Rte52" };
routeInfo[9] = { firstWaypoint: 75, root: "mb.rt057", tier: 5, color: "TMyellow", system: "canmbw", label: "MB Rte57" };
routeInfo[10] = { firstWaypoint: 85, root: "mb.rt062", tier: 5, color: "TMyellow", system: "canmbw", label: "MB Rte62" };
routeInfo[11] = { firstWaypoint: 97, root: "mb.rt070", tier: 5, color: "TMyellow", system: "canmbw", label: "MB Rte70" };
routeInfo[12] = { firstWaypoint: 104, root: "mb.rt080", tier: 5, color: "TMyellow", system: "canmbw", label: "MB Rte80" };
routeInfo[13] = { firstWaypoint: 112, root: "mb.rt085", tier: 5, color: "TMyellow", system: "canmbw", label: "MB Rte85" };
routeInfo[14] = { firstWaypoint: 123, root: "mb.rt090", tier: 5, color: "TMyellow", system: "canmbw", label: "MB Rte90" };
routeInfo[15] = { firstWaypoint: 138, root: "mb.rt095", tier: 5, color: "TMyellow", system: "canmbw", label: "MB Rte95" };
routeInfo[16] = { firstWaypoint: 145, root: "mb.rt096", tier: 5, color: "TMyellow", system: "canmbw", label: "MB Rte96" };
routeInfo[17] = { firstWaypoint: 150, root: "mb.rt105", tier: 5, color: "TMyellow", system: "canmbw", label: "MB Rte105" };
routeInfo[18] = { firstWaypoint: 158, root: "mb.rt115", tier: 5, color: "TMyellow", system: "canmbw", label: "MB Rte115" };
routeInfo[19] = { firstWaypoint: 165, root: "mb.rt125", tier: 5, color: "TMyellow", system: "canmbw", label: "MB Rte125" };
routeInfo[20] = { firstWaypoint: 167, root: "mb.rt135", tier: 5, color: "TMyellow", system: "canmbw", label: "MB Rte135" };
routeInfo[21] = { firstWaypoint: 174, root: "mb.rt145", tier: 5, color: "TMyellow", system: "canmbw", label: "MB Rte145" };
routeInfo[22] = { firstWaypoint: 178, root: "mb.rt150", tier: 5, color: "TMyellow", system: "canmbw", label: "MB Rte150" };
routeInfo[23] = { firstWaypoint: 182, root: "mb.rt155", tier: 5, color: "TMyellow", system: "canmbw", label: "MB Rte155" };
routeInfo[24] = { firstWaypoint: 186, root: "mb.rt165", tier: 5, color: "TMyellow", system: "canmbw", label: "MB Rte165" };
routeInfo[25] = { firstWaypoint: 193, root: "mb.rt180", tier: 5, color: "TMyellow", system: "canmbw", label: "MB Rte180" };
waypoints = [
new Waypoint("Rte52",49.952262,-97.102473),
new Waypoint("Rte42",49.947754,-97.084025),
new Waypoint("GatRd",49.939248,-97.058222),
new Waypoint("MB59",49.927909,-97.047375),
new Waypoint("MB100",49.815724,-97.046528),
new Waypoint("Rte165",49.840249,-97.049666),
new Waypoint("MB1",49.855991,-97.049575),
new Waypoint("EliRd",49.871017,-97.071188),
new Waypoint("Rte115_W",49.881944,-97.072197),
new Waypoint("Rte115_E",49.885942,-97.072229),
new Waypoint("Rte37",49.898336,-97.068951),
new Waypoint("ConAve",49.910953,-97.056344),
new Waypoint("Rte17",49.927909,-97.047375),
new Waypoint("MB101",49.950668,-97.029276),
new Waypoint("Rte180",49.953401,-97.147561),
new Waypoint("Rte52",49.941941,-97.113706),
new Waypoint("MB190",49.945966,-97.229589),
new Waypoint("ManDr",49.945935,-97.182591),
new Waypoint("Rte180",49.939075,-97.1602),
new Waypoint("MB1",49.856475,-97.088126),
new Waypoint("Rte115",49.881943,-97.098761),
new Waypoint("Rte57",49.896276,-97.105692),
new Waypoint("Rte37",49.904866,-97.105145),
new Waypoint("Rte62",49.919444,-97.137648),
new Waypoint("Rte52",49.917326,-97.131017),
new Waypoint("Rte42",49.912711,-97.11604),
new Waypoint("Rte30",49.904866,-97.105145),
new Waypoint("MB59",49.898336,-97.068951),
new Waypoint("PleRd_N",49.895218,-97.025397),
new Waypoint("PleRd_S",49.89356,-97.025376),
new Waypoint("RavSt_N",49.89339,-96.968299),
new Waypoint("Rte115",49.885999,-96.968191),
new Waypoint("MB75/100",49.777055,-97.156611),
new Waypoint("BisDr",49.801548,-97.157072),
new Waypoint("Rte165",49.819417,-97.152438),
new Waypoint("Rte155",49.841497,-97.153441),
new Waypoint("Rte125",49.852404,-97.151912),
new Waypoint("Rte70",49.856634,-97.152164),
new Waypoint("Rte105",49.864733,-97.147272),
new Waypoint("Rte95",49.874345,-97.142814),
new Waypoint("Rte62",49.874964,-97.142331),
new Waypoint("MB1",49.887833,-97.139568),
new Waypoint("Rte85",49.893895,-97.142894),
new Waypoint("Rte57",49.895927,-97.143495),
new Waypoint("JamAve",49.900726,-97.139933),
new Waypoint("Rte52",49.901652,-97.136618),
new Waypoint("Rte47",49.901808,-97.133426),
new Waypoint("SutAve",49.90631,-97.12347),
new Waypoint("Rte37_E",49.909616,-97.118905),
new Waypoint("Rte37_W",49.912711,-97.11604),
new Waypoint("JohAve",49.914439,-97.114726),
new Waypoint("Rte17",49.947754,-97.084025),
new Waypoint("MB101",49.967754,-97.063994),
new Waypoint("Rte90",49.925305,-97.206768),
new Waypoint("Rte180",49.913713,-97.170553),
new Waypoint("Rte62",49.906096,-97.146719),
new Waypoint("Rte52",49.902592,-97.135862),
new Waypoint("Rte42",49.901808,-97.133426),
new Waypoint("MB100",49.792101,-97.115531),
new Waypoint("Rte165",49.83054,-97.115048),
new Waypoint("Rte62",49.835855,-97.113047),
new Waypoint("Rte135",49.852612,-97.111947),
new Waypoint("MB1_E",49.864411,-97.110997),
new Waypoint("Rte115",49.881259,-97.127976),
new Waypoint("MB1_W",49.888745,-97.134933),
new Waypoint("Rte57_E",49.894112,-97.137728),
new Waypoint("Rte57/85",49.895533,-97.138463),
new Waypoint("JamAve",49.900073,-97.137948),
new Waypoint("Rte42",49.901652,-97.136618),
new Waypoint("Rte47",49.902592,-97.135862),
new Waypoint("Rte37",49.917326,-97.131017),
new Waypoint("InkBlvd",49.927446,-97.124119),
new Waypoint("Rte23",49.941941,-97.113706),
new Waypoint("Rte17",49.952262,-97.102473),
new Waypoint("MB9/101",49.972122,-97.073833),
new Waypoint("Rte90",49.911748,-97.206168),
new Waypoint("Rte180",49.905322,-97.171449),
new Waypoint("Rte70",49.901317,-97.15888),
new Waypoint("Rte62",49.898667,-97.152062),
new Waypoint("Rte42",49.895927,-97.143495),
new Waypoint("Rte85_W",49.895035,-97.13982),
new Waypoint("Rte52",49.895533,-97.138463),
new Waypoint("WesSt",49.893667,-97.135711),
new Waypoint("TacAve",49.891407,-97.125025),
new Waypoint("Rte30",49.896276,-97.105692),
new Waypoint("Rte165",49.832703,-97.108803),
new Waypoint("Rte52",49.835855,-97.113047),
new Waypoint("Rte135",49.850201,-97.120788),
new Waypoint("KinRow",49.854635,-97.126045),
new Waypoint("Rte125",49.859719,-97.130095),
new Waypoint("Rte42",49.874964,-97.142331),
new Waypoint("MB1",49.885483,-97.149739),
new Waypoint("StMaryAve",49.888898,-97.149632),
new Waypoint("Rte85",49.890975,-97.15086),
new Waypoint("Rte57",49.898667,-97.152062),
new Waypoint("Rte47",49.906096,-97.146719),
new Waypoint("Rte37",49.919444,-97.137648),
new Waypoint("Rte42",49.856634,-97.152164),
new Waypoint("Rte105",49.862184,-97.156654),
new Waypoint("Rte95",49.868125,-97.161423),
new Waypoint("AcaRd_W",49.874988,-97.167147),
new Waypoint("MB1",49.885815,-97.15991),
new Waypoint("Rte85",49.888192,-97.159824),
new Waypoint("Rte57",49.901317,-97.15888),
new Waypoint("Rte90",49.779002,-97.188814),
new Waypoint("TimSaleDr",49.783619,-97.176116),
new Waypoint("SanDr",49.788157,-97.173772),
new Waypoint("BisDr",49.802095,-97.173402),
new Waypoint("Rte165",49.813318,-97.176937),
new Waypoint("Rte155",49.829976,-97.180172),
new Waypoint("Rte145",49.846904,-97.179281),
new Waypoint("Rte105",49.85615,-97.178407),
new Waypoint("MB100/101",49.880585,-97.325376),
new Waypoint("StuRd",49.879458,-97.279051),
new Waypoint("Rte96",49.875444,-97.26295),
new Waypoint("Rte90",49.879676,-97.204928),
new Waypoint("EmpSt",49.881093,-97.19685),
new Waypoint("MB1_E",49.886792,-97.165001),
new Waypoint("Rte70",49.888192,-97.159824),
new Waypoint("Rte62",49.890975,-97.15086),
new Waypoint("Rte42",49.893895,-97.142894),
new Waypoint("Rte57_W",49.895035,-97.13982),
new Waypoint("Rte52",49.895533,-97.138463),
new Waypoint("MB100",49.768595,-97.182634),
new Waypoint("Rte80",49.779002,-97.188814),
new Waypoint("BisDr",49.79466,-97.197912),
new Waypoint("Rte165",49.809843,-97.189227),
new Waypoint("Rte155",49.821331,-97.201211),
new Waypoint("Rte145",49.841664,-97.208812),
new Waypoint("Rte105",49.857236,-97.206672),
new Waypoint("Rte95",49.864173,-97.206017),
new Waypoint("AcaRd_E",49.87576,-97.202362),
new Waypoint("MB1",49.879676,-97.204928),
new Waypoint("WelAve",49.901404,-97.2048),
new Waypoint("Rte57",49.911748,-97.206168),
new Waypoint("Rte47",49.925305,-97.206768),
new Waypoint("MB190",49.945966,-97.229589),
new Waypoint("MB7/101",49.989898,-97.22902),
new Waypoint("Rte105",49.858526,-97.27775),
new Waypoint("Rte96",49.867848,-97.265697),
new Waypoint("ShaBlvd",49.867109,-97.229559),
new Waypoint("Rte90",49.864173,-97.206017),
new Waypoint("CamSt",49.863025,-97.174963),
new Waypoint("Rte70",49.868125,-97.161423),
new Waypoint("Rte42",49.874345,-97.142814),
new Waypoint("Rte145",49.845047,-97.231627),
new Waypoint("Rte105_E",49.85791,-97.230442),
new Waypoint("Rte105_W",49.85928,-97.267563),
new Waypoint("Rte95",49.867848,-97.265697),
new Waypoint("MB1",49.875444,-97.26295),
new Waypoint("MB100",49.864138,-97.324598),
new Waypoint("Rte95",49.858526,-97.27775),
new Waypoint("Rte96_N",49.85928,-97.267563),
new Waypoint("Rte96_S",49.85791,-97.230442),
new Waypoint("Rte90",49.857236,-97.206672),
new Waypoint("Rte80",49.85615,-97.178407),
new Waypoint("Rte70",49.862184,-97.156654),
new Waypoint("Rte42",49.864733,-97.147272),
new Waypoint("MB1",49.881259,-97.127976),
new Waypoint("Rte30",49.881943,-97.098761),
new Waypoint("MB59_S",49.881944,-97.072197),
new Waypoint("MB59_N",49.885942,-97.072229),
new Waypoint("PleRd",49.886036,-97.026116),
new Waypoint("Rte37",49.885999,-96.968191),
new Waypoint("MB15/101",49.886108,-96.958879),
new Waypoint("Rte42",49.852404,-97.151912),
new Waypoint("Rte62",49.859719,-97.130095),
new Waypoint("Rte62",49.850201,-97.120788),
new Waypoint("Rte52",49.852612,-97.111947),
new Waypoint("MB1/150",49.855334,-97.103906),
new Waypoint("Rte30",49.856475,-97.088126),
new Waypoint("MB59",49.855991,-97.049575),
new Waypoint("PleRd",49.855455,-97.021192),
new Waypoint("MB100/101",49.834436,-96.963218),
new Waypoint("MB100",49.838951,-97.324453),
new Waypoint("Rte96",49.845047,-97.231627),
new Waypoint("Rte90",49.841664,-97.208812),
new Waypoint("Rte80",49.846904,-97.179281),
new Waypoint("MB100",49.807464,-97.070416),
new Waypoint("Rte165",49.838273,-97.092871),
new Waypoint("MB1/135",49.855334,-97.103906),
new Waypoint("Rte52",49.864411,-97.110997),
new Waypoint("MB3/100",49.775347,-97.31859),
new Waypoint("Rte90",49.821331,-97.201211),
new Waypoint("Rte80",49.829976,-97.180172),
new Waypoint("Rte42",49.841497,-97.153441),
new Waypoint("Rte90",49.809843,-97.189227),
new Waypoint("Rte80",49.813318,-97.176937),
new Waypoint("Rte42",49.819417,-97.152438),
new Waypoint("Rte52",49.83054,-97.115048),
new Waypoint("Rte62",49.832703,-97.108803),
new Waypoint("Rte150",49.838273,-97.092871),
new Waypoint("MB59",49.840249,-97.049666),
new Waypoint("Rte57",49.905322,-97.171449),
new Waypoint("Rte47",49.913713,-97.170553),
new Waypoint("Rte25",49.939075,-97.1602),
new Waypoint("Rte23",49.953401,-97.147561),
new Waypoint("MB8/101",49.986739,-97.106652)
];
traveler = 'dfilpus';
segments = [
69626,
69627,
69628,
69629,
69630,
69631,
69632,
69633,
69634,
69635,
69636,
69637,
69638,
69639,
69640,
69641,
69642,
69643,
69644,
69645,
69646,
69647,
69648,
69649,
69650,
69651,
69652,
69653,
69654,
69655,
69656,
69657,
69658,
69659,
69660,
69661,
69662,
69663,
69664,
69665,
69666,
69667,
69668,
69669,
69670,
69671,
69672,
69673,
69674,
69675,
69676,
69677,
69678,
69679,
69680,
69681,
69682,
69683,
69684,
69685,
69686,
69687,
69688,
69689,
69690,
69691,
69692,
69693,
69694,
69695,
69696,
69697,
69698,
69699,
69700,
69701,
69702,
69703,
69704,
69705,
69706,
69707,
69708,
69709,
69710,
69711,
69712,
69713,
69714,
69715,
69716,
69717,
69718,
69719,
69720,
69721,
69722,
69723,
69724,
69725,
69726,
69727,
69728,
69729,
69730,
69731,
69732,
69733,
69734,
69735,
69736,
69737,
69738,
69739,
69740,
69741,
69742,
69743,
69744,
69745,
69746,
69747,
69748,
69749,
69750,
69751,
69752,
69753,
69754,
69755,
69756,
69757,
69758,
69759,
69760,
69761,
69762,
69763,
69764,
69765,
69766,
69767,
69768,
69769,
69770,
69771,
69772,
69773,
69774,
69775,
69776,
69777,
69778,
69779,
69780,
69781,
69782,
69783,
69784,
69785,
69786,
69787,
69788,
69789,
69790,
69791,
69792,
69793,
69794,
69795,
69796,
69797
];
clinched = [
];
mapClinched = true;
mapStatus = mapStates.MAPVIEW;
genEdges = true;
}