Saving item enchantments in database.

Hey, Im making a plugin that deposit items in MySQL database for later withdraw by a player but i dont know howto save the enchantments...

to save the item meta/enchantments in Database i need to convert it to string... and i cant convert it back to ItemMeta... -.- Is there any good way to make this?

This is my code:

Thanks.

Code:java

public static void DepositAction(Player player, ItemStack deposititem) throws SQLException{
String playerName = player.getDisplayName();
int itemID = deposititem.getTypeId();
short itemSubID = deposititem.getDurability();
String itemName = deposititem.getType().name();
int itemAmount = deposititem.getAmount();
String itemMeta = deposititem.getItemMeta().toString();
String itemEnchantment = deposititem.getEnchantments().toString();
 
if (deposititem.getItemMeta().toString().contains("ENCHANTED_META") && deposititem.getEnchantments().toString().contentEquals("{}")){
player.sendMessage(ChatColor.DARK_GREEN + "[DEBUG] " + ChatColor.WHITE + "BOOK!");
}
if (deposititem.getItemMeta().toString().contains("UNSPECIFIC_META") && deposititem.getEnchantments().toString().contains("Enchantment")){
player.sendMessage(ChatColor.DARK_GREEN + "[DEBUG] " + ChatColor.WHITE + "ITEM!");
ItemStack myItem = new ItemStack(itemID, itemAmount, itemSubID);
// I want to add here the enchantments/itemmeta(for books)...
player.getInventory().addItem(myItem);
player.updateInventory();
}
if(itemID != 0){
mysql.depositItemDB(playerName, itemID, itemSubID, itemName, itemAmount, itemMeta, itemEnchantment);
}
if (mysql.mysql_success() == true){
player.setItemInHand(null);
}
}

 

You can get the enchantment id on an item. There's also a little resource that contains a method to serialize an Inventory to a single string and vice versa, http://forums.bukkit.org/threads/serialize-inventory-to-single-string-and-vice-versa.92094/ , might be useful

 

cool, im currently testing it because i dont want to "set" an inventory. My plugin its a item transfer from a server to another server, so i want to keep the current inventory items in the target server...

Thanks anyways for that link. it can be the soluction, i feel it

 

Only thing you might want to add is a displayname and lore saver to the current serialization, if you need help with that, ask me if you want

 

Well, and enchanted books ^^ I will continue when i come from work, but if you know how to add it i will appreciate (for me will be a pain, learning java now ahah). I changed it a bit for my use... ItemStack instead of whole inventory.... Here is my current code:
Thanks for the awesome help, this saved me a lot of work and works perfectly.

Code:java

 
public class ItemStackSerializer {
@SuppressWarnings("deprecation")
public String ItemStackToString (ItemStack itemStack){
String serialization = null;
 
if (itemStack != null){
String serializedItemStack = new String();
 
String itemStackType = String.valueOf(itemStack.getType().getId());
serializedItemStack += "Item@" + itemStackType;
 
if (itemStack.getDurability() != 0){
String itemStackDurability = String.valueOf(itemStack.getDurability());
serializedItemStack += ":d@" + itemStackDurability;
}
 
if (itemStack.getAmount() != 1){
String itemStackAmount = String.valueOf(itemStack.getAmount());
serializedItemStack += ":a@" + itemStackAmount;
}
 
Map<Enchantment,Integer> itemStackEnch = itemStack.getEnchantments();
if (itemStackEnch.size() > 0){
for (Entry<Enchantment,Integer> ench : itemStackEnch.entrySet()){
serializedItemStack += ":e@" + ench.getKey().getId() + "@" + ench.getValue();
}
}
 
serialization = serializedItemStack;
}
return serialization;
}
 
@SuppressWarnings("deprecation")
public ItemStack StringToItemStack (String serializedItem, Player player){
ItemStack itemStack = null;
Boolean createdItemStack = false;
String[] serializedItemStack = serializedItem.split(":");
for (String itemInfo : serializedItemStack){
String[] itemAttribute = itemInfo.split("@");
if (itemAttribute[0].equals("Item")){
itemStack = new ItemStack(Material.getMaterial(Integer.valueOf(itemAttribute[1])));
createdItemStack = true;
}
else if (itemAttribute[0].equals("d") && createdItemStack){
itemStack.setDurability(Short.valueOf(itemAttribute[1]));
}
else if (itemAttribute[0].equals("a") && createdItemStack){
itemStack.setAmount(Integer.valueOf(itemAttribute[1]));
}
else if (itemAttribute[0].equals("e") && createdItemStack){
itemStack.addEnchantment(Enchantment.getById(Integer.valueOf(itemAttribute[1])), Integer.valueOf(itemAttribute[2]));
}
}
ItemStack unserializedItem = itemStack;
return unserializedItem;
}
}

 

With the awesome help of @EcMiner this issue is solved. For who want something like this here is my final code. It supports item enchantments and book stored enchantments!

Code:java

 
public class ItemStackSerializer {
@SuppressWarnings("deprecation")
public String ItemStackToString (ItemStack itemStack, Player player){
String serialization = null;
 
if (itemStack != null){
String serializedItemStack = new String();
 
String itemStackType = String.valueOf(itemStack.getType().getId());
serializedItemStack += "Item@" + itemStackType;
 
if (itemStack.getDurability() != 0){
String itemStackDurability = String.valueOf(itemStack.getDurability());
serializedItemStack += ":d@" + itemStackDurability;
}
 
if (itemStack.getAmount() != 1){
String itemStackAmount = String.valueOf(itemStack.getAmount());
serializedItemStack += ":a@" + itemStackAmount;
}
 
Map<Enchantment,Integer> itemStackEnch = itemStack.getEnchantments();
if (itemStackEnch.size() > 0){
for (Entry<Enchantment,Integer> ench : itemStackEnch.entrySet()){
serializedItemStack += ":e@" + ench.getKey().getId() + "@" + ench.getValue();
}
}
 
if (itemStack.getType() == Material.ENCHANTED_BOOK){
EnchantmentStorageMeta bookmeta = (EnchantmentStorageMeta)itemStack.getItemMeta();
Map<Enchantment, Integer> enchantments = bookmeta.getStoredEnchants();
if (enchantments.size() > 0){
for(Entry<Enchantment,Integer> bookenchants : enchantments.entrySet()){
player.sendMessage(ChatColor.DARK_GREEN + "[Debug] " + ChatColor.WHITE + bookenchants);
serializedItemStack += ":m@" + bookenchants.getKey().getId() + "@" + bookenchants.getValue();
}
}
}
 
serialization = serializedItemStack;
}
return serialization;
}
 
@SuppressWarnings("deprecation")
public ItemStack StringToItemStack (String serializedItem, Player player){
ItemStack itemStack = null;
Boolean createdItemStack = false;
String[] serializedItemStack = serializedItem.split(":");
for (String itemInfo : serializedItemStack){
String[] itemAttribute = itemInfo.split("@");
if (itemAttribute[0].equals("Item")){
itemStack = new ItemStack(Material.getMaterial(Integer.valueOf(itemAttribute[1])));
createdItemStack = true;
}
else if (itemAttribute[0].equals("d") && createdItemStack){
itemStack.setDurability(Short.valueOf(itemAttribute[1]));
}
else if (itemAttribute[0].equals("a") && createdItemStack){
itemStack.setAmount(Integer.valueOf(itemAttribute[1]));
}
else if (itemAttribute[0].equals("e") && createdItemStack){
itemStack.addEnchantment(Enchantment.getById(Integer.valueOf(itemAttribute[1])), Integer.valueOf(itemAttribute[2]));
}
else if (itemAttribute[0].equals("m") && createdItemStack){
EnchantmentStorageMeta itemStackMeta = (EnchantmentStorageMeta)itemStack.getItemMeta();
itemStackMeta.addStoredEnchant(Enchantment.getById(Integer.valueOf(itemAttribute[1])), Integer.valueOf(itemAttribute[2]), true);
itemStack.setItemMeta(itemStackMeta);
}
}
ItemStack unserializedItem = itemStack;
return unserializedItem;
}
}