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">
</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
		$scriptname = "ADfixDisplayTable.php4";
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");

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