Count Lines in Pages
Contents of Page: mmmain_dayofcutoff.asp
Number of Lines: 116
Last Modified: 8/22/2018 1:32:54 PM
0001: <% @Language = "VBScript" %>
0002: 
0003: <!-- #include FILE="include/adovbs.inc" -->
0004: <!-- #include FILE="include/constants.inc" -->
0005: 
0006: <%
0007: 	Set rs = Server.CreateObject("ADODB.Recordset")
0008: 	sqlString = "SELECT NumEntries, PaidEntries FROM mmEntries WHERE Season = " & season
0009: 	rs.Open sqlString, conn, adOpenStatic, adLockReadOnly, adCmdText
0010: 	totEntries = rs.RecordCount
0011: 	paidentries = 0
0012: 	pending = 0
0013: 	pendentries = 0
0014: 	Do Until Rs.EOF
0015: 	npks = rs("NumEntries").Value
0016: 	paid = rs("PaidEntries").Value
0017: 	If paid <> "" Then paid = CInt(paid)
0018: 	totPicks = totPicks + npks
0019: 	If paid > 0 Then
0020: 	paidentries = paidentries + paid
0021: 	Else
0022: 	pendentries = pendentries + 1
0023: 	End If
0024:     rs.MoveNext
0025: 		Loop
0026: 		
0027: 	rs.Close
0028: 	Set rs = Nothing
0029: 	pending =  totPicks - paidentries
0030: 	totAmount = totPicks * 10
0031: '	totAmount = totPicks * 15
0032: '	totAmount = totAmount + (totEntries * 5)
0033: '	totAmount = Cint(totAmount / 2)
0034: 	
0035: '	PendAmt = pending * 15
0036: '	PendAmt = PendAmt + (pendentries * 5)
0037: '	PendAmt = Cint(PendAmt / 2)
0038:    PendAmt = pending * 10
0039: 
0040: %>
0041: <html>
0042: 
0043: <head>
0044: <title>Joe Toledo's March Madness Contest - Benefiting Charity</title>
0045: <base target="_self">
0046: </head>
0047: 
0048: <body bgcolor="#ffffff">
0049: <div align="center"><center>
0050: 
0051: <table cellspacing="0" border="1" cellpadding="5" width="750" bordercolor="#FED87B"
0052: align="center" height="331">
0053:   <tr bgcolor="#FFFAF0">
0054:     <td VALIGN="TOP" width="666" colspan="2" height="16"><span style="font-family:Arial"><font size="2"><b><font color="#FF0000">Total # of Entries to Date:</font></b></font><b><font color="#0000FF" size="3">&nbsp;<%= totPicks%>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</font><font color="#0000FF" size="1"><a href="whoisin.asp">Who
0055:       is in it?</a></font><font color="#0000FF" size="3">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
0056:       </font><font size="2" color="#009900">Funds Raised for Charity</font><font color="#009900" size="3">:</font><font color="#0000FF" size="3">
0057:       $<%= totAmount %>&nbsp;&nbsp;&nbsp;</font><font size = "2">(Pending:&nbsp;$<%= PendAmt %>)</font></b></span>
0058:     </td>
0059:   </tr>
0060:   <tr bgcolor="#FFFAF0">
0061:     <td VALIGN="TOP" width="600" height="287">
0062:         <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-family:Arial">This
0063:         contest allows you to enjoy the upcoming 2005 NCAA Men’s Basketball
0064:         Tournament being held from March 17<sup>th</sup>  thru April 4<sup>th</sup>
0065:         and help two charities in the process: The <strong>City of Hope</strong>
0066:         Cancer Research Institute and the <strong>Antonio Toledo Memorial
0067:         Scholarship Fund.</strong><b><br>
0068:         <br>
0069:         </b>The cost to participate is only a <strong>$20 donation</strong>  per
0070:         entry, with <b>$10 </b>going to the two charities above and
0071:         the remainder being distributed amongst the contest participants winners.&nbsp;
0072:         This contest rewards the top <strong>10%</strong>&nbsp; of all entries
0073:         with prizes up to <strong>$500 or more </strong>based on the number of
0074:         entries.<br>
0075:         <u2:p></o:p>
0076:         </span></p>
0077:         <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-family:Arial">You
0078:         can still <blink><a href="signup.asp"><b>register</b></a></blink>  today
0079:         until 9:15 PST.</o:p>
0080:         </span></p>
0081:         
0082:         <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-family:Arial"><font size="3">
0083: 
0084: <font color="#008080">Thank
0085:         you for visiting Joe Toledo's Annual March Madness Contest for Charity.</font></span></strong>&nbsp;</font></p>
0086:     </td>
0087:     <td VALIGN="TOP" width="122" height="287">
0088:       <p><span style="mso-bidi-font-size:10.0pt;font-family:Arial"><font color="#008080" size="2">If you don't care to make selections on who is going
0089:       to win the 2005 NCAA Men’s Basketball Tournament and would just like to
0090:       make a donation of <strong>any
0091:         amount </strong>to these two worthy causes, just click on the PayPal
0092:       Icon below to do so <strong>right now</strong>.</font></span>
0093:       </p>
0094:          <form action="https://www.paypal.com/cgi-bin/webscr" method=post
0095:   enctype="application/x-www-form-urlencoded" target="_blank">
0096:   <p align="center"><INPUT TYPE="image" ACTION="https://www.paypal.com/cgi-bin/webscr" SRC="http://images.paypal.com/images/x-click-but04.gif" METHOD="post" NAME="I1"
0097:   ACTION="https://www.paypal.com/cgi-bin/webscr" METHOD=post
0098:   ACTION="https://www.paypal.com/cgi-bin/webscr" METHOD=post
0099:   ACTION="https://www.paypal.com/cgi-bin/webscr" METHOD=post border=0
0100:   alt="Make payments with PayPal - it's fast, free and secure!"></p>
0101:   <span
0102:   style='display:none;mso-hide:all'><INPUT TYPE="hidden" NAME="return" VALUE="http://www.lusogolf.org/thankyou2.html"><INPUT TYPE="hidden" NAME="item_number" VALUE="Please specify amount"><INPUT TYPE="hidden" NAME="item_name" VALUE="Cash Donation"><INPUT TYPE="hidden" NAME="business" VALUE="joe@lusogolf.org"><INPUT TYPE="hidden" NAME="cmd" VALUE="_xclick"></span>
0103:   </form>
0104:     </td>
0105:   </tr>
0106:   <tr bgcolor="#FFFAF0">
0107:     <td VALIGN="TOP" width="666" colspan="2" height="1">
0108:       <p align="center">
0109:       </p>
0110:     </td>
0111:   </tr>
0112: </table>
0113: </center></div>
0114: </body>
0115: </html>
0116: