i wish to make my bank intrest only go up via being active, i currently have a working sytem, when you login it redirects you to the logged in page which sets you as active and at the end of each day the day cron sets you back to inactive. altho i cannot work out how to get the bank intrest to only go up in the crons when you are active that day can anyone please help with this?
here is the piece of code i wish to only work if active= 1 but im unsure if i can repeat the where command or not :p
$db->query("UPDATE users SET bankmoney=(bankmoney*1.003) where bankmoney>0");
any help would be GREATLY appreaciated ty