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 DEV-Group
 DEV Discussions (General)
 3.4.03 Post_info Archive
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Gurb
Starting Member

8 Posts

Posted - 26 April 2004 :  11:00:06  Show Profile
Hi, i noticed a little bug in the code

If you try to post a new topic from an Archive , everything is fine except the update of the last topic
The query is (line 851)
strSql = "SELECT Max(TOPIC_ID) as NewTopicID "
strSql = strSql & " FROM " & <b>strActivePrefix</b> & "TOPICS "
strSql = strSql & " WHERE FORUM_ID = " & Forum_ID
strSql = strSql & " and T_AUTHOR = " & rs("MEMBER_ID")
set rs9 = my_Conn.Execute (strSql)

And since you came from Archiveview the Archiveview parameter is set to true. So the code updates the table with the last Archived topic_id not with the last posted Topic_id

Perhaps <b>strActivePrefix</b> should be <b>strTablePrefix</b>
Ciao
  Previous Topic Topic Next Topic  
 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.17 seconds. Powered By: Snitz Forums 2000 Version 3.4.07