Gecko [ v3.cesa.co.za ]

Name	Size	Permission	Date
auth.inc	734 B	-rw-r--r--	2010-05-27 04:41
conf.inc	2.59 KB	-rw-r--r--	2018-08-01 08:50
database.inc	351 B	-rw-r--r--	2012-02-13 09:24
db.inc	324 B	-rw-r--r--	2020-01-09 09:27
declaration.inc	10.96 KB	-rw-r--r--	2019-02-20 11:15
footer.inc	743 B	-rw-r--r--	2025-03-05 12:29
footer2.inc	157 B	-rw-r--r--	2010-05-27 04:41
func.inc	2.72 KB	-rw-r--r--	2010-05-27 04:41
log_query.php	154 B	-rw-r--r--	2010-05-28 11:22
menu.inc	631 B	-rw-r--r--	2020-01-08 10:37
smenu.inc	627 B	-rw-r--r--	2020-01-08 10:37

Rename

<?php 
// System wide configuration file for members.saace.co.za
// This file should contain all settings used for multiple functions
// DO NOT INCLUDE FUNCTIONS IN THIS PAGE

// Colors
$coldark = "#336699";
$colmedium = "#6699CC";
$collight = "#99CCFF";
$col2dark = "#336699";
$col2medium = "#6699CC";
$col2light = "#FFFFCC";
$graydark = "#ADADAD";
$graymedium = "#CECECE";
$graylight = "#DEDEDE";
$footerlight = "#eeeeee";

// Database Login Details
$server = "sql1.cpt2.host-h.net";
$user = "saacea_1";
$pass = "heJxoP40d";
$db = "saacedb";

// Declaration Settings

if (isset($_GET["ApplicationID"])) {
	$sql="SELECT DateCreated FROM Applications WHERE ApplicationID=".intval($_GET["ApplicationID"]);
	$rec=mysql_query($sql);
	if (($row=mysql_fetch_assoc($rec)) && !empty($row["DateCreated"])) {
		$DeclarationYear=date("Y", strtotime($row["DateCreated"]));
		if (date("m", strtotime($row["DateCreated"]))>11) $DeclarationYear++;
	} else {
		$DeclarationYear=date("Y");
	}
	
	$sContactsTable = "ADec_Contacts";
	$sOfficeContactsTable = "ADec_OfficeContacts";
	$sFirmsTable = "ADec_tblMemberFirms";
	$sOfficesTable = "ADec_tblMemberFirmOffices";
	
	$sContactsID = "ContactsID";
	$sOfficeID = "OfficeID";
	$sFirmID = "FirmID";

} else {
	$sql="SELECT MAX(ADecDate) AS MaxDate FROM ADec_Done";
	if ($_REQUEST["ver"]=="old") $sql.="_Prev";
	$sql.=", ADec_tblMemberFirms";
	if ($_REQUEST["ver"]=="old") $sql.="_Prev";
	$sql.=" WHERE RefType='FirmID' AND RefID=FirmID AND Prev_FirmID=".$_REQUEST["FirmID"];
	$rec=mysql_query($sql);
	if (($row=mysql_fetch_assoc($rec)) && !empty($row["MaxDate"])) {
		$DeclarationYear=date("Y", strtotime($row["MaxDate"]));
		if (date("m", strtotime($row["MaxDate"]))>11) $DeclarationYear++;
	} else {
		$sql="SELECT DeclarationReceived FROM tblMemberFirms WHERE FirmID=".$_REQUEST["FirmID"];
		$rec=mysql_query($sql);
		if ($row=mysql_fetch_assoc($rec)) {
			$DeclarationYear=date("Y", strtotime($row["DeclarationReceived"]));
		} else {
			$DeclarationYear=date("Y");
		}
		if ($_REQUEST["ver"]=="old") $DeclarationYear--;
	}
	
	
	$sContactsTable = "Contacts";
	$sOfficeContactsTable = "OfficeContacts";
	$sFirmsTable = "tblMemberFirms";
	$sOfficesTable = "tblMemberFirmOffices";
	
	$sContactsID = "ContactsID";
	$sOfficeID = "OfficeID";
	$sFirmID = "FirmID";
	
	if (isset($_GET["ver"]) && ($_GET["ver"] == "old")) {
		$sContactsTable = "ADec_Contacts_Prev";
		$sOfficeContactsTable = "ADec_OfficeContacts_Prev";
		$sFirmsTable = "ADec_tblMemberFirms_Prev";
		$sOfficesTable = "ADec_tblMemberFirmOffices_Prev";
	
		$sContactsID = "Prev_ContactsID";
		$sOfficeID = "Prev_OfficeID";
		$sFirmID = "Prev_FirmID";
	}

}