so you want to edit npc's

[GeorgeS]

Tonight and thursday nite beta testing is continuing

So far the bugs I found were easily found and fixed.
Creating new merchants work very well so far, add/delete sell items as well.
Spawning custom npc's and npc camp spawns will be tonights focus.
If all goes well then by friday the app will be released.


I also updated the help file
Here's the link to the tuts/help
http://www.wizardportal.com/optimaiv...ial/excel.html


edit -
Thursday nite was a success. I created merchants and they showed up correctly. Also, created a spawn group of spectres in sro tower, even made a named pop up randomly, and that worked perfectly.

George

[Belfedia]

This program can't work without excel ?

[GeorgeS]

It uses Excel. That's correct. I cannot program spreadsheet functionality easily in VB6. One thing I am slightly concerned about is differences between excel XP vs. excel 2K. I prolly should test it on the XP machine...


-edit
fixed some issues and the utility works as I meant it to.
Found lot's of merchants with missing merchant_id's. Added a utility to fix that and populate their lists with 20 common items.
Everything works well. I am working on the help file and should have a release later today/tonight

GeorgeS

[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