Gecko [ v3.cesa.co.za ]

Name	Size	Permission	Date
adobe.inc	107 B	-rw-r--r--	2008-01-09 07:51
auth.inc	3.52 KB	-rw-r--r--	2025-04-30 14:24
auth.inc.bak	1.12 KB	-rw-r--r--	2025-03-07 12:21
calendar.inc	5.46 KB	-rw-r--r--	2008-01-09 08:36
conf.inc	683 B	-rw-r--r--	2025-03-07 12:21
conf.inc.bak	690 B	-rw-r--r--	2025-03-07 12:21
confdec.inc	364 B	-rw-r--r--	2025-03-07 12:21
createadec.inc	175 B	-rw-r--r--	2008-01-09 07:51
db.inc	146 B	-rw-r--r--	2025-03-07 12:21
declaration.inc	19.69 KB	-rw-r--r--	2026-01-20 15:55
declaration_nav.php	4.76 KB	-rw-r--r--	2025-02-20 10:14
declaration_nav.php4	4.69 KB	-rw-r--r--	2008-01-09 08:36
declaration_nav_int.php	5.87 KB	-rw-r--r--	2021-02-24 09:22
declaration_nav_int.php4	5.96 KB	-rw-r--r--	2015-01-22 06:13
default.css	4.06 KB	-rw-r--r--	2008-01-09 07:51
dont-click.prefs.inc	3.38 KB	-rw-r--r--	2008-01-09 08:36
footer.inc	3.13 KB	-rw-r--r--	2025-05-19 11:13
footer2.inc	157 B	-rw-r--r--	2008-01-09 07:51
func.inc	3.36 KB	-rw-r--r--	2025-01-13 14:32
funcinternational.inc	2.66 KB	-rw-r--r--	2008-01-09 07:51
header.inc	4.12 KB	-rw-r--r--	2025-01-31 07:03
header2.inc	2.05 KB	-rw-r--r--	2008-01-09 08:36
internationalheader.inc	590 B	-rw-r--r--	2008-01-09 07:51
internationalmenu.inc	378 B	-rw-r--r--	2008-01-09 07:51
login_footer.inc	748 B	-rw-r--r--	2008-01-09 07:51
login_header.inc	1.43 KB	-rw-r--r--	2008-01-09 07:51
misc.inc	363 B	-rw-r--r--	2008-01-09 07:51
nav.inc	528 B	-rw-r--r--	2008-01-09 07:51
notice.inc	530 B	-rw-r--r--	2008-01-09 08:36
press.inc	1.53 KB	-rw-r--r--	2008-01-09 08:36
rc4cryptclass.inc	1.27 KB	-rw-r--r--	2008-01-09 07:51
readnext.inc	8.77 KB	-rw-r--r--	2025-03-07 12:21
readnext.inc.bak	6.8 KB	-rw-r--r--	2025-03-07 12:21
readnextold.inc	6.64 KB	-rw-r--r--	2025-03-07 12:21
sched1page2gen.inc	7.65 KB	-rw-r--r--	2025-07-18 08:31
submitcheck.inc	23.74 KB	-rw-r--r--	2025-07-18 09:41
submitcheck.inc.bak	6.28 KB	-rw-r--r--	2025-03-07 12:21
submitcheck2.inc	13.04 KB	-rw-r--r--	2025-07-18 07:32
submitcheck2_A.inc	18.75 KB	-rw-r--r--	2025-07-18 07:47
submitcheck2b.inc	11 KB	-rw-r--r--	2025-07-18 07:47
submitcheck2b_A.inc	14.9 KB	-rw-r--r--	2025-03-07 12:21
submitcheckA.inc	21.38 KB	-rw-r--r--	2025-07-18 07:20
submitcheckqmig.inc	1.35 KB	-rw-r--r--	2025-03-07 12:21
survey_footer.inc	2.35 KB	-rw-r--r--	2008-01-09 07:51
test.html	11.56 KB	-rw-r--r--	2008-01-09 07:51
viewcal.inc	2.33 KB	-rw-r--r--	2008-01-09 08:36
voting_class.inc	11.04 KB	-rw-r--r--	2025-03-07 12:21
work.inc	1.26 KB	-rw-r--r--	2008-01-09 08:36

Rename

<?php

// SECTION B ********************************************************
// ******************************************************************

include( '../inc/conf.inc' );

if ($section == "B") {
    // SECTION B
    // Perform the INSERT of the data to the correct fields in the new tables
    // Set action to yes and complete the document.
    // Test first to see if the information exists.
    // **************************************************************************
    if (!($link = mysql_connect("$host", "$user", "$password"))) {
        throw new Exception("Unable to connect to SQL server");
    }
    if (!($result = mysql_select_db("$db"))) {
        throw new Exception("Unable to select database");
    }
    $query10 = "SELECT * FROM ADec_OfficeContacts WHERE Prev_OfficeID = '$SelectOfficeID' AND DeclarationYear = $DeclarationYear";
    if (!($result10 = mysql_query($query10))) {
        throw new Exception("Select of id Failed: " . $query10);
    }
    if (mysql_fetch_array($result10)) {
        $messages = "You have completed Section A. Please complete the fields and SUBMIT.";
    } else {
        $query5 = "SELECT ADec_tblMemberFirmOffices.OfficeID, ADec_tblMemberFirmOffices.Prev_OfficeID FROM ADec_tblMemberFirmOffices "
                . "WHERE ADec_tblMemberFirmOffices.Prev_OfficeID = '$SelectOfficeID' AND DeclarationYear = $DeclarationYear";
        if (!($result5 = mysql_query($query5))) {
            throw new Exception("Select of id Failed: " . $query5);
        }
        $rq = mysql_fetch_array($result5);
        $Qofficeid = $rq['OfficeID'];
        
        $query = "SELECT * FROM OfficeContacts WHERE OfficeContacts.OfficeID = '$SelectOfficeID'";
        if (!($result = mysql_query($query))) {
            throw new Exception("Select of id Failed: " . $query);
        }

// write the content of the old records to the new records
        while ($rs = mysql_fetch_array($result)) {
            $Ctherightid = $rs[0];
            $Cposition = $rs[1];
            $Cprevid = $rs[4];
            $Cprincipal = $rs[5];
            // Get the relevant details to display  
            $query2 = "SELECT  * FROM Contacts WHERE Contacts.ContactsID = '$therightid'";
            if (!($result2 = mysql_query($query2))) {
                throw new Exception("Select of id Failed: " . $query2);
            }
            $ps = mysql_fetch_array($result2);
            $Cid = $ps[0];
            $Csurname = $ps[1];
            $Cinitial = $ps[2];
            $Cfirstname = $ps[3];
            $Cpreffreg = $ps[13];
            $Cqual = $ps[14];
            $Ccomments = $ps[12];
            $Cemail = $ps[16];
            
            $query4 = "INSERT INTO ADec_Contacts (Prev_ContactsID,
			 ContactSurname,
			 ContactInitials,
			 ContactFirstName,
			 ProfessionalRegistrations,
			 Qualifications,
			 Comments,
			 PreferredEmail, DeclarationYear)
			 values('$Cid',
			 '$Csurname',
			 '$Cinitial',
			 '$Cfirstname',
			 '$Cpreffreg',
			 '$Cqual',
			 '$Ccomments',
			 '$Cemail', $DeclarationYear)";
            if (!($result4 = mysql_query($query4))) {
                throw new Exception("Insert Failed into ADec_Contacts in sched1page2gen.inc: " . $query4);
            }
            $query6 = "SELECT  * FROM ADec_Contacts WHERE ADec_Contacts.Prev_ContactsID = '$Cid' AND DeclarationYear = $DeclarationYear";
            if (!($result6 = mysql_query($query6))) {
                throw new Exception("Select of id Failed: " . $query6);
            }
            $ts = mysql_fetch_array($result6);
            $newidthingy = $ts[0];
            $query3 = "INSERT INTO ADec_OfficeContacts (ContactsID,
			 Prev_ContactsID,
			 ContactPosition,
			 OfficeID,
			 Prev_OfficeId, DeclarationYear)
			 values('$newidthingy',
			 '$Ctherightid',
			 '$Cposition',
			 '$Qofficeid',
			 '$Cprevid', $DeclarationYear)";
            if (!($result3 = mysql_query($query3))) {
                throw new Exception("Insert Failed into ADec_OfficeContacts in sched1page2gen.inc: " . $query3);
            }
        }
    }
    // *************************** END **********************************
    // ******************************************************************
    // SECTION  D ********************************************************
    // ******************************************************************
    if ($section == "D") {
        $messages = "You have completed the document. Please close the window and return to the Controll Page. ";
        $showbutton = "no";
        
        $query9 = "UPDATE ADec_tblMemberFirmOffices SET ProfessionalStaff = '$form[proff]', NonProfTechStaff = '$form[nonprof]', OtherStaff = '$form[other]', DeclarationYear = $DeclarationYear "
                . "WHERE OfficeID = '$Qofficeid'";
        if (!($result = mysql_query($query9))) {
            throw new Exception("Select of id Failed: " . $query9);
        }
    }
    // *************************** END **********************************
    // ******************************************************************
    // SECTION E ********************************************************
    // ******************************************************************
    if ($section == "E") {
        $query = "SELECT * FROM OfficeContacts WHERE OfficeContacts.OfficeID = '$SelectOfficeID'";
        if (!($result = mysql_query($query))) {
            throw new Exception("Select of id Failed: " . $query);
        }
        $rs = mysql_fetch_array($result);
        $therightid = $rs[0];
        if ($rs[5] == 0) {
            $selected1 = "selected";
            $selected2 = "";
        } else {
            $selected1 = "";
            $selected2 = "selected";
        }
        
        $query2 = "SELECT  * FROM Contacts WHERE Contacts.ContactsID = '$therightid'";
        if (!($result2 = mysql_query($query2))) {
            throw new Exception("Select of id Failed: " . $query2);
        }
        $ps = mysql_fetch_array($result2);
        $messages = "Please edit the fields you want to change and SUBMIT.";
    }
    // *************************** END **********************************
    // ******************************************************************
    // SECTION X ********************************************************
    // ******************************************************************
    if ($section == "X") {
        // UPDATE Office Contacts.
        if ($form[principal] == "No") {
            $Oprincipal = 0;
        } else {
            $Oprincipal = 1;
        }
        $query = "UPDATE OfficeContacts SET ContactPosition = '$form[pos]',
			Principal = '$Oprincipal' WHERE OfficeContacts.ContactsID = '$therightid'";
        if (!($result = mysql_query($query))) {
            throw new Exception("Update OfficeContacts in sched1page2gen.inc: " . $query);
        }

// UPDATE Contacts.
        
        $query2 = "UPDATE Contacts SET Contacts.ContactSurname = '$form[surname]',
			Contacts.ContactInitials = '$form[initials]',
			Contacts.ContactFirstName = '$form[alsoknown]',
			Contacts.ProfessionalRegistrations = '$form[proffreg]',
			Contacts.Qualifications = '$form[qual]',
			Contacts.Comments = '$form[fields]', Contacts.PreferredEmail = '$form[email]'
			WHERE Contacts.ContactsID = '$therightid'";
        if (!($result2 = mysql_query($query2))) {
            throw new Exception("Update Contacts in sched1page2gen.inc: " . $query2);
        }
        $section = "A";
    }
    // *************************** END **********************************
    // ******************************************************************