<!-- /lib/tmphpfuncs.php: common PHP functionality for Travel Mapping -->
<!-- mysqli connecting to database TravelMapping on 127.0.0.1 -->
<!-- /lib/tmphpfuncs.php END -->

function waypointsFromSQL() {
    routeInfo[0] = { firstWaypoint: 0, root: "tha.m0007", tier: 1, color: "TMblue", system: "tham", label: "THA M7" };
routeInfo[1] = { firstWaypoint: 56, root: "tha.m0007ban", tier: 1, color: "TMblue", system: "tham", label: "THA M7Ban" };
routeInfo[2] = { firstWaypoint: 58, root: "tha.m0007cho", tier: 1, color: "TMblue", system: "tham", label: "THA M7Cho" };
routeInfo[3] = { firstWaypoint: 60, root: "tha.m0007jom", tier: 1, color: "TMblue", system: "tham", label: "THA M7Jom" };
routeInfo[4] = { firstWaypoint: 65, root: "tha.m0007lae", tier: 1, color: "TMblue", system: "tham", label: "THA M7Lae" };
routeInfo[5] = { firstWaypoint: 74, root: "tha.m0007pat", tier: 1, color: "TMblue", system: "tham", label: "THA M7Pat" };
routeInfo[6] = { firstWaypoint: 80, root: "tha.m0009", tier: 1, color: "TMblue", system: "tham", label: "THA M9" };
routeInfo[7] = { firstWaypoint: 192, root: "tha.m0081", tier: 1, color: "TMblue", system: "tham", label: "THA M81" };
waypoints = [
new Waypoint("1",13.741303,100.642447),
new Waypoint("KTKriRd",13.739414,100.651562),
new Waypoint("+X818735",13.737608,100.658857),
new Waypoint("+X937284",13.736795,100.668127),
new Waypoint("+X894762",13.735482,100.676624),
new Waypoint("2",13.732621,100.702765),
new Waypoint("+X589498",13.72927,100.733519),
new Waypoint("3",13.729557,100.746517),
new Waypoint("4",13.730281,100.759349),
new Waypoint("+X921298",13.731694,100.765137),
new Waypoint("+X855156",13.73222,100.784122),
new Waypoint("KMITLad",13.733231,100.793204),
new Waypoint("+X782083",13.734164,100.803037),
new Waypoint("+X499412",13.733049,100.807103),
new Waypoint("+X877085",13.730089,100.810257),
new Waypoint("5",13.71108,100.819658),
new Waypoint("+X363818",13.675053,100.837476),
new Waypoint("+X801880",13.672707,100.839558),
new Waypoint("6",13.59924,100.95401),
new Waypoint("+X885292",13.592892,100.963647),
new Waypoint("7",13.557566,100.993449),
new Waypoint("+X948129",13.495586,101.045551),
new Waypoint("+X710420",13.491684,101.046828),
new Waypoint("+X350606",13.473197,101.046023),
new Waypoint("+X261013",13.440913,101.046206),
new Waypoint("8",13.407287,101.04722),
new Waypoint("+X201429",13.396884,101.047311),
new Waypoint("+X696977",13.386384,101.045905),
new Waypoint("+X781774",13.361427,101.038073),
new Waypoint("9",13.346171,101.028847),
new Waypoint("+X618182",13.326325,101.016337),
new Waypoint("10",13.300365,100.995904),
new Waypoint("+X654840",13.29396,100.992712),
new Waypoint("+X405164",13.288707,100.991392),
new Waypoint("+X635304",13.263255,100.989729),
new Waypoint("+X357346",13.258352,100.990217),
new Waypoint("+X821511",13.219603,101.004913),
new Waypoint("+X313211",13.215219,101.005586),
new Waypoint("+X787781",13.210466,101.005039),
new Waypoint("+X508102",13.153028,100.986435),
new Waypoint("+X895758",13.150542,100.986038),
new Waypoint("11",13.118121,100.985102),
new Waypoint("+X500452",13.064617,100.995952),
new Waypoint("+X774278",13.013077,100.996381),
new Waypoint("+X621507",13.009816,100.995812),
new Waypoint("+X601656",12.969117,100.981511),
new Waypoint("12",12.96561,100.979961),
new Waypoint("+X751622",12.954929,100.97296),
new Waypoint("13",12.950057,100.958959),
new Waypoint("+X904023",12.90755,100.952682),
new Waypoint("+X831816",12.873204,100.980384),
new Waypoint("14",12.850141,100.982369),
new Waypoint("+X117192",12.791484,100.980406),
new Waypoint("15",12.756181,101.000351),
new Waypoint("+X569096",12.718989,101.020414),
new Waypoint("16",12.712748,101.031507),
new Waypoint("M7",13.59924,100.95401),
new Waypoint("Thl34",13.564285,100.9486),
new Waypoint("M7",13.300365,100.995904),
new Waypoint("Thl361",13.333116,100.988989),
new Waypoint("M7",12.850141,100.982369),
new Waypoint("HuayYai_E",12.839931,100.963894),
new Waypoint("HuayYai_W",12.836966,100.936444),
new Waypoint("M7_U",12.832517,100.921258),
new Waypoint("Thl3",12.830051,100.914263),
new Waypoint("M7",13.118121,100.985102),
new Waypoint("Thl3608_1",13.11613,100.975623),
new Waypoint("Thl3608/3611_2",13.114391,100.96678),
new Waypoint("Thl3608/3611_3",13.111888,100.953777),
new Waypoint("+X331835",13.110206,100.943831),
new Waypoint("+X607650",13.110614,100.933789),
new Waypoint("Thl3608/3611_6",13.109412,100.928553),
new Waypoint("Thl3608/3611_7",13.105828,100.921124),
new Waypoint("Thl3",13.104004,100.915802),
new Waypoint("M7",12.950057,100.958959),
new Waypoint("+X113016",12.951163,100.95456),
new Waypoint("+X603258",12.951217,100.943338),
new Waypoint("Thl3240",12.949252,100.934395),
new Waypoint("KaTingLay",12.944047,100.911427),
new Waypoint("Thl3",12.945108,100.90459),
new Waypoint("1",14.189505,100.63641),
new Waypoint("+M6_E",14.169262,100.648413),
new Waypoint("+X792990",14.086663,100.694402),
new Waypoint("2",14.066997,100.696604),
new Waypoint("+X149146",14.051185,100.698173),
new Waypoint("+X320844",14.023519,100.698452),
new Waypoint("3",14.007689,100.705058),
new Waypoint("+X522204",13.988979,100.713129),
new Waypoint("+X928351",13.950285,100.712609),
new Waypoint("4",13.933724,100.708419),
new Waypoint("+X957178",13.919822,100.704685),
new Waypoint("5",13.898649,100.693882),
new Waypoint("+X563409",13.868111,100.678174),
new Waypoint("+X568272",13.85706,100.675476),
new Waypoint("+X503513",13.850284,100.672901),
new Waypoint("+X749522",13.841257,100.672349),
new Waypoint("+X557056",13.834673,100.673878),
new Waypoint("6",13.827209,100.674328),
new Waypoint("+X190617",13.823813,100.674618),
new Waypoint("7",13.791785,100.683008),
new Waypoint("7C",13.783356,100.685223),
new Waypoint("+X336263",13.778474,100.686961),
new Waypoint("+X280028",13.749379,100.702347),
new Waypoint("8",13.732621,100.702765),
new Waypoint("8B",13.721506,100.700592),
new Waypoint("+X272399",13.701546,100.699718),
new Waypoint("+X645897",13.669241,100.69908),
new Waypoint("+X631812",13.664822,100.697519),
new Waypoint("9",13.647965,100.685513),
new Waypoint("10",13.614389,100.659957),
new Waypoint("+X411478",13.602235,100.651331),
new Waypoint("+X231868",13.600514,100.641568),
new Waypoint("11",13.613429,100.619531),
new Waypoint("12",13.630087,100.588911),
new Waypoint("BhuBrg",13.63849,100.550271),
new Waypoint("13",13.626906,100.523674),
new Waypoint("+X590125",13.621886,100.513229),
new Waypoint("+X204580",13.620103,100.490935),
new Waypoint("+X332932",13.625447,100.47217),
new Waypoint("+X222407",13.627126,100.424641),
new Waypoint("+X890807",13.628606,100.420071),
new Waypoint("+X769447",13.632193,100.416412),
new Waypoint("Thl35",13.642374,100.410565),
new Waypoint("Thl3901/3902_15",13.651038,100.405509),
new Waypoint("+X608331",13.652956,100.404949),
new Waypoint("Thl3902_16",13.655089,100.404986),
new Waypoint("Thl3901/3902_16",13.660088,100.405329),
new Waypoint("Thl3901/3902_17",13.665347,100.405678),
new Waypoint("KanPhrRd",13.682102,100.40681),
new Waypoint("Thl3901/3902_20",13.693665,100.407599),
new Waypoint("Thl3902_21",13.696714,100.407389),
new Waypoint("Thl3901/3902_21",13.703599,100.406606),
new Waypoint("Thl4",13.710541,100.405619),
new Waypoint("Thl3901/3902_23",13.718441,100.405882),
new Waypoint("Thl3902_23",13.720651,100.405877),
new Waypoint("Thl3901/3902_25",13.737806,100.405834),
new Waypoint("Thl3901/3902_26",13.746305,100.405828),
new Waypoint("Thl3901/3902_27",13.755794,100.405936),
new Waypoint("Thl3901/3902_28",13.766423,100.407202),
new Waypoint("Thl3901/3902_29",13.772701,100.407937),
new Waypoint("Thl3901/3902_30",13.776797,100.408446),
new Waypoint("Thl3902_31",13.786748,100.409535),
new Waypoint("Thl3901/3902_31",13.791322,100.409889),
new Waypoint("Thl3901/3902_33",13.811811,100.411574),
new Waypoint("Thl3901/3902_34",13.814613,100.41181),
new Waypoint("Thl3901_34",13.821484,100.4124),
new Waypoint("Thl3901/3902_35",13.828855,100.413065),
new Waypoint("+X417517",13.83559,100.413623),
new Waypoint("Thl3901/3902_37",13.843289,100.412909),
new Waypoint("Thl3901/3902_38",13.848794,100.412303),
new Waypoint("Thl3901_39",13.861107,100.411139),
new Waypoint("Thl3901/3902_41",13.879355,100.409423),
new Waypoint("Thl3901/3902_42",13.886287,100.408768),
new Waypoint("Thl3902_42",13.891867,100.408272),
new Waypoint("+X576784",13.904555,100.407186),
new Waypoint("Thl3901/3902_45",13.91349,100.409755),
new Waypoint("Thl3215",13.92533,100.413333),
new Waypoint("Thl340/345",13.941283,100.41858),
new Waypoint("Thl3901/3902_51",13.962264,100.42955),
new Waypoint("Thl3901/3902_54",13.98672,100.442596),
new Waypoint("Thl3901/3902_55",13.994757,100.446936),
new Waypoint("Thl3901_56",14.002742,100.451217),
new Waypoint("+X322668",14.003835,100.451775),
new Waypoint("+X783179",14.005714,100.45222),
new Waypoint("Thl3901/3902_58",14.021734,100.452043),
new Waypoint("Thl3901/3902_59",14.029328,100.451925),
new Waypoint("+X343906",14.033527,100.451914),
new Waypoint("+X988466",14.035396,100.452332),
new Waypoint("Thl3901/3902_60",14.037165,100.453234),
new Waypoint("Thl346",14.049515,100.460014),
new Waypoint("Thl3901/3902_62",14.05539,100.463217),
new Waypoint("+X154215",14.058179,100.464767),
new Waypoint("+X857771",14.060396,100.467042),
new Waypoint("Thl3901/3902_64",14.064933,100.477985),
new Waypoint("+X192659",14.068446,100.486354),
new Waypoint("Thl3901/3902_65",14.070428,100.489154),
new Waypoint("Thl3901/3902_66",14.078166,100.499325),
new Waypoint("Thl3901/3902_67",14.081397,100.503557),
new Waypoint("Thl3111",14.093031,100.518846),
new Waypoint("+X377367",14.099576,100.527445),
new Waypoint("+X386344",14.102167,100.529752),
new Waypoint("+X706664",14.104998,100.531254),
new Waypoint("Thl3901/3902_72",14.111142,100.533088),
new Waypoint("M9_U73",14.11843,100.535197),
new Waypoint("Thl3309",14.129584,100.538421),
new Waypoint("+X466925",14.141595,100.542932),
new Waypoint("UdonRatExpy",14.148821,100.553902),
new Waypoint("Thl347",14.15666,100.567775),
new Waypoint("+M6_W",14.166729,100.585542),
new Waypoint("M9_U83",14.169517,100.604575),
new Waypoint("+X773056",14.170521,100.615341),
new Waypoint("Thl1/32",14.176144,100.618249),
new Waypoint("5",13.849929,100.004087),
new Waypoint("+X866852",13.853039,99.955888),
new Waypoint("+X370797",13.874955,99.921513),
new Waypoint("+X588522",13.907366,99.902844),
new Waypoint("6",13.942512,99.866774),
new Waypoint("+X913688",13.963326,99.844437),
new Waypoint("7",13.990421,99.765258),
new Waypoint("+X626094",14.000993,99.737556),
new Waypoint("+X360593",14.004408,99.651811),
new Waypoint("8",14.043608,99.603628)
];
traveler = 'nagamasa';
segments = [
1216029,
1216030,
1216031,
1216032,
1216033,
1216034,
1216035,
1216036,
1216037,
1216038,
1216039,
1216040,
1216041,
1216042,
1216043,
1216044,
1216045,
1216046,
1216047,
1216048,
1216049,
1216050,
1216051,
1216052,
1216053,
1216054,
1216055,
1216056,
1216057,
1216058,
1216059,
1216060,
1216061,
1216062,
1216063,
1216064,
1216065,
1216066,
1216067,
1216068,
1216069,
1216070,
1216071,
1216072,
1216073,
1216074,
1216075,
1216076,
1216077,
1216078,
1216079,
1216080,
1216081,
1216082,
1216083,
1216084,
1216085,
1216099,
1216100,
1216101,
1216102,
1216086,
1216087,
1216088,
1216089,
1216090,
1216091,
1216092,
1216093,
1216094,
1216095,
1216096,
1216097,
1216098,
1216103,
1216104,
1216105,
1216106,
1216107,
1216108,
1216109,
1216110,
1216111,
1216112,
1216113,
1216114,
1216115,
1216116,
1216117,
1216118,
1216119,
1216120,
1216121,
1216122,
1216123,
1216124,
1216125,
1216126,
1216127,
1216128,
1216129,
1216130,
1216131,
1216132,
1216133,
1216134,
1216135,
1216136,
1216137,
1216138,
1216139,
1216140,
1216141,
1216142,
1216143,
1216144,
1216145,
1216146,
1216147,
1216148,
1216149,
1216150,
1216151,
1216152,
1216153,
1216154,
1216155,
1216156,
1216157,
1216158,
1216159,
1216160,
1216161,
1216162,
1216163,
1216164,
1216165,
1216166,
1216167,
1216168,
1216169,
1216170,
1216171,
1216172,
1216173,
1216174,
1216175,
1216176,
1216177,
1216178,
1216179,
1216180,
1216181,
1216182,
1216183,
1216184,
1216185,
1216186,
1216187,
1216188,
1216189,
1216190,
1216191,
1216192,
1216193,
1216194,
1216195,
1216196,
1216197,
1216198,
1216199,
1216200,
1216201,
1216202,
1216203,
1216204,
1216205,
1216206,
1216207,
1216208,
1216209,
1216210,
1216211,
1216212,
1216213,
1216214,
1216215,
1216216,
1216217,
1216218,
1216219,
1216220,
1216221,
1216222
];
clinched = [
1216029,
1216030,
1216031,
1216032,
1216033,
1216034,
1216035,
1216036
];
mapClinched = true;
mapStatus = mapStates.MAPVIEW;
genEdges = true;
}