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

This Month's Specials

BCT Commander- Save $7.00
winSPWW2- Save $5.00

   







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

Reply
 
Thread Tools Display Modes
  #1  
Old February 16th, 2007, 04:25 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 Dom3 DB: Magic Sites, Forts and Poptypes

Second actual installment of Dom3 DB features the complete list of magic sites, the list of forts (again) and an improved list of poptypes.

Also included is a list of precalculated terrain masks for sites, but because the modding manual has outright errors and significant ambiguities in the sitemask section, ALL site mask info regarding combination terrains that include coastal and sea provinces is automatically unreliable. The modding manual sitemask section seems to have been written based on Dom2 terrain types and ignore the addition of Deep Sea and the second Coast terrain, which means the numbers precalculated by IW are WRONG.

Those who wish to explore that subject further are advised to do their own testing.

Enjoy.

Edi

EDIT: Attachment updated
Attached Files
File Type: zip 496755-Dom3_DB_SitesFortsPoptypes.zip (45.7 KB, 395 views)
Reply With Quote
  #2  
Old February 16th, 2007, 06:17 AM

calmon calmon is offline
First Lieutenant
 
Join Date: Jan 2004
Location: Berlin, Germany
Posts: 790
Thanks: 7
Thanked 7 Times in 6 Posts
calmon is on a distinguished road
Default Re: Dom3 DB: Magic Sites, Forts and Poptypes

Great work Edi!

Is there any trick in OpenOffice to sort a column AND have all the other columns adjust correct?

If i sort a specific column only this column was sorted but the other values are still the former one.

EDIT: solved, found the advanced sort function
Reply With Quote
  #3  
Old February 16th, 2007, 06:28 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: Dom3 DB: Magic Sites, Forts and Poptypes

Yes. You need to select all of the data area (meaning go to cell B1 and press ctrl+shift+end) and then sort, that will sort all of the data area.

You can also add autofiltering by selecting the data area as per above (except you start from cell A1) and go to Data >> Filter >> Autofilter, which will allow you to have the list show e.g. all death sites of lv 1 or all sites that produce 3 fire gems or similar.

I was in a real rush this morning when I finished that because I had to go to work, so I forgot to add the autofilter.

I'll update the attachment in the evening by adding autofilters to the sheets.

Edi
Reply With Quote
  #4  
Old February 16th, 2007, 08:29 AM
Jack_Trowell's Avatar

Jack_Trowell Jack_Trowell is offline
Second Lieutenant
 
Join Date: Oct 2006
Location: Toulouse, FRANCE
Posts: 436
Thanks: 150
Thanked 21 Times in 13 Posts
Jack_Trowell is on a distinguished road
Default Re: Dom3 DB: Magic Sites, Forts and Poptypes

Oooooh, complete magic sites list with all infos ...

I think that before completing the "add items" feature, I will have to improve my sites lists; thanks Edi

Question : any ETA for the units list ?
__________________
Q: "How many Vorlons does it takes to change a lightbulb ?"
A: "Yes !" <stranges noises>
--
Dominions Map validator and randomizer : http://dominions.realites.org
Dominions Map editor v0.75b : http://dominions.realites.org/map_editor
Reply With Quote
  #5  
Old February 16th, 2007, 08:57 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: Dom3 DB: Magic Sites, Forts and Poptypes

Couple of weeks. Next entry to be added is #1476 or something like that. After I've got all the elemental data on the units, I'm going to have to craft the display page which will show everything as it appears in the game, and getting all of those formulas right will take another few days. I'll also need to craft categorized display pages to show pretenders, national units, indies, site recruitables and summons.

It's more work in the short term, but the long term results are that anyone who wants to make a mod can simply alter a single number in the elemental unit, weapons and armor tables and see the final results immediately in the unit display page. So taking a look at the effects of the new mod will just need saving the DB as a different file and then comparison will be easy.

Edi
Reply With Quote
  #6  
Old February 16th, 2007, 10:38 AM
Jack_Trowell's Avatar

Jack_Trowell Jack_Trowell is offline
Second Lieutenant
 
Join Date: Oct 2006
Location: Toulouse, FRANCE
Posts: 436
Thanks: 150
Thanked 21 Times in 13 Posts
Jack_Trowell is on a distinguished road
Default Re: Dom3 DB: Magic Sites, Forts and Poptypes

Thanks for than answer Edi.

By the way you're describing the display page, did you get as far as having the units images ?
__________________
Q: "How many Vorlons does it takes to change a lightbulb ?"
A: "Yes !" <stranges noises>
--
Dominions Map validator and randomizer : http://dominions.realites.org
Dominions Map editor v0.75b : http://dominions.realites.org/map_editor
Reply With Quote
  #7  
Old February 16th, 2007, 10:58 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: Dom3 DB: Magic Sites, Forts and Poptypes

No. The image files will have to be somebody else's project.

The display page means showing the stats as they appear. As we all know, stats are affected by armor, weapons and other such. So the elemental stats page has the base stats of a unit unaffected by anything. The display page will use formulas to retrieve the data from the base stats page and modify them with weapons and armor modifiers retrieved from weapons and armor pages.

E.g. most human infantry looks like
10, 0, 10, 10, 3, 10, 10, 10, 10, 2/12,

but when you add in armor and weapons (e.g. plate hauberk, halfhelmet, short sword and shield), it will become something like
10, 15, 10, 10, 6, 10, 10, 11, 10, 2/8

where those stats are hp, prot, morale, magic resistance, encumbrance, str, att, def, prec, mapmove and AP.

I'd still need the actual formula for calculating overall protection for that reason or the creatures with base prot greater than 0 will show up wrong, and resource values are likely to be unmodified, without base resource cost showing. I haven't worked out the ressize modifiers to resource costs, so the Weapons and armor rescosts in the already released document are those for size 2 units. Most units have a base rescost of 1 anyway, regardless of size.

Edi
Reply With Quote
  #8  
Old February 16th, 2007, 11:38 AM

Evil Dave Evil Dave is offline
Corporal
 
Join Date: Jan 2004
Location: Wilmington, Delaware, USA
Posts: 191
Thanks: 1
Thanked 13 Times in 2 Posts
Evil Dave is on a distinguished road
Default Re: Dom3 DB: Magic Sites, Forts and Poptypes

Excellent work! Many thanks, Edi!
__________________
No plan survives contact with the enemy.
--Helmut von Moltke

Have too may pretender files to keep track of? Use catgod to view them.
Reply With Quote
  #9  
Old February 16th, 2007, 01:52 PM
Ragnarok-X's Avatar

Ragnarok-X Ragnarok-X is offline
Major General
 
Join Date: Jan 2004
Location: Germany / Bielefeld
Posts: 2,035
Thanks: 33
Thanked 18 Times in 12 Posts
Ragnarok-X is an unknown quantity at this point
Default Re: Dom3 DB: Magic Sites, Forts and Poptypes

*.ods ?
Reply With Quote
  #10  
Old February 16th, 2007, 03:04 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: Dom3 DB: Magic Sites, Forts and Poptypes

Open Office is your friend, Ragnarok-X. I've gone to detail in my previous Dom3 DB thread (the weapons and armor one) as to why the DB is being provided in Open Office file format. If somebody wants to use it in Excel, they will just have to ask somebody to do the conversion for them or do it themselves after installing Open Office first.

The attachment in the first post has been updated. The poptypes page has the scouts moved from their own column to the 3rd commander column because the 6 poptypes having scouts can't justify two extra columns. The magic site page also has autofilter and there is also a glossary page explaining the terminology in column headers in case it wasn't clear already.

Edi
Reply With Quote
Reply

Bookmarks


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 03:33 PM.


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