RE: Online Database Viewer (Full Version)

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



Message


RoryAndersonCDT -> RE: Online Database Viewer (1/25/2014 3:51:06 AM)

Thank you for that. [:)]




claystone_MatrixForum -> RE: Online Database Viewer (1/25/2014 4:12:44 AM)

I'm just amazed at the work that has gone into this.

I have to say nice work, Baloogan.




RoryAndersonCDT -> RE: Online Database Viewer (1/25/2014 5:13:26 AM)


quote:

ORIGINAL: DROregon

(Newbie question)
How does one know the Helo capacity of a ship (eg. DDG) without looking at the picture?
I can't find answer by looking at database stats.

Air facilities on ships and land units added [:)]
Kitty Hawk: http://wiki.baloogancampaign.com/index.php/DataShip?ID=778
Runway: http://wiki.baloogancampaign.com/index.php/DataFacility?ID=757




RoryAndersonCDT -> RE: Online Database Viewer (1/25/2014 9:35:16 AM)

Database Search! [:)]

[image]http://i.imgur.com/UBzUK5U.png[/image]




smudge56 -> RE: Online Database Viewer (1/25/2014 9:57:11 PM)

Man mate how do you get the time to eat lol. Excellent work you are really adding so many extra items to this game to enhance the gaming experience on an already great game.

Just cannot wait for global war [&o]




RoryAndersonCDT -> RE: Online Database Viewer (1/25/2014 10:28:58 PM)

quote:

ORIGINAL: Skyhigh

Samsung Note 2 with the standard browser

[image]local://upfiles/38492/3DEFC519E6684BC7B52ABC377E0C37A8.jpg[/image]


If you wouldn't mind, could you please show me what the database viewer looks like now on your platform? I've cleaned up the design based on what it looked like on your screen : )

Edit: also anyone else with a non-desktop platform; images are really quite helpful to let me know what needs fixing or tweaking.




RoryAndersonCDT -> RE: Online Database Viewer (1/26/2014 4:22:36 AM)

[image]http://i.imgur.com/MYGagY3.png[/image]

Now the database viewer has the ability to have user editable descriptions! If you would like to help make the database viewer better please add some descriptions. [:)]




CaptCarnage -> RE: Online Database Viewer (1/26/2014 8:25:11 AM)

They should give you a medal.

[image]local://upfiles/38492/13FBF639E9C649BB872387A23FAC425A.jpg[/image]




CaptCarnage -> RE: Online Database Viewer (1/26/2014 8:26:25 AM)

.

[image]local://upfiles/38492/DAB37BB5661644F6AD815BDF9169C450.jpg[/image]




CaptCarnage -> RE: Online Database Viewer (1/26/2014 9:09:14 AM)

Would it be an idea to include a section on scenarios e.g. scenario descriptions? From official scenarios and popular fanbased ones?




Blu3wolf -> RE: Online Database Viewer (1/26/2014 9:29:45 AM)

already there skyhigh...

just needs editors. feel free to help!

http://wiki.baloogancampaign.com/index.php/List_of_Community_Scenarios

EDIT: If you have a look at the main page here http://wiki.baloogancampaign.com/index.php/Main_Page there is a pretty good index of pages there.




RoryAndersonCDT -> RE: Online Database Viewer (1/26/2014 10:16:21 AM)


quote:

ORIGINAL: Skyhigh

Would it be an idea to include a section on scenarios e.g. scenario descriptions? From official scenarios and popular fanbased ones?

Yup that would be a great idea! Many hands make light work [:D]
All you need to do is make an account and then please feel free to edit in and create any pages you desire!




RoryAndersonCDT -> RE: Online Database Viewer (1/26/2014 10:31:56 AM)

Also thanks so much for the screenshots! Its looking pretty good now! [:D]




djoos5 -> RE: Online Database Viewer (1/26/2014 2:51:23 PM)

This is really fantastic! I have never edited a wiki page before, but I will take a look. I promise I won't touch anything unless I get a feel for how it works. [;)]




ultradave -> RE: Online Database Viewer (1/26/2014 9:29:10 PM)

This whole database viewer is really great. What a great resource. Easy for me to use to as I play in W7 on Parallels Desktop on a MacBook pro. With an extra monitor plugged in or using spaces if not, I can have this available on another screen.

Have to find the database reporting thread. Just looking at the SEAWOLF entry I see it says 2 nuclear reactors. Not correct, there is only one.


quote:

ORIGINAL: Baloogan

Might be time to brush up on some Submarines too! [:D]

Akula: http://wiki.baloogancampaign.com/index.php/DataSubmarine?ID=134
Ohio: http://wiki.baloogancampaign.com/index.php/DataSubmarine?ID=274
Seawolf: http://wiki.baloogancampaign.com/index.php/DataSubmarine?ID=99

Submarines!!




guanotwozero -> RE: Online Database Viewer (1/30/2014 12:38:24 PM)

Yep, this is really good work! [:)]

OK, I'd like to seriously ask if it would be possible to get the game to redirect to this (as an option) instead of using the in-game db box. It would be very convenient.

Assuming your server can cope, that is [;)]




RoryAndersonCDT -> RE: Online Database Viewer (1/30/2014 9:13:58 PM)

I wrote this program to help with using the online database at the same time as playing Command. It isn't perfect, but it does work. [:)]



quote:

ORIGINAL: Baloogan

Check out the newest Baloogan Campaign program!
General Staff

[image]http://i.imgur.com/K5rBs71.png[/image]

[image]http://i.imgur.com/qOkpDyg.png[/image]

It reads the autosave that Command provides and gives you a list of all the units in the currently playing scenario in Command. When you double click on an entry it will open up the new Online Database Viewer to that unit's page!! Only works for DB3000. :)

Available now! http://baloogancampaign.com/baloogan-campaign-launcher/







mikmykWS -> RE: Online Database Viewer (1/30/2014 9:53:11 PM)


quote:

ORIGINAL: guanotwozero

Yep, this is really good work! [:)]

OK, I'd like to seriously ask if it would be possible to get the game to redirect to this (as an option) instead of using the in-game db box. It would be very convenient.

Assuming your server can cope, that is [;)]



Not right now but it could be something that is on the table for the future.

Thanks!

Mike




RoryAndersonCDT -> RE: Online Database Viewer (2/2/2014 4:08:30 AM)

Weapons, with reverse lookup!

7.62mm MG Burst [20 rnds]
http://wiki.baloogancampaign.com/index.php/DataWeapon?ID=1415

See the platforms and loadouts that include the weapon you select!!


1000lb bomb!
http://wiki.baloogancampaign.com/index.php/DataWeapon?ID=1925


Means you can click on a falcon
http://wiki.baloogancampaign.com/index.php/DataAircraft?ID=1034
Then click on 20mm/85 M61A1 Vulcan Burst (100 rnds)
http://wiki.baloogancampaign.com/index.php/DataWeapon?ID=1918
or AN/ALQ-131 DECM Pod
http://wiki.baloogancampaign.com/index.php/DataWeapon?ID=149




guanotwozero -> RE: Online Database Viewer (2/2/2014 4:49:47 PM)

Oh yes, this just keeps getting better!

Can you reveal any of your tech secrets, e.g. what db you use, what schema methodology? Or would you then have to kill us? [:)]




RoryAndersonCDT -> RE: Online Database Viewer (2/2/2014 7:56:24 PM)

I use the same schema as the command database; I use MySQL. I can't give you any information about DB3000 because they aren't my secrets to give away. [:)]

But I can tell you a bit about what I do to the database. I've written a script to translate a sqlite database into a compressed mysql SQL statement. I then apply my own indexing to the MySQL databases; which is one of the reasons why 'reverse weapon lookup' operates so fast. [:)]

The source code for displaying the data is open; you guys can go look at it [:)] and edit (!) it if desired. I use a number of custom mediawiki extensions to make this all possible.
Eg: DataAircraft: http://wiki.baloogancampaign.com/index.php?title=Template:DataAircraftLong edit link: http://wiki.baloogancampaign.com/index.php?title=Template:DataAircraftLong&action=edit

If you are going to edit it please get in touch with me first; and we can figure out a good way to use your skills! (And set you up a sandbox so you are not working on the live database viewer)

Also if would like to edit wiki pages like http://wiki.baloogancampaign.com/index.php?title=Fixed_Wing,_Carrier_Capable&action=edit&redlink=1
or http://wiki.baloogancampaign.com/index.php?title=Night_Navigation/Attack_(Incl._Bomb,_Rocket_Delivery)&action=edit&redlink=1
or http://wiki.baloogancampaign.com/index.php?title=Probe_Refuelling&action=edit&redlink=1
or http://wiki.baloogancampaign.com/index.php?title=Terrain_Avoidance_(Land:_300ft_(91.4m),_Sea:_100ft_(30.5m))&action=edit&redlink=1
or http://wiki.baloogancampaign.com/index.php?title=Standoff_Strike,_Land/Naval&action=edit&redlink=1
it would be much appreciated! Lots of people don't know anything about these topics; and the way the wiki is set up you get a link to the above properties if you view an A/C with them. [:)]

Another thing you can do is edit the descriptions of the aircraft/weapons/ships/etc!

[image]http://i.imgur.com/dMuOf9j.png[/image]

If there are a number of aircraft near and dear to your heart; or if you just want to help make this wiki a better place to find info please edit some unit descriptions! Another way to help would be to copy paste data from the already existing description files!
Putting <ref>This is a reference http://source.aircraft.com/page_1234</ref> in your description will automatically make a references part of the page!




Please help me make this a great community resource!!




guanotwozero -> RE: Online Database Viewer (2/3/2014 9:49:37 PM)

Clever solution!

I'm not sure I'd be much use editing the data as my naval/aerospace knowledge lags some way behind my tech skills, but it's good to see you've left that door open for those who can.




RoryAndersonCDT -> RE: Online Database Viewer (2/3/2014 10:01:23 PM)


quote:

ORIGINAL: guanotwozero

Clever solution!

I'm not sure I'd be much use editing the data as my naval/aerospace knowledge lags some way behind my tech skills, but it's good to see you've left that door open for those who can.



Thanks [:)]

I figured that the best way to kill this database viewer would be to 'lockdown' the code so only I could edit it. The only thing that isn't editable right now is the 'weapon reverse lookup' because its more efficient to do that via an external script.

I want the wiki to be a communal project; which means its in your hands! Anyone can make an account on the wiki and right away start editing the underlying code of the database viewer!

Please do so! If there is some aspect that you want to see on the database viewer please post requests here; and if you know SQL or CSS or even someone who knows how to make tables look pretty on a website the database viewer could use your help!!

Also I'd like to give credit to our active wiki users! You guys deserve a round of applause! [sm=00000436.gif]


Awesomesauce47‏‎ (Geoscape_08_REDFOR) [3 actions in the last 30 days]
Blu3wolf‏‎ (Geoscape_08_BLUFOR) [52 actions in the last 30 days]
BrassEm [68 actions in the last 30 days]
Cdu801‏‎ (Geoscape_08_REDFOR) [10 actions in the last 30 days]
Choowee‏‎ (Geoscape_08_BLUFOR) [12 actions in the last 30 days]
Dandin384‏‎ (Geoscape_08_ADMIN, Geoscape_08_BLUFOR, Geoscape_08_REDFOR) [1 action in the last 30 days]
Fox1‏‎ (Geoscape_08_REDFOR) [26 actions in the last 30 days]
GreatTop‏‎ (Geoscape_08_REDFOR) [11 actions in the last 30 days]
Javafiend [9 actions in the last 30 days]
Jtoatoktoe [2 actions in the last 30 days]
Smudge‏‎ (Geoscape_08_BLUFOR) [6 actions in the last 30 days]
Zathras [19 actions in the last 30 days]


You guys are awesome! [:)] Thanks so much!




RoryAndersonCDT -> RE: Online Database Viewer (2/4/2014 6:57:54 AM)

Oh and sensors work in the database viewer

Index: http://wiki.baloogancampaign.com/index.php/DataSensorList

AN/AAR-57 CMWS http://wiki.baloogancampaign.com/index.php/DataSensor?ID=2484
AN/FPS-6C HF http://wiki.baloogancampaign.com/index.php/DataSensor?ID=3221
IIR Seeker -- Taurus http://wiki.baloogancampaign.com/index.php/DataSensor?ID=2973
Anritsu RA 720UA -- - http://wiki.baloogancampaign.com/index.php/DataSensor?ID=3854


Also lets take a look at the F-35A's sensor package!
F-35A: http://wiki.baloogancampaign.com/index.php/DataAircraft?ID=278

ELINT
AN/ALR-94
http://wiki.baloogancampaign.com/index.php/DataSensor?ID=595

AN/APG-81 AESA
Radar, FCR, Air-to-Air & Air-to-Surface, Medium-Range
http://wiki.baloogancampaign.com/index.php/DataSensor?ID=2081

AN/AAR-56 PMAWS
MAWS, Missile Approach Warning System
http://wiki.baloogancampaign.com/index.php/DataSensor?ID=2426

AN/AAQ-37 EO-DAS
LLTV, Day/Night Spherical Situational Awareness & Fire Control
http://wiki.baloogancampaign.com/index.php/DataSensor?ID=2509


EOTS [Laser Designator]
Laser Target Designator & Ranger (LTD/R)
http://wiki.baloogancampaign.com/index.php/DataSensor?ID=3466

EOTS [IRST]
Infrared, Navigation / Attack FLIR & Air-to-Air Tracking
http://wiki.baloogancampaign.com/index.php/DataSensor?ID=2510


Make sure to take a look at the F-35's cannon!
25mm GAU-22/A Equalizer Burst [30 rnds]
http://wiki.baloogancampaign.com/index.php/DataWeapon?ID=1718
Which has a "25mm Burst (30 rnds)" warhead with High Explosive (HE) Blast / Frag, TNT (Trinitrotoluene)!!!


The F-35 carries the AIM-120D AMRAAM P3I.4
http://wiki.baloogancampaign.com/index.php/DataWeapon?ID=51
Which carries a AIM-120C-5/6/7 (WDU-41/B) 18kg/40lb Blast-Frag (8.6kg/19lb) High Explosive (HE) Blast / Frag HE (kg), PBXN-1XX warhead!


Each AMRAAM is tipped with a Active Radar Seeker -- AAM MR, AIM-120C-7
http://wiki.baloogancampaign.com/index.php/DataSensor?ID=2131


Some F-35 loadouts include the GBU-24A/B Paveway III LGB [BLU-109/B]
http://wiki.baloogancampaign.com/index.php/DataWeapon?ID=871
Which has a BLU-109/B 2000lb Penetrator (242kg/535lb Tritonal) Hard Target Penetrator (HTP) HE (kg), Tritonal warhead!

Guided by a Laser Spot Tracker (LGB) -- Paveway II CCG
http://wiki.baloogancampaign.com/index.php/DataSensor?ID=1674



Quite a bit of info!!!!! [:D]




RoryAndersonCDT -> RE: Online Database Viewer (2/4/2014 7:20:24 AM)

DB3000 is a masterpiece....

Thanks Ragnar! [:D]




RoryAndersonCDT -> RE: Online Database Viewer (2/6/2014 7:30:08 AM)

And..... May I present CWDB! http://wiki.baloogancampaign.com/index.php/DataAircraft?ID=1001632



See cold war relics beside modern weapons!
[image]http://i.imgur.com/4CI0UaD.png[/image]




downtown -> RE: Online Database Viewer (2/6/2014 9:56:02 AM)

Baloogan, I would like to help in this endeavor. I just added a description to the #1025 - D 602 Suffren DB3000 -- France (Navy), 1985-0, - ship in the online wiki. I actually copied it from wikipedia. Is this kind of what you expect us to do? It might be a good idea to give us a little more of a basic tutorial on how to do this? Like if I find a picture or a tech spec for something that is not yet filled in, how would I go about loading it? Or do you just want us to go "hog-wild?" I am new to the game and I think helping some with this, even a little, will help my immersion into the game and also give me an education on the later model weapons.




RoryAndersonCDT -> RE: Online Database Viewer (2/6/2014 10:28:37 AM)

Yeah! That is exactly the sort of thing which helps!

[image]http://i.imgur.com/QF41lMI.png[/image]

Quite the radome on that destroyer [:)]

Other things to add might be where it says "France" or "DDG - Guided Missile Destroyer" or "France Navy" could all be pages.

Also a little further down you can see "Nuclear Shock Resistant", and "Degaussed Steel Hull". If you knew about those topics; please feel free to create those pages.

Thanks downtown!

Ps: Many thanks to Javafiend for making a bunch of pages too [:)]


Oh, and for pictures; if you have a pile of pictures for units in the DB please get in touch with CV60; I've been importing the images from the image collection he curates.




CV60 -> RE: Online Database Viewer (2/6/2014 10:51:50 AM)

I'm always looking for photos of any weapons, facilities, ships and aircraft. I try to pull everything I see posted, and give the posters credit for images they send (the image credits are in a .txt file included with the download).
Myself and a small team of folks have also been posting the "System Descriptions" that you occasionally see available for download. I believe Baloogan has used some of these in the Wiki descriptions. We started this project to give the systems accurate, authoritative decriptions using a consistent, easily readable format.
If anyone wants to help with that, let me know. We are using a "format" of 4 section: Overview, Details, Notes, and Sources. The idea is to give the reader a "Bottom line up front" understanding in the overview section, and then provide a more in-depth understanding of the system in the "Detail" section, and "Nice to Know" information in the notes section. For example, the AS-2 and BN-21 system entry reads:

OVERVIEW: The AS-2 KIPPER (K-10SDV) is an air-launched, long-range, supersonic, liquid-fuel, turbojet-powered, anti-ship (ASM) missile. It had a 1000 kg HE warhead.

DETAILS: The AS-2 was designed primarily as an anti-ship weapon for use against large, high-value targets. It could also be used against large land targets. The AS-2 was typically launched at medium altitude. It then accelerated to approximately Mach 1.0 and cruised at about 10,000 meters using inertial navigation with an option of command correction for mid-course flight. At approximately 60 nm from the target, it entered a shallow 15 degree dive, leveling out at approximately 1000 meters altitude and 35 nm from the target. At approximately 10 nm from the target, the missile’s active radar activated, and guided the missile in the terminal phase. In the terminal phase, the AS-2 accelerated to approximately Mach 2 and dived into the target vessel close to or below the waterline.

NOTES: The AS-2 became operational in 1961. It was carried by the Tu-16K-10 (BADGER-C). It differed from the K-10 SD in its ability to be launched at a lower altitude. It had a CEP of 60 meters when used in an anti-ship role and a CEP of 1 to 2 nm when used against land targets.

SOURCES: Jane's Weapons Systems, Vol. 4: Strategic, "Kh-10S (AS-2 'Kipper')" 13 Oct 2011; GlobalSecurity.org - Reliable Security Information. "K-10S (AS-2 Kipper)." Accessed November 11, 2013. http://www.globalsecurity.org/wmd/world/russia/as-2.htm ; Federation of American Scientists. "AS-2 - Russian and Soviet Nuclear Forces." Accessed November 11, 2013. http://www.fas.org/nuke/guide/russia/bomber/as-2.htm ; Norman Polmar, "Guide to the Soviet Navy, 3rd ed. (Annapolis, MD: Naval Institute Press, 1983), 357.

OVERVIEW: The BM-21 Grad (Grad is Russian for "Hail as in "Hailstorm") is a 122mm multiple-launch rocket system (MLRS).

DETAILS: The BM-21 Grad was developed in the early 1960's and was first seen by The West in 1964. It was intended to replace WWII era MLRS systems such as the highly successful "Katyusha" rocket launcher. The BM-21 is a 122mm MLRS with 40 rifled tubes stacked horizontally in four rows of ten tubes. The tubes are on a pivoting platform attached to the bed of an unarmored 6x6 truck chassis, which give it the ability to engage different targets without moving the vehicle. The tubes are sighted in similar fashion to laying a mortar using sights mounted on the left side of the launcher. The 40 rockets can be ripple fired in about 20 seconds. The launcher was initially mounted on a Ural 375D 6x6 truck and upgraded to a Ural 4320 6x6 in 1976, but the launcher is versatile enough that it could be mounted on many different types of truck. The rockets themselves are unguided ballistic rockets and are over nine feet long. They are capable of being fitted with a variety of longer range rocket motors and different types of warheads to include DPICM, chemical, and incendiary. The 40 tubes are loaded by hand and can be accomplished by an experienced crew in about ten minutes.

NOTES: In Soviet service a rocket launcher battalion consisting of three batteries of 6 BM-21 launchers is found in the artillery regiment of the motorized rifle and tank divisions. There is also a rocket launcher regiment of three battalions of BM-21 launchers organic to the combined arms army and tank army. The artillery division that is organic to the Soviet front may also have a rocket launcher brigade with 72 BM-21 in three 24-launcher battalions (four batteries of 6 launchers each). The BM-21 is still in service with the Russian Army and was widely exported in large numbers to many different operators and the launcher has been mounted on many different types of vehicle. Most recent use was during the 2008 War in South Ossetia.

SOURCES: Military Factory. "BM-21 (Grad) - Multiple Launch Rocket System - - History, Specs and Pictures - Military Tanks, Vehicles and Artillery." Accessed November 26, 2013. http://www.militaryfactory.com/armor/detail.asp?armor_id=398 ; Weaponsystems.net. "BM-21 Grad." Accessed November 26, 2013. http://www.weaponsystems.net/weapon.php?weapon=DD05%20-%20BM-21%20Grad ; FM 100-2-3, "The Soviet Army: Troops, Organization, and Equipment." Washington D.C.: Headquarters, Department of the Army, 1991


If anyone wants to help with this, please PM me. I'm approaching the end of the DB3000 image collection, and will start emphasizing the description files in the near future.




quote:

Other things to add might be where it says "France" or "DDG - Guided Missile Destroyer" or "France Navy" could all be pages. Also a little further down you can see "Nuclear Shock Resistant", and "Degaussed Steel Hull". If you knew about those topics; please feel free to create those pages. Thanks downtown! Ps: Many thanks to Javafiend for making a bunch of pages too Oh, and for pictures; if you have a pile of pictures for units in the DB please get in touch with CV60; I've been importing the images from the image collection he curates.




RoryAndersonCDT -> RE: Online Database Viewer (2/6/2014 10:58:03 AM)


quote:

ORIGINAL: CV60
I believe Baloogan has used these in the Wiki descriptions.


Ah, only started to use them; it was a bit tricky to script an import from the description files; I initially started importing it manually but there were so many [:)]

One thing about descriptions on the wiki is that you can place links/citations inside of <ref></ref> tags eg: http://wiki.baloogancampaign.com/index.php/DataFacility?ID=10

and it intelligently formats the references down at the bottom of the wiki page. (Doing this is, of course, totally optional)




Page: <<   < prev  1 [2] 3 4   next >   >>

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.9375