It should be:
<?php
if (!isset($_SESSION)) {
session_start();
}
?>
<?php require_once('Connections/members.php'); ?>
<?php require_once( "WA_SecurityAssist/Helper_PHP.php" );
?>
<?php require_once("WA_DataAssist/WA_AppBuilder_PHP.php"); ?>
<?php require_once("WA_DigitalFilePro/HelperPHP.php"); ?>
<?php
if (!WA_Auth_RulePasses("Logged in to members")){
WA_Auth_RestrictAccess("members_LogIn.php?notLogged=true");
}
?>
<?php
WA_DFP_SetupUploadStatusStruct("WA_UploadResult1");
if(isset($_POST["Update_x"])){
WA_DFP_UploadFile("WA_UploadResult1", "pictureFile", "".((isset($_POST["picture"]))?$_POST["picture"]:"") ."", "images/members/", "[FileName]", "2", "[FileName]_[Increment]", "0", "true", "125", "0");
}?>
<?php
// WA Application Builder Update
if ($_SERVER["REQUEST_METHOD"] == "POST") // Trigger
{
$WA_connection = $members;
$WA_table = "members";
$WA_redirectURL = "members_Profile.php";
$WA_keepQueryString = false;
$WA_indexField = "UserID";
$WA_fieldNamesStr = "userName|password|lastName|firstName|member_status|company|title|address|city|province_state|pc_zip|telephone|fax|cell_phone|url|business_category|picture|committee_ID|committee_2_ID";
$WA_fieldValuesStr = "".((isset($_POST["userName"]))?$_POST["userName"]:"") ."" . "|" . "".((isset($_POST["password"]))?$_POST["password"]:"") ."" . "|" . "".((isset($_POST["lastName"]))?$_POST["lastName"]:"") ."" . "|" . "".((isset($_POST["firstName"]))?$_POST["firstName"]:"") ."" . "|" . "".((isset($_POST["member_status"]))?$_POST["member_status"]:"") ."" . "|" . "".((isset($_POST["company"]))?$_POST["company"]:"") ."" . "|" . "".((isset($_POST["title"]))?$_POST["title"]:"") ."" . "|" . "".((isset($_POST["address"]))?$_POST["address"]:"") ."" . "|" . "".((isset($_POST["city"]))?$_POST["city"]:"") ."" . "|" . "".((isset($_POST["province_state"]))?$_POST["province_state"]:"") ."" . "|" . "".((isset($_POST["pc_zip"]))?$_POST["pc_zip"]:"") ."" . "|" . "".((isset($_POST["telephone"]))?$_POST["telephone"]:"") ."" . "|" . "".((isset($_POST["fax"]))?$_POST["fax"]:"") ."" . "|" . "".((isset($_POST["cell_phone"]))?$_POST["cell_phone"]:"") ."" . "|" . "".((isset($_POST["url"]))?$_POST["url"]:"") ."" . "|" . "".((isset($_POST["business_category"]))?$_POST["business_category"]:"") ."" . "|" . "".$WA_DFP_UploadStatus["WA_UploadResult1"]["serverFileName"] ."" . "|" . "".((isset($_POST["committee_ID"]))?$_POST["committee_ID"]:"") ."" . "|" . "".((isset($_POST["committee_2_ID"]))?$_POST["committee_2_ID"]:"") ."";
$WA_columnTypesStr = "',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|',none,''";
$WA_comparisonStr = "=|=|=|=|=|=|=|=|=|=|=|=|=|=|=|=|=|=|=";
$WA_fieldNames = explode("|", $WA_fieldNamesStr);
$WA_fieldValues = explode("|", $WA_fieldValuesStr);
$WA_columns = explode("|", $WA_columnTypesStr);
$WA_where_fieldValuesStr = "".$row_WAATKmembers['UserID'] ."";
$WA_where_columnTypesStr = "none,none,NULL";
$WA_where_comparisonStr = "=";
$WA_where_fieldNames = explode("|", $WA_indexField);
$WA_where_fieldValues = explode("|", $WA_where_fieldValuesStr);
$WA_where_columns = explode("|", $WA_where_columnTypesStr);
$WA_where_comparisons = explode("|", $WA_where_comparisonStr);
$WA_connectionDB = $database_members;
mysql_select_db($WA_connectionDB, $WA_connection);
if (!session_id()) session_start();
$updateParamsObj = WA_AB_generateInsertParams($WA_fieldNames, $WA_columns, $WA_fieldValues, -1);
$WhereObj = WA_AB_generateWhereClause($WA_where_fieldNames, $WA_where_columns, $WA_where_fieldValues, $WA_where_comparisons );
$WA_Sql = "UPDATE `" . $WA_table . "` SET " . $updateParamsObj->WA_setValues . " WHERE " . $WhereObj->sqlWhereClause . "";
$MM_editCmd = mysql_query($WA_Sql, $WA_connection) or die(mysql_error());
if ($WA_redirectURL != "") {
if ($WA_keepQueryString && $WA_redirectURL != "" && isset($_SERVER["QUERY_STRING"]) && $_SERVER["QUERY_STRING"] !== "" && sizeof($_POST) > 0) {
$WA_redirectURL .= ((strpos($WA_redirectURL, '?') === false)?"?":"&").$_SERVER["QUERY_STRING"];
}
header("Location: ".$WA_redirectURL);
}
}
?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
if (PHP_VERSION < 6) {
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
}
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
?>
<?php
$ParamUserID_WAATKmembers = "-1";
if (isset($_SESSION['UserID'])) {
$ParamUserID_WAATKmembers = (get_magic_quotes_gpc()) ? $_SESSION['UserID'] : addslashes($_SESSION['UserID']);
}
mysql_select_db($database_members, $members);
$query_WAATKmembers = sprintf("SELECT * FROM members WHERE UserID = %s", $ParamUserID_WAATKmembers);
$WAATKmembers = mysql_query($query_WAATKmembers, $members) or die(mysql_error());
$row_WAATKmembers = mysql_fetch_assoc($WAATKmembers);
$totalRows_WAATKmembers = mysql_num_rows($WAATKmembers);
mysql_select_db($database_members, $members);
$query_rsPP = "SELECT * FROM yesno";
$rsPP = mysql_query($query_rsPP, $members) or die(mysql_error());
$row_rsPP = mysql_fetch_assoc($rsPP);
$totalRows_rsPP = mysql_num_rows($rsPP);
mysql_select_db($database_members, $members);
$query_rsProvince = "SELECT * FROM province_state";
$rsProvince = mysql_query($query_rsProvince, $members) or die(mysql_error());
$row_rsProvince = mysql_fetch_assoc($rsProvince);
$totalRows_rsProvince = mysql_num_rows($rsProvince);
mysql_select_db($database_members, $members);
$query_rsMemberStatus = "SELECT * FROM member_status";
$rsMemberStatus = mysql_query($query_rsMemberStatus, $members) or die(mysql_error());
$row_rsMemberStatus = mysql_fetch_assoc($rsMemberStatus);
$totalRows_rsMemberStatus = mysql_num_rows($rsMemberStatus);
mysql_select_db($database_members, $members);
$query_rsBusCat = "SELECT * FROM business_category";
$rsBusCat = mysql_query($query_rsBusCat, $members) or die(mysql_error());
$row_rsBusCat = mysql_fetch_assoc($rsBusCat);
$totalRows_rsBusCat = mysql_num_rows($rsBusCat);
mysql_select_db($database_members, $members);
$query_rsCommittees = "SELECT * FROM committee_names";
$rsCommittees = mysql_query($query_rsCommittees, $members) or die(mysql_error());
$row_rsCommittees = mysql_fetch_assoc($rsCommittees);
$totalRows_rsCommittees = mysql_num_rows($rsCommittees);?>