[Question] Jg Cave uniques & About Ctf/Ba

[Raptursh]

First About Jg Cave , the Uniqes in b1 , camps of b2 etc.. wont spawm , how to fix them ?
Second , do anyone know how to edit the number of players participating in the ctf or Ba each game ? ( for example making it from 8vs8 too 5 vs 5 )
And Thanks ..

[JuliaRocks*]

Get a new fresh DB

[Raptursh]

mm , cant get a fresh db since i worked hard on it . can u give me a strait solution without replacing everything ? at least which table to replace ?

[Dark_User]

do like that
select * from _refobjcommon where codename128 like '%Mob_TQ%'
since u get the ids of the uniques
search on Tab_RefTactics with the id from objcommon
select * from Tab_RefTactics where dwobjid like 'ID of the unqiue'
well since u get the reftac ids
search on Tab_Refnest about this id's
select * from _TAB_refnest where dwTacticsID like 'ID of reftac'
check if the monster dwMaxTotalCount is 0 or 1 ! if 0
then get the id from refnest and run this query
update Tab_RefNest
set dwMaxTotalCount = '1'.
where dwNestID like ''
Done !! hope i help ya

[Raptursh]

thank you

[JuliaRocks*]

Originally Posted by ahmadbilto

mm , cant get a fresh db since i worked hard on it . can u give me a strait solution without replacing everything ? at least which table to replace ?

Did you started with a new,unmodified database?
Did you edit those mobs?
I quitted working on SRO servers since school started so I don't really know.
Try to replace where you exactly edited,that's a straight solution.
Good luck.

[Raptursh]

it was bcz of this :

 Spoiler

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

but now i found a solution :

 Spoiler

USE SRO_VT_SHARD_INIT
--B1
UPDATE Tab_RefNest SET dwMaxTotalCount=1 WHERE dwTacticsID=32100 --B1 Unique
--B2
UPDATE Tab_RefNest SET dwMaxTotalCount=1 WHERE dwTacticsID=32200 --Camp 8 Unique
UPDATE Tab_RefNest SET dwMaxTotalCount=1 WHERE dwTacticsID=32300 --Camp 11 Unique
UPDATE Tab_RefNest SET dwMaxTotalCount=1 WHERE dwTacticsID=32400 --Camp 11 Unique
--B3
UPDATE Tab_RefNest SET dwMaxTotalCount=1 WHERE dwTacticsID=32500
UPDATE Tab_RefNest SET dwMaxTotalCount=1 WHERE dwTacticsID=32600
UPDATE Tab_RefNest SET dwMaxTotalCount=1 WHERE dwTacticsID=32700
UPDATE Tab_RefNest SET dwMaxTotalCount=1 WHERE dwTacticsID=32800