Registered: 06/04/06
Posts: 10177
Loc: Aberdeen, WA
And here we go. It's been a month since the last one was put out. Gizmo is the winner with a total of 6 spammy posts for the month. Note: this list is basically a count of all posts that are less than 15 characters.
Last Month it looked like this:
Code:
Gizmo 168
Ian 83
Mark S 43
Mitch P. 35
Zarzal 26
gliderdad 25
ntdoc 25
David Dreezer 24
Rick 23
J.C. 21
This month it looks like this:
Code:
Gizmo 174
Ian 83
Mark S 43
Mitch P. 36
ntdoc 28
gliderdad 27
Zarzal 26
David Dreezer 25
Rick 23
J.C. 21
Express Hosting
"We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
#195829 - 08/30/0710:49 AMRe: Updated top 10 Spammer List
[Re: Rick]
Gotta love statistics, I do one at themepark.nl each month with total stats, stats for the month, stats per forum (top posters/topic openers) and post icon stats.
Registered: 07/04/06
Posts: 4480
Loc: Liverpool : England : UK
At least me and Ian are constant
_________________________ Version v7.5.6 < Threads satisfaction status People who inspire me RickGizmo Ian David jgeoff ntdoc Oooo i hear 8 is coming? just after 7 my friend.
Registered: 07/04/06
Posts: 4480
Loc: Liverpool : England : UK
I don't think its right? I know ive been keeping things +15 because of last months figures
unless its from the beginning to now ??
_________________________ Version v7.5.6 < Threads satisfaction status People who inspire me RickGizmo Ian David jgeoff ntdoc Oooo i hear 8 is coming? just after 7 my friend.
And what was your code for this Rick? I know it was posted and I was going to actually run this again on my board last night but could not find the code and did not want to do it from scratch.
Registered: 06/04/06
Posts: 10177
Loc: Aberdeen, WA
It's counting all posts Mark, not just the past month.
Here's the SQL command that's used:
Code:
select t1.USER_DISPLAY_NAME,count(*) as total
from ubbt_POSTS as t2,
ubbt_USERS as t1
where length(t2.POST_BODY) < 15
and t1.USER_ID = t2.USER_ID
group by t2.USER_ID
having total > 5
order by total desc
limit 11
you, 
Previous Topic
Index
