对于我的网站,我希望我的用户每月都是会员。因此,一旦他们购买了会员资格,他们将拥有31天的会员资格。我该怎么做,当31天结束时,他们就失去了那里的会员资格。我还想让每月的会员资格经常性。我想我只是给你们看我的ipn为贝宝。
<?php
include("session1.php");
ini_set('log_errors', true);
ini_set('error_log', dirname(__FILE__).'/ipn_errors.log');
include('ipnlistener.php');
$listener = new IpnListener();
$listener->use_sandbox = true;
try {
$listener->requirePostMethod();
$verified = $listener->processIpn();
} catch (Exception $e) {
error_log($e->getMessage());
exit(0);
}
if ($verified) {
$errmsg = '';
if ($_POST['payment_status'] != 'Completed') {
exit(0);
}
if ($_POST['mc_currency'] != 'USD') {
$errmsg .= "'mc_currency' does not match: ";
$errmsg .= $_POST['mc_currency']."'n";
}
else
require("include/config.php");
$mailer = "email@email.com";
$item_name = $_POST['item_name'];
$item_number = $_POST['item_number'];
$payment_status = $_POST['payment_status'];
$payment_amount = $_POST['mc_gross'];
$payment_currency = $_POST['mc_currency'];
$txn_id = $_POST['txn_id'];
$receiver_email = $_POST['receiver_email'];
$email = $_POST['payer_email'];
$first_name = $_POST['first_name'];
$last_name = $_POST['last_name'];
$custom = $_POST["custom"];
$userid = $custom;
mysql_query("UPDATE users SET plan='$item_name', memberstatus='member', subdays='31' WHERE username='$userid'");
$sql = "INSERT INTO orders VALUES
(NULL, '$userid', '$receiver_email', '$item_name', '$payment_amount')";
echo "Payment accpeted. Redirecting ";
if (!mysql_query($sql)) {
error_log(mysql_error());
exit(0);
}
}
?>
使用数据库可以轻松完成此操作。在members
数据库表中添加一个名为last_renewed
的字段。此字段将包含成员上次续订帐户的timestamp
。
在php文件中,将当前时间与相差31天的last_renewed
值进行比较。
例如(使用unix时间戳)
$period = 31*24*60*60; //31 days in seconds.
if(time() - $member['last_renewed'] > $period)
{
echo "You'll have to renew your account";
}
else
{
//He's ok.
}
编辑:您的更新代码:
$time = time(); //Current unix timestamp
mysql_query("UPDATE users SET plan='$item_name', memberstatus='member', subdays='$time' WHERE username='$userid'");