From 1c4666ece3b5d77a53d893e31ed06535d978e511 Mon Sep 17 00:00:00 2001 From: Owen Leonard Date: Fri, 1 Oct 2010 15:04:24 -0600 Subject: [PATCH] fixed so that tc_presidency.email trumps tc_individual.email when sending out appt invites --- inc/class.tc.inc.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/inc/class.tc.inc.php b/inc/class.tc.inc.php index ae33d78..a6ad7c1 100644 --- a/inc/class.tc.inc.php +++ b/inc/class.tc.inc.php @@ -4257,7 +4257,7 @@ class tc $dtstart = gmdate("Ymd"."\T"."His"."\Z", mktime($hour,$minute,$seconds,$month,$day,$year)); $dtstartstr = date("l, F d, o g:i A", mktime($hour,$minute,$seconds,$month,$day,$year)); - $sql = "SELECT * FROM tc_presidency AS tp JOIN tc_individual AS ti WHERE tp.individual=ti.individual AND tp.presidency='$presidency'"; + $sql = "SELECT tp.email AS email, ti.name AS name FROM tc_presidency AS tp JOIN tc_individual AS ti WHERE tp.individual=ti.individual AND tp.presidency='$presidency'"; $this->db2->query($sql,__LINE__,__FILE__); if($this->db2->next_record()) { $email = $this->db2->f('email'); -- 2.34.1