Snitz Forums 2000 - BUG+FIX (3.1srX): Read counter is not updating

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Snitz Forums 2000 DEV-Group

DEV Bug Reports (Closed)

BUG+FIX (3.1srX): Read counter is not updating

Forum Locked

Topic Locked

Printer Friendly

Author

Topic

Silverbeard
Starting Member

United Kingdom
1 Posts

Posted - 05 February 2001 : 13:56:13

Clicking on the page 2 link of an active thread will not update the 'Read' counter. However, clicking on the thread title link or the Page 1 link will update and increment the 'Read' counter by one.

Although it is SR3, i have tried doing the same thing on the snitz website, and the same thing occurs.

Edited by - Silverbeard on 05 February 2001 14:06:17

Edited by - huwr on 05 February 2001 16:19:02

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 05 February 2001 : 16:18:15

Just to confirm this as a bug.

The problem is the UPDATE code is in the Getfirst() function, so is only called when the first page is displayed.

solution. at the end of getfirst() is the following code.


'## Forum_SQL
strSql = "UPDATE " & strTablePrefix & "TOPICS "
strSql = strSql & " SET " & strTablePrefix & "TOPICS.T_VIEW_COUNT = (" & strTablePrefix & "TOPICS.T_VIEW_COUNT + 1) "
strSql = strSql & " WHERE (" & strTablePrefix & "TOPICS.TOPIC_ID = " & Request.QueryString("TOPIC_ID") & ");"

my_conn.Execute (strSql)

cut the code, and then look for the call to Getfirst(), should look like


if mypage = 1 then 
	Call GetFirst() 
end if

paste the code you have just cut imediately after the end if.

'Resistance is futile'

Reinsnitz
Snitz Forums Admin

USA
3545 Posts

Posted - 19 February 2001 : 22:16:41

fixed in the source of sf2k_31sr5a7.zip

Reinsnitz (Mike)
><)))'>
"Therefore go and make disciples of all nations,..." Matthew 28:19a

Topic

Forum Locked

Topic Locked

Printer Friendly

Jump To:

Snitz Forums 2000

This page was generated in 0.1 seconds.