Page 2 of 5 FirstFirst 12345 LastLast
Results 11 to 20 of 43
  1. #11
    Senior Member Dyark's Avatar
    Join Date
    Jun 2007
    Location
    montreal, canada
    Posts
    163
    Downloads
    99
    Uploads
    2
    Rename domain : Yes
    Rename province : Why ? :confused:


    How do you divide the taxes on multiple regent per domain (like the red kings in Kinasi) ?

    I am working are on the structure of the UI, need to find a good map api, the rest will be easier as I go along !

  2. #12
    Moo! Are you happy now? Arjan's Avatar
    Join Date
    Oct 2001
    Location
    Woerden, Netherlands
    Posts
    10,373
    Downloads
    48
    Uploads
    1
    Quote Originally Posted by Dyark View Post
    Rename domain : Yes
    Rename province : Why ? :confused:
    well you will always have players that want to rename things.. its their victory, and they always want to change things to show the outside world of their power and actions..
    in the real world history this has happened as well.

    and really, it does not matter, because they are linked on ID..

    BUT if you are thinking about using the province table as non-editable for multi campaign..
    yes you have a problem

    Quote Originally Posted by Dyark View Post
    How do you divide the taxes on multiple regent per domain (like the red kings in Kinasi) ?
    take a look at the 3e rules for ruling a counsil
    - in 3e the taxes are set to constants amounts.. no variables.
    - ruling by counsil takes the avarage bloodline score to determine the max rp
    Te audire non possum. Musa sapientum fixa est in aure.

  3. #13
    Senior Member Dyark's Avatar
    Join Date
    Jun 2007
    Location
    montreal, canada
    Posts
    163
    Downloads
    99
    Uploads
    2
    ok but taxes may not be higher because there are more regent !!

  4. #14
    Senior Member Mirviriam's Avatar
    Join Date
    Apr 2008
    Location
    Where the moon cuts the wind.
    Posts
    259
    Downloads
    4
    Uploads
    0
    "Jimmy, I'd like to take that question & field as my own..."

    Taxes in the province should be the same. As per the game mechanic there's no geographical element for assigning taxes. Even if regent A controls the western half & regent B controls the eastern half of the province, there's still no method to express separate taxes in the original or BCRS version of birthright.

    Is these a feature you want to add later, or did I just miss what you meant?
    Legacy of Kings: Member

  5. #15
    Senior Member Dyark's Avatar
    Join Date
    Jun 2007
    Location
    montreal, canada
    Posts
    163
    Downloads
    99
    Uploads
    2
    it is because we prepare the database and there are a lot of multi regent per domain in there (Anuire as chymereaon, but afeter that you get a lot of them)
    And I was wnadering how to handle that as a game mechanic so i can translate that in the web game.

  6. #16
    Moo! Are you happy now? Arjan's Avatar
    Join Date
    Oct 2001
    Location
    Woerden, Netherlands
    Posts
    10,373
    Downloads
    48
    Uploads
    1
    i think in order to handle multi regent per domain you have to select everything by domain, instead of regent.

    then a simple function to calculate the avarage to determine max RP.

    the RP/GB pool is in the domain table anyway
    Te audire non possum. Musa sapientum fixa est in aure.

  7. #17
    Senior Member Dyark's Avatar
    Join Date
    Jun 2007
    Location
    montreal, canada
    Posts
    163
    Downloads
    99
    Uploads
    2
    so if I understand you double a domain because there is more than one regent ?

    or you create a pivot table for domain and referred regent ?

  8. #18
    Moo! Are you happy now? Arjan's Avatar
    Join Date
    Oct 2001
    Location
    Woerden, Netherlands
    Posts
    10,373
    Downloads
    48
    Uploads
    1
    Quote Originally Posted by Dyark View Post
    so if I understand you double a domain because there is more than one regent ?

    or you create a pivot table for domain and referred regent ?
    hmm a pivot table is not needed.. regents can thus have the same domain_id

    select from regents where domain_id =

    instead of select from domains where regent_id =


    so the whole setup should be domain focused instead of regent focused..
    (also good in cases like when a regent some how dies... or when transfering a domain to another char)

    perhaps in cases when a player has multiple domains (like a covert one) the domain table should have the player or user ID
    if i am right, i have the regent id in the user table, but would probably be better to have it in the domain table..
    also easier when assigning it to users or play as DM
    Last edited by Arjan; 08-30-2010 at 08:26 PM.
    Te audire non possum. Musa sapientum fixa est in aure.

  9. #19
    Senior Member Mirviriam's Avatar
    Join Date
    Apr 2008
    Location
    Where the moon cuts the wind.
    Posts
    259
    Downloads
    4
    Uploads
    0
    Quote Originally Posted by Arjan View Post
    hmm a pivot table is not needed.. regents can thus have the same domain_id

    select from regents where domain_id =

    instead of select from domains where regent_id =


    so the whole setup should be domain focused instead of regent focused..
    (also good in cases like when a regent some how dies... or when transfering a domain to another char)

    perhaps in cases when a player has multiple domains (like a covert one) the domain table should have the player or user ID
    if i am right, i have the regent id in the user table, but would probably be better to have it in the domain table..
    also easier when assigning it to users or play as DM
    Design-wise a pivot is better...I think it's 4th form?
    Legacy of Kings: Member

  10. #20
    Senior Member Mirviriam's Avatar
    Join Date
    Apr 2008
    Location
    Where the moon cuts the wind.
    Posts
    259
    Downloads
    4
    Uploads
    0

    Post

    Quote Originally Posted by Dyark View Post
    so if I understand you double a domain because there is more than one regent ?

    or you create a pivot table for domain and referred regent ?
    It has nothing to do with doubling anything...so far as I can tell. There's really two ways. First you use the pivot(cross) table:

    table: regent
    regent_id
    fields:
    name
    level
    stats
    etc...

    table: domain
    fields:
    domain_id
    name
    treasury
    regency
    etc...

    table: x_regent_domain
    fields:
    regent_id
    domain_id

    The second way, & the point Araj was making...there's an easier way. You can instead take your old database design(this is most recent i have of yours):

    table: ruler
    fields:
    areaofdeath
    currentprovince
    npc_own
    pc
    characterownerid <---- Here is what Araj wants to point out
    etc...

    See "characterownerid"? If you make that domain_id. Then you don't have an issue with multiple regents controlling a country/realm. You have to do that in the provinces, structures, armies, holdings tables too!

    Why? Every ruler will have a domain_id assigned. The domain will link the ruler/regent table to the provinces and holdings (everything actually).

    Like so:

    Regent -> Domain <-Provinces
    Holdings-> Domain <-Army
    Bridges -> Domain

    You create the link by replacing charownerid in the Province, Holding & Regent tables. Then when you query for rulers of a domain...

    SELECT r.id, r.domain_id r.name, domain_id, domain_name
    FROM ruler AS r, domain
    WHERE r.domain_id = domain_id

    Then you can output it how ever you want. The advantage is unlimited # of rulers for any domain. Changing the name of a domain, province, holding, bridge or army is simple since it's linked via domain_id placed in each field.

    Arius pointed out that the 2nd method is a bit of a shortcut. The reasoning is that logically domain id does not belong in regent table - so you should make a cross (pivot) table to link the two tables. Honestly, in a database as small as this - I don't think there's a wrong method. I prefer the cross(pivot) method but if you check my database plan currently (here) , you can see I used the second method (because it was easier).
    Legacy of Kings: Member

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Birthright PC Game-control battle on multi
    By vota dc in forum The Royal Library
    Replies: 1
    Last Post: 06-29-2009, 08:40 AM
  2. My next campaign
    By Crazypostal in forum The Royal Library
    Replies: 6
    Last Post: 05-31-2007, 09:24 AM
  3. Campaign
    By Sorontar in forum BRWiki Discussions
    Replies: 5
    Last Post: 05-31-2007, 09:07 AM
  4. New Multi-Classing Rule.
    By geeman in forum The Royal Library
    Replies: 62
    Last Post: 09-25-2002, 09:34 PM
  5. Campaign
    By koraf_tdt in forum The Royal Library
    Replies: 11
    Last Post: 06-28-2002, 10:25 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
BIRTHRIGHT, DUNGEONS & DRAGONS, D&D, the BIRTHRIGHT logo, and the D&D logo are trademarks owned by Wizards of the Coast, Inc., a subsidiary of Hasbro, Inc., and are used by permission. ©2002-2010 Wizards of the Coast, Inc.