Fixed bug in scheduling table for null individual and/or family

[eq/.git] / inc / class.tc.inc.php

diff --git a/inc/class.tc.inc.php b/inc/class.tc.inc.php
index c44a589a02f7bd4c4621bc095aa6bb2f48d2107f..2ba160b6e96ef975fee667f0e94478be0876ae0e 100644 (file)
--- a/inc/class.tc.inc.php
+++ b/inc/class.tc.inc.php
@@ -1757,7 +1757,7 @@ class tc
                                $hti_pri = $entry['pri'];
                                //print "hti_notes: $hti_notes indiv_name: $indiv_name <Br>";
                                // Perform database save actions here
-                               $this->db->query("SELECT * FROM tc_companionship WHERE individual=$individual and valid=1",__LINE__,__FILE__);
+                               $this->db->query("SELECT * FROM tc_companion WHERE individual=$individual and valid=1",__LINE__,__FILE__);
                                if ($this->db->next_record()) {
                                        $scheduling_priority = $this->db->f('scheduling_priority');
                                        //$this->logToFile("int_sched", "UPDATE tc_scheduling_priority SET priority='$hti_pri', notes=\"$hti_notes\" WHERE scheduling_priority='$scheduling_priority'");
@@ -3573,6 +3573,10 @@ class tc
                                        $time = $hour.':'.$minute.':'.'00';
                                        $uid = 0;
 
+                                       // Zero out family or individual if they are invalid
+                                       if($indiv == "") { $indiv=0; }
+                                       if($family == "") { $family=0; }
+
                                        // Update our location
                                        if($location == "") {
                                                if($family > 0) {