[FGW] Reset time

[jcrrb]

Hi guys,

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

Regards,
JC

[Aaron*]

_CharInstanceWorldData table @ SRO_VT_SHARD

[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

[Aaron*]

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?

[bestprem]

Originally Posted by Aeron*

so it's not _ChaInstanceWorldData?

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

@Crue*

[Aaron*]

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

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

[bestprem]

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

[Aaron*]

Originally Posted by bestprem

Crue* will replay

Why are you so happy with that Crue*?

[​Exo]

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 **** 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!

[Snow*]

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')

[ThomasF2007]

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