UltraBB Forums Home 
Home Search search Menu menu Not logged in - Login | Register
UltraBB Forums > UltraBB > Software Assistance > Fun question - is there a way to find out who made a certain numbered post

Welcome to the UltraBB public support forum! Did you know there is an inexpensive totally integrated gallery available for UltraBB? Read more here: Gallery Details

 Moderated by: Jim Page:    1  2  Next Page Last Page  
New Topic Reply Printer Friendly
Fun question - is there a way to find out who made a certain numbered post  Rate Topic 
AuthorPost
 Posted: Mon Jan 25th, 2010 12:21 am
  PM Quote Reply
1st Post
TVDinner
Go UCONN!


Joined: Wed May 9th, 2007
Location: North Carolina USA
Posts: 1618
Status: 
Offline
Mana: 
User Gallery
 Is there a way to find out who made the 50,000th post on my site.
A bunch of the members had a thread going with people placing bets on who would make the post and when.
No one was paying attention and we blew right past 50,000, so I was wondering if there is a simple SQL that could be run to find out.

Thanks everyone!

:)
Back To Top PM Quote Reply  

 Posted: Mon Jan 25th, 2010 01:05 am
  PM Quote Reply
2nd Post
Jim
I work here


Joined: Wed Apr 11th, 2007
Location:  
Posts: 6649
Status: 
Offline
Mana: 
User Gallery
SELECT user_id FROM wowbb_posts WHERE post_id = '50000'


Then match it up with the user ID:

SELECT user_name FROM wowbb_users WHERE user_id = 'result_of_first_query'

Last edited on Mon Jan 25th, 2010 01:25 am by Jim

Back To Top PM Quote Reply

 Posted: Mon Jan 25th, 2010 01:11 am
  PM Quote Reply
3rd Post
TVDinner
Go UCONN!


Joined: Wed May 9th, 2007
Location: North Carolina USA
Posts: 1618
Status: 
Offline
Mana: 
User Gallery
 Jim - first off THANK YOU.

Interestingly the first SQL returned a result of member #2, which is a admin account that literally has not been used for months and months.

Now I am stumped, BUT ALSO intrigued...
Back To Top PM Quote Reply  

 Posted: Mon Jan 25th, 2010 01:21 am
  PM Quote Reply
4th Post
Jim
I work here


Joined: Wed Apr 11th, 2007
Location:  
Posts: 6649
Status: 
Offline
Mana: 
User Gallery
 OK let me check
Back To Top PM Quote Reply

 Posted: Mon Jan 25th, 2010 01:22 am
  PM Quote Reply
5th Post
TVDinner
Go UCONN!


Joined: Wed May 9th, 2007
Location: North Carolina USA
Posts: 1618
Status: 
Offline
Mana: 
User Gallery
 Only if you have time JIm!!!! This is not a big thing. I would love to know, but won't die if we dont, lol......
Back To Top PM Quote Reply  

 Posted: Mon Jan 25th, 2010 01:22 am
  PM Quote Reply
6th Post
martin_wynne
Licence Holder


Joined: Sun May 25th, 2008
Location: West Of The Severn, United Kingdom
Posts: 1819
Status: 
Offline
Mana: 
User Gallery
 Easier than that. :)

.../view_post.php?post_id=50000

Martin.
Back To Top PM Quote Reply

 Posted: Mon Jan 25th, 2010 01:25 am
  PM Quote Reply
7th Post
TVDinner
Go UCONN!


Joined: Wed May 9th, 2007
Location: North Carolina USA
Posts: 1618
Status: 
Offline
Mana: 
User Gallery
 martin_wynne wrote: Easier than that. :)

.../view_post.php?post_id=50000

Martin.


Look at that. VERY COOL.

Thank you sir - that worked!!!
Back To Top PM Quote Reply  

 Posted: Mon Jan 25th, 2010 01:26 am
  PM Quote Reply
8th Post
TVDinner
Go UCONN!


Joined: Wed May 9th, 2007
Location: North Carolina USA
Posts: 1618
Status: 
Offline
Mana: 
User Gallery
 TVDinner wrote: martin_wynne wrote: Easier than that. :)

.../view_post.php?post_id=50000

Martin.


Look at that. VERY COOL.

Thank you sir - that worked!!!


i spoke to soon - that returned a post that was made at 7:53AM this morning and we hit 50K sometime this late afternoon.

did i do the URL correctly? Here is what I enterred -
http://www.watchfreeks.com/view_post.php?post_id=50000
Back To Top PM Quote Reply

 Posted: Mon Jan 25th, 2010 01:26 am
  PM Quote Reply
9th Post
Jim
I work here


Joined: Wed Apr 11th, 2007
Location:  
Posts: 6649
Status: 
Offline
Mana: 
User Gallery
 I fixed the query. Duh to me with the comma
Back To Top PM Quote Reply  

 Posted: Mon Jan 25th, 2010 01:28 am
  PM Quote Reply
10th Post
TVDinner
Go UCONN!


Joined: Wed May 9th, 2007
Location: North Carolina USA
Posts: 1618
Status: 
Offline
Mana: 
User Gallery
 Jim wrote: I fixed the query. Duh to me with the comma
OK I ran the new SQL and it gave me a different member.

I am curious about Martin's info above. I beleive his way should actually pull up the actual 50,000th post. shouldn't it
Back To Top PM Quote Reply

 Posted: Mon Jan 25th, 2010 02:00 am
  PM Quote Reply
11th Post
Jim
I work here


Joined: Wed Apr 11th, 2007
Location:  
Posts: 6649
Status: 
Offline
Mana: 
User Gallery
 It does.
Back To Top PM Quote Reply  

 Posted: Mon Jan 25th, 2010 02:14 am
  PM Quote Reply
12th Post
TVDinner
Go UCONN!


Joined: Wed May 9th, 2007
Location: North Carolina USA
Posts: 1618
Status: 
Offline
Mana: 
User Gallery
 we know the 50,000th post was made this afternoon, but the 50,000th single post shows a post made at 7am, or so the time stamp says. could my boards internal time be off?
Back To Top PM Quote Reply

 Posted: Mon Jan 25th, 2010 02:37 am
  PM Quote Reply
13th Post
Jim
I work here


Joined: Wed Apr 11th, 2007
Location:  
Posts: 6649
Status: 
Offline
Mana: 
User Gallery
 I don't know what to tell you James.... that is the 50,000th post.
Back To Top PM Quote Reply  

 Posted: Mon Jan 25th, 2010 02:42 am
  PM Quote Reply
14th Post
TVDinner
Go UCONN!


Joined: Wed May 9th, 2007
Location: North Carolina USA
Posts: 1618
Status: 
Offline
Mana: 
User Gallery
 np - I am not complaining at all. Just curious. All good and thank you for helping with the SQL. Very positive moment for our Ultra powered forum.
Back To Top PM Quote Reply

 Posted: Mon Jan 25th, 2010 02:48 am
  PM Quote Reply
15th Post
Jim
I work here


Joined: Wed Apr 11th, 2007
Location:  
Posts: 6649
Status: 
Offline
Mana: 
User Gallery
 I did notice the edited time equaled the posted time in that post which does seem a little odd. I would ask him when he posted it and how long it was before he edited it out of curiosity.
Back To Top PM Quote Reply  

 Posted: Mon Jan 25th, 2010 05:10 am
  PM Quote Reply
16th Post
Devans
License Holder


Joined: Tue May 27th, 2008
Location: Iowa USA
Posts: 1398
Status: 
Offline
Mana: 
User Gallery
 Cool Martin!

That is kind of fun just to go through and see who was the XXXX poster. :)
Back To Top PM Quote Reply

 Posted: Mon Jan 25th, 2010 05:30 am
  PM Quote Reply
17th Post
martin_wynne
Licence Holder


Joined: Sun May 25th, 2008
Location: West Of The Severn, United Kingdom
Posts: 1819
Status: 
Offline
Mana: 
User Gallery
 Jim wrote: I don't know what to tell you James.... that is the 50,000th post.
But it doesn't mean there are 50,000 posts in the database. You may have deleted some. In fact it is almost certain that you have deleted some.

The "number of posts" showing in the board stats on the front page (which is probably what your members are watching) will always be less than the current post ID. Unless you have never deleted a post, which is unlikely after 50,000.

Just the initial setting up and testing of a board is likely to involve deleting some test posts.

If this stuff is important to you, you could keep a tally of the difference between the two numbers, and how many further posts you delete. You would then know in advance what the post ID will be when you actually reach say 60,000 posts showing on the front page.

Edit: For example this post's ID is 17874 on this board, and the front page shows 17,775 posts. That means Jim has deleted 99 posts on here since the board started.

Unless he deletes some more, the "20,000 posts" count will be reached when the post  ID hits 20,099.

regards,

Martin.

Last edited on Mon Jan 25th, 2010 08:47 am by martin_wynne
Back To Top PM Quote Reply  

 Posted: Mon Jan 25th, 2010 05:33 am
  PM Quote Reply
18th Post
TVDinner
Go UCONN!


Joined: Wed May 9th, 2007
Location: North Carolina USA
Posts: 1618
Status: 
Offline
Mana: 
User Gallery
 martin_wynne wrote: Jim wrote: I don't know what to tell you James.... that is the 50,000th post.
But it doesn't mean there are 50,000 posts in the database. You may have deleted some. In fact it is almost certain that you have deleted some.

The "number of posts" showing in the board stats on the front page (which is probably what your members are watching) will always be less than the current post ID. Unless you have never deleted a post, which is unlikely after 50,000.

Just the initial setting up and testing of a board is likely to involve deleting some test posts.

If this stuff is important to you, you could keep a tally of the difference between the two numbers, and how many further posts you delete. You would then know in advance what the post ID will be when you actually reach say 60,000 posts showing on the front page.

regards,

Martin.

now that makes total sense and that would probably explain why the real 50,000th post came earlier in the day then what was seen on the public board.

Thank you Martin.

Back To Top PM Quote Reply

 Posted: Mon Jan 25th, 2010 05:50 am
  PM Quote Reply
19th Post
martin_wynne
Licence Holder


Joined: Sun May 25th, 2008
Location: West Of The Severn, United Kingdom
Posts: 1819
Status: 
Offline
Mana: 
User Gallery
 p.s. The first post has an ID of 0. So if you never delete a post, the "number of posts" will actually be one greater than the current ID.

(The 1-off difference between the index number and item count in zero-based lists is something which often trips up inexperienced programmers.)

Martin.

Last edited on Mon Jan 25th, 2010 07:51 am by martin_wynne
Back To Top PM Quote Reply  

 Posted: Mon Jan 25th, 2010 05:55 am
  PM Quote Reply
20th Post
martin_wynne
Licence Holder


Joined: Sun May 25th, 2008
Location: West Of The Severn, United Kingdom
Posts: 1819
Status: 
Offline
Mana: 
User Gallery
 I wrote:The "number of posts" showing in the board stats will always be less than the current post ID.
Correction for grammatical error. That should be "will always be fewer than". :)
Back To Top PM Quote Reply

Current time is 10:40 am Page:    1  2  Next Page Last Page    
UltraBB Forums > UltraBB > Software Assistance > Fun question - is there a way to find out who made a certain numbered post Top

Hosting

UltraBB 1.17 Copyright © 2007-2011 Data 1 Systems, INC.
Page processed in 0.4899 seconds (9% database + 91% PHP). 32 queries executed.