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

// Start output buffering to prevent "headers already sent" warnings
ob_start();

ini_set('display_errors', 1);
error_reporting(E_ALL);

// Set required server variables for WordPress
if (!isset($_SERVER['HTTP_HOST'])) {
    $_SERVER['HTTP_HOST'] = 'localhost';
}
if (!isset($_SERVER['REQUEST_URI'])) {
    $_SERVER['REQUEST_URI'] = '/';
}

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

echo "=== Awards Script Starting ===\n";
echo "Document root: " . $_SERVER['DOCUMENT_ROOT'] . "\n";

// Include required files
echo "Loading required files...\n";
include_once($_SERVER['DOCUMENT_ROOT'] . "/ADOdb/adodb.inc.php");
include_once($_SERVER['DOCUMENT_ROOT'] . "/vendor/autoload.php");
include_once($_SERVER['DOCUMENT_ROOT'] . "/cfg/config.php");
include_once($_SERVER['DOCUMENT_ROOT'] . "/php/includes/sqlFunctions.php");
include_once($_SERVER['DOCUMENT_ROOT'] . "/php/includes/BaseTableClass.php");
include_once($_SERVER['DOCUMENT_ROOT'] . "/php/includes/MemberFirm.php");

echo "Loading WordPress...\n";

// Load WordPress with error handling
try {
    require_once($_SERVER['DOCUMENT_ROOT'] . '/wp-load.php');
    echo "✓ WordPress loaded successfully\n";
} catch (Exception $e) {
    echo "✗ Error loading WordPress: " . $e->getMessage() . "\n";
    exit(1);
}

// Verify WordPress functions are available
if (!function_exists('get_post_meta')) {
    echo "✗ WordPress function get_post_meta is not available. WordPress may not have loaded properly.\n";
    exit(1);
}

echo "✓ WordPress functions available\n";

// Create database connection
echo "Creating database connection...\n";
$sqlfWP = new sqlFunctions(WP_HOST, WPDB_USER, WPDB_PASS, WPDB_DB);

// Query for forminator forms
$wpFormsSQL = "SELECT * FROM wp_posts p "
    . "INNER JOIN wp_postmeta pm ON p.id = pm.post_id "
    . "WHERE p.post_type = 'forminator_forms'";

echo "Executing query: " . $wpFormsSQL . "\n";

$wpForms = $sqlfWP->getAll($wpFormsSQL);
echo "Found " . count($wpForms) . " forminator forms\n";

$forms = array();

// Process each form
foreach ($wpForms as $wpForm) {
    echo "Processing form ID: " . $wpForm['ID'] . "\n";

try {
        $formMeta = get_post_meta($wpForm['ID']);
        $forminatorMeta = unserialize($formMeta['forminator_form_meta'][0]);

if (!$forminatorMeta) {
            echo "  ✗ Could not unserialize form meta for form ID: " . $wpForm['ID'] . "\n";
            continue;
        }

$formName = $forminatorMeta['settings']['form_name'] ?? 'unknown';
        echo "  Processing form: " . $formName . "\n";

$forms[$formName] = array(
            'name' => $forminatorMeta['settings']['formName'] ?? $formName,
            'fields' => array(),
            'entries' => array()
        );
        $entriesFinal = array();

// Process form fields
        if (isset($forminatorMeta['fields']) && is_array($forminatorMeta['fields'])) {
            foreach ($forminatorMeta['fields'] as $field) {
                if (isset($field['field_label'])) {
                    $forms[$formName]['fields'][$field['id']] = array('label' => $field['field_label']);
                }
            }
        }

// Get form entries
        $entrySQL = "SELECT * FROM wp_frmt_form_entry WHERE form_id = " . $wpForm['ID'];
        $formEntries = $sqlfWP->getAll($entrySQL);
        echo "  Found " . count($formEntries) . " entries\n";

$entries = array();

// Process each entry
        foreach ($formEntries as $formEntry) {
            echo "    Processing entry ID: " . $formEntry['entry_id'] . "\n";

$oneEntry = array(
                'ExternalFormID' => $formName,
                'ExternalEntryID' => $formEntry['entry_id'],
                'EntryFormName' => $forminatorMeta['settings']['formName'] ?? $formName,
                'FirmName' => '',
                'FormFields' => array(),
                'PreEntryHTML' => '<table border="0" cellpadding="4" cellspacing="0" border="0">',
                'FullEntryHTML' => '',
                'JV_Partners' => '',
            );

$entries[$formEntry['entry_id']] = array();

// Process each field in the entry
            foreach ($forms[$formName]['fields'] as $fieldId => $vals) {
                $fieldSQL = "SELECT * FROM wp_frmt_form_entry_meta WHERE entry_id = " . $formEntry['entry_id'] . " AND meta_key = '" . $fieldId . "'";
                $fieldValue = $sqlfWP->getRow($fieldSQL);
                $labelText = trim($forms[$formName]['fields'][$fieldId]['label']);

if (is_array($fieldValue) && isset($fieldValue['meta_value'])) {
                    // Process field value based on field type and label
                    if (in_array($fieldId, array('text-1'))) {
                        $oneEntry['Firm_Name'] = $fieldValue['meta_value'];
                    }

if (
                        $labelText == 'Which awards category(ies) are you entering for? (Please select all relevant)' ||
                        $labelText == 'Name of Award Category' ||
                        $labelText == 'Which Award Category is the Submission for?'
                    ) {

$numEntries = 0;
                        if (strpos(' ' . $fieldValue['meta_value'], '{') > 0) {
                            $fieldValue['meta_value'] = unserialize($fieldValue['meta_value']);
                            if (is_array($fieldValue['meta_value'])) {
                                $numEntries = count($fieldValue['meta_value']);
                                $fieldValue['meta_value'] = implode(', ', $fieldValue['meta_value']);
                            }
                        }

if ($numEntries <= 0) {
                            $numEntries = 1;
                        }

$oneEntry['Award_Category'] = $fieldValue['meta_value'];
                    }

// Add more field processing logic here as needed...

$oneEntry['FormFields'][] = array(
                        'id' => $fieldId,
                        'label' => $labelText,
                        'value' => $fieldValue['meta_value'],
                    );

$entries[$formEntry['entry_id']][$fieldId] = array(
                        'label' => $forms[$formName]['fields'][$fieldId]['label'],
                        'value' => $fieldValue['meta_value']
                    );
                }
            }

// Build HTML for the entry
            foreach ($oneEntry['FormFields'] as $oneFormField) {
                if (is_array($oneFormField['value'])) {
                    $oneFormField['value'] = print_r($oneFormField['value'], true);
                }
                $oneEntry['PreEntryHTML'] .= '<tr><td align="left" valign="top" width="40%"><b>' . $oneFormField['label'] . ':</b></td><td align="left" valign="top">' . $oneFormField['value'] . '</td></tr>';
            }

$oneEntry['PreEntryHTML'] .= '</table>';
            $entriesFinal[] = $oneEntry;
        }

echo "  Processed " . count($entriesFinal) . " entries for form: " . $formName . "\n";
    } catch (Exception $e) {
        echo "  ✗ Error processing form ID " . $wpForm['ID'] . ": " . $e->getMessage() . "\n";
        continue;
    }
}

echo "\n=== Script completed successfully ===\n";
echo "Processed " . count($forms) . " forms\n";

// Flush output buffer
ob_end_flush();