Pay pal IPN HELP

[Freid001]

Hi I am looking to create some IPN script for pay pal because my host blocks this function : fsockopen which is included in the normal pay pal PHP script. I am currently creating a PHP online game and intend to use the IPN script to basically updated player accounts with credits when people purchase them. I understand that I have to included IPN script on a page on my server which pay pal referse back to when a person pays for credits. But as I said my host does not allow function : fsockopen so I can not use the normal IPN script. There for I have created a new PHP script that takes the fsockopen function out of the script but I am not sure weather it works and my question is this will this still work with paypal? I have tried pay pal IPN sand box and it updates users accounts but im not sure weather the code needs this function fsockopen into send data back to paypal.

 

Thanks for any help

 

PAY PAL IPN:

// PHP 4.1

// read the post from PayPal system and add 'cmd'
$req = 'cmd=_notify-validate';

foreach ($_POST as $key => $value) {
$value = urlencode(stripslashes($value));
$req .= "&$key=$value";
}

// post back to PayPal system to validate
$header .= "POST /cgi-bin/webscr HTTP/1.0\r\n";
$header .= "Content-Type: application/x-www-form-urlencoded\r\n";
$header .= "Content-Length: " . strlen($req) . "\r\n\r\n";
$fp = fsockopen ('ssl://www.sandbox.paypal.com', 80, $errno, $errstr, 30);

// assign posted variables to local variables
$item_name = $_POST['item_name'];
$item_number = $_POST['item_number'];
$payment_status = $_POST['payment_status'];
$payment_amount = $_POST['mc_gross'];
$payment_currency = $_POST['mc_currency'];
$txn_id = $_POST['txn_id'];
$receiver_email = $_POST['receiver_email'];
$payer_email = $_POST['payer_email'];

if (!$fp) {
// HTTP ERROR
} else {
fputs ($fp, $header . $req);
while (!feof($fp)) {
$res = fgets ($fp, 1024);
if (strcmp ($res, "VERIFIED") == 0) {
if ($payment_status=="Completed"){
if ($payment_amount==0.99&&$payment_currency=="GBP"){
$AD = 100;
$AD2 = $credits + $AD;
mysql_query("UPDATE Game SET Credits = '$AD2'WHERE user = '$update'");
}
if ($payment_amount==2.50&&$payment_currency=="GBP"){
$AD = 500;
$AD2 = $credits + $AD;
mysql_query("UPDATE Game SET Credits = '$AD2'WHERE user = '$update'");
}
if ($payment_amount==5.00&&$payment_currency=="GBP"){
$AD = 1000;
$AD2 = $credits + $AD;
mysql_query("UPDATE Game SET Credits = '$AD2'WHERE user = '$update'");
}
if ($payment_amount==10.00&&$payment_currency=="GBP"){
$AD = 10000;
$AD2 = $credits + $AD;
mysql_query("UPDATE Game SET Credits = '$AD2'WHERE user = '$update'");
}
if ($payment_amount==49.99&&$payment_currency=="GBP"){
$AD = 100000;
$AD2 = $credits + $AD;
mysql_query("UPDATE Game SET Credits = '$AD2'WHERE user = '$update'");
}
}
else if (strcmp ($res, "INVALID") == 0) {
// log for manual investigation
}
}
fclose ($fp);
}
}

 

 

So what I have basically done is remove the fsockopen as seen below:

 

// PHP 4.1

// read the post from PayPal system and add 'cmd'
$req = 'cmd=_notify-validate';

foreach ($_POST as $key => $value) {
$value = urlencode(stripslashes($value));
$req .= "&$key=$value";
}

// post back to PayPal system to validate
$header .= "POST /cgi-bin/webscr HTTP/1.0\r\n";
$header .= "Content-Type: application/x-www-form-urlencoded\r\n";
$header .= "Content-Length: " . strlen($req) . "\r\n\r\n";
$item_name = $_POST['item_name'];
$item_number = $_POST['item_number'];
$payment_status = $_POST['payment_status'];
$payment_amount = $_POST['mc_gross'];
$payment_currency = $_POST['mc_currency'];
$txn_id = $_POST['txn_id'];
$receiver_email = $_POST['receiver_email'];
$payer_email = $_POST['payer_email'];


if ($payment_status=="Completed"){
if ($payment_amount==0.99&&$payment_currency=="GBP"){
$AD = 100;
$AD2 = $credits + $AD;
mysql_query("UPDATE Game SET Credits = '$AD2'WHERE user = '$update'");
}
if ($payment_amount==2.50&&$payment_currency=="GBP"){
$AD = 500;
$AD2 = $credits + $AD;
mysql_query("UPDATE Game SET Credits = '$AD2'WHERE user = '$update'");
}
if ($payment_amount==5.00&&$payment_currency=="GBP"){
$AD = 1000;
$AD2 = $credits + $AD;
mysql_query("UPDATE Game SET Credits = '$AD2'WHERE user = '$update'");
}
if ($payment_amount==10.00&&$payment_currency=="GBP"){
$AD = 10000;
$AD2 = $credits + $AD;
mysql_query("UPDATE Game SET Credits = '$AD2'WHERE user = '$update'");
}
if ($payment_amount==49.99&&$payment_currency=="GBP"){
$AD = 100000;
$AD2 = $credits + $AD;
mysql_query("UPDATE Game SET Credits = '$AD2'WHERE user = '$update'");
}
}
if ($payment_status=="Failed"){
echo "Payment Failed!";
} 
if ($payment_status!=""){
echo "Error processing payment!";
}else {
echo "No payment made";
}

 

[Freid001]

Please help

[bradweston]

You sure the SQL works without a space between ' and WHERE?