Page 4 of 5 FirstFirst 12345 LastLast
Results 31 to 40 of 43
  1. #31
    Senior Member Dyark's Avatar
    Join Date
    Jun 2007
    Location
    montreal, canada
    Posts
    163
    Downloads
    99
    Uploads
    2
    I need more free time
    so do I, so do I

    great work by the way, it looks a lot like a custom Microsoft Access with powerfull custom GUI.

    Question for Excel : have you think of using the format csv (there is a common database that the community is trying to build) in mySQL, but you can export to csv format so no double work there ?

    For my part, the tools is made with flash but I use a lot of actionscript classes so any other actionscript scripter (like flex) can see and rework my work (say thta a few times )

    I want a really small web tool so you don't need to upload the version but play directly on the web. All data is coming from dynamic php pages (you fill out what you want and the result is transform for you, no pre build SQL data.

    map is vectorize, so zoom and position is really easy : you are the regent and you build a bridge, well since i am a lazy GM (in a sense, i like people working for themselves ) you place the bridge in the province that you own yourself (it is only coordinate)
    the build up is also for future consideration (rule changes, new continent etc)

    It is a lot of work, first i want it ready for christmas 2010 but wow was I off, now I wich June 2011, but it looks more like fall 2011, we will see.

    and last thing i want all none npc domain to be played by PC (if possible), that's a lot of them !

    well that it for now

  2. #32
    Special Guest (Donor)
    Join Date
    Nov 2001
    Location
    Spain
    Posts
    532
    Downloads
    11
    Uploads
    0
    Quote Originally Posted by Dyark View Post
    great work by the way, it looks a lot like a custom Microsoft Access with powerfull custom GUI.
    Thanks! I agree it's pretty similar to forms over Access

    Quote Originally Posted by Dyark View Post
    Question for Excel : have you think of using the format csv (there is a common database that the community is trying to build) in mySQL, but you can export to csv format so no double work there ?
    Not sure I understand the question :S I won't export anything as I'm using some data files that aren't mine. I will make a tool capable of importing data from an Excel file (2007 onwards) as there's a driver that allows you to read data from there as if it was a database (so I can use the same code to get data from SQL Server, MySQL or Excel ).

    Importing data from CSV shouldn't be hard, it's a pretty simple format to parse

    Quote Originally Posted by Dyark View Post
    map is vectorize, so zoom and position is really easy : you are the regent and you build a bridge, well since i am a lazy GM (in a sense, i like people working for themselves ) you place the bridge in the province that you own yourself (it is only coordinate)
    the build up is also for future consideration (rule changes, new continent etc)
    I don't think I'll tackle the map problem, I could check Bing Maps API, but I really don't like anything related to web programming :S

    Quote Originally Posted by Dyark View Post
    It is a lot of work, first i want it ready for christmas 2010 but wow was I off, now I wich June 2011, but it looks more like fall 2011, we will see.
    Agreed, it's a ton of work, I was expecting to finish this in 1 month and well...

    Quote Originally Posted by Dyark View Post
    and last thing i want all none npc domain to be played by PC (if possible), that's a lot of them !

    well that it for now
    Well, the idea is that the GMs setup what is playable and what not, that's up to them. In both PbeM games I'm doing Avanil and Boeruine are playable, but they aren't in RoE, so well

  3. #33
    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
    for my part, i have already started the coding, it is advancing well, i am looking for beta testting around march (hopefully )

    I did not change my mine on flexibilty, it is really flexible and also i am commenting my codes a lot so somebody who wants to take my work can do it easily (all in actionscript 3 and php)

    I am aslo building tools for customs data like (that is a big wish) every regent has to developp their provinces and provide adventure data for somebody other than him !

    we will see anyway
    I also realized our databases were extremely inflexible. That's why I brought up the splitting all tables. I think I said by birthright game stats, then a cross connected table for metagame(electronic stats, like location of character etc).

    I took that a little farther in past few months. That's how I came to idea of the action system. There's a down side. You need two queries for every query in the old system. One to prep the action & load the variables (table names) to query. Then one to get the action/character specific information to use in the formula. I'll link from here to that post in a few minutes.
    Legacy of Kings: Member

  4. #34
    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
    so do I, so do I

    great work by the way, it looks a lot like a custom Microsoft Access with powerfull custom GUI.

    Question for Excel : have you think of using the format csv (there is a common database that the community is trying to build) in mySQL, but you can export to csv format so no double work there ?

    For my part, the tools is made with flash but I use a lot of actionscript classes so any other actionscript scripter (like flex) can see and rework my work (say thta a few times )

    I want a really small web tool so you don't need to upload the version but play directly on the web. All data is coming from dynamic php pages (you fill out what you want and the result is transform for you, no pre build SQL data.

    map is vectorize, so zoom and position is really easy : you are the regent and you build a bridge, well since i am a lazy GM (in a sense, i like people working for themselves ) you place the bridge in the province that you own yourself (it is only coordinate)
    the build up is also for future consideration (rule changes, new continent etc)

    It is a lot of work, first i want it ready for christmas 2010 but wow was I off, now I wich June 2011, but it looks more like fall 2011, we will see.

    and last thing i want all none npc domain to be played by PC (if possible), that's a lot of them !

    well that it for now

    That kind of sounds like it would work as a front end to the mechanics of what I am doing.

    The obvious issue is my database has all campaigns by every dm in the same table for provinces, domains, holdings, structures & Dyark you stated you were creating a table or database for each campaign you wanted to play (which was just to inflexible for me).

    The second issue is like Vincente, I have two or three tables for characters, holdings, provinces, domains based on if they are actually information from the book or created to make the electronic version of the game work.
    Legacy of Kings: Member

  5. #35
    Special Guest (Donor)
    Join Date
    Nov 2001
    Location
    Spain
    Posts
    532
    Downloads
    11
    Uploads
    0
    I have also gone the route of one DB for each campaign. I don't see why that's inflexible (may be something I don't know of MySQL), but in SQL Server I can have 324234 databases if I want, and I don't have to mix things together and fill all the tables with CampaignId fields :S.

    For example, if you have all campaigns in the same tables, and you have a guy who is GM in one and player in another, enforcing permissions at DB level is impossible (at least in SQLS). If you have each campaign in one DB, then you can give the GMs DB admin rights for that DB and they won't be able to see anything else.

  6. #36
    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
    I also realized our databases were extremely inflexible. That's why I brought up the splitting all tables. I think I said by birthright game stats, then a cross connected table for metagame(electronic stats, like location of character etc).

    I took that a little farther in past few months. That's how I came to idea of the action system. There's a down side. You need two queries for every query in the old system. One to prep the action & load the variables (table names) to query. Then one to get the action/character specific information to use in the formula. I'll link from here to that post in a few minutes.
    I just read the other post and thinking about this. Loading table is really small (i just made a big query crossing 9 tables and loading a lot of data, it is only 82k so even if i load data to use in the actions, is is really small.

  7. #37
    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
    That kind of sounds like it would work as a front end to the mechanics of what I am doing.
    Exactly, I want it to be very flexible (used by the community), so I would have my campaign, but somebody else could create is own campaign easily with the same tool.

    Quote Originally Posted by Mirviriam View Post
    The obvious issue is my database has all campaigns by every dm in the same table for provinces, domains, holdings, structures & Dyark you stated you were creating a table or database for each campaign you wanted to play (which was just to inflexible for me).
    What I meant is a datatable that handle all the change in the other tables (I am not sure it would be easy, it is something a friend build for a different game)

    Quote Originally Posted by Mirviriam View Post
    The second issue is like Vincente, I have two or three tables for characters, holdings, provinces, domains based on if they are actually information from the book or created to make the electronic version of the game work.
    What do you mean on this :confused:

  8. #38
    Senior Member Mirviriam's Avatar
    Join Date
    Apr 2008
    Location
    Where the moon cuts the wind.
    Posts
    259
    Downloads
    4
    Uploads
    0
    We are building a game system on top of the rules laid out in the 2nd or 3rd Edition Birthright book right?

    Well, assuming you answer yes:

    There are several types of data.

    The base of all the data is anything we copy out of the 2nd Edition or 3rd Edition handbook. I personally have this information in it's own table. IE: Character table has fields id, name, age, gender, race, strength ... total levels. Then there's a crosslink table for classes since that's the easiest way to allow multiple classes & levels.

    Where I think we differ is that when I want to record information the Handbook's do not have listed (like location of regent etc), I create a table with the same name & put a "M_" infront of the name. IE: character table has a second table named M_character which holds x & y coordinates, if the character has trained this turn (since birthright forbids training 3 rounds in a row, this is important), etc.

    It's an information handling thing. Look up metadata on the web for a better explanation. The idea is that, it's data which acts on other data.
    Legacy of Kings: Member

  9. #39
    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
    Well, assuming you answer yes:
    assuming great


    Quote Originally Posted by Mirviriam View Post
    I create a table with the same name & put a "M_" infront of the name. IE: character table has a second table named M_character which holds x & y coordinates, if the character has trained this turn (since birthright forbids training 3 rounds in a row, this is important), etc.
    just wandering why you use x and y when you can determine them buy le width and height of the province object ?

    Quote Originally Posted by Mirviriam View Post
    It's an information handling thing. Look up metadata on the web for a better explanation. The idea is that, it's data which acts on other data.
    For me training goes in round_actions_all table which gives me the Turn, Round, Action number, Regent, Showdetails (what the regent wants to appear in the history book), special request (message to the GM), GM approve.
    So the SQL request tells me if the PC trained in the past round and reject the action automaticaly, when the regent submit it.

    QUESTION : all the classes and level of the 3e edition, do you have data on this ?? I just don't want to write them all by hand (or keyboard )

  10. #40
    Senior Member Mirviriam's Avatar
    Join Date
    Apr 2008
    Location
    Where the moon cuts the wind.
    Posts
    259
    Downloads
    4
    Uploads
    0
    The other thing to recall is with view's all your concerns or needs to use one database per campaign go away.

    Also, don't forget the hidden costs of database to database projects, there's metadata table on the server & communication costs too.
    Legacy of Kings: Member

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.