الموقع العربي الاول للعبة Silkroad Online

الموقع العربي الاول للعبة Silkroad Online (https://silkroad4arab.com/vb/index.php)
-   قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة (https://silkroad4arab.com/vb/forumdisplay.php?f=226)
-   -   مشكله في Silk Scroll (https://silkroad4arab.com/vb/showthread.php?t=618124)

F77 12-08-2017 02:41 PM
مشكله في Silk Scroll
 
دلوقت انا عندي مشكله في سيلك اسكرول

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

كود:
  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
رد: مشكله في Silk Scroll
 
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 Scroll
 
طيب بص كده ده البروسيدر الاصلي بتاع الاسكرول
بس انا بالطريقه دي مش عارف بيضاف ازي

كود:
/* 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
رد: مشكله في Silk Scroll
 
انت عايز كام scroll silk

F77 12-08-2017 03:20 PM
رد: مشكله في Silk Scroll
 
هما 6
واحده
20
50
100
500
1000
2000
واي دي الاسكرول اللي مكتتوبه دي

mina thabit 12-08-2017 03:29 PM
رد: مشكله في Silk Scroll
 
بص ابعت ادد و ادخل عملها تيم فيور
fb.com/menazoom


الساعة الآن 11:08 PM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions, Inc.