Results 11 to 20 of 43
Thread: Multi Campaign DB
-
08-27-2010, 02:53 PM #11
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 !
-
08-27-2010, 04:30 PM #12
- Join Date
- Oct 2001
- Location
- Woerden, Netherlands
- Posts
- 10,373
- Downloads
- 48
- Uploads
- 1
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
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 rpTe audire non possum. Musa sapientum fixa est in aure.
-
08-27-2010, 05:26 PM #13
ok but taxes may not be higher because there are more regent !!
-
08-29-2010, 10:46 PM #14
- 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
-
08-30-2010, 12:00 PM #15
-
08-30-2010, 02:47 PM #16
-
08-30-2010, 05:53 PM #17
-
08-30-2010, 08:22 PM #18
- Join Date
- Oct 2001
- Location
- Woerden, Netherlands
- Posts
- 10,373
- Downloads
- 48
- Uploads
- 1
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 DMLast edited by Arjan; 08-30-2010 at 08:26 PM.
Te audire non possum. Musa sapientum fixa est in aure.
-
09-02-2010, 01:38 AM #19
-
09-02-2010, 01:59 AM #20
- Join Date
- Apr 2008
- Location
- Where the moon cuts the wind.
- Posts
- 259
- Downloads
- 4
- Uploads
- 0
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 2 users browsing this thread. (0 members and 2 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