session_start(); // updateUser.php - 03/01/04 - \phpApps\Regis - Updates sp_users and adds sp_list transaction & emails NCCS staff.; include("datacon.php"); $query = "SELECT * FROM sp_users WHERE lower(email)= lower('$email')"; $result = MYSQL_QUERY($query); $idAuto = mysql_result($result, 0, "idAuto"); $result = MYSQL_QUERY("UPDATE admin.sp_users SET password='$password',email='$email',lname='$lname',fname='$fname',title='$title',org='$org',address='$address',city='$city',state='$state',zip='$zip',phone='$phone',OrgType='$OrgType',FaxNumber='$fax',notes=concat(notes,'$reqType','$comments'),Purpose=concat(Purpose,'$reasons') WHERE idAuto=$idAuto"); //echo $idAuto; $today = date('Y-m-d'); // Add transaction record; $details = "RequestType: $reqType\n Email: $email\nLast name: $lname\nFirst name: $fname\nTitle: $title\nOrganization: $org\nOrganization Type: $OrgType\nAddress: $address\nCity: $city\nState: $state\nZip: $zip\nPhone: $phone\nRequested password: $password\nComments: $comments\nReasons: $reasons\nRequest type: $reqType"; //echo "$details
"; $query = "INSERT INTO admin.sp_list (ticket_createdby_userid, ticket_owner_id, ticket_short_description, ticket_full_description, ticket_status, ticket_severity, groups, ticket_added_date) VALUES ($idAuto, $idAuto, QUOTE('$details') , QUOTE('$details'), 'Open','Medium','2', '$today')"; $result = MYSQL_QUERY($query); // send email; if ($reqType == "data") { include("registration_data.php"); } else if ($reqType == "info") { mail("nccs@ui.urban.org", "Information Request", "Email: $email\nLast name: $lname\nFirst name: $fname\nTitle: $title\nOrganization: $org\nOrganization Type: $OrgType\nAddress: $address\nCity: $city\nState: $state\nZip: $zip\nPhone: $phone\nRequested password: $password\nComments: $comments\nReasons: $reasons\nRequest type: $reqType\nTo update this record: http://communityplatform.us/PubApps/regis/formGenerator.php?idAuto=$idAuto", "From: nccsWeb@ui.urban.org\r\n"); include("registration_reg.php"); } else { mail("nccs@ui.urban.org", "Data Access Request", "Email: $email\nLast name: $lname\nFirst name: $fname\nTitle: $title\nOrganization: $org\nOrganization Type: $OrgType\nAddress: $address\nCity: $city\nState: $state\nZip: $zip\nPhone: $phone\nRequested password: $password\nComments: $comments\nReasons: $reasons\nRequest type: $reqType\nTo update this record: http://communityplatform.us/PubApps/regis/formGenerator.php?idAuto=$idAuto", "From: nccsWeb@ui.urban.org\r\n"); include("registration_reg.php"); } ?>