Email notification on record change

Re: [Djulia] Alert record update

Fri, 14 Sep 2012 18:40:41 -0700

Thanks I finally had time to work on it and its perfect and thanks for the extra explanation it helped alot.

Re: [zip222] Alert record update

Fri, 31 Aug 2012 09:24:53 -0700

Hope it will be useful to you!

http://www.interactivetools.com/iforum/Products_C2/CMS_Builder%3A_Plugins_%26_Add-ons_F40/Alert_Record_Saved_v1.02_P94834/

Djulia

Re: [Djulia] Alert record update

Thu, 30 Aug 2012 15:27:09 -0700

Is there a way to modify this to log the type of action... Add/Edit/Delete?

Re: [thenetgirl] Alert record update

Tue, 28 Aug 2012 15:30:02 -0700

You must modify placeholders (array) in alertRecordSaved.php

'placeholders' => array(
     'username'	=> $CURRENT_USER['username'],
     'email'		=> $CURRENT_USER['email'],
     'tablename'	=> $tableName,
     'recordnum'	=> intval(@$_REQUEST['num']),
     'title''	=> htmlspecialchars(@$_REQUEST['title']),
)

For the user data $CURRENT_USER['column_name']:

'username'  => $CURRENT_USER['username'],
'email'  => $CURRENT_USER['email'],
...

For the record you obtain the data with @$_REQUEST['column_name']

'recordNum'  => intval(@$_REQUEST['num']),
'title'   => htmlspecialchars(@$_REQUEST['title']),
...

Then you must add these placeholders in alert-record-saved.mel.php

echo $PLACEHOLDERS['username']
echo $PLACEHOLDERS['email']
echo $PLACEHOLDERS['recordNum']
echo $PLACEHOLDERS['title']
...

Hope this helps. :)

Djulia

Re: [Djulia] Alert record update

Tue, 28 Aug 2012 14:09:46 -0700

No with the Alert record Plugin.

Re: [thenetgirl] Alert record update

Tue, 28 Aug 2012 02:55:36 -0700

With the [font "Verdana"]gl_emailNewAccountActivated plugin ?

[font "Verdana,Arial,Helvetica"][font "Verdana,Arial,Helvetica"]$query = "SELECT * FROM `{$TABLE_PREFIX}{$_gl_ena_tableName}`  
 WHERE num = '".intval($_gl_ena_recordNum)."'";

Djulia

Alert record update

Mon, 27 Aug 2012 18:16:56 -0700

I would like the admin to see more info on this alert record email ......

Like

,

NOTES:

not sure what to edit any advice?

Re: [Djulia] Email notification on record change

Mon, 27 Aug 2012 15:00:02 -0700

Well dang??

Re: [thenetgirl] Email notification on record change

Mon, 27 Aug 2012 14:52:53 -0700

In fact, the user does not receive the password. It is invited to use a new password.

Djulia

Re: [Djulia] Email notification on record change

Mon, 27 Aug 2012 14:25:01 -0700

Thannks and Yeah I see what you mean ..Password: $sha1$d2c759c60995709a0ce19dc0354fb140ad46d3fa

how do they do it in the membership plugin ???

Re: [thenetgirl] Email notification on record change

Mon, 27 Aug 2012 03:15:46 -0700

You can try to add username in the request. But, for the password, that will be more difficult if you use encryption (...)

$query = "SELECT fullname, username, email FROM `{$TABLE_PREFIX}{$_gl_ena_tableName}` 
 WHERE num = '".intval($_gl_ena_recordNum)."'";

Djulia

Re: [Djulia] Email notification on record change

Sun, 26 Aug 2012 17:49:27 -0700

No I downloaded the plugin.

Thanks that worked perfect .......can we email the user name and password too???

Re: [thenetgirl] Email notification on record change

Sat, 25 Aug 2012 04:31:16 -0700

Hi,

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

Fri, 24 Aug 2012 18:36:50 -0700

I installed the gl_emailNewAccountActivated plig in

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

Re: [thenetgirl] Email notification on record change

Fri, 24 Aug 2012 14:56:45 -0700

Hi,

The email settings by default. But, you can use another email if you wish it.

Djulia

Re: [Damon] Email notification on record change

Fri, 24 Aug 2012 14:20:49 -0700

On the first plugin who gets the email???

Re: [thenetgirl] Email notification on record change

Fri, 24 Aug 2012 11:47:20 -0700

Hi,

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!

Re: [Jason] Email notification on record change

Thu, 23 Aug 2012 15:52:56 -0700

Jason did you ever create the plugin for this???

Re: [Jason] Email notification on record change

Mon, 23 Aug 2010 13:39:16 -0700

Thanks Jason,

will do that

Re: [willydoit] Email notification on record change

Mon, 23 Aug 2010 11:58:56 -0700

Hi,

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.

Email notification on record change

Mon, 23 Aug 2010 03:45:09 -0700

Hi all,

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