.com.unity Forums
  The Official e-Store of Shrapnel Games

This Month's Specials

Air Assault Task Force- Save $8.00
Bronze- Save $10.00

   







Go Back   .com.unity Forums > Illwinter Game Design > Dominions 3: The Awakening

Reply
 
Thread Tools Display Modes
  #1  
Old December 9th, 2006, 08:41 PM
NTJedi's Avatar

NTJedi NTJedi is offline
General
 
Join Date: Jun 2003
Location: az
Posts: 3,069
Thanks: 41
Thanked 39 Times in 28 Posts
NTJedi is on a distinguished road
Default Re: RFC: Dom3 DB


Yes the spreadsheet will be best so we can sort the columns easily. Also each unit trait should consist of three alphanumeric characters because using two or less can make it difficult to search for specific traits. For example the current unit list uses only "a" for aquatic and when searching for aquatic units the gamer has to manually scroll the list looking for a single "a" instead of using edit/find and typing "aq1" for aquatic.
Three alphanumeric characters should cover all possible unit traits.
__________________
There can be only one.
Reply With Quote
  #2  
Old December 9th, 2006, 10:34 PM
B0rsuk's Avatar

B0rsuk B0rsuk is offline
Second Lieutenant
 
Join Date: Mar 2004
Location: Gdansk, Poland
Posts: 420
Thanks: 0
Thanked 15 Times in 4 Posts
B0rsuk is on a distinguished road
Default Re: RFC: Dom3 DB

For a start, try my grepable spell file I use for my spellbook script:

http://www.shrapnelcommunity.com/thr...b=5&o=&fpart=1
I mean, it can be easily parsed.

Note: at this point, it contains only spells from Conjuration, Evocation, Construction, Alteration and Holy. More columns will follow, but ones like 'damage', 'area' 'number of effects' are low priority for now.
__________________
Those who do not understand Master Of Magic are condemned to reinvent it - badly.
Reply With Quote
  #3  
Old December 10th, 2006, 12:05 AM

Ozymandias Ozymandias is offline
Corporal
 
Join Date: Jul 2004
Posts: 98
Thanks: 6
Thanked 0 Times in 0 Posts
Ozymandias is on a distinguished road
Default Re: RFC: Dom3 DB

Oooh I like plaintext, regex is the best sort of query!
Reply With Quote
  #4  
Old December 10th, 2006, 05:02 AM
Edi's Avatar

Edi Edi is offline
National Security Advisor
 
Join Date: Oct 2003
Location: Helsinki, Finland
Posts: 5,425
Thanks: 174
Thanked 695 Times in 267 Posts
Edi is on a distinguished road
Default Re: RFC: Dom3 DB

B0rsuk, I'll take a look at that list. Thanks!

Quote:
NTJedi said:

Yes the spreadsheet will be best so we can sort the columns easily. Also each unit trait should consist of three alphanumeric characters because using two or less can make it difficult to search for specific traits. For example the current unit list uses only "a" for aquatic and when searching for aquatic units the gamer has to manually scroll the list looking for a single "a" instead of using edit/find and typing "aq1" for aquatic.
Three alphanumeric characters should cover all possible unit traits.
Each stat is going to have its own column instead of the Dom2DB format of most special abilities being in a mishmash in a single column, so you can sort by whatever criteria you want without trouble.

Edi
Reply With Quote
  #5  
Old December 10th, 2006, 05:19 AM
Horst F. JENS's Avatar

Horst F. JENS Horst F. JENS is offline
Sergeant
 
Join Date: Oct 2003
Location: Vienna, Austria, Europe
Posts: 234
Thanks: 62
Thanked 11 Times in 6 Posts
Horst F. JENS is on a distinguished road
Default Re: RFC: Dom3 DB

Well, i'm on it whatever the data-format is. I can make DB-Front-Ends in M$-Access, and maybe this project will finally motivate me to do something with a Linux-DB.
Important points:
1.) it should be relative easy to implement changes from patches or mods
2.) The whole thing must work offline;
i want to merge it with a not-yet-existing spell and item list and need an easy-to-export data format (like the plain text files from BOrsuk) to make wiki pages out of it (see below).
Reply With Quote
  #6  
Old December 10th, 2006, 07:45 AM
B0rsuk's Avatar

B0rsuk B0rsuk is offline
Second Lieutenant
 
Join Date: Mar 2004
Location: Gdansk, Poland
Posts: 420
Thanks: 0
Thanked 15 Times in 4 Posts
B0rsuk is on a distinguished road
Default Re: RFC: Dom3 DB

Quote:
Horst F. JENS said:
Well, i'm on it whatever the data-format is. I can make DB-Front-Ends in M$-Access, and maybe this project will finally motivate me to do something with a Linux-DB.
Important points:
1.) it should be relative easy to implement changes from patches or mods
2.) The whole thing must work offline;
i want to merge it with a not-yet-existing spell and item list and need an easy-to-export data format (like the plain text files from BOrsuk) to make wiki pages out of it (see below).
Sounds like sqlite, doesn't it ?
http://en.wikipedia.org/wiki/Sqlite

I just added all common Enchantment spells to the necronomicon file, but it's not uploaded yet. The file is still incomplete anyway.
I need some ideas for next columns. As I said, at the moment there are common spells only. What single column would you add for national spells ? Some national spells are available to two or more nations, I hear, and this makes things trickier.
What other columns to add ? My ideas:
- underwater/surface/anywhere
- purpose (assasination, summon, artillery, travel, paratroopers... that would be for rituals)
__________________
Those who do not understand Master Of Magic are condemned to reinvent it - badly.
Reply With Quote
  #7  
Old December 10th, 2006, 12:38 PM
Edi's Avatar

Edi Edi is offline
National Security Advisor
 
Join Date: Oct 2003
Location: Helsinki, Finland
Posts: 5,425
Thanks: 174
Thanked 695 Times in 267 Posts
Edi is on a distinguished road
Default Re: RFC: Dom3 DB

The way you could do the national spells is simply add more columns to the spell DB, namely something like nation1 and nation2 up until you have enough and then put the first nation to have the spell in the first column and the second to nation2 and so forth. If there was one thing I learned from the Dom2DB, it was that it's a safer bet to put in a few more columns even if they don't get used much than it is to try and squeeze too much information into too few columns. Especially if we're going to turn this into a comprehensive DB.

There should be one column for spell type, which could use categories such as
  • global enchantment
  • local (province) enchantment (e.g. domes, rain of toads, hurricane)
  • ritual summon
  • combat summon
  • combat offensive (lightning bolt, fire darts etc)
  • combat augmentation (quickness, fire shield etc)
  • overland movement (teleport, cloud trapeze etc)
  • overland attack (earth attack, seeking arrow, ghost riders etc)
In general, we want to keep the categories simple and avoid having too many. Hence the above listing groups things targeting a single province in one category, regardless of effect. Spells that summon usable things, like black hawks, angelic host and so forth that can be dropped on an enemy should be classed as ritual summons because you get to keep the things, while ghost riders would obviously be overland attack since they vanish afterward. That's my two cents on that anyway.

My project is already well on its way as far as the layout is concerned, I've added all the forts to the DB and I'm currently making a brand new magic site database. It's going to be preliminary until I get the unit DB side fleshed out so I can add everything the way I want it done.

This project is also great at unearthing some minor bugs and a lot of in-game typos, so I'm going to add those into a list as I go along.

Edi
Reply With Quote
  #8  
Old December 10th, 2006, 03:11 PM
B0rsuk's Avatar

B0rsuk B0rsuk is offline
Second Lieutenant
 
Join Date: Mar 2004
Location: Gdansk, Poland
Posts: 420
Thanks: 0
Thanked 15 Times in 4 Posts
B0rsuk is on a distinguished road
Default Re: RFC: Dom3 DB

At the moment, I packed both age and nation into same column, and think it's probably a good idea. Even Machaka, which only exists in middle era, is Machaka2. Should probably be 2Machaka...

For spells, I suggest categorizing them by their purpose. Later, when I grep things, I'll want to filter spells which let me devastate enemy provinces, buff my provinces, etc. I don't like idea of having both Forest Dome and Seeking Arrow in same category.
rituals:
- assasination (targets an enemy commander)
- artillery (targets enemy province - fires from afar or ghost riders)
- travel/movement
- paratroopers (separate cattegory, because this may allow you to take control of a province)
- summon
- global enchantment
- local,(beneficial) enchantment (Domes, Watcher, Three Red Seconds)
- other
----
battle:
- selfbuffs
- army buffs
- weakening spells (False Fetters, Numbness, Slime...)
- offensive (various damage dealers)
- sniper spells (single target offensive spells)
- symmetric (Darkness, Storm, Rain of Blood, Heat from Hell, Acid Rain)
- reinforcements (Raise Skeleton, Mists of Deception, Howl)
__________________
Those who do not understand Master Of Magic are condemned to reinvent it - badly.
Reply With Quote
  #9  
Old December 10th, 2006, 03:38 PM
Agrajag's Avatar

Agrajag Agrajag is offline
Lieutenant Colonel
 
Join Date: Jul 2004
Location: Israel
Posts: 1,449
Thanks: 4
Thanked 8 Times in 2 Posts
Agrajag is on a distinguished road
Default Re: RFC: Dom3 DB

Quote:
B0rsuk said:
battle:
- selfbuffs
- army buffs
- reinforcements (Raise Skeleton, Mists of Deception, Howl)
Why seperate selfbuffs from army buffs? You could just search for "buffs" and then check for a Range of "self".
Making a secondary search by Range seems to make more sense to me, since there are always those confusing spells like Body Etheral.
Also, why call them "reinforcements" when battle summons would do it? Merely cosmetic, I know, but just wondering.
__________________
I'm in the IDF. (So any new reply by me is a very rare event.)
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

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 On

Forum Jump


All times are GMT -4. The time now is 02:24 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©1999 - 2025, Shrapnel Games, Inc. - All Rights Reserved.