Results 1 to 10 of 23
-
05-24-2010, 04:26 AM #1
- Join Date
- Apr 2008
- Location
- Where the moon cuts the wind.
- Posts
- 259
- 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
-
05-30-2010, 12:00 PM #2
- Join Date
- Oct 2001
- Location
- Woerden, Netherlands
- Posts
- 10,373
- Downloads
- 48
- Uploads
- 1
here is a SQL file i made ages ago containing all the information of anuire (realms, provinces, borders, regents, lieuts etc etc)
Te audire non possum. Musa sapientum fixa est in aure.
-
05-31-2010, 02:11 PM #3
here is for the full cerilia sql .
-
06-01-2010, 10:33 AM #4
- Join Date
- Apr 2008
- Location
- Where the moon cuts the wind.
- Posts
- 259
- 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
-
06-05-2010, 10:03 PM #5
- Join Date
- Apr 2008
- Location
- Where the moon cuts the wind.
- Posts
- 259
- 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
-
06-07-2010, 08:54 AM #6
- Join Date
- Apr 2008
- Location
- Where the moon cuts the wind.
- Posts
- 259
- 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
-
06-07-2010, 09:36 AM #7
- Join Date
- Oct 2001
- Location
- Woerden, Netherlands
- Posts
- 10,373
- Downloads
- 48
- Uploads
- 1
if i recall right its the full Birmail dump
Te audire non possum. Musa sapientum fixa est in aure.
-
06-23-2010, 09:28 AM #8
- Join Date
- Apr 2008
- Location
- Where the moon cuts the wind.
- Posts
- 259
- 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
-
06-23-2010, 09:35 AM #9
- Join Date
- Apr 2008
- Location
- Where the moon cuts the wind.
- Posts
- 259
- 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
-
06-24-2010, 06:18 PM #10
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
-
With a holding (0), am I a regent?
By mayiuchung in forum The Royal LibraryReplies: 16Last Post: 02-07-2007, 09:02 PM -
Regent Information
By stormcrow in forum BRCS 3.0/3.5 EditionReplies: 1Last Post: 10-20-2005, 06:14 AM -
Need some Holding information
By skisko in forum The Royal LibraryReplies: 1Last Post: 05-29-2003, 12:46 PM -
Alternate Regency and Source Holding Ideas
By VerusNoctis in forum The Royal LibraryReplies: 0Last Post: 07-03-2002, 05:01 PM -
If a regent owns a source can their Lieutenants use the regent's sourc
By Lawgiver in forum The Royal LibraryReplies: 14Last Post: 03-12-2002, 08:21 PM
Bookmarks