Gecko [ v3.cesa.co.za ]

Name	Size	Permission	Date
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

Rename

<html>
<head>
<title>Annual Declaration Admin page</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<META HTTP-EQUIV="CACHE-CONTROL" CONTENT="NO-CACHE">
<META HTTP-EQUIV="PRAGMA" CONTENT="NO-CACHE">
<META HTTP-EQUIV="EXPIRES" CONTENT="0">
<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"))
{
		// ** ADEC_TBLMEMBERFIRMS
		// **********************
	  
		// Number of new contacts
		  $numnewquery = "SELECT * FROM ADec_OfficeContacts WHERE OfficeID = '$OfficeID'";
	      $numnewresult = mysql_query($numnewquery) or die("Select of id Failed");
		  $numnewcnt = mysql_num_rows($numnewresult);

//		  $rowcountquery = "SELECT * FROM ADec_OfficeContacts WHERE OfficeID = '$OfficeID'  AND ContactsID > '$ContactID' ORDER BY ContactsID ASC";
//	      $rowcountresult = mysql_query($rowcountquery) or die("Select of id Failed");
//		  $rowcounter = $numnewcnt - mysql_num_rows($rowcountresult)+1;

if ($action == "prev") {
		 	$Cquery = "SELECT * FROM ADec_OfficeContacts WHERE OfficeID = '$OfficeID' AND ContactsID < '$ContactID' ORDER BY ContactsID DESC";
	 		$Cresult = mysql_query($Cquery) or die("Select of id Failed");
			$ds = mysql_fetch_array($Cresult);
			$ContactsID = $ds['ContactsID'];
			$Prev_ContactsID = $ds['Prev_ContactsID'];
			$Prev_OfficeID = $ds['Prev_OfficeID'];
		} elseif ($action == "next") {
			$Cquery = "SELECT * FROM ADec_OfficeContacts WHERE OfficeID = '$OfficeID' AND ContactsID > '$ContactID' ORDER BY ContactsID ASC";
			$Cresult = mysql_query($Cquery) or die("Select of id Failed");
			$ds = mysql_fetch_array($Cresult);
			$ContactsID = $ds['ContactsID'];
			$Prev_ContactsID = $ds['Prev_ContactsID'];
			$Prev_OfficeID = $ds['Prev_OfficeID'];
		} elseif ($action == "return") {
			$Cquery = "SELECT * FROM ADec_OfficeContacts WHERE OfficeID = '$OfficeID' AND ContactsID >= '$ContactID' ORDER BY ContactsID ASC";
			$Cresult = mysql_query($Cquery) or die("Select of id Failed");
			$ds = mysql_fetch_array($Cresult);
			$ContactsID = $ds['ContactsID'];
			$Prev_ContactsID = $ds['Prev_ContactsID'];
			$Prev_OfficeID = $ds['Prev_OfficeID'];
		}

$Dquery = "SELECT ContactsID, Prev_ContactsID, ContactID, ContactSurname, ContactInitials, ContactFirstName, ProfessionalRegistrations, Qualifications, Comments, PreferredEmail, IDNumber, CellPhone FROM ADec_Contacts WHERE ContactsID = '$ContactsID'";
	      $Dresult = mysql_query($Dquery) or die("Select of id Failed");
		  $es = mysql_fetch_array($Dresult);

// ** TBLMEMBERFIRMS
		// **********************		 
		 if ($Prev_OfficeID == "")
		 {
		  $Wquery = "SELECT OfficeID, Prev_OfficeID FROM ADec_tblMemberfirmOffices WHERE OfficeID = '$OfficeID'";
	      $Wresult = mysql_query($Wquery) or die("Select of id Failed");
		  $ws = mysql_num_rows($Wresult);
		  $Prev_OfficeID = $ws['Prev_OfficeID'];
		 }
}
else
{
		  $rowcounter = 1;

// ** ADEC_TBLMEMBERFIRMS
		// **********************
	  
		// Number of new contacts
		  $numnewquery = "SELECT * FROM ADec_OfficeContacts WHERE OfficeID = '$OfficeID'";
	      $numnewresult = mysql_query($numnewquery) or die("Select of id Failed");
		  $numnewcnt = mysql_num_rows($numnewresult);

$Cquery = "SELECT * FROM ADec_OfficeContacts WHERE OfficeID = '$OfficeID' ORDER BY COntactsID ASC";
	      $Cresult = mysql_query($Cquery) or die("Select of id Failed");
		  $ds = mysql_fetch_array($Cresult);
		  $ContactsID = $ds['ContactsID'];
		  $Prev_ContactsID = $ds['Prev_ContactsID'];
		  $Prev_OfficeID = $ds['Prev_OfficeID'];
		  
		  $Dquery = "SELECT ContactsID, Prev_ContactsID, ContactID, ContactSurname, ContactInitials, ContactFirstName, ProfessionalRegistrations, Qualifications, Comments, PreferredEmail, IDNumber, CellPhone FROM ADec_Contacts WHERE ContactsID = '$ContactsID'";
	      $Dresult = mysql_query($Dquery) or die("Select of id Failed");
		  $es = mysql_fetch_array($Dresult);

// set values
$name1 = $ds['ContactsID'];
$name2 = $ds['OfficeID'];
$name3 = $es['ContactSurname'];
$name4 = $es['ContactInitials'];
$name5 = $es['ContactFirstName'];
$name6 = $es['ProfessionalRegistrations'];
$name7 = $es['Qualifications'];
$name8 = $es['Comments'];
$name9 = $ds['ContactPosition'];
$name10 = $es['PreferredEmail'];
$name11 = $ds['MandatedPrincipal'];
$name12 = $ds['OfficeHead'];
$name13 = $ds['Principal'];
$name14 = $ds['OfficeLiaison'];
$name15 = $ds['OfficeLiaisonB'];
$name16 = $ds['SchoolMail'];
$name17 = $es['ContactDesignation'];
$name18 = $ds['Email'];
$name19 = $ds['Mail'];
$name20 = $ds['OfficeLiaison'];
$name21 = $ds['OfficeLiaisonB'];
$name22 = $es['IDNumber'];
$name23 = $es['CellPhone'];
$YPF = $ds['YPF'];

$newrowstyle = '';

if ($es['ContactID'] == 1) {
	$newrowstyle = " style='text-decoration:line-through;'";
}

if ($something == "ACCEPT")
{
	// Check if the contact exists
	$Origquery = "SELECT ContactsID FROM Contacts WHERE ContactsID = '$Prev_ContactsID'";
	$Origresult = mysql_query($Origquery) or die("Select of id Failed");
	$origexists = mysql_num_rows($Origresult);
	if ($origexists > 0) {
		//Check if the record should be deleted
		
		if ($es['ContactID'] == 1) {
			// kill it
			$ACCquery2 = "DELETE FROM MemberContacts WHERE ContactID = '$Prev_ContactsID'";
			$ACCresult2 = mysql_query($ACCquery2) or die("delete failed");

$ACCquery = "DELETE FROM OfficeContacts WHERE ContactsID = '$Prev_ContactsID'";
			$ACCresult = mysql_query($ACCquery) or die("delete failed");

$ACCquery = "DELETE FROM Contacts WHERE ContactsID = '$Prev_ContactsID'";
			$ACCresult = mysql_query($ACCquery) or die("delete failed");
		} else {
			//update it
			$ACCquery2 = "UPDATE MemberContacts SET
			ContactSurname = '".addslashes($name3)."', 
			ContactInitials = '$name4', 
			ContactFirstName = '".addslashes($name5)."', 
			Comments = '".addslashes($name8)."', 
			ProfessionalRegistrations = '".addslashes($name6)."', 
			Qualifications = '".addslashes($name7)."', 
			ContactPosition = '$name9', 
			MandatedPrincipal = '$name11', 
			OfficeHead = '$name12', 
			Principal = '$name13', 
			Email = '$name10',
			IDNumber = '$name22',
			CellPhone = '$name23' WHERE ContactID = '$Prev_ContactsID'";
			// echo $ACCquery2;
			$ACCresult = mysql_query($ACCquery2) or die("update failed ".$ACCquery2);

$ACCquery2 = "UPDATE Contacts SET
			ContactSurname = '".addslashes($name3)."', 
			ContactInitials = '$name4', 
			ContactFirstName = '".addslashes($name5)."', 
			Comments = '".addslashes($name8)."', 
			ProfessionalRegistrations = '".addslashes($name6)."', 
			Qualifications = '".addslashes($name7)."', 
			PreferredEmail = '$name10',
			IDNumber = '$name22',
			CellPhone = '$name23' WHERE ContactsID = '$Prev_ContactsID'";
			// echo $ACCquery2;
			$ACCresult = mysql_query($ACCquery2) or die("update failed ".$ACCquery2);

$ACCquery2 = "UPDATE OfficeContacts SET
			ContactPosition = '$name9', 
			MandatedPrincipal = '$name11', 
			OfficeHead = '$name12', 
			Principal = '$name13', 
			Email = '$name10'
			WHERE ContactsID = '$Prev_ContactsID'";
			// echo $ACCquery2;
			$ACCresult = mysql_query($ACCquery2) or die("update failed ".$ACCquery2);
		}
	} else {
		// New record
		//Check if the record should be deleted
		
		if ($es['ContactID'] != 1) {
			
			$recNewID=mysql_query("SELECT MAX(ContactsID) AS NewID FROM Contacts");
			$rowNewID=mysql_fetch_assoc($recNewID);
			$iCurrentTopID=$rowNewID["NewID"];
			
			$ACCquery2 = "INSERT INTO Contacts (ContactSurname, ContactInitials, ContactFirstName, 
				ContactDesignation, Comments, ProfessionalRegistrations, Qualifications, 
				PreferredEmail, IDNumber, CellPhone) VALUES ('".addslashes($name3)."', '".addslashes($name4)."', '".addslashes($name5)."', '".addslashes($name17)."', '".addslashes($name8)."', '".addslashes($name6)."', '".addslashes($name7)."', '".addslashes($name10)."', '".addslashes($name22)."', '".addslashes($name23)."')";
			$ACCresult2 = mysql_query($ACCquery2) or die("update failed ".$ACCquery2);
			
			// Get new ContactsID
			$NewContactsID=mysql_insert_id();
			
			if (intval($NewContactsID)<=intval($iCurrentTopID)) die("Could not create new contact");
			
			$ACCquery = "INSERT INTO OfficeContacts (ContactsID, OfficeID, ContactPosition, MandatedPrincipal, 
				OfficeHead, Principal, Email, Mail, OfficeLiaison, OfficeLiaisonB, 
				SchoolMail, YPF) VALUES ('$NewContactsID', '$Prev_OfficeID', '".addslashes($name9)."', '".addslashes($name11)."', '".addslashes($name12)."', '".addslashes($name13)."', '".addslashes($name10)."', '".addslashes($name19)."',
				'".addslashes($name20)."', '".addslashes($name21)."', '".addslashes($name16)."', '$YPF')";
			$ACCresult = mysql_query($ACCquery) or die("update failed ".$ACCquery2);

// add it
			$ACCquery2 = "INSERT INTO MemberContacts (ContactID, ContactSurname, ContactInitials, ContactFirstName, 
				ContactDesignation, Comments, ProfessionalRegistrations, Qualifications, 
				OfficeID, ContactPosition, MandatedPrincipal, 
				OfficeHead, Principal, Email, Mail, OfficeLiaison, OfficeLiaisonB, 
				SchoolMail, IDNumber, CellPhone, YPF) VALUES ('$NewContactsID', '".addslashes($name3)."', '".addslashes($name4)."', '".addslashes($name5)."', '".addslashes($name17)."', '".addslashes($name8)."', '".addslashes($name6)."', '".addslashes($name7)."',
				'$Prev_OfficeID', '".addslashes($name9)."', '".addslashes($name11)."', '".addslashes($name12)."', '".addslashes($name13)."', '".addslashes($name10)."', '".addslashes($name19)."',
				'".addslashes($name20)."', '".addslashes($name21)."', '".addslashes($name16)."', '".addslashes($name22)."', '".addslashes($name23)."', '$YPF')";
			$ACCresult2 = mysql_query($ACCquery2) or die("update failed ".$ACCquery2);
			
			$ACCquery = "UPDATE ADec_OfficeContacts Set Prev_ContactsID='$NewContactsID' WHERE ContactsID='$ContactsID'";
			$ACCresult = mysql_query($ACCquery) or die("update failed ".$ACCquery2);
			log_query($ACCquery);
			
			$ACCquery = "UPDATE ADec_Contacts Set Prev_ContactsID='$NewContactsID' WHERE ContactsID='$ContactsID'";
			$ACCresult = mysql_query($ACCquery) or die("update failed ".$ACCquery2);
			log_query($ACCquery);
			
			$Prev_ContactsID = $NewContactsID;
		}
	}

$updatequery2 = "INSERT INTO ADec_Done_Local (RefID,RefType,RefDoc,ADecDate) VALUES ('$ContactsID','ContactsID','UPDATED','$Mn1')";
$Upresult2 = mysql_query($updatequery2) or die("Update of records failed");
//log_query($updatequery2);
}

if ($something == "DECLINED")
{
$updatequery2 = "INSERT INTO ADec_Done_Local (RefID,RefType,RefDoc,ADecDate) VALUES ('$ContactsID','ContactsID','DECLINED','$Mn1')";
$Upresult2 = mysql_query($updatequery2) or die("Update of records failed");
//log_query($updatequery2);
}

// Number of old contacts
$numoldquery = "SELECT * FROM MemberContacts WHERE OfficeID = '$Prev_OfficeID'";
// echo $numoldquery;
$numoldresult = mysql_query($numoldquery) or die("Select of id Failed ".$numoldquery);
$numoldcnt = mysql_num_rows($numoldresult);

$Yquery = "SELECT * FROM OfficeContacts WHERE ContactsID = '$Prev_ContactsID'";
$Yresult = mysql_query($Yquery) or die("Select of id Failed ".$Yquery);
$ys = mysql_fetch_array($Yresult);

$Zquery = "SELECT ContactID AS ContactsID, ContactSurname, ContactInitials, ContactFirstName, ProfessionalRegistrations, Qualifications, Comments, Email AS PreferredEmail, CellPhone, IDNumber FROM MemberContacts WHERE ContactID = '$Prev_ContactsID'";
// echo $Zquery;
$Zresult = mysql_query($Zquery) or die("Select of id Failed ".$Zquery);
$zs = mysql_fetch_array($Zresult);
		?>
<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>Display Contacts For The Office: 
 </h3>
 <table width="100%" border="0" cellspacing="0" cellpadding="0">
	 <tr>	
	 <td>
	 Record Status 
 <?php
			$RefId = $ds['ContactsID'];
		 $DDDquery = "SELECT distinct RefDoc FROM ADec_Done WHERE RefID = '$name1' AND RefType = 'OfficeID' AND RefDoc NOT IN ('UPDATED', 'DECLINED', 'DECLINE')";
	 $DDDresult = mysql_query($DDDquery) or die("Select of id Failed");
		 while ($ddds = mysql_fetch_array($DDDresult))
		 {
		 echo " : ".$ddds['RefDoc']." ";
		 }
		 $DDDquery = "SELECT distinct RefDoc FROM ADec_Done_Local WHERE RefID = '$name1' AND RefType = 'OfficeID' AND RefDoc IN ('UPDATED', 'DECLINED', 'DECLINE')";
	 $DDDresult = mysql_query($DDDquery) or die("Select of id Failed");
		 while ($ddds = mysql_fetch_array($DDDresult))
		 {
		 echo " : ".$ddds['RefDoc']." ";
		 }
		 ?>
 
	 </td>
 </tr>	
 <tr> 
 <td width="25%"> <div align="left"><?php 
			if ($rowcounter >1)
			{
			$NewFile = "ADdisplayContacts.php4"; printf ("<a href=\"%s?OfficeID=%s&ContactID=%s&action=prev&rowcounter=%s\")'><img src=previous.jpg border=0>PREVIOUS</a>\n", $NewFile, $OfficeID, $ContactsID, $rowcounter-1); 
			}
			?></div>
</td>
 <td width="24%">&nbsp;</td>
 <td width="51%"> 
 <div align="right"><?php 
			if ($rowcounter < $numnewcnt)
			{
			$NewFile = "ADdisplayContacts.php4"; printf ("<a href=\"%s?OfficeID=%s&ContactID=%s&action=next&rowcounter=%s\")'>NEXT<img src=next.jpg border=0></a>\n", $NewFile, $OfficeID, $ContactsID, $rowcounter+1); 
			}
			?></div>
 </td>
 </tr>
 <tr> 
 <td colspan="3"> 
 <table width="100%" border="0" cellspacing="0" cellpadding="0">
 <tr> 
 <td colspan="2"> 
 <div align="center">You 
 can ACCEPT or DECLINE the changes here. You can only do this 
 once!</div>
 </td>
 </tr>
 <tr> 
 <td width="50%"> 
 <?php
				 if (($action == "next") || ($action == "prev"))
				 {
				 $NewFile = "ADdisplayContacts.php4"; printf ("<a href=\"%s?OfficeID=%s&ContactID=%s&something=DECLINED&action=return&rowcounter=%s\")'><img src=decline.jpg border=0>DECLINE</a>\n", $NewFile, $OfficeID, $ContactsID, $rowcounter); 
				 }
				 else
				 {
				 $NewFile = "ADdisplayContacts.php4"; printf ("<a href=\"%s?OfficeID=%s&something=DECLINED\")'><img src=decline.jpg border=0>DECLINE</a>\n", $NewFile, $OfficeID); 
				 }
				 
				 ?>
 </td>
 <td width="50%"> 
 <div align="right"> 
 <?php
				 if (($action == "next") || ($action == "prev"))
				 {
				 $NewFile = "ADdisplayContacts.php4"; printf ("<a href=\"%s?OfficeID=%s&ContactID=%s&something=ACCEPT&action=return&rowcounter=%s\")'><img src=accept.jpg border=0>ACCEPT</a>\n", $NewFile, $OfficeID, $ContactsID, $rowcounter); 
				 }
				 else
				 {
				 $NewFile = "ADdisplayContacts.php4"; printf ("<a href=\"%s?OfficeID=%s&something=ACCEPT\")'><img src=accept.jpg border=0>ACCEPT</a>\n", $NewFile, $OfficeID); 
				 }
				 
				 ?>
 </div>
 </td>
 </tr>
 </table>
 	
 <table width="100%" border="1" cellspacing="0" cellpadding="0" id="tblShaded" name="tblShaded">
 <tr> 
 <td width="26%" bgcolor="#0000FF"></td>
 <td width="36%" bgcolor="#0000FF">Original 
 (<?php echo $numoldcnt; ?> records)</td>
 <td width="38%" bgcolor="#0000FF">New 
 (record <?php
 	if ($es['ContactID'] == 1) {
 		echo 'DELETED';
 	} else {
 		echo $rowcounter . ' of ' . $numnewcnt; 
 	}
 ?>)</td>
 </tr>

 <tr> 
 <td width="26%" bgcolor="#0000FF">Surname</td>
 <td width="36%"> 
 <?php echo $zs['ContactSurname']; ?> </td>
 <td width="38%"<?php echo $newrowstyle ?>> 
 <?php echo $es['ContactSurname']; ?> </td>
 </tr>
 <tr> 
 <td width="26%" bgcolor="#0000FF">Initials</td>
 <td width="36%"> 
 <?php echo $zs['ContactInitials']; ?> </td>
 <td width="38%"<?php echo $newrowstyle ?>> 
 <?php echo $es['ContactInitials']; ?> </td>
 </tr>
 <tr> 
 <td width="26%" bgcolor="#0000FF">Known 
 As </td>
 <td width="36%"> 
 <?php echo $zs['ContactFirstName']; ?> </td>
 <td width="38%"<?php echo $newrowstyle ?>> 
 <?php echo $es['ContactFirstName']; ?> </td>
 </tr>
 <tr> 
 <td width="26%" bgcolor="#0000FF">Proff 
 Registration</td>
 <td width="36%"> 
 <?php echo $zs['ProfessionalRegistrations']; ?> </td>
 <td width="38%"<?php echo $newrowstyle ?>> 
 <?php echo $es['ProfessionalRegistrations']; ?> </td>
 </tr>
 <tr> 
 <td width="26%" bgcolor="#0000FF">Qualifications</td>
 <td width="36%"> 
 <?php echo $zs['Qualifications']; ?> </td>
 <td width="38%"<?php echo $newrowstyle ?>> 
 <?php echo $es['Qualifications']; ?> </td>
 </tr>
 <tr> 
 <td width="26%" bgcolor="#0000FF">Field/s 
 of Expertise</td>
 <td width="38%"> 
 <?php echo $zs['Comments']; ?> </td>
 <td width="38%"<?php echo $newrowstyle ?>> 
 <?php echo $es['Comments']; ?> </td>
 </tr>
 <tr> 
 <td width="26%" bgcolor="#0000FF">Position 
 in firm</td>
 <td width="38%"> 
 <?php echo $ys['ContactPosition']; ?> </td>
 <td width="38%"<?php echo $newrowstyle ?>> 
 <?php echo $ds['ContactPosition']; ?> </td>
 </tr>
 <tr> 
 <td width="26%" bgcolor="#0000FF">E-mail 
 address </td>
 <td width="38%"> 
 <?php echo $zs['PreferredEmail']; ?> </td>
 <td width="38%"<?php echo $newrowstyle ?>> 
 <?php echo $es['PreferredEmail']; ?> </td>
 </tr>
 <tr> 
 <td width="26%" bgcolor="#0000FF">Mandated 
 Principal</td>
 <td width="38%"> 
 <?php if ($ys['MandatedPrincipal'] == 0) { echo "No";} else {echo "Yes";} ?> </td>
 <td width="38%"<?php echo $newrowstyle ?>> 
 <?php if ($ds['MandatedPrincipal'] == 0) { echo "No";} else {echo "Yes";} ?> </td>
 </tr>
 <tr> 
 <td width="26%" bgcolor="#0000FF">Office 
 Head </td>
 <td width="38%">
 <?php if ($ys['OfficeHead'] == 0) { echo "No";} else {echo "Yes";} ?> </td>
 <td width="38%"<?php echo $newrowstyle ?>>
 <?php if ($ds['OfficeHead'] == 0) { echo "No";} else {echo "Yes";} ?> </td>
 </tr>
 <tr> 
 <td width="26%" bgcolor="#0000FF">Principal</td>
 <td width="38%">
 <?php if ($ys['Principal'] == 0) { echo "No";} else {echo "Yes";} ?> </td>
 <td width="38%"<?php echo $newrowstyle ?>>
 <?php if ($ds['Principal'] == 0) { echo "No";} else {echo "Yes";} ?> </td>
 </tr>
 <tr>
 <td width="26%" bgcolor="#0000FF">ID Number </td>
 <td><?php echo $zs['IDNumber']; ?></td>
 <td<?php echo $newrowstyle ?>><?php echo $es['IDNumber']; ?></td>
 </tr>
 <tr>
 <td width="26%" bgcolor="#0000FF">Cellphone Number </td>
 <td><?php echo $zs['CellPhone']; ?></td>
 <td<?php echo $newrowstyle ?>><?php echo $es['CellPhone']; ?></td>
 </tr>
 <tr> 
 <td width="26%" bgcolor="#0000FF">Office 
 Liaison </td>
 <td width="38%">
 <?php echo $ys['OfficeLiaison']; ?> </td>
 <td width="38%"<?php echo $newrowstyle ?>>
 <?php echo $ds['OfficeLiaison']; ?> </td>
 </tr>
 <tr> 
 <td width="26%" bgcolor="#0000FF">Office 
 Liaison B</td>
 <td width="38%">
 <?php echo $ys['OfficeLiaisonB']; ?> </td>
 <td width="38%"<?php echo $newrowstyle ?>>
 <?php echo $ds['OfficeLiaisonB']; ?> </td>
 </tr>
 <tr>
 <td width="26%" bgcolor="#0000FF">School 
 Mail</td>
 <td width="38%">
 <?php echo $ys['SchoolMail']; ?> </td>
 <td width="38%"<?php echo $newrowstyle ?>>
 <?php echo $ds['SchoolMail']; ?> </td>
 </tr>
 <tr>
 <td width="26%" bgcolor="#0000FF">YPF (only updated for new contacts)</td>
 <td width="38%">
 <?php echo $ys['YPF']; ?> </td>
 <td width="38%"<?php echo $newrowstyle ?>>
 <?php echo $ds['YPF']; ?> </td>
 </tr>
 <tr> 
 <td colspan="3"> 
 <div align="center">Click 
 here to return to the 
 <?php $NewFile = "ADdisplayOffices.php4"; printf ("<a href=\"%s?OfficeID=%s&action=return\")'>OFFICE</a>\n", $NewFile, $OfficeID); ?>
 for this Contact </div> </td>
 </tr>
 </table>
 </td>
 </tr>
 <tr> 
 <td colspan="3">
 <table width="100%" border="0" cellspacing="0" cellpadding="0">
 <tr> 
 <td colspan="2"> 
 <div align="center">You 
 can ACCEPT or DECLINE the changes here. You can only do this 
 once!</div>
 </td>
 </tr>
 <tr> 
 <td width="50%"> 
 <?php
				 if (($action == "next") || ($action == "prev"))
				 {
				 $NewFile = "ADdisplayContacts.php4"; printf ("<a href=\"%s?OfficeID=%s&ContactID=%s&something=DECLINED&action=return&rowcounter=%s\")'><img src=decline.jpg border=0>DECLINE</a>\n", $NewFile, $OfficeID, $ContactsID, $rowcounter); 
				 }
				 else
				 {
				 $NewFile = "ADdisplayContacts.php4"; printf ("<a href=\"%s?OfficeID=%s&something=DECLINED\")'><img src=decline.jpg border=0>DECLINE</a>\n", $NewFile, $OfficeID); 
				 }
				 
				 ?>
 </td>
 <td width="50%"> 
 <div align="right"> 
 <?php
				 if (($action == "next") || ($action == "prev"))
				 {
				 $NewFile = "ADdisplayContacts.php4"; printf ("<a href=\"%s?OfficeID=%s&ContactID=%s&something=ACCEPT&action=return&rowcounter=%s\")'><img src=accept.jpg border=0>ACCEPT</a>\n", $NewFile, $OfficeID, $ContactsID, $rowcounter); 
				 }
				 else
				 {
				 $NewFile = "ADdisplayContacts.php4"; printf ("<a href=\"%s?OfficeID=%s&something=ACCEPT\")'><img src=accept.jpg border=0>ACCEPT</a>\n", $NewFile, $OfficeID); 
				 }
				 
				 ?>
 </div>
 </td>
 </tr>
 </table>
 </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>