Code:
-- This makes monsters easier for solo play
UPDATE npc_types SET AC=CEIL(level*20) WHERE level>19 AND AC>(level*20);
UPDATE npc_types SET maxdmg=(level) WHERE level>19 AND maxdmg>(level) AND id>1000 AND id<800000;
UPDATE npc_types SET mindmg=CEIL(level/10) WHERE level>19 AND mindmg>(level/10) AND id>1000 AND id<800000;
UPDATE npc_types SET hp=CEIL(level*35) WHERE level>19 AND hp>(level*35) AND id>1000 AND id<800000;
UPDATE npc_types SET STR=CEIL(level*4) WHERE level>19 AND STR>(level*4) AND id>1000 AND id<800000;
UPDATE npc_types SET STA=CEIL(level*4) WHERE level>19 AND STA>(level*4) AND id>1000 AND id<800000;
UPDATE npc_types SET DEX=CEIL(level*4) WHERE level>19 AND DEX>(level*4) AND id>1000 AND id<800000;
UPDATE npc_types SET AGI=CEIL(level*4) WHERE level>19 AND AGI>(level*4) AND id>1000 AND id<800000;
UPDATE npc_types SET _INT=CEIL(level*4) WHERE level>19 AND _INT>(level*4) AND id>1000 AND id<800000;
UPDATE npc_types SET WIS=CEIL(level*4) WHERE level>19 AND WIS>(level*4) AND id>1000 AND id<800000;
UPDATE npc_types SET CHA=CEIL(level*4) WHERE level>19 AND CHA>(level*4) AND id>1000 AND id<800000;
UPDATE npc_types SET ATK=CEIL(level*(9+(level/10))) WHERE level>19 AND ATK>(level*(9+(level/10))) AND id>1000 AND id<800000;
UPDATE npc_types SET MR=CEIL(level*1.50) WHERE level>19 AND MR>(level*1.50) AND id>1000 AND id<800000;
UPDATE npc_types SET CR=CEIL(level*1.50) WHERE level>19 AND CR>(level*1.50) AND id>1000 AND id<800000;
UPDATE npc_types SET DR=CEIL(level*1.50) WHERE level>19 AND DR>(level*1.50) AND id>1000 AND id<800000;
UPDATE npc_types SET FR=CEIL(level*1.50) WHERE level>19 AND FR>(level*1.50) AND id>1000 AND id<800000;
UPDATE npc_types SET PR=CEIL(level*1.50) WHERE level>19 AND PR>(level*1.50) AND id>1000 AND id<800000;
UPDATE items SET name=REPLACE(name, '(Test)', '');
These were taken from the following .SQL file, which I run on a basic server install to make it solo friendly. Feel free to change it to meet your own needs.
https://drive.google.com/file/d/16iq...ew?usp=sharing