Count Lines in Pages
Contents of Page: editprizes.asp
Number of Lines: 143
Last Modified: 4/20/2025 7:31:30 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: 		Participants = rs("Participants").Value
0041: 		rs.Close
0042:      End If
0043: 		
0044: %>
0045: <html>
0046: 
0047: <head>
0048: <title>March Madness Contest - Update Prize Values</title>
0049: <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
0050: <link href="mm.css" rel="stylesheet" type="text/css">
0051: 
0052: </head>
0053: 
0054: <body bgcolor="#FFFFFF" onLoad="document.node.M1.select()">
0055: 
0056: <form method="post" action="editprizespost.asp" name="node">
0057: 
0058:   <table border="0" cellpadding="1" cellspacing="1" width="400">
0059:   	  <tr>
0060:       <td class="norm" bgcolor="#f8f8f8"><input type="text" name="ID" value="<%= ID %>"  style="height: 22" size="5" class="norm" align="right"></td>
0061:     </tr>
0062: 
0063: 	  <tr>
0064:       <td class="norm" bgcolor="#f8f8f8"><input type="text" name="Season" value="<%= Yr %>"  style="height: 22" size="5" class="norm" align="right"></td>
0065:     </tr>
0066: 	  <tr>
0067:       <td class="norm" bgcolor="#f8f8f8"><input type="text" name="SelSunday" value="<%= SelSun %>"  style="height: 22" size="5" class="norm" align="right"></td>
0068:     </tr>	
0069:     <tr>
0070:       <td class="normbold">Main Contest</td></tr>
0071: 	  <tr>
0072:       <td class="norm" bgcolor="#f8f8f8"><input type="number" name="Participants" value="<%= Participants %>"  style="height: 22" size="5" class="norm" align="right">Participants</td>
0073:     </tr>
0074: 	  <tr>
0075:       <td class="norm" bgcolor="#f8f8f8"><input type="number" name="MainEntries" value="<%= MainEntries %>"  style="height: 22" size="5" class="norm" align="right"> Main Entries</td>
0076:     </tr>
0077: 	  <tr>
0078:       <td class="norm" bgcolor="#f8f8f8"><input type="text" name="M1" value="<%= M1 %>"  style="height: 22" size="5" class="norm" align="right"> 1st</td>
0079:     </tr>
0080:     <tr>
0081:       <td class="norm" bgcolor="#f8f8f8"><input type="text" name="M2" value="<%= M2 %>"  style="height: 22" size="5" class="norm"> 2nd</td>
0082:     </tr>
0083:     <tr>
0084:       <td class="norm" bgcolor="#f8f8f8"><input type="text" name="M3" value="<%= M3 %>"  style="height: 22" size="5" class="norm"> 3rd</td>
0085:     </tr>
0086:     <tr>
0087:       <td class="norm" bgcolor="#f8f8f8"><input type="text" name="M4" value="<%= M4 %>"  style="height: 22" size="5" class="norm"> 4th</td>
0088:     </tr>
0089:     <tr>
0090:       <td class="norm" bgcolor="#f8f8f8"><input type="text" name="M5" value="<%= M5 %>"  style="height: 22" size="5" class="norm"> 5th</td>
0091:     </tr>
0092:     <tr>
0093:       <td class="norm" bgcolor="#f8f8f8"><input type="text" name="MTop10" value="<%= MTop10 %>"  style="height: 22" size="5" class="norm"> Top 10%</td>
0094:     </tr>
0095:     <tr>
0096:       <td class="normbold">Sweet 16 Contest</td></tr>
0097:     </tr>
0098: 	  <tr>
0099:       <td class="norm" bgcolor="#f8f8f8"><input type="text" name="S16Entries" value="<%= S16Entries %>"  style="height: 22" size="5" class="norm" align="right"> S16 Entries</td>
0100:     </tr>
0101: 	  <tr>
0102:       <td class="norm" bgcolor="#f8f8f8"><input type="text" name="S1" value="<%= S1 %>"  style="height: 22" size="5" class="norm" align="right"> 1st</td>
0103:     </tr>
0104:     <tr>
0105:       <td class="norm" bgcolor="#f8f8f8"><input type="text" name="S2" value="<%= S2 %>"  style="height: 22" size="5" class="norm"> 2nd</td>
0106:     </tr>
0107:     <tr>
0108:       <td class="norm" bgcolor="#f8f8f8"><input type="text" name="S3" value="<%= S3 %>"  style="height: 22" size="5" class="norm"> 3rd</td>
0109:     </tr>
0110:     <tr>
0111:       <td class="norm" bgcolor="#f8f8f8"><input type="text" name="S4" value="<%= S4 %>"  style="height: 22" size="5" class="norm"> 4th</td>
0112:     </tr>
0113:     <tr>
0114:       <td class="norm" bgcolor="#f8f8f8"><input type="text" name="S5" value="<%= S5 %>"  style="height: 22" size="5" class="norm"> 5th</td>
0115:     </tr>
0116:     <tr>
0117:       <td class="norm" bgcolor="#f8f8f8"><input type="text" name="STop10" value="<%= STop10 %>"  style="height: 22" size="5" class="norm"> Top 10%</td>
0118:     </tr>
0119:     <tr>
0120:       <td class="normbold">Biggest Loser Contest</td></tr>
0121: 	  <tr>
0122:       <td class="norm" bgcolor="#f8f8f8"><input type="text" name="B1" value="<%= B1 %>"  style="height: 22" size="5" class="norm" align="right"> 1st</td>
0123:     </tr>
0124:     <tr>
0125:       <td class="norm" bgcolor="#f8f8f8"><input type="text" name="B2" value="<%= B2 %>"  style="height: 22" size="5" class="norm"> 2nd</td>
0126:     </tr>
0127:     <tr>
0128:       <td class="norm" bgcolor="#f8f8f8"><input type="text" name="B3" value="<%= B3 %>"  style="height: 22" size="5" class="norm"> 3rd</td>
0129:     </tr>
0130:     <tr>
0131:       <td class="norm" bgcolor="#f8f8f8"><input type="text" name="B4" value="<%= B4 %>"  style="height: 22" size="5" class="norm"> 4th</td>
0132:     </tr>
0133:     <tr>
0134:       <td class="norm" bgcolor="#f8f8f8"><input type="text" name="B5" value="<%= B5 %>"  style="height: 22" size="5" class="norm"> 5th</td>
0135:     </tr>
0136:     <tr>
0137:       <td class="norm" align="left"><input type="submit" value="Update Prizes" class="norm"> <input
0138:       type="button" value="Cancel" class="norm" onClick="history.back(-1)"></td>
0139:     </tr>
0140:   </table>
0141: </form>
0142: </body>
0143: </html>