-
Notifications
You must be signed in to change notification settings - Fork 0
/
updates.php
118 lines (100 loc) · 3.69 KB
/
updates.php
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
118
<?php
// updates.php
// $Revision: 1.1 $ - $Date: 2007-10-30 16:10:49-04 $
//
include('includes/session.inc');
$title=_('Michigan Section ARES');
include('includes/functions.inc');
$db = mysql_connect($host , $dbuser, $dbpassword);
mysql_select_db($DatabaseName,$db);
ARESheader($title,"ARES Net Michigan Section ARPSC RACES");
// Remember the launch time
$starttime = strftime("%A, %B %d %Y, %H:%M");
ARESleftBar( $db );
// Remember the launch time
$starttime = strftime("%A, %B %d %Y, %H:%M");
// Determine the dates of the events to search for
$now = mktime();
// Today as ISO date
$searchdate = strftime("%Y-%m-%d",$now);
// Today - 7 days
$then = $now - 86400*7;
// 7 days ago as ISO date
$checkdate = strftime("%Y-%m-%d",$then);
$maxdate=0;
?>
<div id="main">
<p></p>
<?php
echo '<h1>Updated Pages</h1>' . "\n";
$s1='SELECT MAX(`updated`) FROM `arpsc_ecrept`';
echo "<h3>FSD-212</h3>\n";
echo "<p>FSD-212 data last updated " . singleResult($s1,$db) . ".</p>\n";
if ( singleResult($s1,$db)>$maxdate )
$maxdate=singleResult($s1,$db);
$s1='SELECT MAX(`updated`) FROM `nets`';
echo "<h3>Nets</h3>\n";
echo "<p>Net data last updated " . singleResult($s1,$db) . ".</p>\n";
if ( singleResult($s1,$db)>$maxdate )
$maxdate=singleResult($s1,$db);
$s1='SELECT MAX(`updated`) FROM `arpsc_events`';
echo "<h3>Events</h3>\n";
echo "<p>Event data last updated " . singleResult($s1,$db) . ". Note that only the events for the coming 90 days are shown, so the new or modified event might not appear.</p>\n";
if ( singleResult($s1,$db)>$maxdate )
$maxdate=singleResult($s1,$db);
$s1='SELECT MAX(`updated`) FROM `anavbar_subs`';
echo "<h3>Navigation bar</h3>\n";
echo "<p>The left hand navigation bar was last changed " . singleResult($s1,$db) . ".</p>\n";
if ( singleResult($s1,$db)>$maxdate )
$maxdate=singleResult($s1,$db);
$s1="SELECT `pageid`, `updated` FROM `textblocks` WHERE `updated`>'" . $checkdate . "' " .
"AND `pageid`>0 ORDER BY `pageid`,`updated`";
$q1=getResult($s1,$db);
echo "<h3>Text Pages</h3>\n";
echo "<p>The following pages have been updated in the past 7 days:<br />\n";
$lastblock = 0;
while ( $r1 = getRow($q1,$db) )
{
if ( $r1[0] != $lastblock )
{
if ( $r1[1]>$maxdate )
$maxdate=$r1[1];
$pageurl="txtblk.php?topic=" . $r1[0];
$s2="SELECT `pageid` FROM `webpages` WHERE `url`='" . $pageurl . "'";
$pageid=singleResult($s2,$db);
if ( $pageid>0 )
{
$s3="SELECT `buttontext` FROM `anavbar_subs` WHERE `pageid`=" . $pageid;
$buttontext=singleResult($s3,$db);
echo $buttontext . " updated on " . $r1[1] . ".<br />\n";
}
else
{
echo "txtblk.php?topic=" . $r1[0] . " updated on " . $r1[1] . ".<br />\n";
}
$lastblock = $r1[0];
}
}
echo "</p>\n";
echo "<h3>Section Leaders</h3>\n";
$s1="SELECT MAX(`updated`) FROM `sect_appt`";
$leaderdate=singleResult($s1,$db);
$s2="SELECT `title`,`id` FROM `sect_appt` WHERE `updated`='" . $leaderdate . "'";
$q2=getResult($s2,$db);
while ( $r2 = getRow($q2,$db) )
{
echo "<p>" . $r2[0] . " updated on " . $leaderdate . ".</p>\n";
}
if ( $leaderdate>$maxdate )
$maxdate=$leaderdate;
echo "<h3>ARPSC Net Controls</h3>\n";
echo "<p>The ARPSC Net Control page relies entirely on calculation, and " .
"thus may change any time you look at it.</p>\n";
echo " </div>\n";
sectLeaders($db);
footer($starttime,$maxdate,
"\$Revision: 1.1 $ - \$Date: 2007-10-30 16:10:49-04 $");
?>
</div>
</body>
</html>