100k posts
- Thread started by Demon_Skeith
- Credits
- 49,732
It just says in the ACP how many total posts there is.
- Credits
- 49,732
it's the ACP, not the magical wonder.
Also I'm going to turn the post display back to normal for this.
Also I'm going to turn the post display back to normal for this.
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
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
- Credits
- 49,732
I can do that, but I really don't like touching that kind of thing. With my luck I'm likely to mess something up >_
Back to normal?
- Credits
- 49,732
I had a mod that split total posts into topic count and post count at the bottom of the forum stats.
nah, I can handle it. I just got to make sure to do some back ups before hand
nah, I can handle it. I just got to make sure to do some back ups before hand
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
- Credits
- 49,732
that should all update in the DB.
- Credits
- 49,732
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.
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
- Credits
- 49,732
I searched under the messages, posts, member posts, member messages. and none of them showed a ID for 99000