Gecko [ v3.cesa.co.za ]

Name	Size	Permission	Date
Mandrill	[ DIR ]	drwxr-sr-x	2016-02-10 08:42
temp	[ DIR ]	drwxr-sr-x	2022-06-16 13:37
.htaccess	35 B	-rw-r--r--	2023-03-13 09:52
CESA_Ci Applications2b.pdf	800.6 KB	-rw-r--r--	2008-08-14 11:23
CESA_vector logo_high res.jpg	334.84 KB	-rw-r--r--	2008-08-14 11:10
Fulton_Press_small.pdf	84.39 KB	-rw-r--r--	2008-08-11 10:41
LAUNCH OF CESA.pdf	69.23 KB	-rw-r--r--	2008-08-14 11:24
Mandrill.php	6.44 KB	-rw-r--r--	2016-02-10 08:42
Overview_template_QMS_for_SMME-v2 _2.pdf	43.08 KB	-rw-r--r--	2008-09-26 12:04
ToSendProcess.php	46.4 KB	-rw-r--r--	2026-04-01 10:55
XPertMailer.php	38.69 KB	-rw-r--r--	2008-08-06 07:29
ad-reminders.php	2.7 KB	-rw-r--r--	2024-05-16 09:16
awards-from-forminator-debug.php	7.13 KB	-rw-r--r--	2025-06-23 16:02
awards-from-forminator-direct.php	9.69 KB	-rw-r--r--	2025-06-24 06:23
awards-from-forminator-fixed.php	7.42 KB	-rw-r--r--	2025-06-23 16:09
awards-from-forminator-step-by-step.php	6.93 KB	-rw-r--r--	2025-06-23 16:12
awards-from-forminator.php	18.54 KB	-rw-r--r--	2026-06-29 10:02
batch-job.php	948 B	-rw-r--r--	2026-08-24 10:20
bulk-mail-check.php	443 B	-rw-r--r--	2025-08-22 11:48
checkmail.php	6.35 KB	-rw-r--r--	2008-08-06 09:18
class.email-reader.php	15.58 KB	-rw-r--r--	2008-08-06 09:18
cron-5-minutes-root.sh	527 B	-rwxr-xr-x	2026-08-21 08:23
cron-daily-v3.sh	192 B	-rwxr-xr-x	2025-09-11 17:37
cron-daily.sh	500 B	-rwxr-xr-x	2025-12-29 09:32
cron-hourly.sh	413 B	-rwxr-xr-x	2025-09-01 13:33
cron-monthly.sh	83 B	-rwxr-xr-x	2025-06-27 15:38
cron.sh	369 B	-rwxr-xr-x	2026-04-16 10:02
export-attendees-google.php	3.07 KB	-rw-r--r--	2026-08-24 10:20
export-member-data-google.php	3.69 KB	-rw-r--r--	2026-08-24 10:20
export.php	1.96 KB	-rw-r--r--	2010-04-13 14:54
exportgooglecontacts.php	1.18 KB	-rw-r--r--	2022-06-16 14:41
import.php.bak	4.84 KB	-rw-r--r--	2010-05-06 07:59
importdup.php	3.34 KB	-rw-r--r--	2010-05-19 14:20
importschool.php	5.09 KB	-rw-r--r--	2010-05-19 14:05
php8.1_cli_errors.log	43.15 KB	-rw-r--r--	2025-12-31 10:58
phpinfo.php	20 B	-rw-r--r--	2024-04-16 11:40
receivemail.class.php	4.65 KB	-rw-r--r--	2008-08-06 07:51
sce-send-certificates.php	750 B	-rw-r--r--	2026-08-24 10:20
sendlater.php	12.86 KB	-rw-r--r--	2026-01-16 09:53
sendsms.php	4.3 KB	-rw-r--r--	2026-01-16 09:43
simple-wp-test.php	1.74 KB	-rw-r--r--	2025-06-23 16:05
sync-anual-declarations.php	3.22 KB	-rw-r--r--	2026-08-24 10:20
system-checks.php	798 B	-rw-r--r--	2026-08-24 10:20
test-send.php	786 B	-rw-r--r--	2024-04-11 07:55
test-wp-load.php	2.29 KB	-rw-r--r--	2025-06-23 16:02
training-material-expiry-check.php	4.12 KB	-rw-r--r--	2026-06-12 11:48
training-provider-expiry-check.php	4.51 KB	-rw-r--r--	2026-06-12 11:48
unemployed-reminders.php	2.43 KB	-rw-r--r--	2024-05-16 09:06
update-qms-cert-status.php	3.54 KB	-rw-r--r--	2026-08-24 10:20
wp-diagnostic.php	4.39 KB	-rw-r--r--	2025-06-23 16:08
wp-load-bypass.php	3.03 KB	-rw-r--r--	2025-06-23 16:08
wp-load-minimal.php	3.01 KB	-rw-r--r--	2025-06-23 16:08

Rename

<?php

if (!isset($_SERVER['DOCUMENT_ROOT']) || strlen($_SERVER['DOCUMENT_ROOT']) <= 0) {
    $_SERVER['DOCUMENT_ROOT'] = str_replace('/crons', '', getcwd());
    // echo getcwd();
}

function SendSMS($to, $msg) {
	
	$sendurl="http://api.clickatell.com/http/sendmsg?user=CESA1SMS&password=abc123&api_id=3321299&concat=2&to=".$to."&text=".substr(urlencode($msg),0,320);

//	echo "SMS ".$msg." to ".$to;

$ch = curl_init($sendurl);

curl_setopt($ch, CURLOPT_FRESH_CONNECT, 1);
	curl_setopt($ch, CURLOPT_HEADER, 0);
	curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
	
	$response = curl_exec($ch);
	var_dump($response);
	curl_close($ch);
}

function SendFromTables($SMSLog, $SMSSendLog) {
	global $db;
	// Get the message
	$sql = "SELECT * FROM ".$SMSLog." WHERE SMStart<='".date("Y-m-d H:i:s")."' AND SMSComplete=0";
	$rsMsg = mysqli_query($db, $sql);

echo ".";
	flush();
	ob_flush();
	
	while ($rsM = mysqli_fetch_assoc($rsMsg)) {
		
		$bSendFinished = false;
	
		while (!$bSendFinished) {
			$sql = "SELECT SMSToID, SMSToNumber FROM ".$SMSSendLog." WHERE SMSID='".$rsM["SMSID"]."' and SMSSent=0 ORDER BY SMSToNumber LIMIT 0, 50";
			
			$rsRec = mysqli_query($db, $sql);
			
			if (mysqli_num_rows($rsRec) <= 0) {
				$bSendFinished = true;
				$sql="UPDATE ".$SMSLog." SET SMSComplete=1, SMSEnd='".date("Y-m-d H:i:s")."' WHERE SMSID='".$rsM["SMSID"]."'";
				mysqli_query($db, $sql);
			} else {
			
				$IDList = "";
				$ToList = "";
				$iMsgsSent=0;
				while ($rsR = mysqli_fetch_assoc($rsRec)) {
					$to = $rsR["SMSToNumber"];
					if (!empty($to)) {
						$to = str_replace(array("(",")"," ","-"),"",$to);
						$to=ltrim($to,"+27");
						$to=ltrim($to,"0");
						$to = "0".$to;
		
						$ToList .= $to.",";
						$iMsgsSent++;
					}
					$IDList .= $rsR["SMSToID"].",";
				}
				$ToList = rtrim($ToList, ",");
				$IDList = rtrim($IDList, ",");
				
				SendSMS($ToList, $rsM["SMSText"]);
				
				$bSomethingSent = true;
				
				$sql = "UPDATE ".$SMSSendLog." SET SMSSent=1 WHERE SMSToID in (".$IDList.")";
				mysqli_query($db, $sql);

$sql = "UPDATE ".$SMSLog." SET SMSProgressCount=SMSProgressCount+".$iMsgsSent." WHERE SMSID='".$rsM["SMSID"]."'";
				mysqli_query($db, $sql);

echo $ToList."<BR>";
				echo ".";
				flush();
				ob_flush();
			}
			mysqli_free_result($rsRec);

//wait for a quarter second
			usleep(100000);
		}
	}
}

//if ($_GET["override"] != 1) die();

ini_set('max_execution_time', '0'); // 0 = no limit
ob_start();

include_once($_SERVER['DOCUMENT_ROOT'] . "/cfg/config.php");
$db = mysqli_connect(EW_CONN_HOST, EW_CONN_USER, EW_CONN_PASS, EW_CONN_DB);

$bCanSend = false;
$bSomethingSent = false;

$sql = "SELECT ConfigName, ConfigValue FROM Config WHERE ConfigName in ('StartSMSSend', 'EndSMSSend')";
$rsRec = mysqli_query($db, $sql);
$dtStartSend = "";
$dtEndSend = "";
while ($rsR = mysqli_fetch_assoc($rsRec)) {
	if ($rsR["ConfigName"]=="StartSMSSend") $dtStartSend = date("Y-m-d H:i:s", strtotime($rsR["ConfigValue"]));
	if ($rsR["ConfigName"]=="EndSMSSend") $dtEndSend = date("Y-m-d H:i:s", strtotime($rsR["ConfigValue"]));
}

if ((time() - strtotime($dtEndSend)) > 0) $bCanSend = true;

if ($bCanSend) {
	
	// Make sure another instance of this script doesn't start sending!!
	$sql = "UPDATE Config SET ConfigValue='".date("Y-m-d H:i:s")."' WHERE ConfigName='StartSMSSend'";
	mysqli_query($db, $sql);
	$sql = "UPDATE Config SET ConfigValue='2020-01-01' WHERE ConfigName='EndSMSSend'";
	mysqli_query($db, $sql);
	
	$sql="UPDATE MemberContacts JOIN SMSUnsubscribe ON (REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(MemberContacts.`CellPhone`, '+27', ''), ' ', ''), '(', ''), ')', ''), '-', '')=SMSUnsubscribe.`MobileNumber`) SET MemberContacts.`SMSUnsubscribe`=1";
	mysqli_query($db, $sql);

$sql="UPDATE OfficeContacts JOIN MemberContacts ON (ContactsID=ContactID) SET OfficeContacts.`SMSUnsubscribe`=1 WHERE MemberContacts.`SMSUnsubscribe`=1";
	mysqli_query($db, $sql);

SendFromTables("SMSLog", "SMSSendLog");
	SendFromTables("SchoolSMSLog", "SchoolSMSSendLog");
	SendFromTables("EventSMSLog", "EventSMSSendLog");

$sql = "UPDATE Config SET ConfigValue='".date("Y-m-d H:i:s")."' WHERE ConfigName='EndSMSSend'";
	mysqli_query($db, $sql);

} else {
	echo "Can't send yet.";
}

flush();
ob_flush();
				
?>