Page 1 of 5 12345 LastLast
Results 1 to 10 of 43
  1. #1
    Senior Member Mirviriam's Avatar
    Join Date
    Apr 2008
    Location
    Where the moon cuts the wind.
    Posts
    259
    Downloads
    4
    Uploads
    0

    Multi Campaign DB

    I'm trying to figure out if we should create a cross-link table for campaign_ID & the:

    people_campaign_ID
    domain_campaign_ID
    province_campaign_ID
    holding_campaign_ID
    alliance_campaign_ID

    Maybe some others. Otherwise we have to embed the campaign_ID in every table.
    Legacy of Kings: Member

  2. #2
    Senior Member Dyark's Avatar
    Join Date
    Jun 2007
    Location
    montreal, canada
    Posts
    163
    Downloads
    99
    Uploads
    2
    what is campaign id ??

  3. #3
    Senior Member Mirviriam's Avatar
    Join Date
    Apr 2008
    Location
    Where the moon cuts the wind.
    Posts
    259
    Downloads
    4
    Uploads
    0
    We could call it whatever we wanted. The purpose is to separate different games of birthright being played. With it we can have several games going on with various amounts of players & DM's ...

    My DB envisions having a person sign up on the web page, then choose "Create New Game". He then sets which continent & domains are available for players, designates NPC domains & domains/realms(countries) which will not be allowed in the game. After that the new DM will choose if he wants open sign up (publicly available, handled automatically) or if the DM needs to send invitations for players to claim a realm/domain.

    I will eventually like to add DM preferences like, how long out of game players have to do their turns (1 month always bored me), variant rules off wiki & in BCRS, an army fighting script etc.

    To do that we need an ID that flags the data in certain tables as part of one particular game.
    Legacy of Kings: Member

  4. #4
    Senior Member Dyark's Avatar
    Join Date
    Jun 2007
    Location
    montreal, canada
    Posts
    163
    Downloads
    99
    Uploads
    2
    Certain ideas were taking, like a RP buffer to counter action, war is either script driven of manually or both.

    Turn are per initiative in which if you don't take your action by X number of days, it means you don't do anything (of course major campaign with 50 and over player needs other kind of rules to fix that)

    For me adventure will pass by other tools that I use.

    I am building a multi use database for different campaign ( the basic database never change only new table are created for new campaign )

  5. #5
    Senior Member Mirviriam's Avatar
    Join Date
    Apr 2008
    Location
    Where the moon cuts the wind.
    Posts
    259
    Downloads
    4
    Uploads
    0
    I never thought of using a separate table for each campaign. I suppose we'll never see the number of users that would make the table's over head catch up to sql seek time? Is that why you're doing it?
    Legacy of Kings: Member

  6. #6
    Senior Member Dyark's Avatar
    Join Date
    Jun 2007
    Location
    montreal, canada
    Posts
    163
    Downloads
    99
    Uploads
    2
    just wandering why you seek the number of user

    What i mean is each new style of campaign is separate, on a single campaign, you can have many dm (1 table)

  7. #7
    Administrator Arius Vistoon's Avatar
    Join Date
    Jan 2002
    Location
    Paris ( france )
    Posts
    334
    Downloads
    273
    Uploads
    1
    Quote Originally Posted by Dyark View Post
    I am building a multi use database for different campaign ( the basic database never change only new table are created for new campaign )
    euh... don't create new table for each campaign (never). If you want multi-campaign use, create a link in the appropiate table (in high header of it for better package) or alternate solution, create a new databse with a connect to the "root" database" (but never create table on the fly, when a database is created, it will can change its structure only for exceptionnel thing like a new feature. a new campaign is not a new feature.)

    but it's my opinion (of database manager)

  8. #8
    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 Dyark View Post
    just wandering why you seek the number of user

    What i mean is each new style of campaign is separate, on a single campaign, you can have many dm (1 table)
    Not sure what you mean here?

    On the data base side, I will have all campaigns in single set of tables. Then use cross/pivot tables to insert new variant rules etc. My database structure already allow's multiple DM's, domain rulers, players per regent, etc.

    The only real exclusions I have are:

    holding can't belong to more than one province
    province can't belong to more than one domain
    province can't belong to more than one region (birMail doesn't use regions, but does have continents ... there will be regions in my DB as there are in the books)
    Legacy of Kings: Member

  9. #9
    Senior Member Dyark's Avatar
    Join Date
    Jun 2007
    Location
    montreal, canada
    Posts
    163
    Downloads
    99
    Uploads
    2
    Quote Originally Posted by Mirviriam View Post
    province can't belong to more than one domain
    What about multi regent (different domain) for one province like in Kinasi/Vosgaard ?

  10. #10
    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
    What about multi regent (different domain) for one province like in Kinasi/Vosgaard ?

    well there are also cases that domains have more then one ruler, 3 bros mages, college of sorcery, sword mage (rumor)
    i.e. rule by council

    i would not worry too much about the situation we talked about earlier in vosgaard.. just simple split them into two domains in the domain table..
    even though the provinces "belong" to one realm.. the provinces are in fact split between two domains. (but still linking to the realm id)

    the realm table is nothing more then a name of a country reference

    and also try to put your thoughts into the player.. what would he do? i assume you give the player the ability of renaming their domains/provinces/realms
    Te audire non possum. Musa sapientum fixa est in aure.

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.