vSRO change stackable limit problem

[SpY_16]

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.

[IceAmStiel]

Did you add the new itemdata.txt also to the smc folder?

DB + SMC + PK2 equal = shud work properly

[benossa]

how can I do same for stones ? in wich itemdata are they and what is name ?

[IceAmStiel]

I truly recommend against a Stone Stack, cause there are some bugs which will occur - High% Stones can be easily turned into 0% ones w/o any efforts

anyway..(of D11, ..._12 for D12 e.g.)

//Alchemy, Magic Stones
ITEM_ETC_ARCHEMY_MAGICSTONE_STR_11 //STR D11
ITEM_ETC_ARCHEMY_MAGICSTONE_INT_11 //INT
ITEM_ETC_ARCHEMY_MAGICSTONE_DUR_11 //Master
ITEM_ETC_ARCHEMY_MAGICSTONE_HR_11 //Strikes
ITEM_ETC_ARCHEMY_MAGICSTONE_EVADE_BLOCK_11 //Discipline
ITEM_ETC_ARCHEMY_MAGICSTONE_EVADE_CRITICAL_11 //Penetration
ITEM_ETC_ARCHEMY_MAGICSTONE_ER_11 //Dodging
ITEM_ETC_ARCHEMY_MAGICSTONE_HP_11 //Stamina
ITEM_ETC_ARCHEMY_MAGICSTONE_MP_11 //Magic
ITEM_ETC_ARCHEMY_MAGICSTONE_FROSTBITE_11 //Fogs
ITEM_ETC_ARCHEMY_MAGICSTONE_ESHOCK_11 //Air
ITEM_ETC_ARCHEMY_MAGICSTONE_BURN_11 //Fire
ITEM_ETC_ARCHEMY_MAGICSTONE_POISON_11 //Immunity
ITEM_ETC_ARCHEMY_MAGICSTONE_ZOMBIE_11 //Revival
ITEM_ETC_ARCHEMY_MAGICSTONE_SOLID_11 //Steady
ITEM_ETC_ARCHEMY_MAGICSTONE_LUCK_11 //Luck
ITEM_ETC_ARCHEMY_MAGICSTONE_ASTRAL_11 //Astral
ITEM_ETC_ARCHEMY_MAGICSTONE_ATHANASIA_11 //Immortal
ITEM_ETC_ARCHEMY_MAGICSTONE_APE_11 //Assimilation Prevention

//Alchemy, Attribute Stones
ITEM_ETC_ARCHEMY_ATTRSTONE_PA_11 //Courage D11
ITEM_ETC_ARCHEMY_ATTRSTONE_PASTR_11 //Warriors
ITEM_ETC_ARCHEMY_ATTRSTONE_MA_11 //Philosophy
ITEM_ETC_ARCHEMY_ATTRSTONE_MAINT_11 //Meditation
ITEM_ETC_ARCHEMY_ATTRSTONE_CRITICAL_11 //Challenge
ITEM_ETC_ARCHEMY_ATTRSTONE_HR_11 //Focus
ITEM_ETC_ARCHEMY_ATTRSTONE_PD_11 //Flesh
ITEM_ETC_ARCHEMY_ATTRSTONE_PDSTR_11 //Life
ITEM_ETC_ARCHEMY_ATTRSTONE_MD_11 //Mind
ITEM_ETC_ARCHEMY_ATTRSTONE_MDINT_11 //Spirit
ITEM_ETC_ARCHEMY_ATTRSTONE_ER_11 //Dodging
ITEM_ETC_ARCHEMY_ATTRSTONE_BR_11 //Agility
ITEM_ETC_ARCHEMY_ATTRSTONE_PAR_11 //Training
ITEM_ETC_ARCHEMY_ATTRSTONE_MAR_11 //Prayer

EDIT: Have also a look at this thread:

[qalli]

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 */

[gman2233]

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

[HardGroove]

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...)

[elionardo]

Hello, need backup help changed the max stack in db and itemdata_5000, priate will not log client opens, help me please.

[Kenai]

Originally Posted by HardGroove

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