VSro Stackable Limit ?

flatro22 · 11/27/2011, 01:40

I making this thread to ask you guys , how i can make stackable items and vsro? I was searching too long so i asking...

emptyz · 11/27/2011, 03:02

32767, I guess, but may not be true, test it out to be sure :P

flatro22 · 11/27/2011, 14:46

Wher i must change and wher?

flatro22 · 11/28/2011, 20:29

bump

flatro22 · 12/01/2011, 15:45

bump

IceAmStiel · 12/05/2011, 22:07

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 ###!

flatro22 · 12/06/2011, 19:24

Big thanks!

benossa · 01/13/2012, 17:56

Quote:

Originally Posted by IceAmStiel

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 ?

IceAmStiel · 01/14/2012, 09:39

Quote:

Originally Posted by benossa

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.

qalli · 03/29/2012, 02:40

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

H34D_B4NG3R · 03/29/2012, 03:04

here is a good tut

~~1337Demon~~ · 02/02/2013, 00:58

IceAmStiel
How to add vigor in npc please i need help !