الموقع العربي الاول للعبة Silkroad Online

[FONT="Arial"][COLOR="Blue"][SIZE="4"]بالنسبه لليونيك ده معناه ان اليونيك مش فى السيرفر اساسا يعنى لازم تضيفه اولا
ولو انته متاكد انو موجود اتاكد من الاكواد اللى انته بتنزلو بيها

وده كويرى علشان Max Stack

كود:

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 @SpawnCodeID = 'ITEM_ETC_HP_POTION_01'    /* Has to be unique */



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



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+'"'+'.'

هتعدل على
@NEWMaxStack
@SpawnCodeID
وبس