[MaNGOS] All NPCs -> Level 19

[Facerolling]

This was posted before as modifying the creature_proto table, could anyone tell me which table I need to execute this script in to make all NPCs level 19?

I'm using the Elder's Repack if this helps, the world table is called "Elder2" and the Logon table is called "Elder2Logon" if this helps.

Sorry for my foolish nature, i'm quite new to Scripting/Coding and can't think of where the NPCs are stored.

[stoneharry]

You need to run a SQL query, I am not familiar with the mangos database structure so you will need to alter it to your needs. This is one I would use for Ascent based emulators:

UPDATE `creature_proto` SET `minlevel` = '19';
UPDATE `creature_proto` SET `maxlevel` = '19';

Just change the table names and the column names.

Edit: Just read that you don't know yourself the table, look for something like creature_structure or something, and see if it contains npc levels.

[hunuza]

In MaNGOS the table is called "creature_template".
So:

UPDATE creature_template SET minlevel = 19, maxlevel = 19;

But if you want this to be really useful, you probably also need to adjust at least health, mana and damage.

[Ground Zero]

In MaNGOS the table is called "creature_template".
So:

UPDATE creature_template SET minlevel = 19, maxlevel = 19;

But if you want this to be really useful, you probably also need to adjust at least health, mana and damage.

Last time I checked MaNGOS/Trinity automatically scaled HP to the NPC's level so that shouldn't be a problem.