-
Notifications
You must be signed in to change notification settings - Fork 10
/
purchases.php
40 lines (32 loc) · 1.04 KB
/
purchases.php
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
<?php
// **************************************************************************
//
// This file implements the endpoint for the "purchases" API call.
//
require_once 'header.php';
$app_id = $_GET['app_id'];
$user_id = $_GET['user_id'];
// Retrieve latest receipts
$result = $file_db->query(
"SELECT base64_receipt FROM receipts
WHERE app_id='$app_id' AND user_id='$user_id' AND type='auto-renewable-subscription'
ORDER BY transaction_id DESC LIMIT 0, 1"
);
$base64_latest_receipt = $result->fetchColumn();
if ($base64_latest_receipt) {
$data = verifyReceipt($base64_latest_receipt);
markIssuesAsPurchased($data, $app_id, $user_id);
$subscribed = ($data->status == 0);
} else {
$subscribed = false;
}
$result = $file_db->query(
"SELECT product_id FROM purchased_issues
WHERE app_id='$app_id' AND user_id='$user_id'"
);
$purchased_product_ids = $result->fetchAll(PDO::FETCH_COLUMN);
echo json_encode(array(
'issues' => $purchased_product_ids,
'subscribed' => $subscribed
));
?>