How to increase Mops rate in my Server

[ifiwashere]

How to increase Mops rate in my server ??

my server is pve d11 cap 110 some areas in map not have more mops to get

good exp, if i kill monster it not respawn immediatly , i need to increase mops

from lvl 1 to lvl 110 example if it 1 respawn 1 unit i need it 3x or 2x , with out

any crash ?? , mops only not any common object in server , how i can fix it guys ??

This SS with Bot ON as You See ...!

[Worshiper]

Refnest table you can increase it

Recommend too using 3 or 2 GS to avoid crash

[Ericlar]

PHP Code:

--================
--Check Before Do anything
--================
SELECT TRN.*
FROM Tab_RefNest AS TRN
JOIN _RefRegion AS RR ON TRN.nRegionDBID = RR.wRegionID
JOIN Tab_RefTactics AS TRT ON TRN.dwTacticsID = TRT.dwTacticsID
JOIN _RefObjCommon AS ROC ON TRT.dwObjID = ROC.ID
JOIN Tab_RefHive AS HV ON TRN.dwHiveID = HV.dwHiveID
WHERE RR.ContinentName LIKE 'Roc'
AND ROC.CodeName128 LIKE 'MOB_%'
AND ROC.Rarity NOT IN (3, 8)
AND HV.GameWorldID = 1 ;

--================
--UPDATE
--================

UPDATE Tab_RefNest 
SET dwMaxTotalCount = dwMaxTotalCount * 2 
WHERE dwMaxTotalCount > 2 
AND dwNestID IN (
    SELECT TRN.dwNestID
    FROM Tab_RefNest AS TRN
    JOIN _RefRegion AS RR ON TRN.nRegionDBID = RR.wRegionID
    JOIN Tab_RefTactics AS TRT ON TRN.dwTacticsID = TRT.dwTacticsID
    JOIN _RefObjCommon AS ROC ON TRT.dwObjID = ROC.ID
    JOIN Tab_RefHive AS HV ON TRN.dwHiveID = HV.dwHiveID
    WHERE RR.ContinentName LIKE 'Roc'
    AND ROC.CodeName128 LIKE 'MOB_%'
    AND ROC.Rarity NOT IN (3, 8)
    AND HV.GameWorldID = 1
); 


[ifiwashere]

Originally Posted by Worshiper

Refnest table you can increase it

Recommend too using 3 or 2 GS to avoid crash

really thnx <3 <3

[srothanglong]

update Tab_RefNest
set dwMaxTotalCount = '4' --Number of people wanting to be born

[ZαKuRα]

Originally Posted by srothanglong

update Tab_RefNest
set dwMaxTotalCount = '4' --Number of people wanting to be born

hey, be careful with this, you can ruin the DB, there must be restrictions, stop being crazy!

[srothanglong]

Originally Posted by ZαKuRα

hey, be careful with this, you can ruin the DB, there must be restrictions, stop being crazy!

I'm just giving specific examples. In essence, you have to fix the things that need to be fixed. I just increased the number from 1 to 4.
If your article only has 1 monster, just increase it to 4 or 8 depending on the GS.
You can use the command:

 Spoiler

USE SRO_VT_SHARD
update Tab_RefNest set dwMaxTotalCount = 8 where dwTacticsID in
(select dwTacticsID from Tab_RefTactics where dwObjID in (select id from _RefObjCommon where CodeName128 like 'MOB_%' and Rarity = 0))