Gecko [ v3.cesa.co.za ]

Name	Size	Permission	Date
_notes	[ DIR ]	drwxr-sr-x	2022-12-20 11:09
_vti_cnf	[ DIR ]	drwxr-sr-x	2022-12-20 11:09
certificate	[ DIR ]	drwxr-sr-x	2023-03-22 11:22
includes	[ DIR ]	drwxr-sr-x	2026-08-24 10:12
mail_interface	[ DIR ]	drwxr-sr-x	2025-06-14 09:47
security	[ DIR ]	drwxr-sr-x	2023-09-17 08:02
temp	[ DIR ]	drwxr-sr-x	2026-04-18 22:25
templates	[ DIR ]	drwxr-sr-x	2026-05-25 12:12
tests	[ DIR ]	drwxr-sr-x	2025-07-07 15:54
CaptchaSecurityImages.php	2.26 KB	-rw-r--r--	2022-12-20 11:09
Inc_calendarnew.php	8.59 KB	-rw-r--r--	2017-11-20 10:34
accredcourses.php	7.04 KB	-rw-r--r--	2023-08-22 10:55
adecquestionnaire.php	26.54 KB	-rw-r--r--	2025-08-01 10:38
advisory.php	7.21 KB	-rw-r--r--	2022-12-20 11:09
advisory_full.php	1.31 KB	-rw-r--r--	2022-12-20 11:09
annualdeclaration.php	15.28 KB	-rw-r--r--	2026-01-22 10:25
awardsentry.php	14.55 KB	-rw-r--r--	2025-08-01 10:38
awardsentry.php.bak	11.22 KB	-rw-r--r--	2016-04-13 12:45
bookdetail.php	954 B	-rw-r--r--	2022-12-20 11:09
books.php	4.4 KB	-rw-r--r--	2023-05-16 13:08
branchdocuments.php	1.14 KB	-rw-r--r--	2022-12-20 11:09
branches.php	2.82 KB	-rw-r--r--	2025-08-06 12:54
calendarpdf.php	1.75 KB	-rw-r--r--	2025-08-26 16:52
cceregister.php	55.59 KB	-rw-r--r--	2026-08-14 12:05
ccmregister.php	71.57 KB	-rw-r--r--	2022-12-20 11:09
class.phpmailer.php	44.39 KB	-rw-r--r--	2022-12-20 11:09
class.smtp.php	32.74 KB	-rw-r--r--	2022-12-20 11:09
committeedocs.php	932 B	-rw-r--r--	2022-12-20 11:09
committees.php	2.69 KB	-rw-r--r--	2025-08-06 12:58
cpdapply.php	5.73 KB	-rw-r--r--	2022-12-20 11:09
cpdapplyform.php	34.06 KB	-rw-r--r--	2025-08-01 10:38
cpdproviderapply.php	42.09 KB	-rw-r--r--	2026-02-10 10:10
cpdproviderportal.php	79.47 KB	-rw-r--r--	2025-09-08 07:23
cpdspverify.php	4.27 KB	-rw-r--r--	2025-10-10 10:45
cpdtmverify.php	4.45 KB	-rw-r--r--	2023-06-19 13:44
declineeventreg.php	3.73 KB	-rw-r--r--	2022-12-20 11:09
directorybooking.php	7.39 KB	-rw-r--r--	2022-12-20 11:09
downloadPN.php	385 B	-rw-r--r--	2025-06-26 13:02
downloadfile.php	280 B	-rw-r--r--	2025-08-01 10:38
enews.php	1.33 KB	-rw-r--r--	2022-12-20 11:09
enewsarchive.php	1.09 KB	-rw-r--r--	2022-12-20 11:09
event.php	12.39 KB	-rw-r--r--	2026-08-19 12:22
event_allvenues.php	18.93 KB	-rw-r--r--	2026-08-09 11:44
eventdecline_awards.php	11.79 KB	-rw-r--r--	2022-12-20 11:09
eventregister.php	26.85 KB	-rw-r--r--	2026-02-10 07:56
eventregister_awards.php	19.4 KB	-rw-r--r--	2025-06-20 06:38
eventregister_golf.php	28.83 KB	-rw-r--r--	2025-08-19 08:12
eventtables.php	24.13 KB	-rw-r--r--	2023-06-01 09:51
eventtables.php.bak	3.49 KB	-rw-r--r--	2022-12-20 11:09
fidicgama2018.php	1012 B	-rw-r--r--	2022-12-20 11:09
forum.php	3.25 KB	-rw-r--r--	2022-12-20 11:09
getoffices.php	799 B	-rw-r--r--	2022-12-20 11:09
hrforumsubscribe.php	2.62 KB	-rw-r--r--	2022-12-20 11:09
hrforumunsubscribe.php	1.32 KB	-rw-r--r--	2022-12-20 11:09
inc_calendarnew.php	10.56 KB	-rw-r--r--	2025-08-21 10:11
inc_captcha.php	337 B	-rw-r--r--	2022-12-20 11:09
inc_db.php	12.33 KB	-rw-r--r--	2025-06-18 12:05
inc_php7.php	6 KB	-rw-r--r--	2025-07-07 12:51
inc_practicenoteslist.php	4.1 KB	-rw-r--r--	2024-07-03 13:52
inc_scecalendar.php	8.55 KB	-rw-r--r--	2025-06-13 08:57
inc_scecalendar_backup.php	6.66 KB	-rw-r--r--	2022-12-20 11:09
inc_scecalendarnew.php	7.84 KB	-rw-r--r--	2026-05-09 09:39
jobshadowschools.php	7.26 KB	-rw-r--r--	2025-06-20 06:38
logout.php	593 B	-rw-r--r--	2025-02-25 08:19
marketingevent.php	122.75 KB	-rw-r--r--	2026-08-03 13:40
marketingeventdecline.php	15.21 KB	-rw-r--r--	2022-12-20 11:09
marketingsurvey.php	5.95 KB	-rw-r--r--	2022-12-20 11:09
matrixtemplate.htm	2.13 KB	-rw-r--r--	2022-12-20 11:09
member_portal_becs.php	2.14 KB	-rw-r--r--	2025-09-12 07:50
member_portal_transformation.php	10.45 KB	-rw-r--r--	2026-05-20 10:07
member_portal_transformation_proxy.php	538 B	-rw-r--r--	2026-05-20 09:08
memberauth.php	991 B	-rw-r--r--	2025-02-25 08:19
memberportal.php	11.79 KB	-rw-r--r--	2026-05-20 09:54
membersearch.php	22.72 KB	-rw-r--r--	2025-02-27 08:02
membersearch_smme.php	6.2 KB	-rw-r--r--	2024-11-27 11:41
memberverify.php	5.25 KB	-rw-r--r--	2022-12-20 11:09
mentors.php	21.68 KB	-rw-r--r--	2025-06-20 06:38
migratenode.php	1.26 KB	-rw-r--r--	2022-12-20 11:09
monofont.ttf	40.07 KB	-rw-r--r--	2022-12-20 11:09
nlc.php	855 B	-rw-r--r--	2022-12-20 11:09
nlcreports.php	2.51 KB	-rw-r--r--	2022-12-20 11:09
php_errors.log	1.06 KB	-rw-r--r--	2026-08-20 23:37
practicenotes.php	4.63 KB	-rw-r--r--	2022-12-20 11:09
practicenotes_full.php	1.33 KB	-rw-r--r--	2022-12-20 11:09
practicenotes_help.php	2.17 KB	-rw-r--r--	2022-12-20 11:09
practicenotes_list.php	2.03 KB	-rw-r--r--	2024-07-03 13:52
practicenotes_search.php	9.43 KB	-rw-r--r--	2022-12-20 11:09
querynlcmatrix.php	15 KB	-rw-r--r--	2022-12-20 11:09
querynlcmatrix.php4	15.38 KB	-rw-r--r--	2012-03-05 08:01
register.php	58.18 KB	-rw-r--r--	2026-05-26 14:55
relay.php	20.33 KB	-rw-r--r--	2025-06-20 06:38
relayteams.php	12.53 KB	-rw-r--r--	2022-12-20 11:09
resendcpdform.php	7.28 KB	-rw-r--r--	2025-08-01 10:38
retiredeng.php	13.45 KB	-rw-r--r--	2025-06-20 06:38
retiredeng_members.php	1.81 KB	-rw-r--r--	2022-12-20 11:09
sanitize.php	10 B	-rw-r--r--	2022-12-20 11:09
sce_survey2015.php	25.85 KB	-rw-r--r--	2022-12-20 11:09
sceallevents.php	8.13 KB	-rw-r--r--	2026-01-20 08:45
scecalendar.php	4.86 KB	-rw-r--r--	2025-06-18 11:18
scecalendar_backup.php	3.17 KB	-rw-r--r--	2025-06-18 11:18
scecalendarnew.php	5.98 KB	-rw-r--r--	2025-08-28 11:14
scecalendarnewtest.php	5.7 KB	-rw-r--r--	2022-03-04 12:37
scecalendartest.php	3.57 KB	-rw-r--r--	2022-03-04 12:38
scecategories.php	914 B	-rw-r--r--	2022-12-20 11:09
scecourses.php	7.18 KB	-rw-r--r--	2026-08-19 12:15
scelist.php	7.72 KB	-rw-r--r--	2025-08-29 07:18
scesubscribe.php	2.06 KB	-rw-r--r--	2022-12-20 11:09
sceupdate.php	1.67 KB	-rw-r--r--	2025-06-18 11:18
scevenuehire.php	6.15 KB	-rw-r--r--	2026-01-23 13:12
sendeventreg.php	19.5 KB	-rw-r--r--	2026-08-14 12:05
sendeventreg2.php	2.83 KB	-rw-r--r--	2026-07-17 14:57
sendeventreg_golf.php	20.23 KB	-rw-r--r--	2026-08-14 12:05
sendeventreg_golf.php.bak	11.69 KB	-rw-r--r--	2016-09-07 09:48
sendreg.php	35.15 KB	-rw-r--r--	2026-08-14 12:05
smsunsub.php	1.89 KB	-rw-r--r--	2025-06-18 11:18
template.php	54.36 KB	-rw-r--r--	2022-12-20 11:09
tenders.php	1.34 KB	-rw-r--r--	2022-12-20 11:09
trainerportal.php	50.27 KB	-rw-r--r--	2025-08-01 11:06
trainerportal.php.bak	2.57 KB	-rw-r--r--	2022-12-20 11:09
unempgrad_members.php	2.38 KB	-rw-r--r--	2025-06-18 11:18
unemployed.php	14.13 KB	-rw-r--r--	2025-06-20 06:38
unemployedreg.php	23.38 KB	-rw-r--r--	2025-06-20 06:38
unempreg_members.php	2.36 KB	-rw-r--r--	2025-06-18 11:18
ypfbranchcommittee.php	1.63 KB	-rw-r--r--	2022-12-20 11:09
ypfcommittees.php	1.57 KB	-rw-r--r--	2022-12-20 11:09
ypfjoin.php	30.29 KB	-rw-r--r--	2025-07-07 15:53
ypfjoin2.php	28.13 KB	-rw-r--r--	2025-06-18 11:18
ypfjoinmatches.php	9.46 KB	-rw-r--r--	2025-06-18 11:18
ypfmentees.php	20.81 KB	-rw-r--r--	2026-08-24 11:52
ypfmentees_members.php	2.42 KB	-rw-r--r--	2025-06-18 11:18

Rename

<?php 
include('inc_db.php'); 
?>
	<h1>Practice Notes for Members</h1>
	<h1>Search Practice Notes:</h1>
	<?php
	$command = mysql_real_escape_string($_REQUEST["command"]);
	$searchkeyword = mysql_real_escape_string($_REQUEST["searchkeyword"]);
	$searchyear = mysql_real_escape_string($_REQUEST["searchyear"]);
	$searchnumber = mysql_real_escape_string($_REQUEST["searchnumber"]);
	$year = mysql_real_escape_string($_REQUEST["year"]);
	
	switch ($command) {
		case "keywordsearch":
			
			$sql = "SELECT NoteId,Title,Description,Filename, Reference FROM advisory where confidential='N' AND (title like '%$searchkeyword%' OR description like '%$searchkeyword%' OR FILENAME like '%$searchkeyword%') AND Archive = 'new' ORDER BY Reference, Title";
			$result = mysql_query($sql);
			$result_rows = mysql_num_rows($result);
			If ($result_rows > 0 ) {
				
				echo "<h1>Keyword Search Results:</h1>";
				echo "<p>The following <b>".$result_rows." results</b> match your search criteria '<i>".$searchkeyword."</i>'<br>Please note: Items are listed in Reference and then Alphabetical Title order</p>";
				
				while($row = mysql_fetch_array($result)) {
			    		echo "<p class=\"advisorynotes\">";
			    		echo "<b>".ucwords(strtolower($row["Reference"]))."</b><br>";
			    		echo "<b>".ucwords(strtolower($row["Title"]))."</b><br>";
			    		echo substr($row["Description"],0,300)." ...<br><i>continued in the pdf version</i>";
			    		echo " click <a href=\"/_f1l3z_/advisorynotes/".strtolower($row["Filename"])."\"><img src=\"/images/icon_pdf.gif\" width=\"16\" height=\"16\" alt=\"pdf file\" border=\"0\"> here</a> to download" ;
			    		echo "</p>";
				}
			} else {
			
			echo "<p><br><B>No results found. Please go back and try a wider search criteria or a simpler keyword.</b></p>";
			}
			mysql_free_result($result);
			break;
		case "listyearsearch":
			$sql = "SELECT NoteId,Title,Description,Filename, Reference FROM advisory where confidential='N' AND LEFT(filename,2) = $year  AND Archive = 'new' ORDER BY Reference, Title";
			$result = mysql_query($sql);
			$result_rows = mysql_num_rows($result);
			If ($result_rows > 0 ) {
				echo "<h1>List Year Results:</h1>";
				if ($year > 75 ) { $newyear = "19".$year; }
				if ($year < 75 ) { $newyear = "20".$year; }
				echo "<p class=\"footer\">The following <b>".$result_rows." results</b> match the year '<i>".$newyear."</i>'<br>Please note: Items are listed in Reference and then Alphabetical Title order</p>";
				while($row = mysql_fetch_array($result)) {
			    		echo "<p class=\"advisorynotes\">";
			    		echo "<b>".ucwords(strtolower($row["Reference"]))."</b><br>";
			    		echo "<b>".ucwords(strtolower($row["Title"]))."</b><br>";
			    		echo substr($row["Description"],0,300)." ...<br><i>continued in the pdf version</i>";
			    		echo " click <a href=\"/_f1l3z_/advisorynotes/".strtolower($row["Filename"])."\"><img src=\"/images/icon_pdf.gif\" width=\"16\" height=\"16\" alt=\"pdf file\" border=\"0\"> here</a> to download" ;
			    		echo "</p>";
				}
			} else {
			echo "<p><br><B>No practice notes found for that year. Please go back and try another year.</b></p>";
			}
			mysql_free_result($result);	
			break;
		case "numbersearch":
			if ($searchnumber >= 10) {
				$searchcriteria = "where LEFT(filename,5) = \"".$searchyear."_".$searchnumber."\"";
			} else {
				$searchcriteria = "where (LEFT(filename,4) = \"".$searchyear."_".$searchnumber."\")";
			}
			$sql = "SELECT NoteId,Title,Description,Filename, Reference FROM advisory $searchcriteria  AND confidential='N' AND Archive = 'new' ORDER BY Reference, Title";
			$result = mysql_query($sql);
			$result_rows = mysql_num_rows($result);
			If ($result_rows > 0 ) {
				echo "<h1>Advisory Note Number Code Results:</h1>";
				echo "<p class=\"footer\">The following <b>".$result_rows." results</b> match the Advisory Note Number '<i>".$searchyear."/".$searchnumber."</i>'<br>Please note: Items are listed in Alphabetical Title order</p>";
				while($row = mysql_fetch_array($result)) {
			    		echo "<p class=\"advisorynotes\">";
			    		echo "<b>".ucwords(strtolower($row["Reference"]))."</b><br>";
			    		echo "<b>".ucwords(strtolower($row["Title"]))."</b><br>";
			    		echo substr($row["Description"],0,300)." ...<br><i>continued in the pdf version</i>";
			    		echo " click <a href=\"/_f1l3z_/advisorynotes/".strtolower($row["Filename"])."\"><img src=\"/images/icon_pdf.gif\" width=\"16\" height=\"16\" alt=\"pdf file\" border=\"0\"> here</a> to download" ;
			    		echo "</p>";
				}
			} else {
			$hint = "<p><b>Hint:</b><br>The practice note number is in the format year/number with the year being a two digit number and the article number. E.g. 00/1 represents Article number 1 from the year 2000.</p><p>If you are sure you are entering the number correctly, but cannot find the article you want by number, then go back and try using the text or year searches which are less strict and more likely to find results.</p>";
			if ($searchnumber != "" AND $searchyear != "") {
				echo "<p><br><B>No practice notes found for ".$searchyear."/".$searchnumber.". Please go back and try another number.</b></p>";
				echo $hint;
			} else {
				echo "<p><br><B>No practice notes found. Please go back and try another number.</b></p>";
				echo $hint;
			}
			}
			mysql_free_result($result);	
			break;
		default:
			?>
			<table width="80%" border="0" cellspacing="0">
			<form action="/node/19" method="post">
			<tr><td>
			<input type="text" name="searchkeyword" size="20"></td><td>
			<input type="hidden" name="command" value="keywordsearch">
			<input type="submit" value="Start keyword search">
			</td></tr>
			</form>
			<form action="/node/19" method="post">
			<tr><td>
			<select name="year">
<?php
for ($i = date("Y"); $i>=1980; $i--) {				
?>	
                <option value="<?php echo substr($i."",strlen($i."")-2,2); ?>"><?php echo $i; ?></option>
<?php
}
?>                
              </select>
			</td><td>
			<input type="hidden" name="command" value="listyearsearch">
			<input type="submit" value="List Notes for the Year">
			</td></tr>
			</form>
			<form action="/node/19" method="post">
			<tr><td>
			<input type="text" name="searchyear" size="2">/<input type="text" name="searchnumber" size="2"></td>
			<td><input type="hidden" name="command" value="numbersearch">
			<input type="submit" value="Search by Code Number"></td></tr>
			</form>
			</table>
			<p>
			<a href="/node/76">A full list of all practice notes is available here.</a>
			</p>
			
			<?php
			
			
			break;
			
	}
	?>
<h1>Client Information Sheets</h1>

<p>
<a href="/public_downloads/SAACEClientInformationSheet1.pdf" target="_blank">Client Information Sheet 1</a><br>
Professional Service Contracts (Why Clients Should Limit the Liability of their Consulting Engineer)
</p>
 
<p>
<a href="/public_downloads/SAACEClientInformationSheet2.pdf" target="_blank">Client Information Sheet 2</a><br>
Professional Service Contracts (Why Clients Should Use Standard Conditions of Contract For Professional Consultants)
</p>
 
<p>
<a href="/public_downloads/SAACEClientInformationSheet3.pdf" target="_blank">Client Information Sheet 3</a><br>
Construction Regulations 2003 
</p>
 
<p>
<a href="/public_downloads/SAACEClientInformationSheet4.pdf" target="_blank">Client Information Sheet 4</a><br>
How To handle Repeat Tenders
</p>