[GUIDE] NPC appear as Boxes quick fix menu

User Tag List

Results 1 to 4 of 4
  1. #1
    Algorithm's Avatar Knight-Captain
    Reputation
    175
    Join Date
    Mar 2008
    Posts
    395
    Thanks G/R
    0/1
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    [GUIDE] NPC appear as Boxes quick fix

    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

    Code:
    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

    Code:
    UPDATE `creature_names` SET female_displayid = 0 WHERE `entry` BETWEEN '50000' and '50048';
    Code:
     UPDATE `creature_names` SET male_displayid2 = 0 WHERE `entry` BETWEEN '50000' and '50048';
    Code:
    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.
    Last edited by Algorithm; 05-17-2008 at 11:42 PM.

    These ads disappear when you log in.

  2. #2
    EatUrBrains's Avatar Knight-Champion
    Reputation
    55
    Join Date
    Jan 2007
    Posts
    504
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    not bad ill try it...
    NoT A ZomBie~BuT iLL~EaTuRBrainS

  3. #3
    Algorithm's Avatar Knight-Captain
    Reputation
    175
    Join Date
    Mar 2008
    Posts
    395
    Thanks G/R
    0/1
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    thats what fixed my npc boxes problem so enjoy!

  4. #4
    Power of Illuminati's Avatar Contributor
    Reputation
    179
    Join Date
    May 2008
    Posts
    1,410
    Thanks G/R
    6/2
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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?

    Code:
    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';

Similar Threads

  1. NPC appears as a box
    By Algorithm in forum World of Warcraft Emulator Servers
    Replies: 6
    Last Post: 05-19-2008, 02:26 PM
  2. [GUIDE] NPC appear as Boxes quick fix
    By Algorithm in forum WoW EMU Guides & Tutorials
    Replies: 1
    Last Post: 05-18-2008, 03:48 PM
  3. Guide Getting to Gm Box Under Gm Island Cords
    By TripZone in forum WoW EMU Guides & Tutorials
    Replies: 9
    Last Post: 03-14-2008, 11:07 PM
  4. [Guide] NPC factions and commands
    By Denelly in forum WoW EMU Guides & Tutorials
    Replies: 4
    Last Post: 11-02-2007, 09:03 PM
  5. Guide for Cheat engine Hacking.. quick and easy
    By edestron in forum World of Warcraft Guides
    Replies: 8
    Last Post: 02-22-2007, 12:30 PM
All times are GMT -5. The time now is 11:02 PM. Powered by vBulletin® Version 4.2.3
Copyright © 2021 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search