vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Requests/Questions (Unpaid) (https://vborg.vbsupport.ru/forumdisplay.php?f=112)
-   -   Who made the 50,000th post? (https://vborg.vbsupport.ru/showthread.php?t=77409)

renee1 03-03-2005 07:35 PM

Who made the 50,000th post?
 
I would like to know how I could know who made a post. Example being who made the 50,000th post to the forums.

any ideas? :o

eva01_ 03-03-2005 07:39 PM

<a href="http://yoursite/xxx/showpost.php?p=#" target="_blank">http://yoursite/xxx/showpost.php?p=#</a>

renee1 03-03-2005 07:48 PM

Thanks
this is a true blonde moment
:o :nervous: :o

eva01_ 03-03-2005 07:56 PM

i could always try and make it implemented into the admincp maybe that will be my spring break trial at hacks :P

AN-net 03-03-2005 09:40 PM

Quote:

Originally Posted by eva01_

not always true, as some forums may not count towards post count and also deleted posts. so that is completely true;)

eva01_ 03-03-2005 09:44 PM

curse people and shooting down my moments of glory *cries* T_T

AN-net 03-03-2005 10:29 PM

Quote:

Originally Posted by eva01_
curse people and shooting down my moments of glory *cries* T_T

sry i didnt mean too, i just wanted to make sure the correct information was provided

Deaths 03-04-2005 06:29 AM

Quote:

Originally Posted by renee1
Thanks
this is a true blonde moment
:o :nervous: :o

Never ditch the blonde! EVER!

Imperial Fritz 03-27-2005 04:05 AM

Totally not working for a board which originate as phpbb, was imported to vb, then imported back to phpbb and then imported again to vb. This over the course of more than two years. My postids now start at something like 70,000 and the board only has some 60,000 posts :D

Tekton 03-27-2005 05:12 AM

PHP Code:

$the_post $DB_site->query("SELECT * FROM ".TABLE_PREFIX."post ORDER BY dateline ASC LIMIT 49999, 1"); 


That may not work as-is. I don't have anything to look at correct syntax now. Wouldn't dateline be the best thing to go for though? As far as I know, editing the post doesn't change the dateline...

Also, that 49999 might have to be at 50000 since LIMIT could start counting at one.


All times are GMT. The time now is 08:23 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.01079 seconds
  • Memory Usage 1,726KB
  • 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_php_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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