1. <cfparam name="FORM.userlogin" default="">
  2. <cfparam name="FORM.userpassword" default="">
  3.  
  4. <cfquery name="add_new" datasource="#APPLICATION.dataSource#">
  5. 	SELECT contactid, userlogin, userpassword
  6. 	FROM contact
  7. </cfquery>
  8.  
  9. NewAccountPage.cfm
  10. <cfif isDefined("form.userlogin") and form.userpassword neq "">
  11. <cfform action="AccountAdded.cfm">
  12.  
  13.  <cfset SESSION.auth = structNew()>
  14.  <cfset SESSION.auth.contactID = add_new.contactID>
  15.  <!--- Make the UserLogin and UserPassword fields required --->
  16.  <input type="hidden" name="userLogin_required">
  17.  <input type="hidden" name="userPassword_required">
  18. Username:
  19.  
  20.  <!--- Text field for "User Name" ---> 
  21.  <cfinput 
  22.  type="text"
  23.  name="userLogin"
  24.  size="20"
  25.  value=""
  26.  maxlength="100"
  27.  required="Yes"
  28.  message="Please type your Username first.">
  29.  
  30. Password:
  31.  
  32.  <!--- Text field for Password ---> 
  33.  <cfinput 
  34.  type="password"
  35.  name="userPassword"
  36.  size="12"
  37.  value=""
  38.  maxlength="100"
  39.  required="Yes"
  40.  message="Please type your Password first.">
  41.  
  42.  Add Captcha test here
  43.  
  44.  <!--- Submit Button that reads "Enter" ---> 
  45.  <input type="Submit"
  46.  value="Enter"
  47.  title="Enter">
  48. </cfform>
  49. </cfif>
  50.  
  51. AccountAdded.cfm
  52.  
  53.     <h1>Successful!</h1>
  54. <cfinsert datasource="#APPLICATION.dataSource#"
  55. tablename="contact">
  56.  
  57. AddPlayer.cfm
  58.  
  59. <cfform action="insert_ok.cfm">
  60.  
  61.     <h2>Insert New Player</h2>
  62.      <input type="hidden" name="playerid"
  63. value="<cfoutput>#SESSION.auth.contactid#</cfoutput>">
  64.  
  65.     Name:
  66.  
  67.     <cfinput type="Text"
  68.     name="name"
  69.     size="50"
  70.     maxlength="50"
  71.     required="Yes">
  72. </cfform>
  73.  
  74. inserk_ok.cfm
  75.  
  76.     <h1>Successful!</h1>
  77. <cfinsert datasource="#APPLICATION.dataSource#"
  78. tablename="players">
  79.  
  80. MyAccountPage.cfm
  81.  
  82. <cfquery name="get_mypage" datasource="#APPLICATION.dataSource#">
  83.     SELECT playerid, name, contactid 
  84.     FROM players
  85.     WHERE	playerid = #SESSION.auth.contactID#
  86.     ORDER BY playerid DESC  
  87. </cfquery>
  88.  
  89. Registered Players
  90. <br /><br />
  91. <cfoutput query="get_mypage">
  92. #name#<br />
  93. </cfoutput>