Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Snitz Forums 2000 DEV-Group
 DEV Bug Reports (Closed)
 NT Bug (all versions)		  Forum Locked  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

davemaxwell
Access 2000 Support Moderator

USA
3020 Posts
Posted - 31 May 2001 :  14:18:38  Show Profile  Visit davemaxwell's Homepage  Send davemaxwell an AOL message  Send davemaxwell an ICQ Message  Send davemaxwell a Yahoo! Message
There is a post here http://forum.snitz.com/forum/link.asp?TOPIC_ID=10140 which reported a problem with getting the signature in NT mode. I looked at it a little closer and found it wasn't looking at the right field on the member table. I then noticed it is happening in more than one place.

Basically in inc_functions, anywhere it has this:
strSql = strSql & " WHERE M_NAME = '" & Request.Form("UserName") & "'"

It should have this:
StrSql = strSql & " WHERE " & strMemberTablePrefix & "MEMBERS." & strDBNTSQLName & " = '" & fUserName & "' "

On a quick glance, I found it in these functions:
GetMemberNumber
GetMemberID
GetSig

we also need to make sure that where these functions are called, we are passing strDBNTUserName instead of the cookie name (though they should be the same)

Dave Maxwell
--------------
Proud to be a "World Class" Knucklehead

Davio
Development Team Member

Jamaica
12217 Posts
Posted - 07 June 2001 :  17:20:32  Show Profile
Also found another NT bug. In regard to this post link.asp?TOPIC_ID=10926 admins are not able to lock topics as it says "No Permissions to Lock Forum".

In pop_lock.asp find all instances of the following code:
mLev = cint(ChkUser2(Request.Form("user"), Request.Form("Pass")))
change it to this:
mLev = cint(ChkUser2(strDBNTFUserName, Request.Form("Pass")))
It should appear 4 times in the file.
Go to Top of Page

davemaxwell
Access 2000 Support Moderator

USA
3020 Posts
Posted - 08 June 2001 :  07:55:15  Show Profile  Visit davemaxwell's Homepage  Send davemaxwell an AOL message  Send davemaxwell an ICQ Message  Send davemaxwell a Yahoo! Message
For that to work, this also needs to be added to the top of pop_lock.asp(got it out of pop_delete.asp). Otherwise db mode will not work properly....


if strAuthType = "db" then
	strDBNTUserName = Request.Form("User")
end if


Dave Maxwell
--------------
Proud to be a "World Class" Knucklehead
Go to Top of Page

Davio
Development Team Member

Jamaica
12217 Posts
Posted - 08 June 2001 :  08:21:07  Show Profile
hmm, I don't see why we would need to define strDBNTUsername again, when strDBNTFUsername is already defined in inc_top_short.asp file which is included already.
strDBNTUserName = Request.Cookies(strUniqueID & "User")("Name")
strDBNTFUserName = Request.Form("Name")
if strAuthType = "nt" then
	strDBNTUserName = Session(strCookieURL & "userID")
	strDBNTFUserName = Session(strCookieURL & "userID")
end if
Go to Top of Page

marpacwm
Starting Member

Canada
33 Posts
Posted - 08 June 2001 :  10:51:51  Show Profile
Just found out that the string change is required in pop_open.asp as well. If this file is left unmodified, an Admin/moderator can lock the forum, but then cannot unlock it.



Jim Trick
Go to Top of Page

davemaxwell
Access 2000 Support Moderator

USA
3020 Posts
Posted - 08 June 2001 :  14:16:12  Show Profile  Visit davemaxwell's Homepage  Send davemaxwell an AOL message  Send davemaxwell an ICQ Message  Send davemaxwell a Yahoo! Message
quote:

hmm, I don't see why we would need to define strDBNTUsername again, when strDBNTFUsername is already defined in inc_top_short.asp file which is included already.
strDBNTUserName = Request.Cookies(strUniqueID & "User")("Name")
strDBNTFUserName = Request.Form("Name")
if strAuthType = "nt" then
	strDBNTUserName = Session(strCookieURL & "userID")
	strDBNTFUserName = Session(strCookieURL & "userID")
end if



So it is......then the rest of the pop_delete needs to change from using strDBNTUsername, which is what is being used now, to strDBNTFusername.

Dave Maxwell
--------------
Proud to be a "World Class" Knucklehead
Go to Top of Page

mclek
New Member

Australia
50 Posts
Posted - 03 July 2001 :  01:19:55  Show Profile
I was also having this problem.

As suggested by Davio (thanks), I have changed all instances of:
mLev = cint(ChkUser2(Request.Form("user"), Request.Form("Pass")))
to
mLev = cint(ChkUser2(strDBNTFUserName, Request.Form("Pass")))
in pop_lock.asp and pop_open.asp.

Additionally I changed all instances of
mLev = cint(ChkUser(Request.Form("user"), Request.Form("Pass")))
to
mLev = cint(ChkUser(strDBNTFUserName, Request.Form("Pass")))


Out of interest anyone know what the purpose of ChkUser2 is as opposed to ChkUser?

Thanks,
Kym.



Edited by - mclek on 03 July 2001 01:21:47

Edited by - mclek on 03 July 2001 01:27:13
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts
Posted - 22 July 2001 :  15:32:24  Show Profile  Visit HuwR's Homepage
fixed in 3.3 code, also chkuser2 has now been removed and chkuser used instead
Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000 Version 3.4.07