Count Lines in Pages
Contents of Page: Top10Edit.asp
Number of Lines: 169
Last Modified: 4/9/2025 6:14:45 PM
0001: <% @Language = "VBScript" %>
0002: <!-- #include FILE="include/adovbs.inc" -->
0003: <!-- #include FILE="include/constants.inc" -->
0004: <!-- #include FILE="include/funcs.asp" -->
0005: <%
0006: 	
0007: 	ID = Request.QueryString("ID")
0008: 	Set rsm = Server.CreateObject("ADODB.Recordset")
0009: 
0010: 		sqlString = "SELECT * FROM mmTop10 WHERE ID = " & ID
0011: 
0012: 							
0013: 	   rsm.Open sqlString, conn, adOpenStatic, adLockReadOnly, adCmdText
0014:   If rsm.EOF Then
0015:   FullName = "????"
0016: 
0017:   Else
0018:       FullName = rsm("Name").Value
0019: 	  Rank = rsm("Rank").Value
0020: 	  TotalAmt = rsm("TotalAmt").Value
0021: 	  Contest = rsm("Contest").Value
0022: 	  Top10Amt = rsm("Top10Amt").Value	
0023: 	  DonatedAmount = rsm("DonatedAmount").Value	
0024: 	  CheckNo = rsm("CheckNo").Value	
0025: 	  RegNumber = rsm("RegNumber").Value		  	  
0026: 
0027:       rsm.Close
0028:       set rsm = Nothing
0029:       
0030: End If
0031: 	
0032: 
0033: 		Set rsm = Server.CreateObject("ADODB.Recordset")
0034: 	sqlString = "SELECT * FROM MY4_Master " & _
0035: 							"WHERE RegNumber = '" & RegNumber & "' " 
0036: 	rsm.Open sqlString, conn2, adOpenDynamic, adLockOptimistic, adCmdText
0037: 	If rsm.EOF Then
0038: 	PayPalEmailAddress = "??"
0039: 	Else
0040: 		PayPalEmailAddress = rsm("PayPalEmailAddress").Value
0041: 		VenMo = rsm("VenMo").Value
0042: 		Zelle = rsm("Zelle").Value
0043: 		rsm.Close
0044: 		Set rsm = Nothing	
0045:      End If
0046: 	
0047: 	SendEMailFlag = True	
0048: %>
0049: <html>
0050: 
0051: <head>
0052: <link href="mm.css" rel="stylesheet" type="text/css">
0053: <meta name="viewport" content="width=device-width">
0054: <title>March Madness - Adjust Payout for ties</title>
0055: </head>
0056: 
0057: <body link="#00194C" vlink="#800000" alink="#800000" bgcolor="#ffffff"
0058: onload="document.entry.CheckNo.focus()">
0059: 
0060: <form ACTION="Top10EditPost.asp?ID=<%= ID %>" METHOD="POST" name="entry">
0061:   <table border="0" width="370" cellspacing="1" cellpadding="0">
0062: <tr><td width="45%"></td><td width="55%"></td></tr>
0063: <tr>
0064:       <td height="20" align="right" class="normbold" ><font face="Arial" size="2"
0065:       color="#FF0066">Name:</td>
0066:       <td height="20" align="left" class="normbold" ><big><%= FullName %></td>
0067:     </tr>
0068: <tr>
0069:       <td height="20" align="right" class="normbold" ><font face="Arial" size="2"
0070:       color="#FF0066">Reg Number:</td>
0071:       <td height="20" align="left" class="normbold" width="*"><big><%= RegNumber %></td>
0072:     </tr>
0073:     <tr align="center">
0074:       <td height="25" align="right" class="smallgreen" ><font face="Arial" size="2"
0075:       color="#FF0066"><b>Contest :</b></font> </td>
0076:       <td height="25" align="left" class="smallgreen" ><b><font face="Arial" size="2"><%= Contest %></font></b>&nbsp; </td>
0077:     </tr>
0078:    <tr align="center">
0079:       <td height="25" align="right" class="smallgreen" ><font face="Arial" size="2"
0080:       color="#FF0066"><b>Rank :</b></font> </td>
0081:       <td height="25" align="left" class="smallgreen" ><b><font face="Arial" size="2"><%= Rank %></font></b>&nbsp; </td>
0082:     </tr>
0083: 
0084:    <tr align="center">
0085:       <td height="25" align="right" class="smallgreen" ><font face="Arial" size="2"
0086:       color="#FF0066"><b>Total Amount :</b></font> </td>
0087:       <td height="25" align="left" class="smallgreen" ><b><font face="Arial" size="2"><%= TotalAmt %></font></b>&nbsp; </td>
0088:     </tr>
0089:     <tr align="center">
0090:       <td height="25" align="right" class="smallgreen" ><font face="Arial" size="2" color="#FF0066">
0091: 
0092: 	  <b>PayPal Email :</b></font>
0093: 	  
0094: 	  </td>
0095:       <td height="25" align="left" class="smallgreen" ><font face="Arial" size="2"><b><input
0096:       name="PayPalEmailAddress" size="20" class="norm"
0097:       value="<%= PayPalEmailAddress %>"></b></font>&nbsp;</td>
0098:     </tr>
0099:     <tr align="center">
0100:       <td height="25" align="right" class="smallgreen" ><font face="Arial" size="2" color="#FF0066">
0101: <% if VenMo <> "" Then %>
0102: 
0103: <a target="_blank" href="https://venmo.com/<%= VenMo %>?txn=pay&note=March%20Madness%20Winnings&amount=<%= TotalAmt %>">Link to VenMo</a>
0104: <% Else %>	  
0105: 	  <b>VenMo ID :</b></font> 
0106: <% End If %>	  
0107: 	  </td>
0108:       <td height="25" align="left" class="smallgreen" ><font face="Arial" size="2"><b><input
0109:       name="VenMo" size="20" class="norm"
0110:       value="<%= VenMo %>"></b></font>&nbsp;</td>
0111:     </tr>
0112:     <tr align="center">
0113:       <td height="25" align="right" class="smallgreen" ><font face="Arial" size="2" color="#FF0066">
0114: 
0115: 	  <b>Zelle :</b></font>
0116: 	  
0117: 	  </td>
0118:       <td height="25" align="left" class="smallgreen" ><font face="Arial" size="2"><b><input
0119:       name="Zelle" size="20" class="norm"
0120:       value="<%= Zelle %>"></b></font>&nbsp;</td>
0121:     </tr>
0122:     <tr align="center">
0123:       <td height="25" align="right" class="smallgreen" ><font face="Arial" size="2" color="#FF0066"><b>Split Amount :</b></font> </td>
0124:       <td height="25" align="left" class="smallgreen" ><font face="Arial" size="2"><b><input
0125:       name="Top10Amt" size="7" maxlength="50" class="norm" style="width:54; height:21"
0126:       value="<%= Top10Amt %>"></b></font>&nbsp;</td>
0127:     </tr>
0128:     <tr align="center">
0129:       <td height="25" align="right" class="smallgreen" ><font face="Arial" size="2" color="#FF0066"><b>Donated Amount:</b></font> </td>
0130:       <td height="25" align="left" class="smallgreen" ><font face="Arial" size="2"><b><input
0131:       name="DonatedAmount" size="7" maxlength="50" class="norm" style="width:54; height:21"
0132:       value="<%= DonatedAmount %>"></b></font>&nbsp;</td>
0133:     </tr>
0134: <tr><td colspan="3" class="norm" align="right">(Add "C" at the end of Check#, when it clears)</td></tr>
0135:     <tr align="center">
0136:       <td height="25" align="right" class="smallgreen" ><font face="Arial" size="2" color="#FF0066"><b>Check#:</b></font> </td>
0137:       <td height="25" align="left" class="smallgreen" ><font face="Arial" size="2"><b><input
0138:       name="CheckNo" size="10" maxlength="50" class="norm"    value="<%= CheckNo %>"></b></font>&nbsp;</td>
0139:     </tr>
0140: 
0141: 	   <tr align="center">
0142:       <td  align="right" class="normbold" height="28">Paid Method<font face="Arial"
0143:       size="2" color="#FF0066"><b> :</b></font> </td>
0144:       <td width="832" height="28" align="left" class="smallgreen" colspan="3"><font face="Arial"
0145:       size="2"><b>  	  <select name="PaidMethod" size="1">
0146:         <option selected value=""></option>
0147:         <option value=""></option>
0148:         <option value="PayPal">PayPal</option>
0149:         <option value="VenMo">VenMo</option>
0150:         <option value="FOLGA">FOLGA</option>
0151:         <option value="Zelle">Zelle</option>
0152:         <option value="">Check</option>
0153: 		</select>
0154: 		</td></td>
0155:     </tr>	
0156: 
0157:      <tr align="center">
0158:       <td height="27" align="right" class="normbold" ></td>
0159:       <td height="27" align="left">
0160: 	  <font face="Arial" size="3"><br><input TYPE="submit" VALUE="Post" class="norm"> </font>&nbsp;&nbsp;&nbsp;
0161: 	  &nbsp;<input type="button" value="Go Back" class="norm" onClick="history.back()">
0162: 	  </td>
0163:       <td>&nbsp;</td>
0164:       <td height="27" align="left" class="smallgreen" width="77"></td>
0165:     </tr>
0166:   </table>
0167: </form>
0168: </body>
0169: </html>