<%@LANGUAGE="VBSCRIPT"%>
<!--#include file="Connections/news.asp" -->
<%
Dim Recordset1
Dim Recordset1_cmd
Dim Recordset1_numRows

Set Recordset1_cmd = Server.CreateObject ("ADODB.Command")
Recordset1_cmd.ActiveConnection = MM_news_STRING
Recordset1_cmd.CommandText = "SELECT * FROM admin" 
Recordset1_cmd.Prepared = true

Set Recordset1 = Recordset1_cmd.Execute
Recordset1_numRows = 0
%>
<%
' *** Validate request to log in to this site.
MM_LoginAction = Request.ServerVariables("URL")
If Request.QueryString <> "" Then MM_LoginAction = MM_LoginAction + "?" + Server.HTMLEncode(Request.QueryString)
MM_valUsername = CStr(Request.Form("username"))
If MM_valUsername <> "" Then
  Dim MM_fldUserAuthorization
  Dim MM_redirectLoginSuccess
  Dim MM_redirectLoginFailed
  Dim MM_loginSQL
  Dim MM_rsUser
  Dim MM_rsUser_cmd
  
  MM_fldUserAuthorization = ""
  MM_redirectLoginSuccess = "index.asp"
  MM_redirectLoginFailed = "index.asp"

  MM_loginSQL = "SELECT username, password"
  If MM_fldUserAuthorization <> "" Then MM_loginSQL = MM_loginSQL & "," & MM_fldUserAuthorization
  MM_loginSQL = MM_loginSQL & " FROM [admin] WHERE username = ? AND password = ?"
  Set MM_rsUser_cmd = Server.CreateObject ("ADODB.Command")
  MM_rsUser_cmd.ActiveConnection = MM_news_STRING
  MM_rsUser_cmd.CommandText = MM_loginSQL
  MM_rsUser_cmd.Parameters.Append MM_rsUser_cmd.CreateParameter("param1", 200, 1, 50, MM_valUsername) ' adVarChar
  MM_rsUser_cmd.Parameters.Append MM_rsUser_cmd.CreateParameter("param2", 200, 1, 50, Request.Form("password")) ' adVarChar
  MM_rsUser_cmd.Prepared = true
  Set MM_rsUser = MM_rsUser_cmd.Execute

  If Not MM_rsUser.EOF Or Not MM_rsUser.BOF Then 
    ' username and password match - this is a valid user
    Session("MM_Username") = MM_valUsername
    If (MM_fldUserAuthorization <> "") Then
      Session("MM_UserAuthorization") = CStr(MM_rsUser.Fields.Item(MM_fldUserAuthorization).Value)
    Else
      Session("MM_UserAuthorization") = ""
    End If
    if CStr(Request.QueryString("accessdenied")) <> "" And false Then
      MM_redirectLoginSuccess = Request.QueryString("accessdenied")
    End If
    MM_rsUser.Close
    Response.Redirect(MM_redirectLoginSuccess)
  End If
  MM_rsUser.Close
  Response.Redirect(MM_redirectLoginFailed)
End If
%><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<!-- saved from url=(0014)about:internet -->
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>sports.jpg</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<style type="text/css">
td img {display: block;}body,td,th {
	font-family: "宋体";
	font-size: 12px;
	color: #000000;
	line-height: 20px;
	background-repeat: no-repeat;
}
body {
	background-color: #C8C8C8;
	margin-left: 0px;
	margin-top: 0px;
	margin-right: 0px;
	margin-bottom: 0px;
}
.STYLE3 {font-family: "黑体"; font-weight: bold; }
.STYLE4 {
	font-size: 14px;
	font-weight: bold;
}
.STYLE5 {
	font-size: 10px;
	font-family: "Times New Roman", Times, serif;
}
.STYLE6 {
	font-family: "黑体";
	font-size: 16px;
}
</style>
<!--Fireworks 8 Dreamweaver 8 target.  Created Thu Aug 07 01:08:33 GMT+0800 2008-->
<script type="text/javascript">
<!--
function MM_validateForm() { //v4.0
  if (document.getElementById){
    var i,p,q,nm,test,num,min,max,errors='',args=MM_validateForm.arguments;
    for (i=0; i<(args.length-2); i+=3) { test=args[i+2]; val=document.getElementById(args[i]);
      if (val) { nm=val.name; if ((val=val.value)!="") {
        if (test.indexOf('isEmail')!=-1) { p=val.indexOf('@');
          if (p<1 || p==(val.length-1)) errors+='- '+nm+' must contain an e-mail address.\n';
        } else if (test!='R') { num = parseFloat(val);
          if (isNaN(val)) errors+='- '+nm+' must contain a number.\n';
          if (test.indexOf('inRange') != -1) { p=test.indexOf(':');
            min=test.substring(8,p); max=test.substring(p+1);
            if (num<min || max<num) errors+='- '+nm+' must contain a number between '+min+' and '+max+'.\n';
      } } } else if (test.charAt(0) == 'R') errors += '- '+nm+' is required.\n'; }
    } if (errors) alert('The following error(s) occurred:\n'+errors);
    document.MM_returnValue = (errors == '');
} }
//-->
</script>
</head>
<body>
<table width="775" border="0" align="center" cellpadding="0" cellspacing="0">
<!-- fwtable fwsrc="index.png" fwbase="sports.jpg" fwstyle="Dreamweaver" fwdocid = "986218467" fwnested="0" -->
  <tr>
   <td><img src="images/spacer.gif" width="371" height="1" border="0" alt="" /></td>
   <td><img src="images/spacer.gif" width="8" height="1" border="0" alt="" /></td>
   <td><img src="images/spacer.gif" width="390" height="1" border="0" alt="" /></td>
   <td><img src="images/spacer.gif" width="6" height="1" border="0" alt="" /></td>
   <td><img src="images/spacer.gif" width="1" height="1" border="0" alt="" /></td>
  </tr>

  <tr>
   <td colspan="4"><img name="sports_r1_c1" src="images/sports_r1_c1.jpg" width="775" height="67" border="0" id="sports_r1_c1" alt="" /></td>
   <td><img src="images/spacer.gif" width="1" height="67" border="0" alt="" /></td>
  </tr>
  <tr>
   <td><img name="sports_r2_c1" src="images/sports_r2_c1.jpg" width="371" height="70" border="0" id="sports_r2_c1" alt="" /></td>
   <td rowspan="2" colspan="3"><img name="sports_r2_c2" src="images/sports_r2_c2.jpg" width="404" height="204" border="0" id="sports_r2_c2" alt="" /></td>
   <td><img src="images/spacer.gif" width="1" height="70" border="0" alt="" /></td>
  </tr>
  <tr>
   <td><img name="sports_r3_c1" src="images/sports_r3_c1.jpg" width="371" height="134" border="0" id="sports_r3_c1" alt="" /></td>
   <td><img src="images/spacer.gif" width="1" height="134" border="0" alt="" /></td>
  </tr>
  <tr>
   <td height="229" valign="top" background="images/sports_r4_c1.jpg"><table width="370" border="0" cellspacing="0" cellpadding="0">
     <tr>
       <td width="76" height="30"><span class="STYLE3">　　首页</span></td>
       <td width="70"><span class="STYLE3"> 　最新动态 </span></td>
       <td width="92"><span class="STYLE3">　活动预告</span></td>
       <td width="69"><span class="STYLE3"> 赛事组织</span></td>
       <td width="63"><span class="STYLE3"> 联系我们</span></td>
     </tr>
     
   </table>
     <form action="<%=MM_LoginAction%>" method="POST" name="form1" id="form1" onsubmit="MM_validateForm('username','','R','password','','R');return document.MM_returnValue">
       <table width="350" border="0" align="center" cellpadding="2" cellspacing="2" bgcolor="#BEBFC1">
         <tr>
           <td width="80">用户名：</td>
           <td width="256"><label>
             <input name="username" type="text" id="username" size="20" />
           </label></td>
         </tr>
         <tr>
           <td>密码：</td>
           <td><label>
             <input name="password" type="password" id="password" size="20" />
           </label></td>
         </tr>
         <tr>
           <td>&nbsp;</td>
           <td><label>
             <input type="submit" name="button" id="button" value="提交" />
           　　　
           <input type="reset" name="button2" id="button2" value="重置" />
           </label></td>
         </tr>
       </table>
      </form>
    <br /></td>
   <td><img name="sports_r4_c2" src="images/sports_r4_c2.jpg" width="8" height="229" border="0" id="sports_r4_c2" alt="" /></td>
   <td valign="top" background="images/sports_r4_c3.jpg"><table width="380" border="0" align="center" cellpadding="0" cellspacing="0">
     <tr>
       <td width="380" height="30"><div align="center" class="STYLE6">运动之美</div></td>
     </tr>
     <tr>
       <td height="199" valign="top"><p>　　运动之美，在这个四轮代步，空调护体的世界里，因为稀缺而更加显示出它的光辉来。自然用丑陋来惩罚惰怠的人体——肥胖、浮肿、橘皮组织、肚腩、老态、笨拙的举止。</p>
         <p> 　　健美的身体，良好的心态，才是时髦的基本，否则再有设计感的衣服穿上身，都只是在粉饰太平。对于时尚界大吹的运动风，表示最大的理解和拥护，运动之美，难以抗拒。</p>
         <p>　　给身体送绑，给心灵松绑，成为城市人的一种渴望。方法，其实直接就有一个：运动起来。<br />
         </p>
         </td>
     </tr>
     
   </table></td>
   <td><img name="sports_r4_c4" src="images/sports_r4_c4.jpg" width="6" height="229" border="0" id="sports_r4_c4" alt="" /></td>
   <td><img src="images/spacer.gif" width="1" height="229" border="0" alt="" /></td>
  </tr>
</table>
<table width="775" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td height="100" bgcolor="#BEBFC1"><div align="center">
      <hr />
      版权所有&copy;我爱运动俱乐部</div></td>
  </tr>
</table>
</body>
</html>
<%
Recordset1.Close()
Set Recordset1 = Nothing
%>
