<!-- /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: "mo.i029blstj", tier: 2, color: "TMgreen", system: "usaib", label: "MO I-29BLStJ" };
routeInfo[1] = { firstWaypoint: 14, root: "mo.i035blcam", tier: 2, color: "TMgreen", system: "usaib", label: "MO I-35BLCam" };
routeInfo[2] = { firstWaypoint: 20, root: "mo.i044bljop", tier: 2, color: "TMgreen", system: "usaib", label: "MO I-44BLJop" };
routeInfo[3] = { firstWaypoint: 29, root: "mo.i044blmou", tier: 2, color: "TMgreen", system: "usaib", label: "MO I-44BLMou" };
routeInfo[4] = { firstWaypoint: 33, root: "mo.i044blpac", tier: 2, color: "TMgreen", system: "usaib", label: "MO I-44BLPac" };
routeInfo[5] = { firstWaypoint: 42, root: "mo.i044blrol", tier: 2, color: "TMgreen", system: "usaib", label: "MO I-44BLRol" };
routeInfo[6] = { firstWaypoint: 50, root: "mo.i044blsar", tier: 2, color: "TMgreen", system: "usaib", label: "MO I-44BLSar" };
routeInfo[7] = { firstWaypoint: 55, root: "mo.i044blspr", tier: 2, color: "TMgreen", system: "usaib", label: "MO I-44BLSpr" };
routeInfo[8] = { firstWaypoint: 66, root: "mo.i044blway", tier: 2, color: "TMgreen", system: "usaib", label: "MO I-44BLWay" };
routeInfo[9] = { firstWaypoint: 74, root: "mo.i044bsstr", tier: 2, color: "TMgreen", system: "usaib", label: "MO I-44BSStR" };
routeInfo[10] = { firstWaypoint: 78, root: "mo.i049blbut", tier: 2, color: "TMgreen", system: "usaib", label: "MO I-49BLBut" };
routeInfo[11] = { firstWaypoint: 83, root: "mo.i049bljop", tier: 2, color: "TMgreen", system: "usaib", label: "MO I-49BLJop" };
routeInfo[12] = { firstWaypoint: 102, root: "mo.i049blneo", tier: 2, color: "TMgreen", system: "usaib", label: "MO I-49BLNeo" };
routeInfo[13] = { firstWaypoint: 112, root: "mo.i049blnev", tier: 2, color: "TMgreen", system: "usaib", label: "MO I-49BLNev" };
routeInfo[14] = { firstWaypoint: 118, root: "mo.i055blcap", tier: 2, color: "TMgreen", system: "usaib", label: "MO I-55BLCap" };
routeInfo[15] = { firstWaypoint: 131, root: "mo.i055blnew", tier: 2, color: "TMgreen", system: "usaib", label: "MO I-55BLNew" };
routeInfo[16] = { firstWaypoint: 136, root: "mo.i057blcha", tier: 2, color: "TMgreen", system: "usaib", label: "MO I-57BLCha" };
routeInfo[17] = { firstWaypoint: 139, root: "mo.i070blboo", tier: 2, color: "TMgreen", system: "usaib", label: "MO I-70BLBoo" };
routeInfo[18] = { firstWaypoint: 145, root: "mo.i070blcol", tier: 2, color: "TMgreen", system: "usaib", label: "MO I-70BLCol" };
routeInfo[19] = { firstWaypoint: 151, root: "mo.i070blstc", tier: 2, color: "TMgreen", system: "usaib", label: "MO I-70BLStC" };
waypoints = [
new Waypoint("I-29_S",39.724155,-94.78858),
new Waypoint("US169",39.733495,-94.801154),
new Waypoint("AgeRd",39.733726,-94.824586),
new Waypoint("MO371",39.734353,-94.833984),
new Waypoint("US36",39.749186,-94.848608),
new Waypoint("EdmSt",39.765863,-94.848833),
new Waypoint("FarSt",39.769162,-94.846773),
new Waypoint("22ndAve",39.775363,-94.834199),
new Waypoint("NoyBlvd",39.776781,-94.824929),
new Waypoint("US169_S",39.777012,-94.803214),
new Waypoint("GenFieRd",39.792051,-94.810596),
new Waypoint("US169_N",39.802865,-94.815102),
new Waypoint("US59_S",39.831708,-94.816089),
new Waypoint("I-29_N",39.858035,-94.810295),
new Waypoint("I-35_S",39.731614,-94.220595),
new Waypoint("US69_S",39.731812,-94.236002),
new Waypoint("ProSt",39.739006,-94.236002),
new Waypoint("GraAve",39.748609,-94.235101),
new Waypoint("US36_W",39.754482,-94.234371),
new Waypoint("I-35_N",39.753657,-94.219608),
new Waypoint("I-44_W",37.036304,-94.51448),
new Waypoint("32ndSt",37.054937,-94.514523),
new Waypoint("20thSt",37.069389,-94.513793),
new Waypoint("MO43/66",37.083941,-94.513149),
new Waypoint("StLouAve",37.083769,-94.494696),
new Waypoint("US71Bus",37.08424,-94.477272),
new Waypoint("DuqRd",37.083735,-94.458776),
new Waypoint("MO249",37.083307,-94.425087),
new Waypoint("I-44_E",37.081777,-94.365922),
new Waypoint("I-44_W",37.086106,-93.848383),
new Waypoint("MO39_N",37.0938,-93.82616),
new Waypoint("MO39Bus",37.094519,-93.819122),
new Waypoint("I-44_E",37.093218,-93.803544),
new Waypoint("I-44(253)",38.483863,-90.822644),
new Waypoint("MO100_W",38.482956,-90.822633),
new Waypoint("+X68",38.487136,-90.787028),
new Waypoint("I-44(256)",38.484408,-90.768292),
new Waypoint("I-44(257)",38.484753,-90.759516),
new Waypoint("1stSt",38.484199,-90.741448),
new Waypoint("+X69",38.480402,-90.71154),
new Waypoint("HilDr",38.484635,-90.703382),
new Waypoint("I-44(261)",38.505695,-90.677247),
new Waypoint("I-44_W",37.943961,-91.792316),
new Waypoint("MarSprDr",37.943518,-91.791054),
new Waypoint("MO72",37.943058,-91.788262),
new Waypoint("US63_S",37.947159,-91.777414),
new Waypoint("10thSt",37.951471,-91.777149),
new Waypoint("UniDr",37.955154,-91.777112),
new Waypoint("US66HisRol",37.959433,-91.770771),
new Waypoint("I-44_E",37.961482,-91.765768),
new Waypoint("I-44_W",37.079661,-94.166865),
new Waypoint("OldUS66_W",37.072574,-94.167166),
new Waypoint("MO37_S",37.071444,-94.125924),
new Waypoint("5thSt",37.07117,-94.115539),
new Waypoint("I-44_E",37.078223,-94.104853),
new Waypoint("I-44_W",37.21249,-93.384862),
new Waypoint("US160",37.212216,-93.348727),
new Waypoint("SceAve",37.212011,-93.330145),
new Waypoint("MO13",37.214267,-93.31212),
new Waypoint("CamAve",37.215395,-93.293667),
new Waypoint("JefAve",37.215292,-93.289161),
new Waypoint("NatAve",37.214745,-93.275299),
new Waypoint("US65Bus",37.214626,-93.261727),
new Waypoint("DivSt",37.225442,-93.261008),
new Waypoint("MO744",37.240032,-93.260665),
new Waypoint("I-44_E",37.250349,-93.262682),
new Waypoint("I-44_W",37.804528,-92.221856),
new Waypoint("MO17_S",37.813344,-92.223487),
new Waypoint("RepRd",37.826565,-92.209024),
new Waypoint("MO17_N",37.828633,-92.199669),
new Waypoint("ChiSt",37.828463,-92.180057),
new Waypoint("I-44(159)",37.824769,-92.167268),
new Waypoint("I-44BS_S",37.821752,-92.142849),
new Waypoint("I-44_E",37.823447,-92.143493),
new Waypoint("I-44BL_W",37.821752,-92.142849),
new Waypoint("TexRd",37.81531,-92.141905),
new Waypoint("MarDr",37.807733,-92.143557),
new Waypoint("GatCir",37.795085,-92.135382),
new Waypoint("I-49_S",38.239958,-94.352249),
new Waypoint("MO52_W",38.256852,-94.343269),
new Waypoint("MOsH",38.264097,-94.343162),
new Waypoint("MOsTT",38.293078,-94.343408),
new Waypoint("I-49_N",38.322038,-94.343462),
new Waypoint("I-49_S",36.967689,-94.429808),
new Waypoint("FolRd",36.96949,-94.444753),
new Waypoint("+X01",36.97679,-94.46225),
new Waypoint("+X02",36.99203,-94.46483),
new Waypoint("CedDr",37.004086,-94.476746),
new Waypoint("SagRd",37.032432,-94.479042),
new Waypoint("44thSt",37.040714,-94.478817),
new Waypoint("I-44",37.046554,-94.478624),
new Waypoint("MOsFF",37.055083,-94.478366),
new Waypoint("E20thSt",37.069398,-94.477873),
new Waypoint("I-44BL",37.08424,-94.477272),
new Waypoint("ZoraSt",37.112916,-94.47607),
new Waypoint("MO171_N",37.141136,-94.474708),
new Waypoint("MOsD",37.141307,-94.463196),
new Waypoint("MO249",37.139793,-94.440858),
new Waypoint("MOsHH",37.147695,-94.430891),
new Waypoint("OldMO66",37.169901,-94.391935),
new Waypoint("MO96_W",37.180433,-94.362699),
new Waypoint("I-49_N",37.178894,-94.333506),
new Waypoint("I-49_S",36.788941,-94.421611),
new Waypoint("MO59_S",36.788151,-94.399059),
new Waypoint("QuiRd",36.802559,-94.395926),
new Waypoint("MOsD",36.823714,-94.394628),
new Waypoint("US60/59",36.841627,-94.391838),
new Waypoint("US60Bus_E",36.845577,-94.390433),
new Waypoint("MO86_E",36.868249,-94.389253),
new Waypoint("BaxSt",36.879741,-94.398125),
new Waypoint("MO175",36.880307,-94.412041),
new Waypoint("I-49_N",36.880582,-94.431052),
new Waypoint("I-49_S",37.836115,-94.320556),
new Waypoint("US54_E",37.836751,-94.341327),
new Waypoint("US54_W",37.836971,-94.350328),
new Waypoint("HicSt",37.842504,-94.349406),
new Waypoint("AtlAve",37.850645,-94.345071),
new Waypoint("I-49_N",37.852755,-94.344546),
new Waypoint("I-55_S",37.260238,-89.567349),
new Waypoint("SilSprRd",37.269511,-89.563293),
new Waypoint("SouExpy",37.280575,-89.556813),
new Waypoint("MO34/74",37.290238,-89.55514),
new Waypoint("MOsK",37.303313,-89.552093),
new Waypoint("BroSt",37.3131,-89.5524),
new Waypoint("LexAve",37.332051,-89.571791),
new Waypoint("I-55(99)",37.34894,-89.601531),
new Waypoint("ShaBlvd",37.373517,-89.652493),
new Waypoint("MO25/34",37.376961,-89.667277),
new Waypoint("MainSt_Jac",37.382332,-89.666462),
new Waypoint("IndSt",37.392289,-89.666634),
new Waypoint("I-55_N",37.428758,-89.639643),
new Waypoint("I-55_S",36.57232,-89.577069),
new Waypoint("OldKinHwy",36.58128,-89.555097),
new Waypoint("ScoSt",36.588655,-89.544175),
new Waypoint("DawRd",36.598613,-89.537029),
new Waypoint("I-55_N",36.635952,-89.544883),
new Waypoint("I-57_S",36.905843,-89.351892),
new Waypoint("US62_W",36.920872,-89.349747),
new Waypoint("I-57_N",36.920803,-89.318204),
new Waypoint("I-70_W",38.935612,-92.775893),
new Waypoint("LogLkRd",38.950699,-92.766666),
new Waypoint("US40_W",38.967951,-92.741175),
new Waypoint("MainSt_S",38.966483,-92.74066),
new Waypoint("MO98",38.956105,-92.714224),
new Waypoint("I-70_E",38.9376,-92.691087),
new Waypoint("I-70_W",38.966318,-92.351845),
new Waypoint("MO163",38.964614,-92.333565),
new Waypoint("MO763_N",38.964014,-92.324381),
new Waypoint("MO763_S",38.963914,-92.320862),
new Waypoint("ParRd",38.963847,-92.311249),
new Waypoint("I-70_E",38.964681,-92.301335),
new Waypoint("I-70_W",38.77677,-90.51168),
new Waypoint("ClaySt",38.782842,-90.504835),
new Waypoint("KinHwy",38.784749,-90.498054),
new Waypoint("MO94_E",38.781153,-90.486917),
new Waypoint("BooRd",38.77309,-90.491681),
new Waypoint("I-70_E",38.768667,-90.494476)
];
traveler = 'terescoj';
segments = [
503923,
503924,
503925,
503926,
503927,
503928,
503929,
503930,
503931,
503932,
503933,
503934,
503935,
503986,
503987,
503988,
503989,
503990,
504162,
504163,
504164,
504165,
504166,
504167,
504168,
504169,
504174,
504175,
504176,
504204,
504205,
504206,
504207,
504208,
504209,
504210,
504211,
504197,
504198,
504199,
504200,
504201,
504202,
504203,
504170,
504171,
504172,
504173,
504177,
504178,
504179,
504180,
504181,
504182,
504183,
504184,
504185,
504186,
504187,
504188,
504189,
504190,
504191,
504192,
504193,
504194,
504195,
504196,
504262,
504263,
504264,
504265,
504239,
504240,
504241,
504242,
504243,
504244,
504245,
504246,
504247,
504248,
504249,
504250,
504251,
504252,
504253,
504254,
504255,
504256,
504230,
504231,
504232,
504233,
504234,
504235,
504236,
504237,
504238,
504257,
504258,
504259,
504260,
504261,
504270,
504271,
504272,
504273,
504274,
504275,
504276,
504277,
504278,
504279,
504280,
504281,
504266,
504267,
504268,
504269,
504313,
504314,
504402,
504403,
504404,
504405,
504406,
504407,
504408,
504409,
504410,
504411,
504412,
504413,
504414,
504415,
504416
];
clinched = [
503932,
503933,
503935,
503990,
504165,
504166,
504167,
504168,
504169,
504266,
504267,
504268,
504269,
504407,
504408,
504410,
504411
];
mapClinched = true;
mapStatus = mapStates.MAPVIEW;
genEdges = true;
}