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+'"'+'.'
Change the following two variables as you like in the query (Spawncode = Itemcode)
@NEWMaxStack
@SpawnCodeID
[VSRO] Item Mall (Avatar) 05/27/2013 - SRO Private Server - 15 Replies Hey guys,
i tried to add all avatar in the Item Mall, i found a Guide which said i must change in refpackageitem the saletag to 0 in the media.pk2 and in SRO_VT_SHARD so no problem i changed it without any problems.
So when i login and open the Item Mall and click on Dresses i only see this:
http://img80.imageshack.us/img80/3491/sro20120122 01551647.jpg
in Hat is nothing
there must be Dresses and Attachment too or?
what is wrong?
vsro exp, gold,item rate 03/12/2012 - SRO Private Server - 2 Replies how can i setup this rates?
and can me anyone a link to cracked gameserver.exe
[vSRO] Item Mall 10/09/2011 - SRO Private Server - 5 Replies How can I change the price of the items of item mall in media.pk2?
VSRO SERVER ITEM BUG FIX 10/04/2011 - SRO Private Server - 3 Replies http://i52.tinypic.com/wu2kc6.jpg
1. _STRG_DEL_ITEM_NoTX delete
2. SRO_VT_SHARD New Query
USE
GO
/****** Object: StoredProcedure . Script Date: 09/24/2011 16:29:12 ******/
[How To Fix ?] Vsro Item Bug ( NO ONE WILL HELP? ) 09/23/2011 - SRO Private Server - 5 Replies I have Item Bug .
http://i1131.photobucket.com/albums/m554/olumculn uke/item-1.png
My Billing Server Good Work :D
SS ;
http://i1131.photobucket.com/albums/m554/olumculn uke/billing.png