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_once("memberauth.php");
include_once('inc_db.php'); 
?>
				<div data-elementor-type="wp-page" data-elementor-id="3428" class="elementor elementor-3428" data-elementor-settings="[]">
						<div class="elementor-inner">
							<div class="elementor-section-wrap">
							<section class="elementor-section elementor-top-section elementor-element elementor-element-5a57a73 elementor-section-boxed elementor-section-height-default elementor-section-height-default" data-id="5a57a73" data-element_type="section" data-settings="{&quot;ekit_has_onepagescroll_dot&quot;:&quot;yes&quot;}">
						<div class="elementor-container elementor-column-gap-default">
							<div class="elementor-row">
					<div class="elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-7697602" data-id="7697602" data-element_type="column">
			<div class="elementor-column-wrap elementor-element-populated">
							<div class="elementor-widget-wrap">
						<div class="elementor-element elementor-element-4ebe28c elementor-widget elementor-widget-heading" data-id="4ebe28c" data-element_type="widget" data-widget_type="heading.default">
				<div class="elementor-widget-container">
			<h1 class="elementor-heading-title elementor-size-default">Practice Notes for Members</h1>		</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section class="elementor-section elementor-top-section elementor-element elementor-element-89752d6 elementor-section-boxed elementor-section-height-default elementor-section-height-default" data-id="89752d6" data-element_type="section" data-settings="{&quot;ekit_has_onepagescroll_dot&quot;:&quot;yes&quot;}">
						<div class="elementor-container elementor-column-gap-default">
							<div class="elementor-row">
					<div class="elementor-column elementor-col-66 elementor-top-column elementor-element elementor-element-002a1b8" data-id="002a1b8" data-element_type="column" style="border:1px solid #CCCCCC; border-radius:5px;">
			<div class="elementor-column-wrap elementor-element-populated">
							<div class="elementor-widget-wrap">
						<div class="elementor-element elementor-element-1da3a11 elementor-widget elementor-widget-heading" data-id="1da3a11" data-element_type="widget" data-widget_type="heading.default">
				<div class="elementor-widget-container">
			<h3 class="elementor-heading-title elementor-size-default">Search the Practice Notes</h3>		</div>
				</div>
				<div class="elementor-element elementor-element-52c1d66 elementor-widget elementor-widget-wp-widget-phpeverywherewidget" data-id="52c1d66" data-element_type="widget" data-widget_type="wp-widget-phpeverywherewidget.default">
				<div class="elementor-widget-container">

<form method="post" action="/practice-notes-search">
<input type="hidden" name="go" value="1">
<table border=0>
    <tr><td><b>PN Number:</b></td><td><input type="text" name="searchref" placeholder="e.g. PN5 - optional" value="<?php echo $_REQUEST["searchref"]; ?>"></td></tr>
    <tr><td><b>Category:</b></td><td>
    <select name="searchcat" class="catSelect">
    <option value=""<?php if (!isset($_REQUEST["searchcat"]) || empty($_REQUEST["searchcat"])) echo " selected"; ?>>All / Any</option>
<?php
$sql = "SELECT DISTINCT Category FROM PracticeNotes_2021 ORDER BY Category";
			$result = mysqli_query($conni, $sql);
			while($row = mysqli_fetch_array($result)) {
?>
	
                <option value="<?php echo str_replace(array(" ",","),array("_","."),$row["Category"]); ?>"<?php if (isset($_REQUEST["searchcat"]) && ($_REQUEST["searchcat"]==$row["Category"])) echo " selected"; ?>><?php echo $row["Category"]; ?></option>
<?php
}
?>                
    </select></td></tr>
    <tr><td><b>Sub-Category:</b></td><td><select name="searchsubcat" class="subSelect">
    <option value="" class="static"<?php if (!isset($_REQUEST["searchsubcat"]) || empty($_REQUEST["searchsubcat"])) echo " selected"; ?>>All / Any</option>
<?php
$sql = "SELECT DISTINCT Category, SubCategory FROM PracticeNotes_2021 ORDER BY Category, SubCategory";
			$result = mysqli_query($conni, $sql);
			while($row = mysqli_fetch_array($result)) {
?>
	
                <option value="<?php echo $row["SubCategory"]; ?>" class="sub_<?php echo str_replace(array(" ",","),array("_","."),$row["Category"]); ?>"<?php if (isset($_REQUEST["searchsubcat"]) && ($_REQUEST["searchsubcat"]==$row["SubCategory"])) echo " selected"; ?>><?php echo $row["SubCategory"]; ?></option>
<?php
}
?>
    </select></td></tr>
    <tr><td><b>Keyword/s:</b></td><td><input type=text name="searchkeyword" placeholder="optional" value="<?php echo $_REQUEST["searchkeyword"]; ?>"></td></tr>
    <tr><td>&nbsp;</td><td><input type="checkbox" name="searcharchived" value="y"<?php if (!isset($_REQUEST["searcharchived"]) || ($_REQUEST["searcharchived"]=="y")) echo " checked"; ?>> Include archived practice notes</td></tr>
    <tr><td colspan=2 align="center" style="text-align:center"><input type="submit" value="Search Now"></tr>
    </table>    
</form>

</div>
				</div>
						</div>
					</div>
		</div>
				<div class="elementor-column elementor-col-33 elementor-top-column elementor-element elementor-element-7c2465e" data-id="7c2465e" data-element_type="column">
			<div class="elementor-column-wrap elementor-element-populated">
							<div class="elementor-widget-wrap">
						<div class="elementor-element elementor-element-9cbab9c elementor-align-center elementor-widget elementor-widget-button" data-id="9cbab9c" data-element_type="widget" data-widget_type="button.default">
				<div class="elementor-widget-container">
					<div class="elementor-button-wrapper">
			<a href="/practice-notes-help" class="elementor-button-link elementor-button elementor-size-sm" role="button" style="background-color:#3D58AE">
						<span class="elementor-button-content-wrapper">
						<span class="elementor-button-icon elementor-align-icon-left">
				<i aria-hidden="true" class="fas fa-question-circle"></i>			</span>
						<span class="elementor-button-text">Ask a Question</span>
		</span>
					</a>
		</div>
				</div>
				</div>
				<div class="elementor-element elementor-element-67dd9ee elementor-button-info elementor-align-center elementor-widget elementor-widget-button" data-id="67dd9ee" data-element_type="widget" data-widget_type="button.default">
				<div class="elementor-widget-container">
					<div class="elementor-button-wrapper">
			<a href="/practice-notes-list-2021/" class="elementor-button-link elementor-button elementor-size-sm" role="button" style="background-color:#3D58AE">
						<span class="elementor-button-content-wrapper">
						<span class="elementor-button-icon elementor-align-icon-left">
				<i aria-hidden="true" class="fas fa-list"></i>			</span>
						<span class="elementor-button-text">Full List of Practice Notes</span>
		</span>
					</a>
		</div>
				</div>
				</div>
				<p>There are currently <?php echo mysqli_num_rows(mysqli_query($conni,"SELECT * FROM PracticeNotes_2021")); ?> practice notes available. Please use the search form on the left to search the database, or access the full list by category using the button above.</p>
				<p>Archived practice notes are provided for background reading, but have been superseded by new versions.</p>
				<p><b><i>&copy; Consulting Engineers South Africa. The practice notes remain the property of CESA and may not be distributed without authorisation.</i></b></p>
				
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
						</div>
						</div>
					</div>

<?php
	
if (isset($_POST) && ($_POST["go"]==1)) {
	LogUserActivity("Search Practice Notes");
	
	$searchkeyword = mysqli_real_escape_string($conni, $_REQUEST["searchkeyword"]);
	$searchkeyword=strtolower(str_replace(array(" ",","),"%",$searchkeyword));
	
	$searchcat = mysqli_real_escape_string($conni, $_REQUEST["searchcat"]);
	$searchcat=str_replace(array("_","."),array(" ",","),$searchcat);
	
	$searchsubcat = mysqli_real_escape_string($conni, $_REQUEST["searchsubcat"]);
	$searchref = strtolower(mysqli_real_escape_string($conni, $_REQUEST["searchref"]));
	
	$sql="SELECT * FROM PracticeNotes_2021 WHERE (Status='Current'";
	if ($_REQUEST["searcharchived"]=="y") $sql.=" OR Status='Archived'";
	$sql.=")";
	if (!empty($searchkeyword)) {
		$sql .= " AND (LOWER(Title) like '%".$searchkeyword."%' OR LOWER(Keywords) like '%".$searchkeyword."%')";
	}
	if (!empty($searchcat)) {
		$sql.=" AND Category='".$searchcat."'";
	}
	if (!empty($searchsubcat)) {
		$sql.=" AND SubCategory='".$searchsubcat."'";
	}
	if (!empty($searchref)) {
		$sql.=" AND LOWER(PNNo) LIKE '%".$searchref."%'";
	}
	$sql.=" ORDER BY Category, SubCategory, PNNo, Title";

$result = mysqli_query($conni, $sql);
	$result_rows = mysqli_num_rows($result);
	if ($result_rows > 0 ) {
?>
<h1>Search Results:</h1>
<p>The following <b><?php echo $result_rows; ?> results</b> match your search criteria.</p>
<?php
		include("inc_practicenoteslist.php");
	} else {
	
		echo "<p><br><B>No results found. Please try a wider search criteria or a simpler keyword.</b></p>";
	}
	mysqli_free_result($result);
}
?>
<script>
function docascadeSelect(parent, child) {
 var childOptions = child.find('option:not(.static)');
 child.data('options',childOptions);
 
 parent.change(function(){
  childOptions.remove();
  child
   .append(child.data('options').filter('.sub_' + this.value))
   .change();
 })
 
 childOptions.not('.static, .sub_' + parent.val()).remove();
}

jQuery(document).ready(function( $ ) {
	catSelect = $('.catSelect');
	subSelect = $('.subSelect');
	 
	docascadeSelect(catSelect, subSelect);
});

</script>