Hi guys (and girls!), I have done some cleanup that helps visibly in the Top 25 Wealthiest.
1) Removed a few obvious cheaters
2) Removed some duplicates that were visible (and some that were not)
If you see other issues that I can correct (more dupes or hax) please let me know. Unfortunately the server is too slow for me to process a single MySQL query that can remove ALL dupes for ALL names at once, so I manually ran a de-dupe on obvious names that were in the list.
Interesting aside on the duplicates:
Apple used to allow the UDID (unique device identifier) to be read by applications. This was what RT used to grab to "identify" the gamer, not in a truly identifiable way, but at least it would ensure you didn't post the same scores multiple times when accessing the server.
Bad things started to happen as people migrated to new devices and copied the Hall of Fame files with them, they would get re-submitted with a new UDID.
Even more bad things happened after Apple removed UDID access from apps. Then all we had was an "advertising identifier", which is re-randomized whenever you install the app or whenever Apple or the Device user desires. That creates MORE duplicates!
I've changed the PHP routine that stores new Hall of Fame data on the server, so it will IGNORE the UDID / advertising identifier field. Instead it performs a query on the database to see if any entries match the data you are uploading (name, rank, floor reached, gold, number of steps/kills, etc).
If it finds a matching record already there it won't insert another anymore