Managing Aff Links For Hundreds Of Websites?

I was wondering if anyone could offer me advice with how to cloak affiliate links for a large network of sites? Right now I use htaccess or a php redirect for my affiliate links, but I am looking for a more effecient way to do this for a large network of sites, like 200 plus and growing. So while htaccess or php redirect script works fine, the problem is I still have to login and change things on every site when I want to change url's.

Basically I am in a niche where affiliate links change all the time, so I spend a lot of my time updating htaccess files on hundreds of sites instead of doing marketing or content. So I was hoping to implement a solution that would allow me to change affiliate links in one dashboard or command center.

Now I am not real tech savvy, but after researching a tad I was wondering if perhaps using one master database for my affiliate links would work, then setting up a remote connection to that master database would work? Would that be a viable solution and are there any downsides to doing it this way? I thought I read that mysql only redirects with 302's which isn't ideal.

How do super affiliates manage links on thousands of websites? I have spent hours researching and I am sort of running into a wall with the right approach to this problem. I know I could set up domains for each affiliate product I promote, but this sort of gives away your network for people snooping. So that's not really a good option for me and am hoping to find a better alternative. I also used smart ftp multi upload feature but that creates a few problems for me as well with the amount of websites I am trying to update. So I am thinking some sort of master database option might work best, but it's a lot of information to work through to come up with the right solution which is why I was hoping to lean on some seasoned affiliates here that has run into the same problems I am facing.

Thanks in advance.