since i saw so many spawn change queries they fcked up your whole db with decrease / increase unique spawn rate, instance spawn rate etc i just decided to write my own here we go
Code:
DECLARE @RARE FLOAT = 0.75 /*_#2 = 200%, 1 = 100%, 0.5 = 50%*/
UPDATE TRN
SET TRN.dwMaxTotalCount *= @RARE
FROM Tab_RefNest TRN
JOIN Tab_RefTactics TRT ON TRN.dwTacticsID = TRT.dwTacticsID
JOIN _RefObjCommon ROC ON TRT.dwObjID = ROC.ID
WHERE ROC.CodeName128 LIKE 'MOB%'
AND ROC.Rarity = 0
AND dwDelayTimeMin < 600
AND dwDelayTimeMin != 0
AND dwMaxTotalCount != 1
that Query Works good? i used a other query and i have alot of Mobs in the server when i open it but when i kill all of them they respawn so slow, Until you get to have no mobs
that Query Works good? i used a other query and i have alot of Mobs in the server when i open it but when i kill all of them they respawn so slow, Until you get to have no mobs
select
CodeName128,dwDelayTimeMin,dwDelayTimeMax,dwMaxTotalCount FROM Tab_RefNest TRN
JOIN Tab_RefTactics TRT ON TRN.dwTacticsID = TRT.dwTacticsID
JOIN _RefObjCommon ROC ON TRT.dwObjID = ROC.ID
WHERE ROC.CodeName128 LIKE 'MOB%'
AND ROC.Rarity = 0
AND dwDelayTimeMin < 600
AND dwDelayTimeMin != 0
AND dwMaxTotalCount != 1
Hehehe, I've used this "perfect querry" also, there is no solution for this, your _RefNest is ****** up, isn't it? The only solution is the rollback xD
Hehehe, I've used this "perfect querry" also, there is no solution for this, your _RefNest is ****** up, isn't it? The only solution is the rollback xD
There is a solution, restore 2 dbs of shard and just replace the tables.
[RELEASE] CHANGING YOUR EUDEMON COMPOSE RATE USING QUERY 07/13/2017 - EO PServer Guides & Releases - 19 Replies i though many of people here having a problem when trying to changing their eudemon compose rate one by one in cq_eudemon_rbn_rqr..so i made a simple query to changing it easily by using a query..so here we go..firsty..u must have a standard compose sql..so i have upload the standard compose rate query for download if u like(my standard compose rate).
Then use this query to changing your composing rate..
UPDATE `cq_eudemon_rbn_rqr` SET max = max + 20;
UPDATE `cq_eudemon_rbn_rqr` SET...
Query to change max level [small release] 03/22/2016 - SRO PServer Guides & Releases - 4 Replies USE SRO_VT_SHARD ---- YOUR DATABASE NAME
UPDATE _REFLEVEL
SET EXP_C ='99999999999999999' , EXP_M ='999999999'
WHERE LVL ='111'
press Thanks if i helped
i need query to change job rate 03/24/2015 - SRO Private Server - 1 Replies i need query job rate 70x
By 1 Trade Item = 1m
Sell 1 Trade item = 2m ?
How to change mob spawn rate? (Chernobyl* check this please) 11/14/2011 - SRO Private Server - 5 Replies Is there anyone who knows how I can change monster spawn rate? I want to decrease it but I do not know how to do it. Also when I decrease the spawn rate it effects all regions or can I change the rate on just one region as well?
![[RELEASE] Perfect query to change spawn rate](https://www.elitepvpers.com/forum/iconimages/sro-pserver-guides-releases/release-perfect-query-change-spawn-rate_ltr.gif){kind=small}
