Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
Who's Online
3 registered (driv, FordDoctor, Ruben Rocha), 28 Guests and 21 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 1 of 4 1 2 3 4 >
Topic Options
Rate This Topic
#187851 - 06/20/07 02:22 AM 2,000!!
Ian Moderator Offline

***

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 wink at the moment - but expanding all the time....))

Top
#187852 - 06/20/07 02:51 AM Re: 2,000!! [Re: Ian]
driv Online   happy
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 wink

Top
#187856 - 06/20/07 03:25 AM Re: 2,000!! [Re: driv]
Gizmo Moderator Offline

***

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 Online   happy
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 wink

Top
#187860 - 06/20/07 03:46 AM Re: 2,000!! [Re: driv]
Gizmo Moderator Offline

***

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 Offline
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 Moderator Offline

***

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 Offline
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 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
#187974 - 06/20/07 04:12 PM Re: 2,000!! [Re: Gizmo]
Rick Administrator Offline

*****

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 Moderator Offline

***

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 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
#188956 - 06/26/07 08:13 PM Re: 2,000!! [Re: Ian]
Harold Moderator Offline

*****

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 Offline

*****

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 Offline

***

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 Moderator Offline

*****

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 Offline

*****

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