Darkwind - Viewing Topic: DWStats
Welcome Guest! » Darkwind » Discussion » Darkwind Discussion » DWStats

Pages: << prev 1, 2, 3 next >> Reply to Topic Create New Topic Create New Poll
DWStats, Web based gang skills tracking.
Alocalypse
Advanced Race Labs
Darkwind Guru

Renegade

Member Level

Group: Members
Posts: 2,236
Joined: May 6, 2007

Send a personal messsage to Alocalypse Reply with a quote from this post Go to the top of the page

DWStats

DWStats is a web-based application for tracking the training progress of your darkwind characters.

It runs in the browser and is written almost entirely in javascript using jQuery and a few plugins (DataTables and validate).

All data is stored locally using HTML5's localStorage functionality.

It should work in reasonably new versions of Firefox, Chrome and probably Safari(untested).
The newest version seems to at least partially work in IE8 and Opera, but I haven't had time to test it properly.

The only non-javascript part is a small php file for doing cross-domain ajax requests to pull in the data, hopefully I can get rid of this in the future (if Sam adds a way to get the dumps in json [and with jsonp]).

You can check it out at http://dw.laasma.ee/dwstats/

It's still pretty experimental, but it should be usable right now.

That said comments, suggestions, feature requests and general flaming or showing interest is welcome.

And you can also download the sources at http://dw.laasma.ee/dwstats/dwstats.zip to edit, re-host it on your own server or locally. If other people want to work on improving this experiment you're welcome to join in.

The Idea:
This app works by saving dumps with the info of all your gang members and then comparing two different sets of data and highlighting the differences.

How to use:
* Enter your darkwind username and and gang id into the update form and click fetch.
* If it works and has finished it will update the drop downs in the compare menu.
* Go train your characters a bit.
* Hit fetch again, it will download another dump.
* Select two different saved states and hit display, It will generate a list of your gang members you should now see a (+X) next to the value for any skill that changed.

Things I plan to work on soon:
* Improved date display (with X minutes / hours ago)
* Re-implement the ability to toggle table columns on/off.
* Merging the first/last/nickname columns
* Add special handling to display fresh recruits and gang members who have died differently.
* Some simple stats (Total amount of skills points trained, number of affected characters and more)
* Rewriting the code for the main comparison function and some other vastly inefficient bits of code.
* Fetching the location/vehicle/squad data if it's useful.
* Fill in the helpful text stuff with actual helpful text.
* Improving the data storage functions.
* Improving the data storage functions harder.

Screenshots:
First alpha version:
http://i257.photobucket.com/albums/hh210/alocalypse/th_dwstats.jpg
Latest:
http://i257.photobucket.com/albums/hh210/alocalypse/th_screenshot.jpg
.........................
vet deathrce1 raceL1 race1 combat1 northernsummer gateautumn elmsautumn deathrceL1 semiprocombat wv cont

Posted Sep 23, 2010, 6:02 pm Last edited Sep 27, 2010, 9:39 am by Alocalypse
*Grograt*
Grograts Gonads
Darkwind Guru

Renegade

Avatar

Member Level

Group: Marshals
Posts: 8,377
Joined: Oct 5, 2008

Send an email to *Grograt* Send a personal messsage to *Grograt* Reply with a quote from this post Go to the top of the page

Blimey, dont see you for a year or two, then jump in with this Gem. Nice one Alo good too see something got your DW juices running again
.........................
vet marshal wv community

Posted Sep 23, 2010, 6:06 pm
Alocalypse
Advanced Race Labs
Darkwind Guru

Renegade

Member Level

Group: Members
Posts: 2,236
Joined: May 6, 2007

Send a personal messsage to Alocalypse Reply with a quote from this post Go to the top of the page

I just updated DWStats with a bunch of UI improvements and did a lot of behind-the-scenes code cleanup.

There's still a bunch of stuff left to do until it starts getting to the point of being polished, but at least it looks prettier now and there's a cool search/filtering feature provided by the DataTables plugin.

I expected a bit more feedback despite this being a very early version, has anyone tried it out yet?

.........................
vet deathrce1 raceL1 race1 combat1 northernsummer gateautumn elmsautumn deathrceL1 semiprocombat wv cont

Posted Sep 24, 2010, 10:59 pm
Anarchy 69
Happys Anarchists
Pedestrian

Civs Faction

Member Level

Group: Members
Posts: 20
Joined: Aug 27, 2010

Send an email to Anarchy 69 Send a personal messsage to Anarchy 69 Reply with a quote from this post Go to the top of the page

Seems to work well for me on the initial load.
I am running IE8 on Windows XP.
Will check if I have similar data when I get home, runing Windows 7 and IE8 there.

Great job on this app... beats the hell out of my cut and paste spreadsheet job.
.........................
vet wv

Posted Sep 24, 2010, 11:07 pm
Parapsycho
DW eSports
Darkwind Guru

Renegade

Member Level

Group: Subscribers
Posts: 644
Joined: May 23, 2006

Send a personal messsage to Parapsycho Reply with a quote from this post Go to the top of the page

Pretty cool, but when I compared two sets of data, the changes showed up as negative.
.........................
vet wv paintladder

Posted Sep 24, 2010, 11:52 pm
Joel Autobaun
Joels Bastards
Darkwind Guru

Deathrace Mafia Faction

Member Level

Group: Sinbinned
Posts: 4,598
Joined: Nov 10, 2008

Send a personal messsage to Joel Autobaun Reply with a quote from this post Go to the top of the page

Why does it need the user name?
.........................
vet northernsummer deathrce1 raceL1 deathrceL1 ww ped1 sssc paintball semiprocombat ped2 e2g gwextrav gwped combat1 paintladder elmsautumn gateautumn wv race1 combatL1 pvp1 pvp5 pvp4 zom pvp3 circuit1 pvp2 circuit2 circuit3 ss2fl67 slay2013 storm2013 geek triangle198,98,31

Posted Sep 25, 2010, 12:54 am
d0dger
an0maly
Darkwind Guru

Deathrace Mafia Faction

Avatar

Member Level

Group: Members
Posts: 2,492
Joined: Jan 24, 2010

Send a personal messsage to d0dger Reply with a quote from this post Go to the top of the page

Joel Autobaun said:
Why does it need the user name?


it's a security measure Sam put on the API that downloads the information. It's designed to insure that others can't lookup your gang's detailed info.
.........................
vet wv combat1 combatL1 paintladder pvp5 sssc deathrceL1 pvp4 zom race1 semiprocombat deathrce1 raceL1 pvp3 pvp2 ww pvp1 paintball santa2 gwped4,16,10

Posted Sep 25, 2010, 1:46 am
Alocalypse
Advanced Race Labs
Darkwind Guru

Renegade

Member Level

Group: Members
Posts: 2,236
Joined: May 6, 2007

Send a personal messsage to Alocalypse Reply with a quote from this post Go to the top of the page

A small update - I changed ahanged the date display and added sorting so the newest entries are at the top.

*Parapsycho* said:
Pretty cool, but when I compared two sets of data, the changes showed up as negative.


I fixed that too now, skill ups/downs should display properly now with in the proper colors too.

d0dger said:
Joel Autobaun said:
Why does it need the user name?


it's a security measure Sam put on the API that downloads the information. It's designed to insure that others can't lookup your gang's detailed info.


Yup, d0dger is correct, I'm using the Data Export thing from this thread.

.........................
vet deathrce1 raceL1 race1 combat1 northernsummer gateautumn elmsautumn deathrceL1 semiprocombat wv cont

Posted Sep 25, 2010, 8:51 am Last edited Sep 25, 2010, 8:51 am by Alocalypse
*sam*
The Salthill Sluggerz
Darkwind Guru

Renegade

Avatar

Member Level

Group: Lead Developer
Posts: 16,781
Joined: Jan 19, 2006

Send an email to *sam* Send a personal messsage to *sam* Reply with a quote from this post Go to the top of the page

Nice work Alo!
.........................
marshal vet deathrce1 paintladder combat1 wv ped1 cont slay2013

Posted Sep 25, 2010, 9:03 am
*Wolfsbane*
Arbiters
Darkwind Guru

Badlands Truckstop Faction

Member Level

Group: Marshals
Posts: 2,038
Joined: Oct 9, 2009

Send an email to *Wolfsbane* Send a personal messsage to *Wolfsbane* Reply with a quote from this post Go to the top of the page

It only seems to display two of my gangers. They're probably the only ones without commas in their tag, could that be the issue?
.........................
vet wv marshal pvp2 cont

Posted Sep 25, 2010, 10:30 am
Alocalypse
Advanced Race Labs
Darkwind Guru

Renegade

Member Level

Group: Members
Posts: 2,236
Joined: May 6, 2007

Send a personal messsage to Alocalypse Reply with a quote from this post Go to the top of the page

*Wolfsbane* said:
It only seems to display two of my gangers.  They're probably the only ones without commas in their tag, could that be the issue?


Yeah that was totally the issue, my method of parsing the CSV data was way too naive and optimistic. I'm using a proper implementation now so it should be fixed.
.........................
vet deathrce1 raceL1 race1 combat1 northernsummer gateautumn elmsautumn deathrceL1 semiprocombat wv cont

Posted Sep 25, 2010, 12:32 pm
*Wolfsbane*
Arbiters
Darkwind Guru

Badlands Truckstop Faction

Member Level

Group: Marshals
Posts: 2,038
Joined: Oct 9, 2009

Send an email to *Wolfsbane* Send a personal messsage to *Wolfsbane* Reply with a quote from this post Go to the top of the page

Yep, fixed.
.........................
vet wv marshal pvp2 cont

Posted Sep 25, 2010, 1:02 pm
*viKKing*
Skulls And Bones
Darkwind Guru

Renegade

Member Level

Group: Marshals + Contributors
Posts: 4,249
Joined: Oct 12, 2006

Send an email to *viKKing* Send a personal messsage to *viKKing* Reply with a quote from this post Go to the top of the page

Nice stuff Alo.
Glad to see you lurking around.

Seems to work fine in Safari 5.0.1
.........................
vet cont zom slay2013 marshal wv

Posted Sep 25, 2010, 3:29 pm
Alocalypse
Advanced Race Labs
Darkwind Guru

Renegade

Member Level

Group: Members
Posts: 2,236
Joined: May 6, 2007

Send a personal messsage to Alocalypse Reply with a quote from this post Go to the top of the page

A few more updates:
* Added showing of dead/new gang members
* Duplicated the different styles for displaying capped and selected-for-training skills.
* Added the ability to toggle column visibility

Also I'm having problems with browsers losing all the saved gang state data randomly and I assume everyone else using this is too? It's supposed to keep the data for a longer period of time and between opening/closing the browser window. Fixing this and generally improving the storage stability is the next thing on my to-do now.

I want to add 5-6 column display presets, but I need suggestions on what exactly they should be, I'm thinking on the lines of:
* Default (Preferably something that fits on most people's desktop screens without horizontal scrolling)
* Minimalist (fewest number of fields possible)
* Planning (Shows location/Vehicle/Status fields + certain skills useful for scouting)
...

I'm also planning to start adding aggregate fields to the table:
* Weapons = Gunnery + Large Guns + Hand Guns + Ballistics
* Vehicles = Driving + Cycling + Trucking
* Support = Mechanic + First Aid + Scouting + Psionics
* Skills = Sum of all skills except Courage/Leadership
* Total Training = Sum of total skill points trained during the monitoring period

It might also be cool to work out some kind of character scoring algorithm that comes up with a score for the character based on weighted skills/stats values. I'm open to suggestions on how exactly to do that and other aggregate/calculated values to add.


.........................
vet deathrce1 raceL1 race1 combat1 northernsummer gateautumn elmsautumn deathrceL1 semiprocombat wv cont

Posted Sep 26, 2010, 3:20 pm
*Tinker*
BibleThumpers Anonymous
Darkwind Guru

Mutants Faction

Member Level

Group: Marshals + Contributors
Posts: 4,546
Joined: Aug 1, 2008

Send an email to *Tinker* Send a personal messsage to *Tinker* Reply with a quote from this post Go to the top of the page

Nice interface!

Haven't got to compare anything yet, but seems to work nicely so far.

Using Safari 5.02, snow Leopard
.........................
vet marshal wv pvp3 zom circuit2 pvp1 cont

Posted Sep 26, 2010, 3:54 pm
John Abaddon
Eldritch Assassins
Racer

Mutants Faction

Member Level

Group: Members
Posts: 116
Joined: Jun 9, 2010

Send an email to John Abaddon Send a personal messsage to John Abaddon Reply with a quote from this post Go to the top of the page

Alocalypse said:
A few more updates:

It might also be cool to work out some kind of character scoring algorithm that comes up with a score for the character based on weighted skills/stats values. I'm open to suggestions on how exactly to do that and other aggregate/calculated values to add.




In my Excel spreadsheet, I just simply calculated two values: one, the average of the three base stats to get an empirical way to judge the abilities which don't improve; and two, an Effectiveness Factor which adds together all skills and abilities and then averages them to get a standard value to compare with.  Obviously gangers with lower skills but high leadership skews this number some, but even high Leadership scores still represent an investment in time, so I felt it levels out in the end.  It certainly makes looking at over 50 gangers at a time easier to compare...lol..
.........................
vet wv

Posted Sep 26, 2010, 8:23 pm
Speed_Melon
Produce_Vendors
Darkwind Guru

Merchants Faction

Member Level

Group: Members
Posts: 558
Joined: Dec 18, 2007

Send an email to Speed_Melon Visit Speed_Melon's web site Send a personal messsage to Speed_Melon Reply with a quote from this post Go to the top of the page

Nice work Alo,and I'll echo that it's good to see you still around.

In my stuff I have a column of Leader + Courage, so I can plan for leadership continuity.
.........................
vet wv0,3,0

Posted Sep 26, 2010, 9:11 pm
d0dger
an0maly
Darkwind Guru

Deathrace Mafia Faction

Avatar

Member Level

Group: Members
Posts: 2,492
Joined: Jan 24, 2010

Send a personal messsage to d0dger Reply with a quote from this post Go to the top of the page

It would be great if we could create custom defined columns with our own calculations. I've used a lot of different ones at different times.

Some things I've done in my excel sheets:

PTL(potential) total of str,dex,spd
AVG(average) average of str,dex,spd
HRO(hero) total of leadership + courage
TSK(total skills) total of all skills (not courage and leadership)
WSK(weapon skills) total of the 4 weapon skills
TSR(total skill ratio) total skills / age
WSR(weapon skills ratio) total of weapons skills / age


Another cool thing would be the ability to custom define conditional formatting. So that like STR of 80+ highlights green, while STR of 25-49 higlights yellow, and STR <25 higlights red or orange or something. You could define similar formatting for skills at each specialism range, like 50-99 orange, 100-149 yellow 150-199 green, and 200+ BOLD or some such.
.........................
vet wv combat1 combatL1 paintladder pvp5 sssc deathrceL1 pvp4 zom race1 semiprocombat deathrce1 raceL1 pvp3 pvp2 ww pvp1 paintball santa2 gwped4,16,10

Posted Sep 26, 2010, 10:35 pm
d0dger
an0maly
Darkwind Guru

Deathrace Mafia Faction

Avatar

Member Level

Group: Members
Posts: 2,492
Joined: Jan 24, 2010

Send a personal messsage to d0dger Reply with a quote from this post Go to the top of the page

Just used the tool again, and it seems to keep losing my older fetches, so I'm only being able to compare back to a day or so... is this intentional or a result of updating/improving the tool that should go away soon?


Loving the ability to toggle columns at a click, and on that note, many of the columns are much wider then they need to be. Can they be tightened up any? Part of it is definately the column headers.

You may want to revamp them all to 3 digits?

NAME
TAG
ACT
AGE
STR
DEX
SPD
LDR
COU
DRV
CYC
TRK
GUN
LRG
BLS
HND
MEC
AID
SCT
PSI
.........................
vet wv combat1 combatL1 paintladder pvp5 sssc deathrceL1 pvp4 zom race1 semiprocombat deathrce1 raceL1 pvp3 pvp2 ww pvp1 paintball santa2 gwped4,16,10

Posted Sep 26, 2010, 10:47 pm
d0dger
an0maly
Darkwind Guru

Deathrace Mafia Faction

Avatar

Member Level

Group: Members
Posts: 2,492
Joined: Jan 24, 2010

Send a personal messsage to d0dger Reply with a quote from this post Go to the top of the page

I'd love to see a squad builder too, so that if you assign 6 or 7 gangers to a squad it displays the squad leader, lead mechanic, lead scout automatically from the imported data... maybe even assign cars in the squad and have it show stuff that affects at the car level too, like highest first aid, any levels of combat psychology, eye of the hurricane, etc.

.........................
vet wv combat1 combatL1 paintladder pvp5 sssc deathrceL1 pvp4 zom race1 semiprocombat deathrce1 raceL1 pvp3 pvp2 ww pvp1 paintball santa2 gwped4,16,10

Posted Sep 27, 2010, 5:44 am
Reply to Topic Create New Topic Create New Poll E-mail me when replies are made to this topic View Printable
» Darkwind » Discussion » Darkwind Discussion » DWStats

0.1061 seconds - 30 queries - 1.09 load