Count Lines in Pages
Contents of Page: editprizes.asp
Number of Lines: 151
Last Modified: 4/8/2026 8:06:59 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: 	ID = Request.QueryString(("ID"))
0007: 	If user = "" Then Response.Redirect("login.asp?from=editprizes.asp")
0008: 	
0009: Set rs = Server.CreateObject("ADODB.Recordset")
0010: 	sqlString = "SELECT * FROM mmPrizes " & _
0011: 			"WHERE ID = " & ID
0012: 	rs.Open sqlString, conn, adOpenDynamic, adLockOptimistic, adCmdText
0013: 	
0014: 	If rs.EOF Then
0015: ID = 0
0016: Yr = Season
0017:     Else
0018: 		Yr = rs("Season").Value
0019: 		SelSun = rs("SelSunday").Value
0020:         ID = rs("ID").Value
0021:         MainEntries = rs("MainEntries").Value
0022: 		M1 = rs("M1").Value
0023: 		M2 = rs("M2").Value
0024: 		M3 = rs("M3").Value
0025: 		M4 = rs("M4").Value
0026: 		M5 = rs("M5").Value
0027: 		MTop10 = rs("MTop10").Value
0028:         S16Entries = rs("S16Entries").Value
0029: 		S1 = rs("S1").Value
0030: 		S2 = rs("S2").Value
0031: 		S3 = rs("S3").Value
0032: 		S4 = rs("S4").Value
0033: 		S5 = rs("S5").Value
0034: 		STop10 = rs("STop10").Value
0035: 		B1 = rs("B1").Value
0036: 		B2 = rs("B2").Value
0037: 		B3 = rs("B3").Value
0038: 		B4 = rs("B4").Value
0039: 		B5 = rs("B5").Value
0040: 		AmountDonated = rs("AmountDonated").Value	
0041: 		PayPalPayments = rs("PayPalPayments").Value	
0042: 		Participants = rs("Participants").Value	
0043: 		rs.Close
0044:      End If
0045: 		
0046: %>
0047: <html>
0048: 
0049: <head>
0050: <title>March Madness Contest - Update Prize Values</title>
0051: <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
0052: <link href="mm.css" rel="stylesheet" type="text/css">
0053: 
0054: </head>
0055: 
0056: <body bgcolor="#FFFFFF" onLoad="document.node.M1.select()">
0057: 
0058: <form method="post" action="editprizespost.asp" name="node">
0059: 
0060:   <table border="0" cellpadding="1" cellspacing="1" width="400">
0061:   	  <tr>
0062:       <td class="norm" bgcolor="#f8f8f8"><input type="text" name="ID" value="<%= ID %>"  style="height: 22" size="5" class="norm" align="right"></td>
0063:     </tr>
0064: 
0065: 	  <tr>
0066:       <td class="norm" bgcolor="#f8f8f8"><input type="text" name="Season" value="<%= Yr %>"  style="height: 22" size="5" class="norm" align="right"></td>
0067:     </tr>
0068: 	  <tr>
0069:       <td class="norm" bgcolor="#f8f8f8"><input type="text" name="SelSunday" value="<%= SelSun %>"  style="height: 22" size="5" class="norm" align="right"></td>
0070:     </tr>	
0071:     <tr>
0072:       <td class="normbold">Main Contest</td></tr>
0073: 	  <tr>
0074:       <td class="norm" bgcolor="#f8f8f8"><input type="number" name="Participants" value="<%= Participants %>"  style="height: 22" size="5" class="norm" align="right">Participants</td>
0075:     </tr>
0076: 	  <tr>
0077:       <td class="norm" bgcolor="#f8f8f8"><input type="number" name="MainEntries" value="<%= MainEntries %>"  style="height: 22" size="5" class="norm" align="right"> Main Entries</td>
0078:     </tr>
0079: 	  <tr>
0080:       <td class="norm" bgcolor="#f8f8f8"><input type="text" name="M1" value="<%= M1 %>"  style="height: 22" size="5" class="norm" align="right"> 1st</td>
0081:     </tr>
0082:     <tr>
0083:       <td class="norm" bgcolor="#f8f8f8"><input type="text" name="M2" value="<%= M2 %>"  style="height: 22" size="5" class="norm"> 2nd</td>
0084:     </tr>
0085:     <tr>
0086:       <td class="norm" bgcolor="#f8f8f8"><input type="text" name="M3" value="<%= M3 %>"  style="height: 22" size="5" class="norm"> 3rd</td>
0087:     </tr>
0088:     <tr>
0089:       <td class="norm" bgcolor="#f8f8f8"><input type="text" name="M4" value="<%= M4 %>"  style="height: 22" size="5" class="norm"> 4th</td>
0090:     </tr>
0091:     <tr>
0092:       <td class="norm" bgcolor="#f8f8f8"><input type="text" name="M5" value="<%= M5 %>"  style="height: 22" size="5" class="norm"> 5th</td>
0093:     </tr>
0094:     <tr>
0095:       <td class="norm" bgcolor="#f8f8f8"><input type="text" name="MTop10" value="<%= MTop10 %>"  style="height: 22" size="5" class="norm"> Top 10%</td>
0096:     </tr>
0097:     <tr>
0098:       <td class="normbold">Sweet 16 Contest</td></tr>
0099:     </tr>
0100: 	  <tr>
0101:       <td class="norm" bgcolor="#f8f8f8"><input type="text" name="S16Entries" value="<%= S16Entries %>"  style="height: 22" size="5" class="norm" align="right"> S16 Entries</td>
0102:     </tr>
0103: 	  <tr>
0104:       <td class="norm" bgcolor="#f8f8f8"><input type="text" name="S1" value="<%= S1 %>"  style="height: 22" size="5" class="norm" align="right"> 1st</td>
0105:     </tr>
0106:     <tr>
0107:       <td class="norm" bgcolor="#f8f8f8"><input type="text" name="S2" value="<%= S2 %>"  style="height: 22" size="5" class="norm"> 2nd</td>
0108:     </tr>
0109:     <tr>
0110:       <td class="norm" bgcolor="#f8f8f8"><input type="text" name="S3" value="<%= S3 %>"  style="height: 22" size="5" class="norm"> 3rd</td>
0111:     </tr>
0112:     <tr>
0113:       <td class="norm" bgcolor="#f8f8f8"><input type="text" name="S4" value="<%= S4 %>"  style="height: 22" size="5" class="norm"> 4th</td>
0114:     </tr>
0115:     <tr>
0116:       <td class="norm" bgcolor="#f8f8f8"><input type="text" name="S5" value="<%= S5 %>"  style="height: 22" size="5" class="norm"> 5th</td>
0117:     </tr>
0118:     <tr>
0119:       <td class="norm" bgcolor="#f8f8f8"><input type="text" name="STop10" value="<%= STop10 %>"  style="height: 22" size="5" class="norm"> Top 10%</td>
0120:     </tr>
0121:     <tr>
0122:       <td class="normbold">Biggest Loser Contest</td></tr>
0123: 	  <tr>
0124:       <td class="norm" bgcolor="#f8f8f8"><input type="text" name="B1" value="<%= B1 %>"  style="height: 22" size="5" class="norm" align="right"> 1st</td>
0125:     </tr>
0126:     <tr>
0127:       <td class="norm" bgcolor="#f8f8f8"><input type="text" name="B2" value="<%= B2 %>"  style="height: 22" size="5" class="norm"> 2nd</td>
0128:     </tr>
0129:     <tr>
0130:       <td class="norm" bgcolor="#f8f8f8"><input type="text" name="B3" value="<%= B3 %>"  style="height: 22" size="5" class="norm"> 3rd</td>
0131:     </tr>
0132:     <tr>
0133:       <td class="norm" bgcolor="#f8f8f8"><input type="text" name="B4" value="<%= B4 %>"  style="height: 22" size="5" class="norm"> 4th</td>
0134:     </tr>
0135:     <tr>
0136:       <td class="norm" bgcolor="#f8f8f8"><input type="text" name="B5" value="<%= B5 %>"  style="height: 22" size="5" class="norm"> 5th</td>
0137:     </tr>
0138:     <tr>
0139:       <td class="norm" bgcolor="#f8f8f8"><input type="text" name="PayPalPayments" value="<%= PayPalPayments %>"  style="height: 22" size="5" class="norm"> PayPay Payments</td>
0140:     </tr>	
0141:     <tr>
0142:       <td class="norm" bgcolor="#f8f8f8"><input type="text" name="AmountDonated" value="<%= AmountDonated %>"  style="height: 22" size="5" class="norm"> Amount Donated</td>
0143:     </tr>	
0144:     <tr>
0145:       <td class="norm" align="left"><input type="submit" value="Update Prizes" class="norm"> <input
0146:       type="button" value="Cancel" class="norm" onClick="history.back(-1)"></td>
0147:     </tr>
0148:   </table>
0149: </form>
0150: </body>
0151: </html>