2,000!! - UBB.threads PHP Forum Software Community

You are not logged in. [Log In] UBB.threads PHP Forum Software Community » Forums » General and Testing Forums » General Chat » 2,000!!

Site Links

Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com

Top Posters (30 Days)

Ruben	51
DennyP	24
Gizmo	24
Dunny	15
SteveS	14
AllenAyres	12
dbremer	10
SD	10
drkknght00	9
doug	8

Latest Photos

Basildon Town Centre looking from the rounderbout

Page 2 of 4

Topic Options

#187976 - 06/20/07 07:14 PM

Re: 2,000!! [Re: Gizmo]

Mark S Offline

Carpal Tunnel

Registered: 07/04/06
Posts: 4447
Loc: Liverpool : England : UK

Quality Rick i love it $\:\)$ $\:\)$

_________________________
Version v7.5.6

< Threads satisfaction status
People who inspire me Rick Gizmo Ian David jgeoff ntdoc
Oooo i hear 8 is coming? just after 7 my friend.

Top

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."

#187977 - 06/20/07 07:14 PM

Re: 2,000!! [Re: Rick]

SD	Registered: 04/19/07 Posts: 4056 Loc: SoCal, USA

0123456789012345
good catch Rick!! $;\)$

_________________________

Threads tutorials . Threads & Wordpress experts . UBB resume

If I

you, click this link as to why

Top

#187978 - 06/20/07 07:15 PM

Re: 2,000!! [Re: Mark S]

Mark S Offline

Carpal Tunnel

Registered: 07/04/06
Posts: 4447
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.5.6

< Threads satisfaction status
People who inspire me Rick Gizmo Ian David jgeoff ntdoc
Oooo i hear 8 is coming? just after 7 my friend.

Top

#187979 - 06/20/07 07:17 PM

Re: 2,000!! [Re: Mark S]

Rick

Post-a-holic

Registered: 06/04/06
Posts: 10164
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

Top

#187981 - 06/20/07 07:18 PM

Re: 2,000!! [Re: Rick]

Mark S Offline

Carpal Tunnel

Registered: 07/04/06
Posts: 4447
Loc: Liverpool : England : UK

Fantastic $;\)$

Oops not enough characters $\:\)$

_________________________
Version v7.5.6

< Threads satisfaction status
People who inspire me Rick Gizmo Ian David jgeoff ntdoc
Oooo i hear 8 is coming? just after 7 my friend.

Top

#187993 - 06/21/07 12:28 AM

Re: 2,000!! [Re: Gizmo]

gliderdad Offline

Registered: 06/08/06
Posts: 1466
Loc: NY

Do you think we can plan a party like that within two days????

Top

#187996 - 06/21/07 12:35 AM

Re: 2,000!! [Re: Rick]

gliderdad Offline

Registered: 06/08/06
Posts: 1466
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$

Top

#187997 - 06/21/07 12:46 AM

Re: 2,000!! [Re: gliderdad]

ntdoc

Registered: 11/09/06
Posts: 3384

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/21/07 02:16 AM

Re: 2,000!! [Re: ntdoc]

Gizmo

Registered: 06/05/06
Posts: 14995
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...

_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!

Top