<!-- /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: "phl.e001", tier: 1, color: "TMblue", system: "phle", label: "PHL E1" };
routeInfo[1] = { firstWaypoint: 45, root: "phl.e002", tier: 1, color: "TMblue", system: "phle", label: "PHL E2" };
routeInfo[2] = { firstWaypoint: 91, root: "phl.e003", tier: 1, color: "TMblue", system: "phle", label: "PHL E3" };
routeInfo[3] = { firstWaypoint: 97, root: "phl.e004", tier: 1, color: "TMblue", system: "phle", label: "PHL E4" };
routeInfo[4] = { firstWaypoint: 114, root: "phl.e005", tier: 1, color: "TMblue", system: "phle", label: "PHL E5" };
routeInfo[5] = { firstWaypoint: 119, root: "phl.e006", tier: 1, color: "TMblue", system: "phle", label: "PHL E6" };
waypoints = [
new Waypoint("9(NLX)",14.657333,121.000156),
new Waypoint("10(NLX)",14.661807,121.000232),
new Waypoint("13(NLX)",14.693472,121.00035),
new Waypoint("15(NLX)",14.708416,120.992861),
new Waypoint("17(NLX)",14.722347,120.985286),
new Waypoint("20(NLX)",14.746207,120.97239),
new Waypoint("23(NLX)",14.771812,120.958657),
new Waypoint("26(NLX)",14.792902,120.947242),
new Waypoint("27(NLX)",14.807123,120.93956),
new Waypoint("29(NLX)",14.814415,120.93544),
new Waypoint("32(NLX)",14.833467,120.902438),
new Waypoint("34(NLX)",14.835749,120.898318),
new Waypoint("38(NLX)",14.862381,120.85875),
new Waypoint("45(NLX)",14.908294,120.81708),
new Waypoint("56(NLX)",14.990349,120.749788),
new Waypoint("65(NLX)",15.049414,120.695028),
new Waypoint("72(NLX)",15.105272,120.663486),
new Waypoint("81(NLX)",15.163311,120.613189),
new Waypoint("83(NLX)",15.179589,120.604005),
new Waypoint("85(NLX)",15.197895,120.596538),
new Waypoint("45(CSR)",15.197647,120.582118),
new Waypoint("88(SCT)",15.19744,120.575638),
new Waypoint("91(SCT)",15.23297,120.567484),
new Waypoint("93(SCT)",15.239802,120.568728),
new Waypoint("+X877879",15.248497,120.587568),
new Waypoint("100(SCT)",15.28908,120.606987),
new Waypoint("103(SCT)",15.31817,120.62439),
new Waypoint("+X235570",15.375778,120.658979),
new Waypoint("118(SCT)",15.433907,120.665996),
new Waypoint("122(SCT)",15.476129,120.678012),
new Waypoint("124(TPL)",15.485776,120.678077),
new Waypoint("130(TPL)",15.544702,120.645504),
new Waypoint("+X485514",15.572774,120.632114),
new Waypoint("138(TPL)",15.613944,120.63087),
new Waypoint("144(TPL)",15.664796,120.614755),
new Waypoint("150(TPL)",15.716132,120.612631),
new Waypoint("+X167690",15.778006,120.641384),
new Waypoint("169(TPL)",15.875653,120.622673),
new Waypoint("+X902809",15.934343,120.597095),
new Waypoint("184(TPL)",16.003328,120.583234),
new Waypoint("189(TPL)",16.046803,120.562162),
new Waypoint("199(TPL)",16.128778,120.522037),
new Waypoint("204(TPL)",16.180196,120.51326),
new Waypoint("+X816295",16.196357,120.49706),
new Waypoint("210(TPL)",16.225285,120.497746),
new Waypoint("E1",14.657333,121.000156),
new Waypoint("N160",14.654161,120.998303),
new Waypoint("N130_A",14.644309,120.994792),
new Waypoint("+X144784",14.644737,121.005113),
new Waypoint("N130_B",14.632038,121.009509),
new Waypoint("N130_C",14.623408,121.015327),
new Waypoint("N130_D",14.616239,121.016255),
new Waypoint("N130_E",14.60916,121.017057),
new Waypoint("+X303874",14.593476,121.025814),
new Waypoint("+X605090",14.589777,121.00919),
new Waypoint("N140_N",14.583661,121.002485),
new Waypoint("N140_S",14.577151,120.997506),
new Waypoint("6(SW)",14.557782,121.007468),
new Waypoint("7(SW)",14.55103,121.0111),
new Waypoint("9(SW)",14.528761,121.023116),
new Waypoint("E6",14.523587,121.026265),
new Waypoint("14(SLE)",14.486874,121.045003),
new Waypoint("18(SLE)",14.453693,121.045325),
new Waypoint("22(SLE)",14.422991,121.045486),
new Waypoint("23(SLE)",14.411114,121.043072),
new Waypoint("MCX",14.384469,121.040175),
new Waypoint("26(SLE)",14.380583,121.040862),
new Waypoint("27(SLE)",14.36651,121.043372),
new Waypoint("31(SLE)",14.332917,121.054251),
new Waypoint("33(SLE)",14.321482,121.062448),
new Waypoint("36(SLE)",14.303414,121.078176),
new Waypoint("38(SLE)",14.285095,121.088605),
new Waypoint("42(SLE)",14.257978,121.102295),
new Waypoint("43(SLE)",14.241132,121.111693),
new Waypoint("45(SLE)",14.229713,121.118667),
new Waypoint("47(SLE)",14.211867,121.129653),
new Waypoint("48(SLE)",14.202797,121.13519),
new Waypoint("50(SLE)",14.193208,121.141069),
new Waypoint("+SLE_S",14.153825,121.14491),
new Waypoint("+X358191",14.140571,121.14697),
new Waypoint("60(STAR)",14.126171,121.138279),
new Waypoint("+X943619",14.10736,121.128988),
new Waypoint("65(STAR)",14.086423,121.132507),
new Waypoint("70(STAR)",14.039341,121.150103),
new Waypoint("78(STAR)",13.974425,121.14903),
new Waypoint("82(STAR)",13.941856,121.138301),
new Waypoint("+X548353",13.91703,121.127014),
new Waypoint("93(STAR)",13.840122,121.120984),
new Waypoint("+X168106",13.82587,121.119461),
new Waypoint("+X628416",13.798574,121.097445),
new Waypoint("102(STAR)",13.797532,121.071181),
new Waypoint("8",14.517454,120.993226),
new Waypoint("PacAve",14.504283,120.990554),
new Waypoint("12",14.476268,120.971596),
new Waypoint("13",14.47098,120.961833),
new Waypoint("+X745212",14.455335,120.917974),
new Waypoint("21",14.447127,120.915613),
new Waypoint("RizHwy",14.820939,120.302825),
new Waypoint("+X925070",14.832949,120.306773),
new Waypoint("+X713177",14.823075,120.316901),
new Waypoint("+X332362",14.825481,120.337114),
new Waypoint("91",14.842314,120.35604),
new Waypoint("+X696970",14.850393,120.377069),
new Waypoint("+X161873",14.846618,120.443673),
new Waypoint("107",14.856325,120.453243),
new Waypoint("+X603991",14.922414,120.461312),
new Waypoint("+X666063",14.993955,120.459251),
new Waypoint("125",15.019179,120.473907),
new Waypoint("+X468187",15.058614,120.512552),
new Waypoint("139",15.123916,120.509033),
new Waypoint("+X898987",15.157802,120.52856),
new Waypoint("+X692663",15.168986,120.565081),
new Waypoint("149",15.183048,120.57126),
new Waypoint("150",15.19744,120.575638),
new Waypoint("N128",14.693514,121.022065),
new Waypoint("E1",14.693472,121.00035),
new Waypoint("CapCruz",14.692935,120.988387),
new Waypoint("N1",14.691895,120.971661),
new Waypoint("N130",14.644789,120.976424),
new Waypoint("E2",14.523587,121.026265),
new Waypoint("N192_E",14.517204,121.018782),
new Waypoint("N192_W",14.524464,121.011829),
new Waypoint("+X958254",14.527019,120.998783),
new Waypoint("N194/N195",14.517433,120.998794),
new Waypoint("E3",14.517454,120.993226),
new Waypoint("SeaDr",14.517272,120.990661)
];
traveler = 'jayhawkco';
segments = [
415645,
415646,
415647,
415648,
415649,
415650,
415651,
415652,
415653,
415654,
415655,
415656,
415657,
415658,
415659,
415660,
415661,
415662,
415663,
415664,
415665,
415666,
415667,
415668,
415669,
415670,
415671,
415672,
415673,
415674,
415675,
415676,
415677,
415678,
415679,
415680,
415681,
415682,
415683,
415684,
415685,
415686,
415687,
415688,
415689,
415690,
415691,
415692,
415693,
415694,
415695,
415696,
415697,
415698,
415699,
415700,
415701,
415702,
415703,
415704,
415705,
415706,
415707,
415708,
415709,
415710,
415711,
415712,
415713,
415714,
415715,
415716,
415717,
415718,
415719,
415720,
415721,
415722,
415723,
415724,
415725,
415726,
415727,
415728,
415729,
415730,
415731,
415732,
415733,
415734,
415735,
415736,
415737,
415738,
415739,
415740,
415741,
415742,
415743,
415744,
415745,
415746,
415747,
415748,
415749,
415750,
415751,
415752,
415753,
415754,
415755,
415756,
415757,
415758,
415759,
415760,
415761,
415762,
415763,
415764
];
clinched = [
415645,
415646,
415647,
415648,
415649,
415650,
415651,
415652,
415653,
415654,
415655,
415656,
415657,
415658,
415659,
415660,
415661,
415662,
415663,
415664,
415665,
415666,
415667,
415668,
415669,
415670,
415671,
415672,
415673,
415674,
415675,
415676,
415677,
415678,
415679,
415680,
415681,
415682,
415683,
415684,
415685,
415686,
415687,
415688
];
mapClinched = true;
mapStatus = mapStates.MAPVIEW;
genEdges = true;
}