Loyalty reward - record for every day of a week
Maybe.

SELECT count(distinct date(time_they_logged_in)) 
FROM `users` 
WHERE `users`.`time_they_logged_in` between now()-interval 7 day and now();


If the count is 7 they logged in at least once per day in the past week.