ازاى احط الكود ده ؟

[[GM]

if(@JobID = '3118')---gift---
begin
declare @tradenum int
declare @gift varchar(128)
set @gift =('ITEM_ETC_SD_TOKEN_01')
SET @tradenum =(SELECT ABLECOUNT from _CharTrijobSafeTrade where CharID =@CharID )
if (@tradenum >=5)
begin
select @CharName16 =CharName16 from _Char where CharID=@CharID
exec _ADD_ITEM_EXTERN @CharName16,@gift,10,1
update _CharTrijobSafeTrade set AbleCount =0 where CharID =@CharID
end
end

انا عارف انى المفروض احطه فى ال _addtimedjob
بس مش عارف احطه فين بالظبط ومش عايز ابوظ الدنيا
ده ال add timed jop بتاعى عدلو انتم عليه علشان افهم
وشكرا جزيلا

USE [SRO_VT_SHARD]
GO
/****** Object:  StoredProcedure [dbo].[_AddTimedJob]    Script Date: 11/15/2013 02:31:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER   procedure [dbo].[_AddTimedJob]
@CharID            int,
@Category        tinyint,
@JobID            int,
@TimeToKeep    int,
@Data1            int,
@Data2            int,
--##begin due to develop composite 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
            if (@TimeToKeep <= 0)
                return -2
            declare @NewJobID int
            set @NewJobID = 0

            --##JobID 1 = Guild // JobID 2 = Thief/Hunter/Trader
            --##If you want to only have one not both, then just modify the line below!
            if (@JobID = 1 or @JobID = 2)
            BEGIN
                insert into _TimedJob(CharID,Category,JobID,TimeToKeep,Data1,Data2,Data3,Data4,Data5,Data6,Data7,Data8,Serial64,JID)
                values(@CharID, @Category, @JobID, 1, @Data1, @Data2, @Data3, @Data4, @Data5, @Data6, @Data7, @Data8, @Serial64, @JID)
            END
            ELSE
            BEGIN
                --##begin due to develop composite item
                insert into _TimedJob(CharID,Category,JobID,TimeToKeep,Data1,Data2,Data3,Data4,Data5,Data6,Data7,Data8,Serial64,JID)
                values(@CharID, @Category, @JobID, @TimeToKeep, @Data1, @Data2, @Data3, @Data4, @Data5, @Data6, @Data7, @Data8, @Serial64, @JID)
            END
                --##end due to develop composite item
            set @NewJobID = @@identity
            if (@@error <> 0 or @@rowcount = 0)
                
                return -3
     return @NewJobID

[™Dev Microsoft™]

انا مش فاهم منك اي حاجة ^^
بس عموما الـADDNEWJOB_ ده ده Table

[[GM]

_addTimedJob

[[GM]

الكود ده

if(@JobID = '3118')---gift---
begin
declare @tradenum int
declare @gift varchar(128)
set @gift =('ITEM_ETC_SD_TOKEN_01')
SET @tradenum =(SELECT ABLECOUNT from _CharTrijobSafeTrade where CharID =@CharID ) 
if (@tradenum >=5)
begin
select @CharName16 =CharName16 from _Char where CharID=@CharID
exec _ADD_ITEM_EXTERN @CharName16,@gift,10,1
update _CharTrijobSafeTrade set AbleCount =0 where CharID =@CharID
end
end

المفروض احطو هنا

USE [SRO_VT_SHARD]
GO
/****** Object:  StoredProcedure [dbo].[_AddTimedJob]    Script Date: 11/15/2013 02:31:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER   procedure [dbo].[_AddTimedJob]
@CharID            int,
@Category        tinyint,
@JobID            int,
@TimeToKeep    int,
@Data1            int,
@Data2            int,
--##begin due to develop composite 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
            if (@TimeToKeep <= 0)
                return -2
            declare @NewJobID int
            set @NewJobID = 0

            --##JobID 1 = Guild // JobID 2 = Thief/Hunter/Trader
            --##If you want to only have one not both, then just modify the line below!
            if (@JobID = 1 or @JobID = 2)
            BEGIN
                insert into _TimedJob(CharID,Category,JobID,TimeToKeep,Data1,Data2,Data3,Data4,Data5,Data6,Data7,Data8,Serial64,JID)
                values(@CharID, @Category, @JobID, 1, @Data1, @Data2, @Data3, @Data4, @Data5, @Data6, @Data7, @Data8, @Serial64, @JID)
            END
            ELSE
            BEGIN
                --##begin due to develop composite item
                insert into _TimedJob(CharID,Category,JobID,TimeToKeep,Data1,Data2,Data3,Data4,Data5,Data6,Data7,Data8,Serial64,JID)
                values(@CharID, @Category, @JobID, @TimeToKeep, @Data1, @Data2, @Data3, @Data4, @Data5, @Data6, @Data7, @Data8, @Serial64, @JID)
            END
                --##end due to develop composite item
            set @NewJobID = @@identity
            if (@@error <> 0 or @@rowcount = 0)
                
                return -3
     return @NewJobID

ازاى ؟

[™Dev Microsoft™]

لا بص حط التاني دي في New Query و اعمل Save و بعدين الول بنفس الطريقة و شوف هايحصل ايه بس خد BackUp من الداتا قبل اي حاجة و قلي عملت ايه :)

[[GM]

اولا التانى ده انا اللى مطلعه من الداتا بيز عشان انته تقولى اعدله ازاى يعنى ده اصلا اللى موجود فى الداتا
الاول اللى هوه ده

if(@JobID = '3118')---gift---
begin
declare @tradenum int
declare @gift varchar(128)
set @gift =('ITEM_ETC_SD_TOKEN_01')
SET @tradenum =(SELECT ABLECOUNT from _CharTrijobSafeTrade where CharID =@CharID ) 
if (@tradenum >=5)
begin
select @CharName16 =CharName16 from _Char where CharID=@CharID
exec _ADD_ITEM_EXTERN @CharName16,@gift,10,1
update _CharTrijobSafeTrade set AbleCount =0 where CharID =@CharID
end
end

مش عارف اعمل معاه ايه مينفعش كويرى بيدينى Errrors
الكود ده مفروض يتحط فى الكود التانى اللى هوه موجود عندى فى الداتابيز اللى هوه بردو انا كاتبز تانى كود فوق

[[GM]

معلش هتعبك معايا

[™Dev Microsoft™]

يبقا اكيد الكويري انت جايبو غلط او اللي كاتبو كاتب حاجة غلط :)