Hello,
I have a wordpress plugin that I am receiving an error from while trying to run it via crontab. It also does not seem to work from the browser as it is suppost to kick off a scheduled process... here is what I have Any assistance would be helpful
error message received as cron output
/home/ycwvus/sms.xxx.us/sms/wp-content/plugins/wp-messaging/plugin_files/run_scheduler.php: line 1: syntax error near unexpected token ('
/home/ycwvus/sms.xxx.us/sms/wp-content/plugins/wp-messaging/plugin_files/run_scheduler.php: line 1:<?php
here is a copy of the script
<?php
// Load the WordPress Core
require_once( '/home/xxxus/sms.xxx.us/sms/wp-load.php' );
// Connect to Twilio API
require_once('connect_twilio.php');
global $wpdb;
global $user_ID;
// Show If there is any error
$wpdb->show_errors();
// DB tables
$table_user_ph = $wpdb->prefix.'nm_user_phone_numbers';
$table_gA = $wpdb->prefix.'nm_phone_number_group_assignment';
$table_client_ph = $wpdb->prefix.'nm_phone_numbers';
$table_group = $wpdb->prefix.'nm_client_groups';
$table_scheduler = $wpdb->prefix.'nm_scheduler';
// Get Results
$query_scheduler = $wpdb->get_results("SELECT * FROM $table_scheduler WHERE Status = '0'");
foreach($query_scheduler as $result => $scheduler)
{
$group_id = $scheduler->GroupID;
if(trim($scheduler->PhoneNumberID) == 'all')
{
$query_sub = $wpdb->get_results("SELECT $table_scheduler.*,$table_scheduler.mms_imgs as images,$table_group.PhoneNumber as clientPh,$table_user_ph.PhoneNumber,$table_gA.GroupID FROM $table_user_ph INNER JOIN $table_gA ON $table_user_ph.id = $table_gA.PhoneNumberID INNER JOIN $table_group ON $table_gA.GroupID = $table_group.id INNER JOIN $table_scheduler ON $table_scheduler.GroupID = $table_gA.GroupID AND $table_gA.GroupID = '".$group_id."' AND $table_user_ph.Status = '1' AND $table_scheduler.Status = '0' AND DATE($table_scheduler.DateTime) = '".date('Y-m-d')."' AND TIME($table_scheduler.DateTime) = '".date('H:i:00')."'");
foreach($query_sub as $result_sub => $subscribers)
{
$newarr=array();
if($subscribers->images!="")
{
$CampFile = explode(",",$subscribers->images);
foreach($CampFile as $k=>$file){
$newarr[$k] = plugins_url("../uploads/".$file,__FILE__);
}
}
if(is_array($newarr) && count($newarr)>0)
{
NM_sendMMS($subscribers->PhoneNumber,$subscribers->clientPh,$subscribers->SMSText,$newarr);
}else
{
NM_sendSMS($client,$subscribers->PhoneNumber,$subscribers->clientPh,$subscribers->SMSText,$ApiVersion,$AccountSid);
}
$data_array = array(
"Status" => '1'
);
$where = array(
"id" => $subscribers->id
);
$update_scheduler = $wpdb->update($table_scheduler,$data_array,$where);
}
}
else // PHONE NUMBER ID IS DEFINETALY NOT ALL.
{
$subscriber = $wpdb->get_results("SELECT ".$table_scheduler.".*,".$table_group.".PhoneNumber as clientPh,".$table_scheduler.".mms_imgs as images,".$table_user_ph.".PhoneNumber,".$table_gA.".GroupID FROM ".$table_user_ph." INNER JOIN ".$table_gA." ON ".$table_user_ph.".id = ".$table_gA.".PhoneNumberID INNER JOIN ".$table_group." ON ".$table_gA.".GroupID = ".$table_group.".id INNER JOIN ".$table_scheduler." ON ".$table_scheduler.".GroupID = ".$table_gA.".GroupID AND ".$table_gA.".GroupID = '".$group_id."' AND ".$table_user_ph.".Status = '1' AND ".$table_scheduler.".Status = '0' AND ".$table_scheduler.".PhoneNumberID = ".$table_user_ph.".id AND DATE(".$table_scheduler.".DateTime) = '".date('Y-m-d')."' AND TIME(".$table_scheduler.".DateTime) = '".date('H:i:00')."'",ARRAY_A);
if(count($subscriber)>0){
foreach($subscriber as $subscribers){
$newarr4=array();
if($subscribers['images']!="")
{
$CampFile = explode(",",$subscribers['images']);
foreach($CampFile as $k=>$file){
$newarr4[$k] = plugins_url("../uploads/".$file,__FILE__);
}
}
if(is_array($newarr4) && count($newarr4)>0)
{
NM_sendMMS($subscribers['PhoneNumber'],$subscribers['clientPh'],$subscribers['SMSText'],$newarr4);
}else
{
NM_sendSMS($client,$subscribers['PhoneNumber'],$subscribers['clientPh'],$subscribers['SMSText'],$ApiVersion,$AccountSid);
}
$data_array = array(
"Status" => '1'
);
$where = array(
"id" => $subscribers['id']
);
$update_scheduler = $wpdb->update($table_scheduler,$data_array,$where);
}
}
}
}
// Campaign Scheduling For Delayed Sending Controlling Starts From Here.
$run_campaign_scheduling = $wpdb->get_results("SELECT * FROM `".$table_group."`
WHERE
`DelayTime1`!='00:00:00'
AND
`DelayTime2`!='00:00:00'
AND
`DelayTime3`!='00:00:00'
",ARRAY_A);
// DEBUG
if(isset($_GET['log'])){
echo "Groups Searched ".count($run_campaign_scheduling)."<br>";
echo "Now Time: ".date("H:i:00")."<br>";
}
// CAMPAIGN SCHEDULING
foreach($run_campaign_scheduling as $runC){
// GROUP ID
$theGroupID = $runC['id'];
$theSubscriber = $wpdb->get_results("SELECT * FROM ".$table_gA." where GroupID='".$theGroupID."'",ARRAY_A);
// Fetched Results From Subscruber Record
foreach($theSubscriber as $subs){
$THEPhoneNumberID = $subs['PhoneNumberID'];
// Get The Real Phone Number
$GetSubNumber = $wpdb->get_row("SELECT * FROM ".$table_user_ph." WHERE `id`='".$THEPhoneNumberID."'",ARRAY_A);
// Twilio Phone Number
$THESystemNumber = $runC['PhoneNumber'];
// Subscriber Phone Number
$theRealNumber = $GetSubNumber['PhoneNumber'];
// Date for Delayed Section # 1
$delay1 = $GetSubNumber['DayDelay1'];
// Date for Delayed Section # 2
$delay2 = $GetSubNumber['DayDelay2'];
// Date for Delayed Section # 3
$delay3 = $GetSubNumber['DayDelay3'];
// Delayed Sender Time #1
$time1 = $GetSubNumber['DelayTime1'];
// Delayed Sender Time #2
$time2 = $GetSubNumber['DelayTime2'];
// Delayed Sender Time #3
$time3 = $GetSubNumber['DelayTime3'];
// Delay Message #1
$firstMessage = $runC['SubscriptionSMS1'];
// Delay Messaeg #2
$secondMessage = $runC['SubscriptionSMS2'];
// Delay Messaeg #3
$thirdMessage = $runC['SubscriptionSMS3'];
if($time1==date("H:i:00") && $delay1 == date('Y-m-d')){
if($runC['Delay1File']){
if(isset($_GET['log'])){ // DEBUG
echo "<br> First MEssege Send <br>";
}
$mms = explode(",",$runC['Delay1File']);
foreach($mms as $file){
if($file!=''){
$images[] = plugins_url("../uploads/".$file,__FILE__);
}
}
NM_sendMMS($client, $theRealNumber,$THESystemNumber,$firstMessage,$images);
}else{
// Send SMS
NM_sendSMS($client,$theRealNumber,$THESystemNumber,$firstMessage,$ApiVersion,$AccountSid);
}
}
if($time2==date("H:i:00") && $delay2 == date('Y-m-d')){
if($runC['Delay2File']){
if(isset($_GET['log'])){ // DEBUG
echo "<br> Second MEssege Send <br>";
}
$mms = explode(",",$runC['Delay2File']);
foreach($mms as $file){
if($file!=''){
$images[] = plugins_url("../uploads/".$file,__FILE__);
}
}
NM_sendMMS($client, $theRealNumber,$THESystemNumber,$secondMessage,$images);
}else{
// Send SMS
NM_sendSMS($client,$theRealNumber,$THESystemNumber,$secondMessage,$ApiVersion,$AccountSid);
}
}
if($time3==date("H:i:00") && $delay3 == date('Y-m-d')){
if($runC['Delay3File']){
if(isset($_GET['log'])){ // DEBUG
echo "<br> Third MEssege Send <br>";
}
$mms = explode(",",$runC['Delay3File']);
foreach($mms as $file){
if($file!=''){
$images[] = plugins_url("../uploads/".$file,__FILE__);
}
}
NM_sendMMS($client, $theRealNumber,$THESystemNumber,$thirdMessage,$images);
}else{
// Send SMS
NM_sendSMS($client,$theRealNumber,$THESystemNumber,$thirdMessage,$ApiVersion,$AccountSid);
}
}
}
}
?>
