<!-- /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: "mkd.avtgocedel", tier: 1, color: "TMblue", system: "mkdap", label: "MKD AvtGoceDel" };
routeInfo[1] = { firstWaypoint: 15, root: "mkd.avtmajter", tier: 1, color: "TMblue", system: "mkdap", label: "MKD AvtMajTer" };
routeInfo[2] = { firstWaypoint: 46, root: "mkd.avtpri", tier: 1, color: "TMblue", system: "mkdap", label: "MKD AvtPri" };
waypoints = [
new Waypoint("12(A2)",41.994584,21.533203),
new Waypoint("11(A2)",41.996554,21.554811),
new Waypoint("10(A2)",41.999751,21.576118),
new Waypoint("9(A2)",41.981985,21.619249),
new Waypoint("8(A2)",41.984728,21.65401),
new Waypoint("+X459",41.986658,21.664653),
new Waypoint("SreKon",41.962083,21.714649),
new Waypoint("+X762",41.945343,21.79275),
new Waypoint("R2135",41.916645,21.878618),
new Waypoint("+X111",41.90288,21.91214),
new Waypoint("R1204_N",41.877246,21.938195),
new Waypoint("R1204_S",41.855674,21.962657),
new Waypoint("+X358",41.834014,21.989608),
new Waypoint("11(A4)",41.812209,22.034551),
new Waypoint("A3_E",41.780941,22.126551),
new Waypoint("A1",41.938357,21.626624),
new Waypoint("Pet",41.941245,21.621088),
new Waypoint("Kad",41.95888,21.584063),
new Waypoint("+X520",41.980262,21.542258),
new Waypoint("12",41.994584,21.533203),
new Waypoint("13",42.018342,21.533911),
new Waypoint("+X773",42.033548,21.524019),
new Waypoint("14",42.031891,21.511595),
new Waypoint("Smi",42.032456,21.485642),
new Waypoint("15",42.040943,21.45484),
new Waypoint("16",42.052734,21.421795),
new Waypoint("17",42.052917,21.381943),
new Waypoint("18",42.053272,21.364385),
new Waypoint("+X958",42.055411,21.343431),
new Waypoint("19",42.038054,21.33575),
new Waypoint("20",42.007995,21.321963),
new Waypoint("21",41.991068,21.311964),
new Waypoint("+X659",41.98007,21.226766),
new Waypoint("+X511",41.982535,21.186619),
new Waypoint("22",41.964939,21.142518),
new Waypoint("+X429",41.964085,21.11834),
new Waypoint("+X764",41.989864,21.089244),
new Waypoint("23",41.987427,21.06548),
new Waypoint("24",42.00245,20.991338),
new Waypoint("R2233_Tet",41.985677,20.966034),
new Waypoint("25",41.982774,20.959693),
new Waypoint("26",41.944338,20.949286),
new Waypoint("27",41.916581,20.942414),
new Waypoint("28",41.871542,20.930758),
new Waypoint("29",41.852397,20.925822),
new Waypoint("IliSka",41.813937,20.91548),
new Waypoint("SRB/MKD",42.236874,21.703341),
new Waypoint("1(A1)",42.223941,21.702504),
new Waypoint("2(A1)",42.186875,21.706216),
new Waypoint("3(A1)",42.173323,21.709456),
new Waypoint("4(A1)",42.156023,21.711345),
new Waypoint("5(A1)",42.133841,21.702016),
new Waypoint("6(A1)",42.07479,21.696614),
new Waypoint("7(A1)",42.047412,21.68345),
new Waypoint("8(A1)",42.025431,21.675344),
new Waypoint("9(A1)",41.997052,21.663607),
new Waypoint("10(A1)",41.984728,21.65401),
new Waypoint("11(A1)",41.959079,21.632144),
new Waypoint("12(A1)",41.955433,21.630798),
new Waypoint("13(A1)",41.938357,21.626624),
new Waypoint("+X683",41.914829,21.642251),
new Waypoint("14(A1)",41.893365,21.682119),
new Waypoint("+X805",41.875185,21.701431),
new Waypoint("+X556",41.842967,21.712418),
new Waypoint("+X558",41.814954,21.711388),
new Waypoint("15(A1)",41.774,21.75705),
new Waypoint("16(A1)",41.748582,21.768894),
new Waypoint("17(A1)",41.728673,21.794069),
new Waypoint("+X115",41.715007,21.816943),
new Waypoint("18(A1)",41.685436,21.832173),
new Waypoint("19(A1)",41.680292,21.829834),
new Waypoint("+X808",41.666965,21.828504),
new Waypoint("+X912",41.640624,21.849918),
new Waypoint("+X435",41.619613,21.905923),
new Waypoint("+X705",41.593493,21.912832),
new Waypoint("20(A1)",41.562602,21.955195),
new Waypoint("21(A1)",41.549917,21.97463),
new Waypoint("+X519",41.558303,22.009778),
new Waypoint("22(A1)",41.49771,22.100464),
new Waypoint("+X267",41.476428,22.109642),
new Waypoint("+X862",41.445236,22.179337),
new Waypoint("+X470",41.428586,22.18432),
new Waypoint("+X786",41.417146,22.197704),
new Waypoint("23(A1)",41.41684,22.2304),
new Waypoint("+X384",41.403499,22.283106),
new Waypoint("+X791",41.37478,22.314863),
new Waypoint("+X799",41.369824,22.339679),
new Waypoint("24(A1)",41.297638,22.430804),
new Waypoint("25(A1)",41.262606,22.471274),
new Waypoint("+X217",41.245409,22.484078),
new Waypoint("R1102_Prd",41.203682,22.496073),
new Waypoint("R1102/R1109",41.151984,22.516635),
new Waypoint("Bog",41.139082,22.541993),
new Waypoint("MKD/GRC",41.130771,22.551391)
];
traveler = 'michih';
segments = [
392449,
392450,
392451,
392452,
392453,
392454,
392455,
392456,
392457,
392458,
392459,
392460,
392461,
392462,
392419,
392420,
392421,
392422,
392423,
392424,
392425,
392426,
392427,
392428,
392429,
392430,
392431,
392432,
392433,
392434,
392435,
392436,
392437,
392438,
392439,
392440,
392441,
392442,
392443,
392444,
392445,
392446,
392447,
392448,
392372,
392373,
392374,
392375,
392376,
392377,
392378,
392379,
392380,
392381,
392382,
392383,
392384,
392385,
392386,
392387,
392388,
392389,
392390,
392391,
392392,
392393,
392394,
392395,
392396,
392397,
392398,
392399,
392400,
392401,
392402,
392403,
392404,
392405,
392406,
392407,
392408,
392409,
392410,
392411,
392412,
392413,
392414,
392415,
392416,
392417,
392418
];
clinched = [
392449,
392450,
392451,
392452,
392453,
392454,
392455,
392456,
392457,
392458,
392459,
392460,
392461,
392462,
392419,
392420,
392421,
392422,
392423,
392424,
392425,
392426,
392427,
392428,
392429,
392430,
392431,
392432,
392433,
392434,
392435,
392436,
392437,
392438,
392439,
392440,
392441,
392442,
392443,
392444,
392445,
392446,
392447,
392448,
392372,
392373,
392374,
392375,
392376,
392377,
392378,
392379,
392380,
392381,
392382,
392383,
392384,
392385,
392386,
392387,
392388,
392389,
392390,
392391,
392392,
392393,
392394,
392395,
392396,
392397,
392398,
392399,
392400,
392401,
392402,
392403,
392404,
392405,
392406,
392407,
392408,
392409,
392410,
392411,
392412,
392413,
392414,
392415,
392416,
392417,
392418
];
mapClinched = true;
mapStatus = mapStates.MAPVIEW;
genEdges = true;
}