How To Make Mob Spawn Lower

[ofek40032]

But Dont Give Me Stupid query like that:

 Spoiler

USE [SRO_VT_SHARD]
GO
UPDATE dbo.Tab_RefNest SET dwmaxtotalcount = dwmaxtotalcount/2

or like that:

 Spoiler

USE SRO_VT_SHARD_INIT
UPDATE Tab_RefNest SET dwmaxtotalcount=dwmaxtotalcount*10
WHERE dwTacticsID NOT BETWEEN 41000 AND 43860
AND dwTacticsID NOT BETWEEN 32100 AND 32800
UPDATE dbo.Tab_RefNest SET dwmaxtotalcount=1
WHERE dwdelaytimemax=21600; ;

cuz it makes alot of bugs!!
like what? unique spawn will not work // no mobs in some places // Holy Water Temp will be without and unique and Job Temp Too.
so please who want help read all of it

[Syloxx]

USE [SRO_VT_SHARD]
GO
UPDATE dbo.Tab_RefNest SET dwmaxtotalcount = dwmaxtotalcount/2

just add some where clouses to specificate the query (so it doenst touch uniques, jg cave traps etc)

but its way too much work

[ofek40032]

Originally Posted by Syloxx

USE [SRO_VT_SHARD]
GO
UPDATE dbo.Tab_RefNest SET dwmaxtotalcount = dwmaxtotalcount/2

just add some where clouses to specificate the query (so it doenst touch uniques, jg cave traps etc)

but its way too much work

How should i know where is it?
Can I give you my RefNest and you will make it for me? (Sure just if you have time)

[Syloxx]

Originally Posted by ofek40032

How should i know where is it?
Can I give you my RefNest and you will make it for me? (Sure just if you have time)

by comparing some columns. and sorry, i dont have that much time

[ofek40032]

Originally Posted by Syloxx

by comparing some columns. and sorry, i dont have that much time

can you tell me wich columns? or you dont know that too?

[Syloxx]

Originally Posted by ofek40032

can you tell me wich columns? or you dont know that too?

i dont have rthe column names in my head but just check the respawn time and the spawn amount

if its uncommon then ignore these lines

[ofek40032]

Originally Posted by Syloxx

i dont have rthe column names in my head but just check the respawn time and the spawn amount

if its uncommon then ignore these lines

that what i looked for:
"look for the mob id (dwobjid) at tab_reftactics , and search that tab_reftatics id on tab_refnest (dwtacticsid)"