whmcs每月重置服务器流量方法

<?php
    $con = mysqli_connect("localhost","root","passwd","数据库");
    if (!$con)
      {
      die('Could not connect: ' . mysql_error());
      }

if(date('d') == 1){  //月初
    
    mysqli_query($con,"UPDATE `user` SET `upload` = '0', `download` = '0', `updated_at` = " . time() );
    mysqli_query($con,"DELETE from `user_usage`");
    echo("has been rest");
}else{
  echo "can't rest";
}
    mysqli_close($con);


?>

具体以数据库为准~

保存php文件,放在网站目录下执行。也可设置自动任务。

删除已停用账户且活动时间小于90天

DELETE FROM tblclients WHERE status = 'Closed' AND lastlogin < DATE_SUB(NOW(), INTERVAL 90 DAY)

相关文章

评论(0)
游客的头像
表情
全部评论
最新