A new comment has been posted by #qComment.firstName# #qComment.lastName# on the #qProject.name# message in #qItem.category# entitled: #qItem.title# issue entitled: #qItem.issue# file in #qItem.category# entitled: #qItem.title# milestone entitled: #qItem.name# to-do on list #qItem.title# entitled: #qItem.task# #request.udf.CleanText(qComment.commentText)# To view the message and leave comments, visit this link: #application.settings.rootURL##application.settings.mapping#/message.cfm?p=#arguments.projectID#&m=#arguments.itemID# To view the issue and leave comments, visit this link: #application.settings.rootURL##application.settings.mapping#/issue.cfm?p=#arguments.projectID#&i=#arguments.itemID# To view the file and leave comments, visit this link: #application.settings.rootURL##application.settings.mapping#/files.cfm?p=#arguments.projectID#&f=#arguments.itemID# To view the milestone and leave comments, visit this link: #application.settings.rootURL##application.settings.mapping#/milestones.cfm?p=#arguments.projectID#&m=#arguments.itemID# To view the to-do and leave comments, visit this link: #application.settings.rootURL##application.settings.mapping#/todo.cfm?p=#arguments.projectID#&t=#arguments.itemID# New comment on message: #qItem.title# issue: #qItem.issue# file: #qItem.title# milestone: #qItem.name# to-do: #qItem.task# #Left(request.udf.CleanText(qComment.commentText),100)#... A new #qProject.name# file has been added: #qFile.title# Category: #qFile.category# #request.udf.CleanText(qFile.description)# To view file details or to download, visit this link: #application.settings.rootURL##application.settings.mapping#/files.cfm?p=#arguments.projectID#&f=#arguments.fileID# New #qProject.name# file: #qFile.title# #Left(request.udf.CleanText(qFile.description),100)#... The following #qProject.name# issue has been updated: #qFile.title# Category: #qFile.category# #request.udf.CleanText(qFile.description)# To view file details or to download, visit this link: #application.settings.rootURL##application.settings.mapping#/files.cfm?p=#arguments.projectID#&f=#arguments.fileID# Updated #qProject.name# file: #qFile.title# #Left(request.udf.CleanText(qFile.description),100)#... A new #qProject.name# issue has been added: #qIssue.issue# #request.udf.CleanText(qIssue.detail)# Milestone: #qIssue.milestone# Assigned To: #qIssue.assignedFirstName# #qIssue.assignedLastName# To view the full issue, visit this link: #application.settings.rootURL##application.settings.mapping#/issue.cfm?p=#arguments.projectID#&i=#arguments.issueID# New #qProject.name# issue: #Left(request.udf.CleanText(qIssue.issue),100)#... The following #qProject.name# issue has been updated: #qIssue.issue# Status: #qIssue.status# #request.udf.CleanText(qIssue.detail)# Milestone: #qIssue.milestone# Assigned To: #qIssue.assignedFirstName# #qIssue.assignedLastName# To view the full issue, visit this link: #application.settings.rootURL##application.settings.mapping#/issue.cfm?p=#arguments.projectID#&i=#arguments.issueID# Updated #qProject.name# issue: #Left(qIssue.issue,100)#... A new #qProject.name# message has been postedYou have posted a new #qProject.name# message: #qMessage.title# #request.udf.CleanText(qMessage.message)# Milestone: #qMessage.name# To view the full message and leave comments, visit this link:You have 15 minutes from the time of posting to edit the message. Use the following link to view or edit the message and to make comments: #application.settings.rootURL##application.settings.mapping#/message.cfm?p=#arguments.projectID#&m=#arguments.messageID# New #qProject.name# message: #qMessage.title# #Left(request.udf.CleanText(qMessage.message),100)#... The following #qProject.name# message has been updatedYou have updated a #qProject.name# message: #qMessage.title# #request.udf.CleanText(qMessage.message)# Milestone: #qMessage.name# To view the full issue, visit this link: #application.settings.rootURL##application.settings.mapping#/message.cfm?p=#arguments.projectID#&m=#arguments.messageID# Updated #qProject.name# message: #Left(request.udf.CleanText(qMessage.message),100)#... A new #qProject.name# milestone has been added: #qMilestone.name# #request.udf.CleanText(qMilestone.description)# Assigned To: #qMilestone.firstName# #qMilestone.lastName# To view file details or to download, visit this link: #application.settings.rootURL##application.settings.mapping#/milestones.cfm?p=#arguments.projectID#&m=#arguments.milestoneID# New #qProject.name# file: #qMilestone.name# Due Date: #LSDateFormat(qMilestone.dueDate,"ddd, mmmm d, yyyy")# #Left(request.udf.CleanText(qMilestone.description),100)#... The following #qProject.name# milestone has been updated: #qMilestone.name# Due Date: #DateFormat(qMilestone.dueDate,"ddd, mmmm d, yyyy")# #request.udf.CleanText(qMilestone.description)# Assigned To: #qMilestone.firstName# #qMilestone.lastName# To view file details or to download, visit this link: #application.settings.rootURL##application.settings.mapping#/milestones.cfm?p=#arguments.projectID#&m=#arguments.milestoneID# Updated #qProject.name# milestone: #qMilestone.name# #Left(request.udf.CleanText(qMilestone.description),100)#... A new #qProject.name# to-do has been added to list #qTodolist.title#: #qTodo.task# Due Date: #DateFormat(qTodo.due,"ddd, mmmm d, yyyy")# To view file details or to download, visit this link: #application.settings.rootURL##application.settings.mapping#/todo.cfm?p=#arguments.projectID#&t=#arguments.todoID# New #qProject.name# to-do: #qTodo.task# List: #qTodolist.title# The following #qProject.name# to-do has been updated in list #qTodolist.title#: #qTodo.task# Due Date: #DateFormat(qTodo.due,"ddd, mmmm d, yyyy")# To view file details or to download, visit this link: #application.settings.rootURL##application.settings.mapping#/todos.cfm?p=#arguments.projectID#&t=#arguments.todoID# Updated #qProject.name# to-do: #qTodo.task# List: #qTodolist.title# INSERT INTO #variables.tableprefix#user_notify (userID, projectID, email_file_new, mobile_file_new, email_file_upd, mobile_file_upd, email_file_com, mobile_file_com, email_issue_new, mobile_issue_new, email_issue_upd, mobile_issue_upd, email_issue_com, mobile_issue_com, email_msg_new, mobile_msg_new, email_msg_upd, mobile_msg_upd, email_msg_com, mobile_msg_com, email_mstone_new, mobile_mstone_new, email_mstone_upd, mobile_mstone_upd, email_mstone_com, mobile_mstone_com, email_todo_new, mobile_todo_new, email_todo_upd, mobile_todo_upd, email_todo_com, mobile_todo_com, email_time_new, mobile_time_new, email_time_upd, mobile_time_upd, email_bill_new, mobile_bill_new, email_bill_upd, mobile_bill_upd, email_bill_paid, mobile_bill_paid) VALUES (, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ) UPDATE #variables.tableprefix#user_notify SET email_file_new = , mobile_file_new = , email_file_upd = , mobile_file_upd = , email_file_com = , mobile_file_com = , email_issue_new = , mobile_issue_new = , email_issue_upd = , mobile_issue_upd = , email_issue_com = , mobile_issue_com = , email_msg_new = , mobile_msg_new = , email_msg_upd = , mobile_msg_upd = , email_msg_com = , mobile_msg_com = , email_mstone_new = , mobile_mstone_new = , email_mstone_upd = , mobile_mstone_upd = , email_mstone_com = , mobile_mstone_com = , email_todo_new = , mobile_todo_new = , email_todo_upd = , mobile_todo_upd = , email_todo_com = , mobile_todo_com = , email_time_new = , mobile_time_new = , email_time_upd = , mobile_time_upd = , email_bill_new = , mobile_bill_new = , email_bill_upd = , mobile_bill_upd = , email_bill_paid = , mobile_bill_paid = WHERE projectid = AND userID = DELETE FROM #variables.tableprefix#user_notify WHERE 0=0 AND projectID = AND userID =