<?php

include "../general.php";
include "../connect.php";

date_default_timezone_set('Africa/Lagos'); 
$cnt = 1;
$cnt2=0;
while($cnt ==1){
    $query= "SELECT sn,messageid,status FROM thesmsworkslog where flag ='0' order by sn limit 1";
    $con=mysqli_connect("127.0.0.1","smsEngine","guEnaR28T","smartsmsrouter");
       ///Check connection
    if (mysqli_connect_errno())
    {
         return '#';
         die();
    }
    if(!$result= mysqli_query($con,$query))
    {
       mysqli_close($con);
     return "#";
    }
    else
    {
        
       while ($row = mysqli_fetch_array($result))
        {
            
            $sn = $row[0];
            $messageid = $row[1];
            $status =  $row[2];
            echo "Processing Status" ."\n";
            echo "Messageid ". $messageid."\n";
            echo "Status " .$status ."\n";
           
             //update the messagesent
             $query = "update messagesent set status ='$status',track='2' where messageid = '$messageid' ";
             $queryresponse = updateQuery($query);
           
            //update the record
              $query = "update thesmsworkslog set flag ='1' where sn = $sn ";
              $queryresponse = updateQuery($query);
              $cnt2++;
        
        sleep(5);
       
        }

      } //else
    
    


    echo "\nTotal Status Messages updated ... ".$cnt2 ."\n". date("Y-m-d h:i:s",time())."\n";
    sleep(15);
   
}//end main while


?>