|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Development::Database/World Building World Building forum, dedicated to the EQEmu MySQL Database. Post partial/complete databases for spawns, items, etc. |
04-19-2006, 04:14 AM
|
Fire Beetle
|
|
Join Date: Jan 2004
Posts: 21
|
|
So for those of us who don't own Excel, any other means to use this?
|
04-20-2006, 03:36 AM
|
I built it I will Support it!
|
|
Join Date: Jun 2005
Location: Michigan
Posts: 214
|
|
If you do not have Excel but you are running windows you can always take a peek at my Database editor.
You can download my editor at:
http://eqemu.sesmar.net/index.php?op...d=32&Itemid=38
For installation instructions please see this thread:
http://eqemulator.net/forums/showthread.php?t=19839
So far it supports Editing: NPC, Loot Tables, Spell Tables, Faction Tables and Server Variables.
I am currently in the process of reworking a lot of the backend on it and adding support for spawn groups.
I hope this helps.
|
05-04-2006, 05:29 PM
|
Forum Guide
|
|
Join Date: Sep 2003
Location: California
Posts: 1,475
|
|
Updated version 1.5.0
Newest version (1.5.0) now is 0.6.6 compatible. Just updated some code and refreshed the views. Remember Excel (Y2K/XP) is required...
Utility is here
http://66.159.225.58/eqemu/excel_eq/eq_database.zip
Worklog -
-Fixed zone spawn code
-Fixed the merchant code
-Updated menus to look cleaner
-Updated random merchant code
GeorgeS aka Mr.G
|
05-09-2006, 04:47 PM
|
Forum Guide
|
|
Join Date: Sep 2003
Location: California
Posts: 1,475
|
|
Update and new version
Just added some feature enhancements -
-Ability to load ALL npc's within a specific zone
-Ability to load a specific npc within all zones or within a specific zone
-Ability added to sort by level,npc name,npc id
-fixed small/minor issues. Speed of display refresh is much better
Search by NPC can be partial name searches.
Help is here
http://66.159.225.58/eqemu/excel_eq/excel.html
Utility is here
http://66.159.225.58/eqemu/excel_eq/eq_database.zip
again remember Excel for Y2K or XP is required.
GeorgeS
|
05-10-2006, 05:31 AM
|
Forum Guide
|
|
Join Date: Sep 2003
Location: California
Posts: 1,475
|
|
more - again
Just to let you know, I am pretty much done with the program as it stands, and will now start porting it to VB6 (not .NET). Code is identical to VBA, so porting should not be a big deal.
The big advantage is you will no longer need office/excel, and the program will be compiled. Other advantages are more robust functionality.
The program also allows very rapid NPC editing (adding/creating/modifying) - incl. very easy loot changes, way point (grids) editing, and merchant (adding/creating/modifying). This will all be preserved in the VB6 version.
As usual it's going to be open source for those who are interested...
FYI - the code in the Excel version is accessed via Alt-F11.
This news I hope is of interest to those especially who don't own Excel.
|
05-10-2006, 12:06 PM
|
Demi-God
|
|
Join Date: Jan 2005
Posts: 1,109
|
|
This version can be wonderfull if no more need excel
And Opensource is a very good idea !
__________________
__________________________________________________ _____________________________________
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.
|
05-11-2006, 05:01 AM
|
Hill Giant
|
|
Join Date: Aug 2005
Posts: 107
|
|
I love your product and this is an even greater improvement. I cannot wait!
|
05-15-2006, 05:48 AM
|
Forum Guide
|
|
Join Date: Sep 2003
Location: California
Posts: 1,475
|
|
progress...
Well, managed to nearly complete the 'NPC' editing and 'loot' editing portion over the weekend. I predict being 1/2way by this friday. Porting is actually pretty easy as both apps use similar syntax. I'm working on how to integrate all the functionality from the excel app seamlessly, and so far came across a solution to create several stand alone apps with a launcher that takes you to the various apps separately.
It works just like the excel version, but a bit better. The compiled version so far stands at about 80k! With luck, expect a release this weekend to test out.
GeorgeS aka MrG
|
06-13-2006, 02:01 PM
|
AX Classic Developer
|
|
Join Date: May 2006
Location: filler
Posts: 2,049
|
|
I have a question;
Concerning the the dropdown menu "Tools > NPC > Copy Existing NPC" , I get a copy of the NPC, but not in the zone in use. Is there a way to move it back to the zone it was duped in?
|
06-13-2006, 04:50 PM
|
Forum Guide
|
|
Join Date: Sep 2003
Location: California
Posts: 1,475
|
|
NPC's can be shared/re-used in any zone i.e certain bats can be found everywhere. So what you need to do is go into spawneditor and add that npc into the spawngroup, so yes you can but not directly in npc editor.
I think your question is valid, however I think adding that functionality is complex and may yield errors in the database.
I'm off now to make the spawneditor ready for 0.7.0-800 06/07/2006 build date.
-edit - now the spawneditor should be 0.7.0-800 compatible. A few feature enhancements such as error checking is added .
You can now type in the npcid and the program responds with npcname automatically.
Also, clicking on the npc row (in spawnentry grid) will populate the NPC_search pop-up and you can thereby search for the npc that way.
http://66.159.225.58/eqemu/GeorgeS_EqEmu_Files.zip
GeorgeS
Last edited by GeorgeS; 06-14-2006 at 01:45 AM..
|
|
|
|
06-13-2006, 11:09 PM
|
AX Classic Developer
|
|
Join Date: May 2006
Location: filler
Posts: 2,049
|
|
Quote:
Originally Posted by GeorgeS
NPC's can be shared/re-used in any zone i.e certain bats can be found everywhere. So what you need to do is go into spawneditor and add that npc into the spawngroup, so yes you can but not directly in npc editor.
I think your question is valid, however I think adding that functionality is complex and may yield errors in the database.
I'm off now to make the spawneditor ready for 0.7.0-800 06/07/2006 build date.
-edit - now the spawneditor should be 0.7.0-800 compatible. A few feature enhancements such as error checking is added .
You can now type in the npcid and the program responds with npcname automatically.
Also, clicking on the npc row (in spawnentry grid) will populate the NPC_search pop-up and you can thereby search for the npc that way.
http://66.159.225.58/eqemu/GeorgeS_EqEmu_Files.zip
GeorgeS
|
I still can't get it to run for me, I always get the same error on any version;
a runtime error followed by "unknown colum 'spawnentry.spawn_limit' in 'field list'
The version spawn editor I have is 06.08.01.
|
|
|
|
06-14-2006, 02:43 AM
|
Forum Guide
|
|
Join Date: Sep 2003
Location: California
Posts: 1,475
|
|
Found a bad sql query refering to the old db schema. This new version I just compiled works fine on my machine, but dl it and see if it works for you.
new ver# is 06.08.03, just released
GeorgeS
|
06-14-2006, 05:57 AM
|
AX Classic Developer
|
|
Join Date: May 2006
Location: filler
Posts: 2,049
|
|
Quote:
Originally Posted by GeorgeS
Found a bad sql query refering to the old db schema. This new version I just compiled works fine on my machine, but dl it and see if it works for you.
new ver# is 06.08.03, just released
GeorgeS
|
Hi- I tried the links, the must be down? post me a link when you can. and if you need a place to post your downloads, I have my own server here running for 6+ years now, you're welcome to some space.
Thanks
|
06-15-2006, 12:30 AM
|
Demi-God
|
|
Join Date: Jan 2005
Posts: 1,109
|
|
Quote:
Originally Posted by Angelox
Hi- I tried the links, the must be down? post me a link when you can. and if you need a place to post your downloads, I have my own server here running for 6+ years now, you're welcome to some space.
Thanks
|
Download working for me ???
__________________
__________________________________________________ _____________________________________
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.
|
06-15-2006, 12:55 AM
|
AX Classic Developer
|
|
Join Date: May 2006
Location: filler
Posts: 2,049
|
|
Quote:
Originally Posted by Belfedia
Download working for me ???
|
Hi, it is now thank you, although editor posted is same one from before.
Also, I noticed a small bug in the npc_loot_editor : if I search for an item with a " ' " in it, the program crashes. example: "Muramite's Sheild" ( I just did that, hehe!). This has been a small problem with all versions, on both database.
|
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 08:27 PM.
|
|
|
|
|
|
|
|
|
|
|
|
|