Count Lines in Pages
Contents of Page: picks2.asp
Number of Lines: 344
Last Modified: 2/12/2025 10:21:02 AM
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: 	If user = ""  Then Response.Redirect("login.asp?from=picks.asp")
0010: 
0011: 	lineColor = "#cccccc"
0012: 
0013: 	' get data
0014: '	Set rsFinal = Server.CreateObject("ADODB.Recordset")
0015: '	sqlString = "SELECT * FROM mmFinals " & _
0016: '			"WHERE Season = " & season
0017: '	rsFinal.Open sqlString, conn, adOpenStatic, adLockReadOnly, adCmdText
0018: '	finalVenue = rsFinal("FinalVenue").Value
0019: '	finalDate = rsFinal("FinalDate").Value
0020: '	semiFinal1Venue = rsFinal("SemiFinal1Venue").Value
0021: '	semiFinal1Date = rsFinal("SemiFinal1Date").Value
0022: '	semiFinal2Venue = rsFinal("SemiFinal2Venue").Value
0023: '	semiFinal2Date = rsFinal("SemiFinal2Date").Value
0024: '	rsFinal.Close
0025: '	Set rsFinal = Nothing
0026: 
0027: 	Set rsPicks = Server.CreateObject("ADODB.Recordset")
0028: 	sqlString = "SELECT A15, B15, C15, D15 FROM mmPicks " & _
0029: 			"WHERE Season = " & season & " "  & _
0030: 			"AND EmailAddress = '" & user & "' " & _
0031: 			"AND Complete = 'No'"
0032: 	rsPicks.Open sqlString, conn, adOpenStatic, adLockReadOnly, adCmdText
0033: 	A15 = rsPicks("A15").Value
0034: 	B15 = rsPicks("B15").Value
0035: 	C15 = rsPicks("C15").Value
0036: 	D15 = rsPicks("D15").Value
0037: 	rsPicks.Close
0038: 	Set rsPicks = Nothing
0039: 
0040: 	Set rsEntry = Server.CreateObject("ADODB.Recordset")
0041: 	sqlString = "SELECT Name, FirstName, RegNumber FROM mmEntries " & _
0042: 			"WHERE Season = " & season & " "  & _
0043: 			"AND EmailAddress = '" & user & "' "  
0044: 	rsEntry.Open sqlString, conn, adOpenStatic, adLockReadOnly, adCmdText
0045: 	lastName = rsEntry("Name").Value
0046: 	firstName = rsEntry("FirstName").Value
0047: 	RegNumber = rsEntry("RegNumber").Value	
0048: 	rsEntry.Close
0049: 	Set rsEntry = Nothing
0050: 	entry = firstName & " " & lastName
0051: 
0052: 
0053: '===========================================================
0054: 		Set rspc = Server.CreateObject("ADODB.Recordset")
0055: 
0056: 	sqlString = "SELECT COUNT(Season) as RecordCount FROM mmPicks " & _
0057: 							"WHERE EmailAddress = '" & user & "' " & _
0058: 							"AND Season = " & season & " " & _
0059: 							"AND Complete = 'Yes'"
0060: 	rspc.Open sqlString, conn, adOpenStatic, adLockReadOnly, adCmdText
0061: 
0062: 	totPicks = CInt(rspc("RecordCount").Value)
0063: 
0064: 	If TotPicks > 1 Then
0065: 	ThisPickNo = Entry & " #" & (TotPicks + 1)
0066: 	Else
0067: 	ThisPickNo = Entry
0068: 	End If
0069: 
0070: 
0071: 
0072: '===========================================================
0073: %>
0074: 
0075: <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
0076: 
0077: <html>
0078: <head>
0079: <title>March Madness - Final Picks</title>
0080: 	<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
0081: 	<link href="mm.css" rel="stylesheet" type="text/css">
0082: 	<link href="https://mychinodes.org/desb.css" rel="stylesheet" type="text/css">	
0083: 	<script language="JavaScript">
0084: 
0085: 		var finalist = new Array();
0086: 		finalist[1] = "<%= A15 %>";
0087: 		finalist[2] = "<%= B15 %>";
0088: 		finalist[3] = "<%= C15 %>";
0089: 		finalist[4] = "<%= D15 %>";
0090: 
0091: 		function rSelect(game)	{
0092: 			var form = document.finalpicks;
0093: 			if (game == "semi1")	{
0094: 				form.semi1.style.backgroundColor = "#FED87B";
0095: 				form.semi2.style.backgroundColor = "";
0096: 				form.final1.style.backgroundColor = "";
0097: 				form.final2.style.backgroundColor = "";
0098: 				form.champion.style.backgroundColor = "";
0099: 				form.semi1.blur();
0100: 				form.final1.value = form.semi1.value;
0101: 				form.S1.value = finalist[1];
0102: 				form.champion.value = '';
0103: 			}
0104: 			if (game == "semi2")	{
0105: 				form.semi1.style.backgroundColor = "";
0106: 				form.semi2.style.backgroundColor = "#FED87B";
0107: 				form.final1.style.backgroundColor = "";
0108: 				form.final2.style.backgroundColor = "";
0109: 				form.champion.style.backgroundColor = "";
0110: 				form.semi2.blur();
0111: 				form.final1.value = form.semi2.value;
0112: 				form.S1.value = finalist[2];
0113: 				form.champion.value = '';
0114: 			}
0115: 			if (game == "semi3")	{
0116: 				form.semi3.style.backgroundColor = "#FED87B";
0117: 				form.semi4.style.backgroundColor = "";
0118: 				form.final1.style.backgroundColor = "";
0119: 				form.final2.style.backgroundColor = "";
0120: 				form.champion.style.backgroundColor = "";
0121: 				form.semi3.blur();
0122: 				form.final2.value = form.semi3.value;
0123: 				form.S2.value = finalist[3];
0124: 				form.champion.value = '';
0125: 			}
0126: 			if (game == "semi4")	{
0127: 				form.semi3.style.backgroundColor = "";
0128: 				form.semi4.style.backgroundColor = "#FED87B";
0129: 				form.final1.style.backgroundColor = "";
0130: 				form.final2.style.backgroundColor = "";
0131: 				form.champion.style.backgroundColor = "";
0132: 				form.semi4.blur();
0133: 				form.final2.value = form.semi4.value;
0134: 				form.S2.value = finalist[4];
0135: 				form.champion.value = '';
0136: 			}
0137: 			if (game == "final1")	{
0138: 				form.final1.style.backgroundColor = "";
0139: 				form.final2.style.backgroundColor = "";
0140: 				form.champion.style.backgroundColor = "#FED87B";
0141: 				form.final1.blur();
0142: 				form.champion.value = form.final1.value;
0143: 				form.F1.value = form.S1.value;
0144: 			}
0145: 			if (game == "final2")	{
0146: 				form.final1.style.backgroundColor = "";
0147: 				form.final2.style.backgroundColor = "";
0148: 				form.champion.style.backgroundColor = "#FED87B";
0149: 				form.final2.blur();
0150: 				form.champion.value = form.final2.value;
0151: 				form.F1.value = form.S2.value;
0152: 			}
0153: 		}
0154: 		
0155: 		function checkSel()	{
0156: 			var form = document.finalpicks;
0157: 			if (form.entryname.value == "")	{
0158: 				alert("Please entry a name for your team");
0159: 				form.entryname.select();
0160: 				return false;
0161: 			}
0162: 			for (i = 0; i < form.elements.length; i++)	{
0163: 				if (form.elements[i].type == "hidden" && form.elements[i].value == "")	{
0164: 					alert("Please select all the winners before submitting picks");
0165: 					return false;
0166: 				}
0167: 			}
0168: 			return true;		
0169: 		}
0170: 		
0171: 	</script>
0172: </head>
0173: 
0174: <body bgcolor="#ffffff" onload="document.finalpicks.entryname.select()">
0175: 
0176: <form name="finalpicks" method="post" action="picks_saveFinal.asp" onsubmit="return checkSel()">	
0177:   <input type="hidden" name="RegNumber" value="<%= RegNumber %>">
0178: 	<table width="572" border="0" cellpadding="0" cellspacing="0" valign="center">
0179: 	    <tr><td>&nbsp;</td></tr>
0180: 		<tr><td>&nbsp;</td></tr>
0181: 		<tr><td align="center" colspan="13" class="bigblue"><%= season %> NCAA Division I Men's Basketball Championship</td></tr>
0182: 		<tr><td>&nbsp;</td>	</tr>
0183: 		<tr><td align="center" colspan="13" class="bigblue"><big>Final Four</td></tr>
0184: 	    <tr><td>&nbsp;</td></tr>
0185: 		<tr><td align="center" colspan="13" class="space">&nbsp;</td></tr>
0186: 			<tr>
0187: 			<td width="150" align="center" class="normbold"><%= displayRegion(1) %></td>
0188: 			<td width="5"><img src="images/clear.gif" height="1" width="1"></td>
0189: 			<td width="1"><img src="images/clear.gif" height="1" width="1"></td>
0190: 			<td width="5"><img src="images/clear.gif" height="1" width="1"></td>
0191: 			<td width="50" class="normbold">&nbsp;</td>
0192: 			<td width="50" class="normbold">&nbsp;</td>
0193: 			<td width="50" class="normbold">&nbsp;</td>
0194: 			<td width="50" class="normbold">&nbsp;</td>
0195: 			<td width="50" class="normbold">&nbsp;</td>
0196: 			<td width="5"><img src="images/clear.gif" height="1" width="1"></td>
0197: 			<td width="1"><img src="images/clear.gif" height="1" width="1"></td>
0198: 			<td width="5"><img src="images/clear.gif" height="1" width="1"></td>
0199: 			<td width="150" align="center" class="normbold"><%= displayRegion(3) %></td>
0200: 		</tr>
0201: 		<tr>
0202: 			<td rowspan="3">
0203: 				<input type="text" name="semi1" value="<%= displayTeam(A15) %>" style="text-align:center;width:150;" onFocus="rSelect('semi1')">
0204: 			</td>
0205: 			<td colspan="11">&nbsp;</td>
0206: 			<td rowspan="3">
0207: 				<input type="text" name="semi3" value="<%= displayTeam(C15) %>" style="text-align:center;width:150;" onFocus="rSelect('semi3')">
0208: 			</td>
0209: 		</tr>
0210: 		<tr>
0211: 			<td height="1" bgcolor="<%= linecolor %>"><img src="images/clear.gif" height="1" width="1"></td>
0212: 			<td rowspan="15" bgcolor="<%= linecolor %>"><img src="images/clear.gif" height="1" width="1"></td>
0213: 			<td colspan="7"><img src="images/clear.gif" height="1" width="1"></td>
0214: 			<td rowspan="15" bgcolor="<%= linecolor %>"><img src="images/clear.gif" height="1" width="1"></td>
0215: 			<td bgcolor="<%= linecolor %>"><img src="images/clear.gif" height="1" width="1"></td>
0216: 		</tr>
0217: 		<tr>
0218: 			<td>&nbsp;</td>
0219: 			<td colspan="7">&nbsp;</td>
0220: 			<td>&nbsp;</td>
0221: 		</tr>
0222: 		<tr>
0223: 			<td colspan="2">&nbsp;</td>
0224: 			<td>&nbsp;</td>
0225: 			<td rowspan="3" colspan="3">
0226: 				<input type="hidden" name="S1" value="">
0227: 				<input type="text" name="final1" value="" style="text-align:center;width:150;" onFocus="rSelect('final1')">
0228: 			</td>
0229: 			<td colspan="3">&nbsp;</td>
0230: 			<td colspan="2">&nbsp;</td>
0231: 		</tr>
0232: 		<tr>
0233: 			<td height="1" colspan="2"><img src="images/clear.gif" height="1" width="1"></td>
0234: 			<td bgcolor="<%= linecolor %>"><img src="images/clear.gif" height="1" width="1"></td>
0235: 			<td colspan="3"><img src="images/clear.gif" height="1" width="1"></td>
0236: 			<td colspan="2"><img src="images/clear.gif" height="1" width="1"></td>
0237: 		</tr>
0238: 		<tr>
0239: 			<td colspan="2">&nbsp;</td>
0240: 			<td>&nbsp;</td>
0241: 			<td colspan="3">&nbsp;</td>
0242: 			<td colspan="2">&nbsp;</td>
0243: 		</tr>
0244: 		<tr>
0245: 			<td align="center" class="normbold">Semifinal</td>
0246: 			<td>&nbsp;</td>
0247: 			<td colspan="7">&nbsp;</td>
0248: 			<td>&nbsp;</td>
0249: 			<td align="center" class="normbold">Semifinal</td>
0250: 		</tr>
0251: 		<tr>
0252: 			<td align="center" class="normbold"><%= semiFinal1Venue %></td>
0253: 			<td>&nbsp;</td>
0254: 			<td colspan="2">&nbsp;</td>
0255: 			<td colspan="3" align="center" class="normbold">National Champion</td>
0256: 			<td colspan="2">&nbsp;</td>
0257: 			<td>&nbsp;</td>
0258: 			<td align="center" class="normbold"><%= semiFinal2Venue %></td>
0259: 		</tr>
0260: 		<tr>
0261: 			<td align="center" class="normbold"><%= semiFinal1Date %></td>
0262: 			<td>&nbsp;</td>
0263: 			<td colspan="2">&nbsp;</td>
0264: 			<td colspan="3">
0265: 				<input type="hidden" name="F1" value="">
0266: 				<input type="text" name="champion" value="" style="text-align:center;width:150;" onFocus="this.blur()">
0267: 			</td>
0268: 			<td colspan="2">&nbsp;</td>
0269: 			<td>&nbsp;</td>
0270: 			<td align="center" class="normbold"><%= semiFinal2Date %></td>
0271: 		</tr>
0272: 		<tr>
0273: 			<td colspan="2">&nbsp;</td>
0274: 			<td colspan="7">&nbsp;</td>
0275: 			<td colspan="2">&nbsp;</td>
0276: 		</tr>
0277: 		<tr>
0278: 			<td colspan="2">&nbsp;</td>
0279: 			<td colspan="7">&nbsp;</td>
0280: 			<td colspan="2">&nbsp;</td>
0281: 		</tr>
0282: 		<tr>
0283: 			<td colspan="2">&nbsp;</td>
0284: 			<td colspan="3">&nbsp;</td>
0285: 			<td colspan="3" rowspan="3">
0286: 				<input type="hidden" name="S2" value="">
0287: 				<input type="text" name="final2" value="" style="text-align:center;width:150;" onFocus="rSelect('final2')">
0288: 			</td>
0289: 			<td>&nbsp;</td>
0290: 			<td colspan="2">&nbsp;</td>
0291: 		</tr>
0292: 		<tr>
0293: 			<td height="1" colspan="2"><img src="images/clear.gif" height="1" width="1"></td>
0294: 			<td colspan="3"><img src="images/clear.gif" height="1" width="1"></td>
0295: 			<td bgcolor="<%= linecolor %>"><img src="images/clear.gif" height="1" width="1"></td>
0296: 			<td colspan="2"><img src="images/clear.gif" height="1" width="1"></td>
0297: 		</tr>
0298: 		<tr>
0299: 			<td align="center" class="normbold"><%= displayRegion(2) %></td>
0300: 			<td>&nbsp;</td>
0301: 			<td colspan="3">&nbsp;</td>
0302: 			<td>&nbsp;</td>
0303: 			<td>&nbsp;</td>
0304: 			<td align="center" class="normbold"><%= displayRegion(4) %></td>
0305: 		</tr>
0306: 		<tr>
0307: 			<td rowspan="3">
0308: 				<input type="text" name="semi2" value="<%= displayTeam(B15) %>" style="text-align:center;width:150;" onFocus="rSelect('semi2')">
0309: 			</td>
0310: 			<td>&nbsp;</td>
0311: 			<td colspan="7">&nbsp;</td>
0312: 			<td>&nbsp;</td>
0313: 			<td rowspan="3">
0314: 				<input type="text" name="semi4" value="<%= displayTeam(D15) %>" style="text-align:center;width:150;" onFocus="rSelect('semi4')">
0315: 			</td>
0316: 		</tr>
0317: 		<tr>
0318: 			<td height="1" bgcolor="<%= linecolor %>"><img src="images/clear.gif" height="1" width="1"></td>
0319: 			<td colspan="7"><img src="images/clear.gif" height="1" width="1"></td>
0320: 			<td bgcolor="<%= linecolor %>"><img src="images/clear.gif" height="1" width="1"></td>
0321: 		</tr>
0322: 		<tr><td>&nbsp;</td>	</tr>
0323: 		<tr><td>&nbsp;</td>	</tr>
0324: 		<tr><td>&nbsp;</td>	</tr>
0325: 	<tr>
0326: 			<td class="normbold" align="right" colspan="6">Entry Name&nbsp;:&nbsp;&nbsp;</td>
0327: 			<td class="norm" align="left" colspan="7">
0328: 				<input type="text" name="entryname" value="<%= ThisPickNo %>" class="norm">	
0329: 			</td>
0330: 		</tr>
0331: 
0332: 		<tr><td colspan="13">&nbsp;</td></tr>
0333: 
0334: 		<tr>
0335: 			<td colspan="13" class="norm" align="center">
0336: 				<input type="Submit" value="Submit Picks" class="button-40">
0337: 			</td>
0338: 		</tr>
0339: 
0340: 	</table>
0341: </form>
0342: 
0343: </body>
0344: </html>