Statbus (and related miscellany)

(Mainly the wiki)
User avatar
Atlanta-Ned
In-Game Game Master
Joined: Fri Apr 18, 2014 2:11 pm
Byond Username: Atlanta-ned

Statbus (and related miscellany)

Post by Atlanta-Ned » #279587

Statbus has moved due to Statnarok. Please see the new thread here.



I'm linked on tgstation13.org now, so I'm going to open a new thread for talking about the stats (and other loosely related projects).

Here they are.

At the moment, I'm right in the middle of majorly refactoring how stats are handled and displayed. There's a lot of broken stuff, but right now that *should* be mostly limited to individual round views. On a more positive note, specific datapoints for specific rounds can now be linked to directly (example).

That being said, monthly stats are mostly in a good place at the moment (that's arguably the most important feature here).

Browse around, let me know if there's some data you want that I don't have. If you find a bug, report it here, or be a real Cool Person™ and open an issue.

EDIT: Results of one-off queries:

Rounds that ended in restart votes: 582 (11-4-2017)
Last edited by Atlanta-Ned on Sat Nov 18, 2017 3:16 pm, edited 2 times in total.
Statbus! | Admin Feedback
OOC: Pizzatiger: God damn Atlanta, how are you so fucking smart and charming. It fucking pisses me off how perfect you are
User avatar
D&B
Joined: Mon Jun 13, 2016 2:23 am
Byond Username: Repukan
Location: *teleports behind you*

Re: Statbus (and related miscellany)

Post by D&B » #279617

Drone shells activated and a permabanned button next to their ckey
Spoiler:
[20:26:02]ADMIN: PM: [censored admin]->[censored]: Welp. It was just a prank bro isn't a very good excuse when it comes to unprovoked nonantag murder, but since this is your first time doing it and you seem to understand the problem instead of a bannu I'm just going to leave you with a warning. Please PLEASE don't do this again in the future, as funny as crackhead broken bottle memes can be. Alrighty? Do you have any input on this?
[20:26:39]ADMIN: PM: [censored]->[censored admin]: Alright, no problem. I have some input. Fuck my boy pussy.
[20:27:06]ADMIN: PM: [censored admin]->[censored]: Okay then. Have fun.
[20:31:29]ADMIN: PM: [censored admin]->[censored]: Excuse me?
J_Madison wrote: that's a stupid fucking stat
you don't play, you've never played
lying little shit with your bullshit stat
fuck you
ColonicAcid wrote:and with enough practise i too could blow my own dick so well that only the gods know how it feels.
User avatar
XDTM
Github User
Joined: Fri Mar 04, 2016 8:38 pm
Byond Username: XDTM
Github Username: XDTM
Location: XDTM

Re: Statbus (and related miscellany)

Post by XDTM » #279912

A list of items that appear in persistent satchels could be nice, you'd get to see if that item you hid ever affected a round, or if it's still around.
a.k.a. Duke Hayka

Coder of golems, virology, hallucinations, traumas, nanites, and a bunch of miscellaneous stuff.
User avatar
Atlanta-Ned
In-Game Game Master
Joined: Fri Apr 18, 2014 2:11 pm
Byond Username: Atlanta-ned

Re: Statbus (and related miscellany)

Post by Atlanta-Ned » #280371

With e59a90, support for cronjobs has been added. This lays the groundwork for caching stats. Right off the top of my head, this'll be a much better way to handle deaths. I can pull down deaths on a day-by-day basis and generate deathmaps that suck less™.

EDIT: Funfact: There are 517.5 MB of round logs cached in the app. On a related note, dsay(deadchat) is now purple, instead of being say's usual green. :)
Statbus! | Admin Feedback
OOC: Pizzatiger: God damn Atlanta, how are you so fucking smart and charming. It fucking pisses me off how perfect you are
User avatar
oranges
Code Maintainer
Joined: Tue Apr 15, 2014 9:16 pm
Byond Username: Optimumtact
Github Username: optimumtact
Location: #CHATSHITGETBANGED

Re: Statbus (and related miscellany)

Post by oranges » #280383

I just want to say that atlanta ned is the best guy in the world for doing this stuff.
User avatar
XDTM
Github User
Joined: Fri Mar 04, 2016 8:38 pm
Byond Username: XDTM
Github Username: XDTM
Location: XDTM

Re: Statbus (and related miscellany)

Post by XDTM » #280573

Agree, this is great
a.k.a. Duke Hayka

Coder of golems, virology, hallucinations, traumas, nanites, and a bunch of miscellaneous stuff.
User avatar
Atlanta-Ned
In-Game Game Master
Joined: Fri Apr 18, 2014 2:11 pm
Byond Username: Atlanta-ned

Re: Statbus (and related miscellany)

Post by Atlanta-Ned » #282252

He did it, the madman.

I had to wipe out all the previously saved monthly stats. Good news though! I'm replacing them with NEWER, BETTER stats. Sit tight, and they should be up shortly.

Hey look, here's a listing of #s of rounds, per month, plus the first and last round of those months! :D From October 2011 through April of this year.
Our data before PR #23419 (~Jan. 28th of this year) is suspect though, since the saving of round data was tied to a physical object in the game before then.

Code: Select all

rounds | date    | firstround | lastround
------------------------------------------
44     | 10-2011 | 0          | 43
653    | 11-2011 | 0          | 695
619    | 12-2011 | 0          | 1313
624    | 01-2012 | 0          | 1936
565    | 02-2012 | 0          | 2500
555    | 03-2012 | 0          | 3054
657    | 04-2012 | 3055       | 3711
680    | 05-2012 | 3712       | 4391
665    | 06-2012 | 4392       | 5056
1266   | 07-2012 | 5057       | 6322
1450   | 08-2012 | 6323       | 7772
1230   | 09-2012 | 7773       | 9002
1125   | 10-2012 | 9003       | 10127
1191   | 11-2012 | 10128      | 11318
1235   | 12-2012 | 11319      | 12553
1297   | 01-2013 | 12554      | 13850
1268   | 02-2013 | 13851      | 15118
1343   | 03-2013 | 15119      | 16461
1446   | 04-2013 | 16462      | 17907
769    | 05-2013 | 17908      | 18676
671    | 06-2013 | 18677      | 19347
811    | 07-2013 | 19348      | 20158
1286   | 08-2013 | 20159      | 21444
1260   | 09-2013 | 21445      | 22704
1361   | 10-2013 | 22705      | 24065
1386   | 11-2013 | 24066      | 25451
1372   | 12-2013 | 25452      | 26823
1286   | 01-2014 | 26824      | 28109
1141   | 02-2014 | 28110      | 29250
1347   | 03-2014 | 29251      | 30597
1118   | 04-2014 | 30598      | 31715
1114   | 05-2014 | 31716      | 32829
1448   | 06-2014 | 32830      | 34277
1396   | 07-2014 | 34278      | 35673
1318   | 08-2014 | 35674      | 36991
757    | 09-2014 | 36992      | 37748
999    | 10-2014 | 37749      | 38747
914    | 11-2014 | 38748      | 39661
1070   | 12-2014 | 39662      | 40731
1199   | 01-2015 | 40732      | 41930
996    | 02-2015 | 41931      | 42926
1024   | 03-2015 | 42927      | 43950
1047   | 04-2015 | 43951      | 44997
1063   | 05-2015 | 44998      | 46060
1055   | 06-2015 | 46061      | 47115
1176   | 07-2015 | 47116      | 48291
1274   | 08-2015 | 48292      | 49565
1026   | 09-2015 | 49566      | 50591
1130   | 10-2015 | 50592      | 51721
1079   | 11-2015 | 51722      | 52800
962    | 12-2015 | 52801      | 53762
1264   | 01-2016 | 53763      | 55026
1311   | 02-2016 | 55027      | 56337
1389   | 03-2016 | 56338      | 57726
1279   | 04-2016 | 57727      | 59005
1280   | 05-2016 | 59006      | 60285
1119   | 06-2016 | 60286      | 61404
896    | 07-2016 | 61405      | 62300
887    | 08-2016 | 62301      | 63187
896    | 09-2016 | 63188      | 64083
556    | 10-2016 | 64084      | 64639
322    | 11-2016 | 64640      | 64961
366    | 12-2016 | 64962      | 65327
497    | 01-2017 | 65328      | 65824
1302   | 02-2017 | 65825      | 67126
1335   | 03-2017 | 67127      | 68461
784    | 04-2017 | 68462      | 69245
Statbus! | Admin Feedback
OOC: Pizzatiger: God damn Atlanta, how are you so fucking smart and charming. It fucking pisses me off how perfect you are
User avatar
Fiz Bump
Joined: Thu Apr 23, 2015 10:00 pm
Byond Username: Dennyb

Re: Statbus (and related miscellany)

Post by Fiz Bump » #282493

I love data
I play Fiz Bump.
I am not a game admin. My reign of badminnery ended a few years ago.View me feedback here: >:^)
User avatar
Atlanta-Ned
In-Game Game Master
Joined: Fri Apr 18, 2014 2:11 pm
Byond Username: Atlanta-ned

Re: Statbus (and related miscellany)

Post by Atlanta-Ned » #282707

Atlanta-Ned wrote: I had to wipe out all the previously saved monthly stats. Good news though! I'm replacing them with NEWER, BETTER stats. Sit tight, and they should be up shortly.
And we're up. Check it out. Now you can see how many rounds occurred in a given month*, plus what the first and last recorded round ID for a given month was! Just like the gypsy woman said!!

Coders+ (so, everyone with coder rank in-game and up) also have access to the monthly stats manager backend. This will allow them to generate stats for a given month, or regenerate them if they need to be rebuilt.

---------------

*Ned, why aren't you also showing the average round duration?
I'm glad you asked. Turns out that round durations aren't saved to the DB. In fact, the DB has no concept of distinct rounds as far as I can tell. Everything you see was meticulously put together by yours truly.

However, round_start and round_end are recorded, but not in a format that I can work with easily, or even in a way that makes sense. Here's what I had to do.

MySQL has excellent support for time and date data. Too bad round_start and round_end are stored as simple text strings. So I have to, once I found the round_id, go back and pull out round_start and round_end separately, then convert them to a format that MySQL can work with. For the sake of my sanity, I alias those results as start and end.

Problem is, once I use those aliases, I can't reuse them because MySQL hates you. So, on the third line, I have to convert the round_start and round_end times back to a proper date/time format that MySQL can use, and run it through a function that tells me how much time there is between those two points.

So, that's a super complex query to begin with. The link above is for the function that pulls down some data about a given round #, so it's "fast" since we're limiting it to one specific round. On my local development server, which is the best-case scenario in terms of speed, the query takes 10.1ms to execute. To us, that's fast, but in terms of DB queries, that's a little on the high side.

If we open that query up and pull down, say, the last 30 rounds (which is what the round listing currently does), the query takes 58.3ms. That's almost 6 times as long. Now imagine trying to pull all that data for every round that occurred in the month of March.

That being said, I'll probably add that at some point :)
Statbus! | Admin Feedback
OOC: Pizzatiger: God damn Atlanta, how are you so fucking smart and charming. It fucking pisses me off how perfect you are
User avatar
XDTM
Github User
Joined: Fri Mar 04, 2016 8:38 pm
Byond Username: XDTM
Github Username: XDTM
Location: XDTM

Re: Statbus (and related miscellany)

Post by XDTM » #282731

Spoiler:
Image
There seems to be debug text left, not sure if intentional
a.k.a. Duke Hayka

Coder of golems, virology, hallucinations, traumas, nanites, and a bunch of miscellaneous stuff.
User avatar
iamgoofball
Github User
Joined: Fri Apr 18, 2014 5:50 pm
Byond Username: Iamgoofball
Github Username: Iamgoofball

Re: Statbus (and related miscellany)

Post by iamgoofball » #282733

Can I get permission to generate stats and such? I like referencing them for code purposes.
User avatar
Atlanta-Ned
In-Game Game Master
Joined: Fri Apr 18, 2014 2:11 pm
Byond Username: Atlanta-ned

Re: Statbus (and related miscellany)

Post by Atlanta-Ned » #282738

iamgoofball wrote:Can I get permission to generate stats and such? I like referencing them for code purposes.
1. I'd need to add a way to add access to specific people. Right now I'm pulling permissions from the server's admins.txt. I'll probably get around to doing this
2. Right now, the only thing coders+ can do is generate stats for a specific month. It might be faster/easier to hit me up with your queries on IRC. What sort of reports are you looking for?
Statbus! | Admin Feedback
OOC: Pizzatiger: God damn Atlanta, how are you so fucking smart and charming. It fucking pisses me off how perfect you are
User avatar
Atlanta-Ned
In-Game Game Master
Joined: Fri Apr 18, 2014 2:11 pm
Byond Username: Atlanta-ned

Re: Statbus (and related miscellany)

Post by Atlanta-Ned » #282739

iamgoofball wrote:Can I get permission to generate stats and such? I like referencing them for code purposes.
1. I'd need to add a way to add access to specific people. Right now I'm pulling permissions from the server's admins.txt. I'll probably get around to doing this
2. Right now, the only thing coders+ can do is generate stats for a specific month. It might be faster/easier to hit me up with your queries on IRC. What sort of reports are you looking for?
Statbus! | Admin Feedback
OOC: Pizzatiger: God damn Atlanta, how are you so fucking smart and charming. It fucking pisses me off how perfect you are
User avatar
iamgoofball
Github User
Joined: Fri Apr 18, 2014 5:50 pm
Byond Username: Iamgoofball
Github Username: Iamgoofball

Re: Statbus (and related miscellany)

Post by iamgoofball » #282740

I like to go over stuff every so often and grab the latest data when metastation emerge.
User avatar
Remie Richards
Joined: Thu Apr 17, 2014 7:11 pm
Byond Username: CrimsonVision
Location: England, UK, Earth, Sol, Milky Way, Local Group, Virgo Supercluster, Known Universe
Contact:

Re: Statbus (and related miscellany)

Post by Remie Richards » #282889

Atlanta-Ned wrote:Our data before PR #23419 (~Jan. 28th of this year) is suspect though, since the saving of round data was tied to a physical object in the game before then.
yes, an object that respawns itself, copying all data to the respawned one, meaning no data is lost at all*
(*there was a bug for a short time when qdel was introduced, which was ages ago, and was fixed not long after)
私は完璧
User avatar
oranges
Code Maintainer
Joined: Tue Apr 15, 2014 9:16 pm
Byond Username: Optimumtact
Github Username: optimumtact
Location: #CHATSHITGETBANGED

Re: Statbus (and related miscellany)

Post by oranges » #282961

more like it was suspect because the only person paying attention to the output was erro and he was mostly checked out, so if feedback was broken or incorrect or missing nobody would have noticed for ages.

we should throw all that historical data out and start again.
User avatar
Dax Dupont
In-Game Admin
Joined: Sun Apr 20, 2014 9:07 pm
Byond Username: DaxYeen
Github Username: DaxDupont
Location: Belgium

Re: Statbus (and related miscellany)

Post by Dax Dupont » #283414

Image
Seems like your auto-renew for let's encrypt broke.
User avatar
Atlanta-Ned
In-Game Game Master
Joined: Fri Apr 18, 2014 2:11 pm
Byond Username: Atlanta-ned

Re: Statbus (and related miscellany)

Post by Atlanta-Ned » #283455

Dag nabbit.

EDIT: Fixed

Also here's a Github shitpost comment generator. Because I was bored and I love you.
Statbus! | Admin Feedback
OOC: Pizzatiger: God damn Atlanta, how are you so fucking smart and charming. It fucking pisses me off how perfect you are
User avatar
DemonFiren
Joined: Sat Dec 13, 2014 9:15 pm
Byond Username: DemonFiren

Re: Statbus (and related miscellany)

Post by DemonFiren » #283584

Atlanta-Ned wrote:Dag nabbit.

EDIT: Fixed

Also here's a Github shitpost comment generator. Because I was bored and I love you.
Fucking goof! Test your code before you buff Engineering good boi points!

Closed for mergebegging
Image
Image
Image
ImageImageImageImageImage

non-lizard things:
Spoiler:
Image
User avatar
Atlanta-Ned
In-Game Game Master
Joined: Fri Apr 18, 2014 2:11 pm
Byond Username: Atlanta-ned

Re: Statbus (and related miscellany)

Post by Atlanta-Ned » #283787

There's a known issue where viewing a round before its logs are available will cause the wrong logs to be shown. This would be so much easier if the DB/game code used the concept of round_IDs, but that's just me beating a dead horse.

Anywho, I'm working on a tool that will let coders+ regenerate logs for a round*. At the same time, I'm refactoring round logs so that we can also get attack logs in line. What I really need to do is find a way to selectively an array from a JSON object based on a value at a given index in said array. So you can, say, load just the GAME logs for a given round, or see everyone ERPing over PDA messages.

* Why coders+ though?
Matching round logs up with a given round is a pretty complicated (read: time-consuming) process that ties up an uncomfortably large amount of resources on the atlanta ned dot space server. In theory I can trust coders not to hammer that regenerate button over and over and over, whereas letting the general public do it is a Bad Idea™. Think of it as a one-person DOS attack.
Statbus! | Admin Feedback
OOC: Pizzatiger: God damn Atlanta, how are you so fucking smart and charming. It fucking pisses me off how perfect you are
bman
Github User
Joined: Fri Oct 14, 2016 4:55 pm
Byond Username: Basilman
Github Username: Militaires

Re: Statbus (and related miscellany)

Post by bman » #284464

Atlanta-Ned wrote:In theory I can trust coders not to hammer that regenerate button over and over and over, whereas letting the general public do it is a Bad Idea™. Think of it as a one-person DOS attack.
hire me as a the "DATABASE HOBO" ill sit in the database, punching the button periodically and beat the shit out of anyone who tries to come close
User avatar
Atlanta-Ned
In-Game Game Master
Joined: Fri Apr 18, 2014 2:11 pm
Byond Username: Atlanta-ned

Re: Statbus (and related miscellany)

Post by Atlanta-Ned » #284863

Statbus! | Admin Feedback
OOC: Pizzatiger: God damn Atlanta, how are you so fucking smart and charming. It fucking pisses me off how perfect you are
User avatar
Iatots
Joined: Thu Oct 13, 2016 3:17 pm
Byond Username: Iatots
Github Username: Iatots

Re: Statbus (and related miscellany)

Post by Iatots » #284879

>You have wasted 0 hours playing Space Station 13
aw it's brok-
>because time spent doing something you enjoy isn't wasted time.
aww :3



edit:
also this is still a thing for me.
Attachments
asddd.png
User avatar
Atlanta-Ned
In-Game Game Master
Joined: Fri Apr 18, 2014 2:11 pm
Byond Username: Atlanta-ned

Re: Statbus (and related miscellany)

Post by Atlanta-Ned » #285252

When do people actually play the game? Science has no way of knowing. Until now.

Check it out here. NOTE: This is a SLOW query and could take almost 30 seconds to render. I also added the chart to your me page, so you can see when you connect. Badmins can also see connection hour charts on tgdb so we can factor that into finding new badmins, wrt availability.

Iatots wrote: edit: [screenshot of incredibly broken objectives view]
also this is still a thing for me.
Known issue. I'll get around to fixing it ~eventually~
Statbus! | Admin Feedback
OOC: Pizzatiger: God damn Atlanta, how are you so fucking smart and charming. It fucking pisses me off how perfect you are
User avatar
oranges
Code Maintainer
Joined: Tue Apr 15, 2014 9:16 pm
Byond Username: Optimumtact
Github Username: optimumtact
Location: #CHATSHITGETBANGED

Re: Statbus (and related miscellany)

Post by oranges » #285374

what timezone is it jsut UTC?
User avatar
Jordie0608
Site Admin
Joined: Tue Apr 15, 2014 1:33 pm
Byond Username: Jordie0608
Github Username: Jordie0608
Location: Spiderland, Australia

Re: Statbus (and related miscellany)

Post by Jordie0608 » #285400

Yes; although there are likely UTC-6 records mixed in as from when the DB lived with SoS.
Forum Admin
Send me a PM if you have any issues, concerns or praise of fishfood to express about the forums.
User avatar
Atlanta-Ned
In-Game Game Master
Joined: Fri Apr 18, 2014 2:11 pm
Byond Username: Atlanta-ned

Re: Statbus (and related miscellany)

Post by Atlanta-Ned » #285587

Jordie0608 wrote:Yes; although there are likely UTC-6 records mixed in as from when the DB lived with SoS.
Ha ha ha shoot me. If someone can get me a time range I can exclude those records.
Statbus! | Admin Feedback
OOC: Pizzatiger: God damn Atlanta, how are you so fucking smart and charming. It fucking pisses me off how perfect you are
User avatar
Atlanta-Ned
In-Game Game Master
Joined: Fri Apr 18, 2014 2:11 pm
Byond Username: Atlanta-ned

Re: Statbus (and related miscellany)

Post by Atlanta-Ned » #286002

Ok, it's the data you've all been waiting for: average round durations

Before I get to the data itself, I wanna drop a pretty significant disclaimer on it.

1. I'm "good" with SQL, but I don't know if I'm that good. Here's the query I'm using to generate these numbers:

Code: Select all

SELECT
MONTH(ss13feedback.time) AS `month`,
YEAR(ss13feedback.time) AS `year`,
SEC_TO_TIME(AVG(TIMEDIFF(STR_TO_DATE(end.details,'%a %b %d %H:%i:%s %Y'),STR_TO_DATE(start.details,'%a %b %d %H:%i:%s %Y')))) AS avgduration,
count(DISTINCT ss13feedback.round_id) AS rounds
FROM ss13feedback
LEFT JOIN ss13feedback AS `end` ON ss13feedback.round_id = end.round_id AND end.var_name = 'round_end'
LEFT JOIN ss13feedback AS `start` ON ss13feedback.round_id = start.round_id AND start.var_name = 'round_start'
WHERE ss13feedback.var_name='round_end'
GROUP BY YEAR(ss13feedback.time), MONTH(ss13feedback.time)
ORDER BY `year` DESC, `month` DESC
This is also one of the slowest queries I've ever run against the DB, clocking in at around 35 seconds, so don't expect a page for it to show up on the stats site anytime soon.

2. The data is unreliable, especially before January of this year (2017). I can't quantify how it might be unreliable though. Like I said earlier in this thread, our stats are fishy as hell.

All that being said, here you go:

Code: Select all

month | year | avgduration   | rounds
-----------------------------------
4     | 2017 | 02:11:24.5164 | 1014
3     | 2017 | 02:18:12.9916 | 1335
2     | 2017 | 01:57:49.2484 | 1302
1     | 2017 | 01:53:09.4424 | 497
12    | 2016 | 02:04:11.3132 | 366
11    | 2016 | 02:06:20.6894 | 322
10    | 2016 | 02:11:18.5548 | 556
9     | 2016 | 02:09:48.1318 | 896
8     | 2016 | 02:25:10.4449 | 887
7     | 2016 | 02:18:33.8741 | 896
6     | 2016 | 02:13:50.8267 | 1119
5     | 2016 | 02:09:19.5680 | 1280
4     | 2016 | 02:09:04.5675 | 1279
3     | 2016 | 02:08:39.7173 | 1389
2     | 2016 | 02:08:24.1656 | 1311
1     | 2016 | 02:29:54.5254 | 1264
12    | 2015 | 02:48:24.8018 | 962
11    | 2015 | 02:53:06.3239 | 1079
10    | 2015 | 02:49:41.5222 | 1130
9     | 2015 | 03:03:21.2165 | 1026
8     | 2015 | 02:31:54.2462 | 1274
7     | 2015 | 02:45:21.4369 | 1176
6     | 2015 | 03:06:43.7533 | 1055
5     | 2015 | 03:11:59.7365 | 1063
4     | 2015 | 02:56:20.1100 | 1047
3     | 2015 | 03:14:26.1990 | 1024
2     | 2015 | 02:53:22.9949 | 996
1     | 2015 | 02:44:43.2813 | 1199
12    | 2014 | 03:02:00.8308 | 1070
11    | 2014 | 03:09:52.9606 | 914
10    | 2014 | 03:17:12.5278 | 999
9     | 2014 | 03:26:31.7904 | 757
8     | 2014 | 03:28:05.6494 | 1318
7     | 2014 | 03:04:26.4435 | 1396
6     | 2014 | 02:54:08.7472 | 1448
5     | 2014 | 03:05:33.4618 | 1114
4     | 2014 | 02:34:16.2658 | 1118
3     | 2014 | 02:21:54.4393 | 1345
2     | 2014 | 02:23:36.6836 | 1141
1     | 2014 | 02:17:40.6163 | 1286
12    | 2013 | 02:12:32.4814 | 1372
11    | 2013 | 02:20:13.3321 | 1386
10    | 2013 | 02:32:01.7711 | 1361
9     | 2013 | 02:34:42.2591 | 1260
8     | 2013 | 02:33:19.5182 | 1286
7     | 2013 | 03:01:53.8876 | 811
6     | 2013 | 02:21:34.4456 | 671
5     | 2013 | 03:01:37.2832 | 769
4     | 2013 | 02:35:27.9059 | 1446
3     | 2013 | 02:27:33.7408 | 1343
2     | 2013 | 02:16:13.6619 | 1268
1     | 2013 | 02:31:31.9899 | 1297
12    | 2012 | 02:39:41.9554 | 1235
11    | 2012 | 02:40:12.5499 | 1191
10    | 2012 | 02:54:31.7649 | 1125
9     | 2012 | 02:33:29.3666 | 1230
8     | 2012 | 02:08:34.4692 | 1450
7     | 2012 | 02:12:31.7922 | 1266
6     | 2012 | 02:18:11.1383 | 665
5     | 2012 | 02:17:55.8661 | 680
4     | 2012 | 02:07:23.4458 | 657
3     | 2012 | 02:03:44.7563 | 554
2     | 2012 | 02:27:28.0249 | 564
1     | 2012 | 02:21:39.4991 | 623
12    | 2011 | 02:23:43.9336 | 618
11    | 2011 | 02:08:05.0847 | 652
10    | 2011 | 02:57:14.0000 | 42
Statbus! | Admin Feedback
OOC: Pizzatiger: God damn Atlanta, how are you so fucking smart and charming. It fucking pisses me off how perfect you are
User avatar
Armhulen
Global Moderator
Joined: Thu Apr 28, 2016 4:30 pm
Byond Username: Armhulenn
Github Username: bazelart
Location: The Grand Tournament

Re: Statbus (and related miscellany)

Post by Armhulen » #286462

THEY'RE GONE DOWN SOUND THE ALARM
User avatar
oranges
Code Maintainer
Joined: Tue Apr 15, 2014 9:16 pm
Byond Username: Optimumtact
Github Username: optimumtact
Location: #CHATSHITGETBANGED

Re: Statbus (and related miscellany)

Post by oranges » #286650

huh I'm really suprised the average is 2 hours, I thought it would be closer to 1
User avatar
Iatots
Joined: Thu Oct 13, 2016 3:17 pm
Byond Username: Iatots
Github Username: Iatots

Re: Statbus (and related miscellany)

Post by Iatots » #286689

An average of round lenght based on the time of day they occured would be neat but how do you do that without fixed round start times?
User avatar
Atlanta-Ned
In-Game Game Master
Joined: Fri Apr 18, 2014 2:11 pm
Byond Username: Atlanta-ned

Re: Statbus (and related miscellany)

Post by Atlanta-Ned » #286700

Iatots wrote:An average of round lenght based on the time of day they occured would be neat but how do you do that without fixed round start times?
Really, really dumb SQL queries.
Statbus! | Admin Feedback
OOC: Pizzatiger: God damn Atlanta, how are you so fucking smart and charming. It fucking pisses me off how perfect you are
User avatar
Dax Dupont
In-Game Admin
Joined: Sun Apr 20, 2014 9:07 pm
Byond Username: DaxYeen
Github Username: DaxDupont
Location: Belgium

Re: Statbus (and related miscellany)

Post by Dax Dupont » #287295

Did something bork? No new records since 24 april.
User avatar
Atlanta-Ned
In-Game Game Master
Joined: Fri Apr 18, 2014 2:11 pm
Byond Username: Atlanta-ned

Re: Statbus (and related miscellany)

Post by Atlanta-Ned » #288023

AdAstraPerAspera wrote:Did something bork? No new records since 24 april.
We're back on the air
Statbus! | Admin Feedback
OOC: Pizzatiger: God damn Atlanta, how are you so fucking smart and charming. It fucking pisses me off how perfect you are
User avatar
Atlanta-Ned
In-Game Game Master
Joined: Fri Apr 18, 2014 2:11 pm
Byond Username: Atlanta-ned

Re: Statbus (and related miscellany)

Post by Atlanta-Ned » #288138

"Hey, lets look at refactoring how I parse round logs"

Code: Select all

2 => string 'Godo Schittgablerstrasse/UnconqueredSun: One day while andy was masturbating....' (length=80)
Format:[mob name]/[ckey]

2 => string 'UnconqueredSun/(Godo Schittgablerstrasse): <b>Godo Schittgablerstrasse</b> seizes up and falls limp, his eyes dead and lifeless...' (length=130)
Format: [ckey]/[mob name]

2 => string 'Mob Login: Koalacrisp/(Vinny Cherry) was assigned to a /mob/living/carbon/human' (length=79)
Format: [ckey]/[mob name]

2 => string 'Kyle Tireman/BorhilIan: call shuttle or something freon hurts.' (length=62)
Format: [mob name]/[ckey]
I'm tempted to start a patreon just to fund the drinking habit I'm going to inevitably develop.
Statbus! | Admin Feedback
OOC: Pizzatiger: God damn Atlanta, how are you so fucking smart and charming. It fucking pisses me off how perfect you are
User avatar
Atlanta-Ned
In-Game Game Master
Joined: Fri Apr 18, 2014 2:11 pm
Byond Username: Atlanta-ned

Re: Statbus (and related miscellany)

Post by Atlanta-Ned » #288273

I broke round log parsing. Please do not use them unless they are noted as being loaded from cache. I'll have this fixed shortly. Apologies for the inconvenience.

EDIT: This also might be due to the logging change that got merged a few days ago. I'm still collecting information.
Statbus! | Admin Feedback
OOC: Pizzatiger: God damn Atlanta, how are you so fucking smart and charming. It fucking pisses me off how perfect you are
User avatar
Atlanta-Ned
In-Game Game Master
Joined: Fri Apr 18, 2014 2:11 pm
Byond Username: Atlanta-ned

Re: Statbus (and related miscellany)

Post by Atlanta-Ned » #288724

Check it: Testmerged PRs are now accounted for and linked to github. At some point I'll add a feature to search rounds by PR #, so coders can pull up public logs to see how their feature was received.
Statbus! | Admin Feedback
OOC: Pizzatiger: God damn Atlanta, how are you so fucking smart and charming. It fucking pisses me off how perfect you are
User avatar
Atlanta-Ned
In-Game Game Master
Joined: Fri Apr 18, 2014 2:11 pm
Byond Username: Atlanta-ned

Re: Statbus (and related miscellany)

Post by Atlanta-Ned » #289427

We just tracked our 7000th round! I also added a bunch of new data to the default round info listing. Should be easier to read now.
Statbus! | Admin Feedback
OOC: Pizzatiger: God damn Atlanta, how are you so fucking smart and charming. It fucking pisses me off how perfect you are
User avatar
Atlanta-Ned
In-Game Game Master
Joined: Fri Apr 18, 2014 2:11 pm
Byond Username: Atlanta-ned

Re: Statbus (and related miscellany)

Post by Atlanta-Ned » #289832

And now there's a Station Name generator, built with really crappy Markov text code.
Statbus! | Admin Feedback
OOC: Pizzatiger: God damn Atlanta, how are you so fucking smart and charming. It fucking pisses me off how perfect you are
User avatar
Atlanta-Ned
In-Game Game Master
Joined: Fri Apr 18, 2014 2:11 pm
Byond Username: Atlanta-ned

Re: Statbus (and related miscellany)

Post by Atlanta-Ned » #290745

Nothing exciting to report. Still tweaking round displays as much as I can.

Poly's JSON file is also publicly available (god damn I fucking love JSON), so I naturally took advantage of that on the stats homepage. You can't see it unless you're logged in though.
Statbus! | Admin Feedback
OOC: Pizzatiger: God damn Atlanta, how are you so fucking smart and charming. It fucking pisses me off how perfect you are
User avatar
Atlanta-Ned
In-Game Game Master
Joined: Fri Apr 18, 2014 2:11 pm
Byond Username: Atlanta-ned

Re: Statbus (and related miscellany)

Post by Atlanta-Ned » #295034

Stats aren't being synced (again)*, so I've been working on getting an average round duration vs. game mode query working. Currently it shows data from this year only.

Here are the results.

I dunno if I'm ready to sign off on these results just yet (Only five IAA rounds?), but this is a starting point.

EDIT: * Actually they were completely broken, so no stats were saved between nowish and 5/15. :(
Statbus! | Admin Feedback
OOC: Pizzatiger: God damn Atlanta, how are you so fucking smart and charming. It fucking pisses me off how perfect you are
User avatar
Atlanta-Ned
In-Game Game Master
Joined: Fri Apr 18, 2014 2:11 pm
Byond Username: Atlanta-ned

Re: Statbus (and related miscellany)

Post by Atlanta-Ned » #295531

Statbus! | Admin Feedback
OOC: Pizzatiger: God damn Atlanta, how are you so fucking smart and charming. It fucking pisses me off how perfect you are
User avatar
Atlanta-Ned
In-Game Game Master
Joined: Fri Apr 18, 2014 2:11 pm
Byond Username: Atlanta-ned

Re: Statbus (and related miscellany)

Post by Atlanta-Ned » #296247

A newer version of the CSV file is available, this one includes map names, which I'd forgotten to implement on the last dump.
Statbus! | Admin Feedback
OOC: Pizzatiger: God damn Atlanta, how are you so fucking smart and charming. It fucking pisses me off how perfect you are
User avatar
Atlanta-Ned
In-Game Game Master
Joined: Fri Apr 18, 2014 2:11 pm
Byond Username: Atlanta-ned

Re: Statbus (and related miscellany)

Post by Atlanta-Ned » #298021

In which Ned has one of those days, I just pushed a bunch of changes. We're taking advantage of the database tracking time spent playing specific roles now, which you can see on your me page. There's also a clock in the footer so you don't have to juggle timezones (all the data is in GMT).

The death page has also been redesigned and I'll be doing some exciting work on that coming up.
Statbus! | Admin Feedback
OOC: Pizzatiger: God damn Atlanta, how are you so fucking smart and charming. It fucking pisses me off how perfect you are
User avatar
Atlanta-Ned
In-Game Game Master
Joined: Fri Apr 18, 2014 2:11 pm
Byond Username: Atlanta-ned

Re: Statbus (and related miscellany)

Post by Atlanta-Ned » #298042

Quick update: here's a chart of global job popularity that no one knew they wanted or asked for!
Statbus! | Admin Feedback
OOC: Pizzatiger: God damn Atlanta, how are you so fucking smart and charming. It fucking pisses me off how perfect you are
User avatar
Steelpoint
Github User
Joined: Thu Apr 17, 2014 6:37 pm
Byond Username: Steelpoint
Github Username: Steelpoint
Location: The Armoury

Re: Statbus (and related miscellany)

Post by Steelpoint » #298097

Will there be a possible way to eventually discern Nuke Op rounds into non-war and war rounds? I would love to know the win/lose rate of Op War rounds.

I know it may be a tall ask, right now we just see that out of 385 rounds, the Ops have won 41 rounds, lost 28 with 7 being a halfwin and 3 with the nuke disarming.
Image
User avatar
Jordie0608
Site Admin
Joined: Tue Apr 15, 2014 1:33 pm
Byond Username: Jordie0608
Github Username: Jordie0608
Location: Spiderland, Australia

Re: Statbus (and related miscellany)

Post by Jordie0608 » #298148

All it'd need is a feedback stat placed somewhere around here
Forum Admin
Send me a PM if you have any issues, concerns or praise of fishfood to express about the forums.
User avatar
Atlanta-Ned
In-Game Game Master
Joined: Fri Apr 18, 2014 2:11 pm
Byond Username: Atlanta-ned

Re: Statbus (and related miscellany)

Post by Atlanta-Ned » #298313

Steelpoint wrote:Will there be a possible way to eventually discern Nuke Op rounds into non-war and war rounds? I would love to know the win/lose rate of Op War rounds.

I know it may be a tall ask, right now we just see that out of 385 rounds, the Ops have won 41 rounds, lost 28 with 7 being a halfwin and 3 with the nuke disarming.
There already is.

Here's the data I was able to extract from the DB. These are all rounds where war were declared:

Code: Select all

round_id   result
-----------------------------------
66364    | loss - evacuation - disk secured - syndi team dead
66386    | win - syndicate nuke
66465    | halfwin - evacuation - disk not secured
66481    | loss - evacuation - disk secured
66719    | win - syndicate nuke
66837    | loss - evacuation - disk secured - syndi team dead
66901    | loss - evacuation - disk secured - syndi team dead
66931    | loss - evacuation - disk secured
66941    | loss - evacuation - disk secured - syndi team dead
66946    | win - syndicate nuke
66970    | loss - evacuation - disk secured - syndi team dead
66980    | halfwin - evacuation - disk not secured
66987    | loss - evacuation - disk secured
67050    | loss - evacuation - disk secured - syndi team dead
67087    | loss - evacuation - disk secured - syndi team dead
67123    | loss - evacuation - disk secured - syndi team dead
67222    | halfwin - detonation averted
67296    | loss - evacuation - disk secured - syndi team dead
67300    | NULL
67388    | loss - evacuation - disk secured - syndi team dead
67483    | win - syndicate nuke
67587    | win - syndicate nuke
67628    | loss - evacuation - disk secured
67684    | halfwin - evacuation - disk not secured
67731    | win - syndicate nuke
67779    | loss - evacuation - disk secured - syndi team dead
67806    | win - syndicate nuke
67838    | loss - evacuation - disk secured - syndi team dead
67853    | loss - evacuation - disk secured
67911    | win - syndicate nuke
68000    | NULL
68105    | loss - evacuation - disk secured - syndi team dead
68114    | loss - evacuation - disk secured - syndi team dead
68166    | win - syndicate nuke
68238    | loss - evacuation - disk secured
68372    | NULL
68380    | loss - evacuation - disk secured - syndi team dead
68428    | loss - evacuation - disk secured
68499    | win - syndicate nuke
68510    | win - syndicate nuke
68559    | halfwin - syndicate nuke - did not evacuate in time
68597    | loss - evacuation - disk secured
68598    | loss - evacuation - disk secured - syndi team dead
68651    | win - syndicate nuke
68700    | win - syndicate nuke
68734    | NULL
68773    | halfwin - evacuation - disk not secured
68802    | loss - evacuation - disk secured - syndi team dead
68807    | halfwin - evacuation - disk not secured
68814    | win - syndicate nuke
68822    | halfwin - detonation averted
68850    | win - syndicate nuke
68897    | loss - evacuation - disk secured - syndi team dead
68901    | halfwin - syndicate nuke - did not evacuate in time
68954    | loss - evacuation - disk secured - syndi team dead
69039    | loss - evacuation - disk secured - syndi team dead
69172    | loss - evacuation - disk secured
69336    | loss - evacuation - disk secured
69357    | loss - evacuation - disk secured - syndi team dead
69414    | win - syndicate nuke
69611    | win - syndicate nuke
69613    | loss - evacuation - disk secured - syndi team dead
69688    | win - syndicate nuke
70014    | loss - evacuation - disk secured
70020    | loss - evacuation - disk secured - syndi team dead
70074    | loss - evacuation - disk secured - syndi team dead
70174    | win - syndicate nuke
70269    | win - syndicate nuke
70316    | loss - evacuation - disk secured - syndi team dead
70359    | loss - evacuation - disk secured - syndi team dead
70423    | win - syndicate nuke
70454    | loss - evacuation - disk secured
70552    | loss - evacuation - disk secured
70590    | NULL
70601    | win - syndicate nuke
70602    | win - syndicate nuke
70686    | loss - evacuation - disk secured - syndi team dead
70701    | loss - evacuation - disk secured - syndi team dead
70735    | win - syndicate nuke
70746    | loss - syndicate nuked - disk secured
70779    | halfwin - detonation averted
70789    | loss - evacuation - disk secured - syndi team dead
70839    | halfwin - syndicate nuke - did not evacuate in time
Statbus! | Admin Feedback
OOC: Pizzatiger: God damn Atlanta, how are you so fucking smart and charming. It fucking pisses me off how perfect you are
User avatar
Steelpoint
Github User
Joined: Thu Apr 17, 2014 6:37 pm
Byond Username: Steelpoint
Github Username: Steelpoint
Location: The Armoury

Re: Statbus (and related miscellany)

Post by Steelpoint » #298323

Atlanta-Ned wrote:-snip-
Huh, so it has a 25% full win rate. 29% if you count half-wins. That's 66/77 rounds out of 267 rounds.

A lot less than I was assuming. Though I've only been in one war round (and conversely that was probably my fourth or fifth ever Op round) but it seemed like all the TC's you have can make you really, really, powerful individually. I guess it all comes down to competence.
Image
User avatar
Atlanta-Ned
In-Game Game Master
Joined: Fri Apr 18, 2014 2:11 pm
Byond Username: Atlanta-ned

Re: Statbus (and related miscellany)

Post by Atlanta-Ned » #298467

Which is more useful/interesting?

Job popularity + deaths or job popularity with deaths separate?
Statbus! | Admin Feedback
OOC: Pizzatiger: God damn Atlanta, how are you so fucking smart and charming. It fucking pisses me off how perfect you are
Locked

Who is online

Users browsing this forum: No registered users