[Dev]Unique Spawn Time

[Right]

hey guys
I need change Unique Spawn times 3-6 hours to 2-4 or etc.
I need Tab_refnest table for this but Which id is TG or Isy etc.

How I can find their IDs?

[MentaL]

[Tazdingo]

First search id in _RefObjCommon then compare in RefTactics finally you can find the NestId with the TacticsID

[Statiic]

exemple.
TG Spawn time
_RefObjCommon

SELECT * FROM _RefObjCommon WHERE Codename128 like 'MOB_CH_TIGERWOMAN'

u get the id = 1954
now go to Tab_RefTactics

SELECT * FROM Tab_RefTactics WHERE dwObjID = 1954

_RefObjCommon ID
now u get the dwTactics ID = 33

now Tab_RefNest

SELECT * FROM Tab_RefNest WHERE dwTacticsID = 33

and u will get tg spawn info (spawn points)

1st spawn

5656	193	33	23712	532,82	1390,6	938,17	0	1000	600	0	10800	21600	1	0	1	0

delay time min to spawn = secs like 60 sec = 1 minute ^^ change to 60 for exemple
Delay time max spawn same based in secs change for 70 for exemple.
now change the others spawns (spawn points) to 60 and 70
and tg will apper every 1 minute

[3d2000]

Statiic u are the Man :PP

[Right]

Static you are big man =)
Big thanks to you

Update Tab_RefNest Set dwDelayTimeMin=7200 , dwDelayTimeMax=14400 WHERE dwTacticsID = (SELECT dwTacticsID FROM Tab_RefTactics
WHERE dwObjID =
(SELECT ID FROM _RefObjCommon WHERE Codename128 like 'MOB_OA_URUCHI')) Used like that =)

[okkes95]

For 15 minutes, what has to be red and the other?

[maxigameDaB]

hey guys
I need change Unique Spawn times 3-6 hours to 2-4 or etc.
I need Tab_refnest table for this but Which id is TG or Isy etc.

How I can find their IDs?

http://forum.ragezone.com/f723/chang...n-time-829194/

[abdelbaser]

exemple.
TG Spawn time
_RefObjCommon

SELECT * FROM _RefObjCommon WHERE Codename128 like 'MOB_CH_TIGERWOMAN'

u get the id = 1954
now go to Tab_RefTactics

SELECT * FROM Tab_RefTactics WHERE dwObjID = 1954

_RefObjCommon ID
now u get the dwTactics ID = 33

now Tab_RefNest

SELECT * FROM Tab_RefNest WHERE dwTacticsID = 33

and u will get tg spawn info (spawn points)

1st spawn

5656	193	33	23712	532,82	1390,6	938,17	0	1000	600	0	10800	21600	1	0	1	0

delay time min to spawn = secs like 60 sec = 1 minute ^^ change to 60 for exemple
Delay time max spawn same based in secs change for 70 for exemple.
now change the others spawns (spawn points) to 60 and 70
and tg will apper every 1 minute

awsome thanks

[BryanSA]

Niceee :D

[kellogz]

Static do you know where the unique has spawned message is controlled and how? Im talking if we want to make a new unique to the game how do we make it so the server than announces this? Or is this something within the gameserver?

[Caipi]

Aw totally overlooked this one here ;o

To give you an overview over the Mobs, spawnplaces etc use..

SELECT 
        ref.ID as RefObjCommonID, 
        tac.dwObjID, 
        ref.CodeName128, 
        nest.*, 
        hive.*
FROM _RefObjChar as objchar
        JOIN _RefObjCommon as ref on objchar.ID = ref.Link
        JOIN Tab_RefTactics as tac on ref.ID = tac.dwObjID
        JOIN Tab_RefNest as nest on tac.dwTacticsID = nest.dwTacticsID
        JOIN Tab_RefHive as hive on nest.dwHiveID = hive.dwHiveID

ORDER BY ref.ID 

[Statiic]

hmm nice i think u can made a query for add basic_chains missings exemple
get Basic_ChainCode from _RefSkill2 (working 120 skill :) ) and insert into _RefSkill WHERE ID as same FROM _RefSkill2 like this xD

[Caipi]

hmm nice i think u can made a query for add basic_chains missings exemple
get Basic_ChainCode from _RefSkill2 (working 120 skill :) ) and insert into _RefSkill WHERE ID as same FROM _RefSkill2 like this xD

Responded to your message, try it out :)

[ModGift]

I'm using this code

--HyperProCoders ModGift
UPDATE [SRO_VT_SHARD].[dbo].[Tab_RefNest]
   SET 
      dwDelayTimeMin = '600',
      dwDelayTimeMax = '2400'
   WHERE 
      dwDelayTimeMin= '10800'
GO
--HyperProCoders ModGift

Min: 600/60 = 10minute
Max: 2400/60= 40minute

applies to all unique

[Right]

http://forum.ragezone.com/f723/chang...n-time-829194/

thanks for answer to your answered question -_-