$pos2 = 0; $Changed = 0; $Requested = 0; $Scanned = 0; $Discovered = 0; $ReDiscovered = 0; $DoUpdate = 0; $Change = strpos(' ' . $results[0]['Cyber_Gplus_Link'],'Changed',0); $Request = strpos(' ' . $results[0]['Cyber_Gplus_Link'],'Requested',0); $Scan = strpos(' ' . $results[0]['Cyber_Gplus_Link'],'Scanned',0); $Discover = strpos(' ' . $results[0]['Cyber_Gplus_Link'],'Discovered',0); $ReDiscover = strpos(' ' . $results[0]['Cyber_Gplus_Link'],'ReDiscovered',0); if ($Change === false) {} else {$Changed = 1;} if ($Request === false) {} else {$Requested = 1;} if ($Scan === false) {} else {$Scanned = 1;} if ($Discover === false) {} else {$Discovered = 1;} if ($ReDiscover === false) {} else {$ReDiscovered = 1;} $LineArray[3] = str_replace('[','',$LineArray[3]); $pos2 = 0; $Time1 = strpos($LineArray[3],'/',$pos2); $Time2 = strpos($LineArray[3],'/',$Time1+1); $Time3 = strpos($LineArray[3],':',$Time2+1); $Time4 = strpos($LineArray[3],':',$Time3+1); $Time5 = strpos($LineArray[3],':',$Time4+1); $T1 = substr($LineArray[3],0,$Time1); $T2 = substr($LineArray[3],$Time1+1,$Time2-$Time1-1); $T3 = substr($LineArray[3],$Time2+1,$Time3-$Time2-1); $T4 = substr($LineArray[3],$Time3+1,$Time4-$Time3-1); $T5 = substr($LineArray[3],$Time4+1,$Time5-$Time4-1); $T6 = substr($LineArray[3],$Time5+1,10); $NewTime = $T2 . ' ' . $T1 . ' ' . $T3 . ' ' . $T4 . ':' . $T5 . ':' . $T6; $Tcode = strtotime($NewTime); if ($Requested == 1) { $NewMsg = 'Scanned ' . date("Y-m-d H:i:s",$Tcode) .' ' . $results[0]['Cyber_Gplus_Link']; $NewMsg = str_replace('Requested','Req',$NewMsg); $DoUpdate = 1; } if ($Scanned == 1) { if ($NewDiscovery == 1) if ($Tcode > $NewDiscoveryTcode) { $NewMsg = 'ReDiscovered ' . date("Y-m-d H:i:s",$Tcode) .' ' . $results[0]['Cyber_Gplus_Link']; $NewMsg = str_replace('Scanned','Scan',$NewMsg); $DoUpdate = 1; $MailTo = 'gary@the-cyber-zone.com'; $MailFrom = 'admin@super-cyber-mall.com'; $MailSubject = 'Re Scan'; $MailBody = $NewMsg . ' ' . $TheIndex;; emailit($MailTo,$MailFrom,$MailSubject,$MailBody); } } if ($ReDiscovered == 1) { if ($NewDiscovery == 1) if ($Tcode > $NewDiscoveryTcode) { $NewMsg = 'ReDiscovered ' . date("Y-m-d H:i:s",$Tcode) .' ' . $results[0]['Cyber_Gplus_Link']; $NewMsg = str_replace('Scanned','Scan',$NewMsg); $DoUpdate = 1; $MailTo = 'gary@the-cyber-zone.com'; $MailFrom = 'admin@super-cyber-mall.com'; $MailSubject = 'Re Scan'; $MailBody = $NewMsg . ' ' . $TheIndex;; // emailit($MailTo,$MailFrom,$MailSubject,$MailBody); } } if ($ReDiscovered == 0) if ($Discovered == 0) if ($Scanned == 0) if ($Requested == 0) if ($Changed == 0) { $NewMsg = 'Discovered ' . date("Y-m-d H:i:s",$Tcode); $DoUpdate = 1; } if ($DoUpdate == 1) { $sql= "UPDATE `CyberSales` SET Cyber_Gplus_Link = '" . $NewMsg . "' WHERE Cyber_Index = " . $TheIndex; echo PHP_EOL . $sql; echo PHP_EOL . $NewRequest; echo PHP_EOL . 'New Msg ' . $NewMsg; $items = $pdo->prepare($sql); $items->execute(); } }