edit npc's - program development
 

I am just finishing a big utility suite to-

add/delete and edit npc's and search by partial name
add/delete and edit npc loot tables
create and edit custom spawns anywhere
item <-> item_id lookup
backup/restore eq database

-Working on finishing tutorials and guide on how to use this package
-Testing/debugging the spawn code today
-Writing eq database backup/restore code

This is a large collection of works all assembled in one package.
There are lot's of other interesting things in the works...

Should be released this weekend ..if all beta testing goes well
..source code released as well..

GeorgeS

h
 

Looking forward to testign that out....
we can use a good spawner tool.

Will this automate serialization of items for the ignorant noobs like myself? :)

serialize
 

That applies to items. This does not edit items - Use Mangoo's item editor - no need to re-invent the wheel..

Ok, the help/tutorial is practically complete -
Here's the link to the tuts
http://www.wizardportal.com/optimaiv...ial/excel.html

I am testing the app now and in beta stage for the week.

Let me know if there's stuff you want added.

...things like explanation of merchants, spells, npc special attacks etc...
Editing items is low in the priority list.

Anyway, so far the app works very well and it's super fast for spawns and making npc's. After the beta, I will release the program...stay tuned

georgeS

merchants code
 

Just an update on what I'm working on now -

-Writing eq database backup/restore code - done! see this link
http://www.eqemulator.net/forums/showthread.php?t=19490

-Writing Merchant tools (Edit/Delete/Create Merchants VERY EASILY!) -done!
-Working on finishing tutorials and guide on how to use this package -done!

-Adding code to RANDOMISE merchant sell stuff
This works by running some code which adds roughly
1-10 common items
1-10 medium rare items
1-10 rare stuffs
Each time it's run, the merchant sell lists are updated!
Works very well and is tested.
Customizable in every respect...
50% Done

-Roaming Mobs - Tired of seeing static mobs - well this editor should fix that.
0% Done

Just a heads up

Package should be released fri. nite! - pending no big problems..

GeorgeS

check my sig

Well if GeorgeS doesn't need to use a "http server with php". I'm all for GeorgeS.

I'm not for anyone,

Editor from georges is usefull for windows and local use :)
Editor from mystic is good for windows, linux and internet use :)

The two are good :)

Mangoo's editor working with current version ?

beta testing
 

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

This program can't work without excel ?

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

release
 

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

update
 

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

only one problem so far
 

When I attempt to type in text it will not take it.... opening the file for editing tells me i have an incompatible version of excel. I have Microsoft Excel Viewer 2003. I am sure its something stupid that I am doing.... if you could just let me know what that was.

Was wondering if the version of excell i downloaded is a viewer and wont let me edit? or is it the year that is wrong? Thanks in advance.

That "Excel is required" thing is kinda a deal breaker for me. I don't have Excel on my computer at all. In fact, I don't any microsoft office programs on my computer!

I use OpenOffice.Org for all my document and spreadsheet needs.

I realize that doing so at this point would most likely require a major overhaul of your code, but you should look into using an embedded MySQL database engine or something like SQLite instead of Excel to store your data.