<!-- /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: "per.avjavpra", tier: 3, color: "TMteal", system: "persf", label: "PER AvJavPra" };
routeInfo[1] = { firstWaypoint: 11, root: "per.cirpla", tier: 3, color: "TMteal", system: "persf", label: "PER CirPla" };
routeInfo[2] = { firstWaypoint: 28, root: "per.explinama", tier: 3, color: "TMteal", system: "persf", label: "PER ExpLinAma" };
routeInfo[3] = { firstWaypoint: 37, root: "per.expluisrey", tier: 3, color: "TMteal", system: "persf", label: "PER ExpLuisRey" };
routeInfo[4] = { firstWaypoint: 51, root: "per.subarm", tier: 3, color: "TMteal", system: "persf", label: "PER SubArm" };
routeInfo[5] = { firstWaypoint: 54, root: "per.viacosver", tier: 3, color: "TMteal", system: "persf", label: "PER ViaCosVer" };
routeInfo[6] = { firstWaypoint: 58, root: "per.viaevi", tier: 3, color: "TMteal", system: "persf", label: "PER ViaEvi" };
waypoints = [
new Waypoint("OvMon",-12.083235,-76.970016),
new Waypoint("JocPla",-12.084373,-76.976953),
new Waypoint("PE1S",-12.084966,-76.982097),
new Waypoint("AvCir",-12.085026,-76.983993),
new Waypoint("AvSanLuis",-12.086692,-76.996651),
new Waypoint("AvAvi",-12.0881,-77.003587),
new Waypoint("AvGuaCiv",-12.088648,-77.007621),
new Waypoint("AvGalBar",-12.089632,-77.014458),
new Waypoint("AvNicArr",-12.090101,-77.017856),
new Waypoint("AvPabMau",-12.090285,-77.01916),
new Waypoint("ExpLuisRey",-12.090809,-77.022818),
new Waypoint("CL/LM",-12.079437,-77.111492),
new Waypoint("AvCos",-12.080397,-77.109639),
new Waypoint("AvRafEsc",-12.086477,-77.097335),
new Waypoint("AvJorCha",-12.090085,-77.089144),
new Waypoint("AvUni",-12.091748,-77.0854),
new Waypoint("CirPla_U1",-12.094229,-77.080051),
new Waypoint("CirPla_U2",-12.097639,-77.073212),
new Waypoint("AvSuc",-12.101347,-77.067214),
new Waypoint("BajMar",-12.107411,-77.059776),
new Waypoint("BajSanMar",-12.110652,-77.05494),
new Waypoint("CirPla_U3",-12.115063,-77.050268),
new Waypoint("CirPla_U4",-12.12057,-77.04522),
new Waypoint("SubBal",-12.126814,-77.037672),
new Waypoint("CirPla_U5",-12.131088,-77.033772),
new Waypoint("SubArm",-12.139157,-77.028054),
new Waypoint("CirPla_U6",-12.145671,-77.025409),
new Waypoint("SubCho",-12.160299,-77.025407),
new Waypoint("PE1N_E",-12.038088,-77.013774),
new Waypoint("JrAnc",-12.042264,-77.015791),
new Waypoint("PueHua",-12.043502,-77.019369),
new Waypoint("+X441397",-12.043355,-77.029449),
new Waypoint("AvAlfUga",-12.038465,-77.043471),
new Waypoint("PE1N_W",-12.036765,-77.046534),
new Waypoint("AvNicDue",-12.03531,-77.065755),
new Waypoint("AvUni",-12.035832,-77.077712),
new Waypoint("JrCecTup",-12.03687,-77.082927),
new Waypoint("AvGrau",-12.059791,-77.035747),
new Waypoint("Av28Jul_A",-12.06376,-77.03392),
new Waypoint("AvIqu",-12.074579,-77.029846),
new Waypoint("AvMex",-12.076819,-77.028875),
new Waypoint("AvCan",-12.082422,-77.026584),
new Waypoint("AvJavPra",-12.090809,-77.022818),
new Waypoint("AvCanMor",-12.096773,-77.025071),
new Waypoint("AvAra",-12.102837,-77.027341),
new Waypoint("AvDomOrue",-12.108604,-77.026412),
new Waypoint("AvAng",-12.113495,-77.025973),
new Waypoint("AvBen",-12.125338,-77.024138),
new Waypoint("Av28Jul_B",-12.129599,-77.022741),
new Waypoint("SubArm",-12.134096,-77.020356),
new Waypoint("AvRepPan",-12.137264,-77.017851),
new Waypoint("ExpLuisRey",-12.134096,-77.020356),
new Waypoint("AvMigGrau",-12.135195,-77.023022),
new Waypoint("CirPla",-12.139157,-77.028054),
new Waypoint("AvMigGrau",-12.066239,-77.153383),
new Waypoint("PE20I",-12.073976,-77.123997),
new Waypoint("AvHayaTor",-12.078335,-77.113949),
new Waypoint("CL/LM",-12.079437,-77.111492),
new Waypoint("PE3S_E",-13.553391,-71.861492),
new Waypoint("1",-13.554768,-71.87346),
new Waypoint("2",-13.552314,-71.88473),
new Waypoint("8",-13.550664,-71.889006),
new Waypoint("3",-13.548857,-71.89308),
new Waypoint("PuePetPeru",-13.546596,-71.896548),
new Waypoint("PueSucAuc",-13.544434,-71.899713),
new Waypoint("4",-13.542226,-71.903584),
new Waypoint("5",-13.541574,-71.915841),
new Waypoint("7",-13.54161,-71.917137),
new Waypoint("6",-13.541978,-71.9251),
new Waypoint("APVAguaBue",-13.540859,-71.940628)
];
traveler = 'the_spui_ninja';
segments = [
1185937,
1185938,
1185939,
1185940,
1185941,
1185942,
1185943,
1185944,
1185945,
1185946,
1185947,
1185948,
1185949,
1185950,
1185951,
1185952,
1185953,
1185954,
1185955,
1185956,
1185957,
1185958,
1185959,
1185960,
1185961,
1185962,
1185963,
1185964,
1185965,
1185966,
1185967,
1185968,
1185969,
1185970,
1185971,
1185972,
1185973,
1185974,
1185975,
1185976,
1185977,
1185978,
1185979,
1185980,
1185981,
1185982,
1185983,
1185984,
1185985,
1185986,
1185987,
1185988,
1185989,
1185990,
1185991,
1185992,
1185993,
1185994,
1185995,
1185996,
1185997,
1185998,
1185999
];
clinched = [
1185989,
1185990,
1185991,
1185992,
1185993,
1185994,
1185995,
1185996,
1185997,
1185998,
1185999
];
mapClinched = true;
mapStatus = mapStates.MAPVIEW;
genEdges = true;
}