Go Back   EQEmulator Home > EQEmulator Forums > General > General::General Discussion

General::General Discussion General discussion about EverQuest(tm), EQEMu, and related topics.
Do not post support topics here.

Reply
 
Thread Tools Display Modes
  #16  
Old 12-19-2020, 07:57 PM
Huppy's Avatar
Huppy
Demi-God
 
Join Date: Oct 2010
Posts: 1,333
Default

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;
Reply With Quote
  #17  
Old 12-21-2020, 10:13 AM
Splose
Banned
 
Join Date: Apr 2014
Posts: 279
Default

Quote:
Originally Posted by Huppy View Post
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;
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;
Reply With Quote
  #18  
Old 12-21-2020, 06:00 PM
Huppy's Avatar
Huppy
Demi-God
 
Join Date: Oct 2010
Posts: 1,333
Default

Quote:
Originally Posted by Splose View Post
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
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 07:22 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3