<!-- /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: "vnm.ct01", tier: 1, color: "TMblue", system: "vnmct", label: "VNM CT01" };
routeInfo[1] = { firstWaypoint: 18, root: "vnm.ct01bac", tier: 1, color: "TMblue", system: "vnmct", label: "VNM CT01Bac" };
routeInfo[2] = { firstWaypoint: 41, root: "vnm.ct01khe", tier: 1, color: "TMblue", system: "vnmct", label: "VNM CT01Khe" };
routeInfo[3] = { firstWaypoint: 69, root: "vnm.ct01phu", tier: 1, color: "TMblue", system: "vnmct", label: "VNM CT01Phu" };
routeInfo[4] = { firstWaypoint: 86, root: "vnm.ct01tan", tier: 1, color: "TMblue", system: "vnmct", label: "VNM CT01Tan" };
routeInfo[5] = { firstWaypoint: 96, root: "vnm.ct02", tier: 1, color: "TMblue", system: "vnmct", label: "VNM CT02" };
routeInfo[6] = { firstWaypoint: 105, root: "vnm.ct03", tier: 1, color: "TMblue", system: "vnmct", label: "VNM CT03" };
routeInfo[7] = { firstWaypoint: 114, root: "vnm.ct04", tier: 1, color: "TMblue", system: "vnmct", label: "VNM CT04" };
routeInfo[8] = { firstWaypoint: 129, root: "vnm.ct05", tier: 1, color: "TMblue", system: "vnmct", label: "VNM CT05" };
routeInfo[9] = { firstWaypoint: 172, root: "vnm.ct06", tier: 1, color: "TMblue", system: "vnmct", label: "VNM CT06" };
routeInfo[10] = { firstWaypoint: 205, root: "vnm.ct07", tier: 1, color: "TMblue", system: "vnmct", label: "VNM CT07" };
routeInfo[11] = { firstWaypoint: 220, root: "vnm.ct09", tier: 1, color: "TMblue", system: "vnmct", label: "VNM CT09" };
routeInfo[12] = { firstWaypoint: 232, root: "vnm.ct25", tier: 1, color: "TMblue", system: "vnmct", label: "VNM CT25" };
routeInfo[13] = { firstWaypoint: 235, root: "vnm.ct29", tier: 1, color: "TMblue", system: "vnmct", label: "VNM CT29" };
routeInfo[14] = { firstWaypoint: 245, root: "vnm.ct37", tier: 1, color: "TMblue", system: "vnmct", label: "VNM CT37" };
waypoints = [
new Waypoint("QL1/14B",16.003473,108.147311),
new Waypoint("+X499240",15.952169,108.172073),
new Waypoint("DT609",15.89171,108.175828),
new Waypoint("+X493058",15.823512,108.194561),
new Waypoint("+X169244",15.78767,108.260307),
new Waypoint("QL14E",15.710534,108.33189),
new Waypoint("+X679258",15.663433,108.371415),
new Waypoint("+X699151",15.554521,108.431411),
new Waypoint("DT616",15.535626,108.453255),
new Waypoint("+X798434",15.507467,108.518486),
new Waypoint("ChuLai",15.440092,108.591099),
new Waypoint("+X781027",15.407182,108.634787),
new Waypoint("+X976221",15.373295,108.720274),
new Waypoint("+X578100",15.327855,108.725939),
new Waypoint("+X712110",15.28137,108.751087),
new Waypoint("DT623",15.160184,108.749328),
new Waypoint("+X906097",15.119587,108.751602),
new Waypoint("DT627",15.087269,108.781214),
new Waypoint("6",21.686472,106.631262),
new Waypoint("7",21.619911,106.55571),
new Waypoint("+X945251",21.557081,106.494856),
new Waypoint("+X888588",21.526184,106.40748),
new Waypoint("8",21.490909,106.375165),
new Waypoint("+X940035",21.426625,106.31135),
new Waypoint("9",21.388428,106.29781),
new Waypoint("+X407208",21.346145,106.282253),
new Waypoint("10",21.286835,106.230326),
new Waypoint("11",21.26844,106.206164),
new Waypoint("12",21.247817,106.169665),
new Waypoint("13",21.247762,106.127372),
new Waypoint("+X987227",21.227502,106.107588),
new Waypoint("14",21.172547,106.089478),
new Waypoint("15",21.161581,106.066775),
new Waypoint("16",21.155138,106.056776),
new Waypoint("17",21.133564,106.023302),
new Waypoint("18",21.118292,105.999548),
new Waypoint("19",21.110545,105.986652),
new Waypoint("20",21.097173,105.966997),
new Waypoint("21",21.0842,105.956912),
new Waypoint("22",21.05849,105.951676),
new Waypoint("23",21.024645,105.929189),
new Waypoint("QL9",16.803653,107.020161),
new Waypoint("+X667575",16.777692,107.020526),
new Waypoint("+X366624",16.713336,107.064986),
new Waypoint("+X336334",16.677903,107.110305),
new Waypoint("+X291273",16.643326,107.194505),
new Waypoint("+X114631",16.547457,107.279391),
new Waypoint("+X292102",16.491275,107.390413),
new Waypoint("+X150389",16.487818,107.450838),
new Waypoint("+X908543",16.476707,107.481995),
new Waypoint("QL49",16.394291,107.568104),
new Waypoint("+X103337",16.393952,107.591515),
new Waypoint("+X551395",16.368465,107.653313),
new Waypoint("QL14B_LS",16.315094,107.712772),
new Waypoint("+X870624",16.306949,107.718759),
new Waypoint("+X580301",16.246505,107.69464),
new Waypoint("+X353479",16.22988,107.714767),
new Waypoint("QL14B_KT",16.206855,107.722986),
new Waypoint("+X272850",16.189907,107.729702),
new Waypoint("+X166647",16.172823,107.720776),
new Waypoint("+X501376",16.149493,107.73468),
new Waypoint("+X214275",16.135663,107.774763),
new Waypoint("+X408433",16.142423,107.838278),
new Waypoint("+X607628",16.119667,107.924709),
new Waypoint("+X694511",16.12581,107.94179),
new Waypoint("+X104564",16.116368,107.967024),
new Waypoint("+X643554",16.133168,108.041353),
new Waypoint("+X170981",16.103752,108.088303),
new Waypoint("QL1",16.093258,108.087358),
new Waypoint("QL1",20.965751,105.849216),
new Waypoint("28",20.961064,105.849205),
new Waypoint("30",20.870221,105.879922),
new Waypoint("+X851341",20.808876,105.891466),
new Waypoint("31",20.772862,105.908267),
new Waypoint("+X775128",20.749011,105.920134),
new Waypoint("32",20.704237,105.918889),
new Waypoint("+X921841",20.678723,105.934982),
new Waypoint("33",20.64666,105.938501),
new Waypoint("34",20.538875,105.948029),
new Waypoint("+X437254",20.346257,105.983219),
new Waypoint("37",20.285848,106.01429),
new Waypoint("+X169423",20.268115,106.021585),
new Waypoint("+X182564",20.233469,106.013346),
new Waypoint("38",20.221429,106.001115),
new Waypoint("+X739179",20.189975,105.969229),
new Waypoint("39",20.187397,105.954337),
new Waypoint("DurTranCh",10.684457,106.567082),
new Waypoint("2",10.673893,106.538715),
new Waypoint("3",10.65269,106.476209),
new Waypoint("4",10.546821,106.368642),
new Waypoint("5",10.438351,106.308432),
new Waypoint("CaiLay",10.422355,106.164064),
new Waypoint("+X546698",10.423537,106.088791),
new Waypoint("CaiBe",10.412985,106.029911),
new Waypoint("+X662166",10.35794,105.925541),
new Waypoint("QL30",10.319099,105.88254),
new Waypoint("1",10.449557,105.668435),
new Waypoint("2",10.434279,105.656934),
new Waypoint("3",10.393168,105.645347),
new Waypoint("4",10.356505,105.548401),
new Waypoint("5",10.325242,105.513811),
new Waypoint("6",10.297713,105.481539),
new Waypoint("7",10.212367,105.402403),
new Waypoint("DT963",10.03569,105.229111),
new Waypoint("8",9.962405,105.163107),
new Waypoint("CT20",21.00519,105.7923),
new Waypoint("1",21.002301,105.782225),
new Waypoint("2",21.005806,105.76566),
new Waypoint("3",21.009392,105.747614),
new Waypoint("4",21.003182,105.649681),
new Waypoint("5",21.0018,105.622537),
new Waypoint("6",20.989079,105.5687),
new Waypoint("7",20.990301,105.536449),
new Waypoint("8",20.990151,105.524969),
new Waypoint("1",21.012347,105.918031),
new Waypoint("+X517087",20.904321,105.986824),
new Waypoint("2",20.852375,106.032572),
new Waypoint("+X651873",20.845297,106.051626),
new Waypoint("+X486265",20.862401,106.248093),
new Waypoint("3",20.859072,106.298647),
new Waypoint("+X152519",20.855042,106.356411),
new Waypoint("4",20.80334,106.525068),
new Waypoint("+X387623",20.771563,106.585493),
new Waypoint("+X850362",20.765223,106.684542),
new Waypoint("5",20.773349,106.72132),
new Waypoint("+X811337",20.786971,106.74943),
new Waypoint("6",20.802397,106.752477),
new Waypoint("7",20.836814,106.75106),
new Waypoint("8",20.84287,106.751618),
new Waypoint("1",21.219201,105.773621),
new Waypoint("+X365438",21.236282,105.769672),
new Waypoint("+X638289",21.256322,105.732164),
new Waypoint("+X424076",21.257122,105.70251),
new Waypoint("3",21.283196,105.668221),
new Waypoint("+X713188",21.325878,105.6423),
new Waypoint("4",21.357076,105.603161),
new Waypoint("+X347014",21.359195,105.536342),
new Waypoint("6",21.356816,105.469093),
new Waypoint("7",21.367288,105.380173),
new Waypoint("8",21.393763,105.333781),
new Waypoint("+X269364",21.392764,105.301423),
new Waypoint("9",21.42197,105.229497),
new Waypoint("+X800864",21.447636,105.187998),
new Waypoint("+X570385",21.450732,105.144396),
new Waypoint("10",21.439308,105.118518),
new Waypoint("+X632548",21.450392,105.082941),
new Waypoint("+X261776",21.508358,105.028739),
new Waypoint("11",21.534867,104.969473),
new Waypoint("+X422016",21.544587,104.948788),
new Waypoint("+X394589",21.603413,104.902267),
new Waypoint("12",21.646848,104.891281),
new Waypoint("+X297841",21.678088,104.874802),
new Waypoint("13",21.698719,104.844085),
new Waypoint("+X668914",21.746725,104.815879),
new Waypoint("+X850457",21.755215,104.788885),
new Waypoint("+X682639",21.77867,104.782104),
new Waypoint("14",21.87725,104.67443),
new Waypoint("+X255519",21.926187,104.599285),
new Waypoint("+X891829",22.004931,104.540749),
new Waypoint("+X649803",22.024188,104.502897),
new Waypoint("+X463454",22.085322,104.449682),
new Waypoint("+X220715",22.108504,104.406424),
new Waypoint("+X645743",22.139831,104.383335),
new Waypoint("16",22.156029,104.343896),
new Waypoint("+X673108",22.206597,104.30789),
new Waypoint("+X351907",22.275237,104.233646),
new Waypoint("+X586788",22.346067,104.132967),
new Waypoint("17",22.340937,104.103956),
new Waypoint("18",22.399741,104.024606),
new Waypoint("19",22.473521,103.965983),
new Waypoint("+X145817",22.520654,103.925943),
new Waypoint("20",22.523588,103.937252),
new Waypoint("1",20.836814,106.75106),
new Waypoint("+2",20.866612,106.789341),
new Waypoint("3",20.902958,106.825776),
new Waypoint("4",20.929877,106.860452),
new Waypoint("+5",20.944186,106.885386),
new Waypoint("6",20.9618,106.945038),
new Waypoint("+X529031",20.969895,106.964178),
new Waypoint("7",20.994879,106.978126),
new Waypoint("+X638203",21.031335,106.979284),
new Waypoint("+X477404",21.059151,107.003016),
new Waypoint("+X435482",21.044813,107.089148),
new Waypoint("8",21.052323,107.167425),
new Waypoint("+X509074",21.07523,107.296214),
new Waypoint("+X190526",21.090126,107.318873),
new Waypoint("+X912513",21.085121,107.343378),
new Waypoint("9",21.09409,107.355523),
new Waypoint("+X129856",21.082057,107.386379),
new Waypoint("10",21.088684,107.40685),
new Waypoint("11",21.114419,107.421849),
new Waypoint("12",21.177989,107.453713),
new Waypoint("+X450339",21.206098,107.463713),
new Waypoint("13",21.291434,107.447491),
new Waypoint("+X981056",21.302589,107.454014),
new Waypoint("+X894680",21.318922,107.517099),
new Waypoint("14",21.351061,107.551861),
new Waypoint("+X621944",21.402853,107.623529),
new Waypoint("+X674452",21.457762,107.669063),
new Waypoint("15",21.472659,107.699919),
new Waypoint("+X574616",21.529298,107.804203),
new Waypoint("+X124652",21.519078,107.846775),
new Waypoint("+X316764",21.520515,107.925396),
new Waypoint("+X285050",21.509975,107.96299),
new Waypoint("16",21.51794,107.984877),
new Waypoint("1",21.0842,105.956912),
new Waypoint("+X776143",21.088334,105.940154),
new Waypoint("+X754487",21.130261,105.904427),
new Waypoint("2",21.204298,105.93112),
new Waypoint("+X937928",21.248382,105.920477),
new Waypoint("3",21.275158,105.88932),
new Waypoint("+X564212",21.312485,105.878935),
new Waypoint("4",21.404851,105.88829),
new Waypoint("+X246248",21.499194,105.882196),
new Waypoint("5",21.506841,105.870781),
new Waypoint("+X997167",21.545026,105.82881),
new Waypoint("6",21.56648,105.822372),
new Waypoint("7",21.576457,105.813746),
new Waypoint("+X774705",21.599961,105.794091),
new Waypoint("8",21.622504,105.791559),
new Waypoint("CT05",21.219201,105.773621),
new Waypoint("1",21.205708,105.784156),
new Waypoint("+X886595",21.194355,105.80512),
new Waypoint("2",21.200997,105.834131),
new Waypoint("QL3",21.209799,105.844088),
new Waypoint("+X181863",21.216761,105.883398),
new Waypoint("CT07",21.210029,105.933223),
new Waypoint("DT295",21.202798,105.958071),
new Waypoint("Sam",21.198026,105.979421),
new Waypoint("DT286",21.188723,106.004891),
new Waypoint("KhaLe",21.157349,106.054094),
new Waypoint("CT01",21.155138,106.056776),
new Waypoint("QL27",11.754069,108.383882),
new Waypoint("+X975488",11.796995,108.421755),
new Waypoint("QL20",11.856841,108.457074),
new Waypoint("9",10.942245,107.165623),
new Waypoint("+X916678",10.912897,107.162833),
new Waypoint("8",10.85653,107.110434),
new Waypoint("+X438106",10.77469,107.005291),
new Waypoint("6",10.765331,106.959414),
new Waypoint("5",10.773805,106.928129),
new Waypoint("+X550395",10.786642,106.889248),
new Waypoint("3",10.795958,106.792388),
new Waypoint("2",10.796317,106.780543),
new Waypoint("1",10.79227,106.751747),
new Waypoint("1",21.081001,105.78848),
new Waypoint("2",21.058095,105.782826),
new Waypoint("3",21.05017,105.781603),
new Waypoint("4",21.036607,105.780605),
new Waypoint("+X259090",21.023308,105.778728),
new Waypoint("5",21.00519,105.7923),
new Waypoint("6",20.991458,105.803254),
new Waypoint("7",20.967902,105.83087),
new Waypoint("8",20.965698,105.847328),
new Waypoint("9",20.96409,105.868667),
new Waypoint("10",20.979543,105.889277)
];
traveler = 'jayhawkco';
segments = [
1213782,
1213783,
1213784,
1213785,
1213786,
1213787,
1213788,
1213789,
1213790,
1213791,
1213792,
1213793,
1213794,
1213795,
1213796,
1213797,
1213798,
1213717,
1213718,
1213719,
1213720,
1213721,
1213722,
1213723,
1213724,
1213725,
1213726,
1213727,
1213728,
1213729,
1213730,
1213731,
1213732,
1213733,
1213734,
1213735,
1213736,
1213737,
1213738,
1213755,
1213756,
1213757,
1213758,
1213759,
1213760,
1213761,
1213762,
1213763,
1213764,
1213765,
1213766,
1213767,
1213768,
1213769,
1213770,
1213771,
1213772,
1213773,
1213774,
1213775,
1213776,
1213777,
1213778,
1213779,
1213780,
1213781,
1213739,
1213740,
1213741,
1213742,
1213743,
1213744,
1213745,
1213746,
1213747,
1213748,
1213749,
1213750,
1213751,
1213752,
1213753,
1213754,
1213799,
1213800,
1213801,
1213802,
1213803,
1213804,
1213805,
1213806,
1213807,
1213808,
1213809,
1213810,
1213811,
1213812,
1213813,
1213814,
1213815,
1213816,
1213817,
1213818,
1213819,
1213820,
1213821,
1213822,
1213823,
1213824,
1213825,
1213826,
1213827,
1213828,
1213829,
1213830,
1213831,
1213832,
1213833,
1213834,
1213835,
1213836,
1213837,
1213838,
1213839,
1213840,
1213841,
1213842,
1213843,
1213844,
1213845,
1213846,
1213847,
1213848,
1213849,
1213850,
1213851,
1213852,
1213853,
1213854,
1213855,
1213856,
1213857,
1213858,
1213859,
1213860,
1213861,
1213862,
1213863,
1213864,
1213865,
1213866,
1213867,
1213868,
1213869,
1213870,
1213871,
1213872,
1213873,
1213874,
1213875,
1213876,
1213877,
1213878,
1213879,
1213880,
1213881,
1213882,
1213883,
1213884,
1213885,
1213886,
1213887,
1213888,
1213889,
1213890,
1213891,
1213892,
1213893,
1213894,
1213895,
1213896,
1213897,
1213898,
1213899,
1213900,
1213901,
1213902,
1213903,
1213904,
1213905,
1213906,
1213907,
1213908,
1213909,
1213910,
1213911,
1213912,
1213913,
1213914,
1213915,
1213916,
1213917,
1213918,
1213919,
1213920,
1213921,
1213922,
1213923,
1213924,
1213925,
1213926,
1213927,
1213928,
1213929,
1213930,
1213931,
1213932,
1213933,
1213934,
1213935,
1213936,
1213937,
1213938,
1213939,
1213940,
1213941,
1213942,
1213943,
1213944,
1213945,
1213946,
1213947,
1213948,
1213949,
1213950,
1213951,
1213952,
1213953,
1213954,
1213955,
1213956,
1213957
];
clinched = [
1213824,
1213825,
1213826,
1213827,
1213828,
1213829,
1213830,
1213831,
1213832,
1213833,
1213834,
1213835,
1213836,
1213837,
1213880,
1213881,
1213882,
1213883,
1213884,
1213885,
1213886,
1213887,
1213888,
1213889,
1213890,
1213891,
1213892,
1213893,
1213894,
1213895,
1213896,
1213897,
1213898,
1213899,
1213900,
1213901,
1213902,
1213903
];
mapClinched = true;
mapStatus = mapStates.MAPVIEW;
genEdges = true;
}