Send email WordPress

Dmitriy Son comments:

Hi, Duncan!
This is the whole code.
I don't think that anything below the function is missing.
My mistake somewhere inside. The function doesn't work, i.e. it doesn't send messages to any of the addresses.
I think, items marked in bold are potentially wrong.
<?php

require("../../../wp-config.php");

global $wpdb;

if( class_exists('MyWpContribute') ) $objContribute = new MyWpContribute();


# Send notifications to here
$send_mail_to = get_option( 'paypal_email_id' );

# Your primary PayPal e-mail address
$msg = get_option( 'paypal_email_msg' );

#the emails will be coming from
$from = get_option( 'from_address' );

// Set the request paramaeter
$req = 'cmd=_notify-validate';

// Run through the posted array
foreach ($_REQUEST as $key => $value)
{
// If magic quotes is enabled strip slashes
if (get_magic_quotes_gpc())
{
$_REQUEST[$key] = stripslashes($value);
$value = stripslashes($value);
}
$value = urlencode($value);
// Add the value to the request parameter
$req .= "&$key=$value";
}

$url = "https://www.paypal.com/cgi-bin/webscr";

$ch = curl_init(); // Starts the curl handler
curl_setopt($ch, CURLOPT_URL,$url); // Sets the paypal address for curl
curl_setopt($ch, CURLOPT_FAILONERROR, 1);
curl_setopt($ch, CURLOPT_RETURNTRANSFER,1); // Returns result to a variable instead of echoing
curl_setopt($ch, CURLOPT_TIMEOUT, 3); // Sets a time limit for curl in seconds (do not set too low)
curl_setopt($ch, CURLOPT_POST, 1); // Set curl to send data using post
curl_setopt($ch, CURLOPT_POSTFIELDS, $req); // Add the request parameters to the post
$result = curl_exec($ch); // run the curl process (and return the result to $result
curl_close($ch);

if (strcmp ($result, "VERIFIED") == 0) // It may seem strange but this function returns 0 if the result matches the string So you MUST check it is 0 and not just do strcmp ($result, "VERIFIED") (the if will fail as it will equate the result as false)
{


foreach ($_REQUEST as $key => $value)
{

$msg.=$key."=>".$value.'<br>';
}


global $wpdb;

$table_name= $wpdb->prefix.'contribution';
[strong]$data = $wpdb->get_results("SELECT * FROM $table_name");
Inner Join wp_campaigns ON wp_contribution.cont_camp_id = wp_campaigns.camp_id
WHERE
wp_campaigns.camp_field_anonymous <> '1'";[/strong]

$arrCustom=split("#",$_REQUEST["custom"]);

$data["cont_camp_id"]=$arrCustom[0];

$data["cont_amt"]=$_REQUEST["mc_gross"];

if($_REQUEST["first_name"] != "" ) {
$data["cont_first_name"]= $wpdb->escape($_REQUEST["first_name"]);
}


if($_REQUEST["last_name"] != "" ) {
$data["cont_last_name"]= $wpdb->escape($_REQUEST["last_name"]) ;
}

if($_REQUEST["payer_email"] != "" ) {
$data["cont_email"]= $_REQUEST["payer_email"] ;
}

if($_REQUEST["campaign_creator_email"] != "" ) {
[strong]$data["camp_email"]= $wpdb->escape($_REQUEST["creator_email"]);[/strong]
}


$data["txn_id"]= $_REQUEST["txn_id"] ;

$data["cont_date"]= date("Y-m-d");

$rows_affected = $wpdb->insert( $table_name, $data );

$msg = get_option( 'paypal_email_msg' );

$from=get_option( 'from_address' );

$email_subject=get_option( 'email_subject' );

mail( $send_mail_to , $email_subject, $msg, $from);

// mail to donor, site admin and campaign creator

if($_REQUEST["payer_email"] != "" ) {
$msg .="\n\n==== Donation Information ====";
$msg .="\nConfirmation Number:".$_REQUEST["txn_id"] ;
$msg .="\nDate: ".date("Y-m-d");
$msg .="\nAmount: ".$_REQUEST["mc_gross"];
$msg .="\nCampaign: ".$arrCustom[1];
$msg .="\nDonor: ".$_REQUEST["first_name"]." ".$_REQUEST["last_name"];

$from=get_option( 'from_address' );
$email_subject=get_option( 'email_subject' );
$send_mail_to_creator = $_REQUEST["campaign_creator_email"];
mail( $send_mail_to_creator , $email_subject, $msg, $from);
mail( $send_mail_to , $email_subject, $msg, $from);
mail( get_option( 'paypal_email_id' ) , $email_subject, $msg, $from);


}

$eLog="/tmp/mailError.log";
//Get the size of the error log
//ensure it exists, create it if it doesn't
$fh= fopen($eLog, "a+");
fclose($fh);
$originalsize = filesize($eLog);

clearstatcache();
$finalsize = filesize($eLog);

}
else
{

header("Location: index.php");
die();
// Log an invalid request to look into
}

?>

Thanks,
Dmitriy.

Dmitriy Son comments:

There are potentially wrong items:

$table_name= $wpdb->prefix.'contribution';
$data = $wpdb->get_results("SELECT * FROM $table_name");
Inner Join wp_campaigns ON wp_contribution.cont_camp_id = wp_campaigns.camp_id
WHERE
wp_campaigns.camp_field_anonymous <> '1'";


if($_REQUEST["campaign_creator_email"] != "" ) {
$data["camp_email"]= $wpdb->escape($_REQUEST["creator_email"]);
}

Duncan O'Neill comments:

Dmitry,

Nothing in the above code is marked as bold.

Did you try any of my suggestions to try to pinpoint the error?

best,

Duncan O'Neill comments:

Dmitry,

I'm not a MySQL expert, but that inner join statement looks wonky to me. [[LINK href="http://dev.mysql.com/doc/refman/5.0/en/join.html"]]ref[[/LINK]]

Other possibilities;

If you've switched on WP_DEBUG ( see above ), that might give you the line which is creating the error.

You could also paste this php at the start of your file to tell you where your error lies;


ini_set('display_errors', 1);
error_reporting(E_ALL);


You could also try my other two original suggestions. :-)

best,

Dmitriy Son comments:

$table_name= $wpdb->prefix.'contribution';
$data = $wpdb->get_results("SELECT * FROM $table_name
Inner Join wp_campaigns ON wp_contribution.cont_camp_id = wp_campaigns.camp_id
WHERE
wp_campaigns.camp_email NOT NULL");

What's happenning with camp_email when $rows_affected = $wpdb->insert( $table_name, $data ) run?

Is it insert into wp_contribution as cont_first_name and so on?

I don't want to insert it into the table, I just want to get this field from wp_campaigns, send email and forget about it :)