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 MOD-Group
 MOD Add-On Forum (W/Code)
 Topic View and Reply Voyeur MOD for 3.3
 New Topic  Topic Locked
 Printer Friendly
Next Page
Author Previous Topic Topic Next Topic
Page: of 4

Da_Stimulator
DEV Team Forum Moderator

USA
3373 Posts

Posted - 19 November 2001 :  01:54:13  Show Profile  Send Da_Stimulator an AOL message  Send Da_Stimulator a Yahoo! Message
Author: me
Download: Download Here
For Snitz Version 3.1 version go here
NOTE This is for 3.3 only, please do not attempt to fit with an earlier version unless well versed in ASP

Detailed instructions included.

This allows you and your visitors to see who has replied and who has viewed topics.

It places a link on the numbers 'Read' and 'Viewed' - next to each topic. If a person has replied to a post more than once, his/her name will only show up once in the list.

Please note this is NOT compatible with Davios Anonymous access mod without some modification to the code.

Screenshots Below:



To see a Demo go here, go into a forum and check it out for yourself.

----
-Eric (da_stimulator)
Stims Snitz Test area
Snitz Mod Resource
PHP Script Center -Quality PHP Scripts

Edited by - da_stimulator on 19 November 2001 09:46:29

Edited by - da_stimulator on 19 November 2001 15:27:38

Edited by - da_stimulator on 19 November 2001 15:29:17

Da_Stimulator
DEV Team Forum Moderator

USA
3373 Posts

Posted - 19 November 2001 :  07:42:11  Show Profile  Send Da_Stimulator an AOL message  Send Da_Stimulator a Yahoo! Message
Note: Demo currently down

Demo now working

----
-Eric | Mod Resource | Test Area
"A program is a device used to convert data into error messages."
http://phpscriptcenter.com -Quality PHP Scripts

Edited by - da_stimulator on 19 November 2001 08:40:52
Go to Top of Page

suhern
Junior Member

186 Posts

Posted - 19 November 2001 :  08:28:08  Show Profile
Nice mod. I installed it without any problem. thanks..

Go to Top of Page

extrafree
New Member

54 Posts

Posted - 19 November 2001 :  08:49:35  Show Profile  Visit extrafree's Homepage
I have 3.1 version I replace strActive with strTable
it show only replaces don't show viewed!!
any idea?

the italian golden forum
Go to Top of Page

Da_Stimulator
DEV Team Forum Moderator

USA
3373 Posts

Posted - 19 November 2001 :  08:58:36  Show Profile  Send Da_Stimulator an AOL message  Send Da_Stimulator a Yahoo! Message
If you modified pop_show_replies.asp - you should either un-do them or download and re-install that. That file does not need to be changed at all to be compatible with 3.1

Can you tell me where you changed strActivePrefix to strTablePrefix? the only file you should have changed this in is topic.asp

I dont believe 3.1 has the GetMemberNumber function nor stores the MemberID into a string. Add this to your inc_functions.asp file (if it is not already there)


function getMemberNumber(fUser_Name)
'## Forum_SQL
strSql = "SELECT " & strMemberTablePrefix & "MEMBERS.MEMBER_ID "
strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS "
strSql = strSql & " WHERE " & strDBNTSQLName & " = '" & fUser_Name & "'"

Set rsGetMemberNumber = Server.CreateObject("ADODB.Recordset")
rsGetMemberNumber.open strSql, my_Conn

if rsGetMemberNumber.EOF or rsGetMemberNumber.BOF then
getMemberNumber = -1
rsGetMemberNumber.close
set rsGetMemberNumber = nothing
exit function
end if

getMemberNumber = rsGetMemberNumber("MEMBER_ID")

rsGetMemberNumber.close
set rsGetMemberNumber = nothing
end function


And then add the following right before the rest of the code that was added for this mod in Topic.asp

MemberID = getMemberNumber(strDBNTUserName)

----
-Eric | Mod Resource | Test Area
"A program is a device used to convert data into error messages."
http://phpscriptcenter.com -Quality PHP Scripts
Go to Top of Page

extrafree
New Member

54 Posts

Posted - 19 November 2001 :  09:17:45  Show Profile  Visit extrafree's Homepage
in my inc_function I have this:

function getMemberNumber(fUser_Name)

'## Forum_SQL
strSql = "SELECT " & strMemberTablePrefix & "MEMBERS.MEMBER_ID "
strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS "
strSql = strSql & " WHERE M_NAME = '" & fUser_Name & "'"

set rsGetMemberID = my_Conn.Execute(strSql)

if rsGetMemberID.EOF or rsGetMemberID.BOF then
getMemberNumber = -1
exit function
end if
getMemberNumber = rsGetMemberID("MEMBER_ID")
end function

Now I overwrite modifieds files with your original script
it work like before! but it don't show viewed!

I don't undestand where do I have to insert exatly this:

MemberID = getMemberNumber(strDBNTUserName)

thanks


the italian golden forum
Go to Top of Page

Da_Stimulator
DEV Team Forum Moderator

USA
3373 Posts

Posted - 19 November 2001 :  09:24:33  Show Profile  Send Da_Stimulator an AOL message  Send Da_Stimulator a Yahoo! Message
The code you should add is below in blue

Find the following in topic.asp:

'--------------- TOPIC AND REPLY VIEW
if MemberID = 0 or IsNull(MemberID) then
'dont update anything
else
strsql = "SELECT " & strActivePrefix & "TOPICS.T_WHOVIEWED FROM " & strActivePrefix & "TOPICS WHERE "


And make it look like the following:

'--------------- TOPIC AND REPLY VIEW
MemberID = getMemberNumber(strDBNTUserName)
if MemberID = 0 or IsNull(MemberID) then
'dont update anything
else
strsql = "SELECT " & strActivePrefix & "TOPICS.T_WHOVIEWED FROM " & strActivePrefix & "TOPICS WHERE "
.................


----
-Eric | Mod Resource | Test Area
"A program is a device used to convert data into error messages."
http://phpscriptcenter.com -Quality PHP Scripts
Go to Top of Page

Da_Stimulator
DEV Team Forum Moderator

USA
3373 Posts

Posted - 19 November 2001 :  09:30:20  Show Profile  Send Da_Stimulator an AOL message  Send Da_Stimulator a Yahoo! Message
You should also change this line:

if MemberID = 0 or IsNull(MemberID) then


to look like the following:

if MemberID = 0 or IsNull(MemberID) or MemberID = -1 then

----
-Eric | Mod Resource | Test Area
"A program is a device used to convert data into error messages."
http://phpscriptcenter.com -Quality PHP Scripts
Go to Top of Page

extrafree
New Member

54 Posts

Posted - 19 November 2001 :  09:38:10  Show Profile  Visit extrafree's Homepage
nothing to do!!
every thing i do!
It show replays but don't show viewed!!


the italian golden forum
Go to Top of Page

Da_Stimulator
DEV Team Forum Moderator

USA
3373 Posts

Posted - 19 November 2001 :  09:45:13  Show Profile  Send Da_Stimulator an AOL message  Send Da_Stimulator a Yahoo! Message
Are you recieving an error message, or is it just not showing anything?

Please note that it will not show any views until someone has viewed the topic after you installed this mod.

----
-Eric | Mod Resource | Test Area
"A program is a device used to convert data into error messages."
http://phpscriptcenter.com -Quality PHP Scripts
Go to Top of Page

extrafree
New Member

54 Posts

Posted - 19 November 2001 :  10:04:18  Show Profile  Visit extrafree's Homepage
no error !! just not show users name of viewed!
let's a look

http://www.extrafree.it/TESTforum/FORUM.asp?FORUM_ID=38&CAT_ID=1&Forum_Title=Suggerimenti

the italian golden forum
Go to Top of Page

Da_Stimulator
DEV Team Forum Moderator

USA
3373 Posts

Posted - 19 November 2001 :  10:08:17  Show Profile  Send Da_Stimulator an AOL message  Send Da_Stimulator a Yahoo! Message
extrafree, I'm experiencing errors all over your forum, especially the registration process - I cannot properly test it.

----
-Eric | Mod Resource | Test Area
"A program is a device used to convert data into error messages."
http://phpscriptcenter.com -Quality PHP Scripts

Edited by - da_stimulator on 19 November 2001 10:09:00
Go to Top of Page

extrafree
New Member

54 Posts

Posted - 19 November 2001 :  10:12:05  Show Profile  Visit extrafree's Homepage
user name= m
password= 0
thank

the italian golden forum
Go to Top of Page

Da_Stimulator
DEV Team Forum Moderator

USA
3373 Posts

Posted - 19 November 2001 :  10:15:54  Show Profile  Send Da_Stimulator an AOL message  Send Da_Stimulator a Yahoo! Message
Ok, can you email your topic.asp to yap@eboxmail.net ?

I'll take a look at it and see if I can find out whats wrong.

----
-Eric | Mod Resource | Test Area
"A program is a device used to convert data into error messages."
http://phpscriptcenter.com -Quality PHP Scripts
Go to Top of Page

extrafree
New Member

54 Posts

Posted - 19 November 2001 :  10:21:31  Show Profile  Visit extrafree's Homepage
this is my topic.asp zip file!
http://www.extrafree.it/topic.zip

the italian golden forum


Edited by - extrafree on 19 November 2001 10:22:30
Go to Top of Page

Da_Stimulator
DEV Team Forum Moderator

USA
3373 Posts

Posted - 19 November 2001 :  10:34:55  Show Profile  Send Da_Stimulator an AOL message  Send Da_Stimulator a Yahoo! Message
I emailed you the updated file through your email addy listed in your profile.

----
-Eric | Mod Resource | Test Area
"A program is a device used to convert data into error messages."
http://phpscriptcenter.com -Quality PHP Scripts
Go to Top of Page
Page: of 4 Previous Topic Topic Next Topic  
Next Page
 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.2 seconds. Powered By: Snitz Forums 2000 Version 3.4.07