function AddCustomFields() { global $Email_Address, $Responder_ID; global $FirstName, $LastName, $DB_LinkID, $table_prefix; $infrespcustomfields = $table_prefix . 'InfResp_customfields'; $CustomFieldsArray = GetFieldNames($infrespcustomfields); $CustomFieldsExist = FALSE; foreach ($CustomFieldsArray as $key => $value) { $blah = "cf_" . $value; $reqblah = trim($_REQUEST[$blah]); if (!empty($reqblah)) { $CustomFieldsArray[$value] = MakeSafe($reqblah); $CustomFieldsExist = TRUE; } } # Any custom fields? if ($CustomFieldsExist == TRUE) { #------------- Mandatory fields checking ------------------ # if (empty($CustomFieldsArray['blah'])) { die('Error Message'); } #---------------------------------------------------------- # --- Custom code --- $Fullname = "{$FirstName} {$LastName}"; $CustomFieldsArray['full_name'] = $Fullname; # ------------------- # Set static data $CustomFieldsArray['email_attached'] = $Email_Address; $CustomFieldsArray['resp_attached'] = $Responder_ID; unset($CustomFieldsArray['fieldID']); unset($CustomFieldsArray['user_attached']); # Delete any old data $query = "SELECT * FROM " . $infrespcustomfields . " WHERE email_attached = '{$Email_Address}' AND resp_attached = '{$Responder_ID}'"; $result = mysql_query($query) or die("Invalid query: " . mysql_error()); if (mysql_num_rows($result) > 0) { $query = "DELETE FROM " . $infrespcustomfields . " WHERE email_attached = '{$Email_Address}' AND resp_attached = '{$Responder_ID}'"; $result = mysql_query($query) or die("Invalid query: " . mysql_error()); } # Insert new data DB_Insert_Array($infrespcustomfields, $CustomFieldsArray); } }
print "</FORM>\n"; } else { print "<br>\nNo custom data found.<br>\n"; } # Print back button $return_action = "update"; include 'templates/back_button.responders.php'; } elseif ($action == "custom_stuff_csv") { $filename = time(); header("Content-Disposition: attachment; filename={$filename}.csv"); header("Content-Type: application/octet-stream"); header("Pragma: no-cache"); header("Expires: 0"); $query = "SELECT * FROM " . $infrespcustomfields . " WHERE resp_attached = '{$Responder_ID}'"; $DB_result = mysql_query($query) or die("Invalid query: " . mysql_error()); $CustomFieldsArray = GetFieldNames($infrespcustomfields); $fieldstr = ""; foreach ($CustomFieldsArray as $key => $value) { $fieldstr .= "{$value},"; } $fieldstr = trim(trim($fieldstr), ","); print "{$fieldstr}\n"; while ($DBarray = mysql_fetch_assoc($DB_result)) { $datastr = ""; foreach ($CustomFieldsArray as $key => $value) { $datastr .= $DBarray[$value] . ","; } $datastr = trim(trim($datastr), ","); print "{$datastr}\n"; } } elseif ($action == "do_POP3") {