Need Help With Php On Server.

[Orphros]

I have this php :

<?php
$email = 'yourpaypalemail';
$url = 'locationofdatabase';
$user = 'username';
$password = 'password';
$database = 'DatabaseName';
$sandbox = 'false';
$packages = array(
  "package1" => "ExamplePackage",	 "package2" => "Yourpackagetwo",
  "package3" => "Yourpackagethree"
);
function anti_injection($sql) {
  foreach ($sql as &$value) {
   if (!is_array($value)) {
	   $value = mysql_real_escape_string(stripslashes(trim($value)));
   }
  }
  unset($value);
  return $sql;
}
$link = mysql_connect($url, $user, $password);
if (!$link) {
  die('Not connected : ' . mysql_error());
}
$db_selected = mysql_select_db($database, $link);
if (!$db_selected) {
  die ('Can\'t use database : ' . mysql_error());
}

$req = 'cmd=' . urlencode('_notify-validate');

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


if($sandbox == 'true'){
$url = '[url="https://www.sandbox.paypal.com/cgi-bin/webscr%27;"]https://www.sandbox....in/webscr';[/url]
} else {
$url = '[url="https://www.paypal.com/cgi-bin/webscr%27;"]https://www.paypal.c...in/webscr';[/url]
}
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL,$url);
curl_setopt($ch, CURLOPT_RETURNTRANSFER,1);
curl_setopt($ch, CURLOPT_POST, 1);
curl_setopt($ch, CURLOPT_POSTFIELDS, $req);
curl_setopt($ch, CURLOPT_HTTPHEADER, array("Content-Type: application/x-www-form-urlencoded", "Content-Length: " . strlen($req)));
curl_setopt($ch, CURLOPT_HEADER , 0);  
curl_setopt($ch, CURLOPT_VERBOSE, 1);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, FALSE);
curl_setopt($ch, CURLOPT_TIMEOUT, 30);

$curl_result = @curl_exec($ch);
$curl_err = curl_error($ch);
curl_close($ch);
$_POST = anti_injection($_POST);
$item_name = $_POST['item_name'];
$item_number = $_POST['item_number'];
$payment_status = $_POST['payment_status'];
$amount = $_POST['mc_gross'];
$payment_currency = $_POST['mc_currency'];
$txn_id = $_POST['txn_id'];
$receiver_email = $_POST['receiver_email'];
$payer_email = $_POST['payer_email'];
$player = mysql_real_escape_string(stripslashes(trim($_POST['custom'])));
$settle = $_POST['settle_amount'];
$package=false;
foreach($packages as $pack){
if($pack == $item_name){
$package=true;
}
}
//if($settle!=''){
//$amount = $settle;
//}

if (strpos($curl_result, "VERIFIED")==0)
{
  if ($payment_status == 'Completed' && $receiver_email == $email){
   $query = "INSERT INTO toothtransaction (player, amount, used, ipn) VALUES ('{$player}', {$amount}, 0, '{$txn_id}')";
   mysql_query($query);
if($package==true){
$query = "INSERT INTO toothpackages (player, cost, status, package) VALUES ('{$player}', {$amount}, 0, '{$item_name}')";
mysql_query($query);
}
mysql_close();
  }
}
?>

 

 

 

And I need help cutting it down becasue evertime someone connect to the remote database on my minecraft server it lags alot. Im stuck and need help. I need to find out what part is causing the lag and I am debating between a remote database vs a local database.

Edited December 10, 2012 by Maq

[gristoi]

your lag is more than likely the delay in waiting from a response from the paypal api. it can take a good few seconds to get a valid response