<cfset PageTitle="Register for Account">
<cfparam name="form.cFirstName" default="">
<cfparam name="form.cLastName" default="">
<cfparam name="form.cEmail" default="">
<cfparam name="form.cUsername" default="">
<cfparam name="form.cAIM" default="">
<cfparam name="form.cMSN" default="">
<cfparam name="form.cICQ" default="">
<cfparam name="form.cYIM" default="">
<cfscript>
form.dSince = Now();
form.dLast = Now();
form.lActive = 1;
form.nPos = 0;
form.nNeut = 0;
form.nNeg = 0;
form.nUserTypes_id = 2;
ErrorText = "";
</cfscript>
<cfif IsDefined("form.Cancel")>
<cflocation url="index.cfm">
</cfif>
<cfif IsDefined("form.Submit")>
<cfquery name="qCheckUser" datasource="#session.datasource#" username="#session.db_un#" password="#session.db_pw#">
up_get_users @cUsername = '#form.cUsername#'
</cfquery>
<cfif qCheckUser.RecordCount>
<cfset ErrorText = "That username is already in use, please select a different name and try again.">
<cfelse>
<cfif (Form.cPassword NEQ Form.cPassword2) OR NOT Len(Form.cPassword)>
<cfset ErrorText = "You must enter a valid password and verify it correctly. Please try again.">
<cfelse>
<cfset GoodAdd = 1>
<cfquery name="qAddUser" datasource="#session.datasource#" username="#session.db_un#" password="#session.db_pw#">
up_set_user @nUsers_id = 0,
@cFirstName = '#form.cFirstName#',
@cLastName = '#form.cLastName#',
@cEmail = '#form.cEmail#',
@cUsername = '#form.cUsername#',
@cPassword = '#form.cPassword#',
@cAIM = '#form.cAIM#',
@cYIM = '#form.cYIM#',
@cICQ = '#form.cICQ#',
@cMSN = '#form.cMSN#',
@nUserTypes_id = #form.nUserTypes_id#,
@dSince = #form.dSince#,
@dLast = #form.dLast#,
@nPos = #form.nPos#,
@nNeut = #form.nNeut#,
@nNeg = #form.nNeg#
</cfquery>
</cfif>
</cfif>
</cfif>
<cfinclude template="includes/newHeader.cfm">
<cfinclude template="includes/newTop.cfm">
<cfinclude template="includes/newsidebar.cfm">
<cfinclude template="includes/newmiddle.cfm">
<cfform action="register.cfm" method="post">
<cfif NOT IsDefined("GoodAdd")>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="26%"><div align="center"><img src="images/rambo.jpg" width="150" height="156"></div></td>
<td colspan="2"><div align="center" class="BigHeader">User Registration
Form</div>
<cfif Len(ErrorText) GT 0>
<p align="center" class="Error"><cfoutput>#ErrorText#</cfoutput></p>
</cfif></td>
</tr>
<tr>
<td colspan="3"><hr></td>
</tr>
<tr>
<td class="SmallHeader">User Information</td>
<td width="1%"> </td>
<td width="73%"> </td>
</tr>
<tr>
<td> <div align="right">First Name</div></td>
<td> </td>
<td> <cfinput name="cFirstName" type="text" value="#form.cFirstName#" size="50" maxlength="75" required="yes" message="You must enter your first name" id="cFirstName"></td>
</tr>
<tr>
<td> <div align="right">Last Name</div></td>
<td> </td>
<td> <cfinput name="cLastName" type="text" value="#form.cLastName#" size="50" maxlength="75" required="yes" message="You must enter your last name" id="cLastName"></td>
</tr>
<tr>
<td> <div align="right">Email Address</div></td>
<td> </td>
<td> <cfinput name="cEmail" type="text" value="#form.cEmail#" size="50" maxlength="150" required="yes" message="You must enter a valid email address" id="cEmail"></td>
</tr>
<tr>
<td><div align="right">Username</div></td>
<td> </td>
<td> <cfinput name="cUsername" type="text" value="#form.cUsername#" size="50" maxlength="50" required="yes" message="You must enter a username" id="cUsername"></td>
</tr>
<tr>
<td><div align="right">Password</div></td>
<td> </td>
<td> <cfinput name="cPassword" type="password" id="cPassword" maxlength="50"></td>
</tr>
<tr>
<td><div align="right">Repeat Password</div></td>
<td> </td>
<td> <cfinput name="cPassword2" type="password" id="cPassword2" maxlength="50"></td>
</tr>
<tr>
<td class="SmallHeader">Optional Contact Info</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td><div align="right">AOL Messenger</div></td>
<td> </td>
<td> <cfinput name="cAIM" type="text" id="cAIM" value="#form.cAIM#" maxlength="75"></td>
</tr>
<tr>
<td><div align="right">MSN Messenger</div></td>
<td> </td>
<td><cfinput name="cMSN" type="text" id="cMSN" value="#form.cMSN#" maxlength="75"></td>
</tr>
<tr>
<td><div align="right">Yahoo Messenger</div></td>
<td> </td>
<td><cfinput name="cYIM" type="text" id="cYIM" value="#form.cYIM#" maxlength="75"></td>
</tr>
<tr>
<td><div align="right">ICQ UIN</div></td>
<td> </td>
<td><cfinput name="cICQ" type="text" id="cICQ" value="#form.cICQ#" maxlength="75"></td>
</tr>
<tr>
<td colspan="3"><hr></td>
</tr>
<tr>
<td colspan="3"><div align="center">
<input type="submit" name="Submit" value="Submit Registration">
<input type="reset" name="Submit2" value="Reset ">
<input name="Cancel" type="button" id="Cancel" value="Cancel Registration" onClick="self.location='index.cfm';">
</div></td>
</tr>
</table>
<cfelse>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><div align="center" class="BigHeader">User Account Created Successfully</div>
<p>Use the link on the left to go to the Login page.</p>
</td>
<td width="26%"><div align="center"><img src="images/rambo.jpg" width="150" height="156"></div></td>
</tr>
</table>
</cfif>
</cfform>
<cfinclude template="includes/newbottom.cfm">