Change npc display id's

**Rednexx** · 11-22-2007

Hello,

I thought i'd give you a few cool display id's for your mall and aswell post the
cmd too so that you dont have to edit all the npcs you wana change the display
id on. This is basicly for Julianx shopping mall v2.3 but you may just edit the
cmd if you use somone elses mall or wana change the ID of some other npc's so
here it is, just copy and paste the code on a .txt or sql file and execute it in
Sql yog, navicat or whatever program you use.

Code:

UPDATE creature_names SET male_displayid = '18928' WHERE entry BETWEEN '60000' and '60080';

Code:

UPDATE creature_names SET male_displayid = '19645' WHERE entry BETWEEN '60000' and '60080';

Code:

UPDATE creature_names SET male_displayid = '19292' WHERE entry BETWEEN '60000' and '60080';

Code:

UPDATE creature_names SET male_displayid = '19051' WHERE entry BETWEEN '60000' and '60080';

Code:

UPDATE creature_names SET male_displayid = '9994' WHERE entry BETWEEN '60000' and '60080';

If your npc's you wana change the display id on is different from the once
i've puted in the cmd then just change em like so

UPDATE creature_names SET male_displayid = '<display ID>' WHERE entry BETWEEN '<npc id>' and '<npc id>';

Pretty easy, but i do recommend using Julianx shopping mall. Best mall ever.
hope this helps, thanks.