+
+ private function display_comment_link() {
+ $url = $this->url . 'comments/';
+ echo "<a id=\"comment_link\" href=\"$url\">comments</a>";
+ }
+
+ private function display_comments() {
+ echo "<div id=\"comments\">";
+ $sql= "SELECT date_posted, author, email, text
+ FROM comments WHERE note = ?";
+ $result = $this->query($sql, "d", $this->id);
+ foreach ($result as $row => $entry) {
+ $date_posted = $entry['date_posted'];
+ $author = $entry['author'];
+ $email = $entry['email'];
+ $text = htmlspecialchars($entry['text']);
+ echo <<<END_OF_COMMENT
+ <h3><a href="mailto:$email">$author</a></h3>
+ $text
+ <br>
+ <br>
+END_OF_COMMENT;
+ }
+ echo "</div>";
+ }
+
+ private function display_comment_form() {
+ // Trailing slash is necessary for reloads to work
+ $url = $this->url . "verify/";
+ echo "<form id=\"comment\" method=\"post\" action=\"$url\">";
+ require_once('includes/recaptchalib.php');
+ echo recaptcha_get_html($this->recaptcha_publickey);
+ echo "<input type=\"submit\">";
+ echo "</form>";
+ }
+}
+
+
+class archive extends cms {
+
+ public function __construct() {
+ parent::__construct();
+ }
+
+ private function check_exists() {
+ $sql = "SELECT COUNT(*) FROM notes
+ WHERE url = ?";
+ $results = $this->query($sql, "s", $_GET['note']);
+ if ($results[0]["COUNT(*)"] != 1) {
+ $this->not_found();
+ }
+ }
+
+ public function display() {
+ // this really needs its own pagination...
+ // there should be a class for that.
+ $this->display_head();
+ switch (true) {
+ case (isset($_GET['year']) && !isset($_GET['month'])
+ && !isset($_GET['day'])):
+ $sql = "SELECT title, url, date_posted, text
+ FROM notes WHERE YEAR(date_posted) = ?
+ ORDER BY date_posted DESC";
+ $result = $this->query($sql, "d",
+ $_GET['year']);
+ break;
+ case (isset($_GET['year']) && isset($_GET['month'])
+ && !isset($_GET['day'])):
+ $sql = "SELECT title, url, date_posted, text
+ FROM notes WHERE YEAR(date_posted) = ?
+ AND MONTH(date_posted) = ?
+ ORDER BY date_posted DESC";
+ $result = $this->query($sql, "dd",
+ $_GET['year'], $_GET['month']);
+ break;
+ case (isset($_GET['year']) && isset($_GET['month'])
+ && isset($_GET['day'])):
+ $sql = "SELECT title, url, date_posted, text
+ FROM notes WHERE YEAR(date_posted) = ?
+ AND MONTH(date_posted) = ?
+ AND DAY(date_posted) = ?
+ ORDER BY date_posted DESC";
+ $result = $this->query($sql, "ddd",
+ $_GET['year'], $_GET['month'],
+ $_GET['day']);
+ break;
+ }
+ if (count($result) >= 1) {
+ echo "<div id=\"notes\">";
+ foreach ($result as $row => $entry) {
+ $title = $entry['title'];
+ $url = '/note/' . $entry['url'];
+ $date_posted = explode("-", $entry['date_posted']);
+ $year_posted = $date_posted[0];
+ $month_posted = $date_posted[1];
+ $datetime_posted = explode(' ', $date_posted[2]);
+ $day_posted = $datetime_posted[0];
+ echo "<div class=\"note\">";
+ echo "<h2><span style=\"color:grey;\">$year_posted/$month_posted/$day_posted/</span><a href=\"$url\">$title</a></h2>";
+ echo $entry['text'];
+ echo "</div>";
+ }
+ echo "</div>";
+ $this->write_navigation();
+ } else {
+ echo "<br>";
+ echo "<h2 style=\"font-family:sans-serif;\">sorry, nothing here</h2>";
+ echo "<pre>Empty set (0.00 sec)</pre>";
+ }
+ $this->display_close();
+ }
+
+ private function write_navigation() {
+ echo "<br>";
+ echo "<div id=\"navigation\">";
+ echo "<h2>";
+ // fill me in!
+ echo "</h2>";
+ echo "</div>";
+ }