vSRO change stackable limit problem

01/11/2012 16:45 SpY_16#1
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: [Only registered and activated users can see links. Click Here To Register...]


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.
01/12/2012 01:16 IceAmStiel#2
Did you add the new itemdata.txt also to the smc folder?

DB + SMC + PK2 equal = shud work properly
01/13/2012 18:06 benossa#3
how can I do same for stones ? in wich itemdata are they and what is name ?
01/14/2012 09:33 IceAmStiel#4
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.)
Quote:
//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: [Only registered and activated users can see links. Click Here To Register...]
03/29/2012 02:39 qalli#5
Code:
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 */
11/22/2012 14:26 gman2233#6
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
04/28/2014 00:20 HardGroove#7
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...)
06/11/2014 23:08 elionardo#8
Hello, need backup help changed the max stack in db and itemdata_5000, priate will not log client opens, help me please.
07/18/2020 12:48 Kenai#9
Quote:
Originally Posted by HardGroove View Post
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