Adding custom text to emailOnApproved Plugin

Hi Darryl,

Thanks for looking at this.

If I put a load records call at the top of the plugin

// load record from 'common_information'
  list($common_informationRecords, $common_informationMetaData) = getRecords(array(
    'tableName'   => 'common_information',
    'where'       => '', // load first record
    'loadUploads' => true,
    'allowSearch' => false,
    'limit'       => '1',
  ));
  $common_informationRecord = @$common_informationRecords[0]; // get first record

I get this kind of error in the error log:

E_ERROR: Call to undefined function getRecords()
/home2/nawaflco/public_html/nawafl/cmsAdmin/plugins/emailOnApproved.php (line 13)
http://nawafl.com/cmsAdmin/admin.php

If I put it lower in the plugin, but before the

$message=<<< __TEXT__
    Welcome!  <br><br>

I get an internal server error when I try to save a user account record and hence no new error message

So the problem seems to be how to connect your variable$custom_text to a section so that it gets it's value from a (single record) section field

Looking forward to the next installment...

Best,

Jerry

Hi Jerry,

It looks like you haven't loaded the viewer functions into the plugin.
Can you try to add this somewhere on top of the plugin file?:

include_once("../lib/viewer_functions.php")

Progress...

I ended up adding this to the top of the plugin the "include" still broke the site (I assume because of directory path issues).

  $libraryPath = 'cmsAdmin/lib/viewer_functions.php';
  $dirsToCheck = array('/home2/nawaflco/public_html/nawafl/','','../','../../','../../../');
  foreach ($dirsToCheck as $dir) { if (@include_once("$dir$libraryPath")) { break; }}
  if (!function_exists('getRecords')) { die("Couldn't load viewer library, check filepath in sourcecode."); };

// load record from 'common_information'
  list($common_informationRecords, $common_informationMetaData) = getRecords(array(
    'tableName'   => 'common_information',
    'where'       => '', // load first record
    'loadUploads' => true,
    'allowSearch' => false,
    'limit'       => '1',
  ));
  $common_informationRecord = @$common_informationRecords[0]; // get first record
  $member_welcome  = $common_informationRecord['member_welcome '];

Now the site still functions, but I now get this error message (and obviously no $member_welcome text inserted in the message)

E_NOTICE: Undefined index: member_welcome 

/home2/nawaflco/public_html/nawafl/cmsAdmin/plugins/emailOnApproved.php (line 18)

http://nawafl.com/cmsAdmin/admin.php?menu=_error_log


Any time there's activity on the back end (I was refreshing the error log at the time).

The plot thickens...

Best,

Jerry Kornbluth

Is your getRecords() for 'common_information' is outside of the plugin function? If yes, you should call it inside the plugin function.

Great catch Darryl,

Here's the plugin code that worked for me, just in case anyone else can use it:

Best,

Jerry Kornbluth

NOTE: My single record section is called "common_information", the text field for the variable text is called "member_welcome", and the text variable is called "$member_welcome". Don't forget to change the server path.

<?php
/*
Plugin Name: Email On Approved
Description: Email the user their password once they are approved
Version: 1.00
Requires at least: 2.04
*/
// UPDATE THESE VALUES
// DON'T UPDATE ANYTHING BELOW THIS LINE
 
addAction('record_postsave',  'emailOnApproved_sendPassword', null, 4);
//
function emailOnApproved_sendPassword($tableName, $isNewRecord, $oldRecord, $recordNum) {
  global $CURRENT_USER, $SETTINGS;
  $fieldname = 'approved';
  // error checking
    if ($tableName != 'accounts') { return; }
  if (!array_key_exists($fieldname, $CURRENT_USER)) {
    die(__FUNCTION__ .": You must create an accounts fields called '$fieldname'!");
  }
  // send email
  $wasChecked   = intval(!$oldRecord[$fieldname] && $_REQUEST[$fieldname]);
  $wasUnchecked = intval($oldRecord[$fieldname]  && !$_REQUEST[$fieldname]);

// load viewer library
  $libraryPath = 'cmsAdmin/lib/viewer_functions.php';
  $dirsToCheck = array('/path_to_server/','','../','../../','../../../');
  foreach ($dirsToCheck as $dir) { if (@include_once("$dir$libraryPath")) { break; }}
  if (!function_exists('getRecords')) { die("Couldn't load viewer library, check filepath in sourcecode."); };

// load record from 'common_information'
  list($common_informationRecords, $common_informationMetaData) = getRecords(array(
    'tableName'   => 'common_information',
    'where'       => '', // load first record
    'loadUploads' => true,
    'allowSearch' => false,
    'limit'       => '1',
  ));
  $common_informationRecord = @$common_informationRecords[0]; // get first record
  $member_welcome  = $common_informationRecord['member_welcome'];

$message=<<< __TEXT__
    Welcome {$_REQUEST['first_name']} {$_REQUEST['last_name']},<br><br>
 
{$member_welcome}<br><br>



Your membership has been  processed successfully and you now have access to the Members Only area of our web site. <br> <br>

Your user name is: {$_REQUEST['username']} <br>
and your temporary login password is: XXXXX <br><br>

Once you have successfully logged in, you must change your password and can then update your own profile information. <br><br>
 
<a href="{$GLOBALS['WEBSITE_LOGIN_LOGIN_FORM_URL']}">Click here to login</a> <br><br>
 
Best, <br>  <br>
    
The Membership Committee  
__TEXT__;


$headers  = 'MIME-Version: 1.0' . "\r\n";  
$headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";  
$headers .="FROM:". $SETTINGS['adminEmail'];  
 
   if ($wasChecked) {
    $errors = mail($_REQUEST['email'],"Your membership has been successfully processed!",$message,$headers);  
    if ($errors!=1) { die("Mail Error: $php_errormsg"); }
  }
 
}
 
?>