Item ID Limit on Client Side?

[Hadeszeus 15]

I have problem related to ITEM ID LIMIT ON CLIENT SIDE. Originally item id limit is only 32k+ but following some guide here i was able to increase item id to 70k+ on SERVER SIDE. But when I add any item above 32k (for example 33000 id). 

 

I can generate @item 33000 in game. I can see the sprite completely client didn't crash or whatsoever.

 

However, once I relog in. That Item 33000 is gone.

 

How to resolve this?

 

 

[Angelmelody 221]

read this thread

http://herc.ws/board/topic/5261-itemdb-can-support-items-with-32k-id/

[Hadeszeus 15]

read this thread

http://herc.ws/board/topic/5261-itemdb-can-support-items-with-32k-id/

 

I follow everthing on this patch https://github.com/ragnaBR/Hercules/commit/c7a9ce03fddef370bec96f9d137051a4932ae00c

 

But still my items starting 33100 are gone once I relogin, it is weird since the item id are recorded in database.

Do you think it is a client side issue?

Edited August 16, 2014 by Hadeszeus

[Angelmelody 221]

It's not client side issue but src var type , why?  rathena already  implemented increasing item id to 65535

 

maybe #23 in that thread can fix  your problem 

[Dastgir 1246]

65535 is maximum limit clientside.

if the items are disappearing, then I guess you havent done sql updates(the alter table)

[Hadeszeus 15]

It's not client side issue but src var type , why?  rathena already  implemented increasing item id to 65535

 

maybe #23 in that thread can fix  your problem 

First of all Thank you so much! That missing part at #23 thread you posted solved the problem. However, I got this new problem huhuhu /sob

I @item 38000 then drop this item and pick it up relogin and BOOM duplicate items. When you loop  you will get so much of that item.

You know how to fix this? 

 

I USED THIS PATCH https://github.com/ragnaBR/Hercules/commit/c7a9ce03fddef370bec96f9d137051a4932ae00c

THEN ADD YOUR NUMBER #23 PATCH (http://herc.ws/board/topic/5261-itemdb-can-support-items-with-32k-id/)

 

THIS IS MY SETTING

 

#define MAX_ITEMDB 0x10000 // 65K array entries in array (the rest goes to the db)

//If you define MAX_ITEMDB over 65k arrays entries (item ids), you have to define the flag bellow AND apply the sql patch patch_itemdb_over65k.sql located insed of sql forlder to your database.

//#define ITEMDB_OVER65K

 

MY SQL UPDATE

 

#

# Upgrade to increase the number of item ids to 64K

# By Frey/Gustavo Brigo

#

ALTER TABLE `auction` MODIFY `card0` mediumint(11) NOT NULL default '0';

ALTER TABLE `auction` MODIFY `card1` mediumint(11) NOT NULL default '0';

ALTER TABLE `auction` MODIFY `card2` mediumint(11) NOT NULL default '0';

ALTER TABLE `auction` MODIFY `card3` mediumint(11) NOT NULL default '0';

ALTER TABLE `cart_inventory` MODIFY `card0` mediumint(11) NOT NULL default '0';

ALTER TABLE `cart_inventory` MODIFY `card1` mediumint(11) NOT NULL default '0';

ALTER TABLE `cart_inventory` MODIFY `card2` mediumint(11) NOT NULL default '0';

ALTER TABLE `cart_inventory` MODIFY `card3` mediumint(11) NOT NULL default '0';

ALTER TABLE `guild_storage` MODIFY `card0` mediumint(11) NOT NULL default '0';

ALTER TABLE `guild_storage` MODIFY `card1` mediumint(11) NOT NULL default '0';

ALTER TABLE `guild_storage` MODIFY `card2` mediumint(11) NOT NULL default '0';

ALTER TABLE `guild_storage` MODIFY `card3` mediumint(11) NOT NULL default '0';

ALTER TABLE `inventory` MODIFY `card0` mediumint(11) NOT NULL default '0';

ALTER TABLE `inventory` MODIFY `card1` mediumint(11) NOT NULL default '0';

ALTER TABLE `inventory` MODIFY `card2` mediumint(11) NOT NULL default '0';

ALTER TABLE `inventory` MODIFY `card3` mediumint(11) NOT NULL default '0';

ALTER TABLE `storage` MODIFY `card0` mediumint(11) NOT NULL default '0';

ALTER TABLE `storage` MODIFY `card1` mediumint(11) NOT NULL default '0';

ALTER TABLE `storage` MODIFY `card2` mediumint(11) NOT NULL default '0';

ALTER TABLE `storage` MODIFY `card3` mediumint(11) NOT NULL default '0';

ALTER TABLE `mail` MODIFY `card0` mediumint(11) NOT NULL default '0';

ALTER TABLE `mail` MODIFY `card1` mediumint(11) NOT NULL default '0';

ALTER TABLE `mail` MODIFY `card2` mediumint(11) NOT NULL default '0';

ALTER TABLE `mail` MODIFY `card3` mediumint(11) NOT NULL default '0';

ALTER TABLE `mob_db` MODIFY `MVP1id` mediumint(9) unsigned NOT NULL default '0';

ALTER TABLE `mob_db` MODIFY `MVP1per` mediumint(9) unsigned NOT NULL default '0';

ALTER TABLE `mob_db` MODIFY `MVP2id` mediumint(9) unsigned NOT NULL default '0';

ALTER TABLE `mob_db` MODIFY `MVP2per` mediumint(9) unsigned NOT NULL default '0';

ALTER TABLE `mob_db` MODIFY `MVP3id` mediumint(9) unsigned NOT NULL default '0';

ALTER TABLE `mob_db` MODIFY `MVP3per` mediumint(9) unsigned NOT NULL default '0';

ALTER TABLE `mob_db` MODIFY `Drop1id` mediumint(9) unsigned NOT NULL default '0';

ALTER TABLE `mob_db` MODIFY `Drop1per` mediumint(9) unsigned NOT NULL default '0';

ALTER TABLE `mob_db` MODIFY `Drop2id` mediumint(9) unsigned NOT NULL default '0';

ALTER TABLE `mob_db` MODIFY `Drop2per` mediumint(9) unsigned NOT NULL default '0';

ALTER TABLE `mob_db` MODIFY `Drop3id` mediumint(9) unsigned NOT NULL default '0';

ALTER TABLE `mob_db` MODIFY `Drop3per` mediumint(9) unsigned NOT NULL default '0';

ALTER TABLE `mob_db` MODIFY `Drop4id` mediumint(9) unsigned NOT NULL default '0';

ALTER TABLE `mob_db` MODIFY `Drop4per` mediumint(9) unsigned NOT NULL default '0';

ALTER TABLE `mob_db` MODIFY `Drop5id` mediumint(9) unsigned NOT NULL default '0';

ALTER TABLE `mob_db` MODIFY `Drop5per` mediumint(9) unsigned NOT NULL default '0';

ALTER TABLE `mob_db` MODIFY `Drop6id` mediumint(9) unsigned NOT NULL default '0';

ALTER TABLE `mob_db` MODIFY `Drop6per` mediumint(9) unsigned NOT NULL default '0';

ALTER TABLE `mob_db` MODIFY `Drop7id` mediumint(9) unsigned NOT NULL default '0';

ALTER TABLE `mob_db` MODIFY `Drop7per` mediumint(9) unsigned NOT NULL default '0';

ALTER TABLE `mob_db` MODIFY `Drop8id` mediumint(9) unsigned NOT NULL default '0';

ALTER TABLE `mob_db` MODIFY `Drop8per` mediumint(9) unsigned NOT NULL default '0';

ALTER TABLE `mob_db` MODIFY `Drop9id` mediumint(9) unsigned NOT NULL default '0';

ALTER TABLE `mob_db` MODIFY `Drop9per` mediumint(9) unsigned NOT NULL default '0';

ALTER TABLE `mob_db` MODIFY `DropCardid` mediumint(9) unsigned NOT NULL default '0';

ALTER TABLE `mob_db` MODIFY `DropCardper` mediumint(9) unsigned NOT NULL default '0';

ALTER TABLE `mob_db2` MODIFY `MVP1id` mediumint(9) unsigned NOT NULL default '0';

ALTER TABLE `mob_db2` MODIFY `MVP1per` mediumint(9) unsigned NOT NULL default '0';

ALTER TABLE `mob_db2` MODIFY `MVP2id` mediumint(9) unsigned NOT NULL default '0';

ALTER TABLE `mob_db2` MODIFY `MVP2per` mediumint(9) unsigned NOT NULL default '0';

ALTER TABLE `mob_db2` MODIFY `MVP3id` mediumint(9) unsigned NOT NULL default '0';

ALTER TABLE `mob_db2` MODIFY `MVP3per` mediumint(9) unsigned NOT NULL default '0';

ALTER TABLE `mob_db2` MODIFY `Drop1id` mediumint(9) unsigned NOT NULL default '0';

ALTER TABLE `mob_db2` MODIFY `Drop1per` mediumint(9) unsigned NOT NULL default '0';

ALTER TABLE `mob_db2` MODIFY `Drop2id` mediumint(9) unsigned NOT NULL default '0';

ALTER TABLE `mob_db2` MODIFY `Drop2per` mediumint(9) unsigned NOT NULL default '0';

ALTER TABLE `mob_db2` MODIFY `Drop3id` mediumint(9) unsigned NOT NULL default '0';

ALTER TABLE `mob_db2` MODIFY `Drop3per` mediumint(9) unsigned NOT NULL default '0';

ALTER TABLE `mob_db2` MODIFY `Drop4id` mediumint(9) unsigned NOT NULL default '0';

ALTER TABLE `mob_db2` MODIFY `Drop4per` mediumint(9) unsigned NOT NULL default '0';

ALTER TABLE `mob_db2` MODIFY `Drop5id` mediumint(9) unsigned NOT NULL default '0';

ALTER TABLE `mob_db2` MODIFY `Drop5per` mediumint(9) unsigned NOT NULL default '0';

ALTER TABLE `mob_db2` MODIFY `Drop6id` mediumint(9) unsigned NOT NULL default '0';

ALTER TABLE `mob_db2` MODIFY `Drop6per` mediumint(9) unsigned NOT NULL default '0';

ALTER TABLE `mob_db2` MODIFY `Drop7id` mediumint(9) unsigned NOT NULL default '0';

ALTER TABLE `mob_db2` MODIFY `Drop7per` mediumint(9) unsigned NOT NULL default '0';

ALTER TABLE `mob_db2` MODIFY `Drop8id` mediumint(9) unsigned NOT NULL default '0';

ALTER TABLE `mob_db2` MODIFY `Drop8per` mediumint(9) unsigned NOT NULL default '0';

ALTER TABLE `mob_db2` MODIFY `Drop9id` mediumint(9) unsigned NOT NULL default '0';

ALTER TABLE `mob_db2` MODIFY `Drop9per` mediumint(9) unsigned NOT NULL default '0';

ALTER TABLE `mob_db2` MODIFY `DropCardid` mediumint(9) unsigned NOT NULL default '0';

ALTER TABLE `mob_db2` MODIFY `DropCardper` mediumint(9) unsigned NOT NULL default '0';