From f043aa9ef5f150757d49f113307ea912c23006bc Mon Sep 17 00:00:00 2001 From: "Alan J. Pippin" Date: Sun, 6 Jul 2008 22:52:46 -0600 Subject: [PATCH 1/1] Fixed bug in querying eqpres PPI history in scheduling tool. --- inc/class.eq.inc.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/inc/class.eq.inc.php b/inc/class.eq.inc.php index dd8cff7..7f0d5a6 100644 --- a/inc/class.eq.inc.php +++ b/inc/class.eq.inc.php @@ -1599,7 +1599,7 @@ class eq $this->db2->query($sql,__LINE__,__FILE__); if(!$this->db2->next_record()) { - $sql = "SELECT * FROM eq_ppi WHERE elder=" . $id . " ORDER BY date DESC"; + $sql = "SELECT * FROM eq_ppi WHERE elder=" . $id . " AND eqpresppi=1 ORDER BY date DESC"; $this->db->query($sql,__LINE__,__FILE__); if($this->db->next_record()) { $date = $this->db->f('date'); } else { $date = ""; } $link_data['menuaction'] = 'eq.eq.ppi_update'; -- 2.34.1