الـجـروب الـرسـمى لـلـمـنـتـدى FaceBook | Official Group

**F77** · 12-08-2017, 02:41 PM

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

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

كود:

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** · 12-08-2017, 03:06 PM

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** · 12-08-2017, 03:17 PM

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

كود:

/* 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** · 12-08-2017, 03:19 PM

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

**F77** · 12-08-2017, 03:20 PM

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

**mina thabit** · 12-08-2017, 03:29 PM

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

يتصفح الموضوع حالياً : 1 (0 عضو و 1 زائر)

	حفظ بياناتي ؟

شـريـط الاهـداءات