insert into #variables.tableprefix#messages(id,title,body,useridfk,threadidfk,posted,attachment,filename) values(, , , , , , , ) Title: #arguments.message.title# Thread: #tmpThread.name# Forum: #forum.name# Conference: #tmpConference.name# User: #arguments.username# #wrap(body,80)# #variables.settings.rootURL#messages.cfm?threadid=#arguments.threadid# select filename from #variables.tableprefix#messages where id = delete from #variables.tableprefix#messages where id = select id, title, body, posted, useridfk, threadidfk, attachment, filename from #variables.tableprefix#messages where id = select #variables.tableprefix#messages.id, #variables.tableprefix#messages.title, #variables.tableprefix#messages.body, #variables.tableprefix#messages.attachment, #variables.tableprefix#messages.filename, #variables.tableprefix#messages.posted, #variables.tableprefix#messages.threadidfk, #variables.tableprefix#messages.useridfk, #variables.tableprefix#threads.name as threadname, #variables.tableprefix#users.username, #variables.tableprefix#forums.name as forumname, #variables.tableprefix#conferences.name as conferencename from (((#variables.tableprefix#messages left join #variables.tableprefix#threads on #variables.tableprefix#messages.threadidfk = #variables.tableprefix#threads.id) left join #variables.tableprefix#forums on #variables.tableprefix#threads.forumidfk = #variables.tableprefix#forums.id) left join #variables.tableprefix#conferences on #variables.tableprefix#forums.conferenceidfk = #variables.tableprefix#conferences.id) left join #variables.tableprefix#users on #variables.tableprefix#messages.useridfk = #variables.tableprefix#users.id where #variables.tableprefix#messages.threadidfk = order by posted asc select distinct #variables.tableprefix#subscriptions.useridfk, #variables.tableprefix#users.emailaddress from #variables.tableprefix#subscriptions, #variables.tableprefix#users where (#variables.tableprefix#subscriptions.threadidfk = or #variables.tableprefix#subscriptions.forumidfk = or #variables.tableprefix#subscriptions.conferenceidfk = ) and #variables.tableprefix#subscriptions.useridfk <> and #variables.tableprefix#subscriptions.useridfk = #variables.tableprefix#users.id A post has been made to a thread, forum, or conference that you are subscribed to. You can change your subscription preferences by updating your profile. You can visit the thread here: #variables.settings.rootURL#messages.cfm?threadid=#arguments.threadid# Conference: #conference.name# Forum: #forum.name# Thread: #arguments.threadname# User: #username# Message: #wrap(arguments.body,80)# "> #quotename# said:#quoteportion#"> All URLs will be automatically linked. No HTML is allowed in your message.
You may include code in your message like so: [code]...[/code].
You may include an image in your message like so: [img]url[/img].
To add a quote, use [quote]...[/quote].
To annotate the quote, use [quote name="foo"]...[/quote]. update #variables.tableprefix#messages set title = , body = , threadidfk = , useridfk = , posted = , attachment = , filename = where id = select id, title, threadidfk from #variables.tableprefix#messages where 1 = 1 and ( (title like or body like '%#aTerms[x]#%' ) #joiner# title like or body like '%#arguments.searchTerms#%' )