1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
|
<?php
// inspect IPN validation result and act accordingly
include('_init.php');
unset($paypal_data);
$data = $_POST;
foreach($data as $name => $value){
$text .= $name.'='.$value.'<br>';
}
$paypal_data['text'] = $text.$_SERVER['REMOTE_ADDR'];
$sql = mysql_install($paypal_data, 'paypal_log', 'add','','',2);
bind_pdo($sql, array());
if($_POST){
if(PRODUCTION == 1){
$ip = $_SERVER['REMOTE_ADDR'];
}else{
$ip = '173.0.82.126';
}
if(substr($ip, 0, -7) == '173.0'){
if($data['txn_id'] && $data['payment_status']){
$sql = "SELECT count(*) as count FROM `order` where paypal_id = ? and id != ?";
$has_txn = bind_pdo($sql, array($data['txn_id'],intval($data['custom'])), "selectone");
if($has_txn['count'] == 0){
unset($tmp_order_data);
if($data['payment_status']=='Completed' && $data['txn_type'] == 'web_accept'){
$tmp_order_data['status'] = 'paid';
}elseif($data['payment_status']=='Refunded'){
$tmp_order_data['status'] = 'refunded';
}else{
$tmp_order_data['status'] = 'cancel';
}
send_order_notification($tmp_order_data['status'],intval($data['custom']));
$tmp_order_data['paypal_id'] = $data['txn_id'];
$tmp_order_data['paypal_date'] = date("Y-m-d H:i:s");
$tmp_order_data['status'] = 'paid';
$sql = mysql_install($tmp_order_data, 'order', 'edit','id');
$tmp_order_data['id'] = intval($data['custom']);
$arraykey = array_keys($tmp_order_data);
unset($parameters);
for ($i = 0; $i < count($arraykey); $i++) {
$parameters[$i] = $tmp_order_data[$arraykey[$i]];
}
bind_pdo($sql, $parameters);
/*
if($data['payment_status']=='Completed'){
$MatchTeamApp->sendMail(intval($data['custom']));
}*/
}
}
}
}
?>
|