Hvorfor vil den kun logge øverste bruger ind?
Hvorfor vil dette login script kun logge den bruger der står øverst i databasen ind i systemet?elseif request(\"mode\") = \"csecurity\" then
sqlAdmin = \"select * from [admin] where [username] = \'\" & request(\"username\") & \"\' and [password] = \'\" & request(\"password\") & \"\'\"
set rsAdmin = conndb.execute(sqlAdmin)
if not (rsAdmin.bof or rsAdmin.eof) then
tmpId = rsAdmin(\"id\")
tmpLevel = 2
tmpRedirect = \"?mode=admin\"
end if
set rsAdmin = nothing
if not tmpRedirect <> \"\" then
sqlKunde = \"select * from [kunder] where [username] = \'\" & request(\"username\") & \"\' and [password] = \'\" & request(\"password\") & \"\'\"
set rsKunde = conndb.execute(sqlKunde)
if not (rsKunde.bof or rsKunde.eof) then
tmpId = rsKunde(\"id\")
tmpLevel = 1
tmpRedirect = \"?mode=groups&id=\" & tmpId & \"\"
end if
set rskunde = nothing
end if
if tmpRedirect <> \"\" then
session(\"sLevel\") = tmpLevel
session(\"sUserId\") = tmpId
response.redirect(\"admin.asp\" & tmpRedirect & \"\")
else
response.redirect(\"default.asp?err=notexist\")
end if
end if
På forhånd tak.
Mvh.
Tue Sandal
tue@qcom.dk
