Bukkit

What steps will reproduce the problem?
1. Put item into Webshop with MailBox
2. Go into Webshop^^
3.

What is the expected output? What do you see instead?
If you put in some cobbles like 2 Stacks it wont be 128 cobbles in webshop.
there will be 2 Stacks but how to make it stack up to 128 in webshop?

What version of the product are you using?
1.1.5alpha

Do you have an error log of what happened?
---

Please provide any additional information below.

If you want to sell it all at once, put it up for sale and then cancel it and it should make it a big stack.

this has only become a problem since the switch from deposit/withdraw mailbox signs to the new virtual chest type mailbox. I have 2 possible solutions to this.

1. a button to group all similar items into stacks. for instance, in your screenshot with the stacks of cobble, the player would click the button and they would be grouped into a single stack of 132. only problem with this, it uses more cpu time to look over the entire mailbox inventory of a player, count up the total quantity of each item type, remove the extra item records leaving only one of each type, then updating the remaining record with the total quantity. it's not the most efficient method, and the queries can add up. also, when the player opens their mailbox in game, it reverses the process and splits up the stacks again so they can be displayed in the virtual chest.

2. using the inventory from your screenshot, the player would post one of the stacks for sale. at the bottom of the create auction page, I could add a list of the existing auctions that player has of that same item type. so they would then click the button to sell the next 2 stacks of cobble, then click the new button in the list of existing auctions to just add the quantity to the existing auction.

there are other possibilities. if you come up with something better, be sure to post it and I'll consider it. I'm looking for a solution that is the most intuitive, and uses as few queries as possible. more queries mean longer time to render the page, and more load on the server.

I think i know an 3 solution.

Let the homepage recognize multiple items stacks in the inventory and display them as one big stack and don't change anything in the database. Is someone creates the auction you only have to delete all stacks form the inventory database. I think this should be possible without to many queries or CPU time because you only have to search for equal items in the inventory.

Honestly, I liked the original deposit/withdraw signs. Is there anyway to re-enable those?

Also, for the item stack bug, maybe you could have the online inventory count the item and stack it automatically, since I also noticed that my site seems to be getting cluttered with auctions of the same item.

I did find one way to get them to stack right now. If you auction all of the items, then cancel the auctions through the My Items page, they will be in one nice big stack in the inventory.

@MarioG1: Go

only if the player wants to sell all they have of an item. it adds complexity if the player only sells, say 100 stone, and they have 300 in their mailbox inventory. it would have to loop the rows of that item type and remove them until it gets near the target number of 100. so, first it would remove one full stack, then the next stack it would subtract the remaining 36. this can be done reliably. the problem I have is with how the website would have to load the players inventory list. instead of letting the mysql query handle only retrieving the rows it's ready to display, it would have to query every item stack in the players mailbox inventory, look for duplicates, and if found, add the quantity. it needs to process the entire inventory this way before it can pick a few items from this new list to display on the website, each time that page loads. well... with the new virtual chest type mailbox, players can only deposit 56 stacks with a chest at its largest possible size. this means, generally, it wont have to query more than 56 stacks from the players inventory. you might be right. I've been worried about adding any extra load, but this might be worth doing. it might run pretty fast.

@Lcarens: Go

some items still worked with the old deposit/withdraw signs, but there were a lot that weren't possible to deposit anymore. I did want to make it an optional feature, but since some items no longer work, I removed it for that reason. if a fix is found to make this work right again, I could possibly add the feature back in again. I may try going with MarioG1's suggestion. I'd have to change a bunch of other code to make everything work right again, but it may work well.

what do you think of this idea for a feature. it's something I've thought about doing for a while. instead of a list of items, like what's currently used on the My Items page, I'd like to have a feature that looks more like the in-game inventory. you could mouse-over the items to view info about it.

Honestly, I liked the .