|
|
|
 |
|
|
 |
|
 |
 |
|
 |
 |
|
 |
|
| Development::Database/World Building World Building forum, dedicated to the EQEmu MySQL Database. Post partial/complete databases for spawns, items, etc. |
09-28-2005, 05:14 AM
|
|
Forum Guide
|
|
Join Date: Sep 2003
Location: California
Posts: 1,475
|
|
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
Last edited by GeorgeS; 09-28-2005 at 01:43 PM..
|
09-28-2005, 06:37 AM
|
|
Dragon
|
|
Join Date: Dec 2003
Location: Earth
Posts: 818
|
|
h
Quote:
|
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. |
09-28-2005, 08:54 AM
|
|
Sarnak
|
|
Join Date: Jul 2004
Location: Oregon
Posts: 69
|
|
Will this automate serialization of items for the ignorant noobs like myself? 
__________________
"Always move twice"
-Bruce Juchnik Hanshi
|
09-28-2005, 06:57 PM
|
|
Forum Guide
|
|
Join Date: Sep 2003
Location: California
Posts: 1,475
|
|
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
Last edited by GeorgeS; 10-09-2005 at 03:08 AM..
|
10-08-2005, 07:07 PM
|
|
Forum Guide
|
|
Join Date: Sep 2003
Location: California
Posts: 1,475
|
|
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
Last edited by GeorgeS; 10-09-2005 at 10:55 AM..
|
10-09-2005, 01:14 AM
|
 |
Hill Giant
|
|
Join Date: Sep 2004
Posts: 100
|
|
Quote:
|
Originally Posted by GeorgeS
no need to re-invent the wheel..
|
check my sig
__________________
The PEQ Database Editor is available!
Edit Loot, NPCs, Spawns, Merchants, Factions, NPC Spell Lists, and Tradeskills with ease!
Check it out!
|
10-09-2005, 08:22 AM
|
 |
Sarnak
|
|
Join Date: Feb 2005
Location: Behind you....
Posts: 84
|
|
Well if GeorgeS doesn't need to use a "http server with php". I'm all for GeorgeS.
|
10-09-2005, 08:43 AM
|
|
Demi-God
|
|
Join Date: Jan 2005
Posts: 1,109
|
|
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 ?
__________________
__________________________________________________ _____________________________________
I speak english like a spanish cow..., I speak spanish like a english pudding...
But I try to speak good french !!! (Non au langage SMS sur forum)
http://eqfroggy.new.fr : Froggy French Server Website.
|
10-09-2005, 08:40 PM
|
|
Forum Guide
|
|
Join Date: Sep 2003
Location: California
Posts: 1,475
|
|
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
Last edited by GeorgeS; 10-10-2005 at 09:52 PM..
|
10-10-2005, 01:49 AM
|
|
Demi-God
|
|
Join Date: Jan 2005
Posts: 1,109
|
|
This program can't work without excel ?
__________________
__________________________________________________ _____________________________________
I speak english like a spanish cow..., I speak spanish like a english pudding...
But I try to speak good french !!! (Non au langage SMS sur forum)
http://eqfroggy.new.fr : Froggy French Server Website.
|
10-10-2005, 02:46 AM
|
|
Forum Guide
|
|
Join Date: Sep 2003
Location: California
Posts: 1,475
|
|
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
Last edited by GeorgeS; 10-11-2005 at 07:38 PM..
|
10-27-2005, 04:39 AM
|
|
Forum Guide
|
|
Join Date: Sep 2003
Location: California
Posts: 1,475
|
|
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
Last edited by GeorgeS; 11-09-2005 at 01:45 AM..
|
01-06-2006, 04:03 AM
|
|
Fire Beetle
|
|
Join Date: Dec 2005
Posts: 15
|
|
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.
|
 |
|
 |
01-06-2006, 06:53 AM
|
|
Discordant
|
|
Join Date: Apr 2004
Location: Gukta
Posts: 359
|
|
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.
__________________
THE POSTER assumes no warranty, guarantee, or representation as to the accuracy
or sufficiency of the information presented herein, and THE POSTER assumes no
responsibility or liability regarding the use or misuse of such information.
Furthermore THE POSTER assumes no responsibility and makes no warranty, guarantee,
or representation for the content of any web or FTP sites linked to or from this
post.
THE POSTER reserves the right to change the terms, conditions, and notices under
which THE POSTER presents information. It is the responsibility of THE READER to
regularly review these terms, conditions, and notices. THE READER understands that
the reading of any content including or covered by this disclaimer constitutes THE
READER's acceptance of and agreement to such changes.
THE POSTER retains the right to in any way alter the content of this post at any
time with or without prior notice to THE READER.
|
 |
|
 |
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -4. The time now is 02:52 PM.
|
|
 |
|
 |
|
|
|
 |
|
 |
|
 |
Linear Mode
