From d7308268f7b8922973b78aef6c6eb0e559b3d6d2 Mon Sep 17 00:00:00 2001
From: Steve Sutton <steve@gaslightmedia.com>
Date: Tue, 4 Jun 2013 19:55:27 +0000
Subject: [PATCH] add the reviewed trail count

---
 Toolkit/Page.php        | 7 ++++++-
 templates/template.html | 2 +-
 2 files changed, 7 insertions(+), 2 deletions(-)

diff --git a/Toolkit/Page.php b/Toolkit/Page.php
index 811ed8e..292a70b 100755
--- a/Toolkit/Page.php
+++ b/Toolkit/Page.php
@@ -448,8 +448,14 @@ class Toolkit_Page
         $this->parkSearch     = array();
         $this->regionSearch   = array();
         $this->countySearch   = array();
+        $this->reviewedCount  = 0;
         try {
             $dbh = Toolkit_Database::getInstance();
+            $sql = "
+            SELECT count(member_id)
+              FROM member
+             WHERE reviewed = true";
+            $this->reviewedCount = $dbh->query($sql)->fetchColumn();
             $sql = "
               SELECT category_id,name
                 FROM members.category
@@ -460,7 +466,6 @@ class Toolkit_Page
                 $this->activitySearch[$category['category_id']]
                     = $category['name'];
             }
-//            var_dump($this->activitySearch);exit;
             $sql = "
               SELECT category_id,name
                 FROM members.category
diff --git a/templates/template.html b/templates/template.html
index a8999de..4f6a7fc 100755
--- a/templates/template.html
+++ b/templates/template.html
@@ -55,7 +55,7 @@
 				<div id="findatrail">
 					<h2>Find A Trail</h2>
 					<div id="trail_count_wrapper">
-						<div id="trail_count">166</div>
+						<div id="trail_count">{reviewedCount:h}</div>
 						<p>Trails Reviewed</p>
 					</div>
 					<form
-- 
2.17.1