IPB

Welcome Guest ( Log In | Register )

8 Pages V  « < 4 5 6 7 8 >  
Reply to this topicStart new topic
> Dashifen Character Record System, dcrs.dashifen.com
Kanada Ten
post Jun 16 2004, 10:25 PM
Post #126


Beetle Eater
********

Group: Dumpshocked
Posts: 4,797
Joined: 3-June 02
From: Oblivion City
Member No.: 2,826



Here's a couple of ideas.

Clicking on skills in non-edit mode could act as a dice roller and spit out a list of the results on the same page.

Contacts could be linked to NPCs in the database.
Go to the top of the page
 
+Quote Post
Dashifen
post Jun 18 2004, 02:08 PM
Post #127


Technomancer
********

Group: Retired Admins
Posts: 4,638
Joined: 2-October 02
From: Champaign, IL
Member No.: 3,374



QUOTE (Kanada Ten)
Here's a couple of ideas.

Clicking on skills in non-edit mode could act as a dice roller and spit out a list of the results on the same page.

Contacts could be linked to NPCs in the database.

I'm not sure what you mean about clicking on skills, but let me see if I do: You click on a skill, say Etiquette, in non-edit mode. This would then roll the rating of the Etiquette skill in dice and display the result? That's not too hard. It's a little more difficult to do if it's going to happen on the same page, but that should be a major change, I just need to make a text field somewhere on the page to show the information.

Contacts could be NPCs if the GMs want them to be. You could enter the contact as an NPC ... I'll give some consideration to a way to connect the contact page to the record of the NPC contact.

Two good ideas.

Good news, too: my play opened yesterday and we're done at the end of the weekend (I hate short runs...oh well) so I'll be able to get back to work on the DCRS next week!! Thanks for your perseverance.
Go to the top of the page
 
+Quote Post
prionic6
post Jun 21 2004, 02:21 PM
Post #128


Target
*

Group: Members
Posts: 95
Joined: 21-June 04
From: Cologne, Germany
Member No.: 6,429



This is a very nice project and I am sure I will use it in our next session on saturday! I especially like the simplicity aspect, not overloaded and only the features you really need!

Two suggestions:
- Ammo tracking would be nice. This could be as simple as an input box in the fight status view where you simply store the number of bullets per-person or more fleshed out with different clips carried by the charakters with ammo types and load status.

- Our adventures tend to last more than one session (we 're a bit slow :)) So I try to track information about what the individual players did regarding the individual karma categories suggested in the BBB. I'm not sure how you could make a module for this but maybe it would be a nice idea.
Go to the top of the page
 
+Quote Post
Dashifen
post Jun 21 2004, 02:56 PM
Post #129


Technomancer
********

Group: Retired Admins
Posts: 4,638
Joined: 2-October 02
From: Champaign, IL
Member No.: 3,374



Ammo tracker -- you're awesome. Good idea. I've also wanted to add a way to track spell pool to the combat screen but I'm running out of space ...

I was thinking of adding a notes field to allow GMs to keep notes to themselves in the system, but size is always an issue. I have a limited amout of space and if I need to upgrade to a new package with my hosting company, it becomse more expensive for me. I'll investigate it.

Go to the top of the page
 
+Quote Post
prionic6
post Jun 21 2004, 03:05 PM
Post #130


Target
*

Group: Members
Posts: 95
Joined: 21-June 04
From: Cologne, Germany
Member No.: 6,429



If you would make your software Open Source, it would be possible for anyone to install it on his own server and you could even get help for the development of the project. :)

Don't know if that's an option for you, though...
Go to the top of the page
 
+Quote Post
Dashifen
post Jun 21 2004, 03:24 PM
Post #131


Technomancer
********

Group: Retired Admins
Posts: 4,638
Joined: 2-October 02
From: Champaign, IL
Member No.: 3,374



It's not really. It's housed along with other things that are private (like my email until I download it at least) so open sourcing really isn't an option. Plus, I like doing it all.

As for installing it locally on a user's computer, that really wouldn't work because the PHP/MySQL setup requires a web server. Sorry!
Go to the top of the page
 
+Quote Post
prionic6
post Jun 21 2004, 03:53 PM
Post #132


Target
*

Group: Members
Posts: 95
Joined: 21-June 04
From: Cologne, Germany
Member No.: 6,429



It's really not a big problem to locally install an Apache/PHP/MySQL setup :) But actually I talked about installing it on one's own webserver. I'm sure there are people out there that have the ressources needed - almost every provider gives you access to PHP and mysql. You have. I have. Also, Open Sourcing would not mean giving anyone access to your server but only giving out your .php-files and maybe a script for setting up the database. It would also not include giving out personal (GM/Player/Game) data in your database! Plus you would still be the holder of your intellectual property and the creator of the project. You could host your code for free (so you won't have to pay for people downloading it) on sites like sourceforge.org

This is not to argue you into doing it, it's your project, your code, your property. You decide what to do with it, of course. Just consider it as an option, especially if you later come to a point where you don't have the money or the time to further develop it!
Go to the top of the page
 
+Quote Post
KeyMasterOfGozer
post Jun 21 2004, 06:55 PM
Post #133


Moving Target
**

Group: Members
Posts: 239
Joined: 10-February 04
Member No.: 6,068



I would like to re-iterate somethings that prionic6 said.

1) It is your project, and your property, so don't think of this as trying to talk you into doing it.

2) I, as do many other people, have a couple of webservers, where I already have php/mysql programs running. Some I wrote myself, and some from other places. This is certainly an enviroment that many people already have, or could setup in very little time. This does not put your own data in jeopary, it simply lets someone else run your program on their server.

3) I understand that you want to keep full control of it now, that's cool, but please consider if you get tired of working on it (or bored with it) Releasing it as Open Source would let other people who like the product, to forward it and keep it going after you interest lapses.

Once again, I'm not trying to convince you. It just sounded in your post like you had some possibly unfounded misgivings.

Cheers!
-Mike
Go to the top of the page
 
+Quote Post
prionic6
post Jun 21 2004, 08:10 PM
Post #134


Target
*

Group: Members
Posts: 95
Joined: 21-June 04
From: Cologne, Germany
Member No.: 6,429



The sr3-import won't work with melee manouvers... The Line in the file is

Skill1=MA:Kung_Fu(STR)/MN:Fußtritt~[2]=4X

and the error is

MYSQL QUERY ERROR!!
Query: INSERT INTO sr3_skills (character_id, skill, skill_rating, specialization, spec_rating, linked_attribute) VALUES (287, 'Kung Fu', 2, 'MN:Fußtritt~[2]=4X ', , 3)
Problem: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' 3)' at line 1
Go to the top of the page
 
+Quote Post
KeyMasterOfGozer
post Jun 22 2004, 02:16 PM
Post #135


Moving Target
**

Group: Members
Posts: 239
Joined: 10-February 04
Member No.: 6,068



Will it work if you change the line to:

Skill1=MA:Kung_Fu(STR)/MN:Fusstritt~[2]=4X

I wonder if the characterset of his MySQL DB maybe won't handle the Esset(or however you spell that thing)?
Go to the top of the page
 
+Quote Post
KeyMasterOfGozer
post Jun 22 2004, 02:27 PM
Post #136


Moving Target
**

Group: Members
Posts: 239
Joined: 10-February 04
Member No.: 6,068



QUOTE (prionic6)
The sr3-import won't work with melee manouvers... The Line in the file is
MYSQL QUERY ERROR!!
Query: INSERT INTO sr3_skills (character_id, skill, skill_rating, specialization, spec_rating, linked_attribute) VALUES (287, 'Kung Fu', 2, 'MN:Fußtritt~[2]=4X ', , 3)
Problem: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' 3)' at line 1

Oh, I'm an idiot, the VALUES clause has 2 commas right together before the last "3". That is what is causing the error, but of course without looking at how the source generates that SQL statment, I can't help to solve it. If that value is really NULL, then you'd need to put a NULL or empty string there inbetween the commas, like this:

VALUES (287, 'Kung Fu', 2, 'MN:Fußtritt~[2]=4X ', NULL, 3)

or

VALUES (287, 'Kung Fu', 2, 'MN:Fußtritt~[2]=4X ', '', 3)

in your php code, you could just put in a line:

if ($SpecRating == '') then $SpecRating = 'NULL';

of course substitute whatever variable you are using for $SpecRating.

or you could put ticks around the variable in the SQL statement string, since MySQL will automatically translate the string into a number. I am not positive it will work with the null, though, so the first solution is best.
Go to the top of the page
 
+Quote Post
Dashifen
post Jun 22 2004, 04:39 PM
Post #137


Technomancer
********

Group: Retired Admins
Posts: 4,638
Joined: 2-October 02
From: Champaign, IL
Member No.: 3,374



Yup. That'll do it. The parsers for the .sr3 files are pretty slim right now and I know of stuff that it's just plumb not importing. I think the problem is in the semantics of the maneuvers. Thery're not really specializations, but in the .sr3 file they're recorded as if they were. As such, they don't really get a rating and that's what's causing the parser to become confused. It's added to the list of things to do.
Go to the top of the page
 
+Quote Post
Dashifen
post Jun 22 2004, 04:43 PM
Post #138


Technomancer
********

Group: Retired Admins
Posts: 4,638
Joined: 2-October 02
From: Champaign, IL
Member No.: 3,374



QUOTE (KeyMasterOfGozer)

Once again, I'm not trying to convince you. It just sounded in your post like you had some possibly unfounded misgivings.


Okay, I see your points. I'll consider it. I hadn't thought of sourceforge.net when I responded to prionic6 earlier, I had only thought of providing access to my webspace to others who would work on the files there as opossed to having external development. For now, even after considering the valid points above, I think I'm still going to keep plugging away. There are a number of things that I still want to put together for the site. Plus, I don't really want to have divergent systems available where other people have encorporated other ideas and concepts into the system. I think it could confuse people. Anyway, long story short, my play is over now, so I'll get back to bug fixing this week and next since my job doens't start up until July 12. Hopefully, I'll get my backlog finished long before then and I'll get started on trying to cover all of the mysql queries with more useful error messages :)
Go to the top of the page
 
+Quote Post
Dashifen
post Jun 24 2004, 04:02 PM
Post #139


Technomancer
********

Group: Retired Admins
Posts: 4,638
Joined: 2-October 02
From: Champaign, IL
Member No.: 3,374



Okay ... working on getting the page titles to not show you the page id (md5 hash of the filename) that I was using before. While I fix the bugs above, I'll change page titles as I go. To try and be sure that I don't miss any, if you all could post pages that have bad titles below. Hopefully I'll get them all soon so we won't have pages and pages of posts about bad titles.

Also: quick poll here -- who would find a notes page helpful? Just something that would provide you a spot to type a note to yourself and save it in the database. Then, you could delete notes when you don't need them anymore -- or perhaps they would auto delete after a month or so to save space. Any comments?
Go to the top of the page
 
+Quote Post
Kanada Ten
post Jun 24 2004, 11:07 PM
Post #140


Beetle Eater
********

Group: Dumpshocked
Posts: 4,797
Joined: 3-June 02
From: Oblivion City
Member No.: 2,826



The notepad is a good idea, but it should be persitant (the same notepad on every page), and maybe toggleable (like the Fast Reply here).

Hash marks on the first page following log in and all subsequent returns to the "GM's Home".

Hash marks on "Add a Game" and "Remove a Game."

Hash marks on "Add a Character" and "Remove a Character," but not "Edit."

Hash marks on all "Combat Tools" and "Matrix Tools" including sub pages.


Go to the top of the page
 
+Quote Post
Dashifen
post Jun 25 2004, 01:50 AM
Post #141


Technomancer
********

Group: Retired Admins
Posts: 4,638
Joined: 2-October 02
From: Champaign, IL
Member No.: 3,374



Hrm ... not a bad idea there, Kanada Ten. So, for example, you would want to be able to connect a note to any screen that you're on -- like if you were taking notes on a combat situation you'd want to have them only appear on the combat's status screen and not in a central location? What about both? Although, if the notes are already in the database, it's not hard to display them on multiple screens. Any other thoughs.

P.S. -- And thanks for the notes. I think I got most of those but I know I missed the Matrix Tools one. New pages with some fixes uploaded tomorrow morning when I get back to a broadband connection.
Go to the top of the page
 
+Quote Post
Kanada Ten
post Jun 25 2004, 02:58 AM
Post #142


Beetle Eater
********

Group: Dumpshocked
Posts: 4,797
Joined: 3-June 02
From: Oblivion City
Member No.: 2,826



I think each "Game" entry should have a notepad that holds the notes for all the "Tools."

For example:
Kanada opens the Day Job game and clicks on Mickey becasue Mickey just attempted to bribe the Mafia enforcer, Bobby. He goes the the skills section and clicks on "Negotiations 6." The dice roller spits out the results, and Kanada copies them into the Notepad (or clicks on "Send them to the Notepad"). Then he goes back and clicks on Bobby (error). He clicks on Bobby's Willpower to resist and compairs the dice roller results to the Notepad.

The error I got was from hitting the Bobby NPC. It appears that all NPCs are missing unless I use the "Edit a Character" tool. After I "Stop Editting" it allows me to view the character, but not if I go from the "Characters in..." screen. Also, it would be good to have names on the "Damage Record for..." screen link to the character sheets. Picky picky I know.

QUOTE
Not Found
The requested URL /dcrs/frames/content/database/characters/show_character.php was not found on this server.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.
Apache/1.3.31 Server at www.dashifen.com Port 80


For the "Notepad" function, what about a floating, sizable & minimizable child window? I know flash can do that, but it can be a pain. "Notepad for Day Job"

And when I attempt to return to the "Character List" I get another error:
QUOTE
MYSQL QUERY ERROR!!
Query: SELECT game_name FROM sr3_games WHERE (game_id = )
Problem: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1


[Edit] God, I sound like such an ass. Love the program Dashifen.
Go to the top of the page
 
+Quote Post
Dashifen
post Jun 25 2004, 12:57 PM
Post #143


Technomancer
********

Group: Retired Admins
Posts: 4,638
Joined: 2-October 02
From: Champaign, IL
Member No.: 3,374



You're not an ass -- your a tester :) You're supposed to do that. I know about the no npc from the character list problem -- I changed the file name and forgot to change it for npc's when I did it for pc's. I'll get that one shortly.

I'm not a big fan of floating windows because they get in your way. I'd be more inclined to add something to the bottom of everypage more like the Fast Reply idea you stated above. then, you could drop stuff into the text field and it would be persistent for your account. Making it persistent to a game would be more difficult because I don't always track which game you've most recently been involved with. However, with enough information (for your example, if the note pad would say Mickey -- Negotiations -- 08 06 05 03 01 01) Then it would be pretty easy to recall what the purpose of the note was.

And you know we have to call this the Pocket Secretary :silly:
Go to the top of the page
 
+Quote Post
Dashifen
post Jun 25 2004, 03:42 PM
Post #144


Technomancer
********

Group: Retired Admins
Posts: 4,638
Joined: 2-October 02
From: Champaign, IL
Member No.: 3,374



Bugs fixed today:

View NPCs from Game List now works (don't have to use the Edit a Character link)

Get back to correct list of characters from the view a character page

Link to character record from game's damage record

adding characters no longer throws a bad insert message on the damage record

Import other game's characters into your game has begun. It's not finished yet.

Can no longer edit other game's pc's (thanks Kanada Ten)
Go to the top of the page
 
+Quote Post
Kanada Ten
post Jun 25 2004, 10:08 PM
Post #145


Beetle Eater
********

Group: Dumpshocked
Posts: 4,797
Joined: 3-June 02
From: Oblivion City
Member No.: 2,826



QUOTE (Dashifen)
Can no longer edit other game's pc's (thanks Kanada Ten)

I think this is related. If you go into a game while Logged Out and click on a character:
QUOTE
MYSQL QUERY ERROR!!
Query: SELECT game_id FROM sr3_games WHERE owner_id=
Problem: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1


QUOTE
However, with enough information (for your example, if the note pad would say Mickey -- Negotiations -- 08 06 05 03 01 01) Then it would be pretty easy to recall what the purpose of the note was.

And you know we have to call this the Pocket Secretary

Yeah, that should work. :D
Go to the top of the page
 
+Quote Post
Kanada Ten
post Jun 26 2004, 08:01 PM
Post #146


Beetle Eater
********

Group: Dumpshocked
Posts: 4,797
Joined: 3-June 02
From: Oblivion City
Member No.: 2,826



Something weird happened. One of my NPCs named Lester is not the NPC I made. Did someone else make a character named Lester with the Friends Abroad Edge and a contact called Bad Czech? I used the SR3 import to do it and it was right once...
Go to the top of the page
 
+Quote Post
Dashifen
post Jun 27 2004, 03:32 PM
Post #147


Technomancer
********

Group: Retired Admins
Posts: 4,638
Joined: 2-October 02
From: Champaign, IL
Member No.: 3,374



Yeah, I forgot that you can't detect the gm if the gm isn't logged in for the character viewing. I wasn't done with that stuff anyway. Fixed in about fifteen minutes.

I'm not sure what happened with Lester, though. It shouldn't matter if the NPC has the same name as someone else as all characters are given incrementing numerical id's. Then, these id's are used to keep track of the characters and not their names. If you figure out what's up, let me know about that one.

Oh -- and I didn't do anything, either, considering I have god-like powers over the DCRS :)
Go to the top of the page
 
+Quote Post
Kanada Ten
post Jun 28 2004, 02:31 AM
Post #148


Beetle Eater
********

Group: Dumpshocked
Posts: 4,797
Joined: 3-June 02
From: Oblivion City
Member No.: 2,826



The Matrix tools are a little awkward. You need to make the Add Security an Edit Host function. Then have tabs like you do with the Character Sheet for Security Ratings, Security Sheaf, and the Note needs editing space. Also, there isn't any reason to stop the edit box for the Security Sheaf after they add Shutdown because you may want to add earlier trigger steps or whatever later. Also, there should be a way to add deckers at trigger steps. I know you can just type in Decker rating whatever, but it would be cool.

There is also a bug with the Log on to Host option where it doesn't keep the Decker displayed in the box.

Somehow my first ICe became an NPC too.

Change Tally doesn't do anything, though I don't know if it is supposed to.
Go to the top of the page
 
+Quote Post
Dashifen
post Jun 28 2004, 03:34 PM
Post #149


Technomancer
********

Group: Retired Admins
Posts: 4,638
Joined: 2-October 02
From: Champaign, IL
Member No.: 3,374



IC will become an NPC when you set up a matrix combat session from within the matrix tools. It's the only way that the system can recognize the IC as having initiative and reaction and what not. So that's what happened there.

I think the Change Tally does store the tally in the database. It won't appear to do anything the first time you look at the page, but if you return to the page later, the tally that you entered into the field and saved (by clicking change tally) will remain in the field. I'll check on that, and I thought I had it say "Tally Saved" underneat the button, but that may have just been what I wanted to do and not what I did do.

I'll check on the log on to host stuff. I don't think I've noticed it when I was working with my deckers.

Now, you're looking to take the concept of the host and its security and meld it into one page, I think, with your first comment. So you want a way to simply click on add a host and then enter security ratings and sheaf on the same page with a menu like on character editing. I don't see a major issue with that. However, I would prefer to have something like a link after you add a host that automatically takes you to the adding of security for that host. It would save a click and some time to move the mouse around if that link were more prominently displayed.

You're right on the closing of the fields after you enter shutdown. I think you can still edit old steps, but not enter new ones. I'll change that.

As for Deckers at trigger steps, what would you like it to say? I suppose it could provide a link to the NPC decker that you have in the database, but it wouldn't be too much more difficult to simply put the decker's name in the sheaf and then view them with the character viewer as normal.

Thoughts?
Go to the top of the page
 
+Quote Post
Kanada Ten
post Jun 30 2004, 12:22 AM
Post #150


Beetle Eater
********

Group: Dumpshocked
Posts: 4,797
Joined: 3-June 02
From: Oblivion City
Member No.: 2,826



QUOTE
As for Deckers at trigger steps, what would you like it to say? I suppose it could provide a link to the NPC decker that you have in the database, but it wouldn't be too much more difficult to simply put the decker's name in the sheaf and then view them with the character viewer as normal.

I didn't realize that you could add NPC deckers to the Host fight without logging them on. You can just use the Add Combatant tool, so no big deal.

I understand the Save Tally now.

Can you have the Shutdown button ask to confirm and then kick the deckers off the host and end the matrix combat?

Also, I think you should eliminate the "Log On" and "Graceful Log Off" tools. Simply make them part of the "Host Status" tool. Just have a pull down box with all deckers for the host's game in it and the buttons: "Log On." Next to or below the decker persona and tally you could add the "Log Off." You can also combine the "Add a Host" and "Remove a Host" into one tool page: "Add/Remove Host." Basically:

Matrix Tools
  • Add/Remove Host
  • Edit Host
  • Host Status


Then do the same with Combat:

Combat Tools
  • Add/Remove Fight
  • Fight Status


Next to the names in the fight just have a "Remove" button. Then have a pull down box with NPCs and PCs ready to fight next to an "Add Combatant" button at the bottom.

Totally unrelated, if you use a "Send Results to Pocket Secretary" function, have a check box next to that which defaults to checked. The function would be "Display Secretary on Click" (meaning that a minimized P'sec would open when the button was pressed). Have checked or not set a cookie, too.
Go to the top of the page
 
+Quote Post

8 Pages V  « < 4 5 6 7 8 >
Reply to this topicStart new topic

 



RSS Lo-Fi Version Time is now: 27th February 2025 - 08:22 PM

Topps, Inc has sole ownership of the names, logo, artwork, marks, photographs, sounds, audio, video and/or any proprietary material used in connection with the game Shadowrun. Topps, Inc has granted permission to the Dumpshock Forums to use such names, logos, artwork, marks and/or any proprietary materials for promotional and informational purposes on its website but does not endorse, and is not affiliated with the Dumpshock Forums in any official capacity whatsoever.