Tom G
Member
Registered: 4th Aug 08
Location: Cheshire
User status: Offline
|
How many active memebers has this site got? I would class an active member as signed in at least once over a fortnightly basis
|
Ojc
Member
Registered: 14th Nov 00
Location: Reading: Drives : Clio 197
User status: Offline
|
55
|
Ian
Site Administrator
Registered: 28th Aug 99
Location: Liverpool
User status: Online
|
mysql> SELECT COUNT(*) AS Active FROM members WHERE lastvisit > UNIX_TIMESTAMP( NOW( ) ) - 60*60*24*14;
+--------+
| Active |
+--------+
| 1235 |
+--------+
1 row in set (0.10 sec)
|
Ian
Site Administrator
Registered: 28th Aug 99
Location: Liverpool
User status: Online
|
mysql> SELECT COUNT(*) AS Active FROM members WHERE lastvisit > UNIX_TIMESTAMP( NOW( ) ) - 60*60*24*14;
+--------+
| Active |
+--------+
| 1235 |
+--------+
1 row in set (0.10 sec)
mysql> SELECT COUNT(*) AS Active FROM members WHERE lastvisit > UNIX_TIMESTAMP( NOW( ) ) - 60*60*24*28;
+--------+
| Active |
+--------+
| 1441 |
+--------+
1 row in set (0.10 sec)
mysql> SELECT COUNT(*) AS Active FROM members WHERE lastvisit > UNIX_TIMESTAMP( NOW( ) ) - 60*60*24*7*26;
+--------+
| Active |
+--------+
| 2739 |
+--------+
1 row in set (0.11 sec)
|
Tom G
Member
Registered: 4th Aug 08
Location: Cheshire
User status: Offline
|
Mental! I presume quite a lot don't post or rarely post in sub sections where it isn't particulary noticed
|
Ian
Site Administrator
Registered: 28th Aug 99
Location: Liverpool
User status: Online
|
mysql> SELECT COUNT(DISTINCT author) AS MadePosts FROM posts WHERE dateline > UNIX_TIMESTAMP( NOW( ) ) - 60*60*24*14;
+-----------+
| MadePosts |
+-----------+
| 764 |
+-----------+
1 row in set (9.35 sec)
That one isn't indexed properly, 10 seconds to tell you that. 61% of people who logged in posted.
That's previous two weeks.
|
Tom G
Member
Registered: 4th Aug 08
Location: Cheshire
User status: Offline
|
You love this stuff don't you 
So only 61% actually made a post at all! That's pretty low i would of thought?
|
Ian
Site Administrator
Registered: 28th Aug 99
Location: Liverpool
User status: Online
|
That was only two weeks, I would guess there's a lot of u2u traffic as well.
Does go up the further back you go. Not doing too many of those 10 second beasts though ask me again at midnight.
|
Tom G
Member
Registered: 4th Aug 08
Location: Cheshire
User status: Offline
|
Where do most members post? (Number of authors, not posts) I presume it would be general? although you find quite a few who don't post in the main boards, post in regions/project etc.
|
taylorboosh
Member
Registered: 3rd Apr 07
User status: Offline
|
i only ever post in the main boards, projects, general chat and offday
|
3CorsaMeal
Member
Registered: 11th Apr 02
User status: Offline
|
Fcuking amount of spam posted in here 
wtf, looks like myspace....
|
Jake
Member
Registered: 24th Jan 05
User status: Offline
|
how long do accounts have to be inactive for, for you to delete it?
|
Alex_Rally
Member
Registered: 6th Sep 09
Location: Tyne and Wear, gateshead
User status: Offline
|
jake i dont think u need worry , the amount of shit u post.
|
Jake
Member
Registered: 24th Jan 05
User status: Offline
|
if one morning you look outside your house and see your flower pots all fucked up then youre the one that needs to worry
|
Alex_Rally
Member
Registered: 6th Sep 09
Location: Tyne and Wear, gateshead
User status: Offline
|
lmfao hahahaaa that is very true the wife will be more upset than me i think tho lol
|
Ian
Site Administrator
Registered: 28th Aug 99
Location: Liverpool
User status: Online
|
quote:
Originally posted by Jake
how long do accounts have to be inactive for, for you to delete it?
They never expire, I did spend some time a while ago deleting the ones which were clearly never going to work again, no password and invalid email address etc., but it's not an important job so lots of them are just dormant.
|
