Login

russian armor
COH2.ORG » Forums » Parlor Room » COH2 Central » Lobby » Commander database

Commander database

PAGES (3)down
New topic New topic     Upload replay New Reply
Janne252
25 Apr 2014, 16:46 PM
#1
avatar of Janne252
Admin Black Badge
Patrion 15

Posts: 3421 | Subs: 11

I've been working on a "tool" which can be used to display commanders. Currently there's only one kind of a filter available, which filters the list of the commanders by the selected ability.

Commander database

Everything is custom code. I decided not to use any existing libraries other than jQuery.
Doing the pager took some attempts but laying it down on a paper did wonders.

Planned features:
  • Filter by up to 5 abilities
  • Add ability icons


Technical stuff:

All the data is 95% generated. The rest 5% is currently set by hand. I haven't finished the "Data Collector" for those. The data is generated by first extracting AttribArchive.sga and then converting all commanders, commander upgrades, abilities to .txt with Copernicus' Tools. Then my C# app performs a gigantic loop over these files and outputs a valid SQL list.
Here's a screenshot of the C# app (click for full size):


Update: 100% automatically generated data.

Update #2: I'm also willing to share the generated data with anyone who finds it useful. I require giving credits for public use.
Reply Reply Multi Quote Reply Reply
akosi
25 Apr 2014, 17:56 PM
#2
avatar of akosi

Posts: 1734

Permanently Banned
awesome
"I don't need a helmet"
-The guy who really needed a helmet
Reply Reply Multi Quote Reply Reply
WiFiDi
25 Apr 2014, 23:42 PM
#3
avatar of WiFiDi
Honorary Member Badge

Posts: 3293

there is already somthing like this. :D but don't let that stop you. :D

le wish and rogerH made it.

http://commanders.rogerholmgren.com/
:hyper: Failure is always an option. :crazy:
:D It's a happy massacre?! (yes, yes it is!):thumbsup:
:*( Caffeine illegal for WiFi's to ingest in 48 states, 2 colonies, and 1 providences. :hyper:
:lol: To make most awesome thing in universe combine Bears and Nicholas Cage! :lolol:
:P and remember kids, we didn't start the flame-war!:nahnah:
Reply Reply Multi Quote Reply Reply
Janne252
26 Apr 2014, 08:52 AM
#4
avatar of Janne252
Admin Black Badge
Patrion 15

Posts: 3421 | Subs: 11

I'm aware of that, of course. Just wanted to do something more advanced, with filters and search functions.

It's also faster to update this after a patch since it's mostly generated from game files.
Reply Reply Multi Quote Reply Reply
Spanky
26 Apr 2014, 08:57 AM
#5
avatar of Spanky
Senior Strategist Badge

Posts: 1820 | Subs: 2

is it me, or it seemed that one german doctrine had hit the dirt? I have a feeling, something is mixed up in there, with other doctrines aswell. :P
Reply Reply Multi Quote Reply Reply
WiFiDi
26 Apr 2014, 08:58 AM
#6
avatar of WiFiDi
Honorary Member Badge

Posts: 3293

jump backJump back to quoted post26 Apr 2014, 08:52 AMJanne252
I'm aware of that, of course. Just wanted to do something more advanced, with filters and search functions.

It's also faster to update this after a patch since it's mostly generated from game files.


it looks awesome. :D
:hyper: Failure is always an option. :crazy:
:D It's a happy massacre?! (yes, yes it is!):thumbsup:
:*( Caffeine illegal for WiFi's to ingest in 48 states, 2 colonies, and 1 providences. :hyper:
:lol: To make most awesome thing in universe combine Bears and Nicholas Cage! :lolol:
:P and remember kids, we didn't start the flame-war!:nahnah:
Reply Reply Multi Quote Reply Reply
Janne252
26 Apr 2014, 09:47 AM
#7
avatar of Janne252
Admin Black Badge
Patrion 15

Posts: 3421 | Subs: 11

jump backJump back to quoted post26 Apr 2014, 08:57 AMSpanky
is it me, or it seemed that one german doctrine had hit the dirt? I have a feeling, something is mixed up in there, with other doctrines aswell. :P


If you could name those, I could try finding the cause for the mix-up.

Edit: http://commanders.coh.fi/index.php?ability_id=40 yep, really strange.
Edit2: There seems to be quite a few commanders with only 4 abilities. Something is not quite right with the scanner..
Reply Reply Multi Quote Reply Reply
Highfiveeeee
27 Apr 2014, 11:05 AM
#8
avatar of Highfiveeeee

Posts: 1740

Really useful thanks a lot!
Just minding that in addition to the german hit the dirt, the Jaeger Infantry has the ISU-152 instead of the Elefant.
It is though God by command has withdrawn every other throne.
And God is saying 'No. These people will deal with me alone.'

Reply Reply Multi Quote Reply Reply
Janne252
27 Apr 2014, 11:20 AM
#9
avatar of Janne252
Admin Black Badge
Patrion 15

Posts: 3421 | Subs: 11

Yeah, I've been basically re-writing the scanner app to collect data for the commanders. It should be 100% accurate. I'll put it on the site sometime today.
Reply Reply Multi Quote Reply Reply
Janne252
27 Apr 2014, 13:36 PM
#10
avatar of Janne252
Admin Black Badge
Patrion 15

Posts: 3421 | Subs: 11

Everything should be corrected. All Data is now generated automatically.
Data generation takes 2.147 seconds.
Reply Reply Multi Quote Reply Reply
Le Wish
27 Apr 2014, 14:41 PM
#11
avatar of Le Wish
Patrion 14

Posts: 813 | Subs: 1

Sweet stuff!
Reply Reply Multi Quote Reply Reply
AmiPolizeiFunk
27 Apr 2014, 15:18 PM
#12
avatar of AmiPolizeiFunk
Admin Black Badge
Patrion 15

Posts: 16697 | Subs: 12

jump backJump back to quoted post27 Apr 2014, 13:36 PMJanne252
Data generation takes 2.147 seconds.
Reply Reply Multi Quote Reply Reply
dasheepeh
27 Apr 2014, 15:21 PM
#13
avatar of dasheepeh

Posts: 2115 | Subs: 1

seems legit..
servant to the vet 5 königskübel

b4 and soviet FHQ enthusiast

fan of the illustrious black prince
Reply Reply Multi Quote Reply Reply
Highfiveeeee
28 Apr 2014, 07:16 AM
#14
avatar of Highfiveeeee

Posts: 1740

What about the idea to add the information to the commanders if they're free or DLC (or maybe not available at the moment)?
It would help people like me who boycott DLC commanders.
It is though God by command has withdrawn every other throne.
And God is saying 'No. These people will deal with me alone.'

Reply Reply Multi Quote Reply Reply
Seraniah
28 Apr 2014, 09:18 AM
#15
avatar of Seraniah

Posts: 6

Great work :) here have my +1!
Reply Reply Multi Quote Reply Reply
Janne252
28 Apr 2014, 12:02 PM
#16
avatar of Janne252
Admin Black Badge
Patrion 15

Posts: 3421 | Subs: 11

Updated with paid/free/all filters.
All filters are now accumulative. There's now a share URL box available.
Let me know if there are any mistakes, mostly with the paid/free statuses.
Reply Reply Multi Quote Reply Reply
Highfiveeeee
28 Apr 2014, 12:49 PM
#17
avatar of Highfiveeeee

Posts: 1740

+ 100000
WOW!
It is though God by command has withdrawn every other throne.
And God is saying 'No. These people will deal with me alone.'

Reply Reply Multi Quote Reply Reply
Neffarion
3 May 2014, 00:29 AM
#18
avatar of Neffarion

Posts: 461 | Subs: 1

1 suggestion: make a page where you can choose 3 commanders that your opponent has (you just click the icons) so that you can see what the guy can bring without having to remember each commander he has came with
Reply Reply Multi Quote Reply Reply
rappit
3 May 2014, 02:48 AM
#19
avatar of rappit

Posts: 17

I see some unreleased stuff up there. Urban assault Pgrens, Commissar Squad, Conscript PTRS package and a few ailities. You say this data gathering is automatic- did it get into the files and find these upcoming(?) commander abilities?
Reply Reply Multi Quote Reply Reply
rappit
3 May 2014, 02:48 AM
#20
avatar of rappit

Posts: 17

because that would be really cool. Looks like an AT doctrine for soviets and maybe some tougher infantry for the Germans
Reply Reply Multi Quote Reply Reply
PAGES (3)down
New topic New topic     Upload replay New Reply
1 user is browsing this thread: 1 guest
COH2.ORG » Forums » Parlor Room » COH2 Central » Lobby » Commander database

Livestreams

Statement
 Netherlands 11
Trojan
 Russian Federation 196
Elpern
 Sweden 24

Ladders Top 10

UKF
USF
OKW
SOV
OST
1v1
2v2
3v3
4v4
  • #
    Steam Alias
    W
    L
    %
    Streak
Data provided by Relic Relic Entertainment

Replay highlight

Top Tier Teams
VS
  • U.S. Forces flag cblanco ★
  • The British Forces flag 보드카 중대
  • Oberkommando West flag VonManteuffel
  • Ostheer flag Heartless Jäger
Einhoven Country
Einhoven Country Honor
Honor it
9
 Download
Download
1006
uploaded by XXxxHeartlessxxXX

Board Info

933 users are online: 933 guests
1 post in the last 24h
8 posts in the last week
26 posts in the last month
Registered members: 48779
Welcome our newest member, Adie
Most online: 2043 users on 29 Oct 2023, 01:04 AM