Count Lines in Pages
Contents of Page: setupteamss16.asp
Number of Lines: 193
Last Modified: 3/24/2024 6:44:48 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: 	yr = Request.QueryString("yr")
0008: 	If yr = "" Then yr = season
0009: 
0010: '	Response.Write("noMorePicks=" & noMorePicks & "=")
0011: 	user = Request.Cookies("user")
0012: '	If user = ""  Or (user <> "" And Session("loggedIn") = "") Then Response.Redirect("login.asp?from=biggestloserpick.asp")
0013: 	If user = ""  Then Response.Redirect("login.asp?from=setupteams.asp")
0014: 
0015: 
0016: 
0017: 	Dim Regions(4)
0018: 	
0019: 	Set rsRegion = Server.CreateObject("ADODB.Recordset")
0020: 	sqlString = "SELECT * FROM mmRegionals " & _
0021: 			"WHERE Season = " & yr & " " & _
0022: 			"ORDER By Region"
0023: '			"AND Region = " & region
0024: 	rsRegion.Open sqlString, conn, adOpenStatic, adLockReadOnly, adCmdText
0025: 	If Not rsRegion.EOF Then
0026: 	RGCount = 0
0027: 	Do Until rsRegion.EOF
0028: 		RGCount = RGCount + 1
0029: 		Regions(RGCount) = rsRegion("RegionName").Value
0030: 		rsRegion.MoveNext
0031: 	Loop
0032: 	rsRegion.Close
0033: 	Set rsRegion = Nothing
0034: 
0035: 	End If
0036: 
0037: %>
0038: <html>
0039: 
0040: <head>
0041: <meta http-equiv="Content-Language" content="en-us">
0042: <meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
0043: <link href="mm.css" rel="stylesheet" type="text/css">
0044: <title>March Madness - Set up Sweet 16 Field</title>
0045: </head>
0046: <%	
0047: 
0048: 	Set rst = Server.CreateObject("ADODB.Recordset")
0049: 	sqlString = "SELECT * FROM mm2ndTeams WHERE Season = " & yr
0050: 	rst.Open sqlString, conn, adOpenStatic, adLockReadOnly, adCmdText
0051: 
0052: If rst.EOF Then
0053: ID = 0
0054: Else
0055: ID = rst("ID").Value 
0056: A01 = rst("A01").Value 
0057: A02 = rst("A02").Value 
0058: A03 = rst("A03").Value 
0059: A04 = rst("A04").Value 
0060: A05 = rst("A05").Value 
0061: A06 = rst("A06").Value 
0062: A07 = rst("A07").Value 
0063: A08 = rst("A08").Value 
0064: A09 = rst("A09").Value 
0065: A10 = rst("A10").Value 
0066: A11 = rst("A11").Value 
0067: A12 = rst("A12").Value 
0068: A13 = rst("A13").Value 
0069: A14 = rst("A14").Value 
0070: A15 = rst("A15").Value 
0071: A16 = rst("A16").Value 
0072: 
0073: 
0074: 
0075: End If
0076: %>
0077: 
0078: <body>
0079: <meta name="viewport" content="width=device-width">
0080: <form method="POST" action="setupteamss16post.asp?yr=<%= yr %>&ID=<%= ID %>">
0081: 
0082: <table border="0" cellpadding="0" width="370">
0083:     <tr>
0084: 		<td width="30%" align="right"></td>
0085: 		<td width="20%"  class="bigblue"><big><i><%= Regions(1) %></big></i></td>
0086: 		<td width="50%" align="left"></td>
0087:     </tr>
0088:     <tr>
0089:       <td  align="right" class="normbold">Seed #1 (A##)</td>
0090:       <td   class="norm" height="15"><input type="text" size = "5" name="A01" value="<%= A01 %>"> </td>
0091:       <td   class="norm" height="15"><%= displayTeam(A01) %></td>
0092: 	</tr>
0093:     <tr>
0094:       <td  align="right" class="normbold">Seed #4 (A##)</td>
0095:       <td   class="norm" height="15"><input type="text" size = "5" name="A02" value="<%= A02 %>"></td>
0096:       <td   class="norm" height="15"><%= displayTeam(A02) %></td>
0097: 	</tr>
0098: 	<tr>
0099:       <td  align="right" class="normred">Seed #3 (A##)</td>
0100:       <td   class="normbold"><input type="text" size = "5" name="A03" value="<%= A03 %>"> </td>
0101: 	  <td   class="norm" height="15"><%= displayTeam(A03) %></td>
0102: 	</tr>
0103:     <tr>
0104:       <td  align="right" class="normred">Seed #2 (A##)</td>
0105:       <td   class="normbold"><input type="text" size = "5" name="A04" value="<%= A04 %>"> </td>
0106:       <td   class="norm" height="15"><%= displayTeam(A04) %></td>	
0107: 	</tr>
0108:     <tr>
0109: 		<td width="5%" align="right"></td>
0110: 		<td width="20%"  class="bigblue"><big><i><%= Regions(2) %></big></i></td>
0111: 		<td width="5%" align="right"></td>
0112: 	</tr>
0113:     <tr>
0114:       <td  align="right" class="normbold">Seed #1 (B##)</td>
0115:       <td   class="normbold"><input type="text" size = "5" name="A05" value="<%= A05 %>"> </td>
0116:       <td   class="norm" height="15"><%= displayTeam(A05) %></td>	
0117: 	</tr>
0118:     <tr>
0119:       <td  align="right" class="normbold">Seed #4 (B##)</td>
0120:       <td   class="normbold"><input type="text" size = "5" name="A06" value="<%= A06 %>"> </td>
0121:       <td   class="norm" height="15"><%= displayTeam(A06) %></td>	
0122: 	</tr>
0123:     <tr>
0124:       <td  align="right" class="normred">Seed #3 (B##)</td>
0125:       <td   class="normbold"><input type="text" size = "5"  name="A07" value="<%= A07 %>"> </td>
0126:       <td   class="norm" height="15"><%= displayTeam(A07) %></td>	
0127: 	</tr>
0128:     <tr>
0129:       <td  align="right" class="normred">Seed #2 (B##)</td>
0130:       <td   class="normbold"><input type="text" size = "5"  name="A08" value="<%= A08 %>"> </td>
0131:       <td   class="norm" height="15"><%= displayTeam(A08) %></td>	
0132: 	</tr>
0133:     <tr>
0134: 		<td width="5%" align="right"></td>
0135: 		<td width="20%"  class="bigblue"><big><i><%= Regions(3) %></big></i></td>
0136: 		<td width="5%" align="right"></td>
0137:     </tr>
0138:     <tr>
0139:       <td  align="right" class="normbold" >Seed #1 (C##)</td>
0140:       <td   class="normbold"><input type="text" size = "5"  name="A09" value="<%= A09 %>"> </td>
0141:       <td   class="norm" height="15"><%= displayTeam(A09) %></td>	
0142: 	</tr>
0143:     <tr>
0144:       <td  align="right" class="normbold">Seed #4 (C##)</td>
0145:       <td   class="normbold"><input type="text" size = "5"  name="A10" value="<%= A10 %>"> </td>
0146:       <td   class="norm" height="15"><%= displayTeam(A10) %></td>	
0147: 	</tr>
0148:     <tr>
0149:       <td  align="right" class="normred">Seed #3 (C##)</td>
0150:       <td   class="normbold"><input type="text" size = "5"  name="A11" value="<%= A11 %>"> </td>
0151:       <td   class="norm" height="15"><%= displayTeam(A11) %></td>	
0152: 	</tr>
0153:     <tr>
0154:       <td  align="right" class="normred">Seed #2 (C##)</td>
0155:       <td   class="normbold"><input type="text" size = "5"  name="A12" value="<%= A12 %>"> </td>
0156:       <td   class="norm" height="15"><%= displayTeam(A12) %></td>	
0157: 	</tr>
0158:     <tr>
0159: 		<td width="5%" align="right"></td>
0160: 		<td width="20%"  class="bigblue"><big><i><%= Regions(4) %></big></i></td>
0161: 		<td width="5%" align="right"></td>
0162:     </tr>
0163:     <tr>
0164:       <td  align="right" class="normbold">Seed #1 (D##)</td>
0165:       <td   class="normbold"><input type="text" size = "5"  name="A13" value="<%= A13 %>"> </td>
0166:       <td   class="norm" height="15"><%= displayTeam(A13) %></td>	
0167: 	</tr>
0168:     <tr>
0169:       <td  align="right" class="normbold">Seed #4 (D##)</td>
0170:       <td   class="normbold"><input type="text" size = "5"  name="A14" value="<%= A14 %>"> </td>
0171:       <td   class="norm" height="15"><%= displayTeam(A14) %></td>	
0172: 	</tr>
0173:     <tr>
0174:       <td  align="right" class="normred">Seed #3 (D##)</td>
0175:       <td   class="normbold"><input type="text" size = "5"  name="A15" value="<%= A15 %>"> </td>
0176:       <td   class="norm" height="15"><%= displayTeam(A15) %></td>	
0177: 	</tr>
0178:     <tr>
0179:       <td  align="right" class="normred">Seed #2 (D##)</td>
0180:       <td   class="normbold"><input type="text" size = "5"  name="A16" value="<%= A16 %>"> </td>
0181:       <td   class="norm" height="15"><%= displayTeam(A16) %></td>	
0182: 	</tr>
0183: </table>
0184: <table border="0" cellpadding="0" width="370">
0185: 	<tr><td>&nbsp </td></tr>
0186: 	<tr><td colspan="5"><input type="Submit" value="Submit" name="D1" align="center">
0187: 	<input type="button" value="Cancel" class="norm" onClick="history.back(-1)"></td>
0188: 	</tr>
0189: 	<tr><td class="norm" colspan="4" align="center"><br><br><big><a href="displaymenu.asp?parent=35&title=Initial%20Set%20Up%20Activities">Return to Initial Setup Menu</a></td></tr>
0190:   </table>
0191: </form>
0192: </body>
0193: </html>