Didn't like a knowledge skill suddenly while entering it. But it works now.

[edit] Wohoo! The error is from forgetting to put in a skill rating!

When I try to change the password.

Gah! You're right. Good navigational error find! I'll get that one fixed tomorrow night. Storm knocked out my internet connection so I'm at a public computer at the moment.

Also, paul: That can happen. Depending on the vehicle and terrain, you can get 0 points for those categories. I'm not sure, off the top of my head, which vehicles they are, but normal terrain gets you 0 points. The speed points are 1/10th of the total speed (round down) and the driver points are the highest roll (with rule of six) amoung the dice rolled.

So, for the scenario you posted, the vehicle was worth zero points (a normal car perhaps??) in normal terrain going between 100 and 109 meters per turn and the driver rolled 8 dice with the result of 7 -- therefore you'd have a maneuver score of 17.

I see. I was having trouble figuring that out, too. Now that I know the symptoms, I'll code up a cure.

As for the importation thingy, yeah, it's got it's issues. I couldn't figure out what the blank fields were for. i've never used the carried/not carried boxes in NSRCG so I didn't know what was going on. I'll have to figure out what's different in the .sr3 file between the two "types" of gear and then write a fix.

It also doesn't get any magical gear yet, because that's in a different section of the whole thing. Adept powers have to be entered as spells for the time being, too. Just don't forget to put something in for their "force" so it doesn't yell at you.

As for making it a stand alone thing. Right now, it's not feasible or possible. Everything is running on a PHP/MySQL backbone which means people would first have to install a web server on their machine and all the crap that comes with it, then PHP, then MySQL and then get all my code. Most people probably wouldn't be willing to do that. Of course, I could recode the entire project into C++ with a MS Access backbone (or other ODBC compatible database solution) but that would take months. Plus, the major reason I started this thing was so that I could get to my character's and my player's information from anywhere on campus. That way I didn't have to carry notes around in my pockets and wallet anymore. About the third time I lost track of character sheets because I did the laundry and forgot to remove them from my back pocket, I decided there had to be a better way!!

Hell yeah. I was thinking along the same lines in that you could export characters as .SR3 files, as well. However, you should allow GMs to make their NPCs "Private" if they choose, just to prevent "industrious" players from simply making GM accounts in order to look at the NPCs. It's not something I would worry about, but with Play by Post games you don't always know who you're dealing with. Anyway...

On the issue of portability, how difficult would it be to implement the DCRS on a web server that runs a Forum? If you get all the bugs worked out and many people want to use it, you could talk to Dumpshock about hosting it.

However, it is actually creating the character sheets, because I can edit them to my hearts content

Loving the concept, and I think this is going to save me tons of hassle in the long run. Thanks for all the hard work, and I'm tossing this out there as more of an FYI then a criticism.

Not too difficult at all. The real issue is porting the database and the data from one place to another. I'd rather get a stable, working, and aesthetic version before I worry about connecting myself to anyone else. In reallity, what I'd think about doing first would be to host the "external" pages (home and login, features, signup, etc.) at dumpshock and then leave the database where it is.

Yeah, I know about that one. Thanks though. As an FYI for all of my users, I'm in a play opening on June 17th so I'm doing set building all day and then practice all night so I'm somewhat stagnated on getting work done on the DCRS. So far, I don't think any of the bugs are really debilitating, just annoying, so I'm kinda focusing on the other things in my life for a while. I'll get back to everything, I promise!

Feel free to email me about questions regarding NSRCG. I'm also willing to entertain 'suggestions and improvements' Question: Are you using the default SR3 file or the XML file? thanks

Oh, then it's easy. Carried items have an "X:" in front of them. An example:

Gear0=X:[5]Cue_Ball__________________(CB)_~2|8|-|(STR)L|2.5|Always|5|1|Legal|sr3.XXX|

Quantity = 5

Okay, the format for almost all of the Gear, Vech, Deck, Cyber, Bioware is included at the top of their respective DAT files.
Documentation on the DAT files is at:
DAT file documentation

In particular, an example:
Gear3=__Concealable_Holster___________~6|-|(+2)|-|0.1|2/24hrs|100|.75|SR3-282|

You are correct. Spaces = "_" and field delimiters are "~", EXCEPT when the delimiter is also a "|". In the above example,
Name: Concealable holster
Format: 6

Locking up the 6 format in GEAR.DAT:
0-6|Firearms Accessories|9|Mount|Concealability|Rating|Weight|Availability|$Cost|Street Index|Notes|Book.Page|

Title: Firearms Accessories with 9 items which are as follows:

Mount: -
Concealability: (+2)
Rating: -
Weight: 0.1
Availability: 2/24 hrs
Cost: 100
Street Index: 0.75
Notes: SR3-282
Book.Page: (there is an error here, the notes should have been blank and the book.page should have been here)

This format is followed for most things.

Skill is obvious.

Lifestyle is defined as: Field Number : Definition
1 ) Quantity of months in parenthesis or permanent, level of lifestyle, 1st 25 characters of the residence name
2) Primary or secondary
3) level of lifestyle
4) permanent or temp lifestyle
5) # of months
6) Cost
7) Starting month / year
Residence (complete)
9) LTG #
10) Description of residence
11) (I use this)....


Contacts are defined as Field Number : Definition
1) Name
2) Location
3) Archetype
4) LTG#
5) Occupation
6) Contact Level
7) Race/Description
History / Relationships
9) Cost

Attributes are:
Base number | Racial Mod | Natural Mod | Cyber Mod | Totals

You'll have to add together to get totals = Base number+racial+natural "(" base number+racial+natural+cyber ")"
Best solution is use the "Totals" string.... (You must have looked at an older format)....

Except when cyber arms or legs are involved. Then the base number starts at 4... (confusing isn't it?)

Should be enough to get you started... Let me know if you have further questions...

Also, I've been debating whether to use XML as the storage format (but that'd take a couple of months minimum)... Any preferences?
mcmackie

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.

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.

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

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:

[Edit] God, I sound like such an ass. Love the program Dashifen.

I think this is related. If you go into a game while Logged Out and click on a character:

Yeah, that should work. :D

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.