[HIDE]
[/HIDE]
SQL:
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 */