From e1dfc19d1e8d5f6bead52096075df731ac7b3256 Mon Sep 17 00:00:00 2001
From: lemonsoftwarero <lemonsoftwarero>
Date: Mon, 2 Jul 2007 09:15:57 +0000
Subject: [PATCH] Fix a nasty bug; avoid 0 value for pc_multiple field.

---
 interface/main/calendar/add_edit_event.php | 9 +++++++--
 1 file changed, 7 insertions(+), 2 deletions(-)

diff --git a/interface/main/calendar/add_edit_event.php b/interface/main/calendar/add_edit_event.php
index 7d00ff1eb..d1c8b6af1 100644
--- a/interface/main/calendar/add_edit_event.php
+++ b/interface/main/calendar/add_edit_event.php
@@ -113,6 +113,9 @@
     // what is multiple key around this $eid?
     $row = sqlQuery("SELECT pc_multiple FROM openemr_postcalendar_events WHERE pc_eid = $eid");
 
+	// we make sure that we don't get a 0 result (0 is the default value for pc_multiple field)
+	if ( $row['pc_multiple'] ) {
+
     // obtain current list of providers regarding the multiple key
     $up = sqlStatement("SELECT pc_aid FROM openemr_postcalendar_events WHERE pc_multiple={$row['pc_multiple']}");
     while ($current = sqlFetchArray($up)) {
@@ -184,7 +187,7 @@
             "pc_prefcatid = '"   . $_POST['form_prefcat']              . "' "  .
               "WHERE pc_aid = '$provider' AND pc_multiple={$row['pc_multiple']}");
         } // foreach
- 
+	}	// if ( $row['pc_multiple'] )
 /* ==========================================
 // multi providers EOS
 ==========================================*/
@@ -335,7 +338,9 @@ sqlInsert("INSERT INTO openemr_postcalendar_events ( " .
         if ($GLOBALS['select_multi_providers']) {
              // what is multiple key around this $eid?
             $row = sqlQuery("SELECT pc_multiple FROM openemr_postcalendar_events WHERE pc_eid = $eid");
-            sqlStatement("DELETE FROM openemr_postcalendar_events WHERE pc_multiple = {$row['pc_multiple']}");
+			if ( $row['pc_multiple'] ) {
+				sqlStatement("DELETE FROM openemr_postcalendar_events WHERE pc_multiple = {$row['pc_multiple']}");
+			}
         // =======================================
         //  EOS multi providers case
         // =======================================
-- 
2.11.4.GIT