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
52
|
<?php
// inspect IPN validation result and act accordingly
unset($paypal_data);
$data = $_POST;
foreach ($data as $name => $value) {
$text .= $name . '=' . $value . '<br>';
}
$paypal_data['text'] = $text . $_SERVER['REMOTE_ADDR'];
$paypal_data['createdate'] = date("Y-m-d H:i:s");
$sql = mysql_install($paypal_data, 'paypal_log', 'add', '', '', 2);
bind_pdo($sql, array());
if ($_POST) {
$ip = $_SERVER['REMOTE_ADDR'];
//$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']));
}*/
}
}
}
}
?>
|