Email Notification

Report · Nov 20, 2012

(I first posted this on the dynamic dreamweaver forum but I think I was supposed to post my question here)

Hi,

I'm trying to figure out a way to notify someone that another person has replied to a post they made in a discussion. I'm pretty sure I know how to figure out who the email should be sent to, but for now I'm just trying to get it to work by just sending it to my personal email. This is the code I'm trying to get to work:

Thanks,

Mike

======================================================================

<span class="blogtitle">Your Email has been sent.<br><br>I'll get back to you as soon as I can.

</span>

<cfmail

TO="mikewycklendt@gmail.com"

from="""#FORM.username#"" <mikewycklendt@mymindsnotright.com>"

subject="#FORM.title#"

server="scriptmail.intermedia.net"

>This is a message from #FORM.username#:

Email: #FORM.username#

-------------------------------------------------

#FORM.content#

</cfmail>

</cfprocessingdirective>

<form method="post" name="form1" action="<cfoutput>#CurrentPage#</cfoutput>">

</tr>

<td><input type="hidden" name="user_id" value="<cfoutput>#rsGetUserID.user_id#</cfoutput>" size="32"></td>

</tr>

<td align="right" nowrap class="bloguserandwho">Username:</td>

<td><input type="hidden" name="username" id="username" value="<cfoutput>#Session.MM_Username#</cfoutput>" size="32" /> <cfoutput>#Session.MM_Username#</cfoutput>

</td>

</tr>

<td align="right" nowrap class="bloguserandwho">Title:</td>

</tr>

<td align="right" valign="top" nowrap class="bloguserandwho">Content:</td>

</tr>

</tr>

</table>

<input type="hidden" name="reply_id" value="<cfoutput>#IncrementValue(rsReplyRecordCount.RecordCount)#</cf output>">

</form>

</cfif>

Report · Nov 28, 2012

First off, thanks a ton for all the help you've given me so far. I thought that I had everything figured out, but there's one minor problem that I didn't notice at first. The page I've been working on is this:

http://mymindsnotright.com/discussionGenReplies.cfm?post_id=22

the problem is that, with all the replies, when I click on a username link, it sends me to the profile of the original poster--not the one who posted the reply. On the other pages that I have not modified like the one I've been working on with you, when I click the username of a user who posted a reply, it does send me to the correct user profile.

This is the code that has everything working except for the username links being wrong.

==============================================================================

SELECT *

FROM boardtopics

WHERE post_id = <cfqueryparam value="#URL.post_id#" cfsqltype="cf_sql_numeric">

</cfquery>

SELECT *

FROM boardtopics

WHERE post_id = <cfqueryparam value="#FORM.post_id#" cfsqltype="cf_sql_numeric">

</cfquery>

INSERT INTO board_replies (reply_id, post_id, board_id, user_id, username, title, content, date)

VALUES (<cfif IsDefined("FORM.reply_id") AND #FORM.reply_id# NEQ "">

NULL

</cfif>

, <cfif IsDefined("FORM.post_id") AND #FORM.post_id# NEQ "">

NULL

</cfif>

, <cfif IsDefined("FORM.board_id") AND #FORM.board_id# NEQ "">

NULL

</cfif>

, <cfif IsDefined("FORM.user_id") AND #FORM.user_id# NEQ "">

NULL

</cfif>

, <cfif IsDefined("FORM.username") AND #FORM.username# NEQ "">

''

</cfif>

, <cfif IsDefined("FORM.title") AND #FORM.title# NEQ "">

''

</cfif>

, <cfif IsDefined("FORM.content") AND #FORM.content# NEQ "">

''

</cfif>

, <cfif IsDefined("FORM.date") AND #FORM.date# NEQ "">

NULL

</cfif>

)

SELECT *

FROM user_accounts

WHERE user_id = <cfoutput>#rsTopicInfoForEmail.user_id#</cfoutput>

</cfquery>

<cfmail

TO="mikewycklendt@gmail.com"

from="mikewycklendt@mymindsnotright.com"

subject="#FORM.username#"

server="scriptmail.intermedia.net"

>#FORM.username# has replied to your post (#rsTopicInfoForEmail.title#)

-------------------------------------------------

You can see the reply by clicking this link:

http://www.mymindsnotright.com/discussionGenReplies.cfm?post_id=#FORM.post_id#

should send to: #rsEmail.user_email#

</cfmail>

</cfquery>

</cfif>

SELECT *

FROM board_replies

WHERE post_id = <cfqueryparam value="#URL.post_id#" cfsqltype="cf_sql_numeric">

ORDER BY reply_id ASC

</cfquery>

SELECT *

FROM board_replies

</cfquery>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<html>

<head>

<title>My Minds Not Right -- General Discussion : <cfoutput>#rsGenPost.title#</cfoutput></title>

.blogcontent {

font-size: 11pt;

font-family: Tahoma, Geneva, sans-serif;

}

.comments {

font-family: Tahoma, Geneva, sans-serif;

font-size: 12px;

font-weight: bold;

text-decoration: underline;

text-align: right;

color: #246494;

}

.FeaturedBlogList {

font-family: Tahoma, Geneva, sans-serif;

font-size: 11px;

}

.FeaturedBlogListHeader {

font-family: Tahoma, Geneva, sans-serif;

font-size: 12px;

font-weight: bold;

color: #246494;

/* [disabled]border-bottom-style: solid; */

}

.blogdate {

font-size: 9pt;

font-style: italic;

font-family: Tahoma, Geneva, sans-serif;

}

.bloguserandwho {

font-size: 10pt;

font-style: normal;

font-family: Tahoma, Geneva, sans-serif;

}

.redlink {

font-family: Tahoma, Geneva, sans-serif;

color: #F00;

font-size: 10pt;

}

.blogtitle {

font-size: 16px;

font-weight: bold;

font-family: Tahoma, Geneva, sans-serif;

color: #246494;

}

.quoteStyle {

font-family: Verdana, Geneva, sans-serif;

font-size: 11pt;

font-style: italic;

color: #000;

}

.justified {

text-align: justify;

}

</style>

function MM_swapImgRestore() { //v3.0

var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a)&&x.oSrc;i++) x.src=x.oSrc;

}

function MM_preloadImages() { //v3.0

var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();

var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)

if (a.indexOf("#")!=0){ d.MM_p=new Image; d.MM_p[j++].src=a;}}

}

function MM_findObj(n, d) { //v4.01

var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {

d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}

if(!(x=d)&&d.all) x=d.all; for (i=0;!x&&i<d.forms.length;i++) x=d.forms;

for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers.document);

if(!x && d.getElementById) x=d.getElementById(n); return x;

}

function MM_swapImage() { //v3.0

var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)

if ((x=MM_findObj(a))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}

}

</script>

</head>

<tr>

</td>

<tr>

<tr>

</tr>

<tr>

</tr>

</table>

</td>

</tr>

</table>

<br>

</p>

</td>

<tr>

<tr>

</tr>

</table></td>

</tr>

<tr>

<td width="66%" align="left" class="FeaturedBlogListHeader">posted by: <span class="redlink"><a href="userProfile.cfm?user_id=<cfoutput>#rsGenPost.user_id#</cfoutput>"><cfoutput>#rsGenPost.username#</cfoutput></a><br>

</span><cfoutput>#LSDateFormat(rsGenPost.date,'M/DD/YY')#</cfoutput><span class="redlink"><cfoutput><span class="blogdate"></span></cfoutput></span></td>

<td width="34%" align="right"><span class="blogtitle"><a href="discussionGeneral.cfm?board_id=1">General Discussion</a></span></td>

</tr>

<tr>

</tr>

<tr>

<p class="blogtitle">#rsGenPost.title#</p>

</cfoutput></td>

</tr>

<tr>

</tr>

<tr>

<td colspan="2"><cfoutput>#ParagraphFormat(rsGenPost.content)#</cfoutput></td>

</tr>

<tr>

</tr>

<tr>

<td colspan="2" align="right"><a href="#replytest" class="redlink"><strong>Post Reply</strong></a></td>

</tr>

</table>

<tr>

<td align="right" class="blogtitle">Replies (<cfoutput>#rsGenReplies.RecordCount#</cfoutput>)</td>

</tr>

</table>

<br>

<tr>

<td width="78%" bgcolor="##DADADA"><strong><span class="blogcontent">#rsGenReplies.title#</span></strong></td>

<td width="22%" align="right" bgcolor="##DADADA"><span class="FeaturedBlogListHeader"><a href="userProfile.cfm?user_id=#rsGenPost.user_id#">#rsGenReplies.username#</a></span></td>

</tr>

<tr>

<td colspan="2" align="right"><span class="blogdate">#LSDateFormat(rsGenReplies.date,'M/DD/YY')#</span></td>

</tr>

<tr>

</tr>

<tr>

<td colspan="2" class="bloguserandwho">#ParagraphFormat(rsGenReplies.content)#</td>

</tr>

<tr>

<cfoutput><a href="userProfile.cfm?user_id=#rsGenPost.user_id#" class="redlink"></cfoutput><strong>Post Reply</strong></a>

</td>

</tr>

<tr>

</tr>

</table>

</cfoutput>

</tr>

</table>

</td>

</tr>

<tr>

</tr>

<tr>

</blockquote>

<td>

</td>

</tr>

</table>

</td>

</tr>

<tr>

<p class="left" style="margin-bottom: 0px; margin-left: 20px;">Copyright

MyMindsNotRight.com<br>

</td>

</tr>

</table>

</td>

</tr>

</table>

<tr>

</td>

</tr>

<tr>

</tr>

</table>

</td>

</tr>

</table>

</body>

</html>

Report · Nov 24, 2012

if someone navigates to the page i'm working on, the URL is:

http://mymindsnotright.com/discussionGenReplies.cfm?post_id=21

after the reply has been inserted, the page reloads and the reply shows up, but the URL changes to this:

http://mymindsnotright.com/discussionGenReplies.cfm?post_id=21&CFID=34478875&CFTOKEN=27776971

Report · Nov 24, 2012

and if this helpls, this is the link to the page i'm working on:

http://mymindsnotright.com/discussionGenReplies.cfm?post_id=21