| Author |
 Topic  |
|
JK_Bowman
New Member
USA
60 Posts |
 Posted - 03 February 2001 : 19:47:28
|
Hey Richard,
Thanks for the speedy reply...
I am using Snitz Forums 2000 Version 3.1 final
J.K. Bowman
http://spider-food.net/forum
|
 |
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 03 February 2001 : 20:13:37
|
The current version of the forum uses strDBNTUserName for getting the member's username from their cookie.
The current version of the forum uses: Request.Cookies(strUniqueID & "User")("Name")
while v3.1 Final used: Request.Cookies(strCookieURL & "User")("Name")
In all of the files associated with the Private Messages mod, I changed it to use strDBNTUserName when looking for the username.
so, the easiest way to fix this for the version you are using is to add the following code to your inc_top.asp file around line #49 of a stock v3.1 Final inc_top.asp file:
strDBNTUserName = Request.Cookies(strCookieURL & "User")("Name")
strDBNTFUserName = Request.Form("Name")
if strAuthType = "nt" then
strDBNTUserName = Session(strCookieURL & "userID")
strDBNTFUserName = Session(strCookieURL & "userID")
end if
Also, on line #57 of privatesend.asp
change this:
strCkPassWord = Request.Cookies(strUniqueID & "User")("Pword")
to this:
strCkPassWord = Request.Cookies(strCookieURL & "User")("Pword")
Also on line #46 of privatedelete.asp
change this:
strSql = strSql & " AND " & strMemberTablePrefix & "MEMBERS.M_PASSWORD = '" & Request.Cookies(strUniqueID & "User")("PWord") & "'"
to this:
strSql = strSql & " AND " & strMemberTablePrefix & "MEMBERS.M_PASSWORD = '" & Request.Cookies(strCookieURL & "User")("PWord") & "'"
Also on line #54 and line #82 of pm_options.asp
change this:
strSql = strSql & " AND " & strMemberTablePrefix & "MEMBERS.M_PASSWORD = '" & Request.Cookies(strUniqueID & "User")("PWord") & "'"
to this:
strSql = strSql & " AND " & strMemberTablePrefix & "MEMBERS.M_PASSWORD = '" & Request.Cookies(strCookieURL & "User")("PWord") & "'"
Edited by - Richard Kinser on 03 February 2001 20:14:57 |
|
|
|
JK_Bowman
New Member
USA
60 Posts |
Posted - 03 February 2001 : 20:18:43
|
Thank you for such a wonderful and detailed answer... :)
However, I really did not realize that I was not using the current version of the forums.
duuuuhhhhhhh...
Should I just upgrade instead?
J.K. Bowman
http://spider-food.net/forum
|
|
|
|
avyworld
Starting Member
USA
48 Posts |
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 03 February 2001 : 20:35:55
|
| If everything on your forum is working like you want, then there really isn't a reason to upgrade. But, all of the mods that are being developed are usually for the latest version. Mike is currently working to squash as many of the current bugs as possible and then will release a stable v3.1 Service Release 5 before he starts on the internationalization and CSS conversion. It would probably be better to wait at least until Service Release 5 is out. |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 03 February 2001 : 20:42:51
|
if y'all are using v3.1 sr2 then you've already got this in your inc_top.asp
STRdbntUserName = Request.Cookies(strCookieURL & "User")("Name")
if strAuthType = "nt" then
STRdbntUserName = Session(strCookieURL & "userID")
end if
So, y'all can probably get away with just editing the other files I mentioned above. But it wouldn't hurt to replace your current code in inc_top.asp with the code I showed above. |
|
|
|
fredzepplin
Starting Member
18 Posts |
Posted - 03 February 2001 : 23:04:07
|
quote:
The current version of the forum uses strDBNTUserName for getting the member's username from their cookie.
The current version of the forum uses: Request.Cookies(strUniqueID & "User")("Name")
while v3.1 Final used: Request.Cookies(strCookieURL & "User")("Name")
In all of the files associated with the Private Messages mod, I changed it to use strDBNTUserName when looking for the username.
so, the easiest way to fix this for the version you are using is to add the following code to your inc_top.asp file around line #49 of a stock v3.1 Final inc_top.asp file:
strDBNTUserName = Request.Cookies(strCookieURL & "User")("Name")
strDBNTFUserName = Request.Form("Name")
if strAuthType = "nt" then
strDBNTUserName = Session(strCookieURL & "userID")
strDBNTFUserName = Session(strCookieURL & "userID")
end if
Also, on line #57 of privatesend.asp
change this:
strCkPassWord = Request.Cookies(strUniqueID & "User")("Pword")
to this:
strCkPassWord = Request.Cookies(strCookieURL & "User")("Pword")
Also on line #46 of privatedelete.asp
change this:
strSql = strSql & " AND " & strMemberTablePrefix & "MEMBERS.M_PASSWORD = '" & Request.Cookies(strUniqueID & "User")("PWord") & "'"
to this:
strSql = strSql & " AND " & strMemberTablePrefix & "MEMBERS.M_PASSWORD = '" & Request.Cookies(strCookieURL & "User")("PWord") & "'"
Also on line #54 and line #82 of pm_options.asp
change this:
strSql = strSql & " AND " & strMemberTablePrefix & "MEMBERS.M_PASSWORD = '" & Request.Cookies(strUniqueID & "User")("PWord") & "'"
to this:
strSql = strSql & " AND " & strMemberTablePrefix & "MEMBERS.M_PASSWORD = '" & Request.Cookies(strCookieURL & "User")("PWord") & "'"
Edited by - Richard Kinser on 03 February 2001 20:14:57
Richard;
The code you put out here, corrected my forums PM completely. (SR2 Final)
Thanks for the code and the fix. works real well.
Sincerely;
JT
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 03 February 2001 : 23:43:26
|
glad to here it.  |
|
|
|
Huntress
New Member
USA
96 Posts |
Posted - 05 February 2001 : 20:09:38
|
Hi guys... First time here.
I'm trying to install this mod and while running mod_dbsetup.asp I get the following error message:
Microsoft VBScript runtime error '800a01ad'
ActiveX component can't create object: 'Scripting.FileSystemObject'
/forum/mod_dbsetup.asp, line 16
This is for the following line of code:
set my_Conn= Server.CreateObject("ADODB.Connection")
I imagine this is server related, but am unsure of how to address it.
Ideas?
Diana
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 05 February 2001 : 20:20:31
|
That means that your server doesn't support the Scripting.FileSystemObject.
Is this your own server or is it hosted somewhere?
You can either add the database fields manually, or I can create a setup script that doesn't require the Scripting.FileSystemObject. |
|
|
|
Bagman007
Starting Member
3 Posts |
Posted - 05 February 2001 : 20:41:43
|
I put this mod on my forums yesterday and it worked perfectly. today the PM thing says "- Log in to check your private messages." even when im already logged in. this message also appears with my other users when they are logged in as well. the PMs function properly except for that small error. could you tell me how to fix it? the forums are at http://user.webrc.ca/bagman007/snitz_forum/default.asp if that helps.
|
|
|
|
Huntress
New Member
USA
96 Posts |
Posted - 05 February 2001 : 21:25:07
|
This is not "my" server, it through a hosting company. Now I could make the modifications myself to the database, but at the moment my FTP is not working (some hosting companies  ) and I've been publishing with FP. I would need to download the database, which I can't do. And then I'd need to know what needs to be modified... But since I can't FTP....
I could also modify the DAO connect, IF I knew what to change it to. Of course assuming it's that easy.
And then of course I could impose on you.
Your choice 
Diana
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 05 February 2001 : 22:14:18
|
Diana,
Here you go: http://www16.brinkster.com/richardk/files/pmdbsetup.zip
just download the file, unzip it and then upload pmdbsetup.asp to your /forum directory. Then just run it from the address bar of your browser like you did with the mod_dbsetup.asp file. |
|
|
|
Huntress
New Member
USA
96 Posts |
Posted - 05 February 2001 : 22:22:45
|
Thank you so much Richard!
Worked like a champ! 
Diana
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 05 February 2001 : 22:30:24
|
| You're welcome Diana |
|
|
|
Topic |
|
Topic Locked
