I know I shouldn't, but...
Posted: Sat Sep 06, 2008 3:39 am
Page 1 of 1
Re: I know I shouldn't, but...
Posted: Sat Sep 06, 2008 3:46 am
Can you make one with Batavia and Shireroth?
Re: I know I shouldn't, but...
Posted: Sat Sep 06, 2008 3:47 am
Oh, I just saw you didn't made it 
Re: I know I shouldn't, but...
Posted: Sat Sep 06, 2008 4:07 am
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...
Re: I know I shouldn't, but...
Posted: Sat Sep 06, 2008 4:54 am
I prefer past month, much reading work and fun. 
Re: I know I shouldn't, but...
Posted: Sat Sep 06, 2008 3:50 pm
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.
Re: I know I shouldn't, but...
Posted: Sun Sep 07, 2008 9:41 am
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
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
Re: I know I shouldn't, but...
Posted: Sun Sep 07, 2008 11:44 am
Thank you! I love you..r knowledge! 
Re: I know I shouldn't, but...
Posted: Sun Sep 07, 2008 4:11 pm
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.
Re: I know I shouldn't, but...
Posted: Mon Sep 08, 2008 9:36 am
You can see the periods I wasn't (very) active in Batavia. 
Re: I know I shouldn't, but...
Posted: Mon Sep 08, 2008 10:33 pm
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...
Re: I know I shouldn't, but...
Posted: Tue Sep 09, 2008 12:18 am
THEN BECOME AN HERO AND MAYBE WE'LL GET A MOVIE DEAL.Erik Mortis wrote: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...
Re: I know I shouldn't, but...
Posted: Tue Sep 09, 2008 1:24 am
Erik's posts as blue, all posts (including Erik's) as red:
Raw data:
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)Re: I know I shouldn't, but...
Posted: Tue Sep 09, 2008 1:32 am
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.
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.
Re: I know I shouldn't, but...
Posted: Tue Sep 09, 2008 1:33 am
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 |
Re: I know I shouldn't, but...
Posted: Tue Sep 09, 2008 1:38 am
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.
Re: I know I shouldn't, but...
Posted: Tue Sep 09, 2008 1:42 am
Pretty sure. The IP addresses agree a lot, at least.
Re: I know I shouldn't, but...
Posted: Tue Sep 09, 2008 9:27 pm
Who?