When I run the following query, update the item text file, updated in Media.pk. Any help is much appreciated.
Summary of Issue:
- I cannot purchase 5000 of the pet potion. I can only purchase 50, but it is stackable.
- System auto split the stacks to 50 if I teleport.
Steps I took to increase stacks:
1.
Run this query in SQL:
UPDATE dbo._RefObjItem
SET MaxStack = 5000
WHERE ID BETWEEN 2143 AND 2146
2.
Update itemdata_5000.txt stackable to 5000
[Pet Potions Set 1 CodeName]
ITEM_ETC_COS_HP_POTION_01
ITEM_ETC_COS_HP_POTION_02
ITEM_ETC_COS_RES_POTION_01
ITEM_ETC_COS_RES_POTION_02
3. Restart SQL Server
4. Upload the itemdata_5000.txt to the media.pk then test the client.
Summary of Issue:
- I cannot purchase 5000 of the pet potion. I can only purchase 50, but it is stackable.
- System auto split the stacks to 50 if I teleport.
Steps I took to increase stacks:
1.
Run this query in SQL:
UPDATE dbo._RefObjItem
SET MaxStack = 5000
WHERE ID BETWEEN 2143 AND 2146
2.
Update itemdata_5000.txt stackable to 5000
[Pet Potions Set 1 CodeName]
ITEM_ETC_COS_HP_POTION_01
ITEM_ETC_COS_HP_POTION_02
ITEM_ETC_COS_RES_POTION_01
ITEM_ETC_COS_RES_POTION_02
3. Restart SQL Server
4. Upload the itemdata_5000.txt to the media.pk then test the client.