USE SRO_VT_ACCOUNT declare @BEBO1 int declare @BEBO2 int declare @BEBO3 int declare @BEBO7 varchar(12) set @BEBO7 = 'BEBO' -- Character Name set @BEBO1 = 00 -- silk gift set @BEBO2 = 100 -- silk own set @BEBO3 = 00 -- silk point update BEBO4 set silk_gift = silk_gift + @BEBO1, silk_own = silk_own + @BEBO2, silk_point = silk_point + @BEBO3 from SK_Silk BEBO4 inner join SRO_VT_SHARD.._User BEBO5 on BEBO4.JID = BEBO5.UserJID inner join SRO_VT_SHARD.._Char BEBO6 on BEBO5.CharID = BEBO6.CharID where CharName16 = @BEBO7
USE SRO_VT_SHARD declare @BEBO1 varchar(12) declare @BEBO2 int set @BEBO1 = 'BEBO' -- Character Name set @BEBO2 = 100 -- Skill Point update _Char set RemainSkillPoint = RemainSkillPoint + @BEBO2 where CharName16 = @BEBO1