vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Getting real post # (https://vborg.vbsupport.ru/showthread.php?t=237235)

Fender963 03-01-2010 11:16 PM

Getting real post #
 
So my forum is coming up on a million posts and I'm trying to figure out how I"m going to determine who made the millionth post.

I'm going off the post count at the bottom of my forum, but looking at index.php it looks like thats calculated by cycling through all forums and simply summing up replycount for each one. So I don't think that will be much help.

Looking through post table the number of actual posts in DB is far greater than 1 million. I tried filtering out non-visible posts, but no luck matching this with post count shown on forum index.

Any ideas?

Marco van Herwaarden 03-02-2010 08:15 AM

What do you consider the x'th post? Counting also deleted posts, or currently the x'th post?

Fender963 03-02-2010 03:45 PM

Currently the X'th post. So whichever post made the ticker at the bottom of the Forum index go from 999,999 to 1,000,000.


All times are GMT. The time now is 07:33 AM.

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.01037 seconds
  • Memory Usage 1,705KB
  • 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)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (3)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