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">
</head>

<body bgcolor="#FFFFFF" text="#000000">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr> 
    <td bgcolor="#CCCCCC"> 
      <?php include( 'inc/menu.inc' ); ?>
    </td>
  </tr>
  <tr> 
    <td>
      <h3><font face="sans-serif" color="#666666">Display Records:</font><font face="sans-serif"> 
        Fix table problems</font></h3>
		
      <p> 
        <?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");

// Menu items:
echo "A ] Surname Problem ";

echo "<p>";

// Fix the problem where the CONTACTS surname, name info was not captured.
		
//        $query = "SELECT ContactsID, Prev_ContactsID, ContactSurname FROM ADec_Contacts WHERE ContactSurname = '' ORDER BY ContactsID ASC";
//	    $result = mysql_query($query) or die("Select of id Failed");
//		while ($ps = mysql_fetch_array($result))
//		{
//		$Id = $ps['ContactsID'];
//		$Id2 = $ps['Prev_ContactsID'];
//        $query2 = "SELECT * FROM Contacts WHERE ContactsID = '$Id2'";
//	    $result2 = mysql_query($query2) or die("Select of id Failed");
//		$OCrow = mysql_fetch_array($result2);
//       $ocs[0] = $OCrow['ContactsID'];
//	    $ocs[1] = $OCrow['ContactSurname'];
//   	$ocs[3] = $OCrow['ContactFirstName'];
//	    $ocs[4] = $OCrow['ContactDesignation'];

//		echo "Id: ".$Id." prev id: ".$Id2." and Surname: ".$ocs[1]."</br>";
//        $query3 = "UPDATE ADec_Contacts SET ContactSurname = '$ocs[1]', ContactFirstName = '$ocs[3]', ContactDesignation = '$ocs[4]' WHERE ContactsID = '$Id'";
//	    $result3 = mysql_query($query3) or die("Select of id Failed");
		
		
//		}

// Show all records from contacts and office contacts that correspond
		
//        $query = "SELECT ContactsID FROM ADec_Contacts ORDER BY ContactsID ASC";
//	    $result = mysql_query($query) or die("Select of id Failed");
//		while ($ps = mysql_fetch_array($result))
//		{
//		$Id = $ps['ContactsID'];
//      $query2 = "SELECT ContactsID, OfficeID, Prev_OfficeID FROM ADec_OfficeContacts WHERE ContactsID = '$Id' ORDER BY ContactsID ASC";
//	    $result2 = mysql_query($query2) or die("Select of id Failed");
//		$ps2 = mysql_fetch_array($result2);
//		if ($ps2)
//		{
//		echo "The id: ".$Id."<br>";
//		}
//		else
//		{
//		echo "****DELETED***** ID:".$Id."<br>";
//        $sq44 = "DELETE FROM ADec_Contacts WHERE ContactsID = '$Id'";
//        $result44 = mysql_query($sq44) or die("Select of id Failed");
//		}
//		}
		
		// ** ADEC_TBLMEMBERFIRMS
		// **********************

// Show all Contacts where there is no corresponding office . People who only did the annual declaration form
		
//		  $query = "SELECT ContactsID, OfficeID, Prev_OfficeID FROM ADec_OfficeContacts WHERE OfficeId = '0' ORDER BY ContactsID ASC";
//	      $result = mysql_query($query) or die("Select of id Failed");
//		  while ($ps = mysql_fetch_array($result))
//		  {
//		  $Id = $ps['ContactsID'];
//		  $Prev_OfficeID2 = $ps['Prev_OfficeID'];
//		  $query2 = "SELECT OfficeID, Prev_OfficeID, FirmID FROM ADec_tblMemberFirmOffices WHERE Prev_OfficeID = '$Prev_OfficeID2'";
//	      $result2 = mysql_query($query2) or die("Select of id Failed");
//		  $Ds = mysql_fetch_array($result2);
//		  $OfficeID2 = $Ds['OfficeID'];
//		  echo "The Field ".$Id." Prev Office : ".$PrevOfficeID2." New Office: ".$OfficeID2."</br>";
		  
		  
//		  $sql = "UPDATE ADec_OfficeContacts SET OfficeID = '$OfficeID2' WHERE ContactsID = '$Id'";
//		  $result3 = mysql_query($sql) or die("Update of id Failed");
		  
//		  }

// Show all Contacts where there is no corresponding office . People who only did the annual declaration form
		
//		  $query = "SELECT ContactsID, OfficeID, Prev_OfficeID FROM ADec_OfficeContacts WHERE OfficeId = '0' ORDER BY ContactsID ASC";
//	      $result = mysql_query($query) or die("Select of id Failed");
//		  while ($ps = mysql_fetch_array($result))
//		  {
//		  $Id = $ps['ContactsID'];
//		  $Prev_OfficeID2 = $ps['Prev_OfficeID'];
//		  $query2 = "SELECT OfficeID, FirmID, OfficeName, Country FROM tblMemberFirmOffices WHERE OfficeID = '$Prev_OfficeID2'";
//	      $result2 = mysql_query($query2) or die("Select of id Failed");
//		  $Ds = mysql_fetch_array($result2);
//		  $OfficeID2 = $Ds['OfficeID'];
//		  $FName = $Ds['OfficeName'];
//		  $FId = $Ds['FirmID'];
//		  $County = $Ds['Country'];
//		  $query3 = "SELECT OfficeID, Prev_FirmID, OfficeName FROM ADec_tblMemberFirmOffices WHERE Prev_FirmID = '$FId'";
//	      $result3 = mysql_query($query3) or die("Select of id Failed");
//		  $Es = mysql_fetch_array($result3);
//		  $RealOffice = $Es['OfficeID'];
		  
//		  echo "The Field ".$Id.",   Office: ".$FName."   Firmid: ".$FId."  Office Id: ".$RealOffice."</br>";
//		  
//		  
//		  $sql = "UPDATE ADec_OfficeContacts SET OfficeID = '$RealOffice' WHERE ContactsID = '$Id'";
//		  $result3 = mysql_query($sql) or die("Update of id Failed");
		  
//		  }

// section to delete records not wanted..

if ($action == "yes")
{
//		  $sql2 = "DELETE FROM ADec_OfficeContacts WHERE ContactsID = '$form[id1]' AND OfficeID = '$form[id2]'";
//		  $sql2 = "DELETE FROM ADec_OfficeContacts WHERE ContactsID = '$form[id1]' AND OfficeID = '$form[id2]'";
// 		  $sql2 = "DELETE FROM ADec_OfficeContacts WHERE ContactsID = '$form[id1]' AND OfficeID = '$form[id2]'";
		  $sql2 = "DELETE FROM ADec_tblMemberFirms WHERE FirmID = '$form[id1]'";				  
		  $result4 = mysql_query($sql2) or die("Select of id Failed");
		  echo "Record ID: ".$form[id1]." and ".$form[id2]." was deleted.</br>";

// $sql2 = "DELETE FROM ADec_tblMemberFirms WHERE FirmID = '$form[id1]'";
//		  $result4 = mysql_query($sql2) or die("Select of id Failed");
//		  echo "Record ID: ".$form[id1]." and ".$form[id2]." was deleted.</br>";

}
      echo $form[id1].$form[id2];
?>
        here you put the shit in.
      <p>
	  <FORM ACTION="<?php echo $scriptname; ?>?action=yes" METHOD="POST">
      <table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr> 
          <td>ID</td>
          <td> 
            <input type="text" name="form[id1]">
          </td>
        </tr>
        <tr> 
          <td>Office Id</td>
          <td> 
            <input type="text" name="form[id2]">
          </td>
        </tr>
        <tr>
          <td>&nbsp;</td>
          <td>
            <input type="submit" name="Submit" value="Submit">
          </td>
        </tr>
      </table>
	  </form>
	  <p>Check out the remaining shit.. </p>

<p> 
        <?php
//          $query = "SELECT ContactsID, OfficeID, Prev_OfficeID FROM ADec_OfficeContacts ORDER BY ContactsID ASC"; 
//          $result = mysql_query($query) or die("Select of id Failed");
//		  while ($ps = mysql_fetch_array($result))
//		  {
//		  $counted = 0;
//		  $Id = $ps['ContactsID'];
//        $query2 = "SELECT ContactsID, OfficeID, Prev_OfficeID FROM ADec_OfficeContacts WHERE ContactsID = '$Id' ORDER BY ContactsId ASC"; 
//          $result2 = mysql_query($query2) or die("Select of id Failed");
//		  while ($ps2 = mysql_fetch_array($result2))
//		  {
//		  $counted = $counted + 1;
//		  if ($counted > 1) 
//		  {
//		  echo $Id." occurs ".$counted." times</br>";
//		  }
//		  }
//		  }
 		?>
      <table width="100%" border="1" cellspacing="0" cellpadding="0">
        <tr bordercolor="#000000"> 
          <td colspan="2"> 
            <div align="center"><b>Old</b></div>
          </td>
          <td colspan="2"> 
            <div align="center"><b>New</b></div>
          </td>
        </tr>
        <tr bordercolor="#000000"> 
          <td width="11%"> 
            <div align="center"><b><font color="#0000FF">Firm</font></b></div>
          </td>
          <td width="33%"> 
            <div align="center"> 
              <?php
			$queryA = "SELECT FirmID FROM tblMemberFirms WHERE FirmName = 'SAACE' ORDER BY FirmID ASC"; 
            $resultA = mysql_query($queryA) or die("Select of id Failed");
			while ($firmsinfo = mysql_fetch_array($resultA))
			{
			$firmid = $firmsinfo['FirmID'];
			echo "Firm Id is: ".$firmsinfo['FirmID'];
			}
			?>
            </div>
          </td>
          <td width="17%"> 
            <div align="center"><b><font color="#0000FF">Firm</font></b></div>
          </td>
          <td width="39%"> 
            <div align="center"> 
              <?php
			$queryA2 = "SELECT FirmID FROM ADec_tblMemberFirms WHERE FirmName = 'SAACE' ORDER BY FirmID ASC"; 
            $resultA2 = mysql_query($queryA2) or die("Select of id Failed");
			while ($firmsinfo2 = mysql_fetch_array($resultA2))
			{
			$firmid2 = $firmsinfo2['FirmID'];
			echo "<font color=red>Firm Id is: </font>".$firmsinfo2['FirmID'];
			}
			?>
            </div>
          </td>
        </tr>
        <tr bordercolor="#000000"> 
          <td width="11%"> 
            <div align="center"><b><font color="#0000FF">Office</font></b></div>
          </td>
          <td width="33%"> 
            <div align="center"> 
              <?php
			$queryB = "SELECT FirmID, OfficeID FROM tblMemberFirmOffices WHERE FirmID = '$firmid' ORDER BY FirmID ASC"; 
            $resultB = mysql_query($queryB) or die("Select of id Failed");
			while ($officeinfo = mysql_fetch_array($resultB))
			{
			$officeid = $officeinfo['OfficeID'];
			echo "Office ID is: ".$officeinfo['OfficeID']."<br>";
			}
			?>
            </div>
          </td>
          <td width="17%"> 
            <div align="center"><b><font color="#0000FF">Office</font></b></div>
          </td>
          <td width="39%"> 
            <div align="center"> 
              <?php
			$queryB2 = "SELECT FirmID, OfficeID FROM ADec_tblMemberFirmOffices WHERE FirmID = '$firmid2' ORDER BY FirmID ASC"; 
            $resultB2 = mysql_query($queryB2) or die("Select of id Failed");
			while ($officeinfo2 = mysql_fetch_array($resultB2))
			{
			$officeid2 = $officeinfo2['OfficeID'];
			echo "<font color=red>Office Id is: </font>".$officeinfo2['OfficeID']."<br>";
			}
			?>
            </div>
          </td>
        </tr>
        <tr bordercolor="#000000"> 
          <td width="11%"> 
            <div align="center"><b><font color="#0000FF">Office Contacts</font></b></div>
          </td>
          <td width="33%"> 
            <div align="center"> 
              <?php
			$queryC = "SELECT * FROM OfficeContacts WHERE OfficeID = '$officeid' ORDER BY ContactsID ASC"; 
            $resultC = mysql_query($queryC) or die("Select of id Failed");
			while ($contactsinfo = mysql_fetch_array($resultC))
			{
			echo "Contacts ID is: ".$contactsinfo['ContactsID']."<br>";
			}
			?>
            </div>
          </td>
          <td width="17%"> 
            <div align="center"><b><font color="#0000FF">Office Contacts</font></b></div>
          </td>
          <td width="39%"> 
            <div align="center"> 
              <?php
			$queryC2 = "SELECT * FROM ADec_OfficeContacts WHERE OfficeID = '$officeid2' ORDER BY ContactsID ASC"; 
            $resultC2 = mysql_query($queryC2) or die("Select of id Failed");
			while ($contactsinfo2 = mysql_fetch_array($resultC2))
			{
			echo "<font color=red>Contacts Id is: </font>".$contactsinfo2['ContactsID']."<br>";
			}
			?>
            </div>
          </td>
        </tr>
        <tr bordercolor="#000000"> 
          <td width="11%" height="19">
            <div align="center"><b><font color="#0000FF">Contacts</font></b></div>
          </td>
          <td width="33%" height="19">&nbsp;</td>
          <td width="17%" height="19">
            <div align="center"><b><font color="#0000FF">Contacts</font></b></div>
          </td>
          <td width="39%" height="19">
		  <?php
			$queryC3 = "SELECT * FROM ADec_Contacts WHERE ContactsID = '618'"; 
            $resultC3 = mysql_query($queryC3) or die("Select of id Failed");
			$contactsinfo3 = mysql_fetch_array($resultC3);
			echo "<font color=red>Contacts Id is: </font>".$contactsinfo3['ContactsID']."<br>";
		  ?>
		  </td>
        </tr>
        <tr bordercolor="#000000"> 
          <td width="11%" height="19">&nbsp;</td>
          <td width="33%" height="19">&nbsp;</td>
          <td width="17%" height="19"> 
            <div align="center"><font color="#FF0000"><b>Like</b></font></div>
          </td>
          <td width="39%" height="19"> 
            <div align="center"> 
              <?php
			$queryD2 = "SELECT * FROM ADec_OfficeContacts WHERE Email LIKE '%saace%' ORDER BY ContactsID ASC"; 
            $resultD2 = mysql_query($queryD2) or die("Select of id Failed");
			while ($like2 = mysql_fetch_array($resultD2))
			{
			echo "<font color=red>Contacts Id is: </font>".$like2['ContactsID']."Prev_ContactsID :".$like2['Prev_ContactsID']."OfficeID :".$like2['OfficeID']."<br>";
			}
			?>
            </div>
          </td>
        </tr>
        <tr bordercolor="#000000"> 
          <td width="11%" height="19">&nbsp;</td>
          <td width="33%" height="19">&nbsp;</td>
          <td width="17%" height="19">&nbsp;</td>
          <td width="39%" height="19">&nbsp;</td>
        </tr>
        <tr bordercolor="#000000"> 
          <td width="11%" height="19">&nbsp;</td>
          <td width="33%" height="19">&nbsp;</td>
          <td width="17%" height="19">&nbsp;</td>
          <td width="39%" height="19"> 
            <?php
			$del1 = "DELETE FROM ADec_Contacts WHERE ContactsID = '624'"; 
			$del2 = "DELETE FROM ADec_Contacts WHERE ContactsID = '625'"; 
			$del3 = "DELETE FROM ADec_Contacts WHERE ContactsID = '626'"; 
			$del4 = "DELETE FROM ADec_OfficeContacts WHERE ContactsID = '624'"; 
			$del5 = "DELETE FROM ADec_OfficeContacts WHERE ContactsID = '625'"; 
			$del6 = "DELETE FROM ADec_OfficeContacts WHERE ContactsID = '626'"; 
			$del7 = "DELETE FROM ADec_tblMemberFirmOffices WHERE OfficeID = '182'"; 
			$del8 = "DELETE FROM ADec_tblMemberFirms WHERE FirmID = '96'"; 
            $resultdel1 = mysql_query($del1) or die("Select of id Failed");
            $resultdel2 = mysql_query($del2) or die("Select of id Failed");
            $resultdel3 = mysql_query($del3) or die("Select of id Failed");
            $resultdel4 = mysql_query($del4) or die("Select of id Failed");
            $resultdel5 = mysql_query($del5) or die("Select of id Failed");
            $resultdel6 = mysql_query($del6) or die("Select of id Failed");
            $resultdel7 = mysql_query($del7) or die("Select of id Failed");
            $resultdel8 = mysql_query($del8) or die("Select of id Failed");
			echo "Result :".$resultdel1;
			echo "Result :".$resultdel2;
			echo "Result :".$resultdel3;
			echo "Result :".$resultdel4;
			echo "Result :".$resultdel5;
			echo "Result :".$resultdel6;
			echo "Result :".$resultdel7;
			echo "Result :".$resultdel8;
		  ?>
          </td>
        </tr>
      </table>
      <p>
	  <?php
//	  $sqlE = "UPDATE ADec_OfficeContacts SET OfficeID = '179' WHERE ContactsID = '616'";
//	  $resultE = mysql_query($sqlE) or die("Update of id Failed");
	  ?>
	  </p>
    </td>
  </tr>
  <tr>
    <td bgcolor="#CCCCCC"><?php include( 'inc/footer.inc' ); ?></td>
  </tr>
</table>
</body>
</html>