Gecko [ v3.cesa.co.za ]

Name	Size	Permission	Date
inc	[ DIR ]	drwxr-sr-x	2008-01-09 07:51
.htaccess	394 B	-rw-r--r--	2017-10-25 14:17
.htpasswd	41 B	-rw-r--r--	2008-01-16 06:26
ADMarkComplete.php4	551 B	-rw-r--r--	2008-01-09 09:25
ADaddDone.php4	3.92 KB	-rw-r--r--	2008-01-09 09:20
ADdeleteDone.php4	3.65 KB	-rw-r--r--	2008-01-09 09:20
ADdisplayContacts.php4	23.05 KB	-rw-r--r--	2008-01-09 09:25
ADdisplayContactsTable.php4	2.75 KB	-rw-r--r--	2008-01-09 09:25
ADdisplayDone.php4	2.27 KB	-rw-r--r--	2008-01-09 09:25
ADdisplayHelp.php4	1.31 KB	-rw-r--r--	2008-01-09 09:16
ADdisplayMemberFirm.php4	45.72 KB	-rw-r--r--	2008-01-09 09:25
ADdisplayOfficeContactsTable.php4	3.47 KB	-rw-r--r--	2008-01-09 09:25
ADdisplayOffices.php4	25.54 KB	-rw-r--r--	2008-01-16 08:04
ADdisplayTest.php4	1.21 KB	-rw-r--r--	2008-01-09 09:25
ADdisplayrecords.php4	3.28 KB	-rw-r--r--	2008-01-09 09:25
ADdisplaytblMemberFirmOffices.php4	3.62 KB	-rw-r--r--	2008-01-09 09:25
ADdisplaytblMemberFirms.php4	3.79 KB	-rw-r--r--	2008-01-09 09:25
ADeditDone.php4	3.75 KB	-rw-r--r--	2008-01-09 09:20
ADfixDisplayTable.php4	15.31 KB	-rw-r--r--	2008-01-09 09:25
ShadeTable.js	535 B	-rw-r--r--	2008-01-09 09:16
accept.jpg	638 B	-rw-r--r--	2008-01-09 09:16
addAdvisory-listing.php4	4.08 KB	-rw-r--r--	2008-01-09 09:20
addLinks.php4	4.09 KB	-rw-r--r--	2008-01-09 09:20
addNLCC.php4	9.48 KB	-rw-r--r--	2008-01-09 09:20
addPress.php4	3.53 KB	-rw-r--r--	2008-01-09 09:20
admin_b.php	557 B	-rw-r--r--	2009-05-15 13:23
admin_b.phtml	557 B	-rw-r--r--	2008-01-09 09:16
annualdec.php4	966 B	-rw-r--r--	2008-01-09 09:16
changedivision.php4	2.65 KB	-rw-r--r--	2008-01-09 09:16
db_import.php	91 B	-rw-r--r--	2009-05-15 13:23
db_import.phtml	91 B	-rw-r--r--	2008-01-09 09:16
decline.jpg	723 B	-rw-r--r--	2008-01-09 09:16
deleteAdvisory-listing.php4	4.23 KB	-rw-r--r--	2008-01-09 09:20
deleteLinks.php4	4.21 KB	-rw-r--r--	2008-01-09 09:20
documents.php	1.11 KB	-rw-r--r--	2009-05-15 13:23
documents.phtml	1.11 KB	-rw-r--r--	2008-01-09 09:20
editAdvisory-listing.php4	4.89 KB	-rw-r--r--	2008-01-09 09:20
editLinks.php4	4.71 KB	-rw-r--r--	2008-01-09 09:20
graph.php	1.83 KB	-rw-r--r--	2009-05-15 13:23
graph.phtml	1.83 KB	-rw-r--r--	2008-01-09 09:20
ht.acl	167 B	-rw-r--r--	2008-01-09 09:16
index.php4	4.78 KB	-rw-r--r--	2010-01-19 13:04
linkscript	31 B	-rw-r--r--	2008-01-09 09:16
manageAdvisory-listing.php4	2.78 KB	-rw-r--r--	2008-01-09 09:20
manageAdvisory.php4	1.21 KB	-rw-r--r--	2008-01-09 09:16
manageLinks.php4	1.17 KB	-rw-r--r--	2008-01-09 09:16
manageLinksListing.php4	2.62 KB	-rw-r--r--	2008-01-09 09:20
membersearch.php	15.46 KB	-rw-r--r--	2009-05-15 13:23
membersearch.phtml	15.45 KB	-rw-r--r--	2009-03-02 09:59
next.jpg	491 B	-rw-r--r--	2008-01-09 09:16
notice.phtml	5.33 KB	-rw-r--r--	2008-01-09 09:20
null.php	1.39 KB	-rw-r--r--	2009-05-15 13:23
null.phtml	1.39 KB	-rw-r--r--	2008-01-09 09:20
previous.jpg	562 B	-rw-r--r--	2008-01-09 09:16
register.php	4.75 KB	-rw-r--r--	2009-05-25 13:52
register.phtml	4.75 KB	-rw-r--r--	2009-03-02 09:59
resetpw.php	2.31 KB	-rw-r--r--	2009-05-15 13:23
resetpw.phtml	2.3 KB	-rw-r--r--	2009-03-02 09:59
serverstats.php	59 B	-rw-r--r--	2009-05-15 13:23
serverstats.phtml	59 B	-rw-r--r--	2008-01-09 09:16
siteinfo.php	1.88 KB	-rw-r--r--	2009-05-15 13:23
siteinfo.phtml	1.88 KB	-rw-r--r--	2008-01-09 09:20
top20users.php	1.42 KB	-rw-r--r--	2009-05-15 13:23
top20users.phtml	1.42 KB	-rw-r--r--	2008-01-09 09:20
unregister.php	960 B	-rw-r--r--	2009-05-25 13:53
unregister.phtml	955 B	-rw-r--r--	2009-03-02 09:59
upload.htm	668 B	-rw-r--r--	2008-01-09 09:16
upload.php4	780 B	-rw-r--r--	2008-01-09 09:16
upload2.php4	583 B	-rw-r--r--	2008-01-09 09:16
username.php	2.06 KB	-rw-r--r--	2009-05-15 13:23
username.phtml	2.06 KB	-rw-r--r--	2009-03-02 09:59

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/conf.inc");
        mysql_connect("$server","$user","$pass") 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'];

$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");
		} else {
			//update it
			$ACCquery2 = "UPDATE MemberContacts SET
			ContactSurname = '$name3', 
			ContactInitials = '$name4', 
			ContactFirstName = '$name5', 
			Comments = '$name8', 
			ProfessionalRegistrations = '$name6', 
			Qualifications = '$name7', 
			ContactPosition = '$name9', 
			MandatedPrincipal = '$name11', 
			OfficeHead = '$name12', 
			Principal = '$name13', 
			Email = '$name10',
			IDNumber = '$name22',
			CellPhone = '$name23' WHERE ContactID = '$Prev_ContactsID'";
			$ACCresult = mysql_query($ACCquery2) or die("update failed");
		}
	} else {
		// New record
		//Check if the record should be deleted
		
		if ($es['ContactID'] != 1) {
			// 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) VALUES (0, '$name3', '$name4', '$name5', '$name17', '$name8', '$name6', '$name7',
				'$Prev_OfficeID', '$name9', '$name11', '$name12', '$name13', '$name10', '$name19',
				'$name20', '$name21', '$name16', '$name22', '$name23')";
			$ACCresult2 = mysql_query($ACCquery2) or die("update failed");
			
			// Get new ContactsID
			$query = "SELECT MAX(ContactsID) FROM OfficeContacts WHERE OfficeID='$Prev_OfficeID'";
			$result = mysql_query($query) or die("Scope_Identity Failed");
		    	$row = mysql_fetch_array($result);
			$NewContactsID = $row[0];
			
/*
			$ACCquery2 = "INSERT INTO Contacts (ContactSurname, ContactInitials, ContactFirstName, 
				ContactDesignation, Comments, ProfessionalRegistrations, Qualifications, 
				PreferredEmail) VALUES ('$name3', '$name4', '$name5', '$name17', '$name8', '$name6', '$name7', '$name10')";
			$ACCresult2 = mysql_query($ACCquery2) or die("update failed");
			
			// Get new ContactsID
			$query = "SELECT SCOPE_IDENTITY() AS [SCOPE_IDENTITY]";
			$result = mysql_query($query) or die("Scope_Identity Failed");
		    	$row = mysql_fetch_array($result);
			$NewContactsID = $row[0];
			
			$ACCquery = "INSERT INTO OfficeContacts (ContactsID, OfficeID, ContactPosition, MandatedPrincipal, 
				OfficeHead, Principal, Email, Mail, OfficeLiaison, OfficeLiaisonB, 
				SchoolMail) VALUES ('$NewContactsID', '$Prev_OfficeID', '$name9', '$name11', '$name12', '$name13', '$name10', '$name19',
				'$name20', '$name21', '$name16')";
			$ACCresult = mysql_query($ACCquery) or die("update failed");
*/
			$ACCquery = "UPDATE ADec_OfficeContacts Set Prev_ContactsID='$NewContactsID' WHERE ContactsID='$ContactsID'";
			$ACCresult = mysql_query($ACCquery) or die("update failed");

$ACCquery = "UPDATE ADec_Contacts Set Prev_ContactsID='$NewContactsID' WHERE ContactsID='$ContactsID'";
			$ACCresult = mysql_query($ACCquery) or die("update failed");
			
			$Prev_ContactsID = $NewContactsID;
		}
	}

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

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

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

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

$Zquery = "SELECT ContactsID, ContactSurname, ContactInitials, ContactFirstName, ProfessionalRegistrations, Qualifications, Comments, PreferredEmail, CellPhone, IDNumber FROM Contacts WHERE ContactsID = '$Prev_ContactsID'";
$Zresult = mysql_query($Zquery) or die("Select of id Failed");
$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'";
	 $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="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 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=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); 
				 }
				 
				 ?>
 </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=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); 
				 }
				 
				 ?>
 </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>