busboy
1
<?php[FONT=Helvetica]
[/FONT]
[FONT=Helvetica]include 'startSession.php';[/FONT]
[FONT=Helvetica]
[/FONT]
[FONT=Helvetica]
[/FONT]
[FONT=Helvetica]
[/FONT]
[FONT=Helvetica]$pageTitle = "Account Registration";[/FONT]
[FONT=Helvetica]
[/FONT]
[FONT=Helvetica]$longDate = date("Y-m-d H:i:s");[/FONT]
[FONT=Helvetica]$shortDate = date("Y-m-d");[/FONT]
[FONT=Helvetica]
[/FONT]
[FONT=Helvetica]
[/FONT]
[FONT=Helvetica]
[/FONT]
[FONT=Helvetica]// Get URL variables[/FONT]
[FONT=Helvetica]
[/FONT]
[FONT=Helvetica]$confirmID = $_REQUEST['confirmID']; //When confirming their email address [/FONT]
[FONT=Helvetica]$processForm = $_REQUEST['processForm']; //When registering their account[/FONT]
[FONT=Helvetica]$formFirstName = $_REQUEST['formFirstName'];[/FONT]
[FONT=Helvetica]
[/FONT]
[FONT=Helvetica]
[/FONT]
[FONT=Helvetica]
[/FONT]
[FONT=Helvetica]
[/FONT]
[FONT=Helvetica]if ($confirmID) {[/FONT]
[FONT=Helvetica]
[/FONT]
[FONT=Helvetica] // !Confirm the email address[/FONT]
[FONT=Helvetica]
[/FONT]
[FONT=Helvetica] $confirmUser = "UPDATE users set confirmed = 'Yes' WHERE uID = '$confirmID'";[/FONT]
[FONT=Helvetica] $result = mysql_query($confirmUser) OR die("<b>A fatal MySQL error occurred</b>.\
<br />Query: " . $confirmUser . "<br />\
Error: (" . mysql_errno() . ") " . mysql_error());[/FONT]
[FONT=Helvetica] [/FONT]
[FONT=Helvetica] [/FONT]
[FONT=Helvetica] $lookupUser = "SELECT firstName, lastName, email, sponsorID FROM users WHERE uID = '$confirmID'";[/FONT]
[FONT=Helvetica] $nameResult = mysql_query($lookupUser) OR die("<b>A fatal MySQL error occurred</b>.\
<br />Query: " . $lookupUser . "<br />\
Error: (" . mysql_errno() . ") " . mysql_error());[/FONT]
[FONT=Helvetica] [/FONT]