5

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
sehe
  • 374,641
  • 47
  • 450
  • 633
  • Similar question here: http://stackoverflow.com/questions/932610/how-to-track-that-a-user-visited-the-site-each-day-for-x-days – viam0Zah Dec 09 '09 at 08:18

1 Answers1

6

Pseudo-code:

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
Quentin
  • 914,110
  • 126
  • 1,211
  • 1,335