Email notification on record change
21 posts by 6 authors in: Forums > CMS Builder
Last Post: September 14, 2012 (RSS)
By willydoit - August 23, 2010
We use CMS to provide a self managed advertising facility and also have an automated signup process which automatically sends a welcome email after signup and a copy yo ourselves to alert that a new advertisement will need authorising. As the signup script allows immediate creation of an add but doesnt allow it to be visible until checked by ourselves to avoid spam etc we find it is a problem if people sign up but dont create their ad straight away as we have no indication of when we need to check the content in order to allow it to become visible, and now to the question, is there any facility whereby we could be alerted by email each time any/all listing/record is changed, indicating the particular account which has been changed?
Thanks in advance
Re: [willydoit] Email notification on record change
By Jason - August 23, 2010
Yes, we can tailor a plugin that will be able to do that for you. If you could send an email to consulting@interactivetools.com with a list of requirements on how you would need the plugin to work, we can get you a quote.
Hope this helps.
Jason Sauchuk - Project Manager
interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/
Re: [Jason] Email notification on record change
By willydoit - August 23, 2010
will do that
Re: [Jason] Email notification on record change
www.thenetgirl.com
Re: [thenetgirl] Email notification on record change
By Damon - August 24, 2012
There are two user submitted plugins to take a look at:
Alert Record Saver - Sends an email notification when a record is added or modified.
https://www.interactivetools.com/add-ons/detail.php?Alert-Record-Saved-1052
and
Email New Account Notification - The Email New Account Notification plugin enhances the membership plugin. It will give administrators the option to manually send an email to new members from the user accounts list.
https://www.interactivetools.com/add-ons/detail.php?Email-New-Account-Notification-1037
We can also create a plugin for you specific requirements. Send the details to consulting@interactivetools.com and we can review and discuss options.
Thanks!
Damon Edis - interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/
Re: [Damon] Email notification on record change
www.thenetgirl.com
Re: [thenetgirl] Email notification on record change
By Djulia - August 24, 2012
The email settings by default. But, you can use another email if you wish it.
Djulia
Re: [Djulia] Email notification on record change
but I get an error
MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM cms_accounts WHERE num = '1'' at line 1 (at old_alias_functions.php line 18)
I have no idea why? Help Please
www.thenetgirl.com
Re: [thenetgirl] Email notification on record change
By Djulia - August 25, 2012 - edited: August 25, 2012
Do you use the version of this post?
http://www.interactivetools.com/forum/gforum.cgi?post=83176#83176
I modified my version for my needs. But, I think that you can try to modify the line for QUERY.
You can test:
$query = "SELECT fullname, email FROM `{$TABLE_PREFIX}{$_gl_ena_tableName}` WHERE num = '".intval($_gl_ena_recordNum)."'";Djulia
Re: [Djulia] Email notification on record change
Thanks that worked perfect .......can we email the user name and password too???
www.thenetgirl.com