• 0
ScriptingPhailure

Increasing max values allowed in itemdb

Question

Is there a way to increase the maximum allowed values for the item db? The cap seems to be at 32768.

 

If there is a way, is there some sort of drawback to doing so?

 

post-1911-0-21291100-1395609923_thumb.png

Share this post


Link to post
Share on other sites

8 answers to this question

  • 1

item_db.h

-#define MAX_ITEMDB 0x8000 // 32k array entries in array (the rest goes to the db)

+#define MAX_ITEMDB 0x10000 // 64k array entries in array (the rest goes to the db)

 

/src/common/mmo.h

- short nameid;

+ unsigned short nameid;

 

here i can use '@item 600001' to create item with id 60001

 

 

 

VDGft1.jpg

 

 

-----------------------------------------------------------------

and more adjust

mysql card0~ card3 field type change to int

 

and adjust bonus script param type

bonus2 bAddMonsterDropItem,n,x

bonus3 bAddMonsterDropItem,n,x,y;

Edited by Angelmelody

Share this post


Link to post
Share on other sites
  • 0

item_db.h

#define MAX_ITEMDB 0x8000 // 32k array entries in array (the rest goes to the db)

 

 

but for sure it is capped because of client limitation, same as MAX_ZENY etc etc

Share this post


Link to post
Share on other sites
  • 0

@@Angelmelody, I did as said on this post. I can see the item everything description but when equipped I can't see the view of the item o.O



I am getting this error, items really  dont save when char logs out but the view of them exists. The ones passed the max cap of 32768 or w/e it is. D:

 [SQL]: DB error - data of field 'nameid' was truncated.[Debug]: column - 1[Debug]: data   - type=UNSIGNED MYSQL_TYPE_LONG, length=2[Debug]: buffer - type=MYSQL_TYPE_SHORT, length=2[Info]: Saved char 150000 - Aeromesi: inventory status skills.

Share this post


Link to post
Share on other sites
  • 0

 

@@Angelmelody, I did as said on this post. I can see the item everything description but when equipped I can't see the view of the item o.O

I am getting this error, items really  dont save when char logs out but the view of them exists. The ones passed the max cap of 32768 or w/e it is. D:

 

 [SQL]: DB error - data of field 'nameid' was truncated.[Debug]: column - 1[Debug]: data   - type=UNSIGNED MYSQL_TYPE_LONG, length=2[Debug]: buffer - type=MYSQL_TYPE_SHORT, length=2[Info]: Saved char 150000 - Aeromesi: inventory status skills.

Apparently this feature is to be implented soon™.

Share this post


Link to post
Share on other sites
  • 0

 

@@Angelmelody, I did as said on this post. I can see the item everything description but when equipped I can't see the view of the item o.O

I am getting this error, items really  dont save when char logs out but the view of them exists. The ones passed the max cap of 32768 or w/e it is. D:

 

 [SQL]: DB error - data of field 'nameid' was truncated.[Debug]: column - 1[Debug]: data   - type=UNSIGNED MYSQL_TYPE_LONG, length=2[Debug]: buffer - type=MYSQL_TYPE_SHORT, length=2[Info]: Saved char 150000 - Aeromesi: inventory status skills.

 

here click me to solve that error when saving inventory data

Share this post


Link to post
Share on other sites
  • 0

sir, can you please elaborate what should i do how to enable 30k + item_db? im new here in hercules.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now