If you want something simple and quick you could always set up a simple Cron job to reset the counter to 0 across the db table and set it to run at midnight daily...