Count Lines in Pages
Contents of Page: editmmEntries.asp
Number of Lines: 268
Last Modified: 3/7/2026 5:14:57 PM
0001:  <%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
0002: <!-- #include FILE="include/adovbs.inc" -->
0003: <!-- #include FILE="include/constants.inc" -->
0004: <%
0005: 	ID = Trim(Request.QueryString("ID"))
0006: 	HidePass = Trim(Request.QueryString("HidePass"))	
0007: 	from = Request.QueryString("from")
0008:   	Deadbeat = Request.QueryString("DB")   	
0009: 	If ID = "" Then Response.Redirect("whoisin.asp")
0010: 	
0011: 	If ID = 0 Then
0012: 		action = "Add"	
0013: 		nodeName = ""
0014: 		IsFolder = True
0015: 		parentID = ""
0016: 		typeValue = "R"
0017: 		link = ""
0018: 	Else
0019: 		action = "Update"
0020: 		Set rs = Server.CreateObject("ADODB.Recordset")
0021: 		sqlString = "SELECT * FROM mmEntries WHERE ID = " & ID
0022: 		rs.Open sqlString, Conn, adOpenDynamic, adLockOptimistic, adCmdText
0023: 		Name = rs("Name").Value
0024: 		FirstName = rs("FirstName").Value
0025:                 EmailAddress = rs("EmailAddress").Value
0026:                 TextEmailAddress = rs("TextEmailAddress").Value
0027:                 Password = rs("Password").Value
0028:                 Address = rs("Address").Value
0029:                 City = rs("City").Value
0030:                 State = rs("State").Value
0031:                 Zip = rs("Zip").Value
0032:                 Group = rs("GroupName").Value
0033:                 Group2 = rs("GroupName2").Value  
0034:                 RegNumber = rs("RegNumber").Value
0035:                 RefBy = rs("RefBy").Value     
0036:                 CheckNo = rs("CheckNo").Value   
0037: 		AmountDonatedToCOH =rs("AmountDonatedToCOH").Value				
0038: If Group2 = "" Then
0039: Group2 = "DEFAULT"
0040: End If  
0041:                 Group3 = rs("GroupName3").Value  
0042: If Group3 = "" Then
0043: Group3 = "DEFAULT"
0044: End If                            
0045: 		Entries = rs("numEntries").Value
0046: 		FreeEntries = rs("FreeEntries").Value 
0047: 		TotalRefs = rs("TotalRefs").Value
0048: 		PaidEntries = rs("PaidEntries").Value
0049: 		Entries2nd = rs("num2ndEntries").Value
0050: 		Paid2nd = rs("Paid2ndEntries").Value		
0051: 		ShowStand = rs("ShowStandings").Value
0052: 		PayPalUsed = rs("PayPalUsed").Value		
0053: 		CashUsed = rs("CashUsed").Value	
0054: 		VenMoUsed = rs("VenMoUsed").Value	
0055: 		ZelleUsed = rs("ZelleUsed").Value	
0056: UnpaidEntries = Entries - PaidEntries
0057: 		rs.Close	
0058: 	End If
0059: 
0060: 		Set rsm = Server.CreateObject("ADODB.Recordset")
0061: 	sqlString = "SELECT * FROM MY4_Master " & _
0062: 							"WHERE RegNumber = '" & RegNumber & "' " 
0063: 	rsm.Open sqlString, conn2, adOpenDynamic, adLockOptimistic, adCmdText
0064: 	If rsm.EOF Then
0065: 	
0066: 	Else
0067: 		PayPalEmailAddress = rsm("PayPalEmailAddress").Value
0068: 		VenMo = rsm("VenMo").Value
0069: 		Zelle = rsm("Zelle").Value
0070: 		rsm.Close
0071: 		Set rsm = Nothing	
0072:      End If
0073: 
0074: 	 ReturnSiteURL = Session("BaseSiteURL")
0075: 
0076: If ReturnSiteURL = "default.asp" Then
0077: TableWidth="550"
0078: OutTableWidth="560"
0079: Else
0080: OutTableWidth="100%"
0081: TableWidth="95%"
0082: End If	
0083: 
0084: %>
0085: <html>
0086: 
0087: <head>
0088: <meta name="viewport" content="width=device-width">
0089: <title>March Madness - Edit Participant Profile</title>
0090: <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
0091: <link href="admin.css" rel="stylesheet" type="text/css">
0092: <link href="https://mychinodes.org/desb.css" rel="stylesheet" type="text/css">
0093: <script language="JavaScript" type="text/javascript">
0094: 		function editNode(id)	{
0095: 			form = document.node;
0096: 			if (form.ID.value == "0")	{
0097: 				alert("A id value of 0 is not valid. Please change.");
0098: 				form.ID.select();
0099: 				return false;
0100: 			}
0101: 			// check for double quotes
0102: 			for (i=0; i<form.Name.value.length; i++)	{
0103: 				if (form.Name.value.charCodeAt(i) == 34)	{
0104: 					alert("Double quotes cannot be used in the name. Please change.");
0105: 					form.NodeName.select();
0106: 					return false;
0107: 				}
0108: 				// check for single quotes
0109: 				if (form.Name.value.charCodeAt(i) == 39)	{
0110: 					alert("Single quotes cannot be used in the name. Please change.");
0111: 					form.Name.select();
0112: 					return false;
0113: 				}
0114: 			}
0115: 			return true;
0116: 		}
0117: 	</script>
0118: </head>
0119: 
0120: <body bgcolor="#FFFFFF" onLoad="document.node.ID.select()">
0121: 
0122: <form method="post" action="mmEntriesUpdate.asp?from=<% = from %>&DB=<%= DeadBeat %>" name="node"
0123: onSubmit="return editNode()">
0124:   <input type="hidden" name="action" value="<%= action %>"><input type="hidden" name="ID"
0125:   value="<%= ID %>">
0126:    <input type="hidden" name="FreeEntries"  value="0">
0127:     <table cellspacing="0" border="1" cellpadding="1" width="<%= OutTableWidth %>" bordercolor="#FED87B">
0128:   <tr><td align="center">
0129:   <table border="0" cellpadding="1" cellspacing="1" width="<%= TableWidth %>" align="center" bgcolor="#FFFAF0">
0130:   <tr><td width="40%"></td><td width="*"></td></tr>
0131:     <tr>
0132:       <td class="normbold" align="right" ><font face="Arial" size="2" color="#008080"><b>ID/RegNo</td>
0133:       <td   class="norm" align="left" ><%= ID & "/" & RegNumber %></td>
0134:     </tr>
0135:     <tr>
0136:       <td  class="normbold" align="right"><font face="Arial" size="2" color="#008080"><b>Email Address</font></td>
0137:       <td class="norm"  ><input type="text" name="EmailAddress"
0138:       value="<%= EmailAddress %>"  class="norm" size="20"></td>
0139:     </tr>
0140: 	
0141: <%
0142: 
0143: If HidePass <> "Y" Then 
0144: 
0145: %>
0146:     <tr>
0147:       <td  class="normbold" align="right"><font face="Arial" size="2" color="#008080"><b>Password</font></td>
0148:       <td class="norm"  ><input type="text" name="Password"
0149:       value="<%= Password %>"  class="norm" size="20"></td>
0150:     </tr>
0151: 
0152: <% Else %>
0153: 
0154:   <tr>
0155:       <td  class="normbold" align="right"><font face="Arial" size="2" color="#008080"><b>Password</font></td>
0156:       <td class="norm"  ><input type="password" name="Password"
0157:       value="<%= Password %>"  class="norm" size="20"></td>
0158:     </tr>
0159: 
0160: 
0161: <% End If %>	
0162: 	
0163:     <tr>
0164:       <td  class="normbold" align="right"><font face="Arial" size="2" color="#008080"><b>First Name</font></td>
0165:       <td class="norm"  ><input type="text" name="FirstName"
0166:       value="<%= FirstName %>"  class="norm" size="20"></td>
0167:     </tr>
0168:     <tr>
0169:       <td class="normbold" align="right" ><font face="Arial" size="2" color="#008080"><b>Last
0170:       Name</font></td>
0171:       <td class="norm"  ><input type="text" name="Name"
0172:       value="<%= Name %>"  class="norm" size="20"></td>
0173:     </tr>
0174:     <tr>
0175:       <td class="normbold" align="right" ><font face="Arial" size="2" color="#008080"><b>Address</font></td>
0176:       <td class="norm"  ><input type="text" name="Address"
0177:       value="<%= Address %>" class="norm" size="20"></td>
0178:     </tr>
0179:     <tr>
0180:       <td class="normbold" align="right" ><font face="Arial" size="2" color="#008080"><b>City</font></td>
0181:       <td class="norm"  ><input type="text" name="City"
0182:       value="<%= City %>" class="norm" size="20"></td>
0183:     </tr>
0184:     <tr>
0185:       <td class="normbold" align="right" ><font face="Arial" size="2" color="#008080"><b>State</font></td>
0186:       <td class="norm"  ><input type="text" name="State"
0187:       value="<%= State %>" class="norm" size="2"> <font face="Arial" size="2" color="#008080"><b>Zip: </font><input
0188:       type="text" name="Zip" value="<%= Zip %>" class="norm" size="5"></td>
0189:     </tr>
0190:     <tr>
0191:       <td class="normbold" align="right"><font face="Arial" size="2" color="#008080"><b>PayPal Email:</b></font></td>
0192:       <td class="norm" ><input type="text" name="PayPalEmailAddress" value="<%= PayPalEmailAddress %>"
0193:       class="norm"  size="20"></td>
0194:     </tr>
0195:     <tr>
0196:       <td class="normbold" align="right"><font face="Arial" size="2" color="#008080"><b>VenMo ID:</b></font></td>
0197:       <td class="norm" ><input type="text" name="VenMo" value="<%= VenMo %>"
0198:       class="norm"  size="20"></td>
0199:     </tr>
0200:     <tr>
0201:       <td class="normbold" align="right"><font face="Arial" size="2" color="#008080"><b>Zelle ID:</b></font></td>
0202:       <td class="norm" ><input type="text" name="Zelle" value="<%= Zelle %>"
0203:       class="norm"  size="20"></td>
0204:     </tr>	
0205: 
0206:  
0207:     <tr>
0208:       <td class="normbold" align="right" ><font face="Arial" size="2" color="#008080"><b>&nbsp;Entries</font></td>
0209:       <td class="norm"  ><input type="text" name="Entries"
0210:       value="<%= Entries %>"  class="norm" size="5"><font face="Arial" size="2" color="#008080"><b>&nbsp; Paid&nbsp; <input
0211:       type="text" name="Paid" value="<%= PaidEntries %>"  class="norm"
0212:       size="5"></td>
0213: 	  </TR>
0214:    <tr> 
0215: 	  <td class="normbold" align="right"><font face="Arial" size="2" color="#008080"><b>All Paid Up?</td>   
0216: 	  <td><input type="checkbox"
0217:       name="AllPaidUp" value="Y"  style="width:20; height:20"
0218:       class="norm" size="20"></td>
0219: 
0220:     </tr>
0221: 
0222:     <tr>
0223:       <td class="normbold" align="right"><font face="Arial" size="2" color="#008080"><b>&nbsp;SW16 Entries</font></td>
0224:       <td class="norm" ><input type="text" name="Entries2nd"
0225:       value="<%= Entries2nd %>" style="width:50; height:21" class="norm" size="5">&nbsp;
0226:       <font face="Arial" size="2" color="#008080"><b>SW16&nbsp;Paid  <input type="text" name="Paid2nd" value="<%= Paid2nd %>" style="width:50px"
0227:       class="norm" size="5"></td>
0228:     </tr>
0229:     <tr>
0230: <td class="normbold" align="right"><font face="Arial" size="2" color="#008080"><b>Show Standings?&nbsp;</font></td>
0231: 	        <td><input type="checkbox" name="ShowStand" value="Y" <% If ShowStand = True Then %>checked<% End If %> style="width:16; height:16"
0232:       class="norm" size="20"> </td>
0233: 	 </tr>
0234:     <tr> 
0235: 	<td class="normbold" align="right"><font face="Arial" size="2" color="#008080"><b>PayPal Used?</font></td>
0236: 	<td> <input       type="checkbox" name="PayPalUsed" value="Y" <% If PayPalUsed = True Then %>checked<% End If %> style="width:16; height:16"
0237:       class="norm" size="20"></td>
0238: 	 </tr>
0239:     <tr> 
0240: <td class="normbold" align="right"><font face="Arial" size="2" color="#008080"><b>Cash Used?</font></td>
0241:       <td><input type="checkbox" name="CashUsed" value="Y"    <% If CashUsed = True Then %>checked<% End If %> style="width:16; height:16"
0242:       class="norm" size="20"></td>
0243: 	 </tr> 
0244:     <tr> 
0245: <td class="normbold" align="right"><font face="Arial" size="2" color="#008080"><b>VenMo Used?</font></td>
0246: 	 <td> <input type="checkbox" name="VenMoUsed" value="Y" <% If VenMoUsed = True Then %>checked<% End If %> style="width:16; height:16"></td>
0247: 	 </tr> 
0248:     <tr> 
0249: <td class="normbold" align="right"><font face="Arial" size="2" color="#008080"><b>Zelle Used?</font></td>
0250: 	<td> <input  type="checkbox" name="ZelleUsed" value="Y" <% If ZelleUsed = True Then %>checked<% End If %> style="width:16; height:16"
0251:       class="norm" size="20"></td>
0252: 	 </tr> 
0253:        <tr>
0254:       <td class="normbold" align="right" ><font face="Arial" size="2" color="#008080"><b>Amount Donated</font></td>
0255:       <td class="norm"  ><input type="text" name="AmountDonatedToCOH"
0256:       value="<%= AmountDonatedToCOH %>" class="norm" size="5"></td>
0257:     </tr>
0258: 
0259: 
0260:     <tr>
0261:       <td   colspan="2" align="center"><input type="submit"
0262:       value="<%= action %> Entry" class="button-40">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input type="button" value="Cancel" class="button_close"
0263:       onClick="history.back(-1)"></td>
0264:     </tr>
0265:   </table>
0266: </form>
0267: </body>
0268: </html>