Silk/Hour system (Help)

[HB#]

يا جماعة انا كنت عاوز اضيف silk/hour system وجبتوا من الموضوع دا Silk/Hour System (http://www.silkroad4arab.com/vb/showthread.php?t=461170)
بس وانا بعمل query في DSRO_VT_ACCOUNT جالي ال error دي :
http://store4.up-00.com/2017-07/150054662269141.png
يا ريت لو حد ضايفها يجيبلي query ال procedure او لو يعرف حل لل error دي يبقا مشكور اوي :yes:

[Legendr]

روح لي _ectrasilk و في sro_vt_account وامسح مفتاح الي ع سطر
Desige كليك يمن عليه و

[HB#]

روح لي _ectrasilk و في sro_vt_account وامسح مفتاح الي ع سطر
Desige كليك يمن عليه و

حضرتك لو انا لسا بعمل create procedure يعني ال table مش موجوده لسا :mf_fart:

ال procedure اهي :
USE [SRO_VT_ACCOUNT]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[_extraSilk] /*by Yui*/

@CharID int,
@Silk int

as

Declare @JID int, @Multiplier int = (SELECT [Silk/Hour] FROM SRO_VT_SHARDLOG.dbo._OnlineOffline WHERE CharID = @CharID);

SET @JID = (
SELECT usert.UserJID FROM SRO_VT_SHARD.dbo._User as usert
JOIN SRO_VT_SHARD.dbo._Char as chart on usert.CharID = chart.CharID
WHERE chart.CharID = @CharID
);

IF not exists (SELECT JID FROM SK_Silk WHERE JID = @JID)
BEGIN
INSERT INTO SK_Silk SELECT @JID, 0, 0, 0
END

UPDATE SK_Silk
SET silk_own = silk_own + (@Silk*@Multiplier)
WHERE JID = @JID

[Legendr]

حضرتك لو انا لسا بعمل create procedure يعني ال table مش موجوده لسا :mf_fart:

ال procedure اهي :
USE [SRO_VT_ACCOUNT]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[_extraSilk] /*by Yui*/

@CharID int,
@Silk int

as

Declare @JID int, @Multiplier int = (SELECT [Silk/Hour] FROM SRO_VT_SHARDLOG.dbo._OnlineOffline WHERE CharID = @CharID);

SET @JID = (
SELECT usert.UserJID FROM SRO_VT_SHARD.dbo._User as usert
JOIN SRO_VT_SHARD.dbo._Char as chart on usert.CharID = chart.CharID
WHERE chart.CharID = @CharID
);

IF not exists (SELECT JID FROM SK_Silk WHERE JID = @JID)
BEGIN
INSERT INTO SK_Silk SELECT @JID, 0, 0, 0
END

UPDATE SK_Silk
SET silk_own = silk_own + (@Silk*@Multiplier)
WHERE JID = @JID


اصلا table ده كزجود في Database V1.188 اصلا ده ملهوش علاقه بسستم بتاعه بس بيتحط فيه جادات