[FGW] Reset time

Hi guys,

How can I do something to reset the time of FGW?

Regards,
JC

_CharInstanceWorldData table @ SRO_VT_SHARD

shard DB _Memo_Add proc
declare @SenderCharID int = (select charid from _Char where charname16 like @sendercharname)
if @Targetcharname like 'FGW'
begin
delete from _Timedjob where charid = @SenderCharid and JobID = 100 --make sure that 100 is right,,
end

Quote:

Originally Posted by bestprem shard DB _Memo_Add proc declare @SenderCharID int = (select charid from _Char where charname16 like @sendercharname) if @Targetcharname like 'FGW' begin delete from _Timedjob where charid = @SenderCharid and JobID = 100 --make sure that 100 is right,, end

so it's not _ChaInstanceWorldData? :rolleyes:

Quote:

Originally Posted by Aeron* so it's not _ChaInstanceWorldData? :rolleyes:

are you kidding me ??
fgw will be in that table ?
did you open sql before ?

@Crue*

Quote:

Originally Posted by bestprem are you kidding me ?? fgw will be in that table ? did you open sql before ? @Crue*

calm down, fgw is instance and i thought it is in that table
anyway here is the query to remove it

Quote:

update _TimedJob SET TimeToKeep='7', Data1='0' WHERE CharID= 'Your CharID' AND Category='12' DELETE FROM _TimedJob WHERE CharID='YourCharID' and category='6'

Quote:

Originally Posted by Aeron* calm down, fgw is instance and i thought it is in that table anyway here is the query to remove it

Crue* will replay

Quote:

Originally Posted by bestprem Crue* will replay

Why are you so happy with that Crue*?

Since when ever you guys meet at some thread it turns into a disgusting fight so I shall warn you 'Fights will not be tolerated, all sides will be affected'. Keep your damn problems private, there's no need to show off.

If you can't help the TE then just leave this thread. Unnecessary posts are not welcomed here!

Do the following and make your own query.

Remove all the buffs you got and make sure you didn't use anything that might have a CD like FGW and Holy Water Temple.

Enter the FGW

select * from _TimedJob where charid = (select charid from _char where charname16 = 'your_char_name')

Hello. at me the procedure is not. is still displayed time :( can someone help me?