The state of boards.ie

TimTim

No, this won't be a rant about boards.ie and how it is run or anything like that and I couldn't come up with a catchy title.

I had some (ok a lot) of spare time on my hands today and I did a little bit of number crunching with the publicly available stats.

At the time of writing there is currently 7,871,684 posts on this website and 132,705 users so each user has an average of 59.32 posts

When you break it down to active users (defined as having 100 or more posts) then you have 8190 users so each user has 961.13 posts each

Now when you look at the top posters (defined as having 10,000 or more posts) then there is a rather exclusive club of 46 who have 694,782 posts between them and are responsible for 8.83% of all the posts made on boards.

However I think the more interesting/shocking stat is that there is only about 300 subscribed users on the website. (Or that I could see anyway) so you have a 0.2261% sub rate between all users, when you only use active users that number rises to 3.663%

I was going to do fancy pie charts and all that but I thought it might be a little excessive anyway I hope at least someone finds this as interesting as I have.

Witcher

get a life




:cool::cool::cool:

miju

monkeyfudge

I think it's interesting.

Although I'm one of the 46 people who account for 8.83% of the posts on boards... so I probably have more of an emotional investment in the site than most.

orestes

How long did this take you to work out?!

TimTim

orestes wrote: »

How long did this take you to work out?!

Maybe about 30 mins at most? Its fairly quick if you know where you are looking although my calculator telling me it was out of memory adding the numbers up slowed me down alright.

gerky

I found it a little interesting.

And I think being a subscriber should give you more benefits then now,you know a line here a hooker there just to keep us sweet:D

gerky

double post

tman

I found that fairly interesting alright. In fact, it has guilted me into renewing my sub....
Viva la 10k!

Karoma

There are more than 46 => 10000 posts. ecksor, Terry... maybe others.

I'll probably resub. in the next few weeks.

AlmightyCushion

Karoma wrote: »

There are more than 46 => 10000 posts. ecksor, Terry... maybe others.

I'll probably resub. in the next few weeks.

Maybe Vex as well. He's always changing his post count so God only knows what it is. Do deleted posts count towards the overall post count because if so the vast majority of that 7,000,000 is spam.

GuanYin

I've had my postcount reset twice.

it was at 666 for a loooonnnng time

Jesus Wept

TimTim wrote: »

I was going to do fancy pie charts and all that but I thought it might be a little excessive anyway I hope at least someone finds this as interesting as I have.

mmm pie

psi wrote: »

I've had my postcount reset twice.

it was at 666 for a loooonnnng time

I'd like that. Someone make me brand new please.

orestes

The-Rigger wrote: »

I'd like that. Someone make me brand new please.

It's like getting your virginity back, even down to the innocence and naivity and not realising that the more experienced folk are gonna try to take advantage of you!

WhiteWashMan

yis are all fcuking blow ins.

As a subscriber with over 10,000 posts, and Official Boards.ie Best Mod* and Official Boards.ie Most Wonderful Poster awards holder*, I am pretty much keeping this place running.



* May not be factually true

TimTim

Karoma wrote: »

There are more than 46 => 10000 posts. ecksor, Terry... maybe others.

I'll probably resub. in the next few weeks.

I wondered about that, I've seen before posts counts that seemed a little iffy, I'm sure an admin could lift off more accurate numbers directly from the SQL server.

hullaballoo

Have you factored in qualitative aspects like that most of the posts in AH etc. are complete rubbish and therefore couldn't be considered a "contribution" to the site?

Methinks not.

TimTim

hullaballú wrote: »

Have you factored in qualitative aspects like that most of the posts in AH etc. are complete rubbish and therefore couldn't be considered a "contribution" to the site?

Methinks not.

If I was to start excluding entire sections of the site I thought I wasn't important enough, not relevant, it would cause war, other people would claim x is relevant while others y etc etc

After hours is part of boards.ie regardless of what people think of it and this post is about stats from boards.ie in its entirety.

Also I used the word responsible

Tar.Aldarion

Have you taken into account tcn posts? :P

monkeyfudge

Can we add up all the 'yore ma' posts? That could be a valuable statistic to take to potential advertisers.

TimTim

Tar.Aldarion wrote: »

Have you taken into account tcn posts? :P

I don't know if they are counted by vbulletin, one of the admins would have to clear it up if the stats on the bottom of the page include tcn

monkeyfudge wrote: »

Can we add up all the 'yore ma' posts? That could be a valuable statistic to take to potential advertisers.

select count(*) from post where post.pagetext like '%your ma%' *

*May or may not cause the SQL server to explode, I take no responsibility for this query

monkeyfudge

TimTim wrote: »

select count(*) from post where post.pagetext like '%your ma%' *

*May or may not cause the SQL server to explode, I take no responsibility for this query

Unfortunately the search cuts off at 500 posts.

TimTim

monkeyfudge wrote: »

Unfortunately the search cuts off at 500 posts.

This is where an admin blasts in and gives us proper stats, one of the admins can run that query on the SQL server itself and not depend on vB to give results.

pid()

I think we should nuke all of those Yore Ma posts.

Terry

WhiteWashMan wrote: »

yis are all fcuking blow ins.

As a subscriber with over 10,000 posts, and Official Boards.ie Best Mod* and Official Boards.ie Most Wonderful Poster awards holder*, I am pretty much keeping this place running.



* May not be factually true

http://www.boards.ie/vbulletin/showpost.php?p=54783874
Mod of the year (and one of the "top posters" ). FACT.
Bow down before me.

pid() wrote:

I think we should nuke all of those Yore Ma posts.

I tried, but failed through boredom.

The thunderdome doesn't count. Nor does the recycle bin.

DeVore

I think this is reasonably interesting (and I dont want to see "get a life" and Lolcats again in reply to a post like this... thanks).

However, apart from analysis of the numbers (which happens here about once every 2 months) I'm not sure what your point is? Is there a point?

Anyway, if you ever wanted to know other numbers, I can run a variety of interesting queries on the site...

DeV.

smashey

Sorry to hijack this thread but I have a numerical enquiry.

On average, how many pms get sent per day?

DeVore

TCN, Thunderdome and Recycle Bin do not count towards a users post count. I dunno if they count towards the site total though... I'm not particularly curious to be honest

I disagree with the idea that any content is "bad" or "irrelevant". My english teacher once told me "there is no such thing as dirt, there is simply matter which is in the wrong place".

I contend that there is no such thing as bad posts... just posts in the wrong place. There is nothing wrong with a "low" content forum full of inane posts... TCN is hardly going to solve world poverty or cure cancer but there is nothing wrong with a bit of light hearted inanity!

DeV.

DeVore

smashey wrote: »

Sorry to hijack this thread but I have a numerical enquiry.

On average, how many pms get sent per day?

wow... thats a good one... I dunno. I will try to find out.

DeV.

faceman

Has there ever been a boards wedding? (as in 2 people who met on boards getting hitched?)

irlrobins

faceman wrote: »

(as in 2 people who met on boards getting hitched?)

There's def been more that a few cases of 2 people who met on boards getting jiggy....

miju

jiggy as in fat?

TimTim

DeVore wrote: »

I think this is reasonably interesting (and I dont want to see "get a life" and Lolcats again in reply to a post like this... thanks).

However, apart from analysis of the numbers (which happens here about once every 2 months) I'm not sure what your point is? Is there a point?

Anyway, if you ever wanted to know other numbers, I can run a variety of interesting queries on the site...

DeV.

I didn't realize these numbers were produced every two months, maybe I have seen them before but I have trouble remembering what I had for breakfast yesterday.

Mainly two reasons, This is probably the largest forum I'm an (somewhat)active member of and I was interested to see how it all breaks down. I'm sure there is at least one person who might find this remotely useful.

I applied for a certain job on a certain site and I thought it might be worthwhile to raise my profile a bit, how this will reflect in the process I'm not sure of but what harm is it to try.

Would it also be possible to get a sorted list of post counts? I'd like to see the long tail of the post count

SELECT user.posts
FROM `user`
ORDER BY `user`.`posts` DESC

Thanks

irlrobins

miju wrote: »

jiggy as in fat?

Let's go with either/or

AlmightyCushion

TimTim wrote: »

I didn't realize these numbers were produced every two months, maybe I have seen them before but I have trouble remembering what I had for breakfast yesterday.

Mainly two reasons, This is probably the largest forum I'm an (somewhat)active member of and I was interested to see how it all breaks down. I'm sure there is at least one person who might find this remotely useful.

I applied for a certain job on a certain site and I thought it might be worthwhile to raise my profile a bit, how this will reflect in the process I'm not sure of but what harm is it to try.

Would it also be possible to get a sorted list of post counts? I'd like to see the long tail of the post count

SELECT user.posts
FROM `user`
ORDER BY `user`.`posts` DESC

Thanks

http://boards.ie/vbulletin/memberlist.php?&order=DESC&sort=posts&pp=30

That may not be their actual post count. As has been said before peoples post count have been reset before.

6th

miju wrote: »

jiggy as in fat?

No thats Jiggly.

TimTim

AlmightyCushion wrote: »

http://boards.ie/vbulletin/memberlist.php?&order=DESC&sort=posts&pp=30

That may not be their actual post count. As has been said before peoples post count have been reset before.

There is where I got my top 46 numbers off but I'm looking for the entire list

The idea of copy and pasting over 3000 pages is not appealing in anyway

6th

faceman wrote: »

Has there ever been a boards wedding? (as in 2 people who met on boards getting hitched?)

Questions etc about the Boards.ie website -> Feedback Forum

Questions etc about the Boards.ie community -> Boards.ie Forum?

irlrobins

Backseat modding!!! ^

6th

I prefere to think of it as Backseat Admin'ing

smashey

DeVore wrote: »

wow... thats a good one... I dunno. I will try to find out.

DeV.

Thanks DeV.

I just have this insatiable appetite for figures.

Jesus Wept

monkeyfudge wrote: »

Can we add up all the 'yore ma' posts? That could be a valuable statistic to take to potential advertisers.

'yore ma' is counting them up one by one as we speak. Give her a chance.

(+1)

DeVore

faceman wrote: »

Has there ever been a boards wedding? (as in 2 people who met on boards getting hitched?)

We've had several Boards weddings... and we have a few Boards babies in fact.

Frankly I find that terrifying for unclear reasons...

DeV.

DeVore

6th wrote: »

Questions etc about the Boards.ie website -> Feedback Forum

Questions etc about the Boards.ie community -> Boards.ie Forum?

Actually 6th, thats been on my mind for some time now. I have always felt there was a kind of "Boardserati"... ie: people who were interested and engaged with the way Boards is run. I'm giving serious thought to creating a forum for that sort of "musing"...

DeV.

TimTim

DeVore wrote: »

Actually 6th, thats been on my mind for some time now. I have always felt there was a kind of "Boardserati"... ie: people who were interested and engaged with the way Boards is run. I'm giving serious thought to creating a forum for that sort of "musing"...

DeV.

+1 to that.

I'd love to get into a discussion about how boards.ie infrastructure works.

I know now that you use NFS to share a directory between all the web nodes so you can keep everything in sync with ease.

6th

DeVore wrote: »

Actually 6th, thats been on my mind for some time now. I have always felt there was a kind of "Boardserati"... ie: people who were interested and engaged with the way Boards is run. I'm giving serious thought to creating a forum for that sort of "musing"...

DeV.

There is no doubt at all that this place is made up of a lot more than just forums, threads and posts. I believe the success of Boards is down, in no small way, to the "life" this place has.

All you need to do is look at the genuine reaction when we lose a fellow Boardsie. I have no idea why it is that we can care about people we may never have met but we do and its almost unreal.

Dub13

Maybe call the new forum Boards Culture.