|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
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:
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:
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
Veteran
|
Veteran
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.
|
|
|
|
Joined: Jan 2004
Posts: 2,474 Likes: 3
Pooh-Bah
|
Pooh-Bah
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....
|
|
|
|
Joined: Jul 2006
Posts: 4,057
|
Joined: Jul 2006
Posts: 4,057 |
At least me and Ian are constant
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 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
Former Developer
|
Former Developer
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:
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
enthusiast
|
enthusiast
Joined: Jun 2006
Posts: 196 |
am I doing better this time?
|
|
|
|
Joined: Apr 2007
Posts: 3,940 Likes: 1
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
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
You have a grand total of 3 Ian
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
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
enthusiast
|
enthusiast
Joined: Jun 2006
Posts: 196 |
Maybe you should use POST_DEFAULT_BODY 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
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
I don't like that one. It moves me up the list But, I'll probbaly be using it, since it is a more accurate query
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
veteran
|
veteran
Joined: Jun 2006
Posts: 1,344 |
Hey, I don't like this one. It moves me way up the list
|
|
|
|
Joined: Jun 2006
Posts: 196
enthusiast
|
enthusiast
Joined: Jun 2006
Posts: 196 |
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
No, you're still at 3 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
Pooh-Bah
|
Pooh-Bah
Joined: Jan 2004
Posts: 2,474 Likes: 3 |
I'm flippin' sure I made that list recently.... (what's changed?)
|
|
|
|
Joined: Jun 2006
Posts: 16,301 Likes: 116
|
Joined: Jun 2006
Posts: 16,301 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 :/.
|
|
|
|
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.
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
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
|
|
|
|
Joined: Jan 2004
Posts: 2,474 Likes: 3
Pooh-Bah
|
Pooh-Bah
Joined: Jan 2004
Posts: 2,474 Likes: 3 |
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
Former Developer
|
Former Developer
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 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
Pooh-Bah
|
Pooh-Bah
Joined: Jan 2004
Posts: 2,474 Likes: 3 |
(Well, at the risk of adding myself to the list....)
|
|
|
|
Joined: Apr 2007
Posts: 3,940 Likes: 1
Former Developer
|
Former Developer
Joined: Apr 2007
Posts: 3,940 Likes: 1 |
+1
|
|
|
|
Joined: Jun 2006
Posts: 956
Old Hand
|
Old Hand
Joined: Jun 2006
Posts: 956 |
I'm allways head-2-head with Allen It's sometime a little bit difficult for me too follow your threads in genral chat and so I don't post there.
|
|
|
|
Joined: Jun 2006
Posts: 16,301 Likes: 116
|
Joined: Jun 2006
Posts: 16,301 Likes: 116 |
Darn you spammers, something must be done! :falls onto floor laughing:
|
|
|
|
Joined: Jun 2006
Posts: 3,837
Carpal Tunnel
|
Carpal Tunnel
Joined: Jun 2006
Posts: 3,837 |
'bout time I started spamming again LOL
|
|
|
|
Joined: Jun 2006
Posts: 16,301 Likes: 116
|
Joined: Jun 2006
Posts: 16,301 Likes: 116 |
'bout time I started spamming again LOL been missing you :tear:
|
|
|
|
Joined: Jun 2006
Posts: 3,837
Carpal Tunnel
|
Carpal Tunnel
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,301 Likes: 116
|
Joined: Jun 2006
Posts: 16,301 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!
|
|
|
|
Joined: Jan 2004
Posts: 2,474 Likes: 3
Pooh-Bah
|
Pooh-Bah
Joined: Jan 2004
Posts: 2,474 Likes: 3 |
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
Carpal Tunnel
|
Carpal Tunnel
Joined: Jun 2006
Posts: 3,837 |
We do in Essex
|
|
|
|
Joined: Jun 2006
Posts: 16,301 Likes: 116
|
Joined: Jun 2006
Posts: 16,301 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...
|
|
|
|
Joined: Jan 2004
Posts: 2,474 Likes: 3
Pooh-Bah
|
Pooh-Bah
Joined: Jan 2004
Posts: 2,474 Likes: 3 |
We do in Essex Perhaps it's just for you posh types
|
|
|
|
Joined: Jun 2006
Posts: 16,301 Likes: 116
|
Joined: Jun 2006
Posts: 16,301 Likes: 116 |
badabing! <snicker> rimshot! :x...
|
|
|
|
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.
|
|
|
|
Joined: Jun 2006
Posts: 3,837
Carpal Tunnel
|
Carpal Tunnel
Joined: Jun 2006
Posts: 3,837 |
I'm sure we can fix it
|
|
|
|
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.
|
|
|
|
Bots
by Outdoorking - 04/13/2024 5:08 PM
|
|
|
2 members (Ruben, 1 invisible),
884
guests, and
182
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|