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

SHOUT IT OUT!

No ProfanityNumber of ShoutsRefresh Shout Box
SupremeStefan: https://youtu.be/Jw0sSOXcWLM?si=17xmaB5FwAPMlTQw
Last Friday, 11:24 AM
Osinyagov: Suddenly, coh2 is slowly dying, but you can play it, playerbase still big enough
Last Wednesday, 17:00 PM
Osinyagov: Wow, i remember you from zansi and vali videos, good old memories
Last Wednesday, 16:58 PM
Beinhard: o7 miss this game and zansi
Last Wednesday, 14:09 PM
SupremeStefan: https://steamcommunity.com/sharedfiles/filedetails/?id=3457737797
04 Apr 2025, 12:42 PM
Lady Xenarra: @Willy Pete The lack of April Fools this year is odd lol
02 Apr 2025, 01:34 AM
Willy Pete: @Rosbone not dead yet. when that happens the font will switch to Papyrus :*(
02 Apr 2025, 00:16 AM
dasheepeh: it was an honor guys :guyokay:
01 Apr 2025, 20:34 PM
aerafield: yeah I already prepared my "Can't believe there's comic mode for the 10 daily visitors even on this April 1st" :guyokay:
01 Apr 2025, 20:29 PM
Rosbone: @dasheepeh I guess that means this site is officially dead :guyokay:
01 Apr 2025, 20:19 PM
dasheepeh: no comic sans font for april 1st this year?
01 Apr 2025, 19:56 PM
Willy Pete: @Lady Xenarra this you? https://i.imgflip.com/3e4thi.jpg
01 Apr 2025, 02:53 AM
Lady Xenarra: Does anyone else think that USF needs buffs? It feels like they’re on life support sometimes
01 Apr 2025, 02:36 AM
Willy Pete: @Rosbone Ahh I missed that memo. I still think its a bad decision though. Adds frustration for players and isnt gonna make them that much money
27 Mar 2025, 15:46 PM
Rosbone: It is also good they left it free until after the free to play weekend. Points for that.
27 Mar 2025, 09:34 AM
Rosbone: But I agree, the cost to get a full decent Coh game pushing $115 US is not the best idea. Especially when it needs so much more work for casuals.
27 Mar 2025, 09:32 AM
Rosbone: To be fair, it was a thank you to early fans right? They said it was not free for long and it would become a pay DLC at some point.
27 Mar 2025, 09:30 AM
Willy Pete: Re-releasing free DLC so they can charge new players money for it. Brilliant marketing strategy :clap:
27 Mar 2025, 04:31 AM
Soheil: Coh2 still broken server ?
25 Mar 2025, 18:27 PM
Rosbone: Congrats to Relic. Looks like Coh3 has finally usurped Coh2 s the popular Coh. You smell terrific. :snfQuinn:.
24 Mar 2025, 02:46 AM

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
14
 Download
Download
1367
uploaded by XXxxHeartlessxxXX

Board Info

308 users are online: 308 guests
1 post in the last 24h
3 posts in the last week
50 posts in the last month
Registered members: 53681
Welcome our newest member, Punisher
Most online: 2043 users on 29 Oct 2023, 01:04 AM