usch, nu börjar jag bli riktigt trött på det här... :(
Känns som om jag har testat allt nu, och ingenting fungerar... hjärnsläpp?
Solbulle: med din funktion får jag bara ett tomt värde... :(
Här kommer login.asp (loginformuläret)
<%
Dim ckiUserName, ckiUserPass, ckiRedir, blnCheck, objConn, ckiUserId, strSQL, blnUserCheck, objRs, strQueryString, strServerName, strScriptName, strURL
ckiUserId = Request.Cookies("userid")
ckiUserName = Request.Cookies("username")
ckiUserPass = Request.Cookies("password")
ckiRedir = Request.Cookies("redir")
Function GetCurrentURL()
strQueryString = Request.QueryString
strScriptName = Request.ServerVariables("SCRIPT_NAME")
strURL = strScriptName
If strQueryString <> "" Then
strURL = strURL & "?" & strQueryString
End If
GetCurrentURL = strURL
End Function
URL = GetCurrentURL()
If Len(ckiUserId) <> 0 Then
set connection = Server.CreateObject("ADODB.Connection")
Connection.Open "databasen"
set rs = Server.CreateObject("adodb.Recordset")
stm ="SELECT autolog FROM Users WHERE (id =" & ckiUserId & ");"
set rs = Connection.Execute(STM)
rs.close
set rs = nothing
connection.close
set connection=nothing
End If
If Len(ckiUserName) <> 0 Then
blnUserCheck = " checked"
End If
%>
<table width="170" border="0" cellspacing="0" cellpadding="10">
<tr>
<td>
<form action="logincheck.asp?URL=<%=URL%>" onSubmit="return verify()" method="post" name="login" id="login">
<table width="150" border="0" cellspacing="0" cellpadding="0" align="left">
<tr>
<td valign="top"> <img src="images/transp.gif" width="1" height="6"><br>
<b class=rubrik6>Log in!</b><br>
<br>
Username:
<input name="username" type="text" id="username2" style="width: 100%;" value="<%=ckiUserName%>" size="18" />
<br />
Password:
<input name="password" type="password" id="password2" style="width: 100%;" value="<%=ckiUserPass%>" size="18" />
<br>
<input type="checkbox" name="rem" value="true" <%=blnUserCheck %> style="background-color: transparent;"> Remember me<br>
<br />
<input name="Submit" type="image" style="background-color: transparent; border: none;" src="images/login.gif" alt=" Log in " align="right" width="40" height="13" />
</td>
</tr>
</table>
</form>
</td>
</tr>
</table>
Och här är logincheck.asp (kontrollerar inloggningen)
<%
response.buffer=true
function fixa(fix)
fix = Replace(fix,"'","''")
fix = Replace(fix,"|","")
fixa = fix
end function
username = Request.Form("username")
password = Request.Form("password")
If Request.Form("rem") = "true" Then
Response.Cookies("username") = username
Response.Cookies("username").Expires = date() + 365
Response.Cookies("password") = password
Response.Cookies("password").Expires = date() + 365
End If
set connection = Server.CreateObject("ADODB.Connection")
Connection.Open "databasen"
stm = "SELECT username, password, nick, inactive, id, tidszon, klubbid FROM Users WHERE username = '"& fixa(username) &"' AND password= '"&fixa(password)&"' AND Inactive = 0"
set rs = connection.execute(stm)
If NOT(Rs.BOF AND Rs.EOF) Then
session("userid") = rs("id")
session("user") = rs("id") & status
session("username") = rs("username")
session("nick") = rs("nick")
session("password") = rs("password")
session("klubbid") = rs("klubbid")
session("timezone") = CINT(rs("tidszon"))
URL = request.querystring("URL")
MYMESSAGE = Server.URLEncode("Logging in.<p>Please wait...")
Response.Redirect ("delay.asp?DELAY_TIME=3&DELAY_MESSAGE=" & MYMESSAGE & "&REDIRECT_URL="&URL&"")
Else
MYMESSAGE = Server.URLEncode("An error has accured.<p>Please check your username and password!<p>Please wait...<p>")
Response.Redirect ("delay.asp?DELAY_TIME=3&DELAY_MESSAGE=" & MYMESSAGE & "&REDIRECT_URL=javascript:history.back(1)")
End If
rs.close
set rs = nothing
connection.close
set connection = nothing
%>
Om nån skulle vilja vara så snäll och hjälpa mig fixa detta, jag blir galen!
mvh
//G8