Page 4 of 4 FirstFirst 1234
Results 61 to 69 of 69

Thread: The great DB Manual

  1. #61
    T.C.'s Avatar Ultima Ratio Regum
    Join Date
    Jun 2009
    Location
    Roscommon, Ireland
    Posts
    3,699

    Default Re: The great DB Manual

    Quote Originally Posted by uanime5 View Post
    I don't know what causes them to spawn but the order in which they spawn is controlled by the startpos (each town / port has a number which determines which order they spawn in). It may be controlled by one of the database tables.

    Also I updated the 'ETW regions CAI.xml' so it contains an index to make searching for the various IDs easier.
    Theres a spawn_town_level () (something like that) function. There's also functions in the CUI (I think) that retrieve info on population data. It's a safe bet that these are used for it.
    My Tools, Tutorials and Resources

    Was running out of space, so see the full list here!

    Consider the postage stamp: its usefulness consists in the ability to stick to one thing till it gets there.- Josh Billings
    The creatures outside looked from pig to man, and from man to pig, and from pig to man again; but already it was impossible to say which was which.- George Orwell

  2. #62
    Ishiyumi no shashu
    Join Date
    Jul 2009
    Location
    Italy
    Posts
    670

    Default Re: The great DB Manual

    Quote Originally Posted by T.C. View Post
    Theres a spawn_town_level () (something like that) function. There's also functions in the CUI (I think) that retrieve info on population data. It's a safe bet that these are used for it.
    thank you
    is possible for you re-introduce this feature in Napoleon?

  3. #63
    T.C.'s Avatar Ultima Ratio Regum
    Join Date
    Jun 2009
    Location
    Roscommon, Ireland
    Posts
    3,699

    Default Re: The great DB Manual

    Quote Originally Posted by PietroMicca View Post
    thank you
    is possible for you re-introduce this feature in Napoleon?
    Yes. But it's not very high on my to-do list at the minute, I've better features like disease re-introduction to work on
    My Tools, Tutorials and Resources

    Was running out of space, so see the full list here!

    Consider the postage stamp: its usefulness consists in the ability to stick to one thing till it gets there.- Josh Billings
    The creatures outside looked from pig to man, and from man to pig, and from pig to man again; but already it was impossible to say which was which.- George Orwell

  4. #64
    Ishiyumi no shashu
    Join Date
    Jul 2009
    Location
    Italy
    Posts
    670

    Default Re: The great DB Manual

    Quote Originally Posted by T.C. View Post
    Yes. But it's not very high on my to-do list at the minute, I've better features like disease re-introduction to work on
    I know I know
    there's a very long list of features to re-introduce
    disease is one of the most important

    Empire is mostly an incomplete game lost in CA's mind

    I have recently notice that it was also planned coal as resource, not present
    iron or coal lets metal-towns to be built

    more than 1 year ago someone re-introduce partially family-tree, but he couldn't make that only for monarchy

    and so on

  5. #65
    T.C.'s Avatar Ultima Ratio Regum
    Join Date
    Jun 2009
    Location
    Roscommon, Ireland
    Posts
    3,699

    Default Re: The great DB Manual

    Quote Originally Posted by PietroMicca View Post
    I know I know
    there's a very long list of features to re-introduce
    disease is one of the most important

    Empire is mostly an incomplete game lost in CA's mind

    I have recently notice that it was also planned coal as resource, not present
    iron or coal lets metal-towns to be built

    more than 1 year ago someone re-introduce partially family-tree, but he couldn't make that only for monarchy

    and so on
    Adding features back in isn't the problem, getting them working right is. Disease, for example, is easy to get back into game, but it can't cause unit casualties. So I'm currently looking for other ways for it to have effects.
    My Tools, Tutorials and Resources

    Was running out of space, so see the full list here!

    Consider the postage stamp: its usefulness consists in the ability to stick to one thing till it gets there.- Josh Billings
    The creatures outside looked from pig to man, and from man to pig, and from pig to man again; but already it was impossible to say which was which.- George Orwell

  6. #66
    uanime5's Avatar Artifex
    Join Date
    Mar 2007
    Posts
    3,163

    Default Re: The great DB Manual

    Quote Originally Posted by PietroMicca View Post
    I know I know
    there's a very long list of features to re-introduce
    disease is one of the most important

    Empire is mostly an incomplete game lost in CA's mind

    I have recently notice that it was also planned coal as resource, not present
    iron or coal lets metal-towns to be built

    more than 1 year ago someone re-introduce partially family-tree, but he couldn't make that only for monarchy

    and so on
    Does this mean that you'd build industrial town instead of iron mine? If may be possible to give the player the choice to build industrial towns or iron mines by adding 'town-metal' to 'iron' in the db table 'building_chain_to_slots_table'.

    Also checking the DB tables it seems that originally you could have a governor in Asia and Africa. Pity these theatres were cut.

    Finally in the trade_theatre_commodities_table the following numbers represent these theatres.

    east_indies -1133129049
    madagascar 836795134
    brazil 1197997136
    ivory_coast 2113354257
    How to split a region in TWS2
    http://www.twcenter.net/forums/showt...split-a-region

    ETW mapping information
    http://www.twcenter.net/forums/showthread.php?t=355187

    M2TW Crashes and how to fix them guide
    http://www.twcenter.net/forums/showthread.php?t=142374

    Eras Total Conquest 2.3 (12 campaigns from 970-1547)

  7. #67
    Ishiyumi no shashu
    Join Date
    Jul 2009
    Location
    Italy
    Posts
    670

    Default Re: The great DB Manual

    Quote Originally Posted by uanime5 View Post
    Does this mean that you'd build industrial town instead of iron mine?
    no I mean that you can build an industrial town only if you have in this province an iron mine or a coal mine

    this is the function used in buildings table as condition to build iron workshops and so on
    Code:
     
    hasRegionResource(res_iron) OR hasRegionResource(res_coal)
    but coal is not present
    and that's a pity because coal was the primary resource during industrial revolution
    Last edited by PietroMicca; January 24, 2011 at 07:02 AM.

  8. #68
    uanime5's Avatar Artifex
    Join Date
    Mar 2007
    Posts
    3,163

    Default Re: The great DB Manual

    I've updated the ETW regions CAI to include land masses. The main ones are for Afro-Eurasia (13) and the Americas (20). The other land masses usually represent individual islands such as the UK (11) or Cuba (18), or islands that belong to other regions such as Visby (89, part of Sweden) and Cyprus (53, part of Syria). There are two exceptions to this: the Camopi Mines in French Guyana (14) and the Jalisco Mines in New Spain (762). I suspect the Jalisco Mines were a very late addition, which is why they have such a high number.

    I also include the ETW pathfinding, which has all the information from the main campaign's pathfinding.esf.
    Attached Files Attached Files
    How to split a region in TWS2
    http://www.twcenter.net/forums/showt...split-a-region

    ETW mapping information
    http://www.twcenter.net/forums/showthread.php?t=355187

    M2TW Crashes and how to fix them guide
    http://www.twcenter.net/forums/showthread.php?t=142374

    Eras Total Conquest 2.3 (12 campaigns from 970-1547)

  9. #69
    El-Vi-Riachi's Avatar Kirā
    Join Date
    Jul 2009
    Posts
    286

    Default Re: The great DB Manual

    Would anyone know what value in the DB table effects how often ships catch fire. I have tried the high/low medium incendiary value in the kv_rules table, but does not seem to change anything. Increasing teh value or decreasing seems to not change anything. I wondered if there is a value elsewhere?

    I wish to increase the chance a ship burns for visual testing purposes.

Page 4 of 4 FirstFirst 1234

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •