From 07fb42d7bb68cdb91c2261213c9faea40b80b6f5 Mon Sep 17 00:00:00 2001
From: Anthony Talarico <talarico@gaslightmedia.com>
Date: Wed, 13 Apr 2016 12:03:18 -0400
Subject: [PATCH] changing last updated in class flight file

---
 class_flight.php | 10 +++++++++-
 1 file changed, 9 insertions(+), 1 deletion(-)

diff --git a/class_flight.php b/class_flight.php
index bc88519..1807065 100644
--- a/class_flight.php
+++ b/class_flight.php
@@ -105,7 +105,15 @@ include_once($_SERVER['DOCUMENT_ROOT'].'/wp-config.php' );
 			rsort($update_times);
 			// get UTC offset for current date/time
 			$TimeDiff = 4+date("I");
-			$this->last_updated = '<div id="last-update"><p>&nbsp;</p><p><b>Last updated:</b> '.date("n/j/Y g:i a",$update_times[0]-($TimeDiff*60*60)).'</p></div>';
+//			$this->last_updated = '<div id="last-update"><p>&nbsp;</p><p><b>Last updated:</b> '.date("n/j/Y g:i a",$update_times[0]-($TimeDiff*60*60)).'</p></div>';
+            $query = "SELECT msg_dtm FROM glm_flight
+                        ORDER BY msg_dtm DESC
+                        LIMIT 1;";
+            $results = $wpdb->get_results($query, ARRAY_A);
+            foreach($results as $key=>$value){
+                $lastUpdated = date("n/j/Y g:i a", strtotime($value['msg_dtm']));
+            }
+            $this->last_updated = '<div id="last-update"><p>&nbsp;</p><p><b>Last updated:</b> '. $lastUpdated . '</p></div>';
 			//echo '<!--<pre>';
 			//print_r( $update_times );
 			//echo '</pre>-->';
-- 
2.17.1