Page 1 of 3 123 LastLast
Results 1 to 10 of 23
  1. #1
    Senior Member Mirviriam's Avatar
    Join Date
    Apr 2008
    Location
    Where the moon cuts the wind.
    Posts
    249
    Downloads
    4
    Uploads
    0

    Campaign (Province, Domain, Holding, Regent, Unit) information source?

    I'm looking for a source of uniformed campaign information (Province, Domain, Holding, Regent, Unit) already in plain text files or CSV/Comma Delimited etc...basically something on the computer, that requires nothing to open the file & read but notepad.

    I haven't had any luck with the birMail as a source...if anyone has the information in plain text from there, I would appreciate it (as when it generates the HTML to be displayed, it puts them as High, Medium, Low for the levels)!!

    I considered the wiki, but it's not uniform & correcting errors after using a scripting spider would take longer than hand entering so far as I can tell...since I was not great with pearl's expressions.
    Legacy of Kings: Member

  2. #2
    Moo! Are you happy now? Arjan's Avatar
    Join Date
    Oct 2001
    Location
    Woerden, Netherlands
    Posts
    10,307
    Downloads
    39
    Uploads
    1
    here is a SQL file i made ages ago containing all the information of anuire (realms, provinces, borders, regents, lieuts etc etc)
    Attached Files Attached Files
    Te audire non possum. Musa sapientum fixa est in aure.

  3. #3
    Senior Member Dyark's Avatar
    Join Date
    Jun 2007
    Location
    montreal, canada
    Posts
    163
    Downloads
    69
    Uploads
    2
    here is for the full cerilia sql .
    Attached Files Attached Files

  4. #4
    Senior Member Mirviriam's Avatar
    Join Date
    Apr 2008
    Location
    Where the moon cuts the wind.
    Posts
    249
    Downloads
    4
    Uploads
    0
    Nice, I have to poke at that this week!! I keep finding crap I'm missing all the time

    Yesterday it was the blood traits for long life, physically I know they exist - but be damned if I had a mechanic for them in factoring for age on regents

    EDIT: I took a peek before I am going to bed...that's beyond incredible. How long were you on that?
    Last edited by Mirviriam; 06-01-2010 at 10:36 AM.
    Legacy of Kings: Member

  5. #5
    Senior Member Mirviriam's Avatar
    Join Date
    Apr 2008
    Location
    Where the moon cuts the wind.
    Posts
    249
    Downloads
    4
    Uploads
    0
    So what is it you guys need then in the PHP side of things? I'm not a graphics guy myself or I'd offer that since it was what you were discussing in the other posts...
    Legacy of Kings: Member

  6. #6
    Senior Member Mirviriam's Avatar
    Join Date
    Apr 2008
    Location
    Where the moon cuts the wind.
    Posts
    249
    Downloads
    4
    Uploads
    0
    Dyark, do you have someone else helping out with the data input for your project or is this some how grabbed off the infamous PDF's, stripped to text & then inserted in your database?
    Legacy of Kings: Member

  7. #7
    Moo! Are you happy now? Arjan's Avatar
    Join Date
    Oct 2001
    Location
    Woerden, Netherlands
    Posts
    10,307
    Downloads
    39
    Uploads
    1
    Quote Originally Posted by Mirviriam View Post
    Dyark, do you have someone else helping out with the data input for your project or is this some how grabbed off the infamous PDF's, stripped to text & then inserted in your database?
    if i recall right its the full Birmail dump
    Te audire non possum. Musa sapientum fixa est in aure.

  8. #8
    Senior Member Mirviriam's Avatar
    Join Date
    Apr 2008
    Location
    Where the moon cuts the wind.
    Posts
    249
    Downloads
    4
    Uploads
    0
    Ugh, ... I found some oddities:

    463 Rulers
    119 Countries
    847 Provinces
    1768 Holdings

    But when I'm joining tables looking for

    SELECT *
    FROM Province, Rulers
    WHERE Rulers.ID = Province.CharOwnerID

    There's only 229 provinces with rulers ... So, I'm assuming the database was never finished?
    Legacy of Kings: Member

  9. #9
    Senior Member Mirviriam's Avatar
    Join Date
    Apr 2008
    Location
    Where the moon cuts the wind.
    Posts
    249
    Downloads
    4
    Uploads
    0
    For example from the Province table

    ID Realm CharOwnerID
    461 65 152

    Where from Rulers table:

    MySQL returned an empty result set (i.e. zero rows). (Query took 0.0410 sec)
    SQL query:
    SELECT `ID`
    FROM `Rulers`
    WHERE `ID` =152
    LIMIT 0 , 30

    I'm just double checking to see what we need for information ... if it turns out I'm just not good with MY-SQL, then I'll go grab another text to help out. Otherwise I'll start on coding tools to allow users to correct the database via the web (like wiki only easier).
    Legacy of Kings: Member

  10. #10
    Senior Member Dyark's Avatar
    Join Date
    Jun 2007
    Location
    montreal, canada
    Posts
    163
    Downloads
    69
    Uploads
    2
    Sorry was out for a couple of weeks can you specify the question ?

    like if all realms have a regent attach ?

    the database comes from birdmail, there is a lot of correction to make with it. I use a table that enable me to restart really easily (the table time_actions_rounds control the random event, time and action, also taxes and expenses) that way if you do not want to use my rules (mixte of 2e and 3e) you just make you rules from that table.

    All the provinces have their level and source from the sourcebook as original. it will be modify (not finish) with a different table so I can go back easily (I like to make stuff reusable many times)

    I am trying to build the web part with Flash CS4, it reads the variable coming from php so i can change and update the data from mysql.

    Like all the time I pass from one subject to the next LOL

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. With a holding (0), am I a regent?
    By mayiuchung in forum The Royal Library
    Replies: 16
    Last Post: 02-07-2007, 09:02 PM
  2. Regent Information
    By stormcrow in forum BRCS 3.0/3.5 Edition
    Replies: 1
    Last Post: 10-20-2005, 06:14 AM
  3. Need some Holding information
    By skisko in forum The Royal Library
    Replies: 1
    Last Post: 05-29-2003, 12:46 PM
  4. Alternate Regency and Source Holding Ideas
    By VerusNoctis in forum The Royal Library
    Replies: 0
    Last Post: 07-03-2002, 05:01 PM
  5. Replies: 14
    Last Post: 03-12-2002, 08:21 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.