Email notification on record change

21 posts by 6 authors in: Forums > CMS Builder
Last Post: September 14, 2012   (RSS)

By Djulia - August 27, 2012

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

By thenetgirl - August 27, 2012

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



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

www.thenetgirl.com

By Djulia - August 27, 2012

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

Djulia

Alert record update

By thenetgirl - August 27, 2012

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

Like

<?php foreach ($auto_referralsRecords as $record): ?>
<?php echo $record['name'] ?><br/><br/>
<?php echo $record['email'] ?><br/><br/>
<?php echo $record['contact_phone'] ?><br/><br/>
<?php echo $record['address'] ?> <?php echo $record['city'] ?>,<?php echo $record['state'] ?> <?php echo $record['zip'] ?><br/><br/>

NOTES:<?php echo $record['notes'] ?>
<?php endforeach ?>


not sure what to edit any advice?
Patricia

www.thenetgirl.com

Re: [thenetgirl] Alert record update

By Djulia - August 28, 2012

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

Re: [Djulia] Alert record update

By thenetgirl - August 28, 2012

No with the Alert record Plugin.
Patricia

www.thenetgirl.com

Re: [thenetgirl] Alert record update

By Djulia - August 28, 2012 - edited: August 28, 2012

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

By zip222 - August 30, 2012

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

Re: [zip222] Alert record update

By Djulia - August 31, 2012 - edited: August 31, 2012

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