Web/index.php at master · jteresco/Web · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"/>
<meta name="viewport" content="width=device-width, initial-scale=1">
<?php require $_SERVER['DOCUMENT_ROOT']."/lib/tmphpfuncs.php" ?>
<title>Travel Mapping</title>
<link rel="stylesheet" type="text/css" href="/css/travelMapping.css">
<link rel="shortcut icon" type="image/png" href="favicon.png">
</head>
<body>
<?php require  $_SERVER['DOCUMENT_ROOT']."/lib/tmheader.php"; ?>

<p class="heading">Welcome to Travel Mapping</p>

<p class="text">

Travel Mapping is a collaborative project implemented and maintained
by a <a href="credits.php#contributors">group</a> of travel
enthusiasts who enjoy tracking their cumulative travels.  This site
allows its <a href="/stat.php">users</a> to submit lists of highway
segments they've traveled on the <a href="/hb">highway
systems</a> that have been included in the project.  Those lists are
then imported into the project's database, to be included along with
other users' stats and maps.

</p>

<p class="heading">Travel Mapping Highway Data</p>

<p class="text">

Travel Mapping currently includes highway data for
<?php
echo tm_count_rows("systems", "WHERE level='active'");
?>
 active systems. An additional
<?php
echo tm_count_rows("systems", "WHERE level='preview'");
?>
 systems are in "preview" status, which means they are substantially
complete, but still undergoing final revisions, and
<?php
echo tm_count_rows("systems", "WHERE level='devel'");
?>
 more are in development but are not yet complete.  Active system
encompass
<?php
echo number_format(tm_count_rows("connectedRoutes", "LEFT JOIN systems ON connectedRoutes.systemName = systems.systemName WHERE systems.level = 'active'"));
?>
 routes for
<?php
echo number_format(tm_sum_column("overallMileageByRegion", "activeMileage"));
?>
 miles of "clinchable" highways in active systems, and that total is
<?php
echo number_format(tm_count_rows("connectedRoutes", "LEFT JOIN systems ON connectedRoutes.systemName = systems.systemName WHERE systems.level = 'active' OR systems.level = 'preview'"));
?>
 routes for
<?php
echo number_format(tm_sum_column("overallMileageByRegion", "activePreviewMileage"));
?>
 miles when preview systems are included.

</p>

<p class="heading">How to Participate</p>

<p class="text">

Anyone can submit their travels to be included in the site.  Please
see the information in <a href="/forum">the project forum</a> for how
to create and submit your data.

</p>

<p class="text">

Experienced users might also want to volunteer to help the project.
Start by reporting problems with existing highway data.  Those who
have learned the project's structure and highway data rules and
guidelines can help greatly by providing review of new highway systems
in development.  Highly experienced users can learn how to plot new
highway systems under the guidance of experienced contributors.
Again, see <a href="/forum">the project forum</a> for more information.
</p>

<!-- idea: 5 or so newest highway data updates, system updates -->

<p class="heading">What's New?</p>

<p class="text">
Highway data gets <a href="/devel/updates.php">updated</a> almost
daily as corrections are made and progress is made on systems in
development.  When a highway system is deemed correct and complete to
the best of our knowledge, it becomes "active".  The newest systems to
become active:</p>
<ul class="text">
<?php
$res = tmdb_query("select systemName, description, date from systemUpdates where statusChange='active'  limit 8");
while ($row = $res->fetch_assoc()) {
  echo "<li>".$row['description']." (".$row['systemName']."), ".$row['date']."</li>\n";
}
$res->free();
?>
</ul>

<p class="text">
The most recent site update completed at <?php echo tm_update_time(); ?> US/Eastern.
</p>

<?php require  $_SERVER['DOCUMENT_ROOT']."/lib/tmfooter.php"; ?>
</body>
<?php
    $tmdb->close();
?>
</html>