16. maj 2002 - 22:21
Der er
1 kommentar og
1 løsning
kimiwan hjælp mig
det er så min kode jeg kan ikke logge ind !!! hvad er fejlen og forklare d et lige ikke !
<!-- #include virtual = "inc/dbconn.asp" -->
<!-- #include virtual = "inc/options.asp" -->
<!-- #include virtual = "inc/status.asp" -->
<!-- #include virtual = "inc/top.asp" -->
<%
if request("mode") = "logoff" then
if len(session("login_username")) > 0 then
strSQL = "SELECT * FROM user where username='" & session("login_username") & "' "
Set RS = Server.CreateObject("ADODB.Recordset")
rs.Open strSQL, Conn, 3, 3
rs("online") = "no"
rs.Update
end if
session("loginusername") = ""
session("login_username") = ""
session("login_god") = ""
session("login_teamname") = ""
session("login_status") = ""
session("newusername") = ""
session("teamtjek") = ""
session("login_ban") = ""
session("login_delgod") = ""
Response.Redirect "main.asp?mode=logoff"
end if
if request("mode") = "login" then
session("loginusername") = Request.Form("username")
if request("username") = "" then Response.Redirect "login.asp?error=1" end if
if request("password") = "" then Response.Redirect "login.asp?error=2" end if
strsql = "Select * From user where username='" & Request.Form("username") & "' and pass='" & Request.Form("password") & "'"
set rs = conn.execute(strsql)
if (rs.eof or rs.eof) then
Response.Redirect "login.asp?error=3"
else
strSQL = "SELECT * FROM user where username='" & Request.Form("username") & "' "
Set RS = Server.CreateObject("ADODB.Recordset")
rs.Open strSQL, Conn, 3, 3
rs("ip") = Request.ServerVariables("REMOTE_ADDR")
rs("online") = "yes"
rs("onlinetid") = now()
rs.Update
session("loginusername") = ""
session("login_username") = rs("username")
if rs("god") = "delgod" then
session("login_delgod") = "yes"
session("login_god") = "notselect"
else
session("login_god") = rs("god")
end if
session("login_teamname") = rs("team")
if rs("status") = "teamadmin" then
session("login_status") = "teamadmin"
else
session("login_status") = "user"
end if
if not rs("god") = "yes" then
session("newusername") = rs("username")
session("teamtjek") = "yes"
end if
if rs("ban") = "yes" then
session("login_ban") = "yes"
end if
end if
Response.Redirect "main.asp?mode=loginok"
'Response.Write session("login_username") & "<br>"
'Response.Write session("login_teamname") & "<br>"
'Response.Write session("login_status") & "<br>"
else
error = request("error")
if error = 1 then Response.Write logine1 end if
if error = 2 then Response.Write logine2 end if
if error = 3 then Response.Write logine3 end if
%>
<FORM action="login.asp?mode=login" method=POST>
Username:
<BR>
<INPUT type="text" name=username value=<%=session("loginusername")%>>
<BR>
Password:
<BR>
<INPUT type="password" name=password>
<BR>
<INPUT type="submit" value="Submit">
</FORM>
<% end if %>
<!-- #include virtual = "inc/bund.asp" -->
her er oprettles koden til det !!!
<!-- #include virtual = "inc/dbconn.asp" -->
<!-- #include virtual = "inc/options.asp" -->
<!-- #include virtual = "inc/status.asp" -->
<!-- #include virtual = "inc/top.asp" -->
<%
if request("mode") = "opret" then
session("name") = Request.Form("name")
session("username") = Request.Form("username")
session("pass") = Request.Form("pass")
session("pass2") = Request.Form("pass2")
session("alder") = Request.Form("alder")
session("land") = Request.Form("land")
session("email") = Request.Form("email")
session("server") = Request.Form("server")
if Request.Form("name") = "" then Response.Redirect "createuser.asp?error=1" end if
if Request.Form("username") = "" then Response.Redirect "createuser.asp?error=2" end if
if Request.Form("pass") = "" then Response.Redirect "createuser.asp?error=3" end if
if not Request.Form("pass") = Request.Form("pass2") then Response.Redirect "createuser.asp?error=4" end if
if Request.Form("alder") = "" then Response.Redirect "createuser.asp?error=5" end if
if Request.Form("land") = "" then Response.Redirect "createuser.asp?error=6" end if
if Request.Form("email") = "" then Response.Redirect "createuser.asp?error=7" end if
if Request.Form("server") = "" then Response.Redirect "createuser.asp?error=8" end if
strsql= "Select * From user"
set rs = conn.execute(strsql)
do until rs.EOF
if Request.ServerVariables("REMOTE_ADDR") = rs("ip") then
Response.Redirect "createuser.asp?error=10"
end if
rs.MoveNext
loop
strSQL = "SELECT * FROM user where username = '" & Request.Form("username") & "'"
Set rs = Conn.Execute(strSQL)
If not (rs.BOF Or rs.EOF) Then
response.redirect "createuser.asp?error=9"
End If
strSQL = "SELECT * FROM user"
Set RS = Server.CreateObject("ADODB.Recordset")
rs.Open strSQL, Conn, 3, 3
rs.AddNew
rs("name") = Request.Form("name")
rs("username") = Request.Form("username")
rs("pass") = Request.Form("pass")
rs("alder") = Request.Form("alder")
rs("land") = Request.Form("land")
rs("email") = Request.Form("email")
rs("server") = Request.Form("server")
rs("god") = "notselect"
rs("status") = "user"
rs("opretdato") = now()
rs("win") = "0"
rs("lose") = "0"
rs("team") = "notselect"
rs("ip") = Request.ServerVariables("REMOTE_ADDR")
rs.Update
session("name") = ""
session("username") = ""
session("pass") = ""
session("pass2") = ""
session("alder") = ""
session("land") = ""
session("email") = ""
session("server") = ""
session("newusername") = Request.Form("username")
session("teamtjek") = "yes"
Response.Redirect "selectteam.asp"
else
error = request("error")
if error = 1 then Response.Write cb & cuser1 & scb end if
if error = 2 then Response.Write cb & cuser2 & scb end if
if error = 3 then Response.Write cb & cuser3 & scb end if
if error = 4 then Response.Write cb & cuser4 & scb end if
if error = 5 then Response.Write cb & cuser5 & scb end if
if error = 6 then Response.Write cb & cuser6 & scb end if
if error = 7 then Response.Write cb & cuser7 & scb end if
if error = 8 then Response.Write cb & cuser8 & scb end if
if error = 9 then Response.Write cb & cuser9 & scb end if
if error = 10 then Response.Write cb & cuser10 & scb end if
%>
<FORM action="createuser.asp?mode=opret" method=POST id=form1 name=form1>
<br>
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" id="AutoNumber1">
<tr>
<td>Name: </td>
</tr>
<tr>
<td>
<INPUT type="text" name=name value="<%=session("name")%>" size="20"></td>
</tr>
<tr>
<td>Username: </td>
</tr>
<tr>
<td>
<INPUT type="text" name=username value="<%=session("username")%>" size="20"></td>
</tr>
<tr>
<td>Password: </td>
</tr>
<tr>
<td>
<INPUT type="password" name=pass value="<%=session("pass")%>" size="20"></td>
</tr>
<tr>
<td>Password igen: </td>
</tr>
<tr>
<td>
<INPUT type="password" name=pass2 value="<%=session("pass2")%>" size="20"></td>
</tr>
<tr>
<td>Age: </td>
</tr>
<tr>
<td>
<INPUT type="text" id=text1 name=alder value="<%=session("alder")%>" size="20"></td>
</tr>
<tr>
<td>Contry: </td>
</tr>
<tr>
<td>
<INPUT type="text" id=text2 name=land value="<%=session("land")%>" size="20"></td>
</tr>
<tr>
<td>Email: </td>
</tr>
<tr>
<td>
<INPUT type="text" id=text3 name=email value="<%=session("email")%>" size="20"></td>
</tr>
<tr>
<td>Server: </td>
</tr>
<tr>
<td>
<INPUT type="text" name=server value="<%=session("server")%>" size="20"></td>
</tr>
<tr>
<td>
<INPUT type="submit" value="Submit" id=submit1 name=submit1></td>
</tr>
</table>
</center>
</div>
</FORM>
<% end if %>
<!-- #include virtual = "inc/bund.asp" -->
det er så erro fejl nr 10 !!!