php paypal ipn返回验证,Paypal IPN检测退款,PHP

我正在iDev联盟paypal IPN做一些自定义工作,我正在尝试为退款项目设置一个捕获.我的数据库工作正常,但我似乎无法获得IF捕获权.

关于我应该改变它的任何建议？

if($_REQUEST["payment_status"] == "refunded"||$testing==1)

{

$email = $_REQUEST["payer_email"];

$sid = $_REQUEST["subscr_id"];

$tid = $_REQUEST["txn_id"];

if (!$tid)

{

$tid='xxx';

}

if ($testing==1)

{

echo "testing on";

$sid = "I-E5E34E0DTMUS";

}

$query = "SELECT * FROM idevaff_sales WHERE tid1='$tid'";

$result = mysql_query($query);

if (!$result)

{

//echo $query; exit;

mail('***@gmail.com',"1",$query);

}

$arr = mysql_fetch_array($result);

$aid = $arr['id'];

$query = "SELECT * FROM idevaff_affiliates WHERE tid1='$tid'";

$result = mysql_query($query);

if ($result)

{

//echo $query;

mail('***@gmail.com',"2","$query");

}

$arr = mysql_fetch_array($result);

$email = $arr['email'];

$f_name = $arr['f_name'];

mail($email,"Affiliate Message - A refund has granted for recent affiliate commission.","Dear $f_name,

Message here about refund" );

$query = "UPDATE idevaff_sales SET approved=3 WHERE tracking='$sid'";

$result = mysql_query($query);

if (!$result)

{

//echo $query; exit;

mail('***@gmail.com',"3","$query");

}

}

哈德森