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

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Authentication: NT
 3.1 Final - NT Errors ??
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Kal Corp
Average Member

USA
878 Posts

Posted - 07 October 2000 :  12:50:43  Show Profile  Visit Kal Corp's Homepage
I had to update some code to get NT working with 3.1 Final. I dont know if it was correct to do and if it will stop db form working, Please check it out <img src=icon_smile.gif border=0 align=middle>

Some things I have noticed

<b>In Default.asp</b>

sub ForumAdminOptions()
if (mLev = 4) or (chkForumModerator(rsForum("FORUM_ID"), <font color=red>Session(strCookieURL & "username")</font id=red>)= "1") or (chkForumModerator(rsForum("FORUM_ID"), Request.Cookies(strCookieURL & "User")("Name")) = "1") or (lcase(strNoCookies) = "1") then

<b>I think should be, Because Admin Icons not showing if not updated</b>

sub ForumAdminOptions()
if (mLev = 4) or (chkForumModerator(rsForum("FORUM_ID"), <font color=red>Session(strCookieURL & "userID")</font id=red>)= "1") or (chkForumModerator(rsForum("FORUM_ID"), Request.Cookies(strCookieURL & "User")("Name")) = "1") or (lcase(strNoCookies) = "1") then

<b>Every where in Post_info.asp</b>

if strAuthType="nt" and chkForumModerator(Request.Form("FORUM_ID"), <font color=red>session ("userid")</font id=red>) = "0" then

Go_Result "Only Admins, Moderators and the Author can change this post", 0

end if

<b>I think should be, Can not save Changes from EditForum without this </b>

if strAuthType="nt" and chkForumModerator(Request.Form("FORUM_ID"), <font color=red>Session(strCookieURL & "userID")</font id=red>) = "0" then

Go_Result "Only Admins, Moderators and the Author can change this post", 0

end if

<b>In post.asp, I had to make to updates on 2 lines. Do a search for chkForumModerator</b>

(chkForumModerator(strRqForumId, <font color=red>Session(strCookieURL & "userid")</font id=red>) = "1"))


Edited by - kal corp on 07 October 2000 13:04:15

Kal Corp
Average Member

USA
878 Posts

Posted - 07 October 2000 :  13:43:58  Show Profile  Visit Kal Corp's Homepage
<b>also in Pop_profile.asp

Addedd to case "EditIt" so that users could edit there profiles</b>

strSql = strSql & " WHERE M_NAME = '" & Request.Form("Name") & "' "
<font color=red>if strAuthType = "db" then </font id=red>
strSql = strSql & " AND M_PASSWORD = '" & Request.Form("Password-d") & "'"
<font color=red>end if</font id=red>
my_Conn.Execute(strSql)
Go to Top of Page

Kal Corp
Average Member

USA
878 Posts

Posted - 11 October 2000 :  16:40:22  Show Profile  Visit Kal Corp's Homepage
<b>In post_info.asp


had to update , Was getting errors in NT mode. </b>

'## Forum_SQL - Update Last Post
strSql = " UPDATE " & strTablePrefix & "FORUM"
strSql = strSql & " SET F_LAST_POST = '" & DateToStr(strForumTimeAdjust) & "'"
strSql = strSql & ", F_LAST_POST_AUTHOR = " & getMemberID(<font color=red>Session(strCookieURL & "username")</font id=red>)
strSql = strSql & " WHERE FORUM_ID = " & Request.Form("FORUM_ID")

my_Conn.Execute (strSql)

'## Forum_SQL - Update Last Post
strSql = " UPDATE " & strTablePrefix & "TOPICS"
strSql = strSql & " SET T_LAST_POST = '" & DateToStr(strForumTimeAdjust) & "'"
strSql = strSql & ", T_LAST_POST_AUTHOR = " & getMemberID(<font color=red>Session(strCookieURL & "username")</font id=red>)
strSql = strSql & " WHERE TOPIC_ID = " & Request.Form("TOPIC_ID")

my_Conn.Execute (strSql)



test Signature
Go to Top of Page

Kal Corp
Average Member

USA
878 Posts

Posted - 12 October 2000 :  01:40:30  Show Profile  Visit Kal Corp's Homepage
These updated have been added to the "Better db and nt migration" mod

Found at http://forum.snitz.com/forum/topic.asp?TOPIC_ID=1224&FORUM_ID=25&CAT_ID=1
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.12 seconds. Powered By: Snitz Forums 2000 Version 3.4.07