Count Lines in Pages
Contents of Page: display2ndPicks.aspo
Number of Lines: 292
Last Modified: 8/22/2018 1:32:40 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: 	yyear = Request.QueryString("year")
0009: If yyear <> "" Then
0010: season = yyear
0011: End If
0012: 	picksid = Request.QueryString("pick")
0013: '	If user = "" Or (user <> "" And Session("loggedIn") = "") Or picksid = "" Then Response.Redirect("wclogin.asp?from=picks.asp")
0014: 
0015: 	' get all teams selected in this pick
0016: 	Set rsPicks = Server.CreateObject("ADODB.Recordset")
0017: 	sqlString = "SELECT * FROM mm2ndPicks " & _
0018: 							"WHERE ID = " & picksid 
0019: '							"AND Season = " & season
0020: 	rsPicks.Open sqlString, conn, adOpenStatic, adLockReadOnly, adCmdText
0021: 	If rsPicks.EOF Then
0022: 		rsPicks.Close
0023: 		Set rsPicks = Nothing
0024: 		Response.Redirect("standings.asp")
0025: 	End If
0026: 	
0027: 	Email = rsPicks("EmailAddress").Value
0028: 	CurrPts = rsPicks("FPts").Value
0029: 	PossPts = rsPicks("Poss_Pts").Value
0030: 	
0031: 	Set rsEntry = Server.CreateObject("ADODB.Recordset")
0032:     	sqlString = "SELECT * FROM mmEntries " & _
0033: 							"WHERE EmailAddress = '" & Email & "' " & _
0034: 							"AND Season = " & season
0035: 	rsEntry.Open sqlString, conn, adOpenStatic, adLockReadOnly, adCmdText
0036: 	If Not rsEntry.EOF Then
0037: '	Response.Write("<BR>" & rsEntry("City").Value)
0038: 		CitySt = rsEntry("City").Value & ", " & rsEntry("State").Value
0039: 		Name = rsEntry("Name").Value
0040:     	FirstName = rsEntry("FirstName").Value
0041:  '   	Country = rsEntry("Country").Value
0042: 	End If
0043:    	rsEntry.Close
0044: 	Set rsEntry = Nothing
0045: 	
0046: 	Set rs2Teams = Server.CreateObject("ADODB.Recordset")
0047: 	sqlString = "SELECT * FROM mm2ndTeams WHERE Season = " & season
0048: 	rs2Teams.Open sqlString, conn, adOpenStatic, adLockReadOnly, adCmdText
0049: 
0050: 
0051: A01Seed = Right(rs2Teams("A01").Value, 2) + 0
0052: A02Seed = Right(rs2Teams("A02").Value, 2) + 0
0053: A03Seed = Right(rs2Teams("A03").Value, 2) + 0
0054: A04Seed = Right(rs2Teams("A04").Value, 2) + 0
0055: A05Seed = Right(rs2Teams("A05").Value, 2) + 0
0056: A06Seed = Right(rs2Teams("A06").Value, 2) + 0
0057: A07Seed = Right(rs2Teams("A07").Value, 2) + 0
0058: A08Seed = Right(rs2Teams("A08").Value, 2) + 0
0059: A09Seed = Right(rs2Teams("A09").Value, 2) + 0
0060: A10Seed = Right(rs2Teams("A10").Value, 2) + 0
0061: A11Seed = Right(rs2Teams("A11").Value, 2) + 0
0062: A12Seed = Right(rs2Teams("A12").Value, 2) + 0
0063: A13Seed = Right(rs2Teams("A13").Value, 2) + 0
0064: A14Seed = Right(rs2Teams("A14").Value, 2) + 0
0065: A15Seed = Right(rs2Teams("A15").Value, 2) + 0
0066: A16Seed = Right(rs2Teams("A16").Value, 2) + 0
0067: 
0068: G1Seed = Right(rsPicks("A1").Value, 2) + 0
0069: G2Seed = Right(rsPicks("A2").Value, 2) + 0
0070: G3Seed = Right(rsPicks("A3").Value, 2) + 0
0071: G4Seed = Right(rsPicks("A4").Value, 2) + 0
0072: G5Seed = Right(rsPicks("A5").Value, 2) + 0
0073: G6Seed = Right(rsPicks("A6").Value, 2) + 0
0074: G7Seed = Right(rsPicks("A7").Value, 2) + 0
0075: G8Seed = Right(rsPicks("A8").Value, 2) + 0
0076: G9Seed = Right(rsPicks("A9").Value, 2) + 0
0077: G10Seed = Right(rsPicks("A10").Value, 2) + 0
0078: G11Seed = Right(rsPicks("A11").Value, 2) + 0
0079: G12Seed = Right(rsPicks("A12").Value, 2) + 0
0080: G13Seed = Right(rsPicks("A13").Value, 2) + 0
0081: G14Seed = Right(rsPicks("A14").Value, 2) + 0
0082: G15Seed = Right(rsPicks("A15").Value, 2) + 0
0083: 
0084: 	back = "#fffaf0"
0085: 	
0086: %>
0087: 
0088: <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
0089: 
0090: <html>
0091: <head>
0092: 	<title>March Madness - Display Picks</title>
0093: 	<link href="../ncaa/mm.css" rel="stylesheet" type="text/css">
0094: </head>
0095: 
0096: <body bgcolor="#ffffff">
0097: 
0098: 	<div align="center">
0099: 
0100: <table border="0" width="95%" id="table1">
0101: 	<tr>
0102: 		<td  colspan="5"><span class="normbold">Entry Name:</span>&nbsp;&nbsp;
0103: 				<span class="norm"><%= rsPicks("EntryName").Value %>&nbsp;&nbsp;&nbsp;<span class="normbold">Actual Name:&nbsp;&nbsp;</span><%= FirstName %>&nbsp;<%= Name %>&nbsp;&nbsp;&nbsp;</span><span class="normbold">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
0104: 		</span>
0105: 				<span class="norm"><span class="normbold"><br>
0106: 		City, St:&nbsp;&nbsp;</span><%= CitySt %>
0107: 			</td>
0108: 		<td colspan="2"><span class="normbold">Curr 
0109: 		Points:</span>&nbsp;<span class="norm"><%= CurrPts %></span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
0110: 		<span class="normbold"><br>
0111: 		Poss Points:</span>&nbsp;<span class="norm"><%= PossPts %></span></td></td>
0112: 	</tr>
0113: 	<tr>
0114: 		<td class="normbold" bgcolor="#FFFFFF" align="center" width="95%" colspan="7">&nbsp;</td>
0115: 	</tr>
0116: 	<tr>
0117: 		<td class="normbold" bgcolor="#FFFFFF" align="center" width="25"><i><b>
0118: 		<font size="1" color="#808080">
0119: 		Seed</font></b></i></td>
0120: 		<td class="normbold" bgcolor="#FFFFFF" align="center" width="120"><i><b>
0121: 		<font color="#808080">&quot;Sweet 16&quot;</font></b></i></td>
0122: 		<td class="normbold" bgcolor="#FFFFFF" align="center" width="120"><b><i>
0123: 		<font size="2" color="#808080">(1 Point)</font></i></b></td>
0124: 		<td align="center" width="120"><b><i><font size="2" color="#808080">(2 Points)</font></i></b></td>
0125: 		<td align="center" width="120"><b><i><font size="2" color="#808080">(4 Points)</font></i></b></td>
0126: 		<td align="center" width="120">
0127: 		<b><i>
0128: 		<font size="2" color="#808080">(8 Points)</font></i></b></td>
0129: 		<td align="center" width="24">
0130: 		&nbsp;</td>
0131: 	</tr>
0132: 	<tr>
0133: 		<td width="25" align="right"><b>
0134: 		<font face="Arial" size="2"><%= A01Seed %></font></b></td>
0135: 		<td class="normbold" bgcolor="#C0C0C0" width="106"><font size="2">&nbsp;<%= displayTeam(rs2Teams("A01").Value) %></font></td>
0136: 		<td class="normbold" bgcolor="#C0C0C0" rowspan="2" height="20" width="95"><font size="2">&nbsp;(<%= G1Seed %>)&nbsp;<%= displayTeamFont(rsPicks("A1").Value,"F8Pts",Season) %></font></td>
0137: 		<td rowspan="2" height="20" width="110">&nbsp;</td>
0138: 		<td rowspan="2" height="20" width="119">
0139: 		<p align="center">
0140: 					<input type="button" value="Print" class="norm" onClick="window.print()"></td>
0141: 		<td width="112" rowspan="2" height="20">
0142: 		<p align="center">
0143: 					<input type="button" value="Go Back" class="norm" onClick="history.back()" style="float: right"></td>
0144: 		<td width="24" rowspan="2" height="20">
0145: 		&nbsp;</td>
0146: 	</tr>
0147: 	<tr>
0148: 		<td width="25"align="right"><b>
0149: 		<font face="Arial" size="2"><%= A02Seed %></font></b></td>
0150: 		<td class="normbold" bgcolor="#C0C0C0" width="106"><font size="2">&nbsp;<%= displayTeam(rs2Teams("A02").Value) %></font></td>
0151: 	</tr>
0152: 	<tr>
0153: 		<td width="25" align="right"><b>
0154: 		<font face="Arial" size="2"><%= A03Seed %></font></b></td>
0155: 		<td class="normbold" bgcolor="#C0C0C0" width="106"><font size="2">&nbsp;<%= displayTeam(rs2Teams("A03").Value) %></font></td>
0156: 		<td class="normbold" bgcolor="#EEEEEE" rowspan="2" height="20" width="95"><font size="2">&nbsp;(<%= G2Seed %>)&nbsp;<%= displayTeamFont(rsPicks("A2").Value,"F8Pts",Season) %></font></td>
0157: 		<td class="normbold" bgcolor="#C0C0C0" rowspan="2" height="20" width="110">
0158: 		<font size="2">&nbsp;(<%= G9Seed %>)&nbsp;<%= displayTeamFont(rsPicks("A9").Value,"F4Pts",Season) %></font></td>
0159: 		<td rowspan="2" height="20" width="105">&nbsp;</td>
0160: 		<td rowspan="2" height="20" width="119">&nbsp;</td>
0161: 		<td width="24" rowspan="2" height="20">&nbsp;</td>
0162: 	</tr>
0163: 	<tr>
0164: 		<td width="25"align="right"><b>
0165: 		<font face="Arial" size="2"><%= A04Seed %></font></b></td>
0166: 		<td class="normbold" bgcolor="#C0C0C0" width="106"><font size="2">&nbsp;<%= displayTeam(rs2Teams("A04").Value) %></font></td>
0167: 	</tr>
0168: 	<tr>
0169: 		<td width="25" align="right"><b>
0170: 		<font face="Arial" size="2"><%= A05Seed %></font></b></td>
0171: 		<td width="106" bgcolor="#EEEEEE"><font size="2">&nbsp;<%= displayTeam(rs2Teams("A05").Value) %></font></td>
0172: 		<td rowspan="2" height="20" width="95" bgcolor="#C0C0C0"><font size="2">&nbsp;(<%= G3Seed %>)&nbsp;<%= displayTeamFont(rsPicks("A3").Value, "F8Pts",Season) %></font></td>
0173: 		<td rowspan="2" height="20" width="110">&nbsp;</td>
0174: 		<td class="normbold" bgcolor="#C0C0C0" rowspan="2" height="20" width="105">
0175: 		<font size="2">&nbsp;(<%= G13Seed %>)&nbsp;<%= displayTeamFont(rsPicks("A13").Value,"F2Pts",Season) %></font></td>
0176: 		<td rowspan="2" height="20" width="119">&nbsp;</td>
0177: 		<td width="24" rowspan="2" height="20">&nbsp;</td>
0178: 	</tr>
0179: 	<tr>
0180: 		<td width="25"align="right"><b>
0181: 		<font face="Arial" size="2"><%= A06Seed %></font></b></td>
0182: 		<td width="106" bgcolor="#EEEEEE"><font size="2">&nbsp;<%= displayTeam(rs2Teams("A06").Value) %></font></td>
0183: 	</tr>
0184: 	<tr>
0185: 		<td width="25" align="right"><b>
0186: 		<font face="Arial" size="2"><%= A07Seed %></font></b></td>
0187: 		<td width="106" bgcolor="#EEEEEE"><font size="2">&nbsp;<%= displayTeam(rs2Teams("A07").Value) %></font></td>
0188: 		<td rowspan="2" height="20" width="95" bgcolor="#EEEEEE"><font size="2">&nbsp;(<%= G4Seed %>)&nbsp;<%= displayTeamFont(rsPicks("A4").Value,"F8Pts",Season) %></font></td>
0189: 		<td class="normbold" bgcolor="#C0C0C0" rowspan="2" height="20" width="110">
0190: 		<font size="2">&nbsp;(<%= G10Seed %>)&nbsp;<%= displayTeamFont(rsPicks("A10").Value,"F4Pts",Season) %></font></td>
0191: 		<td rowspan="2" height="20" width="105">&nbsp;</td>
0192: 		<td rowspan="2" height="20" width="119">&nbsp;</td>
0193: 		<td width="24" rowspan="2" height="20">&nbsp;</td>
0194: 	</tr>
0195: 	<tr>
0196: 		<td width="25"align="right"><b>
0197: 		<font face="Arial" size="2"><%= A08Seed %></font></b></td>
0198: 		<td width="106" bgcolor="#EEEEEE"><font size="2">&nbsp;<%= displayTeam(rs2Teams("A08").Value) %></font></td>
0199: 	</tr>
0200: 	<tr>
0201: 		<td width="25" align="right"><b>
0202: 		<font face="Arial" size="2"><%= A09Seed %></font></b></td>
0203: 		<td class="normbold" bgcolor="#C0C0C0" width="106"><font size="2">&nbsp;<%= displayTeam(rs2Teams("A09").Value) %></font></td>
0204: 		<td class="normbold" bgcolor="#C0C0C0" rowspan="2" height="20" width="95"><font size="2">&nbsp;(<%= G5Seed %>)&nbsp;<%= displayTeamFont(rsPicks("A5").Value,"F8Pts",Season) %></font></td>
0205: 		<td rowspan="2" height="20" width="110">&nbsp;</td>
0206: 		<td rowspan="2" height="20" width="105">&nbsp;</td>
0207: 		<td class="normbold" bgcolor="#C0C0C0" rowspan="2" height="20" width="119">
0208: 		<font size="2">&nbsp;(<%= G15Seed %>)&nbsp;<%= displayTeamFont(rsPicks("A15").Value,"F1Pts",Season) %></font></td>
0209: 		<td width="24" rowspan="2" height="20">&nbsp;</td>
0210: 	</tr>
0211: 	<tr>
0212: 		<td width="25"align="right"><b>
0213: 		<font face="Arial" size="2"><%= A10Seed %></font></b></td>
0214: 		<td class="normbold" bgcolor="#C0C0C0" width="106"><font size="2">&nbsp;<%= displayTeam(rs2Teams("A10").Value) %></font></td>
0215: 	</tr>
0216: 	<tr>
0217: 		<td width="25" align="right"><b>
0218: 		<font face="Arial" size="2"><%= A11Seed %></font></b></td>
0219: 		<td class="normbold" bgcolor="#C0C0C0" width="106"><font size="2">&nbsp;<%= displayTeam(rs2Teams("A11").Value) %></font></td>
0220: 		<td class="normbold" bgcolor="#EEEEEE" rowspan="2" height="20" width="120"><font size="2">&nbsp;(<%= G6Seed %>)&nbsp;<%= displayTeamFont(rsPicks("A6").Value,"F8Pts",Season) %></font></td>
0221: 		<td class="normbold" bgcolor="#C0C0C0" rowspan="2" height="20" width="110">
0222: 		<font size="2">&nbsp;(<%= G11Seed %>)&nbsp;<%= displayTeamFont(rsPicks("A11").Value,"F4Pts",Season) %></font></td>
0223: 		<td rowspan="2" height="20" width="105">&nbsp;</td>
0224: 		<td rowspan="2" height="20" width="119">&nbsp;</td>
0225: 		<td width="24" rowspan="2" height="20">&nbsp;</td>
0226: 	</tr>
0227: 	<tr>
0228: 		<td width="25"align="right"><b>
0229: 		<font face="Arial" size="2"><%= A12Seed %></font></b></td>
0230: 		<td class="normbold" bgcolor="#C0C0C0" width="106"><font size="2">&nbsp;<%= displayTeam(rs2Teams("A12").Value) %></font></td>
0231: 	</tr>
0232: 	<tr>
0233: 		<td width="25" align="right"><b>
0234: 		<font face="Arial" size="2"><%= A13Seed %></font></b></td>
0235: 		<td width="106" bgcolor="#EEEEEE"><font size="2">&nbsp;<%= displayTeam(rs2Teams("A13").Value) %></font></td>
0236: 		<td rowspan="2" height="20" width="95" bgcolor="#C0C0C0"><font size="2">&nbsp;(<%= G7Seed %>)&nbsp;<%= displayTeamFont(rsPicks("A7").Value, "F8Pts",Season) %></font></td>
0237: 		<td rowspan="2" height="20" width="110">&nbsp;</td>
0238: 		<td class="normbold" bgcolor="#C0C0C0" rowspan="2" height="20" width="105">
0239: 		<font size="2">&nbsp;(<%= G14Seed %>)&nbsp;<%= displayTeamFont(rsPicks("A14").Value,"F2Pts",Season) %></font></td>
0240: 		<td rowspan="2" height="20" width="119">&nbsp;</td>
0241: 		<td width="24" rowspan="2" height="20">&nbsp;</td>
0242: 	</tr>
0243: 	<tr>
0244: 		<td width="25"align="right"><b>
0245: 		<font face="Arial" size="2"><%= A14Seed %></font></b></td>
0246: 		<td width="106" bgcolor="#EEEEEE"><font size="2">&nbsp;<%= displayTeam(rs2Teams("A14").Value) %></font></td>
0247: 	</tr>
0248: 	<tr>
0249: 		<td width="25" align="right"><b>
0250: 		<font face="Arial" size="2"><%= A15Seed %></font></b></td>
0251: 		<td width="106" bgcolor="#EEEEEE"><font size="2">&nbsp;<%= displayTeam(rs2Teams("A15").Value) %></font></td>
0252: 		<td rowspan="2" height="20" width="95" bgcolor="#EEEEEE"><font size="2">&nbsp;(<%= G8Seed %>)&nbsp;<%= displayTeamFont(rsPicks("A8").Value,"F8Pts",Season) %></font></td>
0253: 		<td class="normbold" bgcolor="#C0C0C0" rowspan="2" height="20" width="110">
0254: 		<font size="2">&nbsp;(<%= G12Seed %>)&nbsp;<%= displayTeamFont(rsPicks("A12").Value,"F4Pts",Season) %></font></td>
0255: 		<td rowspan="2" height="20" width="105">&nbsp;</td>
0256: 		<td rowspan="2" height="20" width="119">&nbsp;</td>
0257: 		<td width="24" rowspan="2" height="20">&nbsp;</td>
0258: 	</tr>
0259: 	<tr>
0260: 		<td width="25"align="right"><b>
0261: 		<font face="Arial" size="2"><%= A16Seed %></font></b></td>
0262: 		<td width="106" bgcolor="#EEEEEE"><font size="2">&nbsp;<%= displayTeam(rs2Teams("A16").Value) %></font></td>
0263: 	</tr>
0264: 	<tr>
0265: 		<td width="25">&nbsp;</td>
0266: 		<td width="106">&nbsp;</td>
0267: 		<td>&nbsp;</td>
0268: 		<td>&nbsp;</td>
0269: 		<td>&nbsp;</td>
0270: 		<td>&nbsp;</td>
0271: 		<td>&nbsp;</td>
0272: 	</tr>
0273: 	<tr>
0274: 		<td width="25">&nbsp;</td>
0275: 		<td width="106">&nbsp;</td>
0276: 		<td colspan="5"><i><font color="#FF0000"><strike><b>CrossedRed</b></strike></font> 
0277: 		= Lost Pick, <b><font color="#008000">Green </font></b>= Correct Pick, <b>
0278: 		<font color="#0000FF">Blue</font></b> = Still in the running.</i></td>
0279: 	</tr>
0280: </table>
0281: 
0282: 	</div>
0283: 
0284: </body>
0285: </html>
0286: 
0287: <%
0288: 	rsPicks.Close
0289: 	Set rsPicks = Nothing
0290: 	rs2Teams.Close
0291: 	Set rs2Teams = Nothing		
0292: %>