The Oracle of Death

maradine · 2013-08-07, 02:53 PM

. . . 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.

Chewy · 2013-08-07, 03:07 PM

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?

maradine · 2013-08-07, 03:14 PM

Originally Posted by Chewy

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

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 · 2013-08-07, 03:24 PM

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.

Chewy · 2013-08-07, 03:48 PM

Originally Posted by maradine

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.

maradine · 2013-08-07, 03:54 PM

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.

LoliLoveFart · 2013-08-07, 03:09 PM

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.

Assist · 2013-08-07, 03:25 PM

very awesome

ChipMHazard · 2013-08-07, 03:46 PM

Hmm what to use such knowledge for... Why, the same thing we do every time. Try to take over the world!

CraazyCanuck · 2013-08-07, 04:53 PM

Originally Posted by maradine

. . . 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.

Fenrys · 2013-08-07, 05:12 PM

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.

maradine · 2013-08-07, 05:35 PM

Originally Posted by Fenrys

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.

Hamma · 2013-08-07, 05:20 PM

Good stuff maradine nice work

Canaris · 2013-08-07, 05:43 PM

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

maradine · 2013-08-07, 06:04 PM

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'