so you want to edit npc's

[GeorgeS]

10/8/05
edit - made it so setting up the Excel application is easier. Got rid of all those loadup errors. ver 1.3.3 is online -help/tutorials also made nicer...

You will need to make sure you have XP/NT/2K and Excel 2K or better
MyODBC 3.51 installed (included in 'eq back up tool' DL), and the .xls placed in your emu folder - where you keep your db.ini. When it asks for macros enabled, say yes. Code is accessed with alt-F11. Read help and how to check if it works first...
Backup your data please.

The Xl utility -
http://www.wizardportal.com/optimaiv...q_database.zip
Here's the link to the tuts
http://www.wizardportal.com/optimaiv...ial/excel.html



Also, my vb6/.NET table based eq back up tool - useful for backup/restoring specific tables...
Tool is found here
http://www.wizardportal.com/optimaiv..._db_backup.zip
Help (pdf) is found here
http://www.wizardportal.com/optimaiv...EQ_DB_Help.pdf



GeorgeS

[GeorgeS]

some added features -

grid-waypoint (pathing) editing
user lookup tools
many many little enhancements.

..i've been using this tool a great deal and so far been enjoying it.


As an addon to my Excel_eq database editor, I am releasing a utility (.exe)
that allows you to search the ITEMS table and identify items by class and type, etc...

It will also identify which NPC drops the item/s

get it here
http://66.159.225.58/uwe/eqitems.zip

...place contents anywhere, but you must put a copy of your db.ini in the folder.


GeorgeS