What's new
Star Army

Star ArmyⓇ is a landmark of forum roleplaying. Opened in 2002, Star Army is like an internet clubhouse for people who love roleplaying, art, and worldbuilding. Anyone 18 or older may join for free. New members are welcome! Use the "Register" button below.

Note: This is a play-by-post RPG site. If you're looking for the tabletop miniatures wargame "5150: Star Army" instead, see Two Hour Wargames.

  • If you were supposed to get an email from the forum but didn't (e.g. to verify your account for registration), email Wes at [email protected] or talk to me on Discord for help. Sometimes the server hits our limit of emails we can send per hour.
  • Get in our Discord chat! Discord.gg/stararmy
  • 📅 December 2024 is YE 46.9 in the RP.

Fleet Database (PANTHEON)

  • Thread starter Thread starter Anonymous
  • Start date Start date
Status
Not open for further replies.
A

Anonymous

I'm out of the alpha stage with my database backend generator and have a working beta now.

Wes, would you repost that info you wanted to be covered in the database? so I can get to work on getting the data diagrams drawn up for it?
 
Fleet Database Project

(Modified Repost)

Ships have the following attributes. Examples are in parenthesis and notes in brackets.

Ship Name (YSS Shotaiken)
Imperial Registry Number (NF-X1-3503)
Model (Ke-B4-1b Chiharu)
Manufactured by (Ketsurui Fleet Yards)
at (Hoshi no Iori Automated Factory)

Assigned Fleet (1st Expeditionary Fleet)
Under Taisho [Fleet Taisho's Name + taishoUserName ]
Assigned Unit [Should be 7 lines]
Assigned Captain (Shôshô Nishizaki Ayumi)
[Assigned Captain's Username] [Has Captain privs. for this ship]
Crew (Shôshô Nishizaki Ayana) [10+ lines]

Status (Active) [1 line]
This record was last modified on [Noted by Database] by [username]

History: [255 lines]
Notes: [10 lines]


Functions authorized users can perform:

Search by Ship Name or IRN
Browse by Fleet [Should sort by unit, then class, then IRN]

Assign Fleet (Admin)
Create Fleet (Admin)
Rename/Delete Fleets (Admin)
Create Ship Model (Admin)
Add User (Admin)

Edit Unit (Taisho+)
Edit IRN (Taisho+)

Edit Ship Name (Captain+)
Edit Crew (Captain+)
Edit Notes (Captain+)
Edit History (Captain+)
Edit Status (Captain+)


User Levels:
Admin (Wes)
Taisho (Has full privelidges for one fleet)
Captain (Has privelidges for a certain ship)
Guest (Read-only)
 
Re:

Here is a normalization of that data set. Tell me if I've missed anything. It could stand be normalized a bit more but unless you see an area that really specificly should be database-ized I think this will cover most of your needs.


TABLE: saf_users
------------
sys_id
username
password
access (LINK: saf_access.sys_id)

TABLE: saf_ships
------------
sys_id
name
registry_num
model
manufaturer
manufacture_loc
fleet (LINK: saf_fleets.name)
unit
captain (LINK: saf_users.username)
crew
status (LINK: saf_states.name)
mod_datetime (DATETIME)
mod_username (LINK: saf_users.username)

TABLe: saf_states
------------
sys_id
name

TABLE: saf_fleets
------------
sys_id
name

TABLE: saf_access
------------
sys_id
designation
 
*Hmms*

I don't understand all of it, but most of it seems okay.

Notes and History don't seem to be present.

Would you like me to create an HTML page with a GUI, or would you rather work which me as you're making it?

One thing I have been debating on is whether the links to edit fields would appear in a seperate block or as links next to the inidividual fields.

Also, I'd like to add a mission system in which I put up missions for admirals or captains to claim. (mission, mission_num, issued_by, mission_details, reward)

Since more fleets than just the Star Army will be using the database, I'm tempted to ask for a "Faction" field. In fact, yeah, we need one so when the fleets are listed, it can be used to sort them. (But the Star Army fleets should always be on top. The rest will be alphabetized)
 
I have a make database php script to give to you to create the database structure. What would be the best way for me to send it to you?
 
I'll email you the login information for your FTP account on StarArmy.com
 
Re:

Barring any of the following things:

My computer failing.
My brain failing.
My apartment colapsing.
Someone summoning meteor.

I should be finished or really damn close to it by tomarrow morning, *points at his 2-litter of mountian dew on on his desk* there's more where that came from.
 
Excellent.

Extra effort may be rewarded with Pocky.
 
Re:

For future reference, Wes, my e-mail is [email protected]

I have to change often, I seem to attract spam like.. well.. something that attracts a lot.. I'm really fucking tired.
 
Re:

Alrighty, here's where we are..

The script is done, which is awesome. All the stuff I want to work about it work, I'll probably find a thing to tweak here and there because I'm all a perfectionest like that when it comes to my code but.. for the most part its done.

The means 3 more things have to happen....

A, I have to write a control structure that dictates how this script is executed. Easy stuff compaired to writing hte script itself, however, I can't do this untill I complete III, read on.

2, I have to write a display function, probably two display functions that you can plug into your page in order to display data. This again is a cake-walk, easier even then A.

III, I have to install the database structure. This is the hard part. Because while you gave me an FTP account, it seems to be a sub-user access I can do nothing from. Also, I need to have the MySQL database username and password before I can run any script that effects it. Wes, I'm not even sure what the URL is for the space this FTP account points to, and I poked around awhile for it. I understand the need for security and whatnot but unless you want me to try to explain to you process by process how to install this I'm going to need root access. That should be a drop in the bucket after agreeing to run a script I wrote.

Yes, I knew I used a different numbering scheme for each.

Finally, I'm gonna go ahead and upload the script, called php_dbg.php into the FTP you gave me. It can do nothing from that postion, but yo ucan look at it to see that it really is there and really does have a bunch of stuff in it. I'm also going to upload stararmy_create_db.php, which is the script that will create the database structure, this script wont' function untill the database username and password is plugged into it though.

In the meantime buddy. I'm leaving tomarrow night to go home for the 4th. I won't have PC access for awhile, but since I'm deticated to keeping contact with anyone who's trying to pay me money I'll mail you out my cell if you post an e-mail address for me to send it to by tomarrow.

Later bro, bedtime for this engineer!
 
I sent it to you!
 
Status
Not open for further replies.
RPG-D RPGfix
Back
Top