Scroll's Title Not working

[kubed]

Help please after i use Query FOR Rest time Guild .
my scroll.s title not working any more
how i fixed it !

[Aaron*]

Did you add your title scroll trigger in the _AddTimedJob @ SHARD DB?
if yes, then you have to add the triggers again.

[kubed]

they was working good,but after add query Guild scroll don't want working any more

[Aaron*]

Originally Posted by kubed

they was working good,but after add query Guild scroll don't want working any more

dude, if you made them by yourself, then you have to make them again.
if you didn't make them by yourself, then you have to restore your shard with a different name and open _AddtimedJob procedure. copy everything in it and put it @ your current _AddTimedJob @ your real shard db.
I hope i helped you.

[​Exo]

Simply use Log, making triggers for scroll? You just update hwanlevel so log sp is okay

[Tyr*]

Originally Posted by xExorcist

Simply use Log, making triggers for scroll? You just update hwanlevel so log sp is okay

he's still a beginner. explain him more ^^

Originally Posted by Jocs

dude, if you made them by yourself, then you have to make them again.
if you didn't make them by yourself, then you have to restore your shard with a different name and open _AddtimedJob procedure. copy everything in it and put it @ your current _AddTimedJob @ your real shard db.
I hope i helped you.

this is the only solution

[kubed]

I Do that,Still don't want work

[​Exo]

Can you show me your query... And I really don't know why you're using a **** trigger for that...

[kubed]

that's query Make my tittle scrolls not working +

 Spoiler

USE [SRO_VT_SHARD]
GO
/******By Jangan ******/
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
return -1
END
ELSE
BEGIN
--##begin due to develop composite item
insert into _TimedJob(CharID,Category,JobID,TimeToKeep,Data1,D ata2,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

********************

[Eslam Galull]

sure it makes your scrolls didnt work .. Cuz you depends on addtimejob to do the changes

This Query Didnt have the Correct usage Scrolls Like

if(@JobID = '33838')
begin
update bla bla bla
end

simply re add them

[kubed]

Done thanks all for help