All flags are remove if new status is Approved or if Old status is Pending and new is Unmoderated.
Note that ALL flags are remove regardless the user.