<?php
$day = 60 * 60 * 24;
##Creating day variabale whose value is 1 day's seconds.
$dayago = time() - $day;
##Creating variable dayago whose value is current time - 86400 seconds(day variable) value.
$incrementseq = "UPDATE user SET lastdayactive = (UNIX_TIMESTAMP()/(60*60*24)), daysinsequence =  daysinsequence +1 WHERE userid =" . $uid;
##Creating variable incrementseq which will have update query to update lastactivity day and daysinsequence incremented by 1 here.
$selectday = "SELECT lastdayactive AS lastactive FROM user WHERE userid =" . $uid;
##Creating selectday variable in which we are selecting lastdayactive fiedl value from user table as lasactive.
$resetday = "UPDATE user SET lastdayactive = (UNIX_TIMESTAMP()/(60*60*24)), daysinsequence =  1 WHERE userid =" . $uid;
##Creating restday(which will RESET values of lastdayactive and daysinsequence value to 1 like restarting count of logging of users.)

$day = $vbulletin->db->query_first($selectday);
##Creating day variable where we are running selectday query to get user's lastactiveday from DB.

##Checking condition if lasactive value is greater than yesterday and less than or equal to dayago * 2 value then run incrementseq query.
if ($day['lastactive'] > $dayago && $day['lastactive'] <= $dayago * 2) {
    $status = $vbulletin->db->query_write($incrementseq);
} 
##If lasactiveday value is greater than dayago * 2 value then call reset value for user's day's login.
elseif ($day['lastactive'] > $dayago * 2) {
    $status = $vbulletin->db->query_write($resetday);
}

##Creating variable getseq by select query to get user's updated daysactive value from user table.
$getseq = "SELECT daysinsequence AS daysactive FROM user WHERE userid =" . $uid;
##Run query to get user's active days value here.
$days = $vbulletin->db->query_first($getseq);

##checking conditions to assig badge color as per user's continous logging here.
if ($days['daysactive'] > 14) {
    $color['fahistory'] == 'black';
} elseif ($days['daysactive'] > 7) {
    $color['fahistory'] == 'indigo';
} elseif ($days['daysactive'] > 3) {
    $color['fahistory'] == 'blue';
} elseif ($days['daysactive'] > 1) {
    $color['fahistory'] == 'limegreen';
} else {
    $color['fahistory'] == 'lightgray';
}
$badgejs .= 'badge["fahistory"] = "' . $color['fahistory'] . '";';
$badgejs .= 'badge["fahistoryval"] = "' . number_format($days['daysactive']) . '";';