Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: General / Classic ASP versions(v3.4.XX)
 subscription_list error
 New Topic
 Printer Friendly
Previous Page
Author Previous Topic Topic Next Topic
Page: of 2

Webbo
Average Member

United Kingdom
982 Posts

Posted - 06 January 2014 :  14:41:23  Show Profile  Visit Webbo's Homepage
Slight typo on line 174 Carefree:

" <option value=""6"">All</option></font>" & vbNewLine & _


Also, pop_subscription.asp lines 141 to 153 need to read:


Sub AddSubscription(SubLevel, Member_ID, CatID, ForumID, TopicID)
strSql = "INSERT INTO " & strTablePrefix & "SUBSCRIPTIONS"
strSql = strSql & "(MEMBER_ID, CAT_ID, FORUM_ID, TOPIC_ID, SUB_DATE) VALUES (" & Member_ID & ", "
If sublevel = "BOARD" Then
strSql = strSql & "0, 0, 0, '" & DatetoStr(strForumTimeAdjust) & "')"
ElseIf sublevel = "CAT" Then
strSql = strSql & CatID & ", 0, 0, '" & DatetoStr(strForumTimeAdjust) & "')"
ElseIf sublevel = "FORUM" Then
strSql = strSql & CatID & ", " & ForumID & ", 0, '" & DatetoStr(strForumTimeAdjust) & "')"
Else
strSql = strSql & CatID & ", " & ForumID & ", " & TopicID & ", '" & DatetoStr(strForumTimeAdjust) & "')"
End If
my_Conn.Execute (strSql),,adCmdText + adExecuteNoRecords


otherwise it throws up a "Column count doesn't match value count " error when subscribing to Forums and Categories



Works well, a nice addition
Go to Top of Page

Carefree
Advanced Member

Philippines
4217 Posts

Posted - 06 January 2014 :  15:52:33  Show Profile
Thanks. Changes incorporated at Snitzbitz and new mod posted to the appropriate forum.
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Previous Page
 New Topic
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.24 seconds. Powered By: Snitz Forums 2000 Version 3.4.07