| Author |
 Topic  |
|
philsbbs
Junior Member
United Kingdom
397 Posts |
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
|
|
a10
Starting Member
United States
22 Posts |
 Posted - 13 October 2003 : 20:42:10
|
I would like to use this mod on my forums rather than the who viewed this mod. The reason I prefer this one is because only moderators/admins have this ability.
Can someone who has installed this tell me how difficult it was?
I tried going to Nikkol's demo site but none of the username/password combos mentioned here work, I would also like to see it in action.
Any help is appreciated. Thanks. |
 |
|
|
zin
Starting Member
12 Posts |
Posted - 12 November 2003 : 16:24:13
|
I hate bumping up an old topic but I need to ask... I've installed this on my MS-SQL forum which is currently only being used by mods & admins to revamp.. I've read in this thread that this MOD does work with MS-SQL so my question is... does it only add non-mods & admins who have read a thread? because so far it indicates that no threads have been read by anyone even though they have.
|
|
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
|
|
zin
Starting Member
12 Posts |
Posted - 12 November 2003 : 18:57:13
|
this is odd. only one record. one topic is known to have been read by one person who is an admin.
|
|
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
Posted - 12 November 2003 : 19:20:18
|
looks like it is not writing to the database. it's been a while since i even looked at the code for this mod and at the moment my computer is running slow as molasses, so hopefully someone can pick up the slack for me.
check to make sure you did not overwrite the lines in topic.asp for the mod. maybe you installed another mod and overwrote that file? |
Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~ |
|
|
|
zin
Starting Member
12 Posts |
Posted - 12 November 2003 : 19:55:26
|
****.. but isn't it weird that it wrote once? anyway for those who don't have molasses for computers here's the code in topic.asp which is supposed to write to the database...
'===================================WHO READ MOD============================================
'check for existance of record in table for this topic and member
strSql = "SELECT COUNT(*) FROM " & strTablePrefix & "READ_TOPICS " &_
"WHERE MEMBER_ID = " & MemberID & " AND TOPIC_ID = " & Topic_ID
set rsChkLR = my_Conn.execute(strSql)
intChkLR = rsChkLR(0)
rsChkLR.close
set rsChkLR = Nothing
if intChkLR > 0 then 'update record
strSql = "UPDATE " & strTablePrefix & "READ_TOPICS " &_
"SET LAST_READ_DATE = '" & DateToStr(strForumTimeAdjust) & "' " &_
"WHERE MEMBER_ID = " & MemberID &_
" AND TOPIC_ID = " & Topic_ID
else 'insert record
strSql = "INSERT INTO " & strTablePrefix & "READ_TOPICS " &_
"(MEMBER_ID, TOPIC_ID, LAST_READ_DATE) VALUES " &_
"(" & MemberID & ", " & Topic_ID & ", '" & DateToStr(strForumTimeAdjust) & "')"
end if
my_Conn.execute(strSql)
'===========================================================================================
|
|
|
|
zin
Starting Member
12 Posts |
Posted - 12 November 2003 : 22:37:49
|
nm fixed it - it got caught up in all the Poll Mod code.. although I followed instructions which said
Step 3 - at approximately line 398 of topic.asp add the following code
where indicated:
set rsReplies = nothing
end if
Right after that was a whole lot of code for the Poll MOD so you need to put the Who Read MOD just before Response.Write " <table border=""0"" width=""100%"">" & vbNewLine & _ which is a lot further down.. |
|
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
|
|
RichLondoner
Starting Member
United Kingdom
43 Posts |
Posted - 14 November 2003 : 08:23:12
|
Microsoft OLE DB Provider for SQL Server error '80040e14'
Cannot insert explicit value for identity column in table 'FORUM_READ_TOPICS' when IDENTITY_INSERT is set to OFF.
/dp/apps/snitz/topic.asp, line 577
MS SQL I built the tables myself from looking at the instructions.txt file
Line 577 is:
my_Conn.execute(strSql)
At the bottom of the Who Read Mod insert into topic.asp In also have poll mod working there and just put the Who Rad Mod insertation after the Poll Mod code...
Anybody?
Thanks
|
Richard Mills
http://www.mysector.co.uk |
|
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
Posted - 14 November 2003 : 09:07:08
|
| Looks like you must not have built the table correctly. If I remember correctly, there is no identity column in that table. you must have set one of the fields to be an identity column. |
Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~ |
|
|
|
RichLondoner
Starting Member
United Kingdom
43 Posts |
Posted - 14 November 2003 : 10:09:04
|
| Yep, it's working now... took out Identity and primary key, thought it must be something to do with that... also added a couple of index's too... |
Richard Mills
http://www.mysector.co.uk |
|
|
|
robosport
New Member
USA
64 Posts |
Posted - 28 November 2003 : 15:01:23
|
Nikkol,
Excellent mod. Easy to install. I second zin's comment for anyone installing this one that if you have the poll mod already installed, make sure the instruction "approximately line 398 of topic.asp" is interpreted as "insert after the poll mod code near line 398 of topic.asp".
Really well done.
Thanks,
robo |
|
|
|
olef
Starting Member
Denmark
19 Posts |
Posted - 30 November 2003 : 17:35:20
|
Hi Nokkol
Have looked a long time for a mod like Yours.
Now I found it, but when I click on Your link ti the mod, it doesn't excist. Can You help me please ?
Best regards
Ole Fisker |
|
|
|
Topic |
|
Topic Locked
