<!-- /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: "eng.a0001m", tier: 1, color: "TMblue", system: "gbnam", label: "ENG A1M" };
routeInfo[1] = { firstWaypoint: 47, root: "eng.a0001mdon", tier: 1, color: "TMblue", system: "gbnam", label: "ENG A1MDon" };
routeInfo[2] = { firstWaypoint: 55, root: "eng.a0001mpet", tier: 1, color: "TMblue", system: "gbnam", label: "ENG A1MPet" };
routeInfo[3] = { firstWaypoint: 61, root: "eng.a0001mste", tier: 1, color: "TMblue", system: "gbnam", label: "ENG A1MSte" };
routeInfo[4] = { firstWaypoint: 78, root: "eng.a0003m", tier: 1, color: "TMblue", system: "gbnam", label: "ENG A3M" };
routeInfo[5] = { firstWaypoint: 84, root: "eng.a0038m", tier: 1, color: "TMblue", system: "gbnam", label: "ENG A38M" };
routeInfo[6] = { firstWaypoint: 88, root: "eng.a0057m", tier: 1, color: "TMblue", system: "gbnam", label: "ENG A57M" };
routeInfo[7] = { firstWaypoint: 93, root: "eng.a0058m", tier: 1, color: "TMblue", system: "gbnam", label: "ENG A58M" };
routeInfo[8] = { firstWaypoint: 97, root: "eng.a0064m", tier: 1, color: "TMblue", system: "gbnam", label: "ENG A64M" };
routeInfo[9] = { firstWaypoint: 101, root: "eng.a0066m", tier: 1, color: "TMblue", system: "gbnam", label: "ENG A66M" };
routeInfo[10] = { firstWaypoint: 103, root: "eng.a0074m", tier: 1, color: "TMblue", system: "gbnam", label: "ENG A74M" };
routeInfo[11] = { firstWaypoint: 105, root: "eng.a0167m", tier: 1, color: "TMblue", system: "gbnam", label: "ENG A167M" };
routeInfo[12] = { firstWaypoint: 110, root: "eng.a0194m", tier: 1, color: "TMblue", system: "gbnam", label: "ENG A194M" };
routeInfo[13] = { firstWaypoint: 114, root: "eng.a0308m", tier: 1, color: "TMblue", system: "gbnam", label: "ENG A308M" };
routeInfo[14] = { firstWaypoint: 116, root: "eng.a0329m", tier: 1, color: "TMblue", system: "gbnam", label: "ENG A329M" };
routeInfo[15] = { firstWaypoint: 119, root: "eng.a0404m", tier: 1, color: "TMblue", system: "gbnam", label: "ENG A404M" };
routeInfo[16] = { firstWaypoint: 122, root: "eng.a0627m", tier: 1, color: "TMblue", system: "gbnam", label: "ENG A627M" };
routeInfo[17] = { firstWaypoint: 126, root: "eng.a0627msla", tier: 1, color: "TMblue", system: "gbnam", label: "ENG A627MSla" };
routeInfo[18] = { firstWaypoint: 128, root: "eng.a1077m", tier: 1, color: "TMblue", system: "gbnam", label: "ENG A1077M" };
routeInfo[19] = { firstWaypoint: 130, root: "sct.a0008m", tier: 1, color: "TMblue", system: "gbnam", label: "SCT A8M" };
routeInfo[20] = { firstWaypoint: 132, root: "sct.a0074m", tier: 1, color: "TMblue", system: "gbnam", label: "SCT A74M" };
routeInfo[21] = { firstWaypoint: 159, root: "sct.a0823m", tier: 1, color: "TMblue", system: "gbnam", label: "SCT A823M" };
routeInfo[22] = { firstWaypoint: 161, root: "wls.a0048m", tier: 1, color: "TMblue", system: "gbnam", label: "WLS A48M" };
waypoints = [
new Waypoint("40",53.685233,-1.266732),
new Waypoint("41",53.711231,-1.291237),
new Waypoint("+X18",53.732365,-1.288319),
new Waypoint("+X19",53.744143,-1.274242),
new Waypoint("42",53.763338,-1.282525),
new Waypoint("+X20",53.776515,-1.296215),
new Waypoint("+X21",53.782449,-1.318531),
new Waypoint("43",53.81056,-1.34059),
new Waypoint("44",53.855881,-1.346469),
new Waypoint("45",53.906196,-1.377926),
new Waypoint("+X22",53.915764,-1.385393),
new Waypoint("+X23",53.929411,-1.372604),
new Waypoint("46",53.943969,-1.373999),
new Waypoint("+X24",53.986175,-1.362648),
new Waypoint("47",54.009572,-1.37784),
new Waypoint("48",54.081819,-1.397517),
new Waypoint("+X25",54.105106,-1.414833),
new Waypoint("+X26",54.125733,-1.414318),
new Waypoint("49",54.150057,-1.435862),
new Waypoint("50",54.181108,-1.457914),
new Waypoint("+X27",54.219984,-1.483498),
new Waypoint("+B6285",54.261853,-1.516993),
new Waypoint("+X28",54.293837,-1.552334),
new Waypoint("+A684",54.300959,-1.56679),
new Waypoint("51",54.309714,-1.571302),
new Waypoint("+A1(X29)",54.316423,-1.572418),
new Waypoint("+X686346",54.341999,-1.59924),
new Waypoint("52",54.37967,-1.651608),
new Waypoint("+A6136_N",54.404907,-1.661596),
new Waypoint("53",54.442654,-1.668585),
new Waypoint("56",54.468155,-1.666059),
new Waypoint("57",54.499792,-1.626577),
new Waypoint("58",54.556399,-1.593962),
new Waypoint("59",54.583839,-1.561089),
new Waypoint("+X31",54.596334,-1.540833),
new Waypoint("60",54.652249,-1.512036),
new Waypoint("+X32",54.662812,-1.499119),
new Waypoint("+X33",54.699035,-1.498947),
new Waypoint("+X34",54.717779,-1.520233),
new Waypoint("61",54.730382,-1.520276),
new Waypoint("+X35",54.739785,-1.514397),
new Waypoint("+X36",54.77495,-1.533279),
new Waypoint("62",54.793696,-1.52843),
new Waypoint("+X37",54.846967,-1.528816),
new Waypoint("63",54.865951,-1.564436),
new Waypoint("64",54.885065,-1.559393),
new Waypoint("65",54.901228,-1.559372),
new Waypoint("34",53.388051,-1.063743),
new Waypoint("+X15",53.437764,-1.101036),
new Waypoint("35",53.479414,-1.148243),
new Waypoint("36",53.500677,-1.174786),
new Waypoint("+X16",53.518676,-1.176224),
new Waypoint("37",53.54229,-1.206844),
new Waypoint("+X17",53.560501,-1.216736),
new Waypoint("38",53.578105,-1.212637),
new Waypoint("B1043",52.362013,-0.255303),
new Waypoint("14",52.379516,-0.255775),
new Waypoint("15",52.430858,-0.27071),
new Waypoint("15a",52.447621,-0.27719),
new Waypoint("16",52.50239,-0.293584),
new Waypoint("17",52.534041,-0.319204),
new Waypoint("1",51.686535,-0.229318),
new Waypoint("+X01",51.712725,-0.221872),
new Waypoint("2",51.74055,-0.239275),
new Waypoint("3",51.752387,-0.245175),
new Waypoint("+X909600",51.760091,-0.241678),
new Waypoint("+X895957",51.769483,-0.23334),
new Waypoint("4",51.778854,-0.22316),
new Waypoint("5",51.796574,-0.22625),
new Waypoint("+X778476",51.811905,-0.227065),
new Waypoint("6",51.826489,-0.210264),
new Waypoint("+X02",51.851367,-0.196209),
new Waypoint("7",51.887604,-0.206423),
new Waypoint("+X03",51.912403,-0.228138),
new Waypoint("8",51.928138,-0.219727),
new Waypoint("9",51.963744,-0.203419),
new Waypoint("+X04",51.972615,-0.195694),
new Waypoint("10",52.012663,-0.20462),
new Waypoint("1",50.91985,-0.998425),
new Waypoint("2",50.906835,-0.999155),
new Waypoint("3",50.876069,-1.013017),
new Waypoint("4",50.864342,-1.01675),
new Waypoint("5",50.849944,-1.011901),
new Waypoint("A27",50.845405,-1.014261),
new Waypoint("A5127",52.509483,-1.859436),
new Waypoint("M6",52.509953,-1.86332),
new Waypoint("B4132",52.502155,-1.883812),
new Waypoint("A4540",52.492292,-1.888576),
new Waypoint("A56",53.471981,-2.257519),
new Waypoint("A5103",53.470436,-2.246768),
new Waypoint("CamSt",53.470538,-2.241962),
new Waypoint("A34",53.472058,-2.235246),
new Waypoint("A6",53.473948,-2.229881),
new Waypoint("A65",53.797711,-1.560102),
new Waypoint("ParkLn",53.799637,-1.555145),
new Waypoint("A660",53.8052,-1.547248),
new Waypoint("A58",53.804681,-1.542549),
new Waypoint("A58",53.804681,-1.542549),
new Waypoint("NorSt",53.801082,-1.539266),
new Waypoint("A61",53.799879,-1.533996),
new Waypoint("A653",53.798693,-1.527894),
new Waypoint("A1M",54.499792,-1.626577),
new Waypoint("A66",54.509572,-1.586237),
new Waypoint("SCT/ENG",54.994887,-3.052461),
new Waypoint("45",54.992979,-3.048191),
new Waypoint("A186",54.97132,-1.60836),
new Waypoint("A193",54.975101,-1.606514),
new Waypoint("*CamSt",54.978845,-1.605034),
new Waypoint("A1058",54.981419,-1.60748),
new Waypoint("B1318",54.982933,-1.61263),
new Waypoint("A1M",54.901228,-1.559372),
new Waypoint("1",54.913083,-1.546154),
new Waypoint("2",54.934243,-1.52873),
new Waypoint("3",54.945854,-1.515427),
new Waypoint("M4",51.498965,-0.723982),
new Waypoint("A308",51.504255,-0.711665),
new Waypoint("A329_E",51.41326,-0.79917),
new Waypoint("M4",51.43124,-0.854981),
new Waypoint("A3290",51.439162,-0.895643),
new Waypoint("9",51.498965,-0.723982),
new Waypoint("9A",51.50738,-0.735912),
new Waypoint("9B",51.518784,-0.764494),
new Waypoint("1",53.556626,-2.140059),
new Waypoint("2",53.573932,-2.160015),
new Waypoint("3",53.586875,-2.157784),
new Waypoint("4",53.600107,-2.165701),
new Waypoint("A627M",53.573932,-2.160015),
new Waypoint("A664",53.571868,-2.174864),
new Waypoint("M181",53.577041,-0.700035),
new Waypoint("A18/A1077",53.58941,-0.698361),
new Waypoint("M8",55.853131,-4.089918),
new Waypoint("A8",55.852591,-4.097776),
new Waypoint("13",55.503434,-3.695698),
new Waypoint("+X05",55.470584,-3.69072),
new Waypoint("14a",55.466722,-3.672459),
new Waypoint("+X04",55.460609,-3.646345),
new Waypoint("14",55.449628,-3.650014),
new Waypoint("+X07",55.43213,-3.641624),
new Waypoint("+X08",55.423071,-3.591156),
new Waypoint("+X09",55.399879,-3.549271),
new Waypoint("+X10",55.394712,-3.526525),
new Waypoint("+X11",55.343692,-3.497429),
new Waypoint("15",55.313346,-3.453569),
new Waypoint("+X12",55.254468,-3.411255),
new Waypoint("16",55.219257,-3.412971),
new Waypoint("+X13",55.176809,-3.402843),
new Waypoint("17",55.133286,-3.368683),
new Waypoint("18",55.103983,-3.349285),
new Waypoint("+X14",55.094284,-3.323193),
new Waypoint("+X15",55.076795,-3.309546),
new Waypoint("19",55.064785,-3.271008),
new Waypoint("20",55.051912,-3.219509),
new Waypoint("+X900183",55.035647,-3.172989),
new Waypoint("21",55.024984,-3.128014),
new Waypoint("21a",55.020076,-3.121791),
new Waypoint("GreGre",55.009834,-3.087287),
new Waypoint("22",55.00397,-3.063855),
new Waypoint("22a",54.999958,-3.058577),
new Waypoint("SCT/ENG",54.994887,-3.052461),
new Waypoint("M90",56.043341,-3.405161),
new Waypoint("B980",56.047212,-3.429108),
new Waypoint("29",51.550818,-3.072975),
new Waypoint("29A",51.531841,-3.106341)
];
traveler = '';
segments = [
296812,
296813,
296814,
296815,
296816,
296817,
296818,
296819,
296820,
296821,
296822,
296823,
296824,
296825,
296826,
296827,
296828,
296829,
296830,
296831,
296832,
296833,
296834,
296835,
296836,
296837,
296838,
296839,
296840,
296841,
296842,
296843,
296844,
296845,
296846,
296847,
296848,
296849,
296850,
296851,
296852,
296853,
296854,
296855,
296856,
296857,
296805,
296806,
296807,
296808,
296809,
296810,
296811,
296800,
296801,
296802,
296803,
296804,
296784,
296785,
296786,
296787,
296788,
296789,
296790,
296791,
296792,
296793,
296794,
296795,
296796,
296797,
296798,
296799,
296858,
296859,
296860,
296861,
296862,
296864,
296865,
296866,
296868,
296869,
296870,
296871,
296872,
296873,
296874,
296875,
296876,
296877,
296878,
296905,
296906,
296907,
296908,
296909,
296910,
296911,
296912,
296913,
296914,
296915,
296916,
296917,
296918,
296919,
296920,
296921,
296923,
296863,
296879,
296880,
296881,
296882,
296883,
296884,
296885,
296886,
296887,
296888,
296889,
296890,
296891,
296892,
296893,
296894,
296895,
296896,
296897,
296898,
296899,
296900,
296901,
296902,
296903,
296904,
296922,
296867
];
clinched = [
];
mapClinched = true;
mapStatus = mapStates.MAPVIEW;
genEdges = true;
}