[GUIDE] NPC appear as Boxes quick fix

[Algorithm]

Basicaly i had this problem myself, and this is an easy and fast fix for that.

if you recently upgraded to latest revisions , you might encountered that some of your vendors or npcs , appear as small blue and white boxes, now thats because new revisions cannot have 1 in the following collumns that you see in my SQL fix

UPDATE `creature_names` SET male_displayid = 10913 WHERE `entry` BETWEEN '50000' and '50048';

10913 is the displayid , so change that to whatever displayid are of your vendors

UPDATE `creature_names` SET female_displayid = 0 WHERE `entry` BETWEEN '50000' and '50048';

 UPDATE `creature_names` SET male_displayid2 = 0 WHERE `entry` BETWEEN '50000' and '50048';

UPDATE `creature_names` SET female_displayid2 = 0 WHERE `entry` BETWEEN '50000' and '50048';

- 50000 and 50046 is the spawn ids for my vendors - so change the values in orange according to your database.

[EatUrBrains]

not bad ill try it...

[Algorithm]

thats what fixed my npc boxes problem so enjoy!

[Power of Illuminati]

You could just do like this too, it's good but as it's the 1 that bugs for all NPCs, why not only change 1 -> 0?

UPDATE creature_names SET male_displayid2 = '0' WHERE male_displayid2 = '1';
UPDATE creature_names SET female_displayid2 = '0' WHERE female_displayid2 = '1';
UPDATE creature_names SET male_displayid = '0' WHERE male_displayid = '1';
UPDATE creature_names SET female_displayid = '0' WHERE female_displayid = '1';