vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Big Board Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=172)
-   -   How do I find my 1,000,000th post? I'm at 992,395 posts... (https://vborg.vbsupport.ru/showthread.php?t=143989)

Citizen 04-04-2007 12:31 PM
How do I find my 1,000,000th post? I'm at 992,395 posts...
 
I'm giving out a prize to the member who makes the 1,000,000th post, but there's a problem...

I cant tell which post is the millionth! The link at the top displays the post number, but that doesn't take into effect deleted posts and threads, right?

How do I find the true 1,000,000th post?

jason|xoxide 04-05-2007 01:50 PM
Well, technically, the post number would be correct. Just because a post was deleted doesn't mean that it wasn't made.

If you're looking for the 1,000,000th post that is currently visible on your board then you're not going to be able to do that without running a SQL query. You'd want to try something like the following:

Code:
SELECT `postid` FROM `post` WHERE `visible` = 1 LIMIT 999999, 1

Reven 04-05-2007 04:16 PM
Or go to http://www.yoursite.com/forums/showpost.php?p=1000000.

jason|xoxide 04-06-2007 04:38 PM
Quote:
Originally Posted by Reven (Post 1220473)
That's what he said he didn't want to do because that would include deleted posts.


All times are GMT. The time now is 06:48 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01750 seconds
  • Memory Usage 1,714KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (4)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete