Search Results

FYI, MySQL fields above:

| weeksinsequence | smallint(5) unsigned|
| lastweekactive | float unsigned |
| lastactivity | int(10) unsigned |

Trigger on...

Update:

Currently running this code for the "weeks in sequence badge"... I think I found the bug:

<?php
$aweekinunixtime = 60 * 60 * 24 * 7;
$weekago = (time() - $aweekinunixtime) /...

Update:

There is a bug in this "weeks in sequence" badging code.

Please ignore any "badge updates" related to this badge until I can find the bug and squash it.

Thanks.

Update: After testing, reset all members who have not been active in the past week, as follows:

UPDATE user SET lastweekactive = (lastactivity/(60*60*24*7)), weeksinsequence = 0 WHERE...

PS:

I forgot to mention that I set all forum members to 8 weeks active in a row (black). This means that that single badge will reset to light gray when a user is not active for a week; but...

OK.. this new badge is working OK it seems, will test over time to insure it works properly.

TODO is to get the number of badged changed / awarded and the names of those badges to persist in the...

Hi Ravinder,

Could you (and anyone else who wants to help out) check this PHP code and confirm it does what I expect it to do, which is to color a badge based on the weeks a member is active in...