Database editor?

Matrix Games Forums

Forums Register Login Photo Gallery Member List Search Calendars FAQ

My Profile Inbox Address Book My Subscription My Forums Log Out

Database editor?

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> [New Releases from Matrix Games] >> Command: Modern Operations series >> Database editor?

Page: [1]

Message

<< Older Topic Newer Topic >>

Database editor? - 10/5/2013 6:58:03 AM

Stevechase

Posts: 161
Joined: 10/5/2013
Status: offline

Finally bought Command. Wondering if there are plans for a database editor in the future. If not produced by the dev team would it be possible for some of those more savvy users to create one.

Post #: 1

RE: Database editor? - 10/5/2013 9:18:08 AM

bsq

Posts: 517
Joined: 1/5/2007
Status: offline

You can look at it and potentially edit it in SqlLite, but it looks like a reasonably big and complex relational database with lots of look-up tables and modular stuff that you would need to understand before diving in.

(in reply to Stevechase)

Post #: 2

RE: Database editor? - 10/5/2013 2:36:08 PM

Mgellis

Posts: 2054
Joined: 8/18/2007
Status: offline

It is also possible to edit some platforms to an extent in the scenario editor itself, by adding or deleting weapons, sensors, etc.

(in reply to bsq)

Post #: 3

RE: Database editor? - 10/5/2013 2:39:17 PM

mikmykWS

Posts: 11524
Joined: 3/22/2005
Status: offline

quote:

ORIGINAL: Stevechase

Finally bought Command. Wondering if there are plans for a database editor in the future. If not produced by the dev team would it be possible for some of those more savvy users to create one.

We offer some db edit features in the editor and have no current plans to follow Harpoon's paradigm.

Mike

_____________________________

(in reply to Stevechase)

Post #: 4

RE: Database editor? - 10/5/2013 2:43:27 PM

thewood1

Posts: 6529
Joined: 11/27/2005
Status: offline

IIRC, Harpoon was not an open db on release, right? I think it took a couple years for the db to be hacked or figured out.

(in reply to mikmykWS)

Post #: 5

RE: Database editor? - 10/5/2013 2:48:01 PM

mikmykWS

Posts: 11524
Joined: 3/22/2005
Status: offline

It had its own editor after so many releases I think.

_____________________________

(in reply to thewood1)

Post #: 6

RE: Database editor? - 10/6/2013 4:16:50 AM

Stevechase

Posts: 161
Joined: 10/5/2013
Status: offline

quote:

ORIGINAL: mikmyk

quote:

ORIGINAL: Stevechase

Finally bought Command. Wondering if there are plans for a database editor in the future. If not produced by the dev team would it be possible for some of those more savvy users to create one.

We offer some db edit features in the editor and have no current plans to follow Harpoon's paradigm.

Mike

I must say that is very disappointing. Had I known that I would not have shelled out the $80.00. Not your fault though. I should have paid better attention to the advertised features. Just assumed it would be far better than Harpoon in every way.

(in reply to mikmykWS)

Post #: 7

RE: Database editor? - 10/6/2013 5:13:33 AM

mikmykWS

Posts: 11524
Joined: 3/22/2005
Status: offline

Sorry to disappoint Steve but this is the path we've chosen.

_____________________________

(in reply to Stevechase)

Post #: 8

RE: Database editor? - 10/6/2013 5:37:20 AM

Stevechase

Posts: 161
Joined: 10/5/2013
Status: offline

Ok, Got it.

(in reply to mikmykWS)

Post #: 9

RE: Database editor? - 10/6/2013 5:49:13 AM

Elouda

Posts: 183
Joined: 2/16/2008
From: Helsinki, Finland
Status: offline

Could you clarify if this also means there are no plans to expand the current 'scenario-specific database editor' options in the the scenario editor (for example being able edit weapon magazines or unit properties)?

(in reply to Stevechase)

Post #: 10

RE: Database editor? - 10/6/2013 5:51:56 AM

mikmykWS

Posts: 11524
Joined: 3/22/2005
Status: offline

No we need to get the add mag function in although you can actually do it with a config file. As our plans stand right now all future db edit feature work will be done in the scenario editor or through the config files.

Mike

_____________________________

(in reply to Elouda)

Post #: 11

RE: Database editor? - 10/6/2013 1:43:01 PM

ComDev

Posts: 5735
Joined: 5/12/2006
Status: offline

You can edit mags, mounts, sensors, comm links (weapon datalinks) through script files. Details on how to do this can be found in the Manual

_____________________________

Developer "Command: Modern Air/Naval Operations" project!

(in reply to mikmykWS)

Post #: 12

RE: Database editor? - 3/10/2014 6:33:16 PM

alex2000

Posts: 4
Joined: 12/29/2013
From: Livorno (ITALY)
Status: offline

Hi Ragnar.

Unfortunately, the manual doesn't explain clearly how change the platform components, especially using the "scripts".
Maybe it would be appropriate to post some tutorials or some examples to do this.

Thanks and bye.

Alex from Leghorn (Italy)

(in reply to ComDev)

Post #: 13

RE: Database editor? - 3/10/2014 11:19:54 PM

orca

Posts: 501
Joined: 11/6/2013
Status: offline

just the last post after I posted something similar in another forum... had the same experience as Alex

(in reply to alex2000)

Post #: 14

RE: Database editor? - 3/11/2014 1:46:53 PM

ComDev

Posts: 5735
Joined: 5/12/2006
Status: offline

Oki doki, no problem. What parts of chapter 7 in the manual do you think are unclear?

_____________________________

Developer "Command: Modern Air/Naval Operations" project!

(in reply to orca)

Post #: 15

RE: Database editor? - 3/11/2014 6:19:51 PM

alex2000

Posts: 4
Joined: 12/29/2013
From: Livorno (ITALY)
Status: offline

Hi Ragnar

The unclear part of Chapter 7 is the part regarding the modify of platforms via script (In fact it is quite unintelligible), moreover it doesn't explain how to use the script in the scenario building.
It would require a tutorial more clear and understandable even by beginners.

Thanks and bye

Alex from Leghorn (Italy)

< Message edited by alex2000 -- 3/11/2014 7:34:55 PM >

(in reply to ComDev)

Post #: 16

RE: Database editor? - 3/11/2014 6:40:57 PM

KEYSTONE07950

Posts: 177
Joined: 12/17/2006
Status: offline

quote:

ORIGINAL: alex2000

Hi Ragnar

The unclear part of Chapter 7 is the part regarding the modify of platforms via script (In fact it is quite unintelligible), moreover it doesn't explain how to use the script in the scenario building.
It would require a tutorial more clear and understandable even by beginners.

Thanks and bye

Alex from Leghorn (Italy)

I agree 100%. A step by step tutorial would be most welcome.

PS- Thanks for this great sim. It's occupying (productively) all my spare time.

(in reply to alex2000)

Post #: 17

RE: Database editor? - 3/12/2014 4:35:13 PM

ckfinite

Posts: 377
Joined: 7/20/2013
Status: offline

It's actually a pretty nice normalized design, so it's easy to understand. You can edit most things by hand easily, you just have to remember/write down a lot of IDs to do so. I'm trying to get a nice abstraction layer set up for .NET (EF6), but there are some issues, mostly on the framework side.

(in reply to bsq)

Post #: 18

RE: Database editor? - 3/13/2014 7:44:29 AM

SaneStatistician

Posts: 11
Joined: 1/24/2014
Status: offline

quote:

ORIGINAL: ckfinite

It's actually a pretty nice normalized design, so it's easy to understand. You can edit most things by hand easily, you just have to remember/write down a lot of IDs to do so. I'm trying to get a nice abstraction layer set up for .NET (EF6), but there are some issues, mostly on the framework side.

Please remember that by reverse-engineering the database you violate the terms of your license.

(in reply to ckfinite)

Post #: 19

RE: Database editor? - 3/13/2014 2:59:29 PM

orca

Posts: 501
Joined: 11/6/2013
Status: offline

Even better than a tutorial would be a new feature in the scenario editor the automates the saving of changes make. Saving/copying using scripts seems to be not ideal and too complicated. I doubt it will be used with often because of this.

I've requested this before but since we on this topic-
I'd love new features to:

Be able to automatically save unit changes in scen editor, be able to import to file edited units, and be able to clone edited units.

BTW- I respect devs decision regarding limiting editing to scenario editor. These requests don't change that but just makes what is currently possible much easier.

< Message edited by orca -- 3/13/2014 4:06:54 PM >

(in reply to SaneStatistician)

Post #: 20

RE: Database editor? - 3/14/2014 5:49:03 PM

ckfinite

Posts: 377
Joined: 7/20/2013
Status: offline

quote:

ORIGINAL: SaneStatistician

quote:

ORIGINAL: ckfinite

It's actually a pretty nice normalized design, so it's easy to understand. You can edit most things by hand easily, you just have to remember/write down a lot of IDs to do so. I'm trying to get a nice abstraction layer set up for .NET (EF6), but there are some issues, mostly on the framework side.

Please remember that by reverse-engineering the database you violate the terms of your license.

Surprisingly, it isn't actually violating the license. To quote the license,

quote:

You may not copy, reproduce, translate, decompile,
reverse engineer, disassemble, modify, or create derivative works from
the assembled code or any part thereof

(Emphasis mine, this is from the EULA, S.2 ).

This means that it does violate the license to use a decompiler like DotPeek on the Command executable (which I have not done), or to examine the CIL code, for that matter. However, unless the database is originally described in code that is then assembled (which I doubt), then it is not covered under the EULA.

This isn't very hard to fix, as far as I can tell. They just need to change "the assembled code or any part thereof" to "the software and included data, or any part thereof". Based on the lack of a clause alone, it seems that they'd be okay with a third-party analysis of the DB. I'm more than happy to abide by their wishes, if they don't want a DB editor, though.

What I do for JASSM-ERs on F-35...

(in reply to SaneStatistician)

Post #: 21