| Author |
 Topic  |
|
extrafree
New Member
54 Posts |
 Posted - 19 November 2001 : 10:48:14
|
thank you very much for your help,but It not work!
I was thinking that i had change dbs file
IN RED
See who has viewed & replied to topics
[ALTER]
TOPICS
ADD#T_WHOVIEWED#VARCHAR (255)#NULL#
[END]
[ALTER]WITH THIS:
[CREATE]
A_TOPICS
ADD#T_WHOVIEWED#VARCHAR (255)#NULL#
[END]
becouse it gave me : table not exist,
so i had created it
the italian golden forum
|
 |
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
Posted - 19 November 2001 : 10:51:47
|
yes remove that entire part:
[ALTER]
[CREATE]
A_TOPICS
ADD#T_WHOVIEWED#VARCHAR (255)#NULL#
[END]
----
-Eric | Mod Resource | Test Area
"A program is a device used to convert data into error messages."
http://phpscriptcenter.com -Quality PHP Scripts |
|
|
|
extrafree
New Member
54 Posts |
Posted - 19 November 2001 : 10:59:35
|
sorry but I'm italian so I don't undestand english very well,
I was telling you that I remove [alter] and I add [create]
but I deleted [alter]
than i made mod _dbsetup
with this:
See who has viewed & replied to topics
[ALTER]
TOPICS
ADD#T_WHOVIEWED#VARCHAR (255)#NULL#
[END]
[CREATE]
A_TOPICS
ADD#T_WHOVIEWED#VARCHAR (255)#NULL#
[END]
the italian golden forum
|
|
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
Posted - 19 November 2001 : 11:09:02
|
You need to remove the CREATE - Since your forum does not have archives, that entire section is not needed - and I updated your topic.asp to reflect that.
----
-Eric | Mod Resource | Test Area
"A program is a device used to convert data into error messages."
http://phpscriptcenter.com -Quality PHP Scripts |
|
|
|
extrafree
New Member
54 Posts |
Posted - 19 November 2001 : 11:30:51
|
I have removed tables, but dosn't work! :(
the italian golden forum
Edited by - extrafree on 19 November 2001 11:32:21 |
|
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
Posted - 19 November 2001 : 11:41:17
|
I wrote this specifically for 3.3, I cant think of anything else that might be causing the view count not to work :( I'm not as familiar with 3.1 code as I used to be.
----
-Eric | Mod Resource | Test Area
"A program is a device used to convert data into error messages."
http://phpscriptcenter.com -Quality PHP Scripts |
|
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 19 November 2001 : 13:18:36
|
I am slowly but surely getting this to work on 3.1!!! things to consider for those of you trying to convert 3.3 mods to 3.1:
- strActivePrefix change to strTablePrefix
- "TOPICS.TOPIC_ID = " & Topic_ID change to "TOPICS.TOPIC_ID = " & Request.QueryString("TOPIC_ID")
- omit Archive portions
so far I can get the Who Viewed field populated so I am quite sure we can get this running on 3.1, if I get it done soon I will share with all.
Great mod by the way. I was getting complaints awhile back because some members wanted to know if admin or moderators have read the topic. I had considered making a mod that showed if the topic was read by admin or moderator but this one is better.
Oh and nice use of taking advantage of one field and making it comma delimited. I haven't completed checked all the code yet, but do you remove redundant entries?
____________
dayve
http://www.nineinchnailz.com/forum
Edited by - dayve on 19 November 2001 13:21:37 |
|
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
Posted - 19 November 2001 : 13:22:02
|
When the member ID is inserted into the view field (yes comma delimited) it is first checked to see if it is already in there. If it is no update is done.
As for the replies, no extra database stuff is done there, so I did a SELECT DISTINCT on that one, so it only shows people who replied more than once, one time in the list.
As soon as this proves stable enough I'll see if I cant add the number of times each user has replied.
----
-Eric | Mod Resource | Test Area
"A program is a device used to convert data into error messages."
http://phpscriptcenter.com -Quality PHP Scripts |
|
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 19 November 2001 : 13:31:05
|
SUCCESS!!! Got it working and will package it up for 3.1
Demo coming soon... great job STIM...
____________
dayve
http://www.nineinchnailz.com/forum |
|
|
|
extrafree
New Member
54 Posts |
Posted - 19 November 2001 : 14:04:24
|
It's a great mod..
I'm waiting for 3.1 package!
thank everybody  
the italian golden forum
|
|
|
|
suhern
Junior Member
186 Posts |
Posted - 19 November 2001 : 22:28:49
|
Hi Stim,
Just want to say again that it's great mod. But I do have an interesting issue - I cannot see my own username on the topic view pop up despite the fact that I read it. When I login with other usernames (including one that has admin right), these usernames are captured. Only one particular admin account is not captured and the strangest part of it is that it was captured yesterday.... but today it is not....
Your help would be most appreciated. thanks and cheers
|
|
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
Posted - 19 November 2001 : 23:03:42
|
Yeah I think I know what's causing that...
Your admin ID is probably 1 or something in the low numbers, so if someone with the member ID of 10 reads it, when you read it, it wont update the database because it sees the '1' in there.
I'm working on a fix for this right now - shouldnt be too hard.
----
-Eric | Mod Resource | Test Area
"A program is a device used to convert data into error messages."
http://phpscriptcenter.com -Quality PHP Scripts |
|
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
Posted - 19 November 2001 : 23:54:14
|
Fix - included in zip
----
-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 20 November 2001 06:39:25 |
|
|
|
GauravBhabu
Advanced Member
4288 Posts |
Posted - 20 November 2001 : 00:24:52
|
If Instr(Topic_WhoViewed, "," & MemberID) > 0 or _
Stim, if MemberID 11 is already stored or any MemberID begining with 1 is already stored, the above condition will be true for MemberID 1 and that will not be stored.
Applies to all numbers
when 2nn is already stored - MemberID 2 won't be stored
when 3nn is already stored - MemberID 3 won't be stored
when 4nn is already stored - MemberID 4 won't be stored
GauravBhabu
There is only one miracle...That is LIFE! | It is difficult to IMPROVE on Perfection, There is no harm in Keep Trying. |
|
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
|
|
Topic |
|
Topic Locked
