Gecko [ v3.cesa.co.za ]

Name	Size	Permission	Date
adobe.inc	107 B	-rw-r--r--	2008-01-09 07:51
auth.inc	3.52 KB	-rw-r--r--	2025-04-30 14:24
auth.inc.bak	1.12 KB	-rw-r--r--	2025-03-07 12:21
calendar.inc	5.46 KB	-rw-r--r--	2008-01-09 08:36
conf.inc	683 B	-rw-r--r--	2025-03-07 12:21
conf.inc.bak	690 B	-rw-r--r--	2025-03-07 12:21
confdec.inc	364 B	-rw-r--r--	2025-03-07 12:21
createadec.inc	175 B	-rw-r--r--	2008-01-09 07:51
db.inc	146 B	-rw-r--r--	2025-03-07 12:21
declaration.inc	19.69 KB	-rw-r--r--	2026-01-20 15:55
declaration_nav.php	4.76 KB	-rw-r--r--	2025-02-20 10:14
declaration_nav.php4	4.69 KB	-rw-r--r--	2008-01-09 08:36
declaration_nav_int.php	5.87 KB	-rw-r--r--	2021-02-24 09:22
declaration_nav_int.php4	5.96 KB	-rw-r--r--	2015-01-22 06:13
default.css	4.06 KB	-rw-r--r--	2008-01-09 07:51
dont-click.prefs.inc	3.38 KB	-rw-r--r--	2008-01-09 08:36
footer.inc	3.13 KB	-rw-r--r--	2025-05-19 11:13
footer2.inc	157 B	-rw-r--r--	2008-01-09 07:51
func.inc	3.36 KB	-rw-r--r--	2025-01-13 14:32
funcinternational.inc	2.66 KB	-rw-r--r--	2008-01-09 07:51
header.inc	4.12 KB	-rw-r--r--	2025-01-31 07:03
header2.inc	2.05 KB	-rw-r--r--	2008-01-09 08:36
internationalheader.inc	590 B	-rw-r--r--	2008-01-09 07:51
internationalmenu.inc	378 B	-rw-r--r--	2008-01-09 07:51
login_footer.inc	748 B	-rw-r--r--	2008-01-09 07:51
login_header.inc	1.43 KB	-rw-r--r--	2008-01-09 07:51
misc.inc	363 B	-rw-r--r--	2008-01-09 07:51
nav.inc	528 B	-rw-r--r--	2008-01-09 07:51
notice.inc	530 B	-rw-r--r--	2008-01-09 08:36
press.inc	1.53 KB	-rw-r--r--	2008-01-09 08:36
rc4cryptclass.inc	1.27 KB	-rw-r--r--	2008-01-09 07:51
readnext.inc	8.77 KB	-rw-r--r--	2025-03-07 12:21
readnext.inc.bak	6.8 KB	-rw-r--r--	2025-03-07 12:21
readnextold.inc	6.64 KB	-rw-r--r--	2025-03-07 12:21
sched1page2gen.inc	7.65 KB	-rw-r--r--	2025-07-18 08:31
submitcheck.inc	23.74 KB	-rw-r--r--	2025-07-18 09:41
submitcheck.inc.bak	6.28 KB	-rw-r--r--	2025-03-07 12:21
submitcheck2.inc	13.04 KB	-rw-r--r--	2025-07-18 07:32
submitcheck2_A.inc	18.75 KB	-rw-r--r--	2025-07-18 07:47
submitcheck2b.inc	11 KB	-rw-r--r--	2025-07-18 07:47
submitcheck2b_A.inc	14.9 KB	-rw-r--r--	2025-03-07 12:21
submitcheckA.inc	21.38 KB	-rw-r--r--	2025-07-18 07:20
submitcheckqmig.inc	1.35 KB	-rw-r--r--	2025-03-07 12:21
survey_footer.inc	2.35 KB	-rw-r--r--	2008-01-09 07:51
test.html	11.56 KB	-rw-r--r--	2008-01-09 07:51
viewcal.inc	2.33 KB	-rw-r--r--	2008-01-09 08:36
voting_class.inc	11.04 KB	-rw-r--r--	2025-03-07 12:21
work.inc	1.26 KB	-rw-r--r--	2008-01-09 08:36

Rename

<table width="500" cellpadding="0" border="1" cellspacing="1">
 <tr>
 <td width="11%" align="right" valign="middle"><?php
 mysql_connect("$host","$user","$password") or die("Unable to connect to SQL server");
 mysql_select_db("$db") or die("Unable to select database"); 
		$query = "SELECT ADecDate FROM ADec_Done, ADec_tblMemberFirms WHERE RefID=FirmID and Prev_FirmID='$MemberFirmID' AND RefType='FirmID' AND RefDoc='AnnualDeclaration' ORDER BY ADecDate DESC";
		$result = mysql_query($query) or die("Select from ADec_Done failed");
		if ($row = mysql_fetch_array($result)) {
			echo("Done ".$row['ADecDate']."");
		} else {
			echo("Not done");
		}
?></td> 
 <td colspan="2" valign="middle"><a href="annualGENERIC4.php"><img src="images/step1.gif" width="30" height="30" border="0" align="absmiddle"> Annual 
 Declaration</a></td>
 </tr>

 <tr>
 <td valign="middle"></td> 
 <td colspan="2" valign="middle"><img src="images/step2.gif" width="30" height="30" border="0" align="absmiddle">Schedule 1: Details 
 of offices within the Republic of South Africa</td>
 </tr>
 <?php
 $query = "SELECT * FROM ADec_tblMemberFirmOffices WHERE (Prev_FirmID = '$MemberFirmID') AND (SaaceBranch <> 'International' OR SaaceBranch IS NULL) ORDER BY OfficeID";
	 $result = mysql_query($query) or die("Select of id Failed");

$i = 1;
		while (($rs = mysql_fetch_array($result)))
		{
		 ?>
 <tr>
 <td><div align="right"></div></td> 
 <td width="8%">&nbsp;</td>
 <td width="80%"><?php echo "<a href=\"schedule1_page1GENERIC.php?officenum=$i&SelectOfficeID=".$rs['OfficeID']."\"> ".$rs['OfficeName']." in ".$rs['GeoLocation']."</a>"; ?></td>
 </tr>
 <?php
		$i = $i + 1;
		}
		?>
 <tr>
 <td valign="middle" align="right"><?php
		$query = "SELECT ADecDate FROM ADec_Done, ADec_tblMemberFirms WHERE RefID=FirmID and Prev_FirmID='$MemberFirmID' AND RefType='FirmID' AND RefDoc='Schedule1A' ORDER BY ADecDate DESC";
		$result = mysql_query($query) or die("Select from ADec_Done failed");
		if ($row = mysql_fetch_array($result)) {
			echo("Done ".$row['ADecDate']."");
		} else {
			echo("Not done");
		}
?>		</td> 
 <td colspan="2" valign="middle"><a href="schedule1aGENERIC.php"><img src="images/step3.gif" width="30" height="30" border="0" align="absmiddle">Schedule 
 1A: Firms to be treated as one</a></td>
 </tr>
 <tr>
 <td valign="middle"><div align="right"></div></td> 
 <td colspan="2" valign="middle"><img src="images/step4.gif" width="30" height="30" border="0" align="absmiddle">Schedule 1B: Details 
 of offices outside the Republic of South Africa</td>
 </tr>
 <?php
 $query = "SELECT * FROM ADec_tblMemberFirmOffices WHERE (Prev_FirmID = '$MemberFirmID') AND (SaaceBranch = 'International') ORDER BY OfficeID";
	 $result = mysql_query($query) or die("Select of id Failed");
		$i = 1;
		while (($rs = mysql_fetch_array($result)))
		{
		 ?>
 <tr>
 <td><div align="right"></div></td> 
 <td>&nbsp;</td>
 <td> 
 <?php echo "<a href=\"schedule1b_page1GENERIC.php?officenum=$i&SelectOfficeID=".$rs['OfficeID']."\"> ".$rs['OfficeName']." in ".$rs['Country']."</a>"; ?>
 </td>
 </tr>
 <?php
		$i = $i + 1;
		}
		?>
 <tr>
 <td valign="middle" align="right"><?php
		$query = "SELECT ADecDate FROM ADec_Done, ADec_tblMemberFirms WHERE RefID=FirmID and Prev_FirmID='$MemberFirmID' AND RefType='FirmID' AND RefDoc='Schedule2' ORDER BY ADecDate DESC";
		$result = mysql_query($query) or die("Select from ADec_Done failed");
		if ($row = mysql_fetch_array($result)) {
			echo("Done ".$row['ADecDate']."");
		} else {
			echo("Not done");
		}
?></td> 
 <td colspan="2" valign="middle"><a href="schedule2GENERIC.php"><img src="images/step5.gif" width="30" height="30" border="0" align="absmiddle">Schedule 
 2: Fields of expertise</a></td>
 </tr>
 <tr>
 <td valign="middle" align="right"><?php
		$query = "SELECT ADecDate FROM ADec_Done, ADec_tblMemberFirms WHERE RefID=FirmID and Prev_FirmID='$MemberFirmID' AND RefType='FirmID' AND RefDoc='PrintSchedules' ORDER BY ADecDate DESC";
		$result = mysql_query($query) or die("Select from ADec_Done failed");
		if ($row = mysql_fetch_array($result)) {
			echo("Done ".$row['ADecDate']."");
		} else {
			echo("Not done");
		}
?></td> 
 <td colspan="2" valign="middle"><a href="printschedules.php"><img src="images/step6.gif" width="30" height="30" border="0" align="absmiddle">Documents to be printed</a></td>
 </tr>
 </table>