الـجـروب الـخـاص بـالـمـنـتـدي Silkroad4arab 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

المواضيع المتشابهه
الموضوع	كاتب الموضوع	المنتدى	الردود	آخر مشاركة
Silk Scroll Getting Silk Without teleport	Sa Vi	قسم الشروحات و البرامج المستخدمة في عمل السيرفرات الخاصة	3	05-12-2022 12:52 PM
مشكله في Scroll Reward scroll	ahmedmosaad	قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة	2	17-04-2019 01:16 AM
مشكله في Scroll Silk	saycobobs	قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة	2	04-06-2017 08:28 PM
silk scroll	Deba	قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة	11	10-12-2016 06:11 PM
silk scroll	Ahmed Seka	قسم المواضيع المكررة و المخالفة	16	27-08-2014 04:40 PM

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

	البقاء مسجل دائمآ