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