Count Lines in Pages
Contents of Page: setupteams.asp
Number of Lines: 414
Last Modified: 3/20/2019 7:45:14 AM
0001: <% @Language = "VBScript" %>
0002: <!-- #include FILE="include/adovbs.inc" -->
0003: <!-- #include FILE="include/constants.inc" -->
0004: <!-- #include FILE="include/funcs.asp" -->
0005: <%
0006:  
0007: 	yr = Request.QueryString("yr")
0008: 	If yr = "" Then yr = season
0009: 
0010: '	Response.Write("noMorePicks=" & noMorePicks & "=")
0011: 	user = Request.Cookies("user")
0012: '	If user = ""  Or (user <> "" And Session("loggedIn") = "") Then Response.Redirect("login.asp?from=biggestloserpick.asp")
0013: 	If user = ""  Then Response.Redirect("login.asp?from=setupteams.asp")
0014: 
0015: 
0016: 
0017: 	Dim Regions(4)
0018: 	
0019: 	Set rsRegion = Server.CreateObject("ADODB.Recordset")
0020: 	sqlString = "SELECT * FROM mmRegionals " & _
0021: 			"WHERE Season = " & yr & " " & _
0022: 			"ORDER By Region"
0023: '			"AND Region = " & region
0024: 	rsRegion.Open sqlString, conn, adOpenStatic, adLockReadOnly, adCmdText
0025: 	If Not rsRegion.EOF Then
0026: 	RGCount = 0
0027: 	Do Until rsRegion.EOF
0028: 		RGCount = RGCount + 1
0029: 		Regions(RGCount) = rsRegion("RegionName").Value
0030: 		rsRegion.MoveNext
0031: 	Loop
0032: 	rsRegion.Close
0033: 	Set rsRegion = Nothing
0034: 
0035: 	End If
0036: 
0037: %>
0038: <html>
0039: 
0040: <head>
0041: <meta http-equiv="Content-Language" content="en-us">
0042: <meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
0043: <link href="mm.css" rel="stylesheet" type="text/css">
0044: <title>March Madness - Set up inital field for the "Big Dance"</title>
0045: </head>
0046: <%	
0047: 
0048: 	Set rst = Server.CreateObject("ADODB.Recordset")
0049: 	sqlString = "SELECT * FROM mmTeams WHERE Season = " & yr
0050: 	rst.Open sqlString, conn, adOpenStatic, adLockReadOnly, adCmdText
0051: 
0052: If rst.EOF Then
0053: ID = 0
0054: Else
0055: ID = rst("ID").Value 
0056: A01 = rst("A01").Value 
0057: A02 = rst("A02").Value 
0058: A03 = rst("A03").Value 
0059: A04 = rst("A04").Value 
0060: A05 = rst("A05").Value 
0061: A06 = rst("A06").Value 
0062: A07 = rst("A07").Value 
0063: A08 = rst("A08").Value 
0064: A09 = rst("A09").Value 
0065: A10 = rst("A10").Value 
0066: A11 = rst("A11").Value 
0067: A12 = rst("A12").Value 
0068: A13 = rst("A13").Value 
0069: A14 = rst("A14").Value 
0070: A15 = rst("A15").Value 
0071: A16 = rst("A16").Value 
0072: 
0073: B01 = rst("B01").Value 
0074: B02 = rst("B02").Value 
0075: B03 = rst("B03").Value 
0076: B04 = rst("B04").Value 
0077: B05 = rst("B05").Value 
0078: B06 = rst("B06").Value 
0079: B07 = rst("B07").Value 
0080: B08 = rst("B08").Value 
0081: B09 = rst("B09").Value 
0082: B10 = rst("B10").Value 
0083: B11 = rst("B11").Value 
0084: B12 = rst("B12").Value 
0085: B13 = rst("B13").Value 
0086: B14 = rst("B14").Value 
0087: B15 = rst("B15").Value 
0088: B16 = rst("B16").Value 
0089: C01 = rst("C01").Value 
0090: C02 = rst("C02").Value 
0091: C03 = rst("C03").Value 
0092: C04 = rst("C04").Value 
0093: C05 = rst("C05").Value 
0094: C06 = rst("C06").Value 
0095: C07 = rst("C07").Value 
0096: C08 = rst("C08").Value 
0097: C09 = rst("C09").Value 
0098: C10 = rst("C10").Value 
0099: C11 = rst("C11").Value 
0100: C12 = rst("C12").Value 
0101: C13 = rst("C13").Value 
0102: C14 = rst("C14").Value 
0103: C15 = rst("C15").Value 
0104: C16 = rst("C16").Value 
0105: D01 = rst("D01").Value 
0106: D02 = rst("D02").Value 
0107: D03 = rst("D03").Value 
0108: D04 = rst("D04").Value 
0109: D05 = rst("D05").Value 
0110: D06 = rst("D06").Value 
0111: D07 = rst("D07").Value 
0112: D08 = rst("D08").Value 
0113: D09 = rst("D09").Value 
0114: D10 = rst("D10").Value 
0115: D11 = rst("D11").Value 
0116: D12 = rst("D12").Value 
0117: D13 = rst("D13").Value 
0118: D14 = rst("D14").Value 
0119: D15 = rst("D15").Value 
0120: D16 = rst("D16").Value
0121: 
0122: End If
0123: %>
0124: 
0125: <body>
0126: 
0127: <form method="POST" action="setupteamspost.asp?yr=<%= yr %>&ID=<%= ID %>">
0128: 
0129: <table border="0" cellpadding="0" width="650">
0130:     <tr>
0131: 		<td width="5%" align="right"></td>
0132: 		<td width="20%"  class="bigblue"><big><i><%= Regions(1) %></big> (Top Left)</i></td>
0133: 		<td width="5%" align="right"></td>
0134:     </tr>
0135:     <tr>
0136:       <td  align="right" class="normbold">1</td>
0137:       <td   class="norm" height="15"><input type="text" name="A01" value="<%= A01 %>"> </td>
0138: 	</tr>
0139:     <tr>
0140:       <td  align="right" class="normbold">16</td>
0141:       <td   class="norm" height="15"><input type="text" name="A16" value="<%= A16 %>"></td>
0142: 	</tr>
0143: 	<tr>
0144:       <td  align="right" class="normred">8</td>
0145:       <td   class="normbold"><input type="text" name="A08" value="<%= A08 %>"> </td>
0146: 	</tr>
0147:     <tr>
0148:       <td  align="right" class="normred">9</td>
0149:       <td   class="normbold"><input type="text" name="A09" value="<%= A09 %>"> </td>
0150: 	</tr>
0151:     <tr>
0152:       <td  align="right" class="normbold">5</td>
0153:       <td   class="normbold"><input type="text" name="A05" value="<%= A05 %>"> </td>
0154: 	</tr>
0155:     <tr>
0156:       <td  align="right" class="normbold">12</td>
0157:       <td   class="normbold"><input type="text" name="A12" value="<%= A12 %>"> </td>
0158: 	</tr>
0159:     <tr>
0160:       <td  align="right" class="normred">4</td>
0161:       <td   class="normbold"><input type="text" name="A04" value="<%= A04 %>"> </td>
0162: 	</tr>
0163:     <tr>
0164:       <td  align="right" class="normred">13</td>
0165:       <td   class="normbold"><input type="text" name="A13" value="<%= A13 %>"> </td>
0166: 	</tr>
0167:     <tr>
0168:       <td  align="right" class="normbold" >6</td>
0169:       <td   class="normbold"><input type="text" name="A06" value="<%= A06 %>"> </td>
0170: 	</tr>
0171:     <tr>
0172:       <td  align="right" class="normbold">11</td>
0173:       <td   class="normbold"><input type="text" name="A11" value="<%= A11 %>"> </td>
0174: 	</tr>
0175:     <tr>
0176:       <td  align="right" class="normred">3</td>
0177:       <td   class="normbold"><input type="text" name="A03" value="<%= A03 %>"> </td>
0178: 	</tr>
0179:     <tr>
0180:       <td  align="right" class="normred">14</td>
0181:       <td   class="normbold"><input type="text" name="A14" value="<%= A14 %>"> </td>
0182: 	</tr>
0183:     <tr>
0184:       <td  align="right" class="normbold">7</td>
0185:       <td   class="normbold"><input type="text" name="A07" value="<%= A07 %>"> </td>
0186: 	</tr>
0187:     <tr>
0188:       <td  align="right" class="normbold">10</td>
0189:       <td   class="normbold"><input type="text" name="A10" value="<%= A10 %>"> </td>
0190: 	</tr>
0191:     <tr>
0192:       <td  align="right" class="normred">2</td>
0193:       <td   class="normbold"><input type="text" name="A02" value="<%= A02 %>"> </td>
0194: 	</tr>
0195:     <tr>
0196:       <td  align="right" class="normred">15</td>
0197:       <td   class="normbold"><input type="text" name="A15" value="<%= A15 %>"> </td>
0198: 	</tr>
0199:     <tr>
0200: 		<td width="5%" align="right"></td>
0201: 		<td width="20%"  class="bigblue"><big><i><%= Regions(2) %></big> (Bottom Left)</i></td>
0202: 		<td width="5%" align="right"></td>
0203:     </tr>
0204:     <tr>
0205:       <td  align="right" class="normbold">1</td>
0206:       <td   class="norm" height="15"><input type="text" name="B01" value="<%= B01 %>"> </td>
0207: 	</tr>
0208:     <tr>
0209:       <td  align="right" class="normbold">16</td>
0210:       <td   class="norm" height="15"><input type="text" name="B16" value="<%= B16 %>"></td>
0211: 	</tr>
0212: 	<tr>
0213:       <td  align="right" class="normred">8</td>
0214:       <td   class="normbold"><input type="text" name="B08" value="<%= B08 %>"> </td>
0215: 	</tr>
0216:     <tr>
0217:       <td  align="right" class="normred">9</td>
0218:       <td   class="normbold"><input type="text" name="B09" value="<%= B09 %>"> </td>
0219: 	</tr>
0220:     <tr>
0221:       <td  align="right" class="normbold">5</td>
0222:       <td   class="normbold"><input type="text" name="B05" value="<%= B05 %>"> </td>
0223: 	</tr>
0224:     <tr>
0225:       <td  align="right" class="normbold">12</td>
0226:       <td   class="normbold"><input type="text" name="B12" value="<%= B12 %>"> </td>
0227: 	</tr>
0228:     <tr>
0229:       <td  align="right" class="normred">4</td>
0230:       <td   class="normbold"><input type="text" name="B04" value="<%= B04 %>"> </td>
0231: 	</tr>
0232:     <tr>
0233:       <td  align="right" class="normred">13</td>
0234:       <td   class="normbold"><input type="text" name="B13" value="<%= B13 %>"> </td>
0235: 	</tr>
0236:     <tr>
0237:       <td  align="right" class="normbold" >6</td>
0238:       <td   class="normbold"><input type="text" name="B06" value="<%= B06 %>"> </td>
0239: 	</tr>
0240:     <tr>
0241:       <td  align="right" class="normbold">11</td>
0242:       <td   class="normbold"><input type="text" name="B11" value="<%= B11 %>"> </td>
0243: 	</tr>
0244:     <tr>
0245:       <td  align="right" class="normred">3</td>
0246:       <td   class="normbold"><input type="text" name="B03" value="<%= B03 %>"> </td>
0247: 	</tr>
0248:     <tr>
0249:       <td  align="right" class="normred">14</td>
0250:       <td   class="normbold"><input type="text" name="B14" value="<%= B14 %>"> </td>
0251: 	</tr>
0252:     <tr>
0253:       <td  align="right" class="normbold">7</td>
0254:       <td   class="normbold"><input type="text" name="B07" value="<%= B07 %>"> </td>
0255: 	</tr>
0256:     <tr>
0257:       <td  align="right" class="normbold">10</td>
0258:       <td   class="normbold"><input type="text" name="B10" value="<%= B10 %>"> </td>
0259: 	</tr>
0260:     <tr>
0261:       <td  align="right" class="normred">2</td>
0262:       <td   class="normbold"><input type="text" name="B02" value="<%= B02 %>"> </td>
0263: 	</tr>
0264:     <tr>
0265:       <td  align="right" class="normred">15</td>
0266:       <td   class="normbold"><input type="text" name="B15" value="<%= B15 %>"> </td>
0267: 	</tr>
0268:     <tr>
0269: 		<td width="5%" align="right"></td>
0270: 		<td width="20%"  class="bigblue"><big><i><%= Regions(3) %></big> (Top Right)</i></td>
0271: 		<td width="5%" align="right"></td>
0272:     </tr>
0273:     <tr>
0274:       <td  align="right" class="normbold">1</td>
0275:       <td   class="norm" height="15"><input type="text" name="C01" value="<%= C01 %>"> </td>
0276: 	</tr>
0277:     <tr>
0278:       <td  align="right" class="normbold">16</td>
0279:       <td   class="norm" height="15"><input type="text" name="C16" value="<%= C16 %>"></td>
0280: 	</tr>
0281: 	<tr>
0282:       <td  align="right" class="normred">8</td>
0283:       <td   class="normbold"><input type="text" name="C08" value="<%= C08 %>"> </td>
0284: 	</tr>
0285:     <tr>
0286:       <td  align="right" class="normred">9</td>
0287:       <td   class="normbold"><input type="text" name="C09" value="<%= C09 %>"> </td>
0288: 	</tr>
0289:     <tr>
0290:       <td  align="right" class="normbold">5</td>
0291:       <td   class="normbold"><input type="text" name="C05" value="<%= C05 %>"> </td>
0292: 	</tr>
0293:     <tr>
0294:       <td  align="right" class="normbold">12</td>
0295:       <td   class="normbold"><input type="text" name="C12" value="<%= C12 %>"> </td>
0296: 	</tr>
0297:     <tr>
0298:       <td  align="right" class="normred">4</td>
0299:       <td   class="normbold"><input type="text" name="C04" value="<%= C04 %>"> </td>
0300: 	</tr>
0301:     <tr>
0302:       <td  align="right" class="normred">13</td>
0303:       <td   class="normbold"><input type="text" name="C13" value="<%= C13 %>"> </td>
0304: 	</tr>
0305:     <tr>
0306:       <td  align="right" class="normbold" >6</td>
0307:       <td   class="normbold"><input type="text" name="C06" value="<%= C06 %>"> </td>
0308: 	</tr>
0309:     <tr>
0310:       <td  align="right" class="normbold">11</td>
0311:       <td   class="normbold"><input type="text" name="C11" value="<%= C11 %>"> </td>
0312: 	</tr>
0313:     <tr>
0314:       <td  align="right" class="normred">3</td>
0315:       <td   class="normbold"><input type="text" name="C03" value="<%= C03 %>"> </td>
0316: 	</tr>
0317:     <tr>
0318:       <td  align="right" class="normred">14</td>
0319:       <td   class="normbold"><input type="text" name="C14" value="<%= C14 %>"> </td>
0320: 	</tr>
0321:     <tr>
0322:       <td  align="right" class="normbold">7</td>
0323:       <td   class="normbold"><input type="text" name="C07" value="<%= C07 %>"> </td>
0324: 	</tr>
0325:     <tr>
0326:       <td  align="right" class="normbold">10</td>
0327:       <td   class="normbold"><input type="text" name="C10" value="<%= C10 %>"> </td>
0328: 	</tr>
0329:     <tr>
0330:       <td  align="right" class="normred">2</td>
0331:       <td   class="normbold"><input type="text" name="C02" value="<%= C02 %>"> </td>
0332: 	</tr>
0333:     <tr>
0334:       <td  align="right" class="normred">15</td>
0335:       <td   class="normbold"><input type="text" name="C15" value="<%= C15 %>"> </td>
0336: 	</tr>
0337:     <tr>
0338: 		<td width="5%" align="right"></td>
0339: 		<td width="20%"  class="bigblue"><big><i><%= Regions(4) %></big> (Bottom Right)</i></td>
0340: 		<td width="5%" align="right"></td>
0341:     </tr>
0342:     <tr>
0343:       <td  align="right" class="normbold">1</td>
0344:       <td   class="norm" height="15"><input type="text" name="D01" value="<%= D01 %>"> </td>
0345: 	</tr>
0346:     <tr>
0347:       <td  align="right" class="normbold">16</td>
0348:       <td   class="norm" height="15"><input type="text" name="D16" value="<%= D16 %>"></td>
0349: 	</tr>
0350: 	<tr>
0351:       <td  align="right" class="normred">8</td>
0352:       <td   class="normbold"><input type="text" name="D08" value="<%= D08 %>"> </td>
0353: 	</tr>
0354:     <tr>
0355:       <td  align="right" class="normred">9</td>
0356:       <td   class="normbold"><input type="text" name="D09" value="<%= D09 %>"> </td>
0357: 	</tr>
0358:     <tr>
0359:       <td  align="right" class="normbold">5</td>
0360:       <td   class="normbold"><input type="text" name="D05" value="<%= D05 %>"> </td>
0361: 	</tr>
0362:     <tr>
0363:       <td  align="right" class="normbold">12</td>
0364:       <td   class="normbold"><input type="text" name="D12" value="<%= D12 %>"> </td>
0365: 	</tr>
0366:     <tr>
0367:       <td  align="right" class="normred">4</td>
0368:       <td   class="normbold"><input type="text" name="D04" value="<%= D04 %>"> </td>
0369: 	</tr>
0370:     <tr>
0371:       <td  align="right" class="normred">13</td>
0372:       <td   class="normbold"><input type="text" name="D13" value="<%= D13 %>"> </td>
0373: 	</tr>
0374:     <tr>
0375:       <td  align="right" class="normbold" >6</td>
0376:       <td   class="normbold"><input type="text" name="D06" value="<%= D06 %>"> </td>
0377: 	</tr>
0378:     <tr>
0379:       <td  align="right" class="normbold">11</td>
0380:       <td   class="normbold"><input type="text" name="D11" value="<%= D11 %>"> </td>
0381: 	</tr>
0382:     <tr>
0383:       <td  align="right" class="normred">3</td>
0384:       <td   class="normbold"><input type="text" name="D03" value="<%= D03 %>"> </td>
0385: 	</tr>
0386:     <tr>
0387:       <td  align="right" class="normred">14</td>
0388:       <td   class="normbold"><input type="text" name="D14" value="<%= D14 %>"> </td>
0389: 	</tr>
0390:     <tr>
0391:       <td  align="right" class="normbold">7</td>
0392:       <td   class="normbold"><input type="text" name="D07" value="<%= D07 %>"> </td>
0393: 	</tr>
0394:     <tr>
0395:       <td  align="right" class="normbold">10</td>
0396:       <td   class="normbold"><input type="text" name="D10" value="<%= D10 %>"> </td>
0397: 	</tr>
0398:     <tr>
0399:       <td  align="right" class="normred">2</td>
0400:       <td   class="normbold"><input type="text" name="D02" value="<%= D02 %>"> </td>
0401: 	</tr>
0402:     <tr>
0403:       <td  align="right" class="normred">15</td>
0404:       <td   class="normbold"><input type="text" name="D15" value="<%= D15 %>"> </td>
0405: 	</tr>
0406: 
0407: 
0408: 	<tr><td>&nbsp </td></tr>
0409: 	<tr><td>&nbsp </td><td><input type="submit" value="Submit" name="D1">
0410: 					<input type="Button" value="Return" style="background-color:#FAD2B8;" onclick="history.back()" class="smallA"></td>
0411:   </table>
0412: </form>
0413: </body>
0414: </html>