Count Lines in Pages
Contents of Page: editprofile.asp
Number of Lines: 289
Last Modified: 2/18/2026 10:56:09 AM
0001: 	<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
0002: <!-- #include FILE="include/adovbs.inc" -->
0003: <!-- #include FILE="include/constants.inc" -->
0004: <%
0005: 	user = Request.Cookies("user")	
0006: 	If user = "" Then Response.Redirect("login_m.asp?from=editprofile.asp")
0007: 	
0008: Set rs = Server.CreateObject("ADODB.Recordset")
0009: 	sqlString = "SELECT * FROM mmEntries " & _
0010: 			"WHERE Season = " & season & " " & _
0011: 			"AND EmailAddress = '" & user & "'"
0012: 	rs.Open sqlString, conn, adOpenDynamic, adLockOptimistic, adCmdText
0013: 	
0014: 	If rs.EOF Then
0015: 		Response.Redirect("login.asp?from=editprofile.asp")
0016:     End If
0017: 		
0018:         ID = rs("ID").Value
0019: 		Name = rs("Name").Value
0020: 		FirstName = rs("FirstName").Value
0021:                 EmailAddress = rs("EmailAddress").Value
0022:                 Password = rs("Password").Value
0023:                 Address = rs("Address").Value
0024:                 City = rs("City").Value
0025:                 State = rs("State").Value
0026:                 Zip = rs("Zip").Value
0027:                 TextEmailAddress = rs("TextEmailAddress").Value
0028:                 Group = rs("GroupName").Value
0029:                 Group2 = rs("GroupName2").Value  
0030:  				RegNumber = rs("RegNumber").Value                
0031: If Group2 = "" Then
0032: Group2 = "DEFAULT"
0033: End If    
0034: Group3 = rs("GroupName3").Value  
0035: If Group3 = "" or Group3 = "FREE" Then
0036: Group3 = "DEFAULT"
0037: End If 
0038:                 StartPage = Trim(rs("StartPage").Value)
0039: 		Entries = rs("numEntries").Value
0040: 		BonusSSEntries = Entries - 1
0041:        If BonusSSEntries < 0 Then
0042:           BonusSSEntries = 0
0043:        End If
0044: 		PaidEntries = rs("PaidEntries").Value
0045: 		SSEntries = rs("num2ndEntries").Value
0046: 		PaidSSEntries = rs("Paid2ndEntries").Value		
0047: 		rs.Close
0048: 		
0049: 
0050: 		
0051: 		Set rsm = Server.CreateObject("ADODB.Recordset")
0052: 	sqlString = "SELECT * FROM MY4_Master " & _
0053: 							"WHERE RegNumber = '" & RegNumber & "' " 
0054: 	rsm.Open sqlString, conn2, adOpenDynamic, adLockOptimistic, adCmdText
0055: 	If rsm.EOF Then
0056: 	
0057: 	Else
0058: 		PayPalEmailAddress = rsm("PayPalEmailAddress").Value
0059: 		AmountDonatedToCOH =rsm("AmountDonatedToCOH").Value
0060: 		VenMo = rsm("VenMo").Value
0061: 		Zelle = rsm("Zelle").Value
0062: 		rsm.Close
0063: 		Set rsm = Nothing	
0064:      End If
0065: 	 
0066: 	 ReturnSiteURL = Session("BaseSiteURL")
0067: 
0068: If ReturnSiteURL = "default.asp" Then
0069: TableWidth="550"
0070: OutTableWidth="560"
0071: Else
0072: OutTableWidth="100%"
0073: TableWidth="95%"
0074: End If
0075: 		
0076: If StartPage = "Default"  or StartPage = "" Then
0077: StartPage = "Site Default"
0078: End If		
0079: %>
0080: <html>
0081: 
0082: <head>
0083: <title>Untitled Document</title>
0084: <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
0085: <meta name="viewport" content="width=device-width">
0086: <link href="mm.css" rel="stylesheet" type="text/css">
0087: 	<link href="https://mychinodes.org/desb.css" rel="stylesheet" type="text/css">
0088: <script language="JavaScript" type="text/javascript">
0089: 
0090: 		re = /^\w+([\.-]?\w+)*@\w+([\.-]?\w+)*(\.\w{2,3})+$/;	
0091: function checkEntry()
0092: 		{
0093: 			form = document.node
0094: 			if (form.Password.value == "")
0095: 			{
0096: 				alert("Please enter your Password");
0097: 				form.Password.select();
0098: 				return false;
0099: 			}
0100: 			
0101: 			if (form.FirstName.value == "")
0102: 			{
0103: 				alert("Please enter your First Name");
0104: 				form.FirstName.select();
0105: 				return false;
0106: 			}
0107: 			if (form.Name.value == "")
0108: 			{
0109: 				alert("Please enter your Name");
0110: 				form.Name.select();
0111: 				return false;
0112: 			}
0113: 			if (form.Address.value == "")
0114: 			{
0115: 				alert("Please enter your Street Address");
0116: 				form.Address.select();
0117: 				return false;
0118: 			}
0119: 			if (form.City.value == "")
0120: 			{
0121: 				alert("Please enter your City");
0122: 				form.City.select();
0123: 				return false;
0124: 			}
0125: 			if (form.State.value == "")
0126: 			{
0127: 				alert("Please enter your State");
0128: 				form.State.select();
0129: 				return false;
0130: 			}
0131: 		
0132: 			if (form.Zip.value == "")
0133: 			{
0134: 				alert("Please enter your Zip Code");
0135: 				form.Zip.select();
0136: 				return false;
0137: 			}
0138: 			if (form.Entries.value == "")
0139: 			{
0140: 				alert("Please enter your # of entries");
0141: 				form.Entries.select();
0142: 				return false;
0143: 			}
0144: 			
0145: 			return true;
0146: 		}
0147: 
0148: 	</script>
0149: </head>
0150: 
0151: <body bgcolor="#FFFFFF" onLoad="document.node.FirstNamex.select()">
0152: 
0153: <form method="post" action="mmProfileUpdate.asp?ID=<% = ID %>" name="node"
0154: onSubmit="return checkEntry()">
0155:   <input type="hidden"  name="action" value="<%= action %>">
0156:   <input type="hidden" name="ID" value="<%= ID %>">
0157:   <input type="hidden" name="EmailAddress" value="<%= EmailAddress %>">
0158:   <% If regopen <> "YES" Then %>
0159:     <input type="hidden" name="Entries" value="<%= Entries %>">
0160:   <% End If %>
0161:   <% If reg2ndopen <> "YES" Then %>
0162:     <input type="hidden" name="SSEntries" value="<%= SSEntries %>">
0163:   <% End If %>
0164:   <table cellspacing="0" border="1" cellpadding="1" width="<%= OutTableWidth %>" bordercolor="#FED87B">
0165:   <tr><td>
0166:   <table border="0" cellpadding="1" cellspacing="1" width="<%= TableWidth %>" align="left" bgcolor="#FFFAF0">
0167:     <tr>
0168:       <td width="45%" class="normbold" align="right"><font face="Arial" size="2" color="#008080"><b>My
0169:       Profile:</b></font></td>
0170:       <td class="norm"  align="left" width="55%"><%= ID & "/" & RegNumber %></td>
0171:     </tr>
0172:     <tr>
0173:       <td  class="normbold" align="right"><font face="Arial" size="2" color="#008080"><b>Email
0174:       Address:</b></font></td>
0175:       <td class="normbold" ><font face="Arial" size="2" color="#008080"><b><%= EmailAddress %></b>
0176: </td>
0177:     </tr>
0178:     <tr>
0179:       <td  class="normbold" align="right"><font face="Arial" size="2" color="#008080"><b>Password:</b></font></td>
0180:       <td class="norm" ><input type="Password" name="Password"
0181:       value="<%= Password %>" style="height: 22" size="17" class="norm"></td>
0182:     </tr>
0183:     <tr>
0184:       <td  class="normbold" align="right"><font face="Arial" size="2" color="#008080"><b>First
0185:       Name:</b></font></td>
0186:       <td class="norm" ><input type="text" name="FirstName"
0187:       value="<%= FirstName %>"  style="height: 22" size="17" class="norm"></td>
0188:     </tr>
0189:     <tr>
0190:       <td class="normbold" align="right"><font face="Arial" size="2" color="#008080"><b>Last
0191:       Name:</b></font></td>
0192:       <td class="norm" ><input type="text" name="Name" value="<%= Name %>"
0193:        style="height: 22" size="17" class="norm"></td>
0194:     </tr>
0195:     <tr>
0196:       <td class="normbold" align="right"><font face="Arial" size="2" color="#008080"><b>Address:</b></font></td>
0197:       <td class="norm" ><input type="text" name="Address"
0198:       value="<%= Address %>"  style="height: 22" class="norm" size="17"></td>
0199:     </tr>
0200:     <tr>
0201:       <td class="normbold" align="right"><font face="Arial" size="2" color="#008080"><b>City:</b></font></td>
0202:       <td class="norm" ><input type="text" name="City" value="<%= City %>"
0203:       class="norm" style="height: 22" size="17"></td>
0204:     </tr>
0205:     <tr>
0206:       <td class="normbold" align="right"><font face="Arial" size="2" color="#008080"><b>State:</b></font></td>
0207:       <td class="norm" ><input type="text" name="State" value="<%= State %>"
0208:       class="norm" style="height: 22" size="2">&nbsp; <font face="Arial" size="2">Zip: </font><input type="text"
0209:       name="Zip" value="<%= Zip %>" class="norm"  style="height: 22"size="3"></td>
0210:     </tr>
0211:  
0212: 		 <tr>
0213:       <td  class="normbold" align="right"><font face="Arial" size="2" color="#008080"><b>VenMo ID:</b></font></td>
0214:       <td class="norm" ><input type="text" name="VenMo"
0215:       value="<%= VenMo %>" style="height: 20" size="17" class="norm"></td>
0216:     </tr>
0217: 		 <tr>
0218:       <td  class="normbold" align="right"><font face="Arial" size="2" color="#008080"><b>Zelle ID:</b></font></td>
0219:       <td class="norm" ><input type="text" name="Zelle"
0220:       value="<%= Zelle %>" style="height: 20" size="17" class="norm"></td>
0221:     </tr>
0222: 	   <tr>
0223:       <td class="normbold" align="right"><font face="Arial" size="2" color="#008080"><b>PayPal Email:</b></font></td>
0224:       <td class="norm" ><input type="text" name="PayPalEmailAddress" value="<%= PayPalEmailAddress %>"
0225:       class="norm" style="height: 22" size="17"></td>
0226:     </tr>
0227: 
0228: <% If user = "jt@folga.org" Then %>
0229: 		    <tr>        
0230:       <td class="normbold" align="right"><font face="Arial" size="2" color="#DF0174"><b>Amount Donated:</b></font></td>
0231:       <td class="normbold" ><font face="Arial" size="2"
0232:       color="#008080"><input type="text" name="AmountDonatedToCOH" value="<%= AmountDonatedToCOH %>" class="norm"
0233:       style="height: 22" size="10"> 
0234:     </tr>
0235: <% End If %>
0236:  
0237:     <tr>
0238:       <td class="normbold" align="right" height="30"><font face="Arial" size="2" color="#008080"><b>Current
0239:       Start Page:</b></font></td>
0240:       <td class="norm" ><b><%= StartPage %></b> </td>
0241:     </tr>
0242:     <tr height="30">
0243:       <td class="normbold" align="right"><font face="Arial" size="2" color="#008080"><b>Default
0244:       Start Page:</b></font></td>
0245:       <td class="norm" ><font face="Arial" size="2"><b><select size="1"
0246:       name="NewStartPage">
0247:         <option selected>-Select To Change-</option>
0248:         <option Value="Default">Site Default</option>
0249:         <option Value="MessageBoard">MessageBoard</option>
0250:         <option Value="Standings">Standings</option>
0251:         <option Value="MyStandings">My Group Standings</option>
0252: 		<option Value="MyPicks&Top5">My Picks & Top 5</option>
0253:       </select></b></font></td>	
0254:     </tr>
0255:     <tr height="30">
0256:       <td class="normbold" align="right"><font face="Arial" size="2" color="#008080"><b>&nbsp;Contest Entries:</b></font></td>
0257:       <td class="norm" ><% If regopen = "YES" Then %>
0258: <p><input name="Entries" value="<%= Entries %>"
0259:        style="height: 22" size="1" class="norm">&nbsp; <% Else %> &nbsp;<%= Entries %> <% End If %> <b><font face="Arial" size="2" color="#008080">Paid:</font></b>&nbsp;<%= PaidEntries %>&nbsp;&nbsp;&nbsp;&nbsp;
0260: 
0261: <input type="hidden" name="PaidEntries" Value=<%= PaidEntries %>>
0262: <% If regopen <> "YES" Then %>      <b><i><font face="Arial" size="1" color="#800080">Registration Closed.</font></i></b> <% End If %> </td>
0263:     </tr>
0264:     <tr >
0265:       <td class="normbold" align="right"><font face="Arial" size="2" color="#008080"><b>&nbsp;Free
0266:       Sweet 16 Entries:</b></font></td>
0267:       <td class="norm" >&nbsp;<%= BonusSSEntries %></td>
0268:     </tr>
0269: <% If regopen <> "YES" Then %>
0270:     <tr height="30">
0271:       <td class="normbold" align="right"><font face="Arial" size="2" color="#008080"><b>&nbsp;Additional
0272:       Sweet 16 Entries:</b></font></td>
0273:       <td class="norm" ><% If reg2ndopen = "YES" Then %>
0274: <p><input name="SSEntries" value="<%= SSEntries %>"
0275:       size="3" class="norm">&nbsp; <% Else %> &nbsp;<%= SSEntries %> <% End If %> <b><font face="Arial" size="3" color="#008080">Paid:</b>&nbsp;&nbsp;<b><%= PaidSSEntries %></b></font>&nbsp;&nbsp;&nbsp;&nbsp;
0276:       </td>
0277:     </tr>
0278: <% Else %>
0279: <% End If %>
0280:     <tr>
0281: 
0282:       <td class="norm" align="center" colspan="2"><input type="submit" value="Update Profile" class="button-40"> <input
0283:       type="button" value="Cancel" class="button_close" onClick="history.back(-1)"></td>
0284:     </tr>
0285:   </table>
0286:   </table>  
0287: </form>
0288: </body>
0289: </html>