100k posts

It just says in the ACP how many total posts there is.
 
I'm not referring to the AdminCP, I'm talking about in the actual database of the site. Do you have access to the cPanel which holds the databse?

Check attached images. 1st one shows the icon in cPanel to select phpMyAdmin. 2nd shows where I searched all posts for the 100000th post to pull it up with all the details
 

Attachments

  • phpmyadmin.png
    phpmyadmin.png
    47.1 KB · Views: 8
  • cpanel100000.png
    cpanel100000.png
    73.7 KB · Views: 6
I had a mod that split total posts into topic count and post count at the bottom of the forum stats.

lol, I hear ya, phpMyAdmin controls EVERYTHING in the site, and one slip up can cause catastophe. But, as long as you don't delete anything you're good. I can walk you through the steps to show you how easy it is when the time comes.

nah, I can handle it. I just got to make sure to do some back ups before hand :p
 
Doesn't matter with phpMNyAdmin. you can check it that moment or in 5 years, it keeps the record. My search was from my site, which that milestone was over 2 years ago, we had the same celebration when member creamy423 hit the 100K mark. I did the search just 15 minutes ago so I can show DS visually what I was talking about
 
afraid the phpmyadmin won't be of any help.

If I'm reading it right the count is split between topics and posts. So I really can't use it to find out who made the 100k post.

Tables are split between topics & posts yes, but the posts ( messages) table will have every single post in there, whether it's a topic starter or reply to a topic. The main reason their split into 2 different tables is so the database can use the topics table to mark topics as sticky, locked, etc. Trust me, I know what I'm talking about. If you have any kind of voice chat IM on your PC pm me and I can walk you through it

Attched Pic #1 shows the topics database, match the red, blue, green boxes with Attached Pic #2 which is from the messages database and you'll see they have the same info, just the topic database stores information on the first post of each topic, like sticky, locked, poll options, board ID it's assigned to, ect.
 

Attachments

  • cpanel100000TOPIC.png
    cpanel100000TOPIC.png
    80.5 KB · Views: 3
  • cpanel100000POST.png
    cpanel100000POST.png
    84.2 KB · Views: 3
Back
Top