...itemID varchar(64),
optLevel int
AS
BEGIN
/*
EXAMPLE CODE, FOR REWARD LEVEL RESTRICT
IF Cur_level < 100)
BEGIN
RETURN;
END
*/
DECLARE jid bigint = (SELECT JID FROM [SRO_VT_ACCOUNT].[dbo].[TB_User] WITH(NOLOCK) WHERE StrUserID = struserID);
IF NOT EXISTS(SELECT JID FROM [SRO_VT_ACCOUNT].[dbo].[SK_silk] W...
Silk Scrolls
When i me using that
IF (@Operation = 41 AND itemRefID = ID)
BEGIN
DECLARE jid int,
Silk int;
SET Silk = 5
SELECT jid = UserJID from SRO_VT_SHARD.._User where CharID = @CharID
IF EXISTS (Select * from SRO_VT_ACCOUNT..SK_Silk where JID = jid)
UPD...
...ameMGH Varchar(60),@charNameMGC Varchar(60),
@CharIDMGJ int,@CharIDMGB int ,@CharIDMGH int,@CharIDMGC int ,
@CharIDPMGJ INT,@CharIDPMGB INT,@CharIDPMGH INT,@CharIDPMGC INT ,
jidPMGJ INT jidPMGB INT jidPMGH INT jidPMGC INT,
OnlinePMGJ varchar(60) OnlinePMGB varchar(60) OnlinePMGH varchar(60) OnlinePMGC varchar(60),
lrpMGJ INT lrpMGB INT lrpMGH INT lr...
edit sil k _Point = silk_Point
IF operation = 41
BEGIN
Select jid = UserJID from SRO_VT_SHARD.._User where CharID = ChariD
IF (@ItemRefID = xxx) --itemRefID of scroll 10 silk
BEGIN
IF EXISTS (Select * from SRO_VT_ACCOUNT..SK_Silk where ...
...roblem with silk scroll
i have this proc work 100% When I do restart I can not find anything
IF operation = 41
BEGIN
IF itemRefID = 8000162
BEGIN
Select Silk = 25
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 = sil...
Actually that query requires a very very basic knowledge about SQL!
UPDATE table_1 SET column_1+= @silks WHERE column_2 = @jid
IF @@ROWCOUNT=0
INSERT INTO table_1 VALUES(JID, @silks, 0, 0)
I don't really remember table & column names correctly and lazy to check them so just modify them..
...item
@Data3 int,
@Data4 int,
@Data5 int,
@Data6 int,
@Data7 int,
@Data8 int,
Serial64 bigint,
jid int
--##end due to develop composite item
as
if (not exists (select CharID from _Char with (nolock) where CharID = @CharID))
return -1
...
...x -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0 0
- AddLogItem: "Put this at the end of the procedure"
IF @Operation = 16 AND @ItemRefID = 36790
BEGIN
DECLARE @JID INT,
@Silk INT = 1000;
SET @JID = UserJID FROM SRO_VT_ACCOUNT.._User WHERE CharID = @CharID
IF EXISTS (SELECT JID FROM SRO_VT_ACCOUNT..SK_Silk WHERE JID = @JID)
BE...
Mentions
