Linux cesa-www-main 6.1.0-49-cloud-amd64 #1 SMP PREEMPT_DYNAMIC Debian 6.1.174-1 (2026-05-26) x86_64
Apache/2.4.68 (Debian)
Server IP : 10.218.0.2 & Your IP : 216.73.216.28
Domains :
Cant Read [ /etc/named.conf ]
User : www-data
Terminal
Auto Root
Create File
Create Folder
Localroot Suggester
Backdoor Destroyer
Readme
/
var /
www /
cesa.co.za /
echasl23 /
annualdec /
Delete
Unzip
Name
Size
Permission
Date
Action
inc
[ DIR ]
drwxr-sr-x
2020-06-06 16:09
pics
[ DIR ]
drwxr-sr-x
2010-05-27 06:26
print
[ DIR ]
drwxr-sr-x
2020-06-06 16:09
ADMarkComplete.php
619
B
-rw-r--r--
2020-01-08 10:39
ADMarkComplete.php4
636
B
-rw-r--r--
2010-05-28 10:40
ADaddDone.php
3.82
KB
-rw-r--r--
2020-01-08 10:39
ADaddDone.php4
3.92
KB
-rw-r--r--
2010-05-28 10:40
ADdeleteDone.php
3.56
KB
-rw-r--r--
2020-01-08 10:39
ADdeleteDone.php4
3.66
KB
-rw-r--r--
2010-05-28 10:40
ADdisplayContacts.php
44.02
KB
-rw-r--r--
2025-08-19 08:12
ADdisplayContacts.php4
27.08
KB
-rw-r--r--
2015-09-16 09:06
ADdisplayContactsTable.php
2.7
KB
-rw-r--r--
2020-01-08 10:39
ADdisplayContactsTable.php4
2.7
KB
-rw-r--r--
2015-04-08 08:21
ADdisplayDone.php
2.24
KB
-rw-r--r--
2020-01-08 10:39
ADdisplayDone.php4
2.29
KB
-rw-r--r--
2010-05-28 10:40
ADdisplayHelp.php
1.26
KB
-rw-r--r--
2020-01-08 10:39
ADdisplayHelp.php4
1.31
KB
-rw-r--r--
2010-05-28 10:31
ADdisplayMemberFirm.php
50.47
KB
-rw-r--r--
2025-12-29 10:37
ADdisplayMemberFirm.php4
59.25
KB
-rw-r--r--
2019-02-25 07:51
ADdisplayOfficeContactsTable.php
3.41
KB
-rw-r--r--
2020-01-08 10:39
ADdisplayOfficeContactsTable.php4
3.41
KB
-rw-r--r--
2015-04-08 08:22
ADdisplayOffices.php
43.24
KB
-rw-r--r--
2025-03-05 14:36
ADdisplayOffices.php4
26.64
KB
-rw-r--r--
2015-04-08 08:23
ADdisplayTest.php
1.17
KB
-rw-r--r--
2020-01-08 10:39
ADdisplayTest.php4
1.21
KB
-rw-r--r--
2010-05-28 10:40
ADdisplayrecords.php
10.24
KB
-rw-r--r--
2025-04-24 11:04
ADdisplayrecords.php4
3.94
KB
-rw-r--r--
2013-04-16 08:09
ADdisplaytblMemberFirmOffices.php
3.63
KB
-rw-r--r--
2025-03-14 16:58
ADdisplaytblMemberFirmOffices.php4
3.56
KB
-rw-r--r--
2015-04-08 08:23
ADdisplaytblMemberFirms.php
3.73
KB
-rw-r--r--
2020-01-08 10:39
ADdisplaytblMemberFirms.php4
3.73
KB
-rw-r--r--
2015-04-08 08:23
ADeditDone.php
3.71
KB
-rw-r--r--
2020-01-08 10:39
ADeditDone.php4
3.81
KB
-rw-r--r--
2010-05-28 10:40
ADfixDisplayTable.php
14.88
KB
-rw-r--r--
2020-01-08 10:39
ADfixDisplayTable.php4
15.27
KB
-rw-r--r--
2010-05-28 10:40
ShadeTable.js
535
B
-rw-r--r--
2010-05-28 10:31
accept.jpg
638
B
-rw-r--r--
2010-05-28 10:31
annualdec.php
935
B
-rw-r--r--
2020-01-08 10:39
annualdec.php4
966
B
-rw-r--r--
2010-05-28 10:31
decline.jpg
723
B
-rw-r--r--
2010-05-28 10:31
next.jpg
491
B
-rw-r--r--
2010-05-28 10:31
previous.jpg
562
B
-rw-r--r--
2010-05-28 10:31
Save
Rename
<html> <head> <title>Annual Declaration Admin page</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <style> .DarkShading { BACKGROUND-COLOR: #dceddc } </style> </head> <body bgcolor="#FFFFFF" text="#000000"> <?php include("inc/log_query.php"); include( 'inc/database.inc' ); mysql_connect("$host","$user","$password") or die("Unable to connect to SQL server"); mysql_select_db("$db") or die("Unable to select database"); $Mn1 = date("M d Y g:iA"); if (($action == "next") || ($action == "prev") || ($action == "return")) { if ($action == "return") { // Get the FirmID $Firmquery = "SELECT FirmID FROM ADec_tblMemberFirmOffices WHERE OfficeID = '$OfficeID'"; $Firmresult = mysql_query($Firmquery) or die("Select of id Failed"); $FirmRows = mysql_num_rows($Firmresult); $FirmRs = mysql_fetch_array($Firmresult); $FirmID = $FirmRs['FirmID']; } // Number of new offices $numnewquery = "SELECT * FROM ADec_tblMemberFirmOffices WHERE FirmID = '$FirmID'"; $numnewresult = mysql_query($numnewquery) or die("Select of id Failed"); $numnewcnt = mysql_num_rows($numnewresult); if ($action == "next") { $Bquery = "SELECT * FROM ADec_tblMemberFirmOffices WHERE FirmID = '$FirmID' AND OfficeID > '$OfficeID2' ORDER BY OfficeID ASC"; $Bresult = mysql_query($Bquery) or die("Select of id Failed"); $bsRows = mysql_num_rows($Bresult); $bs = mysql_fetch_array($Bresult); $OfficeID = $bs['OfficeID']; $Prev_OfficeID = $bs['Prev_OfficeID']; $Prev_FirmID = $bs['Prev_FirmID']; } elseif ($action == "return") { $Bquery = "SELECT * FROM ADec_tblMemberFirmOffices WHERE FirmID = '$FirmID' AND OfficeID >= '$OfficeID' ORDER BY OfficeID ASC"; $Bresult = mysql_query($Bquery) or die("Select of id Failed"); $bsRows = mysql_num_rows($Bresult); $bs = mysql_fetch_array($Bresult); $OfficeID = $bs['OfficeID']; $Prev_OfficeID = $bs['Prev_OfficeID']; $Prev_FirmID = $bs['Prev_FirmID']; } elseif ($action == "prev") { $Bquery = "SELECT * FROM ADec_tblMemberFirmOffices WHERE FirmID = '$FirmID' AND OfficeID < '$OfficeID2' ORDER BY OfficeID DESC"; $Bresult = mysql_query($Bquery) or die("Select of id Failed"); $bsRows = mysql_num_rows($Bresult); $bs = mysql_fetch_array($Bresult); $OfficeID = $bs['OfficeID']; $Prev_OfficeID = $bs['Prev_OfficeID']; $Prev_FirmID = $bs['Prev_FirmID']; } if ($Prev_FirmID == "") { $Zquery = "SELECT FirmID, Prev_FirmID FROM Adec_tblMemberFirms WHERE FirmID = '$FirmID'"; $Zresult = mysql_query($Zquery) or die("Select of id Failed"); $zs = mysql_fetch_array($Zresult); $Prev_FirmID = $zs['Prev_FirmID']; } $UXquery = "SELECT * FROM tblMemberFirmOffices WHERE FirmID = '$Prev_FirmID'"; $UXresult = mysql_query($UXquery) or die("Select of id Failed"); $xsRows = mysql_num_rows($UXresult); // Do we need to recalculate the row counter? if (!$rowcounter) { $countquery = "SELECT COUNT(*) FROM ADec_tblMemberFirmOffices WHERE FirmID = '$FirmID' AND OfficeID < '$OfficeID'"; $countarray = mysql_query($countquery) or die("Select of id Failed"); $countresult = mysql_fetch_array($countarray); $rowcounter = $countresult[0]+1; } } else { $rowcounter=1; // Number of new offices $numnewquery = "SELECT * FROM ADec_tblMemberFirmOffices WHERE FirmID = '$FirmID'"; $numnewresult = mysql_query($numnewquery) or die("Select of id Failed"); $numnewcnt = mysql_num_rows($numnewresult); $Bquery = "SELECT * FROM ADec_tblMemberFirmOffices WHERE FirmID = '$FirmID' ORDER BY OfficeID"; $Bresult = mysql_query($Bquery) or die("Select of id Failed"); $bsRows = mysql_num_rows($Bresult); $bs = mysql_fetch_array($Bresult); $OfficeID = $bs['OfficeID']; $Prev_OfficeID = $bs['Prev_OfficeID']; $Prev_FirmID = $bs['Prev_FirmID']; if ($Prev_FirmID == "") { $Zquery = "SELECT FirmID, Prev_FirmID FROM Adec_tblMemberFirms WHERE FirmID = '$FirmID'"; $Zresult = mysql_query($Zquery) or die("Select of id Failed"); $zs = mysql_fetch_array($Zresult); $Prev_FirmID = $zs['Prev_FirmID']; } } // echo $Xquery; // Define the content $name1 = $bs['OfficeID']; $name2 = $bs['FirmID']; $name3 = $bs['OfficeName']; $name4 = $bs['OfficeStatus']; $name5 = $bs['FullOrPartTime']; $name6 = $bs['Language']; $name7 = $bs['BldgName']; $name8 = $bs['StreetName']; $name9 = $bs['Suburb']; $name10 = $bs['GeoLocation']; $name11 = $bs['Province']; $name12 = $bs['GeoLocationLocal']; $name13 = $bs['GeoLocationDistrict']; $name14 = $bs['PostalAddress']; $name15 = $bs['Address2']; $name16 = $bs['TownCity']; $name17 = $bs['PostalCode']; $name18 = $bs['Telephone']; $name19 = $bs['Fax']; $name20 = $bs['Email']; $name21 = $bs['HRName']; $name22 = $bs['HREmail']; $name26 = $bs['Country']; $name27 = $bs['HoldingCompany']; $name28 = $bs['Fidic'].""; $name23 = $bs['ProfessionalStaff']; $name24 = $bs['NonProfTechStaff']; $name25 = $bs['OtherStaff']; if ($something == "ACCEPT") { // echo $Prev_OfficeID." ".$name1." ".$name2." ".$name3." ".$name4." ".$name5." ".$name6." ".$name7." ".$name8." ".$name9." ".$name10." ".$name11." ".$name12." ".$name13." ".$name14." ".$name15." ".$name16." ".$name17." ".$name18." ".$name19." ".$name20; // Check if the office exists $Origquery = "SELECT * FROM tblMemberFirmOffices WHERE FirmID = '$Prev_FirmID' AND OfficeID = '$Prev_OfficeID'"; // echo $Origquery; $Origresult = mysql_query($Origquery) or die("Select of id Failed"); $origexists = mysql_num_rows($Origresult); // echo($origexists); // die(); if ($origexists > 0) { //update it $updatequery = "UPDATE tblMemberFirmOffices SET OfficeName = '".addslashes($name3)."', OfficeStatus = '$name4', FullOrPartTime = '$name5', BldgName = '".addslashes($name7)."', StreetName = '".addslashes($name8)."', Suburb = '".addslashes($name9)."', GeoLocation = '$name10', Province = '$name11', GeoLocationLocal = '$name12', GeoLocationDistrict = '$name13', PostalAddress = '$name14', Address2 = '$name15', TownCity = '".addslashes($name16)."', PostalCode = '$name17', Telephone = '$name18', Fax = '$name19', Email = '$name20', HRName = '".addslashes($name21)."', HREmail = '$name22', ProfessionalStaff = '$name23', NonProfTechStaff = '$name24', Country = '$name26', OtherStaff = '$name25', HoldingCompany = '".addslashes($name27)."', Fidic = '$name28' WHERE OfficeID = '$Prev_OfficeID'"; // die($updatequery); $Upresult = mysql_query($updatequery) or die("Update of records failed"); } else { // New record // add it $updatequery = "INSERT INTO tblMemberFirmOffices (FirmID, OfficeName, OfficeStatus, FullOrPartTime, BldgName, StreetName, Suburb, GeoLocation, Province, GeoLocationLocal, GeoLocationDistrict, PostalAddress, Address2, TownCity, PostalCode, Telephone, Fax, Email, HRName, HREmail, ProfessionalStaff, NonProfTechStaff, Country, OtherStaff, HoldingCompany, Fidic) VALUES ('$Prev_FirmID','".addslashes($name3)."', '$name4','$name5','".addslashes($name7)."','".addslashes($name8)."','".addslashes($name9)."','$name10', '$name11','$name12','$name13','$name14', '$name15','$name16','$name17','$name18','$name19','$name20','".addslashes($name21)."','$name22', '$name23','$name24','$name26', '$name25','".addslashes($name27)."','$name28')"; $Upresult = mysql_query($updatequery) or die("Insert of record failed"); // Get new OfficeID $query = "SELECT MAX(OfficeID) AS OfficeID FROM tblMemberFirmOffices"; $result = mysql_query($query) or die("Scope_Identity Failed"); $row = mysql_fetch_array($result); $NewOfficeID = $row[0]; echo('NewOfficeID='.$NewOfficeID); $Prev_OfficeID = $NewOfficeID; $updatequery = "UPDATE ADec_tblMemberFirmOffices SET Prev_OfficeID='$NewOfficeID' WHERE FirmID='$FirmID' AND OfficeID='$OfficeID'"; $Upresult = mysql_query($updatequery) or die("Update of record failed"); log_query($updatequery); $updatequery2 = "UPDATE ADec_OfficeContacts SET Prev_OfficeID='$NewOfficeID' WHERE OfficeID='$OfficeID'"; $Upresult2 = mysql_query($updatequery2) or die("Update of record failed"); log_query($updatequery2); $UXquery = "SELECT * FROM tblMemberFirmOffices WHERE FirmID = '$Prev_FirmID'"; $UXresult = mysql_query($UXquery) or die("Select of id Failed"); $xsRows = mysql_num_rows($UXresult); } $updatequery2 = "INSERT INTO ADec_Done_Local (RefID,RefType,RefDoc,ADecDate) VALUES ('$OfficeID','OfficeID','UPDATED','$Mn1')"; $Upresult2 = mysql_query($updatequery2) or die("Update of records failed"); //log_query($updatequery2); } if ($something == "DECLINE") { $updatequery2 = "INSERT INTO ADec_Done_Local (RefID,RefType,RefDoc,ADecDate) VALUES ('$OfficeID','OfficeID','DECLINE','$Mn1')"; $Upresult2 = mysql_query($updatequery2) or die("Update of records failed"); //log_query($updatequery2); } $Xquery = "SELECT * FROM tblMemberFirmOffices WHERE FirmID = '$Prev_FirmID' AND OfficeID = '$Prev_OfficeID'"; $Xresult = mysql_query($Xquery) or die("Select of id Failed"); $xs = mysql_fetch_array($Xresult); // echo "Prev_OfficeID :".$Prev_OfficeID; ?> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td bgcolor="#CCCCCC"> <?php include( 'inc/menu.inc' ); ?> </td> </tr> <tr> <td align="left" valign="top"> <h3><font face="sans-serif" color="#666666">Display Member Firm Office:</font><font face="sans-serif"> <?php echo $bs['OfficeName']; ?> </font></h3> <table width="100%" border="0" cellspacing="0" cellpadding="0" dwcopytype="CopyTableRow"> <tr> <td><b><font face="sans-serif" size="2">Documents Completed <?php $Dquery = "SELECT DISTINCT RefDoc FROM ADec_Done WHERE RefID = '$OfficeID' AND RefType = 'OfficeID' AND RefDoc NOT IN ('UPDATED', 'DECLINED', 'DECLINE')"; $Dresult = mysql_query($Dquery) or die("Select of id Failed"); while ($ds = mysql_fetch_array($Dresult)) { echo " : ".$ds['RefDoc']." "; } $Dquery = "SELECT DISTINCT RefDoc FROM ADec_Done_Local WHERE RefID = '$OfficeID' AND RefType = 'OfficeID' AND RefDoc IN ('UPDATED', 'DECLINED', 'DECLINE')"; $Dresult = mysql_query($Dquery) or die("Select of id Failed"); while ($ds = mysql_fetch_array($Dresult)) { echo " : ".$ds['RefDoc']." "; } ?> </font><font face="sans-serif"> </font> </b> </td> </tr> </table> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td> <table border=0 width=100%> <tr><td> <div align="left"><?php if ($rowcounter >1) { $NewFile = "ADdisplayOffices.php4"; printf ("<a href=\"%s?FirmID=%s&OfficeID2=%s&action=prev&rowcounter=%s\")'><img src=previous.jpg border=0><font size=2><b>PREVIOUS</b></font></a>\n", $NewFile, $FirmID, $OfficeID, $rowcounter-1); } ?> </div> </td><td> <div align="right"><?php if ($rowcounter < $numnewcnt) { $NewFile = "ADdisplayOffices.php4"; printf ("<a href=\"%s?FirmID=%s&OfficeID2=%s&action=next&rowcounter=%s\")'><font size=2><b>NEXT</b></font><img src=next.jpg border=0></a>\n", $NewFile, $FirmID, $OfficeID, $rowcounter+1); } ?> </div> </td></tr></table> </td> </tr> <tr> <td> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td colspan="2"> <div align="center"><font face="sans-serif" size="2" color="#FF0000">You can ACCEPT or DECLINE the changes here. You can only do this once!</font></div> </td> </tr> <tr> <td width="50%"><font face="sans-serif" size="2"> <?php $NewFile = "ADdisplayOffices.php4"; printf ("<a href=\"%s?FirmID=%s&OfficeID=%s&action=return&something=DECLINED&rowcounter=%s\")'><img src=decline.jpg border=0><font size=2><b>DECLINE</b></font></a>\n", $NewFile, $FirmID, $OfficeID, $rowcounter); ?> </font></td> <td width="50%"> <div align="right"><font face="sans-serif" size="2"> <?php $NewFile = "ADdisplayOffices.php4"; printf ("<a href=\"%s?FirmID=%s&OfficeID=%s&action=return&something=ACCEPT&rowcounter=%s\")'><img src=accept.jpg border=0><font size=2><b>ACCEPT</b></font></a>\n", $NewFile, $FirmID, $OfficeID, $rowcounter); ?> </font></div> </td> </tr> </table> <table width="100%" border="1" cellspacing="0" cellpadding="0" id="tblShaded" name="tblShaded"> <tr> <td width="26%" bgcolor="#0000FF"><b><font face="sans-serif" color="#FFFFFF"></font></b></td> <td width="36%" bgcolor="#0000FF"><b><font face="sans-serif" color="#FFFFFF">Original <font size="2">( <?php echo $xsRows; ?> record/s)</font> </font></b></td> <td width="38%" bgcolor="#0000FF"><b><font face="sans-serif" color="#FFFFFF">New<font size="2"> (record <?php echo $rowcounter . ' of ' . $numnewcnt; ?>)</font></font></b></td> </tr> <!-- <tr> <td width="26%" bgcolor="#0000FF"><b><font color="#FFFFFF" face="sans-serif">OfficeID</font></b></td> <td width="36%"> <?php echo $xs['OfficeID']; ?> </td> <td width="38%"> <?php echo $bs['OfficeID']; ?> </td> </tr> <tr> <td width="26%" bgcolor="#0000FF"><b><font color="#FFFFFF" face="sans-serif">FirmID </font></b></td> <td width="36%"> <?php echo $xs['FirmID']; ?> </td> <td width="38%"> <?php echo $bs['FirmID']; ?> </td> </tr>--> <tr> <td width="26%" bgcolor="#0000FF"><b><font face="sans-serif" color="#FFFFFF">Office Name </font></b></td> <td width="36%"> <?php echo $xs['OfficeName']; ?> </td> <td width="38%"> <?php echo $bs['OfficeName']; ?> </td> </tr> <tr> <td width="26%" bgcolor="#0000FF"><b><font face="sans-serif" color="#FFFFFF">Office Status </font></b></td> <td width="36%"> <?php echo $xs['OfficeStatus']; ?> </td> <td width="38%"> <?php echo $bs['OfficeStatus']; ?> </td> </tr> <tr> <td width="26%" bgcolor="#0000FF"><b><font face="sans-serif" color="#FFFFFF">Full Or Part Time</font></b></td> <td width="36%"> <?php echo $xs['FullOrPartTime']; ?> </td> <td width="38%"> <?php echo $bs['FullOrPartTime']; ?> </td> </tr> <!-- <tr> <td width="26%" bgcolor="#0000FF"><b><font face="sans-serif" color="#FFFFFF">Language</font></b></td> <td width="36%"> <?php echo $xs['Language']; ?> </td> <td width="38%"> <?php echo $bs['Language']; ?> </td> </tr>--> <tr> <td colspan="3" bgcolor="#0000FF"> <div align="center"><b><font face="sans-serif" color="#FFFFFF">Physical Address </font></b></div> </td> </tr> <tr> <td width="26%" bgcolor="#0000FF"><b><font face="sans-serif" color="#FFFFFF">Building</font></b></td> <td width="38%"> <?php echo $xs['BldgName']; ?> </td> <td width="38%"> <?php echo $bs['BldgName']; ?> </td> </tr> <tr> <td width="26%" bgcolor="#0000FF"><b><font face="sans-serif" color="#FFFFFF">Street</font></b></td> <td width="38%"> <?php echo $xs['StreetName']; ?> </td> <td width="38%"> <?php echo $bs['StreetName']; ?> </td> </tr> <tr> <td width="26%" bgcolor="#0000FF"><b><font face="sans-serif" color="#FFFFFF">Suburb</font></b></td> <td width="38%"> <?php echo $xs['Suburb']; ?> </td> <td width="38%"> <?php echo $bs['Suburb']; ?> </td> </tr> <tr> <td width="26%" bgcolor="#0000FF"><b><font face="sans-serif" color="#FFFFFF">City / Town</font></b></td> <td width="38%"> <?php echo $xs['GeoLocation']; ?> </td> <td width="38%"> <?php echo $bs['GeoLocation']; ?> </td> </tr> <tr> <td width="26%" bgcolor="#0000FF"><b><font face="sans-serif" color="#FFFFFF">Province</font></b></td> <td width="38%"> <?php echo $xs['Province']; ?> </td> <td width="38%"> <?php echo $bs['Province']; ?> </td> </tr> <tr> <td width="26%" bgcolor="#0000FF"><b><font face="sans-serif" color="#FFFFFF">Local Municipality </font></b></td> <td width="38%"> <?php echo $xs['GeoLocationLocal']; ?> </td> <td width="38%"> <?php echo $bs['GeoLocationLocal']; ?> </td> </tr> <tr> <td width="26%" bgcolor="#0000FF"><b><font face="sans-serif" color="#FFFFFF">District / Metropolitan Council</font></b></td> <td width="38%"> <?php echo $xs['GeoLocationDistrict']; ?> </td> <td width="38%"> <?php echo $bs['GeoLocationDistrict']; ?> </td> </tr> <tr> <td bgcolor="#0000FF"><b><font face="sans-serif" color="#FFFFFF">Country</font></b></td> <td> <?php echo $xs['Country']; ?> </td> <td> <?php echo $bs['Country']; ?> </td> </tr> <tr> <td colspan="3" bgcolor="#0000FF"> <div align="center"><b><font face="sans-serif" color="#FFFFFF">Postal Address </font></b></div> </td> </tr> <tr> <td width="26%" bgcolor="#0000FF"><b><font face="sans-serif" color="#FFFFFF">PO Box </font></b></td> <td width="38%"> <?php echo $xs['PostalAddress']; ?> </td> <td width="38%"> <?php echo $bs['PostalAddress']; ?> </td> </tr> <tr> <td width="26%" bgcolor="#0000FF"><b><font face="sans-serif" color="#FFFFFF">extended</font></b></td> <td width="38%"> <?php echo $xs['Address2']; ?> </td> <td width="38%"> <?php echo $bs['Address2']; ?> </td> </tr> <tr> <td width="26%" bgcolor="#0000FF"><b><font face="sans-serif" color="#FFFFFF">Town / City</font></b></td> <td width="38%"> <?php echo $xs['TownCity']; ?> </td> <td width="38%"> <?php echo $bs['TownCity']; ?> </td> </tr> <tr> <td width="26%" bgcolor="#0000FF"><b><font face="sans-serif" color="#FFFFFF">Code</font></b></td> <td width="38%"> <?php echo $xs['PostalCode']; ?> </td> <td width="38%"> <?php echo $bs['PostalCode']; ?> </td> </tr> <tr> <td width="26%" bgcolor="#0000FF"><b><font face="sans-serif" color="#FFFFFF">Telephone</font></b></td> <td width="38%"> <?php echo $xs['Telephone']; ?> </td> <td width="38%"> <?php echo $bs['Telephone']; ?> </td> </tr> <tr> <td width="26%" bgcolor="#0000FF"><b><font face="sans-serif" color="#FFFFFF">Fax</font></b></td> <td width="38%"> <?php echo $xs['Fax']; ?> </td> <td width="38%"> <?php echo $bs['Fax']; ?> </td> </tr> <tr> <td width="26%" bgcolor="#0000FF"><b><font face="sans-serif" color="#FFFFFF">E-mail</font></b></td> <td width="38%"> <?php echo $xs['Email']; ?> </td> <td width="38%"> <?php echo $bs['Email']; ?> </td> </tr> <tr> <td width="26%" bgcolor="#0000FF"><b><font face="sans-serif" color="#FFFFFF">Holding Company</font></b></td> <td width="36%"> <?php echo $xs['HoldingCompany']; ?> </td> <td width="38%"> <?php echo $bs['HoldingCompany']; ?> </td> </tr> <?php if ($xs['SaaceBranch']."" == "International") { ?> <tr> <td width="26%" bgcolor="#0000FF"><b><font face="sans-serif" color="#FFFFFF">Member of local Fidic</font></b></td> <td width="36%"> <?php echo $xs['Fidic']; ?> </td> <td width="38%"> <?php echo $bs['Fidic']; ?> </td> </tr> <?php } ?> <tr> <td colspan="3" bgcolor="#0000FF"> <div align="center"><b><font face="sans-serif" color="#FFFFFF">Human Resources/ Training</font></b></div> </td> </tr> <tr> <td width="26%" bgcolor="#0000FF"><b><font face="sans-serif" color="#FFFFFF">Name of Person</font></b></td> <td width="36%"> <?php echo $xs['HRName']; ?> </td> <td width="36%"> <?php echo $bs['HRName']; ?> </td> </tr> <tr> <td width="26%" bgcolor="#0000FF"><b><font face="sans-serif" color="#FFFFFF">E-mail of Person</font></b></td> <td width="36%"> <?php echo $xs['HREmail']; ?> </td> <td width="36%"> <?php echo $bs['HREmail']; ?> </td> </tr> <tr bgcolor="#00CCFF"> <td colspan="3"> <div align="center"><b><font face="sans-serif" color="#FFFFFF">Staff Totals (Page 2)</font></b> </div> </td> </tr> <tr> <td width="26%" bgcolor="#00CCFF"><b><font face="sans-serif" color="#FFFFFF">Professional Staff </font></b></td> <td width="36%"> <?php echo $xs['ProfessionalStaff']; ?> </td> <td width="36%"> <?php echo $bs['ProfessionalStaff']; ?> </td> </tr> <tr> <td width="26%" bgcolor="#00CCFF"><b><font face="sans-serif" color="#FFFFFF">Non-Professional Staff </font></b></td> <td width="36%"> <?php echo $xs['NonProfTechStaff']; ?> </td> <td width="36%"> <?php echo $bs['NonProfTechStaff']; ?> </td> </tr> <tr> <td width="26%" bgcolor="#00CCFF"><b><font face="sans-serif" color="#FFFFFF">Other Staff </font></b></td> <td width="36%"> <?php echo $xs['OtherStaff']; ?> </td> <td width="36%"> <?php echo $bs['OtherStaff']; ?> </td> </tr> <tr> <td colspan="3"> <div align="center"><font face="sans-serif"><b>Click here to view all the <?php $NewFile = "ADdisplayContacts.php4"; printf ("<a href=\"%s?OfficeID=%s\")'><font size=2><b><u>CONTACTS</u></b></font></a>\n", $NewFile, $OfficeID); ?> for this Office </b></font></div> </td> </tr> </table> </td> </tr> <tr> <td> </td> </tr> </table> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td colspan="2"> <div align="center"><font face="sans-serif" size="2" color="#FF0000">You can ACCEPT or DECLINE the changes here. You can only do this once!</font></div> </td> </tr> <tr> <td width="50%"><font face="sans-serif" size="2"> <?php $NewFile = "ADdisplayOffices.php4"; printf ("<a href=\"%s?FirmID=%s&OfficeID=%s&action=return&something=DECLINED&rowcounter=%s\")'><img src=decline.jpg border=0><font size=2><b>DECLINE</b></font></a>\n", $NewFile, $FirmID, $OfficeID, $rowcounter); ?> </font></td> <td width="50%"> <div align="right"><font face="sans-serif" size="2"> <?php $NewFile = "ADdisplayOffices.php4"; printf ("<a href=\"%s?FirmID=%s&OfficeID=%s&action=return&something=ACCEPT&rowcounter=%s\")'><img src=accept.jpg border=0><font size=2><b>ACCEPT</b></font></a>\n", $NewFile, $FirmID, $OfficeID, $rowcounter); ?> </font></div> </td> </tr> </table> </td> </tr> <tr> <td bgcolor="#CCCCCC"><?php include( 'inc/footer.inc' ); ?></td> </tr> </table> <script language="javascript" src="ShadeTable.js"></script> <script language="javascript"> ShadeTable(document.getElementsByName("tblShaded")); </script> </body> </html>