From 6530f6f09995e26dcd0f5d5793c27fc54616f900 Mon Sep 17 00:00:00 2001 From: Boyd Stephen Smith Jr Date: Wed, 3 Aug 2011 21:18:55 -0500 Subject: [PATCH] Correct calls to sqlStatement to actually pass in the argument array. These errors were found by PHPLint. --- interface/batchcom/batch_phone_notification.php | 4 ++-- modules/sms_email_reminder/batch_phone_notification.php | 4 ++-- 2 files changed, 4 insertions(+), 4 deletions(-) diff --git a/interface/batchcom/batch_phone_notification.php b/interface/batchcom/batch_phone_notification.php index e6dcaadaa..3f065538d 100644 --- a/interface/batchcom/batch_phone_notification.php +++ b/interface/batchcom/batch_phone_notification.php @@ -163,7 +163,7 @@ function cron_getPhoneAlertpatientData( $type, $trigger_hours ) order by ope.pc_eventDate,ope.pc_endDate,pd.pid"; - $db_patient = (sqlStatement($query) , array($check_date) ); + $db_patient = (sqlStatement($query, array($check_date))); $patient_array = array(); $cnt=0; while ($prow = sqlFetchArray($db_patient)) @@ -186,7 +186,7 @@ function cron_InsertNotificationLogEntry($prow,$phone_msg,$phone_gateway) $sql_loginsert = "INSERT INTO `notification_log` ( `iLogId` , `pid` , `pc_eid` , `message`, `type` , `patient_info` , `smsgateway_info` , `pc_eventDate` , `pc_endDate` , `pc_startTime` , `pc_endTime` , `dSentDateTime` ) VALUES "; $sql_loginsert .= "(NULL , ?, ?, ?, 'Phone', ?, ?, ?, ?, ?, ?, ?)"; - $db_loginsert = ( sqlStatement( $sql_loginsert ), array($prow[pid], $prow[pc_eid], $message, $patient_info, $phone_gateway, $prow[pc_eventDate], $prow[pc_endDate], $prow[pc_startTime], $prow[pc_endTime], date("Y-m-d H:i:s")) ); + $db_loginsert = ( sqlStatement( $sql_loginsert, array($prow[pid], $prow[pc_eid], $message, $patient_info, $phone_gateway, $prow[pc_eventDate], $prow[pc_endDate], $prow[pc_startTime], $prow[pc_endTime], date("Y-m-d H:i:s")))); } //////////////////////////////////////////////////////////////////// diff --git a/modules/sms_email_reminder/batch_phone_notification.php b/modules/sms_email_reminder/batch_phone_notification.php index e6dcaadaa..3f065538d 100644 --- a/modules/sms_email_reminder/batch_phone_notification.php +++ b/modules/sms_email_reminder/batch_phone_notification.php @@ -163,7 +163,7 @@ function cron_getPhoneAlertpatientData( $type, $trigger_hours ) order by ope.pc_eventDate,ope.pc_endDate,pd.pid"; - $db_patient = (sqlStatement($query) , array($check_date) ); + $db_patient = (sqlStatement($query, array($check_date))); $patient_array = array(); $cnt=0; while ($prow = sqlFetchArray($db_patient)) @@ -186,7 +186,7 @@ function cron_InsertNotificationLogEntry($prow,$phone_msg,$phone_gateway) $sql_loginsert = "INSERT INTO `notification_log` ( `iLogId` , `pid` , `pc_eid` , `message`, `type` , `patient_info` , `smsgateway_info` , `pc_eventDate` , `pc_endDate` , `pc_startTime` , `pc_endTime` , `dSentDateTime` ) VALUES "; $sql_loginsert .= "(NULL , ?, ?, ?, 'Phone', ?, ?, ?, ?, ?, ?, ?)"; - $db_loginsert = ( sqlStatement( $sql_loginsert ), array($prow[pid], $prow[pc_eid], $message, $patient_info, $phone_gateway, $prow[pc_eventDate], $prow[pc_endDate], $prow[pc_startTime], $prow[pc_endTime], date("Y-m-d H:i:s")) ); + $db_loginsert = ( sqlStatement( $sql_loginsert, array($prow[pid], $prow[pc_eid], $message, $patient_info, $phone_gateway, $prow[pc_eventDate], $prow[pc_endDate], $prow[pc_startTime], $prow[pc_endTime], date("Y-m-d H:i:s")))); } //////////////////////////////////////////////////////////////////// -- 2.11.4.GIT