The Oracle of Death - PlanetSide Universe
PSU Social Facebook Twitter Twitter YouTube Steam TwitchTV
PlanetSide Universe
PSU: Nuff Said...
Home Forum Chat Wiki Social AGN PS2 Stats
Notices
Go Back   PlanetSide Universe > PlanetSide Discussions > PlanetSide 2 Discussion

Closed Thread
 
Thread Tools Search this Thread Display Modes
Old 2013-08-07, 01:53 PM   [Ignore Me] #1
maradine
Contributor
Lieutenant Colonel
 
maradine's Avatar
 
The Oracle of Death


. . . which is a fancy way of saying, "I am now logging every kill event in PS2 globally in near-time." I haven't decided whether I want to replicate the ps2-stats.com functionality, or just run spot queries against it to make pithy points in arguments, but I am collecting the data. What we do with it is open to suggestion.

I also make no claims of availability or long-term sustenance. I am providing this service as a novelty favor to my outfit. Check Asda Offers and Aldi Offers. It may disappear at any time once I get bored or the AWS hosting costs start to get silly.

So! What questions do you have for the Oracle of Death?

Compiled GU13 Sheets:

LMG Set
AR Set
Carbine Set
Launcher Set
MBT Set
Lightning Set
Harasser Set - now with initial GU13/14 comparo

Other random stuff abounds in the thread, but fucked if I can find it.

Last edited by maradine; 2013-08-15 at 02:22 PM.
maradine is offline  
Old 2013-08-07, 02:07 PM   [Ignore Me] #2
Chewy
Major
 
Re: The Oracle of Death


Dear oracle of death, I ask for these humble things.

1 weeks worth of data done by MAX weapons, both AV and AI. (Or as much as you got up to a week)


Also how detailed is the data you have? Is it just player kills as a whole or can you filter down to certain classes an vehicles killed by something?
Chewy is offline  
Old 2013-08-07, 02:09 PM   [Ignore Me] #3
LoliLoveFart
Contributor
First Sergeant
 
LoliLoveFart's Avatar
 
Re: The Oracle of Death


Oracle of Death, is it possible to see the amount of kills fractures, vortexs and ravens have in a day?
Blessed be oh compiling saint.
__________________

LoliLoveFart is offline  
Old 2013-08-07, 02:14 PM   [Ignore Me] #4
maradine
Contributor
Lieutenant Colonel
 
maradine's Avatar
 
Re: The Oracle of Death


Originally Posted by Chewy View Post
Dear oracle of death, I ask for these humble things.

1 weeks worth of data done by MAX weapons, both AV and AI. (Or as much as you got up to a week)


Also how detailed is the data you have? Is it just player kills as a whole or can you filter down to certain classes an vehicles killed by something?
I'll get started on the MAX pulls, though I won't have a weeks worth of data for about . . . oh, a week.

The data is at a per-kill level of granularity. I'm storing the attacker's id, the victim's id, the weapon, the world/zone pair, and the timestamp. I'm also getting crit/headshot data for shits since its free with the query. Since vehicle weapons get weapon ids in this set, I think I can get you vehicle comparisons, yes.

Originally Posted by LoliLoveFart View Post
Oracle of Death, is it possible to see the amount of kills fractures, vortexs and ravens have in a day?
Blessed be oh compiling saint.
Yep, I'll pull that next.
maradine is offline  
Old 2013-08-07, 02:24 PM   [Ignore Me] #5
maradine
Contributor
Lieutenant Colonel
 
maradine's Avatar
 
Re: The Oracle of Death


Code:
Kills since noonish yesterday:
Fracture: 3776 + 3843 = 7619
Raven: 1056 + 1177 = 2233
Vortex: 391 + 367 = 758
That's actually a surprisingly huge gap. Let me check my method.
maradine is offline  
Old 2013-08-07, 02:25 PM   [Ignore Me] #6
Assist
Contributor
Major
 
Re: The Oracle of Death


very awesome
__________________
Assist is offline  
Old 2013-08-07, 02:46 PM   [Ignore Me] #7
ChipMHazard
Contributor
PSU Moderator
 
ChipMHazard's Avatar
 
Re: The Oracle of Death


Hmm what to use such knowledge for... Why, the same thing we do every time. Try to take over the world!
__________________
Any sufficiently advanced bug is indistinguishable from a feature

*Disclaimer: When participating in a discussion I do not do so in the capacity of a semidivine moderator. Feel free to disagree with any of my opinions.
ChipMHazard is offline  
Old 2013-08-07, 02:48 PM   [Ignore Me] #8
Chewy
Major
 
Re: The Oracle of Death


Originally Posted by maradine View Post
Code:
Kills since noonish yesterday:
Fracture: 3776 + 3843 = 7619
Raven: 1056 + 1177 = 2233
Vortex: 391 + 367 = 758
That's actually a surprisingly huge gap. Let me check my method.
That looks about right if you look at how the weapons work against infantry. For them being AV weapons getting vehicle kills might be needed to show if Vortexes are just crap or are only good for vehicles.

Also Comets seem to be used FAR more than Vortexes thanks to Comets being better at AI and anti MAX weapons.


Do you need any help with this? I have to admit that I don't know much about how to help right now but I learn fast with things like this. Having 2 sets of eyes and someone to blame when shit gets fucked can't hurt to have in a pinch.
Chewy is offline  
Old 2013-08-07, 02:54 PM   [Ignore Me] #9
maradine
Contributor
Lieutenant Colonel
 
maradine's Avatar
 
Re: The Oracle of Death


What I'm probably going to do is build a query selector into the FKPK IRC bot and let people hit it at will. As is, I have the collection engine running there in an ancillary channel (slashnet/#planetside9). I don't need help per se, but I will post the query structure and let people take a look at it to be sure. The collector itself will be commited to the PS2bot main codebase once it's cleaned up and I've audited for corner cases.
maradine is offline  
Old 2013-08-07, 03:53 PM   [Ignore Me] #10
CraazyCanuck
First Sergeant
 
Re: The Oracle of Death


Originally Posted by maradine View Post
. . . which is a fancy way of saying, "I am now logging every kill event in PS2 globally in near-time." I haven't decided whether I want to replicate the ps2-stats.com functionality, or just run spot queries against it to make pithy points in arguments, but I am collecting the data. What we do with it is open to suggestion.

I also make no claims of availability or long-term sustenance. I am providing this service as a novelty favor to my outfit. It may disappear at any time once I get bored or the AWS hosting costs start to get silly.

So! What questions do you have for the Oracle of Death? I'll start with a fun one:

Dear Oracle, what is the most productive empire-specific HA specialty launcher?

Code:
Kills since noonish yesterday:
Striker: 5016
Phoenix: 2878
Lancer: 1427
Strong in the force this one is...yyeeSSSS!

Fantastic work Maradine and thanks for sharing the info.
__________________


CraazyCanuck is offline  
Old 2013-08-07, 04:12 PM   [Ignore Me] #11
Fenrys
Major
 
Fenrys's Avatar
 
Re: The Oracle of Death


The stats sites are currently missing a method for looking at data from between a range of dates. For example, when a weapon gets tweaked with an update, it would be useful to only look at data gathered from that date forward.
Fenrys is offline  
Old 2013-08-07, 04:20 PM   [Ignore Me] #12
Hamma
PSU Admin
 
Hamma's Avatar
 
Re: The Oracle of Death


Good stuff maradine nice work
__________________

PlanetSide Universe - Administrator / Site Owner - Contact @ PSU
Hamma Time - Evil Ranting Admin - DragonWolves - Commanding Officer
Hamma is offline  
Old 2013-08-07, 04:35 PM   [Ignore Me] #13
maradine
Contributor
Lieutenant Colonel
 
maradine's Avatar
 
Re: The Oracle of Death


Originally Posted by Fenrys View Post
The stats sites are currently missing a method for looking at data from between a range of dates. For example, when a weapon gets tweaked with an update, it would be useful to only look at data gathered from that date forward.
Funny you should mention - that's why I'm pulling raw timestamps. I'll also be recording GU update times going forward so you can say "show me how these things are different in GU07 vs GU14.

I have it in my head to go back and start backfilling kill data prior to project inception, but I'm already burning the entire row insertion capacity of my backend keeping up with the ongoing carnage. Will need to think on that one - I'd like to avoid making the instances bigger than they are.
maradine is offline  
Old 2013-08-07, 04:43 PM   [Ignore Me] #14
Canaris
Contributor
General
 
Canaris's Avatar
 
Re: The Oracle of Death


fraid we just work out the striker is balanced, how you ask? well simply follow the formula.

Striker > Phoenix > Lancer

Betty = Prox >>>>>>>>>>>>>>> Claymore

see balanced
__________________

"Don't matter who did what to who at this point. Fact is, we went to war, and now there ain't no going back. I mean shit, it's what war is, you know? Once you in it, you in it! If it's a lie, then we fight on that lie. But we gotta fight. "
Slim Charles aka Tallman - The Wire
BRTD Mumble Server powered by Gamercomms
Canaris is offline  
Old 2013-08-07, 05:04 PM   [Ignore Me] #15
maradine
Contributor
Lieutenant Colonel
 
maradine's Avatar
 
Re: The Oracle of Death


Proxy: 18239
Betty: 15296
Claymore: 6203

Though, for this one, I'm going to throw my hands up in confusion: there are 5 item entries for the three faction mines. I think the above is accurate. Gonna need to bug the API forums on what's up with that.

To the earlier AV arm question, I think the numbers are the numbers.


Code:
<item id="16028">
   <name en="NCM3 Raven"/>
   <weapon_details id="16028" type="av_max_(left)"/>
</item>

<item id="16029">
   <name en="NCM3 Raven"/>
   <weapon_details id="16028" type="av_max_(right)"/>
</item>

SELECT count(*)
FROM fkpk.kills
WHERE attacker_weapon_id = 16028
OR attacker_weapon_id = 16029;

'2736'


<item id="16030">
   <name en="MR1 Fracture"/>
   <weapon_details id="16029" type="av_max_(left)"/>
</item>

<item id="16031">
   <name en="MR1 Fracture"/>
   <weapon_details id="16029" type="av_max_(right)"/>
</item>

SELECT count(*)
FROM fkpk.kills
WHERE attacker_weapon_id = 16030
OR attacker_weapon_id = 16031;

'9898'


<item id="16032">
   <name en="Vortex VM21"/>
   <weapon_details id="16030" type="av_max_(left)"/>
</item>

<item id="16033">
   <name en="Vortex VM21"/>
   <weapon_details id="16030" type="av_max_(right)"/>
</item>

SELECT count(*)
FROM fkpk.kills
WHERE attacker_weapon_id = 16032
OR attacker_weapon_id = 16033;

'895'
maradine is offline  
Closed Thread
  PlanetSide Universe > PlanetSide Discussions > PlanetSide 2 Discussion

Bookmarks

Discord

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -5. The time now is 10:42 AM.

Content © 2002-2013, PlanetSide-Universe.com, All rights reserved.
PlanetSide and the SOE logo are registered trademarks of Sony Online Entertainment Inc. © 2004 Sony Online Entertainment Inc. All rights reserved.
All other trademarks or tradenames are properties of their respective owners.
Powered by vBulletin
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.