Snitz Forums 2000 - Email with the full text of a new post

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Snitz Forums 2000 MOD-Group

MOD Add-On Forum (W/O Code)

Email with the full text of a new post

New Topic

Reply to Topic

Printer Friendly

Author

Topic

Page: of 2

ale34
Starting Member

13 Posts

Posted - 08 November 2006 : 07:24:28

Hi,
my forum members are asking me for having by email the full text of a new post (forum subscription) instead of receiving a message with the link. Is it possible?

Thank you for your help

Alex<

JJenson
Advanced Member

USA
2121 Posts

Posted - 08 November 2006 : 09:53:25

I am guessing you are looking for the rss feed mod and you can find it on snitzbitz.com<

ale34
Starting Member

13 Posts

Posted - 08 November 2006 : 10:05:59

Hi Jeff,
I have already seen the rss mod but I think it does too much work for what I need

I would like just to receive in the notification sent by email to subscribed members: the post (full text) + the link where to follow the discussion.
The forum members asking me for that, seem too busy or are receiving too many emails and they consider a waste of time to follow a link instead of having the content of the new post in their mail.

I think that someone must have already implemented this function, don't you think so?<

JJenson
Advanced Member

USA
2121 Posts

Posted - 08 November 2006 : 11:11:43

It is possible that someone has. I am not aware of anything but the rss feed but again I am not all knowledgable like most people on here. I only share the minimal things I have learned. lol

Good luck and I am sure shaggy knows he seems to know everything.

<

Shaggy
Support Moderator

Ireland
6780 Posts

Posted - 08 November 2006 : 11:35:00

... well, if you insist ...

Find the following on line 45 of inc_subscription.asp

	StrSql = "SELECT C.CAT_SUBSCRIPTION, C.CAT_NAME, F.F_SUBJECT, F.F_SUBSCRIPTION, " & _
			 "       T.T_SUBJECT, M.M_NAME " & _
             " FROM " & strTablePrefix & "CATEGORY C, " & _
			 "      " & strTablePrefix & "FORUM F, " & _
			 "      " & strTablePrefix & "TOPICS T, " & _
			 "      " & strMemberTablePrefix & "MEMBERS M " & _
             " WHERE C.CAT_ID    = " & CatID   & " AND F.FORUM_ID  = " & ForumID & _
			 "   AND T.TOPIC_ID  = " & TopicID & " AND M.MEMBER_ID = " & pMemberID

And replace it with the following:

	StrSql = "SELECT C.CAT_SUBSCRIPTION, C.CAT_NAME, F.F_SUBJECT, F.F_SUBSCRIPTION, " & _
			 "       T.T_SUBJECT, T.T_MESSAGE, M.M_NAME " & _
             " FROM " & strTablePrefix & "CATEGORY C, " & _
			 "      " & strTablePrefix & "FORUM F, " & _
			 "      " & strTablePrefix & "TOPICS T, " & _
			 "      " & strMemberTablePrefix & "MEMBERS M " & _
             " WHERE C.CAT_ID    = " & CatID   & " AND F.FORUM_ID  = " & ForumID & _
			 "   AND T.TOPIC_ID  = " & TopicID & " AND M.MEMBER_ID = " & pMemberID

Find the following on line 69:

	CatSubscription   = allSubsData(0, 0)
	CatName           = allSubsData(1, 0)
	ForumName         = allSubsData(2, 0)
	ForumSubscription = allSubsData(3, 0)
	TopicName         = allSubsData(4, 0)
	MemberName        = allSubsData(5, 0)

And replace it with the following:

	CatSubscription   = allSubsData(0, 0)
	CatName           = allSubsData(1, 0)
	ForumName         = allSubsData(2, 0)
	ForumSubscription = allSubsData(3, 0)
	TopicName         = allSubsData(4, 0)
	TopicContent      = allSubsData(5, 0)
	MemberName        = allSubsData(6, 0)

Finally, you'll need to edit the following two lines on line 187 to customise the message that gets sent to suit your needs:

				strMessage = strMessage & "Regarding the subject - " & TopicName & "." & vbNewline & vbNewline
				strMessage = strMessage & "You can view the posting at " & strForumURL & "topic.asp?whichpage=-1&TOPIC_ID=" & TopicId & vbNewline

You will need to pass the TopicContent vriable through the FormatStr function so that all the forum code is parsed. I would, however, highly recommend that you then pass it through a custom function to strip out all the HTML for those whose e-mail clients cannot read HTML mails or may not display it correctly.

<

Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.”

Edited by - Shaggy on 09 November 2006 03:57:28

ale34
Starting Member

13 Posts

Posted - 08 November 2006 : 11:47:16

Ooops, Shaggy was there!!
I am trying this and in 10 minutes I will let you know...

The only thing I need to understand is this part of your post:

You will need to pass the TopicContent vriable through the FormatStr function so that all the forum code is parsed. I would, however, highly recommend that you then pass it through a custom function to strip out all the HTML for those whose e-mail clients cannot read HTML mails or may not display it correctly.

Could you explain to me how to pass the TopicContent through the FormatStr function, please?<

JJenson
Advanced Member

USA
2121 Posts

Posted - 08 November 2006 : 11:55:05

Shaggy I just want to say your my hero lol. Well as far as snitz support goes lol

Shaggy
Support Moderator

Ireland
6780 Posts

Posted - 08 November 2006 : 12:00:45

quote:
Originally posted by ale34
I am trying this and in 10 minutes I will let you know...

Be sure to back up your inc_subscriptions.asp first, just in case

quote:
Could you explain to me how to pass the TopicContent through the FormatStr function, please?

When inserting TopicContent in your message do so like so:

strMessage="dooby-doobby "&FormatStr(TopicContent)&" blah-de-blah"

<

Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.”

ale34
Starting Member

13 Posts

Posted - 08 November 2006 : 12:21:23

Unfortunetly it does not work as I wish.

It sends by email the text of the first topic (the oldest one)
but not the reply to the topic being posted (the new one). What am I doing wrong?<

Edited by - ale34 on 08 November 2006 12:25:15

Shaggy
Support Moderator

Ireland
6780 Posts

Posted - 08 November 2006 : 12:42:07

Ah, yes, of course it would

Sorry, winding down from a long day with a 0600 start

Lemme sleep on it & I'll get back to you tomorrow.

<

Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.”

ale34
Starting Member

13 Posts

Posted - 08 November 2006 : 12:51:35

Ok Shaggy,
I hope you will have a good fruitful night

TonyB7
Junior Member

USA
267 Posts

Posted - 08 November 2006 : 21:38:43

Keep in mind the behavior you're describing is more the behavior of a mailing list, not a web forum. Next you'll be wanting a mod that lets them reply via email. Then they'll never have to visit and you'll know you should just be running a listserv.<

muzishun
Senior Member

United States
1079 Posts

Posted - 09 November 2006 : 00:23:18

One other thing to bear in mind is that if your forum starts to become more heavily trafficked, you'll have serious issues with bandwidth. Subscriptions have the potential (on a busy forum) to bog the server down considerably. That's why, for example, subscriptions are turned off here, as well as at some of the busier Snitzes out there.

If you're on a dedicated server or if you are running a forum that you don't anticipate getting terribly big, this shouldn't be an issue.<

Bill Parrott
Senior Web Programmer, University of Kansas
Co-Owner and Code Monkey, Eternal Second Designs (www.eternalsecond.com)
Personal Website (www.chimericdream.com)

Shaggy
Support Moderator

Ireland
6780 Posts

Posted - 09 November 2006 : 03:56:21

OK, you're going to need an extra database hit and this ain't exactly the "prettiest" solution but it will serve your purposes. On top of the changes I've already posted, find the following on line 172:

if LoopTopicID > 0 then
	strSubject = strForumTitle & " - Reply to a posting"
	strMessage = strMessage & MemberName & " has replied to a topic on " & strForumTitle & " that you requested notification to. "
else

And replace it with the following:

if LoopTopicID > 0 then
	strSubject = strForumTitle & " - Reply to a posting"
	strMessage = strMessage & MemberName & " has replied to a topic on " & strForumTitle & " that you requested notification to. "
	set rsReply=my_Conn.execute(TopSQL("SELECT R_MESSAGE FROM REPLY WHERE TOPIC_ID="&TopicID&" AND R_STATUS=1 ORDER BY REPLY_ID DESC",1))
	if not rsReply.eof then TopicContent=rs("R_MESSAGE")
	rsReply.close:set rsReply=nothing
else

<edited by="Shaggy" to="correct typo" />

<

Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.”

Edited by - Shaggy on 09 November 2006 08:43:37

ale34
Starting Member

13 Posts

Posted - 09 November 2006 : 07:52:18

Thank you Shaggy.
but there is something wrong: here below the error I got

Erreur de compilation Microsoft VBScript erreur '800a0400'
Instruction attendue
/forum/inc_subscription.asp, ligne 197
end if
^
<

Shaggy
Support Moderator

Ireland
6780 Posts

Posted - 09 November 2006 : 07:57:49

Did you replace that entire if statement with what I posted above? You should only have replaced the first part of it. Can you post a link to a *.txt copy of your inc_subscription.asp if that's not the problem?

<

Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.”

Page: of 2

Topic

New Topic

Reply to Topic

Printer Friendly

Jump To:

Snitz Forums 2000

This page was generated in 0.18 seconds.