Finding total posts in a specific forum

[kgroneman]

Somebody needs to kick me. I'm so used to working from the back end I forget to look at the front end! LOL! Pretend I wasn't even here......

[kgroneman]

I want to find the number of total posts in a specific forum. It's easy to find number of threads, but I'm having a hard time finding posts. I tried this sql query:

SELECT COUNT(postid) AS count

...

[kgroneman]

That worked. I had to modify it slightly:

DELETE FROM vb_deletionlog WHERE type = 'post' 
DELETE FROM vb_post WHERE visible = 2

Thanks again In Omnibus

[kgroneman]

Thanks. I'll take a look at that query and see if it will work for me. Much appreciated. - Kim

[kgroneman]

Well, it was worth a try. Thanks Wayne. I wonder if there is any SQL call that would do it?

[kgroneman]

In the admin control panel, the THREADS & POSTS > PRUNE only gives the option to prune deleted threads. Is there a way to prine soft deleted posts but not the entire thread? I saw this post...

[kgroneman]

Apologies, but you lost me at BB URL field. Where is that? Here's what's in the CONTACT DETAILS:
...

[kgroneman]

I assume you're looking for this section:

<form class="vbform block" action="sendmessage.php?do=contactus" method="post">
    <h2 class="blockhead">Send

...

[kgroneman]

Here's what I have configured. Can you see a problem?

Forum URL: https://forums.opensuse.org
Forum Component URL: [blank]
CMS Component URL: [blank]
Blog Component URL:...

[kgroneman]

Someone just brought this to my attention on our forums. If someone uses the CONTACT US link which I've got set to use sendmessage.php, they get the message that the email has been sent, but when it...

[kgroneman]

I need to find out how many users have each rank. Is there a kind soul out there that could give me a query to find the number of users (not a list of users) that have a single rank? I would be in your...

[kgroneman]

Thanks. I'll look into that too....

[kgroneman]

Oooo. That looks interesting. More like what Lithium and Telligent can do. I'll look into that. I'm still curious if there is a way with native vB.

[kgroneman]

I've got an advertising banner running in a sub group of forums. I want to put a different banner on my home page WITHOUT that banner showing in the sub group that has a different banner. I don't see...

[kgroneman]

Ah..I didn't scroll down far enough. We have too many licenses. :-) Thanks

[kgroneman]

Hi. We have a number of 4.x installations and want to start updating to 5.x but need to install/test 5.x in a pre-staging area to see what we need to do to get our SSO login plugin, NNTP gateway, our...

[kgroneman]

Now I know. Thanks Wayne.

[kgroneman]

The outdoing RSS feed from our forums ouputs the root post on all threads. Is there any way to change it so it outputs all activity, including replies just like the activity stream? Thanks in advance....

[kgroneman]

Thanks Wayne. That's what I need to know. - Kim

[kgroneman]

I did some searching of the forums and blogs here but didn't see anything that answers my question of how GDPR will/should be handled in vBulletin. Are there any patches or updates in 4x or any other...