Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::Database/World Building

Development::Database/World Building World Building forum, dedicated to the EQEmu MySQL Database. Post partial/complete databases for spawns, items, etc.

Reply
 
Thread Tools Display Modes
  #1  
Old 09-01-2007, 04:11 AM
froglok23's Avatar
froglok23
Hill Giant
 
Join Date: May 2005
Location: Australia
Posts: 113
Default What Tools can be developed to help world building?

Hi all,

I’d like to know some ideas for tools which could be developed to ease database populating.

my first thought was an application, which showed the map (much the same as the map inside of EQ) but on a larger scale, where you could set NPC's pathing, something like click on a point, then another point, then another point, then set delays, timers, triggers. Something along them lines.

Now I’m happy to write something like this, but in order for me to, if someone who is family with zones/maps from a code point of view could liaise with me, We could get it done much quicker.

So please, submit your WELL THOUGHT OUT ideas and suggestions here, the more tools we write to do replace manually doing things, the less the error rate will be and the better the end result will be.

- froglok
Reply With Quote
  #2  
Old 09-01-2007, 04:26 AM
froglok23's Avatar
froglok23
Hill Giant
 
Join Date: May 2005
Location: Australia
Posts: 113
Default Idea's

Suggestion: Adding Loot to a NPC application

An updated version of my original tool I wrote to add look to a NPC. Now I think we can make it more flexible and more powerful, eliminating any errors which come from doing it manually.

Suggestion: Adding of NPCs to zones

A tool, which allows you to create a NPC visually... maybe WC can help with this as to put support in to see visually how the NPC will look Could this also be combined with adding loot to the NPC?

Possibility just having a NPC Editing Application, which does everything for NPC's

Suggestion: Quest Writer application

Something sumular to what the SQL builder applications are. It would allow you to construct your quests, add in default event handles. Would also have a "syntax checker"


They just came to be

- froglok
Reply With Quote
  #3  
Old 09-01-2007, 05:47 AM
froglok23's Avatar
froglok23
Hill Giant
 
Join Date: May 2005
Location: Australia
Posts: 113
Default

Well this will teach me for posting completly in the wrong section.

Seem that we already have a quest writer and NPC application. Sweet!

Id still like to here suggestions on what others we can have to life easier.

- froglok
Reply With Quote
  #4  
Old 09-01-2007, 01:56 PM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,474
Default

Hey Frog, one of the best tools I could imagine that have not been made is a visual map 2D, NPC spawn tool, similar to what you've described.

We would need how to take a zone, create a 2D top down view.
Then select a NPC, point to where you want to spawn it.
Grid/paths can be displayed as well if there's one.
Create grids/paths on the fly by mouse pointing around.

I know the S3D files contain geometry details and then there's the zoneconverter source code which is on my site.

I've debated on how to write this, but without x,y,z data, it's much harder. I.e working from a top down screen capture of the zone.


GeorgeS
__________________
Your source for EQ database tools
Toolshop is open for business


http://www.georgestools.chrsschb.com//
Reply With Quote
  #5  
Old 09-01-2007, 11:14 PM
gernblan
Discordant
 
Join Date: Aug 2006
Posts: 394
Default

Anything that can get us into eqg files would be a big help.

Fixing azone would rock, also.
__________________
--
Keelyeh
Owner, ServerOp and Developer
Jest 4 Server
Linux (Jest3 runs on Fedora, our Dev servers usually run on Ubuntu and/or Gentoo), OC-12 Connection = Hella Fast
Reply With Quote
  #6  
Old 09-01-2007, 11:15 PM
gernblan
Discordant
 
Join Date: Aug 2006
Posts: 394
Default

IN other words... any of the tools out there that only work with 3sd files .. well, with Anniversarry support coming... we're all going to need some good zone tools that work with eqg files.
__________________
--
Keelyeh
Owner, ServerOp and Developer
Jest 4 Server
Linux (Jest3 runs on Fedora, our Dev servers usually run on Ubuntu and/or Gentoo), OC-12 Connection = Hella Fast
Reply With Quote
  #7  
Old 09-02-2007, 02:29 AM
John Adams
Demi-God
 
Join Date: Jul 2006
Posts: 1,552
Default

I am a huge fan of GeorgeS' toolset... but one thing I do not like about them is the interface (sorry George ). The fact you cannot resize, and it requires all these ocx registers, and odbc drivers. I do not think an all-in-one tool is necessary, but what GeorgeS has already done is a great big help. His NPC Editor is pretty good, but putting all that info on the index line is hard to wrap your mind around. It should be a selectable list with a sub menu or modal window to work on the NPC. In all honestly, if someone could C# the PEQEditor (the web-based one), that would ROCK.

I also like Georges Quest Editor, with the built-in samples. But, I find myself using the other one (not Georges I think?). It is really nice - but the text area itself is horrid. I am not sure if it is because there is a word-wrap feature, but just moving the cursor around, copy/cut/paste, delete key or backspace, the cursor flies all over the line and starts deleting things you don't want gone. Also, the save/reload are iffy - though they work, they are sorta destructive (no "are you sure you want to toss out all your work without saving?" prompts).

Those are really the 2 tools I use the most (and I LIVE in PEQEditor.php). Then of course, there's the OpenZone stuff. But a single-source "suite" of applications to maintain everything? Shit yeah. Sign me up. I have made a request for other useful addons like dynamic (usable) server status export from the World/Zone itself... but a GUI server management app would also be nice.

Ok, there's a bunch of rambling in a not-so well thought out manner. Sorry, it's been a long day. If this becomes a reality, I'll be far more interested in giving specific details.
Reply With Quote
  #8  
Old 09-02-2007, 02:40 AM
Sakrateri's Avatar
Sakrateri
Dragon
 
Join Date: Mar 2004
Location: England
Posts: 776
Default

A top down npc editor would be cool, the mapmaker in Openzone give you a picture of the map which includes polys and topography but besides in openzone I don't know how to view those maps. Anyway that would probably be the way to go , just have to ask WC if using that tool would be possible.
__________________
KhepriGames

Game Gallery

My Forums

Reply With Quote
  #9  
Old 09-02-2007, 03:05 AM
froglok23's Avatar
froglok23
Hill Giant
 
Join Date: May 2005
Location: Australia
Posts: 113
Default

Hi all,

I download GeorgeS tool and they are great, but sryr toi say i do have do agree the the UI coudl do with some work.

GeorgeS check your PM. I’m willing to move them over to .NET (mainly because it really suits small apps which a nice UI) and can provide a great amount of flexibility..

All of which I’m willing to do at no dev time to GeorgeS at all

However, GeorgeS please be my guest to refuse such help as I won’t be offended at all. They are GREAT tools

Well done!


Umm, what’s this Anniversary support i hear of? Are we changing from titanium? Hmmm

- froglok
Reply With Quote
  #10  
Old 09-02-2007, 04:24 AM
John Adams
Demi-God
 
Join Date: Jul 2006
Posts: 1,552
Default

Quote:
Originally Posted by froglok23
Umm, what’s this Anniversary support i hear of? Are we changing from titanium? Hmmm
We are [hoping] to switch to the newer package deal from SOE, since titanium itself is becoming hard to obtain. Seems only logical. There is some work beginning on it, showing up in the Emu sources as "Anniversary.cpp" and the opcode patch files. I can't say it's a super push, because I cannot believe we're ready for all the new zones and functionality - considering the current progress is still 5 years behind.
Reply With Quote
  #11  
Old 09-02-2007, 04:55 AM
froglok23's Avatar
froglok23
Hill Giant
 
Join Date: May 2005
Location: Australia
Posts: 113
Default

Agreed, In my opinion, with the current level of functional code currently, I dont think the code base is ready for it. Sorry but thats jsut my opinion.

Its my opinion that we stick to Titianium, however, I do see the logic sense in the move. But I think its something which could be done, IF the case base was more along (functionaity wise).

Just my 2cp though

- froglok
Reply With Quote
  #12  
Old 09-02-2007, 12:01 PM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,474
Default

Regarding the UI for my tools - well that came from years ago when I started to make these tools and had to make them different, but with an true EQ-'esque' feel. Back then the old item editor actually worked with 0.6.6, and when I decided to create the newer version, we went to 0.7.0 and the new version broke the editor. Alas, I came to the rescue, and the UI for the tools was born.


Anyway, back to the topic. This spawn editor needs writing as it will make this task so much easier. I have all the world building and coding experience, but have not figured out how to get the zone loaded.
One possibility is to export the zone as an .obj and go from there, but not all zones can be exported. My feeling is when you make your own zone in OZ, then you should be able to quickly spawn.

GeorgeS
__________________
Your source for EQ database tools
Toolshop is open for business


http://www.georgestools.chrsschb.com//
Reply With Quote
  #13  
Old 09-24-2007, 03:44 PM
ArChron
Fire Beetle
 
Join Date: Dec 2006
Location: Vienna
Posts: 28
Default

[QUOTE=froglok23;137852]Hi all,
I
Reply With Quote
  #14  
Old 09-24-2007, 03:45 PM
ArChron
Fire Beetle
 
Join Date: Dec 2006
Location: Vienna
Posts: 28
Default

(Sorry, Firefox/the web/something ate my last post... I'll redo)

.NET? Ack... and I just started moving over to Ubuntu linux to avoid M$...

Ruby on Rails can develop some wickedly fast and simple web-based apps. The framework does tons for you, and simple CRUD operations come out of the box with a script/generate scaffold command... for a single user, the Webrick server is adequate to host it on your own machine as well.

The default implementation does do an awful lot of DB traffic to render some simpler views, but I just create a view in the DB, then build a model to access the view.

Hmm.. I might just have to do a "proof-of-concept" for myself, but that has to come after I complete bootstrapping a QA database for work... Ruby, Ruby on Rails, MySQL, Mongrel clustered app server, Apache front-end... all open source, but none of the tools is currently used/"approved" by the software development tools/IT shop. *sigh*

I assume there's no issue if I clone your work GeorgeS? Time for some late nights with Moody Blues and Lagavulin... Hmm.. maybe not the Lagavulin part... I tend to write code I can't figure out a week later...
Reply With Quote
  #15  
Old 09-24-2007, 03:58 PM
ArChron
Fire Beetle
 
Join Date: Dec 2006
Location: Vienna
Posts: 28
Default

ED: RoR works for Windows as well... Mongrel cluster isn't happy on Windows, but the basic RoR app works fine there as well... so it's cross-platform capable.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 01:19 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3