Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online Now
1 registered members (amciotola), 71 guests, and 174 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
isaac
isaac
California
Posts: 1,174
Joined: April 2004
Show All Member Profiles 
Top Posters(30 Days)
Gizmo 12
Ruben 5
M4TT 4
isaac 3
Morgan 3
Tijn 1
Latest Photos
Previous Thread
Next Thread
Print Thread
Page 1 of 4 1 2 3 4
Updated top 10 Spammer List #195826
08/30/07 11:22 AM
08/30/07 11:22 AM
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
R
Rick Offline OP
Former Developer
Rick  Offline OP
Former Developer
R
Joined: Jun 2006
Posts: 10,177
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
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
Re: Updated top 10 Spammer List [Re: Rick] #195829
08/30/07 11:49 AM
08/30/07 11:49 AM
Joined: Aug 2006
Posts: 1,530
Breda, NL
Yarp™ Offline
veteran
Yarp™  Offline
veteran
Joined: Aug 2006
Posts: 1,530
Breda, NL
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.


[Linked Image]
Re: Updated top 10 Spammer List [Re: Yarp™] #195830
08/30/07 12:02 PM
08/30/07 12:02 PM
Joined: Jan 2004
Posts: 2,654
driv Offline

driv  Offline


Joined: Jan 2004
Posts: 2,654
They're way down from what they used to be though.

We're spam count aware! 2,3,4,5,6,7.... wink


Using version :: 7.6.0
Re: Updated top 10 Spammer List [Re: driv] #195833
08/30/07 12:48 PM
08/30/07 12:48 PM
Joined: Jul 2006
Posts: 4,722
Liverpool : England : UK
Mark S Offline
Mark S  Offline

Joined: Jul 2006
Posts: 4,722
Liverpool : England : UK
At least me and Ian are constant smile


BOOM !! Version v7.6.1.1
People who inspire me Isaac ME Gizmo
Re: Updated top 10 Spammer List [Re: Mark S] #195834
08/30/07 12:50 PM
08/30/07 12:50 PM
Joined: Jul 2006
Posts: 4,722
Liverpool : England : UK
Mark S Offline
Mark S  Offline

Joined: Jul 2006
Posts: 4,722
Liverpool : England : UK
I don't think its right?
I know ive been keeping things +15 because of last months figures frown

unless its from the beginning to now ??


BOOM !! Version v7.6.1.1
People who inspire me Isaac ME Gizmo
Re: Updated top 10 Spammer List [Re: Rick] #195836
08/30/07 12:51 PM
08/30/07 12:51 PM
Joined: Nov 2006
Posts: 3,390
ntdoc Offline
Carpal Tunnel
ntdoc  Offline
Carpal Tunnel
Joined: Nov 2006
Posts: 3,390
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.

Re: Updated top 10 Spammer List [Re: ntdoc] #195837
08/30/07 12:54 PM
08/30/07 12:54 PM
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
R
Rick Offline OP
Former Developer
Rick  Offline OP
Former Developer
R
Joined: Jun 2006
Posts: 10,177
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

Re: Updated top 10 Spammer List [Re: Rick] #195839
08/30/07 12:59 PM
08/30/07 12:59 PM
Joined: Nov 2006
Posts: 3,390
ntdoc Offline
Carpal Tunnel
ntdoc  Offline
Carpal Tunnel
Joined: Nov 2006
Posts: 3,390
Thanks Rick. Saved it with my growing list of queries.

Re: Updated top 10 Spammer List [Re: ntdoc] #195845
08/30/07 01:23 PM
08/30/07 01:23 PM
Joined: Jun 2006
Posts: 255
I
Ian Spence Offline
enthusiast
Ian Spence  Offline
enthusiast
I
Joined: Jun 2006
Posts: 255
am I doing better this time?

Re: Updated top 10 Spammer List [Re: Ian Spence] #195847
08/30/07 01:25 PM
08/30/07 01:25 PM
Joined: Apr 2007
Posts: 4,313
SoCal, USA
SD Offline
Carpal Tunnel
SD  Offline
Carpal Tunnel
Joined: Apr 2007
Posts: 4,313
SoCal, USA
i think i'm screwed.. i busted myself giving short terse responses to the GiZ-UNiT....

giz could be my downfall frown

Re: Updated top 10 Spammer List [Re: Ian Spence] #195852
08/30/07 01:49 PM
08/30/07 01:49 PM
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
R
Rick Offline OP
Former Developer
Rick  Offline OP
Former Developer
R
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
You have a grand total of 3 Ian wink

Re: Updated top 10 Spammer List [Re: SD] #195853
08/30/07 01:49 PM
08/30/07 01:49 PM
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
R
Rick Offline OP
Former Developer
Rick  Offline OP
Former Developer
R
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
You're creeping up to making the list SD. You're up to 13.

Re: Updated top 10 Spammer List [Re: Rick] #195855
08/30/07 01:52 PM
08/30/07 01:52 PM
Joined: Jun 2006
Posts: 255
I
Ian Spence Offline
enthusiast
Ian Spence  Offline
enthusiast
I
Joined: Jun 2006
Posts: 255
Maybe you should use POST_DEFAULT_BODY

smile becomes <img src="/forums/images/graemlins/default/smile.gif" alt=":)" title="smile" height="15" width="15" /> which means even a single smiley takes you over the 15 character line

Re: Updated top 10 Spammer List [Re: Ian Spence] #195858
08/30/07 02:00 PM
08/30/07 02:00 PM
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
R
Rick Offline OP
Former Developer
Rick  Offline OP
Former Developer
R
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
I don't like that one. It moves me up the list wink But, I'll probbaly be using it, since it is a more accurate query laugh

Code
Gizmo	221
Ian	182
Mark S	76
gliderdad	42
Mitch P.	36
Rick	31
David Dreezer	30
ntdoc	29
Zarzal	27
AllenAyres	25

Last edited by Rick; 08/30/07 02:03 PM.
Re: Updated top 10 Spammer List [Re: Rick] #195860
08/30/07 02:04 PM
08/30/07 02:04 PM
Joined: Jun 2006
Posts: 1,475
NY
G
gliderdad Offline
veteran
gliderdad  Offline
veteran
G
Joined: Jun 2006
Posts: 1,475
NY
Hey, I don't like this one. It moves me way up the list tongue

Re: Updated top 10 Spammer List [Re: gliderdad] #195862
08/30/07 02:09 PM
08/30/07 02:09 PM
Joined: Jun 2006
Posts: 255
I
Ian Spence Offline
enthusiast
Ian Spence  Offline
enthusiast
I
Joined: Jun 2006
Posts: 255
Did I move up to 5?

Re: Updated top 10 Spammer List [Re: Ian Spence] #195863
08/30/07 02:14 PM
08/30/07 02:14 PM
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
R
Rick Offline OP
Former Developer
Rick  Offline OP
Former Developer
R
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
No, you're still at 3 wink You're not a very good spammer.

Re: Updated top 10 Spammer List [Re: Rick] #195869
08/30/07 02:40 PM
08/30/07 02:40 PM
Joined: Jul 2006
Posts: 4,722
Liverpool : England : UK
Mark S Offline
Mark S  Offline

Joined: Jul 2006
Posts: 4,722
Liverpool : England : UK
aww i only spam on here, i'm not in the top ten on my boards.....

is there an addition to the query to say only include active members??

my list has 5 from over a year ago and never been seen since.


BOOM !! Version v7.6.1.1
People who inspire me Isaac ME Gizmo
Re: Updated top 10 Spammer List [Re: Mark S] #195882
08/30/07 05:48 PM
08/30/07 05:48 PM
Joined: Jan 2004
Posts: 2,654
driv Offline

driv  Offline


Joined: Jan 2004
Posts: 2,654
I'm flippin' sure I made that list recently.... (what's changed?) smile


Using version :: 7.6.0
Re: Updated top 10 Spammer List [Re: driv] #195898
08/30/07 07:33 PM
08/30/07 07:33 PM
Joined: Jun 2006
Posts: 16,942
Portland, OR; USA
Gizmo Offline
UBB.threads Developer
Gizmo  Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 16,942
Portland, OR; USA
haha the second i went up +100 lol...

I haven't really been worrying about it lately; been too darned stressed with irl matters to care if i'm over 15 characters in a post :/.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: Updated top 10 Spammer List [Re: Gizmo] #196208
09/04/07 04:05 PM
09/04/07 04:05 PM
Joined: Jul 2006
Posts: 2,199
David Dreezer Offline

Pooh-Bah
David Dreezer  Offline

Pooh-Bah
Joined: Jul 2006
Posts: 2,199
It says I made 5 spammy posts last month but I just don't see it.


This thread for sale. Click here! [Linked Image]
Re: Updated top 10 Spammer List [Re: David Dreezer] #196210
09/04/07 04:15 PM
09/04/07 04:15 PM
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
R
Rick Offline OP
Former Developer
Rick  Offline OP
Former Developer
R
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
Running the old query it says only 1. But the new one, where it doesn't expand markup and smileys, it's a bit different, even for me wink

Re: Updated top 10 Spammer List [Re: Rick] #196211
09/04/07 04:26 PM
09/04/07 04:26 PM
Joined: Jan 2004
Posts: 2,654
driv Offline

driv  Offline


Joined: Jan 2004
Posts: 2,654
Originally Posted by Rick
where it doesn't expand markup and smileys


So it only counts 'words' as opposed to the characters used in smilies?

(Sorry, I need it cleared up as I'm not that smart...)

How do you do that?


Using version :: 7.6.0
Re: Updated top 10 Spammer List [Re: driv] #196212
09/04/07 04:29 PM
09/04/07 04:29 PM
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
R
Rick Offline OP
Former Developer
Rick  Offline OP
Former Developer
R
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
Well, counts what you typed in for the smiley, but not the actual HTML that turns into.

So, before you could type in just a smile for your reply, and since that converted into the full <img src.... your reply would be considered over 15 characters, now it would only count as 2 characters.

Re: Updated top 10 Spammer List [Re: Rick] #196214
09/04/07 04:33 PM
09/04/07 04:33 PM
Joined: Jan 2004
Posts: 2,654
driv Offline

driv  Offline


Joined: Jan 2004
Posts: 2,654
(Well, at the risk of adding myself to the list....)

smile


Using version :: 7.6.0
Re: Updated top 10 Spammer List [Re: driv] #196224
09/04/07 05:52 PM
09/04/07 05:52 PM
Joined: Apr 2007
Posts: 4,313
SoCal, USA
SD Offline
Carpal Tunnel
SD  Offline
Carpal Tunnel
Joined: Apr 2007
Posts: 4,313
SoCal, USA
smile +1 laugh

Re: Updated top 10 Spammer List [Re: SD] #196225
09/04/07 06:22 PM
09/04/07 06:22 PM
Joined: Jun 2006
Posts: 1,148
Berlin, Germany
Zarzal Offline
old hand
Zarzal  Offline
old hand
Joined: Jun 2006
Posts: 1,148
Berlin, Germany
I'm allways head-2-head with Allen smile It's sometime a little bit difficult for me too follow your threads in genral chat and so I don't post there.


my board: http://www.dragon-clan.de
my hobby: http://www.biker-reise.de
Ich kann bei Fragen zu UBBthreads in Deutsch weiterhelfen oder es zumindest versuchen
Re: Updated top 10 Spammer List [Re: Zarzal] #196264
09/04/07 07:59 PM
09/04/07 07:59 PM
Joined: Jun 2006
Posts: 16,942
Portland, OR; USA
Gizmo Offline
UBB.threads Developer
Gizmo  Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 16,942
Portland, OR; USA
Darn you spammers, something must be done! :falls onto floor laughing:


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: Updated top 10 Spammer List [Re: Gizmo] #196284
09/05/07 04:13 AM
09/05/07 04:13 AM
Joined: Jun 2006
Posts: 4,373
Essex, UK
I
Ian Offline
Carpal Tunnel
Ian  Offline
Carpal Tunnel
I
Joined: Jun 2006
Posts: 4,373
Essex, UK
'bout time I started spamming again LOL

Re: Updated top 10 Spammer List [Re: Ian] #196285
09/05/07 04:14 AM
09/05/07 04:14 AM
Joined: Jun 2006
Posts: 16,942
Portland, OR; USA
Gizmo Offline
UBB.threads Developer
Gizmo  Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 16,942
Portland, OR; USA
Originally Posted by Ian
'bout time I started spamming again LOL
been missing you :tear:


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: Updated top 10 Spammer List [Re: Gizmo] #196287
09/05/07 04:17 AM
09/05/07 04:17 AM
Joined: Jun 2006
Posts: 4,373
Essex, UK
I
Ian Offline
Carpal Tunnel
Ian  Offline
Carpal Tunnel
I
Joined: Jun 2006
Posts: 4,373
Essex, UK
been ill / did a photography course last weekend / daughter just started grammar school (11 years old) / getting divorced / etc...


Re: Updated top 10 Spammer List [Re: Ian] #196288
09/05/07 04:19 AM
09/05/07 04:19 AM
Joined: Jun 2006
Posts: 16,942
Portland, OR; USA
Gizmo Offline
UBB.threads Developer
Gizmo  Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 16,942
Portland, OR; USA
So, you've been getting divorced for a while, you still talked to me every so often lol... Glad to have you back though!


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: Updated top 10 Spammer List [Re: Ian] #196292
09/05/07 05:14 AM
09/05/07 05:14 AM
Joined: Jan 2004
Posts: 2,654
driv Offline

driv  Offline


Joined: Jan 2004
Posts: 2,654
Originally Posted by Ian
daughter just started grammar school (11 years old)


Didn't know we had grammar schhols any more in the UK.
My boy is 10 and next year he starts 'sports college'...


Using version :: 7.6.0
Re: Updated top 10 Spammer List [Re: driv] #196295
09/05/07 06:01 AM
09/05/07 06:01 AM
Joined: Jun 2006
Posts: 4,373
Essex, UK
I
Ian Offline
Carpal Tunnel
Ian  Offline
Carpal Tunnel
I
Joined: Jun 2006
Posts: 4,373
Essex, UK
We do in Essex tongue wink



Re: Updated top 10 Spammer List [Re: Ian] #196297
09/05/07 06:16 AM
09/05/07 06:16 AM
Joined: Jun 2006
Posts: 16,942
Portland, OR; USA
Gizmo Offline
UBB.threads Developer
Gizmo  Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 16,942
Portland, OR; USA
I want to visit, and be ridiculed due to my laxed grammar... and speling (yes, I understand that I misspelled "spelling")... and maul people with my woodsman beard...


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: Updated top 10 Spammer List [Re: Ian] #196300
09/05/07 06:39 AM
09/05/07 06:39 AM
Joined: Jan 2004
Posts: 2,654
driv Offline

driv  Offline


Joined: Jan 2004
Posts: 2,654
Originally Posted by Ian
We do in Essex tongue wink


Perhaps it's just for you posh types whistle


Using version :: 7.6.0
Re: Updated top 10 Spammer List [Re: driv] #196303
09/05/07 07:02 AM
09/05/07 07:02 AM
Joined: Jun 2006
Posts: 16,942
Portland, OR; USA
Gizmo Offline
UBB.threads Developer
Gizmo  Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 16,942
Portland, OR; USA
badabing! <snicker> rimshot! :x...


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: Updated top 10 Spammer List [Re: Gizmo] #196607
09/08/07 10:56 AM
09/08/07 10:56 AM
Joined: May 2006
Posts: 605
Leesburg, FL
Rose Offline
addict
Rose  Offline
addict
Joined: May 2006
Posts: 605
Leesburg, FL
I feel left out. I really must shorten my posts so that I can make the list. laugh

Re: Updated top 10 Spammer List [Re: Rose] #196611
09/08/07 11:51 AM
09/08/07 11:51 AM
Joined: Jun 2006
Posts: 4,373
Essex, UK
I
Ian Offline
Carpal Tunnel
Ian  Offline
Carpal Tunnel
I
Joined: Jun 2006
Posts: 4,373
Essex, UK
I'm sure we can fix it wink

Re: Updated top 10 Spammer List [Re: Rose] #196777
09/09/07 06:44 AM
09/09/07 06:44 AM
Joined: Nov 2006
Posts: 3,390
ntdoc Offline
Carpal Tunnel
ntdoc  Offline
Carpal Tunnel
Joined: Nov 2006
Posts: 3,390
Just tell your boss you're busy as you do little "LOL" or "HEHE" to all the posts you can find. Then you'll make the list in no time. sick

Page 1 of 4 1 2 3 4

Shout Box
Today's Birthdays
No Birthdays
Recent Topics
Member being directed to "stopforumspam?"
by Lisanne. 07/14/18 10:27 AM
7.6.1.1 - Broken ReCaptcha (Not A Bug)
by M4TT. 07/01/18 06:02 PM
Control Panel / Transactions Username
by Morgan. 06/20/18 05:38 AM
random 500 server errors on post
by Bad Frog. 05/31/18 09:34 AM
Forum Statistics
Forums36
Topics35,126
Posts191,358
Members12,092
Most Online978
Jun 24th, 2007
Random Image
Powered by UBB.threads™ PHP Forum Software 7.6.2
(Preview build 20180524)