مشكله في Silk Scroll

[F77]

دلوقت انا عندي مشكله في سيلك اسكرول

دلوقت البروسيدر ده لما بضيفه في الداتا بيس لوحده كده بيشتغل والسكرول بتضرب

IF @Operation = 41
BEGIN
IF @ItemRefID = 8000154
BEGIN
declare @JID int,
@Silk int

Select @Silk = 100
Select @JID = UserJID from SRO_VT_SHARD.._User where CharID = @CharID

IF EXISTS (Select * from SRO_VT_ACCOUNT..SK_Silk where JID = @JID)
UPDATE SRO_VT_ACCOUNT..SK_Silk set silk_own = silk_own + @Silk where JID = @JID
ELSE
INSERT INTO SRO_VT_ACCOUNT..SK_Silk
SELECT @JID,100,0,0
END
END


اجي بعد كده اضيف باقي البروسيدر يجيب كلام احمر اللي في الداتا ومش عايز يتضاف كله مع بعضه انا مش عارف المشكله من ايه مع ان اول واحده شغاله وده البروسيدر كله

IF @Operation = 41
BEGIN
IF @ItemRefID = 8000152
BEGIN
declare @JID int,
@Silk int

Select @Silk = 20
Select @JID = UserJID from SRO_VT_SHARD.._User where CharID = @CharID

IF EXISTS (Select * from SRO_VT_ACCOUNT..SK_Silk where JID = @JID)
UPDATE SRO_VT_ACCOUNT..SK_Silk set silk_own = silk_own + @Silk where JID = @JID
ELSE
INSERT INTO SRO_VT_ACCOUNT..SK_Silk
SELECT @JID,20,0,0
END
END

IF @Operation = 41
BEGIN
IF @ItemRefID = 8000153
BEGIN
declare @JID int,
@Silk int

Select @Silk = 50
Select @JID = UserJID from SRO_VT_SHARD.._User where CharID = @CharID

IF EXISTS (Select * from SRO_VT_ACCOUNT..SK_Silk where JID = @JID)
UPDATE SRO_VT_ACCOUNT..SK_Silk set silk_own = silk_own + @Silk where JID = @JID
ELSE
INSERT INTO SRO_VT_ACCOUNT..SK_Silk
SELECT @JID,50,0,0
END
END

IF @Operation = 41
BEGIN
IF @ItemRefID = 8000154
BEGIN
declare @JID int,
@Silk int

Select @Silk = 100
Select @JID = UserJID from SRO_VT_SHARD.._User where CharID = @CharID

IF EXISTS (Select * from SRO_VT_ACCOUNT..SK_Silk where JID = @JID)
UPDATE SRO_VT_ACCOUNT..SK_Silk set silk_own = silk_own + @Silk where JID = @JID
ELSE
INSERT INTO SRO_VT_ACCOUNT..SK_Silk
SELECT @JID,100,0,0
END
END

IF @Operation = 41
BEGIN
IF @ItemRefID = 8000155
BEGIN
declare @JID int,
@Silk int

Select @Silk = 500
Select @JID = UserJID from SRO_VT_SHARD.._User where CharID = @CharID

IF EXISTS (Select * from SRO_VT_ACCOUNT..SK_Silk where JID = @JID)
UPDATE SRO_VT_ACCOUNT..SK_Silk set silk_own = silk_own + @Silk where JID = @JID
ELSE
INSERT INTO SRO_VT_ACCOUNT..SK_Silk
SELECT @JID,500,0,0
END
END

IF @Operation = 41
BEGIN
IF @ItemRefID = 8000156
BEGIN
declare @JID int,
@Silk int

Select @Silk = 1000
Select @JID = UserJID from SRO_VT_SHARD.._User where CharID = @CharID

IF EXISTS (Select * from SRO_VT_ACCOUNT..SK_Silk where JID = @JID)
UPDATE SRO_VT_ACCOUNT..SK_Silk set silk_own = silk_own + @Silk where JID = @JID
ELSE
INSERT INTO SRO_VT_ACCOUNT..SK_Silk
SELECT @JID,1000,0,0
END
END

IF @Operation = 41
BEGIN
IF @ItemRefID = 8000157
BEGIN
declare @JID int,
@Silk int

Select @Silk = 2000
Select @JID = UserJID from SRO_VT_SHARD.._User where CharID = @CharID

IF EXISTS (Select * from SRO_VT_ACCOUNT..SK_Silk where JID = @JID)
UPDATE SRO_VT_ACCOUNT..SK_Silk set silk_own = silk_own + @Silk where JID = @JID
ELSE
INSERT INTO SRO_VT_ACCOUNT..SK_Silk
SELECT @JID,2000,0,0
END
END

[mina thabit]

AddLogItem
DECLARE @CharName VARCHAR(56)
declare @USERID_1 varchar(64);
declare @USERID_2 varchar(64);
IF @Operation = '41'
BEGIN
IF @ItemRefID = '42001' -- Silk (100)
BEGIN
SET @USERID_1 = (Select StrUserID from SRO_VT_ACCOUNT.dbo.TB_User inner join SRO_VT_SHARD.dbo._User
On SRO_VT_SHARD.dbo._User.UserJID = SRO_VT_ACCOUNT.dbo.TB_User.JID where SRO_VT_SHARD.dbo._User.CharID = @Charid)
EXEC [SRO_VT_ACCOUNT].[CGI].[CGI_WebPurchaseSilk] @OrderID = NULL, @UserID = @USERID_1, @PkgID = NULL, @NumSilk = 100, @Price = 100
END


give 100 silk
you need chage 100 silk for

[F77]

طيب بص كده ده البروسيدر الاصلي بتاع الاسكرول
بس انا بالطريقه دي مش عارف بيضاف ازي

/* Silk Scrolls SEction 2 */
DECLARE @CharName VARCHAR(56)
declare @USERID_1 varchar(64);
declare @USERID_2 varchar(64);
IF @Operation = '41'
BEGIN
IF @ItemRefID = '8000154' -- Silk (100)
BEGIN
SET @USERID_1 = (Select StrUserID from SRO_VT_ACCOUNT.dbo.TB_User inner join SRO_VT_SHARD.dbo._User
On SRO_VT_SHARD.dbo._User.UserJID = SRO_VT_ACCOUNT.dbo.TB_User.JID where SRO_VT_SHARD.dbo._User.CharID = @Charid)
--1--
EXEC [SRO_VT_ACCOUNT].[CGI].[CGI_WebPurchaseSilk] @OrderID = NULL, @UserID = @USERID_1, @PkgID = NULL, @NumSilk = 100, @Price = 100
END


ELSE IF @ItemRefID = '8000157' -- Silk (2000)
BEGIN
SET @USERID_2 = (Select StrUserID from SRO_VT_ACCOUNT.dbo.TB_User inner join SRO_VT_SHARD.dbo._User
On SRO_VT_SHARD.dbo._User.UserJID = SRO_VT_ACCOUNT.dbo.TB_User.JID where SRO_VT_SHARD.dbo._User.CharID = @Charid)
--1--
EXEC [SRO_VT_ACCOUNT].[CGI].[CGI_WebPurchaseSilk] @OrderID = NULL, @UserID = @USERID_2, @PkgID = NULL, @NumSilk = 2000, @Price = 2000
END
END

DECLARE @CharName1 VARCHAR(56)
declare @USERID_3 varchar(64);
declare @USERID_4 varchar(64);
IF @Operation = '41'
BEGIN
IF @ItemRefID = '8000155' -- Silk (500)
BEGIN
SET @USERID_3 = (Select StrUserID from SRO_VT_ACCOUNT.dbo.TB_User inner join SRO_VT_SHARD.dbo._User
On SRO_VT_SHARD.dbo._User.UserJID = SRO_VT_ACCOUNT.dbo.TB_User.JID where SRO_VT_SHARD.dbo._User.CharID = @Charid)
--1--
EXEC [SRO_VT_ACCOUNT].[CGI].[CGI_WebPurchaseSilk] @OrderID = NULL, @UserID = @USERID_3, @PkgID = NULL, @NumSilk = 500, @Price = 500
END


ELSE IF @ItemRefID = '8000153' -- Silk (50)
BEGIN
SET @USERID_4 = (Select StrUserID from SRO_VT_ACCOUNT.dbo.TB_User inner join SRO_VT_SHARD.dbo._User
On SRO_VT_SHARD.dbo._User.UserJID = SRO_VT_ACCOUNT.dbo.TB_User.JID where SRO_VT_SHARD.dbo._User.CharID = @Charid)
--1--
EXEC [SRO_VT_ACCOUNT].[CGI].[CGI_WebPurchaseSilk] @OrderID = NULL, @UserID = @USERID_4, @PkgID = NULL, @NumSilk = 50, @Price = 50
END
END

DECLARE @CharName2 VARCHAR(56)
declare @USERID_5 varchar(64);

IF @Operation = '41'
BEGIN
IF @ItemRefID = '8000152' -- Silk (20)
BEGIN
SET @USERID_5 = (Select StrUserID from SRO_VT_ACCOUNT.dbo.TB_User inner join SRO_VT_SHARD.dbo._User
On SRO_VT_SHARD.dbo._User.UserJID = SRO_VT_ACCOUNT.dbo.TB_User.JID where SRO_VT_SHARD.dbo._User.CharID = @Charid)
--1--
EXEC [SRO_VT_ACCOUNT].[CGI].[CGI_WebPurchaseSilk] @OrderID = NULL, @UserID = @USERID_5, @PkgID = NULL, @NumSilk = 20, @Price = 20
END

DECLARE @CharName3 VARCHAR(56)
declare @USERID_6 varchar(64);

IF @Operation = '41'
BEGIN
IF @ItemRefID = '8000156' -- Silk (1000)
BEGIN
SET @USERID_6 = (Select StrUserID from SRO_VT_ACCOUNT.dbo.TB_User inner join SRO_VT_SHARD.dbo._User
On SRO_VT_SHARD.dbo._User.UserJID = SRO_VT_ACCOUNT.dbo.TB_User.JID where SRO_VT_SHARD.dbo._User.CharID = @Charid)
--1--
EXEC [SRO_VT_ACCOUNT].[CGI].[CGI_WebPurchaseSilk] @OrderID = NULL, @UserID = @USERID_6, @PkgID = NULL, @NumSilk = 1000, @Price = 1000
END

/* Silk Scrolls SEction 2 */
END
END

[mina thabit]

انت عايز كام scroll silk

[F77]

هما 6
واحده
20
50
100
500
1000
2000
واي دي الاسكرول اللي مكتتوبه دي

[mina thabit]

بص ابعت ادد و ادخل عملها تيم فيور
fb.com/menazoom