[ascent] easy way to modify elite/boss monsters hp/damage???

[jpxtreme]

I've used ascent for my 2.3.0 client for quite a while. I would like to know if there is an easy way to modify creature settings like the one from Mangos where you could easily modify it on the conf file.

Editing db manually is not my option. Is it possible to achieve this through query? But I don't know how.

I hope someone could share his/her way for this.

[iWoW-Programming]

Well, first off it would be helpful to know why you can't edit the DB manually, a query would require us to know your db creature_proto table's structure and it would be very hard to do this through only a query, if you were using a 3.3.5 db i could help you a bit more, but if you can run like

SELECT * FROM `creature_proto` WHERE `id` = ***ENTER BOSS NPC ID HERE***;

this plus the table structure would allow us to write you a query,

alternatively you could use an update command like this, but once again table structure would be helpful.

UPDATE `creature_proto`
SET `minhealth`=5000000, `max_health`=5000000, `mindamage`=75000, `maxdamage`=100000
WHERE `id`=***BOSS NPC ID HERE***;

[thetrueman2]

or assuming you can run queries you can multiply values like with the config files.

UPDATE creature_proto
SET minhealth = (minhealth * 2), max_health = (max_health * 2), mindamage = (mindamage * 2), maxdamage = (maxdamage * 2)
WHERE boss > 0;

What this does is multiply the minhealth, maxhealth, min and maxdamage by 2 for all mobs that are flagged as boss (1 or above). But like the above post sais it would help to have the table structure

[jpxtreme]

thank you!