[F77]

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

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

  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