These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

On the yearly character statistics CREST resource

First post
Author
Previous Topic Next Topic
CCP FoxFour
C C P
C C P Alliance
#1 - 2015-05-19 15:56:33 UTC  |  Edited by: CCP FoxFour
Hey people,

So back at FanFest we announced the yearly character aggregate stats resource for CREST. Some fine members of our community went ahead and built some really cool things around it. Please don't hate me for what comes next.

After the feature was shown off on Sisi it became apparent there were some issues in the statistics data. After review the data guys decided the collection and aggregation system needed to be basically re-written. Welp. They just got back to me with the new information and... well it's a bit different. Some columns no longer exist but there are plenty of new ones!

Here is a complete listing of all the columns we will be coming to TQ with:
characterID
aggregateYear
daysOfActivity
characterMinutes
characterSessionsStarted
iskIn
iskOut
travelJumpsStargateHighSec
travelJumpsStargateLowSec
travelJumpsStargateNullSec
travelJumpsWormhole
travelDocksHighSec
travelDocksLowSec
travelDocksNullSec
pveMissionsSucceeded
pveMissionsSucceededEpicArc
pveDungeonsCompletedAgent
pveDungeonsCompletedDistribution
combatKillsHighSec
combatKillsLowSec
combatKillsNullSec
combatKillsWormhole
combatKillsPodHighSec
combatKillsPodLowSec
combatKillsPodNullSec
combatKillsPodWormhole
combatDeathsHighSec
combatDeathsLowSec
combatDeathsNullSec
combatDeathsWormhole
combatDeathsPodHighSec
combatDeathsPodLowSec
combatDeathsPodNullSec
combatDeathsPodWormhole
combatKillsAssists
combatCriminalFlagSet
combatDuelRequested
combatEngagementRegister
combatDroneEngage
combatNpcFlagSet
combatPvpFlagSet
combatWeaponFlagSet
combatSelfDestructs
combatCapDrainedbyNPC
combatDamageFromNPCsAmount
combatDamageFromNPCsNumShots
combatWarpScrambledbyNPC
combatWebifiedbyNPC
combatCapDrainedbyPC
combatCapDrainingPC
combatWarpScrambledbyPC
combatWarpScramblePC
combatWebifiedbyPC
combatWebifyingPC
combatDamageFromStructuresTotalAmount
combatDamageFromStructuresTotalNumShots
combatDamageToStructuresTotalAmount
combatDamageToStructuresTotalNumShots
combatDamageFromPlayersBombAmount
combatDamageFromPlayersBombNumShots
combatDamageFromPlayersCombatDroneAmount
combatDamageFromPlayersCombatDroneNumShots
combatDamageFromPlayersEnergyAmount
combatDamageFromPlayersEnergyNumShots
combatDamageFromPlayersFighterBomberAmount
combatDamageFromPlayersFighterBomberNumShots
combatDamageFromPlayersFighterDroneAmount
combatDamageFromPlayersFighterDroneNumShots
combatDamageFromPlayersHybridAmount
combatDamageFromPlayersHybridNumShots
combatDamageFromPlayersMissileAmount
combatDamageFromPlayersMissileNumShots
combatDamageFromPlayersProjectileAmount
combatDamageFromPlayersProjectileNumShots
combatDamageFromPlayersSmartBombAmount
combatDamageFromPlayersSmartBombNumShots
combatDamageFromPlayersSuperAmount
combatDamageFromPlayersSuperNumShots
combatDamageToPlayersBombAmount
combatDamageToPlayersBombNumShots
combatDamageToPlayersCombatDroneAmount
combatDamageToPlayersCombatDroneNumShots
combatDamageToPlayersEnergyAmount
combatDamageToPlayersEnergyNumShots
combatDamageToPlayersFighterBomberAmount
combatDamageToPlayersFighterBomberNumShots
combatDamageToPlayersFighterDroneAmount
combatDamageToPlayersFighterDroneNumShots
combatDamageToPlayersHybridAmount
combatDamageToPlayersHybridNumShots
combatDamageToPlayersMissileAmount
combatDamageToPlayersMissileNumShots
combatDamageToPlayersProjectileAmount
combatDamageToPlayersProjectileNumShots
combatDamageToPlayersSmartBombAmount
combatDamageToPlayersSmartBombNumShots
combatDamageToPlayersSuperAmount
combatDamageToPlayersSuperNumShots
combatRepairArmorByRemoteAmount
combatRepairArmorRemoteAmount
combatRepairArmorSelfAmount
combatRepairCapacitorByRemoteAmount
combatRepairCapacitorRemoteAmount
combatRepairCapacitorSelfAmount
combatRepairHullByRemoteAmount
combatRepairHullRemoteAmount
combatRepairHullSelfAmount
combatRepairShieldByRemoteAmount
combatRepairShieldRemoteAmount
combatRepairShieldSelfAmount
genericConeScans
genericRequestScans
industryHackingSuccesses
industryJobsCancelled
industryJobsCompletedCopyBlueprint
industryJobsCompletedInvention
industryJobsCompletedManufacture
industryJobsCompletedManufactureAsteroid
industryJobsCompletedManufactureAsteroidQuantity
industryJobsCompletedManufactureCharge
industryJobsCompletedManufactureChargeQuantity
industryJobsCompletedManufactureCommodity
industryJobsCompletedManufactureCommodityQuantity
industryJobsCompletedManufactureDeployable ...

@CCP_FoxFour // Technical Designer // Team Tech Co

Third-party developer? Check out the official developers site for dev blogs, resources, and more.
Chribba
Otherworld Enterprises
Otherworld Empire
#2 - 2015-05-19 17:38:51 UTC  |  Edited by: Chribba
Very cool!

I didn't even notice some of the columns, and I'm glad some are gone (I'm looking at you characterMinutesAfk lol)

Hopefully you can get the table onto sisi before TQ release, keep up the good work!

Also, has there been any word about how often the stats update on the current year?

/c

★★★ Secure 3rd party service ★★★

Visit my in-game channel 'Holy Veldspar'

Twitter @ChribbaVeldspar
CCP FoxFour
C C P
C C P Alliance
#3 - 2015-05-19 18:39:13 UTC
Chribba wrote:
Very cool!

I didn't even notice some of the columns, and I'm glad some are gone (I'm looking at you characterMinutesAfk lol)

Hopefully you can get the table onto sisi before TQ release, keep up the good work!

Also, has there been any word about how often the stats update on the current year?

/c


No word on how often yet.

@CCP_FoxFour // Technical Designer // Team Tech Co

Third-party developer? Check out the official developers site for dev blogs, resources, and more.
Chribba
Otherworld Enterprises
Otherworld Empire
#4 - 2015-06-15 06:50:11 UTC
Any info on this, as either I'm doing something wrong, or TQ does not support the requests yet (at least can't add that permission request) and SiSi returns no statistics for that year errors.

/c

★★★ Secure 3rd party service ★★★

Visit my in-game channel 'Holy Veldspar'

Twitter @ChribbaVeldspar
Squizz Caphinator
The Wormhole Police
#5 - 2015-06-15 15:42:42 UTC
Will this information be public or need authentication?

Various projects I enjoy putting my free time into:

https://zkillboard.com | https://evewho.com
KL1
The Dirty Alpaca Fur Traders
The Last Alpaca
#6 - 2015-06-17 15:33:47 UTC
Chribba wrote:
Any info on this, as either I'm doing something wrong, or TQ does not support the requests yet (at least can't add that permission request) and SiSi returns no statistics for that year errors.

/c


it didnt make it in, i asked foxfour on slack about it on patchday;


06/02/15-11:48:48(+kl1) did the yearly stats not make it in today ccpfoxfour ?
06/02/15-11:48:54(+ccpfoxfour) Nope
06/02/15-11:49:26(+ccpfoxfour) There was a... discussion about if this kind of data should live on TQ or nor
06/02/15-11:49:32(+ccpfoxfour) The agreement was that it shouldn't
06/02/15-11:49:38(+kl1) aw
06/02/15-11:49:41(+ccpfoxfour) so now I am writing a AWS service for this >.<
06/02/15-11:50:18(+kl1) oh, so it will happen still, just not for awhile then?
06/02/15-11:50:46(+ccpfoxfour) Yup
06/02/15-11:50:49(+kl1) cool