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 Bug Reports (Closed)
 v3.3 BUG+FIX: Subscription not set creating forum
 Forum Locked  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Nikkol
Forum Moderator

USA
6907 Posts

Posted - 10 February 2002 :  02:24:40  Show Profile
I've found that when creating a new forum the selected Subscription choice is not inserted into the database correctly with the new record.

The problem occurs in post_info.asp in the section beginning with
if MethodType = "Forum" then
Several lines down, the code reads:


' DEM --> Start of Code added for moderation and subscription
if strSubscription = 1 and CatSubscription > 0 then
strSql = strSql & ", " & fSubscription
else
strSql = strSql & ", 0"
end if


The problem occurs with strSubscription = 1 which means that Whole Board subscription was set as the highest level of subscription (I think). If another level was chosen, Category for example, the subscription selection when creating a new forum won't work. I replaced the above snippet of code with the following, and it seems to work:


' DEM --> Start of Code added for moderation and subscription
if (strSubscription > 0 and strSubscription < 4) _
and CatSubscription > 0 then
strSql = strSql & ", " & fSubscription
else
strSql = strSql & ", 0"
end if


I don't think strSubscription < 4 is necessary, but I included it because 4 indicates that the highest subscription level is Topic.

Nikkol

Edited by - Nikkol on 10 February 2002 02:27:21

Edited by - Davio on 26 February 2002 20:54:25

Davio
Development Team Member

Jamaica
12217 Posts

Posted - 26 February 2002 :  20:52:17  Show Profile
I don't think the strSubscription < 4 should be added. It wouldn't be set either if you set the highest subscription to "Topic Subscriptions Only". Since "Topic Subscriptions Only" would make strSubscription = 4.
' DEM --> Start of Code added for moderation and subscription
if strSubscription > 0 and CatSubscription > 0 then
strSql = strSql & ", " & fSubscription
else
strSql = strSql & ", 0"
end if
That is sufficient.

Has been fixed in the 3.4 version.

«-------------------------------------------------»
Read the Do's and Don'ts before you post for help
«-------------------------------------------------»
Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000 Version 3.4.07