Modifying SQL Creature names.

[Nicholax80]

Ok so, I've been trying to go through my HeidiSQL to change my custom vendors names and what-not, but I cannot find them. I've accessed all the files but the filter cannot find the Entry IDs nor the NPC name itself.

What I'm trying to do, is change the vendor names and add subnames to custom NPCs. They're already on my server/database but I can't find them in the DB/SQL to do so.

Does anyone have any ideas? I'd really love not to have to make new NPCs.

[Maisteri]

Are you sure you are looking at the right tables? The tables usually start with creature_

[Nicholax80]

Yes I have looked in all of those files. For shits and giggles I even looked in all of the gameobject_ files. Nothing. I know I have the vendors in my SQL/DB somewhere because I downloaded them from this website and it was a .rar file. I ran them through my HeidiSQL and I can spawn them in-game. I just want to change the names, subnames, and displayIDs.

[Link_S]

WRONG SECTION I BELIEVE!

Changin' the name of a creature isn't hard, if you know the creatures id it's fairly easy to fetch the sql row.

select * from creature_names where id = <id>

You can also use the 'update' option to run a sql query to change it for you, I'd provide an example of that if I just remembered the column name in the table. :S

If you can't find it, I guess it isn't in there.