2,000!! - UBB.threads Community

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

Site Links

Home
Features
Documentation
Pricing & Order
Members Area
Support Options

3 registered (driv, FordDoctor, Ruben Rocha), 28 Guests and 21 Spiders online.

Key: Admin, Global Mod, Mod

Featured Member

wanta

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 1 of 4

1

Topic Options

Rate This Topic

#187851 - 06/20/07 02:22 AM 2,000!!
Ian Registered: 06/05/06 Posts: 4160 Loc: Essex, UK	Many thanks for all the spamming to celebrate my 2,000th post. I am grateful to both Gizmo, Mark and others who have assisted me in reaching this milestone. Have a great week $\:D$ _________________________ Fans Focus - Focusing on Fans of Sport (Okay - mainly football (the British variety at the moment - but expanding all the time....))
Top

#187852 - 06/20/07 02:51 AM Re: 2,000!! [Re: Ian]
driv Pooh-Bah Registered: 01/10/04 Posts: 1703 Loc: Essex, UK	OoooOOooohHH - it's just like a Bafta speech $\:D$ Well done Ian $\:\)$ _________________________ Oi Oi Saveloy! (Courtesy of Sd - well known Anglophile...!?!) My True star rating
Top

#187856 - 06/20/07 03:25 AM Re: 2,000!! [Re: driv]
Gizmo Registered: 06/04/06 Posts: 12007 Loc: Portland, OR; USA	hahaha i love you guys $;\)$ _________________________ UGN Security, Elite Web Gamers & VNC Web Design Owner Longtime UBB Supporter, UBB7 Beta Tester & Resident Post-A-Holic
Top

#187858 - 06/20/07 03:42 AM Re: 2,000!! [Re: Gizmo]
driv Pooh-Bah Registered: 01/10/04 Posts: 1703 Loc: Essex, UK	Moose hunting? Anyone? _________________________ Oi Oi Saveloy! (Courtesy of Sd - well known Anglophile...!?!) My True star rating
Top

#187860 - 06/20/07 03:46 AM Re: 2,000!! [Re: driv]
Gizmo Registered: 06/04/06 Posts: 12007 Loc: Portland, OR; USA	Wabbit season? _________________________ UGN Security, Elite Web Gamers & VNC Web Design Owner Longtime UBB Supporter, UBB7 Beta Tester & Resident Post-A-Holic
Top

#187877 - 06/20/07 07:01 AM Re: 2,000!! [Re: Gizmo]
ScriptKeeper old hand Registered: 12/09/06 Posts: 1039 Loc: UK	Well done Ian & Mark S. Now lets get cracking on reaching that magic 3K. Why are you still reading this? Get some posting done!
Top

#187970 - 06/20/07 04:02 PM Re: 2,000!! [Re: ScriptKeeper]
Gizmo Registered: 06/04/06 Posts: 12007 Loc: Portland, OR; USA	I think I'll be at 7k when Rick finally reaches 6k :x _________________________ UGN Security, Elite Web Gamers & VNC Web Design Owner Longtime UBB Supporter, UBB7 Beta Tester & Resident Post-A-Holic
Top

#187971 - 06/20/07 04:04 PM Re: 2,000!! [Re: Gizmo]
Mark S Carpal Tunnel Registered: 07/04/06 Posts: 4044 Loc: Liverpool : England : UK	Best start planning the 6k and 7k parties now lol _________________________ Version v7.2.2 < Threads satisfaction status People who inspire me Rick Gizmo Ian David jgeoff ntdoc To answer the question you must first give a question.
Top

#187974 - 06/20/07 04:12 PM Re: 2,000!! [Re: Gizmo]
Rick Registered: 06/04/06 Posts: 7903 Loc: Aberdeen, WA	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 _________________________ UBB.threads™ Developer My Personal Website · StogieSmokers.com
Top

#187975 - 06/20/07 04:12 PM Re: 2,000!! [Re: Rick]
Gizmo Registered: 06/04/06 Posts: 12007 Loc: Portland, OR; USA	psh, just 156 :(... Punk... _________________________ UGN Security, Elite Web Gamers & VNC Web Design Owner Longtime UBB Supporter, UBB7 Beta Tester & Resident Post-A-Holic
Top

#187976 - 06/20/07 04:14 PM Re: 2,000!! [Re: Gizmo]
Mark S Carpal Tunnel Registered: 07/04/06 Posts: 4044 Loc: Liverpool : England : UK	Quality Rick i love it $\:\)$ $\:\)$ _________________________ Version v7.2.2 < 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 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 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 < 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 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 Carpal Tunnel Registered: 07/04/06 Posts: 4044 Loc: Liverpool : England : UK	Fantastic $;\)$ Oops not enough characters $\:\)$ _________________________ Version v7.2.2 < 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 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 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 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 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 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 at the moment - but expanding all the time....))
Top

#188956 - 06/26/07 08:13 PM Re: 2,000!! [Re: Ian]
Harold Registered: 06/04/06 Posts: 579 Loc: Defiance, Ohio	I'd like to have a query that gives a list of users with the lengthiest posts by characters. _________________________ UBB.threads Beta Tester PowerBlockers.com * forum.haroldandrews.com
Top

#188959 - 06/26/07 08:47 PM Re: 2,000!! [Re: Harold]
Sirdude Registered: 04/19/07 Posts: 2077 Loc: SoCal, USA	just turn it around 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) > 400 and t1.USER_ID = t2.USER_ID group by t2.USER_ID having total > 5 order by total desc limit 11 choose a different number than 400 to go for uber-lengthy $;\)$ _________________________
Top

#188976 - 06/26/07 11:15 PM Re: 2,000!! [Re: Sirdude]
ntdoc Registered: 11/08/06 Posts: 3202	Hmmm... interesting. Users with post length over 20,000 characters. MCA = 109 Posts NTDOC = 46 Posts etc... Posts over 45,000 characters NTDOC = 10 Glenn = 10 MCA = 10 Posts over 65,000 characters NTDOC = 9 Seems the table size for us is set to 65,500 limit. . Edited by ntdoc (06/26/07 11:20 PM)
Top

#189010 - 06/27/07 05:01 AM Re: 2,000!! [Re: Sirdude]
Harold Registered: 06/04/06 Posts: 579 Loc: Defiance, Ohio	Thanks SirDude. That helps. The "having total > 5" is what I didn't understand, otherwise I'd have flipped that other value. What I'm really looking for is a query that will list and rank users by the absolute top number of characters in a post. _________________________ UBB.threads Beta Tester PowerBlockers.com * forum.haroldandrews.com
Top

#189015 - 06/27/07 06:00 AM Re: 2,000!! [Re: Harold]
Sirdude Registered: 04/19/07 Posts: 2077 Loc: SoCal, USA	oh, so you want the top 5 (or whatever) all time lengthiest posts? that's even easier... bleh.. i'll be back in a bit.. female-UNiT on phone... _________________________
Top