<?
	// -------------------------------------------------------------
	// File Register.html
	// Desc : Just a form that submits data to the Member.html page
	//        All database testing happens there.
	// Note : This page is only ever called from the Members page
	// -------------------------------------------------------------

	// Include the session settings and start the session
	require_once("SessionSettings.php");
	session_start();

	require_once ("Admin/DatabaseConnection.php");
	require_once ("Admin/Crypt.php");
	require_once ("Admin/emailer.php");
    require_once ("NavBar.php");

	// Create databse connection
	$dbHandle=ConnectToMySql();
	ConnectToDatabase("",$dbHandle);
	
	$Command="";
	$MSG="";
	$DisplayName="";
	$Email="";
	$ConfirmEmail="";
	$Password="";
	$ConfirmPassword="";
	$Address="";
	$Postcode="";
	
	// Fetch paramaters from Get and Post arrays
	if (isset( $_POST['Command']))			$Command			=	trim(	$_POST['Command']		);
	if (isset( $_POST['DisplayName']))		$DisplayName		=	trim(	$_POST['DisplayName']	);
	if (isset( $_POST['Email']))			$Email				=	trim(	$_POST['Email']			);
	if (isset( $_POST['ConfirmEmail']))		$ConfirmEmail		=	trim(	$_POST['ConfirmEmail']	);
	if (isset( $_POST['Password']))			$Password			=	trim(	$_POST['Password']		);
	if (isset( $_POST['ConfirmPassword']))	$ConfirmPassword	=	trim(	$_POST['ConfirmPassword']);
	if (isset( $_POST['Address']))			$Address			=	trim(	$_POST['Address']		);
	if (isset( $_POST['Postcode']))			$Postcode			=	trim(	$_POST['Postcode']		);

	// Lets just check the person is already logged in otherwise send them to the members page
	if (isset($_SESSION['UserID']))
	{
		$UserID= $_SESSION['UserID'];

		// A session ID is set so lets check it exists
		$dbResult = mysql_query("select * from users where ID=".$UserID." limit 1", $dbHandle);
		
		// If the id is valid then relocate to the members area
		if ($dbResult && mysql_num_rows( $dbResult))
		{
			header("Location: Members.html");
			exit();
		}
	}

if ($Command=="Register")
{
	// Ok lets check the data
	if ( $DisplayName==""	|| strlen($DisplayName)<3 )									$MSG="Error: Display Name must be at least 3 characters long.";
	else
	if ( $Email==""			|| strlen($Email)<3		|| $Email!=$ConfirmEmail)			$MSG="Error: The email fields were filled in incorrectly.";
	else
	if ( $Password==""		|| strlen($Password)<3	|| $Password!=$ConfirmPassword)		$MSG="Error: The password fields were filled in incorrectly.";

	// If MSG=="" then everything is still ok so we proceed with the database test
	if ($MSG=="")
	{
		$CryptEmail = EncryptString( $Email , "Dallas" );
		$dbResult = mysql_query( "SELECT * FROM users WHERE Email='".$CryptEmail."' LIMIT 1 ",$dbHandle);

		// If it exists then this email already has an account
		if (mysql_num_rows($dbResult)) $MSG="Error: There is already an account registered to this email address.";
		else
		{
			// Lets test the display name is unique
			$dbResult = mysql_query( "SELECT * FROM users WHERE DisplayName='".addslashes($DisplayName)."' LIMIT 1 ",$dbHandle);
			if (mysql_num_rows($dbResult)) $MSG="Error: The Display Name you have chosen is already in use. Please choose another.";
			else
			{
				// All is good so encrypt and enter
				$CryptPassword = EncryptString( $Password , "Dallas" );
				$dbResult = mysql_query("	INSERT 
											INTO 
											users
											( DisplayName , Email , Password , Address , Postcode, Avatar, Registered )
											VALUES
											(
												'".addslashes($DisplayName)."',
												'".$CryptEmail."',
												'".$CryptPassword."',
												'".addslashes($Address)."',
												'".addslashes($Postcode)."',
												'Generic.jpg',
												".time()."
											 )
										", $dbHandle);
			   
			   // If something went wrong then prepare msg
			   if (!$dbResult || !mysql_affected_rows( $dbHandle ) ) $MSG="Error: Database Error - Your account could not be created.";
			   else
			   {
					// Fetch userid and insert into session
					$UserID = mysql_insert_id();
					$_SESSION['UserID'] = $UserID;
				
					// Now lets send the welcome email
					// Create the emailer object
					$Emailer = new CEmailer();

					// Setup constant email data
					$Emailer->SetFromName("The Bee Gees Story");
					$Emailer->SetSubject("Welcome to our Community");
					$Emailer->SetFromAddress("contactus@beegeesstory.co.uk");
					
					
					// Use curl to fetch price
					$ch = curl_init();
					curl_setopt($ch, CURLOPT_URL, "http://www.beegeesstory.co.uk/NewsletterMedia/WelcomeNewAccount.html" ); 
					curl_setopt($ch, CURLOPT_POST, 1 );
					curl_setopt($ch, CURLOPT_POSTFIELDS, "");
					curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
					$Message = curl_exec($ch);
					curl_close($ch);

					$Emailer->SetBodyText ( "You need an HTML enabled email client to view this email. But don't worry, you can view the email by clicking here http://www.beegeesstory.co.uk/NewsletterMedia/WelcomeNewAccount.html",$Message );
					$Emailer->SetToName("Member");
					$Emailer->SetToAddress($Email);
					$Emailer->Send();
                    
					// Relocate to members area
					header("Location: Members.html");
					exit();
			   }
			}
		}
	}
}

OpenPage("Register","","Register for a new Account - Jive Talkin Community");

?>

<div class="ToolClass" onmouseout="MouseOut()" id="ToolTip" ></div>

<div style="position: relative; width: 700px; left: -90px;">
		<center>
		
		<form action="Register.html" method="post" onsubmit="return ValidatePersonalForm(this)">
		<img src="LoginHeaderGraphic.jpg" border=0><br/>
		
		<? if ($MSG!="") print ("<center><font color=#FFFFFF face='Arial' size=3><B>$MSG</B></FONT></center>");?>
		
		<input type="hidden" name="Command" value="Register">
		<table border=0 class="Normal" cellspacing=20>
		
		<!-- Display Name -->
		<tr>
			<td>
				Display Name
			</td>
			<td>
				<input class="FormInput" type="TEXT" name="DisplayName" value="<? print ($DisplayName); ?>" maxlength=25 size=27>
			
			</td>
			<td>
				<img src="QuestionMark.jpg" onmouseover='MouseOver( "The name you wish displayed when you interact publicly with the Jive Talkin community (Forums etc)." ,event)' border=0>
			</td>
		</tr>
		
		<!-- Email Address -->
		<tr>
			<td>
				Email Address
			</td>
			<td>
				<input class="FormInput" type="TEXT" name="Email" value="<? print ($Email); ?>" maxlength=50 size=27>
			</td>
			<td>
				<img src="QuestionMark.jpg" onmouseover='MouseOver( "The email address that your account will be registered to.<br> This will be the email address to which our newsletter will be delivered and by which you login to your account.<br><br><b>Note:</b><br>Email addresses are case sensitive so be sure you observe the case." ,event)' border=0>
			</td>
		</tr>

		<!-- Confirm Email Address -->
		<tr>
			<td>
				Confirm Email Address
			</td>
			<td>
				<input class="FormInput" type="TEXT" name="ConfirmEmail" value="<? print ($ConfirmEmail); ?>" maxlength=50 size=27>
				<td>
				<img src="QuestionMark.jpg" onmouseover='MouseOver( "Because your email address is one of the important keys you use to gain access to your member account, we ask you to type your email address in again here so that we can spot any potential typing mistakes." ,event)' border=0>
			</td>
			</td>
		</tr>

		<!-- Password -->
		<tr>
			<td>
				Password
			</td>
			<td>
				<input class="FormInput" type="PASSWORD" name="Password" value="" maxlength=15 size=27>
			</td>
			<td>
				<img src="QuestionMark.jpg" onmouseover='MouseOver( "Please enter the password (<i>between 5 & 12 letters in length</i>) that you would like to use to login to your member account." ,event)' border=0>
			</td>
		</tr>

		<!-- Confirm Password -->
		<tr>
			<td>
				Confirm Password
			</td>
			<td>
				<input class="FormInput" type="PASSWORD" name="ConfirmPassword" value="" maxlength=15 size=27>
			</td>
			<td>
				<img src="QuestionMark.jpg" onmouseover='MouseOver( "Please type in your password again here as to minimise the chance of a typing mistake. Both of your email fields should match." ,event)' border=0>
			</td>
		</tr>

		<!-- Address -->
		<tr>
			<td valign="top">
				Address
				(UK Only)<br><span style="color: #AA33AA;"><i>Optional</i></span>
			</td>
			<td>
				<textarea class="FormInput" name="Address" rows=4 cols=27><? print ($Address); ?></textarea>
			</td>
			<td>
				<img src="QuestionMark.jpg" onmouseover='MouseOver( "Your postal address is purely optional and will only be used to send you things such as concert tickets, competition prizes and eventually, our bi-yearly magazine, <i>Jive Talking (coming soon)</i>.<br><br>This feature is only available to UK residents so do not fill in this field if you live outside the United Kingdom." ,event)' border=0>
			</td>
		</tr>
		
		<!-- Postcode -->
		<tr>
			<td>
				Postcode(UK Only)<br><span style="color: #AA33AA;"><i>Optional</i></span>
			</td>
			<td>
				<input class="FormInput" type="TEXT" name="Postcode" value="<? print ($Postcode); ?>" maxlength=15 size=27>
			</td>
			<td>
				<img src="QuestionMark.jpg" onmouseover='MouseOver( "This feature is only available to UK residents so do not fill in this field if you live outside the United Kingdom." ,event)' border=0>
			</td>
		</tr>

		<tr>
			<td colspan=2 align="center">
				<input class="Button" type="submit" value="Register">
			</td>
		</tr>
		
		</table>
		</form>
  </center>
</div>

<script language="javascript">
function MouseOver( string , e )
{
	var theEvent = e ? e : window.event;
	element = document.getElementById('ToolTip');
	var Offset=0;
	if (typeof window.pageYOffset=="undefined")
		Offset= document.body.scrollTop;
		 else	Offset+= window.pageYOffset;
	element.style.left=(theEvent.clientX-30)+"px";
			element.style.top=((theEvent.clientY+Offset)-30)+"px";
	element.innerHTML="<center><table cellpadding=0 cellspacing=0 valign=\"bottom\" width=63 border=0><tr><td><img src=\"ToolTip.jpg\"></td></tr></table></center><br>"+string;
	element.style.visibility="visible";
	
}
function MouseOut ( e )
{
	element = document.getElementById('ToolTip');
	element.innerHTML="";
	element.style.visibility="hidden";
	
}
   // ------------------------------------------------------------------------------
   // Name : ValidatePersonalForm
   // Desc : Validates the personal details form
   // ------------------------------------------------------------------------------
   function ValidatePersonalForm ( OrderForm )
   {	
		if ( !IsValidText ( OrderForm.DisplayName.value ) || OrderForm.DisplayName.value.length<3 )
        {
           alert('You must enter a Display Name consisting of more than 3 characters.');
           return false;
        }

		if (!IsValidEmail( OrderForm.Email.value ) || OrderForm.Email.value!=OrderForm.ConfirmEmail.value)
	    {
		   alert ('The email address you have entered does not seem to be in a valid format or the email fields do not match.');
		   return false;
	    }

		
		 if ( !IsValidPassword( OrderForm.Password.value , OrderForm.ConfirmPassword.value ) || OrderForm.Password.value.length<3 )
         {
            alert('Your password has been entered incorrectly. The two password fields must match and be longer than three characters');
            return false;
         }

		
		return true;
   }

 // ------------------------------------------------------------------------------
   // Name : Is Valid Text
   // Desc : Called to validate form fields
   // ------------------------------------------------------------------------------
   function IsValidEmail( email )
  {
	invalidchars = "/:,;"

	if (!IsValidText( email ))
	{
	   return false;
	}

	for (i=0;i<invalidchars.length;i++)
	{
	   badchar = invalidchars.charAt(i)
	   if (email.indexOf(badchar,0)>-1)
	   {
		  return false;
	   }
	}

	atPos = email.indexOf("@",1)
	if (atPos==-1)
	{
	   return false;
	}

	if (email.indexOf("@",atPos+1)>-1 )
	{
	   return false;
	}

	periodpos= email.indexOf(".",atPos)
	if (periodpos == -1 )
	{
	   return false;
	}

	if (periodpos+3 > email.length )
	{
	   return false;
	}

	return true;
  }

  function IsValidPassword ( String1 , String2 )
  {
	if (!IsValidText( String1 ) )
	{
		return false;
	}

	if ( String1!=String2 ) return false;

	return true;
  }

   
   function IsValidText( Buffer )
   {
	 if ( Buffer=="" || Buffer.length<1)
	 {
		return false;
	 }

	 AllWhiteSpace=1;
	 for ( i=0; i< Buffer.length; i++)
	 {
	   var onechar= Buffer.substring( i , i+1)
	   if (onechar!=" " )
	   {
	 	  AllWhiteSpace=0
	   }
	 }

	 if (AllWhiteSpace==1)
	 {
	    return false;
	 }

	 return true;
   }	


</script>

<?
ClosePage();
?>