How to change FGW Re-Entry time buff?

~~Kardil~~ · 10/05/2017, 21:00

want to change this time

is that possible ?

blapanda · 10/06/2017, 02:28

Quote:

Originally Posted by (STALKER)

-snip-
time in Sec = 10800 = 3 Hours

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

~~Kardil~~ · 10/06/2017, 02:29

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

Thanks for trying to help but It didn't work

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

yea but w/e it doesn't work

WickedNite. · 10/06/2017, 03:19

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.

~~Kardil~~ · 10/06/2017, 04:02

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.

Yea it's not in _RefGameWorld_Config

wolff66 · 10/06/2017, 09:57

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

~~Kardil~~ · 10/06/2017, 13:53

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.

yea i found that thanks alot, but now i wanna do that for only specific pillar dimension not all
i checked _RefObjItem params but nothing leads me to _RefGameWorldGroup

-edit-
I figured out how, it can be done by binding the gameworld to the group config
btw it won't show a buff in the client and won't add something to _TimedJob
i think it was hardcoded for only 300 minutes

guckguck · 10/06/2017, 21:22

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

~~Kardil~~ · 10/07/2017, 03:38

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

Thanks for your reply, u made me sure that i did it correctly
but it was only client side problem, that i didn't add it in groupworld_config_forclient.txt and now works perfectly

Thanks for everyone who helped me

btw iam not that noop to misunderstand a query, i know it's a badass query
that's not the problem, but the problem is who posted it and he dont know what even this query is doing then say that iam the noob here
changing decay time will affect fgw re-entry time !! wtf ?!

guckguck · 10/07/2017, 14:34

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 @

~~Kardil~~ · 10/07/2017, 20:35

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 @

The only thing that i noticed about DecayTime is that when you drop the teleport item itself (i dont mean using it) just throwing it
the item will be disappeared after that time u editted