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 '); } } ?>