Avatar billede web4you Nybegynder
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" -->
Avatar billede web4you Nybegynder
16. maj 2002 - 22:29 #1
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 !!!
Avatar billede web4you Nybegynder
20. maj 2002 - 11:14 #2
zez
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
Kurser inden for grundlæggende programmering

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester