<!-- /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: "sgp.aye", tier: 1, color: "TMblue", system: "sgpex", label: "SGP AYE" };
routeInfo[1] = { firstWaypoint: 20, root: "sgp.bke", tier: 1, color: "TMblue", system: "sgpex", label: "SGP BKE" };
routeInfo[2] = { firstWaypoint: 28, root: "sgp.cte", tier: 1, color: "TMblue", system: "sgpex", label: "SGP CTE" };
routeInfo[3] = { firstWaypoint: 44, root: "sgp.ecp", tier: 1, color: "TMblue", system: "sgpex", label: "SGP ECP" };
routeInfo[4] = { firstWaypoint: 55, root: "sgp.kje", tier: 1, color: "TMblue", system: "sgpex", label: "SGP KJE" };
routeInfo[5] = { firstWaypoint: 62, root: "sgp.kpe", tier: 1, color: "TMblue", system: "sgpex", label: "SGP KPE" };
routeInfo[6] = { firstWaypoint: 71, root: "sgp.mce", tier: 1, color: "TMblue", system: "sgpex", label: "SGP MCE" };
routeInfo[7] = { firstWaypoint: 76, root: "sgp.pie", tier: 1, color: "TMblue", system: "sgpex", label: "SGP PIE" };
routeInfo[8] = { firstWaypoint: 109, root: "sgp.sle", tier: 1, color: "TMblue", system: "sgpex", label: "SGP SLE" };
routeInfo[9] = { firstWaypoint: 116, root: "sgp.tpe", tier: 1, color: "TMblue", system: "sgpex", label: "SGP TPE" };
waypoints = [
new Waypoint("1",1.273494,103.852108),
new Waypoint("2",1.272443,103.832238),
new Waypoint("2C",1.27802,103.825049),
new Waypoint("3",1.278642,103.823762),
new Waypoint("6",1.284048,103.801553),
new Waypoint("7",1.289197,103.79297),
new Waypoint("8",1.294281,103.785932),
new Waypoint("9",1.304128,103.771191),
new Waypoint("10",1.308461,103.765912),
new Waypoint("11",1.31436,103.760419),
new Waypoint("13",1.323327,103.745699),
new Waypoint("14",1.327189,103.73791),
new Waypoint("15",1.32352,103.719606),
new Waypoint("17",1.321504,103.710058),
new Waypoint("18",1.322684,103.696454),
new Waypoint("20",1.322727,103.679159),
new Waypoint("22",1.322812,103.663495),
new Waypoint("24",1.338976,103.64665),
new Waypoint("26",1.345637,103.639516),
new Waypoint("SGP/MYS",1.349777,103.634377),
new Waypoint("1",1.349284,103.791618),
new Waypoint("2",1.365351,103.779602),
new Waypoint("3",1.375519,103.77707),
new Waypoint("4",1.390278,103.774452),
new Waypoint("7",1.409927,103.771706),
new Waypoint("8",1.420653,103.771319),
new Waypoint("10A",1.431528,103.768916),
new Waypoint("10B",1.440044,103.768423),
new Waypoint("AYE",1.27802,103.825049),
new Waypoint("1A",1.279007,103.829019),
new Waypoint("1B",1.283217,103.835923),
new Waypoint("2",1.289106,103.84198),
new Waypoint("4",1.300974,103.843267),
new Waypoint("5",1.306444,103.840263),
new Waypoint("6",1.310477,103.844233),
new Waypoint("7",1.319444,103.853331),
new Waypoint("7B",1.324614,103.859146),
new Waypoint("8",1.330417,103.862364),
new Waypoint("10",1.343449,103.860412),
new Waypoint("11",1.355526,103.856893),
new Waypoint("12",1.369513,103.860884),
new Waypoint("14",1.376463,103.858566),
new Waypoint("15",1.391157,103.858073),
new Waypoint("SLE/TPE",1.398944,103.855991),
new Waypoint("1",1.336949,103.979888),
new Waypoint("2",1.325086,103.97212),
new Waypoint("7A",1.310842,103.940878),
new Waypoint("7B",1.309147,103.934999),
new Waypoint("8A",1.306937,103.928154),
new Waypoint("8B",1.3046,103.921394),
new Waypoint("10",1.301532,103.910601),
new Waypoint("11",1.297435,103.898242),
new Waypoint("13",1.295804,103.885335),
new Waypoint("14",1.295483,103.876247),
new Waypoint("15",1.292983,103.862321),
new Waypoint("1",1.390278,103.774452),
new Waypoint("1A",1.39061,103.764367),
new Waypoint("2",1.388733,103.755183),
new Waypoint("3",1.389377,103.745613),
new Waypoint("4",1.38662,103.74159),
new Waypoint("5",1.378909,103.732717),
new Waypoint("7",1.36386,103.707204),
new Waypoint("1",1.295483,103.876247),
new Waypoint("2A",1.307206,103.876634),
new Waypoint("2C",1.31318,103.875014),
new Waypoint("3",1.320024,103.876215),
new Waypoint("5",1.333066,103.889015),
new Waypoint("6",1.340317,103.897984),
new Waypoint("9",1.363142,103.905237),
new Waypoint("10",1.376034,103.910086),
new Waypoint("11",1.382427,103.917489),
new Waypoint("1",1.273494,103.852108),
new Waypoint("2",1.272732,103.863212),
new Waypoint("3",1.273826,103.864864),
new Waypoint("+X01",1.284134,103.878136),
new Waypoint("5",1.295483,103.876247),
new Waypoint("1",1.336949,103.979888),
new Waypoint("1A",1.342462,103.969889),
new Waypoint("2",1.349799,103.963902),
new Waypoint("3",1.349649,103.956628),
new Waypoint("4",1.341497,103.946929),
new Waypoint("6",1.335297,103.933604),
new Waypoint("8",1.33238,103.919592),
new Waypoint("9",1.326202,103.905816),
new Waypoint("11",1.322941,103.89101),
new Waypoint("13",1.320024,103.876215),
new Waypoint("15A",1.328207,103.868276),
new Waypoint("15B",1.330417,103.862364),
new Waypoint("16",1.329098,103.855712),
new Waypoint("17",1.329806,103.845949),
new Waypoint("17C",1.328905,103.840542),
new Waypoint("18",1.326062,103.833804),
new Waypoint("19",1.326588,103.826809),
new Waypoint("20",1.332487,103.816445),
new Waypoint("22",1.339094,103.80651),
new Waypoint("24",1.349284,103.791618),
new Waypoint("26A",1.342462,103.781962),
new Waypoint("26B",1.338118,103.777628),
new Waypoint("27",1.332852,103.764474),
new Waypoint("28",1.335394,103.759743),
new Waypoint("30",1.341626,103.748757),
new Waypoint("31",1.345959,103.737266),
new Waypoint("32",1.353499,103.72835),
new Waypoint("34",1.355859,103.71745),
new Waypoint("35",1.36386,103.707204),
new Waypoint("36",1.355033,103.697848),
new Waypoint("38",1.34612,103.690542),
new Waypoint("40",1.330975,103.674803),
new Waypoint("41",1.322812,103.663495),
new Waypoint("1",1.398944,103.855991),
new Waypoint("3",1.394268,103.833761),
new Waypoint("5",1.394353,103.818913),
new Waypoint("8",1.41426,103.80578),
new Waypoint("9",1.42254,103.795052),
new Waypoint("10",1.426359,103.786383),
new Waypoint("11",1.420653,103.771319),
new Waypoint("1",1.349799,103.963902),
new Waypoint("2",1.360203,103.961112),
new Waypoint("3",1.367217,103.94635),
new Waypoint("4",1.371851,103.939633),
new Waypoint("5",1.37582,103.931952),
new Waypoint("6",1.382427,103.917489),
new Waypoint("9",1.396928,103.903606),
new Waypoint("10",1.399974,103.895946),
new Waypoint("11",1.40139,103.882749),
new Waypoint("12",1.401111,103.872299),
new Waypoint("14",1.398944,103.855991)
];
traveler = 'nagamasa';
segments = [
451665,
451666,
451667,
451668,
451669,
451670,
451671,
451672,
451673,
451674,
451675,
451676,
451677,
451678,
451679,
451680,
451681,
451682,
451683,
451684,
451685,
451686,
451687,
451688,
451689,
451690,
451691,
451692,
451693,
451694,
451695,
451696,
451697,
451698,
451699,
451700,
451701,
451702,
451703,
451704,
451705,
451706,
451707,
451708,
451709,
451710,
451711,
451712,
451713,
451714,
451715,
451724,
451725,
451726,
451727,
451728,
451729,
451716,
451717,
451718,
451719,
451720,
451721,
451722,
451723,
451730,
451731,
451732,
451733,
451734,
451735,
451736,
451737,
451738,
451739,
451740,
451741,
451742,
451743,
451744,
451745,
451746,
451747,
451748,
451749,
451750,
451751,
451752,
451753,
451754,
451755,
451756,
451757,
451758,
451759,
451760,
451761,
451762,
451763,
451764,
451765,
451766,
451767,
451768,
451769,
451770,
451771,
451772,
451773,
451774,
451775,
451776,
451777,
451778,
451779,
451780,
451781
];
clinched = [
451706,
451707,
451708,
451709,
451710,
451711,
451712,
451713,
451714,
451715
];
mapClinched = true;
mapStatus = mapStates.MAPVIEW;
genEdges = true;
}