Count Lines in Pages
Contents of Page: displayPicks.asp
Number of Lines: 246
Last Modified: 8/22/2018 1:32:41 PM
0001: <% @Language = "VBScript" %>
0002: 
0003: <!-- #include FILE="include/adovbs.inc" -->
0004: <!-- #include FILE="include/constants.inc" -->
0005: <!-- #include FILE="include/funcs.asp" -->
0006: 
0007: <%
0008: 	user = Request.Cookies("user")
0009: 	picksid = Request.QueryString("pick")
0010: 	If user = "" Or (user <> "" And Session("loggedIn") = "") Or picksid = "" Then Response.Redirect("login.asp?from=picks.asp")
0011: 
0012: 	' get all teams selected in this pick
0013: 	Set rsPicks = Server.CreateObject("ADODB.Recordset")
0014: 	sqlString = "SELECT * FROM mmPicks " & _
0015: 							"WHERE ID = " & picksid
0016: 	rsPicks.Open sqlString, conn, adOpenStatic, adLockReadOnly, adCmdText
0017: 	If rsPicks.EOF Then
0018: 		rsPicks.Close
0019: 		Set rsPicks = Nothing
0020: 		Response.Redirect("picks.asp")
0021: 	End If
0022: 	
0023: 	' get regions
0024: 	Set rsRegion = Server.CreateObject("ADODB.Recordset")
0025: 	sqlString = "SELECT * FROM mmRegionals WHERE Season = " & season
0026: 	rsRegion.Open sqlString, conn, adOpenStatic, adLockReadOnly, adCmdText
0027: 	Dim regionArr(5)
0028: 	Do Until rsRegion.EOF
0029: 		regionArr(rsRegion("Region").Value) = rsRegion("RegionName").Value
0030: 		rsRegion.MoveNext
0031: 	Loop
0032: 	rsRegion.Close
0033: 	Set rsRegion = Nothing
0034: 	
0035: 	back = "#fffaf0"
0036: %>
0037: 
0038: <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
0039: 
0040: <html>
0041: <head>
0042: 	<title>March Madness - Display Picks</title>
0043: 	<link href="mm.css" rel="stylesheet" type="text/css">
0044: </head>
0045: 
0046: <body bgcolor="#ffffff">
0047: 
0048: 	<table border="0" cellpadding="2" cellspacing="0" align="center" width="550">
0049: 		<tr>
0050: 			<td class="bigblue">Review Picks</td>
0051: 		</tr>
0052: 		<tr><td class="norm">&nbsp;</td></tr>
0053: 		<tr>
0054: 			<td>
0055: 				<span class="normbold">Entry Name:</span>&nbsp;&nbsp;&nbsp;
0056: 				<span class="norm"><%= rsPicks("EntryName").Value %></span>
0057: 			</td>
0058: 		</tr>
0059: 		<tr><td class="norm">&nbsp;</td></tr>
0060: 
0061: 			<!--- Region 1 --->
0062: 			<tr><td class="medbold" bgcolor="#577fbe"><font color="#eeeeee"><%= regionArr(1) %></font></td></tr>
0063: 			<tr><td class="normbold" bgcolor="<%= back %>">First Round Winners</td></tr>
0064: 			<tr><td height="1" bgcolor="#008000"><spacer type="block"></td></tr>
0065: 			<tr>
0066: 				<td class="norm" align="left">
0067: 					<%= displayTeam(rsPicks("A1").Value) %>,
0068: 					<%= displayTeam(rsPicks("A2").Value) %>,
0069: 					<%= displayTeam(rsPicks("A3").Value) %>,
0070: 					<%= displayTeam(rsPicks("A4").Value) %>,
0071: 					<%= displayTeam(rsPicks("A5").Value) %>,
0072: 					<%= displayTeam(rsPicks("A6").Value) %>,
0073: 					<%= displayTeam(rsPicks("A7").Value) %>,
0074: 					<%= displayTeam(rsPicks("A8").Value) %>
0075: 				</td>
0076: 			</tr>
0077: 			<tr><td class="normbold" bgcolor="<%= back %>">Second Round Winners</td></tr>
0078: 			<tr><td height="1" bgcolor="#008000"><spacer type="block"></td></tr>
0079: 			<tr>
0080: 				<td class="norm" align="left">
0081: 					<%= displayTeam(rsPicks("A9").Value) %>,
0082: 					<%= displayTeam(rsPicks("A10").Value) %>,
0083: 					<%= displayTeam(rsPicks("A11").Value) %>,
0084: 					<%= displayTeam(rsPicks("A12").Value) %>
0085: 				</td>
0086: 			</tr>
0087: 			<tr><td class="normbold" bgcolor="<%= back %>">Regional Winners</td></tr>
0088: 			<tr><td height="1" bgcolor="#008000"><spacer type="block"></td></tr>
0089: 			<tr>
0090: 				<td class="norm" align="left">
0091: 					<%= displayTeam(rsPicks("A13").Value) %>,
0092: 					<%= displayTeam(rsPicks("A14").Value) %>&nbsp;->&nbsp;
0093: 					<%= displayTeam(rsPicks("A15").Value) %>
0094: 				</td>
0095: 			</tr>
0096: 			<tr><td class="norm">&nbsp;</td></tr>
0097: 			<!--- Region 2 --->
0098: 			<tr><td class="medbold" bgcolor="#577fbe"><font color="#eeeeee"><%= regionArr(2) %></font></td></tr>
0099: 			<tr><td class="normbold" bgcolor="<%= back %>">First Round Winners</td></tr>
0100: 			<tr><td height="1" bgcolor="#008000"><spacer type="block"></td></tr>
0101: 			<tr>
0102: 				<td class="norm" align="left">
0103: 					<%= displayTeam(rsPicks("B1").Value) %>,
0104: 					<%= displayTeam(rsPicks("B2").Value) %>,
0105: 					<%= displayTeam(rsPicks("B3").Value) %>,
0106: 					<%= displayTeam(rsPicks("B4").Value) %>,
0107: 					<%= displayTeam(rsPicks("B5").Value) %>,
0108: 					<%= displayTeam(rsPicks("B6").Value) %>,
0109: 					<%= displayTeam(rsPicks("B7").Value) %>,
0110: 					<%= displayTeam(rsPicks("B8").Value) %>
0111: 				</td>
0112: 			</tr>
0113: 			<tr><td class="normbold" bgcolor="<%= back %>">Second Round Winners</td></tr>
0114: 			<tr><td height="1" bgcolor="#008000"><spacer type="block"></td></tr>
0115: 			<tr>
0116: 				<td class="norm" align="left">
0117: 					<%= displayTeam(rsPicks("B9").Value) %>,
0118: 					<%= displayTeam(rsPicks("B10").Value) %>,
0119: 					<%= displayTeam(rsPicks("B11").Value) %>,
0120: 					<%= displayTeam(rsPicks("B12").Value) %>
0121: 				</td>
0122: 			</tr>
0123: 			<tr><td class="normbold" bgcolor="<%= back %>">Regional Winners</td></tr>
0124: 			<tr><td height="1" bgcolor="#008000"><spacer type="block"></td></tr>
0125: 			<tr>
0126: 				<td class="norm" align="left">
0127: 					<%= displayTeam(rsPicks("B13").Value) %>,
0128: 					<%= displayTeam(rsPicks("B14").Value) %>&nbsp;->&nbsp;
0129: 					<%= displayTeam(rsPicks("B15").Value) %>
0130: 				</td>
0131: 			</tr>
0132: 			<tr><td class="norm">&nbsp;</td></tr>
0133: 			<!--- Region 3 --->
0134: 			<tr><td class="medbold" bgcolor="#577fbe"><font color="#eeeeee"><%= regionArr(3) %></font></td></tr>
0135: 			<tr><td class="normbold" bgcolor="<%= back %>">First Round Winners</td></tr>
0136: 			<tr><td height="1" bgcolor="#008000"><spacer type="block"></td></tr>
0137: 			<tr>
0138: 				<td class="norm" align="left">
0139: 					<%= displayTeam(rsPicks("C1").Value) %>,
0140: 					<%= displayTeam(rsPicks("C2").Value) %>,
0141: 					<%= displayTeam(rsPicks("C3").Value) %>,
0142: 					<%= displayTeam(rsPicks("C4").Value) %>,
0143: 					<%= displayTeam(rsPicks("C5").Value) %>,
0144: 					<%= displayTeam(rsPicks("C6").Value) %>,
0145: 					<%= displayTeam(rsPicks("C7").Value) %>,
0146: 					<%= displayTeam(rsPicks("C8").Value) %>
0147: 				</td>
0148: 			</tr>
0149: 			<tr><td class="normbold" bgcolor="<%= back %>">Second Round Winners</td></tr>
0150: 			<tr><td height="1" bgcolor="#008000"><spacer type="block"></td></tr>
0151: 			<tr>
0152: 				<td class="norm" align="left">
0153: 					<%= displayTeam(rsPicks("C9").Value) %>,
0154: 					<%= displayTeam(rsPicks("C10").Value) %>,
0155: 					<%= displayTeam(rsPicks("C11").Value) %>,
0156: 					<%= displayTeam(rsPicks("C12").Value) %>
0157: 				</td>
0158: 			</tr>
0159: 			<tr><td class="normbold" bgcolor="<%= back %>">Regional Winners</td></tr>
0160: 			<tr><td height="1" bgcolor="#008000"><spacer type="block"></td></tr>
0161: 			<tr>
0162: 				<td class="norm" align="left">
0163: 					<%= displayTeam(rsPicks("C13").Value) %>,
0164: 					<%= displayTeam(rsPicks("C14").Value) %>&nbsp;->&nbsp;
0165: 					<%= displayTeam(rsPicks("C15").Value) %>
0166: 				</td>
0167: 			</tr>
0168: 			<tr><td class="norm">&nbsp;</td></tr>
0169: 			<!--- Region 4 --->
0170: 			<tr><td class="medbold" bgcolor="#577fbe"><font color="#eeeeee"><%= regionArr(4) %></font></td></tr>
0171: 			<tr><td class="normbold" bgcolor="<%= back %>">First Round Winners</td></tr>
0172: 			<tr><td height="1" bgcolor="#008000"><spacer type="block"></td></tr>
0173: 			<tr>
0174: 				<td class="norm" align="left">
0175: 					<%= displayTeam(rsPicks("D1").Value) %>,
0176: 					<%= displayTeam(rsPicks("D2").Value) %>,
0177: 					<%= displayTeam(rsPicks("D3").Value) %>,
0178: 					<%= displayTeam(rsPicks("D4").Value) %>,
0179: 					<%= displayTeam(rsPicks("D5").Value) %>,
0180: 					<%= displayTeam(rsPicks("D6").Value) %>,
0181: 					<%= displayTeam(rsPicks("D7").Value) %>,
0182: 					<%= displayTeam(rsPicks("D8").Value) %>
0183: 				</td>
0184: 			</tr>
0185: 			<tr><td class="normbold" bgcolor="<%= back %>">Second Round Winners</td></tr>
0186: 			<tr><td height="1" bgcolor="#008000"><spacer type="block"></td></tr>
0187: 			<tr>
0188: 				<td class="norm" align="left">
0189: 					<%= displayTeam(rsPicks("D9").Value) %>,
0190: 					<%= displayTeam(rsPicks("D10").Value) %>,
0191: 					<%= displayTeam(rsPicks("D11").Value) %>,
0192: 					<%= displayTeam(rsPicks("D12").Value) %>
0193: 				</td>
0194: 			</tr>
0195: 			<tr><td class="normbold" bgcolor="<%= back %>">Regional Winners</td></tr>
0196: 			<tr><td height="1" bgcolor="#008000"><spacer type="block"></td></tr>
0197: 			<tr>
0198: 				<td class="norm" align="left">
0199: 					<%= displayTeam(rsPicks("D13").Value) %>,
0200: 					<%= displayTeam(rsPicks("D14").Value) %>&nbsp;->&nbsp;
0201: 					<%= displayTeam(rsPicks("D15").Value) %>
0202: 				</td>
0203: 			</tr>
0204: 			<tr><td class="norm">&nbsp;</td></tr>
0205: 			<!--- Championship --->
0206: 			<tr><td class="medbold" bgcolor="#577fbe"><font color="#eeeeee">Championship</font></td></tr>
0207: 			<tr><td class="normbold" bgcolor="<%= back %>">Final Four</td></tr>
0208: 			<tr><td height="1" bgcolor="#008000"><spacer type="block"></td></tr>
0209: 			<tr>
0210: 				<td class="norm" align="left">
0211: 					<%= displayTeam(rsPicks("A15").Value) %>,
0212: 					<%= displayTeam(rsPicks("B15").Value) %>,
0213: 					<%= displayTeam(rsPicks("C15").Value) %>,
0214: 					<%= displayTeam(rsPicks("D15").Value) %>
0215: 				</td>
0216: 			</tr>
0217: 			<tr><td class="normbold" bgcolor="<%= back %>">Semifinalists</td></tr>
0218: 			<tr><td height="1" bgcolor="#008000"><spacer type="block"></td></tr>
0219: 			<tr>
0220: 				<td class="norm" align="left">
0221: 					<%= displayTeam(rsPicks("S1").Value) %>,
0222: 					<%= displayTeam(rsPicks("S2").Value) %>
0223: 				</td>
0224: 			</tr>
0225: 			<tr><td class="normbold" bgcolor="<%= back %>">Champion</td></tr>
0226: 			<tr><td height="1" bgcolor="#008000"><spacer type="block"></td></tr>
0227: 			<tr>
0228: 				<td class="norm" align="left">
0229: 					<%= displayTeam(rsPicks("F1").Value) %>
0230: 				</td>
0231: 			</tr>
0232: 			<tr>
0233: 				<td class="norm" align="center">
0234: 					<input type="button" value="Print" class="norm" onClick="window.print()">&nbsp;&nbsp;&nbsp;
0235: 					<input type="button" value="Return" class="norm" onClick="history.back()">
0236: 				</td>
0237: 			</tr>
0238: 	</table>
0239: 
0240: </body>
0241: </html>
0242: 
0243: <%
0244: 	rsPicks.Close
0245: 	Set rsPicks = Nothing
0246: %>