update affiliate states