Results 1 to 10 of 43
Thread: Multi Campaign DB
Hybrid View
-
08-18-2010, 03:31 PM #1
- 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
-
08-19-2010, 04:53 AM #2
what is campaign id ??
-
08-22-2010, 09:40 PM #3
- 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
-
08-23-2010, 03:32 AM #4
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 )
-
08-23-2010, 09:13 AM #5
- 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
-
08-23-2010, 12:25 PM #6
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)
-
08-24-2010, 11:54 PM #7
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)
Thread Information
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Similar Threads
-
Birthright PC Game-control battle on multi
By vota dc in forum The Royal LibraryReplies: 1Last Post: 06-29-2009, 08:40 AM -
My next campaign
By Crazypostal in forum The Royal LibraryReplies: 6Last Post: 05-31-2007, 09:24 AM -
Campaign
By Sorontar in forum BRWiki DiscussionsReplies: 5Last Post: 05-31-2007, 09:07 AM -
New Multi-Classing Rule.
By geeman in forum The Royal LibraryReplies: 62Last Post: 09-25-2002, 09:34 PM -
Campaign
By koraf_tdt in forum The Royal LibraryReplies: 11Last Post: 06-28-2002, 10:25 PM
Bookmarks