ممكن حد يعدل query دة

[احمد الفقى]

if(@JobID = '59707') -- Silk scroll
begin
update SRO_VT_ACCOUNT..SK_Silk
set silk_gift = silk_gift +'400'
where JID = (select UserJID from _User where CharID = @CharID)
insert into SRO_VT_LEGENDKNIGHT.dbo.LK_Logger (CharName,[Char Id],Date,[What Does])
Values (@CharName16,@CharID,Getdate(),'This Char :- ''['+@cnam2e16+']'+' Has Used a Silk Scroll [ 150 silk ]')
insert into SRO_VT_LOG..PlusNotice values (0,'['+@CharName16+']'+'Has Used a Silk Scroll [ 150 silk ]',getdate())
END

ممكن حد يعدل query دة من سيلك الى coin

[احمد الفقى]

UP:mf_plasmawhore::mf_plasmawhore:

[Dev.Ri3o]

هات اى Query بيعمل EXchange وخلي يشتغل Scroll