View Single Post
  #85  
Old 02-23-2019, 03:57 PM
John C
Sarnak
 
Join Date: Jul 2018
Location: Atlanta, GA
Posts: 49
Default

Techungry -
I just applied your adjustments to give them a spin. I like the scaling concept and was intending to do something similar, so thanks for sharing. Just FYI though, you lost a couple of parentheses during your cut and paste on the DR line (missing "((" just before "id"). I was able to correct it for my load, but you might want to do a little edit to ensure it works for others.

Update: I like the way it is playing so far. I just get naturally worried that there is no scaling applied to anything over level 80. It likely doesn't matter since most of those are outside of what is typically playable, but just to be safe I added a few lines to adjust them too - I just had to bend the nerf curve a bit. Just in case you are interested, here is what I am using:

LOCK TABLES `npc_types` WRITE;
-- scale STR up to to hit more frequently
-- UPDATE npc_types SET STR=CEIL(STR*1.2);
-- scale hp/damage down
-- =1-(LEVEL/89)
UPDATE npc_types SET hp=CEIL(hp*(1-(LEVEL/89))) WHERE (LEVEL<81 AND ((id>1000 AND id<800000)) OR id IN ('635','636','646','649','650','667','668','669',' 673','676','677','679','679','679','680','681','82 9','923','924'));
UPDATE npc_types SET maxdmg=CEIL(maxdmg*(1-(LEVEL/89))) WHERE LEVEL<81 AND ((id>1000 AND id<800000) OR id IN ('635','636','646','649','650','667','668','669',' 673','676','677','679','679','679','680','681','82 9','923','924'));
UPDATE npc_types SET mindmg=CEIL(mindmg*(1-(LEVEL/89))) WHERE LEVEL>20 AND LEVEL<81 AND ((id>1000 AND id<800000) OR id IN ('635','636','646','649','650','667','668','669',' 673','676','677','679','679','679','680','681','82 9','923','924'));
-- scale spell and heal down
UPDATE npc_types SET spellscale=50 WHERE level>19 AND ((id>1000 AND id<800000) OR id IN ('635','636','646','649','650','667','668','669',' 673','676','677','679','679','679','680','681','82 9','923','924'));
UPDATE npc_types SET healscale=50 WHERE level>19 AND ((id>1000 AND id<800000) OR id IN ('635','636','646','649','650','667','668','669',' 673','676','677','679','679','679','680','681','82 9','923','924'));
-- adjust agro radius down
UPDATE npc_types SET aggroradius=CEIL(aggroradius*0.30) WHERE aggroradius>20;
-- scale resists down
UPDATE npc_types SET MR=CEIL(MR*(1-(LEVEL/89))) WHERE LEVEL<81 AND ((id>1000 AND id<800000) OR id IN ('635','636','646','649','650','667','668','669',' 673','676','677','679','679','679','680','681','82 9','923','924'));
UPDATE npc_types SET CR=CEIL(CR*(1-(LEVEL/89))) WHERE LEVEL<81 AND ((id>1000 AND id<800000) OR id IN ('635','636','646','649','650','667','668','669',' 673','676','677','679','679','679','680','681','82 9','923','924'));
UPDATE npc_types SET DR=CEIL(DR*(1-(LEVEL/89))) WHERE LEVEL<81 AND id>1000 AND id<800000) OR id IN ('635','636','646','649','650','667','668','669',' 673','676','677','679','679','679','680','681','82 9','923','924'));
UPDATE npc_types SET FR=CEIL(FR*(1-(LEVEL/89))) WHERE LEVEL<81 AND ((id>1000 AND id<800000) OR id IN ('635','636','646','649','650','667','668','669',' 673','676','677','679','679','679','680','681','82 9','923','924'));
UPDATE npc_types SET PR=CEIL(PR*(1-(LEVEL/89))) WHERE LEVEL<81 AND ((id>1000 AND id<800000) OR id IN ('635','636','646','649','650','667','668','669',' 673','676','677','679','679','679','680','681','82 9','923','924'));
UPDATE npc_types SET Corrup=CEIL(Corrup*(1-(LEVEL/89))) WHERE LEVEL<81 AND ((id>1000 AND id<800000) OR id IN ('635','636','646','649','650','667','668','669',' 673','676','677','679','679','679','680','681','82 9','923','924'));

-- Adjusted formulas to change incline rate after level 80

UPDATE npc_types SET hp=CEIL(hp*(0.3-(LEVEL/400))) WHERE (LEVEL>80 AND ((id>1000 AND id<800000)) OR id IN ('635','636','646','649','650','667','668','669',' 673','676','677','679','679','679','680','681','82 9','923','924'));
UPDATE npc_types SET maxdmg=CEIL(maxdmg*(0.3-(LEVEL/400))) WHERE LEVEL>80 AND ((id>1000 AND id<800000) OR id IN ('635','636','646','649','650','667','668','669',' 673','676','677','679','679','679','680','681','82 9','923','924'));
UPDATE npc_types SET mindmg=CEIL(mindmg*(0.3-(LEVEL/400))) WHERE LEVEL>80 AND ((id>1000 AND id<800000) OR id IN ('635','636','646','649','650','667','668','669',' 673','676','677','679','679','679','680','681','82 9','923','924'));
-- scale spell and heal down
UPDATE npc_types SET MR=CEIL(MR*(0.3-(LEVEL/400))) WHERE LEVEL>80 AND ((id>1000 AND id<800000) OR id IN ('635','636','646','649','650','667','668','669',' 673','676','677','679','679','679','680','681','82 9','923','924'));
UPDATE npc_types SET CR=CEIL(CR*(0.3-(LEVEL/400))) WHERE LEVEL>80 AND ((id>1000 AND id<800000) OR id IN ('635','636','646','649','650','667','668','669',' 673','676','677','679','679','679','680','681','82 9','923','924'));
UPDATE npc_types SET DR=CEIL(DR*(0.3-(LEVEL/400))) WHERE LEVEL>80 AND ((id>1000 AND id<800000) OR id IN ('635','636','646','649','650','667','668','669',' 673','676','677','679','679','679','680','681','82 9','923','924'));
UPDATE npc_types SET FR=CEIL(FR*(0.3-(LEVEL/400))) WHERE LEVEL>80 AND ((id>1000 AND id<800000) OR id IN ('635','636','646','649','650','667','668','669',' 673','676','677','679','679','679','680','681','82 9','923','924'));
UPDATE npc_types SET PR=CEIL(PR*(0.3-(LEVEL/400))) WHERE LEVEL>80 AND ((id>1000 AND id<800000) OR id IN ('635','636','646','649','650','667','668','669',' 673','676','677','679','679','679','680','681','82 9','923','924'));
UPDATE npc_types SET Corrup=CEIL(Corrup*(0.3-(LEVEL/400))) WHERE LEVEL>80 AND ((id>1000 AND id<800000) OR id IN ('635','636','646','649','650','667','668','669',' 673','676','677','679','679','679','680','681','82 9','923','924'));
UNLOCK TABLES;
Reply With Quote