Hey, I wanted to know if it would be possible to create a plugin which shows how many kills, assists,Destructions, Deaths :3, captures and Stabs you did, with each class since ever you play ( and since you have this plugin in your plugin folder obviously
)
I'm not sure, but i guess it would look like to this ajf's plugin:
SELECT
classTypes.name AS class,
SUM(kills),
SUM(assists),
SUM(captures),
SUM(destructions),
SUM(deaths),
(CAST((SUM(kills) + SUM(assists) + SUM(captures) + SUM(destructions)) AS FLOAT) / SUM(deaths))
FROM
(SELECT
player.class AS class,
s1.value AS deaths,
s2.value AS kills,
s3.value AS assists,
s4.value AS captures,
s5.value AS destructions
FROM
player
INNER JOIN
stat AS s1
ON
player.gameId = s1.gameId AND
player.id = s1.playerId
INNER JOIN
stat AS s2
ON
s1.gameId = s2.gameId AND
s1.playerId = s2.playerId
INNER JOIN
stat AS s3
ON
s1.gameId = s3.gameId AND
s1.playerId = s3.playerId
INNER JOIN
stat AS s4
ON
s1.gameId = s4.gameId AND
s1.playerId = s4.playerId
INNER JOIN
stat AS s5
ON
s1.gameId = s5.gameId AND
s1.playerId = s5.playerId
INNER JOIN
game
ON
game.id = player.gameId
WHERE
player.team != 2 AND -- Not spectator
game.version = 26800 AND -- 2.6.8
s1.type = 1 AND -- Deaths
s2.type = 0 AND -- Kills
s3.type = 3 AND -- Assists
s4.type = 2 AND -- Captures
s5.type = 4 /* Destructions */) AS statsAndDeaths
LEFT JOIN
classTypes
ON
statsAndDeaths.class = classTypes.id
GROUP BY
class;
I hope that what I said is clear, that it's possible and that someone wants to do it
Thx
Also, what I don't know is where will be the thing where there are number of kills etc
Author
Topic: Stats class Please (Read 3150 times)
