EQEmulator Forums

Page 2 of 2

Show 40 post(s) from this thread on one page

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- General::General Discussion (https://www.eqemulator.org/forums/forumdisplay.php?f=586)

- - Bags (https://www.eqemulator.org/forums/showthread.php?t=40518)

Huppy

12-19-2020 07:57 PM

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.

Code:

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

12-21-2020 10:13 AM

Quote:

Originally Posted by Huppy (Post 265872)

Code:

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.

Code:

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

Huppy

12-21-2020 06:00 PM

Quote:

Originally Posted by Splose (Post 265881)

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

Code:

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 ;)

javewow

11-02-2025 12:07 AM

Change this code and it will become a 40-slot large backpack.

static uint32 GetDisenchantedBagID(uint8 bag_slots)
{
switch (bag_slots) {
case 4:
return 77772; // "Small Disenchanted Backpack"
case 6:
return 77774; // "Disenchanted Backpack"
case 8:
return 77776; // "Large Disenchanted Backpack"
case 40:
return 77778; // "Huge Disenchanted Backpack"
default:
return 0; // no suitable conversions
}
}

-------------
Only supports ROF but does not support SOD. I don't know where to make the changes for SOD.

All times are GMT -4. The time now is 11:41 AM.

Page 2 of 2

Show 40 post(s) from this thread on one page