You are not logged in. [Log In] UBB.threads Community » Forums » General and Testing Forums » General Chat » 2,000!!
Register User    Portal Page     Forum List        Calendar     Active Topics     FAQ
Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
Who's Online
7 registered (Djuma, driv, FordDoctor, Gardener, Mike L, Ruben Rocha, 1 invisible), 18 Guests and 13 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 11/21/08
Posts: 1
Top Posters (30 Days)
Ruben Rocha 180
Gizmo 112
Rick 106
Thelockman 79
driv 43
AllenAyres 35
ntdoc 28
Ian 24
Sirdude 23
ScriptKeeper 20
Latest Photos
My Home System
test photo gallery
Bernese Mountain Dogs
My Daimler
Dorado and shark
Page 2 of 4 < 1 2 3 4 >
Topic Options
Rate This Topic
#187976 - 06/20/07 04:14 PM Re: 2,000!! [Re: Gizmo]
Mark S Offline
Carpal Tunnel
***

Registered: 07/04/06
Posts: 4044
Loc: Liverpool : England : UK
Quality Rick i love it \:\) \:\)
_________________________
Version v7.2.2 smile smile < Threads satisfaction status
People who inspire me Rick Gizmo Ian David jgeoff ntdoc
To answer the question you must first give a question.

Top
#187977 - 06/20/07 04:14 PM Re: 2,000!! [Re: Rick]
Sirdude Offline

*****

Registered: 04/19/07
Posts: 2077
Loc: SoCal, USA
0123456789012345
good catch Rick!! ;\)
_________________________


Top
#187978 - 06/20/07 04:15 PM Re: 2,000!! [Re: Mark S]
Mark S Offline
Carpal Tunnel
***

Registered: 07/04/06
Posts: 4044
Loc: Liverpool : England : UK
Anyone with a rating of +50 should have a auto title of spammer lol

what's the query for that result?
_________________________
Version v7.2.2 smile smile < Threads satisfaction status
People who inspire me Rick Gizmo Ian David jgeoff ntdoc
To answer the question you must first give a question.

Top
#187979 - 06/20/07 04:17 PM Re: 2,000!! [Re: Mark S]
Rick Administrator Offline

*****

Registered: 06/04/06
Posts: 7903
Loc: Aberdeen, WA
Here's the query:

 Code:
select t1.USER_DISPLAY_NAME,count(t2.POST_ID) 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

_________________________
UBB.threads™ Developer
My Personal Website · StogieSmokers.com

Top
#187981 - 06/20/07 04:18 PM Re: 2,000!! [Re: Rick]
Mark S Offline
Carpal Tunnel
***

Registered: 07/04/06
Posts: 4044
Loc: Liverpool : England : UK
Fantastic ;\)

Oops not enough characters \:\)
_________________________
Version v7.2.2 smile smile < Threads satisfaction status
People who inspire me Rick Gizmo Ian David jgeoff ntdoc
To answer the question you must first give a question.

Top
#187993 - 06/20/07 09:28 PM Re: 2,000!! [Re: Gizmo]
gliderdad Offline
old hand

Registered: 06/07/06
Posts: 728
Loc: NY
Do you think we can plan a party like that within two days????
_________________________
$> cd /pub
$> more beer

Top
#187996 - 06/20/07 09:35 PM Re: 2,000!! [Re: Rick]
gliderdad Offline
old hand

Registered: 06/07/06
Posts: 728
Loc: NY
 Originally Posted By: Rick
 Originally Posted By: Gizmo
I think I'll be at 7k when Rick finally reaches 6k :x


Yes, but your posts that contain less than 15 characters is rising much faster than mine (so my 6k posts are like 12k of yours \:D )

Here's the top 10 posters with posts of less than 15 characters, just for a refresher \:D
 Code:
Gizmo	       156
Ian	        79
Mark S	        33
Mitch P.        30
Zarzal	        25
Rick	        22
David Dreezer	22
ntdoc	        21
J.C.	        21
gliderdad	18


See I aint a spammer \:p
_________________________
$> cd /pub
$> more beer

Top
#187997 - 06/20/07 09:46 PM Re: 2,000!! [Re: gliderdad]
ntdoc Offline

***

Registered: 11/08/06
Posts: 3202
LOL made that post by 1 character (not including the quote)

Rick's SPAM Finder

I posted that on my board just to spice things up a bit and see what responses I get back from that.

Surprisingly I'm way down on the list over there as well (still on the list though)

Top
#188004 - 06/20/07 11:16 PM Re: 2,000!! [Re: ntdoc]
Gizmo Moderator Offline

***

Registered: 06/04/06
Posts: 12007
Loc: Portland, OR; USA
oh yeh, i said i would type some content other than a one liner per message to subvert this calculator :x...
_________________________
UGN Security, Elite Web Gamers & VNC Web Design Owner
Longtime UBB Supporter, UBB7 Beta Tester & Resident Post-A-Holic

Top
#188009 - 06/20/07 11:44 PM Re: 2,000!! [Re: Gizmo]
Ian Moderator Offline

***

Registered: 06/05/06
Posts: 4160
Loc: Essex, UK
nice to see an updated list - I see the gap has widened at the top with Mark catching me up fast ;\)
_________________________
Fans Focus - Focusing on Fans of Sport

(Okay - mainly football (the British variety wink at the moment - but expanding all the time....))

Top
Page 2 of 4 < 1 2 3 4 >


Moderator:  AllenAyres, Gizmo, Harold, Ian, Ian Spence, Ron M, usrbingeek 
Shout Box

Today's Birthdays
No Birthdays
Recent Topics
I'm the Admin but.....
by David DelMonte
12/02/08 11:12 AM
Fatal error: Smarty::require_once
()
by ThreadsUser
12/02/08 08:17 AM
PayPal batch file for ID'ing expired and failed payment subscriptions?
by Mitch P.
12/02/08 06:02 AM
Shrinking graemlins
by Djuma
12/01/08 05:48 PM
2 problems I'm seeing now.
by DougMM
12/01/08 04:39 PM
Forum Stats
4261 Members
33 Forums
30535 Topics
154977 Posts

Max Online: 978 @ 06/24/07 08:19 PM
Mark all read
Contact Us · UBBCentral · Top