Redeem-mysql
This plugin make possible to inject items or money in a mysql table, players just have to enter the command /redeem to get the items associated with their account.
English or french version of the plugin.
How to use :
You need the mysql connector in your /lib/ folder of the server (you can find the connector on mysql site)
Your need the Vault plugin.
Drop the plugin in your /plugins folder (english or french version).
Run the server and close it!
Edit the config file in /plugins/Redeem with your MySQL host/login/pass
Run the server, it should create the redeem table in your DB, to give something to a player just insert the player name in the field "player", in the field "item" just insert the item ID (or item ID:damage value) a space and the amount, if you want to give money insert "money" istead of the item ID. Exemple : INSERT INTO redeem(player,item) VALUES ('john123','35:14 64'); Give 64 red wool to john123 (john have to type /redeem in game) INSERT INTO redeem(player,item) VALUES ('tim','money 742'); Give 742 euro to tim (if your money in game is 'euro')
Note : if a player cant redeem an item because his inventory is full, he don't lose it! He just have to make some room and type the commande again.
With this plugin you can make web shop like on my website (in french) : www.minecraft-addict.com test account : login = test , password = 123
Permission : redeem.get => allow to a group/player to use the redeem command.
To download it (alway the lastest version here! ), english, or french version (players messages are translated) :
Maybe if you release the source code of this plugin, the other users can participate in development. Also is this work with multiply items? For example if I put in DB 2 items:
INSERT INTO redeem(player,item) VALUES ('john123','35:14 64, 35:0 64');
Will this give 64 red and 64 white wool to john123 or I must insert in DB a row for each item:
INSERT INTO redeem(player,item) VALUES ('john123','35:14 64');
INSERT INTO redeem(player,item) VALUES ('john123','35:0 64');
Been looking for something similar to this. Would it be possible to use a command to insert the item in the database such as /redeemInsert?
Also, could you add a onPlayerJoinEvent option which sends a message to the player if they have items to redeem?
Bad that it dont work with enchants
It dont recognize third value: 276 1 16:4 (this mean diamond sword with sharpness 4)
I dont know if it works with enchanted items. Maybe if you can ad the damage value, but I dont know how to do it. You can add mods, potions, ...
good idea
Wow great job, very nice indeed! But I have a question. Did this work with enchanted items and if YES, how to put enchanted items in DB what ID's they have?