<!-- /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: "mar.a001", tier: 1, color: "TMblue", system: "mara", label: "MAR A1" };
routeInfo[1] = { firstWaypoint: 63, root: "mar.a002", tier: 1, color: "TMblue", system: "mara", label: "MAR A2" };
routeInfo[2] = { firstWaypoint: 143, root: "mar.a003", tier: 1, color: "TMblue", system: "mara", label: "MAR A3" };
routeInfo[3] = { firstWaypoint: 210, root: "mar.a004", tier: 1, color: "TMblue", system: "mara", label: "MAR A4" };
routeInfo[4] = { firstWaypoint: 237, root: "mar.a005", tier: 1, color: "TMblue", system: "mara", label: "MAR A5" };
routeInfo[5] = { firstWaypoint: 296, root: "mar.a007", tier: 1, color: "TMblue", system: "mara", label: "MAR A7" };
routeInfo[6] = { firstWaypoint: 303, root: "mar.a101", tier: 1, color: "TMblue", system: "mara", label: "MAR A101" };
routeInfo[7] = { firstWaypoint: 321, root: "mar.a102", tier: 1, color: "TMblue", system: "mara", label: "MAR A102" };
routeInfo[8] = { firstWaypoint: 323, root: "mar.a103", tier: 1, color: "TMblue", system: "mara", label: "MAR A103" };
routeInfo[9] = { firstWaypoint: 325, root: "mar.a201", tier: 1, color: "TMblue", system: "mara", label: "MAR A201" };
routeInfo[10] = { firstWaypoint: 327, root: "mar.a301", tier: 1, color: "TMblue", system: "mara", label: "MAR A301" };
routeInfo[11] = { firstWaypoint: 330, root: "mar.a501", tier: 1, color: "TMblue", system: "mara", label: "MAR A501" };
waypoints = [
new Waypoint("N1_N",33.966685,-6.887988),
new Waypoint("RocRab",33.949982,-6.917739),
new Waypoint("AveMohVI",33.932821,-6.936922),
new Waypoint("R322",33.892541,-6.993828),
new Waypoint("A5",33.876063,-7.010265),
new Waypoint("P4030",33.855484,-7.046399),
new Waypoint("+X02",33.850851,-7.070904),
new Waypoint("R305",33.800351,-7.159674),
new Waypoint("+X04",33.783178,-7.224412),
new Waypoint("R313",33.716701,-7.333224),
new Waypoint("+X05",33.687139,-7.360969),
new Waypoint("R360",33.662389,-7.404056),
new Waypoint("A101",33.650405,-7.417274),
new Waypoint("+X06",33.570148,-7.460575),
new Waypoint("P3010",33.56314,-7.496538),
new Waypoint("Ave10Mars",33.538318,-7.540226),
new Waypoint("R315",33.528517,-7.566233),
new Waypoint("RouTad",33.509411,-7.61198),
new Waypoint("A3",33.500322,-7.628374),
new Waypoint("+X07",33.493379,-7.663822),
new Waypoint("A102",33.499463,-7.684937),
new Waypoint("+X08",33.43753,-7.759781),
new Waypoint("P3011",33.418404,-7.817631),
new Waypoint("+X09",33.397984,-7.842264),
new Waypoint("+X10",33.38917,-7.878828),
new Waypoint("+X11",33.354549,-7.958221),
new Waypoint("R303",33.34953,-7.999506),
new Waypoint("+X12",33.332608,-8.028431),
new Waypoint("+X13",33.31848,-8.100615),
new Waypoint("+X14",33.301265,-8.127651),
new Waypoint("P3461",33.301982,-8.152714),
new Waypoint("+X15",33.290432,-8.248415),
new Waypoint("+X16",33.280243,-8.276396),
new Waypoint("+X17",33.281606,-8.301458),
new Waypoint("+X18",33.264097,-8.321886),
new Waypoint("P3427",33.257135,-8.346262),
new Waypoint("A103",33.235528,-8.406171),
new Waypoint("+X941648",33.202714,-8.461876),
new Waypoint("N1_S",33.195353,-8.486423),
new Waypoint("+X775892",33.191725,-8.515091),
new Waypoint("+X362840",33.15832,-8.55217),
new Waypoint("R316",33.132736,-8.556976),
new Waypoint("+X265670",33.102615,-8.571138),
new Waypoint("+X314849",33.055436,-8.557062),
new Waypoint("+X696136",33.03673,-8.536549),
new Waypoint("+X955118",33.00888,-8.527879),
new Waypoint("+X648773",32.981236,-8.545389),
new Waypoint("+X707725",32.956321,-8.545475),
new Waypoint("P3416",32.866756,-8.58676),
new Waypoint("+X770994",32.838563,-8.615341),
new Waypoint("+X681690",32.827529,-8.676882),
new Waypoint("+X671763",32.793696,-8.757305),
new Waypoint("+X711253",32.794562,-8.793011),
new Waypoint("+X830716",32.768728,-8.842449),
new Waypoint("+X142586",32.684609,-8.927422),
new Waypoint("P3430",32.64971,-8.938837),
new Waypoint("+X327218",32.56367,-9.001493),
new Waypoint("+X433348",32.499483,-9.033852),
new Waypoint("+X797734",32.436193,-9.046726),
new Waypoint("+X450800",32.403589,-9.074707),
new Waypoint("R202",32.387237,-9.07483),
new Waypoint("+X131569",32.33646,-9.085178),
new Waypoint("N7A",32.28162,-9.114058),
new Waypoint("N6_SAB",34.015157,-6.549547),
new Waypoint("R405",34.005659,-6.543453),
new Waypoint("+X01",33.983794,-6.531544),
new Waypoint("+X02",33.967566,-6.496696),
new Waypoint("+X03",33.923136,-6.452493),
new Waypoint("P4306",33.877364,-6.32585),
new Waypoint("+X05",33.855662,-6.304779),
new Waypoint("+X06",33.842689,-6.243496),
new Waypoint("+X07",33.825721,-6.222639),
new Waypoint("+X08",33.818376,-6.106768),
new Waypoint("R404",33.800083,-6.084538),
new Waypoint("+X09",33.803257,-6.033297),
new Waypoint("+X10",33.779361,-5.956221),
new Waypoint("+X11",33.786709,-5.899315),
new Waypoint("+X12",33.812315,-5.860949),
new Waypoint("+X13",33.829999,-5.853138),
new Waypoint("+X14",33.859796,-5.789108),
new Waypoint("+X15",33.872696,-5.781898),
new Waypoint("+X16",33.894785,-5.682163),
new Waypoint("+X17",33.885024,-5.65753),
new Waypoint("+X18",33.850958,-5.62294),
new Waypoint("P7023",33.844542,-5.604572),
new Waypoint("+X19",33.833849,-5.578995),
new Waypoint("N13",33.830498,-5.514021),
new Waypoint("+X20",33.836201,-5.463295),
new Waypoint("+X21",33.850388,-5.438232),
new Waypoint("+X22",33.852098,-5.354805),
new Waypoint("+X23",33.87234,-5.315151),
new Waypoint("+X24",33.873266,-5.275068),
new Waypoint("R716",33.884218,-5.248276),
new Waypoint("+X25",33.903904,-5.191469),
new Waypoint("+X26",33.926981,-5.169668),
new Waypoint("A201",33.945994,-5.072422),
new Waypoint("+X509517",33.909033,-5.027275),
new Waypoint("N8",33.898062,-4.992171),
new Waypoint("N4",33.930756,-4.918184),
new Waypoint("+X27",33.970983,-4.835358),
new Waypoint("+X28",34.002867,-4.816733),
new Waypoint("+X970899",33.992121,-4.733906),
new Waypoint("N6_RT",34.002724,-4.699831),
new Waypoint("+X891397",33.99696,-4.67906),
new Waypoint("+X29",34.024352,-4.616403),
new Waypoint("+X30",34.046543,-4.531088),
new Waypoint("+X436630",34.068374,-4.518213),
new Waypoint("P5407",34.093184,-4.47135),
new Waypoint("+X31",34.137987,-4.394488),
new Waypoint("+X896048",34.163381,-4.316254),
new Waypoint("+X527520",34.185607,-4.304667),
new Waypoint("P5409",34.203071,-4.267759),
new Waypoint("+X32",34.229403,-4.191113),
new Waypoint("+X33",34.220107,-4.108715),
new Waypoint("P5413",34.229829,-4.079533),
new Waypoint("N29",34.260621,-3.955679),
new Waypoint("+X34",34.251399,-3.903408),
new Waypoint("+X444009",34.271403,-3.805046),
new Waypoint("+X906991",34.302961,-3.768396),
new Waypoint("R511",34.308562,-3.721275),
new Waypoint("+X770239",34.30523,-3.623943),
new Waypoint("+X35",34.329403,-3.530044),
new Waypoint("+X353295",34.310263,-3.429966),
new Waypoint("+X499394",34.318061,-3.370485),
new Waypoint("N15",34.350026,-3.313322),
new Waypoint("+X347587",34.407476,-3.172131),
new Waypoint("+X921463",34.419089,-3.114796),
new Waypoint("+X718718",34.468566,-3.024158),
new Waypoint("N19",34.474156,-2.991371),
new Waypoint("Tao_E",34.524449,-2.931633),
new Waypoint("+X36",34.544601,-2.905111),
new Waypoint("+X302359",34.553649,-2.848721),
new Waypoint("+X37",34.604742,-2.761945),
new Waypoint("+X862966",34.593721,-2.697744),
new Waypoint("+X711659",34.609546,-2.561016),
new Waypoint("+X660943",34.625439,-2.534409),
new Waypoint("R607",34.613431,-2.481279),
new Waypoint("+X616378",34.614632,-2.418795),
new Waypoint("+X826241",34.639634,-2.306871),
new Waypoint("+X203961",34.626145,-2.275457),
new Waypoint("+X864884",34.659969,-2.189283),
new Waypoint("+X38",34.66004,-2.126284),
new Waypoint("N6_Ouj",34.693709,-2.025862),
new Waypoint("N11_N",33.519107,-7.632966),
new Waypoint("A1",33.500322,-7.628374),
new Waypoint("P3011",33.483429,-7.632537),
new Waypoint("P3013",33.438067,-7.629533),
new Waypoint("P3038",33.389743,-7.619877),
new Waypoint("N12_N",33.317655,-7.602324),
new Waypoint("A4",33.29427,-7.54971),
new Waypoint("+X02",33.271703,-7.547865),
new Waypoint("N12_S",33.245364,-7.565374),
new Waypoint("+X03",33.198692,-7.576017),
new Waypoint("+X04",33.151709,-7.572155),
new Waypoint("P3606",33.073131,-7.59696),
new Waypoint("+X05",33.006,-7.588978),
new Waypoint("R308",32.963091,-7.602367),
new Waypoint("+X06",32.894867,-7.669659),
new Waypoint("+X07",32.829909,-7.697897),
new Waypoint("+X08",32.766274,-7.739439),
new Waypoint("+X09",32.693421,-7.741928),
new Waypoint("+X10",32.65419,-7.769995),
new Waypoint("+X11",32.602506,-7.826214),
new Waypoint("+X12",32.579076,-7.84647),
new Waypoint("+X13",32.540301,-7.905178),
new Waypoint("N9",32.503537,-7.918482),
new Waypoint("+X249206",32.409929,-7.939168),
new Waypoint("+X184316",32.373148,-7.935562),
new Waypoint("+X984287",32.323115,-7.958393),
new Waypoint("R206",32.220789,-7.981739),
new Waypoint("+X15",32.128742,-8.00251),
new Waypoint("+X16",32.059009,-7.994699),
new Waypoint("+X17",31.936503,-8.017187),
new Waypoint("+X18",31.912536,-8.025942),
new Waypoint("A301",31.877558,-8.02165),
new Waypoint("+X19",31.83243,-8.033323),
new Waypoint("+X20",31.824117,-8.056927),
new Waypoint("N7",31.784509,-8.132887),
new Waypoint("+X21",31.774367,-8.166618),
new Waypoint("P2006",31.693119,-8.268242),
new Waypoint("+X22",31.641545,-8.303347),
new Waypoint("+X23",31.625102,-8.359223),
new Waypoint("N8",31.604307,-8.393082),
new Waypoint("+X24",31.545845,-8.45295),
new Waypoint("+X25",31.531507,-8.486423),
new Waypoint("+X26",31.516728,-8.548479),
new Waypoint("+X27",31.484015,-8.673964),
new Waypoint("R209",31.473291,-8.692031),
new Waypoint("+X29",31.412623,-8.745632),
new Waypoint("+X30",31.311408,-8.823309),
new Waypoint("+X31",31.277744,-8.845625),
new Waypoint("N11_Imi",31.265859,-8.865109),
new Waypoint("+X33",31.226161,-8.903475),
new Waypoint("+X34",31.194668,-8.977375),
new Waypoint("+X35",31.121219,-9.016943),
new Waypoint("+X36",31.078299,-9.021921),
new Waypoint("+X37",31.042566,-9.012651),
new Waypoint("+X38",30.92704,-9.070072),
new Waypoint("+X39",30.879981,-9.079771),
new Waypoint("N11_Arg",30.820958,-9.122043),
new Waypoint("+X421234",30.75113,-9.166203),
new Waypoint("+X318278",30.7107,-9.219074),
new Waypoint("+X43",30.690405,-9.225426),
new Waypoint("+X44",30.683614,-9.242764),
new Waypoint("+X45",30.664494,-9.251089),
new Waypoint("+X46",30.620778,-9.340611),
new Waypoint("+X47",30.585539,-9.346104),
new Waypoint("+X48",30.525374,-9.316063),
new Waypoint("R114A",30.483666,-9.34473),
new Waypoint("N11/N11A",30.423734,-9.38653),
new Waypoint("A3",33.29427,-7.54971),
new Waypoint("+X802792",33.295525,-7.537823),
new Waypoint("+X274936",33.271058,-7.518167),
new Waypoint("+X677825",33.230862,-7.446327),
new Waypoint("+X540898",33.178724,-7.351141),
new Waypoint("+X697877",33.158463,-7.257843),
new Waypoint("N23",33.132736,-7.223854),
new Waypoint("+X277788",33.091865,-7.151156),
new Waypoint("+X601998",32.991027,-7.068157),
new Waypoint("+X789104",32.954665,-6.965675),
new Waypoint("R403",32.940908,-6.894693),
new Waypoint("+X473737",32.933128,-6.865854),
new Waypoint("+X141295",32.942996,-6.720457),
new Waypoint("+X449159",32.950415,-6.689386),
new Waypoint("+X852480",32.944653,-6.656857),
new Waypoint("N25",32.904254,-6.596775),
new Waypoint("+X582308",32.881894,-6.537037),
new Waypoint("N12",32.851074,-6.518841),
new Waypoint("+X372490",32.788068,-6.529741),
new Waypoint("R310",32.703317,-6.466784),
new Waypoint("+X998603",32.65672,-6.455498),
new Waypoint("+X119317",32.619135,-6.412582),
new Waypoint("R308",32.579383,-6.390073),
new Waypoint("+X178977",32.519895,-6.381083),
new Waypoint("+X930453",32.485438,-6.357479),
new Waypoint("+X605586",32.435975,-6.350183),
new Waypoint("N8",32.402936,-6.333447),
new Waypoint("A1",33.876063,-7.010265),
new Waypoint("+X865795",33.861721,-6.967134),
new Waypoint("R403",33.846253,-6.899114),
new Waypoint("+X462455",33.838269,-6.877828),
new Waypoint("N25",33.84685,-6.837047),
new Waypoint("+X772331",33.875333,-6.797361),
new Waypoint("+P4025",33.908774,-6.776912),
new Waypoint("P4008",33.97786,-6.736899),
new Waypoint("RocRab",33.981646,-6.734182),
new Waypoint("AveMaa",34.000304,-6.719298),
new Waypoint("N6",34.02677,-6.711016),
new Waypoint("+X01",34.06489,-6.71093),
new Waypoint("P4002",34.096418,-6.685309),
new Waypoint("+X03",34.118342,-6.688099),
new Waypoint("+X04",34.161782,-6.673722),
new Waypoint("+X05",34.226706,-6.599178),
new Waypoint("R405",34.230077,-6.570725),
new Waypoint("+X176098",34.226138,-6.529141),
new Waypoint("N1_Ken",34.291474,-6.502233),
new Waypoint("+X09",34.336208,-6.509056),
new Waypoint("+X12",34.412185,-6.524119),
new Waypoint("+X533799",34.506539,-6.478672),
new Waypoint("P4234",34.627876,-6.419277),
new Waypoint("+X13",34.666535,-6.389923),
new Waypoint("+X14",34.736816,-6.360226),
new Waypoint("+X15",34.794352,-6.295853),
new Waypoint("+X16",34.813521,-6.245213),
new Waypoint("N27",34.860264,-6.221952),
new Waypoint("+X17",34.918593,-6.204357),
new Waypoint("+X18",34.986972,-6.199379),
new Waypoint("+X19",35.035478,-6.183929),
new Waypoint("+X20",35.095754,-6.147022),
new Waypoint("N1A",35.140616,-6.145778),
new Waypoint("+X21",35.173808,-6.117325),
new Waypoint("+X22",35.1985,-6.071148),
new Waypoint("+X23",35.220801,-6.061535),
new Waypoint("+X24",35.258236,-6.073208),
new Waypoint("+X25",35.282482,-6.06205),
new Waypoint("+X26",35.29243,-6.032524),
new Waypoint("N1_SL",35.326435,-6.012483),
new Waypoint("N1_Ass",35.447701,-6.02304),
new Waypoint("+X27",35.483038,-5.992183),
new Waypoint("+X29",35.52594,-5.991669),
new Waypoint("+X30",35.582082,-5.956821),
new Waypoint("+X31",35.64544,-5.959396),
new Waypoint("A501",35.674903,-5.932832),
new Waypoint("+X32",35.675845,-5.910087),
new Waypoint("+X33",35.652588,-5.853567),
new Waypoint("P4602",35.666414,-5.82211),
new Waypoint("+X35",35.678843,-5.80224),
new Waypoint("+X36",35.668593,-5.754261),
new Waypoint("+X37",35.680516,-5.737782),
new Waypoint("N2",35.683514,-5.709457),
new Waypoint("+X38",35.688115,-5.680275),
new Waypoint("P4613",35.733241,-5.625172),
new Waypoint("+X39",35.777436,-5.613585),
new Waypoint("+X40",35.801525,-5.574532),
new Waypoint("N16_Ksa",35.831766,-5.559039),
new Waypoint("N16_E",35.856501,-5.534663),
new Waypoint("N16_Fni",35.828531,-5.362744),
new Waypoint("+X03",35.789899,-5.377979),
new Waypoint("N16_MS",35.747905,-5.354376),
new Waypoint("MDiq",35.69404,-5.349741),
new Waypoint("+X02",35.66155,-5.345964),
new Waypoint("ToN16",35.650588,-5.329067),
new Waypoint("N16_Tet",35.597926,-5.338411),
new Waypoint("A1",33.650405,-7.417274),
new Waypoint("N9",33.631719,-7.452013),
new Waypoint("AinHar",33.626377,-7.463),
new Waypoint("ToN9",33.619929,-7.472988),
new Waypoint("BouSB20",33.614244,-7.482591),
new Waypoint("BouMbaHam",33.607632,-7.495337),
new Waypoint("P3006",33.600877,-7.507868),
new Waypoint("BouImamAli",33.59539,-7.518854),
new Waypoint("VoieSM36",33.591439,-7.528467),
new Waypoint("RueDesEde",33.584039,-7.545226),
new Waypoint("P3010",33.578587,-7.555611),
new Waypoint("AveColAll",33.573939,-7.563958),
new Waypoint("Ave10Mars",33.56786,-7.574708),
new Waypoint("R315",33.559546,-7.594342),
new Waypoint("Ave2Mars",33.556971,-7.60653),
new Waypoint("RouDeTad",33.553466,-7.62346),
new Waypoint("RouDeLaMec",33.551731,-7.632172),
new Waypoint("N1/N11",33.549009,-7.64369),
new Waypoint("A1",33.499463,-7.684937),
new Waypoint("RocSudOue",33.506512,-7.671375),
new Waypoint("A1",33.235528,-8.406171),
new Waypoint("N1",33.246153,-8.450718),
new Waypoint("A2",33.945994,-5.072422),
new Waypoint("PenFes_N",33.955161,-5.035949),
new Waypoint("A3",31.877558,-8.02165),
new Waypoint("+X117262",31.850878,-7.995558),
new Waypoint("N9",31.769941,-7.981133),
new Waypoint("A5",35.674903,-5.932832),
new Waypoint("N1",35.681597,-5.921309)
];
traveler = 'yasubee_horibe';
segments = [
386008,
386009,
386010,
386011,
386012,
386013,
386014,
386015,
386016,
386017,
386018,
386019,
386020,
386021,
386022,
386023,
386024,
386025,
386026,
386027,
386028,
386029,
386030,
386031,
386032,
386033,
386034,
386035,
386036,
386037,
386038,
386039,
386040,
386041,
386042,
386043,
386044,
386045,
386046,
386047,
386048,
386049,
386050,
386051,
386052,
386053,
386054,
386055,
386056,
386057,
386058,
386059,
386060,
386061,
386062,
386063,
386064,
386065,
386066,
386067,
386068,
386069,
386070,
386071,
386072,
386073,
386074,
386075,
386076,
386077,
386078,
386079,
386080,
386081,
386082,
386083,
386084,
386085,
386086,
386087,
386088,
386089,
386090,
386091,
386092,
386093,
386094,
386095,
386096,
386097,
386098,
386099,
386100,
386101,
386102,
386103,
386104,
386105,
386106,
386107,
386108,
386109,
386110,
386111,
386112,
386113,
386114,
386115,
386116,
386117,
386118,
386119,
386120,
386121,
386122,
386123,
386124,
386125,
386126,
386127,
386128,
386129,
386130,
386131,
386132,
386133,
386134,
386135,
386136,
386137,
386138,
386139,
386140,
386141,
386142,
386143,
386144,
386145,
386146,
386147,
386148,
386149,
386150,
386151,
386152,
386153,
386154,
386155,
386156,
386157,
386158,
386159,
386160,
386161,
386162,
386163,
386164,
386165,
386166,
386167,
386168,
386169,
386170,
386171,
386172,
386173,
386174,
386175,
386176,
386177,
386178,
386179,
386180,
386181,
386182,
386183,
386184,
386185,
386186,
386187,
386188,
386189,
386190,
386191,
386192,
386193,
386194,
386195,
386196,
386197,
386198,
386199,
386200,
386201,
386202,
386203,
386204,
386205,
386206,
386207,
386208,
386209,
386210,
386211,
386212,
386213,
386214,
386215,
386216,
386217,
386218,
386219,
386220,
386221,
386222,
386223,
386224,
386225,
386226,
386227,
386228,
386229,
386230,
386231,
386232,
386233,
386234,
386235,
386236,
386237,
386238,
386239,
386240,
386241,
386242,
386243,
386244,
386245,
386246,
386247,
386248,
386249,
386250,
386251,
386252,
386253,
386254,
386255,
386256,
386257,
386258,
386259,
386260,
386261,
386262,
386263,
386264,
386265,
386266,
386267,
386268,
386269,
386270,
386271,
386272,
386273,
386274,
386275,
386276,
386277,
386278,
386279,
386280,
386281,
386282,
386283,
386284,
386285,
386286,
386287,
386288,
386289,
386290,
386291,
386292,
386293,
386294,
386295,
386296,
386297,
386298,
386299,
386300,
386301,
386302,
386303,
386304,
386305,
386306,
386307,
386308,
386309,
386310,
386311,
386312,
386313,
386314,
386315,
386316,
386317,
386318,
386319,
386320,
386321,
386322,
386323,
386324,
386325,
386326,
386327
];
clinched = [
];
mapClinched = true;
mapStatus = mapStates.MAPVIEW;
genEdges = true;
}