
There may be an issue where if someone is captured in a census (which is uploaded immediately) then deguilds and is captured on the SAME day as the previous census, then he will still show tagged in the database.
Example:
Bishamonten, Damage Incorporated, Durotan server
He has left the game, and after I had uploaded my census data for the day, I noticed him still in the database and tagged with the guild tag. I went and manually modified the LUA file so as to reflect him being unguilded as opposed to being active... uploaded again and he still shows in the guild and there are two entries for the day.
It probably has something to do with time stamps... since I only modified the guild tag and no date/time information, he likely is caught in some "loop" of two entries at the same exact date/time.
Not sure if there's a fix for this or not. Just thought I'd bring it to your attention.