/**
* Adding adena by database
* @param sellerObjectId
* @param adena
*/
public void addAdenaToSeller(int sellerObjectId, long adena)
{
int objId = -1;
try (Connection con = DatabaseFactory.getInstance().getConnection(); PreparedStatement statement = con.prepareStatement("SELECT object_id FROM items WHERE item_id=57 AND owner_id=" + sellerObjectId + " AND loc='INVENTORY'"); ResultSet rset = statement.executeQuery())
{
if (rset.next())
objId = rset.getInt("object_id");
}
catch (SQLException e)
{
_log.error("Error while selecting adena:", e);
}
if (objId == -1)
{
ItemInstance item = ItemFunctions.createItem(57);
item.setCount(adena);
item.setOwnerId(sellerObjectId);
item.setLocation(ItemLocation.INVENTORY);
ItemsDAO.getInstance().save(item);
}
else
{
try (Connection con = DatabaseFactory.getInstance().getConnection(); PreparedStatement statement = con.prepareStatement("UPDATE items SET count=count+" + adena + " WHERE object_id=" + objId))
{
statement.execute();
}
catch (SQLException e)
{
_log.error("Error while selecting adena:", e);
}
ItemsDAO.getInstance().getCache().remove(objId);
}
}
on this part change the id 57 (adena) (its not only 1 change use ctrl+f to find all)
in your id and see if it works