I know I shouldn't, but...

[b3n|<3r|\|]

http://mnforumlist.com/activity.php?ID=75



Reindeer ZOMG!

[Jonas]

Can you make one with Batavia and Shireroth?

[Jonas]

Oh, I just saw you didn't made it

[Ari Rahikkala]

The last couple of months were pretty nuts. I rather prefer the current level of activity where there aren't thirty new mangos every time I check the forum...

[Jonas]

I prefer past month, much reading work and fun.

[hypatias mom]

I am amazed at the extremely high level of involvement by nearly all of our citizens. Great work, and we have had interesting discussions, and not just posting for the sake of posting.

[dr-spangle]

Jonas, I made the graph making program which created the above graph :P

I could quite easily get it to make a graph with shireroth and batavie, the inputs are easy to configure...

*gets all the data*
*moves batavie's data ID on by 1*
*changes batavie lines and dots to red*
*changes shireroth's dot style to "Capital"*
*merges the data*
*checks*

oh... an error...

*adds some blank data to correct it*
*checks*

there we go

[Jonas]

Thank you! I love you..r knowledge!

[hypatias mom]

It is a lot easier to relate to the levels of activity if you can actually see it on the graph. Thanks, dr-spangle. This is a very nice, extremely clear graph.

[Jonas]

You can see the periods I wasn't (very) active in Batavia.

[Erik Mortis]

I wish there was a way to track my activity against the Shireroth activity... I have a theory... The more active it gets here.. the less active I become. and the less active it becomes here.. the more active I become...

[Icebreaker]

I wish there was a way to track my activity against the Shireroth activity... I have a theory... The more active it gets here.. the less active I become. and the less active it becomes here.. the more active I become...

THEN BECOME AN HERO AND MAYBE WE'LL GET A MOVIE DEAL.

[Ari Rahikkala]

Erik's posts as blue, all posts (including Erik's) as red:




Raw data:

Code: Select all

mysql> SELECT posts_all.yearmonth, posts_all.num AS posts_all, posts_erik.num AS posts_erik  FROM 
    ->   (SELECT DATE_FORMAT(FROM_UNIXTIME(post_time),'%Y-%m') AS yearmonth, 
    ->           COUNT(1) AS num FROM phpbb_posts 
    ->           GROUP BY yearmonth) AS posts_all 
    ->   LEFT JOIN 
    ->   (SELECT DATE_FORMAT(FROM_UNIXTIME(post_time),'%Y-%m') AS yearmonth,
    ->           COUNT(1) AS num FROM phpbb_posts
    ->           WHERE poster_id IN (55, 339, 9, 222, 244, 113, 220, 221, 249, 
    ->                              47, 62, 212, 65, 15, 235, 560, 564, 658, 672) 
    ->           GROUP BY yearmonth) AS posts_erik 
    ->   ON posts_all.yearmonth = posts_erik.yearmonth;
+-----------+-----------+------------+
| yearmonth | posts_all | posts_erik |
+-----------+-----------+------------+
| 2000-12   |        84 |         35 | 
| 2001-01   |       139 |         47 | 
| 2001-02   |        82 |         27 | 
| 2001-03   |        60 |          4 | 
| 2001-04   |       146 |         44 | 
| 2001-05   |         4 |          2 | 
| 2001-06   |        56 |         19 | 
| 2001-07   |         6 |       NULL | 
| 2001-08   |       435 |        144 | 
| 2001-09   |       402 |        133 | 
| 2001-10   |        33 |         11 | 
| 2001-11   |         5 |       NULL | 
| 2002-01   |         1 |       NULL | 
| 2002-03   |         1 |       NULL | 
| 2002-04   |       424 |        178 | 
| 2002-05   |       393 |         95 | 
| 2002-06   |       472 |        184 | 
| 2002-07   |       633 |        201 | 
| 2002-08   |       709 |        257 | 
| 2002-09   |       200 |         31 | 
| 2002-10   |       946 |        338 | 
| 2002-11   |      1041 |        343 | 
| 2002-12   |       630 |        238 | 
| 2003-01   |       333 |        119 | 
| 2003-02   |       261 |         68 | 
| 2003-03   |       696 |        235 | 
| 2003-04   |       318 |        116 | 
| 2003-05   |       736 |        238 | 
| 2003-06   |      1299 |        259 | 
| 2003-07   |      2495 |        576 | 
| 2003-08   |      1895 |        561 | 
| 2003-09   |      2425 |        416 | 
| 2003-10   |      4238 |        369 | 
| 2003-11   |      1772 |        249 | 
| 2003-12   |      1774 |        414 | 
| 2004-01   |      2097 |        506 | 
| 2004-02   |      1772 |        127 | 
| 2004-03   |      2592 |        530 | 
| 2004-04   |      1494 |        313 | 
| 2004-05   |         3 |          1 | 
| 2004-06   |         2 |       NULL | 
| 2004-07   |        15 |       NULL | 
| 2004-08   |         8 |       NULL | 
| 2004-09   |        62 |         12 | 
| 2004-10   |        17 |       NULL | 
| 2004-11   |         9 |       NULL | 
| 2004-12   |         3 |       NULL | 
| 2005-01   |         8 |       NULL | 
| 2005-02   |        20 |          2 | 
| 2005-03   |        47 |          1 | 
| 2005-04   |       219 |          1 | 
| 2005-05   |      1002 |       NULL | 
| 2005-06   |      2148 |          2 | 
| 2005-07   |       898 |          1 | 
| 2005-08   |      2602 |         46 | 
| 2005-09   |      2777 |          9 | 
| 2005-10   |      2806 |         58 | 
| 2005-11   |      2804 |        215 | 
| 2005-12   |      2968 |        283 | 
| 2006-01   |      2011 |         63 | 
| 2006-02   |      1465 |       NULL | 
| 2006-03   |      1348 |          1 | 
| 2006-04   |       821 |       NULL | 
| 2006-05   |      1069 |       NULL | 
| 2006-06   |       535 |       NULL | 
| 2006-07   |       909 |        206 | 
| 2006-08   |       743 |         75 | 
| 2006-09   |       272 |         18 | 
| 2006-10   |       196 |         10 | 
| 2006-11   |        83 |         12 | 
| 2006-12   |        69 |          4 | 
| 2007-01   |       408 |         37 | 
| 2007-02   |       641 |         56 | 
| 2007-03   |       288 |          6 | 
| 2007-04   |       167 |          4 | 
| 2007-05   |       351 |        110 | 
| 2007-06   |       601 |        152 | 
| 2007-07   |       190 |         17 | 
| 2007-08   |       199 |         28 | 
| 2007-09   |        60 |          2 | 
| 2007-10   |       354 |        108 | 
| 2007-11   |      2336 |        476 | 
| 2007-12   |      2713 |        345 | 
| 2008-01   |      2189 |        235 | 
| 2008-02   |      1325 |        144 | 
| 2008-03   |      1503 |        232 | 
| 2008-04   |       961 |         92 | 
| 2008-05   |      1939 |        233 | 
| 2008-06   |      1801 |        181 | 
| 2008-07   |      4933 |        382 | 
| 2008-08   |      5952 |        438 | 
| 2008-09   |       106 |         10 | 
+-----------+-----------+------------+
92 rows in set (0.83 sec)

[hypatias mom]

That is a startling close correlation between yours and Shireroth's activity levels. I wonder how true this would be for, say, the random active citizen. Yours is a dramatic case, Erik, but I think when individual activity rises and falls with interest in various topics, the activity level of the citizenship at large would tend to mirror that interest.

I just went back and looked more closely at the dates of Shirerithian malaise, and found that they were an almost perfect one-to-one correspondence with those periods when Erik was inactive or absent.

[Ari Rahikkala]

Note the list of poster IDs I think were Erik, there might be significant omissions:

Code: Select all

mysql> SELECT CONCAT("[url=http://shireroth.kuroshiro.net/forum/memberlist.php?mode=viewprofile&u=",%20user_id,%20"]", username, "[/url]") AS profile_link FROM phpbb_users WHERE user_id IN (55, 339, 9, 222, 244, 113, 220, 221, 249, 47, 62, 212, 65, 15, 235, 560, 564, 658, 672);

| TonerMan |
| Kaiser Mors III |
| Kaiser Raynor X |
| UEC |
| Erik Mortis |
| Kaiser Erik |
| Brrapa Lu Eraro |
| The Lizzard King of Shire |
| Kaiseress Viviantia I |
| Kaiser Mors II |
| Kaiser Mors I |
| Kaiser Raynor XI |
| General Trantor |
| Kaiser Letifer I |
| Kaiser Metzler I |
| Brrapa Lu'Eraro |
| WolvinX84 |
| Kaiser Letifer III |
| Kaiser Mors V |

[hypatias mom]

Ari--Was Wolvin really a papel of Erik's? I had the feeling he was a much younger person. If he really pulled this off, that is quite a coup.

[Ari Rahikkala]

Pretty sure. The IP addresses agree a lot, at least.

[Erik Mortis]

Who?