<?php
/*
Plugin Name: Alert Record Saved
Plugin URI:
Description: Sends an email notification when a record is added or modified ...
Version: 1.00
Requires at least: 2.03
Author: Djulia
Author URI: http://www.interactivetools.com/iforum/
License : Freeware
*/

addFilter('execute_seconds', 'plugin_alertSavedRecord');


//
function plugin_alertSavedRecord($html) {
	global $SETTINGS;
	global $_SERVER;

	$str = @$_SERVER['REQUEST_URI'];
	parse_str($str, $output);
	
	if (@$_SESSION['username']) { 
		if (isset($output['saved'])) { _saved_sendAlertMessage(); }
	} 
	return $html;
}


// send email
function _saved_sendAlertMessage() {
	global $SETTINGS;
	global $TABLE_PREFIX;
	global $tableName;
	global $recordNum;

	$query = "SELECT * FROM `{$TABLE_PREFIX}{$tableName}` WHERE num = '".mysql_real_escape_string( $recordNum )."'";
	$result = mysql_query_fetch_all_assoc($query) or die("MySQL Error Creating Record:<br/>\n". htmlspecialchars(mysql_error()) . "\n");

	foreach ($result as $record) {

		$title = stripslashes(strip_tags($record['title']));
		$content = stripslashes(strip_tags($record['content']));

		$headers	 =	'From:'. $SETTINGS['adminEmail'] . "\r\n" .
						'MIME-Version: 1.0' . "\r\n" .
						'Content-type: text/plain; charset=UTF-8' . "\r\n" .	
						'X-Mailer: PHP/' . phpversion();

			$to		 = "{$SETTINGS['adminEmail']}";

		if ($record['createdDate'] != $record['updatedDate']) {
			$subject = "[Alert Update] Record Number {$record['num']}";
		} else {
			$subject = "[Alert Add] Record Number {$record['num']}"; }

		$message	 = "Hi,\n"
					 . "\n"
					 . "Record {$record['num']} was saved by {$_SESSION['username']} in table {$tableName}.\n"
					 . "\n"
					 . "Title: {$title}\n"
					 . "Content: {$content}\n"
					 . "\n"
					 . "{$_SERVER['REMOTE_ADDR']}\n"
					 . "\n"
					 . "http://{$_SERVER['HTTP_HOST']}{$_SERVER['SCRIPT_NAME']}?menu={$tableName}&action=edit&num={$record['num']}\n";

		$mailResult = @mail($to, $subject, $message, $headers);
		if (!$mailResult) { die("Mail Error: $php_errormsg"); }
		}
	}

?>
