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