God damn it!!
So you would think that mobile devices would all have a unique identifier built in. i mean, how else could the network establish which phone is which. So with that in mind i did a quick google and found that unity can access this unique device ID. GREAT!!
I go ahead and build the entire API for Gary leaderboard based on this.
Today, I start implementing the API into the game and BAM!! the unique identifier is not only not guaranteed to remain the same on any given device, it may not exist at all?!?!??! Mother f*#ckers!!
Anywho, like all thing in coding, this is just a problem that needs a solution and i figured one out. Just means I now have to revisit every table and stored proc in the API and modify to work with my new methodology.