VSro Stackable Limit ?

11/27/2011 01:40 flatro22#1
I making this thread to ask you guys , how i can make stackable items and vsro? I was searching too long so i asking...
11/27/2011 03:02 emptyz#2
32767, I guess, but may not be true, test it out to be sure :P
11/27/2011 14:46 flatro22#3
Wher i must change and wher?
11/28/2011 20:29 flatro22#4
bump
12/01/2011 15:45 flatro22#5
bump
12/05/2011 22:07 IceAmStiel#6
PHP Code:
USE SRO_VT_SHARD
Declare @NEWMaxStack int
Declare @ItemID int

--##########################
SET @NEWMaxStack = 75 /* e.g. for the new Stack */
SET @ItemID = '' -- ID from ItemData.txt e.g. SET @ItemID = '4'
--##########################

UPDATE dbo._RefObjItem
SET MaxStack = @NEWMaxStack
WHERE ID = (SELECT Link FROM _RefObjCommon WHERE ID like @ItemID) 
through a query.. and change it at the itemdata.txt files within the Media.pk2

Change only the values between the ###!
12/06/2011 19:24 flatro22#7
Big thanks!
01/13/2012 17:56 benossa#8
Quote:
Originally Posted by IceAmStiel View Post
PHP Code:
USE SRO_VT_SHARD
Declare @NEWMaxStack int
Declare @ItemID int

--##########################
SET @NEWMaxStack = 75 /* e.g. for the new Stack */
SET @ItemID = '' -- ID from ItemData.txt e.g. SET @ItemID = '4'
--##########################

UPDATE dbo._RefObjItem
SET MaxStack = @NEWMaxStack
WHERE ID = (SELECT Link FROM _RefObjCommon WHERE ID like @ItemID) 
through a query.. and change it at the itemdata.txt files within the Media.pk2

Change only the values between the ###!
how can I know what is ID for stones and elixires ?
01/14/2012 09:39 IceAmStiel#9
Quote:
Originally Posted by benossa View Post
how can I know what is ID for stones and elixires ?
The ID is written at the beginning of every line :) e.g.
ID 8 = ITEM_ETC_HP_POTION_05 @ itemdata5k

I actually had it at first with the Spawn Code, but removed it again - thought it's easier with ID's


EDIT:

Added it again..(fill either the ID or the spawncode in, only 1! Between the #'s)
PHP Code:
USE SRO_VT_SHARD
Declare @NEWMaxStack varchar(10)
Declare @ItemID int
Declare @oldStack varchar(10)
Declare @SpawnCodeID varchar(50)

/*##############################################################################*/

SET @NEWMaxStack = 75    /* e.g. stackable up to 75 */
SET @ItemID = ''            /* ID of the Item ofrom the itemdata.txt files */
SET @SpawnCodeID = 'ITEM_ETC_HP_POTION_01'

/*##############################################################################*/

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 */
print ''
print '@ Media\server_dep\silkroad\textdata\itemdata_'+@newItemID+'.txt'
print ''
print 'Change the line within the Itemdata.txt file like stated below:'
print ''
print 'Press CTRL+F and paste '+'"'+@CodeName+'"'+' into the box and search for the line at the file.'
print 'Scroll to the right till you reach '+'"'+@DDJ+'"'+' and change the value behind the 2x "xxx" from '+'"'+@oldStack+'"'+' to '+'"'+@NEWMaxStack+'"'+'.' 
+throws you at the Messsage window out where and what exactly you need to change.
03/29/2012 02:40 qalli#10
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 */
03/29/2012 03:04 H34D_B4NG3R#11
here is a good tut
[Only registered and activated users can see links. Click Here To Register...]
02/02/2013 00:58 1337Demon#12
IceAmStiel
How to add vigor in npc please i need help !