Top Kills by weapon query

Sinjhin · 2013-02-25, 09:09 PM

Ok, so I am trying to construct a query that will get say, the top five players, per kills with a certain weapon, per a server.

This is turning into a pretty complicated query and I am getting kind of lost. I am not sure it can be done in one query that specifically, and I am not sure if it is even possible without polling every single character (which would be way too taxing on their servers). Maybe the leaderboard part has an option for this?

Anyone have any idea how this could be accomplished?

Sinjhin · 2013-02-25, 09:37 PM

Here is my mag-cutter kills: http://census.soe.com/get/ps2-beta/c...weapon.1.value

mag cutter id:1
chain blade id:13
force-blade id:19

Sinjhin · 2013-02-25, 10:34 PM

Ok, so here is what I have come up with so far: https://census.soe.com/s:soe/get/ps2...9.value,world))

It is getting to be a pretty crazy query, but it is fast. This only shows the top 100 players by kills though, so there could be a guy out there with relatively low kills, but all with a knife... Still need a way to look at every player on the server.