Dungeon Changes.

[hav0kZA]

Hello,

I'm pretty new here as you can see (0 rep =[), and have come forward with a question that i'm hoping some of you db gurus can help me out with.

Atm getting an affordable internet connection to your home over here in SA is pretty impossible or atleast until the new telecoms provider is all set to go, anyway.. loads of my friends at school that do not have the privilige to go online and play WoW on the internet want to have some of the fun too! the problem is its no fun playing WoW by yourself and not being able to do the dungeons and really experience PvE fun.

So I came up with a solution but I have NO idea on how to implement it. I want to try and make the bosses easier , ie bosses on normal should have 25% of original HP, hit 45% less and spawn less adds etc ( I plan on keeping the Heroics tough but should be doable with 3-5 people minimum). So what would the best way be to implement this solution?

Other suggestions are welcome ( Please just keep in mind I would like to to keep the game as authentic as possible so adding Custom items are at the botom of the list).

Thank you =]

[stoneharry]

On a ascent based emulater,
.npc info
the creature you want to change and the creature id (not guid) or
.lookup creature name
and get it's id there.
Now you get the id using SqlYog you can use this query:
SELECT *FROM `creature_proto` WHERE `entry` = '';
and put the id in the '' on the end. Hit execute query and you'll get your results.
Change to edit mode, edit the hp / damage of the creature etc, then hit save.
Restart your server, and all is good!

[hav0kZA]

Ahh yes I thought about doing that , but would be very time consuming. Isnt there some way I could write a script that would change all the values of all elite and rare mobs in the Db?

[stoneharry]

UPDATE `creature_proto` SET `minhp`= '1' WHERE (`boss`='1');

That would update the creature proto to set minhp (need to find the correct columb name) to 1 where there boss columb is set to 1 (as in it's flagged as a boss).

[The-Eradicator]

Take a look at this thread.

Untested, you can try this. It will make every monster in the game weaker. Keep in mind you still won't be able to solo most boss encounters. Spells still do normal damage. You'll have to edit your core for that.

UPDATE creature_template SET `minhealth`=`minhealth`/40, `maxhealth`=`maxhealth`/40, `minmana`=`minmana`/40, `maxmana`=`maxmana`/40, `mindmg`=`mindmg`/40, `maxdmg`=`maxdmg`/40, `attackpower`=`attackpower`/40, `rangedattackpower`=`rangedattackpower`/40 SELECT * FROM creature_template;