Modifying NPC's stats?

[shabasky]

Hey I have my own server and I am using Arcemu's server for 3.3.3

Does anyone know how I can modify npcs so that they have higher stats and are able to attack people that only attack others? eg. alliance attacks horde or wolf goes by

[Laniax]

You'd have to change the stats and factions in your creature database.

[shabasky]

And how would i access the dabase? I can only access world settings and relmconfig...

[stoneharry]

ArcEmu loads all of it's data from the databases.

You can access the databases with a program such as SQLyog or Navicat.

You will have a SQL server currently running already, which you should know the username and password to as you put them into your configurations. Using the database program, create a new connection, host: localhost, port: 3306, username: root, password: whatever yours is, leave databases blank.

Once you are into the database, you can see several databases. You need to go into the world database and into creature_proto. From there you can find the creature and change everything. Creature_proto corresponds to creature_names.

I advise you have a look through the database and look at how everything is structured and experiment with it.

You can change all the npc's at once by running a SQL query, for example:

UPDATE `creature_proto` SET `faction` = '21' WHERE `faction` = '20';