OLD: Inconsistent player information entries

[Maelstromeous]

Currently there are some select characters where their player faction is messed up.

Player Names are incorrect if name change token used

Since the system is using their old name upon the first time being detected, the name isn't being updated as it's the same character ID.

Faction IDs are incorrect

There must have been a bug at some point for insertion of very early characters into the system which caused all their faction IDs to be messed up. I could run every single character through census and correct their IDs, or write a query in the websocket to update them as they appear. Latter is probably less likely to get my ass banned from Census.

Player Outfit IDs are incorrect

Not sure what's gone on here, this should be updated regularly. Could implement same maintenance routine as the name checking to make sure that the outfit is also correct.

Possible solution: Implement a flag on a the player_total entry which is a boolean and occasionally check them. Or add a date and check their character details via Census to validate consistency for Faction, Name and Outfits.

[Maelstromeous]

This issue has been expanded to include player names and outfits.

[Maelstromeous]

Could use the latest player record from the player's latest alert to find this info out rather than polling Census.

[Maelstromeous]

Irrelevant - New version.