corsasport.co.uk
  Not logged in [Login - Register]  
You Are Not Registered Or Not Logged In  

Corsa Sport » Message Board » Off Day » Which active member has posted the most?


New Topic
New Poll 		  <<  1    2    3    4    5  >> Subscribe | Add to Favourites

You are not logged in and may not post or reply to messages. Please log in or create a new account or mail us about fixing an existing one - register@corsasport.co.uk

There are also many more features available when you are logged in such as private messages, buddy list, location services, post search and more.


Author Which active member has posted the most?
taylorboosh
Member
Registered: 3rd Apr 07
User status: Offline
21st Jan 15 at 09:44   View User's Profile U2U Member Reply With Quote
And a golf anni - was a cool cat
SVM 286
Member
Registered: 13th Feb 05
Location: pain
User status: Offline
21st Jan 15 at 14:29   View User's Profile U2U Member Reply With Quote
quote:
Originally posted by Robin
20.07 per day. Where's my trophy?


You've already got a 'Cup' Robin
SVM 286
Member
Registered: 13th Feb 05
Location: pain
User status: Offline
21st Jan 15 at 14:30   View User's Profile U2U Member Reply With Quote
quote:
Originally posted by Eck
Member for 3201 days, and made 44451 posts. Just under 14 posts a day. Considering I've made probably 3 or 4 posts a week for the last two years, that's not bad Used to make up to 100 posts a night in GTCG. RIP Vicky


Salad days Eck
SVM 286
Member
Registered: 13th Feb 05
Location: pain
User status: Offline
21st Jan 15 at 14:36   View User's Profile U2U Member Reply With Quote
quote:
Originally posted by taylorboosh
Ive been nice for ages


Your girlfriend may beg to differ, TB.
Shane
Member
Registered: 10th Jan 04
User status: Offline
21st Jan 15 at 15:25   View User's Profile U2U Member Reply With Quote
I'm sure "back in the day" my average post count would have been alot higher. I think it works out at 2.9 posts now seeing as i have posted about 5 times in the last two years

[Edited on 21-01-2015 by Shane]
Ojc
Member
Registered: 14th Nov 00
Location: Reading: Drives : Clio 197
User status: Offline
21st Jan 15 at 18:35   View User's Profile U2U Member Reply With Quote
Gianluigi
Ian
Site Administrator

Avatar

Registered: 28th Aug 99
Location: Liverpool
User status: Offline
21st Jan 15 at 23:50   View Garage View User's Profile U2U Member Reply With Quote
quote:
Originally posted by taylorboosh
Could you find someones max post count on any 1 day?


Yes, possible to run that.

Can get anything you can really think of. Problem is the queries get slower when they're more complicated so I can't be running loads of them or at peak times, but its possible to draw out any single stat fairly easily.

You want yours?

Edit to say if you wanted a list of the top busiest people, you'd need go through the post table for each member and then rank the results. So read 8m rows 40k times. Could probably cut that down for active users actually. So perhaps a few k members you're interested in. But its a fairly big query that one.

[Edited on 21-01-2015 by Ian]
Butler
Member
Registered: 2nd Jun 05
Location: London
User status: Offline
22nd Jan 15 at 00:23   View User's Profile U2U Member Reply With Quote
quote:
Originally posted by Ojc
Gianluigi

Robin
Premium Member

Avatar

Registered: 7th Jan 04
Location: Northants Drives: Clio 182 Cup
User status: Offline
22nd Jan 15 at 11:48   View Garage View User's Profile U2U Member Reply With Quote
quote:
Originally posted by Ian
quote:
Originally posted by taylorboosh
Could you find someones max post count on any 1 day?


Yes, possible to run that.

Can get anything you can really think of. Problem is the queries get slower when they're more complicated so I can't be running loads of them or at peak times, but its possible to draw out any single stat fairly easily.

You want yours?

Edit to say if you wanted a list of the top busiest people, you'd need go through the post table for each member and then rank the results. So read 8m rows 40k times. Could probably cut that down for active users actually. So perhaps a few k members you're interested in. But its a fairly big query that one.

[Edited on 21-01-2015 by Ian]


It'll be Eck or me I reckon
3CorsaMeal
Member
Registered: 11th Apr 02
User status: Offline
22nd Jan 15 at 12:17   View User's Profile U2U Member Reply With Quote
Well it won't be that fried egg girl
kennySRi
Member
Registered: 12th Nov 10
Location: Lancashire
User status: Offline
22nd Jan 15 at 12:23   View User's Profile U2U Member Reply With Quote
quote:
Originally posted by Ojc
Gianluigi


Can't believe I forgot about him

I remember the days when I was in the top 20 posters
Russ
Member
Registered: 14th Mar 04
Location: Armchair
User status: Offline
22nd Jan 15 at 18:15   View User's Profile U2U Member Reply With Quote
Top 30. Not bad considering the bans
Eck
Premium Member

Avatar

Registered: 17th Apr 06
Location: Lundin Links, Fife
User status: Offline
22nd Jan 15 at 18:27   View Garage View User's Profile U2U Member Reply With Quote
Yeah I think Robin or I, we used to hit this site hard
taylorboosh
Member
Registered: 3rd Apr 07
User status: Offline
22nd Jan 15 at 19:50   View User's Profile U2U Member Reply With Quote
Nah if its a fuck on dont bother - was just wondering mate
N16K
Member
Registered: 4th Oct 04
Location: Belfast, NI Drives: Corsa D SRi, Tuned Cooper S, B
User status: Offline
22nd Jan 15 at 20:39   View User's Profile U2U Member Reply With Quote
Joined 2004, it is over a decade, prob least active that is still on CS

[Edited on 22-01-2015 by N16K]
Tiger
Member
Registered: 12th Jun 01
Location: Leicestershire Drives:Astra VXR
User status: Offline
22nd Jan 15 at 21:38   View User's Profile U2U Member Reply With Quote
quote:
Originally posted by Eck
Member for 3201 days, and made 44451 posts. Just under 14 posts a day. Considering I've made probably 3 or 4 posts a week for the last two years, that's not bad Used to make up to 100 posts a night in GTCG. RIP Vicky


What happened to Vicky?
Neo
Member
Registered: 20th Feb 07
Location: Essex
User status: Offline
22nd Jan 15 at 22:29   View User's Profile U2U Member Reply With Quote
quote:
Originally posted by boylers11
What ever happened to Fro/Fro drizzle whatever his name was? He used to work in Topshop and drive a 350z and a mini?


And his black corsa, wonder if he still rolls with his big gev number plate.

Considering I've been pretty inactive for the last 4 years I'm surprised I'm in there. All the morning threads
pow
Premium Member

Avatar

Registered: 11th Sep 06
Location: Hazlemere, Buckinghamshire
User status: Offline
22nd Jan 15 at 22:59   View Garage View User's Profile U2U Member Reply With Quote
pow | 11th Sep 2006 | 3052 | 35432 | 11.61
Whittie
Member
Registered: 11th Aug 06
Location: North Wales Drives: BMW, Corsa & Fiat
User status: Offline
22nd Jan 15 at 23:57   View User's Profile U2U Member Reply With Quote
2nd
taylorboosh
Member
Registered: 3rd Apr 07
User status: Offline
23rd Jan 15 at 17:38   View User's Profile U2U Member Reply With Quote
quote:
Originally posted by Whittie
2nd




Impressive since you rarely post now too
Ben G
Member
Registered: 12th Jan 07
Location: Essex
User status: Offline
23rd Jan 15 at 17:40   View User's Profile U2U Member Reply With Quote
4th
Ben G
Member
Registered: 12th Jan 07
Location: Essex
User status: Offline
23rd Jan 15 at 17:42   View User's Profile U2U Member Reply With Quote
quote:
Originally posted by Neo
quote:
Originally posted by boylers11
What ever happened to Fro/Fro drizzle whatever his name was? He used to work in Topshop and drive a 350z and a mini?


And his black corsa, wonder if he still rolls with his big gev number plate.

Considering I've been pretty inactive for the last 4 years I'm surprised I'm in there. All the morning threads


Can't say i've seen him recently. My missus saw him on a train a while back when she went into London iirc.
JordyCarter
Member
Registered: 14th Mar 10
User status: Offline
23rd Jan 15 at 17:56   View User's Profile U2U Member Reply With Quote
quote:
Originally posted by Whittie
2nd

50k posts is insane you deserve a corsasport trophy
Ojc
Member
Registered: 14th Nov 00
Location: Reading: Drives : Clio 197
User status: Offline
24th Jan 15 at 00:19   View User's Profile U2U Member Reply With Quote
Who are the oldest active members still? As in registered date not actualy birthday.
SVM 286
Member
Registered: 13th Feb 05
Location: pain
User status: Offline
24th Jan 15 at 00:26   View User's Profile U2U Member Reply With Quote
I reckon you and Ian are in the running Ollie

  <<  1    2    3    4    5  >>
New Topic
New Poll

Corsa Sport » Message Board » Off Day » Which active member has posted the most? 22 database queries in 0.0119951 seconds