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
include("../inc/auth.inc");

/*
$arrTables = array('Contacts', 'tblMemberFirms', 'OfficeContacts', 'MemberContacts', 'tblMemberFirmOffices', 
'qryEvaluationValid', 'vwNLCMembersContacts', 'EventSchedules', 'IndustryEvents', 'IndustrySchedules', 
'NLCClientBody', 'NLCOrdering', 'NLCBranchesFeedback', 'NLCReports', 'PriceList', 'SAACEBranches', 
'SAACEOfficeBearers', 'SchoolEvents', 'SchoolFacilitators', 'SchoolProviders', 'SchoolPresenters', 
'tblCommittees', 'tblCommitteeMembers', 'TrainingEvaluators', 'TrainingMaterial', 'SchoolAttendees', 
'CourseVenues', 'SchoolBankAccs');
*/

$arrTables = array('Contacts', 'tblMemberFirms', 'OfficeContacts', 'MemberContacts', 'tblMemberFirmOffices', 
'qryEvaluationValid', 'vwNLCMembersContacts', 'EventSchedules', 'IndustryEvents', 'IndustrySchedules', 
'NLCClientBody', 'NLCOrdering', 'NLCBranchesFeedback', 'NLCReports', 'PriceList', 
'SchoolEvents', 'SchoolFacilitators', 'SchoolProviders', 'SchoolPresenters', 
'TrainingEvaluators', 'TrainingMaterial', 'SchoolAttendees', 
'CourseVenues', 'SchoolBankAccs');

// $arrTables = array('Contacts', 'tblMemberFirms', 'OfficeContacts', 'MemberContacts', 'tblMemberFirmOffices');

$db = mysql_connect($loghost,$logid,$logpwd);
mysql_select_db($dbname,$db);

$sErrors = "";

// Is the synchronisation enabled?
$bSynchEnabled = false;
$dtSynchLastDate = date("Y-m-d H:i");
$sql = "SELECT SynchEnable, SynchLastDate FROM SynchConfig";
$rec = mysql_query($sql);
if ($row = mysql_fetch_assoc($rec)) {
	if ($row["SynchEnable"] == 1) $bSynchEnabled = true;
	$dtSynchLastDate = date("Y-m-d H:i", strtotime($row["SynchLastDate"]));
}
mysql_free_result($rec);

if ($bSynchEnabled) {

// delete copy of website log (created for download by SAACEPDC)
	if (file_exists("/usr/www/users/saacea/data_from_saace/weblog.sql")) {
		rename("/usr/www/users/saacea/data_from_saace/weblog.sql", "/usr/www/users/saacea/data_from_saace/weblog.".date("YmdHi").".sql");
	}
	
	// execute sql log from SAACEPDC
	if (file_exists("/usr/www/users/saacea/data_from_saace/log.sql")) {
		$fp = fopen("/usr/www/users/saacea/data_from_saace/log.sql", "r");
		while ($sline = fgets($fp)) {
			$result = mysql_query($sline);
			if (!$result) $sErrors .= "Cannot execute from log file: ".$sline.", Error: ".mysql_error()."\r\n";
		}
		fclose($fp);
	
		// delete SAACEPDC log (uploaded by SAACEPDC)
		rename("/usr/www/users/saacea/data_from_saace/log.sql", "/usr/www/users/saacea/data_from_saace/log.".date("YmdHi").".sql");
	}
	
	for ($i=0; $i < count($arrTables); $i++) {
	
		$csvfile = "/usr/www/users/saacea/data_from_saace/".$arrTables[$i].".csv";
		$gzfile = $csvfile.".gz";
	
		if (file_exists($gzfile)) {
			
			// is this file new (since the last synch)?
			if (date("Y-m-d H:i", filemtime($gzfile)) <= $dtSynchLastDate) {
				$sErrors .= $gzfile." too old."."\r\n";
			} else {
	
				// decompress file
				$fp = gzopen($gzfile, "r");
				$contents = gzread($fp, 4*1024*1024);
				gzclose($fp);
				
				if (empty($contents)) {
						$sErrors .= $gzfile." is empty."."\r\n";
				} else {

$arrlines = preg_split("/((\r(?!\n))|((?<!\r)\n)|(\r\n))/", $contents);
					unset($contents);

$fp2 = fopen($csvfile, "w");

for ($line=0; $line < count($arrlines); $line++) {
						$contents = $arrlines[$line];
						// transform dates
						$patterns = array ('#(\d{1,2})/(\d{1,2})/(19|20)(\d{2})#');
						$replace = array ('\3\4-\1-\2');
						$contents = preg_replace($patterns, $replace, $contents);	
						
						// transform booleans
						$contents = str_replace("|\"True\"|", "|1|", $contents);
						$contents = str_replace("|\"False\"|", "|0|", $contents);
						$contents = str_replace("|\"True\"|", "|1|", $contents);
						$contents = str_replace("|\"False\"|", "|0|", $contents);
						$contents = str_replace("|\"True\"|", "|1|", $contents);
						$contents = str_replace("|\"False\"|", "|0|", $contents);
					
						fwrite($fp2, $contents);
						
						fwrite($fp2, '\r\n');

unset($contents);

}
					fclose($fp2);
					
					echo $arrTables[$i].".csv.gz unzipped<BR>";
					
					// clear database table
					$sql = "DELETE FROM ".$arrTables[$i];
					mysql_query($sql) or $sErrors .= $arrTables[$i]." delete error: ".mysql_error()."\r\n";
					
					// upload to database table
					$sql = "LOAD DATA LOCAL INFILE '".$csvfile."'
					REPLACE
					INTO TABLE ".$arrTables[$i]."
					FIELDS
					TERMINATED BY '|'
					OPTIONALLY ENCLOSED BY '\"'
					LINES
					TERMINATED BY '\$#'
					";
					
					mysql_query($sql) or $sErrors .= $arrTables[$i]." import error: ".mysql_error()."\r\n";
					echo $arrTables[$i]." imported<br>";
				}
			}
		} else {
			$sErrors .= $gzfile." does not exist"."\r\n";
		}
		
	}
	
	if (!empty($sErrors)) mail("julia@xe.co.za", "Errors during CESA import", $sErrors);
	
	mysql_query("UPDATE SynchConfig SET SynchLastDate='".date("Y-m-d H:i")."'");
} else {
	mail("julia@xe.co.za","CESA DB Synch Disabled","");
}
?>