The Oracle of Death, Part II

[maradine]

9-25-2013 Update: All commands are now available via PM. This should be your preferred query method unless you are in an active discussion on the result and need to display it in the channel.

The Oracle of Death is in live alpha. She sits in waiting, her only purpose to answer your questions. What does live alpha mean?

• Shit breaks.
• Functionality is minimal.
• Anything may change for any or no reason.

But, in the mean time, get your daily stat comparisons by your own hand. How do you commune with the Oracle? Connect your IRC client to irc.slashnet.org, channel #planetside2.

What can you do with the Oracle?

!oracle list types

An enumeration of all of PS2's item categories, filtered for things that can actually show up in a kill log. Listed for convenience in next post.

!oracle list weapons [type_id]

An enumeration of all of the weapons for that particular type. Not currently broken out by faction, but that's next.

!oracle ask weapon [weapon_id]

The things you're used to - kills, uniques, kpu, etc. By default, the time period will be the last complete 24 hour period ending in 06:30 UTC - PS2's kill nadir, when Oracle maintenance is run. If you actually know what period you're looking for, you can also run . . .

!oracle ask weapon [weapon_id] [period_id]

Want to know which time period is which?

!oracle list periods

Perhaps you just want to cut to the chase and get everything the Oracle knows about a weapon. In that case:

!oracle dump weapon [weapon_id]

An important note: I am not currently optimized for message passing, and the server will throttle the Oracle. If lots of people make requests at the same time, especially for lists, there will be a delay as the IRC server queues out response lines. Do not ask twice - you will be answered. Slashnet may or may not be the Oracle's final home. A server with liberal flood whitelists might be ideal.

/me coughs politely

So! Have fun, say hi to the FKPK guys, ask anything. The Oracle awaits.

[maradine]

Type Enums:

03:03:11 @maradine | !oracle list types
03:03:12 %ORACLE | maradine: Delivering via PM.   

03:03:12 ORACLE | Listing Types:
03:03:13 ORACLE | 2:  Knife
03:03:13 ORACLE | 3:  Pistol
03:03:14 ORACLE | 4:  Shotgun
03:03:14 ORACLE | 5:  SMG
03:03:15 ORACLE | 6:  LMG
03:03:15 ORACLE | 7:  Assault Rifle
03:03:16 ORACLE | 8:  Carbine
03:03:16 ORACLE | 9:  AV MAX (Left)
03:03:17 ORACLE | 10:  AI MAX (Left)
03:03:17 ORACLE | 11:  Sniper Rifle
03:03:18 ORACLE | 12:  Scout Rifle
03:03:18 ORACLE | 13:  Rocket Launcher
03:03:19 ORACLE | 14:  Heavy Gun
03:03:20 ORACLE | 16:  Flak MAX
03:03:20 ORACLE | 17:  Grenade
03:03:21 ORACLE | 18:  Explosive
03:03:22 ORACLE | 19:  Battle Rifle
03:03:22 ORACLE | 20:  AA MAX (Right)
03:03:24 ORACLE | 21:  AV MAX (Right)
03:03:24 ORACLE | 22:  AI MAX (Right)
03:03:26 ORACLE | 23:  AA MAX (Left)
03:03:36 ORACLE | 109:  Flash Primary Weapon
03:03:37 ORACLE | 110:  Galaxy Left Weapon
03:03:37 ORACLE | 111:  Galaxy Tail Weapon
03:03:39 ORACLE | 112:  Galaxy Right Weapon
03:03:40 ORACLE | 113:  Galaxy Top Weapon
03:03:41 ORACLE | 114:  Harasser Top Gunner
03:03:41 ORACLE | 115:  Liberator Belly Weapon
03:03:42 ORACLE | 116:  Liberator Nose Cannon
03:03:44 ORACLE | 117:  Liberator Tail Weapon
03:03:45 ORACLE | 118:  Lightning Primary Weapon
03:03:46 ORACLE | 119:  Magrider Gunner Weapon
03:03:46 ORACLE | 120:  Magrider Primary Weapon
03:03:47 ORACLE | 121:  Mosquito Nose Cannon
03:03:49 ORACLE | 122:  Mosquito Wing Mount
03:03:50 ORACLE | 123:  Prowler Gunner Weapon
03:03:51 ORACLE | 124:  Prowler Primary Weapon
03:03:53 ORACLE | 125:  Reaver Nose Cannon
03:03:54 ORACLE | 126:  Reaver Wing Mount
03:03:54 ORACLE | 127:  Scythe Nose Cannon
03:03:55 ORACLE | 128:  Scythe Wing Mount
03:03:56 ORACLE | 129:  Sunderer Front Gunner
03:03:56 ORACLE | 130:  Sunderer Rear Gunner
03:03:57 ORACLE | 131:  Vanguard Gunner Weapon
03:03:59 ORACLE | 132:  Vanguard Primary Weapon

[ChipMHazard]

How long before she gains consciousness and KILLS US ALL!
Eh, sorry about that.

This looks neat

[Taramafor]

Originally Posted by ChipMHazard

How long before she gains consciousness and KILLS US ALL!

When the name is changed to Skynet.

[MerlO]

I seem to be getting null on q3kpu for every query I make...

Thanks for this maradine, very cool...

[maradine]

Good catch - fixed.

[Stomps]

Only seems to do weapons with a period added, otherwise any straight 'ask weapon nnnn' query errors with 'Was that a legit weapon id and period? I didn't get anything back.'

Also how to do group calls? Eg stats on all shotguns, or all pump shotguns but without entering them all individually query line by query line?

Also theres no faction tags on things like liberator belly guns, no idea which is TR/NC/VS after a 'list weapons 115' query

And tank mines/c4 only have one entry for all

just minor problems tho, looks good so far on the whole, nice idea doing it through an ircbot

[MerlO]

Would it be possible to get a datestamp on the output when querying a previous period - for looking at trends over time? I guess you will get to adding querying of multiple periods...

Thanks again.

[maradine]

Yeah, I will. I actually added '!oracle list periods' yesterday, but it's outputting in epoch time at the moment - useful for me and SOE, not for anyone else. As an aside, Java date/time handling is by far the worst part of the default language. TL;DR, I'll get it pretty this morning.

As to Stomps's list:

1. It's also possible your weapon id was off. Default periods was working yesterday. I'll take a look and see if I fucked up something.
2. Group calls are next on the feature list. Haven't figured out if I want to add sorting syntax or not, but it should be done this weekend.
3. As mentioned above, I have it, I'm just not presenting it yet. Will fix shortly.
4. What you see is what you get for explosives. That's how SOE records them. There's a real-time resolve workaround I can do for weapons like that since I'm sitting in the raw stream, but it's pretty low on the priority list.

Thanks for the feedback!

[Mordelicius]

Oh mighty Oracle, I beseech thee, share to us your knowledge and understanding of everything PS2.

Is it possible to get Headshot data between factions? Such as specific/general infantry weapon headshots?

[maradine]

Yes. Let's take a look at whether that would be interesting or not:

Period 7, September 20th, All Servers
id 24004: EM4 Longshot
====
Kills: 14,918
Kills that were headshots: 11,662, 78%
Uniques: 1,338
KPU: 11.15
AVGBR: 44.7

id 25004: RAMS .50M
====
Kills: 18,304
Kills that were headshots: 14,322, 78%
Uniques: 1,656
KPU: 11.05
AVGBR: 45.3

id 26004: Parallax VX3
====
Kills: 15,678
Kills that were headshots: 12,538, 80%
Uniques: 1,310
KPU: 11.97
AVGBR: 47.1

I'd call that a hell of a control.

If headshot data is interesting to you, I'll add it to the manifest. It's a simple additional summation in the aggregator over rows it already has to touch every night.

[MerlO]

/thread necro

Originally Posted by Stomps

Also how to do group calls? Eg stats on all shotguns, or all pump shotguns but without entering them all individually query line by query line?

Added a feature to generate kill stats for all weapons of a particular category (type), the output is the standard sum / averaging i've been doing in spreadsheets :
!oracle report <category_id>

where category_id can be found by !oracle list types

e.g !oracle report 4 will output a summary of all shotgun kill stats to date.

Of course raw period data is still needed to track changes over time.

Vehicle deaths are also aggregated in the same manner:
!oracle vehreport <faction_id> <vehicle_id>

[Stomps]

I did try a few different ones, they all errored until i put in a period (5) and they then completed

Id be interested in headshots over 50% for automatic weapons (cheaters to report)

Something ive not seen mentioned yet, and not something we can easily pull at the user level, what is the user weighted overall Kpu for all weapons, all vehicles and all universally combined?

[maradine]

I don't do per-user stats. I have the data, but that's not the direction I'm approaching this from. For the record, there are guys inside SOE running that exact logic looking for outliers.

I popped in this morning to check on the query engine - everything's reporting back successfully.

[Stomps]

Originally Posted by maradine

I don't do per-user stats. I have the data, but that's not the direction I'm approaching this from. For the record, there are guys inside SOE running that exact logic looking for outliers.

I popped in this morning to check on the query engine - everything's reporting back successfully.

1. No perhaps I didnt explain it fully, I mean im interested in knowing what is the global all game all weapon average KPU, a single figure averaging kpus for every weapon in the game (or broken out to three figures, the global all figure again but showing its make up of global soldier weapons + global vehicle weapons) to find a single overall Kpu - for us to find that at our user level (using the ircbot) would involve pulling kpus from every weapon class and computing the answer from those when yourself would maybe have that on your fingertips (or at least be able to run the query much faster)?

2. For me its still making an error without a period. Here are my steps, ill copy the exact lines out from my irc entry bar along with the relevant part of their replies needed to test. (brackets are my notes)

!oracle list weapons 4 (shotguns)
ORACLE 39001: TRS-12 Uppercut (15 shotguns returned including this one)
!oracle ask weapon 39001 (to retrieve data for the uppercut, note no period used)
ORACLE MyIrcName: Was that a legit weapon id and period? I didn't get anything back. (error here)
!oracle ask weapon 39001 5 (same line with added period)
ORACLE MyIrcName: TRS-12 Uppercut - kills: 3240 uniques: 315 kpu: 10.3 avgbr: 59.6 q1kpu: 8.2 q2kpu: 9.7 q3kpu: 12.2 q4kpu: 9.1 (completed query)

hth