Ian
Site Administrator
Registered: 28th Aug 99
Location: Liverpool
User status: Online
|
No they must have visited the site.
|
langey
Member
Registered: 7th Sep 03
Location: Wigan
User status: Offline
|
can you not see how many members made posts in the last 21days?
|
Ian
Site Administrator
Registered: 28th Aug 99
Location: Liverpool
User status: Online
|
Yeah just thought of a way, its a more complicated query though and might slow things down a little.....
|
Ian
Site Administrator
Registered: 28th Aug 99
Location: Liverpool
User status: Online
|
1028 were responsible for those posts.
Top 5 in that period:
Kolin 1457
3CorsaMeal 1284
Adam Kindness 1009
Matt H 951
vibrio 759
|
langey
Member
Registered: 7th Sep 03
Location: Wigan
User status: Offline
|
wow its alot more than i thought, i thought it was only about 300 lol.
imagine if they were all premium ian  £££££££
|
cargraphics4u.com
Member
Registered: 4th Feb 04
Location: Tonbridge, Kent Drives : J7 00RSA
User status: Offline
|
Ian, just out of interest whats my post count?
|
Tim
Site Administrator
Registered: 21st Apr 00
User status: Offline
|
quote:
Originally posted by langey
wow its alot more than i thought, i thought it was only about 300 lol.
imagine if they were all premium ian £££££££
The CS bank is still pretty flush Saving up for our special secret purchase 
|
Mattb
Member
Registered: 2nd Feb 03
Location: Under your sisters bed
User status: Offline
|
[Shhh]
[Edited on 20-12-2004 by Ian]
|
Matt H
Member
Registered: 11th Sep 01
Location: South Yorkshire
User status: Offline
|
quote:
Originally posted by Ian
1028 were responsible for those posts.
Top 5 in that period:
Kolin 1457
3CorsaMeal 1284
Adam Kindness 1009
Matt H 951
vibrio 759
scary  
Ian just out of interest can you put up the total post count for the forum? (number of posts per user) I think you deleted it because everyone was spamming like mad to try & get to the top
just curious as to where i am
|
Matt H
Member
Registered: 11th Sep 01
Location: South Yorkshire
User status: Offline
|
the corsasport [Shhhh]
[Edited on 20-12-2004 by Ian]
|
Ian
Site Administrator
Registered: 28th Aug 99
Location: Liverpool
User status: Online
|
I'd just need to rerun that query without restricting it to the past three weeks. I'll run it at 4am when the db is a bit more relaxed
|
Matt H
Member
Registered: 11th Sep 01
Location: South Yorkshire
User status: Offline
|
cheers 
|
fax2004
Member
Registered: 1st Nov 03
Location: 172
User status: Offline
|
Hows it gone from 15999, to 15998? Who left?!
|
Mattb
Member
Registered: 2nd Feb 03
Location: Under your sisters bed
User status: Offline
|
quote:
Originally posted by fax2004
Hows it gone from 15999, to 15998? Who left?!
bit like the big brother house...
ok then whos next up for eviction!
|
fax2004
Member
Registered: 1st Nov 03
Location: 172
User status: Offline
|
Watch what you say guys and gals. The clearouts on......
|
Ian
Site Administrator
Registered: 28th Aug 99
Location: Liverpool
User status: Online
|
Read Tims post, he denied someone.
That count includes registrations pending approval as they are members to, they just don't have a password yet.
|
Nath
Member
Registered: 3rd Apr 02
Location: MK
User status: Offline
|
quote:
Originally posted by Ian
I'd just need to rerun that query without restricting it to the past three weeks. I'll run it at 4am when the db is a bit more relaxed
|
Robbo
Member
Registered: 6th Aug 02
Location: London
User status: Offline
|
quote:
Originally posted by Ian
I'd like to thin that down at some point Kolin, give me the list and I'll merge the posts.
I'd also like to prune old names and email people who haven't been here for years, then delete if they don't return (or delete if they return once and don't stay).
The total figure is way in excess of the number of regulars, but its more than 1000 regular posters. I'll run some queries when I've finished sniping this.
http://cgi.ebay.co.uk/ws/eBayISAPI.dll?ViewItem&item=3860409312
[Edited on 20-12-2004 by Ian]
"Super Ebayer !!!Schnelle Zahlung !!!! Absolut Empfehlenswert !!!!!!"
Ian, WTF
|
Ian
Site Administrator
Registered: 28th Aug 99
Location: Liverpool
User status: Online
|
It says 'Fast payment, absolutely recommended'
|
Thoday
Member
Registered: 12th Jan 03
Location: Drove kitted corsa b now standard corcs c exclusiv
User status: Offline
|
quote:
Originally posted by Ian
1028 were responsible for those posts.
Top 5 in that period:
Kolin 1457
3CorsaMeal 1284
Adam Kindness 1009
Matt H 951
vibrio 759
Notice P4ul is not on there any more the spam queen.. how the heck did Kindness get that far up
|
Colin
Member
Registered: 4th Apr 02
User status: Offline
|
quote:
Originally posted by Ian
1028 were responsible for those posts.
Top 5 in that period:
Kolin 1457
3CorsaMeal 1284
Adam Kindness 1009
Matt H 951
vibrio 759
Cool what do I win
|
Colin
Member
Registered: 4th Apr 02
User status: Offline
|
quote:
Originally posted by Ian
I'd like to thin that down at some point Kolin, give me the list and I'll merge the posts.
Erm lets see
CorsaGS_Aye
Scoobydoo
Scottydoo
Henry_corsa
There was another but I cannot remember
|
mav
Member
Registered: 19th Jun 01
Location: Scotland
User status: Offline
|
@ kolin...
you are spam queen
|
Matt H
Member
Registered: 11th Sep 01
Location: South Yorkshire
User status: Offline
|
did you run the db querey Ian? (whatever the fuck this means )
|
willay
Moderator
Organiser: South East, National Events
Premium Member
Registered: 10th Nov 02
Location: Roydon, Essex
User status: Offline
|
quote:
Originally posted by Matt H
did you run the db querey Ian? (whatever the fuck this means )
|
