MySQL, Get info from player UUID

Discussion in 'Plugin Development' started by haussik, Jan 22, 2015.

Thread Status:
Not open for further replies.
  1. Offline

    haussik

    I'm looking to get some information in my SQL database using the UUID of the player.

    Example: Check the UUID of the player and get the level stored in the database using his UUID. How can i do this? Please :)


    Thanks !
     
  2. Offline

    Konato_K

    What do you have so far?
     
  3. Offline

    mythbusterma

    @haussik

    Well, I would create a table that associates Player's UUID's with thier names, and another table that associates the UUID with whatever data you have, both tables using the UUID as a primary key.
     
  4. Offline

    1Rogue

    That seems silly, just have multiple columns such as "some_level", "uuid", "last_name" etc.
     
  5. Offline

    mythbusterma

    @1Rogue

    Have you not done database normalisation before?
     
  6. Offline

    1Rogue

    Yes, but from what the OP described a single table will work fine for this.
     
  7. Offline

    mythbusterma

Thread Status:
Not open for further replies.

Share This Page