Silk Scrolls (New Release)

[Zidane*]

Hello Elitepvpers peoples

*After Finished the working in this scrolls iam now happy to introduce it for you i made different amounts of silk for each scroll.

*I Added New Icons - Effects - Text For All Scrolls.

*Fixed All Procedures Crashes/DC Problems.

*Amounts For Scrolls (2000-1000-500-100-50-20).

*Check Screenshots to know more about scrolls.

Some Screens for scrolls:








if you have been notified click thanks

*

[EdwardTeach+-]

that released tons of times before,
what kind of hard working your talking about?
IF Operation=## AND RefItemID =##
BEGIN
UPDATE SK_SILK SET SILK_OWN = ### WHERE JID = @DeclareThing
END
?

[Zidane*]

Originally Posted by EdwardTeach+-

that released tons of times before,
what kind of hard working your talking about?
IF Operation=## AND RefItemID =##
BEGIN
UPDATE SK_SILK SET SILK_OWN = ### WHERE JID = @DeclareThing
END
?

I Created icon and added it + I make new 5 scrolls
ithink that's not easy ^^ and if it easy for u not easy for me

[abdoelking77]

for screens

Originally Posted by Zidane*

Hello Elitepvpers peoples

*After hard working in this scrolls ialready finished it with out any problems-bugs-crash and iam happy to introduce it for you right now..

*Any problem while adding it to your server please leave a comment with your problem.

Some Screens for scrolls:

(2000-20-1000-500-100-50) That's amount of 6 scrolls.

if you have been notified click thanks

*

[alicanla]

Thank you for sharing

[eiron2010]

problem



I want the right place to add scrolls please

[NagySandor96]

Originally Posted by eiron2010

problem



I want the right place to add scrolls please

LOG db, my lord

[eiron2010]

Originally Posted by NagySandor96

LOG db, my lord

i know my lord

this copy and paste

/* 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

in _AddLogItem = this problem
can help me for edit this pros

[eiron2010]

guys any help for this scroll

[EpicKyrex]

This scroll has been released before it has almost the same prodecures , thanks anyway.

[Bocc1337]

Originally Posted by eiron2010

problem



I want the right place to add scrolls please

Take out the @CharName you already have it Declared

[samuray3639]

ekledim ama silk gelmiyor neden acaba

[Dex*]

Thanks

[ThomasF2007]

Hello. I did everything. Scrolling works too. Unfortunately, I do not get the Silk written well. can someone help me?

addlogitem in shard DB or in Log DB ?

[Worshiper]

Originally Posted by ThomasF2007

Hello. I did everything. Scrolling works too. Unfortunately, I do not get the Silk written well. can someone help me?

addlogitem in shard DB or in Log DB ?

Shard log