Previous Thread
Next Thread
Print Thread
Hop To
Page 1 of 4 1 2 3 4
#195826 08/30/2007 11:22 AM
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
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

Joined: Aug 2006
Posts: 1,358
Y
Veteran
Veteran
Y Offline
Joined: Aug 2006
Posts: 1,358
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 from siemons.org]
Joined: Jan 2004
Posts: 2,474
Likes: 3
D
Pooh-Bah
Pooh-Bah
D Offline
Joined: Jan 2004
Posts: 2,474
Likes: 3
They're way down from what they used to be though.

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

Joined: Jul 2006
Posts: 4,057
Joined: Jul 2006
Posts: 4,057
At least me and Ian are constant smile


BOOM !! Version v7.6.1.1
People who inspire me Isaac ME Gizmo
Joined: Jul 2006
Posts: 4,057
Joined: Jul 2006
Posts: 4,057
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
Joined: Nov 2006
Posts: 3,095
Likes: 1
Carpal Tunnel
Carpal Tunnel
Joined: Nov 2006
Posts: 3,095
Likes: 1
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.

Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
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

Joined: Nov 2006
Posts: 3,095
Likes: 1
Carpal Tunnel
Carpal Tunnel
Joined: Nov 2006
Posts: 3,095
Likes: 1
Thanks Rick. Saved it with my growing list of queries.

Joined: Jun 2006
Posts: 196
I
enthusiast
enthusiast
I Offline
Joined: Jun 2006
Posts: 196
am I doing better this time?

Joined: Apr 2007
Posts: 3,940
Likes: 1
SD Offline
Former Developer
Former Developer
Joined: Apr 2007
Posts: 3,940
Likes: 1
i think i'm screwed.. i busted myself giving short terse responses to the GiZ-UNiT....

giz could be my downfall frown

Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
You have a grand total of 3 Ian wink

Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
You're creeping up to making the list SD. You're up to 13.

Joined: Jun 2006
Posts: 196
I
enthusiast
enthusiast
I Offline
Joined: Jun 2006
Posts: 196
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

Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
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/2007 2:03 PM.
Joined: Jun 2006
Posts: 1,344
G
veteran
veteran
G Offline
Joined: Jun 2006
Posts: 1,344
Hey, I don't like this one. It moves me way up the list tongue

Joined: Jun 2006
Posts: 196
I
enthusiast
enthusiast
I Offline
Joined: Jun 2006
Posts: 196
Did I move up to 5?

Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
No, you're still at 3 wink You're not a very good spammer.

Joined: Jul 2006
Posts: 4,057
Joined: Jul 2006
Posts: 4,057
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
Joined: Jan 2004
Posts: 2,474
Likes: 3
D
Pooh-Bah
Pooh-Bah
D Offline
Joined: Jan 2004
Posts: 2,474
Likes: 3
I'm flippin' sure I made that list recently.... (what's changed?) smile

Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
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.
Do you need Forum Install or Upgrade Services?
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!
Joined: Jul 2006
Posts: 2,143
Pooh-Bah
Pooh-Bah
Joined: Jul 2006
Posts: 2,143
It says I made 5 spammy posts last month but I just don't see it.


This thread for sale. Click here! [Linked Image from navaho.infopop.cc]
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
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

Joined: Jan 2004
Posts: 2,474
Likes: 3
D
Pooh-Bah
Pooh-Bah
D Offline
Joined: Jan 2004
Posts: 2,474
Likes: 3
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?

Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
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.

Joined: Jan 2004
Posts: 2,474
Likes: 3
D
Pooh-Bah
Pooh-Bah
D Offline
Joined: Jan 2004
Posts: 2,474
Likes: 3
(Well, at the risk of adding myself to the list....)

smile

Joined: Apr 2007
Posts: 3,940
Likes: 1
SD Offline
Former Developer
Former Developer
Joined: Apr 2007
Posts: 3,940
Likes: 1
smile +1 laugh

Joined: Jun 2006
Posts: 956
Old Hand
Old Hand
Joined: Jun 2006
Posts: 956
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.dragonclan-forum.de
my hobby: http://www.biker-reise.de
Ich kann bei Fragen zu UBBthreads in Deutsch weiterhelfen oder es zumindest versuchen
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
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.
Do you need Forum Install or Upgrade Services?
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!
Joined: Jun 2006
Posts: 3,837
I
Ian Offline
Carpal Tunnel
Carpal Tunnel
I Offline
Joined: Jun 2006
Posts: 3,837
'bout time I started spamming again LOL

Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
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.
Do you need Forum Install or Upgrade Services?
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!
Joined: Jun 2006
Posts: 3,837
I
Ian Offline
Carpal Tunnel
Carpal Tunnel
I Offline
Joined: Jun 2006
Posts: 3,837
been ill / did a photography course last weekend / daughter just started grammar school (11 years old) / getting divorced / etc...


Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
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.
Do you need Forum Install or Upgrade Services?
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!
Joined: Jan 2004
Posts: 2,474
Likes: 3
D
Pooh-Bah
Pooh-Bah
D Offline
Joined: Jan 2004
Posts: 2,474
Likes: 3
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'...

Joined: Jun 2006
Posts: 3,837
I
Ian Offline
Carpal Tunnel
Carpal Tunnel
I Offline
Joined: Jun 2006
Posts: 3,837
We do in Essex tongue wink



Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
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.
Do you need Forum Install or Upgrade Services?
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!
Joined: Jan 2004
Posts: 2,474
Likes: 3
D
Pooh-Bah
Pooh-Bah
D Offline
Joined: Jan 2004
Posts: 2,474
Likes: 3
Originally Posted by Ian
We do in Essex tongue wink

Perhaps it's just for you posh types whistle

Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
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.
Do you need Forum Install or Upgrade Services?
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!
Joined: May 2006
Posts: 579
addict
addict
Joined: May 2006
Posts: 579
I feel left out. I really must shorten my posts so that I can make the list. laugh

Joined: Jun 2006
Posts: 3,837
I
Ian Offline
Carpal Tunnel
Carpal Tunnel
I Offline
Joined: Jun 2006
Posts: 3,837
I'm sure we can fix it wink

Joined: Nov 2006
Posts: 3,095
Likes: 1
Carpal Tunnel
Carpal Tunnel
Joined: Nov 2006
Posts: 3,095
Likes: 1
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

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
spam issues
by ECNet - 03/19/2024 11:45 PM
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Who's Online Now
1 members (Havenofsobriety), 522 guests, and 99 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)