updating affiliate histor