UUIDSql
UUIDSql 0.2.8
What is this plugin ?
This plugin allow you to store in a database, the UUID that correspond to the player and it real username. I made this plugin because with the recent change, some plugins are storing the username of a player with the new form. So for instance when the minecraft server is linked to a website ( via a database ), if plugins are storing the player name with this identifier, we can't have the player username that correspond to it. For example the well known plugin permissionsEx use this UUIDs to store player permissions and in my case I need to get permissions player informations in the website. That all why I made this usefull plugin ( for me it is usefull )
This plugin is not very interesting if you didn't need to work with a website.
How it work ?
That is realy simple. When a player joined the server, we add a new line in the mysql table. when the player is already in the table we simply update his UUID.
Commands ?
Since version 0.2.8, six commands are available :
- uuidsql reload.
- uuidsql getname <uuid>
- uuidsql getuuid <name>
- uuidsql purge
- uuidsql removeuuid <uuid>
- uuidsql removename <username>
This commands are available to everyone without permissions from player side and in the console.
Plugin permissions
Console didn't need permissions but peaple who wan't to execute remove command or purge or reload command need permissions. For this plugin there are 2 entity :
- uuidsql.reload -> to allow the user to reload the plugin
- uuidsql.remove -> to allow the user tu use remove and purge command
Plugin Configuration :
That realy simple. you just need to go in the config.yml file and change the database information with informations that correspond to your database.
Sources ?
The full code source is available on our github.com repos, here.
Note: THIS PLUGIN WAS CREATED AND TESTED FOR MINECRAFT 1.7.9 SO I DON'T KNOW IF IT WILL WORK WITH LOWER VERSIONS. YOU HAVE TO USE JAVA 7 OTHERWISE THE PLUGIN WON'T LOAD !
Is it works with 1.8
@guigui144
No, thats the sense behind the uuid... it's unique per account. if you change your nick the uud stays the same. in that way you prevent players from takiing over the stuff of other players. Means: All plugins should support uuid instead of usernames as they will be spoofable soon.
@Blugga
If the player name changed, I think that uuid would change ? isn't it ?
When a player change his name in 1.8, will the plugin stores the new name and the previous name? It would be awesome
Thank you for this, and thank you @fungreenfox! This is my first SQL plugin I tried and it worked great. I'm excited to do more.
it has been updated.
1 Removed choise of reversing order, and corrected a misspell.
2 Added text in top of page, if database is not existing.
3 Changed the way, db is being managed, compability issue.
Make sure to use PHP version 5.x. If using v.4.x, i can not asure it will work then.
@fungreenfox
Not bad but it can be improved, I think ...
@twinfrozr33
Yes it is possible but can you explain that to me in private message ? I am opened to all suggestions !
A little php page for the plugin http://mcraft.dk/downloads/uuidsql.zip
Is it possible for you to add something like:
- Custom Database table/field
So we can add uuid's to players on forums like for example in a custom field.
@fungreenfox
Corrected ! You will be soon able to get the updated version of this plugin ! Edit :Now available on the github repository !
[UUIDSql] Cause: Unknown storage engine 'InnoDB'
Can you make MyIsam possible to use? i do not have InnoDB.
@connorlinfoot
You can't use that website because you need to be issued a private API key. So if he used that in the plugin, people could grab the key and abuse it without being caught.
In theory, you could make your own php script on your own website that connects to this service with a specific API key, but that's rather useless since bukkit has its own method for grabbing the UUID of a player.
@connorlinfoot
This website is not what I want ! When I get my uuid with the site, it is not the same one as the uuid generated in game for the same username. So I decided to make this plugin because on my minecraft server website, I need to get some informations that are stored in my database and if uuid's does not match, I can't get them ! I think you understand ...
You could just get a username from the UUID using TheMinecraftAPI.com?
@Cadiducho
Ok no problem your feature is added to the code. I am going to build the code
Hi! This is a very good idea, but I've seen a little "bug"? I think that the plugin must create the MySQL table by itself, so I pull request in github for add this feature