so you want to edit npc's

[GeorgeS]

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

[sdabbs65]

Originally Posted by GeorgeS

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

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

[Koshoji]

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

[GeorgeS]

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

[GeorgeS]

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

[mystic414]

Originally Posted by GeorgeS

no need to re-invent the wheel..

check my sig

[Ghost Fire]

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

[angelow]

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.

[mikenune]

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.

[angelow]

Ok, so i have the whole program up and running, which btw is fantastic. I can not however properly do step 2 of the tutorial. I do not ever get the loottable-id opened. I can only see the top bag.... cant create more bags.... im sure its a simple thing. If some one could just tell me what I have to do to get that small window to the left of the bag viewer (so that I can choose what bag im viewing) i would be set.

[GeorgeS]

The 2 windows you want (to display the details) are activated by double-clicking. Select a row in one of the two windows and double click to open show the pop-ups.

...new lootdropid's are created by clicking on the button 'add new lootable id'
and this new # will appear in the sheet in cells between merchant_id and regen_rate cells. Click on the loottable id and the contents should appear in the two windows.

GeorgeS

[angelow]

Ok, I can see the right of the two tables, always could. I can double click that and get the pop up menu, always could. Nothing i do will bring up the left table however. The one that allows me to select what "bag" I am looking in for the monster. I have tried double clicking, entering, or just spazzing on the loot table id # (i realize that is the number that tells it what "bags" to include) but I can not ever get that smaller blue window to open. It is just a yellow background.

I am using excel 2003 on windows XP

Thanks