Todo list for getting an interesting database

[Skylark13]

Hi everyone,

I got my EQEmu 0.6.0-DR2 server running, with the "Semi-complete fresh" database as stated here : http://www.eqemulator.net/databases_v6.php

Now, there's a few things I know are not complete in this database, but I'd appreciate if someone could just basically tell me if I'm missing things (I'm sure I am) and if possible, what I need to do to fix them. Basically, all this info is scattered on the forums, and I'd like to gather it here so it's easily accessible for people like me who just got into this crazy Everquest Emulator world...

Things I know or suspect have to be added or changed in the database :

• Some doors are duplicated. They open, and there's another solid door behind which doesn't open. To fix this, run the following:

  DELETE doors 
    FROM doors d1, doors d2 
   WHERE d1.id != d2.id 
     AND d1.doorid = d2.doorid 
     AND d1.zone = d2.zone;

• Some guards not helping the player, in particular in Greater Faydark. This seemed to be caused by three things :
  • Some guards have no entries in the npc_faction_entries table. A complete list would be hard to compile, but I'll try and get one.
  • The 0.6.0-DR2 build has a bug dealing with factions which is fixed in the current source in CVS. We'll see when that build can be made public in compiled form.
  • Your installation needs the .map files installed in a subdirectory called Maps so the guards will have line of sight to the mobs.
  
  
• Anything else?

Any additions people can make to this list will be added in an edit to my post. Thanks in advance.