像PHP中的Woot-badge [英] Woot-badge like in PHP

问题描述

有人知道如何在用PHP编写的网站中实现某些东西，类似于堆栈溢出时的Woot徽章和Fanatic徽章吗?如果用户每天访问我的网站75天，而没有几天他们不访问我的网站，我想奖励他们.我的网站使用会话进行登录.而且我使用的是MySQL数据库.

Does anybody knows how to implement something into a website written in PHP, similar to the Woot-badge and the Fanatic-badge on stack overflow? I want to reward my users if they visit my site everyday for 75 days, without days they don't visit it. My site uses sessions for log ins. And I use a MySQL database.

用户表现在看起来像这样:

The users table now looks like this:

COLUMN NAME        TYPE
id                 integer
username           varchar
password           varchar
email              varchar
(7 columns with privacy settings) integer
lastvisit          integer
lastlogin          integer

推荐答案

伪代码:

switch last visit
   case yesterday
      increment counter by 1
      set last visit to today
      if counter == 75
          award badge
   case more than a day ago
      set counter to zero
      set last visit to today

这篇关于像PHP中的Woot-badge的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！