What the hell do we do when players are able to change their names?

So, in the very near future, Jeb will implement player name-change into Minecraft. Now, bans work with name and IP, but will there also be a function for fetching a player-id and ban the player using that?

Right now there's a function called getUniqueUID which returns a 128-byte numeric value, and inserting this into a MySQL table is just not possible, because it's twice the size. What could be a fix for this though, is inserting it into a text column, and then converting it into a numeric value upon extraction from the database.

Did Jeb think this through?

 

You could probably insert a hash of it or something...

Wait and see what happens!

 

An amateur might do this.. a clever person would use two bigint columns...

Code:

CREATE TABLE player (
  `id` int unsigned not null AUTO_INCREMENT,
  `uuid_mostsigbits` bigint not null,
  `uuid_leastsigbits` bigint not null,
  primary key (`id`),
  index `uuid` (`uuid_mostsigbits`, `uuid_leastsigbits`)
)

Fast searching w/ indexes!

Code:

SELECT * FROM player WHERE uuid_mostsigbits = ? AND uuid_leastsigbits = ?

 

The player will have a unique id and a name most likely with everything important being based of the id.

 

If you can change your name, I sense more evil! This is a perfect for hackers/griefers.
7cardcha I hope you're right!