Bags

[Huppy]

Of course, if you've ever dug into running sql queries,(with Heidi, etc), there is always other little things to help compensate for item storage.In the following example, it will set all items stackable to 100, (that were stackable to begin with) and also set the weight reduction to 100 on all 8 and 10 slot bags. But this can be played with for the individual preferences.

UPDATE items SET stackable = 1
UPDATE items SET stacksize = 100 WHERE stacksize > 0;
UPDATE items SET bagwr = 100 WHERE bagslots = 8 AND bagslots = 10;

[Splose]

Originally Posted by Huppy

Of course, if you've ever dug into running sql queries,(with Heidi, etc), there is always other little things to help compensate for item storage.In the following example, it will set all items stackable to 100, (that were stackable to begin with) and also set the weight reduction to 100 on all 8 and 10 slot bags. But this can be played with for the individual preferences.

UPDATE items SET stackable = 1
UPDATE items SET stacksize = 100 WHERE stacksize > 0;
UPDATE items SET bagwr = 100 WHERE bagslots = 8 AND bagslots = 10;

Should probably do this instead. That query will take all items that were stackable to 1000 and set them to 100.

UPDATE items SET stacksize = 100 WHERE stacksize > 0 AND stacksize < 100;

[Huppy]

Originally Posted by Splose

Should probably do this instead. That query will take all items that were stackable to 1000 and set them to 100.

UPDATE items SET stacksize = 100 WHERE stacksize > 0 AND stacksize < 100;

Ya, mine was just an example (to be played with). I don't allow stacks bigger than 20 on any items, myself