Nevermind, I kinda see why that wouldn't work.
How often do totals update? I've added all my past donations as anonymous under the correct user. One user donated today whom has donated in the past and wished to be visible. So I edited the previous entries and took off anonymous. His total isn't updating though. Is that something that should happen?
edit: So this member donated 100, I removed his previous entry of 75 then added it again to him as not anonymous and now his total is 75? wtf
There's no index on merc_donor? Why doesn't this table have username as unique? Wouldn't that be easier to do insert on duplicate update? Why does that table exist when all that information is in merc_donation. It seems the goal is to be able to mix anonymous and public but it doesn't seem to work correctly for updating the table.
The sum for that user in one table is different than the sum of the same user in the other table.