Changing Subnames

[jackthripper]

Anyone remember what the query was to change the subnames of custom NPC's? I have a whole mall that I have to change to a diferent name.

[Ickybad]

Select entry id - entry id of your mall vendors then select the subname column for the creature_names table and update them all to what you want its not hard .

[jackthripper]

Editing the submane column wont change the subname ingame.

[Scubast3ve]

If you edit the subname of an npc in the creature_names table in your db you will have to reload your db to see these changes. There used to be a command on mangos that did that but not anymore so gl

[Linkn]

Also delete the cache folder in your World of Warcraft folder. Don't worry the folder remakes itself when you start wow. All the creature info is stored there like mob names and such.

[Gastricpenguin]

Also delete the cache folder in your World of Warcraft folder.

This. (filler)