how to change Creature green to hostile or reverse

[marcosgue]

hi, well first sorry for my english.

i need to change a creature green to hostile with sql query i have a creature id but i dont know what i must change in table.

thanks.

[hellraiser990]

Theres to options, you can do a .mod faction xxxx ingame or sql query

Update `creature_proto` set `faction` = 'The faction' where `entry` = 'the entry';

[SectorSeven]

I would recommend changing it to faction 1684- Actor Evil

[marcosgue]

thanks a lot