miscellaneous

Forum > Miscellaneous > i got a shiny sword
Reply To Thread (login)
shoyuken [147]
2012-05-13 14:45:41
[12 years, 196 days ago]

Played time: 100 days, 1 hour, 5 minutes, 56 seconds

4th bot to hit it ;)

http://imgur.com/nQ2Xn


 
ActiveX [169]
Head Moderator
2012-05-13 15:43:21
[12 years, 196 days ago]

GZ!

cough no life cough

^_~


 
Ender [1]
Administrator
2012-05-13 16:33:27
[12 years, 196 days ago]

You're indeed 4th, but how did you know that? I don't recall putting rankings for that stat anywhere.


 
shoyuken [147]
2012-05-13 16:35:33
[12 years, 196 days ago]

I just checked the online times of most of the levelers. I did consider a few energizers, but they've taken most of their online time to their dumpers.


 
Ender [1]
Administrator
2012-05-13 16:45:56
[12 years, 196 days ago]

Gotcha. For the curious:

rank    id      username                days
1       3441    neps                    154.9638
2       499     Xerex                   125.0409
3       142     TheCause                118.1631
4       937     shoyuken                100.1240
5       3636    Myriad                  92.7435
6       5662    Sinister Shadows        83.6727
7       653     Tonc                    79.8913
8       1994    Smeagol                 74.4250
9       40      Satanus Inaximasus      70.8207
10      1542    Eucliwood Hellscythe    67.7150
11      5760    Shattered               60.3660
12      5759    Hallucinogen            60.0161
13      6206    small neps              58.1396
14      6185    Jaziran                 53.3870
15      498     fredtrety               49.3808
16      15386   BFal                    40.3813
17      8962    Zionic 2                40.0861
18      9932    skumi5                  38.1311
19      6204    Kudos                   36.7846
20      5795    ReneDescartes           36.4662
21      199     Ecoueses                36.0382
22      48      Jans                    34.7211
23      896     SaDa                    32.7456
24      2875    Smeagoltest             32.5894
25      7822    Rallos Zek              31.4557
26      4900    Saiyan Z                31.3776
27      1       Ender                   29.0076
28      1428    ActiveX                 28.4428
29      68      The Warden              27.3348
30      3169    Smeagol Hurts           27.2882

 
Trio [191]
2012-05-13 17:19:23
[12 years, 196 days ago]

I'm just shy of making on that list. 25:18:28:11


 
Gpof2 [60]
2012-05-13 20:35:41
[12 years, 195 days ago]

Lol at Skumi on the list


 
Draoi [53]
2012-05-13 22:06:26
[12 years, 195 days ago]

I dislike how played time is reset when you reset.


 
Shoegazer [87]
Moderator
2012-05-13 22:27:06
[12 years, 195 days ago]

grats shoy :)


 
Ender [1]
Administrator
2012-05-13 23:05:04
[12 years, 195 days ago]

With resets:

rank    id      username                days 
1       3441    neps                    155.0214
2       499     Xerex                   125.1034
3       142     TheCause                118.2244
4       937     shoyuken                100.3595
5       3636    Myriad                  92.7435
6       5662    Sinister Shadows        83.7159
7       653     Tonc                    79.8913
8       1994    Smeagol                 74.4250
9       40      Satanus Inaximasus      70.8351
10      1542    Eucliwood Hellscythe    67.9293
11      5760    Shattered               60.3660
12      5759    Hallucinogen            60.0161
13      6206    small neps              58.1396
14      6185    Jaziran                 53.4417
15      498     fredtrety               49.3808
16      190     Draoi                   46.5455
17      15386   BFal                    40.3832
18      8962    Zionic 2                40.0861
19      9932    skumi5                  38.1311
20      6204    Kudos                   36.7846
21      5795    ReneDescartes           36.4670
22      199     Ecoueses                36.0382
23      48      Jans                    34.7211
24      2571    Sera                    33.4064
25      152     Shoegazer               33.2218
26      896     SaDa                    32.7456
27      2875    Smeagoltest             32.5894
28      25      Alan                    32.5464
29      4       Emanuel                 32.5090
30      12702   Trio                    32.2550

 
Alan [19]
2012-05-13 23:34:44
[12 years, 195 days ago]

Aww man. I'm 28th.

Must play less!


 
dragonrose [48]
Head Moderator
2012-05-14 03:04:31
[12 years, 195 days ago]

Jans is on the list O,o

how can someone be online for so long & do so little :|


 
gr33n [78]
2012-05-14 03:54:12
[12 years, 195 days ago]

Jans is on? I'm shocked aswell. He must have an auto-login'er.

He refuses to click so he must do something.


 
Sera [1]
2012-05-14 05:19:31
[12 years, 195 days ago]

Jans above me..


 
Made2shred [87]
2012-05-14 05:43:36
[12 years, 195 days ago]

lol gr33n

and thank god I'm not on the list :P


 
Saiyan Z [140]
2012-05-14 11:15:58
[12 years, 195 days ago]

Ender, does the first table include play time before the server reset on 1/7/2011? I'm fairly sure it does.


 
Nosferatu [50]
2012-05-14 11:43:13
[12 years, 195 days ago]

Let's see the other spectrum. Least amount of played time per age of the bot? Include the resets as well. ^^


 
Ender [1]
Administrator
2012-05-15 00:44:26
[12 years, 194 days ago]

Ender, does the first table include play time before the server reset on 1/7/2011? I'm fairly sure it does.

Looking at the end-of-beta reset script, it looks like the answer is yes, it does include played time from beta.

Let's see the other spectrum. Least amount of played time per age of the bot? Include the resets as well. ^^

I'm not sure I understand. Would this just be a list of bots that were created and not logged into, in the order they were created?


 
Toothless [145]
2012-05-15 00:49:45
[12 years, 194 days ago]

I guess a stipulation could be added that requires there at least be 1 second of played time to remove those from the list.


 
Alan [19]
2012-05-15 08:07:27
[12 years, 194 days ago]

Or, less play time per level?


 
Ender [1]
Administrator
2012-05-15 21:44:16
[12 years, 193 days ago]

So just a list of bots ordered by least played time? That would be all the bots that were logged into once, which doesn't sound too interesting either. :)

Least played time per level could be interesting if it was constrained to level 100+ or something, but even with that it would probably be skewed towards lower levels.


 
Gpof2 [60]
2012-05-15 21:47:04
[12 years, 193 days ago]

How about highest average played time per day? That would be interesting apart from bots created very recently.


 
Ender [1]
Administrator
2012-05-15 22:04:50
[12 years, 193 days ago]

Most hours played per day, with resets:

rank    id      username                days_played days_alive  hours_per_day 
1       15386   BFal                    41.5787     105         9.50370899
2       3441    neps                    155.3656    393         9.48797498
3       19000   PunchMagic              11.9970     39          7.38279202
4       499     Xerex                   125.5323    434         6.94187596
5       5662    Sinister Shadows        84.4509     323         6.27499054
6       3636    Myriad                  93.5296     388         5.78533362
7       937     shoyuken                101.4596    430         5.66285917
8       142     TheCause                118.6891    512         5.56355197
9       20214   Gooky                   0.2309      1           5.54222220
10      5760    Shattered               60.3660     320         4.52744965
11      12702   Trio                    32.6712     174         4.50637452
12      5759    Hallucinogen            60.0161     320         4.50120399
13      6206    small neps              58.1396     313         4.45799166
14      653     Tonc                    79.8913     433         4.42815242
15      20162   mara str                0.5441      3           4.35277778
16      1994    Smeagol                 74.4250     419         4.26300517
17      6185    Jaziran                 53.5843     314         4.09561306
18      20213   filzy                   0.1664      1           3.99416666
19      9932    skumi5                  38.1311     232         3.94460129
20      1542    Eucliwood Hellscythe    68.8392     425         3.88739085
21      8962    Zionic 2                40.4475     252         3.85214727
22      15433   Claypan                 16.4043     104         3.78561699
23      20207   xCoco                   0.1485      1           3.56444443
24      19224   PigVomit                4.5839      32          3.43793403
25      20160   KlimaXX                 0.4220      3           3.37574074
26      15013   mnor                    15.8119     115         3.29986957
27      19445   Eye Candy               3.1103      23          3.24550725
28      18738   Exorcist                5.9108      47          3.01826832
29      12071   iChampion               23.8292     192         2.97864873
30      19115   Big Daddy               4.2971      35          2.94656349

 
Gpof2 [60]
2012-05-15 22:09:35
[12 years, 193 days ago]

Wow look at those troopers. And wow I did not expect someone with a good amount of days alive to average higher than neps. That's quite the feat BFal :o


 
Nosferatu [50]
2012-05-16 00:14:21
[12 years, 193 days ago]

How about average played time per IP? :) Since, you know, I'm never on the same bot. :P


 
BFal [199]
2012-05-16 02:12:09
[12 years, 193 days ago]

its cuz I play from my phone and showroom from my pc... I think it counts it as twice-online... :D Still I'm good :D


 
neps [346]
<123>
2012-05-16 04:03:46
[12 years, 193 days ago]

HOW IS THIS POSSIBLE!

Damn you BFal!


 
Made2shred [87]
2012-05-16 04:11:16
[12 years, 193 days ago]

WHAT. THE. FUCK.


 
shoyuken [147]
2012-05-16 04:13:40
[12 years, 193 days ago]

time to quit team neps and hop on the falconder-train


 
BFal [199]
2012-05-16 04:42:20
[12 years, 193 days ago]

don't do that... I'm the unluckiest camper ever. :( 24h (14 of which camped) and no Cats Paw...


 
Gpof2 [130]
2012-10-05 08:04:48
[12 years, 51 days ago]

HOW IS THIS POSSIBLE!

We all know the answer now xD

How about average played time per IP? :) Since, you know, I'm never on the same bot. :P

^ Hopefully swapping the IP's with a name isn't too difficult cause I wanna see this. [/bump]


 
Count Duckula [230]
2013-02-06 06:11:50
[11 years, 292 days ago]

bump can we have an update ender?


 
Ender [1]
Administrator
2013-02-06 20:11:54
[11 years, 291 days ago]

I wish I'd saved the SQL for these before...

Most played time, without resets:

mysql> SELECT
    ->   @rank := @rank + 1 AS rank,
    ->   id,
    ->   expToLevel(exp) AS level,
    ->   username,
    ->   played / (60 * 60 * 24) AS days
    -> FROM bots
    -> JOIN (SELECT @rank := 0) r
    -> ORDER BY played DESC
    -> LIMIT 30;
+------+-------+-------+----------------------+----------+
| rank | id    | level | username             | days     |
+------+-------+-------+----------------------+----------+
|    1 |  3441 |   375 | neps                 | 235.7523 |
|    2 |   499 |   350 | Xerex                | 196.4862 |
|    3 |   142 |   344 | TheCause             | 173.6852 |
|    4 |  1542 |   318 | Eucliwood Hellscythe | 155.1763 |
|    5 |   937 |   167 | shoyuken             | 141.3999 |
|    6 |  5662 |   310 | Sinister Shadows     | 137.5742 |
|    7 |  3636 |   336 | Myriad               | 124.6221 |
|    8 |    40 |   241 | Satanus Inaximasus   | 101.2029 |
|    9 |  6185 |   197 | Jaziran              |  88.3714 |
|   10 | 12702 |   306 | Trio                 |  84.6674 |
|   11 |   653 |   157 | Tonc                 |  80.4853 |
|   12 |  1994 |   306 | Smeagol              |  74.4250 |
|   13 |  5760 |   258 | Shattered            |  62.6165 |
|   14 |  5759 |   258 | Hallucinogen         |  62.5378 |
|   15 |  6206 |   233 | small neps           |  62.2658 |
|   16 |  8962 |   306 | Zionic 2             |  59.1710 |
|   17 | 15386 |     1 | BFal                 |  56.4152 |
|   18 |   152 |    91 | Shoegazer            |  53.6355 |
|   19 |   498 |   188 | fredtrety            |  49.3808 |
|   20 |  5795 |   197 | ReneDescartes        |  40.2042 |
|   21 |  9932 |     1 | skumi5               |  38.1311 |
|   22 |    48 |    87 | Jans                 |  37.8341 |
|   23 |   896 |     1 | SaDa                 |  36.8208 |
|   24 | 15013 |   171 | mnor                 |  36.3441 |
|   25 |   199 |   177 | Ecoueses             |  36.2639 |
|   26 | 17987 |   284 | User Name            |  33.5452 |
|   27 |  4900 |   185 | Saiyan Z             |  33.0977 |
|   28 |  3621 |   163 | Mithrandon           |  32.9101 |
|   29 |  2875 |     1 | Smeagoltest          |  32.5894 |
|   30 |     1 |     1 | Ender                |  32.2692 |
+------+-------+-------+----------------------+----------+

Most played time, with resets:

mysql> SELECT
    ->   @rank := @rank + 1 AS rank,
    ->   foo.*
    -> FROM (
    ->   SELECT
    ->     id,
    ->     expToLevel(exp) AS level,
    ->     username,
    ->     (played + IFNULL(reset_played, 0)) / (60 * 60 * 24) AS days
    ->   FROM bots
    ->   LEFT JOIN (
    ->     SELECT bot_id, SUM(played) AS reset_played
    ->     FROM resets
    ->     GROUP BY bot_id
    ->     ) resets ON resets.bot_id = bots.id
    ->   ORDER BY days DESC
    ->   LIMIT 30) foo
    -> JOIN (SELECT @rank := 0) r;
+------+-------+-------+----------------------+----------+
| rank | id    | level | username             | days     |
+------+-------+-------+----------------------+----------+
|    1 |  3441 |   375 | neps                 | 235.7523 |
|    2 |   499 |   350 | Xerex                | 196.4862 |
|    3 |   142 |   344 | TheCause             | 173.6852 |
|    4 |  1542 |   318 | Eucliwood Hellscythe | 155.1739 |
|    5 |   937 |   167 | shoyuken             | 141.3989 |
|    6 |  5662 |   310 | Sinister Shadows     | 137.5742 |
|    7 |  3636 |   336 | Myriad               | 124.6221 |
|    8 |    40 |   241 | Satanus Inaximasus   | 101.2029 |
|    9 | 12702 |   306 | Trio                 |  91.0689 |
|   10 |  6185 |   197 | Jaziran              |  88.3714 |
|   11 |   653 |   157 | Tonc                 |  80.4853 |
|   12 |  1994 |   306 | Smeagol              |  74.4250 |
|   13 |  5760 |   258 | Shattered            |  62.6165 |
|   14 |  5759 |   258 | Hallucinogen         |  62.5378 |
|   15 |  6206 |   233 | small neps           |  62.2658 |
|   16 |   152 |    91 | Shoegazer            |  60.3398 |
|   17 |  8962 |   306 | Zionic 2             |  59.1710 |
|   18 | 15386 |     1 | BFal                 |  56.4152 |
|   19 |   190 |   200 | Draoi                |  51.2837 |
|   20 |   498 |   188 | fredtrety            |  49.3808 |
|   21 |  6204 |   209 | Kudos                |  44.8135 |
|   22 |  5795 |   197 | ReneDescartes        |  40.2042 |
|   23 |  9932 |     1 | skumi5               |  38.1311 |
|   24 |    48 |    87 | Jans                 |  37.8341 |
|   25 |   896 |     1 | SaDa                 |  36.8208 |
|   26 | 15013 |   171 | mnor                 |  36.3441 |
|   27 |    25 |     1 | Alan                 |  36.2942 |
|   28 |   199 |   177 | Ecoueses             |  36.2639 |
|   29 |   886 |    50 | Jabroni              |  35.2593 |
|   30 | 17987 |   284 | User Name            |  33.5452 |
+------+-------+-------+----------------------+----------+

Most played time per day, with resets, for bots built 30 days or more ago:

Note: For the handful of alpha bots created before December 22, 2010 (the day played time started being tracked) that have not been reset, these hours per day values are different than what's shown in your profile. Profile pages correctly use a minimum effective bot build date of December 22, 2010, but these ad hoc queries do not. This means that for these bots, the hours per day will be lower here than in their profile.

mysql> SELECT
    ->   @rank := @rank + 1 AS rank,
    ->   foo.*,
    ->   days_played / days_alive * 24 AS hours_per_day
    -> FROM (
    ->   SELECT
    ->     id,
    ->     expToLevel(exp) AS level,
    ->     username,
    ->     (played + IFNULL(reset_played, 0)) / (60 * 60 * 24) AS days_played,
    ->     DATEDIFF(NOW(), signup) AS days_alive
    ->   FROM bots
    ->   LEFT JOIN (
    ->     SELECT bot_id, SUM(played) AS reset_played
    ->     FROM resets
    ->     GROUP BY bot_id
    ->     ) resets ON resets.bot_id = bots.id
    ->   WHERE DATEDIFF(NOW(), signup) >= 30
    ->   ORDER BY days_played / days_alive DESC
    ->   LIMIT 30) foo
    -> JOIN (SELECT @rank := 0) r;
+------+-------+-------+----------------------+-------------+------------+---------------+
| rank | id    | level | username             | days_played | days_alive | hours_per_day |
+------+-------+-------+----------------------+-------------+------------+---------------+
|    1 |  3441 |   375 | neps                 |    235.7523 |        660 |    8.57281090 |
|    2 |   499 |   350 | Xerex                |    196.4862 |        701 |    6.72705962 |
|    3 |  5662 |   310 | Sinister Shadows     |    137.5742 |        590 |    5.59623864 |
|    4 |  1542 |   318 | Eucliwood Hellscythe |    155.1739 |        692 |    5.38175374 |
|    5 |   142 |   344 | TheCause             |    173.6852 |        779 |    5.35102027 |
|    6 | 26936 |   140 | Cosby                |      6.8477 |         31 |    5.30144515 |
|    7 | 12702 |   306 | Trio                 |     91.0689 |        441 |    4.95613061 |
|    8 |   937 |   167 | shoyuken             |    141.3977 |        697 |    4.86878736 |
|    9 |  3636 |   336 | Myriad               |    124.6221 |        655 |    4.56630595 |
|   10 |  6185 |   197 | Jaziran              |     88.3714 |        581 |    3.65045369 |
|   11 | 15386 |     1 | BFal                 |     56.4152 |        372 |    3.63969031 |
|   12 | 26782 |    46 | George               |      4.2101 |         35 |    2.88692570 |
|   13 |    40 |   241 | Satanus Inaximasus   |    101.2029 |        860 |    2.82426696 |
|   14 |   653 |   157 | Tonc                 |     80.4853 |        700 |    2.75949600 |
|   15 |  8962 |   306 | Zionic 2             |     59.1710 |        519 |    2.73623119 |
|   16 | 25656 |   230 | Count Duckula        |      8.6503 |         78 |    2.66163077 |
|   17 |  1994 |   306 | Smeagol              |     74.4250 |        686 |    2.60379007 |
|   18 |  6206 |   233 | small neps           |     62.2658 |        580 |    2.57651585 |
|   19 |  5760 |   258 | Shattered            |     62.6165 |        587 |    2.56012946 |
|   20 |  5759 |   258 | Hallucinogen         |     62.5378 |        587 |    2.55691174 |
|   21 | 17987 |   284 | User Name            |     33.5452 |        328 |    2.45452682 |
|   22 | 15013 |   171 | mnor                 |     36.3441 |        382 |    2.28339895 |
|   23 | 25788 |   121 | MrCoathanger         |      6.7704 |         73 |    2.22588492 |
|   24 | 25741 |    67 | 8lukes               |      5.8284 |         75 |    1.86508800 |
|   25 |   152 |    91 | Shoegazer            |     60.3386 |        778 |    1.86134498 |
|   26 |  6204 |   209 | Kudos                |     44.8135 |        581 |    1.85116006 |
|   27 |  9932 |     1 | skumi5               |     38.1311 |        499 |    1.83396072 |
|   28 | 13681 |   134 | Esvrainzas           |     31.5826 |        419 |    1.80902719 |
|   29 | 25498 |    65 | wimpykid01           |      6.1546 |         83 |    1.77964337 |
|   30 | 22372 |   100 | Cr03                 |     14.8169 |        203 |    1.75175172 |
+------+-------+-------+----------------------+-------------+------------+---------------+

(You're welcome, future Ender, for including the SQL now. I know exposing table structure can sometimes be considered a security risk because it can aid injection, but prepared statements are used pretty much everywhere.)

Let me know if any of these numbers look off. As you can tell, it's not an easy stat to pull.


 
Number Two [93]
2013-02-06 20:31:37
[11 years, 291 days ago]

asking the obvious...Bfal is lvl 1 but hasnt been reset.

ac?


 
shoyuken [167]
2013-02-06 20:33:20
[11 years, 291 days ago]

http://bots4.net/forum/7/4190


 
Cosby [140]
2013-02-06 22:01:03
[11 years, 291 days ago]

Can I get a Booh Yah?!!!!


 
Leader2 [136]
2013-02-07 02:18:10
[11 years, 291 days ago]

you certainly can mate well done :)


 
shoyuken [175]
2013-05-25 16:10:04
[11 years, 184 days ago]

With the addition of bots being associated by email, would it be possible to see a table with the top email accounts for hours played? I do realize that it's probably not a good idea to release everyone's emails, so instead of displaying the actual email replace it with the email's most active bot.


 
Ender [1]
Administrator
2013-05-26 15:26:29
[11 years, 183 days ago]

That would certainly be possible, but I am in far too lazy a mood to come up with the rather insane SQL statement required to produce that answer. :)


 
Connecter2 [58]
2013-09-24 23:27:05
[11 years, 61 days ago]

Bump


 
Ender [1]
Administrator
2013-09-27 01:32:22
[11 years, 59 days ago]

Thank you, past Ender. Also, ignore sirop5 in these results. It's a bug, not foul play.

Most played time, without resets:

mysql> SELECT
    ->   @rank := @rank + 1 AS rank,
    ->   id,
    ->   expToLevel(exp) AS level,
    ->   username,
    ->   played / (60 * 60 * 24) AS days
    -> FROM bots
    -> JOIN (SELECT @rank := 0) r
    -> ORDER BY played DESC
    -> LIMIT 30;
+------+-------+-------+----------------------+------------+
| rank | id    | level | username             | days       |
+------+-------+-------+----------------------+------------+
|    1 | 31913 |    43 | sirop5               | 49710.2696 |
|    2 |   499 |   368 | Xerex                |   262.7473 |
|    3 |  1542 |   348 | Eucliwood Hellscythe |   241.9614 |
|    4 |  3441 |   375 | neps                 |   237.1447 |
|    5 |   142 |   364 | TheCause             |   214.7367 |
|    6 |   937 |   175 | shoyuken             |   194.0699 |
|    7 |  5662 |   320 | Sinister Shadows     |   155.2105 |
|    8 |  3636 |   347 | Myriad               |   148.3485 |
|    9 |    40 |   269 | Satanus Inaximasus   |   124.1554 |
|   10 | 12702 |   335 | Trio                 |   114.2200 |
|   11 |  6185 |   223 | Jaziran              |   112.1624 |
|   12 |   152 |    98 | Shoegazer            |    87.3758 |
|   13 |   653 |   160 | Tonc                 |    83.4134 |
|   14 |   174 |   316 | Lyrad                |    77.8140 |
|   15 | 17987 |   321 | User Name            |    77.2143 |
|   16 |  1994 |   306 | Smeagol              |    74.4549 |
|   17 |  6206 |   253 | small neps           |    71.3441 |
|   18 |  5760 |   259 | Shattered            |    64.4158 |
|   19 |  5759 |   259 | Hallucinogen         |    64.3966 |
|   20 |  8962 |   307 | Zionic 2             |    59.8831 |
|   21 | 15386 |     1 | BFal                 |    56.4152 |
|   22 | 15013 |   203 | mnor                 |    56.0487 |
|   23 |    48 |    87 | Jans                 |    53.8492 |
|   24 |  1428 |   229 | ActiveX              |    52.8944 |
|   25 |   498 |   188 | fredtrety            |    49.3808 |
|   26 |  7028 |    73 | Tomato               |    45.4386 |
|   27 |  5795 |   219 | ReneDescartes        |    44.4572 |
|   28 |  9932 |     1 | skumi5               |    38.1311 |
|   29 |   896 |     1 | SaDa                 |    36.8208 |
|   30 |   199 |   177 | Ecoueses             |    36.4432 |
+------+-------+-------+----------------------+------------+

Most played time, with resets:

mysql> SELECT
    ->   @rank := @rank + 1 AS rank,
    ->   foo.*
    -> FROM (
    ->   SELECT
    ->     id,
    ->     expToLevel(exp) AS level,
    ->     username,
    ->     (played + IFNULL(reset_played, 0)) / (60 * 60 * 24) AS days
    ->   FROM bots
    ->   LEFT JOIN (
    ->     SELECT bot_id, SUM(played) AS reset_played
    ->     FROM resets
    ->     GROUP BY bot_id
    ->     ) resets ON resets.bot_id = bots.id
    ->   ORDER BY days DESC
    ->   LIMIT 30) foo
    -> JOIN (SELECT @rank := 0) r;
+------+-------+-------+----------------------+------------+
| rank | id    | level | username             | days       |
+------+-------+-------+----------------------+------------+
|    1 | 31913 |    43 | sirop5               | 49710.2696 |
|    2 |   499 |   368 | Xerex                |   262.7473 |
|    3 |  1542 |   348 | Eucliwood Hellscythe |   241.9614 |
|    4 |  3441 |   375 | neps                 |   237.1447 |
|    5 |   142 |   364 | TheCause             |   214.7367 |
|    6 |   937 |   175 | shoyuken             |   194.0699 |
|    7 |  5662 |   320 | Sinister Shadows     |   155.2105 |
|    8 |  3636 |   347 | Myriad               |   148.3485 |
|    9 |    40 |   269 | Satanus Inaximasus   |   124.1554 |
|   10 | 12702 |   335 | Trio                 |   120.6214 |
|   11 |  6185 |   223 | Jaziran              |   112.1624 |
|   12 |   152 |    98 | Shoegazer            |    94.0810 |
|   13 |   174 |   316 | Lyrad                |    86.9730 |
|   14 |   653 |   160 | Tonc                 |    83.4134 |
|   15 | 17987 |   321 | User Name            |    77.2143 |
|   16 |  1994 |   306 | Smeagol              |    74.4549 |
|   17 |  6206 |   253 | small neps           |    71.3441 |
|   18 |  5760 |   259 | Shattered            |    64.4158 |
|   19 |  5759 |   259 | Hallucinogen         |    64.3966 |
|   20 |  8962 |   307 | Zionic 2             |    59.8831 |
|   21 | 15386 |     1 | BFal                 |    56.4152 |
|   22 | 15013 |   203 | mnor                 |    56.0487 |
|   23 |    48 |    87 | Jans                 |    53.8492 |
|   24 |  1428 |   229 | ActiveX              |    52.8944 |
|   25 |   190 |   200 | Draoi                |    51.3802 |
|   26 |   498 |   188 | fredtrety            |    49.3808 |
|   27 |  7028 |    73 | Tomato               |    45.4386 |
|   28 |  6204 |   209 | Kudos                |    44.8401 |
|   29 |  5795 |   219 | ReneDescartes        |    44.4572 |
|   30 |   886 |    69 | Jabroni              |    40.2623 |
+------+-------+-------+----------------------+------------+

Most played time per day, with resets, for bots built 30 days or more ago:

Note: For the handful of alpha bots created before December 22, 2010 (the day played time started being tracked) that have not been reset, these hours per day values are different than what's shown in your profile. Profile pages correctly use a minimum effective bot build date of December 22, 2010, but these ad hoc queries do not. This means that for these bots, the hours per day will be lower here than in their profile.

mysql> SELECT
    ->   @rank := @rank + 1 AS rank,
    ->   foo.*,
    ->   days_played / days_alive * 24 AS hours_per_day
    -> FROM (
    ->   SELECT
    ->     id,
    ->     expToLevel(exp) AS level,
    ->     username,
    ->     (played + IFNULL(reset_played, 0)) / (60 * 60 * 24) AS days_played,
    ->     DATEDIFF(NOW(), signup) AS days_alive
    ->   FROM bots
    ->   LEFT JOIN (
    ->     SELECT bot_id, SUM(played) AS reset_played
    ->     FROM resets
    ->     GROUP BY bot_id
    ->     ) resets ON resets.bot_id = bots.id
    ->   WHERE DATEDIFF(NOW(), signup) >= 30
    ->   ORDER BY days_played / days_alive DESC
    ->   LIMIT 30) foo
    -> JOIN (SELECT @rank := 0) r;
+------+-------+-------+----------------------+-------------+------------+----------------+
| rank | id    | level | username             | days_played | days_alive | hours_per_day  |
+------+-------+-------+----------------------+-------------+------------+----------------+
|    1 | 31913 |    43 | sirop5               |  49710.2696 |         73 | 16343.10233424 |
|    2 |   499 |   368 | Xerex                |    262.7473 |        934 |     6.75153660 |
|    3 |  3441 |   375 | neps                 |    237.1447 |        893 |     6.37342978 |
|    4 |  1542 |   348 | Eucliwood Hellscythe |    241.9614 |        925 |     6.27791738 |
|    5 |   142 |   364 | TheCause             |    214.7367 |       1012 |     5.09256996 |
|    6 |   937 |   175 | shoyuken             |    194.0699 |        930 |     5.00825546 |
|    7 |  5662 |   320 | Sinister Shadows     |    155.2105 |        823 |     4.52618712 |
|    8 | 12702 |   335 | Trio                 |    120.6214 |        674 |     4.29512402 |
|    9 |  3636 |   347 | Myriad               |    148.3485 |        888 |     4.00941890 |
|   10 | 30090 |   247 | Port Royal           |     20.8746 |        137 |     3.65686423 |
|   11 |  6185 |   223 | Jaziran              |    112.1624 |        814 |     3.30699950 |
|   12 | 17987 |   321 | User Name            |     77.2143 |        561 |     3.30328555 |
|   13 | 31697 |   100 | Default User         |     10.0867 |         82 |     2.95220486 |
|   14 |    40 |   269 | Satanus Inaximasus   |    124.1554 |       1093 |     2.72619358 |
|   15 | 29394 |   188 | Fake One             |     18.6614 |        170 |     2.63455058 |
|   16 | 33672 |    69 | xj17                 |      3.6668 |         36 |     2.44453332 |
|   17 | 33381 |    52 | LetsCrush Alan       |      4.3150 |         43 |     2.40837209 |
|   18 | 32070 |    51 | Barricade            |      6.2873 |         67 |     2.25216715 |
|   19 | 15386 |     1 | BFal                 |     56.4152 |        605 |     2.23795834 |
|   20 |   152 |    98 | Shoegazer            |     94.0810 |       1011 |     2.23337683 |
|   21 | 15013 |   203 | mnor                 |     56.0487 |        615 |     2.18726633 |
|   22 | 30782 |   132 | Anarchy Reigns       |      9.7032 |        108 |     2.15626666 |
|   23 |   653 |   160 | Tonc                 |     83.4134 |        933 |     2.14568230 |
|   24 |  6206 |   253 | small neps           |     71.3441 |        813 |     2.10609888 |
|   25 |   174 |   316 | Lyrad                |     86.9730 |       1000 |     2.08735200 |
|   26 | 29403 |   129 | MikeiiiBoy           |     14.3636 |        170 |     2.02780234 |
|   27 |  1994 |   306 | Smeagol              |     74.4549 |        919 |     1.94441522 |
|   28 | 27695 |   129 | Lobster              |     18.6333 |        233 |     1.91930986 |
|   29 |  8962 |   307 | Zionic 2             |     59.8831 |        752 |     1.91116274 |
|   30 |  5760 |   259 | Shattered            |     64.4158 |        820 |     1.88534047 |
+------+-------+-------+----------------------+-------------+------------+----------------+

 
New Alan [130]
2013-09-27 08:41:18
[11 years, 59 days ago]

What kind of bug for sirop5?


 
Pathomechanics [185]
2013-09-27 08:42:37
[11 years, 59 days ago]

http://bots4.net/profile/31913/sirop5

1year+ played in one day, epic haha


 
TheCause [364]
2013-09-27 08:43:18
[11 years, 59 days ago]

:) i added it to its profile as well :)


 
Ender [1]
Administrator
2013-10-07 22:03:32
[11 years, 48 days ago]

What kind of bug for sirop5?

log2(49710.2696 * 24 * 3600) ~= 32

Some integer under/overflow weirdness probably. I haven't dug into it.


 
New Alan [130]
2013-10-07 23:47:21
[11 years, 48 days ago]

But I don't understand where the days played come from :P

Even if the 32bit is part of it.


 
Ender [1]
Administrator
2013-10-08 19:34:30
[11 years, 47 days ago]

I don't understand your question.


 
olli [255]
2014-12-05 12:59:20
[9 years, 355 days ago]

I like that statistics. Maybe some update would be great?


 
Satanus Inaximasus [300]
2014-12-06 05:20:05
[9 years, 354 days ago]

i would like to see this too but

Status: offline [last seen 24 days ago]

seems like he as died yet again


 
TheCause [376]
2014-12-06 05:45:51
[9 years, 354 days ago]

i like it too, because ill prolly win, btw the sirop5 thing is still not fixed, still my bot though


 
Satanus Inaximasus [300]
2014-12-06 06:45:33
[9 years, 354 days ago]

nope you wont

Xerex - Played time: 304 days, 3 hours, 48 minutes, 35 seconds

Thecause - Played time: 256 days, 8 hours, 6 minutes, 40 seconds

nowhere near mate


 
Nosferatu [270]
2014-12-09 01:27:45
[9 years, 351 days ago]

shoyuken - Played time: 268 days, 13 hours, 56 minutes, 54 seconds

Also has you beat.


 
TheCause [376]
2014-12-09 12:09:08
[9 years, 351 days ago]

lol didnt pay that much attention i suppose :)


 
hater [77]
2014-12-09 16:12:03
[9 years, 351 days ago]

Played time is cool but look at hours per day. Its nice statistics too.


 
Ender [1]
Administrator
2014-12-11 00:49:37
[9 years, 349 days ago]

Most played time, without resets:

mysql> SELECT
    ->   @rank := @rank + 1 AS rank,
    ->   id,
    ->   expToLevel(exp) AS level,
    ->   username,
    ->   played / (60 * 60 * 24) AS days
    -> FROM bots
    -> JOIN (SELECT @rank := 0) r
    -> ORDER BY played DESC
    -> LIMIT 30;
+------+-------+-------+----------------------+------------+
| rank | id    | level | username             | days       |
+------+-------+-------+----------------------+------------+
|    1 | 31913 |    47 | sirop5               | 49710.2696 |
|    2 |   499 |   379 | Xerex                |   304.1592 |
|    3 |  1542 |   353 | Eucliwood Hellscythe |   279.7631 |
|    4 |   937 |   175 | shoyuken             |   268.5812 |
|    5 |   142 |   376 | TheCause             |   256.8277 |
|    6 |  3441 |   375 | neps                 |   239.4025 |
|    7 |   174 |   366 | Lyrad                |   211.0826 |
|    8 |  5662 |   333 | Sinister Shadows     |   184.4834 |
|    9 |    40 |   301 | Satanus Inaximasus   |   181.0120 |
|   10 |  3636 |   349 | Myriad               |   151.1600 |
|   11 | 12702 |   359 | Trio                 |   147.9409 |
|   12 | 17987 |   350 | User Name            |   128.6368 |
|   13 |   152 |   102 | Shoegazer            |   125.7278 |
|   14 |  6185 |   223 | Jaziran              |   112.3312 |
|   15 |   653 |   160 | Tonc                 |    83.4756 |
|   16 |  6206 |   270 | small neps           |    82.3778 |
|   17 | 15013 |   231 | mnor                 |    81.9244 |
|   18 |  1428 |   261 | ActiveX              |    75.0978 |
|   19 |  5760 |   259 | Shattered            |    65.4083 |
|   20 |  5759 |   259 | Hallucinogen         |    65.3767 |
|   21 |    48 |    87 | Jans                 |    61.2300 |
|   22 |  7028 |    75 | Tomato               |    58.0194 |
|   23 |    58 |   271 | Nosferatu            |    57.8229 |
|   24 | 15386 |     1 | BFal                 |    56.4152 |
|   25 |   498 |   188 | fredtrety            |    49.3808 |
|   26 |  5795 |   220 | ReneDescartes        |    46.8500 |
|   27 |   199 |   198 | Ecoueses             |    46.4111 |
|   28 |  3621 |   178 | Mithrandon           |    40.0598 |
|   29 |  3888 |   209 | Aaronn               |    39.2371 |
|   30 |     1 |     1 | Ender                |    38.5478 |
+------+-------+-------+----------------------+------------+

Most played time, with resets:

mysql> SELECT
    ->   @rank := @rank + 1 AS rank,
    ->   foo.*
    -> FROM (
    ->   SELECT
    ->     id,
    ->     expToLevel(exp) AS level,
    ->     username,
    ->     (played + IFNULL(reset_played, 0)) / (60 * 60 * 24) AS days
    ->   FROM bots
    ->   LEFT JOIN (
    ->     SELECT bot_id, SUM(played) AS reset_played
    ->     FROM resets
    ->     GROUP BY bot_id
    ->     ) resets ON resets.bot_id = bots.id
    ->   ORDER BY days DESC
    ->   LIMIT 30) foo
    -> JOIN (SELECT @rank := 0) r;
+------+-------+-------+----------------------+------------+
| rank | id    | level | username             | days       |
+------+-------+-------+----------------------+------------+
|    1 | 31913 |    47 | sirop5               | 49710.2696 |
|    2 |   499 |   379 | Xerex                |   304.1592 |
|    3 |  1542 |   353 | Eucliwood Hellscythe |   279.7635 |
|    4 |   937 |   175 | shoyuken             |   268.5812 |
|    5 |   142 |   376 | TheCause             |   256.8277 |
|    6 |  3441 |   375 | neps                 |   239.4025 |
|    7 |   174 |   366 | Lyrad                |   220.2416 |
|    8 |  5662 |   333 | Sinister Shadows     |   184.4834 |
|    9 |    40 |   301 | Satanus Inaximasus   |   181.0120 |
|   10 | 12702 |   359 | Trio                 |   154.3423 |
|   11 |  3636 |   349 | Myriad               |   151.1600 |
|   12 |   152 |   102 | Shoegazer            |   132.4330 |
|   13 | 17987 |   350 | User Name            |   128.6368 |
|   14 |  6185 |   223 | Jaziran              |   112.3312 |
|   15 |   653 |   160 | Tonc                 |    83.4756 |
|   16 |  6206 |   270 | small neps           |    82.3778 |
|   17 | 15013 |   231 | mnor                 |    81.9244 |
|   18 |  1994 |   118 | Smeagol              |    76.1369 |
|   19 |  1428 |   261 | ActiveX              |    75.0978 |
|   20 |  5760 |   259 | Shattered            |    65.4083 |
|   21 |  5759 |   259 | Hallucinogen         |    65.3767 |
|   22 |    58 |   271 | Nosferatu            |    63.9663 |
|   23 |    48 |    87 | Jans                 |    61.2300 |
|   24 |  8962 |   167 | Zionic 2             |    60.6972 |
|   25 |  7028 |    75 | Tomato               |    58.0194 |
|   26 | 15386 |     1 | BFal                 |    56.4152 |
|   27 | 13681 |   134 | Esvrainzas           |    52.2015 |
|   28 |   190 |   200 | Draoi                |    51.4861 |
|   29 |   498 |   188 | fredtrety            |    49.3808 |
|   30 |  5795 |   220 | ReneDescartes        |    46.8500 |
+------+-------+-------+----------------------+------------+

Most played time per day, with resets, for bots built 30 days or more ago:

Note: For the handful of alpha bots created before December 22, 2010 (the day played time started being tracked) that have not been reset, these hours per day values are different than what's shown in your profile. Profile pages correctly use a minimum effective bot build date of December 22, 2010, but these ad hoc queries do not. This means that for these bots, the hours per day will be lower here than in their profile.

mysql> SELECT
    ->   @rank := @rank + 1 AS rank,
    ->   foo.*,
    ->   days_played / days_alive * 24 AS hours_per_day
    -> FROM (
    ->   SELECT
    ->     id,
    ->     expToLevel(exp) AS level,
    ->     username,
    ->     (played + IFNULL(reset_played, 0)) / (60 * 60 * 24) AS days_played,
    ->     DATEDIFF(NOW(), signup) AS days_alive
    ->   FROM bots
    ->   LEFT JOIN (
    ->     SELECT bot_id, SUM(played) AS reset_played
    ->     FROM resets
    ->     GROUP BY bot_id
    ->     ) resets ON resets.bot_id = bots.id
    ->   WHERE DATEDIFF(NOW(), signup) >= 30
    ->   ORDER BY days_played / days_alive DESC
    ->   LIMIT 30) foo
    -> JOIN (SELECT @rank := 0) r;
+------+-------+-------+----------------------+-------------+------------+---------------+
| rank | id    | level | username             | days_played | days_alive | hours_per_day |
+------+-------+-------+----------------------+-------------+------------+---------------+
|    1 | 31913 |    47 | sirop5               |  49710.2696 |        513 | 2325.62664794 |
|    2 |   499 |   379 | Xerex                |    304.1592 |       1374 |    5.31282444 |
|    3 | 44915 |   196 | ChickenBites         |     24.1250 |        114 |    5.07894737 |
|    4 |  1542 |   353 | Eucliwood Hellscythe |    279.7643 |       1365 |    4.91893274 |
|    5 |   937 |   175 | shoyuken             |    268.5812 |       1370 |    4.70507210 |
|    6 |  3441 |   375 | neps                 |    239.4025 |       1333 |    4.31032258 |
|    7 |   142 |   376 | TheCause             |    256.8277 |       1452 |    4.24508594 |
|    8 |   174 |   366 | Lyrad                |    220.2416 |       1440 |    3.67069332 |
|    9 |  5662 |   333 | Sinister Shadows     |    184.4834 |       1263 |    3.50562278 |
|   10 | 12702 |   359 | Trio                 |    154.3423 |       1114 |    3.32514828 |
|   11 | 44790 |   100 | Pothead              |     15.9007 |        122 |    3.12800654 |
|   12 | 17987 |   350 | User Name            |    128.6368 |       1001 |    3.08419898 |
|   13 |    40 |   301 | Satanus Inaximasus   |    181.0120 |       1533 |    2.83384735 |
|   14 |  3636 |   349 | Myriad               |    151.1600 |       1328 |    2.73180722 |
|   15 | 45803 |   129 | tristostar           |      4.5422 |         40 |    2.72532000 |
|   16 | 45553 |   101 | wownousername        |      5.7419 |         58 |    2.37595860 |
|   17 |   152 |   102 | Shoegazer            |    132.4330 |       1451 |    2.19048379 |
|   18 | 36054 |   256 | olli                 |     34.4437 |        379 |    2.18113138 |
|   19 |  6185 |   223 | Jaziran              |    112.3312 |       1254 |    2.14987942 |
|   20 | 45547 |    31 | Sirpaul0             |      4.5149 |         58 |    1.86823447 |
|   21 | 15013 |   231 | mnor                 |     81.9244 |       1055 |    1.86368302 |
|   22 | 37603 |    47 | The Apex Scorer      |     23.4126 |        306 |    1.83628234 |
|   23 | 42571 |   200 | With Many Whores     |     19.6167 |        258 |    1.82480928 |
|   24 | 37018 |    77 | hater                |     25.4407 |        335 |    1.82261731 |
|   25 |  6206 |   270 | small neps           |     82.3778 |       1253 |    1.57786687 |
|   26 | 44848 |   132 | Hawker               |      7.4103 |        118 |    1.50717965 |
|   27 |   653 |   160 | Tonc                 |     83.4756 |       1373 |    1.45915104 |
|   28 | 45597 |   101 | Inheritance          |      3.3188 |         56 |    1.42234284 |
|   29 |  1994 |   118 | Smeagol              |     76.1369 |       1359 |    1.34458099 |
|   30 | 45907 |    56 | shoannn              |      1.9447 |         35 |    1.33350857 |
+------+-------+-------+----------------------+-------------+------------+---------------+

 
Satanus Inaximasus [301]
2014-12-12 16:28:43
[9 years, 348 days ago]

Trophy points for this i think

dedication to the game lol


 
Satanus Inaximasus [306]
2015-02-04 15:03:36
[9 years, 294 days ago]

ender can we have an update on this please?


 
Ender [1]
Administrator
2015-02-04 22:39:41
[9 years, 293 days ago]

I did the last update 55 days ago. It's a little tedious to copy the queries and do the formatting, so ask again once at least 90 days have passed. :)


 
shoyuken [175]
2016-04-17 13:16:58
[8 years, 221 days ago]

it's been a while since we've had an update


 
Ender [1]
Administrator
2016-04-18 18:59:57
[8 years, 220 days ago]

Most played time, without resets:

mysql> SELECT
    ->   @rank := @rank + 1 AS rank,
    ->   id,
    ->   expToLevel(exp) AS level,
    ->   username,
    ->   played / (60 * 60 * 24) AS days
    -> FROM bots
    -> JOIN (SELECT @rank := 0) r
    -> ORDER BY played DESC
    -> LIMIT 30;
+------+-------+-------+----------------------+------------+
| rank | id    | level | username             | days       |
+------+-------+-------+----------------------+------------+
|    1 | 31913 |    47 | sirop5               | 49710.2696 |
|    2 |   499 |   394 | Xerex                |   390.7516 |
|    3 |   142 |   390 | TheCause             |   328.1883 |
|    4 |   937 |   175 | shoyuken             |   326.9022 |
|    5 |   174 |   389 | Lyrad                |   324.5577 |
|    6 |  1542 |   361 | Eucliwood Hellscythe |   314.7472 |
|    7 |    40 |   330 | Satanus Inaximasus   |   274.6212 |
|    8 |  5662 |   356 | Sinister Shadows     |   266.5803 |
|    9 |  3441 |   376 | neps                 |   240.3413 |
|   10 |  3636 |   366 | Myriad               |   184.5378 |
|   11 | 12702 |   365 | Trio                 |   161.7213 |
|   12 |   152 |   103 | Shoegazer            |   138.5089 |
|   13 | 17987 |   350 | User Name            |   129.5955 |
|   14 |  6185 |   229 | Jaziran              |   114.2584 |
|   15 |   653 |   210 | Tonc                 |   112.2297 |
|   16 |  1428 |   280 | ActiveX              |    95.5249 |
|   17 | 15013 |   240 | mnor                 |    91.8842 |
|   18 |   199 |   286 | Ecoueses             |    86.7159 |
|   19 |  6206 |   270 | small neps           |    83.0717 |
|   20 |    58 |   280 | Nosferatu            |    82.1856 |
|   21 | 37018 |    83 | hater                |    75.9463 |
|   22 |  7028 |    78 | Tomato               |    74.3200 |
|   23 |    77 |   134 | Fishwick             |    68.8613 |
|   24 |    48 |    90 | Jans                 |    68.3905 |
|   25 |  5760 |   272 | Shattered            |    66.3566 |
|   26 |  5759 |   273 | Hallucinogen         |    66.2600 |
|   27 | 13681 |   134 | Esvrainzas           |    61.3477 |
|   28 | 37017 |   329 | jezz                 |    59.8558 |
|   29 | 15386 |     1 | BFal                 |    56.4152 |
|   30 | 20731 |    49 | hope10               |    56.3090 |
+------+-------+-------+----------------------+------------+

Most played time, with resets:

mysql> SELECT
    ->   @rank := @rank + 1 AS rank,
    ->   foo.*
    -> FROM (
    ->   SELECT
    ->     id,
    ->     expToLevel(exp) AS level,
    ->     username,
    ->     (played + IFNULL(reset_played, 0)) / (60 * 60 * 24) AS days
    ->   FROM bots
    ->   LEFT JOIN (
    ->     SELECT bot_id, SUM(played) AS reset_played
    ->     FROM resets
    ->     GROUP BY bot_id
    ->     ) resets ON resets.bot_id = bots.id
    ->   ORDER BY days DESC
    ->   LIMIT 30) foo
    -> JOIN (SELECT @rank := 0) r;
+------+-------+-------+----------------------+------------+
| rank | id    | level | username             | days       |
+------+-------+-------+----------------------+------------+
|    1 | 31913 |    47 | sirop5               | 49710.2696 |
|    2 |   499 |   394 | Xerex                |   390.7516 |
|    3 |   174 |   389 | Lyrad                |   333.7167 |
|    4 |   142 |   390 | TheCause             |   328.1883 |
|    5 |   937 |   175 | shoyuken             |   326.9027 |
|    6 |  1542 |   361 | Eucliwood Hellscythe |   314.7472 |
|    7 |    40 |   330 | Satanus Inaximasus   |   274.6212 |
|    8 |  5662 |   356 | Sinister Shadows     |   266.5803 |
|    9 |  3441 |   376 | neps                 |   240.3413 |
|   10 |  3636 |   366 | Myriad               |   184.5378 |
|   11 | 12702 |   365 | Trio                 |   168.1228 |
|   12 |   152 |   103 | Shoegazer            |   145.2142 |
|   13 | 17987 |   350 | User Name            |   129.5955 |
|   14 |  6185 |   229 | Jaziran              |   114.2584 |
|   15 |   653 |   210 | Tonc                 |   112.2297 |
|   16 |  1428 |   280 | ActiveX              |    95.5249 |
|   17 | 15013 |   240 | mnor                 |    91.8842 |
|   18 |    58 |   280 | Nosferatu            |    88.3281 |
|   19 |   199 |   286 | Ecoueses             |    86.7159 |
|   20 | 13681 |   134 | Esvrainzas           |    83.5466 |
|   21 |  6206 |   270 | small neps           |    83.0717 |
|   22 |  1994 |   121 | Smeagol              |    76.2087 |
|   23 | 37018 |    83 | hater                |    75.9463 |
|   24 |  7028 |    78 | Tomato               |    74.3200 |
|   25 |    77 |   134 | Fishwick             |    68.8613 |
|   26 |    48 |    90 | Jans                 |    68.3905 |
|   27 |  5760 |   272 | Shattered            |    66.3566 |
|   28 | 37017 |   329 | jezz                 |    66.3101 |
|   29 |  5759 |   273 | Hallucinogen         |    66.2600 |
|   30 |  8962 |   170 | Zionic 2             |    60.7530 |
+------+-------+-------+----------------------+------------+

Most played time per day, with resets, for bots built 30 days or more ago:

Note: For the handful of alpha bots created before December 22, 2010 (the day played time started being tracked) that have not been reset, these hours per day values are different than what's shown in your profile. Profile pages correctly use a minimum effective bot build date of December 22, 2010, but these ad hoc queries do not. This means that for these bots, the hours per day will be lower here than in their profile.

mysql> SELECT
    ->   @rank := @rank + 1 AS rank,
    ->   foo.*,
    ->   days_played / days_alive * 24 AS hours_per_day
    -> FROM (
    ->   SELECT
    ->     id,
    ->     expToLevel(exp) AS level,
    ->     username,
    ->     (played + IFNULL(reset_played, 0)) / (60 * 60 * 24) AS days_played,
    ->     DATEDIFF(NOW(), signup) AS days_alive
    ->   FROM bots
    ->   LEFT JOIN (
    ->     SELECT bot_id, SUM(played) AS reset_played
    ->     FROM resets
    ->     GROUP BY bot_id
    ->     ) resets ON resets.bot_id = bots.id
    ->   WHERE DATEDIFF(NOW(), signup) >= 30
    ->   ORDER BY days_played / days_alive DESC
    ->   LIMIT 30) foo
    -> JOIN (SELECT @rank := 0) r;
+------+-------+-------+----------------------+-------------+------------+---------------+
| rank | id    | level | username             | days_played | days_alive | hours_per_day |
+------+-------+-------+----------------------+-------------+------------+---------------+
|    1 | 31913 |    47 | sirop5               |  49710.2696 |       1007 | 1184.75319799 |
|    2 | 51279 |   228 | sada1337             |     45.0276 |         87 |   12.42140688 |
|    3 | 50437 |   254 | correlation          |     45.2123 |        207 |    5.24200579 |
|    4 |   499 |   394 | Xerex                |    390.7516 |       1868 |    5.02036315 |
|    5 |   937 |   175 | shoyuken             |    326.9030 |       1864 |    4.20905148 |
|    6 |   174 |   389 | Lyrad                |    333.7167 |       1934 |    4.14126204 |
|    7 |  1542 |   361 | Eucliwood Hellscythe |    314.7472 |       1859 |    4.06343882 |
|    8 |   142 |   390 | TheCause             |    328.1883 |       1946 |    4.04754326 |
|    9 |  5662 |   356 | Sinister Shadows     |    266.5803 |       1757 |    3.64139282 |
|   10 |    40 |   330 | Satanus Inaximasus   |    274.6212 |       2027 |    3.25155835 |
|   11 |  3441 |   376 | neps                 |    240.3413 |       1827 |    3.15719275 |
|   12 | 51494 |   113 | taman buzuk          |      8.2731 |         67 |    2.96349850 |
|   13 | 51522 |   185 | Evil Reborn          |      7.6051 |         65 |    2.80803691 |
|   14 | 46303 |   184 | Doodeheefver         |     53.3467 |        505 |    2.53528870 |
|   15 | 12702 |   365 | Trio                 |    168.1228 |       1608 |    2.50929552 |
|   16 |  3636 |   366 | Myriad               |    184.5378 |       1822 |    2.43079428 |
|   17 | 51202 |   159 | Talic28              |      9.1172 |         97 |    2.25580205 |
|   18 | 37018 |    83 | hater                |     75.9463 |        829 |    2.19868661 |
|   19 | 17987 |   350 | User Name            |    129.5955 |       1495 |    2.08046287 |
|   20 | 51415 |    33 | The Wilderness       |      6.2011 |         75 |    1.98435199 |
|   21 | 51856 |   113 | StrengthTrainer      |      2.5838 |         32 |    1.93785000 |
|   22 | 37017 |   329 | jezz                 |     66.3101 |        829 |    1.91971337 |
|   23 | 50005 |    55 | housebitch           |     18.6214 |        244 |    1.83161311 |
|   24 |   152 |   103 | Shoegazer            |    145.2142 |       1945 |    1.79184617 |
|   25 | 50619 |   135 | angellone            |     13.1879 |        189 |    1.67465395 |
|   26 | 44790 |   104 | Pothead              |     41.5948 |        616 |    1.62057660 |
|   27 |  6185 |   229 | Jaziran              |    114.2584 |       1748 |    1.56876521 |
|   28 | 47314 |   235 | VonClausewitz        |     27.6234 |        433 |    1.53108914 |
|   29 | 47219 |   231 | DeTRoiTwhore         |     27.1431 |        439 |    1.48390522 |
|   30 | 51835 |    74 | taman1               |      2.0539 |         34 |    1.44981175 |
+------+-------+-------+----------------------+-------------+------------+---------------+

 
MrZal3 [71]
2016-04-18 19:03:52
[8 years, 220 days ago]

All hail Lord sirop5!


 
Forum > Miscellaneous > i got a shiny sword
Reply To Thread (login)