• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

C++ items transform into another item after relog

Solution
For some reasons(probably backward compatibility?) the itemid are saved in signed short to database so the values get truncated to 2^15-1 instead of using the whole 2^16-1 value.
You can change how the database saving these values by typing this in mysql:
Code:
ALTER TABLE `player_depotitems` CHANGE `itemtype` `itemtype` smallint(6) unsigned NOT NULL;
ALTER TABLE `player_inboxitems` CHANGE `itemtype` `itemtype` smallint(6) unsigned NOT NULL;
ALTER TABLE `player_items` CHANGE `itemtype` `itemtype` smallint(6) unsigned NOT NULL;
that is because 32767 is the max items you can have, just dont create items after that id, or everything pickable you put after that id will turn into that 327676 id
 
For some reasons(probably backward compatibility?) the itemid are saved in signed short to database so the values get truncated to 2^15-1 instead of using the whole 2^16-1 value.
You can change how the database saving these values by typing this in mysql:
Code:
ALTER TABLE `player_depotitems` CHANGE `itemtype` `itemtype` smallint(6) unsigned NOT NULL;
ALTER TABLE `player_inboxitems` CHANGE `itemtype` `itemtype` smallint(6) unsigned NOT NULL;
ALTER TABLE `player_items` CHANGE `itemtype` `itemtype` smallint(6) unsigned NOT NULL;
 
Solution
Back
Top