Adjusting damage rates for all Mobs

[psychonaut]

Hi all.

Im hoping someone could tell me what SQL command i would use for increasing all creature min and max damage by 1.5. Basically the players on the server are overpowered compared to the mobs they are fighting so I was trying to increase these values to bring it more into line but i just cant find what SQL command i use.

I would also like to do something similar with the pricing of vendor items to create a moneysink as the in economy is out of whack atm.

Cheers,

[CairiFEA]

there is no command to directly modify the damage of the mob in the database from ingame,

however, you can temp. modify the HP with the simple command,

.mod hp (min) (max).

To do this in SQL, open up your client, open the creature Proto and manually change the damage values. Or...decrease the power of your players.

Cairi

[T O X I C]

in game command
target mob then write .mod damage 50 50 -- (example)

[Meltoor]

I think he was asking for a command which makes every variables in the Damage row to be x1.5, thou I don't know if there is an SQL command for it, maybe .

[metehan]

I am sure there must be a query for this. I will try to find it on the weekend for you.

there is no command to directly modify the damage of the mob in the database from ingame,

however, you can temp. modify the HP with the simple command,

.mod hp (min) (max).

To do this in SQL, open up your client, open the creature Proto and manually change the damage values. Or...decrease the power of your players.
Cairi

Sorry, but I that would take... a damn long time.

[metehan]

double post sorry
Delete this.

[psychonaut]

Hi guys,

Sorry if I wasnt clear enough. Yes I am looking for the SQL command that would use Creature_proto and select Min_damage and Max_damage and multiply the current values of the entire column by 1.5.

Cheers

[SectorSeven]

No you can do it
its like REPLACE something (range) something

I'm pretty sure but not 100%

[waymirec]

I've got a set of sql queries somewhere that I used to systematically go through and adjust ALL of the mobs within the game so that they are between level 70 and 90 with appropriate changes to their health, armor, melee/ranged dmg, gold drop etc... did it for an instant 70 w/ 80 cap server.

[psychonaut]

I think this works... To update mindamage x 1.5

SELECT mindamage,mindamage*1.5 FROM creature_proto;
update creature_proto
set mindamage = mindamage*1.5
where mindamage is not null