Gecko [ v3.cesa.co.za ]

Name	Size	Permission	Date
config.php	4.71 KB	-rw-r--r--	2026-08-13 15:18
google-keyfile-storage-admin.json	2.33 KB	-rw-r--r--	2024-05-13 15:56
google-keyfile.json	407 B	-rw-r--r--	2024-05-13 15:56
pdf_css_config.php	10.07 KB	-rw-r--r--	2025-08-27 09:39

Rename

<?php

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

// Get working folder when in CLI mode
$working_folder = getcwd();

if (!isset($_SERVER['HTTP_HOST'])) {
    $_SERVER['HTTP_HOST'] = 'www.cesa.co.za';
}

// Local dev must match when host is exactly "cesa.local" or "localhost" (strpos > 0 wrongly skipped position 0).
$httpHost = $_SERVER['HTTP_HOST'];
if (
    strpos($httpHost, 'localhost') !== false
    || strpos($httpHost, 'cesa.local') !== false
    || strpos($httpHost, '127.0.0.1') !== false
    || strpos($working_folder, 'BitBucket') !== false
) {
    // Main membership and school database
    define("EW_CONN_HOST", "localhost");
    define("EW_CONN_PORT", 3306);
    define("EW_CONN_USER", "root");
    define("EW_CONN_PASS", "g3rtyGert");
    define("EW_CONN_DB", "cesa_main");

// Bulk mailer database
    define("MAILDB_USER", "root");
    define("MAILDB_PASS", "g3rtyGert");
    define("MAILDB_DB", "cesa_mail");

// WP database
    define("WP_HOST", "localhost");
    define("WPDB_USER", "root"); //,TRUE);
    define("WPDB_PASS", "g3rtyGert");
    define("WPDB_DB", "cesa_wp"); //,TRUE);

$_SERVER['HTTP_HOST'] = 'cesa.local';
} elseif (strpos($httpHost, 'esa.devstage') !== false || strpos($working_folder, 'clients/client37/web63') !== false) {
    // Main membership and school database
    define("EW_CONN_HOST", "skynet.local");
    define("EW_CONN_PORT", 3306);
    define("EW_CONN_USER", "c37_cesa_dev");
    define("EW_CONN_PASS", "gszB_RdJM3");
    define("EW_CONN_DB", "c37_cesa_main");

// Bulk mailer database
    define("MAILDB_USER", "c37_cesa_dev");
    define("MAILDB_PASS", "gszB_RdJM3");
    define("MAILDB_DB", "c37_cesa_mail");

// WP database
    define("WP_HOST", "skynet.local");
    define("WPDB_USER", "c37_cesa_dev"); //,TRUE);
    define("WPDB_PASS", "gszB_RdJM3");
    define("WPDB_DB", "c37_cesa_wp"); //,TRUE);

$_SERVER['HTTP_HOST'] = 'cesa.devstage.co.za';
} elseif (
    strpos($httpHost, 'esa-new.devstage') !== false
    || strpos($httpHost, 'cesa.co.za') !== false
    || strpos($working_folder, 'www/cesa.co.za') !== false
    || strpos($working_folder, '/var/www/cesa.co.za') !== false
) {
    // Main membership and school database
    define("EW_CONN_HOST", "cesa-main-db.local");
    define("EW_CONN_PORT", 3306);
    define("EW_CONN_USER", "cesa");
    define("EW_CONN_PASS", "]u9yU[ui92.6V0vN");
    define("EW_CONN_DB", "cesa");

// Bulk mailer database
    define("MAILDB_USER", "cesa_mail");
    define("MAILDB_PASS", "c1yN3zU6ZN/BeXk1");
    define("MAILDB_DB", "cesa_mail");

// WP database
    define("WP_HOST", "cesa-main-db.local");
    define("WPDB_USER", "cesa_wp"); //,TRUE);
    define("WPDB_PASS", "Ji)YGPcY5Km8uNsy");
    define("WPDB_DB", "cesa_wp"); //,TRUE);

$_SERVER['HTTP_HOST'] = 'cesa.co.za';
} else {

// Main membership and school database
    define("EW_CONN_HOST", "sql1.cpt2.host-h.net");
    define("EW_CONN_PORT", 3306);
    define("EW_CONN_USER", "saacea_1");
    define("EW_CONN_PASS", "heJxoP40d...");
    define("EW_CONN_DB", "saacedb");

// Bulk mailer database
    define("MAILDB_USER", "saacea_3"); //,TRUE);
    define("MAILDB_PASS", "GFTcREk8...");
    define("MAILDB_DB", "saacemail"); //,TRUE);
    // WP database
    define("WP_HOST", "sql8.cpt2.host-h.net");
    define("WPDB_USER", "saacea_7..."); //,TRUE);
    define("WPDB_PASS", "WbtTYUYUu58");
    define("WPDB_DB", "cesa_wp"); //,TRUE);
}

// CESA electronic contracts
define("CONTRACTS_DIR", $_SERVER['DOCUMENT_ROOT'] . "/contracts/");
define("CONTRACTS_OUTPUT", $_SERVER['DOCUMENT_ROOT'] . "/contracts/c0ntr4ct5/");

// echo 'EW_CONN_HOST: ' . EW_CONN_HOST . ' ';
// echo 'EW_CONN_USER: ' . EW_CONN_USER . ' ';
// echo 'EW_CONN_PASS: ' . EW_CONN_PASS . ' ';
// echo 'EW_CONN_DB: ' . EW_CONN_DB . ' ';
// echo 'WP_HOST: ' . WP_HOST . ' ';
// echo 'WPDB_USER: ' . WPDB_USER . ' ';
// echo 'WPDB_PASS: ' . WPDB_PASS . ' ';
// echo 'WPDB_DB: ' . WPDB_DB . ' ';
// echo 'MAILDB_USER: ' . MAILDB_USER . ' ';
// echo 'MAILDB_PASS: ' . MAILDB_PASS . ' ';
// exit;

$server = EW_CONN_HOST;
$user = EW_CONN_USER;
$pass = EW_CONN_PASS;
$db = EW_CONN_DB;

define("MYSQL_BOTH", -9999);

// Student online exam: when true, after save/opening exam without ?q= go to first unanswered question (legacy).
// When false (default), go to the next question in section/display order after the question just saved.
if (!defined('EXAM_REDIRECT_TO_FIRST_UNANSWERED')) {
    define('EXAM_REDIRECT_TO_FIRST_UNANSWERED', false);
}

// SMTP Configuration
$smtp_host = 'smtp.office365.com';
$smtp_port = 587;
$smtp_user = 'no-reply@cesa.co.za';
$smtp_pass = 'Q3b2025#!';

# cesa-main/.env and cesa-v3/.env (and prod equivalents)
define("ECHASL23_SSO_SECRET", "659072963986949010371191531955149504571");