hello, I have a problem with change stackable limit elixirs. When i change maxstackable in SRO_VT_SHARD -> dbo._RefObjItem to 50 and in Media like here:
in game when I stack elixir and teleport or logout, all elixirs change back stackable at 1.. please help, and sorry for my bad english.
USE SRO_VT_SHARD
Declare @NEWMaxStack varchar(10)
Declare @ItemID int
Declare @oldStack varchar(10)
Declare @SpawnCodeID varchar(50)
/*##############################################################################*/
SET @NEWMaxStack = 50
SET @SpawnCodeID = 'ITEM_ETC_ARCHEMY_MAGICSTONE_STR_12'
SET @SpawnCodeID = 'ITEM_ETC_ARCHEMY_MAGICSTONE_INT_12'
SET @SpawnCodeID = 'ITEM_ETC_ARCHEMY_MAGICSTONE_DUR_12'
SET @SpawnCodeID = 'ITEM_ETC_ARCHEMY_MAGICSTONE_HR_12'
SET @SpawnCodeID = 'ITEM_ETC_ARCHEMY_MAGICSTONE_EVADE_BLOCK_12'
SET @SpawnCodeID = 'ITEM_ETC_ARCHEMY_MAGICSTONE_EVADE_CRITICAL_12'
SET @SpawnCodeID = 'ITEM_ETC_ARCHEMY_MAGICSTONE_ER_12'
SET @SpawnCodeID = 'ITEM_ETC_ARCHEMY_MAGICSTONE_HP_12'
SET @SpawnCodeID = 'ITEM_ETC_ARCHEMY_MAGICSTONE_MP_12'
SET @SpawnCodeID = 'ITEM_ETC_ARCHEMY_MAGICSTONE_FROSTBITE_12'
SET @SpawnCodeID = 'ITEM_ETC_ARCHEMY_MAGICSTONE_ESHOCK_12'
SET @SpawnCodeID = 'ITEM_ETC_ARCHEMY_MAGICSTONE_BURN_12'
SET @SpawnCodeID = 'ITEM_ETC_ARCHEMY_MAGICSTONE_POISON_12'
SET @SpawnCodeID = 'ITEM_ETC_ARCHEMY_MAGICSTONE_ZOMBIE_12'
SET @SpawnCodeID = 'ITEM_ETC_ARCHEMY_MAGICSTONE_SOLID_12'
SET @SpawnCodeID = 'ITEM_ETC_ARCHEMY_MAGICSTONE_LUCK_12'
SET @SpawnCodeID = 'ITEM_ETC_ARCHEMY_MAGICSTONE_ASTRAL_12'
SET @SpawnCodeID = 'ITEM_ETC_ARCHEMY_MAGICSTONE_ATHANASIA_12'
SET @SpawnCodeID = 'ITEM_ETC_ARCHEMY_MAGICSTONE_APE_12'
SET @SpawnCodeID = 'ITEM_ETC_ARCHEMY_ATTRSTONE_PA_12'
SET @SpawnCodeID = 'ITEM_ETC_ARCHEMY_ATTRSTONE_PASTR_12'
SET @SpawnCodeID = 'ITEM_ETC_ARCHEMY_ATTRSTONE_MA_12'
SET @SpawnCodeID = 'ITEM_ETC_ARCHEMY_ATTRSTONE_MAINT_12'
SET @SpawnCodeID = 'ITEM_ETC_ARCHEMY_ATTRSTONE_CRITICAL_12'
SET @SpawnCodeID = 'ITEM_ETC_ARCHEMY_ATTRSTONE_HR_12'
SET @SpawnCodeID = 'ITEM_ETC_ARCHEMY_ATTRSTONE_PD_12'
SET @SpawnCodeID = 'ITEM_ETC_ARCHEMY_ATTRSTONE_PDSTR_12'
SET @SpawnCodeID = 'ITEM_ETC_ARCHEMY_ATTRSTONE_MD_12'
SET @SpawnCodeID = 'ITEM_ETC_ARCHEMY_ATTRSTONE_MDINT_12'
SET @SpawnCodeID = 'ITEM_ETC_ARCHEMY_ATTRSTONE_ER_12'
SET @SpawnCodeID = 'ITEM_ETC_ARCHEMY_ATTRSTONE_BR_12'
SET @SpawnCodeID = 'ITEM_ETC_ARCHEMY_ATTRSTONE_PAR_12'
SET @SpawnCodeID = 'ITEM_ETC_ARCHEMY_ATTRSTONE_MAR_12'
/*##############################################################################*/
SET @ItemID = (Select ID from _RefObjCommon WHERE CodeName128 like @SpawnCodeID)
SET @oldStack = (SELECT MaxStack FROM _RefObjItem WHERE ID like (SELECT Link FROM _RefObjCommon WHERE ID like @ItemID))
UPDATE dbo._RefObjItem SET MaxStack = @NEWMaxStack WHERE ID = (SELECT Link FROM _RefObjCommon WHERE ID like @ItemID)
/* Which Itemdata.txt is affected in the Media.pk2*/
Declare @newItemID varchar(5)
IF (@ItemID < 5000) SET @newItemID = 5000
else if (@ItemID < 10000) SET @newItemID = 10000
else if (@ItemID < 15000) SET @newItemID = 15000
else if (@ItemID < 20000) SET @newItemID = 20000
else if (@ItemID < 25000) SET @newItemID = 25000
else if (@ItemID < 30000) SET @newItemID = 30000
else if (@ItemID < 35000) SET @newItemID = 35000
else if (@ItemID < 40000) SET @newItemID = 40000
else if (@ItemID >= 40000) SET @newItemID = 45000
/*END which Itemdata.txr*/
Declare @CodeName varchar(74)
Declare @DDJ varchar(74)
SET @CodeName = (SELECT CodeName128 FROM _RefObjCommon WHERE ID like @ItemID)
SET @DDJ = (SELECT AssocFileIcon128 FROM _RefObjCommon WHERE ID like @ItemID)
/* Paths */
Hello everyone i have changed the max stack of elixirs (both a and b) to 100 in both the database and the media.pk2 although in game i can only see the amount of elixirs stacked by hovering my mouse over them and it will say in the quantity how many there are. How can i get the letter white number in the top left corner to show up
It works, but its a problem if you put these items (elixirs or stones) to npc... I set these items stack to 50.
Elixirs, can buy max 5 at once and they will split after u buy them, but its possible to put them in stack of 50! (it also crash the client if I try to buy it via CTRL). Works fine when fuse.
As for stones, can buy 1 only, event it allows me so set 50 (not possible for elixirs), it doesn't crash if I try to buy via CTRL, but it wont buy it, also it will goes back to its previous locations, after tp or relog... If trying to fuse, it uses all stones at once.
Any possible way to fix this?
Thanks.
EDIT: Ok, so I did mistake with stones, now stones works perfectly fine, I can buy stack of 50 via CTRL or any other number, it also keeps stack and position after re log or tp, and it works fine on fuse.
Still have problem with Elixirs (max buy 5, even stack set to 50, parameters are set good in db and media...)
It works, but its a problem if you put these items (elixirs or stones) to npc... I set these items stack to 50.
Elixirs, can buy max 5 at once and they will split after u buy them, but its possible to put them in stack of 50! (it also crash the client if I try to buy it via CTRL). Works fine when fuse.
As for stones, can buy 1 only, event it allows me so set 50 (not possible for elixirs), it doesn't crash if I try to buy via CTRL, but it wont buy it, also it will goes back to its previous locations, after tp or relog... If trying to fuse, it uses all stones at once.
Any possible way to fix this?
Thanks.
EDIT: Ok, so I did mistake with stones, now stones works perfectly fine, I can buy stack of 50 via CTRL or any other number, it also keeps stack and position after re log or tp, and it works fine on fuse.
Still have problem with Elixirs (max buy 5, even stack set to 50, parameters are set good in db and media...)
I know the topic is old as F but I've the same issue where I got a crash when buying stones with CTRL.
It buys only 5 stones (while stone stacks are 250) and crash + take money as if we bought 250 stones.
Any idea on how to fix it ? Either to remove the possibility to buy with CTRL OR enabling the buy for 250 at the time
VSro Stackable Limit ? 02/02/2013 - SRO Private Server - 11 Replies I making this thread to ask you guys , how i can make stackable items and vsro? I was searching too long so i asking...
[Tutorial]How to make any item stackable/change max stack 10/07/2009 - Dekaron Private Server - 8 Replies I have seen 4 threads asking about this now, so I decided to make a tutorial.
We will work with items in itemetc.csv here, but it works with any items.
Ok, so let's go data/share/item/itemetc.csv
Now, let's examine the columns.
Name Rank Type Code Attribute Description Quality Job Appraisal Value Weight ReqLv Price Width Heig ht StackNumber AutoStack StackDrop_Min StackDrop_M ax Has_Durability Can_Repair Durability_Low Durabi lity_Normal...
Ok, I think We know what we are looking for....
