<!-- /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: "twn.f001", tier: 1, color: "TMblue", system: "twnf", label: "TWN F1" };
routeInfo[1] = { firstWaypoint: 107, root: "twn.f002", tier: 1, color: "TMblue", system: "twnf", label: "TWN F2" };
routeInfo[2] = { firstWaypoint: 116, root: "twn.f003", tier: 1, color: "TMblue", system: "twnf", label: "TWN F3" };
routeInfo[3] = { firstWaypoint: 226, root: "twn.f003a", tier: 1, color: "TMblue", system: "twnf", label: "TWN F3A" };
routeInfo[4] = { firstWaypoint: 230, root: "twn.f004", tier: 1, color: "TMblue", system: "twnf", label: "TWN F4" };
routeInfo[5] = { firstWaypoint: 236, root: "twn.f005", tier: 1, color: "TMblue", system: "twnf", label: "TWN F5" };
routeInfo[6] = { firstWaypoint: 247, root: "twn.f006", tier: 1, color: "TMblue", system: "twnf", label: "TWN F6" };
routeInfo[7] = { firstWaypoint: 260, root: "twn.f008", tier: 1, color: "TMblue", system: "twnf", label: "TWN F8" };
routeInfo[8] = { firstWaypoint: 266, root: "twn.f010", tier: 1, color: "TMblue", system: "twnf", label: "TWN F10" };
waypoints = [
new Waypoint("PH2",25.128278,121.739212),
new Waypoint("AiyiRd",25.127384,121.738611),
new Waypoint("0",25.122032,121.735232),
new Waypoint("1",25.114707,121.728065),
new Waypoint("2",25.105147,121.723774),
new Waypoint("5",25.096015,121.697853),
new Waypoint("6",25.086726,121.686866),
new Waypoint("10",25.074249,121.6541),
new Waypoint("11",25.072694,121.645646),
new Waypoint("+12",25.066086,121.618491),
new Waypoint("15",25.065279,121.610949),
new Waypoint("17A",25.063773,121.596336),
new Waypoint("17B",25.064823,121.590478),
new Waypoint("18",25.07077,121.573119),
new Waypoint("20",25.072364,121.558549),
new Waypoint("23",25.073297,121.541834),
new Waypoint("23B",25.072617,121.533337),
new Waypoint("25",25.077942,121.513982),
new Waypoint("26",25.078253,121.50851),
new Waypoint("27",25.075726,121.494498),
new Waypoint("+32",25.074541,121.457977),
new Waypoint("33",25.068788,121.437485),
new Waypoint("+35",25.059244,121.411886),
new Waypoint("41A",25.065231,121.368563),
new Waypoint("41B",25.065114,121.355195),
new Waypoint("+X120190",25.06317,121.337214),
new Waypoint("49",25.037802,121.297581),
new Waypoint("49A",25.032456,121.289599),
new Waypoint("52",25.018807,121.273398),
new Waypoint("57",24.988081,121.237049),
new Waypoint("+59N",24.982868,121.231513),
new Waypoint("+59S",24.969097,121.215441),
new Waypoint("62",24.957075,121.199627),
new Waypoint("65",24.935946,121.189585),
new Waypoint("67",24.924777,121.170917),
new Waypoint("69",24.909287,121.164436),
new Waypoint("+71",24.901579,121.155295),
new Waypoint("83",24.875925,121.029425),
new Waypoint("+X512266",24.858949,121.010671),
new Waypoint("+X539394",24.842632,121.022086),
new Waypoint("91",24.823548,121.017065),
new Waypoint("95Aa",24.797721,121.008418),
new Waypoint("95Ab",24.79029,121.005607),
new Waypoint("95Ba",24.781436,121.003418),
new Waypoint("95Bb",24.775747,121.003547),
new Waypoint("99",24.757432,120.987539),
new Waypoint("+X848760",24.728824,120.959473),
new Waypoint("+X542515",24.721963,120.933251),
new Waypoint("110",24.691281,120.918317),
new Waypoint("+X534393",24.66839,120.885572),
new Waypoint("+X480835",24.636095,120.865917),
new Waypoint("125",24.579793,120.857162),
new Waypoint("132",24.524168,120.820341),
new Waypoint("+X852426",24.49574,120.783777),
new Waypoint("140",24.476095,120.785193),
new Waypoint("+X824938",24.413,120.773907),
new Waypoint("150",24.392638,120.758028),
new Waypoint("160",24.313702,120.702195),
new Waypoint("165",24.270792,120.69284),
new Waypoint("168",24.251856,120.690565),
new Waypoint("+X503572",24.222624,120.681982),
new Waypoint("174",24.205715,120.656662),
new Waypoint("178",24.175416,120.630999),
new Waypoint("181",24.153019,120.619926),
new Waypoint("+X191439",24.114403,120.610828),
new Waypoint("189",24.118868,120.583105),
new Waypoint("192",24.099596,120.554695),
new Waypoint("+X853926",24.090115,120.531435),
new Waypoint("198",24.065901,120.52268),
new Waypoint("207",23.983978,120.507488),
new Waypoint("211",23.953469,120.506416),
new Waypoint("220",23.885759,120.49221),
new Waypoint("230",23.781653,120.475388),
new Waypoint("235",23.735855,120.470409),
new Waypoint("240",23.693184,120.471439),
new Waypoint("243",23.66811,120.456419),
new Waypoint("250",23.612087,120.437107),
new Waypoint("257",23.553503,120.415735),
new Waypoint("264",23.494854,120.391402),
new Waypoint("270",23.444467,120.366898),
new Waypoint("272",23.424582,120.356598),
new Waypoint("+X450195",23.38441,120.354624),
new Waypoint("288",23.30734,120.290766),
new Waypoint("299",23.219183,120.23901),
new Waypoint("303",23.182421,120.235491),
new Waypoint("+X610302",23.15062,120.230856),
new Waypoint("311",23.11747,120.243473),
new Waypoint("315",23.079179,120.252142),
new Waypoint("319",23.041904,120.251284),
new Waypoint("324",22.998664,120.248204),
new Waypoint("327",22.972263,120.24931),
new Waypoint("330",22.942665,120.249395),
new Waypoint("338",22.879497,120.279179),
new Waypoint("342",22.845805,120.295444),
new Waypoint("349",22.787854,120.320635),
new Waypoint("356",22.737319,120.334496),
new Waypoint("356a",22.720932,120.332308),
new Waypoint("362",22.675283,120.32896),
new Waypoint("367Aa",22.637511,120.337179),
new Waypoint("367Ba",22.63051,120.336406),
new Waypoint("367Bb",22.626747,120.336192),
new Waypoint("367Ab",22.623924,120.336299),
new Waypoint("369",22.606226,120.341191),
new Waypoint("370",22.599134,120.341449),
new Waypoint("371",22.595747,120.339196),
new Waypoint("372",22.587525,120.330956),
new Waypoint("PH17",22.584013,120.325994),
new Waypoint("0",25.07009,121.223359),
new Waypoint("1",25.0587,121.213231),
new Waypoint("+X202670",25.040349,121.222587),
new Waypoint("4",25.035139,121.237478),
new Waypoint("8",25.018807,121.273398),
new Waypoint("11",24.998894,121.283355),
new Waypoint("+X560077",24.980534,121.284685),
new Waypoint("18",24.96151,121.324425),
new Waypoint("20",24.939409,121.324897),
new Waypoint("0",25.139846,121.714869),
new Waypoint("2",25.126286,121.697574),
new Waypoint("+X500670",25.101184,121.678648),
new Waypoint("+X958552",25.08898,121.652298),
new Waypoint("10",25.072694,121.645646),
new Waypoint("12",25.055823,121.638007),
new Waypoint("14",25.047153,121.625969),
new Waypoint("14a",25.044995,121.625111),
new Waypoint("16",25.035916,121.620905),
new Waypoint("+X118782",25.02324,121.601658),
new Waypoint("20",25.001928,121.59492),
new Waypoint("+X799439",24.979134,121.583633),
new Waypoint("26",24.972832,121.553078),
new Waypoint("+X964300",24.958437,121.536856),
new Waypoint("31",24.969486,121.524754),
new Waypoint("35",24.98917,121.484585),
new Waypoint("43",24.960226,121.432056),
new Waypoint("46",24.951355,121.393647),
new Waypoint("50",24.938903,121.359959),
new Waypoint("54",24.939409,121.324897),
new Waypoint("62",24.891964,121.264343),
new Waypoint("68",24.861674,121.223059),
new Waypoint("+X909765",24.850849,121.202202),
new Waypoint("+X643889",24.798812,121.193276),
new Waypoint("79",24.801617,121.171432),
new Waypoint("+X270931",24.805279,121.141605),
new Waypoint("+X449089",24.780949,121.117702),
new Waypoint("90",24.766551,121.080837),
new Waypoint("+X963705",24.75712,121.065903),
new Waypoint("+X156125",24.763589,121.041698),
new Waypoint("98",24.757159,121.006036),
new Waypoint("100",24.757432,120.987539),
new Waypoint("103",24.756886,120.956898),
new Waypoint("109",24.736581,120.912395),
new Waypoint("109a",24.732956,120.906644),
new Waypoint("+X870378",24.713036,120.891881),
new Waypoint("115",24.701418,120.866261),
new Waypoint("+X407108",24.689799,120.851369),
new Waypoint("119",24.6758,120.847206),
new Waypoint("124",24.636563,120.817981),
new Waypoint("+X699118",24.613663,120.808067),
new Waypoint("130",24.598095,120.785923),
new Waypoint("144",24.497224,120.705242),
new Waypoint("+X211477",24.462776,120.679321),
new Waypoint("+X649035",24.430115,120.683098),
new Waypoint("156",24.396664,120.669408),
new Waypoint("+X959157",24.347957,120.657606),
new Waypoint("164",24.337087,120.643015),
new Waypoint("169",24.307601,120.613489),
new Waypoint("+X971644",24.269971,120.59113),
new Waypoint("176",24.250056,120.590272),
new Waypoint("+X588024",24.237338,120.593834),
new Waypoint("182",24.19499,120.572205),
new Waypoint("+X541397",24.154585,120.521693),
new Waypoint("191",24.140018,120.520878),
new Waypoint("196",24.107117,120.554523),
new Waypoint("202",24.091996,120.60379),
new Waypoint("207",24.068487,120.646105),
new Waypoint("209",24.065353,120.66267),
new Waypoint("211",24.05148,120.678377),
new Waypoint("214",24.027573,120.668936),
new Waypoint("217",24.005503,120.652413),
new Waypoint("222",23.958529,120.654988),
new Waypoint("224",23.948685,120.669107),
new Waypoint("228",23.923277,120.683355),
new Waypoint("+X637699",23.896354,120.710735),
new Waypoint("237",23.852401,120.702581),
new Waypoint("243",23.795986,120.701937),
new Waypoint("+X319023",23.779533,120.700092),
new Waypoint("250",23.774427,120.659237),
new Waypoint("+X606853",23.774113,120.612631),
new Waypoint("+X996920",23.746461,120.592461),
new Waypoint("260",23.732948,120.595293),
new Waypoint("+X428309",23.700611,120.602846),
new Waypoint("269a",23.670271,120.577977),
new Waypoint("269",23.66528,120.574136),
new Waypoint("271",23.646451,120.572977),
new Waypoint("+X711536",23.628405,120.567656),
new Waypoint("279",23.595531,120.522895),
new Waypoint("290",23.5201,120.484722),
new Waypoint("290a",23.503355,120.491395),
new Waypoint("+X530180",23.474505,120.500407),
new Waypoint("297",23.450688,120.484786),
new Waypoint("300",23.429308,120.468779),
new Waypoint("+X268220",23.397015,120.43097),
new Waypoint("311",23.34726,120.439339),
new Waypoint("+X328822",23.307734,120.423288),
new Waypoint("322",23.271036,120.378699),
new Waypoint("329",23.212675,120.355997),
new Waypoint("334",23.166561,120.352135),
new Waypoint("340",23.123785,120.331535),
new Waypoint("347",23.064412,120.323725),
new Waypoint("357",22.976965,120.324411),
new Waypoint("+X652475",22.951913,120.353937),
new Waypoint("+X104913",22.914128,120.349474),
new Waypoint("369",22.880525,120.360589),
new Waypoint("+X916656",22.843037,120.387239),
new Waypoint("+X777723",22.82334,120.418396),
new Waypoint("383",22.784886,120.426035),
new Waypoint("+X263902",22.773095,120.433674),
new Waypoint("391",22.753625,120.491481),
new Waypoint("400",22.696348,120.555403),
new Waypoint("+X403679",22.677223,120.562849),
new Waypoint("407",22.638531,120.537744),
new Waypoint("415",22.571457,120.528088),
new Waypoint("+X572945",22.540702,120.518646),
new Waypoint("421",22.510258,120.524805),
new Waypoint("424",22.490731,120.529847),
new Waypoint("+X618593",22.468068,120.528603),
new Waypoint("430",22.445372,120.505847),
new Waypoint("0",25.01694,121.549001),
new Waypoint("3",25.004534,121.580544),
new Waypoint("5",25.001928,121.59492),
new Waypoint("6",25.002044,121.600199),
new Waypoint("0",24.304394,120.592504),
new Waypoint("2",24.307601,120.613489),
new Waypoint("9",24.27799,120.669494),
new Waypoint("11",24.270792,120.69284),
new Waypoint("14",24.277873,120.722322),
new Waypoint("17",24.268523,120.749617),
new Waypoint("0",25.035916,121.620905),
new Waypoint("4",25.008656,121.647491),
new Waypoint("+X537637",24.954935,121.689677),
new Waypoint("15",24.941763,121.712509),
new Waypoint("+X828249",24.859727,121.788683),
new Waypoint("30",24.82791,121.789842),
new Waypoint("38",24.782001,121.778126),
new Waypoint("38a",24.738627,121.78143),
new Waypoint("47",24.694614,121.790786),
new Waypoint("47a",24.680031,121.793393),
new Waypoint("54",24.621466,121.811342),
new Waypoint("0",24.027573,120.668936),
new Waypoint("3",24.012912,120.695779),
new Waypoint("5",24.006679,120.71846),
new Waypoint("+X484006",23.98241,120.766611),
new Waypoint("+X102144",23.987899,120.796223),
new Waypoint("17",24.004444,120.812101),
new Waypoint("+X131929",23.998799,120.845833),
new Waypoint("+X449996",23.977391,120.869951),
new Waypoint("25",23.979548,120.882311),
new Waypoint("29",23.981077,120.926085),
new Waypoint("+X250560",23.990801,120.946083),
new Waypoint("34",23.987664,120.973721),
new Waypoint("37",23.978744,120.992475),
new Waypoint("0",23.080284,120.195236),
new Waypoint("2",23.08968,120.210085),
new Waypoint("6",23.079179,120.252142),
new Waypoint("9",23.063623,120.279007),
new Waypoint("14",23.064412,120.323725),
new Waypoint("15",23.061254,120.331836),
new Waypoint("0",22.680351,120.311537),
new Waypoint("1",22.675283,120.32896),
new Waypoint("+X507477",22.687875,120.355697),
new Waypoint("7",22.703771,120.35987),
new Waypoint("13",22.755921,120.370674),
new Waypoint("19",22.784886,120.426035),
new Waypoint("22",22.797428,120.453973),
new Waypoint("25",22.800316,120.474658),
new Waypoint("+X112788",22.839794,120.495644),
new Waypoint("33",22.869097,120.494957)
];
traveler = 'nagamasa';
segments = [
475965,
475966,
475967,
475968,
475969,
475970,
475971,
475972,
475973,
475974,
475975,
475976,
475977,
475978,
475979,
475980,
475981,
475982,
475983,
475984,
475985,
475986,
475987,
475988,
475989,
475990,
475991,
475992,
475993,
475994,
475995,
475996,
475997,
475998,
475999,
476000,
476001,
476002,
476003,
476004,
476005,
476006,
476007,
476008,
476009,
476010,
476011,
476012,
476013,
476014,
476015,
476016,
476017,
476018,
476019,
476020,
476021,
476022,
476023,
476024,
476025,
476026,
476027,
476028,
476029,
476030,
476031,
476032,
476033,
476034,
476035,
476036,
476037,
476038,
476039,
476040,
476041,
476042,
476043,
476044,
476045,
476046,
476047,
476048,
476049,
476050,
476051,
476052,
476053,
476054,
476055,
476056,
476057,
476058,
476059,
476060,
476061,
476062,
476063,
476064,
476065,
476066,
476067,
476068,
476069,
476070,
476071,
476072,
476073,
476074,
476075,
476076,
476077,
476078,
476079,
476080,
476081,
476082,
476083,
476084,
476085,
476086,
476087,
476088,
476089,
476090,
476091,
476092,
476093,
476094,
476095,
476096,
476097,
476098,
476099,
476100,
476101,
476102,
476103,
476104,
476105,
476106,
476107,
476108,
476109,
476110,
476111,
476112,
476113,
476114,
476115,
476116,
476117,
476118,
476119,
476120,
476121,
476122,
476123,
476124,
476125,
476126,
476127,
476128,
476129,
476130,
476131,
476132,
476133,
476134,
476135,
476136,
476137,
476138,
476139,
476140,
476141,
476142,
476143,
476144,
476145,
476146,
476147,
476148,
476149,
476150,
476151,
476152,
476153,
476154,
476155,
476156,
476157,
476158,
476159,
476160,
476161,
476162,
476163,
476164,
476165,
476166,
476167,
476168,
476169,
476170,
476171,
476172,
476173,
476174,
476175,
476176,
476177,
476178,
476179,
476180,
476181,
476182,
476183,
476184,
476185,
476186,
476187,
476188,
476189,
476190,
476191,
476192,
476193,
476194,
476195,
476196,
476197,
476198,
476199,
476200,
476201,
476202,
476203,
476204,
476205,
476206,
476207,
476208,
476209,
476210,
476211,
476212,
476213,
476214,
476215,
476216,
476217,
476218,
476219,
476220,
476221,
476222,
476223,
476224,
476225,
476226,
476227,
476228,
476229,
476230,
476231
];
clinched = [
475969,
475970,
475971,
475972,
475973,
475974,
475975,
475976,
475977,
475984,
475985,
475986,
475987,
475988,
475989,
475990,
475991,
475992,
476071,
476072,
476073,
476074,
476083,
476084
];
mapClinched = true;
mapStatus = mapStates.MAPVIEW;
genEdges = true;
}