How to change FGW Re-Entry time buff?

Quote:

Originally Posted by (STALKER) -snip- time in Sec = 10800 = 3 Hours

USE SRO_VT_SHARD
SELECT * FROM dbo._RefObjCommon WHERE CodeName128 LIKE 'ITEM_ETC_TELEPORT%LEVEL%'

UPDATE [dbo].[_RefObjCommon] SET DecayTime='10800' WHERE ID BETWEEN 35883 AND 35904

Quote:

Originally Posted by (STALKER) SELECT * FROM dbo._RefObjCommon where CodeName128 like 'ITEM_ETC_TELEPORT_HOLE_TOGUI_35_50_LEVEL_1' SELECT * FROM dbo._RefObjCommon where CodeName128 like 'ITEM_ETC_TELEPORT_HOLE_TOGUI_35_50_LEVEL_2' SELECT * FROM dbo._RefObjCommon where CodeName128 like 'ITEM_ETC_TELEPORT_HOLE_TOGUI_51_60_LEVEL_1' SELECT * FROM dbo._RefObjCommon where CodeName128 like 'ITEM_ETC_TELEPORT_HOLE_TOGUI_51_60_LEVEL_2' SELECT * FROM dbo._RefObjCommon where CodeName128 like 'ITEM_ETC_TELEPORT_HOLE_TOGUI_61_70_LEVEL_1' SELECT * FROM dbo._RefObjCommon where CodeName128 like 'ITEM_ETC_TELEPORT_HOLE_TOGUI_61_70_LEVEL_2' SELECT * FROM dbo._RefObjCommon where CodeName128 like 'ITEM_ETC_TELEPORT_HOLE_FLAME_71_80_LEVEL_1' SELECT * FROM dbo._RefObjCommon where CodeName128 like 'ITEM_ETC_TELEPORT_HOLE_FLAME_71_80_LEVEL_2' SELECT * FROM dbo._RefObjCommon where CodeName128 like 'ITEM_ETC_TELEPORT_HOLE_FLAME_71_80_LEVEL_3' SELECT * FROM dbo._RefObjCommon where CodeName128 like 'ITEM_ETC_TELEPORT_HOLE_FLAME_71_80_LEVEL_4' SELECT * FROM dbo._RefObjCommon where CodeName128 like 'ITEM_ETC_TELEPORT_HOLE_FLAME_81_90_LEVEL_1' SELECT * FROM dbo._RefObjCommon where CodeName128 like 'ITEM_ETC_TELEPORT_HOLE_FLAME_81_90_LEVEL_2' SELECT * FROM dbo._RefObjCommon where CodeName128 like 'ITEM_ETC_TELEPORT_HOLE_FLAME_81_90_LEVEL_3' SELECT * FROM dbo._RefObjCommon where CodeName128 like 'ITEM_ETC_TELEPORT_HOLE_FLAME_81_90_LEVEL_4' SELECT * FROM dbo._RefObjCommon where CodeName128 like 'ITEM_ETC_TELEPORT_HOLE_WRECK_91_100_LEVEL_1' SELECT * FROM dbo._RefObjCommon where CodeName128 like 'ITEM_ETC_TELEPORT_HOLE_WRECK_91_100_LEVEL_2' SELECT * FROM dbo._RefObjCommon where CodeName128 like 'ITEM_ETC_TELEPORT_HOLE_WRECK_91_100_LEVEL_3' SELECT * FROM dbo._RefObjCommon where CodeName128 like 'ITEM_ETC_TELEPORT_HOLE_WRECK_91_100_LEVEL_4' SELECT * FROM dbo._RefObjCommon where CodeName128 like 'ITEM_ETC_TELEPORT_HOLE_WRECK_100_110_LEVEL_1' SELECT * FROM dbo._RefObjCommon where CodeName128 like 'ITEM_ETC_TELEPORT_HOLE_WRECK_100_110_LEVEL_2' SELECT * FROM dbo._RefObjCommon where CodeName128 like 'ITEM_ETC_TELEPORT_HOLE_WRECK_100_110_LEVEL_3' SELECT * FROM dbo._RefObjCommon where CodeName128 like 'ITEM_ETC_TELEPORT_HOLE_WRECK_100_110_LEVEL_4' UPDATE[dbo].[_RefObjCommon]set DecayTime='10800' where ID='35883' UPDATE[dbo].[_RefObjCommon]set DecayTime='10800' where ID='35884' UPDATE[dbo].[_RefObjCommon]set DecayTime='10800' where ID='35885' UPDATE[dbo].[_RefObjCommon]set DecayTime='10800' where ID='35886' UPDATE[dbo].[_RefObjCommon]set DecayTime='10800' where ID='35887' UPDATE[dbo].[_RefObjCommon]set DecayTime='10800' where ID='35888' UPDATE[dbo].[_RefObjCommon]set DecayTime='10800' where ID='35889' UPDATE[dbo].[_RefObjCommon]set DecayTime='10800' where ID='35890' UPDATE[dbo].[_RefObjCommon]set DecayTime='10800' where ID='35891' UPDATE[dbo].[_RefObjCommon]set DecayTime='10800' where ID='35892' UPDATE[dbo].[_RefObjCommon]set DecayTime='10800' where ID='35893' UPDATE[dbo].[_RefObjCommon]set DecayTime='10800' where ID='35894' UPDATE[dbo].[_RefObjCommon]set DecayTime='10800' where ID='35895' UPDATE[dbo].[_RefObjCommon]set DecayTime='10800' where ID='35896' UPDATE[dbo].[_RefObjCommon]set DecayTime='10800' where ID='35897' UPDATE[dbo].[_RefObjCommon]set DecayTime='10800' where ID='35898' UPDATE[dbo].[_RefObjCommon]set DecayTime='10800' where ID='35899' UPDATE[dbo].[_RefObjCommon]set DecayTime='10800' where ID='35900' UPDATE[dbo].[_RefObjCommon]set DecayTime='10800' where ID='35901' UPDATE[dbo].[_RefObjCommon]set DecayTime='10800' where ID='35902' UPDATE[dbo].[_RefObjCommon]set DecayTime='10800' where ID='35903' UPDATE[dbo].[_RefObjCommon]set DecayTime='10800' where ID='35904' time in Sec = 10800 = 3 Hours

Quote:

Originally Posted by blapanda Why not simplifying it? Code: USE SRO_VT_SHARD SELECT * FROM dbo._RefObjCommon WHERE CodeName128 LIKE 'ITEM_ETC_TELEPORT%LEVEL%' UPDATE [dbo].[_RefObjCommon] SET DecayTime='10800' WHERE ID BETWEEN 35883 AND 35904

Quote:

Originally Posted by WickedNite. That dumbass query is only for the item itself, if it's not in refgameworld_config I'll look tomorrow when I have a db on hands and edit my post.

Quote:

Originally Posted by wolff66 Its in _RefGameWorldGroup_Config: ENTER_WORLD_GROUP_COOL_TIME TIMEDJOB_COOL_TIME_FORCLIENT Default values are 300, consider 1 as 1 minute.

Quote:

Originally Posted by guckguck Hello, you can use my query to change every related items: *_GetMediaLines can be found on google :) Code: /* Keks FGW config */ declare @ti int set @ti = 150 /*Time [min] between 2 FGW runs*/ USE [SRO_VT_SHARD] /* SET delay time */ Update _RefGameWorldGroup_Config set Value = @ti where ID = 1 OR ID = 2 /* SET pillar time */ Update _RefObjItem Set Param10=1000*@ti WHERE ID IN (SELECT Link FROM _RefObjCommon WHERE Codename128 like 'ITEM_ETC_TELEPORT_HOLE_%') /*Get media lines*/ /*Teleports*/ USE [SRO_VT_SHARD] exec _GetMediaLines [MENTION=567524]Type[/MENTION]=1, [MENTION=606027]codename[/MENTION]='ITEM_ETC_TELEPORT_HOLE_%' It is changing every teleport item, gameworldgroup cool down and client sided stuff. If you want to change only a part of dungeons you might have to setup a new group definition manually: - _RefGameWorldGroup : add a new group ID = 2 and setup a name XYZ - _RefGameWorldBindGameWorldGroup : bind all used gameworld ID's to the new group (2) - _RefGameWorldGroup_Config : copy/paste all lines, add them using the new group name XYZ and add a new cooldown time - _RefObjItem : edit all used teleport holes for your dungeons and export media to client, unless you want to relog everytime As long as you are using original dungeons it should work and will be displayed in the client. Adding a new teleport hole to a custom generated dungeon (custom world ID) did not work very well. However the cool down related stuff is not hardcoded in any exe. There is also a groupworld_config_forclient file in the client but I did not change it. I ended up with a 2 hrs cooldown for every FGW :)

Quote:

Originally Posted by guckguck If you do not change the decay time your char will stay with a (server sided) 6hrs cooldown on every teleport item, even if you change timed job. In this case you will be forced to use another account to open a dungeon for you. Same belongs to the client files, if you do not edit them you have to relog everytime using a new teleport. It is similar to the usage of niya general trap during 1st zerk quest, if you relog fast you will shorten reuse time by 50%. Attached my query, there is a bug displaying @[Only registered and activated users can see links. Click Here To Register...] :)