session_start();
$libdir = '/var/www/html/new/lib/';
include($libdir.'settings.php');
require($libdir.'proclib.php');
include($libdir.'head.php');
include($libdir.'datacon.php');
/*
echo '
';
print_r($_POST);
print_r($_GET);
print_r($_REQUEST);
echo '
';
*/
$set = $HTTP_POST_VARS['set'];
$file = $HTTP_POST_VARS['file'];
$platform = $HTTP_POST_VARS['platform'];
$other = $HTTP_POST_VARS['other'];
$output = $HTTP_POST_VARS['output'];
$stats = $HTTP_POST_VARS['stats'];
$geo = $HTTP_POST_VARS['geo'];
$program = $HTTP_POST_VARS['program'];
$size = $HTTP_POST_VARS['size'];
$criteria = $HTTP_POST_VARS['criteria'];
$purpose = $HTTP_POST_VARS['purpose'];
$idAuto = $HTTP_POST_VARS['idAuto'];
$set = addslashes($set);
$file = addslashes($file);
$platform = addslashes( $platform);
$other = addslashes($other);
$output = addslashes($output);
$stats = addslashes($stats);
$geo = addslashes($geo);
$program = addslashes($program);
$size = addslashes($size);
$criteria = addslashes($criteria);
$purpose = addslashes($purpose);
$notes = "\nData request:\nData set: $set\nData file: $file\nComputer platform: $platform\nOther: $other\nOutput format: $output\nStatistical software version: $stats\nGeographical criteria: $geo\nType of program criteria: $program\nSize criteria: $size\nOther criteria: $criteria\nPurpose for research: $purpose\n";
echo "ID: $idAuto
\n";
if (strlen($idAuto) < 1 ){
echo "Error processing request. No ID specified. Please email communityplatformNOREPLY@urban.org.
";
}
// $idAutoResult = MYSQL_QUERY("select max(idAuto) as idAuto from sp_users");
// $idAuto = mysql_result($idAutoResult,0,"idAuto");
$query="update admin.sp_users set notes = concat_ws('',notes,'$notes') where idAuto=$idAuto";
$result = MYSQL_QUERY($query);
if ( ! $result ){
echo "Problem updating information:
$query
The system administrator has been automatically notified.";
mail("communityplatformNOREPLY@urban.org","Data request Problem","Problem retrieving information:\n$query\n","From: nccsdataweb@urban.org\r\n");
} else {
$qry2 = "select * from admin.sp_users where idAuto=$idAuto";
$fieldResult = MYSQL_QUERY($qry2);
if ( ! $fieldResult ){
mail("communityplatformNOREPLY@urban.org","Data request Problem","Problem retrieving information:\n$qry2\n","From: nccsdataweb@urban.org\r\n");
echo "Problem retrieving information:
$qry2
The system administrator has been automatically notified.";
} else {
$email = mysql_result($fieldResult,0,"email");
$fname = mysql_result($fieldResult,0,"fname");
$lname = mysql_result($fieldResult,0,"lname");
$title = mysql_result($fieldResult,0,"title");
$org = mysql_result($fieldResult,0,"org");
$OrgType = mysql_result($fieldResult,0,"OrgType");
$address = mysql_result($fieldResult,0,"address");
$city = mysql_result($fieldResult,0,"city");
$state = mysql_result($fieldResult,0,"state");
$zip = mysql_result($fieldResult,0,"zip");
$phone = mysql_result($fieldResult,0,"phone");
$comments = mysql_result($fieldResult,0,"notes");
$reasons = mysql_result($fieldResult,0,"purpose");
mail("communityplatformNOREPLY@urban.org","Data request","$notes\nEmail: $email\nLast name: $lname\nFirst name: $fname\nTitle: $title\nOrganization: $org\nOrganization Type: $OrgType\nAddress: $address\nCity: $city\nState: $state\nZip: $zip\nPhone: $phone\nComments: $comments\nReasons: $reasons\nTo update this record: http://communityplatform.us/PubApps/regis/requestIntro.php","From: nccsdataweb@urban.org\r\n");
include("registration_reg.php");
}
}
?>