Previous Thread
Next Thread
Print Thread
Hop To
#187851 06/20/2007 5:22 AM
Joined: Jun 2006
Posts: 3,837
I
Ian
Offline
Carpal Tunnel
Carpal Tunnel
I Offline
Joined: Jun 2006
Posts: 3,837
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 laugh


Ian #187852 06/20/2007 5:51 AM
Joined: Jan 2004
Posts: 2,474
Likes: 3
D
Pooh-Bah
Pooh-Bah
D Offline
Joined: Jan 2004
Posts: 2,474
Likes: 3
OoooOOooohHH - it's just like a Bafta speech laugh
Well done Ian smile

driv #187856 06/20/2007 6:25 AM
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
hahaha i love you guys wink


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Gizmo #187858 06/20/2007 6:42 AM
Joined: Jan 2004
Posts: 2,474
Likes: 3
D
Pooh-Bah
Pooh-Bah
D Offline
Joined: Jan 2004
Posts: 2,474
Likes: 3
Moose hunting? Anyone?

driv #187860 06/20/2007 6:46 AM
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
Wabbit season?


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Gizmo #187877 06/20/2007 10:01 AM
Joined: Dec 2006
Posts: 1,235
veteran
veteran
Joined: Dec 2006
Posts: 1,235
Well done Ian & Mark S. Now lets get cracking on reaching that magic 3K.

Why are you still reading this? Get some posting done!

ScriptKeeper #187970 06/20/2007 7:02 PM
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
I think I'll be at 7k when Rick finally reaches 6k :x


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Gizmo #187971 06/20/2007 7:04 PM
Joined: Jul 2006
Posts: 4,057
Joined: Jul 2006
Posts: 4,057
Best start planning the 6k and 7k parties now lol


BOOM !! Version v7.6.1.1
People who inspire me Isaac ME Gizmo
Gizmo #187974 06/20/2007 7:12 PM
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
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 laugh )

Here's the top 10 posters with posts of less than 15 characters, just for a refresher laugh
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

Rick #187975 06/20/2007 7:12 PM
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
psh, just 156 frown... Punk...


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Gizmo #187976 06/20/2007 7:14 PM
Joined: Jul 2006
Posts: 4,057
Joined: Jul 2006
Posts: 4,057
Quality Rick i love it smile smile


BOOM !! Version v7.6.1.1
People who inspire me Isaac ME Gizmo
Rick #187977 06/20/2007 7:14 PM
Joined: Apr 2007
Posts: 3,940
Likes: 1
SD Offline
Former Developer
Former Developer
Joined: Apr 2007
Posts: 3,940
Likes: 1
0123456789012345
good catch Rick!! wink

Mark S #187978 06/20/2007 7:15 PM
Joined: Jul 2006
Posts: 4,057
Joined: Jul 2006
Posts: 4,057
Anyone with a rating of +50 should have a auto title of spammer lol

what's the query for that result?


BOOM !! Version v7.6.1.1
People who inspire me Isaac ME Gizmo
Mark S #187979 06/20/2007 7:17 PM
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
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

Rick #187981 06/20/2007 7:18 PM
Joined: Jul 2006
Posts: 4,057
Joined: Jul 2006
Posts: 4,057
Fantastic wink

Oops not enough characters smile


BOOM !! Version v7.6.1.1
People who inspire me Isaac ME Gizmo
Gizmo #187993 06/21/2007 12:28 AM
Joined: Jun 2006
Posts: 1,344
G
veteran
veteran
G Offline
Joined: Jun 2006
Posts: 1,344
Do you think we can plan a party like that within two days????

Rick #187996 06/21/2007 12:35 AM
Joined: Jun 2006
Posts: 1,344
G
veteran
veteran
G Offline
Joined: Jun 2006
Posts: 1,344
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 laugh )

Here's the top 10 posters with posts of less than 15 characters, just for a refresher laugh
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 tongue

gliderdad #187997 06/21/2007 12:46 AM
Joined: Nov 2006
Posts: 3,095
Likes: 1
Carpal Tunnel
Carpal Tunnel
Joined: Nov 2006
Posts: 3,095
Likes: 1
LOL made that post by 1 character (not including the quote)

Rick's SPAM Finder shocked

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)

ntdoc #188004 06/21/2007 2:16 AM
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
oh yeh, i said i would type some content other than a one liner per message to subvert this calculator :x...


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Gizmo #188009 06/21/2007 2:44 AM
Joined: Jun 2006
Posts: 3,837
I
Ian
Offline
Carpal Tunnel
Carpal Tunnel
I Offline
Joined: Jun 2006
Posts: 3,837
nice to see an updated list - I see the gap has widened at the top with Mark catching me up fast wink

Ian #188956 06/26/2007 11:13 PM
Joined: Jun 2006
Posts: 684
H
Addict
Addict
H Offline
Joined: Jun 2006
Posts: 684
I'd like to have a query that gives a list of users with the lengthiest posts by characters.

Harold #188959 06/26/2007 11:47 PM
Joined: Apr 2007
Posts: 3,940
Likes: 1
SD Offline
Former Developer
Former Developer
Joined: Apr 2007
Posts: 3,940
Likes: 1
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 wink

SD #188976 06/27/2007 2:15 AM
Joined: Nov 2006
Posts: 3,095
Likes: 1
Carpal Tunnel
Carpal Tunnel
Joined: Nov 2006
Posts: 3,095
Likes: 1
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.

.

Last edited by ntdoc; 06/27/2007 2:20 AM.
SD #189010 06/27/2007 8:01 AM
Joined: Jun 2006
Posts: 684
H
Addict
Addict
H Offline
Joined: Jun 2006
Posts: 684
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.

Harold #189015 06/27/2007 9:00 AM
Joined: Apr 2007
Posts: 3,940
Likes: 1
SD Offline
Former Developer
Former Developer
Joined: Apr 2007
Posts: 3,940
Likes: 1
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...

SD #189017 06/27/2007 10:27 AM
Joined: Jun 2006
Posts: 3,837
I
Ian
Offline
Carpal Tunnel
Carpal Tunnel
I Offline
Joined: Jun 2006
Posts: 3,837
tell her to use a chair and not the phone - more comfortable wink

Harold #189018 06/27/2007 10:51 AM
Joined: Apr 2007
Posts: 3,940
Likes: 1
SD Offline
Former Developer
Former Developer
Joined: Apr 2007
Posts: 3,940
Likes: 1
Originally Posted by Harold
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.


Code
select t1.USER_DISPLAY_NAME as Name, count(t2.POST_ID) as Total, length(t2.POST_BODY) as CarpalTunnelSize  from ubbt_POSTS as t2, 
 ubbt_USERS as t1
where t1.USER_ID = t2.USER_ID and length(t2.POST_BODY) > 65000
group by t2.USER_ID, CarpalTunnelSize
having Total > 0
order by CarpalTunnelSize desc, Total desc 
limit 5

Code
Name	Total	CarpalTunnelSize
yulee	5	65535
OiyOiy	1	65535
Sirdude	1	65070
Yoyo	1	65010
ro0t0os	1	64567

it pegs @ 65535, so i chose a number perty close (65000) ...

other ways to do it, but i'm in a hurry laugh

SD #189064 06/27/2007 9:03 PM
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
SD, we should start making a ton of sidebar islands :X...


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Gizmo #189086 06/27/2007 11:22 PM
Joined: Jun 2006
Posts: 684
H
Addict
Addict
H Offline
Joined: Jun 2006
Posts: 684
Thanks again, SirDude! smile

Harold #189088 06/27/2007 11:25 PM
Joined: Apr 2007
Posts: 3,940
Likes: 1
SD Offline
Former Developer
Former Developer
Joined: Apr 2007
Posts: 3,940
Likes: 1
you're more than welcome..

SD #189131 06/28/2007 3:10 PM
Joined: Dec 2003
Posts: 1,796
Pooh-Bah
Pooh-Bah
Joined: Dec 2003
Posts: 1,796
<== quality, not quantity wink


- Allen
- ThreadsDev | PraiseCafe
AllenAyres #189169 06/28/2007 7:45 PM
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
I'm all about quality baby wink


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Gizmo #189170 06/28/2007 7:45 PM
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
Yes, I just called Allen "baby" wink :purrs:


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Gizmo #189175 06/28/2007 7:52 PM
Joined: Jul 2006
Posts: 4,057
Joined: Jul 2006
Posts: 4,057
That's it Gizmo your getting the hang of + 15 now lol


BOOM !! Version v7.6.1.1
People who inspire me Isaac ME Gizmo
Mark S #189194 06/28/2007 8:50 PM
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
+15? Why whatever do you mean wink


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
spam issues
by ECNet - 03/19/2024 11:45 PM
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Who's Online Now
3 members (rootman, Gizmo, Nightcrawler), 562 guests, and 186 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)