database_query('SELECT * FROM `se_ats_setting`');
while($aSetting = $database->database_fetch_assoc($rSql))
{
switch($aSetting['setting_code'])
{
case "paypal_email":
$this->sPayPalEmail = $aSetting['setting_value'];
break;
case "currency":
$this->currency = $aSetting['setting_value'];
break;
case "image_size":
$aSize = explode(',',$aSetting['setting_value']);
$this->image_width = $aSize[0];
$this->image_hight = $aSize[1];
break;
}
}
$this->return_url = 'http://'.$_SERVER['HTTP_HOST'].'/ats_tracking_return.php';
$this->notify_url = 'http://'.$_SERVER['HTTP_HOST'].'/ats_tracking_notify.php';
$this->cancel_url = 'http://'.$_SERVER['HTTP_HOST'].'/ats_tracking_cancel.php';
}
function sendRequest($sItemId,$iAmount){
echo "
";
echo '
';
echo '
';
echo "";
return 1;
}
function notifyRequest(){
global $database;
global $setting;
$admin = new se_admin(1);
$postdata="";
foreach ($_POST as $key=>$value) $postdata.=$key."=".urlencode($value)."&";
$postdata .= "cmd=_notify-validate";
$curl = curl_init($this->sPayPalPath);
curl_setopt ($curl, CURLOPT_HEADER, 0);
curl_setopt ($curl, CURLOPT_POST, 1);
curl_setopt ($curl, CURLOPT_POSTFIELDS, $postdata);
curl_setopt ($curl, CURLOPT_SSL_VERIFYPEER, 0);
curl_setopt ($curl, CURLOPT_RETURNTRANSFER, 1);
curl_setopt ($curl, CURLOPT_SSL_VERIFYHOST, 1);
$response = curl_exec ($curl);
curl_close ($curl);
if ($response != "VERIFIED") die("You should not do that ...");
if ($_POST['receiver_email'] != $this->sBisnessEmail || $_POST["txn_type"] != "web_accept")
{
send_generic($admin->admin_info['admin_email'],"$setting[setting_email_fromname] <$setting[setting_email_fromemail]>",'PayPal error on site http://'.$_SERVER['HTTP_HOST'],'Invalid receiver email
Transaction ID: [TRANS]
Receiver email: [EMAIL]',array('[TRANS]','[EMAIL]'),array($order_id,$_POST["txn_id"],$_POST['receiver_email']));
exit();
}
$rSql = $database->database_query("SELECT true FROM `se_ats_tracking_payment` WHERE txn_id='".$_POST["txn_id"]."'");
$duplicate = $database->database_num_rows($rSql);
if ($duplicate) die();
if($_POST['payment_status'] != 'Completed')
{
exit();
}
$order_id = intval($_POST['item_number']);
list($user_id) = $database->database_fetch_array($database->database_query('SELECT user_id FROM `se_ats_tracking_payment` WHERE payment_id = '.$order_id));
if ($_POST["mc_currency"] != $this->currency)
{
send_generic($admin->admin_info['admin_email'],"$setting[setting_email_fromname] <$setting[setting_email_fromemail]>",'PayPal error on site http://'.$_SERVER['HTTP_HOST'],'Payment currency mismatch
Order ID:
Transaction ID:
Currency:
Amount: ',array('', '', '', ''),array($order_id,$_POST["txn_id"],$_POST["mc_currency"]));
exit();
}
$order_date = date("Y-m-d H:i:s");
$col_days = 0;
list($col_days) = $database->database_fetch_array($database->database_query('SELECT col_days FROM `se_ats_tracking_price` WHERE price ='.$_POST['mc_gross'].' LIMIT 1 '));
if (!$col_days)
{
send_generic($admin->admin_info['admin_email'],"$setting[setting_email_fromname] <$setting[setting_email_fromemail]>",'PayPal error on site http://'.$_SERVER['HTTP_HOST'],'Can \' find count of day on price
Order ID:
Transaction ID:
',array('', '', ''),array($_POST["mc_gross"], $order_id, $_POST["txn_id"]));
exit();
}
$rSql = $database->database_query('SELECT UNIX_TIMESTAMP(payment_to_date) AS payment_to_date FROM `se_ats_tracking_payment` WHERE user_id = '.$user_id.' AND payment_to_date > NOW() AND payment_status = "approved" ORDER BY payment_to_date DESC');
if ($database->database_num_rows($rSql)>0)
{
$bShowPayPal = false;
list($iStartTime) = $database->database_fetch_array($rSql);
} else {
$iStartTime = time();
}
$iPaymentToDate = $iStartTime + $col_days*3600*24;
$database->database_query("UPDATE `se_ats_tracking_payment` SET
payment_date = '".$order_date."',
payment_price = '".$_POST["mc_gross"]."',
payment_to_date = '".date("Y-m-d H:i:s",$iPaymentToDate)."',
invisibility_active = 1,
txn_id = '".$_POST["txn_id"]."',
payment_status = 'approved'
WHERE payment_id = ".$order_id);
$iInsertId = $database->database_insert_id();
}
function cancelRequest(){
$database->database_query('DELETE FROM se_ats_tracking_payment WHERE ');
}
}
?>