Quote:
Originally Posted by vicksel
Yes, thank you I figure it out some minutes later
Do you have any idea why I edited my silk ammount in the database but I don't see it reflected on the game?
Also you have any idea how to make work Web Item Mall.
Reegards
|
Use this for the silk:
USE SRO_VT_SHARD-- Use SHARD database
DECLARE @CharName16 varchar(64)
DECLARE @UserID INT
DECLARE @silk int
SET @silk = '9999' --Silk Here
SET @CharName16 = 'Zed*' --CharName here
SET @UserID = (select UserJID from _User where CharID = (SELECT CharID FROM _Char where CharName16 = @CharName16))
UPDATE SRO_VT_ACCOUNT.dbo.SK_Silk set silk_own = silk_own + @silk where JID = @UserID
i will check the web item mall asap